daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where confirmed = 18750 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 9
country_or_region 1
- US · 28 ✖
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 | |
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-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 | |
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;