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
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2625660 | 2625660 | 2021-01-10 | Chile | Coquimbo | 14785 | 310 | 14115 | 360 | -29.959 | -71.3389 | 2021-01-11 05:21:50 | Coquimbo, Chile | ||
2625661 | 2625661 | 2021-01-10 | Chile | Los Lagos | 29677 | 281 | 26799 | 2597 | -41.9198 | -72.1416 | 2021-01-11 05:21:50 | Los Lagos, Chile | ||
2625662 | 2625662 | 2021-01-10 | Chile | Los Rios | 10462 | 110 | 9244 | 1108 | -40.231 | -72.3311 | 2021-01-11 05:21:50 | Los Rios, Chile | ||
2625663 | 2625663 | 2021-01-10 | Chile | Magallanes | 17916 | 241 | 17055 | 620 | -52.368 | -70.9863 | 2021-01-11 05:21:50 | Magallanes, Chile | ||
2625664 | 2625664 | 2021-01-10 | Chile | Maule | 28341 | 592 | 25841 | 1908 | -35.5183 | -71.6885 | 2021-01-11 05:21:50 | Maule, Chile | ||
2625665 | 2625665 | 2021-01-10 | Chile | Metropolitana | 326465 | 10961 | 310534 | 4970 | -33.4376 | -70.6505 | 2021-01-11 05:21:50 | Metropolitana, Chile | ||
2625666 | 2625666 | 2021-01-10 | Chile | Nuble | 11552 | 228 | 10756 | 568 | -36.7226 | -71.7622 | 2021-01-11 05:21:50 | Nuble, Chile | ||
2625667 | 2625667 | 2021-01-10 | Chile | OHiggins | 22705 | 604 | 21346 | 755 | -34.5755 | -71.0022 | 2021-01-11 05:21:50 | OHiggins, Chile | ||
2625668 | 2625668 | 2021-01-10 | Chile | Tarapaca | 17340 | 303 | 15948 | 1089 | -19.9232 | -69.5132 | 2021-01-11 05:21:50 | Tarapaca, Chile | ||
2625669 | 2625669 | 2021-01-10 | Chile | Unknown | 53 | 1 | 50 | 2 | 2021-01-11 05:21:50 | Unknown, Chile | ||||
2625670 | 2625670 | 2021-01-10 | Chile | Valparaiso | 38158 | 1290 | 35268 | 1600 | -33.0472 | -71.6127 | 2021-01-11 05:21:50 | Valparaiso, Chile | ||
2625671 | 2625671 | 2021-01-10 | China | Anhui | 993 | 6 | 987 | 0 | 31.8257 | 117.2264 | 2021-01-11 05:21:50 | Anhui, China | ||
2625672 | 2625672 | 2021-01-10 | China | Beijing | 997 | 9 | 951 | 37 | 40.1824 | 116.4142 | 2021-01-11 05:21:50 | Beijing, China | ||
2625673 | 2625673 | 2021-01-10 | China | Chongqing | 590 | 6 | 584 | 0 | 30.0572 | 107.874 | 2021-01-11 05:21:50 | Chongqing, China | ||
2625674 | 2625674 | 2021-01-10 | China | Fujian | 527 | 1 | 497 | 29 | 26.0789 | 117.9874 | 2021-01-11 05:21:50 | Fujian, China | ||
2625675 | 2625675 | 2021-01-10 | China | Gansu | 182 | 2 | 180 | 0 | 35.7518 | 104.2861 | 2021-01-11 05:21:50 | Gansu, China | ||
2625676 | 2625676 | 2021-01-10 | China | Guangdong | 2075 | 8 | 2024 | 43 | 23.3417 | 113.4244 | 2021-01-11 05:21:50 | Guangdong, China | ||
2625677 | 2625677 | 2021-01-10 | China | Guangxi | 264 | 2 | 261 | 1 | 23.8298 | 108.7881 | 2021-01-11 05:21:50 | Guangxi, China | ||
2625678 | 2625678 | 2021-01-10 | China | Guizhou | 147 | 2 | 145 | 0 | 26.8154 | 106.8748 | 2021-01-11 05:21:50 | Guizhou, China | ||
2625679 | 2625679 | 2021-01-10 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-11 05:21:50 | Hainan, China | ||
2625680 | 2625680 | 2021-01-10 | China | Hebei | 640 | 6 | 367 | 267 | 37.8957 | 114.9042 | 2021-01-11 05:21:50 | Hebei, China | ||
2625681 | 2625681 | 2021-01-10 | China | Heilongjiang | 971 | 13 | 949 | 9 | 47.862 | 127.7615 | 2021-01-11 05:21:50 | Heilongjiang, China | ||
2625682 | 2625682 | 2021-01-10 | China | Henan | 1301 | 22 | 1273 | 6 | 33.882 | 113.614 | 2021-01-11 05:21:50 | Henan, China | ||
2625683 | 2625683 | 2021-01-10 | China | Hong Kong | 9242 | 158 | 8423 | 661 | 22.3 | 114.2 | 2021-01-11 05:21:50 | Hong Kong, China | ||
2625684 | 2625684 | 2021-01-10 | China | Hubei | 68149 | 4512 | 63637 | 0 | 30.9756 | 112.2707 | 2021-01-11 05:21:50 | Hubei, China | ||
2625685 | 2625685 | 2021-01-10 | China | Hunan | 1022 | 4 | 1017 | 1 | 27.6104 | 111.7088 | 2021-01-11 05:21:50 | Hunan, China | ||
2625686 | 2625686 | 2021-01-10 | China | Inner Mongolia | 366 | 1 | 349 | 16 | 44.0935 | 113.9448 | 2021-01-11 05:21:50 | Inner Mongolia, China | ||
2625687 | 2625687 | 2021-01-10 | China | Jiangsu | 687 | 0 | 684 | 3 | 32.9711 | 119.455 | 2021-01-11 05:21:50 | Jiangsu, China | ||
2625688 | 2625688 | 2021-01-10 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2021-01-11 05:21:50 | Jiangxi, China | ||
2625689 | 2625689 | 2021-01-10 | China | Jilin | 157 | 2 | 155 | 0 | 43.6661 | 126.1923 | 2021-01-11 05:21:50 | Jilin, China | ||
2625690 | 2625690 | 2021-01-10 | China | Liaoning | 393 | 2 | 314 | 77 | 41.2956 | 122.6085 | 2021-01-11 05:21:50 | Liaoning, China | ||
2625691 | 2625691 | 2021-01-10 | China | Macau | 46 | 0 | 46 | 0 | 22.1667 | 113.55 | 2021-01-11 05:21:50 | Macau, China | ||
2625692 | 2625692 | 2021-01-10 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2021-01-11 05:21:50 | Ningxia, China | ||
2625693 | 2625693 | 2021-01-10 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-01-11 05:21:50 | Qinghai, China | ||
2625694 | 2625694 | 2021-01-10 | China | Shaanxi | 523 | 3 | 498 | 22 | 35.1917 | 108.8701 | 2021-01-11 05:21:50 | Shaanxi, China | ||
2625695 | 2625695 | 2021-01-10 | China | Shandong | 864 | 7 | 852 | 5 | 36.3427 | 118.1498 | 2021-01-11 05:21:50 | Shandong, China | ||
2625696 | 2625696 | 2021-01-10 | China | Shanghai | 1564 | 7 | 1457 | 100 | 31.202 | 121.4491 | 2021-01-11 05:21:50 | Shanghai, China | ||
2625697 | 2625697 | 2021-01-10 | China | Shanxi | 226 | 0 | 224 | 2 | 37.5777 | 112.2922 | 2021-01-11 05:21:50 | Shanxi, China | ||
2625698 | 2625698 | 2021-01-10 | China | Sichuan | 857 | 3 | 835 | 19 | 30.6171 | 102.7103 | 2021-01-11 05:21:50 | Sichuan, China | ||
2625699 | 2625699 | 2021-01-10 | China | Tianjin | 322 | 3 | 303 | 16 | 39.3054 | 117.323 | 2021-01-11 05:21:50 | Tianjin, China | ||
2625700 | 2625700 | 2021-01-10 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-01-11 05:21:50 | Tibet, China | ||
2625701 | 2625701 | 2021-01-10 | China | Xinjiang | 980 | 3 | 977 | 0 | 41.1129 | 85.2401 | 2021-01-11 05:21:50 | Xinjiang, China | ||
2625702 | 2625702 | 2021-01-10 | China | Yunnan | 231 | 2 | 219 | 10 | 24.974 | 101.487 | 2021-01-11 05:21:50 | Yunnan, China | ||
2625703 | 2625703 | 2021-01-10 | China | Zhejiang | 1308 | 1 | 1296 | 11 | 29.1832 | 120.0934 | 2021-01-11 05:21:50 | Zhejiang, China | ||
2625704 | 2625704 | 2021-01-10 | Colombia | Amazonas | 3333 | 127 | 3172 | 34 | -1.4429 | -71.5724 | 2021-01-11 05:21:50 | Amazonas, Colombia | ||
2625705 | 2625705 | 2021-01-10 | Colombia | Antioquia | 287473 | 5112 | 261307 | 21054 | 7.1986 | -75.3412 | 2021-01-11 05:21:50 | Antioquia, Colombia | ||
2625706 | 2625706 | 2021-01-10 | Colombia | Arauca | 4761 | 137 | 4436 | 188 | 7.0762 | -70.7105 | 2021-01-11 05:21:50 | Arauca, Colombia | ||
2625707 | 2625707 | 2021-01-10 | Colombia | Atlantico | 99883 | 3550 | 92543 | 3790 | 10.6966 | -74.8741 | 2021-01-11 05:21:50 | Atlantico, Colombia | ||
2625708 | 2625708 | 2021-01-10 | Colombia | Bolivar | 55628 | 1162 | 52637 | 1829 | 8.6704 | -74.03 | 2021-01-11 05:21:50 | Bolivar, Colombia | ||
2625709 | 2625709 | 2021-01-10 | Colombia | Boyaca | 32464 | 684 | 29002 | 2778 | 5.4545 | -73.362 | 2021-01-11 05:21:50 | Boyaca, Colombia | ||
2625710 | 2625710 | 2021-01-10 | Colombia | Caldas | 36021 | 704 | 32516 | 2801 | 5.2983 | -75.2479 | 2021-01-11 05:21:50 | Caldas, Colombia | ||
2625711 | 2625711 | 2021-01-10 | Colombia | Capital District | 518261 | 10564 | 459060 | 48637 | 4.711 | -74.0721 | 2021-01-11 05:21:50 | Capital District, Colombia | ||
2625712 | 2625712 | 2021-01-10 | Colombia | Caqueta | 15450 | 550 | 14019 | 881 | 0.8699 | -73.8419 | 2021-01-11 05:21:50 | Caqueta, Colombia | ||
2625713 | 2625713 | 2021-01-10 | Colombia | Casanare | 9549 | 191 | 8774 | 584 | 5.7589 | -71.5724 | 2021-01-11 05:21:50 | Casanare, Colombia | ||
2625714 | 2625714 | 2021-01-10 | Colombia | Cauca | 20286 | 522 | 18324 | 1440 | 2.705 | -76.82600000000002 | 2021-01-11 05:21:50 | Cauca, Colombia | ||
2625715 | 2625715 | 2021-01-10 | Colombia | Cesar | 34913 | 1016 | 31938 | 1959 | 9.3373 | -73.6536 | 2021-01-11 05:21:50 | Cesar, Colombia | ||
2625716 | 2625716 | 2021-01-10 | Colombia | Choco | 5107 | 169 | 4799 | 139 | 5.2528 | -76.82600000000002 | 2021-01-11 05:21:50 | Choco, Colombia | ||
2625717 | 2625717 | 2021-01-10 | Colombia | Cordoba | 30264 | 1683 | 27991 | 590 | 8.0493 | -75.574 | 2021-01-11 05:21:50 | Cordoba, Colombia | ||
2625718 | 2625718 | 2021-01-10 | Colombia | Cundinamarca | 74417 | 1854 | 68017 | 4546 | 5.026 | -74.03 | 2021-01-11 05:21:50 | Cundinamarca, Colombia | ||
2625719 | 2625719 | 2021-01-10 | Colombia | Guainia | 1241 | 20 | 1211 | 10 | 2.5854 | -68.5247 | 2021-01-11 05:21:50 | Guainia, Colombia | ||
2625720 | 2625720 | 2021-01-10 | Colombia | Guaviare | 2027 | 37 | 1946 | 44 | 1.0654 | -73.2603 | 2021-01-11 05:21:50 | Guaviare, Colombia | ||
2625721 | 2625721 | 2021-01-10 | Colombia | Huila | 37591 | 1189 | 34759 | 1643 | 2.5359 | -75.5277 | 2021-01-11 05:21:50 | Huila, Colombia | ||
2625722 | 2625722 | 2021-01-10 | Colombia | La Guajira | 14599 | 558 | 13508 | 533 | 11.3548 | -72.5205 | 2021-01-11 05:21:50 | La Guajira, Colombia | ||
2625723 | 2625723 | 2021-01-10 | Colombia | Magdalena | 26128 | 1109 | 23960 | 1059 | 10.4113 | -74.4057 | 2021-01-11 05:21:50 | Magdalena, Colombia | ||
2625724 | 2625724 | 2021-01-10 | Colombia | Meta | 36024 | 778 | 33931 | 1315 | 3.272 | -73.0877 | 2021-01-11 05:21:50 | Meta, Colombia | ||
2625725 | 2625725 | 2021-01-10 | Colombia | Narino | 35902 | 1074 | 32264 | 2564 | 1.2892 | -77.3579 | 2021-01-11 05:21:50 | Narino, Colombia | ||
2625726 | 2625726 | 2021-01-10 | Colombia | Norte de Santander | 43428 | 2198 | 39322 | 1908 | 7.9463 | -72.8988 | 2021-01-11 05:21:50 | Norte de Santander, Colombia | ||
2625727 | 2625727 | 2021-01-10 | Colombia | Putumayo | 6306 | 255 | 5727 | 324 | 0.436 | -75.5277 | 2021-01-11 05:21:50 | Putumayo, Colombia | ||
2625728 | 2625728 | 2021-01-10 | Colombia | Quindio | 25810 | 715 | 23653 | 1442 | 4.461 | -75.6674 | 2021-01-11 05:21:50 | Quindio, Colombia | ||
2625729 | 2625729 | 2021-01-10 | Colombia | Risaralda | 38235 | 849 | 34715 | 2671 | 5.3158 | -75.9928 | 2021-01-11 05:21:50 | Risaralda, Colombia | ||
2625730 | 2625730 | 2021-01-10 | Colombia | San Andres y Providencia | 2503 | 42 | 2430 | 31 | 12.5567 | -81.7185 | 2021-01-11 05:21:50 | San Andres y Providencia, Colombia | ||
2625731 | 2625731 | 2021-01-10 | Colombia | Santander | 72585 | 2542 | 65422 | 4621 | 6.6437 | -73.6536 | 2021-01-11 05:21:50 | Santander, Colombia | ||
2625732 | 2625732 | 2021-01-10 | Colombia | Sucre | 17907 | 685 | 16688 | 534 | 8.814 | -74.7233 | 2021-01-11 05:21:50 | Sucre, Colombia | ||
2625733 | 2625733 | 2021-01-10 | Colombia | Tolima | 49623 | 1419 | 45649 | 2555 | 4.0925 | -75.1545 | 2021-01-11 05:21:50 | Tolima, Colombia | ||
2625734 | 2625734 | 2021-01-10 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-01-11 05:21:50 | Unknown, Colombia | ||||
2625735 | 2625735 | 2021-01-10 | Colombia | Valle del Cauca | 146871 | 4591 | 135031 | 7249 | 3.8009 | -76.6413 | 2021-01-11 05:21:50 | Valle del Cauca, Colombia | ||
2625736 | 2625736 | 2021-01-10 | Colombia | Vaupes | 1142 | 13 | 1125 | 4 | 0.8554 | -70.812 | 2021-01-11 05:21:50 | Vaupes, Colombia | ||
2625737 | 2625737 | 2021-01-10 | Colombia | Vichada | 1168 | 15 | 1143 | 10 | 4.4234 | -69.2878 | 2021-01-11 05:21:50 | Vichada, Colombia | ||
2625738 | 2625738 | 2021-01-10 | Comoros | 1150 | 18 | 860 | 272 | -11.6455 | 43.3333 | 2021-01-11 05:21:50 | Comoros | |||
2625739 | 2625739 | 2021-01-10 | Congo (Brazzaville) | 7127 | 108 | 5846 | 1173 | -0.228 | 15.8277 | 2021-01-11 05:21:50 | Congo (Brazzaville) | |||
2625740 | 2625740 | 2021-01-10 | Congo (Kinshasa) | 19436 | 611 | 14743 | 4082 | -4.0383 | 21.7587 | 2021-01-11 05:21:50 | Congo (Kinshasa) | |||
2625741 | 2625741 | 2021-01-10 | Costa Rica | 177614 | 2305 | 136083 | 39226 | 9.7489 | -83.7534 | 2021-01-11 05:21:50 | Costa Rica | |||
2625742 | 2625742 | 2021-01-10 | Cote d'Ivoire | 23750 | 139 | 22570 | 1041 | 7.54 | -5.5471 | 2021-01-11 05:21:50 | Cote d'Ivoire | |||
2625743 | 2625743 | 2021-01-10 | Croatia | 219993 | 4368 | 210126 | 5499 | 45.1 | 15.2 | 2021-01-11 05:21:50 | Croatia | |||
2625744 | 2625744 | 2021-01-10 | Cuba | 14576 | 151 | 11863 | 2562 | 21.521757 | -77.78116700000002 | 2021-01-11 05:21:50 | Cuba | |||
2625745 | 2625745 | 2021-01-10 | Cyprus | 27468 | 148 | 2057 | 25263 | 35.1264 | 33.4299 | 2021-01-11 05:21:50 | Cyprus | |||
2625746 | 2625746 | 2021-01-10 | Czechia | 831165 | 13115 | 657504 | 160546 | 49.8175 | 15.473 | 2021-01-11 05:21:50 | Czechia | |||
2625747 | 2625747 | 2021-01-10 | Denmark | Faroe Islands | 646 | 1 | 607 | 38 | 61.8926 | -6.9118 | 2021-01-11 05:21:50 | Faroe Islands, Denmark | ||
2625748 | 2625748 | 2021-01-10 | Denmark | Greenland | 29 | 0 | 28 | 1 | 71.7069 | -42.6043 | 2021-01-11 05:21:50 | Greenland, Denmark | ||
2625749 | 2625749 | 2021-01-10 | Denmark | 181486 | 1570 | 153565 | 26351 | 56.2639 | 9.5018 | 2021-01-11 05:21:50 | Denmark | |||
2625750 | 2625750 | 2021-01-10 | Diamond Princess | 712 | 13 | 699 | 0 | 2021-01-11 05:21:50 | Diamond Princess | |||||
2625751 | 2625751 | 2021-01-10 | Djibouti | 5871 | 61 | 5780 | 30 | 11.8251 | 42.5903 | 2021-01-11 05:21:50 | Djibouti | |||
2625752 | 2625752 | 2021-01-10 | Dominica | 106 | 0 | 98 | 8 | 15.415 | -61.371 | 2021-01-11 05:21:50 | Dominica | |||
2625753 | 2625753 | 2021-01-10 | Dominican Republic | 182103 | 2427 | 138076 | 41600 | 18.7357 | -70.1627 | 2021-01-11 05:21:50 | Dominican Republic | |||
2625754 | 2625754 | 2021-01-10 | Ecuador | 221070 | 14177 | 190350 | 16543 | -1.8312 | -78.1834 | 2021-01-11 05:21:50 | Ecuador | |||
2625755 | 2625755 | 2021-01-10 | Egypt | 149792 | 8197 | 118900 | 22695 | 26.820553000000004 | 30.802498 | 2021-01-11 05:21:50 | Egypt | |||
2625756 | 2625756 | 2021-01-10 | El Salvador | 48905 | 1419 | 43356 | 4130 | 13.7942 | -88.8965 | 2021-01-11 05:21:50 | El Salvador | |||
2625757 | 2625757 | 2021-01-10 | Equatorial Guinea | 5289 | 86 | 5154 | 49 | 1.6508 | 10.2679 | 2021-01-11 05:21:50 | Equatorial Guinea | |||
2625758 | 2625758 | 2021-01-10 | Eritrea | 1556 | 6 | 740 | 810 | 15.1794 | 39.7823 | 2021-01-11 05:21:50 | Eritrea | |||
2625759 | 2625759 | 2021-01-10 | Estonia | 33516 | 283 | 22876 | 10357 | 58.5953 | 25.0136 | 2021-01-11 05:21:50 | Estonia |
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]);