johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where country_or_region = "China" and "last_update" is on date 2020-04-05 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered
province_or_state 16
country_or_region 1
- China · 21 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3949896 | 3949896 | 2020-04-09 | China | Jiangsu | 651 | 0 | 633 | 18 | 32.9711 | 119.455 | 2020-04-05 01:33:26 | Jiangsu, China | ||
3562003 | 3562003 | 2020-04-08 | China | Jiangsu | 651 | 0 | 633 | 18 | 32.9711 | 119.455 | 2020-04-05 01:33:26 | Jiangsu, China | ||
3021678 | 3021678 | 2020-04-07 | China | Jiangsu | 651 | 0 | 633 | 18 | 32.9711 | 119.455 | 2020-04-05 01:33:26 | Jiangsu, China | ||
3021682 | 3021682 | 2020-04-07 | China | Macau | 44 | 0 | 10 | 34 | 22.1667 | 113.55 | 2020-04-05 02:24:59 | Macau, China | ||
3021713 | 3021713 | 2020-04-07 | China | Shanxi | 138 | 0 | 133 | 5 | 37.5777 | 112.2922 | 2020-04-05 00:58:54 | Shanxi, China | ||
589013 | 589013 | 2020-04-05 | China | Beijing | 586 | 8 | 441 | 137 | 40.1824 | 116.4142 | 2020-04-05 01:28:19 | Beijing, China | ||
589028 | 589028 | 2020-04-05 | China | Fujian | 350 | 1 | 303 | 46 | 26.0789 | 117.9874 | 2020-04-05 01:58:42 | Fujian, China | ||
589036 | 589036 | 2020-04-05 | China | Guangdong | 1524 | 8 | 1387 | 129 | 23.3417 | 113.4244 | 2020-04-05 01:49:37 | Guangdong, China | ||
589040 | 589040 | 2020-04-05 | China | Hebei | 327 | 6 | 310 | 11 | 39.549 | 116.1306 | 2020-04-05 01:06:01 | Hebei, China | ||
589041 | 589041 | 2020-04-05 | China | Heilongjiang | 504 | 13 | 469 | 22 | 47.861999999999995 | 127.7615 | 2020-04-05 01:08:02 | Heilongjiang, China | ||
589043 | 589043 | 2020-04-05 | China | Hong Kong | 882 | 4 | 206 | 680 | 22.3 | 114.2 | 2020-04-05 09:23:04 | Hong Kong, China | ||
589044 | 589044 | 2020-04-05 | China | Hubei | 67803 | 3210 | 63945 | 648 | 30.9756 | 112.2707 | 2020-04-05 02:06:47 | Hubei, China | ||
589048 | 589048 | 2020-04-05 | China | Jiangsu | 651 | 0 | 633 | 18 | 32.9711 | 119.455 | 2020-04-05 01:33:26 | Jiangsu, China | ||
589051 | 589051 | 2020-04-05 | China | Liaoning | 142 | 2 | 126 | 14 | 41.2956 | 122.6085 | 2020-04-05 01:28:19 | Liaoning, China | ||
589052 | 589052 | 2020-04-05 | China | Macau | 44 | 0 | 10 | 34 | 22.1667 | 113.55 | 2020-04-05 02:24:59 | Macau, China | ||
589081 | 589081 | 2020-04-05 | China | Shandong | 779 | 7 | 755 | 17 | 36.3427 | 118.1498 | 2020-04-05 01:58:42 | Shandong, China | ||
589082 | 589082 | 2020-04-05 | China | Shanghai | 531 | 6 | 383 | 142 | 31.201999999999998 | 121.4491 | 2020-04-05 06:22:56 | Shanghai, China | ||
589083 | 589083 | 2020-04-05 | China | Shanxi | 138 | 0 | 133 | 5 | 37.5777 | 112.2922 | 2020-04-05 00:58:54 | Shanxi, China | ||
589084 | 589084 | 2020-04-05 | China | Sichuan | 558 | 3 | 539 | 16 | 30.6171 | 102.7103 | 2020-04-05 01:28:19 | Sichuan, China | ||
589098 | 589098 | 2020-04-05 | China | Zhejiang | 1263 | 1 | 1230 | 32 | 29.1832 | 120.0934 | 2020-04-05 02:18:55 | Zhejiang, China | ||
589278 | 589278 | 2020-04-05 | China | Unknown | 1873 | 0 | 0 | 0 | 2020-04-05 23:06:45 | Unknown, 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]);