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

8 rows where Faeroe Islands = 3

View and edit SQL

Suggested facets: Afghanistan, Andorra, Angola, Antigua and Barbuda, Australia, Azerbaijan, Bangladesh, Barbados, Benin, Bermuda, Bhutan, Bonaire Sint Eustatius and Saba, Brunei, Burundi, Cambodia, Cameroon, Cape Verde, Cayman Islands, Central African Republic, Chad, Comoros, Congo, Cuba, Curacao, Democratic Republic of Congo, Denmark, Djibouti, Equatorial Guinea, Eritrea, Estonia, Fiji, French Polynesia, Gabon, Gambia, Georgia, Ghana, Gibraltar, Greenland, Guernsey, Guinea, Guinea-Bissau, Haiti, Isle of Man, Jersey, Lesotho, Liberia, Liechtenstein, Luxembourg, Malawi, Maldives, Mali, Mauritania, Mauritius, Monaco, Mongolia, New Caledonia, New Zealand, Nicaragua, Niger, Northern Mariana Islands, Norway, Papua New Guinea, Saint Kitts and Nevis, Saint Vincent and the Grenadines, San Marino, Sao Tome and Principe, Senegal, Seychelles, Sierra Leone, Sint Maarten (Dutch part), Somalia, South Korea, South Sudan, Sri Lanka, Sudan, Suriname, Swaziland, Syria, Taiwan, Tajikistan, Thailand, Togo, Turks and Caicos Islands, United States Virgin Islands, Uruguay, Vietnam, Yemen, Zambia, 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
85 2020-03-24 44570 6 11 29 20 0   0 35 41 8 114 855 7 0 5 6 0 5 1328 1 3 0 0 1   6   345   3 16 11   1 29 216 0 0 0 0 114 69 71   0 24 0 71 5 3 21 71 0 65 2 0 43 192 33 2 3 0 26 0 3   1 74 3838 5 0 1 7 4438 3 0 71 2 0 2 1 3 0   0 3 3 20 20 53 65   1411 33 219 11 371 4789 0 39 3 13 2 1 28 1 2   41 19   0   0 36 77 22 14   212 0   17   0 8 135 15 2 0 6 0 19 0 2 0 1 545 2 40 0 1 10   239 11 103 0 32 0 5 32 82 115 460   7 143 71 17   0   36   51 12 34 0   54   6 28   0 128 76   7691 10 0 1 0 182 1044 0 30   0 106 0 3 1 14 293   8 26 45 1378 11236 17 4 3 0 48 11       0 0
203 2020-07-20 213628 174 82 535 0 18 0 0 3223 104 5 361 63 388 15 418 2459 1 142 64 0 0 0 2 1444 0 288 0 23529 0 0 95 13 0 0 0 680 29 0 0 0 2084 130 6578 6 0 563 207 119 1 2 1 90 79 0 8 0 1336 631 603 338 0 0 0 356 3 0 0 20 0 0 0 0 0 249 607 0 24 0 0 4 635 0 53 0 9 0 1042 18 1 40425 1639   2182 2310 10 0 924 218 16 454 0 4 1499 603 118 300 611 0 3 84 0 3 75 1 17 74 123 200 85 15 36 3 0   427 0 3389 186 0 0 107 0 221 56 0 44 156 144 0 1 0 0 556 0 0 1157 1587 465 1207 2 92 4090 2152 358 246 610 340 767 6109 43 0 0 6 0 3 2504 141 396 0 10 257 0 3 6   8 13449 26 9 4581 20 80 28 64 110 98 0 0 44 0 1 0 8 0 26 924 6 3 731 211 493 61796 0 10 537 0 408 0   0 25 0 133
266 2020-09-21 284329 0 159 203 0 90 0 0 9276 277 91 13 609 146 55 620 1544 4 213 461 21 0 0 2 206 0 212 0 16389 0 0 44 30 0 0 0 875 71 0 7 2 1600 36 6678 0 0 0 51 197 36 21 20 934 26 0 0 0 589 799 115 125 0 0 49 689 3 0 0 58 11569 47 0 22 193 922 127 4 164 0 0 0 292 1 39 0 101 4 473 876 39 86961 3989   3097 3438 395 0 4825 1587 230 0 0 239 107 152 61 385 55 0 10 1006 34 0 715 0 80 86 178 33 15 52 75 7 32   7 0 1701 260 1 0 714 0 1927 234 542 85 1325 1843 0 0 0 6 97 1 0 1722 633 683 602 1 505 6030 3283 910 552 845 230 1231 6148 22 0 0 0 0 0 483 26 68 0 9 18 0 131 111   0 1555 70 0 31428 4 20 14 24 133 0 35 2 43 0 0 0 7 48 996 1519 0 270 2966 674 3899 39852 27 13 554 0 707 0   0 2 107 11
267 2020-09-22 268939 30 150 197 117 126 0 0 17213 121 36 14 593 92 48 540 1705 0 224 2202 8 14 0 0 310 20 92 0 13439 0 0 151 50 1 0 167 1766 0 1 0 2 1194 12 5359 0 16 1890 7 70 50 14 3 1524 4 1476 1 0 494 292 126 245 16 0 17 889 3 0 0 66 4298 14 8 14 218 1821 58 0 453 0 0 30 237 1 19 0 133 5 459 633 31 75083 4176   3341 3821 188 1 4152 1350 134 781 3 266 87 98 79 530 71 0 1 684 0 1 847 2 70 112 45 20 2 57 46 11 46   16 0 6031 200 2 1 230 0 1376 141 666 149 1154 2215 0 0 0 1 195 0 251 576 582 611 607 9 740 4001 3447 748 623 638 228 808 6196 11 2 0 0 0 0 492 24 30 2 0 30 7 79 50   23 725 61 7 10799 12 0 17 13 266 1093 33 0 42 0 5 0 3 44 528 1743 0 181 2675 679 4368 53153 0 10 702 0 787 0   0 0 44 23
269 2020-09-24 311481 25 121 186 72 0 0 1 12638 210 56 31 661 146 151 650 1666 0 253 2096 37 31 1 0 537 5 344 0 33281 0 0 160 22 2 0 92 1090 131 0 0 9 1380 10 6731 0 3 1370 87 204 48 10 36 2306 14 558 0 0 468 2249 121 0 0 0 57 661 3 0 0 93 13072 0 12 2 259 2143 37 2 358 0 0 45 819 0 47 0 98 13 369 750 57 86508 4465   3605 5055 231 0 11316 1640 122 273 1 363 307 130 62 616 127 0 12 940 0 1 651 1 73 74 182 31 9 147 67 4 42   41 0 5495 786 2 0 290 0 2397 148 868 56 1172 2351 0 3 0 0 111 0 152 628 799 503 706 4 743 6149 2802 974 802 55 258 1767 6431 41 0 0 0 0 0 561 36 81 0 9 12 22 338 136   0 1906 125 0 10653 11 0 20 36 553 436 47 0 43 0 2 0 18 110 1219 1767 4 167 3497 1083 6178 37930 12 12 616 0 986 1   0 0 54 14
271 2020-09-26 311601 6 124 175 83 112 0 0 12956 392 43 17 1071 101 91 687 1383 1 306 1622 50 0 0 0 604 7 248 0 31911 0 0 255 12 6 0 0 1362 149 0 2 4 2234 17 7494 0 0 1357 55 223 40 14 8 2944 23 678 2 0 475 1329 112 214 0 5 42 486 3 0 0 105 15797 0 12 3 265 2507 0 3 286 0 0 51 945 0 0 21 130 38 647 950 49 85362 4823   3563 4593 321 0 815 1912 135 558 1 620 301 218 46 590 158 0 31 1143 51 0 658 0 114 75 143 30 14 0 75 23 31   0 0 5079 713 3 0 245 0 2423 190 597 95 1313 2776 1 2 0 0 213 0 131 0 566 452 705 1 822 5654 2606 1587 899 1063 225 1629 7212 9 0 0 0 0 1 472 0 75 0 11 11 9 419 191   0 1480 61 12 0 12 0 28 24 629 255 35 1 42 0 3 0 15 42 1087 1665 1 154 3565 1008 6873 55013 18 8 496 0 867 0   0 0 24 35
275 2020-09-30 293940 15 127 155 0 108 0 0 13477 327 62 19 722 58 65 574 1488 0 314 2984 52 0 0 1 333 0 225 0 32058 0 0 276 4 4 0 0 1660 83 0 19 8 1629 23 5839 1 0 890 28 135 48 6 30 1960 6 392 6 0 234 784 124 172 2 0 48 640 3 0 0 158 8051 0 0 10 0 1798 0 9 416 0 0 53 705 0 36 0 59 7 561 894 32 80472 4002   3677 4724 362 0 3661 1647 239 516 1 823 374 210 54 587 147 0 32 1105 11 1 801 2 88 55 112 29 2 101 37 0 29   10 14 5741 835 2 0 134 0 2076 268 794 19 1513 3001 0 1 97 0 187 0 90 528 747 420 576 2 669 3054 2015 1326 688 1045 222 1470 8232 4 0 0 0 0 0 539 26 65 0 7 27 14 231 93   0 903 113 8 11016 11 0 27 10 613 223 46 1 41 0 5 0 10 77 1291 1427 4 240 3627 995 7143 43017 0 23 451 0 835 17   0 0 55 21
296 2020-10-21 394459 88 301 223 0 207 0 0 16337 1234 21 31 1803 584 150 309 1383 0 619 18753 53 0 3 1 147 0 728 0 23227 0 0 1336 19 1 1 64 2251 101 0 2 9 1173 16 8256 2 0 847 18 890 47 8 152 11984 14 529 30 0 306 692 158 309 4 0 42 630 3 0 1 294 20468 751 0 0 1194 7595 89 31 667 0 0 130 620 1 20 14 31 0 851 1423 92 54044 3602   5039 3920 1263 0 1627 10871 53 453 7 2035 363 571 130 886 549 0 115 1392 0 3 957 22 202 353 408 0 1 862 39 4 134   13 0 5788 656 3 1 132 0 3254 110 1297 41 3093 8149 0 25 81 1 72 0 147 439 1292 513 558 0 621 3242 1606 9291 1876 693 273 3400 16319 5 0 0 1 0 0 385 27 326 0 5 6 0 705 794 0 0 1050 91 0 16973 186 27 11 12 1292 3008 46 3 41 0 9 0 33 35 1723 1894 0 97 0 1077 21330 58549 1 63 273 0 1008 1 0 0 0 85 28

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
);