daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where active = 11 and province_or_state = "Vichada" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, recovered, 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-03-21 | Colombia | Vichada | 1403 | 23 | 1369 | 11 | 4.4234 | -69.2878 | 2021-03-22 05:25:43 | Vichada, Colombia | ||
2021-03-04 | Colombia | Vichada | 1377 | 22 | 1344 | 11 | 4.4234 | -69.2878 | 2021-03-05 05:26:29 | Vichada, Colombia | ||
2021-03-03 | Colombia | Vichada | 1377 | 22 | 1344 | 11 | 4.4234 | -69.2878 | 2021-03-04 05:24:24 | Vichada, Colombia | ||
2021-02-27 | Colombia | Vichada | 1364 | 22 | 1331 | 11 | 4.4234 | -69.2878 | 2021-02-28 05:22:20 | Vichada, Colombia | ||
2021-01-14 | Colombia | Vichada | 1174 | 17 | 1146 | 11 | 4.4234 | -69.2878 | 2021-01-15 05:22:24 | Vichada, Colombia | ||
2020-12-31 | Colombia | Vichada | 1150 | 14 | 1125 | 11 | 4.4234 | -69.2878 | 2021-01-01 05:23:07 | Vichada, Colombia | ||
2020-11-11 | Colombia | Vichada | 850 | 11 | 828 | 11 | 4.4234 | -69.2878 | 2020-11-12 05:25:55 | Vichada, Colombia | ||
2020-11-06 | Colombia | Vichada | 836 | 10 | 815 | 11 | 4.4234 | -69.2878 | 2020-11-07 05:24:52 | Vichada, Colombia | ||
2020-10-25 | Colombia | Vichada | 756 | 9 | 736 | 11 | 4.4234 | -69.2878 | 2020-10-26 04:25:02 | Vichada, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;