johns_hopkins_csse_daily_reports

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

8,185 rows where country_or_region = "Colombia" sorted by day descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

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

province_or_state

country_or_region

  • Colombia · 8,185 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
89512 89512 2021-01-22 Colombia Amazonas     3497 132 3319 46 -1.4429 -71.5724 2021-01-23 05:22:03 Amazonas, Colombia
89513 89513 2021-01-22 Colombia Antioquia     314361 5582 288853 19926 7.1986 -75.3412 2021-01-23 05:22:03 Antioquia, Colombia
89514 89514 2021-01-22 Colombia Arauca     5127 148 4719 260 7.0762 -70.7105 2021-01-23 05:22:03 Arauca, Colombia
89515 89515 2021-01-22 Colombia Atlantico     109112 3713 101706 3693 10.6966 -74.8741 2021-01-23 05:22:03 Atlantico, Colombia
89516 89516 2021-01-22 Colombia Bolivar     61049 1221 58107 1721 8.6704 -74.03 2021-01-23 05:22:03 Bolivar, Colombia
89517 89517 2021-01-22 Colombia Boyaca     38242 797 34384 3061 5.4545 -73.362 2021-01-23 05:22:03 Boyaca, Colombia
89518 89518 2021-01-22 Colombia Caldas     41421 797 37662 2962 5.2983 -75.2479 2021-01-23 05:22:03 Caldas, Colombia
89519 89519 2021-01-22 Colombia Capital District     582085 11787 520853 49445 4.711 -74.0721 2021-01-23 05:22:03 Capital District, Colombia
89520 89520 2021-01-22 Colombia Caqueta     16175 577 14911 687 0.8699 -73.8419 2021-01-23 05:22:03 Caqueta, Colombia
89521 89521 2021-01-22 Colombia Casanare     10800 208 9872 720 5.7589 -71.5724 2021-01-23 05:22:03 Casanare, Colombia
89522 89522 2021-01-22 Colombia Cauca     23711 579 21336 1796 2.705 -76.82600000000002 2021-01-23 05:22:03 Cauca, Colombia
89523 89523 2021-01-22 Colombia Cesar     37227 1058 34659 1510 9.3373 -73.6536 2021-01-23 05:22:03 Cesar, Colombia
89524 89524 2021-01-22 Colombia Choco     5732 172 5192 368 5.2528 -76.82600000000002 2021-01-23 05:22:03 Choco, Colombia
89525 89525 2021-01-22 Colombia Cordoba     31521 1702 29110 709 8.0493 -75.574 2021-01-23 05:22:03 Cordoba, Colombia
89526 89526 2021-01-22 Colombia Cundinamarca     87713 2200 79630 5883 5.026 -74.03 2021-01-23 05:22:03 Cundinamarca, Colombia
89527 89527 2021-01-22 Colombia Guainia     1261 20 1225 16 2.5854 -68.5247 2021-01-23 05:22:03 Guainia, Colombia
89528 89528 2021-01-22 Colombia Guaviare     2116 38 2039 39 1.0654 -73.2603 2021-01-23 05:22:03 Guaviare, Colombia
89529 89529 2021-01-22 Colombia Huila     43088 1345 39308 2435 2.5359 -75.5277 2021-01-23 05:22:03 Huila, Colombia
89530 89530 2021-01-22 Colombia La Guajira     15242 582 14260 400 11.3548 -72.5205 2021-01-23 05:22:03 La Guajira, Colombia
89531 89531 2021-01-22 Colombia Magdalena     28464 1152 26264 1048 10.4113 -74.4057 2021-01-23 05:22:03 Magdalena, Colombia
89532 89532 2021-01-22 Colombia Meta     38977 844 36783 1350 3.272 -73.0877 2021-01-23 05:22:03 Meta, Colombia
89533 89533 2021-01-22 Colombia Narino     42704 1227 38009 3468 1.2892 -77.3579 2021-01-23 05:22:03 Narino, Colombia
89534 89534 2021-01-22 Colombia Norte de Santander     47021 2411 42288 2322 7.9463 -72.8988 2021-01-23 05:22:03 Norte de Santander, Colombia
89535 89535 2021-01-22 Colombia Putumayo     6974 270 6255 449 0.436 -75.5277 2021-01-23 05:22:03 Putumayo, Colombia
89536 89536 2021-01-22 Colombia Quindio     28597 792 26333 1472 4.461 -75.6674 2021-01-23 05:22:03 Quindio, Colombia
89537 89537 2021-01-22 Colombia Risaralda     42455 958 39104 2393 5.3158 -75.9928 2021-01-23 05:22:03 Risaralda, Colombia
89538 89538 2021-01-22 Colombia San Andres y Providencia     2578 42 2499 37 12.5567 -81.7185 2021-01-23 05:22:03 San Andres y Providencia, Colombia
89539 89539 2021-01-22 Colombia Santander     79922 2757 72828 4337 6.6437 -73.6536 2021-01-23 05:22:03 Santander, Colombia
89540 89540 2021-01-22 Colombia Sucre     18721 697 17522 502 8.814 -74.7233 2021-01-23 05:22:03 Sucre, Colombia
89541 89541 2021-01-22 Colombia Tolima     58343 1700 52785 3858 4.0925 -75.1545 2021-01-23 05:22:03 Tolima, Colombia
89542 89542 2021-01-22 Colombia Unknown     0 0 0 0     2021-01-23 05:22:03 Unknown, Colombia
89543 89543 2021-01-22 Colombia Valle del Cauca     160839 5045 147447 8347 3.8009 -76.6413 2021-01-23 05:22:03 Valle del Cauca, Colombia
89544 89544 2021-01-22 Colombia Vaupes     1143 13 1126 4 0.8554 -70.812 2021-01-23 05:22:03 Vaupes, Colombia
89545 89545 2021-01-22 Colombia Vichada     1200 20 1164 16 4.4234 -69.2878 2021-01-23 05:22:03 Vichada, Colombia
302418 302418 2021-01-21 Colombia Amazonas     3494 132 3303 59 -1.4429 -71.5724 2021-01-22 05:22:10 Amazonas, Colombia
302419 302419 2021-01-21 Colombia Antioquia     312640 5538 287831 19271 7.1986 -75.3412 2021-01-22 05:22:10 Antioquia, Colombia
302420 302420 2021-01-21 Colombia Arauca     5118 147 4701 270 7.0762 -70.7105 2021-01-22 05:22:10 Arauca, Colombia
302421 302421 2021-01-21 Colombia Atlantico     108352 3695 101081 3576 10.6966 -74.8741 2021-01-22 05:22:10 Atlantico, Colombia
302422 302422 2021-01-21 Colombia Bolivar     60896 1218 57766 1912 8.6704 -74.03 2021-01-22 05:22:10 Bolivar, Colombia
302423 302423 2021-01-21 Colombia Boyaca     37848 786 33873 3189 5.4545 -73.362 2021-01-22 05:22:10 Boyaca, Colombia
302424 302424 2021-01-21 Colombia Caldas     41061 786 37166 3109 5.2983 -75.2479 2021-01-22 05:22:10 Caldas, Colombia
302425 302425 2021-01-21 Colombia Capital District     576011 11697 519329 44985 4.711 -74.0721 2021-01-22 05:22:10 Capital District, Colombia
302426 302426 2021-01-21 Colombia Caqueta     16146 574 14867 705 0.8699 -73.8419 2021-01-22 05:22:10 Caqueta, Colombia
302427 302427 2021-01-21 Colombia Casanare     10753 205 9781 767 5.7589 -71.5724 2021-01-22 05:22:10 Casanare, Colombia
302428 302428 2021-01-21 Colombia Cauca     23443 573 21096 1774 2.705 -76.82600000000002 2021-01-22 05:22:10 Cauca, Colombia
302429 302429 2021-01-21 Colombia Cesar     37083 1055 34457 1571 9.3373 -73.6536 2021-01-22 05:22:10 Cesar, Colombia
302430 302430 2021-01-21 Colombia Choco     5702 172 5104 426 5.2528 -76.82600000000002 2021-01-22 05:22:10 Choco, Colombia
302431 302431 2021-01-21 Colombia Cordoba     31393 1698 29011 684 8.0493 -75.574 2021-01-22 05:22:10 Cordoba, Colombia
302432 302432 2021-01-21 Colombia Cundinamarca     86779 2165 78999 5615 5.026 -74.03 2021-01-22 05:22:10 Cundinamarca, Colombia
302433 302433 2021-01-21 Colombia Guainia     1261 20 1222 19 2.5854 -68.5247 2021-01-22 05:22:10 Guainia, Colombia
302434 302434 2021-01-21 Colombia Guaviare     2110 38 2036 36 1.0654 -73.2603 2021-01-22 05:22:10 Guaviare, Colombia
302435 302435 2021-01-21 Colombia Huila     42794 1331 39038 2425 2.5359 -75.5277 2021-01-22 05:22:10 Huila, Colombia
302436 302436 2021-01-21 Colombia La Guajira     15222 580 14234 408 11.3548 -72.5205 2021-01-22 05:22:10 La Guajira, Colombia
302437 302437 2021-01-21 Colombia Magdalena     28338 1147 26063 1128 10.4113 -74.4057 2021-01-22 05:22:10 Magdalena, Colombia
302438 302438 2021-01-21 Colombia Meta     38795 837 36666 1292 3.272 -73.0877 2021-01-22 05:22:10 Meta, Colombia
302439 302439 2021-01-21 Colombia Narino     42488 1213 37498 3777 1.2892 -77.3579 2021-01-22 05:22:10 Narino, Colombia
302440 302440 2021-01-21 Colombia Norte de Santander     46830 2402 42148 2280 7.9463 -72.8988 2021-01-22 05:22:10 Norte de Santander, Colombia
302441 302441 2021-01-21 Colombia Putumayo     6945 269 6219 457 0.436 -75.5277 2021-01-22 05:22:10 Putumayo, Colombia
302442 302442 2021-01-21 Colombia Quindio     28353 789 26160 1404 4.461 -75.6674 2021-01-22 05:22:10 Quindio, Colombia
302443 302443 2021-01-21 Colombia Risaralda     42244 949 38844 2451 5.3158 -75.9928 2021-01-22 05:22:10 Risaralda, Colombia
302444 302444 2021-01-21 Colombia San Andres y Providencia     2577 42 2486 49 12.5567 -81.7185 2021-01-22 05:22:10 San Andres y Providencia, Colombia
302445 302445 2021-01-21 Colombia Santander     79328 2741 72399 4188 6.6437 -73.6536 2021-01-22 05:22:10 Santander, Colombia
302446 302446 2021-01-21 Colombia Sucre     18665 695 17369 601 8.814 -74.7233 2021-01-22 05:22:10 Sucre, Colombia
302447 302447 2021-01-21 Colombia Tolima     57787 1667 52450 3670 4.0925 -75.1545 2021-01-22 05:22:10 Tolima, Colombia
302448 302448 2021-01-21 Colombia Unknown     0 0 0 0     2021-01-22 05:22:10 Unknown, Colombia
302449 302449 2021-01-21 Colombia Valle del Cauca     159546 4993 145649 8904 3.8009 -76.6413 2021-01-22 05:22:10 Valle del Cauca, Colombia
302450 302450 2021-01-21 Colombia Vaupes     1143 13 1126 4 0.8554 -70.812 2021-01-22 05:22:10 Vaupes, Colombia
302451 302451 2021-01-21 Colombia Vichada     1200 20 1162 18 4.4234 -69.2878 2021-01-22 05:22:10 Vichada, Colombia
893470 893470 2021-01-20 Colombia Amazonas     3483 132 3291 60 -1.4429 -71.5724 2021-01-21 05:22:01 Amazonas, Colombia
893471 893471 2021-01-20 Colombia Antioquia     310692 5506 287726 17460 7.1986 -75.3412 2021-01-21 05:22:01 Antioquia, Colombia
893472 893472 2021-01-20 Colombia Arauca     5086 147 4666 273 7.0762 -70.7105 2021-01-21 05:22:01 Arauca, Colombia
893473 893473 2021-01-20 Colombia Atlantico     107995 3678 99737 4580 10.6966 -74.8741 2021-01-21 05:22:01 Atlantico, Colombia
893474 893474 2021-01-20 Colombia Bolivar     60479 1207 56950 2322 8.6704 -74.03 2021-01-21 05:22:01 Bolivar, Colombia
893475 893475 2021-01-20 Colombia Boyaca     37296 767 33348 3181 5.4545 -73.362 2021-01-21 05:22:01 Boyaca, Colombia
893476 893476 2021-01-20 Colombia Caldas     40595 775 36706 3114 5.2983 -75.2479 2021-01-21 05:22:01 Caldas, Colombia
893477 893477 2021-01-20 Colombia Capital District     571951 11580 514232 46139 4.711 -74.0721 2021-01-21 05:22:01 Capital District, Colombia
893478 893478 2021-01-20 Colombia Caqueta     16070 572 14816 682 0.8699 -73.8419 2021-01-21 05:22:01 Caqueta, Colombia
893479 893479 2021-01-20 Colombia Casanare     10596 205 9683 708 5.7589 -71.5724 2021-01-21 05:22:01 Casanare, Colombia
893480 893480 2021-01-20 Colombia Cauca     23072 566 20780 1726 2.705 -76.82600000000002 2021-01-21 05:22:01 Cauca, Colombia
893481 893481 2021-01-20 Colombia Cesar     36777 1050 34209 1518 9.3373 -73.6536 2021-01-21 05:22:01 Cesar, Colombia
893482 893482 2021-01-20 Colombia Choco     5536 172 5076 288 5.2528 -76.82600000000002 2021-01-21 05:22:01 Choco, Colombia
893483 893483 2021-01-20 Colombia Cordoba     31254 1695 28931 628 8.0493 -75.574 2021-01-21 05:22:01 Cordoba, Colombia
893484 893484 2021-01-20 Colombia Cundinamarca     85809 2134 77691 5984 5.026 -74.03 2021-01-21 05:22:01 Cundinamarca, Colombia
893485 893485 2021-01-20 Colombia Guainia     1252 20 1219 13 2.5854 -68.5247 2021-01-21 05:22:01 Guainia, Colombia
893486 893486 2021-01-20 Colombia Guaviare     2104 38 2031 35 1.0654 -73.2603 2021-01-21 05:22:01 Guaviare, Colombia
893487 893487 2021-01-20 Colombia Huila     42334 1311 38414 2609 2.5359 -75.5277 2021-01-21 05:22:01 Huila, Colombia
893488 893488 2021-01-20 Colombia La Guajira     15153 580 14176 397 11.3548 -72.5205 2021-01-21 05:22:01 La Guajira, Colombia
893489 893489 2021-01-20 Colombia Magdalena     28120 1144 25798 1178 10.4113 -74.4057 2021-01-21 05:22:01 Magdalena, Colombia
893490 893490 2021-01-20 Colombia Meta     38578 833 36240 1505 3.272 -73.0877 2021-01-21 05:22:01 Meta, Colombia
893491 893491 2021-01-20 Colombia Narino     41839 1193 36829 3817 1.2892 -77.3579 2021-01-21 05:22:01 Narino, Colombia
893492 893492 2021-01-20 Colombia Norte de Santander     46512 2387 41969 2156 7.9463 -72.8988 2021-01-21 05:22:01 Norte de Santander, Colombia
893493 893493 2021-01-20 Colombia Putumayo     6900 268 6139 493 0.436 -75.5277 2021-01-21 05:22:01 Putumayo, Colombia
893494 893494 2021-01-20 Colombia Quindio     28204 786 25940 1478 4.461 -75.6674 2021-01-21 05:22:01 Quindio, Colombia
893495 893495 2021-01-20 Colombia Risaralda     41873 945 38557 2371 5.3158 -75.9928 2021-01-21 05:22:01 Risaralda, Colombia
893496 893496 2021-01-20 Colombia San Andres y Providencia     2564 42 2477 45 12.5567 -81.7185 2021-01-21 05:22:01 San Andres y Providencia, Colombia
893497 893497 2021-01-20 Colombia Santander     78800 2729 71763 4308 6.6437 -73.6536 2021-01-21 05:22:01 Santander, Colombia
893498 893498 2021-01-20 Colombia Sucre     18468 693 17300 475 8.814 -74.7233 2021-01-21 05:22:01 Sucre, Colombia
893499 893499 2021-01-20 Colombia Tolima     57225 1651 51779 3795 4.0925 -75.1545 2021-01-21 05:22:01 Tolima, Colombia
893500 893500 2021-01-20 Colombia Unknown     0 0 0 0     2021-01-21 05:22:01 Unknown, Colombia
893501 893501 2021-01-20 Colombia Valle del Cauca     158021 4953 145410 7658 3.8009 -76.6413 2021-01-21 05:22:01 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]);