johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
34,865 rows where country_or_region = "China" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Unknown 1,058
- Anhui 1,024
- Beijing 1,024
- Chongqing 1,024
- Fujian 1,024
- Gansu 1,024
- Guangdong 1,024
- Guangxi 1,024
- Guizhou 1,024
- Hainan 1,024
- Hebei 1,024
- Heilongjiang 1,024
- Henan 1,024
- Hong Kong 1,024
- Hubei 1,024
- Hunan 1,024
- Inner Mongolia 1,024
- Jiangxi 1,024
- Jilin 1,024
- Liaoning 1,024
- Shaanxi 1,024
- Shandong 1,024
- Shanghai 1,024
- Sichuan 1,024
- Tianjin 1,024
- Xinjiang 1,024
- Yunnan 1,024
- Zhejiang 1,024
- Macau 1,010
- Ningxia 1,010
- …
country_or_region 1
- China · 34,765 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
54623 | 54623 | 2021-03-07 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-08 05:24:48 | Macau, China | ||
54624 | 54624 | 2021-03-07 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2021-03-08 05:24:48 | Ningxia, China | ||
54625 | 54625 | 2021-03-07 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-03-08 05:24:48 | Qinghai, China | ||
54629 | 54629 | 2021-03-07 | China | Shanxi | 241 | 0 | 238 | 3 | 37.5777 | 112.2922 | 2021-03-08 05:24:48 | Shanxi, China | ||
54632 | 54632 | 2021-03-07 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-03-08 05:24:48 | Tibet, China | ||
54633 | 54633 | 2021-03-07 | China | Unknown | 8116 | 0 | 3 | 0 | 2021-03-08 05:24:48 | Unknown, China | ||||
61924 | 61924 | 2020-07-23 | China | Jiangsu | 655 | 0 | 654 | 1 | 32.9711 | 119.455 | 2020-07-24 05:30:40 | Jiangsu, China | ||
61982 | 61982 | 2020-07-23 | China | Macau | 46 | 0 | 46 | 0 | 22.1667 | 113.55 | 2020-07-24 05:30:40 | Macau, China | ||
62032 | 62032 | 2020-07-23 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-07-24 05:30:40 | Ningxia, China | ||
62087 | 62087 | 2020-07-23 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2020-07-24 05:30:40 | Qinghai, China | ||
62131 | 62131 | 2020-07-23 | China | Shanxi | 201 | 0 | 201 | 0 | 37.5777 | 112.2922 | 2020-07-24 05:30:40 | Shanxi, China | ||
62160 | 62160 | 2020-07-23 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2020-07-24 05:30:40 | Tibet, China | ||
62438 | 62438 | 2020-07-23 | China | Unknown | 3723 | 0 | 0 | 0 | 2020-07-24 05:30:40 | Unknown, China | ||||
62695 | 62695 | 2020-03-07 | China | Unknown | 0 | 0 | 0 | 2020-03-07T11:13:04 | ||||||
62860 | 62860 | 2022-11-12 | China | Jiangsu | 2793 | 0 | 0 | 32.9711 | 119.455 | 2022-11-13 04:21:14 | Jiangsu, China | |||
62865 | 62865 | 2022-11-12 | China | Ningxia | 225 | 0 | 0 | 37.2692 | 106.1655 | 2022-11-13 04:21:14 | Ningxia, China | |||
62866 | 62866 | 2022-11-12 | China | Qinghai | 312 | 0 | 0 | 35.7452 | 95.9956 | 2022-11-13 04:21:14 | Qinghai, China | |||
62870 | 62870 | 2022-11-12 | China | Shanxi | 1803 | 0 | 0 | 37.5777 | 112.2922 | 2022-11-13 04:21:14 | Shanxi, China | |||
62873 | 62873 | 2022-11-12 | China | Tibet | 1470 | 0 | 0 | 31.6927 | 88.0924 | 2022-11-13 04:21:14 | Tibet, China | |||
62874 | 62874 | 2022-11-12 | China | Unknown | 847765 | 0 | 0 | 2022-11-13 04:21:14 | Unknown, China | |||||
66875 | 66875 | 2021-09-01 | China | Jiangsu | 1590 | 0 | 0 | 32.9711 | 119.455 | 2021-09-02 04:21:15 | Jiangsu, China | |||
66879 | 66879 | 2021-09-01 | China | Macau | 63 | 0 | 0 | 22.1667 | 113.55 | 2021-09-02 04:21:15 | Macau, China | |||
66880 | 66880 | 2021-09-01 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-02 04:21:15 | Ningxia, China | |||
66881 | 66881 | 2021-09-01 | China | Qinghai | 18 | 0 | 0 | 35.7452 | 95.9956 | 2021-09-02 04:21:15 | Qinghai, China | |||
66885 | 66885 | 2021-09-01 | China | Shanxi | 259 | 0 | 0 | 37.5777 | 112.2922 | 2021-09-02 04:21:15 | Shanxi, China | |||
66888 | 66888 | 2021-09-01 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2021-09-02 04:21:15 | Tibet, China | |||
66889 | 66889 | 2021-09-01 | China | Unknown | 10889 | 0 | 0 | 2021-09-02 04:21:15 | Unknown, China | |||||
70889 | 70889 | 2022-02-07 | China | Jiangsu | 1631 | 0 | 0 | 32.9711 | 119.455 | 2022-02-08 04:21:15 | Jiangsu, China | |||
70893 | 70893 | 2022-02-07 | China | Macau | 79 | 0 | 0 | 22.1667 | 113.55 | 2022-02-08 04:21:15 | Macau, China | |||
70894 | 70894 | 2022-02-07 | China | Ningxia | 122 | 0 | 0 | 37.2692 | 106.1655 | 2022-02-08 04:21:15 | Ningxia, China | |||
70895 | 70895 | 2022-02-07 | China | Qinghai | 30 | 0 | 0 | 35.7452 | 95.9956 | 2022-02-08 04:21:15 | Qinghai, China | |||
70899 | 70899 | 2022-02-07 | China | Shanxi | 268 | 0 | 0 | 37.5777 | 112.2922 | 2022-02-08 04:21:15 | Shanxi, China | |||
70902 | 70902 | 2022-02-07 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2022-02-08 04:21:15 | Tibet, China | |||
70903 | 70903 | 2022-02-07 | China | Unknown | 14255 | 0 | 0 | 2022-02-08 04:21:15 | Unknown, China | |||||
74905 | 74905 | 2020-12-03 | China | Jiangsu | 680 | 0 | 672 | 8 | 32.9711 | 119.455 | 2020-12-04 05:27:27 | Jiangsu, China | ||
74909 | 74909 | 2020-12-03 | China | Macau | 46 | 0 | 46 | 0 | 22.1667 | 113.55 | 2020-12-04 05:27:27 | Macau, China | ||
74910 | 74910 | 2020-12-03 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-12-04 05:27:27 | Ningxia, China | ||
74911 | 74911 | 2020-12-03 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2020-12-04 05:27:27 | Qinghai, China | ||
74915 | 74915 | 2020-12-03 | China | Shanxi | 221 | 0 | 218 | 3 | 37.5777 | 112.2922 | 2020-12-04 05:27:27 | Shanxi, China | ||
74918 | 74918 | 2020-12-03 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2020-12-04 05:27:27 | Tibet, China | ||
78756 | 78756 | 2020-12-03 | China | Unknown | 6349 | 0 | 0 | 0 | 2020-12-04 05:27:27 | Unknown, China | ||||
78904 | 78904 | 2020-10-14 | China | Jiangsu | 667 | 0 | 664 | 3 | 32.9711 | 119.455 | 2020-10-15 04:24:28 | Jiangsu, China | ||
78908 | 78908 | 2020-10-14 | China | Macau | 46 | 0 | 46 | 0 | 22.1667 | 113.55 | 2020-10-15 04:24:28 | Macau, China | ||
78909 | 78909 | 2020-10-14 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-10-15 04:24:28 | Ningxia, China | ||
78910 | 78910 | 2020-10-14 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2020-10-15 04:24:28 | Qinghai, China | ||
78914 | 78914 | 2020-10-14 | China | Shanxi | 208 | 0 | 204 | 4 | 37.5777 | 112.2922 | 2020-10-15 04:24:28 | Shanxi, China | ||
78917 | 78917 | 2020-10-14 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2020-10-15 04:24:28 | Tibet, China | ||
82749 | 82749 | 2020-10-14 | China | Unknown | 5277 | 0 | 0 | 0 | 2020-10-15 04:24:28 | Unknown, China | ||||
82909 | 82909 | 2021-05-25 | China | Jiangsu | 725 | 0 | 715 | 10 | 32.9711 | 119.455 | 2021-05-26 04:20:35 | Jiangsu, China | ||
82913 | 82913 | 2021-05-25 | China | Macau | 51 | 0 | 49 | 2 | 22.1667 | 113.55 | 2021-05-26 04:20:35 | Macau, China | ||
82914 | 82914 | 2021-05-25 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-05-26 04:20:35 | Ningxia, China | ||
82915 | 82915 | 2021-05-25 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-05-26 04:20:35 | Qinghai, China | ||
82919 | 82919 | 2021-05-25 | China | Shanxi | 253 | 0 | 247 | 6 | 37.5777 | 112.2922 | 2021-05-26 04:20:35 | Shanxi, China | ||
82922 | 82922 | 2021-05-25 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-05-26 04:20:35 | Tibet, China | ||
82923 | 82923 | 2021-05-25 | China | Unknown | 9177 | 0 | 10 | 0 | 2021-05-26 04:20:35 | Unknown, China | ||||
86923 | 86923 | 2021-11-09 | China | Jiangsu | 1603 | 0 | 0 | 32.9711 | 119.455 | 2021-11-10 04:21:38 | Jiangsu, China | |||
86927 | 86927 | 2021-11-09 | China | Macau | 77 | 0 | 0 | 22.1667 | 113.55 | 2021-11-10 04:21:38 | Macau, China | |||
86928 | 86928 | 2021-11-09 | China | Ningxia | 122 | 0 | 0 | 37.2692 | 106.1655 | 2021-11-10 04:21:38 | Ningxia, China | |||
86929 | 86929 | 2021-11-09 | China | Qinghai | 30 | 0 | 0 | 35.7452 | 95.9956 | 2021-11-10 04:21:38 | Qinghai, China | |||
86933 | 86933 | 2021-11-09 | China | Shanxi | 263 | 0 | 0 | 37.5777 | 112.2922 | 2021-11-10 04:21:38 | Shanxi, China | |||
86936 | 86936 | 2021-11-09 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2021-11-10 04:21:38 | Tibet, China | |||
86937 | 86937 | 2021-11-09 | China | Unknown | 11960 | 0 | 0 | 2021-11-10 04:21:38 | Unknown, China | |||||
90940 | 90940 | 2022-07-23 | China | Jiangsu | 2317 | 0 | 0 | 32.9711 | 119.455 | 2022-07-24 04:20:47 | Jiangsu, China | |||
90945 | 90945 | 2022-07-23 | China | Ningxia | 122 | 0 | 0 | 37.2692 | 106.1655 | 2022-07-24 04:20:47 | Ningxia, China | |||
90946 | 90946 | 2022-07-23 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-24 04:20:47 | Qinghai, China | |||
90950 | 90950 | 2022-07-23 | China | Shanxi | 427 | 0 | 0 | 37.5777 | 112.2922 | 2022-07-24 04:20:47 | Shanxi, China | |||
90953 | 90953 | 2022-07-23 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2022-07-24 04:20:47 | Tibet, China | |||
90954 | 90954 | 2022-07-23 | China | Unknown | 672090 | 0 | 0 | 2022-07-24 04:20:47 | Unknown, China | |||||
98268 | 98268 | 2020-08-04 | China | Jiangsu | 658 | 0 | 654 | 4 | 32.9711 | 119.455 | 2020-08-05 04:34:43 | Jiangsu, China | ||
98327 | 98327 | 2020-08-04 | China | Macau | 46 | 0 | 46 | 0 | 22.1667 | 113.55 | 2020-08-05 04:34:43 | Macau, China | ||
98381 | 98381 | 2020-08-04 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-08-05 04:34:43 | Ningxia, China | ||
98439 | 98439 | 2020-08-04 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2020-08-05 04:34:43 | Qinghai, China | ||
98486 | 98486 | 2020-08-04 | China | Shanxi | 201 | 0 | 201 | 0 | 37.5777 | 112.2922 | 2020-08-05 04:34:43 | Shanxi, China | ||
98519 | 98519 | 2020-08-04 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2020-08-05 04:34:43 | Tibet, China | ||
98768 | 98768 | 2020-08-04 | China | Unknown | 3903 | 0 | 0 | 0 | 2020-08-05 04:34:43 | Unknown, China | ||||
98960 | 98960 | 2020-03-04 | China | Unknown | 0 | 0 | 0 | 2020-03-04T12:53:03 | ||||||
99124 | 99124 | 2022-01-14 | China | Jiangsu | 1629 | 0 | 0 | 32.9711 | 119.455 | 2022-01-15 04:21:07 | Jiangsu, China | |||
99128 | 99128 | 2022-01-14 | China | Macau | 79 | 0 | 0 | 22.1667 | 113.55 | 2022-01-15 04:21:07 | Macau, China | |||
99129 | 99129 | 2022-01-14 | China | Ningxia | 122 | 0 | 0 | 37.2692 | 106.1655 | 2022-01-15 04:21:07 | Ningxia, China | |||
99130 | 99130 | 2022-01-14 | China | Qinghai | 30 | 0 | 0 | 35.7452 | 95.9956 | 2022-01-15 04:21:07 | Qinghai, China | |||
99134 | 99134 | 2022-01-14 | China | Shanxi | 266 | 0 | 0 | 37.5777 | 112.2922 | 2022-01-15 04:21:07 | Shanxi, China | |||
99137 | 99137 | 2022-01-14 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2022-01-15 04:21:07 | Tibet, China | |||
99138 | 99138 | 2022-01-14 | China | Unknown | 13335 | 0 | 0 | 2022-01-15 04:21:07 | Unknown, China | |||||
103140 | 103140 | 2021-08-15 | China | Jiangsu | 1567 | 0 | 0 | 32.9711 | 119.455 | 2021-08-16 04:21:31 | Jiangsu, China | |||
103144 | 103144 | 2021-08-15 | China | Macau | 63 | 0 | 0 | 22.1667 | 113.55 | 2021-08-16 04:21:31 | Macau, China | |||
103145 | 103145 | 2021-08-15 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-16 04:21:31 | Ningxia, China | |||
103146 | 103146 | 2021-08-15 | China | Qinghai | 18 | 0 | 0 | 35.7452 | 95.9956 | 2021-08-16 04:21:31 | Qinghai, China | |||
103150 | 103150 | 2021-08-15 | China | Shanxi | 255 | 0 | 0 | 37.5777 | 112.2922 | 2021-08-16 04:21:31 | Shanxi, China | |||
103153 | 103153 | 2021-08-15 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2021-08-16 04:21:31 | Tibet, China | |||
103154 | 103154 | 2021-08-15 | China | Unknown | 10634 | 0 | 0 | 2021-08-16 04:21:31 | Unknown, China | |||||
107101 | 107101 | 2020-02-15 | China | Unknown | 0 | 0 | 0 | 2020-02-15T23:13:05 | ||||||
107265 | 107265 | 2021-06-19 | China | Jiangsu | 739 | 0 | 725 | 14 | 32.9711 | 119.455 | 2021-06-20 04:21:48 | Jiangsu, China | ||
107269 | 107269 | 2021-06-19 | China | Macau | 53 | 0 | 51 | 2 | 22.1667 | 113.55 | 2021-06-20 04:21:48 | Macau, China | ||
107270 | 107270 | 2021-06-19 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-20 04:21:48 | Ningxia, China | ||
107271 | 107271 | 2021-06-19 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-06-20 04:21:48 | Qinghai, China | ||
107275 | 107275 | 2021-06-19 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-20 04:21:48 | Shanxi, China | ||
107278 | 107278 | 2021-06-19 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-06-20 04:21:48 | Tibet, China | ||
107279 | 107279 | 2021-06-19 | China | Unknown | 9632 | 0 | 10 | 0 | 2021-06-20 04:21:48 | Unknown, China | ||||
114150 | 114150 | 2020-05-08 | China | Jiangsu | 653 | 0 | 652 | 1 | 32.9711 | 119.455 | 2020-05-09 02:32:35 | Jiangsu, China | ||
114154 | 114154 | 2020-05-08 | China | Macau | 45 | 0 | 40 | 5 | 22.1667 | 113.55 | 2020-05-09 02:32:35 | Macau, China |
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]);