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

11,861 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 · 11,861 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
900480 900480 2021-03-04 China Anhui     994 6 988 0 31.8257 117.2264 2021-03-05 05:26:29 Anhui, China
900481 900481 2021-03-04 China Beijing     1049 9 1029 11 40.1824 116.4142 2021-03-05 05:26:29 Beijing, China
900482 900482 2021-03-04 China Chongqing     591 6 585 0 30.0572 107.874 2021-03-05 05:26:29 Chongqing, China
900483 900483 2021-03-04 China Fujian     551 1 546 4 26.0789 117.9874 2021-03-05 05:26:29 Fujian, China
900484 900484 2021-03-04 China Gansu     187 2 185 0 35.7518 104.2861 2021-03-05 05:26:29 Gansu, China
900485 900485 2021-03-04 China Guangdong     2222 8 2167 47 23.3417 113.4244 2021-03-05 05:26:29 Guangdong, China
900486 900486 2021-03-04 China Guangxi     267 2 265 0 23.8298 108.7881 2021-03-05 05:26:29 Guangxi, China
900487 900487 2021-03-04 China Guizhou     147 2 145 0 26.8154 106.8748 2021-03-05 05:26:29 Guizhou, China
900488 900488 2021-03-04 China Hainan     171 6 165 0 19.1959 109.7453 2021-03-05 05:26:29 Hainan, China
900489 900489 2021-03-04 China Hebei     1317 7 1310 0 37.8957 114.9042 2021-03-05 05:26:29 Hebei, China
900490 900490 2021-03-04 China Heilongjiang     1610 13 1597 0 47.862 127.7615 2021-03-05 05:26:29 Heilongjiang, China
900491 900491 2021-03-04 China Henan     1305 22 1281 2 33.882 113.614 2021-03-05 05:26:29 Henan, China
900492 900492 2021-03-04 China Hong Kong     11055 201 10593 261 22.3 114.2 2021-03-05 05:26:29 Hong Kong, China
900493 900493 2021-03-04 China Hubei     68151 4512 63639 0 30.9756 112.2707 2021-03-05 05:26:29 Hubei, China
900494 900494 2021-03-04 China Hunan     1037 4 1027 6 27.6104 111.7088 2021-03-05 05:26:29 Hunan, China
900495 900495 2021-03-04 China Inner Mongolia     367 1 365 1 44.0935 113.9448 2021-03-05 05:26:29 Inner Mongolia, China
900496 900496 2021-03-04 China Jiangsu     704 0 701 3 32.9711 119.455 2021-03-05 05:26:29 Jiangsu, China
900497 900497 2021-03-04 China Jiangxi     935 1 934 0 27.614 115.7221 2021-03-05 05:26:29 Jiangxi, China
900498 900498 2021-03-04 China Jilin     573 3 570 0 43.6661 126.1923 2021-03-05 05:26:29 Jilin, China
900499 900499 2021-03-04 China Liaoning     406 2 402 2 41.2956 122.6085 2021-03-05 05:26:29 Liaoning, China
900500 900500 2021-03-04 China Macau     48 0 47 1 22.1667 113.55 2021-03-05 05:26:29 Macau, China
900501 900501 2021-03-04 China Ningxia     75 0 75 0 37.2692 106.1655 2021-03-05 05:26:29 Ningxia, China
900502 900502 2021-03-04 China Qinghai     18 0 18 0 35.7452 95.9956 2021-03-05 05:26:29 Qinghai, China
900503 900503 2021-03-04 China Shaanxi     553 3 542 8 35.1917 108.8701 2021-03-05 05:26:29 Shaanxi, China
900504 900504 2021-03-04 China Shandong     869 7 861 1 36.3427 118.1498 2021-03-05 05:26:29 Shandong, China
900505 900505 2021-03-04 China Shanghai     1808 7 1763 38 31.202 121.4491 2021-03-05 05:26:29 Shanghai, China
900506 900506 2021-03-04 China Shanxi     240 0 238 2 37.5777 112.2922 2021-03-05 05:26:29 Shanxi, China
900507 900507 2021-03-04 China Sichuan     910 3 877 30 30.6171 102.7103 2021-03-05 05:26:29 Sichuan, China
900508 900508 2021-03-04 China Tianjin     358 3 339 16 39.3054 117.323 2021-03-05 05:26:29 Tianjin, China
900509 900509 2021-03-04 China Tibet     1 0 1 0 31.6927 88.0924 2021-03-05 05:26:29 Tibet, China
900510 900510 2021-03-04 China Unknown     0 0 3 -3     2021-03-05 05:26:29 Unknown, China
900511 900511 2021-03-04 China Xinjiang     980 3 977 0 41.1129 85.2401 2021-03-05 05:26:29 Xinjiang, China
900512 900512 2021-03-04 China Yunnan     234 2 229 3 24.974 101.487 2021-03-05 05:26:29 Yunnan, China
900513 900513 2021-03-04 China Zhejiang     1322 1 1314 7 29.1832 120.0934 2021-03-05 05:26:29 Zhejiang, China
908205 908205 2021-03-03 China Anhui     994 6 988 0 31.8257 117.2264 2021-03-04 05:24:24 Anhui, China
908206 908206 2021-03-03 China Beijing     1049 9 1027 13 40.1824 116.4142 2021-03-04 05:24:24 Beijing, China
908207 908207 2021-03-03 China Chongqing     591 6 585 0 30.0572 107.874 2021-03-04 05:24:24 Chongqing, China
908208 908208 2021-03-03 China Fujian     551 1 546 4 26.0789 117.9874 2021-03-04 05:24:24 Fujian, China
908209 908209 2021-03-03 China Gansu     187 2 185 0 35.7518 104.2861 2021-03-04 05:24:24 Gansu, China
908210 908210 2021-03-03 China Guangdong     2221 8 2166 47 23.3417 113.4244 2021-03-04 05:24:24 Guangdong, China
908211 908211 2021-03-03 China Guangxi     267 2 265 0 23.8298 108.7881 2021-03-04 05:24:24 Guangxi, China
908212 908212 2021-03-03 China Guizhou     147 2 145 0 26.8154 106.8748 2021-03-04 05:24:24 Guizhou, China
908213 908213 2021-03-03 China Hainan     171 6 165 0 19.1959 109.7453 2021-03-04 05:24:24 Hainan, China
908214 908214 2021-03-03 China Hebei     1317 7 1310 0 37.8957 114.9042 2021-03-04 05:24:24 Hebei, China
908215 908215 2021-03-03 China Heilongjiang     1610 13 1597 0 47.862 127.7615 2021-03-04 05:24:24 Heilongjiang, China
908216 908216 2021-03-03 China Henan     1305 22 1281 2 33.882 113.614 2021-03-04 05:24:24 Henan, China
908217 908217 2021-03-03 China Hong Kong     11046 200 10578 268 22.3 114.2 2021-03-04 05:24:24 Hong Kong, China
908218 908218 2021-03-03 China Hubei     68151 4512 63639 0 30.9756 112.2707 2021-03-04 05:24:24 Hubei, China
908219 908219 2021-03-03 China Hunan     1036 4 1027 5 27.6104 111.7088 2021-03-04 05:24:24 Hunan, China
908220 908220 2021-03-03 China Inner Mongolia     367 1 365 1 44.0935 113.9448 2021-03-04 05:24:24 Inner Mongolia, China
908221 908221 2021-03-03 China Jiangsu     704 0 700 4 32.9711 119.455 2021-03-04 05:24:24 Jiangsu, China
908222 908222 2021-03-03 China Jiangxi     935 1 934 0 27.614 115.7221 2021-03-04 05:24:24 Jiangxi, China
908223 908223 2021-03-03 China Jilin     573 3 570 0 43.6661 126.1923 2021-03-04 05:24:24 Jilin, China
908224 908224 2021-03-03 China Liaoning     406 2 402 2 41.2956 122.6085 2021-03-04 05:24:24 Liaoning, China
908225 908225 2021-03-03 China Macau     48 0 47 1 22.1667 113.55 2021-03-04 05:24:24 Macau, China
908226 908226 2021-03-03 China Ningxia     75 0 75 0 37.2692 106.1655 2021-03-04 05:24:24 Ningxia, China
908227 908227 2021-03-03 China Qinghai     18 0 18 0 35.7452 95.9956 2021-03-04 05:24:24 Qinghai, China
908228 908228 2021-03-03 China Shaanxi     553 3 542 8 35.1917 108.8701 2021-03-04 05:24:24 Shaanxi, China
908229 908229 2021-03-03 China Shandong     869 7 860 2 36.3427 118.1498 2021-03-04 05:24:24 Shandong, China
908230 908230 2021-03-03 China Shanghai     1802 7 1761 34 31.202 121.4491 2021-03-04 05:24:24 Shanghai, China
908231 908231 2021-03-03 China Shanxi     240 0 238 2 37.5777 112.2922 2021-03-04 05:24:24 Shanxi, China
908232 908232 2021-03-03 China Sichuan     910 3 876 31 30.6171 102.7103 2021-03-04 05:24:24 Sichuan, China
908233 908233 2021-03-03 China Tianjin     357 3 339 15 39.3054 117.323 2021-03-04 05:24:24 Tianjin, China
908234 908234 2021-03-03 China Tibet     1 0 1 0 31.6927 88.0924 2021-03-04 05:24:24 Tibet, China
908235 908235 2021-03-03 China Unknown     0 0 3 -3     2021-03-04 05:24:24 Unknown, China
908236 908236 2021-03-03 China Xinjiang     980 3 977 0 41.1129 85.2401 2021-03-04 05:24:24 Xinjiang, China
908237 908237 2021-03-03 China Yunnan     234 2 229 3 24.974 101.487 2021-03-04 05:24:24 Yunnan, China
908238 908238 2021-03-03 China Zhejiang     1322 1 1314 7 29.1832 120.0934 2021-03-04 05:24:24 Zhejiang, China
66605 66605 2021-03-02 China Anhui     994 6 988 0 31.8257 117.2264 2021-03-03 05:23:28 Anhui, China
66606 66606 2021-03-02 China Beijing     1049 9 1026 14 40.1824 116.4142 2021-03-03 05:23:28 Beijing, China
66607 66607 2021-03-02 China Chongqing     591 6 585 0 30.0572 107.874 2021-03-03 05:23:28 Chongqing, China
66608 66608 2021-03-02 China Fujian     551 1 546 4 26.0789 117.9874 2021-03-03 05:23:28 Fujian, China
66609 66609 2021-03-02 China Gansu     187 2 185 0 35.7518 104.2861 2021-03-03 05:23:28 Gansu, China
66610 66610 2021-03-02 China Guangdong     2218 8 2162 48 23.3417 113.4244 2021-03-03 05:23:28 Guangdong, China
66611 66611 2021-03-02 China Guangxi     267 2 265 0 23.8298 108.7881 2021-03-03 05:23:28 Guangxi, China
66612 66612 2021-03-02 China Guizhou     147 2 145 0 26.8154 106.8748 2021-03-03 05:23:28 Guizhou, China
66613 66613 2021-03-02 China Hainan     171 6 165 0 19.1959 109.7453 2021-03-03 05:23:28 Hainan, China
66614 66614 2021-03-02 China Hebei     1317 7 1305 5 37.8957 114.9042 2021-03-03 05:23:28 Hebei, China
66615 66615 2021-03-02 China Heilongjiang     1610 13 1597 0 47.862 127.7615 2021-03-03 05:23:28 Heilongjiang, China
66616 66616 2021-03-02 China Henan     1305 22 1281 2 33.882 113.614 2021-03-03 05:23:28 Henan, China
66617 66617 2021-03-02 China Hong Kong     11032 200 10563 269 22.3 114.2 2021-03-03 05:23:28 Hong Kong, China
66618 66618 2021-03-02 China Hubei     68151 4512 63639 0 30.9756 112.2707 2021-03-03 05:23:28 Hubei, China
66619 66619 2021-03-02 China Hunan     1036 4 1027 5 27.6104 111.7088 2021-03-03 05:23:28 Hunan, China
66620 66620 2021-03-02 China Inner Mongolia     367 1 365 1 44.0935 113.9448 2021-03-03 05:23:28 Inner Mongolia, China
66621 66621 2021-03-02 China Jiangsu     704 0 700 4 32.9711 119.455 2021-03-03 05:23:28 Jiangsu, China
66622 66622 2021-03-02 China Jiangxi     935 1 934 0 27.614 115.7221 2021-03-03 05:23:28 Jiangxi, China
66623 66623 2021-03-02 China Jilin     573 3 567 3 43.6661 126.1923 2021-03-03 05:23:28 Jilin, China
66624 66624 2021-03-02 China Liaoning     406 2 402 2 41.2956 122.6085 2021-03-03 05:23:28 Liaoning, China
66625 66625 2021-03-02 China Macau     48 0 47 1 22.1667 113.55 2021-03-03 05:23:28 Macau, China
66626 66626 2021-03-02 China Ningxia     75 0 75 0 37.2692 106.1655 2021-03-03 05:23:28 Ningxia, China
66627 66627 2021-03-02 China Qinghai     18 0 18 0 35.7452 95.9956 2021-03-03 05:23:28 Qinghai, China
66628 66628 2021-03-02 China Shaanxi     553 3 542 8 35.1917 108.8701 2021-03-03 05:23:28 Shaanxi, China
66629 66629 2021-03-02 China Shandong     869 7 860 2 36.3427 118.1498 2021-03-03 05:23:28 Shandong, China
66630 66630 2021-03-02 China Shanghai     1797 7 1757 33 31.202 121.4491 2021-03-03 05:23:28 Shanghai, China
66631 66631 2021-03-02 China Shanxi     240 0 238 2 37.5777 112.2922 2021-03-03 05:23:28 Shanxi, China
66632 66632 2021-03-02 China Sichuan     909 3 875 31 30.6171 102.7103 2021-03-03 05:23:28 Sichuan, China
66633 66633 2021-03-02 China Tianjin     357 3 338 16 39.3054 117.323 2021-03-03 05:23:28 Tianjin, China
66634 66634 2021-03-02 China Tibet     1 0 1 0 31.6927 88.0924 2021-03-03 05:23:28 Tibet, China
66635 66635 2021-03-02 China Unknown     0 0 3 -3     2021-03-03 05:23:28 Unknown, China
66636 66636 2021-03-02 China Xinjiang     980 3 977 0 41.1129 85.2401 2021-03-03 05:23:28 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]);