daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where country_or_region = "Finland" and recovered = 1 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, latitude, longitude, last_update, day (date)
country_or_region 1
- Finland · 32 ✖
province_or_state 0
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-14 | Finland | 279 | 2 | 1 | 61.9241 | 25.7482 | 2020-03-14T22:33:03 | |||||
2020-03-13 | Finland | 251 | 1 | 1 | 61.9241 | 25.7482 | 2020-03-11T20:00:00 | |||||
2020-03-12 | Finland | 191 | 1 | 1 | 64.0 | 26.0 | 2020-03-11T13:33:10 | |||||
2020-03-11 | Finland | 115 | 1 | 1 | 64.0 | 26.0 | 2020-03-11T13:33:10 | |||||
2020-03-10 | Finland | 61 | 1 | 1 | 64.0 | 26.0 | 2020-03-10T10:13:30 | |||||
2020-03-09 | Finland | 44 | 1 | 1 | 64.0 | 26.0 | 2020-03-09T09:23:03 | |||||
2020-03-08 | Finland | 35 | 1 | 1 | 64.0 | 26.0 | 2020-03-08T10:03:13 | |||||
2020-03-07 | Finland | 28 | 1 | 1 | 64.0 | 26.0 | 2020-03-06T13:03:12 | |||||
2020-03-06 | Finland | 21 | 0 | 1 | 64.0 | 26.0 | 2020-03-06T13:03:12 | |||||
2020-03-05 | Finland | 20 | 0 | 1 | 64.0 | 26.0 | 2020-03-05T13:53:03 | |||||
2020-03-04 | Finland | 14 | 0 | 1 | 64.0 | 26.0 | 2020-03-01T23:23:02 | |||||
2020-03-03 | Finland | 10 | 0 | 1 | 64.0 | 26.0 | 2020-03-01T23:23:02 | |||||
2020-03-02 | Finland | 10 | 0 | 1 | 64.0 | 26.0 | 2020-03-01T23:23:02 | |||||
2020-03-01 | Finland | 9 | 0 | 1 | 64.0 | 26.0 | 2020-03-01T23:23:02 | |||||
2020-02-29 | Finland | 8 | 0 | 1 | 2020-02-29T05:23:03 | |||||||
2020-02-28 | Finland | 5 | 0 | 1 | 2020-02-26T19:03:08 | |||||||
2020-02-27 | Finland | 4 | 0 | 1 | 2020-02-26T19:03:08 | |||||||
2020-02-26 | Finland | 4 | 0 | 1 | 2020-02-26T19:03:08 | |||||||
2020-02-25 | Finland | 3 | 0 | 1 | 2020-02-12T00:03:12 | |||||||
2020-02-24 | Finland | 3 | 0 | 1 | 2020-02-12T00:03:12 | |||||||
2020-02-23 | Finland | 3 | 0 | 1 | 2020-02-12T00:03:12 | |||||||
2020-02-22 | Finland | 2 | 0 | 1 | 2020-02-12T00:03:12 | |||||||
2020-02-21 | Finland | 2 | 0 | 1 | 2020-02-12T00:03:12 | |||||||
2020-02-20 | Finland | 2 | 0 | 1 | 2020-02-12T00:03:12 | |||||||
2020-02-19 | Finland | 2 | 0 | 1 | 2020-02-12T00:03:12 | |||||||
2020-02-18 | Finland | 2 | 0 | 1 | 2020-02-12T00:03:12 | |||||||
2020-02-17 | Finland | 2 | 0 | 1 | 2020-02-12T00:03:12 | |||||||
2020-02-16 | Finland | 2 | 0 | 1 | 2020-02-12T00:03:12 | |||||||
2020-02-15 | Finland | 2 | 0 | 1 | 2020-02-12T00:03:12 | |||||||
2020-02-14 | Finland | 2 | 0 | 1 | 2020-02-12T00:03:12 | |||||||
2020-02-13 | Finland | 2 | 0 | 1 | 2020-02-12T00:03:12 | |||||||
2020-02-12 | Finland | 2 | 0 | 1 | 2020-02-12T00:03:12 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;