johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,517 rows where country_or_region = "Mainland China" sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Gansu 48
- Hebei 48
- Fujian 46
- Guangxi 46
- Guizhou 46
- Hainan 46
- Heilongjiang 46
- Henan 46
- Inner Mongolia 46
- Jiangsu 46
- Jiangxi 46
- Jilin 46
- Liaoning 46
- Ningxia 46
- Qinghai 46
- Shaanxi 46
- Shandong 46
- Shanxi 46
- Sichuan 46
- Tianjin 46
- Xinjiang 46
- Yunnan 46
- Anhui 45
- Beijing 45
- Chongqing 45
- Guangdong 45
- Hubei 45
- Hunan 45
- Shanghai 45
- Zhejiang 45
- …
country_or_region 1
- Mainland China · 1,417 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2938940 | 2938940 | 2020-01-25 | Mainland China | Henan | 32 | 0 | 0 | 33.882 | 113.614 | 1/25/20 17:00 | ||||
2938941 | 2938941 | 2020-01-25 | Mainland China | Sichuan | 28 | 0 | 0 | 30.6171 | 102.7103 | 1/25/20 17:00 | ||||
2938942 | 2938942 | 2020-01-25 | Mainland China | Shandong | 27 | 0 | 0 | 36.3427 | 118.1498 | 1/25/20 17:00 | ||||
2938943 | 2938943 | 2020-01-25 | Mainland China | Guangxi | 23 | 0 | 0 | 23.8298 | 108.7881 | 1/25/20 17:00 | ||||
2938944 | 2938944 | 2020-01-25 | Mainland China | Hainan | 19 | 0 | 0 | 19.1959 | 109.7453 | 1/25/20 17:00 | ||||
2938945 | 2938945 | 2020-01-25 | Mainland China | Jiangxi | 18 | 0 | 0 | 27.614 | 115.7221 | 1/25/20 17:00 | ||||
2938946 | 2938946 | 2020-01-25 | Mainland China | Fujian | 18 | 0 | 0 | 26.0789 | 117.9874 | 1/25/20 17:00 | ||||
2938947 | 2938947 | 2020-01-25 | Mainland China | Jiangsu | 18 | 0 | 1 | 32.9711 | 119.455 | 1/25/20 17:00 | ||||
2938948 | 2938948 | 2020-01-25 | Mainland China | Liaoning | 17 | 0 | 0 | 41.2956 | 122.6085 | 1/25/20 17:00 | ||||
2938949 | 2938949 | 2020-01-25 | Mainland China | Shaanxi | 15 | 0 | 0 | 35.1917 | 108.8701 | 1/25/20 17:00 | ||||
2938950 | 2938950 | 2020-01-25 | Mainland China | Yunnan | 11 | 0 | 0 | 24.974 | 101.487 | 1/25/20 17:00 | ||||
2938951 | 2938951 | 2020-01-25 | Mainland China | Tianjin | 10 | 0 | 0 | 39.3054 | 117.323 | 1/25/20 17:00 | ||||
2938952 | 2938952 | 2020-01-25 | Mainland China | Heilongjiang | 9 | 1 | 0 | 47.862 | 127.7615 | 1/25/20 17:00 | ||||
2938953 | 2938953 | 2020-01-25 | Mainland China | Hebei | 8 | 1 | 0 | 38.0428 | 114.5149 | 1/25/20 17:00 | ||||
2938954 | 2938954 | 2020-01-25 | Mainland China | Inner Mongolia | 7 | 0 | 0 | 44.0935 | 113.9448 | 1/25/20 17:00 | ||||
2938955 | 2938955 | 2020-01-25 | Mainland China | Shanxi | 6 | 0 | 0 | 37.5777 | 112.2922 | 1/25/20 17:00 | ||||
2938957 | 2938957 | 2020-01-25 | Mainland China | Guizhou | 4 | 0 | 0 | 26.8154 | 106.8748 | 1/25/20 17:00 | ||||
2938958 | 2938958 | 2020-01-25 | Mainland China | Jilin | 4 | 0 | 0 | 43.6661 | 126.1923 | 1/25/20 17:00 | ||||
2938959 | 2938959 | 2020-01-25 | Mainland China | Gansu | 4 | 0 | 0 | 36.0611 | 103.8343 | 1/25/20 17:00 | ||||
2938960 | 2938960 | 2020-01-25 | Mainland China | Ningxia | 3 | 0 | 0 | 37.2692 | 106.1655 | 1/25/20 17:00 | ||||
2938962 | 2938962 | 2020-01-25 | Mainland China | Xinjiang | 3 | 0 | 0 | 41.1129 | 85.2401 | 1/25/20 17:00 | ||||
2938964 | 2938964 | 2020-01-25 | Mainland China | Qinghai | 1 | 0 | 0 | 35.7452 | 95.9956 | 1/25/20 17:00 | ||||
415831 | 415831 | 2020-01-26 | Mainland China | Hubei | 1058 | 52 | 42 | 30.9756 | 112.2707 | 1/26/20 16:00 | ||||
415832 | 415832 | 2020-01-26 | Mainland China | Guangdong | 111 | 0 | 2 | 23.3417 | 113.4244 | 1/26/20 16:00 | ||||
415833 | 415833 | 2020-01-26 | Mainland China | Zhejiang | 104 | 0 | 1 | 29.1832 | 120.0934 | 1/26/20 16:00 | ||||
415834 | 415834 | 2020-01-26 | Mainland China | Henan | 83 | 1 | 0 | 33.882 | 113.614 | 1/26/20 16:00 | ||||
415835 | 415835 | 2020-01-26 | Mainland China | Chongqing | 75 | 0 | 0 | 30.0572 | 107.874 | 1/26/20 16:00 | ||||
415836 | 415836 | 2020-01-26 | Mainland China | Hunan | 69 | 0 | 0 | 27.6104 | 111.7088 | 1/26/20 16:00 | ||||
415837 | 415837 | 2020-01-26 | Mainland China | Beijing | 68 | 0 | 2 | 40.1824 | 116.4142 | 1/26/20 16:00 | ||||
415838 | 415838 | 2020-01-26 | Mainland China | Anhui | 60 | 0 | 0 | 31.8257 | 117.2264 | 1/26/20 16:00 | ||||
415839 | 415839 | 2020-01-26 | Mainland China | Shandong | 46 | 0 | 0 | 36.3427 | 118.1498 | 1/26/20 16:00 | ||||
415840 | 415840 | 2020-01-26 | Mainland China | Sichuan | 44 | 0 | 0 | 30.6171 | 102.7103 | 1/26/20 16:00 | ||||
415841 | 415841 | 2020-01-26 | Mainland China | Shanghai | 40 | 1 | 1 | 31.202 | 121.4491 | 1/26/20 16:00 | ||||
415842 | 415842 | 2020-01-26 | Mainland China | Guangxi | 36 | 0 | 0 | 23.8298 | 108.7881 | 1/26/20 16:00 | ||||
415843 | 415843 | 2020-01-26 | Mainland China | Jiangxi | 36 | 0 | 0 | 27.614 | 115.7221 | 1/26/20 16:00 | ||||
415844 | 415844 | 2020-01-26 | Mainland China | Fujian | 35 | 0 | 0 | 26.0789 | 117.9874 | 1/26/20 16:00 | ||||
415845 | 415845 | 2020-01-26 | Mainland China | Jiangsu | 33 | 0 | 1 | 32.9711 | 119.455 | 1/26/20 16:00 | ||||
415846 | 415846 | 2020-01-26 | Mainland China | Hainan | 22 | 0 | 0 | 19.1959 | 109.7453 | 1/26/20 16:00 | ||||
415847 | 415847 | 2020-01-26 | Mainland China | Shaanxi | 22 | 0 | 0 | 35.1917 | 108.8701 | 1/26/20 16:00 | ||||
415848 | 415848 | 2020-01-26 | Mainland China | Liaoning | 21 | 0 | 0 | 41.2956 | 122.6085 | 1/26/20 16:00 | ||||
415849 | 415849 | 2020-01-26 | Mainland China | Yunnan | 16 | 0 | 0 | 24.974 | 101.487 | 1/26/20 16:00 | ||||
415850 | 415850 | 2020-01-26 | Mainland China | Heilongjiang | 15 | 1 | 0 | 47.862 | 127.7615 | 1/26/20 16:00 | ||||
415851 | 415851 | 2020-01-26 | Mainland China | Tianjin | 14 | 0 | 0 | 39.3054 | 117.323 | 1/26/20 16:00 | ||||
415852 | 415852 | 2020-01-26 | Mainland China | Hebei | 13 | 1 | 0 | 38.0428 | 114.5149 | 1/26/20 16:00 | ||||
415853 | 415853 | 2020-01-26 | Mainland China | Shanxi | 9 | 0 | 0 | 37.5777 | 112.2922 | 1/26/20 16:00 | ||||
415855 | 415855 | 2020-01-26 | Mainland China | Inner Mongolia | 7 | 0 | 0 | 44.0935 | 113.9448 | 1/26/20 16:00 | ||||
415856 | 415856 | 2020-01-26 | Mainland China | Gansu | 7 | 0 | 0 | 36.0611 | 103.8343 | 1/26/20 16:00 | ||||
415857 | 415857 | 2020-01-26 | Mainland China | Guizhou | 5 | 0 | 0 | 26.8154 | 106.8748 | 1/26/20 16:00 | ||||
415859 | 415859 | 2020-01-26 | Mainland China | Ningxia | 4 | 0 | 0 | 37.2692 | 106.1655 | 1/26/20 16:00 | ||||
415860 | 415860 | 2020-01-26 | Mainland China | Jilin | 4 | 0 | 0 | 43.6661 | 126.1923 | 1/26/20 16:00 | ||||
415862 | 415862 | 2020-01-26 | Mainland China | Xinjiang | 4 | 0 | 0 | 41.1129 | 85.2401 | 1/26/20 16:00 | ||||
415863 | 415863 | 2020-01-26 | Mainland China | Qinghai | 1 | 0 | 0 | 35.7452 | 95.9956 | 1/26/20 16:00 | ||||
3753056 | 3753056 | 2020-01-27 | Mainland China | Hubei | 1423 | 76 | 45 | 30.9756 | 112.2707 | 1/27/20 23:59 | ||||
3753057 | 3753057 | 2020-01-27 | Mainland China | Guangdong | 151 | 0 | 4 | 23.3417 | 113.4244 | 1/27/20 23:59 | ||||
3753058 | 3753058 | 2020-01-27 | Mainland China | Zhejiang | 128 | 0 | 1 | 29.1832 | 120.0934 | 1/27/20 23:59 | ||||
3753059 | 3753059 | 2020-01-27 | Mainland China | Henan | 128 | 1 | 0 | 33.882 | 113.614 | 1/27/20 23:59 | ||||
3753060 | 3753060 | 2020-01-27 | Mainland China | Chongqing | 110 | 0 | 0 | 30.0572 | 107.874 | 1/27/20 23:59 | ||||
3753061 | 3753061 | 2020-01-27 | Mainland China | Hunan | 100 | 0 | 0 | 27.6104 | 111.7088 | 1/27/20 23:59 | ||||
3753062 | 3753062 | 2020-01-27 | Mainland China | Beijing | 80 | 1 | 2 | 40.1824 | 116.4142 | 1/27/20 23:59 | ||||
3753063 | 3753063 | 2020-01-27 | Mainland China | Shandong | 75 | 0 | 0 | 36.3427 | 118.1498 | 1/27/20 23:59 | ||||
3753064 | 3753064 | 2020-01-27 | Mainland China | Jiangxi | 72 | 0 | 2 | 27.614 | 115.7221 | 1/27/20 23:59 | ||||
3753065 | 3753065 | 2020-01-27 | Mainland China | Anhui | 70 | 0 | 0 | 31.8257 | 117.2264 | 1/27/20 23:59 | ||||
3753066 | 3753066 | 2020-01-27 | Mainland China | Sichuan | 69 | 0 | 0 | 30.6171 | 102.7103 | 1/27/20 23:59 | ||||
3753067 | 3753067 | 2020-01-27 | Mainland China | Fujian | 59 | 0 | 0 | 26.0789 | 117.9874 | 1/27/20 23:59 | ||||
3753068 | 3753068 | 2020-01-27 | Mainland China | Shanghai | 53 | 1 | 3 | 31.202 | 121.4491 | 1/27/20 23:59 | ||||
3753069 | 3753069 | 2020-01-27 | Mainland China | Jiangsu | 47 | 0 | 1 | 32.9711 | 119.455 | 1/27/20 23:59 | ||||
3753070 | 3753070 | 2020-01-27 | Mainland China | Guangxi | 46 | 0 | 0 | 23.8298 | 108.7881 | 1/27/20 23:59 | ||||
3753071 | 3753071 | 2020-01-27 | Mainland China | Shaanxi | 35 | 0 | 0 | 35.1917 | 108.8701 | 1/27/20 23:59 | ||||
3753072 | 3753072 | 2020-01-27 | Mainland China | Hainan | 33 | 1 | 0 | 19.1959 | 109.7453 | 1/27/20 23:59 | ||||
3753073 | 3753073 | 2020-01-27 | Mainland China | Liaoning | 27 | 0 | 0 | 41.2956 | 122.6085 | 1/27/20 23:59 | ||||
3753074 | 3753074 | 2020-01-27 | Mainland China | Yunnan | 26 | 0 | 0 | 24.974 | 101.487 | 1/27/20 23:59 | ||||
3753075 | 3753075 | 2020-01-27 | Mainland China | Tianjin | 23 | 0 | 0 | 39.3054 | 117.323 | 1/27/20 23:59 | ||||
3753076 | 3753076 | 2020-01-27 | Mainland China | Heilongjiang | 21 | 1 | 0 | 47.862 | 127.7615 | 1/27/20 23:59 | ||||
3753077 | 3753077 | 2020-01-27 | Mainland China | Hebei | 18 | 1 | 0 | 38.0428 | 114.5149 | 1/27/20 23:59 | ||||
3753078 | 3753078 | 2020-01-27 | Mainland China | Gansu | 14 | 0 | 0 | 36.0611 | 103.8343 | 1/27/20 23:59 | ||||
3753079 | 3753079 | 2020-01-27 | Mainland China | Shanxi | 13 | 0 | 0 | 37.5777 | 112.2922 | 1/27/20 23:59 | ||||
3753080 | 3753080 | 2020-01-27 | Mainland China | Inner Mongolia | 11 | 0 | 0 | 44.0935 | 113.9448 | 1/27/20 23:59 | ||||
3753082 | 3753082 | 2020-01-27 | Mainland China | Guizhou | 7 | 0 | 0 | 26.8154 | 106.8748 | 1/27/20 23:59 | ||||
3753083 | 3753083 | 2020-01-27 | Mainland China | Ningxia | 7 | 0 | 0 | 37.2692 | 106.1655 | 1/27/20 23:59 | ||||
3753084 | 3753084 | 2020-01-27 | Mainland China | Jilin | 6 | 0 | 0 | 43.6661 | 126.1923 | 1/27/20 23:59 | ||||
3753086 | 3753086 | 2020-01-27 | Mainland China | Qinghai | 6 | 0 | 0 | 35.7452 | 95.9956 | 1/27/20 23:59 | ||||
3753088 | 3753088 | 2020-01-27 | Mainland China | Xinjiang | 5 | 0 | 0 | 41.1129 | 85.2401 | 1/27/20 23:59 | ||||
1305753 | 1305753 | 2020-01-28 | Mainland China | Hubei | 3554 | 125 | 80 | 30.9756 | 112.2707 | 1/28/20 23:00 | ||||
1305754 | 1305754 | 2020-01-28 | Mainland China | Guangdong | 207 | 0 | 4 | 23.3417 | 113.4244 | 1/28/20 23:00 | ||||
1305755 | 1305755 | 2020-01-28 | Mainland China | Zhejiang | 173 | 0 | 3 | 29.1832 | 120.0934 | 1/28/20 23:00 | ||||
1305756 | 1305756 | 2020-01-28 | Mainland China | Henan | 168 | 1 | 0 | 33.882 | 113.614 | 1/28/20 23:00 | ||||
1305757 | 1305757 | 2020-01-28 | Mainland China | Hunan | 143 | 0 | 0 | 27.6104 | 111.7088 | 1/28/20 23:00 | ||||
1305758 | 1305758 | 2020-01-28 | Mainland China | Chongqing | 132 | 0 | 0 | 30.0572 | 107.874 | 1/28/20 23:00 | ||||
1305759 | 1305759 | 2020-01-28 | Mainland China | Jiangxi | 109 | 0 | 3 | 27.614 | 115.7221 | 1/28/20 23:00 | ||||
1305760 | 1305760 | 2020-01-28 | Mainland China | Anhui | 106 | 0 | 0 | 31.8257 | 117.2264 | 1/28/20 23:00 | ||||
1305761 | 1305761 | 2020-01-28 | Mainland China | Shandong | 95 | 0 | 0 | 36.3427 | 118.1498 | 1/28/20 23:00 | ||||
1305762 | 1305762 | 2020-01-28 | Mainland China | Beijing | 91 | 1 | 4 | 40.1824 | 116.4142 | 1/28/20 23:00 | ||||
1305763 | 1305763 | 2020-01-28 | Mainland China | Sichuan | 90 | 0 | 0 | 30.6171 | 102.7103 | 1/28/20 23:00 | ||||
1305764 | 1305764 | 2020-01-28 | Mainland China | Fujian | 80 | 0 | 0 | 26.0789 | 117.9874 | 1/28/20 23:00 | ||||
1305765 | 1305765 | 2020-01-28 | Mainland China | Jiangsu | 70 | 0 | 1 | 32.9711 | 119.455 | 1/28/20 23:00 | ||||
1305766 | 1305766 | 2020-01-28 | Mainland China | Shanghai | 66 | 1 | 4 | 31.202 | 121.4491 | 1/28/20 23:00 | ||||
1305767 | 1305767 | 2020-01-28 | Mainland China | Guangxi | 51 | 0 | 2 | 23.8298 | 108.7881 | 1/28/20 23:00 | ||||
1305768 | 1305768 | 2020-01-28 | Mainland China | Shaanxi | 46 | 0 | 0 | 35.1917 | 108.8701 | 1/28/20 23:00 | ||||
1305769 | 1305769 | 2020-01-28 | Mainland China | Yunnan | 44 | 0 | 0 | 24.974 | 101.487 | 1/28/20 23:00 | ||||
1305770 | 1305770 | 2020-01-28 | Mainland China | Hainan | 40 | 1 | 0 | 19.1959 | 109.7453 | 1/28/20 23:00 |
Advanced export
JSON shape: default, array, newline-delimited
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]);