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

34,865 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 · 34,865 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2752686 2752686 2022-12-29 China Anhui     1700 6 0   31.8257 117.2264 2022-12-30 04:21:04 Anhui, China
2752687 2752687 2022-12-29 China Beijing     28860 20 0   40.1824 116.4142 2022-12-30 04:21:04 Beijing, China
2752688 2752688 2022-12-29 China Chongqing     10181 7 0   30.0572 107.874 2022-12-30 04:21:04 Chongqing, China
2752689 2752689 2022-12-29 China Fujian     7651 1 0   26.0789 117.9874 2022-12-30 04:21:04 Fujian, China
2752690 2752690 2022-12-29 China Gansu     1563 2 0   35.7518 104.2861 2022-12-30 04:21:04 Gansu, China
2752691 2752691 2022-12-29 China Guangdong     63739 8 0   23.3417 113.4244 2022-12-30 04:21:04 Guangdong, China
2752692 2752692 2022-12-29 China Guangxi     2457 2 0   23.8298 108.7881 2022-12-30 04:21:04 Guangxi, China
2752693 2752693 2022-12-29 China Guizhou     1794 2 0   26.8154 106.8748 2022-12-30 04:21:04 Guizhou, China
2752694 2752694 2022-12-29 China Hainan     10436 6 0   19.1959 109.7453 2022-12-30 04:21:04 Hainan, China
2752695 2752695 2022-12-29 China Hebei     2943 7 0   37.8957 114.9042 2022-12-30 04:21:04 Hebei, China
2752696 2752696 2022-12-29 China Heilongjiang     5493 13 0   47.862 127.7615 2022-12-30 04:21:04 Heilongjiang, China
2752697 2752697 2022-12-29 China Henan     9089 23 0   33.882 113.614 2022-12-30 04:21:04 Henan, China
2752698 2752698 2022-12-29 China Hong Kong     2568596 11683 0   22.3 114.2 2022-12-30 04:21:04 Hong Kong, China
2752699 2752699 2022-12-29 China Hubei     68861 4512 0   30.9756 112.2707 2022-12-30 04:21:04 Hubei, China
2752700 2752700 2022-12-29 China Hunan     2983 4 0   27.6104 111.7088 2022-12-30 04:21:04 Hunan, China
2752701 2752701 2022-12-29 China Inner Mongolia     8394 1 0   44.0935 113.9448 2022-12-30 04:21:04 Inner Mongolia, China
2752702 2752702 2022-12-29 China Jiangsu     3808 0 0   32.9711 119.455 2022-12-30 04:21:04 Jiangsu, China
2752703 2752703 2022-12-29 China Jiangxi     1971 1 0   27.614 115.7221 2022-12-30 04:21:04 Jiangxi, China
2752704 2752704 2022-12-29 China Jilin     40485 5 0   43.6661 126.1923 2022-12-30 04:21:04 Jilin, China
2752705 2752705 2022-12-29 China Liaoning     3086 2 0   41.2956 122.6085 2022-12-30 04:21:04 Liaoning, China
2752706 2752706 2022-12-29 China Macau     1569 13 0   22.1667 113.55 2022-12-30 04:21:04 Macau, China
2752707 2752707 2022-12-29 China Ningxia     239 0 0   37.2692 106.1655 2022-12-30 04:21:04 Ningxia, China
2752708 2752708 2022-12-29 China Qinghai     542 0 0   35.7452 95.9956 2022-12-30 04:21:04 Qinghai, China
2752709 2752709 2022-12-29 China Shaanxi     5589 3 0   35.1917 108.8701 2022-12-30 04:21:04 Shaanxi, China
2752710 2752710 2022-12-29 China Shandong     4797 8 0   36.3427 118.1498 2022-12-30 04:21:04 Shandong, China
2752711 2752711 2022-12-29 China Shanghai     65423 595 0   31.202 121.4491 2022-12-30 04:21:04 Shanghai, China
2752712 2752712 2022-12-29 China Shanxi     5142 0 0   37.5777 112.2922 2022-12-30 04:21:04 Shanxi, China
2752713 2752713 2022-12-29 China Sichuan     12023 5 0   30.6171 102.7103 2022-12-30 04:21:04 Sichuan, China
2752714 2752714 2022-12-29 China Tianjin     2913 3 0   39.3054 117.323 2022-12-30 04:21:04 Tianjin, China
2752715 2752715 2022-12-29 China Tibet     1515 0 0   31.6927 88.0924 2022-12-30 04:21:04 Tibet, China
2752716 2752716 2022-12-29 China Unknown     1521800 0 0       2022-12-30 04:21:04 Unknown, China
2752717 2752717 2022-12-29 China Xinjiang     2632 3 0   41.1129 85.2401 2022-12-30 04:21:04 Xinjiang, China
2752718 2752718 2022-12-29 China Yunnan     5561 2 0   24.974 101.487 2022-12-30 04:21:04 Yunnan, China
2752719 2752719 2022-12-29 China Zhejiang     6235 1 0   29.1832 120.0934 2022-12-30 04:21:04 Zhejiang, China
1073692 1073692 2022-12-28 China Anhui     1700 6 0   31.8257 117.2264 2022-12-29 04:21:01 Anhui, China
1073693 1073693 2022-12-28 China Beijing     28860 20 0   40.1824 116.4142 2022-12-29 04:21:01 Beijing, China
1073694 1073694 2022-12-28 China Chongqing     10181 7 0   30.0572 107.874 2022-12-29 04:21:01 Chongqing, China
1073695 1073695 2022-12-28 China Fujian     7651 1 0   26.0789 117.9874 2022-12-29 04:21:01 Fujian, China
1073696 1073696 2022-12-28 China Gansu     1563 2 0   35.7518 104.2861 2022-12-29 04:21:01 Gansu, China
1073697 1073697 2022-12-28 China Guangdong     63739 8 0   23.3417 113.4244 2022-12-29 04:21:01 Guangdong, China
1073698 1073698 2022-12-28 China Guangxi     2457 2 0   23.8298 108.7881 2022-12-29 04:21:01 Guangxi, China
1073699 1073699 2022-12-28 China Guizhou     1794 2 0   26.8154 106.8748 2022-12-29 04:21:01 Guizhou, China
1073700 1073700 2022-12-28 China Hainan     10436 6 0   19.1959 109.7453 2022-12-29 04:21:01 Hainan, China
1073701 1073701 2022-12-28 China Hebei     2943 7 0   37.8957 114.9042 2022-12-29 04:21:01 Hebei, China
1073702 1073702 2022-12-28 China Heilongjiang     5493 13 0   47.862 127.7615 2022-12-29 04:21:01 Heilongjiang, China
1073703 1073703 2022-12-28 China Henan     9089 23 0   33.882 113.614 2022-12-29 04:21:01 Henan, China
1073704 1073704 2022-12-28 China Hong Kong     2543701 11621 0   22.3 114.2 2022-12-29 04:21:01 Hong Kong, China
1073705 1073705 2022-12-28 China Hubei     68861 4512 0   30.9756 112.2707 2022-12-29 04:21:01 Hubei, China
1073706 1073706 2022-12-28 China Hunan     2983 4 0   27.6104 111.7088 2022-12-29 04:21:01 Hunan, China
1073707 1073707 2022-12-28 China Inner Mongolia     8394 1 0   44.0935 113.9448 2022-12-29 04:21:01 Inner Mongolia, China
1073708 1073708 2022-12-28 China Jiangsu     3808 0 0   32.9711 119.455 2022-12-29 04:21:01 Jiangsu, China
1073709 1073709 2022-12-28 China Jiangxi     1971 1 0   27.614 115.7221 2022-12-29 04:21:01 Jiangxi, China
1073710 1073710 2022-12-28 China Jilin     40485 5 0   43.6661 126.1923 2022-12-29 04:21:01 Jilin, China
1073711 1073711 2022-12-28 China Liaoning     3086 2 0   41.2956 122.6085 2022-12-29 04:21:01 Liaoning, China
1073712 1073712 2022-12-28 China Macau     1569 13 0   22.1667 113.55 2022-12-29 04:21:01 Macau, China
1073713 1073713 2022-12-28 China Ningxia     239 0 0   37.2692 106.1655 2022-12-29 04:21:01 Ningxia, China
1073714 1073714 2022-12-28 China Qinghai     542 0 0   35.7452 95.9956 2022-12-29 04:21:01 Qinghai, China
1073715 1073715 2022-12-28 China Shaanxi     5589 3 0   35.1917 108.8701 2022-12-29 04:21:01 Shaanxi, China
1073716 1073716 2022-12-28 China Shandong     4797 8 0   36.3427 118.1498 2022-12-29 04:21:01 Shandong, China
1073717 1073717 2022-12-28 China Shanghai     65423 595 0   31.202 121.4491 2022-12-29 04:21:01 Shanghai, China
1073718 1073718 2022-12-28 China Shanxi     5142 0 0   37.5777 112.2922 2022-12-29 04:21:01 Shanxi, China
1073719 1073719 2022-12-28 China Sichuan     12023 5 0   30.6171 102.7103 2022-12-29 04:21:01 Sichuan, China
1073720 1073720 2022-12-28 China Tianjin     2913 3 0   39.3054 117.323 2022-12-29 04:21:01 Tianjin, China
1073721 1073721 2022-12-28 China Tibet     1515 0 0   31.6927 88.0924 2022-12-29 04:21:01 Tibet, China
1073722 1073722 2022-12-28 China Unknown     1521800 0 0       2022-12-29 04:21:01 Unknown, China
1073723 1073723 2022-12-28 China Xinjiang     2632 3 0   41.1129 85.2401 2022-12-29 04:21:01 Xinjiang, China
1073724 1073724 2022-12-28 China Yunnan     5561 2 0   24.974 101.487 2022-12-29 04:21:01 Yunnan, China
1073725 1073725 2022-12-28 China Zhejiang     6235 1 0   29.1832 120.0934 2022-12-29 04:21:01 Zhejiang, China
327689 327689 2022-12-27 China Anhui     1700 6 0   31.8257 117.2264 2022-12-28 04:21:04 Anhui, China
327690 327690 2022-12-27 China Beijing     28860 20 0   40.1824 116.4142 2022-12-28 04:21:04 Beijing, China
327691 327691 2022-12-27 China Chongqing     10181 7 0   30.0572 107.874 2022-12-28 04:21:04 Chongqing, China
327692 327692 2022-12-27 China Fujian     7651 1 0   26.0789 117.9874 2022-12-28 04:21:04 Fujian, China
327693 327693 2022-12-27 China Gansu     1563 2 0   35.7518 104.2861 2022-12-28 04:21:04 Gansu, China
327694 327694 2022-12-27 China Guangdong     63739 8 0   23.3417 113.4244 2022-12-28 04:21:04 Guangdong, China
327695 327695 2022-12-27 China Guangxi     2457 2 0   23.8298 108.7881 2022-12-28 04:21:04 Guangxi, China
327696 327696 2022-12-27 China Guizhou     1794 2 0   26.8154 106.8748 2022-12-28 04:21:04 Guizhou, China
327697 327697 2022-12-27 China Hainan     10436 6 0   19.1959 109.7453 2022-12-28 04:21:04 Hainan, China
327698 327698 2022-12-27 China Hebei     2943 7 0   37.8957 114.9042 2022-12-28 04:21:04 Hebei, China
327699 327699 2022-12-27 China Heilongjiang     5493 13 0   47.862 127.7615 2022-12-28 04:21:04 Heilongjiang, China
327700 327700 2022-12-27 China Henan     9089 23 0   33.882 113.614 2022-12-28 04:21:04 Henan, China
327701 327701 2022-12-27 China Hong Kong     2522836 11562 0   22.3 114.2 2022-12-28 04:21:04 Hong Kong, China
327702 327702 2022-12-27 China Hubei     68861 4512 0   30.9756 112.2707 2022-12-28 04:21:04 Hubei, China
327703 327703 2022-12-27 China Hunan     2983 4 0   27.6104 111.7088 2022-12-28 04:21:04 Hunan, China
327704 327704 2022-12-27 China Inner Mongolia     8394 1 0   44.0935 113.9448 2022-12-28 04:21:04 Inner Mongolia, China
327705 327705 2022-12-27 China Jiangsu     3808 0 0   32.9711 119.455 2022-12-28 04:21:04 Jiangsu, China
327706 327706 2022-12-27 China Jiangxi     1971 1 0   27.614 115.7221 2022-12-28 04:21:04 Jiangxi, China
327707 327707 2022-12-27 China Jilin     40485 5 0   43.6661 126.1923 2022-12-28 04:21:04 Jilin, China
327708 327708 2022-12-27 China Liaoning     3086 2 0   41.2956 122.6085 2022-12-28 04:21:04 Liaoning, China
327709 327709 2022-12-27 China Macau     1569 13 0   22.1667 113.55 2022-12-28 04:21:04 Macau, China
327710 327710 2022-12-27 China Ningxia     239 0 0   37.2692 106.1655 2022-12-28 04:21:04 Ningxia, China
327711 327711 2022-12-27 China Qinghai     542 0 0   35.7452 95.9956 2022-12-28 04:21:04 Qinghai, China
327712 327712 2022-12-27 China Shaanxi     5589 3 0   35.1917 108.8701 2022-12-28 04:21:04 Shaanxi, China
327713 327713 2022-12-27 China Shandong     4797 8 0   36.3427 118.1498 2022-12-28 04:21:04 Shandong, China
327714 327714 2022-12-27 China Shanghai     65423 595 0   31.202 121.4491 2022-12-28 04:21:04 Shanghai, China
327715 327715 2022-12-27 China Shanxi     5142 0 0   37.5777 112.2922 2022-12-28 04:21:04 Shanxi, China
327716 327716 2022-12-27 China Sichuan     12023 5 0   30.6171 102.7103 2022-12-28 04:21:04 Sichuan, China
327717 327717 2022-12-27 China Tianjin     2913 3 0   39.3054 117.323 2022-12-28 04:21:04 Tianjin, China
327718 327718 2022-12-27 China Tibet     1515 0 0   31.6927 88.0924 2022-12-28 04:21:04 Tibet, China
327719 327719 2022-12-27 China Unknown     1521800 0 0       2022-12-28 04:21:04 Unknown, China
327720 327720 2022-12-27 China Xinjiang     2632 3 0   41.1129 85.2401 2022-12-28 04:21:04 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] TEXT,
   [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]);