daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
7 rows where deaths = 27 and province_or_state = "Guaviare" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-11-24 | Colombia | Guaviare | 1773 | 27 | 1711 | 35 | 1.0654 | -73.2603 | 2020-11-25 05:27:20 | Guaviare, Colombia | ||
2020-11-23 | Colombia | Guaviare | 1773 | 27 | 1705 | 41 | 1.0654 | -73.2603 | 2020-11-24 05:27:31 | Guaviare, Colombia | ||
2020-11-22 | Colombia | Guaviare | 1766 | 27 | 1689 | 50 | 1.0654 | -73.2603 | 2020-11-23 05:25:26 | Guaviare, Colombia | ||
2020-11-21 | Colombia | Guaviare | 1758 | 27 | 1681 | 50 | 1.0654 | -73.2603 | 2020-11-22 05:25:45 | Guaviare, Colombia | ||
2020-11-20 | Colombia | Guaviare | 1753 | 27 | 1676 | 50 | 1.0654 | -73.2603 | 2020-11-21 05:25:51 | Guaviare, Colombia | ||
2020-11-19 | Colombia | Guaviare | 1748 | 27 | 1664 | 57 | 1.0654 | -73.2603 | 2020-11-20 05:26:28 | Guaviare, Colombia | ||
2020-11-18 | Colombia | Guaviare | 1741 | 27 | 1650 | 64 | 1.0654 | -73.2603 | 2020-11-19 05:25:23 | Guaviare, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;