daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where deaths = 27 and province_or_state = "Aomori" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: active, 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-05-20 | Japan | Aomori | 2099 | 27 | 1740 | 332 | 40.781541 | 140.828896 | 2021-05-21 04:20:43 | Aomori, Japan | ||
2021-05-19 | Japan | Aomori | 2033 | 27 | 1702 | 304 | 40.781541 | 140.828896 | 2021-05-20 04:21:05 | Aomori, Japan | ||
2021-05-18 | Japan | Aomori | 2009 | 27 | 1644 | 338 | 40.781541 | 140.828896 | 2021-05-19 04:20:42 | Aomori, Japan | ||
2021-05-17 | Japan | Aomori | 1981 | 27 | 1622 | 332 | 40.781541 | 140.828896 | 2021-05-18 04:20:33 | Aomori, Japan | ||
2021-05-16 | Japan | Aomori | 1952 | 27 | 1609 | 316 | 40.781541 | 140.828896 | 2021-05-17 04:20:34 | Aomori, Japan | ||
2021-05-15 | Japan | Aomori | 1942 | 27 | 1574 | 341 | 40.781541 | 140.828896 | 2021-05-16 04:20:49 | Aomori, Japan | ||
2021-05-14 | Japan | Aomori | 1926 | 27 | 1563 | 336 | 40.781541 | 140.828896 | 2021-05-15 04:20:58 | Aomori, Japan | ||
2021-05-13 | Japan | Aomori | 1895 | 27 | 1544 | 324 | 40.781541 | 140.828896 | 2021-05-14 04:20:41 | Aomori, Japan | ||
2021-05-12 | Japan | Aomori | 1873 | 27 | 1515 | 331 | 40.781541 | 140.828896 | 2021-05-13 04:20:51 | Aomori, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;