johns_hopkins_csse_daily_reports

Table actions
⚠️ 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

20,177 rows where country_or_region = "China" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date), last_update (date)

province_or_state

country_or_region

  • China · 20,177 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
32065 32065 2021-10-23 China Anhui     1008 6 0   31.8257 117.2264 2021-10-24 04:21:22 Anhui, China
32066 32066 2021-10-23 China Beijing     1141 9 0   40.1824 116.4142 2021-10-24 04:21:22 Beijing, China
32067 32067 2021-10-23 China Chongqing     603 6 0   30.0572 107.874 2021-10-24 04:21:22 Chongqing, China
32068 32068 2021-10-23 China Fujian     1298 1 0   26.0789 117.9874 2021-10-24 04:21:22 Fujian, China
32069 32069 2021-10-23 China Gansu     241 2 0   35.7518 104.2861 2021-10-24 04:21:22 Gansu, China
32070 32070 2021-10-23 China Guangdong     3211 8 0   23.3417 113.4244 2021-10-24 04:21:22 Guangdong, China
32071 32071 2021-10-23 China Guangxi     326 2 0   23.8298 108.7881 2021-10-24 04:21:22 Guangxi, China
32072 32072 2021-10-23 China Guizhou     149 2 0   26.8154 106.8748 2021-10-24 04:21:22 Guizhou, China
32073 32073 2021-10-23 China Hainan     190 6 0   19.1959 109.7453 2021-10-24 04:21:22 Hainan, China
32074 32074 2021-10-23 China Hebei     1319 7 0   37.8957 114.9042 2021-10-24 04:21:22 Hebei, China
32075 32075 2021-10-23 China Heilongjiang     1713 13 0   47.861999999999995 127.7615 2021-10-24 04:21:22 Heilongjiang, China
32076 32076 2021-10-23 China Henan     1553 22 0   33.882 113.61399999999999 2021-10-24 04:21:22 Henan, China
32077 32077 2021-10-23 China Hong Kong     12319 213 0   22.3 114.2 2021-10-24 04:21:22 Hong Kong, China
32078 32078 2021-10-23 China Hubei     68305 4512 0   30.9756 112.2707 2021-10-24 04:21:22 Hubei, China
32079 32079 2021-10-23 China Hunan     1195 4 0   27.6104 111.7088 2021-10-24 04:21:22 Hunan, China
32080 32080 2021-10-23 China Inner Mongolia     464 1 0   44.0935 113.9448 2021-10-24 04:21:22 Inner Mongolia, China
32081 32081 2021-10-23 China Jiangsu     1600 0 0   32.9711 119.455 2021-10-24 04:21:22 Jiangsu, China
32082 32082 2021-10-23 China Jiangxi     937 1 0   27.614 115.7221 2021-10-24 04:21:22 Jiangxi, China
32083 32083 2021-10-23 China Jilin     577 3 0   43.6661 126.1923 2021-10-24 04:21:22 Jilin, China
32084 32084 2021-10-23 China Liaoning     465 2 0   41.2956 122.6085 2021-10-24 04:21:22 Liaoning, China
32085 32085 2021-10-23 China Macau     77 0 0   22.1667 113.55 2021-10-24 04:21:22 Macau, China
32086 32086 2021-10-23 China Ningxia     94 0 0   37.2692 106.1655 2021-10-24 04:21:22 Ningxia, China
32087 32087 2021-10-23 China Qinghai     19 0 0   35.7452 95.9956 2021-10-24 04:21:22 Qinghai, China
32088 32088 2021-10-23 China Shaanxi     696 3 0   35.1917 108.8701 2021-10-24 04:21:22 Shaanxi, China
32089 32089 2021-10-23 China Shandong     965 7 0   36.3427 118.1498 2021-10-24 04:21:22 Shandong, China
32090 32090 2021-10-23 China Shanghai     2704 7 0   31.201999999999998 121.4491 2021-10-24 04:21:22 Shanghai, China
32091 32091 2021-10-23 China Shanxi     260 0 0   37.5777 112.2922 2021-10-24 04:21:22 Shanxi, China
32092 32092 2021-10-23 China Sichuan     1220 3 0   30.6171 102.7103 2021-10-24 04:21:22 Sichuan, China
32093 32093 2021-10-23 China Tianjin     501 3 0   39.3054 117.323 2021-10-24 04:21:22 Tianjin, China
32094 32094 2021-10-23 China Tibet     1 0 0   31.6927 88.0924 2021-10-24 04:21:22 Tibet, China
32095 32095 2021-10-23 China Unknown     0 0 0       2021-10-24 04:21:22 Unknown, China
32096 32096 2021-10-23 China Xinjiang     981 3 0   41.1129 85.2401 2021-10-24 04:21:22 Xinjiang, China
32097 32097 2021-10-23 China Yunnan     1558 2 0   24.974 101.48700000000001 2021-10-24 04:21:22 Yunnan, China
32098 32098 2021-10-23 China Zhejiang     1465 1 0   29.1832 120.0934 2021-10-24 04:21:22 Zhejiang, China
312549 312549 2021-10-22 China Anhui     1008 6 0   31.8257 117.2264 2021-10-23 04:21:32 Anhui, China
312550 312550 2021-10-22 China Beijing     1136 9 0   40.1824 116.4142 2021-10-23 04:21:32 Beijing, China
312551 312551 2021-10-22 China Chongqing     603 6 0   30.0572 107.874 2021-10-23 04:21:32 Chongqing, China
312552 312552 2021-10-22 China Fujian     1298 1 0   26.0789 117.9874 2021-10-23 04:21:32 Fujian, China
312553 312553 2021-10-22 China Gansu     235 2 0   35.7518 104.2861 2021-10-23 04:21:32 Gansu, China
312554 312554 2021-10-22 China Guangdong     3210 8 0   23.3417 113.4244 2021-10-23 04:21:32 Guangdong, China
312555 312555 2021-10-22 China Guangxi     325 2 0   23.8298 108.7881 2021-10-23 04:21:32 Guangxi, China
312556 312556 2021-10-22 China Guizhou     149 2 0   26.8154 106.8748 2021-10-23 04:21:32 Guizhou, China
312557 312557 2021-10-22 China Hainan     190 6 0   19.1959 109.7453 2021-10-23 04:21:32 Hainan, China
312558 312558 2021-10-22 China Hebei     1318 7 0   37.8957 114.9042 2021-10-23 04:21:32 Hebei, China
312559 312559 2021-10-22 China Heilongjiang     1712 13 0   47.861999999999995 127.7615 2021-10-23 04:21:32 Heilongjiang, China
312560 312560 2021-10-22 China Henan     1553 22 0   33.882 113.61399999999999 2021-10-23 04:21:32 Henan, China
312561 312561 2021-10-22 China Hong Kong     12313 213 0   22.3 114.2 2021-10-23 04:21:32 Hong Kong, China
312562 312562 2021-10-22 China Hubei     68305 4512 0   30.9756 112.2707 2021-10-23 04:21:32 Hubei, China
312563 312563 2021-10-22 China Hunan     1194 4 0   27.6104 111.7088 2021-10-23 04:21:32 Hunan, China
312564 312564 2021-10-22 China Inner Mongolia     457 1 0   44.0935 113.9448 2021-10-23 04:21:32 Inner Mongolia, China
312565 312565 2021-10-22 China Jiangsu     1600 0 0   32.9711 119.455 2021-10-23 04:21:32 Jiangsu, China
312566 312566 2021-10-22 China Jiangxi     937 1 0   27.614 115.7221 2021-10-23 04:21:32 Jiangxi, China
312567 312567 2021-10-22 China Jilin     577 3 0   43.6661 126.1923 2021-10-23 04:21:32 Jilin, China
312568 312568 2021-10-22 China Liaoning     465 2 0   41.2956 122.6085 2021-10-23 04:21:32 Liaoning, China
312569 312569 2021-10-22 China Macau     77 0 0   22.1667 113.55 2021-10-23 04:21:32 Macau, China
312570 312570 2021-10-22 China Ningxia     88 0 0   37.2692 106.1655 2021-10-23 04:21:32 Ningxia, China
312571 312571 2021-10-22 China Qinghai     19 0 0   35.7452 95.9956 2021-10-23 04:21:32 Qinghai, China
312572 312572 2021-10-22 China Shaanxi     694 3 0   35.1917 108.8701 2021-10-23 04:21:32 Shaanxi, China
312573 312573 2021-10-22 China Shandong     965 7 0   36.3427 118.1498 2021-10-23 04:21:32 Shandong, China
312574 312574 2021-10-22 China Shanghai     2700 7 0   31.201999999999998 121.4491 2021-10-23 04:21:32 Shanghai, China
312575 312575 2021-10-22 China Shanxi     260 0 0   37.5777 112.2922 2021-10-23 04:21:32 Shanxi, China
312576 312576 2021-10-22 China Sichuan     1220 3 0   30.6171 102.7103 2021-10-23 04:21:32 Sichuan, China
312577 312577 2021-10-22 China Tianjin     501 3 0   39.3054 117.323 2021-10-23 04:21:32 Tianjin, China
312578 312578 2021-10-22 China Tibet     1 0 0   31.6927 88.0924 2021-10-23 04:21:32 Tibet, China
312579 312579 2021-10-22 China Unknown     0 0 0       2021-10-23 04:21:32 Unknown, China
312580 312580 2021-10-22 China Xinjiang     981 3 0   41.1129 85.2401 2021-10-23 04:21:32 Xinjiang, China
312581 312581 2021-10-22 China Yunnan     1557 2 0   24.974 101.48700000000001 2021-10-23 04:21:32 Yunnan, China
312582 312582 2021-10-22 China Zhejiang     1457 1 0   29.1832 120.0934 2021-10-23 04:21:32 Zhejiang, China
2134571 2134571 2021-10-21 China Anhui     1008 6 0   31.8257 117.2264 2021-10-22 04:21:14 Anhui, China
2134572 2134572 2021-10-21 China Beijing     1130 9 0   40.1824 116.4142 2021-10-22 04:21:14 Beijing, China
2134573 2134573 2021-10-21 China Chongqing     603 6 0   30.0572 107.874 2021-10-22 04:21:14 Chongqing, China
2134574 2134574 2021-10-21 China Fujian     1296 1 0   26.0789 117.9874 2021-10-22 04:21:14 Fujian, China
2134575 2134575 2021-10-21 China Gansu     218 2 0   35.7518 104.2861 2021-10-22 04:21:14 Gansu, China
2134576 2134576 2021-10-21 China Guangdong     3209 8 0   23.3417 113.4244 2021-10-22 04:21:14 Guangdong, China
2134577 2134577 2021-10-21 China Guangxi     323 2 0   23.8298 108.7881 2021-10-22 04:21:14 Guangxi, China
2134578 2134578 2021-10-21 China Guizhou     149 2 0   26.8154 106.8748 2021-10-22 04:21:14 Guizhou, China
2134579 2134579 2021-10-21 China Hainan     190 6 0   19.1959 109.7453 2021-10-22 04:21:14 Hainan, China
2134580 2134580 2021-10-21 China Hebei     1318 7 0   37.8957 114.9042 2021-10-22 04:21:14 Hebei, China
2134581 2134581 2021-10-21 China Heilongjiang     1712 13 0   47.861999999999995 127.7615 2021-10-22 04:21:14 Heilongjiang, China
2134582 2134582 2021-10-21 China Henan     1553 22 0   33.882 113.61399999999999 2021-10-22 04:21:14 Henan, China
2134583 2134583 2021-10-21 China Hong Kong     12311 213 0   22.3 114.2 2021-10-22 04:21:14 Hong Kong, China
2134584 2134584 2021-10-21 China Hubei     68305 4512 0   30.9756 112.2707 2021-10-22 04:21:14 Hubei, China
2134585 2134585 2021-10-21 China Hunan     1194 4 0   27.6104 111.7088 2021-10-22 04:21:14 Hunan, China
2134586 2134586 2021-10-21 China Inner Mongolia     451 1 0   44.0935 113.9448 2021-10-22 04:21:14 Inner Mongolia, China
2134587 2134587 2021-10-21 China Jiangsu     1600 0 0   32.9711 119.455 2021-10-22 04:21:14 Jiangsu, China
2134588 2134588 2021-10-21 China Jiangxi     937 1 0   27.614 115.7221 2021-10-22 04:21:14 Jiangxi, China
2134589 2134589 2021-10-21 China Jilin     577 3 0   43.6661 126.1923 2021-10-22 04:21:14 Jilin, China
2134590 2134590 2021-10-21 China Liaoning     464 2 0   41.2956 122.6085 2021-10-22 04:21:14 Liaoning, China
2134591 2134591 2021-10-21 China Macau     77 0 0   22.1667 113.55 2021-10-22 04:21:14 Macau, China
2134592 2134592 2021-10-21 China Ningxia     85 0 0   37.2692 106.1655 2021-10-22 04:21:14 Ningxia, China
2134593 2134593 2021-10-21 China Qinghai     19 0 0   35.7452 95.9956 2021-10-22 04:21:14 Qinghai, China
2134594 2134594 2021-10-21 China Shaanxi     694 3 0   35.1917 108.8701 2021-10-22 04:21:14 Shaanxi, China
2134595 2134595 2021-10-21 China Shandong     964 7 0   36.3427 118.1498 2021-10-22 04:21:14 Shandong, China
2134596 2134596 2021-10-21 China Shanghai     2697 7 0   31.201999999999998 121.4491 2021-10-22 04:21:14 Shanghai, China
2134597 2134597 2021-10-21 China Shanxi     260 0 0   37.5777 112.2922 2021-10-22 04:21:14 Shanxi, China
2134598 2134598 2021-10-21 China Sichuan     1220 3 0   30.6171 102.7103 2021-10-22 04:21:14 Sichuan, China
2134599 2134599 2021-10-21 China Tianjin     500 3 0   39.3054 117.323 2021-10-22 04:21:14 Tianjin, China
2134600 2134600 2021-10-21 China Tibet     1 0 0   31.6927 88.0924 2021-10-22 04:21:14 Tibet, China
2134601 2134601 2021-10-21 China Unknown     0 0 0       2021-10-22 04:21:14 Unknown, China
2134602 2134602 2021-10-21 China Xinjiang     981 3 0   41.1129 85.2401 2021-10-22 04:21:14 Xinjiang, 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
);
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]);