daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where country_or_region = "China" and "last_update" is on date 2020-03-20 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update
province_or_state 15
country_or_region 1
- China · 25 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-04-01 | China | Guangxi | 254 | 2 | 250 | 2 | 23.8298 | 108.7881 | 2020-03-20 04:33:45 | Guangxi, China | ||
2020-03-31 | China | Guangxi | 254 | 2 | 250 | 2 | 23.8298 | 108.7881 | 2020-03-20 04:33:45 | Guangxi, China | ||
2020-03-27 | China | Guangxi | 254 | 2 | 250 | 2 | 23.8298 | 108.7881 | 2020-03-20 04:33:45 | Guangxi, China | ||
2020-03-26 | China | Guangxi | 254 | 2 | 250 | 2 | 23.8298 | 108.7881 | 2020-03-20 04:33:45 | Guangxi, China | ||
2020-03-25 | China | Guangxi | 254 | 2 | 250 | 2 | 23.8298 | 108.7881 | 2020-03-20 04:33:45 | Guangxi, China | ||
2020-03-24 | China | Guangxi | 254 | 2 | 250 | 2 | 23.8298 | 108.7881 | 2020-03-20 04:33:45 | Guangxi, China | ||
2020-03-23 | China | Guangxi | 254 | 2 | 250 | 2 | 23.8298 | 108.7881 | 2020-03-20 04:33:45 | Guangxi, China | ||
2020-03-21 | China | Heilongjiang | 484 | 13 | 463 | 47.862 | 127.7615 | 2020-03-20T02:13:46 | ||||
2020-03-21 | China | Guangxi | 254 | 2 | 250 | 23.8298 | 108.7881 | 2020-03-20T00:43:02 | ||||
2020-03-21 | China | Liaoning | 126 | 2 | 122 | 41.2956 | 122.6085 | 2020-03-20T01:43:03 | ||||
2020-03-20 | China | Hubei | 67800 | 3133 | 58382 | 30.9756 | 112.2707 | 2020-03-20T07:43:02 | ||||
2020-03-20 | China | Guangdong | 1395 | 8 | 1323 | 23.3417 | 113.4244 | 2020-03-20T09:13:30 | ||||
2020-03-20 | China | Zhejiang | 1234 | 1 | 1219 | 29.1832 | 120.0934 | 2020-03-20T02:43:09 | ||||
2020-03-20 | China | Shandong | 762 | 7 | 748 | 36.3427 | 118.1498 | 2020-03-20T01:13:16 | ||||
2020-03-20 | China | Sichuan | 541 | 3 | 536 | 30.6171 | 102.7103 | 2020-03-20T01:43:03 | ||||
2020-03-20 | China | Beijing | 491 | 8 | 390 | 40.1824 | 116.4142 | 2020-03-20T06:43:05 | ||||
2020-03-20 | China | Heilongjiang | 484 | 13 | 463 | 47.862 | 127.7615 | 2020-03-20T02:13:46 | ||||
2020-03-20 | China | Shanghai | 371 | 3 | 326 | 31.202 | 121.4491 | 2020-03-20T00:43:02 | ||||
2020-03-20 | China | Fujian | 299 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-20T02:43:09 | ||||
2020-03-20 | China | Hong Kong | 256 | 4 | 98 | 22.3 | 114.2 | 2020-03-20T09:43:03 | ||||
2020-03-20 | China | Guangxi | 254 | 2 | 250 | 23.8298 | 108.7881 | 2020-03-20T00:43:02 | ||||
2020-03-20 | China | Shaanxi | 247 | 3 | 237 | 35.1917 | 108.8701 | 2020-03-20T01:13:16 | ||||
2020-03-20 | China | Gansu | 134 | 2 | 98 | 36.0611 | 103.8343 | 2020-03-20T00:13:24 | ||||
2020-03-20 | China | Liaoning | 126 | 2 | 122 | 41.2956 | 122.6085 | 2020-03-20T01:43:03 | ||||
2020-03-20 | China | Unknown | 0 | 0 | 0 | 2020-03-20T07:43:02 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;