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)
Suggested facets: day (date), last_update (date)
province_or_state >30
- Unknown 1,073
- 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
- Jiangsu 1,024
- Jiangxi 1,024
- Jilin 1,024
- Liaoning 1,024
- Macau 1,024
- Ningxia 1,024
- Qinghai 1,024
- Shaanxi 1,024
- Shandong 1,024
- Shanghai 1,024
- Shanxi 1,024
- Sichuan 1,024
- Tianjin 1,024
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
128 | 128 | 2021-12-02 | China | Jiangsu | 1619 | 0 | 0 | 32.9711 | 119.455 | 2021-12-03 04:23:05 | Jiangsu, China | |||
132 | 132 | 2021-12-02 | China | Macau | 77 | 0 | 0 | 22.1667 | 113.55 | 2021-12-03 04:23:05 | Macau, China | |||
133 | 133 | 2021-12-02 | China | Ningxia | 122 | 0 | 0 | 37.2692 | 106.1655 | 2021-12-03 04:23:05 | Ningxia, China | |||
134 | 134 | 2021-12-02 | China | Qinghai | 30 | 0 | 0 | 35.7452 | 95.9956 | 2021-12-03 04:23:05 | Qinghai, China | |||
138 | 138 | 2021-12-02 | China | Shanxi | 265 | 0 | 0 | 37.5777 | 112.2922 | 2021-12-03 04:23:05 | Shanxi, China | |||
141 | 141 | 2021-12-02 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2021-12-03 04:23:05 | Tibet, China | |||
142 | 142 | 2021-12-02 | China | Unknown | 12324 | 0 | 0 | 2021-12-03 04:23:05 | Unknown, China | |||||
4144 | 4144 | 2021-10-28 | China | Jiangsu | 1600 | 0 | 0 | 32.9711 | 119.455 | 2021-10-29 04:22:03 | Jiangsu, China | |||
4148 | 4148 | 2021-10-28 | China | Macau | 77 | 0 | 0 | 22.1667 | 113.55 | 2021-10-29 04:22:03 | Macau, China | |||
4149 | 4149 | 2021-10-28 | China | Ningxia | 103 | 0 | 0 | 37.2692 | 106.1655 | 2021-10-29 04:22:03 | Ningxia, China | |||
4150 | 4150 | 2021-10-28 | China | Qinghai | 22 | 0 | 0 | 35.7452 | 95.9956 | 2021-10-29 04:22:03 | Qinghai, China | |||
4154 | 4154 | 2021-10-28 | China | Shanxi | 260 | 0 | 0 | 37.5777 | 112.2922 | 2021-10-29 04:22:03 | Shanxi, China | |||
4157 | 4157 | 2021-10-28 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2021-10-29 04:22:03 | Tibet, China | |||
4158 | 4158 | 2021-10-28 | China | Unknown | 11686 | 0 | 0 | 2021-10-29 04:22:03 | Unknown, China | |||||
8148 | 8148 | 2020-10-25 | China | Jiangsu | 670 | 0 | 665 | 5 | 32.9711 | 119.455 | 2020-10-26 04:25:02 | Jiangsu, China | ||
8152 | 8152 | 2020-10-25 | China | Macau | 46 | 0 | 46 | 0 | 22.1667 | 113.55 | 2020-10-26 04:25:02 | Macau, China | ||
8153 | 8153 | 2020-10-25 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-10-26 04:25:02 | Ningxia, China | ||
8154 | 8154 | 2020-10-25 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2020-10-26 04:25:02 | Qinghai, China | ||
8158 | 8158 | 2020-10-25 | China | Shanxi | 212 | 0 | 205 | 7 | 37.5777 | 112.2922 | 2020-10-26 04:25:02 | Shanxi, China | ||
8161 | 8161 | 2020-10-25 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2020-10-26 04:25:02 | Tibet, China | ||
11995 | 11995 | 2020-10-25 | China | Unknown | 5492 | 0 | 0 | 0 | 2020-10-26 04:25:02 | Unknown, China | ||||
12155 | 12155 | 2021-01-26 | China | Jiangsu | 692 | 0 | 685 | 7 | 32.9711 | 119.455 | 2021-01-27 05:23:41 | Jiangsu, China | ||
12159 | 12159 | 2021-01-26 | China | Macau | 47 | 0 | 46 | 1 | 22.1667 | 113.55 | 2021-01-27 05:23:41 | Macau, China | ||
12160 | 12160 | 2021-01-26 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2021-01-27 05:23:41 | Ningxia, China | ||
12161 | 12161 | 2021-01-26 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-01-27 05:23:41 | Qinghai, China | ||
12165 | 12165 | 2021-01-26 | China | Shanxi | 237 | 0 | 225 | 12 | 37.5777 | 112.2922 | 2021-01-27 05:23:41 | Shanxi, China | ||
12168 | 12168 | 2021-01-26 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-01-27 05:23:41 | Tibet, China | ||
16009 | 16009 | 2021-01-26 | China | Unknown | 7689 | 0 | 0 | 0 | 2021-01-27 05:23:41 | Unknown, China | ||||
16169 | 16169 | 2021-09-18 | China | Jiangsu | 1592 | 0 | 0 | 32.9711 | 119.455 | 2021-09-19 04:21:34 | Jiangsu, China | |||
16173 | 16173 | 2021-09-18 | China | Macau | 63 | 0 | 0 | 22.1667 | 113.55 | 2021-09-19 04:21:34 | Macau, China | |||
16174 | 16174 | 2021-09-18 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-19 04:21:34 | Ningxia, China | |||
16175 | 16175 | 2021-09-18 | China | Qinghai | 18 | 0 | 0 | 35.7452 | 95.9956 | 2021-09-19 04:21:34 | Qinghai, China | |||
16179 | 16179 | 2021-09-18 | China | Shanxi | 260 | 0 | 0 | 37.5777 | 112.2922 | 2021-09-19 04:21:34 | Shanxi, China | |||
16182 | 16182 | 2021-09-18 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2021-09-19 04:21:34 | Tibet, China | |||
16183 | 16183 | 2021-09-18 | China | Unknown | 11129 | 0 | 0 | 2021-09-19 04:21:34 | Unknown, China | |||||
20184 | 20184 | 2021-05-28 | China | Jiangsu | 726 | 0 | 715 | 11 | 32.9711 | 119.455 | 2021-05-29 04:20:41 | Jiangsu, China | ||
20188 | 20188 | 2021-05-28 | China | Macau | 51 | 0 | 49 | 2 | 22.1667 | 113.55 | 2021-05-29 04:20:41 | Macau, China | ||
20189 | 20189 | 2021-05-28 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-05-29 04:20:41 | Ningxia, China | ||
20190 | 20190 | 2021-05-28 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-05-29 04:20:41 | Qinghai, China | ||
20194 | 20194 | 2021-05-28 | China | Shanxi | 253 | 0 | 248 | 5 | 37.5777 | 112.2922 | 2021-05-29 04:20:41 | Shanxi, China | ||
20197 | 20197 | 2021-05-28 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-05-29 04:20:41 | Tibet, China | ||
20198 | 20198 | 2021-05-28 | China | Unknown | 9235 | 0 | 14 | 0 | 2021-05-29 04:20:41 | Unknown, China | ||||
24199 | 24199 | 2022-03-20 | China | Jiangsu | 1978 | 0 | 0 | 32.9711 | 119.455 | 2022-03-21 04:20:50 | Jiangsu, China | |||
24203 | 24203 | 2022-03-20 | China | Macau | 82 | 0 | 0 | 22.1667 | 113.55 | 2022-03-21 04:20:50 | Macau, China | |||
24204 | 24204 | 2022-03-20 | China | Ningxia | 122 | 0 | 0 | 37.2692 | 106.1655 | 2022-03-21 04:20:50 | Ningxia, China | |||
24205 | 24205 | 2022-03-20 | China | Qinghai | 32 | 0 | 0 | 35.7452 | 95.9956 | 2022-03-21 04:20:50 | Qinghai, China | |||
24209 | 24209 | 2022-03-20 | China | Shanxi | 295 | 0 | 0 | 37.5777 | 112.2922 | 2022-03-21 04:20:50 | Shanxi, China | |||
24212 | 24212 | 2022-03-20 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2022-03-21 04:20:50 | Tibet, China | |||
24213 | 24213 | 2022-03-20 | China | Unknown | 31966 | 0 | 0 | 2022-03-21 04:20:50 | Unknown, China | |||||
28214 | 28214 | 2021-11-11 | China | Jiangsu | 1603 | 0 | 0 | 32.9711 | 119.455 | 2021-11-12 04:22:01 | Jiangsu, China | |||
28218 | 28218 | 2021-11-11 | China | Macau | 77 | 0 | 0 | 22.1667 | 113.55 | 2021-11-12 04:22:01 | Macau, China | |||
28219 | 28219 | 2021-11-11 | China | Ningxia | 122 | 0 | 0 | 37.2692 | 106.1655 | 2021-11-12 04:22:01 | Ningxia, China | |||
28220 | 28220 | 2021-11-11 | China | Qinghai | 30 | 0 | 0 | 35.7452 | 95.9956 | 2021-11-12 04:22:01 | Qinghai, China | |||
28224 | 28224 | 2021-11-11 | China | Shanxi | 263 | 0 | 0 | 37.5777 | 112.2922 | 2021-11-12 04:22:01 | Shanxi, China | |||
28227 | 28227 | 2021-11-11 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2021-11-12 04:22:01 | Tibet, China | |||
28228 | 28228 | 2021-11-11 | China | Unknown | 12010 | 0 | 0 | 2021-11-12 04:22:01 | Unknown, China | |||||
32230 | 32230 | 2021-08-25 | China | Jiangsu | 1586 | 0 | 0 | 32.9711 | 119.455 | 2021-08-26 04:21:28 | Jiangsu, China | |||
32234 | 32234 | 2021-08-25 | China | Macau | 63 | 0 | 0 | 22.1667 | 113.55 | 2021-08-26 04:21:28 | Macau, China | |||
32235 | 32235 | 2021-08-25 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-26 04:21:28 | Ningxia, China | |||
32236 | 32236 | 2021-08-25 | China | Qinghai | 18 | 0 | 0 | 35.7452 | 95.9956 | 2021-08-26 04:21:28 | Qinghai, China | |||
32240 | 32240 | 2021-08-25 | China | Shanxi | 256 | 0 | 0 | 37.5777 | 112.2922 | 2021-08-26 04:21:28 | Shanxi, China | |||
32243 | 32243 | 2021-08-25 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2021-08-26 04:21:28 | Tibet, China | |||
32244 | 32244 | 2021-08-25 | China | Unknown | 10791 | 0 | 0 | 2021-08-26 04:21:28 | Unknown, China | |||||
36244 | 36244 | 2021-04-12 | China | Jiangsu | 716 | 0 | 708 | 8 | 32.9711 | 119.455 | 2021-04-13 04:20:37 | Jiangsu, China | ||
36248 | 36248 | 2021-04-12 | China | Macau | 49 | 0 | 48 | 1 | 22.1667 | 113.55 | 2021-04-13 04:20:37 | Macau, China | ||
36249 | 36249 | 2021-04-12 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2021-04-13 04:20:37 | Ningxia, China | ||
36250 | 36250 | 2021-04-12 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-04-13 04:20:37 | Qinghai, China | ||
36254 | 36254 | 2021-04-12 | China | Shanxi | 248 | 0 | 240 | 8 | 37.5777 | 112.2922 | 2021-04-13 04:20:37 | Shanxi, China | ||
36257 | 36257 | 2021-04-12 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-04-13 04:20:37 | Tibet, China | ||
36258 | 36258 | 2021-04-12 | China | Unknown | 8541 | 0 | 2 | 0 | 2021-04-13 04:20:37 | Unknown, China | ||||
40303 | 40303 | 2020-03-05 | China | Unknown | 0 | 0 | 0 | 2020-03-05T14:53:03 | ||||||
43111 | 43111 | 2020-04-13 | China | Jiangsu | 653 | 0 | 638 | 15 | 32.9711 | 119.455 | 2020-04-12 02:25:30 | Jiangsu, China | ||
43115 | 43115 | 2020-04-13 | China | Macau | 45 | 0 | 13 | 32 | 22.1667 | 113.55 | 2020-04-12 12:33:48 | Macau, China | ||
43124 | 43124 | 2020-04-13 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
43133 | 43133 | 2020-04-13 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2020-02-23 11:19:02 | Qinghai, China | ||
43146 | 43146 | 2020-04-13 | China | Shanxi | 173 | 0 | 135 | 38 | 37.5777 | 112.2922 | 2020-04-13 00:27:41 | Shanxi, China | ||
43153 | 43153 | 2020-04-13 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2020-02-23 11:19:02 | Tibet, China | ||
43342 | 43342 | 2020-04-13 | China | Unknown | 2276 | 0 | 0 | 0 | 2020-04-13 23:07:54 | Unknown, China | ||||
43506 | 43506 | 2021-11-02 | China | Jiangsu | 1600 | 0 | 0 | 32.9711 | 119.455 | 2021-11-03 06:22:09 | Jiangsu, China | |||
43510 | 43510 | 2021-11-02 | China | Macau | 77 | 0 | 0 | 22.1667 | 113.55 | 2021-11-03 06:22:09 | Macau, China | |||
43511 | 43511 | 2021-11-02 | China | Ningxia | 113 | 0 | 0 | 37.2692 | 106.1655 | 2021-11-03 06:22:09 | Ningxia, China | |||
43512 | 43512 | 2021-11-02 | China | Qinghai | 29 | 0 | 0 | 35.7452 | 95.9956 | 2021-11-03 06:22:09 | Qinghai, China | |||
43516 | 43516 | 2021-11-02 | China | Shanxi | 260 | 0 | 0 | 37.5777 | 112.2922 | 2021-11-03 06:22:09 | Shanxi, China | |||
43519 | 43519 | 2021-11-02 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2021-11-03 06:22:09 | Tibet, China | |||
43520 | 43520 | 2021-11-02 | China | Unknown | 11743 | 0 | 0 | 2021-11-03 06:22:09 | Unknown, China | |||||
50210 | 50210 | 2020-04-17 | China | Jiangsu | 653 | 0 | 643 | 10 | 32.9711 | 119.455 | 2020-04-17 01:05:09 | Jiangsu, China | ||
50214 | 50214 | 2020-04-17 | China | Macau | 45 | 0 | 16 | 29 | 22.1667 | 113.55 | 2020-04-15 14:46:10 | Macau, China | ||
50223 | 50223 | 2020-04-17 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
50232 | 50232 | 2020-04-17 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2020-02-23 11:19:02 | Qinghai, China | ||
50245 | 50245 | 2020-04-17 | China | Shanxi | 197 | 0 | 135 | 62 | 37.5777 | 112.2922 | 2020-04-16 23:58:59 | Shanxi, China | ||
50252 | 50252 | 2020-04-17 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2020-02-23 11:19:02 | Tibet, China | ||
50441 | 50441 | 2020-04-17 | China | Unknown | 2427 | 0 | 0 | 0 | 2020-04-17 23:30:52 | Unknown, China | ||||
50605 | 50605 | 2021-05-29 | China | Jiangsu | 726 | 0 | 716 | 10 | 32.9711 | 119.455 | 2021-05-30 04:20:55 | Jiangsu, China | ||
50609 | 50609 | 2021-05-29 | China | Macau | 51 | 0 | 49 | 2 | 22.1667 | 113.55 | 2021-05-30 04:20:55 | Macau, China | ||
50610 | 50610 | 2021-05-29 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-05-30 04:20:55 | Ningxia, China | ||
50611 | 50611 | 2021-05-29 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-05-30 04:20:55 | Qinghai, China | ||
50615 | 50615 | 2021-05-29 | China | Shanxi | 253 | 0 | 248 | 5 | 37.5777 | 112.2922 | 2021-05-30 04:20:55 | Shanxi, China | ||
50618 | 50618 | 2021-05-29 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-05-30 04:20:55 | Tibet, China | ||
50619 | 50619 | 2021-05-29 | China | Unknown | 9247 | 0 | 10 | 0 | 2021-05-30 04:20:55 | Unknown, China | ||||
54619 | 54619 | 2021-03-07 | China | Jiangsu | 705 | 0 | 702 | 3 | 32.9711 | 119.455 | 2021-03-08 05:24:48 | Jiangsu, 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]);