daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where deaths = 4756 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-08-30 | Germany | Berlin | 1227303 | 4756 | 0 | 52.52 | 13.405 | 2022-08-31 04:20:57 | Berlin, Germany | |||
2022-07-18 | United Kingdom | Northern Ireland | 713294 | 4756 | 0 | 54.7877 | -6.4923 | 2022-07-19 04:20:58 | Northern Ireland, United Kingdom | |||
2022-07-03 | India | Jammu and Kashmir | 455333 | 4756 | 0 | 33.75943 | 76.612638 | 2022-07-04 04:20:54 | Jammu and Kashmir, India | |||
2022-07-02 | India | Jammu and Kashmir | 455257 | 4756 | 0 | 33.75943 | 76.612638 | 2022-07-03 04:20:59 | Jammu and Kashmir, India | |||
2022-07-01 | India | Jammu and Kashmir | 455183 | 4756 | 0 | 33.75943 | 76.612638 | 2022-07-02 04:21:16 | Jammu and Kashmir, India | |||
2022-06-30 | India | Jammu and Kashmir | 455089 | 4756 | 0 | 33.75943 | 76.612638 | 2022-07-01 04:21:10 | Jammu and Kashmir, India | |||
2022-06-29 | India | Jammu and Kashmir | 455006 | 4756 | 0 | 33.75943 | 76.612638 | 2022-06-30 04:21:01 | Jammu and Kashmir, India | |||
2022-06-28 | India | Jammu and Kashmir | 454933 | 4756 | 0 | 33.75943 | 76.612638 | 2022-06-29 04:20:59 | Jammu and Kashmir, India | |||
2022-06-27 | India | Jammu and Kashmir | 454865 | 4756 | 0 | 33.75943 | 76.612638 | 2022-06-28 04:20:58 | Jammu and Kashmir, India | |||
2022-06-26 | India | Jammu and Kashmir | 454798 | 4756 | 0 | 33.75943 | 76.612638 | 2022-06-27 04:21:00 | Jammu and Kashmir, India | |||
2022-02-21 | Spain | Aragon | 392597 | 4756 | 0 | 41.5976 | -0.9057 | 2022-02-22 04:21:01 | Aragon, Spain | |||
2022-02-16 | Russia | Tula Oblast | 123387 | 4756 | 0 | 53.9570701 | 37.369090899999996 | 2022-02-17 04:20:56 | Tula Oblast, Russia | |||
2021-11-01 | Slovenia | 337108 | 4756 | 0 | 46.1512 | 14.9955 | 2021-11-02 04:22:03 | Slovenia | ||||
2021-10-02 | US | Texas | Bexar | 48029 | 315536 | 4756 | 0 | 29.44928723 | -98.52019748 | 2021-10-03 04:21:24 | Bexar, Texas, US | |
2021-08-29 | Mexico | Tabasco | 112051 | 4756 | 0 | 17.8409 | -92.6189 | 2021-08-30 04:21:23 | Tabasco, Mexico | |||
2021-08-17 | Russia | Sverdlovsk Oblast | 116281 | 4756 | 0 | 58.6414755 | 61.802154599999994 | 2021-08-18 04:21:35 | Sverdlovsk Oblast, Russia | |||
2021-07-08 | Russia | Rostov Oblast | 101467 | 4756 | 91239 | 5472 | 47.6222451 | 40.7957942 | 2021-07-09 04:21:21 | Rostov Oblast, Russia | ||
2021-05-27 | US | California | San Bernardino | 6071 | 301675 | 4756 | 0 | 34.84060306 | -116.1774685 | 2021-05-28 04:20:36 | San Bernardino, California, US | |
2021-03-02 | Jordan | 402282 | 4756 | 354143 | 43383 | 31.24 | 36.51 | 2021-03-03 05:23:28 | Jordan | |||
2020-10-30 | Mexico | Puebla | 35547 | 4756 | 29782 | 1009 | 19.0414 | -98.2063 | 2020-10-31 04:24:44 | Puebla, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;