johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
22 rows where active = 4, country_or_region = "China" and province_or_state = "Yunnan" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
435186 | 435186 | 2021-01-21 | China | Yunnan | 231 | 2 | 225 | 4 | 24.974 | 101.487 | 2021-01-22 05:22:10 | Yunnan, China | ||
1093918 | 1093918 | 2021-01-20 | China | Yunnan | 231 | 2 | 225 | 4 | 24.974 | 101.487 | 2021-01-21 05:22:01 | Yunnan, China | ||
908008 | 908008 | 2021-01-19 | China | Yunnan | 231 | 2 | 225 | 4 | 24.974 | 101.487 | 2021-01-20 05:21:54 | Yunnan, China | ||
237071 | 237071 | 2021-01-18 | China | Yunnan | 231 | 2 | 225 | 4 | 24.974 | 101.487 | 2021-01-19 05:22:15 | Yunnan, China | ||
1988463 | 1988463 | 2020-11-09 | China | Yunnan | 214 | 2 | 208 | 4 | 24.974 | 101.487 | 2020-11-10 05:40:07 | Yunnan, China | ||
1728315 | 1728315 | 2020-11-08 | China | Yunnan | 214 | 2 | 208 | 4 | 24.974 | 101.487 | 2020-11-09 05:25:45 | Yunnan, China | ||
1543775 | 1543775 | 2020-11-07 | China | Yunnan | 214 | 2 | 208 | 4 | 24.974 | 101.487 | 2020-11-08 05:24:56 | Yunnan, China | ||
376013 | 376013 | 2020-11-06 | China | Yunnan | 214 | 2 | 208 | 4 | 24.974 | 101.487 | 2020-11-07 05:24:52 | Yunnan, China | ||
891951 | 891951 | 2020-11-05 | China | Yunnan | 214 | 2 | 208 | 4 | 24.974 | 101.487 | 2020-11-06 05:24:55 | Yunnan, China | ||
2243216 | 2243216 | 2020-10-30 | China | Yunnan | 213 | 2 | 207 | 4 | 24.974 | 101.487 | 2020-10-31 04:24:44 | Yunnan, China | ||
210071 | 210071 | 2020-10-29 | China | Yunnan | 212 | 2 | 206 | 4 | 24.974 | 101.487 | 2020-10-30 04:24:49 | Yunnan, China | ||
1053655 | 1053655 | 2020-10-23 | China | Yunnan | 211 | 2 | 205 | 4 | 24.974 | 101.487 | 2020-10-24 04:24:46 | Yunnan, China | ||
2299281 | 2299281 | 2020-08-22 | China | Yunnan | 195 | 2 | 189 | 4 | 24.974 | 101.487 | 2020-08-23 04:27:48 | Yunnan, China | ||
1479388 | 1479388 | 2020-08-21 | China | Yunnan | 195 | 2 | 189 | 4 | 24.974 | 101.487 | 2020-08-22 04:27:49 | Yunnan, China | ||
3484137 | 3484137 | 2020-08-20 | China | Yunnan | 195 | 2 | 189 | 4 | 24.974 | 101.487 | 2020-08-21 04:27:41 | Yunnan, China | ||
206086 | 206086 | 2020-08-19 | China | Yunnan | 195 | 2 | 189 | 4 | 24.974 | 101.487 | 2020-08-20 04:27:43 | Yunnan, China | ||
3177840 | 3177840 | 2020-08-18 | China | Yunnan | 195 | 2 | 189 | 4 | 24.974 | 101.487 | 2020-08-19 04:27:00 | Yunnan, China | ||
1199259 | 1199259 | 2020-04-22 | China | Yunnan | 184 | 2 | 178 | 4 | 24.974 | 101.48700000000001 | 2020-04-19 00:00:14 | Yunnan, China | ||
522325 | 522325 | 2020-04-21 | China | Yunnan | 184 | 2 | 178 | 4 | 24.974 | 101.48700000000001 | 2020-04-19 00:00:14 | Yunnan, China | ||
2473407 | 2473407 | 2020-04-20 | China | Yunnan | 184 | 2 | 178 | 4 | 24.974 | 101.487 | 2020-04-19 00:00:14 | Yunnan, China | ||
1385099 | 1385099 | 2020-04-19 | China | Yunnan | 184 | 2 | 178 | 4 | 24.974 | 101.487 | 2020-04-19 00:00:14 | Yunnan, China | ||
919145 | 919145 | 2020-03-26 | China | Yunnan | 178 | 2 | 172 | 4 | 24.974 | 101.48700000000001 | 2020-03-25 23:30:18 | Yunnan, 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]);