daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where deaths = 59 and province_or_state = "Vichada" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, day (date), last_update (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-02-16 | Colombia | Vichada | 3355 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-17 04:20:56 | Vichada, Colombia | |||
2022-02-15 | Colombia | Vichada | 3352 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-16 04:21:10 | Vichada, Colombia | |||
2022-02-14 | Colombia | Vichada | 3351 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-15 04:21:09 | Vichada, Colombia | |||
2022-02-13 | Colombia | Vichada | 3349 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-14 04:20:51 | Vichada, Colombia | |||
2022-02-12 | Colombia | Vichada | 3349 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-13 04:21:00 | Vichada, Colombia | |||
2022-02-11 | Colombia | Vichada | 3343 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-12 04:21:06 | Vichada, Colombia | |||
2022-02-10 | Colombia | Vichada | 3327 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-11 04:21:09 | Vichada, Colombia | |||
2022-02-09 | Colombia | Vichada | 3327 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-10 04:21:14 | Vichada, Colombia | |||
2022-02-08 | Colombia | Vichada | 3330 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-09 04:21:04 | Vichada, Colombia | |||
2022-02-07 | Colombia | Vichada | 3329 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-08 04:21:15 | Vichada, Colombia | |||
2022-02-06 | Colombia | Vichada | 3321 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-07 04:21:05 | Vichada, Colombia | |||
2022-02-05 | Colombia | Vichada | 3312 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-06 04:21:00 | Vichada, Colombia | |||
2022-02-04 | Colombia | Vichada | 3297 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-05 04:21:05 | Vichada, Colombia | |||
2022-02-03 | Colombia | Vichada | 3296 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-04 04:21:10 | Vichada, Colombia | |||
2022-02-02 | Colombia | Vichada | 3288 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-03 04:21:21 | Vichada, Colombia | |||
2022-02-01 | Colombia | Vichada | 3265 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-02 04:21:09 | Vichada, Colombia | |||
2022-01-31 | Colombia | Vichada | 3242 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-01 04:21:11 | Vichada, Colombia | |||
2022-01-30 | Colombia | Vichada | 3242 | 59 | 0 | 4.4234 | -69.2878 | 2022-01-31 04:21:09 | Vichada, Colombia | |||
2022-01-29 | Colombia | Vichada | 3209 | 59 | 0 | 4.4234 | -69.2878 | 2022-01-30 04:21:26 | Vichada, Colombia | |||
2022-01-28 | Colombia | Vichada | 3199 | 59 | 0 | 4.4234 | -69.2878 | 2022-01-29 04:21:10 | Vichada, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;