daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where confirmed = 18985 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-08-21 | Liechtenstein | 18985 | 86 | 0 | 47.14 | 9.55 | 2022-08-22 04:20:38 | Liechtenstein | ||||
2022-08-20 | Liechtenstein | 18985 | 86 | 0 | 47.14 | 9.55 | 2022-08-21 04:20:44 | Liechtenstein | ||||
2022-08-19 | Liechtenstein | 18985 | 86 | 0 | 47.14 | 9.55 | 2022-08-20 04:21:01 | Liechtenstein | ||||
2022-06-13 | US | New York | Wayne | 36117 | 18985 | 183 | 0 | 43.15494365 | -77.02976528 | 2022-06-14 04:20:52 | Wayne, New York, US | |
2022-05-26 | US | New Mexico | Valencia | 35061 | 18985 | 279 | 0 | 34.71669834 | -106.8103733 | 2022-05-27 04:20:56 | Valencia, New Mexico, US | |
2022-03-20 | US | Michigan | Midland | 26111 | 18985 | 222 | 0 | 43.64330771 | -84.38804374 | 2022-03-21 04:20:50 | Midland, Michigan, US | |
2022-03-19 | US | Michigan | Midland | 26111 | 18985 | 222 | 0 | 43.64330771 | -84.38804374 | 2022-03-20 04:20:45 | Midland, Michigan, US | |
2022-03-18 | US | Michigan | Midland | 26111 | 18985 | 222 | 0 | 43.64330771 | -84.38804374 | 2022-03-19 04:20:47 | Midland, Michigan, US | |
2022-01-18 | US | Kentucky | Campbell | 21037 | 18985 | 126 | 0 | 38.94384345 | -84.37875208 | 2022-01-19 04:21:23 | Campbell, Kentucky, US | |
2022-01-09 | US | Montana | Missoula | 30063 | 18985 | 192 | 0 | 47.03728583 | -113.92135079999998 | 2022-01-10 04:22:07 | Missoula, Montana, US | |
2022-01-08 | US | Montana | Missoula | 30063 | 18985 | 192 | 0 | 47.03728583 | -113.92135079999998 | 2022-01-09 04:21:46 | Missoula, Montana, US | |
2022-01-07 | US | Montana | Missoula | 30063 | 18985 | 192 | 0 | 47.03728583 | -113.92135079999998 | 2022-01-08 04:21:53 | Missoula, Montana, US | |
2021-11-07 | US | West Virginia | Berkeley | 54003 | 18985 | 186 | 0 | 39.46704621 | -78.02414609 | 2021-11-08 04:21:43 | Berkeley, West Virginia, US | |
2021-10-05 | US | Texas | Randall | 48381 | 18985 | 330 | 0 | 34.96585996 | -101.8971322 | 2021-10-06 04:21:33 | Randall, Texas, US | |
2021-10-01 | US | Arkansas | Faulkner | 5045 | 18985 | 214 | 0 | 35.14719007 | -92.33717519 | 2021-10-02 04:21:25 | Faulkner, Arkansas, US | |
2021-09-30 | US | Arkansas | Faulkner | 5045 | 18985 | 214 | 0 | 35.14719007 | -92.33717519 | 2021-10-01 04:21:35 | Faulkner, Arkansas, US | |
2021-05-06 | US | Maryland | Howard | 24027 | 18985 | 233 | 0 | 39.25305293 | -76.93126208 | 2021-05-07 04:20:40 | Howard, Maryland, US | |
2021-03-30 | Japan | Fukuoka | 18985 | 332 | 18214 | 439 | 33.526032 | 130.666949 | 2021-03-31 04:26:25 | Fukuoka, Japan | ||
2021-03-09 | US | Mississippi | Hinds | 28049 | 18985 | 396 | 0 | 32.2656285 | -90.44435448 | 2021-03-10 05:24:35 | Hinds, Mississippi, US | |
2021-02-10 | US | Iowa | Linn | 19113 | 18985 | 303 | 0 | 18682 | 42.07923082 | -91.59809485 | 2021-02-11 05:23:55 | Linn, Iowa, US |
2020-12-15 | Germany | Sachsen-Anhalt | 18985 | 289 | 12729 | 6456 | 51.9503 | 11.6923 | 2020-12-16 05:28:04 | Sachsen-Anhalt, Germany | ||
2020-12-01 | Ukraine | Mykolaiv Oblast | 18985 | 313 | 5734 | 12938 | 46.975 | 31.9946 | 2020-12-02 05:27:41 | Mykolaiv Oblast, Ukraine | ||
2020-11-01 | Chile | Maule | 18985 | 423 | 17961 | 601 | -35.5183 | -71.6885 | 2020-11-02 05:25:04 | Maule, Chile | ||
2020-10-09 | US | Illinois | DuPage | 17043 | 18985 | 579 | 0 | 18406 | 41.85116968 | -88.08642662 | 2020-10-10 04:23:57 | DuPage, Illinois, US |
2020-10-06 | Colombia | Narino | 18985 | 707 | 16843 | 1435 | 1.2892 | -77.3579 | 2020-10-07 04:23:40 | Narino, Colombia | ||
2020-06-21 | Brazil | Sergipe | 18985 | 462 | 6790 | 11733 | -10.5741 | -37.3857 | 2020-06-22 04:33:20 | Sergipe, Brazil |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;