johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
22 rows where confirmed = 235 and country_or_region = "China" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- China · 22 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3713973 | 3713973 | 2022-12-06 | China | Ningxia | 235 | 0 | 0 | 37.2692 | 106.1655 | 2022-12-07 04:20:58 | Ningxia, China | |||
2414678 | 2414678 | 2022-12-05 | China | Ningxia | 235 | 0 | 0 | 37.2692 | 106.1655 | 2022-12-06 04:21:03 | Ningxia, China | |||
1976421 | 1976421 | 2022-09-25 | China | Qinghai | 235 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-26 04:20:52 | Qinghai, China | |||
653782 | 653782 | 2021-10-22 | China | Gansu | 235 | 2 | 0 | 35.7518 | 104.2861 | 2021-10-23 04:21:32 | Gansu, China | |||
1289836 | 1289836 | 2021-03-29 | China | Yunnan | 235 | 2 | 230 | 3 | 24.974 | 101.487 | 2021-03-30 04:26:23 | Yunnan, China | ||
1535758 | 1535758 | 2021-03-28 | China | Yunnan | 235 | 2 | 230 | 3 | 24.974 | 101.487 | 2021-03-29 04:28:35 | Yunnan, China | ||
1219398 | 1219398 | 2021-03-27 | China | Yunnan | 235 | 2 | 230 | 3 | 24.974 | 101.487 | 2021-03-28 05:28:10 | Yunnan, China | ||
1880816 | 1880816 | 2021-03-26 | China | Yunnan | 235 | 2 | 230 | 3 | 24.974 | 101.487 | 2021-03-27 05:25:04 | Yunnan, China | ||
1980446 | 1980446 | 2021-03-25 | China | Yunnan | 235 | 2 | 230 | 3 | 24.974 | 101.487 | 2021-03-26 05:26:55 | Yunnan, China | ||
2780824 | 2780824 | 2021-03-24 | China | Yunnan | 235 | 2 | 230 | 3 | 24.974 | 101.487 | 2021-03-25 05:27:00 | Yunnan, China | ||
1798469 | 1798469 | 2021-03-23 | China | Yunnan | 235 | 2 | 230 | 3 | 24.974 | 101.487 | 2021-03-24 05:25:40 | Yunnan, China | ||
1203637 | 1203637 | 2021-03-22 | China | Yunnan | 235 | 2 | 230 | 3 | 24.974 | 101.487 | 2021-03-23 05:26:18 | Yunnan, China | ||
2466630 | 2466630 | 2021-01-22 | China | Shanxi | 235 | 0 | 224 | 11 | 37.5777 | 112.2922 | 2021-01-23 05:22:03 | Shanxi, China | ||
217140 | 217140 | 2020-06-08 | China | Inner Mongolia | 235 | 1 | 226 | 8 | 44.0935 | 113.9448 | 2020-06-09 03:33:03 | Inner Mongolia, China | ||
2799936 | 2799936 | 2020-06-07 | China | Inner Mongolia | 235 | 1 | 218 | 16 | 44.0935 | 113.9448 | 2020-06-08 03:33:22 | Inner Mongolia, China | ||
573992 | 573992 | 2020-06-06 | China | Inner Mongolia | 235 | 1 | 213 | 21 | 44.0935 | 113.9448 | 2020-06-07 03:53:30 | Inner Mongolia, China | ||
1269689 | 1269689 | 2020-06-05 | China | Inner Mongolia | 235 | 1 | 213 | 21 | 44.0935 | 113.9448 | 2020-06-06 02:33:00 | Inner Mongolia, China | ||
1281165 | 1281165 | 2020-06-04 | China | Inner Mongolia | 235 | 1 | 213 | 21 | 44.0935 | 113.9448 | 2020-06-05 02:33:06 | Inner Mongolia, China | ||
3866720 | 3866720 | 2020-06-03 | China | Inner Mongolia | 235 | 1 | 212 | 22 | 44.0935 | 113.9448 | 2020-06-04 02:33:14 | Inner Mongolia, China | ||
2555762 | 2555762 | 2020-06-02 | China | Inner Mongolia | 235 | 1 | 209 | 25 | 44.0935 | 113.9448 | 2020-06-03 02:33:13 | Inner Mongolia, China | ||
805299 | 805299 | 2020-06-01 | China | Inner Mongolia | 235 | 1 | 209 | 25 | 44.0935 | 113.9448 | 2020-06-02 02:33:08 | Inner Mongolia, China | ||
1793922 | 1793922 | 2020-05-31 | China | Inner Mongolia | 235 | 1 | 207 | 27 | 44.0935 | 113.9448 | 2020-06-01 02:32:46 | Inner Mongolia, 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]);