daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
5 rows where confirmed = 1895 and country_or_region = "Japan" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-10-20 | Japan | Akita | 1895 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-10-21 04:21:18 | Akita, Japan | |||
2021-05-13 | Japan | Aomori | 1895 | 27 | 1544 | 324 | 40.781541 | 140.828896 | 2021-05-14 04:20:41 | Aomori, Japan | ||
2021-03-23 | Japan | Ishikawa | 1895 | 64 | 1813 | 18 | 36.769464 | 136.771027 | 2021-03-24 05:25:40 | Ishikawa, Japan | ||
2020-12-29 | Japan | Nara | 1895 | 22 | 1555 | 318 | 34.317451 | 135.871644 | 2020-12-30 05:22:34 | Nara, Japan | ||
2020-12-24 | Japan | Gifu | 1895 | 27 | 1461 | 407 | 35.778671 | 137.055925 | 2020-12-25 05:22:48 | Gifu, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;