daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
74 rows where country_or_region = "Colombia" and deaths = 6 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
province_or_state 15
country_or_region 1
- Colombia · 74 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-10-14 | Colombia | Vichada | 708 | 6 | 638 | 64 | 4.4234 | -69.2878 | 2020-10-15 04:24:28 | Vichada, Colombia | ||
2020-09-23 | Colombia | Vaupes | 731 | 6 | 583 | 142 | 0.8554 | -70.812 | 2020-09-24 04:23:00 | Vaupes, Colombia | ||
2020-09-22 | Colombia | Vaupes | 712 | 6 | 556 | 150 | 0.8554 | -70.812 | 2020-09-23 04:23:00 | Vaupes, Colombia | ||
2020-09-21 | Colombia | Vaupes | 693 | 6 | 556 | 131 | 0.8554 | -70.812 | 2020-09-22 04:23:00 | Vaupes, Colombia | ||
2020-09-20 | Colombia | Vaupes | 693 | 6 | 530 | 157 | 0.8554 | -70.812 | 2020-09-21 04:23:00 | Vaupes, Colombia | ||
2020-09-15 | Colombia | Guaviare | 518 | 6 | 338 | 174 | 1.0654 | -73.2603 | 2020-09-16 04:22:53 | Guaviare, Colombia | ||
2020-09-11 | Colombia | San Andres y Providencia | 431 | 6 | 232 | 193 | 12.5567 | -81.7185 | 2020-09-12 04:25:05 | San Andres y Providencia, Colombia | ||
2020-09-08 | Colombia | Guainia | 277 | 6 | 57 | 214 | 2.5854 | -68.5247 | 2020-09-09 04:28:48 | Guainia, Colombia | ||
2020-09-07 | Colombia | Guainia | 171 | 6 | 54 | 111 | 2.5854 | -68.5247 | 2020-09-08 04:28:25 | Guainia, Colombia | ||
2020-09-06 | Colombia | Guainia | 171 | 6 | 54 | 111 | 2.5854 | -68.5247 | 2020-09-07 04:28:30 | Guainia, Colombia | ||
2020-09-05 | Colombia | Guainia | 165 | 6 | 49 | 110 | 2.5854 | -68.5247 | 2020-09-06 04:28:33 | Guainia, Colombia | ||
2020-08-08 | Colombia | Casanare | 443 | 6 | 178 | 259 | 5.7589 | -71.5724 | 2020-08-09 04:34:54 | Casanare, Colombia | ||
2020-08-07 | Colombia | Casanare | 427 | 6 | 172 | 249 | 5.7589 | -71.5724 | 2020-08-08 04:34:53 | Casanare, Colombia | ||
2020-08-06 | Colombia | Arauca | 305 | 6 | 160 | 139 | 7.0762 | -70.7105 | 2020-08-07 04:35:11 | Arauca, Colombia | ||
2020-08-06 | Colombia | Casanare | 414 | 6 | 161 | 247 | 5.7589 | -71.5724 | 2020-08-07 04:35:11 | Casanare, Colombia | ||
2020-08-05 | Colombia | Casanare | 389 | 6 | 154 | 229 | 5.7589 | -71.5724 | 2020-08-06 04:35:02 | Casanare, Colombia | ||
2020-08-04 | Colombia | Casanare | 366 | 6 | 148 | 212 | 5.7589 | -71.5724 | 2020-08-05 04:34:43 | Casanare, Colombia | ||
2020-08-03 | Colombia | Casanare | 351 | 6 | 144 | 201 | 5.7589 | -71.5724 | 2020-08-04 04:41:59 | Casanare, Colombia | ||
2020-07-27 | Colombia | Quindio | 267 | 6 | 195 | 66 | 4.461 | -75.6674 | 2020-07-28 04:58:43 | Quindio, Colombia | ||
2020-07-26 | Colombia | Quindio | 245 | 6 | 189 | 50 | 4.461 | -75.6674 | 2020-07-27 04:35:02 | Quindio, Colombia | ||
2020-07-25 | Colombia | Quindio | 245 | 6 | 189 | 50 | 4.461 | -75.6674 | 2020-07-26 04:35:00 | Quindio, Colombia | ||
2020-07-24 | Colombia | Quindio | 235 | 6 | 185 | 44 | 4.461 | -75.6674 | 2020-07-25 04:47:39 | Quindio, Colombia | ||
2020-07-23 | Colombia | Quindio | 226 | 6 | 173 | 47 | 4.461 | -75.6674 | 2020-07-24 05:30:40 | Quindio, Colombia | ||
2020-07-22 | Colombia | Quindio | 223 | 6 | 170 | 47 | 4.461 | -75.6674 | 2020-07-23 05:15:04 | Quindio, Colombia | ||
2020-07-21 | Colombia | Quindio | 215 | 6 | 168 | 41 | 4.461 | -75.6674 | 2020-07-22 04:34:42 | Quindio, Colombia | ||
2020-07-20 | Colombia | Quindio | 215 | 6 | 166 | 43 | 4.461 | -75.6674 | 2020-07-21 04:38:46 | Quindio, Colombia | ||
2020-07-16 | Colombia | Quindio | 204 | 6 | 149 | 49 | 4.461 | -75.6674 | 2020-07-17 04:34:50 | Quindio, Colombia | ||
2020-07-15 | Colombia | Quindio | 204 | 6 | 145 | 53 | 4.461 | -75.6674 | 2020-07-16 04:44:59 | Quindio, Colombia | ||
2020-07-14 | Colombia | Quindio | 195 | 6 | 142 | 47 | 4.461 | -75.6674 | 2020-07-15 04:34:39 | Quindio, Colombia | ||
2020-07-13 | Colombia | Quindio | 195 | 6 | 142 | 47 | 4.461 | -75.6674 | 2020-07-14 04:34:46 | Quindio, Colombia | ||
2020-07-12 | Colombia | Quindio | 193 | 6 | 142 | 45 | 4.461 | -75.6674 | 2020-07-13 04:43:04 | Quindio, Colombia | ||
2020-07-11 | Colombia | Quindio | 194 | 6 | 139 | 49 | 4.461 | -75.6674 | 2020-07-12 04:34:30 | Quindio, Colombia | ||
2020-07-10 | Colombia | Quindio | 188 | 6 | 137 | 45 | 4.461 | -75.6674 | 2020-07-11 04:34:26 | Quindio, Colombia | ||
2020-07-09 | Colombia | Quindio | 180 | 6 | 134 | 40 | 4.461 | -75.6674 | 2020-07-10 04:34:24 | Quindio, Colombia | ||
2020-07-08 | Colombia | Quindio | 177 | 6 | 131 | 40 | 4.461 | -75.6674 | 2020-07-09 04:34:23 | Quindio, Colombia | ||
2020-07-07 | Colombia | Quindio | 177 | 6 | 130 | 41 | 4.461 | -75.6674 | 2020-07-08 05:33:48 | Quindio, Colombia | ||
2020-07-06 | Colombia | Quindio | 177 | 6 | 122 | 49 | 4.461 | -75.6674 | 2020-07-07 04:34:00 | Quindio, Colombia | ||
2020-07-05 | Colombia | Quindio | 177 | 6 | 119 | 52 | 4.461 | -75.6674 | 2020-07-06 04:33:57 | Quindio, Colombia | ||
2020-07-04 | Colombia | Quindio | 169 | 6 | 118 | 45 | 4.461 | -75.6674 | 2020-07-05 04:33:46 | Quindio, Colombia | ||
2020-07-03 | Colombia | Putumayo | 29 | 6 | 9 | 14 | 0.436 | -75.5277 | 2020-07-04 04:33:51 | Putumayo, Colombia | ||
2020-07-03 | Colombia | Quindio | 168 | 6 | 117 | 45 | 4.461 | -75.6674 | 2020-07-04 04:33:51 | Quindio, Colombia | ||
2020-07-02 | Colombia | Putumayo | 28 | 6 | 9 | 13 | 0.436 | -75.5277 | 2020-07-03 04:33:54 | Putumayo, Colombia | ||
2020-07-01 | Colombia | Putumayo | 28 | 6 | 9 | 13 | 0.436 | -75.5277 | 2020-07-02 04:33:46 | Putumayo, Colombia | ||
2020-06-30 | Colombia | Putumayo | 26 | 6 | 9 | 11 | 0.436 | -75.5277 | 2020-07-01 04:33:52 | Putumayo, Colombia | ||
2020-06-29 | Colombia | Putumayo | 22 | 6 | 9 | 7 | 0.436 | -75.5277 | 2020-06-30 04:33:48 | Putumayo, Colombia | ||
2020-06-28 | Colombia | Putumayo | 22 | 6 | 9 | 7 | 0.436 | -75.5277 | 2020-06-29 04:33:44 | Putumayo, Colombia | ||
2020-06-27 | Colombia | Putumayo | 20 | 6 | 9 | 5 | 0.436 | -75.5277 | 2020-06-28 04:34:04 | Putumayo, Colombia | ||
2020-06-26 | Colombia | Putumayo | 19 | 6 | 9 | 4 | 0.436 | -75.5277 | 2020-06-27 04:33:35 | Putumayo, Colombia | ||
2020-06-25 | Colombia | Putumayo | 19 | 6 | 9 | 4 | 0.436 | -75.5277 | 2020-06-26 04:33:43 | Putumayo, Colombia | ||
2020-06-10 | Colombia | La Guajira | 113 | 6 | 44 | 63 | 11.3548 | -72.5205 | 2020-06-11 03:33:41 | La Guajira, Colombia | ||
2020-06-09 | Colombia | Cauca | 158 | 6 | 63 | 89 | 2.705 | -76.82600000000002 | 2020-06-10 04:07:00 | Cauca, Colombia | ||
2020-06-09 | Colombia | La Guajira | 109 | 6 | 44 | 59 | 11.3548 | -72.5205 | 2020-06-10 04:07:00 | La Guajira, Colombia | ||
2020-06-09 | Colombia | Santander | 167 | 6 | 50 | 111 | 6.6437 | -73.6536 | 2020-06-10 04:07:00 | Santander, Colombia | ||
2020-06-08 | Colombia | Cauca | 158 | 6 | 63 | 89 | 2.705 | -76.82600000000002 | 2020-06-09 03:33:03 | Cauca, Colombia | ||
2020-06-08 | Colombia | La Guajira | 109 | 6 | 44 | 59 | 11.3548 | -72.5205 | 2020-06-09 03:33:03 | La Guajira, Colombia | ||
2020-06-08 | Colombia | Santander | 167 | 6 | 50 | 111 | 6.6437 | -73.6536 | 2020-06-09 03:33:03 | Santander, Colombia | ||
2020-06-04 | Colombia | Caldas | 156 | 6 | 105 | 45 | 5.2983 | -75.2479 | 2020-06-05 02:33:06 | Caldas, Colombia | ||
2020-06-03 | Colombia | Caldas | 147 | 6 | 105 | 36 | 5.2983 | -75.2479 | 2020-06-04 02:33:14 | Caldas, Colombia | ||
2020-06-02 | Colombia | Caldas | 138 | 6 | 97 | 35 | 5.2983 | -75.2479 | 2020-06-03 02:33:13 | Caldas, Colombia | ||
2020-06-01 | Colombia | Caldas | 135 | 6 | 94 | 35 | 5.2983 | -75.2479 | 2020-06-02 02:33:08 | Caldas, Colombia | ||
2020-05-31 | Colombia | Caldas | 135 | 6 | 88 | 41 | 5.2983 | -75.2479 | 2020-06-01 02:32:46 | Caldas, Colombia | ||
2020-05-31 | Colombia | Cordoba | 121 | 6 | 27 | 88 | 8.0493 | -75.574 | 2020-06-01 02:32:46 | Cordoba, Colombia | ||
2020-05-30 | Colombia | Antioquia | 1024 | 6 | 449 | 569 | 7.1986 | -75.3412 | 2020-05-31 02:32:45 | Antioquia, Colombia | ||
2020-05-30 | Colombia | Caldas | 135 | 6 | 87 | 42 | 5.2983 | -75.2479 | 2020-05-31 02:32:45 | Caldas, Colombia | ||
2020-05-30 | Colombia | Cordoba | 110 | 6 | 27 | 77 | 8.0493 | -75.574 | 2020-05-31 02:32:45 | Cordoba, Colombia | ||
2020-05-29 | Colombia | Antioquia | 1005 | 6 | 409 | 590 | 7.1986 | -75.3412 | 2020-05-30 02:32:48 | Antioquia, Colombia | ||
2020-05-29 | Colombia | Caldas | 135 | 6 | 84 | 45 | 5.2983 | -75.2479 | 2020-05-30 02:32:48 | Caldas, Colombia | ||
2020-05-29 | Colombia | Cordoba | 101 | 6 | 25 | 70 | 8.0493 | -75.574 | 2020-05-30 02:32:48 | Cordoba, Colombia | ||
2020-05-28 | Colombia | Antioquia | 960 | 6 | 405 | 549 | 7.1986 | -75.3412 | 2020-05-29 02:32:50 | Antioquia, Colombia | ||
2020-05-28 | Colombia | Caldas | 134 | 6 | 82 | 46 | 5.2983 | -75.2479 | 2020-05-29 02:32:50 | Caldas, Colombia | ||
2020-05-28 | Colombia | Cordoba | 96 | 6 | 23 | 67 | 8.0493 | -75.574 | 2020-05-29 02:32:50 | Cordoba, Colombia | ||
2020-03-28 | Colombia | 608 | 6 | 10 | 592 | 4.5709 | -74.2973 | 3/28/20 23:05 | Colombia | |||
2020-03-27 | Colombia | 539 | 6 | 10 | 523 | 4.5709 | -74.2973 | 2020-03-27 23:23:03 | Colombia | |||
2020-03-26 | Colombia | 491 | 6 | 8 | 477 | 4.5709 | -74.2973 | 2020-03-26 23:48:18 | Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;