daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12 rows where deaths = 8427 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-09-25 | Russia | Voronezh Oblast | 449105 | 8427 | 0 | 50.9800393 | 40.1506507 | 2022-09-26 04:20:52 | Voronezh Oblast, Russia | |||
2022-08-17 | Brazil | Rio Grande do Norte | 550007 | 8427 | 0 | -5.4026 | -36.9541 | 2022-08-18 04:21:11 | Rio Grande do Norte, Brazil | |||
2022-07-06 | Mexico | Hidalgo | 99811 | 8427 | 0 | 20.0911 | -98.7624 | 2022-07-07 04:20:55 | Hidalgo, Mexico | |||
2022-07-05 | Mexico | Hidalgo | 99372 | 8427 | 0 | 20.0911 | -98.7624 | 2022-07-06 04:20:58 | Hidalgo, Mexico | |||
2022-07-04 | Mexico | Hidalgo | 98876 | 8427 | 0 | 20.0911 | -98.7624 | 2022-07-05 04:20:45 | Hidalgo, Mexico | |||
2022-07-03 | Mexico | Hidalgo | 98788 | 8427 | 0 | 20.0911 | -98.7624 | 2022-07-04 04:20:54 | Hidalgo, Mexico | |||
2022-02-04 | Cuba | 1050840 | 8427 | 0 | 21.521757 | -77.78116700000002 | 2022-02-05 04:21:05 | Cuba | ||||
2021-11-22 | Russia | Rostov Oblast | 170353 | 8427 | 0 | 47.6222451 | 40.7957942 | 2021-11-23 04:22:39 | Rostov Oblast, Russia | |||
2021-09-11 | Croatia | 383108 | 8427 | 0 | 45.1 | 15.2 | 2021-09-12 04:21:13 | Croatia | ||||
2021-02-21 | Mexico | Puebla | 68704 | 8427 | 0 | 60277 | 19.0414 | -98.2063 | 2021-02-22 05:24:21 | Puebla, Mexico | ||
2021-01-15 | US | Illinois | Cook | 17031 | 429270 | 8427 | 0 | 420843 | 41.84144849 | -87.81658794 | 2021-01-16 05:22:40 | Cook, Illinois, US |
2020-07-01 | Spain | Madrid | 72033 | 8427 | 40736 | 22870 | 40.4168 | -3.7038 | 2020-07-02 04:33:46 | Madrid, Spain |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;