total_cases

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

7 rows where Greenland = 17

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Afghanistan, Andorra, Antigua and Barbuda, Aruba, Bahrain, Barbados, Benin, Bermuda, Bhutan, Bonaire Sint Eustatius and Saba, Botswana, Burkina Faso, Cambodia, Cameroon, Cayman Islands, Central African Republic, Comoros, Congo, Costa Rica, Curacao, Cyprus, Democratic Republic of Congo, Dominica, El Salvador, Equatorial Guinea, Eritrea, Faeroe Islands, French Polynesia, Gabon, Gambia, Ghana, Grenada, Guam, Guernsey, Guinea, Haiti, Isle of Man, Jersey, Lesotho, Liberia, Macedonia, Madagascar, Mauritania, Mauritius, Mongolia, Nicaragua, Niger, Northern Mariana Islands, Norway, Oman, Palestine, Papua New Guinea, Paraguay, Saint Lucia, Saint Vincent and the Grenadines, San Marino, Sao Tome and Principe, Sierra Leone, Sint Maarten (Dutch part), Solomon Islands, Somalia, South Sudan, Spain, Sudan, Suriname, Switzerland, Taiwan, Timor, Tunisia, Turks and Caicos Islands, United States Virgin Islands, Vietnam, Yemen, 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
);