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

1,517 rows where country_or_region = "Mainland 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

  • Mainland China · 1,517 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2283070 2283070 2020-03-12 Mainland China Gansu     0 0 0   36.0611 103.8343 2020-03-11T02:18:28  
2283071 2283071 2020-03-12 Mainland China Hebei     0 0 0   38.0428 114.5149 2020-03-11T02:18:29  
2127635 2127635 2020-03-11 Mainland China Gansu     0 0 0   36.0611 103.8343 2020-03-11T02:18:28  
2127636 2127636 2020-03-11 Mainland China Hebei     0 0 0   38.0428 114.5149 2020-03-11T02:18:29  
3752814 3752814 2020-03-10 Mainland China Hubei     67760 3024 47743   30.9756 112.2707 2020-03-10T15:13:05  
3752821 3752821 2020-03-10 Mainland China Guangdong     1353 8 1274   23.3417 113.4244 2020-03-10T09:13:07  
3752822 3752822 2020-03-10 Mainland China Henan     1272 22 1247   33.882 113.614 2020-03-08T05:03:02  
3752823 3752823 2020-03-10 Mainland China Zhejiang     1215 1 1191   29.1832 120.0934 2020-03-10T10:33:02  
3752824 3752824 2020-03-10 Mainland China Hunan     1018 4 990   27.6104 111.7088 2020-03-10T08:33:02  
3752825 3752825 2020-03-10 Mainland China Anhui     990 6 984   31.8257 117.2264 2020-03-08T05:13:06  
3752826 3752826 2020-03-10 Mainland China Jiangxi     935 1 927   27.614 115.7221 2020-03-10T01:33:02  
3752827 3752827 2020-03-10 Mainland China Shandong     758 6 719   36.3427 118.1498 2020-03-10T07:33:03  
3752829 3752829 2020-03-10 Mainland China Jiangsu     631 0 627   32.9711 119.455 2020-03-10T08:13:08  
3752831 3752831 2020-03-10 Mainland China Chongqing     576 6 547   30.0572 107.874 2020-03-10T23:53:02  
3752832 3752832 2020-03-10 Mainland China Sichuan     539 3 478   30.6171 102.7103 2020-03-10T10:13:17  
3752834 3752834 2020-03-10 Mainland China Heilongjiang     481 13 434   47.862 127.7615 2020-03-10T00:13:18  
3752835 3752835 2020-03-10 Mainland China Beijing     429 8 320   40.1824 116.4142 2020-03-10T01:13:07  
3752840 3752840 2020-03-10 Mainland China Shanghai     344 3 319   31.202 121.4491 2020-03-10T06:13:14  
3752841 3752841 2020-03-10 Mainland China Hebei     318 6 307   38.0428 114.5149 2020-03-07T13:03:05  
3752842 3752842 2020-03-10 Mainland China Fujian     296 1 295   26.0789 117.9874 2020-03-07T13:03:05  
3752846 3752846 2020-03-10 Mainland China Guangxi     252 2 234   23.8298 108.7881 2020-03-10T00:53:02  
3752847 3752847 2020-03-10 Mainland China Shaanxi     245 1 227   35.1917 108.8701 2020-03-10T08:53:02  
3752849 3752849 2020-03-10 Mainland China Yunnan     174 2 170   24.974 101.487 2020-03-06T03:23:06  
3752851 3752851 2020-03-10 Mainland China Hainan     168 6 159   19.1959 109.7453 2020-03-08T04:33:02  
3752853 3752853 2020-03-10 Mainland China Guizhou     146 2 129   26.8154 106.8748 2020-03-10T01:13:07  
3752855 3752855 2020-03-10 Mainland China Tianjin     136 3 131   39.3054 117.323 2020-03-10T10:13:25  
3752856 3752856 2020-03-10 Mainland China Shanxi     133 0 131   37.5777 112.2922 2020-03-10T23:53:02  
3752857 3752857 2020-03-10 Mainland China Gansu     125 2 88   36.0611 103.8343 2020-03-10T14:33:13  
3752858 3752858 2020-03-10 Mainland China Liaoning     125 1 111   41.2956 122.6085 2020-03-10T04:13:09  
3752861 3752861 2020-03-10 Mainland China Jilin     93 1 91   43.6661 126.1923 2020-03-09T14:33:03  
3752864 3752864 2020-03-10 Mainland China Xinjiang     76 3 73   41.1129 85.2401 2020-03-08T05:33:02  
3752865 3752865 2020-03-10 Mainland China Inner Mongolia     75 1 70   44.0935 113.9448 2020-03-08T05:13:06  
3752866 3752866 2020-03-10 Mainland China Ningxia     75 0 71   37.2692 106.1655 2020-03-06T12:53:03  
3752900 3752900 2020-03-10 Mainland China Qinghai     18 0 18   35.7452 95.9956 2020-02-21T04:43:02  
3752991 3752991 2020-03-10 Mainland China Tibet     1 0 1   31.6927 88.0924 2020-02-12T06:43:02  
657683 657683 2020-03-09 Mainland China Hubei     67743 3008 46488   30.9756 112.2707 2020-03-09T14:33:03  
657687 657687 2020-03-09 Mainland China Guangdong     1352 8 1260   23.3417 113.4244 2020-03-09T01:43:01  
657688 657688 2020-03-09 Mainland China Henan     1272 22 1247   33.882 113.614 2020-03-08T05:03:02  
657689 657689 2020-03-09 Mainland China Zhejiang     1215 1 1176   29.1832 120.0934 2020-03-09T09:43:03  
657693 657693 2020-03-09 Mainland China Hunan     1018 4 979   27.6104 111.7088 2020-03-09T01:33:06  
657694 657694 2020-03-09 Mainland China Anhui     990 6 984   31.8257 117.2264 2020-03-08T05:13:06  
657695 657695 2020-03-09 Mainland China Jiangxi     935 1 923   27.614 115.7221 2020-03-09T01:53:01  
657696 657696 2020-03-09 Mainland China Shandong     758 6 700   36.3427 118.1498 2020-03-09T10:13:06  
657698 657698 2020-03-09 Mainland China Jiangsu     631 0 621   32.9711 119.455 2020-03-09T08:53:03  
657699 657699 2020-03-09 Mainland China Chongqing     576 6 542   30.0572 107.874 2020-03-09T23:13:03  
657700 657700 2020-03-09 Mainland China Sichuan     539 3 466   30.6171 102.7103 2020-03-09T08:53:03  
657702 657702 2020-03-09 Mainland China Heilongjiang     481 13 430   47.862 127.7615 2020-03-09T14:33:03  
657703 657703 2020-03-09 Mainland China Beijing     428 8 315   40.1824 116.4142 2020-03-09T01:53:01  
657705 657705 2020-03-09 Mainland China Shanghai     342 3 315   31.202 121.4491 2020-03-09T04:03:11  
657708 657708 2020-03-09 Mainland China Hebei     318 6 307   38.0428 114.5149 2020-03-07T13:03:05  
657709 657709 2020-03-09 Mainland China Fujian     296 1 295   26.0789 117.9874 2020-03-07T13:03:05  
657710 657710 2020-03-09 Mainland China Guangxi     252 2 230   23.8298 108.7881 2020-03-09T00:23:09  
657712 657712 2020-03-09 Mainland China Shaanxi     245 1 227   35.1917 108.8701 2020-03-08T14:43:03  
657715 657715 2020-03-09 Mainland China Yunnan     174 2 170   24.974 101.487 2020-03-06T03:23:06  
657716 657716 2020-03-09 Mainland China Hainan     168 6 159   19.1959 109.7453 2020-03-08T04:33:02  
657718 657718 2020-03-09 Mainland China Guizhou     146 2 123   26.8154 106.8748 2020-03-09T01:13:05  
657719 657719 2020-03-09 Mainland China Tianjin     136 3 130   39.3054 117.323 2020-03-09T10:13:06  
657720 657720 2020-03-09 Mainland China Shanxi     133 0 127   37.5777 112.2922 2020-03-09T11:43:02  
657722 657722 2020-03-09 Mainland China Liaoning     125 1 109   41.2956 122.6085 2020-03-08T05:13:06  
657723 657723 2020-03-09 Mainland China Gansu     124 2 88   36.0611 103.8343 2020-03-09T14:33:03  
657727 657727 2020-03-09 Mainland China Jilin     93 1 91   43.6661 126.1923 2020-03-09T14:33:03  
657730 657730 2020-03-09 Mainland China Xinjiang     76 3 73   41.1129 85.2401 2020-03-08T05:33:02  
657731 657731 2020-03-09 Mainland China Inner Mongolia     75 1 70   44.0935 113.9448 2020-03-08T05:13:06  
657732 657732 2020-03-09 Mainland China Ningxia     75 0 71   37.2692 106.1655 2020-03-06T12:53:03  
657763 657763 2020-03-09 Mainland China Qinghai     18 0 18   35.7452 95.9956 2020-02-21T04:43:02  
657876 657876 2020-03-09 Mainland China Tibet     1 0 1   31.6927 88.0924 2020-02-12T06:43:02  
1527199 1527199 2020-03-08 Mainland China Hubei     67707 2986 45235   30.9756 112.2707 2020-03-08T14:43:03  
1527203 1527203 2020-03-08 Mainland China Guangdong     1352 7 1256   23.3417 113.4244 2020-03-08T14:43:03  
1527204 1527204 2020-03-08 Mainland China Henan     1272 22 1247   33.882 113.614 2020-03-08T05:03:02  
1527205 1527205 2020-03-08 Mainland China Zhejiang     1215 1 1161   29.1832 120.0934 2020-03-08T09:03:04  
1527208 1527208 2020-03-08 Mainland China Hunan     1018 4 968   27.6104 111.7088 2020-03-08T12:53:03  
1527209 1527209 2020-03-08 Mainland China Anhui     990 6 984   31.8257 117.2264 2020-03-08T05:13:06  
1527210 1527210 2020-03-08 Mainland China Jiangxi     935 1 919   27.614 115.7221 2020-03-08T06:53:04  
1527211 1527211 2020-03-08 Mainland China Shandong     758 6 642   36.3427 118.1498 2020-03-08T10:03:11  
1527214 1527214 2020-03-08 Mainland China Jiangsu     631 0 612   32.9711 119.455 2020-03-08T09:23:05  
1527215 1527215 2020-03-08 Mainland China Chongqing     576 6 527   30.0572 107.874 2020-03-08T23:23:03  
1527216 1527216 2020-03-08 Mainland China Sichuan     539 3 464   30.6171 102.7103 2020-03-08T12:53:03  
1527218 1527218 2020-03-08 Mainland China Heilongjiang     481 13 412   47.862 127.7615 2020-03-08T14:43:03  
1527219 1527219 2020-03-08 Mainland China Beijing     428 8 308   40.1824 116.4142 2020-03-08T01:23:07  
1527220 1527220 2020-03-08 Mainland China Shanghai     342 3 314   31.202 121.4491 2020-03-08T04:33:02  
1527222 1527222 2020-03-08 Mainland China Hebei     318 6 307   38.0428 114.5149 2020-03-07T13:03:05  
1527223 1527223 2020-03-08 Mainland China Fujian     296 1 295   26.0789 117.9874 2020-03-07T13:03:05  
1527226 1527226 2020-03-08 Mainland China Guangxi     252 2 223   23.8298 108.7881 2020-03-08T00:23:02  
1527227 1527227 2020-03-08 Mainland China Shaanxi     245 1 227   35.1917 108.8701 2020-03-08T14:43:03  
1527231 1527231 2020-03-08 Mainland China Yunnan     174 2 170   24.974 101.487 2020-03-06T03:23:06  
1527232 1527232 2020-03-08 Mainland China Hainan     168 6 159   19.1959 109.7453 2020-03-08T04:33:02  
1527234 1527234 2020-03-08 Mainland China Guizhou     146 2 117   26.8154 106.8748 2020-03-08T01:13:11  
1527235 1527235 2020-03-08 Mainland China Tianjin     136 3 128   39.3054 117.323 2020-03-05T03:33:27  
1527236 1527236 2020-03-08 Mainland China Shanxi     133 0 126   37.5777 112.2922 2020-03-05T14:53:03  
1527237 1527237 2020-03-08 Mainland China Liaoning     125 1 109   41.2956 122.6085 2020-03-08T05:13:06  
1527238 1527238 2020-03-08 Mainland China Gansu     124 2 87   36.0611 103.8343 2020-03-08T14:33:06  
1527241 1527241 2020-03-08 Mainland China Jilin     93 1 90   43.6661 126.1923 2020-03-06T10:23:03  
1527245 1527245 2020-03-08 Mainland China Xinjiang     76 3 73   41.1129 85.2401 2020-03-08T05:33:02  
1527246 1527246 2020-03-08 Mainland China Inner Mongolia     75 1 70   44.0935 113.9448 2020-03-08T05:13:06  
1527247 1527247 2020-03-08 Mainland China Ningxia     75 0 71   37.2692 106.1655 2020-03-06T12:53:03  
1527277 1527277 2020-03-08 Mainland China Qinghai     18 0 18   35.7452 95.9956 2020-02-21T04:43:02  
1527383 1527383 2020-03-08 Mainland China Tibet     1 0 1   31.6927 88.0924 2020-02-12T06:43:02  
62471 62471 2020-03-07 Mainland China Hubei     67666 2959 43500   30.9756 112.2707 2020-03-07T11:13:04  
62475 62475 2020-03-07 Mainland China Guangdong     1352 7 1237   23.3417 113.4244 2020-03-07T10:43:02  
62476 62476 2020-03-07 Mainland China Henan     1272 22 1244   33.882 113.614 2020-03-07T11:23:10  

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]);