daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where deaths = 5047 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-08 | Canada | Alberta | 614234 | 5047 | 0 | 53.9333 | -116.5765 | 2022-11-09 04:21:22 | Alberta, Canada | |||
2022-11-07 | Canada | Alberta | 614234 | 5047 | 0 | 53.9333 | -116.5765 | 2022-11-08 04:21:21 | Alberta, Canada | |||
2022-11-06 | Canada | Alberta | 614234 | 5047 | 0 | 53.9333 | -116.5765 | 2022-11-07 04:21:26 | Alberta, Canada | |||
2022-11-05 | Canada | Alberta | 614234 | 5047 | 0 | 53.9333 | -116.5765 | 2022-11-06 04:21:24 | Alberta, Canada | |||
2022-11-04 | Canada | Alberta | 614234 | 5047 | 0 | 53.9333 | -116.5765 | 2022-11-05 04:21:52 | Alberta, Canada | |||
2022-11-03 | Canada | Alberta | 614234 | 5047 | 0 | 53.9333 | -116.5765 | 2022-11-04 04:22:11 | Alberta, Canada | |||
2022-11-02 | Canada | Alberta | 614234 | 5047 | 0 | 53.9333 | -116.5765 | 2022-11-03 04:22:05 | Alberta, Canada | |||
2022-03-03 | Colombia | Norte de Santander | 119185 | 5047 | 0 | 7.9463 | -72.8988 | 2022-03-04 04:21:09 | Norte de Santander, Colombia | |||
2022-01-03 | Zimbabwe | 216087 | 5047 | 0 | -19.015438 | 29.154857 | 2022-01-04 04:22:17 | Zimbabwe | ||||
2021-12-13 | Russia | Volgograd Oblast | 123264 | 5047 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-12-14 04:22:38 | Volgograd Oblast, Russia | |||
2021-11-05 | Russia | Altai Krai | 90989 | 5047 | 0 | 52.693224300000004 | 82.69314240000001 | 2021-11-06 04:21:51 | Altai Krai, Russia | |||
2021-10-11 | Ukraine | Dnipropetrovsk Oblast | 159155 | 5047 | 0 | 48.4647 | 35.0462 | 2021-10-12 04:21:09 | Dnipropetrovsk Oblast, Ukraine | |||
2021-10-02 | Lithuania | 336575 | 5047 | 0 | 55.1694 | 23.8813 | 2021-10-03 04:21:24 | Lithuania | ||||
2021-08-21 | Malaysia | Selangor | 552133 | 5047 | 456686 | 90400 | 3.0738 | 101.5183 | 2021-08-22 04:21:29 | Selangor, Malaysia | ||
2021-05-22 | US | California | Orange | 6059 | 271589 | 5047 | 0 | 33.70147516 | -117.76459979999998 | 2021-05-23 04:20:51 | Orange, California, US | |
2021-04-22 | Honduras | 204828 | 5047 | 77431 | 122350 | 15.2 | -86.2419 | 2021-04-23 04:20:52 | Honduras | |||
2020-12-25 | Mexico | Guanajuato | 79837 | 5047 | 0 | 74790 | 21.019 | -101.2574 | 2020-12-26 05:22:28 | Guanajuato, Mexico | ||
2020-11-30 | Peru | Callao | 40792 | 5047 | 0 | 35745 | -11.954609 | -77.136042 | 2020-12-01 05:26:18 | Callao, Peru | ||
2020-10-22 | Brazil | Parana | 204326 | 5047 | 140100 | 59179 | -25.2521 | -52.0215 | 2020-10-23 04:24:46 | Parana, Brazil | ||
2020-09-20 | India | Uttar Pradesh | 354275 | 5047 | 283274 | 65954 | 26.925425 | 80.560982 | 2020-09-21 04:23:00 | Uttar Pradesh, India | ||
2020-07-12 | Ecuador | 67870 | 5047 | 30283 | 32540 | -1.8312 | -78.1834 | 2020-07-13 04:43:04 | Ecuador |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;