johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region, last_update
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2207441 | 2207441 | 2021-03-04 | Chile | Coquimbo | 21599 | 418 | 20100 | 1081 | -29.959 | -71.3389 | 2021-03-05 05:26:29 | Coquimbo, Chile | ||
2207442 | 2207442 | 2021-03-04 | Chile | Los Lagos | 52567 | 647 | 50172 | 1748 | -41.9198 | -72.1416 | 2021-03-05 05:26:29 | Los Lagos, Chile | ||
2207443 | 2207443 | 2021-03-04 | Chile | Los Rios | 20212 | 240 | 18506 | 1466 | -40.231 | -72.3311 | 2021-03-05 05:26:29 | Los Rios, Chile | ||
2207444 | 2207444 | 2021-03-04 | Chile | Magallanes | 22053 | 318 | 21363 | 372 | -52.368 | -70.9863 | 2021-03-05 05:26:29 | Magallanes, Chile | ||
2207445 | 2207445 | 2021-03-04 | Chile | Maule | 44021 | 862 | 41481 | 1678 | -35.5183 | -71.6885 | 2021-03-05 05:26:29 | Maule, Chile | ||
2207446 | 2207446 | 2021-03-04 | Chile | Metropolitana | 368835 | 12081 | 350359 | 6395 | -33.4376 | -70.6505 | 2021-03-05 05:26:29 | Metropolitana, Chile | ||
2207447 | 2207447 | 2021-03-04 | Chile | Nuble | 17338 | 328 | 16380 | 630 | -36.7226 | -71.7622 | 2021-03-05 05:26:29 | Nuble, Chile | ||
2207448 | 2207448 | 2021-03-04 | Chile | OHiggins | 31046 | 773 | 29055 | 1218 | -34.5755 | -71.0022 | 2021-03-05 05:26:29 | OHiggins, Chile | ||
2207449 | 2207449 | 2021-03-04 | Chile | Tarapaca | 25104 | 443 | 23993 | 668 | -19.9232 | -69.5132 | 2021-03-05 05:26:29 | Tarapaca, Chile | ||
2207450 | 2207450 | 2021-03-04 | Chile | Unknown | 51 | 1 | 51 | 0 | 2021-03-05 05:26:29 | Unknown, Chile | ||||
2207451 | 2207451 | 2021-03-04 | Chile | Valparaiso | 51414 | 1621 | 47681 | 2112 | -33.0472 | -71.6127 | 2021-03-05 05:26:29 | Valparaiso, Chile | ||
2207452 | 2207452 | 2021-03-04 | China | Anhui | 994 | 6 | 988 | 0 | 31.8257 | 117.2264 | 2021-03-05 05:26:29 | Anhui, China | ||
2207453 | 2207453 | 2021-03-04 | China | Beijing | 1049 | 9 | 1029 | 11 | 40.1824 | 116.4142 | 2021-03-05 05:26:29 | Beijing, China | ||
2207454 | 2207454 | 2021-03-04 | China | Chongqing | 591 | 6 | 585 | 0 | 30.0572 | 107.874 | 2021-03-05 05:26:29 | Chongqing, China | ||
2207455 | 2207455 | 2021-03-04 | China | Fujian | 551 | 1 | 546 | 4 | 26.0789 | 117.9874 | 2021-03-05 05:26:29 | Fujian, China | ||
2207456 | 2207456 | 2021-03-04 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-05 05:26:29 | Gansu, China | ||
2207457 | 2207457 | 2021-03-04 | China | Guangdong | 2222 | 8 | 2167 | 47 | 23.3417 | 113.4244 | 2021-03-05 05:26:29 | Guangdong, China | ||
2207458 | 2207458 | 2021-03-04 | China | Guangxi | 267 | 2 | 265 | 0 | 23.8298 | 108.7881 | 2021-03-05 05:26:29 | Guangxi, China | ||
2207459 | 2207459 | 2021-03-04 | China | Guizhou | 147 | 2 | 145 | 0 | 26.8154 | 106.8748 | 2021-03-05 05:26:29 | Guizhou, China | ||
2207460 | 2207460 | 2021-03-04 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-05 05:26:29 | Hainan, China | ||
2207461 | 2207461 | 2021-03-04 | China | Hebei | 1317 | 7 | 1310 | 0 | 37.8957 | 114.9042 | 2021-03-05 05:26:29 | Hebei, China | ||
2207462 | 2207462 | 2021-03-04 | China | Heilongjiang | 1610 | 13 | 1597 | 0 | 47.862 | 127.7615 | 2021-03-05 05:26:29 | Heilongjiang, China | ||
2207463 | 2207463 | 2021-03-04 | China | Henan | 1305 | 22 | 1281 | 2 | 33.882 | 113.614 | 2021-03-05 05:26:29 | Henan, China | ||
2207464 | 2207464 | 2021-03-04 | China | Hong Kong | 11055 | 201 | 10593 | 261 | 22.3 | 114.2 | 2021-03-05 05:26:29 | Hong Kong, China | ||
2207465 | 2207465 | 2021-03-04 | China | Hubei | 68151 | 4512 | 63639 | 0 | 30.9756 | 112.2707 | 2021-03-05 05:26:29 | Hubei, China | ||
2207466 | 2207466 | 2021-03-04 | China | Hunan | 1037 | 4 | 1027 | 6 | 27.6104 | 111.7088 | 2021-03-05 05:26:29 | Hunan, China | ||
2207467 | 2207467 | 2021-03-04 | China | Inner Mongolia | 367 | 1 | 365 | 1 | 44.0935 | 113.9448 | 2021-03-05 05:26:29 | Inner Mongolia, China | ||
2207468 | 2207468 | 2021-03-04 | China | Jiangsu | 704 | 0 | 701 | 3 | 32.9711 | 119.455 | 2021-03-05 05:26:29 | Jiangsu, China | ||
2207469 | 2207469 | 2021-03-04 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2021-03-05 05:26:29 | Jiangxi, China | ||
2207470 | 2207470 | 2021-03-04 | China | Jilin | 573 | 3 | 570 | 0 | 43.6661 | 126.1923 | 2021-03-05 05:26:29 | Jilin, China | ||
2207471 | 2207471 | 2021-03-04 | China | Liaoning | 406 | 2 | 402 | 2 | 41.2956 | 122.6085 | 2021-03-05 05:26:29 | Liaoning, China | ||
2207472 | 2207472 | 2021-03-04 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-05 05:26:29 | Macau, China | ||
2207473 | 2207473 | 2021-03-04 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2021-03-05 05:26:29 | Ningxia, China | ||
2207474 | 2207474 | 2021-03-04 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-03-05 05:26:29 | Qinghai, China | ||
2207475 | 2207475 | 2021-03-04 | China | Shaanxi | 553 | 3 | 542 | 8 | 35.1917 | 108.8701 | 2021-03-05 05:26:29 | Shaanxi, China | ||
2207476 | 2207476 | 2021-03-04 | China | Shandong | 869 | 7 | 861 | 1 | 36.3427 | 118.1498 | 2021-03-05 05:26:29 | Shandong, China | ||
2207477 | 2207477 | 2021-03-04 | China | Shanghai | 1808 | 7 | 1763 | 38 | 31.202 | 121.4491 | 2021-03-05 05:26:29 | Shanghai, China | ||
2207478 | 2207478 | 2021-03-04 | China | Shanxi | 240 | 0 | 238 | 2 | 37.5777 | 112.2922 | 2021-03-05 05:26:29 | Shanxi, China | ||
2207479 | 2207479 | 2021-03-04 | China | Sichuan | 910 | 3 | 877 | 30 | 30.6171 | 102.7103 | 2021-03-05 05:26:29 | Sichuan, China | ||
2207480 | 2207480 | 2021-03-04 | China | Tianjin | 358 | 3 | 339 | 16 | 39.3054 | 117.323 | 2021-03-05 05:26:29 | Tianjin, China | ||
2207481 | 2207481 | 2021-03-04 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-03-05 05:26:29 | Tibet, China | ||
2207482 | 2207482 | 2021-03-04 | China | Unknown | 8076 | 0 | 3 | 0 | 2021-03-05 05:26:29 | Unknown, China | ||||
2207483 | 2207483 | 2021-03-04 | China | Xinjiang | 980 | 3 | 977 | 0 | 41.1129 | 85.2401 | 2021-03-05 05:26:29 | Xinjiang, China | ||
2207484 | 2207484 | 2021-03-04 | China | Yunnan | 234 | 2 | 229 | 3 | 24.974 | 101.487 | 2021-03-05 05:26:29 | Yunnan, China | ||
2207485 | 2207485 | 2021-03-04 | China | Zhejiang | 1322 | 1 | 1314 | 7 | 29.1832 | 120.0934 | 2021-03-05 05:26:29 | Zhejiang, China | ||
2207486 | 2207486 | 2021-03-04 | Colombia | Amazonas | 5316 | 182 | 4977 | 157 | -1.4429 | -71.5724 | 2021-03-05 05:26:29 | Amazonas, Colombia | ||
2207487 | 2207487 | 2021-03-04 | Colombia | Antioquia | 346832 | 6587 | 335052 | 5193 | 7.1986 | -75.3412 | 2021-03-05 05:26:29 | Antioquia, Colombia | ||
2207488 | 2207488 | 2021-03-04 | Colombia | Arauca | 5599 | 170 | 5313 | 116 | 7.0762 | -70.7105 | 2021-03-05 05:26:29 | Arauca, Colombia | ||
2207489 | 2207489 | 2021-03-04 | Colombia | Atlantico | 124518 | 4047 | 118573 | 1898 | 10.6966 | -74.8741 | 2021-03-05 05:26:29 | Atlantico, Colombia | ||
2207490 | 2207490 | 2021-03-04 | Colombia | Bolivar | 67131 | 1359 | 65157 | 615 | 8.6704 | -74.03 | 2021-03-05 05:26:29 | Bolivar, Colombia | ||
2207491 | 2207491 | 2021-03-04 | Colombia | Boyaca | 46490 | 1095 | 44350 | 1045 | 5.4545 | -73.362 | 2021-03-05 05:26:29 | Boyaca, Colombia | ||
2207492 | 2207492 | 2021-03-04 | Colombia | Caldas | 46691 | 981 | 44732 | 978 | 5.2983 | -75.2479 | 2021-03-05 05:26:29 | Caldas, Colombia | ||
2207493 | 2207493 | 2021-03-04 | Colombia | Capital District | 661207 | 13916 | 634594 | 12697 | 4.711 | -74.0721 | 2021-03-05 05:26:29 | Capital District, Colombia | ||
2207494 | 2207494 | 2021-03-04 | Colombia | Caqueta | 17058 | 634 | 16168 | 256 | 0.8699 | -73.8419 | 2021-03-05 05:26:29 | Caqueta, Colombia | ||
2207495 | 2207495 | 2021-03-04 | Colombia | Casanare | 12446 | 273 | 11827 | 346 | 5.7589 | -71.5724 | 2021-03-05 05:26:29 | Casanare, Colombia | ||
2207496 | 2207496 | 2021-03-04 | Colombia | Cauca | 27467 | 751 | 26147 | 569 | 2.705 | -76.82600000000002 | 2021-03-05 05:26:29 | Cauca, Colombia | ||
2207497 | 2207497 | 2021-03-04 | Colombia | Cesar | 40670 | 1186 | 38772 | 712 | 9.3373 | -73.6536 | 2021-03-05 05:26:29 | Cesar, Colombia | ||
2207498 | 2207498 | 2021-03-04 | Colombia | Choco | 6561 | 201 | 6276 | 84 | 5.2528 | -76.82600000000002 | 2021-03-05 05:26:29 | Choco, Colombia | ||
2207499 | 2207499 | 2021-03-04 | Colombia | Cordoba | 38104 | 1847 | 35066 | 1191 | 8.0493 | -75.574 | 2021-03-05 05:26:29 | Cordoba, Colombia | ||
2207500 | 2207500 | 2021-03-04 | Colombia | Cundinamarca | 106445 | 2905 | 101475 | 2065 | 5.026 | -74.03 | 2021-03-05 05:26:29 | Cundinamarca, Colombia | ||
2207501 | 2207501 | 2021-03-04 | Colombia | Guainia | 1305 | 22 | 1276 | 7 | 2.5854 | -68.5247 | 2021-03-05 05:26:29 | Guainia, Colombia | ||
2207502 | 2207502 | 2021-03-04 | Colombia | Guaviare | 2252 | 40 | 2199 | 13 | 1.0654 | -73.2603 | 2021-03-05 05:26:29 | Guaviare, Colombia | ||
2207503 | 2207503 | 2021-03-04 | Colombia | Huila | 49890 | 1739 | 47683 | 468 | 2.5359 | -75.5277 | 2021-03-05 05:26:29 | Huila, Colombia | ||
2207504 | 2207504 | 2021-03-04 | Colombia | La Guajira | 16276 | 637 | 15382 | 257 | 11.3548 | -72.5205 | 2021-03-05 05:26:29 | La Guajira, Colombia | ||
2207505 | 2207505 | 2021-03-04 | Colombia | Magdalena | 34769 | 1316 | 32123 | 1330 | 10.4113 | -74.4057 | 2021-03-05 05:26:29 | Magdalena, Colombia | ||
2207506 | 2207506 | 2021-03-04 | Colombia | Meta | 42546 | 974 | 41036 | 536 | 3.272 | -73.0877 | 2021-03-05 05:26:29 | Meta, Colombia | ||
2207507 | 2207507 | 2021-03-04 | Colombia | Narino | 49140 | 1625 | 46500 | 1015 | 1.2892 | -77.3579 | 2021-03-05 05:26:29 | Narino, Colombia | ||
2207508 | 2207508 | 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 | ||
2207509 | 2207509 | 2021-03-04 | Colombia | Putumayo | 7922 | 314 | 7374 | 234 | 0.436 | -75.5277 | 2021-03-05 05:26:29 | Putumayo, Colombia | ||
2207510 | 2207510 | 2021-03-04 | Colombia | Quindio | 32358 | 961 | 30853 | 544 | 4.461 | -75.6674 | 2021-03-05 05:26:29 | Quindio, Colombia | ||
2207511 | 2207511 | 2021-03-04 | Colombia | Risaralda | 46281 | 1148 | 44300 | 833 | 5.3158 | -75.9928 | 2021-03-05 05:26:29 | Risaralda, Colombia | ||
2207512 | 2207512 | 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 | ||
2207513 | 2207513 | 2021-03-04 | Colombia | Santander | 91617 | 3347 | 86273 | 1997 | 6.6437 | -73.6536 | 2021-03-05 05:26:29 | Santander, Colombia | ||
2207514 | 2207514 | 2021-03-04 | Colombia | Sucre | 20731 | 785 | 19494 | 452 | 8.814 | -74.7233 | 2021-03-05 05:26:29 | Sucre, Colombia | ||
2207515 | 2207515 | 2021-03-04 | Colombia | Tolima | 65494 | 2107 | 62442 | 945 | 4.0925 | -75.1545 | 2021-03-05 05:26:29 | Tolima, Colombia | ||
2207516 | 2207516 | 2021-03-04 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-03-05 05:26:29 | Unknown, Colombia | ||||
2207517 | 2207517 | 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 | ||
2207518 | 2207518 | 2021-03-04 | Colombia | Vaupes | 1153 | 13 | 1135 | 5 | 0.8554 | -70.812 | 2021-03-05 05:26:29 | Vaupes, Colombia | ||
2207519 | 2207519 | 2021-03-04 | Colombia | Vichada | 1377 | 22 | 1344 | 11 | 4.4234 | -69.2878 | 2021-03-05 05:26:29 | Vichada, Colombia | ||
2207520 | 2207520 | 2021-03-04 | Comoros | 3580 | 144 | 3369 | 67 | -11.6455 | 43.3333 | 2021-03-05 05:26:29 | Comoros | |||
2207521 | 2207521 | 2021-03-04 | Congo (Brazzaville) | 9179 | 131 | 7019 | 2029 | -0.228 | 15.8277 | 2021-03-05 05:26:29 | Congo (Brazzaville) | |||
2207522 | 2207522 | 2021-03-04 | Congo (Kinshasa) | 26340 | 711 | 20601 | 5028 | -4.0383 | 21.7587 | 2021-03-05 05:26:29 | Congo (Kinshasa) | |||
2207523 | 2207523 | 2021-03-04 | Costa Rica | 206293 | 2829 | 186093 | 17371 | 9.7489 | -83.7534 | 2021-03-05 05:26:29 | Costa Rica | |||
2207524 | 2207524 | 2021-03-04 | Cote d'Ivoire | 33976 | 196 | 32245 | 1535 | 7.54 | -5.5471 | 2021-03-05 05:26:29 | Cote d'Ivoire | |||
2207525 | 2207525 | 2021-03-04 | Croatia | 244872 | 5564 | 235750 | 3558 | 45.1 | 15.2 | 2021-03-05 05:26:29 | Croatia | |||
2207526 | 2207526 | 2021-03-04 | Cuba | 53308 | 336 | 48341 | 4631 | 21.521757 | -77.78116700000002 | 2021-03-05 05:26:29 | Cuba | |||
2207527 | 2207527 | 2021-03-04 | Cyprus | 36295 | 233 | 2057 | 34005 | 35.1264 | 33.4299 | 2021-03-05 05:26:29 | Cyprus | |||
2207528 | 2207528 | 2021-03-04 | Czechia | 1284288 | 21128 | 1104592 | 158568 | 49.8175 | 15.473 | 2021-03-05 05:26:29 | Czechia | |||
2207529 | 2207529 | 2021-03-04 | Denmark | Faroe Islands | 658 | 1 | 657 | 0 | 61.8926 | -6.9118 | 2021-03-05 05:26:29 | Faroe Islands, Denmark | ||
2207530 | 2207530 | 2021-03-04 | Denmark | Greenland | 31 | 0 | 30 | 1 | 71.7069 | -42.6043 | 2021-03-05 05:26:29 | Greenland, Denmark | ||
2207531 | 2207531 | 2021-03-04 | Denmark | 213318 | 2374 | 203934 | 7010 | 56.2639 | 9.5018 | 2021-03-05 05:26:29 | Denmark | |||
2207532 | 2207532 | 2021-03-04 | Diamond Princess | 712 | 13 | 699 | 0 | 2021-03-05 05:26:29 | Diamond Princess | |||||
2207533 | 2207533 | 2021-03-04 | Djibouti | 6110 | 63 | 5926 | 121 | 11.8251 | 42.5903 | 2021-03-05 05:26:29 | Djibouti | |||
2207534 | 2207534 | 2021-03-04 | Dominica | 144 | 0 | 130 | 14 | 15.415 | -61.371 | 2021-03-05 05:26:29 | Dominica | |||
2207535 | 2207535 | 2021-03-04 | Dominican Republic | 241392 | 3139 | 194653 | 43600 | 18.7357 | -70.1627 | 2021-03-05 05:26:29 | Dominican Republic | |||
2207536 | 2207536 | 2021-03-04 | Ecuador | 289735 | 15959 | 247898 | 25878 | -1.8312 | -78.1834 | 2021-03-05 05:26:29 | Ecuador | |||
2207537 | 2207537 | 2021-03-04 | Egypt | 184755 | 10871 | 142610 | 31274 | 26.820553000000004 | 30.802498 | 2021-03-05 05:26:29 | Egypt | |||
2207538 | 2207538 | 2021-03-04 | El Salvador | 60800 | 1887 | 56807 | 2106 | 13.7942 | -88.8965 | 2021-03-05 05:26:29 | El Salvador | |||
2207539 | 2207539 | 2021-03-04 | Equatorial Guinea | 6210 | 93 | 5690 | 427 | 1.6508 | 10.2679 | 2021-03-05 05:26:29 | Equatorial Guinea | |||
2207540 | 2207540 | 2021-03-04 | Eritrea | 2913 | 7 | 2388 | 518 | 15.1794 | 39.7823 | 2021-03-05 05:26:29 | Eritrea |
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]);