johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
36 rows where country_or_region = "Canada", deaths = 8 and province_or_state = "Yukon" sorted by province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32194 | 32194 | 2021-08-25 | Canada | Yukon | 683 | 8 | 0 | 64.2823 | -135.0 | 2021-08-26 04:21:28 | Yukon, Canada | |||
66839 | 66839 | 2021-09-01 | Canada | Yukon | 693 | 8 | 0 | 64.2823 | -135.0 | 2021-09-02 04:21:15 | Yukon, Canada | |||
103104 | 103104 | 2021-08-15 | Canada | Yukon | 647 | 8 | 0 | 64.2823 | -135.0 | 2021-08-16 04:21:31 | Yukon, Canada | |||
177804 | 177804 | 2021-09-02 | Canada | Yukon | 694 | 8 | 0 | 64.2823 | -135.0 | 2021-09-03 04:21:20 | Yukon, Canada | |||
245047 | 245047 | 2021-08-17 | Canada | Yukon | 660 | 8 | 0 | 64.2823 | -135.0 | 2021-08-18 04:21:35 | Yukon, Canada | |||
249061 | 249061 | 2021-09-04 | Canada | Yukon | 694 | 8 | 0 | 64.2823 | -135.0 | 2021-09-05 04:21:33 | Yukon, Canada | |||
331684 | 331684 | 2021-08-04 | Canada | Yukon | 616 | 8 | 557 | 51 | 64.2823 | -135.0 | 2021-08-05 04:21:51 | Yukon, Canada | ||
507462 | 507462 | 2021-08-14 | Canada | Yukon | 647 | 8 | 0 | 64.2823 | -135.0 | 2021-08-15 04:21:41 | Yukon, Canada | |||
511476 | 511476 | 2021-08-19 | Canada | Yukon | 671 | 8 | 0 | 64.2823 | -135.0 | 2021-08-20 04:21:33 | Yukon, Canada | |||
589406 | 589406 | 2021-08-08 | Canada | Yukon | 624 | 8 | 0 | 64.2823 | -135.0 | 2021-08-09 04:21:24 | Yukon, Canada | |||
641716 | 641716 | 2021-09-07 | Canada | Yukon | 696 | 8 | 0 | 64.2823 | -135.0 | 2021-09-08 04:21:31 | Yukon, Canada | |||
649744 | 649744 | 2021-08-09 | Canada | Yukon | 633 | 8 | 0 | 64.2823 | -135.0 | 2021-08-10 04:21:27 | Yukon, Canada | |||
1117368 | 1117368 | 2021-08-06 | Canada | Yukon | 624 | 8 | 0 | 64.2823 | -135.0 | 2021-08-07 04:21:30 | Yukon, Canada | |||
1342068 | 1342068 | 2021-08-11 | Canada | Yukon | 638 | 8 | 0 | 64.2823 | -135.0 | 2021-08-12 04:21:25 | Yukon, Canada | |||
1483334 | 1483334 | 2021-08-13 | Canada | Yukon | 647 | 8 | 0 | 64.2823 | -135.0 | 2021-08-14 04:21:25 | Yukon, Canada | |||
1595985 | 1595985 | 2021-08-26 | Canada | Yukon | 684 | 8 | 0 | 64.2823 | -135.0 | 2021-08-27 04:21:37 | Yukon, Canada | |||
1604010 | 1604010 | 2021-08-16 | Canada | Yukon | 647 | 8 | 0 | 64.2823 | -135.0 | 2021-08-17 04:21:49 | Yukon, Canada | |||
1775135 | 1775135 | 2021-08-30 | Canada | Yukon | 689 | 8 | 0 | 64.2823 | -135.0 | 2021-08-31 04:21:46 | Yukon, Canada | |||
1853769 | 1853769 | 2021-08-20 | Canada | Yukon | 674 | 8 | 0 | 64.2823 | -135.0 | 2021-08-21 04:21:38 | Yukon, Canada | |||
1956305 | 1956305 | 2021-08-05 | Canada | Yukon | 623 | 8 | 0 | 64.2823 | -135.0 | 2021-08-06 04:21:18 | Yukon, Canada | |||
2067681 | 2067681 | 2021-08-31 | Canada | Yukon | 691 | 8 | 0 | 64.2823 | -135.0 | 2021-09-01 04:21:38 | Yukon, Canada | |||
2175331 | 2175331 | 2021-08-22 | Canada | Yukon | 674 | 8 | 0 | 64.2823 | -135.0 | 2021-08-23 04:21:27 | Yukon, Canada | |||
2203418 | 2203418 | 2021-08-07 | Canada | Yukon | 624 | 8 | 0 | 64.2823 | -135.0 | 2021-08-08 04:21:33 | Yukon, Canada | |||
2351215 | 2351215 | 2021-08-10 | Canada | Yukon | 636 | 8 | 0 | 64.2823 | -135.0 | 2021-08-11 04:21:58 | Yukon, Canada | |||
2517955 | 2517955 | 2021-08-18 | Canada | Yukon | 668 | 8 | 0 | 64.2823 | -135.0 | 2021-08-19 04:21:15 | Yukon, Canada | |||
2792812 | 2792812 | 2021-08-28 | Canada | Yukon | 684 | 8 | 0 | 64.2823 | -135.0 | 2021-08-29 04:21:14 | Yukon, Canada | |||
2899464 | 2899464 | 2021-08-12 | Canada | Yukon | 645 | 8 | 0 | 64.2823 | -135.0 | 2021-08-13 04:21:24 | Yukon, Canada | |||
2922971 | 2922971 | 2021-08-27 | Canada | Yukon | 684 | 8 | 0 | 64.2823 | -135.0 | 2021-08-28 04:21:28 | Yukon, Canada | |||
3105233 | 3105233 | 2021-08-24 | Canada | Yukon | 683 | 8 | 0 | 64.2823 | -135.0 | 2021-08-25 04:21:41 | Yukon, Canada | |||
3165404 | 3165404 | 2021-08-23 | Canada | Yukon | 681 | 8 | 0 | 64.2823 | -135.0 | 2021-08-24 04:21:19 | Yukon, Canada | |||
3193779 | 3193779 | 2021-09-06 | Canada | Yukon | 694 | 8 | 0 | 64.2823 | -135.0 | 2021-09-07 04:21:35 | Yukon, Canada | |||
3280647 | 3280647 | 2021-09-05 | Canada | Yukon | 694 | 8 | 0 | 64.2823 | -135.0 | 2021-09-06 04:21:22 | Yukon, Canada | |||
3467955 | 3467955 | 2021-08-03 | Canada | Yukon | 610 | 8 | 544 | 58 | 64.2823 | -135.0 | 2021-08-04 04:21:25 | Yukon, Canada | ||
3555427 | 3555427 | 2021-08-21 | Canada | Yukon | 674 | 8 | 0 | 64.2823 | -135.0 | 2021-08-22 04:21:29 | Yukon, Canada | |||
3891709 | 3891709 | 2021-08-29 | Canada | Yukon | 684 | 8 | 0 | 64.2823 | -135.0 | 2021-08-30 04:21:23 | Yukon, Canada | |||
3974342 | 3974342 | 2021-09-03 | Canada | Yukon | 694 | 8 | 0 | 64.2823 | -135.0 | 2021-09-04 04:21:28 | Yukon, Canada |
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]);