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 937
- Anhui 888
- Beijing 888
- Chongqing 888
- Fujian 888
- Gansu 888
- Guangdong 888
- Guangxi 888
- Guizhou 888
- Hainan 888
- Hebei 888
- Heilongjiang 888
- Henan 888
- Hong Kong 888
- Hubei 888
- Hunan 888
- Inner Mongolia 888
- Jiangsu 888
- Jiangxi 888
- Jilin 888
- Liaoning 888
- Macau 888
- Ningxia 888
- Qinghai 888
- Shaanxi 888
- Shandong 888
- Shanghai 888
- Shanxi 888
- Sichuan 888
- Tianjin 888
- …
country_or_region 1
- China · 30,241 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2493816 | 2493816 | 2022-08-15 | China | Anhui | 1504 | 6 | 0 | 31.8257 | 117.2264 | 2022-08-16 04:20:58 | Anhui, China | |||
2493817 | 2493817 | 2022-08-15 | China | Beijing | 3872 | 9 | 0 | 40.1824 | 116.4142 | 2022-08-16 04:20:58 | Beijing, China | |||
2493818 | 2493818 | 2022-08-15 | China | Chongqing | 818 | 6 | 0 | 30.0572 | 107.874 | 2022-08-16 04:20:58 | Chongqing, China | |||
2493819 | 2493819 | 2022-08-15 | China | Fujian | 3888 | 1 | 0 | 26.0789 | 117.9874 | 2022-08-16 04:20:58 | Fujian, China | |||
2493820 | 2493820 | 2022-08-15 | China | Gansu | 1335 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-16 04:20:58 | Gansu, China | |||
2493821 | 2493821 | 2022-08-15 | China | Guangdong | 8614 | 8 | 0 | 23.3417 | 113.4244 | 2022-08-16 04:20:58 | Guangdong, China | |||
2493822 | 2493822 | 2022-08-15 | China | Guangxi | 2249 | 2 | 0 | 23.8298 | 108.7881 | 2022-08-16 04:20:58 | Guangxi, China | |||
2493823 | 2493823 | 2022-08-15 | China | Guizhou | 190 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-16 04:20:58 | Guizhou, China | |||
2493824 | 2493824 | 2022-08-15 | China | Hainan | 5142 | 6 | 0 | 19.1959 | 109.7453 | 2022-08-16 04:20:58 | Hainan, China | |||
2493825 | 2493825 | 2022-08-15 | China | Hebei | 2009 | 7 | 0 | 37.8957 | 114.9042 | 2022-08-16 04:20:58 | Hebei, China | |||
2493826 | 2493826 | 2022-08-15 | China | Heilongjiang | 3013 | 13 | 0 | 47.862 | 127.7615 | 2022-08-16 04:20:58 | Heilongjiang, China | |||
2493827 | 2493827 | 2022-08-15 | China | Henan | 3235 | 22 | 0 | 33.882 | 113.614 | 2022-08-16 04:20:58 | Henan, China | |||
2493828 | 2493828 | 2022-08-15 | China | Hong Kong | 1421918 | 9569 | 0 | 22.3 | 114.2 | 2022-08-16 04:20:58 | Hong Kong, China | |||
2493829 | 2493829 | 2022-08-15 | China | Hubei | 68411 | 4512 | 0 | 30.9756 | 112.2707 | 2022-08-16 04:20:58 | Hubei, China | |||
2493830 | 2493830 | 2022-08-15 | China | Hunan | 1416 | 4 | 0 | 27.6104 | 111.7088 | 2022-08-16 04:20:58 | Hunan, China | |||
2493831 | 2493831 | 2022-08-15 | China | Inner Mongolia | 2326 | 1 | 0 | 44.0935 | 113.9448 | 2022-08-16 04:20:58 | Inner Mongolia, China | |||
2493832 | 2493832 | 2022-08-15 | China | Jiangsu | 2334 | 0 | 0 | 32.9711 | 119.455 | 2022-08-16 04:20:58 | Jiangsu, China | |||
2493833 | 2493833 | 2022-08-15 | China | Jiangxi | 1463 | 1 | 0 | 27.614 | 115.7221 | 2022-08-16 04:20:58 | Jiangxi, China | |||
2493834 | 2493834 | 2022-08-15 | China | Jilin | 40304 | 5 | 0 | 43.6661 | 126.1923 | 2022-08-16 04:20:58 | Jilin, China | |||
2493835 | 2493835 | 2022-08-15 | China | Liaoning | 1753 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-16 04:20:58 | Liaoning, China | |||
2493836 | 2493836 | 2022-08-15 | China | Macau | 792 | 6 | 0 | 22.1667 | 113.55 | 2022-08-16 04:20:58 | Macau, China | |||
2493837 | 2493837 | 2022-08-15 | China | Ningxia | 122 | 0 | 0 | 37.2692 | 106.1655 | 2022-08-16 04:20:58 | Ningxia, China | |||
2493838 | 2493838 | 2022-08-15 | China | Qinghai | 156 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-16 04:20:58 | Qinghai, China | |||
2493839 | 2493839 | 2022-08-15 | China | Shaanxi | 3406 | 3 | 0 | 35.1917 | 108.8701 | 2022-08-16 04:20:58 | Shaanxi, China | |||
2493840 | 2493840 | 2022-08-15 | China | Shandong | 2902 | 7 | 0 | 36.3427 | 118.1498 | 2022-08-16 04:20:58 | Shandong, China | |||
2493841 | 2493841 | 2022-08-15 | China | Shanghai | 63731 | 595 | 0 | 31.202 | 121.4491 | 2022-08-16 04:20:58 | Shanghai, China | |||
2493842 | 2493842 | 2022-08-15 | China | Shanxi | 429 | 0 | 0 | 37.5777 | 112.2922 | 2022-08-16 04:20:58 | Shanxi, China | |||
2493843 | 2493843 | 2022-08-15 | China | Sichuan | 2791 | 3 | 0 | 30.6171 | 102.7103 | 2022-08-16 04:20:58 | Sichuan, China | |||
2493844 | 2493844 | 2022-08-15 | China | Tianjin | 2096 | 3 | 0 | 39.3054 | 117.323 | 2022-08-16 04:20:58 | Tianjin, China | |||
2493845 | 2493845 | 2022-08-15 | China | Tibet | 179 | 0 | 0 | 31.6927 | 88.0924 | 2022-08-16 04:20:58 | Tibet, China | |||
2493846 | 2493846 | 2022-08-15 | China | Unknown | 686362 | 0 | 0 | 2022-08-16 04:20:58 | Unknown, China | |||||
2493847 | 2493847 | 2022-08-15 | China | Xinjiang | 1027 | 3 | 0 | 41.1129 | 85.2401 | 2022-08-16 04:20:58 | Xinjiang, China | |||
2493848 | 2493848 | 2022-08-15 | China | Yunnan | 2236 | 2 | 0 | 24.974 | 101.487 | 2022-08-16 04:20:58 | Yunnan, China | |||
2493849 | 2493849 | 2022-08-15 | China | Zhejiang | 3310 | 1 | 0 | 29.1832 | 120.0934 | 2022-08-16 04:20:58 | Zhejiang, China | |||
3647366 | 3647366 | 2022-08-14 | China | Anhui | 1504 | 6 | 0 | 31.8257 | 117.2264 | 2022-08-15 04:20:59 | Anhui, China | |||
3647367 | 3647367 | 2022-08-14 | China | Beijing | 3856 | 9 | 0 | 40.1824 | 116.4142 | 2022-08-15 04:20:59 | Beijing, China | |||
3647368 | 3647368 | 2022-08-14 | China | Chongqing | 818 | 6 | 0 | 30.0572 | 107.874 | 2022-08-15 04:20:59 | Chongqing, China | |||
3647369 | 3647369 | 2022-08-14 | China | Fujian | 3866 | 1 | 0 | 26.0789 | 117.9874 | 2022-08-15 04:20:59 | Fujian, China | |||
3647370 | 3647370 | 2022-08-14 | China | Gansu | 1335 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-15 04:20:59 | Gansu, China | |||
3647371 | 3647371 | 2022-08-14 | China | Guangdong | 8602 | 8 | 0 | 23.3417 | 113.4244 | 2022-08-15 04:20:59 | Guangdong, China | |||
3647372 | 3647372 | 2022-08-14 | China | Guangxi | 2248 | 2 | 0 | 23.8298 | 108.7881 | 2022-08-15 04:20:59 | Guangxi, China | |||
3647373 | 3647373 | 2022-08-14 | China | Guizhou | 189 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-15 04:20:59 | Guizhou, China | |||
3647374 | 3647374 | 2022-08-14 | China | Hainan | 4135 | 6 | 0 | 19.1959 | 109.7453 | 2022-08-15 04:20:59 | Hainan, China | |||
3647375 | 3647375 | 2022-08-14 | China | Hebei | 2009 | 7 | 0 | 37.8957 | 114.9042 | 2022-08-15 04:20:59 | Hebei, China | |||
3647376 | 3647376 | 2022-08-14 | China | Heilongjiang | 3012 | 13 | 0 | 47.862 | 127.7615 | 2022-08-15 04:20:59 | Heilongjiang, China | |||
3647377 | 3647377 | 2022-08-14 | China | Henan | 3232 | 22 | 0 | 33.882 | 113.614 | 2022-08-15 04:20:59 | Henan, China | |||
3647378 | 3647378 | 2022-08-14 | China | Hong Kong | 1417022 | 9565 | 0 | 22.3 | 114.2 | 2022-08-15 04:20:59 | Hong Kong, China | |||
3647379 | 3647379 | 2022-08-14 | China | Hubei | 68411 | 4512 | 0 | 30.9756 | 112.2707 | 2022-08-15 04:20:59 | Hubei, China | |||
3647380 | 3647380 | 2022-08-14 | China | Hunan | 1416 | 4 | 0 | 27.6104 | 111.7088 | 2022-08-15 04:20:59 | Hunan, China | |||
3647381 | 3647381 | 2022-08-14 | China | Inner Mongolia | 2324 | 1 | 0 | 44.0935 | 113.9448 | 2022-08-15 04:20:59 | Inner Mongolia, China | |||
3647382 | 3647382 | 2022-08-14 | China | Jiangsu | 2333 | 0 | 0 | 32.9711 | 119.455 | 2022-08-15 04:20:59 | Jiangsu, China | |||
3647383 | 3647383 | 2022-08-14 | China | Jiangxi | 1462 | 1 | 0 | 27.614 | 115.7221 | 2022-08-15 04:20:59 | Jiangxi, China | |||
3647384 | 3647384 | 2022-08-14 | China | Jilin | 40304 | 5 | 0 | 43.6661 | 126.1923 | 2022-08-15 04:20:59 | Jilin, China | |||
3647385 | 3647385 | 2022-08-14 | China | Liaoning | 1752 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-15 04:20:59 | Liaoning, China | |||
3647386 | 3647386 | 2022-08-14 | China | Macau | 791 | 6 | 0 | 22.1667 | 113.55 | 2022-08-15 04:20:59 | Macau, China | |||
3647387 | 3647387 | 2022-08-14 | China | Ningxia | 122 | 0 | 0 | 37.2692 | 106.1655 | 2022-08-15 04:20:59 | Ningxia, China | |||
3647388 | 3647388 | 2022-08-14 | China | Qinghai | 154 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-15 04:20:59 | Qinghai, China | |||
3647389 | 3647389 | 2022-08-14 | China | Shaanxi | 3402 | 3 | 0 | 35.1917 | 108.8701 | 2022-08-15 04:20:59 | Shaanxi, China | |||
3647390 | 3647390 | 2022-08-14 | China | Shandong | 2895 | 7 | 0 | 36.3427 | 118.1498 | 2022-08-15 04:20:59 | Shandong, China | |||
3647391 | 3647391 | 2022-08-14 | China | Shanghai | 63721 | 595 | 0 | 31.202 | 121.4491 | 2022-08-15 04:20:59 | Shanghai, China | |||
3647392 | 3647392 | 2022-08-14 | China | Shanxi | 429 | 0 | 0 | 37.5777 | 112.2922 | 2022-08-15 04:20:59 | Shanxi, China | |||
3647393 | 3647393 | 2022-08-14 | China | Sichuan | 2769 | 3 | 0 | 30.6171 | 102.7103 | 2022-08-15 04:20:59 | Sichuan, China | |||
3647394 | 3647394 | 2022-08-14 | China | Tianjin | 2095 | 3 | 0 | 39.3054 | 117.323 | 2022-08-15 04:20:59 | Tianjin, China | |||
3647395 | 3647395 | 2022-08-14 | China | Tibet | 84 | 0 | 0 | 31.6927 | 88.0924 | 2022-08-15 04:20:59 | Tibet, China | |||
3647396 | 3647396 | 2022-08-14 | China | Unknown | 686362 | 0 | 0 | 2022-08-15 04:20:59 | Unknown, China | |||||
3647397 | 3647397 | 2022-08-14 | China | Xinjiang | 1015 | 3 | 0 | 41.1129 | 85.2401 | 2022-08-15 04:20:59 | Xinjiang, China | |||
3647398 | 3647398 | 2022-08-14 | China | Yunnan | 2233 | 2 | 0 | 24.974 | 101.487 | 2022-08-15 04:20:59 | Yunnan, China | |||
3647399 | 3647399 | 2022-08-14 | China | Zhejiang | 3293 | 1 | 0 | 29.1832 | 120.0934 | 2022-08-15 04:20:59 | Zhejiang, China | |||
1968372 | 1968372 | 2022-08-13 | China | Anhui | 1504 | 6 | 0 | 31.8257 | 117.2264 | 2022-08-14 04:20:55 | Anhui, China | |||
1968373 | 1968373 | 2022-08-13 | China | Beijing | 3840 | 9 | 0 | 40.1824 | 116.4142 | 2022-08-14 04:20:55 | Beijing, China | |||
1968374 | 1968374 | 2022-08-13 | China | Chongqing | 816 | 6 | 0 | 30.0572 | 107.874 | 2022-08-14 04:20:55 | Chongqing, China | |||
1968375 | 1968375 | 2022-08-13 | China | Fujian | 3855 | 1 | 0 | 26.0789 | 117.9874 | 2022-08-14 04:20:55 | Fujian, China | |||
1968376 | 1968376 | 2022-08-13 | China | Gansu | 1335 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-14 04:20:55 | Gansu, China | |||
1968377 | 1968377 | 2022-08-13 | China | Guangdong | 8575 | 8 | 0 | 23.3417 | 113.4244 | 2022-08-14 04:20:55 | Guangdong, China | |||
1968378 | 1968378 | 2022-08-13 | China | Guangxi | 2248 | 2 | 0 | 23.8298 | 108.7881 | 2022-08-14 04:20:55 | Guangxi, China | |||
1968379 | 1968379 | 2022-08-13 | China | Guizhou | 189 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-14 04:20:55 | Guizhou, China | |||
1968380 | 1968380 | 2022-08-13 | China | Hainan | 2452 | 6 | 0 | 19.1959 | 109.7453 | 2022-08-14 04:20:55 | Hainan, China | |||
1968381 | 1968381 | 2022-08-13 | China | Hebei | 2009 | 7 | 0 | 37.8957 | 114.9042 | 2022-08-14 04:20:55 | Hebei, China | |||
1968382 | 1968382 | 2022-08-13 | China | Heilongjiang | 3006 | 13 | 0 | 47.862 | 127.7615 | 2022-08-14 04:20:55 | Heilongjiang, China | |||
1968383 | 1968383 | 2022-08-13 | China | Henan | 3231 | 22 | 0 | 33.882 | 113.614 | 2022-08-14 04:20:55 | Henan, China | |||
1968384 | 1968384 | 2022-08-13 | China | Hong Kong | 1412043 | 9562 | 0 | 22.3 | 114.2 | 2022-08-14 04:20:55 | Hong Kong, China | |||
1968385 | 1968385 | 2022-08-13 | China | Hubei | 68411 | 4512 | 0 | 30.9756 | 112.2707 | 2022-08-14 04:20:55 | Hubei, China | |||
1968386 | 1968386 | 2022-08-13 | China | Hunan | 1416 | 4 | 0 | 27.6104 | 111.7088 | 2022-08-14 04:20:55 | Hunan, China | |||
1968387 | 1968387 | 2022-08-13 | China | Inner Mongolia | 2320 | 1 | 0 | 44.0935 | 113.9448 | 2022-08-14 04:20:55 | Inner Mongolia, China | |||
1968388 | 1968388 | 2022-08-13 | China | Jiangsu | 2332 | 0 | 0 | 32.9711 | 119.455 | 2022-08-14 04:20:55 | Jiangsu, China | |||
1968389 | 1968389 | 2022-08-13 | China | Jiangxi | 1461 | 1 | 0 | 27.614 | 115.7221 | 2022-08-14 04:20:55 | Jiangxi, China | |||
1968390 | 1968390 | 2022-08-13 | China | Jilin | 40301 | 5 | 0 | 43.6661 | 126.1923 | 2022-08-14 04:20:55 | Jilin, China | |||
1968391 | 1968391 | 2022-08-13 | China | Liaoning | 1750 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-14 04:20:55 | Liaoning, China | |||
1968392 | 1968392 | 2022-08-13 | China | Macau | 791 | 6 | 0 | 22.1667 | 113.55 | 2022-08-14 04:20:55 | Macau, China | |||
1968393 | 1968393 | 2022-08-13 | China | Ningxia | 122 | 0 | 0 | 37.2692 | 106.1655 | 2022-08-14 04:20:55 | Ningxia, China | |||
1968394 | 1968394 | 2022-08-13 | China | Qinghai | 151 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-14 04:20:55 | Qinghai, China | |||
1968395 | 1968395 | 2022-08-13 | China | Shaanxi | 3398 | 3 | 0 | 35.1917 | 108.8701 | 2022-08-14 04:20:55 | Shaanxi, China | |||
1968396 | 1968396 | 2022-08-13 | China | Shandong | 2889 | 7 | 0 | 36.3427 | 118.1498 | 2022-08-14 04:20:55 | Shandong, China | |||
1968397 | 1968397 | 2022-08-13 | China | Shanghai | 63709 | 595 | 0 | 31.202 | 121.4491 | 2022-08-14 04:20:55 | Shanghai, China | |||
1968398 | 1968398 | 2022-08-13 | China | Shanxi | 429 | 0 | 0 | 37.5777 | 112.2922 | 2022-08-14 04:20:55 | Shanxi, China | |||
1968399 | 1968399 | 2022-08-13 | China | Sichuan | 2761 | 3 | 0 | 30.6171 | 102.7103 | 2022-08-14 04:20:55 | Sichuan, China | |||
1968400 | 1968400 | 2022-08-13 | China | Tianjin | 2095 | 3 | 0 | 39.3054 | 117.323 | 2022-08-14 04:20:55 | Tianjin, China | |||
1968401 | 1968401 | 2022-08-13 | China | Tibet | 14 | 0 | 0 | 31.6927 | 88.0924 | 2022-08-14 04:20:55 | Tibet, China | |||
1968402 | 1968402 | 2022-08-13 | China | Unknown | 684477 | 0 | 0 | 2022-08-14 04:20:55 | Unknown, China | |||||
1968403 | 1968403 | 2022-08-13 | China | Xinjiang | 1014 | 3 | 0 | 41.1129 | 85.2401 | 2022-08-14 04:20:55 | 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]);