daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
22 rows where confirmed = 16929 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-10-03 | US | Michigan | Montcalm | 26117 | 16929 | 221 | 0 | 43.31082541 | -85.15252824 | 2022-10-04 04:22:55 | Montcalm, Michigan, US | |
2022-10-02 | US | Michigan | Montcalm | 26117 | 16929 | 221 | 0 | 43.31082541 | -85.15252824 | 2022-10-03 04:23:11 | Montcalm, Michigan, US | |
2022-10-01 | US | Michigan | Montcalm | 26117 | 16929 | 221 | 0 | 43.31082541 | -85.15252824 | 2022-10-02 04:21:23 | Montcalm, Michigan, US | |
2022-09-30 | US | Michigan | Montcalm | 26117 | 16929 | 221 | 0 | 43.31082541 | -85.15252824 | 2022-10-01 04:23:01 | Montcalm, Michigan, US | |
2022-09-29 | US | Michigan | Montcalm | 26117 | 16929 | 221 | 0 | 43.31082541 | -85.15252824 | 2022-09-30 04:23:09 | Montcalm, Michigan, US | |
2022-09-28 | US | Michigan | Montcalm | 26117 | 16929 | 221 | 0 | 43.31082541 | -85.15252824 | 2022-09-29 04:22:34 | Montcalm, Michigan, US | |
2022-09-27 | US | Michigan | Montcalm | 26117 | 16929 | 221 | 0 | 43.31082541 | -85.15252824 | 2022-09-28 04:23:01 | Montcalm, Michigan, US | |
2022-06-01 | US | Oregon | Josephine | 41033 | 16929 | 340 | 0 | 42.3665549 | -123.5561938 | 2022-06-02 05:20:39 | Josephine, Oregon, US | |
2022-04-08 | US | Texas | Wise | 48497 | 16929 | 269 | 0 | 33.21570665 | -97.65460265 | 2022-04-09 04:20:42 | Wise, Texas, US | |
2021-12-14 | US | Montana | Cascade | 30013 | 16929 | 279 | 0 | 47.30797024 | -111.3467922 | 2021-12-15 03:22:16 | Cascade, Montana, US | |
2021-11-18 | Germany | Unknown | 16929 | 0 | 0 | 2021-11-19 04:21:40 | Unknown, Germany | |||||
2021-08-20 | US | Pennsylvania | Lebanon | 42075 | 16929 | 301 | 0 | 40.36680311 | -76.45651841 | 2021-08-21 04:21:38 | Lebanon, Pennsylvania, US | |
2021-05-25 | US | Georgia | Whitfield | 13313 | 16929 | 243 | 0 | 34.80987459 | -84.96093476 | 2021-05-26 04:20:35 | Whitfield, Georgia, US | |
2021-05-17 | US | South Carolina | Beaufort | 45013 | 16929 | 207 | 0 | 32.39226291 | -80.72619758 | 2021-05-18 04:20:33 | Beaufort, South Carolina, US | |
2021-05-16 | US | Georgia | Columbia | 13073 | 16929 | 203 | 0 | 33.54534185 | -82.263524 | 2021-05-17 04:20:34 | Columbia, Georgia, US | |
2021-05-13 | US | Georgia | Paulding | 13223 | 16929 | 218 | 0 | 33.91969522 | -84.86848792 | 2021-05-14 04:20:41 | Paulding, Georgia, US | |
2021-05-13 | Colombia | Casanare | 16929 | 385 | 15892 | 652 | 5.7589 | -71.5724 | 2021-05-14 04:20:41 | Casanare, Colombia | ||
2021-03-18 | US | North Carolina | New Hanover | 37129 | 16929 | 159 | 0 | 34.25758282 | -77.87075626 | 2021-03-19 05:26:09 | New Hanover, North Carolina, US | |
2021-03-10 | US | Florida | Clay | 12019 | 16929 | 315 | 0 | 29.98319144 | -81.85609986 | 2021-03-11 05:25:48 | Clay, Florida, US | |
2021-01-20 | US | Texas | Ellis | 48139 | 16929 | 205 | 0 | 17002 | 32.34894117 | -96.79371841 | 2021-01-21 05:22:01 | Ellis, Texas, US |
2020-10-10 | US | California | Tulare | 6107 | 16929 | 286 | 0 | 16654 | 36.22026558 | -118.8020203 | 2020-10-11 04:23:46 | Tulare, California, US |
2020-06-12 | Bolivia | 16929 | 559 | 2431 | 13939 | -16.2902 | -63.5887 | 2020-06-13 03:33:14 | Bolivia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;