daily_reports (view)
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 ✖
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | China | Jiangsu | 1619 | 0 | 0 | 32.9711 | 119.455 | 2021-12-03 04:23:05 | Jiangsu, China | |||
2021-12-02 | China | Macau | 77 | 0 | 0 | 22.1667 | 113.55 | 2021-12-03 04:23:05 | Macau, China | |||
2021-12-02 | China | Ningxia | 122 | 0 | 0 | 37.2692 | 106.1655 | 2021-12-03 04:23:05 | Ningxia, China | |||
2021-12-02 | China | Qinghai | 30 | 0 | 0 | 35.7452 | 95.9956 | 2021-12-03 04:23:05 | Qinghai, China | |||
2021-12-02 | China | Shanxi | 265 | 0 | 0 | 37.5777 | 112.2922 | 2021-12-03 04:23:05 | Shanxi, China | |||
2021-12-02 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2021-12-03 04:23:05 | Tibet, China | |||
2021-12-02 | China | Unknown | 12324 | 0 | 0 | 2021-12-03 04:23:05 | Unknown, China | |||||
2021-10-28 | China | Jiangsu | 1600 | 0 | 0 | 32.9711 | 119.455 | 2021-10-29 04:22:03 | Jiangsu, China | |||
2021-10-28 | China | Macau | 77 | 0 | 0 | 22.1667 | 113.55 | 2021-10-29 04:22:03 | Macau, China | |||
2021-10-28 | China | Ningxia | 103 | 0 | 0 | 37.2692 | 106.1655 | 2021-10-29 04:22:03 | Ningxia, China | |||
2021-10-28 | China | Qinghai | 22 | 0 | 0 | 35.7452 | 95.9956 | 2021-10-29 04:22:03 | Qinghai, China | |||
2021-10-28 | China | Shanxi | 260 | 0 | 0 | 37.5777 | 112.2922 | 2021-10-29 04:22:03 | Shanxi, China | |||
2021-10-28 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2021-10-29 04:22:03 | Tibet, China | |||
2021-10-28 | China | Unknown | 11686 | 0 | 0 | 2021-10-29 04:22:03 | Unknown, China | |||||
2020-10-25 | China | Jiangsu | 670 | 0 | 665 | 5 | 32.9711 | 119.455 | 2020-10-26 04:25:02 | Jiangsu, China | ||
2020-10-25 | China | Macau | 46 | 0 | 46 | 0 | 22.1667 | 113.55 | 2020-10-26 04:25:02 | Macau, China | ||
2020-10-25 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-10-26 04:25:02 | Ningxia, China | ||
2020-10-25 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2020-10-26 04:25:02 | Qinghai, China | ||
2020-10-25 | China | Shanxi | 212 | 0 | 205 | 7 | 37.5777 | 112.2922 | 2020-10-26 04:25:02 | Shanxi, China | ||
2020-10-25 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2020-10-26 04:25:02 | Tibet, China | ||
2020-10-25 | China | Unknown | 5492 | 0 | 0 | 0 | 2020-10-26 04:25:02 | Unknown, China | ||||
2021-01-26 | China | Jiangsu | 692 | 0 | 685 | 7 | 32.9711 | 119.455 | 2021-01-27 05:23:41 | Jiangsu, China | ||
2021-01-26 | China | Macau | 47 | 0 | 46 | 1 | 22.1667 | 113.55 | 2021-01-27 05:23:41 | Macau, China | ||
2021-01-26 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2021-01-27 05:23:41 | Ningxia, China | ||
2021-01-26 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-01-27 05:23:41 | Qinghai, China | ||
2021-01-26 | China | Shanxi | 237 | 0 | 225 | 12 | 37.5777 | 112.2922 | 2021-01-27 05:23:41 | Shanxi, China | ||
2021-01-26 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-01-27 05:23:41 | Tibet, China | ||
2021-01-26 | China | Unknown | 7689 | 0 | 0 | 0 | 2021-01-27 05:23:41 | Unknown, China | ||||
2021-09-18 | China | Jiangsu | 1592 | 0 | 0 | 32.9711 | 119.455 | 2021-09-19 04:21:34 | Jiangsu, China | |||
2021-09-18 | China | Macau | 63 | 0 | 0 | 22.1667 | 113.55 | 2021-09-19 04:21:34 | Macau, China | |||
2021-09-18 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-19 04:21:34 | Ningxia, China | |||
2021-09-18 | China | Qinghai | 18 | 0 | 0 | 35.7452 | 95.9956 | 2021-09-19 04:21:34 | Qinghai, China | |||
2021-09-18 | China | Shanxi | 260 | 0 | 0 | 37.5777 | 112.2922 | 2021-09-19 04:21:34 | Shanxi, China | |||
2021-09-18 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2021-09-19 04:21:34 | Tibet, China | |||
2021-09-18 | China | Unknown | 11129 | 0 | 0 | 2021-09-19 04:21:34 | Unknown, China | |||||
2021-05-28 | China | Jiangsu | 726 | 0 | 715 | 11 | 32.9711 | 119.455 | 2021-05-29 04:20:41 | Jiangsu, China | ||
2021-05-28 | China | Macau | 51 | 0 | 49 | 2 | 22.1667 | 113.55 | 2021-05-29 04:20:41 | Macau, China | ||
2021-05-28 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-05-29 04:20:41 | Ningxia, China | ||
2021-05-28 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-05-29 04:20:41 | Qinghai, China | ||
2021-05-28 | China | Shanxi | 253 | 0 | 248 | 5 | 37.5777 | 112.2922 | 2021-05-29 04:20:41 | Shanxi, China | ||
2021-05-28 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-05-29 04:20:41 | Tibet, China | ||
2021-05-28 | China | Unknown | 9235 | 0 | 14 | 0 | 2021-05-29 04:20:41 | Unknown, China | ||||
2022-03-20 | China | Jiangsu | 1978 | 0 | 0 | 32.9711 | 119.455 | 2022-03-21 04:20:50 | Jiangsu, China | |||
2022-03-20 | China | Macau | 82 | 0 | 0 | 22.1667 | 113.55 | 2022-03-21 04:20:50 | Macau, China | |||
2022-03-20 | China | Ningxia | 122 | 0 | 0 | 37.2692 | 106.1655 | 2022-03-21 04:20:50 | Ningxia, China | |||
2022-03-20 | China | Qinghai | 32 | 0 | 0 | 35.7452 | 95.9956 | 2022-03-21 04:20:50 | Qinghai, China | |||
2022-03-20 | China | Shanxi | 295 | 0 | 0 | 37.5777 | 112.2922 | 2022-03-21 04:20:50 | Shanxi, China | |||
2022-03-20 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2022-03-21 04:20:50 | Tibet, China | |||
2022-03-20 | China | Unknown | 31966 | 0 | 0 | 2022-03-21 04:20:50 | Unknown, China | |||||
2021-11-11 | China | Jiangsu | 1603 | 0 | 0 | 32.9711 | 119.455 | 2021-11-12 04:22:01 | Jiangsu, China | |||
2021-11-11 | China | Macau | 77 | 0 | 0 | 22.1667 | 113.55 | 2021-11-12 04:22:01 | Macau, China | |||
2021-11-11 | China | Ningxia | 122 | 0 | 0 | 37.2692 | 106.1655 | 2021-11-12 04:22:01 | Ningxia, China | |||
2021-11-11 | China | Qinghai | 30 | 0 | 0 | 35.7452 | 95.9956 | 2021-11-12 04:22:01 | Qinghai, China | |||
2021-11-11 | China | Shanxi | 263 | 0 | 0 | 37.5777 | 112.2922 | 2021-11-12 04:22:01 | Shanxi, China | |||
2021-11-11 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2021-11-12 04:22:01 | Tibet, China | |||
2021-11-11 | China | Unknown | 12010 | 0 | 0 | 2021-11-12 04:22:01 | Unknown, China | |||||
2021-08-25 | China | Jiangsu | 1586 | 0 | 0 | 32.9711 | 119.455 | 2021-08-26 04:21:28 | Jiangsu, China | |||
2021-08-25 | China | Macau | 63 | 0 | 0 | 22.1667 | 113.55 | 2021-08-26 04:21:28 | Macau, China | |||
2021-08-25 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-26 04:21:28 | Ningxia, China | |||
2021-08-25 | China | Qinghai | 18 | 0 | 0 | 35.7452 | 95.9956 | 2021-08-26 04:21:28 | Qinghai, China | |||
2021-08-25 | China | Shanxi | 256 | 0 | 0 | 37.5777 | 112.2922 | 2021-08-26 04:21:28 | Shanxi, China | |||
2021-08-25 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2021-08-26 04:21:28 | Tibet, China | |||
2021-08-25 | China | Unknown | 10791 | 0 | 0 | 2021-08-26 04:21:28 | Unknown, China | |||||
2021-04-12 | China | Jiangsu | 716 | 0 | 708 | 8 | 32.9711 | 119.455 | 2021-04-13 04:20:37 | Jiangsu, China | ||
2021-04-12 | China | Macau | 49 | 0 | 48 | 1 | 22.1667 | 113.55 | 2021-04-13 04:20:37 | Macau, China | ||
2021-04-12 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2021-04-13 04:20:37 | Ningxia, China | ||
2021-04-12 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-04-13 04:20:37 | Qinghai, China | ||
2021-04-12 | China | Shanxi | 248 | 0 | 240 | 8 | 37.5777 | 112.2922 | 2021-04-13 04:20:37 | Shanxi, China | ||
2021-04-12 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-04-13 04:20:37 | Tibet, China | ||
2021-04-12 | China | Unknown | 8541 | 0 | 2 | 0 | 2021-04-13 04:20:37 | Unknown, China | ||||
2020-03-05 | China | Unknown | 0 | 0 | 0 | 2020-03-05T14:53:03 | ||||||
2020-04-13 | China | Jiangsu | 653 | 0 | 638 | 15 | 32.9711 | 119.455 | 2020-04-12 02:25:30 | Jiangsu, China | ||
2020-04-13 | China | Macau | 45 | 0 | 13 | 32 | 22.1667 | 113.55 | 2020-04-12 12:33:48 | Macau, China | ||
2020-04-13 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
2020-04-13 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2020-02-23 11:19:02 | Qinghai, China | ||
2020-04-13 | China | Shanxi | 173 | 0 | 135 | 38 | 37.5777 | 112.2922 | 2020-04-13 00:27:41 | Shanxi, China | ||
2020-04-13 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2020-02-23 11:19:02 | Tibet, China | ||
2020-04-13 | China | Unknown | 2276 | 0 | 0 | 0 | 2020-04-13 23:07:54 | Unknown, China | ||||
2021-11-02 | China | Jiangsu | 1600 | 0 | 0 | 32.9711 | 119.455 | 2021-11-03 06:22:09 | Jiangsu, China | |||
2021-11-02 | China | Macau | 77 | 0 | 0 | 22.1667 | 113.55 | 2021-11-03 06:22:09 | Macau, China | |||
2021-11-02 | China | Ningxia | 113 | 0 | 0 | 37.2692 | 106.1655 | 2021-11-03 06:22:09 | Ningxia, China | |||
2021-11-02 | China | Qinghai | 29 | 0 | 0 | 35.7452 | 95.9956 | 2021-11-03 06:22:09 | Qinghai, China | |||
2021-11-02 | China | Shanxi | 260 | 0 | 0 | 37.5777 | 112.2922 | 2021-11-03 06:22:09 | Shanxi, China | |||
2021-11-02 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2021-11-03 06:22:09 | Tibet, China | |||
2021-11-02 | China | Unknown | 11743 | 0 | 0 | 2021-11-03 06:22:09 | Unknown, China | |||||
2020-04-17 | China | Jiangsu | 653 | 0 | 643 | 10 | 32.9711 | 119.455 | 2020-04-17 01:05:09 | Jiangsu, China | ||
2020-04-17 | China | Macau | 45 | 0 | 16 | 29 | 22.1667 | 113.55 | 2020-04-15 14:46:10 | Macau, China | ||
2020-04-17 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
2020-04-17 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2020-02-23 11:19:02 | Qinghai, China | ||
2020-04-17 | China | Shanxi | 197 | 0 | 135 | 62 | 37.5777 | 112.2922 | 2020-04-16 23:58:59 | Shanxi, China | ||
2020-04-17 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2020-02-23 11:19:02 | Tibet, China | ||
2020-04-17 | China | Unknown | 2427 | 0 | 0 | 0 | 2020-04-17 23:30:52 | Unknown, China | ||||
2021-05-29 | China | Jiangsu | 726 | 0 | 716 | 10 | 32.9711 | 119.455 | 2021-05-30 04:20:55 | Jiangsu, China | ||
2021-05-29 | China | Macau | 51 | 0 | 49 | 2 | 22.1667 | 113.55 | 2021-05-30 04:20:55 | Macau, China | ||
2021-05-29 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-05-30 04:20:55 | Ningxia, China | ||
2021-05-29 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-05-30 04:20:55 | Qinghai, China | ||
2021-05-29 | China | Shanxi | 253 | 0 | 248 | 5 | 37.5777 | 112.2922 | 2021-05-30 04:20:55 | Shanxi, China | ||
2021-05-29 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-05-30 04:20:55 | Tibet, China | ||
2021-05-29 | China | Unknown | 9247 | 0 | 10 | 0 | 2021-05-30 04:20:55 | Unknown, China | ||||
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 VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;