daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12 rows where confirmed = 40833 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 7
- Russia 2
- Afghanistan 1
- Japan 1
- Mexico 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-08-23 | US | Louisiana | Livingston | 22063 | 40833 | 475 | 0 | 30.44143993 | -90.73061664 | 2022-08-24 04:20:46 | Livingston, Louisiana, US | |
2022-07-22 | Mexico | Campeche | 40833 | 2263 | 0 | 19.8301 | -90.5349 | 2022-07-23 04:20:53 | Campeche, Mexico | |||
2022-07-09 | US | Tennessee | Washington | 47179 | 40833 | 504 | 0 | 36.29472368 | -82.4945472 | 2022-07-10 04:20:54 | Washington, Tennessee, US | |
2022-04-03 | US | Minnesota | Olmsted | 27109 | 40833 | 176 | 0 | 44.00374114 | -92.40209944 | 2022-04-04 04:20:51 | Olmsted, Minnesota, US | |
2022-04-02 | US | Minnesota | Olmsted | 27109 | 40833 | 176 | 0 | 44.00374114 | -92.40209944 | 2022-04-03 04:20:48 | Olmsted, Minnesota, US | |
2022-04-01 | US | Minnesota | Olmsted | 27109 | 40833 | 176 | 0 | 44.00374114 | -92.40209944 | 2022-04-02 04:20:47 | Olmsted, Minnesota, US | |
2022-02-17 | US | Montana | Yellowstone | 30111 | 40833 | 514 | 0 | 45.93955949 | -108.26914860000001 | 2022-02-18 04:21:04 | Yellowstone, Montana, US | |
2022-02-08 | US | Texas | Johnson | 48251 | 40833 | 655 | 0 | 32.37877812 | -97.36615819 | 2022-02-09 04:21:04 | Johnson, Texas, US | |
2021-05-13 | Japan | Saitama | 40833 | 758 | 37054 | 3021 | 35.997101 | 139.347635 | 2021-05-14 04:20:41 | Saitama, Japan | ||
2021-04-13 | Russia | Kirov Oblast | 40833 | 332 | 37536 | 2965 | 57.9665589 | 49.4074599 | 2021-04-14 04:20:41 | Kirov Oblast, Russia | ||
2021-02-28 | Russia | Karelia Republic | 40833 | 306 | 36741 | 3786 | 62.61940309999999 | 33.4920267 | 2021-03-01 05:23:01 | Karelia Republic, Russia | ||
2020-10-26 | Afghanistan | 40833 | 1514 | 34150 | 5169 | 33.93911 | 67.709953 | 2020-10-27 04:24:45 | Afghanistan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;