daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where deaths = 5089 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-22 | Germany | Berlin | 1352692 | 5089 | 0 | 52.52 | 13.405 | 2022-11-23 04:21:06 | Berlin, Germany | |||
2022-04-25 | US | Pennsylvania | Philadelphia | 42101 | 312583 | 5089 | 0 | 40.00338507 | -75.1379271 | 2022-04-26 04:20:51 | Philadelphia, Pennsylvania, US | |
2022-04-24 | US | Pennsylvania | Philadelphia | 42101 | 312583 | 5089 | 0 | 40.00338507 | -75.1379271 | 2022-04-25 04:20:56 | Philadelphia, Pennsylvania, US | |
2022-04-23 | US | Pennsylvania | Philadelphia | 42101 | 312345 | 5089 | 0 | 40.00338507 | -75.1379271 | 2022-04-24 04:20:56 | Philadelphia, Pennsylvania, US | |
2022-02-15 | Mexico | Morelos | 62676 | 5089 | 0 | 18.6813 | -99.1013 | 2022-02-16 04:21:10 | Morelos, Mexico | |||
2021-12-09 | Spain | Pais Vasco | 291254 | 5089 | 0 | 42.9896 | -2.6189 | 2021-12-10 04:22:28 | Pais Vasco, Spain | |||
2021-10-13 | Ukraine | Dnipropetrovsk Oblast | 161355 | 5089 | 0 | 48.4647 | 35.0462 | 2021-10-14 04:21:29 | Dnipropetrovsk Oblast, Ukraine | |||
2021-07-27 | Russia | Rostov Oblast | 107984 | 5089 | 95930 | 6965 | 47.6222451 | 40.7957942 | 2021-07-28 04:21:39 | Rostov Oblast, Russia | ||
2021-06-15 | Uruguay | 343615 | 5089 | 307189 | 31337 | -32.5228 | -55.7658 | 2021-06-16 04:22:32 | Uruguay | |||
2021-06-15 | India | Jharkhand | 343793 | 5089 | 336058 | 2646 | 23.654536 | 85.557631 | 2021-06-16 04:22:32 | Jharkhand, India | ||
2021-06-03 | Pakistan | Sindh | 321425 | 5089 | 292001 | 24335 | 26.009446 | 68.77680699999999 | 2021-06-04 04:23:37 | Sindh, Pakistan | ||
2021-03-08 | Lebanon | 397887 | 5089 | 312747 | 80051 | 33.8547 | 35.8623 | 2021-03-09 05:28:19 | Lebanon | |||
2021-02-08 | Spain | Castilla - La Mancha | 161214 | 5089 | 6392 | 149733 | 39.2796 | -3.0977 | 2021-02-09 05:23:30 | Castilla - La Mancha, Spain | ||
2020-11-25 | Mexico | Puebla | 39088 | 5089 | 0 | 33999 | 19.0414 | -98.2063 | 2020-11-26 05:27:44 | Puebla, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;