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

7 rows where Australia = 8

View and edit SQL

Suggested facets: Afghanistan, Albania, Algeria, Angola, Armenia, Aruba, Austria, Azerbaijan, Bahamas, Bahrain, Bangladesh, Belarus, Belgium, Belize, Bosnia and Herzegovina, Botswana, Bulgaria, Cameroon, Canada, Cape Verde, Chad, China, Congo, Costa Rica, Croatia, Cuba, Czech Republic, Denmark, Djibouti, Dominican Republic, Ecuador, Egypt, El Salvador, Gambia, Georgia, Germany, Ghana, Greece, Guam, Guinea, Guyana, Haiti, Hungary, Iraq, Ireland, Jamaica, Jordan, Kazakhstan, Kenya, Kosovo, Kuwait, Kyrgyzstan, Latvia, Lebanon, Lesotho, Liberia, Luxembourg, Macedonia, Madagascar, Malawi, Maldives, Malta, Moldova, Montenegro, Mozambique, Myanmar, Namibia, Nepal, Netherlands, Nicaragua, Nigeria, Norway, Oman, Pakistan, Palestine, Papua New Guinea, Paraguay, Philippines, Poland, Portugal, Puerto Rico, Qatar, Rwanda, Saudi Arabia, Senegal, Serbia, Sierra Leone, Sint Maarten (Dutch part), Slovakia, Somalia, South Korea, Sudan, Suriname, Swaziland, Sweden, Switzerland, Syria, Tajikistan, Togo, Trinidad and Tobago, Tunisia, Uganda, United Arab Emirates, United States Virgin Islands, Uruguay, Uzbekistan, Venezuela, Vietnam, Yemen, Zambia, 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
217 2020-08-03 4233 1 5 8 0 0 0 0 54 8 0 8 0 8 0 0 22 0 4 5 0 0 0 0 89 0 8 0 541 0 0 3 0 0 0 0 4 0 0 0 0 75 2 320 0 0 8 0 4 0 0 0 0 0 0 1 0 8 14 31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 0 0 2 0 0 0 36 0 0 0 1 0 9 0 0 771 43   208 63 0 0 9 8 2 1 0 0 286 5 13 4 11 0 0 1 5 2 6 0 0 3 4 7 3 0 0 0 0   0 0 274 3 0 0 1 0 15 2 0 0 1 0 0 0 0 0 5 0 0 0 33 2 22 0 0 206 20 10 1 5 3 34 70 0 0 0 0 0 0 50 0 8 0 0 0 1 0 0   0 213 0 0 27 0 6 1 0 3 0 1 0 1 0 0 0 0 0 0 18 0 0 16 0 5 413 0 1 6 0 5 1   0 3 5 1
221 2020-08-07 6895 0 6 12 0 3 0 0 126 2 0 8 0 3 0 2 39 0 3 4 0 0 0 0 80 0 5 0 1237 0 0 9 0 0 0 0 4 0 0 0 1 97 3 315 0 0 9 0 1 0 0 0 1 0 1 0 0 24 40 21 7 0 0 0 9 0 0 0 0 7 0 0 0 0 8 7 0 0 0 0 0 47 0 0 0 0 0 23 1 0 886 69   14 67 5 0 11 6 0 7 0 0 0 8 16 1 4 0 0 2 2 0 3 0 0 1 6 7 1 0 0 0 0   0 0 819 5 0 0 3 0 14 0 0 3 5 0 0 0 0 0 3 0 0 4 17 1 21 1 5 196 27 18 3 12 0 45 74 0 0 0 0 0 0 35 9 7 0 1 0 0 0 0   0 306 1 0 3 0 0 2 2 4 3 0 0 1 0 0 0 1 0 0 14 0 0 31 1 18 1848 0 0 6 0 7 1   0 1 23 13
240 2020-08-26 6477 0 5 10 0 2 0 0 323 4 1 8 0 2 0 2 45 0 6 5 0 0 0 0 86 0 14 0 1271 0 0 9 0 0 0 2 7 0 0 0 1 42 1 277 0 1 14 0 2 0 0 0 1 0 0 0 0 12 46 18 9 0 0 0 17 0 0 0 0 16 0 0 3 1 3 7 0 1 0 0 2 19 0 3 0 0 0 0 1 0 1059 99   133 77 0 0 12 4 3 13 0 0 0 5 8 1 0 0 0 12 0 0 4 0 0 0 4 0 1 0 1 0 0   0 0 650 15 0 0 3 0 35 0 0 1 7 5 0 0 4 0 3 0 0 5 12 3 13 0 12 188 28 17 4 5 0 58 120 1 0 0 0 0 0 31 2 4 0 0 0 0 0 0   2 149 2 0 47 0 4 1 1 1 2 0 0 0 0 0 0 0 0 0 24 0 3 25 1 16 1207 2 1 7 0 6 0   0 2 2 11
254 2020-09-09 4964 3 2 9 0 3 0 0 267 3 0 8 1 1 4 2 36 0 5 3 0 0 0 0 43 0 5 0 504 0 0 15 0 0 0 0 7 0 0 0 0 30 1 202 0 0 21 0 2 2 0 0 4 0 0 0 0 25 51 19 1 0 0 0 16 0 0 0 0 38 0 0 0 0 9 0 0 1 0 0 4 28 0 2 0 1 0 11 1 0 1115 100   132 68 1 0 14 10 2 16 0 2 47 0 0 2 1 0 0 7 0 0 18 0 0 0 6 4 0 0 0 0 0   0 0 703 13 0 0 3 0 33 1 4 0 6 1 0 0 3 0 6 0 0 8 9 8 8 0 14 147 26 12 3 5 0 41 122 1 0 0 0 0 0 30 1 2 0 1 0 0 0 0   0 82 3 0 34 0 0 0 2 1 0 3 0 0 0 0 0 1 2 3 52 0 2 102 1 32 471 1 0 6 0 8 0   0 3 1 8
262 2020-09-17 5437 0 3 13 0 5 0 0 200 3 0 8 1 3 0 2 21 0 6 2 0 0 0 0 31 0 11 0 987 0 0 8 0 0 0 0 5 1 0 0 0 18 0 190 0 0 16 0 6 1 0 0 6 0 0 0 0 11 33 17 5 0 0 0 10 0 0 0 0 46 0 0 2 0 3 0 0 3 0 0 2 25 0 0 0 0 0 15 9 0 1132 135   179 82 1 0 18 12 0 12 0 0 3 10 3 3 0 0 0 7 0 0 11 0 0 0 7 1 0 0 0 0 0   0 0 300 15 0 0 3 0 38 2 7 2 8 2 0 0 0 0 3 0 0 8 6 15 11 0 14 124 69 10 3 19 0 49 132 0 0 0 0 0 0 31 1 1 0 0 0 0 0 0   0 64 5 0 162 0 0 0 0 2 7 3 0 0 0 0 0 0 2 6 63 0 2 0 1 20 865 0 0 6 0 9 0   0 1 2 0
263 2020-09-18 5319 0 5 9 0 5 0 0 319 2 1 8 0 2 0 1 36 0 4 1 0 0 0 0 33 0 12 2 829 0 0 0 0 0 0 1 7 2 0 0 0 84 0 187 0 1 17 0 2 0 0 0 7 0 2 0 0 13 33 19 0 0 0 0 15 0 0 0 0 50 0 0 0 0 7 0 0 9 0 0 2 27 0 0 0 2 0 20 6 0 1174 122   176 84 1 0 4 13 5 9 0 0 2 8 3 5 0 0 1 4 0 0 15 0 0 0 7 0 1 0 0 0 0   0 0 201 11 0 0 3 0 28 0 15 0 4 6 0 0 0 0 2 0 1 13 9 2 15 0 18 95 53 16 10 18 0 27 144 1 0 0 0 0 0 30 1 2 0 0 0 0 1 0   0 67 5 0 90 0 0 0 2 1 8 2 0 0 0 0 0 1 2 4 66 0 0 60 0 21 831 0 1 6 0 10 0   0 0 0 0
271 2020-09-26 5577 2 3 4 0 3 0 0 442 2 0 8 3 2 1 4 21 0 5 5 1 0 0 0 35 0 6 0 729 0 0 4 0 0 0 0 6 0 0 0 1 58 1 179 0 0 17 0 5 0 0 0 14 0 2 0 0 11 23 18 3 0 0 0 7 0 0 0 0 150 0 0 0 2 9 0 0 3 0 0 4 16 0 0 0 2 2 22 12 0 1089 113   207 68 0 0 27 20 3 8 0 3 0 13 1 3 0 0 0 4 0 0 17 0 0 0 9 1 0 0 0 0 2   0 0 405 12 0 0 1 0 42 2 19 0 6 16 0 0 0 0 1 0 0 0 7 5 14 0 18 99 69 23 5 8 0 42 108 2 0 0 0 0 0 26 0 1 0 0 0 0 0 0   0 29 4 0 0 0 0 0 0 4 1 2 0 0 0 0 0 0 3 11 73 0 1 70 2 34 964 0 0 3 0 10 0   0 0 0 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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