daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,517 rows where country_or_region = "Mainland China" sorted by deaths descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Gansu 51
- Hebei 50
- Hubei 50
- Anhui 49
- Beijing 49
- Chongqing 49
- Fujian 49
- Guangdong 49
- Guangxi 49
- Guizhou 49
- Hainan 49
- Heilongjiang 49
- Henan 49
- Hunan 49
- Inner Mongolia 49
- Jiangsu 49
- Jiangxi 49
- Jilin 49
- Liaoning 49
- Ningxia 49
- Qinghai 49
- Shaanxi 49
- Shandong 49
- Shanghai 49
- Shanxi 49
- Sichuan 49
- Tianjin 49
- Xinjiang 49
- Yunnan 49
- Zhejiang 49
- …
country_or_region 1
- Mainland China · 1,517 ✖
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▲ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-02-18 | Mainland China | Heilongjiang | 464 | 11 | 111 | 47.862 | 127.7615 | 2020-02-18T11:03:12 | ||||
2020-02-16 | Mainland China | Heilongjiang | 445 | 11 | 79 | 47.862 | 127.7615 | 2020-02-16T13:53:03 | ||||
2020-02-13 | Mainland China | Henan | 1169 | 10 | 296 | 33.882 | 113.614 | 2020-02-13T14:53:02 | ||||
2020-02-13 | Mainland China | Heilongjiang | 395 | 9 | 33 | 47.862 | 127.7615 | 2020-02-13T12:13:06 | ||||
2020-03-05 | Mainland China | Beijing | 418 | 8 | 297 | 40.1824 | 116.4142 | 2020-03-04T23:23:01 | ||||
2020-03-07 | Mainland China | Beijing | 426 | 8 | 303 | 40.1824 | 116.4142 | 2020-03-07T01:03:05 | ||||
2020-03-04 | Mainland China | Beijing | 418 | 8 | 297 | 40.1824 | 116.4142 | 2020-03-04T23:23:01 | ||||
2020-03-03 | Mainland China | Beijing | 414 | 8 | 288 | 40.1824 | 116.4142 | 2020-03-03T02:03:11 | ||||
2020-03-01 | Mainland China | Beijing | 413 | 8 | 276 | 40.1824 | 116.4142 | 2020-03-01T02:53:03 | ||||
2020-03-09 | Mainland China | Guangdong | 1352 | 8 | 1260 | 23.3417 | 113.4244 | 2020-03-09T01:43:01 | ||||
2020-03-09 | Mainland China | Beijing | 428 | 8 | 315 | 40.1824 | 116.4142 | 2020-03-09T01:53:01 | ||||
2020-03-02 | Mainland China | Beijing | 414 | 8 | 282 | 40.1824 | 116.4142 | 2020-03-02T02:13:16 | ||||
2020-03-08 | Mainland China | Beijing | 428 | 8 | 308 | 40.1824 | 116.4142 | 2020-03-08T01:23:07 | ||||
2020-02-12 | Mainland China | Henan | 1135 | 8 | 246 | 33.882 | 113.614 | 2020-02-12T14:13:08 | ||||
2020-02-12 | Mainland China | Heilongjiang | 378 | 8 | 31 | 47.862 | 127.7615 | 2020-02-12T14:13:08 | ||||
2020-03-06 | Mainland China | Beijing | 422 | 8 | 299 | 40.1824 | 116.4142 | 2020-03-06T12:53:03 | ||||
2020-02-11 | Mainland China | Heilongjiang | 360 | 8 | 28 | 47.862 | 127.7615 | 2020-02-11T11:23:04 | ||||
2020-02-29 | Mainland China | Beijing | 411 | 8 | 271 | 40.1824 | 116.4142 | 2020-02-29T03:33:02 | ||||
2020-03-10 | Mainland China | Guangdong | 1353 | 8 | 1274 | 23.3417 | 113.4244 | 2020-03-10T09:13:07 | ||||
2020-03-10 | Mainland China | Beijing | 429 | 8 | 320 | 40.1824 | 116.4142 | 2020-03-10T01:13:07 | ||||
2020-03-05 | Mainland China | Guangdong | 1351 | 7 | 1181 | 23.3417 | 113.4244 | 2020-03-05T09:23:03 | ||||
2020-03-07 | Mainland China | Guangdong | 1352 | 7 | 1237 | 23.3417 | 113.4244 | 2020-03-07T10:43:02 | ||||
2020-03-04 | Mainland China | Guangdong | 1350 | 7 | 1133 | 23.3417 | 113.4244 | 2020-03-04T10:03:19 | ||||
2020-03-03 | Mainland China | Guangdong | 1350 | 7 | 1101 | 23.3417 | 113.4244 | 2020-03-03T10:23:10 | ||||
2020-02-25 | Mainland China | Guangdong | 1347 | 7 | 822 | 23.3417 | 113.4244 | 2020-02-25T08:53:02 | ||||
2020-03-01 | Mainland China | Guangdong | 1349 | 7 | 1016 | 23.3417 | 113.4244 | 2020-03-01T14:13:18 | ||||
2020-02-27 | Mainland China | Guangdong | 1347 | 7 | 890 | 23.3417 | 113.4244 | 2020-02-27T09:53:02 | ||||
2020-03-02 | Mainland China | Guangdong | 1350 | 7 | 1059 | 23.3417 | 113.4244 | 2020-03-02T15:03:23 | ||||
2020-03-08 | Mainland China | Guangdong | 1352 | 7 | 1256 | 23.3417 | 113.4244 | 2020-03-08T14:43:03 | ||||
2020-02-26 | Mainland China | Guangdong | 1347 | 7 | 851 | 23.3417 | 113.4244 | 2020-02-26T10:33:02 | ||||
2020-02-28 | Mainland China | Guangdong | 1348 | 7 | 935 | 23.3417 | 113.4244 | 2020-02-28T08:53:03 | ||||
2020-02-28 | Mainland China | Beijing | 410 | 7 | 257 | 40.1824 | 116.4142 | 2020-02-28T02:23:05 | ||||
2020-02-10 | Mainland China | Heilongjiang | 331 | 7 | 30 | 47.862 | 127.7615 | 2020-02-10T07:33:05 | ||||
2020-03-06 | Mainland China | Guangdong | 1352 | 7 | 1216 | 23.3417 | 113.4244 | 2020-03-06T12:53:03 | ||||
2020-02-11 | Mainland China | Henan | 1105 | 7 | 218 | 33.882 | 113.614 | 2020-02-11T14:03:05 | ||||
2020-02-29 | Mainland China | Guangdong | 1349 | 7 | 983 | 23.3417 | 113.4244 | 2020-02-29T15:33:03 | ||||
2020-03-05 | Mainland China | Anhui | 990 | 6 | 970 | 31.8257 | 117.2264 | 2020-03-05T04:33:02 | ||||
2020-03-05 | Mainland China | Shandong | 758 | 6 | 578 | 36.3427 | 118.1498 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Mainland China | Chongqing | 576 | 6 | 512 | 30.0572 | 107.874 | 2020-03-05T23:23:02 | ||||
2020-03-05 | Mainland China | Hebei | 318 | 6 | 304 | 38.0428 | 114.5149 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Mainland China | Hainan | 168 | 6 | 158 | 19.1959 | 109.7453 | 2020-03-05T06:13:10 | ||||
2020-03-07 | Mainland China | Anhui | 990 | 6 | 979 | 31.8257 | 117.2264 | 2020-03-06T03:23:06 | ||||
2020-03-07 | Mainland China | Shandong | 758 | 6 | 627 | 36.3427 | 118.1498 | 2020-03-07T13:03:05 | ||||
2020-03-07 | Mainland China | Chongqing | 576 | 6 | 526 | 30.0572 | 107.874 | 2020-03-07T23:23:02 | ||||
2020-03-07 | Mainland China | Hebei | 318 | 6 | 307 | 38.0428 | 114.5149 | 2020-03-07T13:03:05 | ||||
2020-03-07 | Mainland China | Hainan | 168 | 6 | 158 | 19.1959 | 109.7453 | 2020-03-05T06:13:10 | ||||
2020-03-04 | Mainland China | Anhui | 990 | 6 | 956 | 31.8257 | 117.2264 | 2020-03-04T10:03:19 | ||||
2020-03-04 | Mainland China | Shandong | 758 | 6 | 516 | 36.3427 | 118.1498 | 2020-03-04T12:53:03 | ||||
2020-03-04 | Mainland China | Chongqing | 576 | 6 | 502 | 30.0572 | 107.874 | 2020-03-04T23:23:01 | ||||
2020-03-04 | Mainland China | Hebei | 318 | 6 | 301 | 38.0428 | 114.5149 | 2020-03-04T10:03:19 | ||||
2020-02-15 | Mainland China | Anhui | 950 | 6 | 221 | 31.8257 | 117.2264 | 2020-02-15T12:13:08 | ||||
2020-03-03 | Mainland China | Anhui | 990 | 6 | 936 | 31.8257 | 117.2264 | 2020-03-03T14:33:03 | ||||
2020-03-03 | Mainland China | Shandong | 758 | 6 | 511 | 36.3427 | 118.1498 | 2020-03-03T07:53:03 | ||||
2020-03-03 | Mainland China | Chongqing | 576 | 6 | 490 | 30.0572 | 107.874 | 2020-03-03T23:13:05 | ||||
2020-03-03 | Mainland China | Hebei | 318 | 6 | 300 | 38.0428 | 114.5149 | 2020-03-03T09:33:02 | ||||
2020-02-25 | Mainland China | Anhui | 989 | 6 | 712 | 31.8257 | 117.2264 | 2020-02-25T06:33:02 | ||||
2020-02-25 | Mainland China | Shandong | 756 | 6 | 355 | 36.3427 | 118.1498 | 2020-02-25T12:53:02 | ||||
2020-02-25 | Mainland China | Chongqing | 576 | 6 | 372 | 30.0572 | 107.874 | 2020-02-25T23:23:03 | ||||
2020-02-25 | Mainland China | Hebei | 311 | 6 | 248 | 38.0428 | 114.5149 | 2020-02-25T12:43:02 | ||||
2020-03-01 | Mainland China | Anhui | 990 | 6 | 873 | 31.8257 | 117.2264 | 2020-03-01T10:03:03 | ||||
2020-03-01 | Mainland China | Shandong | 758 | 6 | 443 | 36.3427 | 118.1498 | 2020-03-01T11:33:03 | ||||
2020-03-01 | Mainland China | Chongqing | 576 | 6 | 450 | 30.0572 | 107.874 | 2020-03-01T23:13:08 | ||||
2020-03-01 | Mainland China | Hebei | 318 | 6 | 294 | 38.0428 | 114.5149 | 2020-03-01T14:13:18 | ||||
2020-02-27 | Mainland China | Anhui | 989 | 6 | 792 | 31.8257 | 117.2264 | 2020-02-27T14:13:06 | ||||
2020-02-27 | Mainland China | Shandong | 756 | 6 | 387 | 36.3427 | 118.1498 | 2020-02-27T14:13:06 | ||||
2020-02-27 | Mainland China | Chongqing | 576 | 6 | 401 | 30.0572 | 107.874 | 2020-02-27T23:23:02 | ||||
2020-02-27 | Mainland China | Hebei | 317 | 6 | 274 | 38.0428 | 114.5149 | 2020-02-27T12:43:02 | ||||
2020-03-09 | Mainland China | Anhui | 990 | 6 | 984 | 31.8257 | 117.2264 | 2020-03-08T05:13:06 | ||||
2020-03-09 | Mainland China | Shandong | 758 | 6 | 700 | 36.3427 | 118.1498 | 2020-03-09T10:13:06 | ||||
2020-03-09 | Mainland China | Chongqing | 576 | 6 | 542 | 30.0572 | 107.874 | 2020-03-09T23:13:03 | ||||
2020-03-09 | Mainland China | Hebei | 318 | 6 | 307 | 38.0428 | 114.5149 | 2020-03-07T13:03:05 | ||||
2020-03-09 | Mainland China | Hainan | 168 | 6 | 159 | 19.1959 | 109.7453 | 2020-03-08T04:33:02 | ||||
2020-02-22 | Mainland China | Anhui | 989 | 6 | 597 | 31.8257 | 117.2264 | 2020-02-22T07:43:03 | ||||
2020-02-22 | Mainland China | Chongqing | 573 | 6 | 328 | 30.0572 | 107.874 | 2020-02-22T23:23:05 | ||||
2020-02-22 | Mainland China | Hebei | 309 | 6 | 203 | 38.0428 | 114.5149 | 2020-02-22T12:33:04 | ||||
2020-03-02 | Mainland China | Anhui | 990 | 6 | 917 | 31.8257 | 117.2264 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Mainland China | Shandong | 758 | 6 | 460 | 36.3427 | 118.1498 | 2020-03-02T08:03:12 | ||||
2020-03-02 | Mainland China | Chongqing | 576 | 6 | 469 | 30.0572 | 107.874 | 2020-03-02T23:23:02 | ||||
2020-03-02 | Mainland China | Hebei | 318 | 6 | 296 | 38.0428 | 114.5149 | 2020-03-02T09:43:05 | ||||
2020-02-14 | Mainland China | Anhui | 934 | 6 | 193 | 31.8257 | 117.2264 | 2020-02-14T12:53:02 | ||||
2020-02-17 | Mainland China | Anhui | 973 | 6 | 280 | 31.8257 | 117.2264 | 2020-02-17T09:13:07 | ||||
2020-03-08 | Mainland China | Anhui | 990 | 6 | 984 | 31.8257 | 117.2264 | 2020-03-08T05:13:06 | ||||
2020-03-08 | Mainland China | Shandong | 758 | 6 | 642 | 36.3427 | 118.1498 | 2020-03-08T10:03:11 | ||||
2020-03-08 | Mainland China | Chongqing | 576 | 6 | 527 | 30.0572 | 107.874 | 2020-03-08T23:23:03 | ||||
2020-03-08 | Mainland China | Hebei | 318 | 6 | 307 | 38.0428 | 114.5149 | 2020-03-07T13:03:05 | ||||
2020-03-08 | Mainland China | Hainan | 168 | 6 | 159 | 19.1959 | 109.7453 | 2020-03-08T04:33:02 | ||||
2020-02-19 | Mainland China | Anhui | 986 | 6 | 413 | 31.8257 | 117.2264 | 2020-02-19T14:13:03 | ||||
2020-02-18 | Mainland China | Anhui | 982 | 6 | 361 | 31.8257 | 117.2264 | 2020-02-18T13:43:02 | ||||
2020-02-16 | Mainland China | Anhui | 962 | 6 | 255 | 31.8257 | 117.2264 | 2020-02-16T08:33:02 | ||||
2020-02-21 | Mainland China | Anhui | 988 | 6 | 539 | 31.8257 | 117.2264 | 2020-02-21T10:13:09 | ||||
2020-02-21 | Mainland China | Chongqing | 572 | 6 | 316 | 30.0572 | 107.874 | 2020-02-21T23:13:14 | ||||
2020-02-20 | Mainland China | Anhui | 987 | 6 | 474 | 31.8257 | 117.2264 | 2020-02-20T09:53:02 | ||||
2020-02-20 | Mainland China | Chongqing | 567 | 6 | 299 | 30.0572 | 107.874 | 2020-02-20T23:13:05 | ||||
2020-02-26 | Mainland China | Anhui | 989 | 6 | 744 | 31.8257 | 117.2264 | 2020-02-26T10:13:11 | ||||
2020-02-26 | Mainland China | Shandong | 756 | 6 | 377 | 36.3427 | 118.1498 | 2020-02-26T12:43:02 | ||||
2020-02-26 | Mainland China | Chongqing | 576 | 6 | 384 | 30.0572 | 107.874 | 2020-02-26T23:43:02 | ||||
2020-02-26 | Mainland China | Hebei | 312 | 6 | 261 | 38.0428 | 114.5149 | 2020-02-26T10:33:02 | ||||
2020-02-28 | Mainland China | Anhui | 990 | 6 | 821 | 31.8257 | 117.2264 | 2020-02-28T04:43:02 | ||||
2020-02-28 | Mainland China | Shandong | 756 | 6 | 405 | 36.3427 | 118.1498 | 2020-02-28T09:23:02 | ||||
2020-02-28 | Mainland China | Chongqing | 576 | 6 | 422 | 30.0572 | 107.874 | 2020-02-28T23:23:03 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;