daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8 rows where deaths = 9520 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 6
- Brazil 2
- India 2
- China 1
- Mexico 1
- North Macedonia 1
- United Kingdom 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-09-15 | North Macedonia | 341986 | 9520 | 0 | 41.6086 | 21.7453 | 2022-09-16 04:21:19 | North Macedonia | ||||
2022-08-02 | China | Hong Kong | 1362371 | 9520 | 0 | 22.3 | 114.2 | 2022-08-03 04:20:59 | Hong Kong, China | |||
2022-02-20 | India | Rajasthan | 1274810 | 9520 | 0 | 26.583423 | 73.847973 | 2022-02-21 04:21:05 | Rajasthan, India | |||
2022-01-18 | United Kingdom | Wales | 746572 | 9520 | 0 | 52.1307 | -3.7837 | 2022-01-19 04:21:23 | Wales, United Kingdom | |||
2021-11-27 | Brazil | Paraiba | 460269 | 9520 | 0 | -7.24 | -36.782 | 2021-11-28 04:22:43 | Paraiba, Brazil | |||
2021-09-22 | Brazil | Mato Grosso do Sul | 372109 | 9520 | 0 | -20.7722 | -54.7852 | 2021-09-23 04:21:43 | Mato Grosso do Sul, Brazil | |||
2021-03-13 | Mexico | Puebla | 74517 | 9520 | 0 | 64997 | 19.0414 | -98.2063 | 2021-03-14 05:25:37 | Puebla, Mexico | ||
2020-09-30 | India | Tamil Nadu | 597602 | 9520 | 541819 | 46263 | 11.006091 | 78.400624 | 2020-10-01 04:23:42 | Tamil Nadu, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;