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

30,343 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 >30

country_or_region 1

  • China · 30,343 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
647360 647360 2022-08-18 China Anhui     1504 6 0   31.8257 117.2264 2022-08-19 04:20:54 Anhui, China
647361 647361 2022-08-18 China Beijing     3910 9 0   40.1824 116.4142 2022-08-19 04:20:54 Beijing, China
647362 647362 2022-08-18 China Chongqing     828 6 0   30.0572 107.874 2022-08-19 04:20:54 Chongqing, China
647363 647363 2022-08-18 China Fujian     3950 1 0   26.0789 117.9874 2022-08-19 04:20:54 Fujian, China
647364 647364 2022-08-18 China Gansu     1335 2 0   35.7518 104.2861 2022-08-19 04:20:54 Gansu, China
647365 647365 2022-08-18 China Guangdong     8665 8 0   23.3417 113.4244 2022-08-19 04:20:54 Guangdong, China
647366 647366 2022-08-18 China Guangxi     2251 2 0   23.8298 108.7881 2022-08-19 04:20:54 Guangxi, China
647367 647367 2022-08-18 China Guizhou     192 2 0   26.8154 106.8748 2022-08-19 04:20:54 Guizhou, China
647368 647368 2022-08-18 China Hainan     6561 6 0   19.1959 109.7453 2022-08-19 04:20:54 Hainan, China
647369 647369 2022-08-18 China Hebei     2009 7 0   37.8957 114.9042 2022-08-19 04:20:54 Hebei, China
647370 647370 2022-08-18 China Heilongjiang     3020 13 0   47.862 127.7615 2022-08-19 04:20:54 Heilongjiang, China
647371 647371 2022-08-18 China Henan     3239 22 0   33.882 113.614 2022-08-19 04:20:54 Henan, China
647372 647372 2022-08-18 China Hong Kong     1438891 9589 0   22.3 114.2 2022-08-19 04:20:54 Hong Kong, China
647373 647373 2022-08-18 China Hubei     68411 4512 0   30.9756 112.2707 2022-08-19 04:20:54 Hubei, China
647374 647374 2022-08-18 China Hunan     1417 4 0   27.6104 111.7088 2022-08-19 04:20:54 Hunan, China
647375 647375 2022-08-18 China Inner Mongolia     2335 1 0   44.0935 113.9448 2022-08-19 04:20:54 Inner Mongolia, China
647376 647376 2022-08-18 China Jiangsu     2340 0 0   32.9711 119.455 2022-08-19 04:20:54 Jiangsu, China
647377 647377 2022-08-18 China Jiangxi     1465 1 0   27.614 115.7221 2022-08-19 04:20:54 Jiangxi, China
647378 647378 2022-08-18 China Jilin     40309 5 0   43.6661 126.1923 2022-08-19 04:20:54 Jilin, China
647379 647379 2022-08-18 China Liaoning     1761 2 0   41.2956 122.6085 2022-08-19 04:20:54 Liaoning, China
647380 647380 2022-08-18 China Macau     793 6 0   22.1667 113.55 2022-08-19 04:20:54 Macau, China
647381 647381 2022-08-18 China Ningxia     122 0 0   37.2692 106.1655 2022-08-19 04:20:54 Ningxia, China
647382 647382 2022-08-18 China Qinghai     162 0 0   35.7452 95.9956 2022-08-19 04:20:54 Qinghai, China
647383 647383 2022-08-18 China Shaanxi     3500 3 0   35.1917 108.8701 2022-08-19 04:20:54 Shaanxi, China
647384 647384 2022-08-18 China Shandong     2911 7 0   36.3427 118.1498 2022-08-19 04:20:54 Shandong, China
647385 647385 2022-08-18 China Shanghai     63752 595 0   31.202 121.4491 2022-08-19 04:20:54 Shanghai, China
647386 647386 2022-08-18 China Shanxi     430 0 0   37.5777 112.2922 2022-08-19 04:20:54 Shanxi, China
647387 647387 2022-08-18 China Sichuan     2808 3 0   30.6171 102.7103 2022-08-19 04:20:54 Sichuan, China
647388 647388 2022-08-18 China Tianjin     2108 3 0   39.3054 117.323 2022-08-19 04:20:54 Tianjin, China
647389 647389 2022-08-18 China Tibet     229 0 0   31.6927 88.0924 2022-08-19 04:20:54 Tibet, China
647390 647390 2022-08-18 China Unknown     695105 0 0       2022-08-19 04:20:54 Unknown, China
647391 647391 2022-08-18 China Xinjiang     1042 3 0   41.1129 85.2401 2022-08-19 04:20:54 Xinjiang, China
647392 647392 2022-08-18 China Yunnan     2251 2 0   24.974 101.487 2022-08-19 04:20:54 Yunnan, China
647393 647393 2022-08-18 China Zhejiang     3366 1 0   29.1832 120.0934 2022-08-19 04:20:54 Zhejiang, China
2706132 2706132 2022-08-17 China Anhui     1504 6 0   31.8257 117.2264 2022-08-18 04:21:11 Anhui, China
2706133 2706133 2022-08-17 China Beijing     3905 9 0   40.1824 116.4142 2022-08-18 04:21:11 Beijing, China
2706134 2706134 2022-08-17 China Chongqing     819 6 0   30.0572 107.874 2022-08-18 04:21:11 Chongqing, China
2706135 2706135 2022-08-17 China Fujian     3928 1 0   26.0789 117.9874 2022-08-18 04:21:11 Fujian, China
2706136 2706136 2022-08-17 China Gansu     1335 2 0   35.7518 104.2861 2022-08-18 04:21:11 Gansu, China
2706137 2706137 2022-08-17 China Guangdong     8650 8 0   23.3417 113.4244 2022-08-18 04:21:11 Guangdong, China
2706138 2706138 2022-08-17 China Guangxi     2250 2 0   23.8298 108.7881 2022-08-18 04:21:11 Guangxi, China
2706139 2706139 2022-08-17 China Guizhou     191 2 0   26.8154 106.8748 2022-08-18 04:21:11 Guizhou, China
2706140 2706140 2022-08-17 China Hainan     6120 6 0   19.1959 109.7453 2022-08-18 04:21:11 Hainan, China
2706141 2706141 2022-08-17 China Hebei     2009 7 0   37.8957 114.9042 2022-08-18 04:21:11 Hebei, China
2706142 2706142 2022-08-17 China Heilongjiang     3017 13 0   47.862 127.7615 2022-08-18 04:21:11 Heilongjiang, China
2706143 2706143 2022-08-17 China Henan     3238 22 0   33.882 113.614 2022-08-18 04:21:11 Henan, China
2706144 2706144 2022-08-17 China Hong Kong     1432837 9584 0   22.3 114.2 2022-08-18 04:21:11 Hong Kong, China
2706145 2706145 2022-08-17 China Hubei     68411 4512 0   30.9756 112.2707 2022-08-18 04:21:11 Hubei, China
2706146 2706146 2022-08-17 China Hunan     1417 4 0   27.6104 111.7088 2022-08-18 04:21:11 Hunan, China
2706147 2706147 2022-08-17 China Inner Mongolia     2331 1 0   44.0935 113.9448 2022-08-18 04:21:11 Inner Mongolia, China
2706148 2706148 2022-08-17 China Jiangsu     2339 0 0   32.9711 119.455 2022-08-18 04:21:11 Jiangsu, China
2706149 2706149 2022-08-17 China Jiangxi     1464 1 0   27.614 115.7221 2022-08-18 04:21:11 Jiangxi, China
2706150 2706150 2022-08-17 China Jilin     40309 5 0   43.6661 126.1923 2022-08-18 04:21:11 Jilin, China
2706151 2706151 2022-08-17 China Liaoning     1761 2 0   41.2956 122.6085 2022-08-18 04:21:11 Liaoning, China
2706152 2706152 2022-08-17 China Macau     793 6 0   22.1667 113.55 2022-08-18 04:21:11 Macau, China
2706153 2706153 2022-08-17 China Ningxia     122 0 0   37.2692 106.1655 2022-08-18 04:21:11 Ningxia, China
2706154 2706154 2022-08-17 China Qinghai     161 0 0   35.7452 95.9956 2022-08-18 04:21:11 Qinghai, China
2706155 2706155 2022-08-17 China Shaanxi     3448 3 0   35.1917 108.8701 2022-08-18 04:21:11 Shaanxi, China
2706156 2706156 2022-08-17 China Shandong     2909 7 0   36.3427 118.1498 2022-08-18 04:21:11 Shandong, China
2706157 2706157 2022-08-17 China Shanghai     63745 595 0   31.202 121.4491 2022-08-18 04:21:11 Shanghai, China
2706158 2706158 2022-08-17 China Shanxi     429 0 0   37.5777 112.2922 2022-08-18 04:21:11 Shanxi, China
2706159 2706159 2022-08-17 China Sichuan     2801 3 0   30.6171 102.7103 2022-08-18 04:21:11 Sichuan, China
2706160 2706160 2022-08-17 China Tianjin     2107 3 0   39.3054 117.323 2022-08-18 04:21:11 Tianjin, China
2706161 2706161 2022-08-17 China Tibet     214 0 0   31.6927 88.0924 2022-08-18 04:21:11 Tibet, China
2706162 2706162 2022-08-17 China Unknown     692259 0 0       2022-08-18 04:21:11 Unknown, China
2706163 2706163 2022-08-17 China Xinjiang     1036 3 0   41.1129 85.2401 2022-08-18 04:21:11 Xinjiang, China
2706164 2706164 2022-08-17 China Yunnan     2249 2 0   24.974 101.487 2022-08-18 04:21:11 Yunnan, China
2706165 2706165 2022-08-17 China Zhejiang     3361 1 0   29.1832 120.0934 2022-08-18 04:21:11 Zhejiang, China
2395799 2395799 2022-08-16 China Anhui     1504 6 0   31.8257 117.2264 2022-08-17 04:20:59 Anhui, China
2395800 2395800 2022-08-16 China Beijing     3894 9 0   40.1824 116.4142 2022-08-17 04:20:59 Beijing, China
2395801 2395801 2022-08-16 China Chongqing     818 6 0   30.0572 107.874 2022-08-17 04:20:59 Chongqing, China
2395802 2395802 2022-08-16 China Fujian     3901 1 0   26.0789 117.9874 2022-08-17 04:20:59 Fujian, China
2395803 2395803 2022-08-16 China Gansu     1335 2 0   35.7518 104.2861 2022-08-17 04:20:59 Gansu, China
2395804 2395804 2022-08-16 China Guangdong     8637 8 0   23.3417 113.4244 2022-08-17 04:20:59 Guangdong, China
2395805 2395805 2022-08-16 China Guangxi     2249 2 0   23.8298 108.7881 2022-08-17 04:20:59 Guangxi, China
2395806 2395806 2022-08-16 China Guizhou     190 2 0   26.8154 106.8748 2022-08-17 04:20:59 Guizhou, China
2395807 2395807 2022-08-16 China Hainan     5624 6 0   19.1959 109.7453 2022-08-17 04:20:59 Hainan, China
2395808 2395808 2022-08-16 China Hebei     2009 7 0   37.8957 114.9042 2022-08-17 04:20:59 Hebei, China
2395809 2395809 2022-08-16 China Heilongjiang     3013 13 0   47.862 127.7615 2022-08-17 04:20:59 Heilongjiang, China
2395810 2395810 2022-08-16 China Henan     3235 22 0   33.882 113.614 2022-08-17 04:20:59 Henan, China
2395811 2395811 2022-08-16 China Hong Kong     1427080 9580 0   22.3 114.2 2022-08-17 04:20:59 Hong Kong, China
2395812 2395812 2022-08-16 China Hubei     68411 4512 0   30.9756 112.2707 2022-08-17 04:20:59 Hubei, China
2395813 2395813 2022-08-16 China Hunan     1416 4 0   27.6104 111.7088 2022-08-17 04:20:59 Hunan, China
2395814 2395814 2022-08-16 China Inner Mongolia     2326 1 0   44.0935 113.9448 2022-08-17 04:20:59 Inner Mongolia, China
2395815 2395815 2022-08-16 China Jiangsu     2338 0 0   32.9711 119.455 2022-08-17 04:20:59 Jiangsu, China
2395816 2395816 2022-08-16 China Jiangxi     1463 1 0   27.614 115.7221 2022-08-17 04:20:59 Jiangxi, China
2395817 2395817 2022-08-16 China Jilin     40308 5 0   43.6661 126.1923 2022-08-17 04:20:59 Jilin, China
2395818 2395818 2022-08-16 China Liaoning     1761 2 0   41.2956 122.6085 2022-08-17 04:20:59 Liaoning, China
2395819 2395819 2022-08-16 China Macau     793 6 0   22.1667 113.55 2022-08-17 04:20:59 Macau, China
2395820 2395820 2022-08-16 China Ningxia     122 0 0   37.2692 106.1655 2022-08-17 04:20:59 Ningxia, China
2395821 2395821 2022-08-16 China Qinghai     158 0 0   35.7452 95.9956 2022-08-17 04:20:59 Qinghai, China
2395822 2395822 2022-08-16 China Shaanxi     3412 3 0   35.1917 108.8701 2022-08-17 04:20:59 Shaanxi, China
2395823 2395823 2022-08-16 China Shandong     2907 7 0   36.3427 118.1498 2022-08-17 04:20:59 Shandong, China
2395824 2395824 2022-08-16 China Shanghai     63738 595 0   31.202 121.4491 2022-08-17 04:20:59 Shanghai, China
2395825 2395825 2022-08-16 China Shanxi     429 0 0   37.5777 112.2922 2022-08-17 04:20:59 Shanxi, China
2395826 2395826 2022-08-16 China Sichuan     2796 3 0   30.6171 102.7103 2022-08-17 04:20:59 Sichuan, China
2395827 2395827 2022-08-16 China Tianjin     2096 3 0   39.3054 117.323 2022-08-17 04:20:59 Tianjin, China
2395828 2395828 2022-08-16 China Tibet     195 0 0   31.6927 88.0924 2022-08-17 04:20:59 Tibet, China
2395829 2395829 2022-08-16 China Unknown     689905 0 0       2022-08-17 04:20:59 Unknown, China
2395830 2395830 2022-08-16 China Xinjiang     1027 3 0   41.1129 85.2401 2022-08-17 04:20:59 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]);