johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where confirmed = 17893 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2272903 | 2272903 | 2022-10-20 | US | Illinois | Coles | 17029 | 17893 | 182 | 0 | 39.51949084 | -88.22358557 | 2022-10-21 04:22:23 | Coles, Illinois, US | |
1101380 | 1101380 | 2022-08-03 | US | Texas | Wise | 48497 | 17893 | 274 | 0 | 33.21570665 | -97.65460265 | 2022-08-04 04:20:58 | Wise, Texas, US | |
1577855 | 1577855 | 2022-04-10 | US | Minnesota | Blue Earth | 27013 | 17893 | 98 | 0 | 44.03554215 | -94.06699781 | 2022-04-11 04:21:02 | Blue Earth, Minnesota, US | |
1654097 | 1654097 | 2022-04-09 | US | Minnesota | Blue Earth | 27013 | 17893 | 98 | 0 | 44.03554215 | -94.06699781 | 2022-04-10 04:20:52 | Blue Earth, Minnesota, US | |
2117419 | 2117419 | 2022-04-08 | US | Minnesota | Blue Earth | 27013 | 17893 | 98 | 0 | 44.03554215 | -94.06699781 | 2022-04-09 04:20:42 | Blue Earth, Minnesota, US | |
3613978 | 3613978 | 2022-01-12 | US | Hawaii | Maui | 15009 | 17893 | 107 | 0 | 20.86399628 | -156.56890969999995 | 2022-01-13 08:00:09 | Maui, Hawaii, US | |
3894585 | 3894585 | 2021-08-29 | US | Pennsylvania | Centre | 42027 | 17893 | 230 | 0 | 40.92058903 | -77.82200624 | 2021-08-30 04:21:23 | Centre, Pennsylvania, US | |
104745 | 104745 | 2021-08-15 | US | Kentucky | Kenton | 21117 | 17893 | 210 | 0 | 38.93950319 | -84.53241199 | 2021-08-16 04:21:31 | Kenton, Kentucky, US | |
1451387 | 1451387 | 2021-06-03 | US | South Carolina | Berkeley | 45015 | 17893 | 201 | 0 | 33.20222596 | -79.94654523 | 2021-06-04 04:23:37 | Berkeley, South Carolina, US | |
2107503 | 2107503 | 2021-06-01 | US | Virginia | Norfolk | 51710 | 17893 | 263 | 0 | 36.89934014 | -76.26420872 | 2021-06-02 04:24:34 | Norfolk, Virginia, US | |
1982186 | 1982186 | 2021-03-25 | US | Maryland | Frederick | 24021 | 17893 | 297 | 0 | 39.47296601 | -77.39999394 | 2021-03-26 05:26:55 | Frederick, Maryland, US | |
473698 | 473698 | 2021-02-19 | US | North Carolina | Cabarrus | 37025 | 17893 | 224 | 0 | 17669 | 35.3877799 | -80.55267168 | 2021-02-20 05:22:51 | Cabarrus, North Carolina, US |
1588381 | 1588381 | 2021-02-05 | Russia | Karachay-Cherkess Republic | 17893 | 60 | 16178 | 1655 | 43.7368326 | 41.7267991 | 2021-02-06 05:23:55 | Karachay-Cherkess Republic, Russia | ||
3516260 | 3516260 | 2021-01-15 | US | Georgia | Richmond | 13245 | 17893 | 286 | 0 | 17607 | 33.35777107 | -82.07026432 | 2021-01-16 05:22:40 | Richmond, Georgia, US |
3230659 | 3230659 | 2021-01-03 | Russia | Khakassia Republic | 17893 | 274 | 14936 | 2683 | 53.72258845 | 91.44293627 | 2021-01-04 05:22:02 | Khakassia Republic, Russia | ||
895645 | 895645 | 2020-11-05 | US | Wisconsin | Dane | 55025 | 17893 | 50 | 0 | 17843 | 43.06601594 | -89.41733797 | 2020-11-06 05:24:55 | Dane, Wisconsin, US |
2498191 | 2498191 | 2020-11-03 | Peru | Ucayali | 17893 | 1517 | 0 | 16376 | -9.621718 | -73.444929 | 2020-11-04 05:25:09 | Ucayali, Peru | ||
3304366 | 3304366 | 2020-11-02 | Peru | Ucayali | 17893 | 1516 | 0 | 16377 | -9.621718 | -73.444929 | 2020-11-03 06:00:16 | Ucayali, Peru | ||
3409615 | 3409615 | 2020-11-01 | Peru | Ucayali | 17893 | 1514 | 0 | 16379 | -9.621718 | -73.444929 | 2020-11-02 05:25:04 | Ucayali, Peru | ||
609559 | 609559 | 2020-08-29 | Cote d'Ivoire | 17893 | 115 | 16440 | 1338 | 7.54 | -5.5471 | 2020-08-30 04:28:22 | Cote d'Ivoire | |||
228646 | 228646 | 2020-04-30 | Canada | Ontario | 17893 | 1082 | 0 | 16190 | 51.2538 | -85.3232 | 2020-05-01 02:32:28 | Ontario, Canada |
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]);