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

6 rows where San Marino = 7

View and edit SQL

Suggested facets: Afghanistan, Aruba, Barbados, Benin, Bhutan, British Virgin Islands, Burundi, Cambodia, Cameroon, Cayman Islands, Central African Republic, Curacao, Democratic Republic of Congo, Dominica, Egypt, El Salvador, Equatorial Guinea, Eritrea, Ethiopia, Faeroe Islands, Falkland Islands, Fiji, Gabon, Gambia, Ghana, Greenland, Guernsey, Guinea-Bissau, Guyana, Isle of Man, Laos, Liberia, Libya, Macedonia, Madagascar, Malawi, Maldives, Mauritania, Mauritius, Monaco, Mongolia, Myanmar, Nepal, New Zealand, Nicaragua, Nigeria, Northern Mariana Islands, Pakistan, Russia, Saint Lucia, Seychelles, Singapore, Somalia, South Korea, Suriname, Swaziland, Taiwan, Tanzania, Thailand, Trinidad and Tobago, United States Virgin Islands, Vatican, Vietnam, 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
63 2020-03-02 2086 0   0           0   3 4 2   6     0 18                 0           0   4           205           2       3   1     1 5 1       0         3 30       0 18     0                       2 0 2 0 385 6 0   3 561   15           1       6         0 0 0     4             0   0               0 6   0     0   4 0 0           0       2 0 0         7             4             686   54 0       0 6   0     1                 0 5 20           0          
67 2020-03-06 3060     5         1     7 12 3   0       81       1     2   5               12         1 170           1       4   10       3 1       3   1     5 138       6 138     22                       9 1     591 7 7   2 769   32           2       3                   0             2           1         44   1         30 1   7             4     2 0         7   4 1       5     5     1 518   183         25 30   2                       2 56 74                      
98 2020-04-06 66260 29 28 69 35 4 0 0 103 11 0 57 217 63 1 12 18 5 170 665 1 6 0 0 26 0 31 2 852 0 0 28 43 0 0 95 1614 0 4 0 1 310 67 79   0 19 16 56 32 0 20 115 0 292 8 0 167 181 85 7 0 0 79 5 0 1 2 45 1873 1 0 0 17 3677 0 5 62 1 0 17 9 18 10 0 5 0 30 11 69 693 181   2483 83 507 1 412 4316 3 383 32 22 71 16 10 77 72 1 24 7   3 0 1 40 75 0 1 0 179 0 4 14   0 31 237 112 3 0 13 0 102 0 0 2 3 1224 0 39 0 64 22 0 130 21 827 62 187 0 9 535 152 475 754 23 279 251 658 2 0 0 0 7   206 3 284 0 2 120 2 14 20   0 70 47 1 3667 7 2 0 0 340 821 3 0   1 51 0 3 1 58 3135 0 4 83 278 4020 25398 2 17 76 0 4 4       0 0
128 2020-05-06 79555 330 17 190 1 1 0 0 133 163 0 24 17 76 6 187 786 0 861 546 0 0 0 0 121 0 20 0 6935 0 0 37 16 0 0 0 1274 11 0 0 53 1373 2 640 0 0 13 32 11 17 0 4 77 21 151 4 0 245 0 388 0 124 0 8 5 0 0 0 85 1104 2 30 0 11 947 0 0 10 0 0 0 33 0 101 62 1 1 92 46 0 2958 484   1323 85 261 1 43 1075 2 123 0 6 156 45 1 526 28 0 0 1   4 0 0 4 12 8 9 0 30 22 32 1   0 0 2082 115 0 0 1 0 176 1 0 0 0 317 0 1 1 8 148 0 56 98 1049 14 136 0 16 3817 199 425 178 81 951 325 10102 0 0 0 0 7 0 1595 58 120 0 21 632 0 8 3   79 352 2 6 880 16 100 0 0 657 28 0 0 63 0 1 0 2 0 4 1832 0 1 366 462 3389 23841 0 13 18 0 6 0   0 9 2 0
291 2020-10-16 402521 0 257 193 0 166 0 0 17096 1371 30 21 1396 530 0 333 1600 3 613 11746 63 18 0 0 178 0 569 203 28523 0 0 914 30 0 0 0 2345 73 0 0 21 1124 36 6823 0 0 1372 40 793 27 28 51 9720 35 430 3 1 404 1277 118 295 0 0 33 739 2 0 0 291 30621 62 0 0 919 7334 47 15 452 0 0 86 671 0 67 0 31 17 631 1293 80 63371 4411   4616 3587 1186 0 948 8803 78 721 3 2459 433 602 77 746 431 0 114 1499 0 2 855 22 255 214 534 0 7 589 51 16 104   0 0 1470 652 5 0 211 0 3317 145 1026 34 3749 7779 0 4 0 2 0 3 162 520 659 442 755 0 751 2789 2162 8099 2101 569 200 4013 13754 13 0 0 0 7 0 472 17 203 1 8 3 8 1929 746 2 0 1770 47 9 15186 74 0 11 18 903 2690 48 5 38 0 4 0 13 40 0 1693 0 48 5062 1398 18978 63785 1 79 309 7 464 2   0 0 43 20
295 2020-10-20 349142 87 295 214 246 160 0 0 12982 766 12 9 1054 331 70 322 1637 0 592 15127 20 0 0 3 119 0 1100 367 15383 1 0 1024 6 7 2 65 3289 48 2 1 11 1545 34 6311 0 0 1561 1 393 38 7 43 8077 0 452 10 0 320 134 123 0 0 27 7 723 0 0 0 131 13243 0 3 6 1186 6868 62 6 432 0 0 81 239 0 0 0 31 51 956 989 46 46790 3373   4251 4044 1031 0 1030 9337 47 353 19 1364 130 195 118 686 384 0 44 658 0 4 1159 3 205 242 160 0 3 865 22 28 455   5 12 3699 252 3 2 145 0 2117 214 1180 33 3790 7720 0 1 0 1 118 2 320 641 0 543 436 0 728 2201 2551 7482 1949 657 240 2466 15982 18 0 3 0 7 0 381 14 122 0 1 4 3 860 537 0 26 1461 58 5 13873 87 6 3 8 770 8737 57 0 40 0 9 0 14 1 2185 2026 0 101 5469 915 18803 60160 1 29 307 0 0 6 0 0 1 44 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
);