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

5 rows where British Virgin Islands = 2

View and edit SQL

Suggested facets: Afghanistan, Andorra, Anguilla, Antigua and Barbuda, Aruba, Azerbaijan, Barbados, Benin, Bermuda, Bhutan, Brunei, Cambodia, Cameroon, Cayman Islands, Central African Republic, Chad, Comoros, Congo, Curacao, Denmark, Djibouti, Dominica, Equatorial Guinea, Eritrea, Faeroe Islands, French Polynesia, Gabon, Gambia, Greenland, Grenada, Guernsey, Guinea-Bissau, Haiti, Isle of Man, Jersey, Kyrgyzstan, Laos, Lesotho, Liberia, Libya, Liechtenstein, Luxembourg, Mauritius, Monaco, Mongolia, Montserrat, New Caledonia, Nicaragua, Niger, Northern Mariana Islands, Norway, Oman, Papua New Guinea, Saint Lucia, San Marino, Sao Tome and Principe, Serbia, Seychelles, Sierra Leone, Sint Maarten (Dutch part), Somalia, South Sudan, Spain, Sri Lanka, Sudan, Taiwan, Tanzania, Togo, Tunisia, Turks and Caicos Islands, United States Virgin Islands, Vatican, 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
88 2020-03-27 61109 0 28 65 36 1 2 4 87 39 9 367 1141 29 4 39 9 6 0 1363 0 1 9 0 22   40   482 2 7 22 32   2 16 633 1 3 1 2 164 94 21   0 30 16 77 10 1 14 408 9 153 0 4 96 192 14 0 1 2 134 0 8   0 78 3922 5 1 0 6 5780 64 9 71 1 6 12 1 4 1 2 0 0 15 39 65 75 103   2389 36 255 3 297 6153 1 96 14 19 32 6 15 13 0 4 23 35   0 0 5 25 120 24 4   235 0 2 5   1 33 203 28 3 1 14 4 50 2 2 4 0 1019 1 76 0 3 14   240 10 140 22 86 0 11 22 71 170 549   12 123 182 9 0 0 0 10   112 6 81 0   26 0 10 49   1 218 91   9181 4 0 0 2 286 1000 4 17   1 91 0 1 5 0 1196 1 0 43 0 2692 16797 0 21 18 4 1 10       2 0
233 2020-08-19 258065 0 155 419 0 60 0 0 4557 145 0 174 158 131 95 0 3200 1 84 725 78 0 0 1 1796 0 316 0 47784 2 0 169 5 3 0 17 282 50 0 12 11 1353 53 12462 0 0 559 124 199 44 0 8 281 15 115 2 0 386 1190 0 269 71 19 8 1386 0 0 0 24 2238 0 0 0 10 1510 340 5 250 0 0 22 903 0 95 0 28 24 675 0 13 64531 1673   2385 4576 186 0 1280 401 17 1592 0 40 1352 271 141 643 0 0 0 0 0 5 0 3 38 30 103 123 121 7 170 26 49   88 0 6561 412 0 0 47 0 1245 0 3 120 1016 487 0 6 196 0 410 0 56 192 0 612 247 14 471 7828 4739 597 214 953 293 1014 4748 37 0 1 0 0 0 1419 68 108 0 3 100 0 15 18   0 2258 297 0 6671 2 75 139 95 314 196 0 1 32 0 4 0 19 77 0 1263 17 43 0 365 1089 44091 0 28 660 0 895 6   0 4 142 70
245 2020-08-31 243219 19 101 364 0 73 0 0 9217 124 22 123 281 135 32 183 1897 3 164 117 30 0 0 29 614 0 575 0 16158 2 0 26 6 6 1 0 267 74 0 0 4 1965 32 8024 1 0 0 55 262 48 0 4 273 37 0 0 0 509 742 230 94 0 0 10 1468 0 0 0 28 5413 0 0 68 25 610 87 10 157 0 0 0 233 0 120 0 50 0 529 292 5 78512 2858   1754 3731 40 0 397 1365 244 601 0 73 0 263 119 412 78 0 18 595 15 0 465 1 35 45 0 52 8 17 89 16 15   10 0 2124 296 1 0 63 0 1343 61 38 249 1221 508 0 9 0 1 138 0 0 539 213 536 728 0 721 7731 4265 631 320 298 168 952 4980 177 0 0 0 0 1 910 100 83 0 3 54 3 34 31   0 2505 248 0 23572 17 0 55 51 48 291 75 0 69 0 1 0 6 38 113 1482 2 81 2096 362 1715 35581 5 15 348 0 922 0   0 6 123 6
258 2020-09-13 284136 35 164 255 0 62 0 0 11505 172 96 42 495 135 114 632 1282 0 191 617 23 0 0 3 810 0 300 0 33523 2 0 92 15 2 1 0 515 60 0 0 2 2131 23 6876 0 0 1485 71 261 60 10 3 1541 24 0 0 0 860 1719 148 77 6 0 23 521 2 0 0 45 10561 0 0 14 0 948 46 4 302 0 0 28 649 0 41 0 49 21 1087 916 1 94372 3817   2139 4106 159 0 4653 1501 112 674 0 117 420 176 70 736 53 0 5 686 0 1 440 0 53 0 141 68 9 58 62 4 27   44 0 2669 531 1 0 145 0 2238 122 351 167 1201 1231 0 2 0 0 160 1 0 0 526 650 711 3 812 6162 4899 603 497 511 236 1311 5488 31 0 0 0 0 0 643 44 72 2 9 42 2 201 105   0 1816 121 10 0 27 33 50 25 206 465 30 0 37 0 7 0 7 168 376 1509 3 326 3103 1007 3497 40820 19 7 544 0 967 0   0 4 143 29
265 2020-09-20 293505 125 153 210 0 112 0 1 11945 244 0 24 757 148 101 690 1567 0 231 894 16 0 2 1 419 0 320 0 33057 2 0 86 19 0 0 60 863 45 0 0 2 1847 25 7927 0 6 1338 69 212 51 19 15 2044 32 0 0 0 968 1491 128 82 0 0 61 616 1 0 0 64 13498 62 0 19 196 1345 20 3 240 0 0 72 808 0 55 0 66 15 532 1070 77 92605 4168   2845 3907 267 0 4531 1637 187 584 0 196 335 105 63 521 81 0 17 779 63 1 796 0 99 0 140 49 0 20 81 15 65   0 1 2658 688 1 1 187 0 2552 273 642 85 1204 1882 0 4 0 0 189 6 0 0 640 726 722 0 888 6453 3934 1002 849 1309 229 1333 6065 18 0 0 0 0 0 551 43 83 0 6 15 10 290 114   52 2029 82 33 0 2 0 18 30 279 0 34 1 44 0 6 0 19 202 1166 1538 1 423 3240 809 4422 40295 0 14 982 0 775 0   0 4 2 25

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