johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32,189 rows where country_or_region = "Colombia" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
province_or_state >30
- Amazonas 946
- Antioquia 946
- Arauca 946
- Atlantico 946
- Bolivar 946
- Boyaca 946
- Caldas 946
- Capital District 946
- Caqueta 946
- Casanare 946
- Cauca 946
- Cesar 946
- Choco 946
- Cordoba 946
- Cundinamarca 946
- Huila 946
- La Guajira 946
- Magdalena 946
- Meta 946
- Narino 946
- Norte de Santander 946
- Putumayo 946
- Quindio 946
- Risaralda 946
- San Andres y Providencia 946
- Santander 946
- Sucre 946
- Tolima 946
- Valle del Cauca 946
- Vaupes 946
- …
day (date) >30 ✖
- 2020-06-08 34
- 2020-06-09 34
- 2020-06-10 34
- 2020-06-11 34
- 2020-06-12 34
- 2020-06-13 34
- 2020-06-14 34
- 2020-06-15 34
- 2020-06-16 34
- 2020-06-17 34
- 2020-06-18 34
- 2020-06-19 34
- 2020-06-20 34
- 2020-06-21 34
- 2020-06-22 34
- 2020-06-23 34
- 2020-06-24 34
- 2020-06-25 34
- 2020-06-26 34
- 2020-06-27 34
- 2020-06-28 34
- 2020-06-29 34
- 2020-06-30 34
- 2020-07-01 34
- 2020-07-02 34
- 2020-07-03 34
- 2020-07-04 34
- 2020-07-05 34
- 2020-07-06 34
- 2020-07-07 34
- …
country_or_region 1
- Colombia · 32,189 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2605889 | 2605889 | 2020-09-24 | Colombia | Unknown | 0 | -178 | -12684 | 12862 | 2020-09-25 04:23:00 | Unknown, Colombia | ||||
8195 | 8195 | 2020-10-25 | Colombia | Unknown | 0 | -154 | -8072 | 8226 | 2020-10-26 04:25:02 | Unknown, Colombia | ||||
20232 | 20232 | 2021-05-28 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-05-29 04:20:41 | Unknown, Colombia | ||||
36292 | 36292 | 2021-04-12 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-04-13 04:20:37 | Unknown, Colombia | ||||
50653 | 50653 | 2021-05-29 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-05-30 04:20:55 | Unknown, Colombia | ||||
54667 | 54667 | 2021-03-07 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-03-08 05:24:48 | Unknown, Colombia | ||||
61887 | 61887 | 2020-07-23 | Colombia | Guaviare | 52 | 0 | 43 | 9 | 1.0654 | -73.2603 | 2020-07-24 05:30:40 | Guaviare, Colombia | ||
62116 | 62116 | 2020-07-23 | Colombia | San Andres y Providencia | 33 | 0 | 24 | 9 | 12.5567 | -81.7185 | 2020-07-24 05:30:40 | San Andres y Providencia, Colombia | ||
62202 | 62202 | 2020-07-23 | Colombia | Vichada | 2 | 0 | 1 | 1 | 4.4234 | -69.2878 | 2020-07-24 05:30:40 | Vichada, Colombia | ||
62431 | 62431 | 2020-07-23 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-07-17 22:34:48 | Unknown, Colombia | ||||
62632 | 62632 | 2020-03-07 | Colombia | 1 | 0 | 0 | 4.5709 | -74.2973 | 2020-03-07T00:43:02 | |||||
74952 | 74952 | 2020-12-03 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-12-04 05:27:27 | Unknown, Colombia | ||||
78951 | 78951 | 2020-10-14 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-10-15 04:24:28 | Unknown, Colombia | ||||
82957 | 82957 | 2021-05-25 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-05-26 04:20:35 | Unknown, Colombia | ||||
98228 | 98228 | 2020-08-04 | Colombia | Guaviare | 115 | 0 | 58 | 57 | 1.0654 | -73.2603 | 2020-08-05 04:34:43 | Guaviare, Colombia | ||
98470 | 98470 | 2020-08-04 | Colombia | San Andres y Providencia | 45 | 0 | 32 | 13 | 12.5567 | -81.7185 | 2020-08-05 04:34:43 | San Andres y Providencia, Colombia | ||
98564 | 98564 | 2020-08-04 | Colombia | Vichada | 8 | 0 | 1 | 7 | 4.4234 | -69.2878 | 2020-08-05 04:34:43 | Vichada, Colombia | ||
98762 | 98762 | 2020-08-04 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-07-17 22:34:48 | Unknown, Colombia | ||||
107313 | 107313 | 2021-06-19 | Colombia | Unknown | 0 | 0 | 1 | 0 | 2021-06-20 04:21:48 | Unknown, Colombia | ||||
121690 | 121690 | 2020-07-19 | Colombia | Arauca | 165 | 0 | 83 | 82 | 7.0762 | -70.7105 | 2020-07-20 05:34:40 | Arauca, Colombia | ||
121821 | 121821 | 2020-07-19 | Colombia | Guaviare | 50 | 0 | 39 | 11 | 1.0654 | -73.2603 | 2020-07-20 05:34:40 | Guaviare, Colombia | ||
122062 | 122062 | 2020-07-19 | Colombia | San Andres y Providencia | 30 | 0 | 23 | 7 | 12.5567 | -81.7185 | 2020-07-20 05:34:40 | San Andres y Providencia, Colombia | ||
122155 | 122155 | 2020-07-19 | Colombia | Vichada | 2 | 0 | 1 | 1 | 4.4234 | -69.2878 | 2020-07-20 05:34:40 | Vichada, Colombia | ||
122354 | 122354 | 2020-07-19 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-07-17 22:34:48 | Unknown, Colombia | ||||
122567 | 122567 | 2020-11-18 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-11-19 05:25:23 | Unknown, Colombia | ||||
145822 | 145822 | 2020-08-15 | Colombia | Guaviare | 193 | 0 | 97 | 96 | 1.0654 | -73.2603 | 2020-08-16 04:27:42 | Guaviare, Colombia | ||
145832 | 145832 | 2020-08-15 | Colombia | San Andres y Providencia | 82 | 0 | 38 | 44 | 12.5567 | -81.7185 | 2020-08-16 04:27:42 | San Andres y Providencia, Colombia | ||
145838 | 145838 | 2020-08-15 | Colombia | Vichada | 6 | 0 | 5 | 1 | 4.4234 | -69.2878 | 2020-08-16 04:27:42 | Vichada, Colombia | ||
153845 | 153845 | 2021-01-08 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-01-09 05:22:18 | Unknown, Colombia | ||||
177139 | 177139 | 2020-07-27 | Colombia | Guaviare | 80 | 0 | 47 | 33 | 1.0654 | -73.2603 | 2020-07-28 04:58:43 | Guaviare, Colombia | ||
177380 | 177380 | 2020-07-27 | Colombia | San Andres y Providencia | 35 | 0 | 28 | 7 | 12.5567 | -81.7185 | 2020-07-28 04:58:43 | San Andres y Providencia, Colombia | ||
177473 | 177473 | 2020-07-27 | Colombia | Vichada | 2 | 0 | 1 | 1 | 4.4234 | -69.2878 | 2020-07-28 04:58:43 | Vichada, Colombia | ||
177673 | 177673 | 2020-07-27 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-07-17 22:34:48 | Unknown, Colombia | ||||
181902 | 181902 | 2021-02-21 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-02-22 05:24:21 | Unknown, Colombia | ||||
189931 | 189931 | 2021-01-11 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-01-12 05:22:15 | Unknown, Colombia | ||||
202119 | 202119 | 2020-12-25 | Colombia | Unknown | 0 | 0 | 1 | 0 | 2020-12-26 05:22:28 | Unknown, Colombia | ||||
206104 | 206104 | 2020-08-19 | Colombia | Guaviare | 198 | 0 | 134 | 64 | 1.0654 | -73.2603 | 2020-08-20 04:27:43 | Guaviare, Colombia | ||
206114 | 206114 | 2020-08-19 | Colombia | San Andres y Providencia | 112 | 0 | 42 | 70 | 12.5567 | -81.7185 | 2020-08-20 04:27:43 | San Andres y Providencia, Colombia | ||
206120 | 206120 | 2020-08-19 | Colombia | Vichada | 14 | 0 | 5 | 9 | 4.4234 | -69.2878 | 2020-08-20 04:27:43 | Vichada, Colombia | ||
217001 | 217001 | 2020-06-08 | Colombia | Arauca | 2 | 0 | 1 | 1 | 7.0762 | -70.7105 | 2020-06-09 03:33:03 | Arauca, Colombia | ||
217048 | 217048 | 2020-06-08 | Colombia | Casanare | 36 | 0 | 31 | 5 | 5.7589 | -71.5724 | 2020-06-09 03:33:03 | Casanare, Colombia | ||
217111 | 217111 | 2020-06-08 | Colombia | Guainia | 6 | 0 | 0 | 6 | 2.5854 | -68.5247 | 2020-06-09 03:33:03 | Guainia, Colombia | ||
217116 | 217116 | 2020-06-08 | Colombia | Guaviare | 1 | 0 | 0 | 1 | 1.0654 | -73.2603 | 2020-06-09 03:33:03 | Guaviare, Colombia | ||
217331 | 217331 | 2020-06-08 | Colombia | San Andres y Providencia | 17 | 0 | 15 | 2 | 12.5567 | -81.7185 | 2020-06-09 03:33:03 | San Andres y Providencia, Colombia | ||
217397 | 217397 | 2020-06-08 | Colombia | Unknown | 64 | 0 | 0 | 64 | 2020-06-09 03:33:03 | Unknown, Colombia | ||||
217411 | 217411 | 2020-06-08 | Colombia | Vaupes | 11 | 0 | 11 | 0 | 0.8554 | -70.812 | 2020-06-09 03:33:03 | Vaupes, Colombia | ||
217414 | 217414 | 2020-06-08 | Colombia | Vichada | 1 | 0 | 0 | 1 | 4.4234 | -69.2878 | 2020-06-09 03:33:03 | Vichada, Colombia | ||
237103 | 237103 | 2021-01-18 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-01-19 05:22:15 | Unknown, Colombia | ||||
241117 | 241117 | 2021-04-02 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-04-03 04:20:44 | Unknown, Colombia | ||||
272018 | 272018 | 2020-11-10 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-11-11 05:25:30 | Unknown, Colombia | ||||
280045 | 280045 | 2021-02-24 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-02-25 05:24:57 | Unknown, Colombia | ||||
286979 | 286979 | 2020-06-15 | Colombia | Arauca | 45 | 0 | 2 | 43 | 7.0762 | -70.7105 | 2020-06-16 04:33:09 | Arauca, Colombia | ||
287031 | 287031 | 2020-06-15 | Colombia | Casanare | 38 | 0 | 33 | 5 | 5.7589 | -71.5724 | 2020-06-16 04:33:09 | Casanare, Colombia | ||
287106 | 287106 | 2020-06-15 | Colombia | Guaviare | 5 | 0 | 0 | 5 | 1.0654 | -73.2603 | 2020-06-16 04:33:09 | Guaviare, Colombia | ||
287343 | 287343 | 2020-06-15 | Colombia | San Andres y Providencia | 19 | 0 | 17 | 2 | 12.5567 | -81.7185 | 2020-06-16 04:33:09 | San Andres y Providencia, Colombia | ||
287415 | 287415 | 2020-06-15 | Colombia | Unknown | 74 | 0 | 0 | 74 | 2020-06-16 04:33:09 | Unknown, Colombia | ||||
287433 | 287433 | 2020-06-15 | Colombia | Vaupes | 27 | 0 | 11 | 16 | 0.8554 | -70.812 | 2020-06-16 04:33:09 | Vaupes, Colombia | ||
287436 | 287436 | 2020-06-15 | Colombia | Vichada | 1 | 0 | 1 | 0 | 4.4234 | -69.2878 | 2020-06-16 04:33:09 | Vichada, Colombia | ||
302851 | 302851 | 2020-07-01 | Colombia | Arauca | 76 | 0 | 4 | 72 | 7.0762 | -70.7105 | 2020-07-02 04:33:46 | Arauca, Colombia | ||
302903 | 302903 | 2020-07-01 | Colombia | Casanare | 66 | 0 | 45 | 21 | 5.7589 | -71.5724 | 2020-07-02 04:33:46 | Casanare, Colombia | ||
302978 | 302978 | 2020-07-01 | Colombia | Guaviare | 38 | 0 | 6 | 32 | 1.0654 | -73.2603 | 2020-07-02 04:33:46 | Guaviare, Colombia | ||
303287 | 303287 | 2020-07-01 | Colombia | Unknown | 122 | 0 | 0 | 122 | 2020-07-02 04:33:46 | Unknown, Colombia | ||||
303305 | 303305 | 2020-07-01 | Colombia | Vaupes | 28 | 0 | 13 | 15 | 0.8554 | -70.812 | 2020-07-02 04:33:46 | Vaupes, Colombia | ||
303308 | 303308 | 2020-07-01 | Colombia | Vichada | 1 | 0 | 1 | 0 | 4.4234 | -69.2878 | 2020-07-02 04:33:46 | Vichada, Colombia | ||
326785 | 326785 | 2020-07-20 | Colombia | Arauca | 171 | 0 | 85 | 86 | 7.0762 | -70.7105 | 2020-07-21 04:38:46 | Arauca, Colombia | ||
326916 | 326916 | 2020-07-20 | Colombia | Guaviare | 50 | 0 | 39 | 11 | 1.0654 | -73.2603 | 2020-07-21 04:38:46 | Guaviare, Colombia | ||
327157 | 327157 | 2020-07-20 | Colombia | San Andres y Providencia | 30 | 0 | 23 | 7 | 12.5567 | -81.7185 | 2020-07-21 04:38:46 | San Andres y Providencia, Colombia | ||
327250 | 327250 | 2020-07-20 | Colombia | Vichada | 2 | 0 | 1 | 1 | 4.4234 | -69.2878 | 2020-07-21 04:38:46 | Vichada, Colombia | ||
327537 | 327537 | 2020-07-20 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-07-17 22:34:48 | Unknown, Colombia | ||||
339713 | 339713 | 2020-03-21 | Colombia | 196 | 0 | 1 | 4.5709 | -74.2973 | 2020-03-21T17:43:03 | |||||
340137 | 340137 | 2021-02-03 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-02-04 05:22:26 | Unknown, Colombia | ||||
352158 | 352158 | 2021-03-11 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-03-12 05:26:50 | Unknown, Colombia | ||||
367200 | 367200 | 2020-07-16 | Colombia | Arauca | 160 | 0 | 64 | 96 | 7.0762 | -70.7105 | 2020-07-17 04:34:50 | Arauca, Colombia | ||
367326 | 367326 | 2020-07-16 | Colombia | Guaviare | 48 | 0 | 37 | 11 | 1.0654 | -73.2603 | 2020-07-17 04:34:50 | Guaviare, Colombia | ||
367635 | 367635 | 2020-07-16 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-07-17 04:34:50 | Unknown, Colombia | ||||
367656 | 367656 | 2020-07-16 | Colombia | Vichada | 1 | 0 | 1 | 0 | 4.4234 | -69.2878 | 2020-07-17 04:34:50 | Vichada, Colombia | ||
371293 | 371293 | 2020-08-08 | Colombia | Guaviare | 128 | 0 | 62 | 66 | 1.0654 | -73.2603 | 2020-08-09 04:34:54 | Guaviare, Colombia | ||
371535 | 371535 | 2020-08-08 | Colombia | San Andres y Providencia | 49 | 0 | 33 | 16 | 12.5567 | -81.7185 | 2020-08-09 04:34:54 | San Andres y Providencia, Colombia | ||
371629 | 371629 | 2020-08-08 | Colombia | Vichada | 5 | 0 | 1 | 4 | 4.4234 | -69.2878 | 2020-08-09 04:34:54 | Vichada, Colombia | ||
371828 | 371828 | 2020-08-08 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-07-17 22:34:48 | Unknown, Colombia | ||||
376045 | 376045 | 2020-11-06 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-11-07 05:24:52 | Unknown, Colombia | ||||
380055 | 380055 | 2021-04-30 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-05-01 04:20:47 | Unknown, Colombia | ||||
388085 | 388085 | 2021-04-04 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-04-05 04:20:35 | Unknown, Colombia | ||||
392098 | 392098 | 2020-11-27 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-11-28 05:25:50 | Unknown, Colombia | ||||
400126 | 400126 | 2021-06-29 | Colombia | Unknown | 0 | 0 | 1 | 0 | 2021-06-30 04:21:41 | Unknown, Colombia | ||||
415143 | 415143 | 2020-07-05 | Colombia | Arauca | 96 | 0 | 7 | 89 | 7.0762 | -70.7105 | 2020-07-06 04:33:57 | Arauca, Colombia | ||
415195 | 415195 | 2020-07-05 | Colombia | Casanare | 85 | 0 | 48 | 37 | 5.7589 | -71.5724 | 2020-07-06 04:33:57 | Casanare, Colombia | ||
415270 | 415270 | 2020-07-05 | Colombia | Guaviare | 39 | 0 | 7 | 32 | 1.0654 | -73.2603 | 2020-07-06 04:33:57 | Guaviare, Colombia | ||
415578 | 415578 | 2020-07-05 | Colombia | Unknown | 148 | 0 | 0 | 148 | 2020-07-06 04:33:57 | Unknown, Colombia | ||||
415599 | 415599 | 2020-07-05 | Colombia | Vichada | 1 | 0 | 1 | 0 | 4.4234 | -69.2878 | 2020-07-06 04:33:57 | Vichada, Colombia | ||
435218 | 435218 | 2021-01-21 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-01-22 05:22:10 | Unknown, Colombia | ||||
442452 | 442452 | 2020-07-26 | Colombia | Guaviare | 77 | 0 | 43 | 34 | 1.0654 | -73.2603 | 2020-07-27 04:35:02 | Guaviare, Colombia | ||
442693 | 442693 | 2020-07-26 | Colombia | San Andres y Providencia | 33 | 0 | 27 | 6 | 12.5567 | -81.7185 | 2020-07-27 04:35:02 | San Andres y Providencia, Colombia | ||
442786 | 442786 | 2020-07-26 | Colombia | Vichada | 2 | 0 | 1 | 1 | 4.4234 | -69.2878 | 2020-07-27 04:35:02 | Vichada, Colombia | ||
442986 | 442986 | 2020-07-26 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-07-17 22:34:48 | Unknown, Colombia | ||||
458477 | 458477 | 2020-08-07 | Colombia | Guaviare | 126 | 0 | 60 | 66 | 1.0654 | -73.2603 | 2020-08-08 04:34:53 | Guaviare, Colombia | ||
458719 | 458719 | 2020-08-07 | Colombia | San Andres y Providencia | 48 | 0 | 32 | 16 | 12.5567 | -81.7185 | 2020-08-08 04:34:53 | San Andres y Providencia, Colombia | ||
458813 | 458813 | 2020-08-07 | Colombia | Vichada | 13 | 0 | 1 | 12 | 4.4234 | -69.2878 | 2020-08-08 03:35:04 | Vichada, Colombia | ||
459012 | 459012 | 2020-08-07 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-07-17 22:34:48 | Unknown, Colombia | ||||
471274 | 471274 | 2021-02-19 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-02-20 05:22:51 | Unknown, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);