daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where deaths = 21 and province_or_state = "Vichada" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, 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-02-24 | Colombia | Vichada | 1362 | 21 | 1331 | 10 | 4.4234 | -69.2878 | 2021-02-25 05:24:57 | Vichada, Colombia | ||
2021-02-23 | Colombia | Vichada | 1359 | 21 | 1331 | 7 | 4.4234 | -69.2878 | 2021-02-24 05:29:16 | Vichada, Colombia | ||
2021-02-22 | Colombia | Vichada | 1359 | 21 | 1331 | 7 | 4.4234 | -69.2878 | 2021-02-23 05:23:41 | Vichada, Colombia | ||
2021-02-21 | Colombia | Vichada | 1359 | 21 | 1331 | 7 | 4.4234 | -69.2878 | 2021-02-22 05:24:21 | Vichada, Colombia | ||
2021-02-20 | Colombia | Vichada | 1358 | 21 | 1315 | 22 | 4.4234 | -69.2878 | 2021-02-21 05:24:33 | Vichada, Colombia | ||
2021-02-19 | Colombia | Vichada | 1343 | 21 | 1315 | 7 | 4.4234 | -69.2878 | 2021-02-20 05:22:51 | Vichada, Colombia | ||
2021-02-18 | Colombia | Vichada | 1343 | 21 | 1308 | 14 | 4.4234 | -69.2878 | 2021-02-19 05:24:16 | Vichada, Colombia | ||
2021-02-17 | Colombia | Vichada | 1336 | 21 | 1308 | 7 | 4.4234 | -69.2878 | 2021-02-18 05:22:58 | Vichada, Colombia | ||
2021-02-16 | Colombia | Vichada | 1336 | 21 | 1308 | 7 | 4.4234 | -69.2878 | 2021-02-17 05:23:10 | Vichada, Colombia | ||
2021-02-15 | Colombia | Vichada | 1336 | 21 | 1308 | 7 | 4.4234 | -69.2878 | 2021-02-16 05:24:38 | Vichada, Colombia | ||
2021-02-14 | Colombia | Vichada | 1336 | 21 | 1308 | 7 | 4.4234 | -69.2878 | 2021-02-15 05:24:49 | Vichada, Colombia | ||
2021-02-13 | Colombia | Vichada | 1336 | 21 | 1307 | 8 | 4.4234 | -69.2878 | 2021-02-14 05:23:43 | Vichada, Colombia | ||
2021-02-12 | Colombia | Vichada | 1335 | 21 | 1306 | 8 | 4.4234 | -69.2878 | 2021-02-13 05:22:12 | Vichada, Colombia | ||
2021-02-11 | Colombia | Vichada | 1334 | 21 | 1294 | 19 | 4.4234 | -69.2878 | 2021-02-12 05:23:29 | Vichada, Colombia | ||
2021-02-10 | Colombia | Vichada | 1322 | 21 | 1286 | 15 | 4.4234 | -69.2878 | 2021-02-11 05:23:55 | Vichada, Colombia | ||
2021-02-09 | Colombia | Vichada | 1314 | 21 | 1284 | 9 | 4.4234 | -69.2878 | 2021-02-10 05:22:41 | Vichada, Colombia | ||
2021-02-08 | Colombia | Vichada | 1314 | 21 | 1274 | 19 | 4.4234 | -69.2878 | 2021-02-09 05:23:30 | Vichada, Colombia | ||
2021-02-07 | Colombia | Vichada | 1313 | 21 | 1263 | 29 | 4.4234 | -69.2878 | 2021-02-08 05:22:39 | Vichada, Colombia | ||
2021-02-06 | Colombia | Vichada | 1293 | 21 | 1263 | 9 | 4.4234 | -69.2878 | 2021-02-07 05:23:00 | Vichada, Colombia | ||
2021-02-05 | Colombia | Vichada | 1291 | 21 | 1263 | 7 | 4.4234 | -69.2878 | 2021-02-06 05:23:55 | Vichada, Colombia | ||
2021-02-04 | Colombia | Vichada | 1291 | 21 | 1262 | 8 | 4.4234 | -69.2878 | 2021-02-05 05:22:38 | Vichada, Colombia | ||
2021-02-03 | Colombia | Vichada | 1292 | 21 | 1232 | 39 | 4.4234 | -69.2878 | 2021-02-04 05:22:26 | Vichada, Colombia | ||
2021-02-02 | Colombia | Vichada | 1259 | 21 | 1196 | 42 | 4.4234 | -69.2878 | 2021-02-03 05:22:52 | Vichada, Colombia | ||
2021-02-01 | Colombia | Vichada | 1227 | 21 | 1196 | 10 | 4.4234 | -69.2878 | 2021-02-02 05:22:49 | Vichada, Colombia | ||
2021-01-31 | Colombia | Vichada | 1227 | 21 | 1194 | 12 | 4.4234 | -69.2878 | 2021-02-01 05:22:53 | Vichada, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;