daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
22 rows where country_or_region = "China" and "last_update" is on date 2020-04-07 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, last_update, combined_key, last_update (date)
province_or_state 16
country_or_region 1
- China · 22 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-04-10 | China | Yunnan | 184 | 2 | 173 | 9 | 24.974 | 101.487 | 2020-04-07 00:20:57 | Yunnan, China | ||
2020-04-09 | China | Sichuan | 560 | 3 | 541 | 16 | 30.6171 | 102.7103 | 2020-04-07 01:35:16 | Sichuan, China | ||
2020-04-09 | China | Yunnan | 184 | 2 | 173 | 9 | 24.974 | 101.48700000000001 | 2020-04-07 00:20:57 | Yunnan, China | ||
2020-04-08 | China | Hebei | 327 | 6 | 312 | 9 | 39.549 | 116.1306 | 2020-04-07 00:29:03 | Hebei, China | ||
2020-04-08 | China | Sichuan | 560 | 3 | 541 | 16 | 30.6171 | 102.7103 | 2020-04-07 01:35:16 | Sichuan, China | ||
2020-04-08 | China | Yunnan | 184 | 2 | 173 | 9 | 24.974 | 101.487 | 2020-04-07 00:20:57 | Yunnan, China | ||
2020-04-07 | China | Beijing | 587 | 8 | 448 | 131 | 40.1824 | 116.4142 | 2020-04-07 00:55:26 | Beijing, China | ||
2020-04-07 | China | Fujian | 351 | 1 | 305 | 45 | 26.0789 | 117.9874 | 2020-04-07 00:55:26 | Fujian, China | ||
2020-04-07 | China | Guangdong | 1533 | 8 | 1401 | 124 | 23.3417 | 113.4244 | 2020-04-07 01:51:26 | Guangdong, China | ||
2020-04-07 | China | Hebei | 327 | 6 | 312 | 9 | 39.549 | 116.1306 | 2020-04-07 00:29:03 | Hebei, China | ||
2020-04-07 | China | Heilongjiang | 544 | 13 | 469 | 62 | 47.861999999999995 | 127.7615 | 2020-04-07 00:20:57 | Heilongjiang, China | ||
2020-04-07 | China | Hong Kong | 935 | 4 | 216 | 715 | 22.3 | 114.2 | 2020-04-07 09:08:12 | Hong Kong, China | ||
2020-04-07 | China | Hubei | 67803 | 3212 | 64073 | 518 | 30.9756 | 112.2707 | 2020-04-07 01:46:23 | Hubei, China | ||
2020-04-07 | China | Inner Mongolia | 121 | 1 | 74 | 46 | 44.0935 | 113.9448 | 2020-04-07 02:06:38 | Inner Mongolia, China | ||
2020-04-07 | China | Liaoning | 144 | 2 | 130 | 12 | 41.2956 | 122.6085 | 2020-04-07 00:29:03 | Liaoning, China | ||
2020-04-07 | China | Shandong | 781 | 7 | 755 | 19 | 36.3427 | 118.1498 | 2020-04-07 00:55:26 | Shandong, China | ||
2020-04-07 | China | Shanghai | 538 | 6 | 406 | 126 | 31.201999999999998 | 121.4491 | 2020-04-07 06:21:55 | Shanghai, China | ||
2020-04-07 | China | Sichuan | 560 | 3 | 541 | 16 | 30.6171 | 102.7103 | 2020-04-07 01:35:16 | Sichuan, China | ||
2020-04-07 | China | Tianjin | 180 | 3 | 151 | 26 | 39.3054 | 117.323 | 2020-04-07 00:20:57 | Tianjin, China | ||
2020-04-07 | China | Yunnan | 184 | 2 | 173 | 9 | 24.974 | 101.48700000000001 | 2020-04-07 00:20:57 | Yunnan, China | ||
2020-04-07 | China | Zhejiang | 1265 | 1 | 1230 | 34 | 29.1832 | 120.0934 | 2020-04-07 02:06:38 | Zhejiang, China | ||
2020-04-07 | China | Unknown | 1974 | 0 | 0 | 0 | 2020-04-07 23:04:49 | Unknown, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;