daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6 rows where confirmed = 35142 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- Ghana 2
- Colombia 1
- Mauritania 1
- Russia 1
- US 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-09-15 | Mauritania | 35142 | 760 | 0 | 21.0079 | -10.9408 | 2021-09-16 04:22:19 | Mauritania | ||||
2021-08-22 | Colombia | Casanare | 35142 | 902 | 0 | 5.7589 | -71.5724 | 2021-08-23 04:21:27 | Casanare, Colombia | |||
2021-02-08 | Russia | Krasnodar Krai | 35142 | 1610 | 26981 | 6551 | 45.7684014 | 39.0261044 | 2021-02-09 05:23:30 | Krasnodar Krai, Russia | ||
2020-11-04 | US | Texas | El Paso | 48141 | 35142 | 669 | 0 | 55686 | 31.76980765 | -106.2363275 | 2020-11-05 06:05:03 | El Paso, Texas, US |
2020-07-30 | Ghana | 35142 | 175 | 31286 | 3681 | 7.9465 | -1.0232 | 2020-07-31 04:35:18 | Ghana | |||
2020-07-29 | Ghana | 35142 | 175 | 31286 | 3681 | 7.9465 | -1.0232 | 2020-07-30 04:35:05 | Ghana |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;