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

5 rows where San Marino = 3

View and edit SQL

Suggested facets: Andorra, Angola, Australia, Bahamas, Barbados, Benin, Bermuda, Bhutan, Burkina Faso, Cambodia, Comoros, Congo, Croatia, Curacao, Cyprus, El Salvador, Estonia, Faeroe Islands, Gambia, Georgia, Greece, Greenland, Guinea, Guyana, Iceland, Jamaica, Lebanon, Luxembourg, Malawi, Malaysia, Mauritania, Mongolia, Myanmar, Namibia, New Caledonia, Niger, Saint Vincent and the Grenadines, Slovakia, Slovenia, Somalia, South Sudan, Suriname, Syria, United States Virgin Islands, Vietnam, 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
69 2020-03-08 3978 3             1     11 25     7       27                 0     2     1   6           46           1       7   8                     1       103       3 163     21                     3 10 3     1076 16 1   6 1247   47   0       3     1                     10 2   0       1 1                   60             34     3     1   1 1 8   1 6 0         3   2         8   2 3     1 367   330         33 55   0                       16 81 95           4          
145 2020-05-23 106803 540 12 190 0 2 0 0 718 374 0 14 29 106 0 240 1694 0 932 248 0 0 3 3 392 0 20 1 20803 0 0 36 2 0 1 112 1156 6 10 43 23 4276 2 801 44 0 8 70 6 8 0 4 59 80 48 223 0 332 522 783 85 0 0 7 34 0 0 0 44 403 0 161 1 2 638 131 0 20 0 0 0 231 0 0 0 0 78 273 35 0 6654 634   2311 87 115 0 0 652 10 23 0 16 322 52 21 955 14 0 5 62 0 9 1 0 10 1 23 43 10 78 58 22 1   0 0 3963 143 0 0 0 0 121 2 2 1 61 188 0 0 254 13 245 0 41 424 1743 0 151 0 2 2929 163 476 288 117 1830 127 8894 1 0 0 0 3 0 2642 97 105 0 21 614 0 1 0   0 988 23 0 466 13 240 0 0 532 13 1 0 210 0 3 0 9 0 2 952 0 15 442 994 2574 24147 0 4 72 0 62 0   0 12 54 5
151 2020-05-29 119332 580 26 140 0 2 0 0 769 460 0 11 28 191 1 419 2029 0 902 171 0 0 1 3 619 0 28 0 26417 0 0 25 2 0 0 0 993 0 0 53 11 4654 0 1262 0 0 16 85 1 9 1 2 54 173 32 217 0 345 368 1127 85 0 0 11 100 0 0 0 51 3325 0 112 0 3 741 0 0 3 1 0 1 203 0 107 0 11 123 112 25 0 7466 687   2258 322 38 0 79 593 0 68 0 8 356 147 4 845 68 0 4 7 0 3 6 0 9 7 38 44 102 10 56 78 4   0 0 4203 188 0 18 0 0 42 6 0 0 156 182 1 0 0 0 182 0 18 636 2801 12 403 0 16 5874 539 352 304 89 1967 197 8371 3 0 0 7 3 15 1644 95 25 0 30 373 0 5 2   97 1466 58 0 658 61 200 0 7 774 35 0 0 463 0 11 0 27 0 17 1182 0 36 477 563 1835 21817 0 8 111 0 82 0   0 23 0 17
164 2020-06-11 135661 684 42 102 0 17 0 0 1239 566 0 9 34 339 0 467 3190 4 801 119 0 0 0 3 637 0 49 6 32913 0 0 104 0 0 0 248 472 30 4 64 2 5737 11 1604 0 17 86 186 2 6 0 2 73 131 15 42 0 393 523 1455 83 0 0 11 170 0 0 0 15 545 0 81 0 9 555 157 0 10 0 0 2 355 0 0 0 0 134 425 10 0 9996 1240   2011 1146 16 0 87 202 0 41 0 18 239 105 29 683 36 0 3 20 0 14 46 0 6 3 125 24 0 2 20 81 3   0 0 5690 296 0 0 0 0 18 19 3 0 279 184 0 0 155 0 409 0 13 689 5834 4 656 0 15 5087 740 197 294 144 1716 196 8404 13 0 0 0 3 118 3717 124 66 0 37 451 0 2 2   36 2430 45 0 427 10 185 0 27 1437 23 6 0 73 0 0 0 21 0 0 922 0 8 525 603 1158 20614 1 1 148 0 106 0   0 36 52 6
166 2020-06-13 144990 656 31 109 1 12 0 0 1391 723 0 5 30 336 0 1046 3471 0 704 89 0 83 1 0 764 0 61 12 25982 0 0 105 0 0 0 267 413 40 7 13 0 6754 12 3176 0 0 74 280 0 14 0 5 52 122 64 43 0 571 1338 1578 0 0 0 5 245 0 0 0 9 726 0 0 0 12 348 760 0 20 0 0 3 421 0 54 0 1 0 463 14 1 11458 1111   2369 1095 12 0 175 163 3 50 0 25 366 90 58 520 41 0 2 20 0 11 16 0 4 3 164 27 0 33 27 30 5   277 0 5586 366 0 0 0 0 73 20 0 0 448 210 0 0 191 4 627 0 12 1117 6472 2 625 0 24 5961 612 376 270 184 1517 222 8987 16 0 0 0 3 11 3921 92 73 0 18 463 0 1 2   0 3359 48 66 396 3 149 19 23 1329 19 0 0 68 0 4 0 1 0 6 1195 0 6 683 513 1017 25639 0 0 82 0 65 1   0 41 69 11

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