johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
34,865 rows where country_or_region = "China" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Unknown 406
- Anhui 357
- Beijing 357
- Chongqing 357
- Fujian 357
- Gansu 357
- Guangdong 357
- Guangxi 357
- Guizhou 357
- Hainan 357
- Hebei 357
- Heilongjiang 357
- Henan 357
- Hong Kong 357
- Hubei 357
- Hunan 357
- Inner Mongolia 357
- Jiangsu 357
- Jiangxi 357
- Jilin 357
- Liaoning 357
- Macau 357
- Ningxia 357
- Qinghai 357
- Shaanxi 357
- Shandong 357
- Shanghai 357
- Shanxi 357
- Sichuan 357
- Tianjin 357
- …
country_or_region 1
- China · 12,187 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3253945 | 3253945 | 2021-03-02 | China | Anhui | 994 | 6 | 988 | 0 | 31.8257 | 117.2264 | 2021-03-03 05:23:28 | Anhui, China | ||
3253946 | 3253946 | 2021-03-02 | China | Beijing | 1049 | 9 | 1026 | 14 | 40.1824 | 116.4142 | 2021-03-03 05:23:28 | Beijing, China | ||
3253947 | 3253947 | 2021-03-02 | China | Chongqing | 591 | 6 | 585 | 0 | 30.0572 | 107.874 | 2021-03-03 05:23:28 | Chongqing, China | ||
3253948 | 3253948 | 2021-03-02 | China | Fujian | 551 | 1 | 546 | 4 | 26.0789 | 117.9874 | 2021-03-03 05:23:28 | Fujian, China | ||
3253949 | 3253949 | 2021-03-02 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-03 05:23:28 | Gansu, China | ||
3253950 | 3253950 | 2021-03-02 | China | Guangdong | 2218 | 8 | 2162 | 48 | 23.3417 | 113.4244 | 2021-03-03 05:23:28 | Guangdong, China | ||
3253951 | 3253951 | 2021-03-02 | China | Guangxi | 267 | 2 | 265 | 0 | 23.8298 | 108.7881 | 2021-03-03 05:23:28 | Guangxi, China | ||
3253952 | 3253952 | 2021-03-02 | China | Guizhou | 147 | 2 | 145 | 0 | 26.8154 | 106.8748 | 2021-03-03 05:23:28 | Guizhou, China | ||
3253953 | 3253953 | 2021-03-02 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-03 05:23:28 | Hainan, China | ||
3253954 | 3253954 | 2021-03-02 | China | Hebei | 1317 | 7 | 1305 | 5 | 37.8957 | 114.9042 | 2021-03-03 05:23:28 | Hebei, China | ||
3253955 | 3253955 | 2021-03-02 | China | Heilongjiang | 1610 | 13 | 1597 | 0 | 47.862 | 127.7615 | 2021-03-03 05:23:28 | Heilongjiang, China | ||
3253956 | 3253956 | 2021-03-02 | China | Henan | 1305 | 22 | 1281 | 2 | 33.882 | 113.614 | 2021-03-03 05:23:28 | Henan, China | ||
3253957 | 3253957 | 2021-03-02 | China | Hong Kong | 11032 | 200 | 10563 | 269 | 22.3 | 114.2 | 2021-03-03 05:23:28 | Hong Kong, China | ||
3253958 | 3253958 | 2021-03-02 | China | Hubei | 68151 | 4512 | 63639 | 0 | 30.9756 | 112.2707 | 2021-03-03 05:23:28 | Hubei, China | ||
3253959 | 3253959 | 2021-03-02 | China | Hunan | 1036 | 4 | 1027 | 5 | 27.6104 | 111.7088 | 2021-03-03 05:23:28 | Hunan, China | ||
3253960 | 3253960 | 2021-03-02 | China | Inner Mongolia | 367 | 1 | 365 | 1 | 44.0935 | 113.9448 | 2021-03-03 05:23:28 | Inner Mongolia, China | ||
3253961 | 3253961 | 2021-03-02 | China | Jiangsu | 704 | 0 | 700 | 4 | 32.9711 | 119.455 | 2021-03-03 05:23:28 | Jiangsu, China | ||
3253962 | 3253962 | 2021-03-02 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2021-03-03 05:23:28 | Jiangxi, China | ||
3253963 | 3253963 | 2021-03-02 | China | Jilin | 573 | 3 | 567 | 3 | 43.6661 | 126.1923 | 2021-03-03 05:23:28 | Jilin, China | ||
3253964 | 3253964 | 2021-03-02 | China | Liaoning | 406 | 2 | 402 | 2 | 41.2956 | 122.6085 | 2021-03-03 05:23:28 | Liaoning, China | ||
3253965 | 3253965 | 2021-03-02 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-03 05:23:28 | Macau, China | ||
3253966 | 3253966 | 2021-03-02 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2021-03-03 05:23:28 | Ningxia, China | ||
3253967 | 3253967 | 2021-03-02 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-03-03 05:23:28 | Qinghai, China | ||
3253968 | 3253968 | 2021-03-02 | China | Shaanxi | 553 | 3 | 542 | 8 | 35.1917 | 108.8701 | 2021-03-03 05:23:28 | Shaanxi, China | ||
3253969 | 3253969 | 2021-03-02 | China | Shandong | 869 | 7 | 860 | 2 | 36.3427 | 118.1498 | 2021-03-03 05:23:28 | Shandong, China | ||
3253970 | 3253970 | 2021-03-02 | China | Shanghai | 1797 | 7 | 1757 | 33 | 31.202 | 121.4491 | 2021-03-03 05:23:28 | Shanghai, China | ||
3253971 | 3253971 | 2021-03-02 | China | Shanxi | 240 | 0 | 238 | 2 | 37.5777 | 112.2922 | 2021-03-03 05:23:28 | Shanxi, China | ||
3253972 | 3253972 | 2021-03-02 | China | Sichuan | 909 | 3 | 875 | 31 | 30.6171 | 102.7103 | 2021-03-03 05:23:28 | Sichuan, China | ||
3253973 | 3253973 | 2021-03-02 | China | Tianjin | 357 | 3 | 338 | 16 | 39.3054 | 117.323 | 2021-03-03 05:23:28 | Tianjin, China | ||
3253974 | 3253974 | 2021-03-02 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-03-03 05:23:28 | Tibet, China | ||
3253975 | 3253975 | 2021-03-02 | China | Unknown | 8048 | 0 | 3 | 0 | 2021-03-03 05:23:28 | Unknown, China | ||||
3253976 | 3253976 | 2021-03-02 | China | Xinjiang | 980 | 3 | 977 | 0 | 41.1129 | 85.2401 | 2021-03-03 05:23:28 | Xinjiang, China | ||
3253977 | 3253977 | 2021-03-02 | China | Yunnan | 234 | 2 | 229 | 3 | 24.974 | 101.487 | 2021-03-03 05:23:28 | Yunnan, China | ||
3253978 | 3253978 | 2021-03-02 | China | Zhejiang | 1321 | 1 | 1314 | 6 | 29.1832 | 120.0934 | 2021-03-03 05:23:28 | Zhejiang, China | ||
998237 | 998237 | 2021-03-01 | China | Anhui | 994 | 6 | 988 | 0 | 31.8257 | 117.2264 | 2021-03-02 05:23:30 | Anhui, China | ||
998238 | 998238 | 2021-03-01 | China | Beijing | 1049 | 9 | 1024 | 16 | 40.1824 | 116.4142 | 2021-03-02 05:23:30 | Beijing, China | ||
998239 | 998239 | 2021-03-01 | China | Chongqing | 591 | 6 | 585 | 0 | 30.0572 | 107.874 | 2021-03-02 05:23:30 | Chongqing, China | ||
998240 | 998240 | 2021-03-01 | China | Fujian | 551 | 1 | 546 | 4 | 26.0789 | 117.9874 | 2021-03-02 05:23:30 | Fujian, China | ||
998241 | 998241 | 2021-03-01 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-02 05:23:30 | Gansu, China | ||
998242 | 998242 | 2021-03-01 | China | Guangdong | 2215 | 8 | 2159 | 48 | 23.3417 | 113.4244 | 2021-03-02 05:23:30 | Guangdong, China | ||
998243 | 998243 | 2021-03-01 | China | Guangxi | 267 | 2 | 265 | 0 | 23.8298 | 108.7881 | 2021-03-02 05:23:30 | Guangxi, China | ||
998244 | 998244 | 2021-03-01 | China | Guizhou | 147 | 2 | 145 | 0 | 26.8154 | 106.8748 | 2021-03-02 05:23:30 | Guizhou, China | ||
998245 | 998245 | 2021-03-01 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-02 05:23:30 | Hainan, China | ||
998246 | 998246 | 2021-03-01 | China | Hebei | 1317 | 7 | 1301 | 9 | 37.8957 | 114.9042 | 2021-03-02 05:23:30 | Hebei, China | ||
998247 | 998247 | 2021-03-01 | China | Heilongjiang | 1610 | 13 | 1597 | 0 | 47.862 | 127.7615 | 2021-03-02 05:23:30 | Heilongjiang, China | ||
998248 | 998248 | 2021-03-01 | China | Henan | 1305 | 22 | 1281 | 2 | 33.882 | 113.614 | 2021-03-02 05:23:30 | Henan, China | ||
998249 | 998249 | 2021-03-01 | China | Hong Kong | 11019 | 200 | 10547 | 272 | 22.3 | 114.2 | 2021-03-02 05:23:30 | Hong Kong, China | ||
998250 | 998250 | 2021-03-01 | China | Hubei | 68151 | 4512 | 63639 | 0 | 30.9756 | 112.2707 | 2021-03-02 05:23:30 | Hubei, China | ||
998251 | 998251 | 2021-03-01 | China | Hunan | 1036 | 4 | 1027 | 5 | 27.6104 | 111.7088 | 2021-03-02 05:23:30 | Hunan, China | ||
998252 | 998252 | 2021-03-01 | China | Inner Mongolia | 367 | 1 | 365 | 1 | 44.0935 | 113.9448 | 2021-03-02 05:23:30 | Inner Mongolia, China | ||
998253 | 998253 | 2021-03-01 | China | Jiangsu | 704 | 0 | 699 | 5 | 32.9711 | 119.455 | 2021-03-02 05:23:30 | Jiangsu, China | ||
998254 | 998254 | 2021-03-01 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2021-03-02 05:23:30 | Jiangxi, China | ||
998255 | 998255 | 2021-03-01 | China | Jilin | 573 | 3 | 564 | 6 | 43.6661 | 126.1923 | 2021-03-02 05:23:30 | Jilin, China | ||
998256 | 998256 | 2021-03-01 | China | Liaoning | 406 | 2 | 402 | 2 | 41.2956 | 122.6085 | 2021-03-02 05:23:30 | Liaoning, China | ||
998257 | 998257 | 2021-03-01 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-02 05:23:30 | Macau, China | ||
998258 | 998258 | 2021-03-01 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2021-03-02 05:23:30 | Ningxia, China | ||
998259 | 998259 | 2021-03-01 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-03-02 05:23:30 | Qinghai, China | ||
998260 | 998260 | 2021-03-01 | China | Shaanxi | 552 | 3 | 541 | 8 | 35.1917 | 108.8701 | 2021-03-02 05:23:30 | Shaanxi, China | ||
998261 | 998261 | 2021-03-01 | China | Shandong | 869 | 7 | 860 | 2 | 36.3427 | 118.1498 | 2021-03-02 05:23:30 | Shandong, China | ||
998262 | 998262 | 2021-03-01 | China | Shanghai | 1797 | 7 | 1749 | 41 | 31.202 | 121.4491 | 2021-03-02 05:23:30 | Shanghai, China | ||
998263 | 998263 | 2021-03-01 | China | Shanxi | 240 | 0 | 238 | 2 | 37.5777 | 112.2922 | 2021-03-02 05:23:30 | Shanxi, China | ||
998264 | 998264 | 2021-03-01 | China | Sichuan | 904 | 3 | 872 | 29 | 30.6171 | 102.7103 | 2021-03-02 05:23:30 | Sichuan, China | ||
998265 | 998265 | 2021-03-01 | China | Tianjin | 357 | 3 | 338 | 16 | 39.3054 | 117.323 | 2021-03-02 05:23:30 | Tianjin, China | ||
998266 | 998266 | 2021-03-01 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-03-02 05:23:30 | Tibet, China | ||
998267 | 998267 | 2021-03-01 | China | Unknown | 8044 | 0 | 4 | 0 | 2021-03-02 05:23:30 | Unknown, China | ||||
998268 | 998268 | 2021-03-01 | China | Xinjiang | 980 | 3 | 977 | 0 | 41.1129 | 85.2401 | 2021-03-02 05:23:30 | Xinjiang, China | ||
998269 | 998269 | 2021-03-01 | China | Yunnan | 233 | 2 | 229 | 2 | 24.974 | 101.487 | 2021-03-02 05:23:30 | Yunnan, China | ||
998270 | 998270 | 2021-03-01 | China | Zhejiang | 1321 | 1 | 1314 | 6 | 29.1832 | 120.0934 | 2021-03-02 05:23:30 | Zhejiang, China | ||
2367295 | 2367295 | 2021-02-28 | China | Anhui | 994 | 6 | 988 | 0 | 31.8257 | 117.2264 | 2021-03-01 05:23:01 | Anhui, China | ||
2367296 | 2367296 | 2021-02-28 | China | Beijing | 1049 | 9 | 1022 | 18 | 40.1824 | 116.4142 | 2021-03-01 05:23:01 | Beijing, China | ||
2367297 | 2367297 | 2021-02-28 | China | Chongqing | 591 | 6 | 585 | 0 | 30.0572 | 107.874 | 2021-03-01 05:23:01 | Chongqing, China | ||
2367298 | 2367298 | 2021-02-28 | China | Fujian | 551 | 1 | 546 | 4 | 26.0789 | 117.9874 | 2021-03-01 05:23:01 | Fujian, China | ||
2367299 | 2367299 | 2021-02-28 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-01 05:23:01 | Gansu, China | ||
2367300 | 2367300 | 2021-02-28 | China | Guangdong | 2212 | 8 | 2158 | 46 | 23.3417 | 113.4244 | 2021-03-01 05:23:01 | Guangdong, China | ||
2367301 | 2367301 | 2021-02-28 | China | Guangxi | 267 | 2 | 265 | 0 | 23.8298 | 108.7881 | 2021-03-01 05:23:01 | Guangxi, China | ||
2367302 | 2367302 | 2021-02-28 | China | Guizhou | 147 | 2 | 145 | 0 | 26.8154 | 106.8748 | 2021-03-01 05:23:01 | Guizhou, China | ||
2367303 | 2367303 | 2021-02-28 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-01 05:23:01 | Hainan, China | ||
2367304 | 2367304 | 2021-02-28 | China | Hebei | 1317 | 7 | 1296 | 14 | 37.8957 | 114.9042 | 2021-03-01 05:23:01 | Hebei, China | ||
2367305 | 2367305 | 2021-02-28 | China | Heilongjiang | 1610 | 13 | 1597 | 0 | 47.862 | 127.7615 | 2021-03-01 05:23:01 | Heilongjiang, China | ||
2367306 | 2367306 | 2021-02-28 | China | Henan | 1304 | 22 | 1281 | 1 | 33.882 | 113.614 | 2021-03-01 05:23:01 | Henan, China | ||
2367307 | 2367307 | 2021-02-28 | China | Hong Kong | 11005 | 199 | 10536 | 270 | 22.3 | 114.2 | 2021-03-01 05:23:01 | Hong Kong, China | ||
2367308 | 2367308 | 2021-02-28 | China | Hubei | 68151 | 4512 | 63639 | 0 | 30.9756 | 112.2707 | 2021-03-01 05:23:01 | Hubei, China | ||
2367309 | 2367309 | 2021-02-28 | China | Hunan | 1036 | 4 | 1026 | 6 | 27.6104 | 111.7088 | 2021-03-01 05:23:01 | Hunan, China | ||
2367310 | 2367310 | 2021-02-28 | China | Inner Mongolia | 367 | 1 | 365 | 1 | 44.0935 | 113.9448 | 2021-03-01 05:23:01 | Inner Mongolia, China | ||
2367311 | 2367311 | 2021-02-28 | China | Jiangsu | 704 | 0 | 698 | 6 | 32.9711 | 119.455 | 2021-03-01 05:23:01 | Jiangsu, China | ||
2367312 | 2367312 | 2021-02-28 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2021-03-01 05:23:01 | Jiangxi, China | ||
2367313 | 2367313 | 2021-02-28 | China | Jilin | 573 | 3 | 561 | 9 | 43.6661 | 126.1923 | 2021-03-01 05:23:01 | Jilin, China | ||
2367314 | 2367314 | 2021-02-28 | China | Liaoning | 406 | 2 | 402 | 2 | 41.2956 | 122.6085 | 2021-03-01 05:23:01 | Liaoning, China | ||
2367315 | 2367315 | 2021-02-28 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-01 05:23:01 | Macau, China | ||
2367316 | 2367316 | 2021-02-28 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2021-03-01 05:23:01 | Ningxia, China | ||
2367317 | 2367317 | 2021-02-28 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-03-01 05:23:01 | Qinghai, China | ||
2367318 | 2367318 | 2021-02-28 | China | Shaanxi | 551 | 3 | 540 | 8 | 35.1917 | 108.8701 | 2021-03-01 05:23:01 | Shaanxi, China | ||
2367319 | 2367319 | 2021-02-28 | China | Shandong | 869 | 7 | 860 | 2 | 36.3427 | 118.1498 | 2021-03-01 05:23:01 | Shandong, China | ||
2367320 | 2367320 | 2021-02-28 | China | Shanghai | 1796 | 7 | 1744 | 45 | 31.202 | 121.4491 | 2021-03-01 05:23:01 | Shanghai, China | ||
2367321 | 2367321 | 2021-02-28 | China | Shanxi | 240 | 0 | 238 | 2 | 37.5777 | 112.2922 | 2021-03-01 05:23:01 | Shanxi, China | ||
2367322 | 2367322 | 2021-02-28 | China | Sichuan | 900 | 3 | 872 | 25 | 30.6171 | 102.7103 | 2021-03-01 05:23:01 | Sichuan, China | ||
2367323 | 2367323 | 2021-02-28 | China | Tianjin | 356 | 3 | 337 | 16 | 39.3054 | 117.323 | 2021-03-01 05:23:01 | Tianjin, China | ||
2367324 | 2367324 | 2021-02-28 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-03-01 05:23:01 | Tibet, China | ||
2367325 | 2367325 | 2021-02-28 | China | Unknown | 8032 | 0 | 3 | 0 | 2021-03-01 05:23:01 | Unknown, China | ||||
2367326 | 2367326 | 2021-02-28 | China | Xinjiang | 980 | 3 | 977 | 0 | 41.1129 | 85.2401 | 2021-03-01 05:23:01 | Xinjiang, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);