daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10 rows where deaths = 24 and province_or_state = "Vichada" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-05-13 | Colombia | Vichada | 1603 | 24 | 1570 | 9 | 4.4234 | -69.2878 | 2021-05-14 04:20:41 | Vichada, Colombia | ||
2021-05-12 | Colombia | Vichada | 1602 | 24 | 1569 | 9 | 4.4234 | -69.2878 | 2021-05-13 04:20:51 | Vichada, Colombia | ||
2021-05-11 | Colombia | Vichada | 1598 | 24 | 1568 | 6 | 4.4234 | -69.2878 | 2021-05-12 04:21:29 | Vichada, Colombia | ||
2021-05-10 | Colombia | Vichada | 1597 | 24 | 1556 | 17 | 4.4234 | -69.2878 | 2021-05-11 04:20:41 | Vichada, Colombia | ||
2021-05-09 | Colombia | Vichada | 1596 | 24 | 1556 | 16 | 4.4234 | -69.2878 | 2021-05-10 04:20:38 | Vichada, Colombia | ||
2021-05-08 | Colombia | Vichada | 1596 | 24 | 1553 | 19 | 4.4234 | -69.2878 | 2021-05-09 04:20:35 | Vichada, Colombia | ||
2021-05-07 | Colombia | Vichada | 1591 | 24 | 1542 | 25 | 4.4234 | -69.2878 | 2021-05-08 04:21:04 | Vichada, Colombia | ||
2021-05-06 | Colombia | Vichada | 1580 | 24 | 1539 | 17 | 4.4234 | -69.2878 | 2021-05-07 04:20:40 | Vichada, Colombia | ||
2021-05-05 | Colombia | Vichada | 1566 | 24 | 1525 | 17 | 4.4234 | -69.2878 | 2021-05-06 04:20:38 | Vichada, Colombia | ||
2021-05-04 | Colombia | Vichada | 1554 | 24 | 1522 | 8 | 4.4234 | -69.2878 | 2021-05-05 04:20:43 | Vichada, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;