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