daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10 rows where country_or_region = "Taiwan*" and deaths = 2 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
country_or_region 1
- Taiwan* · 10 ✖
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-29 | Taiwan* | 298 | 2 | 30 | 266 | 23.7 | 121.0 | 3/29/20 8:04 | Taiwan* | |||
2020-03-28 | Taiwan* | 283 | 2 | 30 | 251 | 23.7 | 121.0 | 3/28/20 6:58 | Taiwan* | |||
2020-03-27 | Taiwan* | 267 | 2 | 29 | 236 | 23.7 | 121.0 | 2020-03-27 06:33:04 | Taiwan* | |||
2020-03-26 | Taiwan* | 252 | 2 | 29 | 221 | 23.7 | 121.0 | 2020-03-26 07:31:30 | Taiwan* | |||
2020-03-25 | Taiwan* | 235 | 2 | 29 | 204 | 23.7 | 121.0 | 2020-03-25 08:02:14 | Taiwan* | |||
2020-03-24 | Taiwan* | 215 | 2 | 29 | 184 | 23.7 | 121.0 | 2020-03-24 07:38:21 | Taiwan* | |||
2020-03-23 | Taiwan* | 195 | 2 | 28 | 165 | 23.7 | 121.0 | 2020-03-23 06:45:13 | Taiwan* | |||
2020-03-22 | Taiwan* | 169 | 2 | 28 | 139 | 23.7 | 121.0 | 3/22/20 8:11 | Taiwan* | |||
2020-03-21 | Taiwan* | 153 | 2 | 28 | 23.7 | 121.0 | 2020-03-21T07:43:02 | |||||
2020-03-20 | Taiwan* | 135 | 2 | 26 | 23.7 | 121.0 | 2020-03-20T09:43:03 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;