daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6 rows where confirmed = 33268 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-10-01 | US | Tennessee | Sumner | 47165 | 33268 | 401 | 0 | 36.46824103 | -86.45917204 | 2021-10-02 04:21:25 | Sumner, Tennessee, US | |
2021-09-11 | Pakistan | Azad Jammu and Kashmir | 33268 | 718 | 0 | 34.027401 | 73.947253 | 2021-09-12 04:21:13 | Azad Jammu and Kashmir, Pakistan | |||
2021-07-23 | Colombia | Casanare | 33268 | 820 | 31330 | 1118 | 5.7589 | -71.5724 | 2021-07-24 00:21:36 | Casanare, Colombia | ||
2021-07-22 | Colombia | Casanare | 33268 | 820 | 31330 | 1118 | 5.7589 | -71.5724 | 2021-07-23 04:21:29 | Casanare, Colombia | ||
2021-04-03 | Japan | Saitama | 33268 | 703 | 30925 | 1640 | 35.997101 | 139.347635 | 2021-04-04 04:20:49 | Saitama, Japan | ||
2021-03-21 | US | Alabama | Madison | 1089 | 33268 | 486 | 0 | 34.76327133 | -86.55069633 | 2021-03-22 05:25:43 | Madison, Alabama, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;