daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
11 rows where deaths = 6400 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-12-13 | Japan | Tokyo | 3691181 | 6400 | 0 | 35.711343 | 139.446921 | 2022-12-14 04:21:04 | Tokyo, Japan | |||
2022-09-25 | Japan | Osaka | 2081168 | 6400 | 0 | 34.620965 | 135.507481 | 2022-09-26 04:20:52 | Osaka, Japan | |||
2022-03-03 | Russia | Volgograd Oblast | 188461 | 6400 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-03-04 04:21:09 | Volgograd Oblast, Russia | |||
2022-02-21 | US | California | San Bernardino | 6071 | 579289 | 6400 | 0 | 34.84060306 | -116.1774685 | 2022-02-22 04:21:01 | San Bernardino, California, US | |
2022-02-20 | US | California | San Bernardino | 6071 | 577761 | 6400 | 0 | 34.84060306 | -116.1774685 | 2022-02-21 04:21:05 | San Bernardino, California, US | |
2022-02-19 | US | California | San Bernardino | 6071 | 577754 | 6400 | 0 | 34.84060306 | -116.1774685 | 2022-02-20 04:21:00 | San Bernardino, California, US | |
2022-02-18 | US | California | San Bernardino | 6071 | 577749 | 6400 | 0 | 34.84060306 | -116.1774685 | 2022-02-19 04:21:11 | San Bernardino, California, US | |
2022-01-28 | India | Assam | 711391 | 6400 | 0 | 26.357149 | 92.83044100000001 | 2022-01-29 04:21:10 | Assam, India | |||
2021-06-24 | Russia | Moscow Oblast | 298855 | 6400 | 244419 | 48036 | 55.50431579999999 | 38.0353929 | 2021-06-25 04:21:33 | Moscow Oblast, Russia | ||
2021-05-24 | Italy | Puglia | 248829 | 6400 | 210660 | 31769 | 41.12559576 | 16.86736689 | 2021-05-25 04:21:08 | Puglia, Italy | ||
2021-03-23 | Italy | Lazio | 271220 | 6400 | 215994 | 48826 | 41.89277044 | 12.48366722 | 2021-03-24 05:25:40 | Lazio, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;