daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where deaths = 22 and province_or_state = "Saskatchewan" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-08-24 | Canada | Saskatchewan | 1601 | 22 | 1482 | 98 | 52.9399 | -106.4509 | 2020-08-25 04:28:02 | Saskatchewan, Canada | ||
2020-08-23 | Canada | Saskatchewan | 1600 | 22 | 1472 | 106 | 52.9399 | -106.4509 | 2020-08-24 04:27:56 | Saskatchewan, Canada | ||
2020-08-22 | Canada | Saskatchewan | 1597 | 22 | 1458 | 117 | 52.9399 | -106.4509 | 2020-08-23 04:27:48 | Saskatchewan, Canada | ||
2020-08-21 | Canada | Saskatchewan | 1595 | 22 | 1439 | 134 | 52.9399 | -106.4509 | 2020-08-22 04:27:49 | Saskatchewan, Canada | ||
2020-08-20 | Canada | Saskatchewan | 1590 | 22 | 1419 | 149 | 52.9399 | -106.4509 | 2020-08-21 04:27:41 | Saskatchewan, Canada | ||
2020-08-19 | Canada | Saskatchewan | 1586 | 22 | 1410 | 154 | 52.9399 | -106.4509 | 2020-08-20 04:27:43 | Saskatchewan, Canada | ||
2020-08-18 | Canada | Saskatchewan | 1582 | 22 | 1403 | 157 | 52.9399 | -106.4509 | 2020-08-19 04:27:00 | Saskatchewan, Canada | ||
2020-08-17 | Canada | Saskatchewan | 1581 | 22 | 1387 | 172 | 52.9399 | -106.4509 | 2020-08-18 04:27:56 | Saskatchewan, Canada | ||
2020-08-16 | Canada | Saskatchewan | 1580 | 22 | 1365 | 193 | 52.9399 | -106.4509 | 2020-08-17 04:27:20 | Saskatchewan, Canada |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;