johns_hopkins_csse_daily_reports

⚠️ 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

1,358 rows where country_or_region = "Colombia" sorted by day descending

View and edit SQL

country_or_region

  • Colombia · 1,358
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
311639 2020-07-04 Colombia Amazonas     2328 90 1966 272 -1.4429 -71.5724 2020-07-05 04:33:46 Amazonas, Colombia
311648 2020-07-04 Colombia Antioquia     5263 42 2083 3138 7.1986 -75.3412 2020-07-05 04:33:46 Antioquia, Colombia
311653 2020-07-04 Colombia Arauca     82 0 7 75 7.0762 -70.7105 2020-07-05 04:33:46 Arauca, Colombia
311664 2020-07-04 Colombia Atlantico     25788 1409 8719 15660 10.6966 -74.8741 2020-07-05 04:33:46 Atlantico, Colombia
311685 2020-07-04 Colombia Bolivar     9854 415 4818 4621 8.6704 -74.03 2020-07-05 04:33:46 Bolivar, Colombia
311687 2020-07-04 Colombia Boyaca     409 17 235 157 5.4545 -73.362 2020-07-05 04:33:46 Boyaca, Colombia
311697 2020-07-04 Colombia Caldas     267 8 183 76 5.2983 -75.2479 2020-07-05 04:33:46 Caldas, Colombia
311703 2020-07-04 Colombia Capital District     34131 806 13484 19841 4.711 -74.0721 2020-07-05 04:33:46 Capital District, Colombia
311704 2020-07-04 Colombia Caqueta     43 2 22 19 0.8699 -73.8419 2020-07-05 04:33:46 Caqueta, Colombia
311705 2020-07-04 Colombia Casanare     85 0 48 37 5.7589 -71.5724 2020-07-05 04:33:46 Casanare, Colombia
311709 2020-07-04 Colombia Cauca     477 20 168 289 2.705 -76.82600000000002 2020-07-05 04:33:46 Cauca, Colombia
311712 2020-07-04 Colombia Cesar     1169 28 501 640 9.3373 -73.6536 2020-07-05 04:33:46 Cesar, Colombia
311725 2020-07-04 Colombia Choco     1754 55 614 1085 5.2528 -76.82600000000002 2020-07-05 04:33:46 Choco, Colombia
311733 2020-07-04 Colombia Cordoba     915 70 251 594 8.0493 -75.574 2020-07-05 04:33:46 Cordoba, Colombia
311735 2020-07-04 Colombia Cundinamarca     3218 72 1590 1556 5.026 -74.03 2020-07-05 04:33:46 Cundinamarca, Colombia
311775 2020-07-04 Colombia Guainia     14 1 2 11 2.5854 -68.5247 2020-07-05 04:33:46 Guainia, Colombia
311780 2020-07-04 Colombia Guaviare     39 0 7 32 1.0654 -73.2603 2020-07-05 04:33:46 Guaviare, Colombia
311801 2020-07-04 Colombia Huila     369 15 255 99 2.5359 -75.5277 2020-07-05 04:33:46 Huila, Colombia
311859 2020-07-04 Colombia La Guajira     559 21 121 417 11.3548 -72.5205 2020-07-05 04:33:46 La Guajira, Colombia
311882 2020-07-04 Colombia Magdalena     2017 153 810 1054 10.4113 -74.4057 2020-07-05 04:33:46 Magdalena, Colombia
311897 2020-07-04 Colombia Meta     1305 17 980 308 3.272 -73.0877 2020-07-05 04:33:46 Meta, Colombia
311920 2020-07-04 Colombia Narino     3676 124 2181 1371 1.2892 -77.3579 2020-07-05 04:33:46 Narino, Colombia
311934 2020-07-04 Colombia Norte de Santander     354 21 176 157 7.9463 -72.8988 2020-07-05 04:33:46 Norte de Santander, Colombia
311984 2020-07-04 Colombia Putumayo     33 7 9 17 0.436 -75.5277 2020-07-05 04:33:46 Putumayo, Colombia
311989 2020-07-04 Colombia Quindio     169 6 118 45 4.461 -75.6674 2020-07-05 04:33:46 Quindio, Colombia
311998 2020-07-04 Colombia Risaralda     587 16 297 274 5.3158 -75.9928 2020-07-05 04:33:46 Risaralda, Colombia
312015 2020-07-04 Colombia San Andres y Providencia     28 1 21 6 12.5567 -81.7185 2020-07-05 04:33:46 San Andres y Providencia, Colombia
312019 2020-07-04 Colombia Santander     846 15 216 615 6.6437 -73.6536 2020-07-05 04:33:46 Santander, Colombia
312049 2020-07-04 Colombia Sucre     1549 90 155 1304 8.814 -74.7233 2020-07-05 04:33:46 Sucre, Colombia
312070 2020-07-04 Colombia Tolima     1090 27 358 705 4.0925 -75.1545 2020-07-05 04:33:46 Tolima, Colombia
312086 2020-07-04 Colombia Unknown     144 0 0 144     2020-07-05 04:33:46 Unknown, Colombia
312097 2020-07-04 Colombia Valle del Cauca     11202 452 4996 5754 3.8009 -76.6413 2020-07-05 04:33:46 Valle del Cauca, Colombia
312104 2020-07-04 Colombia Vaupes     28 1 17 10 0.8554 -70.812 2020-07-05 04:33:46 Vaupes, Colombia
312107 2020-07-04 Colombia Vichada     1 0 1 0 4.4234 -69.2878 2020-07-05 04:33:46 Vichada, Colombia
252073 2020-07-03 Colombia Amazonas     2325 90 1960 275 -1.4429 -71.5724 2020-07-04 04:33:51 Amazonas, Colombia
252082 2020-07-03 Colombia Antioquia     4981 35 2012 2934 7.1986 -75.3412 2020-07-04 04:33:51 Antioquia, Colombia
252087 2020-07-03 Colombia Arauca     81 0 7 74 7.0762 -70.7105 2020-07-04 04:33:51 Arauca, Colombia
252098 2020-07-03 Colombia Atlantico     25181 1361 8473 15347 10.6966 -74.8741 2020-07-04 04:33:51 Atlantico, Colombia
252119 2020-07-03 Colombia Bolivar     9629 407 4747 4475 8.6704 -74.03 2020-07-04 04:33:51 Bolivar, Colombia
252121 2020-07-03 Colombia Boyaca     405 17 234 154 5.4545 -73.362 2020-07-04 04:33:51 Boyaca, Colombia
252131 2020-07-03 Colombia Caldas     267 8 183 76 5.2983 -75.2479 2020-07-04 04:33:51 Caldas, Colombia
252137 2020-07-03 Colombia Capital District     32726 774 13299 18653 4.711 -74.0721 2020-07-04 04:33:51 Capital District, Colombia
252138 2020-07-03 Colombia Caqueta     43 2 22 19 0.8699 -73.8419 2020-07-04 04:33:51 Caqueta, Colombia
252139 2020-07-03 Colombia Casanare     69 0 47 22 5.7589 -71.5724 2020-07-04 04:33:51 Casanare, Colombia
252143 2020-07-03 Colombia Cauca     467 20 161 286 2.705 -76.82600000000002 2020-07-04 04:33:51 Cauca, Colombia
252146 2020-07-03 Colombia Cesar     1076 27 493 556 9.3373 -73.6536 2020-07-04 04:33:51 Cesar, Colombia
252159 2020-07-03 Colombia Choco     1740 53 609 1078 5.2528 -76.82600000000002 2020-07-04 04:33:51 Choco, Colombia
252167 2020-07-03 Colombia Cordoba     893 63 246 584 8.0493 -75.574 2020-07-04 04:33:51 Cordoba, Colombia
252169 2020-07-03 Colombia Cundinamarca     3147 66 1573 1508 5.026 -74.03 2020-07-04 04:33:51 Cundinamarca, Colombia
252209 2020-07-03 Colombia Guainia     14 1 2 11 2.5854 -68.5247 2020-07-04 04:33:51 Guainia, Colombia
252214 2020-07-03 Colombia Guaviare     39 0 7 32 1.0654 -73.2603 2020-07-04 04:33:51 Guaviare, Colombia
252235 2020-07-03 Colombia Huila     365 14 254 97 2.5359 -75.5277 2020-07-04 04:33:51 Huila, Colombia
252293 2020-07-03 Colombia La Guajira     536 21 111 404 11.3548 -72.5205 2020-07-04 04:33:51 La Guajira, Colombia
252316 2020-07-03 Colombia Magdalena     1988 142 793 1053 10.4113 -74.4057 2020-07-04 04:33:51 Magdalena, Colombia
252331 2020-07-03 Colombia Meta     1293 17 980 296 3.272 -73.0877 2020-07-04 04:33:51 Meta, Colombia
252354 2020-07-03 Colombia Narino     3574 122 2169 1283 1.2892 -77.3579 2020-07-04 04:33:51 Narino, Colombia
252368 2020-07-03 Colombia Norte de Santander     347 21 166 160 7.9463 -72.8988 2020-07-04 04:33:51 Norte de Santander, Colombia
252418 2020-07-03 Colombia Putumayo     29 6 9 14 0.436 -75.5277 2020-07-04 04:33:51 Putumayo, Colombia
252423 2020-07-03 Colombia Quindio     168 6 117 45 4.461 -75.6674 2020-07-04 04:33:51 Quindio, Colombia
252432 2020-07-03 Colombia Risaralda     563 15 290 258 5.3158 -75.9928 2020-07-04 04:33:51 Risaralda, Colombia
252449 2020-07-03 Colombia San Andres y Providencia     28 1 21 6 12.5567 -81.7185 2020-07-04 04:33:51 San Andres y Providencia, Colombia
252453 2020-07-03 Colombia Santander     812 15 211 586 6.6437 -73.6536 2020-07-04 04:33:51 Santander, Colombia
252483 2020-07-03 Colombia Sucre     1490 82 147 1261 8.814 -74.7233 2020-07-04 04:33:51 Sucre, Colombia
252504 2020-07-03 Colombia Tolima     1042 22 353 667 4.0925 -75.1545 2020-07-04 04:33:51 Tolima, Colombia
252520 2020-07-03 Colombia Unknown     141 0 0 141     2020-07-04 04:33:51 Unknown, Colombia
252531 2020-07-03 Colombia Valle del Cauca     10904 442 4892 5570 3.8009 -76.6413 2020-07-04 04:33:51 Valle del Cauca, Colombia
252538 2020-07-03 Colombia Vaupes     28 1 17 10 0.8554 -70.812 2020-07-04 04:33:51 Vaupes, Colombia
252541 2020-07-03 Colombia Vichada     1 0 1 0 4.4234 -69.2878 2020-07-04 04:33:51 Vichada, Colombia
203454 2020-07-02 Colombia Amazonas     2319 90 1951 278 -1.4429 -71.5724 2020-07-03 04:33:54 Amazonas, Colombia
203463 2020-07-02 Colombia Antioquia     4660 30 1921 2709 7.1986 -75.3412 2020-07-03 04:33:54 Antioquia, Colombia
203468 2020-07-02 Colombia Arauca     80 0 4 76 7.0762 -70.7105 2020-07-03 04:33:54 Arauca, Colombia
203479 2020-07-02 Colombia Atlantico     24212 1277 8149 14786 10.6966 -74.8741 2020-07-03 04:33:54 Atlantico, Colombia
203500 2020-07-02 Colombia Bolivar     9392 388 4640 4364 8.6704 -74.03 2020-07-03 04:33:54 Bolivar, Colombia
203502 2020-07-02 Colombia Boyaca     390 17 228 145 5.4545 -73.362 2020-07-03 04:33:54 Boyaca, Colombia
203512 2020-07-02 Colombia Caldas     264 8 181 75 5.2983 -75.2479 2020-07-03 04:33:54 Caldas, Colombia
203518 2020-07-02 Colombia Capital District     31417 735 13065 17617 4.711 -74.0721 2020-07-03 04:33:54 Capital District, Colombia
203519 2020-07-02 Colombia Caqueta     39 2 22 15 0.8699 -73.8419 2020-07-03 04:33:54 Caqueta, Colombia
203520 2020-07-02 Colombia Casanare     67 0 47 20 5.7589 -71.5724 2020-07-03 04:33:54 Casanare, Colombia
203524 2020-07-02 Colombia Cauca     405 18 161 226 2.705 -76.82600000000002 2020-07-03 04:33:54 Cauca, Colombia
203527 2020-07-02 Colombia Cesar     1071 27 475 569 9.3373 -73.6536 2020-07-03 04:33:54 Cesar, Colombia
203540 2020-07-02 Colombia Choco     1682 49 586 1047 5.2528 -76.82600000000002 2020-07-03 04:33:54 Choco, Colombia
203548 2020-07-02 Colombia Cordoba     801 59 241 501 8.0493 -75.574 2020-07-03 04:33:54 Cordoba, Colombia
203550 2020-07-02 Colombia Cundinamarca     2975 66 1516 1393 5.026 -74.03 2020-07-03 04:33:54 Cundinamarca, Colombia
203590 2020-07-02 Colombia Guainia     14 1 2 11 2.5854 -68.5247 2020-07-03 04:33:54 Guainia, Colombia
203595 2020-07-02 Colombia Guaviare     39 0 7 32 1.0654 -73.2603 2020-07-03 04:33:54 Guaviare, Colombia
203616 2020-07-02 Colombia Huila     340 14 252 74 2.5359 -75.5277 2020-07-03 04:33:54 Huila, Colombia
203674 2020-07-02 Colombia La Guajira     479 21 108 350 11.3548 -72.5205 2020-07-03 04:33:54 La Guajira, Colombia
203697 2020-07-02 Colombia Magdalena     1903 134 789 980 10.4113 -74.4057 2020-07-03 04:33:54 Magdalena, Colombia
203712 2020-07-02 Colombia Meta     1271 16 976 279 3.272 -73.0877 2020-07-03 04:33:54 Meta, Colombia
203735 2020-07-02 Colombia Narino     3521 119 2102 1300 1.2892 -77.3579 2020-07-03 04:33:54 Narino, Colombia
203749 2020-07-02 Colombia Norte de Santander     342 20 164 158 7.9463 -72.8988 2020-07-03 04:33:54 Norte de Santander, Colombia
203799 2020-07-02 Colombia Putumayo     28 6 9 13 0.436 -75.5277 2020-07-03 04:33:54 Putumayo, Colombia
203804 2020-07-02 Colombia Quindio     167 5 117 45 4.461 -75.6674 2020-07-03 04:33:54 Quindio, Colombia
203813 2020-07-02 Colombia Risaralda     546 13 284 249 5.3158 -75.9928 2020-07-03 04:33:54 Risaralda, Colombia
203830 2020-07-02 Colombia San Andres y Providencia     23 1 18 4 12.5567 -81.7185 2020-07-03 04:33:54 San Andres y Providencia, Colombia
203834 2020-07-02 Colombia Santander     757 15 204 538 6.6437 -73.6536 2020-07-03 04:33:54 Santander, Colombia
203864 2020-07-02 Colombia Sucre     1373 75 133 1165 8.814 -74.7233 2020-07-03 04:33:54 Sucre, Colombia
203885 2020-07-02 Colombia Tolima     1021 22 340 659 4.0925 -75.1545 2020-07-03 04:33:54 Tolima, Colombia
203902 2020-07-02 Colombia Unknown     126 0 0 126     2020-07-03 04:33:54 Unknown, Colombia
203913 2020-07-02 Colombia Valle del Cauca     10508 422 4771 5315 3.8009 -76.6413 2020-07-03 04:33:54 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
);
Powered by Datasette · Query took 2374.323ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette