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

5 rows where Gibraltar = 8

View and edit SQL

Suggested facets: Andorra, Antigua and Barbuda, Bahamas, Bangladesh, Barbados, Belize, Benin, Bermuda, Bhutan, Bonaire Sint Eustatius and Saba, Botswana, Brunei, Bulgaria, Burundi, Cambodia, Cameroon, Cayman Islands, Central African Republic, Comoros, Curacao, Djibouti, Dominica, El Salvador, Equatorial Guinea, Eritrea, Faeroe Islands, French Polynesia, Gabon, Gambia, Ghana, Guinea-Bissau, Jersey, Lesotho, Mali, Malta, Mauritania, Monaco, Mongolia, Nicaragua, Niger, Northern Mariana Islands, Norway, Oman, Papua New Guinea, Peru, Saint Lucia, Sao Tome and Principe, Seychelles, Sierra Leone, Somalia, South Sudan, Spain, Suriname, Switzerland, Syria, Taiwan, Tajikistan, Thailand, Togo, Turks and Caicos Islands, United States Virgin Islands, Vietnam, Yemen, Zimbabwe, 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
154 2020-06-01 105625 680 15 127 0 2 0 0 637 210 0 10 4 248 0 605 2545 0 898 49 0 0 0 0 390 0 16 3 16409 0 0 0 28 21 0 0 757 14 0 49 19 4830 19 1147 0 24 9 34 0 20 0 1 43 83 36 160 0 377 527 1536 0 0 0 4 109 0 0 0 33 257 0 0 0 26 333 302 8 2 0 0 2 348 0 65 66 1 259 108 9 0 8392 700   2516 260 61 0 59 355 5 33 0 5 450 74 13 851 69 0 1 29 0 8 26 0 5 2 62 13 5 57 101 15 0   47 0 2061 153 0 6 0 0 27 10 4 1 171 185 0 0 0 2 307 0 0 1014 2964 1 445 0 22 8805 862 215 297 58 1648 124 9268 11 0 0 0 0 4 1877 110 31 0 9 518 0 1 0   60 1716 35 0 209 13 226 9 2 265 17 0 0 0 0 0 0 9 0 1 839 0 45 468 661 1125 19807 0 2 108 0 51 1   0 13 0 4
240 2020-08-26 256559 1 154 370 0 61 0 0 8713 111 42 137 291 133 15 746 2545 3 82 527 17 0 0 17 851 0 297 0 47134 0 1 203 14 0 0 211 322 36 0 12 8 1417 34 10432 0 129 842 56 219 27 0 23 367 49 83 0 0 609 741 141 175 0 9 19 1545 1 0 0 43 3304 0 0 101 15 1576 95 8 168 0 0 77 1118 0 115 0 105 2 0 24 4 67151 2447   2245 3962 85 0 2015 876 120 701 4 77 0 246 136 613 113 0 5 532 34 5 272 0 21 44 78 73 4 11 135 5 38   23 0 6403 530 6 2 66 0 1276 68 30 130 855 414 0 5 183 1 252 0 72 143 482 574 896 18 626 6944 2912 763 192 102 232 1060 4696 231 0 0 0 0 0 1114 43 106 4 4 31 10 28 21   6 1567 320 3 7296 12 138 66 23 222 202 0 0 33 0 1 0 14 153 176 1502 48 64 3331 339 1184 38119 32 3 284 0 820 7   0 8 137 126
272 2020-09-27 299267 35 108 160 0 115 0 3 11249 429 33 16 623 108 0 489 1106 0 332 944 17 0 0 8 370 0 231 0 28378 0 1 169 11 2 1 23 1215 73 0 0 2 2111 15 7721 4 3 1233 44 212 62 8 13 1976 15 619 0 0 360 1506 111 0 10 6 47 527 2 0 0 93 14412 0 0 0 590 1410 0 8 315 0 0 68 824 0 70 0 16 39 708 937 40 88600 4494   3204 4270 245 0 11827 1869 129 635 0 850 293 164 46 758 161 0 29 1280 0 0 538 0 111 78 140 36 2 193 31 16 0   24 0 2535 868 2 0 235 0 2719 168 879 83 1207 2711 0 2 0 0 136 0 0 0 694 290 677 0 696 5558 1895 1584 884 508 200 1552 7523 13 0 0 0 0 0 461 53 74 0 9 20 6 552 184   123 969 95 0 0 4 14 14 20 325 117 37 0 43 0 1 0 14 35 786 1511 1 146 3833 1078 6041 45368 3 31 491 0 667 0   0 0 97 16
283 2020-10-08 353625 68 162 121 198 0 0 0 16447 672 14 8 947 182 154 456 1520 3 415 6798 67 54 1 4 238 4 365 0 31553 0 0 437 25 1 1 0 1800 106 0 0 13 1134 22 7875 0 29 1355 32 363 15 14 21 5338 26 331 0 0 777 1475 133 105 10 0 56 892 1 0 0 120 18746 62 7 0 508 4058 0 8 406 0 0 0 834 0 0 0 104 0 354 932 91 78524 4538   4019 3923 609 0 4455 3677 82 477 3 1199 358 321 49 475 298 0 67 1459 0 1 1045 0 117 140 316 33 7 489 35 15 68   0 0 5175 1062 3 0 210 0 2776 96 1400 41 3439 4979 0 3 0 0 155 0 180 817 583 510 698 0 788 2733 2804 3003 944 31 238 2958 11115 10 0 1 0 0 0 468 33 121 0 10 10 3 877 356   0 1913 69 0 12423 207 15 14 19 831 0 47 3 41 0 7 0 17 41 2312 1581 0 178 4753 1046 14162 48182 1 29 562 0 608 1   0 8 54 4
286 2020-10-11 349000 0 165 136 0 73 0 0 12428 649 21 15 901 233 68 427 1203 2 0 4307 54 0 0 0 237 0 0 0 26749 0 0 0 17 2 0 0 0 104 7 2 17 1826 21 8447 0 0 1386 92 486 5 66 35 4633 6 444 0 1 557 980 125 0 0 9 37 767 0 0 0 269 26896 0 0 7 519 3483 18 8 306 0 0 89 609 0 42 0 47 6 594 1068 87 74383 4294   3875 2344 1011 0 2145 5724 196 679 0 1235 352 538 80 492 0 0 89 1388 0 3 318 0 205 0 392 26 8 374 51 25 100   0 0 2435 929 0 1 293 0 3443 102 2158 62 5008 6493 0 1 0 0 111 2 0 0 666 281 825 0 703 2733 2156 5300 1646 472 178 3517 12846 2 0 1 0 0 0 405 31 168 0 5 7 4 1887 380   0 2364 58 0 0 105 0 17 16 509 0 57 0 43 0 0 0 14 22 3137 1649 0 163 11532 1129 15165 54271 0 17 552 0 757 2   0 1 38 16

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