total_cases

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

10 rows where Western Sahara = 519

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Afghanistan, Angola, Antigua and Barbuda, Argentina, Aruba, Bahamas, Barbados, Belize, Benin, Bermuda, Bhutan, Botswana, Burkina Faso, Burundi, Cambodia, Cameroon, Cape Verde, Central African Republic, Chad, Comoros, Congo, Cote d'Ivoire, Denmark, Djibouti, Eritrea, Estonia, Ethiopia, Faeroe Islands, Fiji, Finland, France, Gabon, Gambia, Ghana, Gibraltar, Guam, Guinea, Guinea-Bissau, Guyana, Haiti, Hungary, Iceland, Jamaica, Jersey, Jordan, Kosovo, Latvia, Lesotho, Libya, Liechtenstein, Madagascar, Malaysia, Mali, Malta, Mauritania, Mauritius, Monaco, Mongolia, Montserrat, Morocco, Myanmar, Namibia, Nepal, New Zealand, Nicaragua, Niger, Northern Mariana Islands, Norway, Philippines, Puerto Rico, Saint Kitts and Nevis, Saint Vincent and the Grenadines, San Marino, Sao Tome and Principe, Seychelles, Sierra Leone, Singapore, Sint Maarten (Dutch part), Somalia, South Korea, South Sudan, Spain, Sudan, Suriname, Syria, Taiwan, Thailand, Togo, Trinidad and Tobago, Turks and Caicos Islands, United States Virgin Islands, Vietnam, Zambia, date (date)

CREATE TABLE "total_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
);