daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
7 rows where confirmed = 71200 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-14 | US | Texas | Hays | 48209 | 71200 | 531 | 0 | 30.05669873 | -98.02944344 | 2022-08-15 04:20:59 | Hays, Texas, US | |
2022-08-13 | US | Texas | Hays | 48209 | 71200 | 531 | 0 | 30.05669873 | -98.02944344 | 2022-08-14 04:20:55 | Hays, Texas, US | |
2022-08-12 | US | Texas | Hays | 48209 | 71200 | 531 | 0 | 30.05669873 | -98.02944344 | 2022-08-13 04:20:52 | Hays, Texas, US | |
2021-11-08 | Russia | Yaroslavl Oblast | 71200 | 1428 | 0 | 57.77819760000001 | 39.002109499999996 | 2021-11-09 04:21:36 | Yaroslavl Oblast, Russia | |||
2021-04-12 | Belgium | Flemish Brabant | 71200 | 0 | 0 | 71200 | 50.9167 | 4.5833 | 2021-04-13 04:20:37 | Flemish Brabant, Belgium | ||
2021-04-02 | Spain | Extremadura | 71200 | 1757 | 2652 | 66791 | 39.4937 | -6.0679 | 2021-04-03 04:20:44 | Extremadura, Spain | ||
2021-04-01 | Spain | Extremadura | 71200 | 1757 | 2652 | 66791 | 39.4937 | -6.0679 | 2021-04-02 04:20:36 | Extremadura, Spain |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;