daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
5 rows where deaths = 326 and province_or_state = "Putumayo" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: active, day (date), last_update (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-04-08 | Colombia | Putumayo | 8301 | 326 | 7872 | 103 | 0.436 | -75.5277 | 2021-04-09 04:21:13 | Putumayo, Colombia | ||
2021-04-07 | Colombia | Putumayo | 8289 | 326 | 7860 | 103 | 0.436 | -75.5277 | 2021-04-08 04:21:13 | Putumayo, Colombia | ||
2021-04-06 | Colombia | Putumayo | 8276 | 326 | 7834 | 116 | 0.436 | -75.5277 | 2021-04-07 04:20:53 | Putumayo, Colombia | ||
2021-04-05 | Colombia | Putumayo | 8247 | 326 | 7821 | 100 | 0.436 | -75.5277 | 2021-04-06 04:20:32 | Putumayo, Colombia | ||
2021-04-04 | Colombia | Putumayo | 8234 | 326 | 7807 | 101 | 0.436 | -75.5277 | 2021-04-05 04:20:35 | Putumayo, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;