daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
94 rows where country_or_region = "China" and recovered = 253 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- China · 94 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-04 | China | Shanxi | 254 | 0 | 253 | 1 | 37.5777 | 112.2922 | 2021-08-05 04:21:51 | Shanxi, China | ||
2021-08-03 | China | Shanxi | 254 | 0 | 253 | 1 | 37.5777 | 112.2922 | 2021-08-04 04:21:25 | Shanxi, China | ||
2021-08-02 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-08-03 04:21:39 | Shanxi, China | ||
2021-08-01 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-08-02 04:21:36 | Shanxi, China | ||
2021-07-31 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-08-01 04:21:50 | Shanxi, China | ||
2021-07-30 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-31 04:21:35 | Shanxi, China | ||
2021-07-29 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-30 04:21:34 | Shanxi, China | ||
2021-07-28 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-29 04:21:33 | Shanxi, China | ||
2021-07-27 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-28 04:21:39 | Shanxi, China | ||
2021-07-26 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-27 04:21:18 | Shanxi, China | ||
2021-07-25 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-26 04:21:28 | Shanxi, China | ||
2021-07-24 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-25 04:22:12 | Shanxi, China | ||
2021-07-23 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-24 00:21:36 | Shanxi, China | ||
2021-07-22 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-23 04:21:29 | Shanxi, China | ||
2021-07-21 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-22 04:21:19 | Shanxi, China | ||
2021-07-20 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-21 04:21:40 | Shanxi, China | ||
2021-07-19 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-20 04:21:48 | Shanxi, China | ||
2021-07-18 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-19 04:21:24 | Shanxi, China | ||
2021-07-17 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-18 04:22:07 | Shanxi, China | ||
2021-07-16 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-17 04:22:22 | Shanxi, China | ||
2021-04-19 | China | Yunnan | 331 | 2 | 253 | 76 | 24.974 | 101.487 | 2021-04-20 04:20:41 | Yunnan, China | ||
2020-09-20 | China | Guangxi | 258 | 2 | 253 | 3 | 23.8298 | 108.7881 | 2020-09-21 04:23:00 | Guangxi, China | ||
2020-09-19 | China | Guangxi | 258 | 2 | 253 | 3 | 23.8298 | 108.7881 | 2020-09-20 04:22:00 | Guangxi, China | ||
2020-09-18 | China | Guangxi | 258 | 2 | 253 | 3 | 23.8298 | 108.7881 | 2020-09-19 04:22:00 | Guangxi, China | ||
2020-09-17 | China | Guangxi | 258 | 2 | 253 | 3 | 23.8298 | 108.7881 | 2020-09-18 05:05:00 | Guangxi, China | ||
2020-09-16 | China | Guangxi | 258 | 2 | 253 | 3 | 23.8298 | 108.7881 | 2020-09-17 04:22:00 | Guangxi, China | ||
2020-09-15 | China | Guangxi | 258 | 2 | 253 | 3 | 23.8298 | 108.7881 | 2020-09-16 04:22:53 | Guangxi, China | ||
2020-09-14 | China | Guangxi | 258 | 2 | 253 | 3 | 23.8298 | 108.7881 | 2020-09-15 03:22:50 | Guangxi, China | ||
2020-09-13 | China | Guangxi | 258 | 2 | 253 | 3 | 23.8298 | 108.7881 | 2020-09-14 04:26:00 | Guangxi, China | ||
2020-09-12 | China | Guangxi | 258 | 2 | 253 | 3 | 23.8298 | 108.7881 | 2020-09-13 04:30:52 | Guangxi, China | ||
2020-09-11 | China | Guangxi | 257 | 2 | 253 | 2 | 23.8298 | 108.7881 | 2020-09-12 04:25:05 | Guangxi, China | ||
2020-09-10 | China | Guangxi | 257 | 2 | 253 | 2 | 23.8298 | 108.7881 | 2020-09-11 04:46:23 | Guangxi, China | ||
2020-09-09 | China | Guangxi | 257 | 2 | 253 | 2 | 23.8298 | 108.7881 | 2020-09-10 04:29:01 | Guangxi, China | ||
2020-09-08 | China | Guangxi | 257 | 2 | 253 | 2 | 23.8298 | 108.7881 | 2020-09-09 04:28:48 | Guangxi, China | ||
2020-09-07 | China | Guangxi | 257 | 2 | 253 | 2 | 23.8298 | 108.7881 | 2020-09-08 04:28:25 | Guangxi, China | ||
2020-09-06 | China | Guangxi | 257 | 2 | 253 | 2 | 23.8298 | 108.7881 | 2020-09-07 04:28:30 | Guangxi, China | ||
2020-09-05 | China | Guangxi | 257 | 2 | 253 | 2 | 23.8298 | 108.7881 | 2020-09-06 04:28:33 | Guangxi, China | ||
2020-09-04 | China | Guangxi | 257 | 2 | 253 | 2 | 23.8298 | 108.7881 | 2020-09-05 04:28:19 | Guangxi, China | ||
2020-09-03 | China | Guangxi | 257 | 2 | 253 | 2 | 23.8298 | 108.7881 | 2020-09-04 04:28:26 | Guangxi, China | ||
2020-09-02 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-09-03 04:28:22 | Guangxi, China | ||
2020-09-01 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-09-02 04:28:25 | Guangxi, China | ||
2020-08-31 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-09-01 04:28:31 | Guangxi, China | ||
2020-08-30 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-31 04:28:27 | Guangxi, China | ||
2020-08-29 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-30 04:28:22 | Guangxi, China | ||
2020-08-28 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-29 04:28:19 | Guangxi, China | ||
2020-08-27 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-28 04:28:11 | Guangxi, China | ||
2020-08-26 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-27 04:28:15 | Guangxi, China | ||
2020-08-25 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-26 04:28:11 | Guangxi, China | ||
2020-08-24 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-25 04:28:02 | Guangxi, China | ||
2020-08-24 | China | Liaoning | 262 | 2 | 253 | 7 | 41.2956 | 122.6085 | 2020-08-25 04:28:02 | Liaoning, China | ||
2020-08-23 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-24 04:27:56 | Guangxi, China | ||
2020-08-22 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-23 04:27:48 | Guangxi, China | ||
2020-08-21 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-22 04:27:49 | Guangxi, China | ||
2020-08-20 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-21 04:27:41 | Guangxi, China | ||
2020-08-19 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-20 04:27:43 | Guangxi, China | ||
2020-08-18 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-19 04:27:00 | Guangxi, China | ||
2020-08-17 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-18 04:27:56 | Guangxi, China | ||
2020-08-16 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-17 04:27:20 | Guangxi, China | ||
2020-08-15 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-16 04:27:42 | Guangxi, China | ||
2020-08-14 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-15 04:27:31 | Guangxi, China | ||
2020-08-13 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-14 04:51:19 | Guangxi, China | ||
2020-08-12 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-13 04:29:15 | Guangxi, China | ||
2020-08-11 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-12 04:27:29 | Guangxi, China | ||
2020-08-10 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-11 04:35:08 | Guangxi, China | ||
2020-08-10 | China | Inner Mongolia | 258 | 1 | 253 | 4 | 44.0935 | 113.9448 | 2020-08-11 04:35:08 | Inner Mongolia, China | ||
2020-08-09 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-10 04:34:55 | Guangxi, China | ||
2020-08-09 | China | Inner Mongolia | 258 | 1 | 253 | 4 | 44.0935 | 113.9448 | 2020-08-10 04:34:55 | Inner Mongolia, China | ||
2020-08-08 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-09 04:34:54 | Guangxi, China | ||
2020-08-07 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-08 04:34:53 | Guangxi, China | ||
2020-08-06 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-07 04:35:11 | Guangxi, China | ||
2020-08-05 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-06 04:35:02 | Guangxi, China | ||
2020-08-04 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-05 04:34:43 | Guangxi, China | ||
2020-08-03 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-04 04:41:59 | Guangxi, China | ||
2020-08-02 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-03 04:34:35 | Guangxi, China | ||
2020-08-01 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-02 04:34:47 | Guangxi, China | ||
2020-07-31 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-08-01 04:36:27 | Guangxi, China | ||
2020-07-30 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-07-31 04:35:18 | Guangxi, China | ||
2020-07-29 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-07-30 04:35:05 | Guangxi, China | ||
2020-07-28 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-07-29 04:35:11 | Guangxi, China | ||
2020-07-27 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-07-28 04:58:43 | Guangxi, China | ||
2020-07-26 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-07-27 04:35:02 | Guangxi, China | ||
2020-07-25 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-07-26 04:35:00 | Guangxi, China | ||
2020-07-24 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-07-25 04:47:39 | Guangxi, China | ||
2020-07-23 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-07-24 05:30:40 | Guangxi, China | ||
2020-07-22 | China | Guangxi | 255 | 2 | 253 | 0 | 23.8298 | 108.7881 | 2020-07-23 05:15:04 | Guangxi, China | ||
2020-04-29 | China | Shaanxi | 306 | 3 | 253 | 50 | 35.1917 | 108.8701 | 2020-04-30 02:32:27 | Shaanxi, China | ||
2020-04-28 | China | Shaanxi | 306 | 3 | 253 | 50 | 35.1917 | 108.8701 | 2020-04-29 02:32:29 | Shaanxi, China | ||
2020-04-27 | China | Shaanxi | 286 | 3 | 253 | 30 | 35.1917 | 108.8701 | 2020-04-25 01:22:13 | Shaanxi, China | ||
2020-04-26 | China | Shaanxi | 286 | 3 | 253 | 30 | 35.1917 | 108.8701 | 2020-04-25 01:22:13 | Shaanxi, China | ||
2020-04-25 | China | Shaanxi | 286 | 3 | 253 | 30 | 35.1917 | 108.8701 | 2020-04-25 01:22:13 | Shaanxi, China | ||
2020-04-24 | China | Shaanxi | 286 | 3 | 253 | 30 | 35.1917 | 108.8701 | 2020-04-25 01:22:13 | Shaanxi, China | ||
2020-04-23 | China | Shaanxi | 279 | 3 | 253 | 23 | 35.1917 | 108.8701 | 2020-04-22 02:37:29 | Shaanxi, China | ||
2020-04-22 | China | Shaanxi | 279 | 3 | 253 | 23 | 35.1917 | 108.8701 | 2020-04-22 02:37:29 | Shaanxi, China | ||
2020-04-21 | China | Shaanxi | 277 | 3 | 253 | 21 | 35.1917 | 108.8701 | 2020-04-21 03:01:26 | Shaanxi, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;