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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Amazonas 475
- Antioquia 475
- Arauca 475
- Atlantico 475
- Bolivar 475
- Boyaca 475
- Caldas 475
- Capital District 475
- Caqueta 475
- Casanare 475
- Cauca 475
- Cesar 475
- Choco 475
- Cordoba 475
- Cundinamarca 475
- Huila 475
- La Guajira 475
- Magdalena 475
- Meta 475
- Narino 475
- Norte de Santander 475
- Putumayo 475
- Quindio 475
- Risaralda 475
- San Andres y Providencia 475
- Santander 475
- Sucre 475
- Tolima 475
- Valle del Cauca 475
- Vaupes 475
- …
country_or_region 1
- Colombia · 16,175 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462624 | 2462624 | 2021-09-14 | Colombia | Amazonas | 6814 | 254 | 0 | -1.4429 | -71.5724 | 2021-09-15 03:22:37 | Amazonas, Colombia | |||
2462625 | 2462625 | 2021-09-14 | Colombia | Antioquia | 740807 | 15955 | 0 | 7.1986 | -75.3412 | 2021-09-15 03:22:37 | Antioquia, Colombia | |||
2462626 | 2462626 | 2021-09-14 | Colombia | Arauca | 13194 | 452 | 0 | 7.0762 | -70.7105 | 2021-09-15 03:22:37 | Arauca, Colombia | |||
2462627 | 2462627 | 2021-09-14 | Colombia | Atlantico | 316518 | 9406 | 0 | 10.6966 | -74.8741 | 2021-09-15 03:22:37 | Atlantico, Colombia | |||
2462628 | 2462628 | 2021-09-14 | Colombia | Bolivar | 155542 | 2949 | 0 | 8.6704 | -74.03 | 2021-09-15 03:22:37 | Bolivar, Colombia | |||
2462629 | 2462629 | 2021-09-14 | Colombia | Boyaca | 105008 | 2540 | 0 | 5.4545 | -73.362 | 2021-09-15 03:22:37 | Boyaca, Colombia | |||
2462630 | 2462630 | 2021-09-14 | Colombia | Caldas | 100074 | 2253 | 0 | 5.2983 | -75.2479 | 2021-09-15 03:22:37 | Caldas, Colombia | |||
2462631 | 2462631 | 2021-09-14 | Colombia | Capital District | 1446549 | 27424 | 0 | 4.711 | -74.0721 | 2021-09-15 03:22:37 | Capital District, Colombia | |||
2462632 | 2462632 | 2021-09-14 | Colombia | Caqueta | 22771 | 928 | 0 | 0.8699 | -73.8419 | 2021-09-15 03:22:37 | Caqueta, Colombia | |||
2462633 | 2462633 | 2021-09-14 | Colombia | Casanare | 35431 | 914 | 0 | 5.7589 | -71.5724 | 2021-09-15 03:22:37 | Casanare, Colombia | |||
2462634 | 2462634 | 2021-09-14 | Colombia | Cauca | 55473 | 1510 | 0 | 2.705 | -76.82600000000002 | 2021-09-15 03:22:37 | Cauca, Colombia | |||
2462635 | 2462635 | 2021-09-14 | Colombia | Cesar | 88532 | 2475 | 0 | 9.3373 | -73.6536 | 2021-09-15 03:22:37 | Cesar, Colombia | |||
2462636 | 2462636 | 2021-09-14 | Colombia | Choco | 16315 | 391 | 0 | 5.2528 | -76.82600000000002 | 2021-09-15 03:22:37 | Choco, Colombia | |||
2462637 | 2462637 | 2021-09-14 | Colombia | Cordoba | 103514 | 3716 | 0 | 8.0493 | -75.574 | 2021-09-15 03:22:37 | Cordoba, Colombia | |||
2462638 | 2462638 | 2021-09-14 | Colombia | Cundinamarca | 263018 | 6788 | 0 | 5.026 | -74.03 | 2021-09-15 03:22:37 | Cundinamarca, Colombia | |||
2462639 | 2462639 | 2021-09-14 | Colombia | Guainia | 2270 | 29 | 0 | 2.5854 | -68.5247 | 2021-09-15 03:22:37 | Guainia, Colombia | |||
2462640 | 2462640 | 2021-09-14 | Colombia | Guaviare | 5127 | 93 | 0 | 1.0654 | -73.2603 | 2021-09-15 03:22:37 | Guaviare, Colombia | |||
2462641 | 2462641 | 2021-09-14 | Colombia | Huila | 88024 | 3131 | 0 | 2.5359 | -75.5277 | 2021-09-15 03:22:37 | Huila, Colombia | |||
2462642 | 2462642 | 2021-09-14 | Colombia | La Guajira | 42198 | 1332 | 0 | 11.3548 | -72.5205 | 2021-09-15 03:22:37 | La Guajira, Colombia | |||
2462643 | 2462643 | 2021-09-14 | Colombia | Magdalena | 92963 | 3300 | 0 | 10.4113 | -74.4057 | 2021-09-15 03:22:37 | Magdalena, Colombia | |||
2462644 | 2462644 | 2021-09-14 | Colombia | Meta | 87662 | 2223 | 0 | 3.272 | -73.0877 | 2021-09-15 03:22:37 | Meta, Colombia | |||
2462645 | 2462645 | 2021-09-14 | Colombia | Narino | 89141 | 3000 | 0 | 1.2892 | -77.3579 | 2021-09-15 03:22:37 | Narino, Colombia | |||
2462646 | 2462646 | 2021-09-14 | Colombia | Norte de Santander | 89713 | 4210 | 0 | 7.9463 | -72.8988 | 2021-09-15 03:22:37 | Norte de Santander, Colombia | |||
2462647 | 2462647 | 2021-09-14 | Colombia | Putumayo | 16168 | 665 | 0 | 0.436 | -75.5277 | 2021-09-15 03:22:37 | Putumayo, Colombia | |||
2462648 | 2462648 | 2021-09-14 | Colombia | Quindio | 55933 | 1722 | 0 | 4.461 | -75.6674 | 2021-09-15 03:22:37 | Quindio, Colombia | |||
2462649 | 2462649 | 2021-09-14 | Colombia | Risaralda | 87392 | 2214 | 0 | 5.3158 | -75.9928 | 2021-09-15 03:22:37 | Risaralda, Colombia | |||
2462650 | 2462650 | 2021-09-14 | Colombia | San Andres y Providencia | 6832 | 134 | 0 | 12.5567 | -81.7185 | 2021-09-15 03:22:37 | San Andres y Providencia, Colombia | |||
2462651 | 2462651 | 2021-09-14 | Colombia | Santander | 224780 | 7260 | 0 | 6.6437 | -73.6536 | 2021-09-15 03:22:37 | Santander, Colombia | |||
2462652 | 2462652 | 2021-09-14 | Colombia | Sucre | 58888 | 1616 | 0 | 8.814 | -74.7233 | 2021-09-15 03:22:37 | Sucre, Colombia | |||
2462653 | 2462653 | 2021-09-14 | Colombia | Tolima | 107170 | 3642 | 0 | 4.0925 | -75.1545 | 2021-09-15 03:22:37 | Tolima, Colombia | |||
2462654 | 2462654 | 2021-09-14 | Colombia | Unknown | 0 | 296 | 0 | 2021-09-15 03:22:37 | Unknown, Colombia | |||||
2462655 | 2462655 | 2021-09-14 | Colombia | Valle del Cauca | 404508 | 12823 | 0 | 3.8009 | -76.6413 | 2021-09-15 03:22:37 | Valle del Cauca, Colombia | |||
2462656 | 2462656 | 2021-09-14 | Colombia | Vaupes | 1747 | 17 | 0 | 0.8554 | -70.812 | 2021-09-15 03:22:37 | Vaupes, Colombia | |||
2462657 | 2462657 | 2021-09-14 | Colombia | Vichada | 2922 | 51 | 0 | 4.4234 | -69.2878 | 2021-09-15 03:22:37 | Vichada, Colombia | |||
1385463 | 1385463 | 2021-09-13 | Colombia | Amazonas | 6812 | 254 | 0 | -1.4429 | -71.5724 | 2021-09-14 04:21:41 | Amazonas, Colombia | |||
1385464 | 1385464 | 2021-09-13 | Colombia | Antioquia | 740459 | 15947 | 0 | 7.1986 | -75.3412 | 2021-09-14 04:21:41 | Antioquia, Colombia | |||
1385465 | 1385465 | 2021-09-13 | Colombia | Arauca | 13192 | 451 | 0 | 7.0762 | -70.7105 | 2021-09-14 04:21:41 | Arauca, Colombia | |||
1385466 | 1385466 | 2021-09-13 | Colombia | Atlantico | 316357 | 9406 | 0 | 10.6966 | -74.8741 | 2021-09-14 04:21:41 | Atlantico, Colombia | |||
1385467 | 1385467 | 2021-09-13 | Colombia | Bolivar | 155518 | 2948 | 0 | 8.6704 | -74.03 | 2021-09-14 04:21:41 | Bolivar, Colombia | |||
1385468 | 1385468 | 2021-09-13 | Colombia | Boyaca | 104994 | 2540 | 0 | 5.4545 | -73.362 | 2021-09-14 04:21:41 | Boyaca, Colombia | |||
1385469 | 1385469 | 2021-09-13 | Colombia | Caldas | 100064 | 2253 | 0 | 5.2983 | -75.2479 | 2021-09-14 04:21:41 | Caldas, Colombia | |||
1385470 | 1385470 | 2021-09-13 | Colombia | Capital District | 1446300 | 27421 | 0 | 4.711 | -74.0721 | 2021-09-14 04:21:41 | Capital District, Colombia | |||
1385471 | 1385471 | 2021-09-13 | Colombia | Caqueta | 22769 | 928 | 0 | 0.8699 | -73.8419 | 2021-09-14 04:21:41 | Caqueta, Colombia | |||
1385472 | 1385472 | 2021-09-13 | Colombia | Casanare | 35420 | 914 | 0 | 5.7589 | -71.5724 | 2021-09-14 04:21:41 | Casanare, Colombia | |||
1385473 | 1385473 | 2021-09-13 | Colombia | Cauca | 55445 | 1509 | 0 | 2.705 | -76.82600000000002 | 2021-09-14 04:21:41 | Cauca, Colombia | |||
1385474 | 1385474 | 2021-09-13 | Colombia | Cesar | 88518 | 2475 | 0 | 9.3373 | -73.6536 | 2021-09-14 04:21:41 | Cesar, Colombia | |||
1385475 | 1385475 | 2021-09-13 | Colombia | Choco | 16315 | 391 | 0 | 5.2528 | -76.82600000000002 | 2021-09-14 04:21:41 | Choco, Colombia | |||
1385476 | 1385476 | 2021-09-13 | Colombia | Cordoba | 103505 | 3715 | 0 | 8.0493 | -75.574 | 2021-09-14 04:21:41 | Cordoba, Colombia | |||
1385477 | 1385477 | 2021-09-13 | Colombia | Cundinamarca | 262866 | 6788 | 0 | 5.026 | -74.03 | 2021-09-14 04:21:41 | Cundinamarca, Colombia | |||
1385478 | 1385478 | 2021-09-13 | Colombia | Guainia | 2270 | 29 | 0 | 2.5854 | -68.5247 | 2021-09-14 04:21:41 | Guainia, Colombia | |||
1385479 | 1385479 | 2021-09-13 | Colombia | Guaviare | 5126 | 93 | 0 | 1.0654 | -73.2603 | 2021-09-14 04:21:41 | Guaviare, Colombia | |||
1385480 | 1385480 | 2021-09-13 | Colombia | Huila | 88012 | 3131 | 0 | 2.5359 | -75.5277 | 2021-09-14 04:21:41 | Huila, Colombia | |||
1385481 | 1385481 | 2021-09-13 | Colombia | La Guajira | 42184 | 1332 | 0 | 11.3548 | -72.5205 | 2021-09-14 04:21:41 | La Guajira, Colombia | |||
1385482 | 1385482 | 2021-09-13 | Colombia | Magdalena | 92892 | 3300 | 0 | 10.4113 | -74.4057 | 2021-09-14 04:21:41 | Magdalena, Colombia | |||
1385483 | 1385483 | 2021-09-13 | Colombia | Meta | 87652 | 2222 | 0 | 3.272 | -73.0877 | 2021-09-14 04:21:41 | Meta, Colombia | |||
1385484 | 1385484 | 2021-09-13 | Colombia | Narino | 89118 | 2999 | 0 | 1.2892 | -77.3579 | 2021-09-14 04:21:41 | Narino, Colombia | |||
1385485 | 1385485 | 2021-09-13 | Colombia | Norte de Santander | 89681 | 4210 | 0 | 7.9463 | -72.8988 | 2021-09-14 04:21:41 | Norte de Santander, Colombia | |||
1385486 | 1385486 | 2021-09-13 | Colombia | Putumayo | 16164 | 665 | 0 | 0.436 | -75.5277 | 2021-09-14 04:21:41 | Putumayo, Colombia | |||
1385487 | 1385487 | 2021-09-13 | Colombia | Quindio | 55929 | 1721 | 0 | 4.461 | -75.6674 | 2021-09-14 04:21:41 | Quindio, Colombia | |||
1385488 | 1385488 | 2021-09-13 | Colombia | Risaralda | 87386 | 2214 | 0 | 5.3158 | -75.9928 | 2021-09-14 04:21:41 | Risaralda, Colombia | |||
1385489 | 1385489 | 2021-09-13 | Colombia | San Andres y Providencia | 6830 | 134 | 0 | 12.5567 | -81.7185 | 2021-09-14 04:21:41 | San Andres y Providencia, Colombia | |||
1385490 | 1385490 | 2021-09-13 | Colombia | Santander | 224706 | 7258 | 0 | 6.6437 | -73.6536 | 2021-09-14 04:21:41 | Santander, Colombia | |||
1385491 | 1385491 | 2021-09-13 | Colombia | Sucre | 58886 | 1615 | 0 | 8.814 | -74.7233 | 2021-09-14 04:21:41 | Sucre, Colombia | |||
1385492 | 1385492 | 2021-09-13 | Colombia | Tolima | 107160 | 3642 | 0 | 4.0925 | -75.1545 | 2021-09-14 04:21:41 | Tolima, Colombia | |||
1385493 | 1385493 | 2021-09-13 | Colombia | Unknown | 0 | 296 | 0 | 2021-09-14 04:21:41 | Unknown, Colombia | |||||
1385494 | 1385494 | 2021-09-13 | Colombia | Valle del Cauca | 404365 | 12818 | 0 | 3.8009 | -76.6413 | 2021-09-14 04:21:41 | Valle del Cauca, Colombia | |||
1385495 | 1385495 | 2021-09-13 | Colombia | Vaupes | 1747 | 17 | 0 | 0.8554 | -70.812 | 2021-09-14 04:21:41 | Vaupes, Colombia | |||
1385496 | 1385496 | 2021-09-13 | Colombia | Vichada | 2921 | 51 | 0 | 4.4234 | -69.2878 | 2021-09-14 04:21:41 | Vichada, Colombia | |||
1884832 | 1884832 | 2021-09-12 | Colombia | Amazonas | 6812 | 254 | 0 | -1.4429 | -71.5724 | 2021-09-13 04:21:15 | Amazonas, Colombia | |||
1884833 | 1884833 | 2021-09-12 | Colombia | Antioquia | 740085 | 15941 | 0 | 7.1986 | -75.3412 | 2021-09-13 04:21:15 | Antioquia, Colombia | |||
1884834 | 1884834 | 2021-09-12 | Colombia | Arauca | 13191 | 451 | 0 | 7.0762 | -70.7105 | 2021-09-13 04:21:15 | Arauca, Colombia | |||
1884835 | 1884835 | 2021-09-12 | Colombia | Atlantico | 316233 | 9404 | 0 | 10.6966 | -74.8741 | 2021-09-13 04:21:15 | Atlantico, Colombia | |||
1884836 | 1884836 | 2021-09-12 | Colombia | Bolivar | 155497 | 2946 | 0 | 8.6704 | -74.03 | 2021-09-13 04:21:15 | Bolivar, Colombia | |||
1884837 | 1884837 | 2021-09-12 | Colombia | Boyaca | 104976 | 2540 | 0 | 5.4545 | -73.362 | 2021-09-13 04:21:15 | Boyaca, Colombia | |||
1884838 | 1884838 | 2021-09-12 | Colombia | Caldas | 100057 | 2253 | 0 | 5.2983 | -75.2479 | 2021-09-13 04:21:15 | Caldas, Colombia | |||
1884839 | 1884839 | 2021-09-12 | Colombia | Capital District | 1446066 | 27413 | 0 | 4.711 | -74.0721 | 2021-09-13 04:21:15 | Capital District, Colombia | |||
1884840 | 1884840 | 2021-09-12 | Colombia | Caqueta | 22765 | 928 | 0 | 0.8699 | -73.8419 | 2021-09-13 04:21:15 | Caqueta, Colombia | |||
1884841 | 1884841 | 2021-09-12 | Colombia | Casanare | 35418 | 914 | 0 | 5.7589 | -71.5724 | 2021-09-13 04:21:15 | Casanare, Colombia | |||
1884842 | 1884842 | 2021-09-12 | Colombia | Cauca | 55428 | 1509 | 0 | 2.705 | -76.82600000000002 | 2021-09-13 04:21:15 | Cauca, Colombia | |||
1884843 | 1884843 | 2021-09-12 | Colombia | Cesar | 88503 | 2475 | 0 | 9.3373 | -73.6536 | 2021-09-13 04:21:15 | Cesar, Colombia | |||
1884844 | 1884844 | 2021-09-12 | Colombia | Choco | 16315 | 391 | 0 | 5.2528 | -76.82600000000002 | 2021-09-13 04:21:15 | Choco, Colombia | |||
1884845 | 1884845 | 2021-09-12 | Colombia | Cordoba | 103491 | 3713 | 0 | 8.0493 | -75.574 | 2021-09-13 04:21:15 | Cordoba, Colombia | |||
1884846 | 1884846 | 2021-09-12 | Colombia | Cundinamarca | 262847 | 6788 | 0 | 5.026 | -74.03 | 2021-09-13 04:21:15 | Cundinamarca, Colombia | |||
1884847 | 1884847 | 2021-09-12 | Colombia | Guainia | 2270 | 29 | 0 | 2.5854 | -68.5247 | 2021-09-13 04:21:15 | Guainia, Colombia | |||
1884848 | 1884848 | 2021-09-12 | Colombia | Guaviare | 5126 | 93 | 0 | 1.0654 | -73.2603 | 2021-09-13 04:21:15 | Guaviare, Colombia | |||
1884849 | 1884849 | 2021-09-12 | Colombia | Huila | 88008 | 3130 | 0 | 2.5359 | -75.5277 | 2021-09-13 04:21:15 | Huila, Colombia | |||
1884850 | 1884850 | 2021-09-12 | Colombia | La Guajira | 42177 | 1332 | 0 | 11.3548 | -72.5205 | 2021-09-13 04:21:15 | La Guajira, Colombia | |||
1884851 | 1884851 | 2021-09-12 | Colombia | Magdalena | 92868 | 3297 | 0 | 10.4113 | -74.4057 | 2021-09-13 04:21:15 | Magdalena, Colombia | |||
1884852 | 1884852 | 2021-09-12 | Colombia | Meta | 87645 | 2220 | 0 | 3.272 | -73.0877 | 2021-09-13 04:21:15 | Meta, Colombia | |||
1884853 | 1884853 | 2021-09-12 | Colombia | Narino | 89106 | 2999 | 0 | 1.2892 | -77.3579 | 2021-09-13 04:21:15 | Narino, Colombia | |||
1884854 | 1884854 | 2021-09-12 | Colombia | Norte de Santander | 89665 | 4207 | 0 | 7.9463 | -72.8988 | 2021-09-13 04:21:15 | Norte de Santander, Colombia | |||
1884855 | 1884855 | 2021-09-12 | Colombia | Putumayo | 16162 | 665 | 0 | 0.436 | -75.5277 | 2021-09-13 04:21:15 | Putumayo, Colombia | |||
1884856 | 1884856 | 2021-09-12 | Colombia | Quindio | 55924 | 1720 | 0 | 4.461 | -75.6674 | 2021-09-13 04:21:15 | Quindio, Colombia | |||
1884857 | 1884857 | 2021-09-12 | Colombia | Risaralda | 87369 | 2214 | 0 | 5.3158 | -75.9928 | 2021-09-13 04:21:15 | Risaralda, Colombia | |||
1884858 | 1884858 | 2021-09-12 | Colombia | San Andres y Providencia | 6830 | 134 | 0 | 12.5567 | -81.7185 | 2021-09-13 04:21:15 | San Andres y Providencia, Colombia | |||
1884859 | 1884859 | 2021-09-12 | Colombia | Santander | 224635 | 7255 | 0 | 6.6437 | -73.6536 | 2021-09-13 04:21:15 | Santander, Colombia | |||
1884860 | 1884860 | 2021-09-12 | Colombia | Sucre | 58881 | 1614 | 0 | 8.814 | -74.7233 | 2021-09-13 04:21:15 | Sucre, Colombia | |||
1884861 | 1884861 | 2021-09-12 | Colombia | Tolima | 107150 | 3641 | 0 | 4.0925 | -75.1545 | 2021-09-13 04:21:15 | Tolima, Colombia | |||
1884862 | 1884862 | 2021-09-12 | Colombia | Unknown | 0 | 296 | 0 | 2021-09-13 04:21:15 | Unknown, Colombia | |||||
1884863 | 1884863 | 2021-09-12 | Colombia | Valle del Cauca | 404081 | 12814 | 0 | 3.8009 | -76.6413 | 2021-09-13 04:21:15 | 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] 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]);