daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6 rows where deaths = 14604 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-02 | US | Illinois | Cook | 17031 | 1341966 | 14604 | 0 | 41.84144849 | -87.81658794 | 2022-08-03 04:20:59 | Cook, Illinois, US | |
2022-08-01 | US | Illinois | Cook | 17031 | 1340012 | 14604 | 0 | 41.84144849 | -87.81658794 | 2022-08-02 04:20:53 | Cook, Illinois, US | |
2022-07-17 | Brazil | Espirito Santo | 1180270 | 14604 | 0 | -19.1834 | -40.3089 | 2022-07-18 04:20:59 | Espirito Santo, Brazil | |||
2021-10-05 | Mexico | Puebla | 120231 | 14604 | 0 | 19.0414 | -98.2063 | 2021-10-06 04:21:33 | Puebla, Mexico | |||
2021-10-04 | Mexico | Puebla | 120231 | 14604 | 0 | 19.0414 | -98.2063 | 2021-10-05 04:21:27 | Puebla, Mexico | |||
2020-04-20 | US | New York | New York City | 36061 | 141235 | 14604 | 0 | 126631 | 40.76727260000001 | -73.97152637 | 2020-04-20 23:36:47 | New York City, New York, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;