johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

3,927 rows where country_or_region = "China" sorted by day descending

✎ View and edit SQL

This data as json, CSV (advanced)

province_or_state

country_or_region

  • China · 3,927 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
242336 242336 2020-07-07 China Anhui     991 6 985 0 31.8257 117.2264 2020-07-08 05:33:48 Anhui, China
242367 242367 2020-07-07 China Beijing     929 9 613 307 40.1824 116.4142 2020-07-08 05:33:48 Beijing, China
242415 242415 2020-07-07 China Chongqing     582 6 574 2 30.0572 107.874 2020-07-08 05:33:48 Chongqing, China
242447 242447 2020-07-07 China Fujian     363 1 360 2 26.0789 117.9874 2020-07-08 05:33:48 Fujian, China
242452 242452 2020-07-07 China Gansu     167 2 159 6 35.7518 104.2861 2020-07-08 05:33:48 Gansu, China
242467 242467 2020-07-07 China Guangdong     1645 8 1631 6 23.3417 113.4244 2020-07-08 05:33:48 Guangdong, China
242468 242468 2020-07-07 China Guangxi     254 2 252 0 23.8298 108.7881 2020-07-08 05:33:48 Guangxi, China
242471 242471 2020-07-07 China Guizhou     147 2 145 0 26.8154 106.8748 2020-07-08 05:33:48 Guizhou, China
242474 242474 2020-07-07 China Hainan     171 6 165 0 19.1959 109.7453 2020-07-08 05:33:48 Hainan, China
242478 242478 2020-07-07 China Hebei     349 6 337 6 37.8957 114.9042 2020-07-08 05:33:48 Hebei, China
242479 242479 2020-07-07 China Heilongjiang     947 13 934 0 47.861999999999995 127.7615 2020-07-08 05:33:48 Heilongjiang, China
242480 242480 2020-07-07 China Henan     1276 22 1254 0 33.882 113.61399999999999 2020-07-08 05:33:48 Henan, China
242486 242486 2020-07-07 China Hong Kong     1299 7 1161 131 22.3 114.2 2020-07-08 05:33:48 Hong Kong, China
242489 242489 2020-07-07 China Hubei     68135 4512 63623 0 30.9756 112.2707 2020-07-08 05:33:48 Hubei, China
242491 242491 2020-07-07 China Hunan     1019 4 1015 0 27.6104 111.7088 2020-07-08 05:33:48 Hunan, China
242496 242496 2020-07-07 China Inner Mongolia     244 1 237 6 44.0935 113.9448 2020-07-08 05:33:48 Inner Mongolia, China
242508 242508 2020-07-07 China Jiangsu     654 0 654 0 32.9711 119.455 2020-07-08 05:33:48 Jiangsu, China
242509 242509 2020-07-07 China Jiangxi     932 1 931 0 27.614 115.7221 2020-07-08 05:33:48 Jiangxi, China
242510 242510 2020-07-07 China Jilin     155 2 153 0 43.6661 126.1923 2020-07-08 05:33:48 Jilin, China
242555 242555 2020-07-07 China Liaoning     159 2 150 7 41.2956 122.6085 2020-07-08 05:33:48 Liaoning, China
242565 242565 2020-07-07 China Macau     46 0 45 1 22.1667 113.55 2020-07-08 05:33:48 Macau, China
242619 242619 2020-07-07 China Ningxia     75 0 75 0 37.2692 106.1655 2020-07-08 05:33:48 Ningxia, China
242674 242674 2020-07-07 China Qinghai     18 0 18 0 35.7452 95.9956 2020-07-08 05:33:48 Qinghai, China
242717 242717 2020-07-07 China Shaanxi     321 3 313 5 35.1917 108.8701 2020-07-08 05:33:48 Shaanxi, China
242718 242718 2020-07-07 China Shandong     792 7 785 0 36.3427 118.1498 2020-07-08 05:33:48 Shandong, China
242719 242719 2020-07-07 China Shanghai     718 7 688 23 31.201999999999998 121.4491 2020-07-08 05:33:48 Shanghai, China
242720 242720 2020-07-07 China Shanxi     199 0 198 1 37.5777 112.2922 2020-07-08 05:33:48 Shanxi, China
242724 242724 2020-07-07 China Sichuan     598 3 581 14 30.6171 102.7103 2020-07-08 05:33:48 Sichuan, China
242752 242752 2020-07-07 China Tianjin     199 3 194 2 39.3054 117.323 2020-07-08 05:33:48 Tianjin, China
242753 242753 2020-07-07 China Tibet     1 0 1 0 31.6927 88.0924 2020-07-08 05:33:48 Tibet, China
242809 242809 2020-07-07 China Xinjiang     76 3 73 0 41.1129 85.2401 2020-07-08 05:33:48 Xinjiang, China
242817 242817 2020-07-07 China Yunnan     187 2 183 2 24.974 101.48700000000001 2020-07-08 05:33:48 Yunnan, China
242822 242822 2020-07-07 China Zhejiang     1269 1 1267 1 29.1832 120.0934 2020-07-08 05:33:48 Zhejiang, China
55927 55927 2020-07-06 China Anhui     991 6 985 0 31.8257 117.2264 2020-07-07 04:34:00 Anhui, China
55958 55958 2020-07-06 China Beijing     929 9 596 324 40.1824 116.4142 2020-07-07 04:34:00 Beijing, China
56006 56006 2020-07-06 China Chongqing     582 6 574 2 30.0572 107.874 2020-07-07 04:34:00 Chongqing, China
56038 56038 2020-07-06 China Fujian     363 1 360 2 26.0789 117.9874 2020-07-07 04:34:00 Fujian, China
56043 56043 2020-07-06 China Gansu     167 2 154 11 35.7518 104.2861 2020-07-07 04:34:00 Gansu, China
56058 56058 2020-07-06 China Guangdong     1643 8 1631 4 23.3417 113.4244 2020-07-07 04:34:00 Guangdong, China
56059 56059 2020-07-06 China Guangxi     254 2 252 0 23.8298 108.7881 2020-07-07 04:34:00 Guangxi, China
56062 56062 2020-07-06 China Guizhou     147 2 145 0 26.8154 106.8748 2020-07-07 04:34:00 Guizhou, China
56065 56065 2020-07-06 China Hainan     171 6 165 0 19.1959 109.7453 2020-07-07 04:34:00 Hainan, China
56069 56069 2020-07-06 China Hebei     349 6 337 6 37.8957 114.9042 2020-07-07 04:34:00 Hebei, China
56070 56070 2020-07-06 China Heilongjiang     947 13 934 0 47.862 127.7615 2020-07-07 04:34:00 Heilongjiang, China
56071 56071 2020-07-06 China Henan     1276 22 1254 0 33.882 113.614 2020-07-07 04:34:00 Henan, China
56077 56077 2020-07-06 China Hong Kong     1285 7 1157 121 22.3 114.2 2020-07-07 04:34:00 Hong Kong, China
56080 56080 2020-07-06 China Hubei     68135 4512 63623 0 30.9756 112.2707 2020-07-07 04:34:00 Hubei, China
56082 56082 2020-07-06 China Hunan     1019 4 1015 0 27.6104 111.7088 2020-07-07 04:34:00 Hunan, China
56087 56087 2020-07-06 China Inner Mongolia     240 1 237 2 44.0935 113.9448 2020-07-07 04:34:00 Inner Mongolia, China
56099 56099 2020-07-06 China Jiangsu     654 0 654 0 32.9711 119.455 2020-07-07 04:34:00 Jiangsu, China
56100 56100 2020-07-06 China Jiangxi     932 1 931 0 27.614 115.7221 2020-07-07 04:34:00 Jiangxi, China
56101 56101 2020-07-06 China Jilin     155 2 153 0 43.6661 126.1923 2020-07-07 04:34:00 Jilin, China
56146 56146 2020-07-06 China Liaoning     157 2 150 5 41.2956 122.6085 2020-07-07 04:34:00 Liaoning, China
56156 56156 2020-07-06 China Macau     46 0 45 1 22.1667 113.55 2020-07-07 04:34:00 Macau, China
56210 56210 2020-07-06 China Ningxia     75 0 75 0 37.2692 106.1655 2020-07-07 04:34:00 Ningxia, China
56265 56265 2020-07-06 China Qinghai     18 0 18 0 35.7452 95.9956 2020-07-07 04:34:00 Qinghai, China
56308 56308 2020-07-06 China Shaanxi     321 3 313 5 35.1917 108.8701 2020-07-07 04:34:00 Shaanxi, China
56309 56309 2020-07-06 China Shandong     792 7 785 0 36.3427 118.1498 2020-07-07 04:34:00 Shandong, China
56310 56310 2020-07-06 China Shanghai     716 7 685 24 31.202 121.4491 2020-07-07 04:34:00 Shanghai, China
56311 56311 2020-07-06 China Shanxi     198 0 198 0 37.5777 112.2922 2020-07-07 04:34:00 Shanxi, China
56315 56315 2020-07-06 China Sichuan     596 3 581 12 30.6171 102.7103 2020-07-07 04:34:00 Sichuan, China
56343 56343 2020-07-06 China Tianjin     199 3 194 2 39.3054 117.323 2020-07-07 04:34:00 Tianjin, China
56344 56344 2020-07-06 China Tibet     1 0 1 0 31.6927 88.0924 2020-07-07 04:34:00 Tibet, China
56400 56400 2020-07-06 China Xinjiang     76 3 73 0 41.1129 85.2401 2020-07-07 04:34:00 Xinjiang, China
56408 56408 2020-07-06 China Yunnan     186 2 183 1 24.974 101.487 2020-07-07 04:34:00 Yunnan, China
56413 56413 2020-07-06 China Zhejiang     1269 1 1267 1 29.1832 120.0934 2020-07-07 04:34:00 Zhejiang, China
347364 347364 2020-07-05 China Anhui     991 6 985 0 31.8257 117.2264 2020-07-06 04:33:57 Anhui, China
347395 347395 2020-07-05 China Beijing     929 9 596 324 40.1824 116.4142 2020-07-06 04:33:57 Beijing, China
347443 347443 2020-07-05 China Chongqing     582 6 574 2 30.0572 107.874 2020-07-06 04:33:57 Chongqing, China
347475 347475 2020-07-05 China Fujian     363 1 360 2 26.0789 117.9874 2020-07-06 04:33:57 Fujian, China
347480 347480 2020-07-05 China Gansu     167 2 154 11 35.7518 104.2861 2020-07-06 04:33:57 Gansu, China
347495 347495 2020-07-05 China Guangdong     1643 8 1631 4 23.3417 113.4244 2020-07-06 04:33:57 Guangdong, China
347496 347496 2020-07-05 China Guangxi     254 2 252 0 23.8298 108.7881 2020-07-06 04:33:57 Guangxi, China
347499 347499 2020-07-05 China Guizhou     147 2 145 0 26.8154 106.8748 2020-07-06 04:33:57 Guizhou, China
347502 347502 2020-07-05 China Hainan     171 6 165 0 19.1959 109.7453 2020-07-06 04:33:57 Hainan, China
347506 347506 2020-07-05 China Hebei     349 6 337 6 37.8957 114.9042 2020-07-06 04:33:57 Hebei, China
347507 347507 2020-07-05 China Heilongjiang     947 13 934 0 47.861999999999995 127.7615 2020-07-06 04:33:57 Heilongjiang, China
347508 347508 2020-07-05 China Henan     1276 22 1254 0 33.882 113.61399999999999 2020-07-06 04:33:57 Henan, China
347514 347514 2020-07-05 China Hong Kong     1268 7 1156 105 22.3 114.2 2020-07-06 04:33:57 Hong Kong, China
347517 347517 2020-07-05 China Hubei     68135 4512 63623 0 30.9756 112.2707 2020-07-06 04:33:57 Hubei, China
347519 347519 2020-07-05 China Hunan     1019 4 1015 0 27.6104 111.7088 2020-07-06 04:33:57 Hunan, China
347524 347524 2020-07-05 China Inner Mongolia     239 1 237 1 44.0935 113.9448 2020-07-06 04:33:57 Inner Mongolia, China
347536 347536 2020-07-05 China Jiangsu     654 0 654 0 32.9711 119.455 2020-07-06 04:33:57 Jiangsu, China
347537 347537 2020-07-05 China Jiangxi     932 1 931 0 27.614 115.7221 2020-07-06 04:33:57 Jiangxi, China
347538 347538 2020-07-05 China Jilin     155 2 153 0 43.6661 126.1923 2020-07-06 04:33:57 Jilin, China
347583 347583 2020-07-05 China Liaoning     157 2 150 5 41.2956 122.6085 2020-07-06 04:33:57 Liaoning, China
347593 347593 2020-07-05 China Macau     46 0 45 1 22.1667 113.55 2020-07-06 04:33:57 Macau, China
347647 347647 2020-07-05 China Ningxia     75 0 75 0 37.2692 106.1655 2020-07-06 04:33:57 Ningxia, China
347702 347702 2020-07-05 China Qinghai     18 0 18 0 35.7452 95.9956 2020-07-06 04:33:57 Qinghai, China
347745 347745 2020-07-05 China Shaanxi     321 3 311 7 35.1917 108.8701 2020-07-06 04:33:57 Shaanxi, China
347746 347746 2020-07-05 China Shandong     792 7 785 0 36.3427 118.1498 2020-07-06 04:33:57 Shandong, China
347747 347747 2020-07-05 China Shanghai     716 7 681 28 31.201999999999998 121.4491 2020-07-06 04:33:57 Shanghai, China
347748 347748 2020-07-05 China Shanxi     198 0 198 0 37.5777 112.2922 2020-07-06 04:33:57 Shanxi, China
347752 347752 2020-07-05 China Sichuan     596 3 581 12 30.6171 102.7103 2020-07-06 04:33:57 Sichuan, China
347780 347780 2020-07-05 China Tianjin     199 3 194 2 39.3054 117.323 2020-07-06 04:33:57 Tianjin, China
347781 347781 2020-07-05 China Tibet     1 0 1 0 31.6927 88.0924 2020-07-06 04:33:57 Tibet, China
347837 347837 2020-07-05 China Xinjiang     76 3 73 0 41.1129 85.2401 2020-07-06 04:33:57 Xinjiang, China
347845 347845 2020-07-05 China Yunnan     186 2 183 1 24.974 101.48700000000001 2020-07-06 04:33:57 Yunnan, China
347850 347850 2020-07-05 China Zhejiang     1269 1 1267 1 29.1832 120.0934 2020-07-06 04:33:57 Zhejiang, China
319252 319252 2020-07-04 China Anhui     991 6 985 0 31.8257 117.2264 2020-07-05 04:33:46 Anhui, China

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
Powered by Datasette · Query took 2356.218ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette