Data license: ODbL · Data source: our world in data github owid/covid-19-data repository

4 rows where Faeroe Islands = 5

View and edit SQL

Suggested facets: Andorra, Antigua and Barbuda, Barbados, Benin, Bhutan, Bonaire Sint Eustatius and Saba, Cambodia, Cameroon, Cape Verde, Central African Republic, Chad, Congo, Curacao, Djibouti, Equatorial Guinea, French Polynesia, Ghana, Guam, Guinea, Jersey, Kosovo, Lesotho, Liechtenstein, Macedonia, Mali, Mauritius, Monaco, New Zealand, Nicaragua, Niger, Northern Mariana Islands, Oman, Papua New Guinea, Saint Vincent and the Grenadines, San Marino, Sao Tome and Principe, Sint Maarten (Dutch part), Somalia, South Sudan, Sudan, Suriname, Thailand, Togo, Tunisia, Turks and Caicos Islands, Uruguay, Yemen, date (date)

Link rowid ▼ date World Afghanistan Albania Algeria Andorra Angola Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Bahamas Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bonaire Sint Eustatius and Saba Bosnia and Herzegovina Botswana Brazil British Virgin Islands Brunei Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Cayman Islands Central African Republic Chad Chile China Colombia Comoros Congo Costa Rica Cote d'Ivoire Croatia Cuba Curacao Cyprus Czech Republic Democratic Republic of Congo Denmark Djibouti Dominica Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Faeroe Islands Falkland Islands Fiji Finland France French Polynesia Gabon Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Honduras Hungary Iceland India Indonesia International Iran Iraq Ireland Isle of Man Israel Italy Jamaica Japan Jersey Jordan Kazakhstan Kenya Kosovo Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Mauritania Mauritius Mexico Moldova Monaco Mongolia Montenegro Montserrat Morocco Mozambique Myanmar Namibia Nepal Netherlands New Caledonia New Zealand Nicaragua Niger Nigeria Northern Mariana Islands Norway Oman Pakistan Palestine Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Puerto Rico Qatar Romania Russia Rwanda Saint Kitts and Nevis Saint Lucia Saint Vincent and the Grenadines San Marino Sao Tome and Principe Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Sint Maarten (Dutch part) Slovakia Slovenia Solomon Islands Somalia South Africa South Korea South Sudan Spain Sri Lanka Sudan Suriname Swaziland Sweden Switzerland Syria Taiwan Tajikistan Tanzania Thailand Timor Togo Trinidad and Tobago Tunisia Turkey Turks and Caicos Islands Uganda Ukraine United Arab Emirates United Kingdom United States United States Virgin Islands Uruguay Uzbekistan Vatican Venezuela Vietnam Wallis and Futuna Western Sahara Yemen Zambia Zimbabwe
215 2020-08-01 277264 168 79 563 3 31 0 0 6377 291 1 602 89 318 66 227 2772 0 143 684 0 35 0 0 1555 0 0 0 52383 0 0 270 26 4 5 0 513 78 0 3 1 2131 166 9488 4 0 530 69 67 11 0 30 232 60 64 0 0 1734 985 321 402 0 0 13 915 5 0 0 9 1346 0 0 95 8 955 359 0 76 0 0 3 963 0 66 0 12 12 976 0 13 57118 2040   2674 3346 38 0 591 379 0 598 0 2 1289 723 226 428 494 0 3 221 0 5 0 0 13 79 139 120 97 12 74 13 9   25 0 6660 786 0 0 39 0 1063 56 0 77 224 338 0 2 0 0 462 0 36 0 0 394 1065 0 131 7243 3980 657 204 209 235 1295 5482 28 0 0 2 0 1 1686 126 339 0 0 396 0 27 26   0 11014 31 0 0 1 148 56 71 258 137 0 7 43 0 2 0 14 5 21 982 3 7 1090 0 880 67023 21 21 746 0 715 49   0 2 408 77
259 2020-09-14 269943 75 168 247 0 56 0 0 10778 187 52 44 384 155 0 747 1476 1 198 301 22 25 0 1 809 1 328 0 14768 0 0 27 193 1 0 158 518 102 0 0 1 2082 29 7355 0 6 0 26 165 31 12 3 787 5 0 1 0 568 2143 153 81 0 0 21 413 5 0 0 23 7183 0 0 29 317 927 0 3 204 0 0 0 251 0 0 0 41 15 653 484 3 92071 3625   2089 3531 255 0 3379 1456 148 439 0 252 129 188 71 553 47 0 10 641 0 3 433 2 39 35 139 20 12 47 121 8 78   10 5 1803 264 2 0 182 0 2251 229 219 115 1039 1086 0 1 0 2 79 0 0 1409 539 994 704 1 493 6787 3353 502 673 288 217 1109 5449 26 0 0 0 0 0 601 43 108 0 13 49 16 79 99   13 1579 109 0 27404 38 0 3 25 106 473 34 0 35 0 2 0 17 49 0 1527 2 96 2476 640 3330 33871 0 28 578 0 910 3   0 2 73 18
261 2020-09-16 303523 40 152 238 0 51 0 0 9908 150 92 46 860 114 24 658 1724 1 192 1628 27 0 0 0 667 1 294 0 36653 0 0 155 16 0 0 43 793 65 0 0 2 1550 24 6698 1 0 787 34 151 77 12 6 1674 12 329 0 0 693 642 163 75 0 0 24 700 5 0 0 98 7852 72 0 23 366 1901 54 4 310 0 0 0 512 0 50 0 74 31 0 1307 6 90123 3507   2705 4224 357 0 6426 1229 109 490 0 149 472 48 71 829 144 0 5 592 0 6 629 0 56 40 134 34 4 23 85 5 49   24 1 4098 527 1 0 161 0 2121 231 337 83 1459 1376 0 1 143 0 90 0 122 438 665 1115 628 0 931 4160 3519 605 425 422 239 1111 5529 22 0 0 0 1 1 672 223 74 0 17 34 0 188 82   0 772 113 5 11193 9 0 14 24 292 315 38 1 41 0 10 0 17 82 241 1742 2 324 5863 674 3103 51473 11 15 584 0 1086 0   0 3 99 45
277 2020-10-02 323170 17 157 160 0 0 0 5 14001 491 35 33 564 80 97 510 1508 3 388 3407 34 0 0 0 405 0 280 0 36157 0 0 263 32 2 0 0 1777 102 0 0 3 1759 39 5660 5 0 1068 31 234 73 7 17 5336 25 398 1 0 519 1537 119 98 15 0 79 730 5 0 0 111 13970 124 0 5 453 2673 0 14 411 0 0 107 663 0 0 0 35 0 698 1322 41 81484 4174   3825 4493 442 0 7638 2548 93 1205 5 1276 298 184 43 494 215 0 44 1248 44 0 683 0 91 86 161 46 6 349 63 13 37   14 0 4955 1022 1 0 215 0 2391 160 1010 108 1911 3253 0 12 0 0 153 3 113 0 625 521 747 5 1041 3468 4776 1967 854 312 199 2086 8945 3 0 0 0 0 0 492 37 111 0 7 42 1 797 175   5 1745 140 0 11325 2 13 14 18 633 550 47 3 42 0 6 0 25 39 0 1407 1 158 0 1158 6914 44771 3 15 457 0 907 1   0 3 43 12

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "new_cases" (
"date" TEXT,
  "World" INTEGER,
  "Afghanistan" INTEGER,
  "Albania" INTEGER,
  "Algeria" INTEGER,
  "Andorra" INTEGER,
  "Angola" INTEGER,
  "Anguilla" INTEGER,
  "Antigua and Barbuda" INTEGER,
  "Argentina" INTEGER,
  "Armenia" INTEGER,
  "Aruba" INTEGER,
  "Australia" INTEGER,
  "Austria" INTEGER,
  "Azerbaijan" INTEGER,
  "Bahamas" INTEGER,
  "Bahrain" INTEGER,
  "Bangladesh" INTEGER,
  "Barbados" INTEGER,
  "Belarus" INTEGER,
  "Belgium" INTEGER,
  "Belize" INTEGER,
  "Benin" INTEGER,
  "Bermuda" INTEGER,
  "Bhutan" INTEGER,
  "Bolivia" INTEGER,
  "Bonaire Sint Eustatius and Saba" INTEGER,
  "Bosnia and Herzegovina" INTEGER,
  "Botswana" INTEGER,
  "Brazil" INTEGER,
  "British Virgin Islands" INTEGER,
  "Brunei" INTEGER,
  "Bulgaria" INTEGER,
  "Burkina Faso" INTEGER,
  "Burundi" INTEGER,
  "Cambodia" INTEGER,
  "Cameroon" INTEGER,
  "Canada" INTEGER,
  "Cape Verde" INTEGER,
  "Cayman Islands" INTEGER,
  "Central African Republic" INTEGER,
  "Chad" INTEGER,
  "Chile" INTEGER,
  "China" INTEGER,
  "Colombia" INTEGER,
  "Comoros" INTEGER,
  "Congo" INTEGER,
  "Costa Rica" INTEGER,
  "Cote d'Ivoire" INTEGER,
  "Croatia" INTEGER,
  "Cuba" INTEGER,
  "Curacao" INTEGER,
  "Cyprus" INTEGER,
  "Czech Republic" INTEGER,
  "Democratic Republic of Congo" INTEGER,
  "Denmark" INTEGER,
  "Djibouti" INTEGER,
  "Dominica" INTEGER,
  "Dominican Republic" INTEGER,
  "Ecuador" INTEGER,
  "Egypt" INTEGER,
  "El Salvador" INTEGER,
  "Equatorial Guinea" INTEGER,
  "Eritrea" INTEGER,
  "Estonia" INTEGER,
  "Ethiopia" INTEGER,
  "Faeroe Islands" INTEGER,
  "Falkland Islands" INTEGER,
  "Fiji" INTEGER,
  "Finland" INTEGER,
  "France" INTEGER,
  "French Polynesia" INTEGER,
  "Gabon" INTEGER,
  "Gambia" INTEGER,
  "Georgia" INTEGER,
  "Germany" INTEGER,
  "Ghana" INTEGER,
  "Gibraltar" INTEGER,
  "Greece" INTEGER,
  "Greenland" INTEGER,
  "Grenada" INTEGER,
  "Guam" INTEGER,
  "Guatemala" INTEGER,
  "Guernsey" INTEGER,
  "Guinea" INTEGER,
  "Guinea-Bissau" INTEGER,
  "Guyana" INTEGER,
  "Haiti" INTEGER,
  "Honduras" INTEGER,
  "Hungary" INTEGER,
  "Iceland" INTEGER,
  "India" INTEGER,
  "Indonesia" INTEGER,
  "International" INTEGER,
  "Iran" INTEGER,
  "Iraq" INTEGER,
  "Ireland" INTEGER,
  "Isle of Man" INTEGER,
  "Israel" INTEGER,
  "Italy" INTEGER,
  "Jamaica" INTEGER,
  "Japan" INTEGER,
  "Jersey" INTEGER,
  "Jordan" INTEGER,
  "Kazakhstan" INTEGER,
  "Kenya" INTEGER,
  "Kosovo" INTEGER,
  "Kuwait" INTEGER,
  "Kyrgyzstan" INTEGER,
  "Laos" INTEGER,
  "Latvia" INTEGER,
  "Lebanon" INTEGER,
  "Lesotho" INTEGER,
  "Liberia" INTEGER,
  "Libya" INTEGER,
  "Liechtenstein" INTEGER,
  "Lithuania" INTEGER,
  "Luxembourg" INTEGER,
  "Macedonia" INTEGER,
  "Madagascar" INTEGER,
  "Malawi" INTEGER,
  "Malaysia" INTEGER,
  "Maldives" INTEGER,
  "Mali" INTEGER,
  "Malta" INTEGER,
  "Marshall Islands" INTEGER,
  "Mauritania" INTEGER,
  "Mauritius" INTEGER,
  "Mexico" INTEGER,
  "Moldova" INTEGER,
  "Monaco" INTEGER,
  "Mongolia" INTEGER,
  "Montenegro" INTEGER,
  "Montserrat" INTEGER,
  "Morocco" INTEGER,
  "Mozambique" INTEGER,
  "Myanmar" INTEGER,
  "Namibia" INTEGER,
  "Nepal" INTEGER,
  "Netherlands" INTEGER,
  "New Caledonia" INTEGER,
  "New Zealand" INTEGER,
  "Nicaragua" INTEGER,
  "Niger" INTEGER,
  "Nigeria" INTEGER,
  "Northern Mariana Islands" INTEGER,
  "Norway" INTEGER,
  "Oman" INTEGER,
  "Pakistan" INTEGER,
  "Palestine" INTEGER,
  "Panama" INTEGER,
  "Papua New Guinea" INTEGER,
  "Paraguay" INTEGER,
  "Peru" INTEGER,
  "Philippines" INTEGER,
  "Poland" INTEGER,
  "Portugal" INTEGER,
  "Puerto Rico" INTEGER,
  "Qatar" INTEGER,
  "Romania" INTEGER,
  "Russia" INTEGER,
  "Rwanda" INTEGER,
  "Saint Kitts and Nevis" INTEGER,
  "Saint Lucia" INTEGER,
  "Saint Vincent and the Grenadines" INTEGER,
  "San Marino" INTEGER,
  "Sao Tome and Principe" INTEGER,
  "Saudi Arabia" INTEGER,
  "Senegal" INTEGER,
  "Serbia" INTEGER,
  "Seychelles" INTEGER,
  "Sierra Leone" INTEGER,
  "Singapore" INTEGER,
  "Sint Maarten (Dutch part)" INTEGER,
  "Slovakia" INTEGER,
  "Slovenia" INTEGER,
  "Solomon Islands" INTEGER,
  "Somalia" INTEGER,
  "South Africa" INTEGER,
  "South Korea" INTEGER,
  "South Sudan" INTEGER,
  "Spain" INTEGER,
  "Sri Lanka" INTEGER,
  "Sudan" INTEGER,
  "Suriname" INTEGER,
  "Swaziland" INTEGER,
  "Sweden" INTEGER,
  "Switzerland" INTEGER,
  "Syria" INTEGER,
  "Taiwan" INTEGER,
  "Tajikistan" INTEGER,
  "Tanzania" INTEGER,
  "Thailand" INTEGER,
  "Timor" INTEGER,
  "Togo" INTEGER,
  "Trinidad and Tobago" INTEGER,
  "Tunisia" INTEGER,
  "Turkey" INTEGER,
  "Turks and Caicos Islands" INTEGER,
  "Uganda" INTEGER,
  "Ukraine" INTEGER,
  "United Arab Emirates" INTEGER,
  "United Kingdom" INTEGER,
  "United States" INTEGER,
  "United States Virgin Islands" INTEGER,
  "Uruguay" INTEGER,
  "Uzbekistan" INTEGER,
  "Vatican" INTEGER,
  "Venezuela" INTEGER,
  "Vietnam" INTEGER,
  "Wallis and Futuna" INTEGER,
  "Western Sahara" INTEGER,
  "Yemen" INTEGER,
  "Zambia" INTEGER,
  "Zimbabwe" INTEGER
);