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