daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where active = 2, country_or_region = "Canada" and latitude = "64.8255" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
province_or_state 1
country_or_region 1
- Canada · 14 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-05-30 | Canada | Northwest Territories | 127 | 0 | 125 | 2 | 64.8255 | -124.8457 | 2021-05-31 03:08:59 | Northwest Territories,Canada | ||
2021-05-29 | Canada | Northwest Territories | 127 | 0 | 125 | 2 | 64.8255 | -124.8457 | 2021-05-30 04:20:55 | Northwest Territories,Canada | ||
2021-05-28 | Canada | Northwest Territories | 127 | 0 | 125 | 2 | 64.8255 | -124.8457 | 2021-05-29 04:20:41 | Northwest Territories,Canada | ||
2021-04-21 | Canada | Northwest Territories | 45 | 0 | 49 | 2 | 64.8255 | -124.8457 | 2021-04-22 04:20:53 | Northwest Territories,Canada | ||
2021-03-03 | Canada | Northwest Territories | 42 | 0 | 45 | 2 | 64.8255 | -124.8457 | 2021-03-04 05:24:24 | Northwest Territories,Canada | ||
2020-11-23 | Canada | Northwest Territories | 15 | 0 | 13 | 2 | 64.8255 | -124.8457 | 2020-11-24 05:27:31 | Northwest Territories,Canada | ||
2020-11-02 | Canada | Northwest Territories | 10 | 0 | 8 | 2 | 64.8255 | -124.8457 | 2020-11-03 06:00:16 | Northwest Territories,Canada | ||
2020-11-01 | Canada | Northwest Territories | 10 | 0 | 8 | 2 | 64.8255 | -124.8457 | 2020-11-02 05:25:04 | Northwest Territories,Canada | ||
2020-10-31 | Canada | Northwest Territories | 10 | 0 | 8 | 2 | 64.8255 | -124.8457 | 2020-11-01 04:36:19 | Northwest Territories,Canada | ||
2020-10-30 | Canada | Northwest Territories | 10 | 0 | 8 | 2 | 64.8255 | -124.8457 | 2020-10-31 04:24:44 | Northwest Territories,Canada | ||
2020-10-29 | Canada | Northwest Territories | 10 | 0 | 8 | 2 | 64.8255 | -124.8457 | 2020-10-30 04:24:49 | Northwest Territories,Canada | ||
2020-04-03 | Canada | Northwest Territories | 4 | 0 | 0 | 2 | 64.8255 | -124.8457 | 2020-04-03 22:52:30 | ,Northwest Territories,Canada | ||
2020-04-02 | Canada | Northwest Territories | 2 | 0 | 0 | 2 | 64.8255 | -124.8457 | 4/2/20 23:31 | ,Northwest Territories,Canada | ||
2020-04-01 | Canada | Northwest Territories | 2 | 0 | 0 | 2 | 64.8255 | -124.8457 | 2020-04-01 22:04:44 | ,Northwest Territories,Canada |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;