daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where deaths = 9412 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-11-17 | Lithuania | 1272547 | 9412 | 0 | 55.1694 | 23.8813 | 2022-11-18 04:21:15 | Lithuania | ||||
2022-11-15 | Lithuania | 1271987 | 9412 | 0 | 55.1694 | 23.8813 | 2022-11-16 04:21:09 | Lithuania | ||||
2022-11-02 | Saudi Arabia | 822976 | 9412 | 0 | 23.885942 | 45.079162 | 2022-11-03 04:22:05 | Saudi Arabia | ||||
2022-07-10 | China | Hong Kong | 1271054 | 9412 | 0 | 22.3 | 114.2 | 2022-07-11 04:20:46 | Hong Kong, China | |||
2022-01-18 | Lebanon | 833871 | 9412 | 0 | 33.8547 | 35.8623 | 2022-01-19 04:21:23 | Lebanon | ||||
2021-09-17 | Colombia | Atlantico | 317223 | 9412 | 0 | 10.6966 | -74.8741 | 2021-09-18 04:21:24 | Atlantico, Colombia | |||
2021-08-12 | Canada | Ontario | 558493 | 9412 | 0 | 51.2538 | -85.3232 | 2021-08-13 04:21:24 | Ontario, Canada | |||
2021-08-11 | Canada | Ontario | 557954 | 9412 | 0 | 51.2538 | -85.3232 | 2021-08-12 04:21:25 | Ontario, Canada | |||
2021-07-13 | Nepal | 658778 | 9412 | 623105 | 26261 | 28.1667 | 84.25 | 2021-07-14 04:21:35 | Nepal |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;