daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
7 rows where country_or_region = "Malawi" and deaths = 175 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
country_or_region 1
- Malawi · 7 ✖
province_or_state 0
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-09-06 | Malawi | 5614 | 175 | 3551 | 1888 | -13.2543 | 34.3015 | 2020-09-07 04:28:30 | Malawi | |||
2020-09-05 | Malawi | 5611 | 175 | 3551 | 1885 | -13.2543 | 34.3015 | 2020-09-06 04:28:33 | Malawi | |||
2020-09-04 | Malawi | 5608 | 175 | 3533 | 1900 | -13.2543 | 34.3015 | 2020-09-05 04:28:19 | Malawi | |||
2020-09-03 | Malawi | 5593 | 175 | 3516 | 1902 | -13.2543 | 34.3015 | 2020-09-04 04:28:26 | Malawi | |||
2020-09-02 | Malawi | 5579 | 175 | 3500 | 1904 | -13.2543 | 34.3015 | 2020-09-03 04:28:22 | Malawi | |||
2020-09-01 | Malawi | 5576 | 175 | 3420 | 1981 | -13.2543 | 34.3015 | 2020-09-02 04:28:25 | Malawi | |||
2020-08-31 | Malawi | 5566 | 175 | 3160 | 2231 | -13.2543 | 34.3015 | 2020-09-01 04:28:31 | Malawi |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;