johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
52 rows where confirmed = 11987 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2416716 | 2416716 | 2022-12-05 | US | Mississippi | Panola | 28107 | 11987 | 178 | 0 | 34.36398677 | -89.95064249 | 2022-12-06 04:21:03 | Panola, Mississippi, US | |
720324 | 720324 | 2022-12-04 | US | Mississippi | Panola | 28107 | 11987 | 178 | 0 | 34.36398677 | -89.95064249 | 2022-12-05 04:20:58 | Panola, Mississippi, US | |
2818613 | 2818613 | 2022-12-03 | US | Mississippi | Panola | 28107 | 11987 | 178 | 0 | 34.36398677 | -89.95064249 | 2022-12-04 04:20:56 | Panola, Mississippi, US | |
835469 | 835469 | 2022-12-02 | US | Mississippi | Panola | 28107 | 11987 | 178 | 0 | 34.36398677 | -89.95064249 | 2022-12-03 04:21:02 | Panola, Mississippi, US | |
2137999 | 2137999 | 2022-12-01 | US | Mississippi | Panola | 28107 | 11987 | 178 | 0 | 34.36398677 | -89.95064249 | 2022-12-02 04:21:07 | Panola, Mississippi, US | |
1966415 | 1966415 | 2022-11-30 | US | Mississippi | Panola | 28107 | 11987 | 178 | 0 | 34.36398677 | -89.95064249 | 2022-12-01 04:21:03 | Panola, Mississippi, US | |
2558429 | 2558429 | 2022-11-29 | US | Mississippi | Panola | 28107 | 11987 | 178 | 0 | 34.36398677 | -89.95064249 | 2022-11-30 04:21:07 | Panola, Mississippi, US | |
481961 | 481961 | 2022-11-08 | US | North Carolina | Scotland | 37165 | 11987 | 146 | 0 | 34.8386299 | -79.4757978 | 2022-11-09 04:21:22 | Scotland, North Carolina, US | |
2442064 | 2442064 | 2022-11-07 | US | Virginia | Charlottesville | 51540 | 11987 | 85 | 0 | 38.03527919 | -78.48569588 | 2022-11-08 04:21:21 | Charlottesville, Virginia, US | |
2441111 | 2441111 | 2022-11-07 | US | North Carolina | Scotland | 37165 | 11987 | 146 | 0 | 34.8386299 | -79.4757978 | 2022-11-08 04:21:21 | Scotland, North Carolina, US | |
1052209 | 1052209 | 2022-11-06 | US | North Carolina | Scotland | 37165 | 11987 | 146 | 0 | 34.8386299 | -79.4757978 | 2022-11-07 04:21:26 | Scotland, North Carolina, US | |
620837 | 620837 | 2022-11-05 | US | Tennessee | Marshall | 47117 | 11987 | 127 | 0 | 35.45798777 | -86.76420988 | 2022-11-06 04:21:24 | Marshall, Tennessee, US | |
620233 | 620233 | 2022-11-05 | US | North Carolina | Scotland | 37165 | 11987 | 146 | 0 | 34.8386299 | -79.4757978 | 2022-11-06 04:21:24 | Scotland, North Carolina, US | |
1025341 | 1025341 | 2022-11-04 | US | Tennessee | Marshall | 47117 | 11987 | 127 | 0 | 35.45798777 | -86.76420988 | 2022-11-05 04:21:52 | Marshall, Tennessee, US | |
1024737 | 1024737 | 2022-11-04 | US | North Carolina | Scotland | 37165 | 11987 | 146 | 0 | 34.8386299 | -79.4757978 | 2022-11-05 04:21:52 | Scotland, North Carolina, US | |
433728 | 433728 | 2022-11-03 | US | North Carolina | Scotland | 37165 | 11987 | 146 | 0 | 34.8386299 | -79.4757978 | 2022-11-04 04:22:11 | Scotland, North Carolina, US | |
851970 | 851970 | 2022-11-02 | US | North Carolina | Scotland | 37165 | 11987 | 146 | 0 | 34.8386299 | -79.4757978 | 2022-11-03 04:22:05 | Scotland, North Carolina, US | |
254300 | 254300 | 2022-09-08 | US | Illinois | Effingham | 17049 | 11987 | 142 | 0 | 39.05935711 | -88.58969584 | 2022-09-09 04:21:11 | Effingham, Illinois, US | |
1088307 | 1088307 | 2022-08-09 | US | New York | Columbia | 36021 | 11987 | 152 | 0 | 42.24819348 | -73.63089095 | 2022-08-10 04:20:57 | Columbia, New York, US | |
3267243 | 3267243 | 2022-05-04 | US | Minnesota | Mower | 27099 | 11987 | 73 | 0 | 43.67142874 | -92.75234549 | 2022-05-05 04:20:55 | Mower, Minnesota, US | |
1572586 | 1572586 | 2022-05-03 | US | Arizona | Graham | 4009 | 11987 | 176 | 0 | 32.93166885 | -109.8882178 | 2022-05-04 04:20:59 | Graham, Arizona, US | |
463846 | 463846 | 2022-05-02 | US | Arizona | Graham | 4009 | 11987 | 176 | 0 | 32.93166885 | -109.8882178 | 2022-05-03 04:21:00 | Graham, Arizona, US | |
3916485 | 3916485 | 2022-05-01 | US | Arizona | Graham | 4009 | 11987 | 176 | 0 | 32.93166885 | -109.8882178 | 2022-05-02 04:21:10 | Graham, Arizona, US | |
2841289 | 2841289 | 2022-04-30 | US | Arizona | Graham | 4009 | 11987 | 176 | 0 | 32.93166885 | -109.8882178 | 2022-05-01 04:20:57 | Graham, Arizona, US | |
1157602 | 1157602 | 2022-04-29 | US | Arizona | Graham | 4009 | 11987 | 176 | 0 | 32.93166885 | -109.8882178 | 2022-04-30 04:21:05 | Graham, Arizona, US | |
1696784 | 1696784 | 2022-04-28 | US | Arizona | Graham | 4009 | 11987 | 176 | 0 | 32.93166885 | -109.8882178 | 2022-04-29 04:20:59 | Graham, Arizona, US | |
3852267 | 3852267 | 2022-04-27 | US | Arizona | Graham | 4009 | 11987 | 176 | 0 | 32.93166885 | -109.8882178 | 2022-04-28 04:20:47 | Graham, Arizona, US | |
944751 | 944751 | 2022-02-28 | US | Missouri | Johnson | 29101 | 11987 | 138 | 0 | 38.74719601 | -93.80691168 | 2022-03-01 04:21:09 | Johnson, Missouri, US | |
1364877 | 1364877 | 2022-02-08 | US | Ohio | Washington | 39167 | 11987 | 194 | 0 | 39.45690571 | -81.49121382 | 2022-02-09 04:21:04 | Washington, Ohio, US | |
1960566 | 1960566 | 2022-01-20 | Japan | Nagano | 11987 | 97 | 0 | 36.132134 | 138.045528 | 2022-01-21 04:21:09 | Nagano, Japan | |||
1146083 | 1146083 | 2021-12-01 | US | Indiana | Wayne | 18177 | 11987 | 268 | 0 | 39.863344399999995 | -85.01044989 | 2021-12-02 04:22:37 | Wayne, Indiana, US | |
2809490 | 2809490 | 2021-09-16 | US | Florida | Walton | 12131 | 11987 | 89 | 0 | 30.64204028 | -86.16935664 | 2021-09-17 04:21:46 | Walton, Florida, US | |
1375234 | 1375234 | 2021-09-15 | US | Florida | Walton | 12131 | 11987 | 89 | 0 | 30.64204028 | -86.16935664 | 2021-09-16 04:22:19 | Walton, Florida, US | |
2463533 | 2463533 | 2021-09-14 | US | Florida | Walton | 12131 | 11987 | 89 | 0 | 30.64204028 | -86.16935664 | 2021-09-15 03:22:37 | Walton, Florida, US | |
1386372 | 1386372 | 2021-09-13 | US | Florida | Walton | 12131 | 11987 | 89 | 0 | 30.64204028 | -86.16935664 | 2021-09-14 04:21:41 | Walton, Florida, US | |
1885741 | 1885741 | 2021-09-12 | US | Florida | Walton | 12131 | 11987 | 89 | 0 | 30.64204028 | -86.16935664 | 2021-09-13 04:21:15 | Walton, Florida, US | |
3806644 | 3806644 | 2021-09-11 | US | Florida | Walton | 12131 | 11987 | 89 | 0 | 30.64204028 | -86.16935664 | 2021-09-12 04:21:13 | Walton, Florida, US | |
3449584 | 3449584 | 2021-09-10 | US | Florida | Walton | 12131 | 11987 | 89 | 0 | 30.64204028 | -86.16935664 | 2021-09-11 04:21:30 | Walton, Florida, US | |
3015160 | 3015160 | 2021-08-01 | China | Hong Kong | 11987 | 212 | 11715 | 60 | 22.3 | 114.2 | 2021-08-02 04:21:36 | Hong Kong, China | ||
1309136 | 1309136 | 2021-07-27 | US | Tennessee | Putnam | 47141 | 11987 | 182 | 0 | 36.14005459 | -85.50646123 | 2021-07-28 04:21:39 | Putnam, Tennessee, US | |
85885 | 85885 | 2021-05-25 | US | Rhode Island | Unassigned | 90044 | 11987 | 10 | 0 | 41.87064746 | 0.0 | 2021-05-26 04:20:35 | Unassigned, Rhode Island, US | |
3087558 | 3087558 | 2021-04-05 | US | New York | Schenectady | 36093 | 11987 | 188 | 0 | 42.81668777 | -74.05278291 | 2021-04-06 04:20:32 | Schenectady, New York, US | |
3067528 | 3067528 | 2021-02-27 | US | Louisiana | Tangipahoa | 22105 | 11987 | 266 | 0 | 11721 | 30.62888673 | -90.40664996 | 2021-02-28 05:22:20 | Tangipahoa, Louisiana, US |
2185112 | 2185112 | 2021-02-26 | US | Louisiana | Tangipahoa | 22105 | 11987 | 266 | 0 | 11721 | 30.62888673 | -90.40664996 | 2021-02-27 05:22:28 | Tangipahoa, Louisiana, US |
2467170 | 2467170 | 2021-01-22 | US | Alabama | Etowah | 1055 | 11987 | 179 | 0 | 11808 | 34.04567266 | -86.04051873 | 2021-01-23 05:22:03 | Etowah, Alabama, US |
190029 | 190029 | 2021-01-11 | India | Nagaland | 11987 | 84 | 11795 | 108 | 26.06702 | 94.470302 | 2021-01-12 05:22:15 | Nagaland, India | ||
1065268 | 1065268 | 2021-01-04 | US | Washington | Benton | 53005 | 11987 | 163 | 0 | 11824 | 46.23946995 | -119.5120834 | 2021-01-05 05:21:49 | Benton, Washington, US |
846427 | 846427 | 2020-12-12 | US | Georgia | Richmond | 13245 | 11987 | 234 | 0 | 11753 | 33.35777107 | -82.07026432 | 2020-12-13 05:27:20 | Richmond, Georgia, US |
681579 | 681579 | 2020-11-23 | US | Utah | Weber-Morgan | 11987 | 50 | 0 | 11937 | 41.27116049 | -111.9145117 | 2020-11-24 05:27:31 | Weber-Morgan, Utah, US | |
3190187 | 3190187 | 2020-11-22 | Russia | Kabardino-Balkarian Republic | 11987 | 193 | 9043 | 2751 | 43.4806048 | 43.5978976 | 2020-11-23 05:25:26 | Kabardino-Balkarian Republic, Russia | ||
789829 | 789829 | 2020-10-15 | US | Washington | Yakima | 53077 | 11987 | 263 | 0 | 11724 | 46.45738486 | -120.7380126 | 2020-10-16 04:24:01 | Yakima, Washington, US |
2061284 | 2061284 | 2020-09-01 | US | Kentucky | Jefferson | 21111 | 11987 | 265 | 0 | 11722 | 38.18664655 | -85.65931031 | 2020-09-02 04:28:25 | Jefferson, Kentucky, US |
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]);