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

10,560 rows where country_or_region = "China" sorted by day descending

View and edit SQL

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

province_or_state

country_or_region

  • China · 10,560
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
831892 2021-01-24 China Anhui     994 6 987 1 31.8257 117.2264 2021-01-25 05:22:16 Anhui, China
831893 2021-01-24 China Beijing     1028 9 966 53 40.1824 116.4142 2021-01-25 05:22:16 Beijing, China
831894 2021-01-24 China Chongqing     591 6 584 1 30.0572 107.874 2021-01-25 05:22:16 Chongqing, China
831895 2021-01-24 China Fujian     535 1 519 15 26.0789 117.9874 2021-01-25 05:22:16 Fujian, China
831896 2021-01-24 China Gansu     183 2 180 1 35.7518 104.2861 2021-01-25 05:22:16 Gansu, China
831897 2021-01-24 China Guangdong     2106 8 2055 43 23.3417 113.4244 2021-01-25 05:22:16 Guangdong, China
831898 2021-01-24 China Guangxi     267 2 262 3 23.8298 108.7881 2021-01-25 05:22:16 Guangxi, China
831899 2021-01-24 China Guizhou     147 2 145 0 26.8154 106.8748 2021-01-25 05:22:16 Guizhou, China
831900 2021-01-24 China Hainan     171 6 165 0 19.1959 109.7453 2021-01-25 05:22:16 Hainan, China
831901 2021-01-24 China Hebei     1294 7 481 806 37.8957 114.9042 2021-01-25 05:22:16 Hebei, China
831902 2021-01-24 China Heilongjiang     1394 13 964 417 47.862 127.7615 2021-01-25 05:22:16 Heilongjiang, China
831903 2021-01-24 China Henan     1303 22 1277 4 33.882 113.614 2021-01-25 05:22:16 Henan, China
831904 2021-01-24 China Hong Kong     10085 169 9034 882 22.3 114.2 2021-01-25 05:22:16 Hong Kong, China
831905 2021-01-24 China Hubei     68150 4512 63637 1 30.9756 112.2707 2021-01-25 05:22:16 Hubei, China
831906 2021-01-24 China Hunan     1027 4 1017 6 27.6104 111.7088 2021-01-25 05:22:16 Hunan, China
831907 2021-01-24 China Inner Mongolia     366 1 351 14 44.0935 113.9448 2021-01-25 05:22:16 Inner Mongolia, China
831908 2021-01-24 China Jiangsu     691 0 685 6 32.9711 119.455 2021-01-25 05:22:16 Jiangsu, China
831909 2021-01-24 China Jiangxi     935 1 934 0 27.614 115.7221 2021-01-25 05:22:16 Jiangxi, China
831910 2021-01-24 China Jilin     430 2 155 273 43.6661 126.1923 2021-01-25 05:22:16 Jilin, China
831911 2021-01-24 China Liaoning     397 2 379 16 41.2956 122.6085 2021-01-25 05:22:16 Liaoning, China
831912 2021-01-24 China Macau     47 0 46 1 22.1667 113.55 2021-01-25 05:22:16 Macau, China
831913 2021-01-24 China Ningxia     75 0 75 0 37.2692 106.1655 2021-01-25 05:22:16 Ningxia, China
831914 2021-01-24 China Qinghai     18 0 18 0 35.7452 95.9956 2021-01-25 05:22:16 Qinghai, China
831915 2021-01-24 China Shaanxi     534 3 508 23 35.1917 108.8701 2021-01-25 05:22:16 Shaanxi, China
831916 2021-01-24 China Shandong     866 7 856 3 36.3427 118.1498 2021-01-25 05:22:16 Shandong, China
831917 2021-01-24 China Shanghai     1644 7 1532 105 31.202 121.4491 2021-01-25 05:22:16 Shanghai, China
831918 2021-01-24 China Shanxi     237 0 225 12 37.5777 112.2922 2021-01-25 05:22:16 Shanxi, China
831919 2021-01-24 China Sichuan     866 3 852 11 30.6171 102.7103 2021-01-25 05:22:16 Sichuan, China
831920 2021-01-24 China Tianjin     338 3 309 26 39.3054 117.323 2021-01-25 05:22:16 Tianjin, China
831921 2021-01-24 China Tibet     1 0 1 0 31.6927 88.0924 2021-01-25 05:22:16 Tibet, China
831922 2021-01-24 China Xinjiang     980 3 977 0 41.1129 85.2401 2021-01-25 05:22:16 Xinjiang, China
831923 2021-01-24 China Yunnan     231 2 228 1 24.974 101.487 2021-01-25 05:22:16 Yunnan, China
831924 2021-01-24 China Zhejiang     1316 1 1305 10 29.1832 120.0934 2021-01-25 05:22:16 Zhejiang, China
901394 2021-01-23 China Anhui     994 6 987 1 31.8257 117.2264 2021-01-24 05:22:35 Anhui, China
901395 2021-01-23 China Beijing     1025 9 965 51 40.1824 116.4142 2021-01-24 05:22:35 Beijing, China
901396 2021-01-23 China Chongqing     591 6 584 1 30.0572 107.874 2021-01-24 05:22:35 Chongqing, China
901397 2021-01-23 China Fujian     534 1 516 17 26.0789 117.9874 2021-01-24 05:22:35 Fujian, China
901398 2021-01-23 China Gansu     183 2 180 1 35.7518 104.2861 2021-01-24 05:22:35 Gansu, China
901399 2021-01-23 China Guangdong     2104 8 2053 43 23.3417 113.4244 2021-01-24 05:22:35 Guangdong, China
901400 2021-01-23 China Guangxi     267 2 262 3 23.8298 108.7881 2021-01-24 05:22:35 Guangxi, China
901401 2021-01-23 China Guizhou     147 2 145 0 26.8154 106.8748 2021-01-24 05:22:35 Guizhou, China
901402 2021-01-23 China Hainan     171 6 165 0 19.1959 109.7453 2021-01-24 05:22:35 Hainan, China
901403 2021-01-23 China Hebei     1283 7 439 837 37.8957 114.9042 2021-01-24 05:22:35 Hebei, China
901404 2021-01-23 China Heilongjiang     1359 13 964 382 47.862 127.7615 2021-01-24 05:22:35 Heilongjiang, China
901405 2021-01-23 China Henan     1303 22 1277 4 33.882 113.614 2021-01-24 05:22:35 Henan, China
901406 2021-01-23 China Hong Kong     10009 168 8998 843 22.3 114.2 2021-01-24 05:22:35 Hong Kong, China
901407 2021-01-23 China Hubei     68150 4512 63637 1 30.9756 112.2707 2021-01-24 05:22:35 Hubei, China
901408 2021-01-23 China Hunan     1027 4 1017 6 27.6104 111.7088 2021-01-24 05:22:35 Hunan, China
901409 2021-01-23 China Inner Mongolia     366 1 351 14 44.0935 113.9448 2021-01-24 05:22:35 Inner Mongolia, China
901410 2021-01-23 China Jiangsu     691 0 685 6 32.9711 119.455 2021-01-24 05:22:35 Jiangsu, China
901411 2021-01-23 China Jiangxi     935 1 934 0 27.614 115.7221 2021-01-24 05:22:35 Jiangxi, China
901412 2021-01-23 China Jilin     363 2 155 206 43.6661 126.1923 2021-01-24 05:22:35 Jilin, China
901413 2021-01-23 China Liaoning     397 2 376 19 41.2956 122.6085 2021-01-24 05:22:35 Liaoning, China
901414 2021-01-23 China Macau     47 0 46 1 22.1667 113.55 2021-01-24 05:22:35 Macau, China
901415 2021-01-23 China Ningxia     75 0 75 0 37.2692 106.1655 2021-01-24 05:22:35 Ningxia, China
901416 2021-01-23 China Qinghai     18 0 18 0 35.7452 95.9956 2021-01-24 05:22:35 Qinghai, China
901417 2021-01-23 China Shaanxi     534 3 505 26 35.1917 108.8701 2021-01-24 05:22:35 Shaanxi, China
901418 2021-01-23 China Shandong     866 7 856 3 36.3427 118.1498 2021-01-24 05:22:35 Shandong, China
901419 2021-01-23 China Shanghai     1641 7 1523 111 31.202 121.4491 2021-01-24 05:22:35 Shanghai, China
901420 2021-01-23 China Shanxi     237 0 224 13 37.5777 112.2922 2021-01-24 05:22:35 Shanxi, China
901421 2021-01-23 China Sichuan     866 3 852 11 30.6171 102.7103 2021-01-24 05:22:35 Sichuan, China
901422 2021-01-23 China Tianjin     336 3 309 24 39.3054 117.323 2021-01-24 05:22:35 Tianjin, China
901423 2021-01-23 China Tibet     1 0 1 0 31.6927 88.0924 2021-01-24 05:22:35 Tibet, China
901424 2021-01-23 China Xinjiang     980 3 977 0 41.1129 85.2401 2021-01-24 05:22:35 Xinjiang, China
901425 2021-01-23 China Yunnan     231 2 228 1 24.974 101.487 2021-01-24 05:22:35 Yunnan, China
901426 2021-01-23 China Zhejiang     1316 1 1305 10 29.1832 120.0934 2021-01-24 05:22:35 Zhejiang, China
89479 2021-01-22 China Anhui     994 6 987 1 31.8257 117.2264 2021-01-23 05:22:03 Anhui, China
89480 2021-01-22 China Beijing     1023 9 965 49 40.1824 116.4142 2021-01-23 05:22:03 Beijing, China
89481 2021-01-22 China Chongqing     591 6 584 1 30.0572 107.874 2021-01-23 05:22:03 Chongqing, China
89482 2021-01-22 China Fujian     534 1 515 18 26.0789 117.9874 2021-01-23 05:22:03 Fujian, China
89483 2021-01-22 China Gansu     182 2 180 0 35.7518 104.2861 2021-01-23 05:22:03 Gansu, China
89484 2021-01-22 China Guangdong     2099 8 2052 39 23.3417 113.4244 2021-01-23 05:22:03 Guangdong, China
89485 2021-01-22 China Guangxi     267 2 262 3 23.8298 108.7881 2021-01-23 05:22:03 Guangxi, China
89486 2021-01-22 China Guizhou     147 2 145 0 26.8154 106.8748 2021-01-23 05:22:03 Guizhou, China
89487 2021-01-22 China Hainan     171 6 165 0 19.1959 109.7453 2021-01-23 05:22:03 Hainan, China
89488 2021-01-22 China Hebei     1264 7 422 835 37.8957 114.9042 2021-01-23 05:22:03 Hebei, China
89489 2021-01-22 China Heilongjiang     1330 13 957 360 47.862 127.7615 2021-01-23 05:22:03 Heilongjiang, China
89490 2021-01-22 China Henan     1303 22 1277 4 33.882 113.614 2021-01-23 05:22:03 Henan, China
89491 2021-01-22 China Hong Kong     9928 168 8948 812 22.3 114.2 2021-01-23 05:22:03 Hong Kong, China
89492 2021-01-22 China Hubei     68150 4512 63637 1 30.9756 112.2707 2021-01-23 05:22:03 Hubei, China
89493 2021-01-22 China Hunan     1027 4 1017 6 27.6104 111.7088 2021-01-23 05:22:03 Hunan, China
89494 2021-01-22 China Inner Mongolia     366 1 351 14 44.0935 113.9448 2021-01-23 05:22:03 Inner Mongolia, China
89495 2021-01-22 China Jiangsu     690 0 685 5 32.9711 119.455 2021-01-23 05:22:03 Jiangsu, China
89496 2021-01-22 China Jiangxi     935 1 934 0 27.614 115.7221 2021-01-23 05:22:03 Jiangxi, China
89497 2021-01-22 China Jilin     351 2 155 194 43.6661 126.1923 2021-01-23 05:22:03 Jilin, China
89498 2021-01-22 China Liaoning     396 2 374 20 41.2956 122.6085 2021-01-23 05:22:03 Liaoning, China
89499 2021-01-22 China Macau     47 0 46 1 22.1667 113.55 2021-01-23 05:22:03 Macau, China
89500 2021-01-22 China Ningxia     75 0 75 0 37.2692 106.1655 2021-01-23 05:22:03 Ningxia, China
89501 2021-01-22 China Qinghai     18 0 18 0 35.7452 95.9956 2021-01-23 05:22:03 Qinghai, China
89502 2021-01-22 China Shaanxi     533 3 505 25 35.1917 108.8701 2021-01-23 05:22:03 Shaanxi, China
89503 2021-01-22 China Shandong     866 7 856 3 36.3427 118.1498 2021-01-23 05:22:03 Shandong, China
89504 2021-01-22 China Shanghai     1635 7 1518 110 31.202 121.4491 2021-01-23 05:22:03 Shanghai, China
89505 2021-01-22 China Shanxi     235 0 224 11 37.5777 112.2922 2021-01-23 05:22:03 Shanxi, China
89506 2021-01-22 China Sichuan     866 3 852 11 30.6171 102.7103 2021-01-23 05:22:03 Sichuan, China
89507 2021-01-22 China Tianjin     335 3 309 23 39.3054 117.323 2021-01-23 05:22:03 Tianjin, China
89508 2021-01-22 China Tibet     1 0 1 0 31.6927 88.0924 2021-01-23 05:22:03 Tibet, China
89509 2021-01-22 China Xinjiang     980 3 977 0 41.1129 85.2401 2021-01-23 05:22:03 Xinjiang, China
89510 2021-01-22 China Yunnan     231 2 228 1 24.974 101.487 2021-01-23 05:22:03 Yunnan, China
89511 2021-01-22 China Zhejiang     1316 1 1305 10 29.1832 120.0934 2021-01-23 05:22:03 Zhejiang, China
302385 2021-01-21 China Anhui     994 6 987 0 31.8257 117.2264 2021-01-22 05:22:10 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
);
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]);