daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
27 rows where deaths = 14 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-01-09 | Colombia | Vichada | 1166 | 14 | 1140 | 12 | 4.4234 | -69.2878 | 2021-01-10 05:22:12 | Vichada, Colombia | ||
2021-01-08 | Colombia | Vichada | 1166 | 14 | 1136 | 16 | 4.4234 | -69.2878 | 2021-01-09 05:22:18 | Vichada, Colombia | ||
2021-01-07 | Colombia | Vichada | 1160 | 14 | 1134 | 12 | 4.4234 | -69.2878 | 2021-01-08 05:22:42 | Vichada, Colombia | ||
2021-01-06 | Colombia | Vichada | 1160 | 14 | 1133 | 13 | 4.4234 | -69.2878 | 2021-01-07 05:22:03 | Vichada, Colombia | ||
2021-01-05 | Colombia | Vichada | 1160 | 14 | 1133 | 13 | 4.4234 | -69.2878 | 2021-01-06 05:22:16 | Vichada, Colombia | ||
2021-01-04 | Colombia | Vichada | 1157 | 14 | 1133 | 10 | 4.4234 | -69.2878 | 2021-01-05 05:21:49 | Vichada, Colombia | ||
2021-01-03 | Colombia | Vichada | 1157 | 14 | 1133 | 10 | 4.4234 | -69.2878 | 2021-01-04 05:22:02 | Vichada, Colombia | ||
2021-01-02 | Colombia | Vichada | 1157 | 14 | 1126 | 17 | 4.4234 | -69.2878 | 2021-01-03 05:22:52 | Vichada, Colombia | ||
2021-01-01 | Colombia | Vichada | 1150 | 14 | 1126 | 10 | 4.4234 | -69.2878 | 2021-01-02 05:22:33 | Vichada, Colombia | ||
2020-12-31 | Colombia | Vichada | 1150 | 14 | 1125 | 11 | 4.4234 | -69.2878 | 2021-01-01 05:23:07 | Vichada, Colombia | ||
2020-12-30 | Colombia | Vichada | 1148 | 14 | 1124 | 10 | 4.4234 | -69.2878 | 2020-12-31 05:22:49 | Vichada, Colombia | ||
2020-12-29 | Colombia | Vichada | 1148 | 14 | 1115 | 19 | 4.4234 | -69.2878 | 2020-12-30 05:22:34 | Vichada, Colombia | ||
2020-12-28 | Colombia | Vichada | 1141 | 14 | 1111 | 16 | 4.4234 | -69.2878 | 2020-12-29 05:22:37 | Vichada, Colombia | ||
2020-12-27 | Colombia | Vichada | 1137 | 14 | 1109 | 14 | 4.4234 | -69.2878 | 2020-12-28 05:22:06 | Vichada, Colombia | ||
2020-12-26 | Colombia | Vichada | 1137 | 14 | 1108 | 15 | 4.4234 | -69.2878 | 2020-12-27 05:22:55 | Vichada, Colombia | ||
2020-12-25 | Colombia | Vichada | 1137 | 14 | 1104 | 19 | 4.4234 | -69.2878 | 2020-12-26 05:22:28 | Vichada, Colombia | ||
2020-12-24 | Colombia | Vichada | 1133 | 14 | 1104 | 15 | 4.4234 | -69.2878 | 2020-12-25 05:22:48 | Vichada, Colombia | ||
2020-12-23 | Colombia | Vichada | 1133 | 14 | 1084 | 35 | 4.4234 | -69.2878 | 2020-12-24 05:23:04 | Vichada, Colombia | ||
2020-12-22 | Colombia | Vichada | 1110 | 14 | 1080 | 16 | 4.4234 | -69.2878 | 2020-12-23 05:22:03 | Vichada, Colombia | ||
2020-12-21 | Colombia | Vichada | 1107 | 14 | 1074 | 19 | 4.4234 | -69.2878 | 2020-12-22 05:22:33 | Vichada, Colombia | ||
2020-12-20 | Colombia | Vichada | 1103 | 14 | 1074 | 15 | 4.4234 | -69.2878 | 2020-12-21 05:27:58 | Vichada, Colombia | ||
2020-12-19 | Colombia | Vichada | 1103 | 14 | 1069 | 20 | 4.4234 | -69.2878 | 2020-12-20 05:27:32 | Vichada, Colombia | ||
2020-12-18 | Colombia | Vichada | 1096 | 14 | 1066 | 16 | 4.4234 | -69.2878 | 2020-12-19 05:27:52 | Vichada, Colombia | ||
2020-12-17 | Colombia | Vichada | 1093 | 14 | 1066 | 13 | 4.4234 | -69.2878 | 2020-12-18 05:28:18 | Vichada, Colombia | ||
2020-12-16 | Colombia | Vichada | 1093 | 14 | 1046 | 33 | 4.4234 | -69.2878 | 2020-12-17 05:28:12 | Vichada, Colombia | ||
2020-12-15 | Colombia | Vichada | 1072 | 14 | 1041 | 17 | 4.4234 | -69.2878 | 2020-12-16 05:28:04 | Vichada, Colombia | ||
2020-12-14 | Colombia | Vichada | 1072 | 14 | 1040 | 18 | 4.4234 | -69.2878 | 2020-12-15 05:26:38 | Vichada, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;