daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,517 rows where country_or_region = "Mainland China" sorted by admin2
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-03-03 | Mainland China | Guangxi | 252 | 2 | 202 | 23.8298 | 108.7881 | 2020-03-03T00:23:14 | ||||
2020-03-03 | Mainland China | Shaanxi | 245 | 1 | 216 | 35.1917 | 108.8701 | 2020-03-02T08:03:12 | ||||
2020-03-03 | Mainland China | Yunnan | 174 | 2 | 169 | 24.974 | 101.487 | 2020-03-03T03:43:02 | ||||
2020-03-03 | Mainland China | Hainan | 168 | 5 | 155 | 19.1959 | 109.7453 | 2020-03-03T23:43:02 | ||||
2020-03-03 | Mainland China | Guizhou | 146 | 2 | 114 | 26.8154 | 106.8748 | 2020-03-02T01:13:06 | ||||
2020-03-03 | Mainland China | Tianjin | 136 | 3 | 124 | 39.3054 | 117.323 | 2020-03-03T11:43:02 | ||||
2020-03-03 | Mainland China | Shanxi | 133 | 0 | 124 | 37.5777 | 112.2922 | 2020-03-03T23:13:05 | ||||
2020-03-03 | Mainland China | Liaoning | 125 | 1 | 106 | 41.2956 | 122.6085 | 2020-03-03T14:33:03 | ||||
2020-03-03 | Mainland China | Jilin | 93 | 1 | 83 | 43.6661 | 126.1923 | 2020-03-02T15:03:23 | ||||
2020-03-03 | Mainland China | Gansu | 91 | 2 | 86 | 36.0611 | 103.8343 | 2020-03-03T13:43:03 | ||||
2020-03-03 | Mainland China | Xinjiang | 76 | 3 | 68 | 41.1129 | 85.2401 | 2020-03-03T07:33:03 | ||||
2020-03-03 | Mainland China | Inner Mongolia | 75 | 1 | 59 | 44.0935 | 113.9448 | 2020-03-03T09:23:02 | ||||
2020-03-03 | Mainland China | Ningxia | 74 | 0 | 69 | 37.2692 | 106.1655 | 2020-03-02T01:33:02 | ||||
2020-03-03 | Mainland China | Qinghai | 18 | 0 | 18 | 35.7452 | 95.9956 | 2020-02-21T04:43:02 | ||||
2020-03-03 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
2020-01-26 | Mainland China | Hubei | 1058 | 52 | 42 | 30.9756 | 112.2707 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Guangdong | 111 | 0 | 2 | 23.3417 | 113.4244 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Zhejiang | 104 | 0 | 1 | 29.1832 | 120.0934 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Henan | 83 | 1 | 0 | 33.882 | 113.614 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Chongqing | 75 | 0 | 0 | 30.0572 | 107.874 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Hunan | 69 | 0 | 0 | 27.6104 | 111.7088 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Beijing | 68 | 0 | 2 | 40.1824 | 116.4142 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Anhui | 60 | 0 | 0 | 31.8257 | 117.2264 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Shandong | 46 | 0 | 0 | 36.3427 | 118.1498 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Sichuan | 44 | 0 | 0 | 30.6171 | 102.7103 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Shanghai | 40 | 1 | 1 | 31.202 | 121.4491 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Guangxi | 36 | 0 | 0 | 23.8298 | 108.7881 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Jiangxi | 36 | 0 | 0 | 27.614 | 115.7221 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Fujian | 35 | 0 | 0 | 26.0789 | 117.9874 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Jiangsu | 33 | 0 | 1 | 32.9711 | 119.455 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Hainan | 22 | 0 | 0 | 19.1959 | 109.7453 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Shaanxi | 22 | 0 | 0 | 35.1917 | 108.8701 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Liaoning | 21 | 0 | 0 | 41.2956 | 122.6085 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Yunnan | 16 | 0 | 0 | 24.974 | 101.487 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Heilongjiang | 15 | 1 | 0 | 47.862 | 127.7615 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Tianjin | 14 | 0 | 0 | 39.3054 | 117.323 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Hebei | 13 | 1 | 0 | 38.0428 | 114.5149 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Shanxi | 9 | 0 | 0 | 37.5777 | 112.2922 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Inner Mongolia | 7 | 0 | 0 | 44.0935 | 113.9448 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Gansu | 7 | 0 | 0 | 36.0611 | 103.8343 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Guizhou | 5 | 0 | 0 | 26.8154 | 106.8748 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Ningxia | 4 | 0 | 0 | 37.2692 | 106.1655 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Jilin | 4 | 0 | 0 | 43.6661 | 126.1923 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Xinjiang | 4 | 0 | 0 | 41.1129 | 85.2401 | 1/26/20 16:00 | ||||
2020-01-26 | Mainland China | Qinghai | 1 | 0 | 0 | 35.7452 | 95.9956 | 1/26/20 16:00 | ||||
2020-02-25 | Mainland China | Hubei | 64786 | 2563 | 18971 | 30.9756 | 112.2707 | 2020-02-25T15:23:04 | ||||
2020-02-25 | Mainland China | Guangdong | 1347 | 7 | 822 | 23.3417 | 113.4244 | 2020-02-25T08:53:02 | ||||
2020-02-25 | Mainland China | Henan | 1271 | 19 | 1002 | 33.882 | 113.614 | 2020-02-25T12:43:02 | ||||
2020-02-25 | Mainland China | Zhejiang | 1205 | 1 | 808 | 29.1832 | 120.0934 | 2020-02-25T09:13:05 | ||||
2020-02-25 | Mainland China | Hunan | 1016 | 4 | 768 | 27.6104 | 111.7088 | 2020-02-25T15:03:05 | ||||
2020-02-25 | Mainland China | Anhui | 989 | 6 | 712 | 31.8257 | 117.2264 | 2020-02-25T06:33:02 | ||||
2020-02-25 | Mainland China | Jiangxi | 934 | 1 | 683 | 27.614 | 115.7221 | 2020-02-25T15:03:05 | ||||
2020-02-25 | Mainland China | Shandong | 756 | 6 | 355 | 36.3427 | 118.1498 | 2020-02-25T12:53:02 | ||||
2020-02-25 | Mainland China | Jiangsu | 631 | 0 | 458 | 32.9711 | 119.455 | 2020-02-25T00: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 | Sichuan | 529 | 3 | 289 | 30.6171 | 102.7103 | 2020-02-25T15:03:05 | ||||
2020-02-25 | Mainland China | Heilongjiang | 480 | 12 | 243 | 47.862 | 127.7615 | 2020-02-25T15:23:04 | ||||
2020-02-25 | Mainland China | Beijing | 400 | 4 | 215 | 40.1824 | 116.4142 | 2020-02-25T01:33:02 | ||||
2020-02-25 | Mainland China | Shanghai | 336 | 3 | 268 | 31.202 | 121.4491 | 2020-02-25T06:33:02 | ||||
2020-02-25 | Mainland China | Hebei | 311 | 6 | 248 | 38.0428 | 114.5149 | 2020-02-25T12:43:02 | ||||
2020-02-25 | Mainland China | Fujian | 294 | 1 | 199 | 26.0789 | 117.9874 | 2020-02-25T10:03:07 | ||||
2020-02-25 | Mainland China | Guangxi | 252 | 2 | 134 | 23.8298 | 108.7881 | 2020-02-25T10:03:07 | ||||
2020-02-25 | Mainland China | Shaanxi | 245 | 1 | 186 | 35.1917 | 108.8701 | 2020-02-25T15:23:04 | ||||
2020-02-25 | Mainland China | Yunnan | 174 | 2 | 129 | 24.974 | 101.487 | 2020-02-25T04:53:02 | ||||
2020-02-25 | Mainland China | Hainan | 168 | 5 | 124 | 19.1959 | 109.7453 | 2020-02-25T12:53:02 | ||||
2020-02-25 | Mainland China | Guizhou | 146 | 2 | 104 | 26.8154 | 106.8748 | 2020-02-25T08:03:07 | ||||
2020-02-25 | Mainland China | Tianjin | 135 | 3 | 91 | 39.3054 | 117.323 | 2020-02-25T15:23:04 | ||||
2020-02-25 | Mainland China | Shanxi | 133 | 0 | 98 | 37.5777 | 112.2922 | 2020-02-25T23:13:03 | ||||
2020-02-25 | Mainland China | Liaoning | 121 | 1 | 83 | 41.2956 | 122.6085 | 2020-02-25T00:23:03 | ||||
2020-02-25 | Mainland China | Jilin | 93 | 1 | 63 | 43.6661 | 126.1923 | 2020-02-25T15:23:04 | ||||
2020-02-25 | Mainland China | Gansu | 91 | 2 | 80 | 36.0611 | 103.8343 | 2020-02-24T15:13:07 | ||||
2020-02-25 | Mainland China | Xinjiang | 76 | 2 | 30 | 41.1129 | 85.2401 | 2020-02-24T15:03:05 | ||||
2020-02-25 | Mainland China | Inner Mongolia | 75 | 0 | 35 | 44.0935 | 113.9448 | 2020-02-25T23:53:02 | ||||
2020-02-25 | Mainland China | Ningxia | 71 | 0 | 61 | 37.2692 | 106.1655 | 2020-02-25T03:53:02 | ||||
2020-02-25 | Mainland China | Qinghai | 18 | 0 | 18 | 35.7452 | 95.9956 | 2020-02-21T04:43:02 | ||||
2020-02-25 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
2020-03-01 | Mainland China | Hubei | 66907 | 2761 | 31536 | 30.9756 | 112.2707 | 2020-03-01T10:13:19 | ||||
2020-03-01 | Mainland China | Guangdong | 1349 | 7 | 1016 | 23.3417 | 113.4244 | 2020-03-01T14:13:18 | ||||
2020-03-01 | Mainland China | Henan | 1272 | 22 | 1198 | 33.882 | 113.614 | 2020-03-01T14:13:18 | ||||
2020-03-01 | Mainland China | Zhejiang | 1205 | 1 | 1046 | 29.1832 | 120.0934 | 2020-03-01T10:13:33 | ||||
2020-03-01 | Mainland China | Hunan | 1018 | 4 | 866 | 27.6104 | 111.7088 | 2020-03-01T10:03:03 | ||||
2020-03-01 | Mainland China | Anhui | 990 | 6 | 873 | 31.8257 | 117.2264 | 2020-03-01T10:03:03 | ||||
2020-03-01 | Mainland China | Jiangxi | 935 | 1 | 831 | 27.614 | 115.7221 | 2020-03-01T01:13:10 | ||||
2020-03-01 | Mainland China | Shandong | 758 | 6 | 443 | 36.3427 | 118.1498 | 2020-03-01T11:33:03 | ||||
2020-03-01 | Mainland China | Jiangsu | 631 | 0 | 536 | 32.9711 | 119.455 | 2020-03-01T10:03:03 | ||||
2020-03-01 | Mainland China | Chongqing | 576 | 6 | 450 | 30.0572 | 107.874 | 2020-03-01T23:13:08 | ||||
2020-03-01 | Mainland China | Sichuan | 538 | 3 | 365 | 30.6171 | 102.7103 | 2020-03-01T11:43:02 | ||||
2020-03-01 | Mainland China | Heilongjiang | 480 | 13 | 342 | 47.862 | 127.7615 | 2020-03-01T11:33:03 | ||||
2020-03-01 | Mainland China | Beijing | 413 | 8 | 276 | 40.1824 | 116.4142 | 2020-03-01T02:53:03 | ||||
2020-03-01 | Mainland China | Shanghai | 337 | 3 | 290 | 31.202 | 121.4491 | 2020-03-01T07:13:07 | ||||
2020-03-01 | Mainland China | Hebei | 318 | 6 | 294 | 38.0428 | 114.5149 | 2020-03-01T14:13:18 | ||||
2020-03-01 | Mainland China | Fujian | 296 | 1 | 247 | 26.0789 | 117.9874 | 2020-03-01T09:43:03 | ||||
2020-03-01 | Mainland China | Guangxi | 252 | 2 | 181 | 23.8298 | 108.7881 | 2020-03-01T09:43:03 | ||||
2020-03-01 | Mainland China | Shaanxi | 245 | 1 | 208 | 35.1917 | 108.8701 | 2020-03-01T09:43:03 | ||||
2020-03-01 | Mainland China | Yunnan | 174 | 2 | 163 | 24.974 | 101.487 | 2020-03-01T07:13:07 | ||||
2020-03-01 | Mainland China | Hainan | 168 | 5 | 149 | 19.1959 | 109.7453 | 2020-03-01T10:13:38 | ||||
2020-03-01 | Mainland China | Guizhou | 146 | 2 | 112 | 26.8154 | 106.8748 | 2020-02-27T00:43:02 | ||||
2020-03-01 | Mainland China | Tianjin | 136 | 3 | 111 | 39.3054 | 117.323 | 2020-03-01T12:43:02 | ||||
2020-03-01 | Mainland China | Shanxi | 133 | 0 | 116 | 37.5777 | 112.2922 | 2020-03-01T23:13:08 | ||||
2020-03-01 | Mainland China | Liaoning | 122 | 1 | 103 | 41.2956 | 122.6085 | 2020-03-01T12:23:06 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;