johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
42 rows where country_or_region = "Canada", deaths = 31 and province_or_state = "Yukon" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3276632 | 3276632 | 2022-10-23 | Canada | Yukon | 4938 | 31 | 0 | 64.2823 | -135.0 | 2022-10-24 04:22:29 | Yukon, Canada | |||
2267670 | 2267670 | 2022-10-22 | Canada | Yukon | 4938 | 31 | 0 | 64.2823 | -135.0 | 2022-10-23 04:22:46 | Yukon, Canada | |||
1591970 | 1591970 | 2022-10-21 | Canada | Yukon | 4938 | 31 | 0 | 64.2823 | -135.0 | 2022-10-22 04:22:53 | Yukon, Canada | |||
2271686 | 2271686 | 2022-10-20 | Canada | Yukon | 4937 | 31 | 0 | 64.2823 | -135.0 | 2022-10-21 04:22:23 | Yukon, Canada | |||
198021 | 198021 | 2022-10-19 | Canada | Yukon | 4933 | 31 | 0 | 64.2823 | -135.0 | 2022-10-20 04:22:59 | Yukon, Canada | |||
2756682 | 2756682 | 2022-10-18 | Canada | Yukon | 4930 | 31 | 0 | 64.2823 | -135.0 | 2022-10-19 04:22:26 | Yukon, Canada | |||
2024516 | 2024516 | 2022-10-17 | Canada | Yukon | 4930 | 31 | 0 | 64.2823 | -135.0 | 2022-10-18 04:22:42 | Yukon, Canada | |||
2159294 | 2159294 | 2022-10-16 | Canada | Yukon | 4929 | 31 | 0 | 64.2823 | -135.0 | 2022-10-17 04:20:31 | Yukon, Canada | |||
515491 | 515491 | 2022-10-15 | Canada | Yukon | 4929 | 31 | 0 | 64.2823 | -135.0 | 2022-10-16 04:22:39 | Yukon, Canada | |||
2032548 | 2032548 | 2022-10-14 | Canada | Yukon | 4929 | 31 | 0 | 64.2823 | -135.0 | 2022-10-15 04:22:00 | Yukon, Canada | |||
3753236 | 3753236 | 2022-10-13 | Canada | Yukon | 4929 | 31 | 0 | 64.2823 | -135.0 | 2022-10-14 04:22:28 | Yukon, Canada | |||
3214061 | 3214061 | 2022-10-12 | Canada | Yukon | 4929 | 31 | 0 | 64.2823 | -135.0 | 2022-10-13 04:22:39 | Yukon, Canada | |||
3249910 | 3249910 | 2022-10-11 | Canada | Yukon | 4927 | 31 | 0 | 64.2823 | -135.0 | 2022-10-12 04:22:51 | Yukon, Canada | |||
2967169 | 2967169 | 2022-10-10 | Canada | Yukon | 4923 | 31 | 0 | 64.2823 | -135.0 | 2022-10-11 04:23:05 | Yukon, Canada | |||
3097205 | 3097205 | 2022-10-09 | Canada | Yukon | 4923 | 31 | 0 | 64.2823 | -135.0 | 2022-10-10 04:22:32 | Yukon, Canada | |||
4002430 | 4002430 | 2022-10-08 | Canada | Yukon | 4923 | 31 | 0 | 64.2823 | -135.0 | 2022-10-09 04:21:16 | Yukon, Canada | |||
396027 | 396027 | 2022-10-07 | Canada | Yukon | 4923 | 31 | 0 | 64.2823 | -135.0 | 2022-10-08 04:22:56 | Yukon, Canada | |||
2529144 | 2529144 | 2022-10-06 | Canada | Yukon | 4923 | 31 | 0 | 64.2823 | -135.0 | 2022-10-07 04:23:08 | Yukon, Canada | |||
1810538 | 1810538 | 2022-10-05 | Canada | Yukon | 4921 | 31 | 0 | 64.2823 | -135.0 | 2022-10-06 04:21:22 | Yukon, Canada | |||
130512 | 130512 | 2022-10-04 | Canada | Yukon | 4919 | 31 | 0 | 64.2823 | -135.0 | 2022-10-05 04:23:06 | Yukon, Canada | |||
2685459 | 2685459 | 2022-10-03 | Canada | Yukon | 4915 | 31 | 0 | 64.2823 | -135.0 | 2022-10-04 04:22:55 | Yukon, Canada | |||
2259526 | 2259526 | 2022-10-02 | Canada | Yukon | 4905 | 31 | 0 | 64.2823 | -135.0 | 2022-10-03 04:23:11 | Yukon, Canada | |||
2995052 | 2995052 | 2022-10-01 | Canada | Yukon | 4905 | 31 | 0 | 64.2823 | -135.0 | 2022-10-02 04:21:23 | Yukon, Canada | |||
853378 | 853378 | 2022-09-30 | Canada | Yukon | 4905 | 31 | 0 | 64.2823 | -135.0 | 2022-10-01 04:23:01 | Yukon, Canada | |||
2375304 | 2375304 | 2022-09-29 | Canada | Yukon | 4905 | 31 | 0 | 64.2823 | -135.0 | 2022-09-30 04:23:09 | Yukon, Canada | |||
1559855 | 1559855 | 2022-09-28 | Canada | Yukon | 4902 | 31 | 0 | 64.2823 | -135.0 | 2022-09-29 04:22:34 | Yukon, Canada | |||
3994398 | 3994398 | 2022-09-27 | Canada | Yukon | 4900 | 31 | 0 | 64.2823 | -135.0 | 2022-09-28 04:23:01 | Yukon, Canada | |||
2768726 | 2768726 | 2022-09-26 | Canada | Yukon | 4896 | 31 | 0 | 64.2823 | -135.0 | 2022-09-27 04:23:01 | Yukon, Canada | |||
1976379 | 1976379 | 2022-09-25 | Canada | Yukon | 4888 | 31 | 0 | 64.2823 | -135.0 | 2022-09-26 04:20:52 | Yukon, Canada | |||
2649546 | 2649546 | 2022-09-24 | Canada | Yukon | 4888 | 31 | 0 | 64.2823 | -135.0 | 2022-09-25 04:23:31 | Yukon, Canada | |||
383986 | 383986 | 2022-09-23 | Canada | Yukon | 4888 | 31 | 0 | 64.2823 | -135.0 | 2022-09-24 04:21:40 | Yukon, Canada | |||
1624052 | 1624052 | 2022-09-22 | Canada | Yukon | 4885 | 31 | 0 | 64.2823 | -135.0 | 2022-09-23 04:23:13 | Yukon, Canada | |||
1370256 | 1370256 | 2022-09-21 | Canada | Yukon | 4884 | 31 | 0 | 64.2823 | -135.0 | 2022-09-22 04:22:56 | Yukon, Canada | |||
2016486 | 2016486 | 2022-09-20 | Canada | Yukon | 4878 | 31 | 0 | 64.2823 | -135.0 | 2022-09-21 04:23:22 | Yukon, Canada | |||
3570359 | 3570359 | 2022-09-19 | Canada | Yukon | 4867 | 31 | 0 | 64.2823 | -135.0 | 2022-09-20 04:22:48 | Yukon, Canada | |||
419098 | 419098 | 2022-09-18 | Canada | Yukon | 4867 | 31 | 0 | 64.2823 | -135.0 | 2022-09-19 04:21:49 | Yukon, Canada | |||
3373122 | 3373122 | 2022-09-17 | Canada | Yukon | 4867 | 31 | 0 | 64.2823 | -135.0 | 2022-09-18 04:22:50 | Yukon, Canada | |||
2355230 | 2355230 | 2022-09-16 | Canada | Yukon | 4867 | 31 | 0 | 64.2823 | -135.0 | 2022-09-17 04:20:19 | Yukon, Canada | |||
3986387 | 3986387 | 2022-09-15 | Canada | Yukon | 4866 | 31 | 0 | 64.2823 | -135.0 | 2022-09-16 04:21:19 | Yukon, Canada | |||
1888904 | 1888904 | 2022-09-14 | Canada | Yukon | 4864 | 31 | 0 | 64.2823 | -135.0 | 2022-09-15 04:21:02 | Yukon, Canada | |||
371959 | 371959 | 2022-09-13 | Canada | Yukon | 4863 | 31 | 0 | 64.2823 | -135.0 | 2022-09-14 04:20:44 | Yukon, Canada | |||
2394564 | 2394564 | 2022-09-12 | Canada | Yukon | 4862 | 31 | 0 | 64.2823 | -135.0 | 2022-09-13 04:20:57 | 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]);