daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8 rows where country_or_region = "Japan" and recovered = 253 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, active, longitude, combined_key, day (date), last_update (date)
country_or_region 1
- Japan · 8 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-12-03 | Japan | Nagasaki | 273 | 3 | 253 | 17 | 33.235712 | 129.608033 | 2020-12-04 05:27:27 | Nagasaki, Japan | ||
2020-12-02 | Japan | Nagasaki | 273 | 3 | 253 | 17 | 33.235712 | 129.608033 | 2020-12-03 05:28:22 | Nagasaki, Japan | ||
2020-11-20 | Japan | Fukui | 298 | 11 | 253 | 34 | 35.846614 | 136.22465400000002 | 2020-11-21 05:25:51 | Fukui, Japan | ||
2020-10-28 | Japan | Saga | 254 | 0 | 253 | 1 | 33.286977 | 130.115738 | 2020-10-29 04:24:49 | Saga, Japan | ||
2020-10-27 | Japan | Saga | 254 | 0 | 253 | 1 | 33.286977 | 130.115738 | 2020-10-28 04:24:39 | Saga, Japan | ||
2020-09-18 | Japan | Miyagi | 351 | 2 | 253 | 96 | 38.446859 | 140.927086 | 2020-09-19 04:22:00 | Miyagi, Japan | ||
2020-08-19 | Japan | Kagoshima | 337 | 7 | 253 | 77 | 31.009484000000004 | 130.430665 | 2020-08-20 04:27:43 | Kagoshima, Japan | ||
2020-08-08 | Japan | Ibaraki | 380 | 10 | 253 | 117 | 36.303588 | 140.319591 | 2020-08-09 04:34:54 | Ibaraki, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;