daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
7 rows where deaths = 575 and province_or_state = "Saskatchewan" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-22 | Canada | Saskatchewan | 49556 | 575 | 48694 | 287 | 52.9399 | -106.4509 | 2021-07-23 04:21:29 | Saskatchewan, Canada | ||
2021-07-21 | Canada | Saskatchewan | 49525 | 575 | 48674 | 276 | 52.9399 | -106.4509 | 2021-07-22 04:21:19 | Saskatchewan, Canada | ||
2021-07-20 | Canada | Saskatchewan | 49472 | 575 | 48655 | 242 | 52.9399 | -106.4509 | 2021-07-21 04:21:40 | Saskatchewan, Canada | ||
2021-07-19 | Canada | Saskatchewan | 49450 | 575 | 48613 | 262 | 52.9399 | -106.4509 | 2021-07-20 04:21:48 | Saskatchewan, Canada | ||
2021-07-18 | Canada | Saskatchewan | 49433 | 575 | 48576 | 282 | 52.9399 | -106.4509 | 2021-07-19 04:21:24 | Saskatchewan, Canada | ||
2021-07-17 | Canada | Saskatchewan | 49397 | 575 | 48462 | 360 | 52.9399 | -106.4509 | 2021-07-18 04:22:07 | Saskatchewan, Canada | ||
2021-07-16 | Canada | Saskatchewan | 49362 | 575 | 48407 | 380 | 52.9399 | -106.4509 | 2021-07-17 04:22:22 | Saskatchewan, Canada |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;