daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where country_or_region = "China" and "last_update" is on date 2020-04-18 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed
province_or_state 12
country_or_region 1
- China · 26 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-04-27 | China | Hunan | 1019 | 4 | 1015 | 0 | 27.6104 | 111.7088 | 2020-04-18 01:15:10 | Hunan, China | ||
2020-04-26 | China | Hunan | 1019 | 4 | 1015 | 0 | 27.6104 | 111.7088 | 2020-04-18 01:15:10 | Hunan, China | ||
2020-04-25 | China | Hunan | 1019 | 4 | 1015 | 0 | 27.6104 | 111.7088 | 2020-04-18 01:15:10 | Hunan, China | ||
2020-04-24 | China | Hunan | 1019 | 4 | 1015 | 0 | 27.6104 | 111.7088 | 2020-04-18 01:15:10 | Hunan, China | ||
2020-04-23 | China | Hunan | 1019 | 4 | 1015 | 0 | 27.6104 | 111.7088 | 2020-04-18 01:15:10 | Hunan, China | ||
2020-04-22 | China | Hunan | 1019 | 4 | 1015 | 0 | 27.6104 | 111.7088 | 2020-04-18 01:15:10 | Hunan, China | ||
2020-04-21 | China | Hunan | 1019 | 4 | 1015 | 0 | 27.6104 | 111.7088 | 2020-04-18 01:15:10 | Hunan, China | ||
2020-04-21 | China | Shandong | 787 | 7 | 765 | 15 | 36.3427 | 118.1498 | 2020-04-18 01:49:39 | Shandong, China | ||
2020-04-20 | China | Hunan | 1019 | 4 | 1015 | 0 | 27.6104 | 111.7088 | 2020-04-18 01:15:10 | Hunan, China | ||
2020-04-20 | China | Shandong | 787 | 7 | 765 | 15 | 36.3427 | 118.1498 | 2020-04-18 01:49:39 | Shandong, China | ||
2020-04-19 | China | Hunan | 1019 | 4 | 1015 | 0 | 27.6104 | 111.7088 | 2020-04-18 01:15:10 | Hunan, China | ||
2020-04-19 | China | Inner Mongolia | 193 | 1 | 104 | 88 | 44.0935 | 113.9448 | 2020-04-18 01:41:32 | Inner Mongolia, China | ||
2020-04-19 | China | Liaoning | 146 | 2 | 142 | 2 | 41.2956 | 122.6085 | 2020-04-18 00:17:14 | Liaoning, China | ||
2020-04-19 | China | Shandong | 787 | 7 | 765 | 15 | 36.3427 | 118.1498 | 2020-04-18 01:49:39 | Shandong, China | ||
2020-04-18 | China | Fujian | 355 | 1 | 336 | 18 | 26.0789 | 117.9874 | 2020-04-18 00:51:42 | Fujian, China | ||
2020-04-18 | China | Guangdong | 1579 | 8 | 1482 | 89 | 23.3417 | 113.4244 | 2020-04-18 01:06:03 | Guangdong, China | ||
2020-04-18 | China | Heilongjiang | 892 | 13 | 472 | 407 | 47.862 | 127.7615 | 2020-04-18 00:17:14 | Heilongjiang, China | ||
2020-04-18 | China | Hong Kong | 1023 | 4 | 568 | 452 | 22.3 | 114.2 | 2020-04-18 15:25:38 | Hong Kong, China | ||
2020-04-18 | China | Hubei | 68128 | 4512 | 63494 | 122 | 30.9756 | 112.2707 | 2020-04-18 01:15:10 | Hubei, China | ||
2020-04-18 | China | Hunan | 1019 | 4 | 1015 | 0 | 27.6104 | 111.7088 | 2020-04-18 01:15:10 | Hunan, China | ||
2020-04-18 | China | Inner Mongolia | 193 | 1 | 104 | 88 | 44.0935 | 113.9448 | 2020-04-18 01:41:32 | Inner Mongolia, China | ||
2020-04-18 | China | Liaoning | 146 | 2 | 142 | 2 | 41.2956 | 122.6085 | 2020-04-18 00:17:14 | Liaoning, China | ||
2020-04-18 | China | Macau | 45 | 0 | 17 | 28 | 22.1667 | 113.55 | 2020-04-18 00:39:33 | Macau, China | ||
2020-04-18 | China | Shandong | 787 | 7 | 765 | 15 | 36.3427 | 118.1498 | 2020-04-18 01:49:39 | Shandong, China | ||
2020-04-18 | China | Sichuan | 561 | 3 | 553 | 5 | 30.6171 | 102.7103 | 2020-04-18 01:43:34 | Sichuan, China | ||
2020-04-18 | China | Unknown | 2472 | 0 | 0 | 0 | 2020-04-18 22:32:47 | Unknown, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;