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 249
- US 1,438,666
- Russia 31,578
- Japan 18,843
- China 15,723
- India 13,774
- Colombia 13,047
- Mexico 12,810
- Ukraine 10,833
- Brazil 10,634
- Peru 10,041
- United Kingdom 9,033
- Malaysia 8,670
- Italy 8,441
- Spain 8,038
- Sweden 8,001
- Canada 7,203
- Germany 6,856
- Chile 6,719
- Netherlands 6,271
- France 5,216
- Australia 3,908
- Belgium 2,850
- Pakistan 2,695
- Mainland China 1,517
- New Zealand 1,499
- Denmark 1,388
- Antarctica 510
- Kiribati 510
- Korea, North 510
- Nauru 510
- Palau 510
- Summer Olympics 2020 510
- Thailand 510
- Tonga 510
- Tuvalu 510
- Winter Olympics 2022 510
- Singapore 509
- Vietnam 508
- Nepal 507
- Sri Lanka 505
- Cambodia 504
- Finland 503
- Philippines 503
- United Arab Emirates 503
- Egypt 487
- Iran 481
- Israel 480
- Lebanon 480
- Iraq 478
- Kuwait 477
- Oman 477
- Afghanistan 476
- Bahrain 476
- Croatia 476
- Switzerland 476
- Algeria 475
- Austria 475
- Georgia 475
- Greece 475
- North Macedonia 475
- Norway 475
- Romania 475
- Estonia 474
- San Marino 474
- Iceland 473
- Lithuania 473
- Nigeria 473
- Belarus 472
- Ireland 472
- Luxembourg 472
- Monaco 472
- Qatar 472
- Azerbaijan 471
- Dominican Republic 471
- Ecuador 471
- Armenia 470
- Indonesia 470
- Latvia 470
- Morocco 470
- Portugal 470
- Saudi Arabia 470
- Senegal 470
- Andorra 469
- Jordan 469
- Argentina 468
- Hungary 468
- Liechtenstein 468
- Poland 468
- Tunisia 468
- Slovenia 467
- South Africa 467
- Bosnia and Herzegovina 466
- Costa Rica 466
- Serbia 466
- Slovakia 466
- Togo 466
- Bhutan 465
- Cameroon 465
- Malta 465
- Maldives 464
- Paraguay 464
- Bangladesh 463
- Bulgaria 463
- Cyprus 463
- Moldova 463
- Albania 462
- Brunei 462
- Holy See 462
- Mongolia 462
- Panama 462
- Burkina Faso 461
- Congo (Kinshasa) 461
- Cote d'Ivoire 461
- Czechia 461
- Honduras 461
- Jamaica 461
- Korea, South 461
- Taiwan* 461
- Turkey 461
- Bolivia 460
- Cuba 460
- Guyana 460
- Ethiopia 459
- Guinea 459
- Kazakhstan 459
- Kenya 459
- Sudan 459
- Antigua and Barbuda 458
- Eswatini 458
- Gabon 458
- Ghana 458
- Guatemala 458
- Mauritania 458
- Namibia 458
- Rwanda 458
- Saint Lucia 458
- Saint Vincent and the Grenadines 458
- Seychelles 458
- Suriname 458
- Trinidad and Tobago 458
- Uruguay 458
- Venezuela 458
- Congo (Brazzaville) 457
- Equatorial Guinea 457
- Uzbekistan 457
- Central African Republic 456
- Liberia 456
- Somalia 456
- Tanzania 456
- Benin 455
- Montenegro 455
- Barbados 454
- Djibouti 454
- Kyrgyzstan 454
- Mauritius 454
- Zambia 454
- El Salvador 453
- Fiji 453
- Kosovo 453
- Nicaragua 453
- Chad 452
- Haiti 452
- Madagascar 452
- Niger 452
- Papua New Guinea 452
- Zimbabwe 452
- Angola 451
- Cabo Verde 451
- Eritrea 451
- Uganda 451
- Dominica 450
- Gambia 450
- Grenada 450
- Mozambique 450
- Samoa 450
- Syria 450
- Timor-Leste 450
- Bahamas 449
- Belize 448
- Laos 448
- Libya 448
- Diamond Princess 447
- Guinea-Bissau 447
- Mali 447
- Saint Kitts and Nevis 447
- West Bank and Gaza 446
- Burma 444
- MS Zaandam 444
- Botswana 441
- Sierra Leone 441
- Burundi 440
- Malawi 439
- South Sudan 436
- Sao Tome and Principe 435
- Yemen 431
- Comoros 411
- Tajikistan 411
- Lesotho 398
- Solomon Islands 246
- Marshall Islands 230
- Vanuatu 217
- Micronesia 145
- Hong Kong 48
- Macau 48
- South Korea 48
- Taiwan 48
- Others 33
- Martinique 15
- French Guiana 14
- Cruise Ship 13
- Reunion 11
- Czech Republic 10
- Guadeloupe 9
- Guernsey 8
- Jersey 8
- Aruba 7
- Faroe Islands 7
- Gibraltar 7
- Saint Barthelemy 7
- occupied Palestinian territory 7
- Greenland 6
- Guam 6
- Mayotte 6
- Puerto Rico 6
- Republic of the Congo 6
- The Bahamas 6
- Palestine 5
- The Gambia 5
- Gambia, The 4
- Vatican City 4
- Bahamas, The 3
- Cayman Islands 3
- Curacao 2
- Cape Verde 1
- Channel Islands 1
- East Timor 1
- Hong Kong SAR 1
- Iran (Islamic Republic of) 1
- Ivory Coast 1
- Macao SAR 1
- North Ireland 1
- Republic of Ireland 1
- Republic of Korea 1
- Republic of Moldova 1
- Russian Federation 1
- Saint Martin 1
- St. Martin 1
- Taipei and environs 1
- Viet Nam 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1563879 | 1563879 | 2021-06-14 | Chile | Coquimbo | 41547 | 750 | 39139 | 1658 | -29.959 | -71.3389 | 2021-06-15 04:22:22 | Coquimbo, Chile | ||
1563880 | 1563880 | 2021-06-14 | Chile | Los Lagos | 81602 | 1122 | 78828 | 1652 | -41.9198 | -72.1416 | 2021-06-15 04:22:22 | Los Lagos, Chile | ||
1563881 | 1563881 | 2021-06-14 | Chile | Los Rios | 42289 | 488 | 40184 | 1617 | -40.231 | -72.3311 | 2021-06-15 04:22:22 | Los Rios, Chile | ||
1563882 | 1563882 | 2021-06-14 | Chile | Magallanes | 28381 | 429 | 27700 | 252 | -52.368 | -70.9863 | 2021-06-15 04:22:22 | Magallanes, Chile | ||
1563883 | 1563883 | 2021-06-14 | Chile | Maule | 90973 | 1441 | 86497 | 3035 | -35.5183 | -71.6885 | 2021-06-15 04:22:22 | Maule, Chile | ||
1563884 | 1563884 | 2021-06-14 | Chile | Metropolitana | 622863 | 16143 | 585897 | 20823 | -33.4376 | -70.6505 | 2021-06-15 04:22:22 | Metropolitana, Chile | ||
1563885 | 1563885 | 2021-06-14 | Chile | Nuble | 32489 | 536 | 30903 | 1050 | -36.7226 | -71.7622 | 2021-06-15 04:22:22 | Nuble, Chile | ||
1563886 | 1563886 | 2021-06-14 | Chile | OHiggins | 62146 | 1248 | 58668 | 2230 | -34.5755 | -71.0022 | 2021-06-15 04:22:22 | OHiggins, Chile | ||
1563887 | 1563887 | 2021-06-14 | Chile | Tarapaca | 37960 | 705 | 36703 | 552 | -19.9232 | -69.5132 | 2021-06-15 04:22:22 | Tarapaca, Chile | ||
1563888 | 1563888 | 2021-06-14 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-06-15 04:22:22 | Unknown, Chile | ||||
1563889 | 1563889 | 2021-06-14 | Chile | Valparaiso | 107182 | 2750 | 100539 | 3893 | -33.0472 | -71.6127 | 2021-06-15 04:22:22 | Valparaiso, Chile | ||
1563890 | 1563890 | 2021-06-14 | China | Anhui | 1004 | 6 | 998 | 0 | 31.8257 | 117.2264 | 2021-06-15 04:22:22 | Anhui, China | ||
1563891 | 1563891 | 2021-06-14 | China | Beijing | 1071 | 9 | 1048 | 14 | 40.1824 | 116.4142 | 2021-06-15 04:22:22 | Beijing, China | ||
1563892 | 1563892 | 2021-06-14 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-15 04:22:22 | Chongqing, China | ||
1563893 | 1563893 | 2021-06-14 | China | Fujian | 638 | 1 | 602 | 35 | 26.0789 | 117.9874 | 2021-06-15 04:22:22 | Fujian, China | ||
1563894 | 1563894 | 2021-06-14 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-15 04:22:22 | Gansu, China | ||
1563895 | 1563895 | 2021-06-14 | China | Guangdong | 2635 | 8 | 2425 | 202 | 23.3417 | 113.4244 | 2021-06-15 04:22:22 | Guangdong, China | ||
1563896 | 1563896 | 2021-06-14 | China | Guangxi | 275 | 2 | 270 | 3 | 23.8298 | 108.7881 | 2021-06-15 04:22:22 | Guangxi, China | ||
1563897 | 1563897 | 2021-06-14 | China | Guizhou | 147 | 2 | 145 | 0 | 26.8154 | 106.8748 | 2021-06-15 04:22:22 | Guizhou, China | ||
1563898 | 1563898 | 2021-06-14 | China | Hainan | 188 | 6 | 181 | 1 | 19.1959 | 109.7453 | 2021-06-15 04:22:22 | Hainan, China | ||
1563899 | 1563899 | 2021-06-14 | China | Hebei | 1317 | 7 | 1310 | 0 | 37.8957 | 114.9042 | 2021-06-15 04:22:22 | Hebei, China | ||
1563900 | 1563900 | 2021-06-14 | China | Heilongjiang | 1612 | 13 | 1599 | 0 | 47.862 | 127.7615 | 2021-06-15 04:22:22 | Heilongjiang, China | ||
1563901 | 1563901 | 2021-06-14 | China | Henan | 1316 | 22 | 1291 | 3 | 33.882 | 113.614 | 2021-06-15 04:22:22 | Henan, China | ||
1563902 | 1563902 | 2021-06-14 | China | Hong Kong | 11878 | 210 | 11600 | 68 | 22.3 | 114.2 | 2021-06-15 04:22:22 | Hong Kong, China | ||
1563903 | 1563903 | 2021-06-14 | China | Hubei | 68159 | 4512 | 63647 | 0 | 30.9756 | 112.2707 | 2021-06-15 04:22:22 | Hubei, China | ||
1563904 | 1563904 | 2021-06-14 | China | Hunan | 1051 | 4 | 1045 | 2 | 27.6104 | 111.7088 | 2021-06-15 04:22:22 | Hunan, China | ||
1563905 | 1563905 | 2021-06-14 | China | Inner Mongolia | 393 | 1 | 385 | 7 | 44.0935 | 113.9448 | 2021-06-15 04:22:22 | Inner Mongolia, China | ||
1563906 | 1563906 | 2021-06-14 | China | Jiangsu | 736 | 0 | 721 | 15 | 32.9711 | 119.455 | 2021-06-15 04:22:22 | Jiangsu, China | ||
1563907 | 1563907 | 2021-06-14 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2021-06-15 04:22:22 | Jiangxi, China | ||
1563908 | 1563908 | 2021-06-14 | China | Jilin | 573 | 3 | 570 | 0 | 43.6661 | 126.1923 | 2021-06-15 04:22:22 | Jilin, China | ||
1563909 | 1563909 | 2021-06-14 | China | Liaoning | 426 | 2 | 421 | 3 | 41.2956 | 122.6085 | 2021-06-15 04:22:22 | Liaoning, China | ||
1563910 | 1563910 | 2021-06-14 | China | Macau | 52 | 0 | 51 | 1 | 22.1667 | 113.55 | 2021-06-15 04:22:22 | Macau, China | ||
1563911 | 1563911 | 2021-06-14 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-15 04:22:22 | Ningxia, China | ||
1563912 | 1563912 | 2021-06-14 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2021-06-15 04:22:22 | Qinghai, China | ||
1563913 | 1563913 | 2021-06-14 | China | Shaanxi | 622 | 3 | 602 | 17 | 35.1917 | 108.8701 | 2021-06-15 04:22:22 | Shaanxi, China | ||
1563914 | 1563914 | 2021-06-14 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-15 04:22:22 | Shandong, China | ||
1563915 | 1563915 | 2021-06-14 | China | Shanghai | 2165 | 7 | 2082 | 76 | 31.202 | 121.4491 | 2021-06-15 04:22:22 | Shanghai, China | ||
1563916 | 1563916 | 2021-06-14 | China | Shanxi | 253 | 0 | 252 | 1 | 37.5777 | 112.2922 | 2021-06-15 04:22:22 | Shanxi, China | ||
1563917 | 1563917 | 2021-06-14 | China | Sichuan | 1055 | 3 | 1019 | 33 | 30.6171 | 102.7103 | 2021-06-15 04:22:22 | Sichuan, China | ||
1563918 | 1563918 | 2021-06-14 | China | Tianjin | 398 | 3 | 385 | 10 | 39.3054 | 117.323 | 2021-06-15 04:22:22 | Tianjin, China | ||
1563919 | 1563919 | 2021-06-14 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2021-06-15 04:22:22 | Tibet, China | ||
1563920 | 1563920 | 2021-06-14 | China | Unknown | 9495 | 0 | 6 | 0 | 2021-06-15 04:22:22 | Unknown, China | ||||
1563921 | 1563921 | 2021-06-14 | China | Xinjiang | 980 | 3 | 977 | 0 | 41.1129 | 85.2401 | 2021-06-15 04:22:22 | Xinjiang, China | ||
1563922 | 1563922 | 2021-06-14 | China | Yunnan | 377 | 2 | 348 | 27 | 24.974 | 101.487 | 2021-06-15 04:22:22 | Yunnan, China | ||
1563923 | 1563923 | 2021-06-14 | China | Zhejiang | 1373 | 1 | 1337 | 35 | 29.1832 | 120.0934 | 2021-06-15 04:22:22 | Zhejiang, China | ||
1563924 | 1563924 | 2021-06-14 | Colombia | Amazonas | 6366 | 242 | 6087 | 37 | -1.4429 | -71.5724 | 2021-06-15 04:22:22 | Amazonas, Colombia | ||
1563925 | 1563925 | 2021-06-14 | Colombia | Antioquia | 578317 | 12811 | 547269 | 18237 | 7.1986 | -75.3412 | 2021-06-15 04:22:22 | Antioquia, Colombia | ||
1563926 | 1563926 | 2021-06-14 | Colombia | Arauca | 8858 | 265 | 8310 | 283 | 7.0762 | -70.7105 | 2021-06-15 04:22:22 | Arauca, Colombia | ||
1563927 | 1563927 | 2021-06-14 | Colombia | Atlantico | 280382 | 8730 | 268865 | 2787 | 10.6966 | -74.8741 | 2021-06-15 04:22:22 | Atlantico, Colombia | ||
1563928 | 1563928 | 2021-06-14 | Colombia | Bolivar | 115359 | 2234 | 112362 | 763 | 8.6704 | -74.03 | 2021-06-15 04:22:22 | Bolivar, Colombia | ||
1563929 | 1563929 | 2021-06-14 | Colombia | Boyaca | 75662 | 1777 | 71678 | 2207 | 5.4545 | -73.362 | 2021-06-15 04:22:22 | Boyaca, Colombia | ||
1563930 | 1563930 | 2021-06-14 | Colombia | Caldas | 78296 | 1620 | 74839 | 1837 | 5.2983 | -75.2479 | 2021-06-15 04:22:22 | Caldas, Colombia | ||
1563931 | 1563931 | 2021-06-14 | Colombia | Capital District | 1079120 | 20831 | 996172 | 62117 | 4.711 | -74.0721 | 2021-06-15 04:22:22 | Capital District, Colombia | ||
1563932 | 1563932 | 2021-06-14 | Colombia | Caqueta | 18815 | 700 | 17874 | 241 | 0.8699 | -73.8419 | 2021-06-15 04:22:22 | Caqueta, Colombia | ||
1563933 | 1563933 | 2021-06-14 | Colombia | Casanare | 24409 | 588 | 22861 | 960 | 5.7589 | -71.5724 | 2021-06-15 04:22:22 | Casanare, Colombia | ||
1563934 | 1563934 | 2021-06-14 | Colombia | Cauca | 36490 | 998 | 34645 | 847 | 2.705 | -76.82600000000002 | 2021-06-15 04:22:22 | Cauca, Colombia | ||
1563935 | 1563935 | 2021-06-14 | Colombia | Cesar | 73417 | 2018 | 70086 | 1313 | 9.3373 | -73.6536 | 2021-06-15 04:22:22 | Cesar, Colombia | ||
1563936 | 1563936 | 2021-06-14 | Colombia | Choco | 12791 | 317 | 12240 | 234 | 5.2528 | -76.82600000000002 | 2021-06-15 04:22:22 | Choco, Colombia | ||
1563937 | 1563937 | 2021-06-14 | Colombia | Cordoba | 69241 | 2705 | 64862 | 1674 | 8.0493 | -75.574 | 2021-06-15 04:22:22 | Cordoba, Colombia | ||
1563938 | 1563938 | 2021-06-14 | Colombia | Cundinamarca | 188243 | 4984 | 179642 | 3617 | 5.026 | -74.03 | 2021-06-15 04:22:22 | Cundinamarca, Colombia | ||
1563939 | 1563939 | 2021-06-14 | Colombia | Guainia | 1899 | 22 | 1863 | 14 | 2.5854 | -68.5247 | 2021-06-15 04:22:22 | Guainia, Colombia | ||
1563940 | 1563940 | 2021-06-14 | Colombia | Guaviare | 3546 | 60 | 3451 | 35 | 1.0654 | -73.2603 | 2021-06-15 04:22:22 | Guaviare, Colombia | ||
1563941 | 1563941 | 2021-06-14 | Colombia | Huila | 63204 | 2178 | 59592 | 1434 | 2.5359 | -75.5277 | 2021-06-15 04:22:22 | Huila, Colombia | ||
1563942 | 1563942 | 2021-06-14 | Colombia | La Guajira | 37707 | 1194 | 36312 | 201 | 11.3548 | -72.5205 | 2021-06-15 04:22:22 | La Guajira, Colombia | ||
1563943 | 1563943 | 2021-06-14 | Colombia | Magdalena | 74450 | 2802 | 70566 | 1082 | 10.4113 | -74.4057 | 2021-06-15 04:22:22 | Magdalena, Colombia | ||
1563944 | 1563944 | 2021-06-14 | Colombia | Meta | 59565 | 1406 | 57235 | 924 | 3.272 | -73.0877 | 2021-06-15 04:22:22 | Meta, Colombia | ||
1563945 | 1563945 | 2021-06-14 | Colombia | Narino | 69364 | 2332 | 65079 | 1953 | 1.2892 | -77.3579 | 2021-06-15 04:22:22 | Narino, Colombia | ||
1563946 | 1563946 | 2021-06-14 | Colombia | Norte de Santander | 66312 | 3248 | 61518 | 1546 | 7.9463 | -72.8988 | 2021-06-15 04:22:22 | Norte de Santander, Colombia | ||
1563947 | 1563947 | 2021-06-14 | Colombia | Putumayo | 12576 | 530 | 11769 | 277 | 0.436 | -75.5277 | 2021-06-15 04:22:22 | Putumayo, Colombia | ||
1563948 | 1563948 | 2021-06-14 | Colombia | Quindio | 45650 | 1376 | 43829 | 445 | 4.461 | -75.6674 | 2021-06-15 04:22:22 | Quindio, Colombia | ||
1563949 | 1563949 | 2021-06-14 | Colombia | Risaralda | 67060 | 1667 | 64038 | 1355 | 5.3158 | -75.9928 | 2021-06-15 04:22:22 | Risaralda, Colombia | ||
1563950 | 1563950 | 2021-06-14 | Colombia | San Andres y Providencia | 5982 | 118 | 5790 | 74 | 12.5567 | -81.7185 | 2021-06-15 04:22:22 | San Andres y Providencia, Colombia | ||
1563951 | 1563951 | 2021-06-14 | Colombia | Santander | 157266 | 5174 | 147376 | 4716 | 6.6437 | -73.6536 | 2021-06-15 04:22:22 | Santander, Colombia | ||
1563952 | 1563952 | 2021-06-14 | Colombia | Sucre | 40754 | 1247 | 38656 | 851 | 8.814 | -74.7233 | 2021-06-15 04:22:22 | Sucre, Colombia | ||
1563953 | 1563953 | 2021-06-14 | Colombia | Tolima | 80676 | 2628 | 77161 | 887 | 4.0925 | -75.1545 | 2021-06-15 04:22:22 | Tolima, Colombia | ||
1563954 | 1563954 | 2021-06-14 | Colombia | Unknown | 52895 | 293 | 1 | 52601 | 2021-06-15 04:22:22 | Unknown, Colombia | ||||
1563955 | 1563955 | 2021-06-14 | Colombia | Valle del Cauca | 289148 | 9224 | 275024 | 4900 | 3.8009 | -76.6413 | 2021-06-15 04:22:22 | Valle del Cauca, Colombia | ||
1563956 | 1563956 | 2021-06-14 | Colombia | Vaupes | 1620 | 14 | 1585 | 21 | 0.8554 | -70.812 | 2021-06-15 04:22:22 | Vaupes, Colombia | ||
1563957 | 1563957 | 2021-06-14 | Colombia | Vichada | 2160 | 33 | 2072 | 55 | 4.4234 | -69.2878 | 2021-06-15 04:22:22 | Vichada, Colombia | ||
1563958 | 1563958 | 2021-06-14 | Comoros | 3901 | 146 | 3738 | 17 | -11.6455 | 43.3333 | 2021-06-15 04:22:22 | Comoros | |||
1563959 | 1563959 | 2021-06-14 | Congo (Brazzaville) | 12121 | 160 | 11211 | 750 | -0.228 | 15.8277 | 2021-06-15 04:22:22 | Congo (Brazzaville) | |||
1563960 | 1563960 | 2021-06-14 | Congo (Kinshasa) | 35668 | 846 | 27849 | 6973 | -4.0383 | 21.7587 | 2021-06-15 04:22:22 | Congo (Kinshasa) | |||
1563961 | 1563961 | 2021-06-14 | Costa Rica | 343604 | 4388 | 262852 | 76364 | 9.7489 | -83.7534 | 2021-06-15 04:22:22 | Costa Rica | |||
1563962 | 1563962 | 2021-06-14 | Cote d'Ivoire | 47760 | 306 | 47239 | 215 | 7.54 | -5.5471 | 2021-06-15 04:22:22 | Cote d'Ivoire | |||
1563963 | 1563963 | 2021-06-14 | Croatia | 358581 | 8152 | 349582 | 847 | 45.1 | 15.2 | 2021-06-15 04:22:22 | Croatia | |||
1563964 | 1563964 | 2021-06-14 | Cuba | 159057 | 1098 | 150855 | 7104 | 21.521757 | -77.78116700000002 | 2021-06-15 04:22:22 | Cuba | |||
1563965 | 1563965 | 2021-06-14 | Cyprus | 74311 | 374 | 39061 | 34876 | 35.1264 | 33.4299 | 2021-06-15 04:22:22 | Cyprus | |||
1563966 | 1563966 | 2021-06-14 | Czechia | 1665138 | 30229 | 1630452 | 4457 | 49.8175 | 15.473 | 2021-06-15 04:22:22 | Czechia | |||
1563967 | 1563967 | 2021-06-14 | Denmark | Faroe Islands | 757 | 1 | 727 | 29 | 61.8926 | -6.9118 | 2021-06-15 04:22:22 | Faroe Islands, Denmark | ||
1563968 | 1563968 | 2021-06-14 | Denmark | Greenland | 44 | 0 | 40 | 4 | 71.7069 | -42.6043 | 2021-06-15 04:22:22 | Greenland, Denmark | ||
1563969 | 1563969 | 2021-06-14 | Denmark | 290111 | 2526 | 279072 | 8513 | 56.2639 | 9.5018 | 2021-06-15 04:22:22 | Denmark | |||
1563970 | 1563970 | 2021-06-14 | Diamond Princess | 712 | 13 | 699 | 0 | 2021-06-15 04:22:22 | Diamond Princess | |||||
1563971 | 1563971 | 2021-06-14 | Djibouti | 11575 | 154 | 11405 | 16 | 11.8251 | 42.5903 | 2021-06-15 04:22:22 | Djibouti | |||
1563972 | 1563972 | 2021-06-14 | Dominica | 189 | 0 | 188 | 1 | 15.415 | -61.371 | 2021-06-15 04:22:22 | Dominica | |||
1563973 | 1563973 | 2021-06-14 | Dominican Republic | 309477 | 3708 | 252803 | 52966 | 18.7357 | -70.1627 | 2021-06-15 04:22:22 | Dominican Republic | |||
1563974 | 1563974 | 2021-06-14 | Ecuador | 439139 | 21051 | 398645 | 19443 | -1.8312 | -78.1834 | 2021-06-15 04:22:22 | Ecuador | |||
1563975 | 1563975 | 2021-06-14 | Egypt | 273795 | 15654 | 201739 | 56402 | 26.820553000000004 | 30.802498 | 2021-06-15 04:22:22 | Egypt | |||
1563976 | 1563976 | 2021-06-14 | El Salvador | 75351 | 2299 | 70150 | 2902 | 13.7942 | -88.8965 | 2021-06-15 04:22:22 | El Salvador | |||
1563977 | 1563977 | 2021-06-14 | Equatorial Guinea | 8662 | 120 | 8413 | 129 | 1.6508 | 10.2679 | 2021-06-15 04:22:22 | Equatorial Guinea | |||
1563978 | 1563978 | 2021-06-14 | Eritrea | 4981 | 16 | 4420 | 545 | 15.1794 | 39.7823 | 2021-06-15 04:22:22 | 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]);