daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3 rows where active = 69, country_or_region = "Japan" and province_or_state = "Fukuoka" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-10-25 | Japan | Fukuoka | 5185 | 101 | 5015 | 69 | 33.526032 | 130.666949 | 2020-10-26 04:25:02 | Fukuoka, Japan | ||
2020-10-24 | Japan | Fukuoka | 5179 | 101 | 5009 | 69 | 33.526032 | 130.666949 | 2020-10-25 04:24:36 | Fukuoka, Japan | ||
2020-10-18 | Japan | Fukuoka | 5142 | 100 | 4973 | 69 | 33.526032 | 130.666949 | 2020-10-19 04:24:16 | Fukuoka, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;