daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where confirmed = 15421 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-24 | US | Michigan | St. Joseph | 26149 | 15421 | 223 | 0 | 41.91441767 | -85.52797979 | 2022-10-25 04:21:53 | St. Joseph, Michigan, US | |
2022-10-23 | US | Michigan | St. Joseph | 26149 | 15421 | 223 | 0 | 41.91441767 | -85.52797979 | 2022-10-24 04:22:29 | St. Joseph, Michigan, US | |
2022-10-22 | US | Michigan | St. Joseph | 26149 | 15421 | 223 | 0 | 41.91441767 | -85.52797979 | 2022-10-23 04:22:46 | St. Joseph, Michigan, US | |
2022-10-21 | US | Michigan | St. Joseph | 26149 | 15421 | 223 | 0 | 41.91441767 | -85.52797979 | 2022-10-22 04:22:53 | St. Joseph, Michigan, US | |
2022-10-20 | US | Michigan | St. Joseph | 26149 | 15421 | 223 | 0 | 41.91441767 | -85.52797979 | 2022-10-21 04:22:23 | St. Joseph, Michigan, US | |
2022-10-19 | US | Michigan | St. Joseph | 26149 | 15421 | 223 | 0 | 41.91441767 | -85.52797979 | 2022-10-20 04:22:59 | St. Joseph, Michigan, US | |
2022-10-18 | US | Michigan | St. Joseph | 26149 | 15421 | 223 | 0 | 41.91441767 | -85.52797979 | 2022-10-19 04:22:26 | St. Joseph, Michigan, US | |
2022-07-04 | US | Alabama | Blount | 1009 | 15421 | 246 | 0 | 33.98210918 | -86.56790593 | 2022-07-05 04:20:45 | Blount, Alabama, US | |
2022-05-26 | US | Louisiana | Vermilion | 22113 | 15421 | 224 | 0 | 29.83517605 | -92.30292538 | 2022-05-27 04:20:56 | Vermilion, Louisiana, US | |
2022-03-28 | Japan | Akita | 15421 | 45 | 0 | 39.748678999999996 | 140.408228 | 2022-03-29 04:20:46 | Akita, Japan | |||
2021-12-13 | US | New York | Oswego | 36075 | 15421 | 138 | 0 | 43.42778894 | -76.14635194 | 2021-12-14 04:22:38 | Oswego, New York, US | |
2021-11-16 | US | North Carolina | Lincoln | 37109 | 15421 | 107 | 0 | 35.48508185 | -81.21740317 | 2021-11-17 04:21:48 | Lincoln, North Carolina, US | |
2021-10-28 | US | Indiana | Monroe | 18105 | 15421 | 200 | 0 | 39.16130004 | -86.52414358 | 2021-10-29 04:22:03 | Monroe, Indiana, US | |
2021-07-20 | Russia | Mari El Republic | 15421 | 345 | 14377 | 699 | 56.5767504 | 47.8817512 | 2021-07-21 04:21:40 | Mari El Republic, Russia | ||
2021-07-13 | Peru | Huancavelica | 15421 | 1120 | 0 | 14301 | -13.023888 | -75.00277 | 2021-07-14 04:21:35 | Huancavelica, Peru | ||
2021-07-12 | Peru | Huancavelica | 15421 | 1120 | 0 | 14301 | -13.023888 | -75.00277 | 2021-07-13 04:21:18 | Huancavelica, Peru | ||
2021-05-04 | US | Missouri | Jasper | 29097 | 15421 | 233 | 0 | 37.20351921 | -94.34050458 | 2021-05-05 04:20:43 | Jasper, Missouri, US | |
2021-04-10 | US | Missouri | Jasper | 29097 | 15421 | 231 | 0 | 37.20351921 | -94.34050458 | 2021-04-11 04:20:56 | Jasper, Missouri, US | |
2021-04-05 | Sweden | Kalmar | 15421 | 222 | 0 | 15199 | 57.235 | 16.1849 | 2021-04-06 04:20:32 | Kalmar, Sweden | ||
2021-04-04 | Sweden | Kalmar | 15421 | 222 | 0 | 15199 | 57.235 | 16.1849 | 2021-04-05 04:20:35 | Kalmar, Sweden | ||
2021-04-03 | Sweden | Kalmar | 15421 | 222 | 0 | 15199 | 57.235 | 16.1849 | 2021-04-04 04:20:49 | Kalmar, Sweden | ||
2021-04-02 | US | New Jersey | Cumberland | 34011 | 15421 | 404 | 0 | 39.37199394 | -75.10712559 | 2021-04-03 04:20:44 | Cumberland, New Jersey, US | |
2021-04-02 | Sweden | Kalmar | 15421 | 222 | 0 | 15199 | 57.235 | 16.1849 | 2021-04-03 04:20:44 | Kalmar, Sweden | ||
2021-04-01 | Sweden | Kalmar | 15421 | 222 | 0 | 15199 | 57.235 | 16.1849 | 2021-04-02 04:20:36 | Kalmar, Sweden | ||
2021-02-15 | Netherlands | Zeeland | 15421 | 168 | 0 | 15249 | 51.47936 | 3.861559 | 2021-02-16 05:24:38 | Zeeland, Netherlands | ||
2021-01-03 | US | Ohio | Lorain | 39093 | 15421 | 327 | 0 | 15094 | 41.29553751 | -82.15083537 | 2021-01-04 05:22:02 | Lorain, Ohio, US |
2020-11-15 | Russia | Tomsk Oblast | 15421 | 136 | 9755 | 5530 | 58.6124279 | 82.04753149999998 | 2020-11-16 05:25:57 | Tomsk Oblast, Russia | ||
2020-11-15 | Japan | Osaka | 15421 | 261 | 13080 | 2080 | 34.620965000000005 | 135.507481 | 2020-11-16 05:25:57 | Osaka, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;