johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,024 rows where country_or_region = "China" and province_or_state = "Shanxi" sorted by recovered descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▲ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331730 | 331730 | 2021-08-04 | China | Shanxi | 254 | 0 | 253 | 1 | 37.5777 | 112.2922 | 2021-08-05 04:21:51 | Shanxi, China | ||
408118 | 408118 | 2021-07-28 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-29 04:21:33 | Shanxi, China | ||
483414 | 483414 | 2021-07-19 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-20 04:21:48 | Shanxi, China | ||
1305979 | 1305979 | 2021-07-27 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-28 04:21:39 | Shanxi, China | ||
1330071 | 1330071 | 2021-07-24 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-25 04:22:12 | Shanxi, China | ||
1378331 | 1378331 | 2021-07-25 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-26 04:21:28 | Shanxi, China | ||
2371335 | 2371335 | 2021-07-20 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-21 04:21:40 | Shanxi, China | ||
2673637 | 2673637 | 2021-07-18 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-19 04:21:24 | Shanxi, China | ||
2947180 | 2947180 | 2021-07-16 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-17 04:22:22 | Shanxi, China | ||
3015174 | 3015174 | 2021-08-01 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-08-02 04:21:36 | Shanxi, China | ||
3137375 | 3137375 | 2021-07-23 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-24 00:21:36 | Shanxi, China | ||
3218122 | 3218122 | 2021-07-26 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-27 04:21:18 | Shanxi, China | ||
3296002 | 3296002 | 2021-07-30 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-31 04:21:35 | Shanxi, China | ||
3331354 | 3331354 | 2021-07-21 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-22 04:21:19 | Shanxi, China | ||
3385213 | 3385213 | 2021-07-29 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-30 04:21:34 | Shanxi, China | ||
3468001 | 3468001 | 2021-08-03 | China | Shanxi | 254 | 0 | 253 | 1 | 37.5777 | 112.2922 | 2021-08-04 04:21:25 | Shanxi, China | ||
3476135 | 3476135 | 2021-07-22 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-23 04:21:29 | Shanxi, China | ||
3683275 | 3683275 | 2021-08-02 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-08-03 04:21:39 | Shanxi, China | ||
3705949 | 3705949 | 2021-07-17 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-07-18 04:22:07 | Shanxi, China | ||
3903797 | 3903797 | 2021-07-31 | China | Shanxi | 253 | 0 | 253 | 0 | 37.5777 | 112.2922 | 2021-08-01 04:21:50 | Shanxi, China | ||
107275 | 107275 | 2021-06-19 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-20 04:21:48 | Shanxi, China | ||
295836 | 295836 | 2021-07-15 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-07-16 04:21:22 | Shanxi, China | ||
400088 | 400088 | 2021-06-29 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-30 04:21:41 | Shanxi, China | ||
562791 | 562791 | 2021-06-22 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-23 04:21:46 | Shanxi, China | ||
578656 | 578656 | 2021-07-13 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-07-14 04:21:35 | Shanxi, China | ||
625702 | 625702 | 2021-07-10 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-07-11 04:21:43 | Shanxi, China | ||
778185 | 778185 | 2021-07-08 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-07-09 04:21:21 | Shanxi, China | ||
829421 | 829421 | 2021-07-09 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-07-10 04:21:25 | Shanxi, China | ||
1125418 | 1125418 | 2021-06-18 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-19 04:22:33 | Shanxi, China | ||
1164992 | 1164992 | 2021-07-04 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-07-05 04:21:28 | Shanxi, China | ||
1440407 | 1440407 | 2021-07-07 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-07-08 04:21:26 | Shanxi, China | ||
1495426 | 1495426 | 2021-07-03 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-07-04 04:21:38 | Shanxi, China | ||
1563916 | 1563916 | 2021-06-14 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-15 04:22:22 | Shanxi, China | ||
1712149 | 1712149 | 2021-06-25 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-26 04:21:43 | Shanxi, China | ||
1892965 | 1892965 | 2021-06-30 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-07-01 04:21:19 | Shanxi, China | ||
1932261 | 1932261 | 2021-07-05 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-07-06 04:21:32 | Shanxi, China | ||
2071741 | 2071741 | 2021-07-02 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-07-03 04:21:37 | Shanxi, China | ||
2295274 | 2295274 | 2021-06-24 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-25 04:21:33 | Shanxi, China | ||
2339220 | 2339220 | 2021-06-15 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-16 04:22:32 | Shanxi, China | ||
2422714 | 2422714 | 2021-06-23 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-24 04:21:55 | Shanxi, China | ||
2589826 | 2589826 | 2021-06-27 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-28 04:21:29 | Shanxi, China | ||
2693512 | 2693512 | 2021-07-06 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-07-07 04:21:20 | Shanxi, China | ||
2764757 | 2764757 | 2021-07-01 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-07-02 04:21:47 | Shanxi, China | ||
2884192 | 2884192 | 2021-06-20 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-21 04:21:41 | Shanxi, China | ||
2910996 | 2910996 | 2021-06-17 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-18 04:22:16 | Shanxi, China | ||
3030114 | 3030114 | 2021-06-16 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-17 04:22:36 | Shanxi, China | ||
3125331 | 3125331 | 2021-06-28 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-29 04:21:28 | Shanxi, China | ||
3358493 | 3358493 | 2021-06-21 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-22 04:21:34 | Shanxi, China | ||
3381199 | 3381199 | 2021-06-13 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-14 04:22:46 | Shanxi, China | ||
3631781 | 3631781 | 2021-07-14 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-07-15 04:21:48 | Shanxi, China | ||
3659418 | 3659418 | 2021-07-11 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-07-12 04:21:34 | Shanxi, China | ||
3740905 | 3740905 | 2021-07-12 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-07-13 04:21:18 | Shanxi, China | ||
3958330 | 3958330 | 2021-06-26 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-27 04:21:39 | Shanxi, China | ||
1736333 | 1736333 | 2021-06-12 | China | Shanxi | 253 | 0 | 251 | 2 | 37.5777 | 112.2922 | 2021-06-13 04:22:44 | Shanxi, China | ||
522681 | 522681 | 2021-06-09 | China | Shanxi | 253 | 0 | 250 | 3 | 37.5777 | 112.2922 | 2021-06-10 04:23:17 | Shanxi, China | ||
825407 | 825407 | 2021-06-06 | China | Shanxi | 253 | 0 | 250 | 3 | 37.5777 | 112.2922 | 2021-06-07 04:22:51 | Shanxi, China | ||
1448411 | 1448411 | 2021-06-03 | China | Shanxi | 253 | 0 | 250 | 3 | 37.5777 | 112.2922 | 2021-06-04 04:23:37 | Shanxi, China | ||
2315126 | 2315126 | 2021-06-04 | China | Shanxi | 253 | 0 | 250 | 3 | 37.5777 | 112.2922 | 2021-06-05 04:23:03 | Shanxi, China | ||
2585812 | 2585812 | 2021-06-05 | China | Shanxi | 253 | 0 | 250 | 3 | 37.5777 | 112.2922 | 2021-06-06 04:24:03 | Shanxi, China | ||
2716796 | 2716796 | 2021-06-10 | China | Shanxi | 253 | 0 | 250 | 3 | 37.5777 | 112.2922 | 2021-06-11 04:23:20 | Shanxi, China | ||
3145405 | 3145405 | 2021-06-07 | China | Shanxi | 253 | 0 | 250 | 3 | 37.5777 | 112.2922 | 2021-06-08 04:22:35 | Shanxi, China | ||
3472121 | 3472121 | 2021-06-08 | China | Shanxi | 253 | 0 | 250 | 3 | 37.5777 | 112.2922 | 2021-06-09 04:23:31 | Shanxi, China | ||
3970374 | 3970374 | 2021-06-11 | China | Shanxi | 253 | 0 | 250 | 3 | 37.5777 | 112.2922 | 2021-06-12 04:22:22 | Shanxi, China | ||
20194 | 20194 | 2021-05-28 | China | Shanxi | 253 | 0 | 248 | 5 | 37.5777 | 112.2922 | 2021-05-29 04:20:41 | Shanxi, China | ||
50615 | 50615 | 2021-05-29 | China | Shanxi | 253 | 0 | 248 | 5 | 37.5777 | 112.2922 | 2021-05-30 04:20:55 | Shanxi, China | ||
1188569 | 1188569 | 2021-05-31 | China | Shanxi | 253 | 0 | 248 | 5 | 37.5777 | 112.2922 | 2021-06-01 04:23:09 | Shanxi, China | ||
1708135 | 1708135 | 2021-06-02 | China | Shanxi | 253 | 0 | 248 | 5 | 37.5777 | 112.2922 | 2021-06-03 04:23:32 | Shanxi, China | ||
2103953 | 2103953 | 2021-06-01 | China | Shanxi | 253 | 0 | 248 | 5 | 37.5777 | 112.2922 | 2021-06-02 04:24:34 | Shanxi, China | ||
3089246 | 3089246 | 2021-05-30 | China | Shanxi | 253 | 0 | 248 | 5 | 37.5777 | 112.2922 | 2021-05-31 03:08:59 | Shanxi, China | ||
82919 | 82919 | 2021-05-25 | China | Shanxi | 253 | 0 | 247 | 6 | 37.5777 | 112.2922 | 2021-05-26 04:20:35 | Shanxi, China | ||
726322 | 726322 | 2021-05-22 | China | Shanxi | 251 | 0 | 247 | 4 | 37.5777 | 112.2922 | 2021-05-23 04:20:51 | Shanxi, China | ||
1309993 | 1309993 | 2021-05-26 | China | Shanxi | 253 | 0 | 247 | 6 | 37.5777 | 112.2922 | 2021-05-27 04:20:59 | Shanxi, China | ||
1412881 | 1412881 | 2021-05-24 | China | Shanxi | 253 | 0 | 247 | 6 | 37.5777 | 112.2922 | 2021-05-25 04:21:08 | Shanxi, China | ||
1771167 | 1771167 | 2021-05-23 | China | Shanxi | 251 | 0 | 247 | 4 | 37.5777 | 112.2922 | 2021-05-24 04:20:53 | Shanxi, China | ||
1806569 | 1806569 | 2021-05-27 | China | Shanxi | 253 | 0 | 247 | 6 | 37.5777 | 112.2922 | 2021-05-28 04:20:36 | Shanxi, China | ||
1952337 | 1952337 | 2021-05-21 | China | Shanxi | 251 | 0 | 247 | 4 | 37.5777 | 112.2922 | 2021-05-22 04:20:45 | Shanxi, China | ||
1913036 | 1913036 | 2021-05-20 | China | Shanxi | 251 | 0 | 246 | 5 | 37.5777 | 112.2922 | 2021-05-21 04:20:43 | Shanxi, China | ||
2255557 | 2255557 | 2021-05-19 | China | Shanxi | 251 | 0 | 246 | 5 | 37.5777 | 112.2922 | 2021-05-20 04:21:05 | Shanxi, China | ||
2390595 | 2390595 | 2021-05-18 | China | Shanxi | 251 | 0 | 246 | 5 | 37.5777 | 112.2922 | 2021-05-19 04:20:42 | Shanxi, China | ||
2939150 | 2939150 | 2021-05-16 | China | Shanxi | 251 | 0 | 245 | 6 | 37.5777 | 112.2922 | 2021-05-17 04:20:34 | Shanxi, China | ||
3574420 | 3574420 | 2021-05-17 | China | Shanxi | 251 | 0 | 245 | 6 | 37.5777 | 112.2922 | 2021-05-18 04:20:33 | Shanxi, China | ||
1081749 | 1081749 | 2021-05-14 | China | Shanxi | 251 | 0 | 244 | 7 | 37.5777 | 112.2922 | 2021-05-15 04:20:58 | Shanxi, China | ||
1424927 | 1424927 | 2021-05-09 | China | Shanxi | 251 | 0 | 244 | 7 | 37.5777 | 112.2922 | 2021-05-10 04:20:38 | Shanxi, China | ||
1551795 | 1551795 | 2021-05-08 | China | Shanxi | 251 | 0 | 244 | 7 | 37.5777 | 112.2922 | 2021-05-09 04:20:35 | Shanxi, China | ||
1872780 | 1872780 | 2021-05-15 | China | Shanxi | 251 | 0 | 244 | 7 | 37.5777 | 112.2922 | 2021-05-16 04:20:49 | Shanxi, China | ||
2004485 | 2004485 | 2021-05-12 | China | Shanxi | 251 | 0 | 244 | 7 | 37.5777 | 112.2922 | 2021-05-13 04:20:51 | Shanxi, China | ||
2501853 | 2501853 | 2021-05-07 | China | Shanxi | 251 | 0 | 244 | 7 | 37.5777 | 112.2922 | 2021-05-08 04:21:04 | Shanxi, China | ||
2820595 | 2820595 | 2021-05-10 | China | Shanxi | 251 | 0 | 244 | 7 | 37.5777 | 112.2922 | 2021-05-11 04:20:41 | Shanxi, China | ||
3054015 | 3054015 | 2021-05-13 | China | Shanxi | 251 | 0 | 244 | 7 | 37.5777 | 112.2922 | 2021-05-14 04:20:41 | Shanxi, China | ||
3954316 | 3954316 | 2021-05-11 | China | Shanxi | 251 | 0 | 244 | 7 | 37.5777 | 112.2922 | 2021-05-12 04:21:29 | Shanxi, China | ||
380017 | 380017 | 2021-04-30 | China | Shanxi | 251 | 0 | 243 | 8 | 37.5777 | 112.2922 | 2021-05-01 04:20:47 | Shanxi, China | ||
645776 | 645776 | 2021-05-05 | China | Shanxi | 251 | 0 | 243 | 8 | 37.5777 | 112.2922 | 2021-05-06 04:20:38 | Shanxi, China | ||
887944 | 887944 | 2021-04-26 | China | Shanxi | 249 | 0 | 243 | 6 | 37.5777 | 112.2922 | 2021-04-27 04:20:52 | Shanxi, China | ||
1636140 | 1636140 | 2021-04-29 | China | Shanxi | 251 | 0 | 243 | 8 | 37.5777 | 112.2922 | 2021-04-30 04:21:03 | Shanxi, China | ||
2450596 | 2450596 | 2021-05-02 | China | Shanxi | 251 | 0 | 243 | 8 | 37.5777 | 112.2922 | 2021-05-03 04:20:39 | Shanxi, China | ||
2760743 | 2760743 | 2021-05-03 | China | Shanxi | 251 | 0 | 243 | 8 | 37.5777 | 112.2922 | 2021-05-04 04:20:34 | Shanxi, China | ||
2824609 | 2824609 | 2021-05-01 | China | Shanxi | 251 | 0 | 243 | 8 | 37.5777 | 112.2922 | 2021-05-02 04:20:48 | Shanxi, China | ||
3113309 | 3113309 | 2021-05-06 | China | Shanxi | 251 | 0 | 243 | 8 | 37.5777 | 112.2922 | 2021-05-07 04:20:40 | Shanxi, China | ||
3393219 | 3393219 | 2021-04-28 | China | Shanxi | 250 | 0 | 243 | 7 | 37.5777 | 112.2922 | 2021-04-29 04:20:55 | Shanxi, China | ||
3675476 | 3675476 | 2021-05-04 | China | Shanxi | 251 | 0 | 243 | 8 | 37.5777 | 112.2922 | 2021-05-05 04:20:43 | Shanxi, 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]);