johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
64 rows where deaths = 4026 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3288022 | 3288022 | 2022-10-31 | US | Texas | Hidalgo | 48215 | 253140 | 4026 | 0 | 26.39418217 | -98.18299696 | 2022-11-01 04:22:36 | Hidalgo, Texas, US | |
323055 | 323055 | 2022-10-30 | US | Texas | Hidalgo | 48215 | 253082 | 4026 | 0 | 26.39418217 | -98.18299696 | 2022-10-31 04:21:36 | Hidalgo, Texas, US | |
915331 | 915331 | 2022-10-29 | US | Texas | Hidalgo | 48215 | 253082 | 4026 | 0 | 26.39418217 | -98.18299696 | 2022-10-30 04:22:14 | Hidalgo, Texas, US | |
1369600 | 1369600 | 2022-10-28 | US | Texas | Hidalgo | 48215 | 253082 | 4026 | 0 | 26.39418217 | -98.18299696 | 2022-10-29 04:21:13 | Hidalgo, Texas, US | |
3041455 | 3041455 | 2022-10-27 | US | Texas | Hidalgo | 48215 | 252839 | 4026 | 0 | 26.39418217 | -98.18299696 | 2022-10-28 04:22:31 | Hidalgo, Texas, US | |
2262017 | 2262017 | 2022-10-02 | US | New York | Nassau | 36059 | 498484 | 4026 | 0 | 40.74066522 | -73.58941873 | 2022-10-03 04:23:11 | Nassau, New York, US | |
2997543 | 2997543 | 2022-10-01 | US | New York | Nassau | 36059 | 498201 | 4026 | 0 | 40.74066522 | -73.58941873 | 2022-10-02 04:21:23 | Nassau, New York, US | |
855869 | 855869 | 2022-09-30 | US | New York | Nassau | 36059 | 497827 | 4026 | 0 | 40.74066522 | -73.58941873 | 2022-10-01 04:23:01 | Nassau, New York, US | |
2008930 | 2008930 | 2022-08-04 | Russia | Orenburg Oblast | 218560 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-08-05 04:20:52 | Orenburg Oblast, Russia | |||
1098357 | 1098357 | 2022-08-03 | Russia | Orenburg Oblast | 218489 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-08-04 04:20:58 | Orenburg Oblast, Russia | |||
1405282 | 1405282 | 2022-08-02 | Russia | Orenburg Oblast | 218425 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-08-03 04:20:59 | Orenburg Oblast, Russia | |||
3617320 | 3617320 | 2022-08-01 | Russia | Orenburg Oblast | 218358 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-08-02 04:20:53 | Orenburg Oblast, Russia | |||
3871800 | 3871800 | 2022-07-31 | Russia | Orenburg Oblast | 218291 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-08-01 04:21:03 | Orenburg Oblast, Russia | |||
3871533 | 3871533 | 2022-07-31 | Italy | Marche | 575282 | 4026 | 0 | 43.61675973 | 13.5188753 | 2022-08-01 04:21:03 | Marche, Italy | |||
674554 | 674554 | 2022-07-30 | Russia | Orenburg Oblast | 218222 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-31 04:21:02 | Orenburg Oblast, Russia | |||
1783753 | 1783753 | 2022-07-29 | Russia | Orenburg Oblast | 218154 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-30 04:20:42 | Orenburg Oblast, Russia | |||
1066116 | 1066116 | 2022-07-28 | Russia | Orenburg Oblast | 218086 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-29 04:20:45 | Orenburg Oblast, Russia | |||
2335635 | 2335635 | 2022-07-27 | Russia | Orenburg Oblast | 218027 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-28 04:20:56 | Orenburg Oblast, Russia | |||
1487825 | 1487825 | 2022-07-26 | Russia | Orenburg Oblast | 217975 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-27 04:21:04 | Orenburg Oblast, Russia | |||
2594271 | 2594271 | 2022-07-25 | Russia | Orenburg Oblast | 217928 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-26 04:20:58 | Orenburg Oblast, Russia | |||
896386 | 896386 | 2022-07-24 | Russia | Orenburg Oblast | 217880 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-25 04:20:51 | Orenburg Oblast, Russia | |||
91380 | 91380 | 2022-07-23 | Russia | Orenburg Oblast | 217832 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-24 04:20:47 | Orenburg Oblast, Russia | |||
900402 | 900402 | 2022-07-22 | Russia | Orenburg Oblast | 217786 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-23 04:20:53 | Orenburg Oblast, Russia | |||
670538 | 670538 | 2022-07-21 | Russia | Orenburg Oblast | 217743 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-22 04:21:15 | Orenburg Oblast, Russia | |||
1608501 | 1608501 | 2022-07-20 | Russia | Orenburg Oblast | 217704 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-21 04:21:10 | Orenburg Oblast, Russia | |||
959134 | 959134 | 2022-07-19 | Russia | Orenburg Oblast | 217673 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-20 04:20:59 | Orenburg Oblast, Russia | |||
3210521 | 3210521 | 2022-07-18 | Russia | Orenburg Oblast | 217648 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-19 04:20:58 | Orenburg Oblast, Russia | |||
3405696 | 3405696 | 2022-07-17 | Russia | Orenburg Oblast | 217623 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-18 04:20:59 | Orenburg Oblast, Russia | |||
2151896 | 2151896 | 2022-07-16 | Russia | Orenburg Oblast | 217601 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-17 04:21:15 | Orenburg Oblast, Russia | |||
2419129 | 2419129 | 2022-07-15 | Russia | Orenburg Oblast | 217579 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-16 04:21:05 | Orenburg Oblast, Russia | |||
3429204 | 3429204 | 2022-07-14 | Russia | Orenburg Oblast | 217561 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-15 04:20:53 | Orenburg Oblast, Russia | |||
3109724 | 3109724 | 2022-07-13 | Russia | Orenburg Oblast | 217541 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-14 04:20:57 | Orenburg Oblast, Russia | |||
630147 | 630147 | 2022-07-12 | Russia | Orenburg Oblast | 217522 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-13 04:20:58 | Orenburg Oblast, Russia | |||
1211791 | 1211791 | 2022-07-11 | Russia | Orenburg Oblast | 217507 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-12 04:20:51 | Orenburg Oblast, Russia | |||
2789273 | 2789273 | 2022-07-10 | Russia | Orenburg Oblast | 217490 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-11 04:20:46 | Orenburg Oblast, Russia | |||
142226 | 142226 | 2022-07-09 | Russia | Orenburg Oblast | 217473 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-10 04:20:54 | Orenburg Oblast, Russia | |||
1417326 | 1417326 | 2022-07-08 | Russia | Orenburg Oblast | 217457 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-09 04:20:59 | Orenburg Oblast, Russia | |||
2741251 | 2741251 | 2022-07-07 | Russia | Orenburg Oblast | 217444 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-08 04:20:56 | Orenburg Oblast, Russia | |||
1200046 | 1200046 | 2022-07-06 | Russia | Orenburg Oblast | 217432 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-07 04:20:55 | Orenburg Oblast, Russia | |||
3966789 | 3966789 | 2022-07-05 | Russia | Orenburg Oblast | 217422 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-06 04:20:58 | Orenburg Oblast, Russia | |||
3078300 | 3078300 | 2022-07-04 | Russia | Orenburg Oblast | 217409 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-05 04:20:45 | Orenburg Oblast, Russia | |||
1767582 | 1767582 | 2022-07-03 | Russia | Orenburg Oblast | 217394 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-04 04:20:54 | Orenburg Oblast, Russia | |||
3365568 | 3365568 | 2022-07-02 | Russia | Orenburg Oblast | 217379 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-03 04:20:59 | Orenburg Oblast, Russia | |||
593897 | 593897 | 2022-07-01 | Russia | Orenburg Oblast | 217362 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-02 04:21:16 | Orenburg Oblast, Russia | |||
3940298 | 3940298 | 2022-06-30 | Russia | Orenburg Oblast | 217342 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-07-01 04:21:10 | Orenburg Oblast, Russia | |||
2490256 | 2490256 | 2022-06-29 | Russia | Orenburg Oblast | 217322 | 4026 | 0 | 52.0269262 | 54.7276647 | 2022-06-30 04:21:01 | Orenburg Oblast, Russia | |||
971114 | 971114 | 2022-06-01 | Russia | Bryansk Oblast | 161916 | 4026 | 0 | 52.8873315 | 33.415853 | 2022-06-02 05:20:39 | Bryansk Oblast, Russia | |||
360459 | 360459 | 2022-05-07 | Namibia | 159136 | 4026 | 0 | -22.9576 | 18.4904 | 2022-05-08 04:20:49 | Namibia | ||||
1397810 | 1397810 | 2022-05-06 | Namibia | 159052 | 4026 | 0 | -22.9576 | 18.4904 | 2022-05-07 04:21:09 | Namibia | ||||
2598165 | 2598165 | 2022-05-05 | Namibia | 158989 | 4026 | 0 | -22.9576 | 18.4904 | 2022-05-06 04:21:00 | Namibia | ||||
2327296 | 2327296 | 2022-02-04 | India | Himachal Pradesh | 275496 | 4026 | 0 | 31.927213000000002 | 77.233081 | 2022-02-05 04:21:05 | Himachal Pradesh, India | |||
534834 | 534834 | 2021-10-27 | Mexico | Quintana Roo | 59291 | 4026 | 0 | 19.1817 | -88.4791 | 2021-10-28 04:22:08 | Quintana Roo, Mexico | |||
70728 | 70728 | 2021-09-01 | Venezuela | 335233 | 4026 | 0 | 6.4238 | -66.5897 | 2021-09-02 04:21:15 | Venezuela | ||||
3137240 | 3137240 | 2021-07-23 | Algeria | 159563 | 4026 | 109349 | 46188 | 28.0339 | 1.6596 | 2021-07-24 00:21:36 | Algeria | |||
2315251 | 2315251 | 2021-06-04 | India | Jammu and Kashmir | 297602 | 4026 | 263961 | 29615 | 33.75943 | 76.612638 | 2021-06-05 04:23:03 | Jammu and Kashmir, India | ||
2571980 | 2571980 | 2021-04-13 | Spain | Pais Vasco | 171232 | 4026 | 16160 | 151046 | 42.9896 | -2.6189 | 2021-04-14 04:20:41 | Pais Vasco, Spain | ||
1980558 | 1980558 | 2021-03-25 | India | Chhattisgarh | 332113 | 4026 | 314769 | 13318 | 21.264705 | 82.035366 | 2021-03-26 05:26:55 | Chhattisgarh, India | ||
3421070 | 3421070 | 2021-03-19 | Peru | Ancash | 46406 | 4026 | 0 | 42380 | -9.407125 | -77.67179499999997 | 2021-03-20 05:25:46 | Ancash, Peru | ||
354536 | 354536 | 2021-03-11 | US | New York | New York | 36061 | 109618 | 4026 | 0 | 40.76727260000001 | -73.97152637 | 2021-03-12 05:26:50 | New York, New York, US | |
1090183 | 1090183 | 2021-03-03 | Moldova | 189397 | 4026 | 168143 | 17228 | 47.4116 | 28.3699 | 2021-03-04 05:24:24 | Moldova | |||
864511 | 864511 | 2020-11-12 | Brazil | Mato Grosso | 151391 | 4026 | 141953 | 4696 | -12.6819 | -56.9211 | 2020-11-13 05:25:30 | Mato Grosso, Brazil | ||
3440890 | 3440890 | 2020-11-11 | Mexico | Baja California | 24196 | 4026 | 18915 | 1255 | 30.8406 | -115.2838 | 2020-11-12 05:25:55 | Baja California, Mexico | ||
2848942 | 2848942 | 2020-09-18 | Mexico | Veracruz | 31561 | 4026 | 26427 | 1108 | 19.1738 | -96.1342 | 2020-09-19 04:22:00 | Veracruz, Mexico | ||
1195971 | 1195971 | 2020-06-17 | Italy | Piemonte | 31131 | 4026 | 24720 | 2385 | 45.0732745 | 7.680687483 | 2020-06-18 04:33:18 | Piemonte, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);