daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where confirmed = 18750 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-22 | US | Arizona | Santa Cruz | 4023 | 18750 | 239 | 0 | 31.52508998 | -110.8479088 | 2022-11-23 04:21:06 | Santa Cruz, Arizona, US | |
2022-11-21 | US | Arizona | Santa Cruz | 4023 | 18750 | 239 | 0 | 31.52508998 | -110.8479088 | 2022-11-22 04:20:47 | Santa Cruz, Arizona, US | |
2022-11-20 | US | Arizona | Santa Cruz | 4023 | 18750 | 239 | 0 | 31.52508998 | -110.8479088 | 2022-11-21 04:21:05 | Santa Cruz, Arizona, US | |
2022-11-19 | US | Arizona | Santa Cruz | 4023 | 18750 | 239 | 0 | 31.52508998 | -110.8479088 | 2022-11-20 04:21:08 | Santa Cruz, Arizona, US | |
2022-11-18 | US | Arizona | Santa Cruz | 4023 | 18750 | 239 | 0 | 31.52508998 | -110.8479088 | 2022-11-19 04:21:14 | Santa Cruz, Arizona, US | |
2022-11-17 | US | Arizona | Santa Cruz | 4023 | 18750 | 239 | 0 | 31.52508998 | -110.8479088 | 2022-11-18 04:21:15 | Santa Cruz, Arizona, US | |
2022-11-16 | US | Arizona | Santa Cruz | 4023 | 18750 | 239 | 0 | 31.52508998 | -110.8479088 | 2022-11-17 04:21:11 | Santa Cruz, Arizona, US | |
2022-10-20 | US | Texas | Wise | 48497 | 18750 | 280 | 0 | 33.21570665 | -97.65460265 | 2022-10-21 04:22:23 | Wise, Texas, US | |
2022-10-19 | US | Texas | Wise | 48497 | 18750 | 280 | 0 | 33.21570665 | -97.65460265 | 2022-10-20 04:22:59 | Wise, Texas, US | |
2022-09-18 | US | Illinois | Jackson | 17077 | 18750 | 129 | 0 | 37.78595185 | -89.38232563 | 2022-09-19 04:21:49 | Jackson, Illinois, US | |
2022-09-17 | US | Illinois | Jackson | 17077 | 18750 | 129 | 0 | 37.78595185 | -89.38232563 | 2022-09-18 04:22:50 | Jackson, Illinois, US | |
2022-09-16 | US | Illinois | Jackson | 17077 | 18750 | 129 | 0 | 37.78595185 | -89.38232563 | 2022-09-17 04:20:19 | Jackson, Illinois, US | |
2022-08-15 | US | Michigan | Van Buren | 26159 | 18750 | 287 | 0 | 42.25190229 | -86.01939087 | 2022-08-16 04:20:58 | Van Buren, Michigan, US | |
2022-08-14 | US | Michigan | Van Buren | 26159 | 18750 | 287 | 0 | 42.25190229 | -86.01939087 | 2022-08-15 04:20:59 | Van Buren, Michigan, US | |
2022-08-13 | US | Michigan | Van Buren | 26159 | 18750 | 287 | 0 | 42.25190229 | -86.01939087 | 2022-08-14 04:20:55 | Van Buren, Michigan, US | |
2022-08-12 | US | Michigan | Van Buren | 26159 | 18750 | 287 | 0 | 42.25190229 | -86.01939087 | 2022-08-13 04:20:52 | Van Buren, Michigan, US | |
2022-08-11 | US | Michigan | Van Buren | 26159 | 18750 | 287 | 0 | 42.25190229 | -86.01939087 | 2022-08-12 04:20:54 | Van Buren, Michigan, US | |
2022-08-10 | US | Michigan | Van Buren | 26159 | 18750 | 287 | 0 | 42.25190229 | -86.01939087 | 2022-08-11 04:20:49 | Van Buren, Michigan, US | |
2022-08-09 | US | Michigan | Van Buren | 26159 | 18750 | 287 | 0 | 42.25190229 | -86.01939087 | 2022-08-10 04:20:57 | Van Buren, Michigan, US | |
2022-04-22 | US | Pennsylvania | Somerset | 42111 | 18750 | 406 | 0 | 39.97172723 | -79.02699593 | 2022-04-23 04:20:50 | Somerset, Pennsylvania, US | |
2022-04-17 | US | Alabama | DeKalb | 1049 | 18750 | 326 | 0 | 34.45946862 | -85.80782906 | 2022-04-18 04:21:12 | DeKalb, Alabama, US | |
2022-04-16 | US | Alabama | DeKalb | 1049 | 18750 | 326 | 0 | 34.45946862 | -85.80782906 | 2022-04-17 04:20:59 | DeKalb, Alabama, US | |
2022-04-15 | US | Alabama | DeKalb | 1049 | 18750 | 326 | 0 | 34.45946862 | -85.80782906 | 2022-04-16 04:20:48 | DeKalb, Alabama, US | |
2022-02-28 | US | Indiana | Floyd | 18043 | 18750 | 272 | 0 | 38.32117957 | -85.90385377 | 2022-03-01 04:21:09 | Floyd, Indiana, US | |
2022-01-07 | Italy | Molise | 18750 | 512 | 0 | 41.55774754 | 14.65916051 | 2022-01-08 04:21:53 | Molise, Italy | |||
2021-12-11 | US | Texas | Tom Green | 48451 | 18750 | 395 | 0 | 31.40464436 | -100.46244300000001 | 2021-12-12 04:22:12 | Tom Green, Texas, US | |
2021-10-07 | Peru | Tumbes | 18750 | 1563 | 0 | -3.857496 | -80.54525500000003 | 2021-10-08 04:21:25 | Tumbes, Peru | |||
2021-06-01 | India | Ladakh | 18750 | 190 | 16979 | 1581 | 34.1526 | 77.5771 | 2021-06-02 04:24:34 | Ladakh, India | ||
2021-05-02 | US | Colorado | Pueblo | 8101 | 18750 | 398 | 0 | 38.17359144 | -104.5127437 | 2021-05-03 04:20:39 | Pueblo, Colorado, US | |
2021-04-20 | US | Tennessee | Wilson | 47189 | 18750 | 229 | 0 | 36.15496772 | -86.29775884 | 2021-04-21 04:21:14 | Wilson, Tennessee, US | |
2021-04-07 | Sweden | Sormland | 18750 | 421 | 0 | 18329 | 59.0336 | 16.7519 | 2021-04-08 04:21:13 | Sormland, Sweden | ||
2021-03-21 | Japan | Fukuoka | 18750 | 325 | 17891 | 534 | 33.526032 | 130.666949 | 2021-03-22 05:25:43 | Fukuoka, Japan | ||
2021-01-24 | Pakistan | Balochistan | 18750 | 193 | 18284 | 273 | 28.328492 | 65.898403 | 2021-01-25 05:22:16 | Balochistan, Pakistan | ||
2020-11-01 | India | Manipur | 18750 | 171 | 15065 | 3514 | 24.738975 | 93.882541 | 2020-11-02 05:25:04 | Manipur, India | ||
2020-10-25 | US | Texas | Cameron | 48061 | 18750 | 1075 | 0 | 22901 | 26.14524221 | -97.48140372 | 2020-10-26 04:25:02 | Cameron, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;