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,740,150
- Russia 39,214
- Japan 23,351
- China 18,851
- India 17,178
- Colombia 16,175
- Mexico 15,846
- Ukraine 13,409
- Brazil 13,118
- Peru 12,433
- United Kingdom 10,781
- Italy 10,373
- Malaysia 10,234
- Sweden 9,933
- Spain 9,878
- Canada 8,675
- Germany 8,420
- Chile 8,283
- Netherlands 7,835
- France 6,320
- Australia 4,644
- Belgium 3,954
- Pakistan 3,339
- New Zealand 1,775
- Denmark 1,664
- Mainland China 1,517
- Antarctica 602
- Kiribati 602
- Korea, North 602
- Nauru 602
- Palau 602
- Summer Olympics 2020 602
- Thailand 602
- Tonga 602
- Tuvalu 602
- Winter Olympics 2022 602
- Singapore 601
- Vietnam 600
- Nepal 599
- Sri Lanka 597
- Cambodia 596
- Finland 595
- Philippines 595
- United Arab Emirates 595
- Egypt 579
- Iran 573
- Israel 572
- Lebanon 572
- Iraq 570
- Kuwait 569
- Oman 569
- Afghanistan 568
- Bahrain 568
- Croatia 568
- Switzerland 568
- Algeria 567
- Austria 567
- Georgia 567
- Greece 567
- North Macedonia 567
- Norway 567
- Romania 567
- Estonia 566
- San Marino 566
- Iceland 565
- Lithuania 565
- Nigeria 565
- Belarus 564
- Ireland 564
- Luxembourg 564
- Monaco 564
- Qatar 564
- Azerbaijan 563
- Dominican Republic 563
- Ecuador 563
- Armenia 562
- Indonesia 562
- Latvia 562
- Morocco 562
- Portugal 562
- Saudi Arabia 562
- Senegal 562
- Andorra 561
- Jordan 561
- Argentina 560
- Hungary 560
- Liechtenstein 560
- Poland 560
- Tunisia 560
- Slovenia 559
- South Africa 559
- Bosnia and Herzegovina 558
- Costa Rica 558
- Serbia 558
- Slovakia 558
- Togo 558
- Bhutan 557
- Cameroon 557
- Malta 557
- Maldives 556
- Paraguay 556
- Bangladesh 555
- Bulgaria 555
- Cyprus 555
- Moldova 555
- Albania 554
- Brunei 554
- Holy See 554
- Mongolia 554
- Panama 554
- Burkina Faso 553
- Congo (Kinshasa) 553
- Cote d'Ivoire 553
- Czechia 553
- Honduras 553
- Jamaica 553
- Korea, South 553
- Taiwan* 553
- Turkey 553
- Bolivia 552
- Cuba 552
- Guyana 552
- Ethiopia 551
- Guinea 551
- Kazakhstan 551
- Kenya 551
- Sudan 551
- Antigua and Barbuda 550
- Eswatini 550
- Gabon 550
- Ghana 550
- Guatemala 550
- Mauritania 550
- Namibia 550
- Rwanda 550
- Saint Lucia 550
- Saint Vincent and the Grenadines 550
- Seychelles 550
- Suriname 550
- Trinidad and Tobago 550
- Uruguay 550
- Venezuela 550
- Congo (Brazzaville) 549
- Equatorial Guinea 549
- Uzbekistan 549
- Central African Republic 548
- Liberia 548
- Somalia 548
- Tanzania 548
- Benin 547
- Montenegro 547
- Barbados 546
- Djibouti 546
- Kyrgyzstan 546
- Mauritius 546
- Zambia 546
- El Salvador 545
- Fiji 545
- Kosovo 545
- Nicaragua 545
- Chad 544
- Haiti 544
- Madagascar 544
- Niger 544
- Papua New Guinea 544
- Zimbabwe 544
- Angola 543
- Cabo Verde 543
- Eritrea 543
- Uganda 543
- Dominica 542
- Gambia 542
- Grenada 542
- Mozambique 542
- Samoa 542
- Syria 542
- Timor-Leste 542
- Bahamas 541
- Belize 540
- Laos 540
- Libya 540
- Diamond Princess 539
- Guinea-Bissau 539
- Mali 539
- Saint Kitts and Nevis 539
- West Bank and Gaza 538
- Burma 536
- MS Zaandam 536
- Botswana 533
- Sierra Leone 533
- Burundi 532
- Malawi 531
- South Sudan 528
- Sao Tome and Principe 527
- Yemen 523
- Comoros 503
- Tajikistan 503
- Lesotho 490
- Solomon Islands 338
- Marshall Islands 322
- Vanuatu 309
- Micronesia 237
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462579 | 2462579 | 2021-09-14 | Chile | Coquimbo | 48499 | 1017 | 0 | -29.959 | -71.3389 | 2021-09-15 03:22:37 | Coquimbo, Chile | |||
2462580 | 2462580 | 2021-09-14 | Chile | Los Lagos | 88688 | 1401 | 0 | -41.9198 | -72.1416 | 2021-09-15 03:22:37 | Los Lagos, Chile | |||
2462581 | 2462581 | 2021-09-14 | Chile | Los Rios | 49262 | 688 | 0 | -40.231 | -72.3311 | 2021-09-15 03:22:37 | Los Rios, Chile | |||
2462582 | 2462582 | 2021-09-14 | Chile | Magallanes | 29250 | 498 | 0 | -52.368 | -70.9863 | 2021-09-15 03:22:37 | Magallanes, Chile | |||
2462583 | 2462583 | 2021-09-14 | Chile | Maule | 101380 | 1774 | 0 | -35.5183 | -71.6885 | 2021-09-15 03:22:37 | Maule, Chile | |||
2462584 | 2462584 | 2021-09-14 | Chile | Metropolitana | 687353 | 19081 | 0 | -33.4376 | -70.6505 | 2021-09-15 03:22:37 | Metropolitana, Chile | |||
2462585 | 2462585 | 2021-09-14 | Chile | Nuble | 35877 | 641 | 0 | -36.7226 | -71.7622 | 2021-09-15 03:22:37 | Nuble, Chile | |||
2462586 | 2462586 | 2021-09-14 | Chile | OHiggins | 68493 | 1540 | 0 | -34.5755 | -71.0022 | 2021-09-15 03:22:37 | OHiggins, Chile | |||
2462587 | 2462587 | 2021-09-14 | Chile | Tarapaca | 41195 | 808 | 0 | -19.9232 | -69.5132 | 2021-09-15 03:22:37 | Tarapaca, Chile | |||
2462588 | 2462588 | 2021-09-14 | Chile | Unknown | 49 | 0 | 0 | 2021-09-15 03:22:37 | Unknown, Chile | |||||
2462589 | 2462589 | 2021-09-14 | Chile | Valparaiso | 122840 | 3450 | 0 | -33.0472 | -71.6127 | 2021-09-15 03:22:37 | Valparaiso, Chile | |||
2462590 | 2462590 | 2021-09-14 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-15 03:22:37 | Anhui, China | |||
2462591 | 2462591 | 2021-09-14 | China | Beijing | 1119 | 9 | 0 | 40.1824 | 116.4142 | 2021-09-15 03:22:37 | Beijing, China | |||
2462592 | 2462592 | 2021-09-14 | China | Chongqing | 603 | 6 | 0 | 30.0572 | 107.874 | 2021-09-15 03:22:37 | Chongqing, China | |||
2462593 | 2462593 | 2021-09-14 | China | Fujian | 957 | 1 | 0 | 26.0789 | 117.9874 | 2021-09-15 03:22:37 | Fujian, China | |||
2462594 | 2462594 | 2021-09-14 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-09-15 03:22:37 | Gansu, China | |||
2462595 | 2462595 | 2021-09-14 | China | Guangdong | 3132 | 8 | 0 | 23.3417 | 113.4244 | 2021-09-15 03:22:37 | Guangdong, China | |||
2462596 | 2462596 | 2021-09-14 | China | Guangxi | 292 | 2 | 0 | 23.8298 | 108.7881 | 2021-09-15 03:22:37 | Guangxi, China | |||
2462597 | 2462597 | 2021-09-14 | China | Guizhou | 147 | 2 | 0 | 26.8154 | 106.8748 | 2021-09-15 03:22:37 | Guizhou, China | |||
2462598 | 2462598 | 2021-09-14 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2021-09-15 03:22:37 | Hainan, China | |||
2462599 | 2462599 | 2021-09-14 | China | Hebei | 1317 | 7 | 0 | 37.8957 | 114.9042 | 2021-09-15 03:22:37 | Hebei, China | |||
2462600 | 2462600 | 2021-09-14 | China | Heilongjiang | 1616 | 13 | 0 | 47.861999999999995 | 127.7615 | 2021-09-15 03:22:37 | Heilongjiang, China | |||
2462601 | 2462601 | 2021-09-14 | China | Henan | 1537 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-09-15 03:22:37 | Henan, China | |||
2462602 | 2462602 | 2021-09-14 | China | Hong Kong | 12148 | 213 | 0 | 22.3 | 114.2 | 2021-09-15 03:22:37 | Hong Kong, China | |||
2462603 | 2462603 | 2021-09-14 | China | Hubei | 68292 | 4512 | 0 | 30.9756 | 112.2707 | 2021-09-15 03:22:37 | Hubei, China | |||
2462604 | 2462604 | 2021-09-14 | China | Hunan | 1181 | 4 | 0 | 27.6104 | 111.7088 | 2021-09-15 03:22:37 | Hunan, China | |||
2462605 | 2462605 | 2021-09-14 | China | Inner Mongolia | 416 | 1 | 0 | 44.0935 | 113.9448 | 2021-09-15 03:22:37 | Inner Mongolia, China | |||
2462606 | 2462606 | 2021-09-14 | China | Jiangsu | 1592 | 0 | 0 | 32.9711 | 119.455 | 2021-09-15 03:22:37 | Jiangsu, China | |||
2462607 | 2462607 | 2021-09-14 | China | Jiangxi | 937 | 1 | 0 | 27.614 | 115.7221 | 2021-09-15 03:22:37 | Jiangxi, China | |||
2462608 | 2462608 | 2021-09-14 | China | Jilin | 574 | 3 | 0 | 43.6661 | 126.1923 | 2021-09-15 03:22:37 | Jilin, China | |||
2462609 | 2462609 | 2021-09-14 | China | Liaoning | 449 | 2 | 0 | 41.2956 | 122.6085 | 2021-09-15 03:22:37 | Liaoning, China | |||
2462610 | 2462610 | 2021-09-14 | China | Macau | 63 | 0 | 0 | 22.1667 | 113.55 | 2021-09-15 03:22:37 | Macau, China | |||
2462611 | 2462611 | 2021-09-14 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-15 03:22:37 | Ningxia, China | |||
2462612 | 2462612 | 2021-09-14 | China | Qinghai | 18 | 0 | 0 | 35.7452 | 95.9956 | 2021-09-15 03:22:37 | Qinghai, China | |||
2462613 | 2462613 | 2021-09-14 | China | Shaanxi | 671 | 3 | 0 | 35.1917 | 108.8701 | 2021-09-15 03:22:37 | Shaanxi, China | |||
2462614 | 2462614 | 2021-09-14 | China | Shandong | 928 | 7 | 0 | 36.3427 | 118.1498 | 2021-09-15 03:22:37 | Shandong, China | |||
2462615 | 2462615 | 2021-09-14 | China | Shanghai | 2550 | 7 | 0 | 31.201999999999998 | 121.4491 | 2021-09-15 03:22:37 | Shanghai, China | |||
2462616 | 2462616 | 2021-09-14 | China | Shanxi | 260 | 0 | 0 | 37.5777 | 112.2922 | 2021-09-15 03:22:37 | Shanxi, China | |||
2462617 | 2462617 | 2021-09-14 | China | Sichuan | 1199 | 3 | 0 | 30.6171 | 102.7103 | 2021-09-15 03:22:37 | Sichuan, China | |||
2462618 | 2462618 | 2021-09-14 | China | Tianjin | 480 | 3 | 0 | 39.3054 | 117.323 | 2021-09-15 03:22:37 | Tianjin, China | |||
2462619 | 2462619 | 2021-09-14 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2021-09-15 03:22:37 | Tibet, China | |||
2462620 | 2462620 | 2021-09-14 | China | Unknown | 11100 | 0 | 0 | 2021-09-15 03:22:37 | Unknown, China | |||||
2462621 | 2462621 | 2021-09-14 | China | Xinjiang | 980 | 3 | 0 | 41.1129 | 85.2401 | 2021-09-15 03:22:37 | Xinjiang, China | |||
2462622 | 2462622 | 2021-09-14 | China | Yunnan | 1251 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-09-15 03:22:37 | Yunnan, China | |||
2462623 | 2462623 | 2021-09-14 | China | Zhejiang | 1440 | 1 | 0 | 29.1832 | 120.0934 | 2021-09-15 03:22:37 | Zhejiang, China | |||
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 | |||
2462658 | 2462658 | 2021-09-14 | Comoros | 4100 | 147 | 0 | -11.6455 | 43.3333 | 2021-09-15 03:22:37 | Comoros | ||||
2462659 | 2462659 | 2021-09-14 | Congo (Brazzaville) | 13701 | 183 | 0 | -0.228 | 15.8277 | 2021-09-15 03:22:37 | Congo (Brazzaville) | ||||
2462660 | 2462660 | 2021-09-14 | Congo (Kinshasa) | 56215 | 1068 | 0 | -4.0383 | 21.7587 | 2021-09-15 03:22:37 | Congo (Kinshasa) | ||||
2462661 | 2462661 | 2021-09-14 | Costa Rica | 496736 | 5851 | 0 | 9.7489 | -83.7534 | 2021-09-15 03:22:37 | Costa Rica | ||||
2462662 | 2462662 | 2021-09-14 | Cote d'Ivoire | 58226 | 534 | 0 | 7.54 | -5.5471 | 2021-09-15 03:22:37 | Cote d'Ivoire | ||||
2462663 | 2462663 | 2021-09-14 | Croatia | 385056 | 8456 | 0 | 45.1 | 15.2 | 2021-09-15 03:22:37 | Croatia | ||||
2462664 | 2462664 | 2021-09-14 | Cuba | 761060 | 6449 | 0 | 21.521757 | -77.78116700000002 | 2021-09-15 03:22:37 | Cuba | ||||
2462665 | 2462665 | 2021-09-14 | Cyprus | 118090 | 541 | 0 | 35.1264 | 33.4299 | 2021-09-15 03:22:37 | Cyprus | ||||
2462666 | 2462666 | 2021-09-14 | Czechia | 1683802 | 30416 | 0 | 49.8175 | 15.472999999999999 | 2021-09-15 03:22:37 | Czechia | ||||
2462667 | 2462667 | 2021-09-14 | Denmark | Faroe Islands | 1041 | 2 | 0 | 61.8926 | -6.9118 | 2021-09-15 03:22:37 | Faroe Islands, Denmark | |||
2462668 | 2462668 | 2021-09-14 | Denmark | Greenland | 409 | 0 | 0 | 71.7069 | -42.6043 | 2021-09-15 03:22:37 | Greenland, Denmark | |||
2462669 | 2462669 | 2021-09-14 | Denmark | 353061 | 2614 | 0 | 56.2639 | 9.5018 | 2021-09-15 03:22:37 | Denmark | ||||
2462670 | 2462670 | 2021-09-14 | Diamond Princess | 712 | 13 | 0 | 2021-09-15 03:22:37 | Diamond Princess | ||||||
2462671 | 2462671 | 2021-09-14 | Djibouti | 11897 | 157 | 0 | 11.8251 | 42.5903 | 2021-09-15 03:22:37 | Djibouti | ||||
2462672 | 2462672 | 2021-09-14 | Dominica | 2634 | 8 | 0 | 15.415 | -61.371 | 2021-09-15 03:22:37 | Dominica | ||||
2462673 | 2462673 | 2021-09-14 | Dominican Republic | 353887 | 4020 | 0 | 18.7357 | -70.1627 | 2021-09-15 03:22:37 | Dominican Republic | ||||
2462674 | 2462674 | 2021-09-14 | Ecuador | 505628 | 32491 | 0 | -1.8312 | -78.1834 | 2021-09-15 03:22:37 | Ecuador | ||||
2462675 | 2462675 | 2021-09-14 | Egypt | 293951 | 16895 | 0 | 26.820553000000004 | 30.802497999999996 | 2021-09-15 03:22:37 | Egypt | ||||
2462676 | 2462676 | 2021-09-14 | El Salvador | 99701 | 3043 | 0 | 13.7942 | -88.8965 | 2021-09-15 03:22:37 | El Salvador | ||||
2462677 | 2462677 | 2021-09-14 | Equatorial Guinea | 10498 | 131 | 0 | 1.6508 | 10.2679 | 2021-09-15 03:22:37 | Equatorial Guinea | ||||
2462678 | 2462678 | 2021-09-14 | Eritrea | 6661 | 40 | 0 | 15.1794 | 39.7823 | 2021-09-15 03:22:37 | 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]);