⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

9,613 rows where country_or_region = "Colombia" sorted by day descending

View and edit SQL

Suggested facets: longitude, day (date), last_update (date)

province_or_state

country_or_region

  • Colombia · 9,613
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
953154 2021-03-05 Colombia Amazonas     5356 184 5011 161 -1.4429 -71.5724 2021-03-06 04:23:41 Amazonas, Colombia
953155 2021-03-05 Colombia Antioquia     347316 6599 335685 5032 7.1986 -75.3412 2021-03-06 04:23:41 Antioquia, Colombia
953156 2021-03-05 Colombia Arauca     5609 170 5320 119 7.0762 -70.7105 2021-03-06 04:23:41 Arauca, Colombia
953157 2021-03-05 Colombia Atlantico     124867 4055 118751 2061 10.6966 -74.8741 2021-03-06 04:23:41 Atlantico, Colombia
953158 2021-03-05 Colombia Bolivar     67207 1362 65223 622 8.6704 -74.03 2021-03-06 04:23:41 Bolivar, Colombia
953159 2021-03-05 Colombia Boyaca     46586 1101 44444 1041 5.4545 -73.362 2021-03-06 04:23:41 Boyaca, Colombia
953160 2021-03-05 Colombia Caldas     46732 982 44777 973 5.2983 -75.2479 2021-03-06 04:23:41 Caldas, Colombia
953161 2021-03-05 Colombia Capital District     661916 13936 635448 12532 4.711 -74.0721 2021-03-06 04:23:41 Capital District, Colombia
953162 2021-03-05 Colombia Caqueta     17060 636 16173 251 0.8699 -73.8419 2021-03-06 04:23:41 Caqueta, Colombia
953163 2021-03-05 Colombia Casanare     12471 273 11850 348 5.7589 -71.5724 2021-03-06 04:23:41 Casanare, Colombia
953164 2021-03-05 Colombia Cauca     27490 753 26166 571 2.705 -76.82600000000002 2021-03-06 04:23:41 Cauca, Colombia
953165 2021-03-05 Colombia Cesar     40705 1190 38844 671 9.3373 -73.6536 2021-03-06 04:23:41 Cesar, Colombia
953166 2021-03-05 Colombia Choco     6564 201 6278 85 5.2528 -76.82600000000002 2021-03-06 04:23:41 Choco, Colombia
953167 2021-03-05 Colombia Cordoba     38266 1851 35214 1201 8.0493 -75.574 2021-03-06 04:23:41 Cordoba, Colombia
953168 2021-03-05 Colombia Cundinamarca     106618 2912 101695 2011 5.026 -74.03 2021-03-06 04:23:41 Cundinamarca, Colombia
953169 2021-03-05 Colombia Guainia     1305 22 1277 6 2.5854 -68.5247 2021-03-06 04:23:41 Guainia, Colombia
953170 2021-03-05 Colombia Guaviare     2256 40 2199 17 1.0654 -73.2603 2021-03-06 04:23:41 Guaviare, Colombia
953171 2021-03-05 Colombia Huila     49931 1739 47770 422 2.5359 -75.5277 2021-03-06 04:23:41 Huila, Colombia
953172 2021-03-05 Colombia La Guajira     16305 637 15414 254 11.3548 -72.5205 2021-03-06 04:23:41 La Guajira, Colombia
953173 2021-03-05 Colombia Magdalena     35083 1326 32428 1329 10.4113 -74.4057 2021-03-06 04:23:41 Magdalena, Colombia
953174 2021-03-05 Colombia Meta     42581 974 41089 518 3.272 -73.0877 2021-03-06 04:23:41 Meta, Colombia
953175 2021-03-05 Colombia Narino     49185 1626 46561 998 1.2892 -77.3579 2021-03-06 04:23:41 Narino, Colombia
953176 2021-03-05 Colombia Norte de Santander     51007 2725 47510 772 7.9463 -72.8988 2021-03-06 04:23:41 Norte de Santander, Colombia
953177 2021-03-05 Colombia Putumayo     7929 315 7400 214 0.436 -75.5277 2021-03-06 04:23:41 Putumayo, Colombia
953178 2021-03-05 Colombia Quindio     32419 963 30918 538 4.461 -75.6674 2021-03-06 04:23:41 Quindio, Colombia
953179 2021-03-05 Colombia Risaralda     46341 1148 44356 837 5.3158 -75.9928 2021-03-06 04:23:41 Risaralda, Colombia
953180 2021-03-05 Colombia San Andres y Providencia     2709 45 2656 8 12.5567 -81.7185 2021-03-06 04:23:41 San Andres y Providencia, Colombia
953181 2021-03-05 Colombia Santander     91733 3359 86418 1956 6.6437 -73.6536 2021-03-06 04:23:41 Santander, Colombia
953182 2021-03-05 Colombia Sucre     20789 786 19547 456 8.814 -74.7233 2021-03-06 04:23:41 Sucre, Colombia
953183 2021-03-05 Colombia Tolima     65528 2108 62491 929 4.0925 -75.1545 2021-03-06 04:23:41 Tolima, Colombia
953184 2021-03-05 Colombia Unknown     0 0 0 0     2021-03-06 04:23:41 Unknown, Colombia
953185 2021-03-05 Colombia Valle del Cauca     197188 6247 186755 4186 3.8009 -76.6413 2021-03-06 04:23:41 Valle del Cauca, Colombia
953186 2021-03-05 Colombia Vaupes     1153 13 1135 5 0.8554 -70.812 2021-03-06 04:23:41 Vaupes, Colombia
953187 2021-03-05 Colombia Vichada     1377 22 1346 9 4.4234 -69.2878 2021-03-06 04:23:41 Vichada, Colombia
900514 2021-03-04 Colombia Amazonas     5316 182 4977 157 -1.4429 -71.5724 2021-03-05 05:26:29 Amazonas, Colombia
900515 2021-03-04 Colombia Antioquia     346832 6587 335052 5193 7.1986 -75.3412 2021-03-05 05:26:29 Antioquia, Colombia
900516 2021-03-04 Colombia Arauca     5599 170 5313 116 7.0762 -70.7105 2021-03-05 05:26:29 Arauca, Colombia
900517 2021-03-04 Colombia Atlantico     124518 4047 118573 1898 10.6966 -74.8741 2021-03-05 05:26:29 Atlantico, Colombia
900518 2021-03-04 Colombia Bolivar     67131 1359 65157 615 8.6704 -74.03 2021-03-05 05:26:29 Bolivar, Colombia
900519 2021-03-04 Colombia Boyaca     46490 1095 44350 1045 5.4545 -73.362 2021-03-05 05:26:29 Boyaca, Colombia
900520 2021-03-04 Colombia Caldas     46691 981 44732 978 5.2983 -75.2479 2021-03-05 05:26:29 Caldas, Colombia
900521 2021-03-04 Colombia Capital District     661207 13916 634594 12697 4.711 -74.0721 2021-03-05 05:26:29 Capital District, Colombia
900522 2021-03-04 Colombia Caqueta     17058 634 16168 256 0.8699 -73.8419 2021-03-05 05:26:29 Caqueta, Colombia
900523 2021-03-04 Colombia Casanare     12446 273 11827 346 5.7589 -71.5724 2021-03-05 05:26:29 Casanare, Colombia
900524 2021-03-04 Colombia Cauca     27467 751 26147 569 2.705 -76.82600000000002 2021-03-05 05:26:29 Cauca, Colombia
900525 2021-03-04 Colombia Cesar     40670 1186 38772 712 9.3373 -73.6536 2021-03-05 05:26:29 Cesar, Colombia
900526 2021-03-04 Colombia Choco     6561 201 6276 84 5.2528 -76.82600000000002 2021-03-05 05:26:29 Choco, Colombia
900527 2021-03-04 Colombia Cordoba     38104 1847 35066 1191 8.0493 -75.574 2021-03-05 05:26:29 Cordoba, Colombia
900528 2021-03-04 Colombia Cundinamarca     106445 2905 101475 2065 5.026 -74.03 2021-03-05 05:26:29 Cundinamarca, Colombia
900529 2021-03-04 Colombia Guainia     1305 22 1276 7 2.5854 -68.5247 2021-03-05 05:26:29 Guainia, Colombia
900530 2021-03-04 Colombia Guaviare     2252 40 2199 13 1.0654 -73.2603 2021-03-05 05:26:29 Guaviare, Colombia
900531 2021-03-04 Colombia Huila     49890 1739 47683 468 2.5359 -75.5277 2021-03-05 05:26:29 Huila, Colombia
900532 2021-03-04 Colombia La Guajira     16276 637 15382 257 11.3548 -72.5205 2021-03-05 05:26:29 La Guajira, Colombia
900533 2021-03-04 Colombia Magdalena     34769 1316 32123 1330 10.4113 -74.4057 2021-03-05 05:26:29 Magdalena, Colombia
900534 2021-03-04 Colombia Meta     42546 974 41036 536 3.272 -73.0877 2021-03-05 05:26:29 Meta, Colombia
900535 2021-03-04 Colombia Narino     49140 1625 46500 1015 1.2892 -77.3579 2021-03-05 05:26:29 Narino, Colombia
900536 2021-03-04 Colombia Norte de Santander     50961 2723 47468 770 7.9463 -72.8988 2021-03-05 05:26:29 Norte de Santander, Colombia
900537 2021-03-04 Colombia Putumayo     7922 314 7374 234 0.436 -75.5277 2021-03-05 05:26:29 Putumayo, Colombia
900538 2021-03-04 Colombia Quindio     32358 961 30853 544 4.461 -75.6674 2021-03-05 05:26:29 Quindio, Colombia
900539 2021-03-04 Colombia Risaralda     46281 1148 44300 833 5.3158 -75.9928 2021-03-05 05:26:29 Risaralda, Colombia
900540 2021-03-04 Colombia San Andres y Providencia     2709 45 2653 11 12.5567 -81.7185 2021-03-05 05:26:29 San Andres y Providencia, Colombia
900541 2021-03-04 Colombia Santander     91617 3347 86273 1997 6.6437 -73.6536 2021-03-05 05:26:29 Santander, Colombia
900542 2021-03-04 Colombia Sucre     20731 785 19494 452 8.814 -74.7233 2021-03-05 05:26:29 Sucre, Colombia
900543 2021-03-04 Colombia Tolima     65494 2107 62442 945 4.0925 -75.1545 2021-03-05 05:26:29 Tolima, Colombia
900544 2021-03-04 Colombia Unknown     0 0 0 0     2021-03-05 05:26:29 Unknown, Colombia
900545 2021-03-04 Colombia Valle del Cauca     196895 6237 186424 4234 3.8009 -76.6413 2021-03-05 05:26:29 Valle del Cauca, Colombia
900546 2021-03-04 Colombia Vaupes     1153 13 1135 5 0.8554 -70.812 2021-03-05 05:26:29 Vaupes, Colombia
900547 2021-03-04 Colombia Vichada     1377 22 1344 11 4.4234 -69.2878 2021-03-05 05:26:29 Vichada, Colombia
908239 2021-03-03 Colombia Amazonas     5284 179 4906 199 -1.4429 -71.5724 2021-03-04 05:24:24 Amazonas, Colombia
908240 2021-03-03 Colombia Antioquia     346342 6572 334621 5149 7.1986 -75.3412 2021-03-04 05:24:24 Antioquia, Colombia
908241 2021-03-03 Colombia Arauca     5590 170 5310 110 7.0762 -70.7105 2021-03-04 05:24:24 Arauca, Colombia
908242 2021-03-03 Colombia Atlantico     124266 4042 118366 1858 10.6966 -74.8741 2021-03-04 05:24:24 Atlantico, Colombia
908243 2021-03-03 Colombia Bolivar     67035 1359 65016 660 8.6704 -74.03 2021-03-04 05:24:24 Bolivar, Colombia
908244 2021-03-03 Colombia Boyaca     46407 1092 44230 1085 5.4545 -73.362 2021-03-04 05:24:24 Boyaca, Colombia
908245 2021-03-03 Colombia Caldas     46657 978 44690 989 5.2983 -75.2479 2021-03-04 05:24:24 Caldas, Colombia
908246 2021-03-03 Colombia Capital District     660487 13899 633713 12875 4.711 -74.0721 2021-03-04 05:24:24 Capital District, Colombia
908247 2021-03-03 Colombia Caqueta     17054 634 16150 270 0.8699 -73.8419 2021-03-04 05:24:24 Caqueta, Colombia
908248 2021-03-03 Colombia Casanare     12425 273 11803 349 5.7589 -71.5724 2021-03-04 05:24:24 Casanare, Colombia
908249 2021-03-03 Colombia Cauca     27446 751 26132 563 2.705 -76.82600000000002 2021-03-04 05:24:24 Cauca, Colombia
908250 2021-03-03 Colombia Cesar     40605 1186 38712 707 9.3373 -73.6536 2021-03-04 05:24:24 Cesar, Colombia
908251 2021-03-03 Colombia Choco     6559 201 6277 81 5.2528 -76.82600000000002 2021-03-04 05:24:24 Choco, Colombia
908252 2021-03-03 Colombia Cordoba     37879 1843 34772 1264 8.0493 -75.574 2021-03-04 05:24:24 Cordoba, Colombia
908253 2021-03-03 Colombia Cundinamarca     106258 2898 101266 2094 5.026 -74.03 2021-03-04 05:24:24 Cundinamarca, Colombia
908254 2021-03-03 Colombia Guainia     1304 22 1274 8 2.5854 -68.5247 2021-03-04 05:24:24 Guainia, Colombia
908255 2021-03-03 Colombia Guaviare     2252 40 2199 13 1.0654 -73.2603 2021-03-04 05:24:24 Guaviare, Colombia
908256 2021-03-03 Colombia Huila     49804 1737 47654 413 2.5359 -75.5277 2021-03-04 05:24:24 Huila, Colombia
908257 2021-03-03 Colombia La Guajira     16243 637 15338 268 11.3548 -72.5205 2021-03-04 05:24:24 La Guajira, Colombia
908258 2021-03-03 Colombia Magdalena     34453 1309 31753 1391 10.4113 -74.4057 2021-03-04 05:24:24 Magdalena, Colombia
908259 2021-03-03 Colombia Meta     42498 974 40973 551 3.272 -73.0877 2021-03-04 05:24:24 Meta, Colombia
908260 2021-03-03 Colombia Narino     49096 1624 46425 1047 1.2892 -77.3579 2021-03-04 05:24:24 Narino, Colombia
908261 2021-03-03 Colombia Norte de Santander     50917 2719 47433 765 7.9463 -72.8988 2021-03-04 05:24:24 Norte de Santander, Colombia
908262 2021-03-03 Colombia Putumayo     7910 314 7358 238 0.436 -75.5277 2021-03-04 05:24:24 Putumayo, Colombia
908263 2021-03-03 Colombia Quindio     32304 959 30786 559 4.461 -75.6674 2021-03-04 05:24:24 Quindio, Colombia
908264 2021-03-03 Colombia Risaralda     46225 1148 44253 824 5.3158 -75.9928 2021-03-04 05:24:24 Risaralda, Colombia
908265 2021-03-03 Colombia San Andres y Providencia     2709 45 2653 11 12.5567 -81.7185 2021-03-04 05:24:24 San Andres y Providencia, Colombia
908266 2021-03-03 Colombia Santander     91455 3334 86125 1996 6.6437 -73.6536 2021-03-04 05:24:24 Santander, Colombia
908267 2021-03-03 Colombia Sucre     20668 784 19460 424 8.814 -74.7233 2021-03-04 05:24:24 Sucre, Colombia
908268 2021-03-03 Colombia Tolima     65452 2102 62387 963 4.0925 -75.1545 2021-03-04 05:24:24 Tolima, Colombia
908269 2021-03-03 Colombia Unknown     0 0 0 0     2021-03-04 05:24:24 Unknown, Colombia
908270 2021-03-03 Colombia Valle del Cauca     196532 6222 186041 4269 3.8009 -76.6413 2021-03-04 05:24:24 Valle del Cauca, Colombia

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);