johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where country_or_region = "China" and recovered = 395 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, latitude, combined_key, day (date)
province_or_state 4
- Inner Mongolia 6
- Tianjin 4
- Hebei 2
- Liaoning 1
country_or_region 1
- China · 13 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3385202 | 3385202 | 2021-07-29 | China | Inner Mongolia | 403 | 1 | 395 | 7 | 44.0935 | 113.9448 | 2021-07-30 04:21:34 | Inner Mongolia, China | ||
408107 | 408107 | 2021-07-28 | China | Inner Mongolia | 403 | 1 | 395 | 7 | 44.0935 | 113.9448 | 2021-07-29 04:21:33 | Inner Mongolia, China | ||
1305968 | 1305968 | 2021-07-27 | China | Inner Mongolia | 403 | 1 | 395 | 7 | 44.0935 | 113.9448 | 2021-07-28 04:21:39 | Inner Mongolia, China | ||
3218111 | 3218111 | 2021-07-26 | China | Inner Mongolia | 403 | 1 | 395 | 7 | 44.0935 | 113.9448 | 2021-07-27 04:21:18 | Inner Mongolia, China | ||
1378320 | 1378320 | 2021-07-25 | China | Inner Mongolia | 403 | 1 | 395 | 7 | 44.0935 | 113.9448 | 2021-07-26 04:21:28 | Inner Mongolia, China | ||
1330060 | 1330060 | 2021-07-24 | China | Inner Mongolia | 401 | 1 | 395 | 5 | 44.0935 | 113.9448 | 2021-07-25 04:22:12 | Inner Mongolia, China | ||
3331356 | 3331356 | 2021-07-21 | China | Tianjin | 415 | 3 | 395 | 17 | 39.3054 | 117.323 | 2021-07-22 04:21:19 | Tianjin, China | ||
2371337 | 2371337 | 2021-07-20 | China | Tianjin | 415 | 3 | 395 | 17 | 39.3054 | 117.323 | 2021-07-21 04:21:40 | Tianjin, China | ||
483416 | 483416 | 2021-07-19 | China | Tianjin | 415 | 3 | 395 | 17 | 39.3054 | 117.323 | 2021-07-20 04:21:48 | Tianjin, China | ||
2673639 | 2673639 | 2021-07-18 | China | Tianjin | 412 | 3 | 395 | 14 | 39.3054 | 117.323 | 2021-07-19 04:21:24 | Tianjin, China | ||
1527715 | 1527715 | 2021-02-09 | China | Liaoning | 402 | 2 | 395 | 5 | 41.2956 | 122.6085 | 2021-02-10 05:22:41 | Liaoning, China | ||
435164 | 435164 | 2021-01-21 | China | Hebei | 1252 | 7 | 395 | 850 | 37.8957 | 114.9042 | 2021-01-22 05:22:10 | Hebei, China | ||
1093896 | 1093896 | 2021-01-20 | China | Hebei | 1231 | 7 | 395 | 829 | 37.8957 | 114.9042 | 2021-01-21 05:22:01 | Hebei, 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]);