daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where active = 7 and province_or_state = "Vichada" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, 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-04-27 | Colombia | Vichada | 1538 | 23 | 1508 | 7 | 4.4234 | -69.2878 | 2021-04-28 04:20:32 | Vichada, Colombia | ||
2021-04-21 | Colombia | Vichada | 1528 | 23 | 1498 | 7 | 4.4234 | -69.2878 | 2021-04-22 04:20:53 | Vichada, Colombia | ||
2021-03-25 | Colombia | Vichada | 1403 | 23 | 1373 | 7 | 4.4234 | -69.2878 | 2021-03-26 05:26:55 | Vichada, Colombia | ||
2021-03-24 | Colombia | Vichada | 1403 | 23 | 1373 | 7 | 4.4234 | -69.2878 | 2021-03-25 05:27:00 | Vichada, Colombia | ||
2021-03-16 | Colombia | Vichada | 1395 | 23 | 1365 | 7 | 4.4234 | -69.2878 | 2021-03-17 05:25:07 | Vichada, Colombia | ||
2021-03-12 | Colombia | Vichada | 1387 | 22 | 1358 | 7 | 4.4234 | -69.2878 | 2021-03-13 05:25:15 | Vichada, Colombia | ||
2021-03-11 | Colombia | Vichada | 1386 | 22 | 1357 | 7 | 4.4234 | -69.2878 | 2021-03-12 05:26:50 | 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-19 | Colombia | Vichada | 1343 | 21 | 1315 | 7 | 4.4234 | -69.2878 | 2021-02-20 05:22:51 | 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-05 | Colombia | Vichada | 1291 | 21 | 1263 | 7 | 4.4234 | -69.2878 | 2021-02-06 05:23:55 | Vichada, Colombia | ||
2020-12-04 | Colombia | Vichada | 931 | 12 | 912 | 7 | 4.4234 | -69.2878 | 2020-12-05 05:27:36 | Vichada, Colombia | ||
2020-11-29 | Colombia | Vichada | 898 | 11 | 880 | 7 | 4.4234 | -69.2878 | 2020-11-30 05:26:13 | Vichada, Colombia | ||
2020-11-26 | Colombia | Vichada | 884 | 11 | 866 | 7 | 4.4234 | -69.2878 | 2020-11-27 05:26:53 | Vichada, Colombia | ||
2020-11-25 | Colombia | Vichada | 884 | 11 | 866 | 7 | 4.4234 | -69.2878 | 2020-11-26 05:27:44 | Vichada, Colombia | ||
2020-11-24 | Colombia | Vichada | 884 | 11 | 866 | 7 | 4.4234 | -69.2878 | 2020-11-25 05:27:20 | Vichada, Colombia | ||
2020-11-23 | Colombia | Vichada | 884 | 11 | 866 | 7 | 4.4234 | -69.2878 | 2020-11-24 05:27:31 | Vichada, Colombia | ||
2020-08-17 | Colombia | Vichada | 12 | 0 | 5 | 7 | 4.4234 | -69.2878 | 2020-08-18 04:27:56 | Vichada, Colombia | ||
2020-08-04 | Colombia | Vichada | 8 | 0 | 1 | 7 | 4.4234 | -69.2878 | 2020-08-05 04:34:43 | Vichada, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;