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

7 rows where Taiwan = 5

View and edit SQL

Suggested facets: Afghanistan, Algeria, Andorra, Angola, Antigua and Barbuda, Armenia, Aruba, Barbados, Belarus, Belgium, Benin, Bermuda, Bhutan, Bolivia, Bonaire Sint Eustatius and Saba, Botswana, Brazil, Burundi, Cambodia, Cameroon, Canada, Cayman Islands, Congo, Curacao, Czech Republic, Dominica, Dominican Republic, Ecuador, Egypt, Eritrea, Estonia, Faeroe Islands, French Polynesia, Gabon, Gambia, Georgia, Gibraltar, Guam, Guernsey, Guinea-Bissau, India, Indonesia, Ireland, Isle of Man, Japan, Jersey, Laos, Lebanon, Lesotho, Libya, Liechtenstein, Lithuania, Luxembourg, Macedonia, Madagascar, Malawi, Malaysia, Maldives, Mauritius, Monaco, Mongolia, Namibia, Nepal, New Zealand, Nigeria, Northern Mariana Islands, Norway, Oman, Pakistan, Philippines, Qatar, Russia, San Marino, Sao Tome and Principe, Saudi Arabia, Seychelles, Singapore, Sri Lanka, Sudan, Suriname, Tajikistan, Tanzania, Thailand, Timor, Tunisia, Turks and Caicos Islands, Uganda, United States Virgin Islands, Uruguay, Vatican, Vietnam, Yemen, 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
39 2020-02-07 3218 0   0           0   1 0 0   0     0 0                 0           0   2           3160           0       0   0     0 0 0       0         0 0       0 1     0                       0 0 0 41 0 0 0   0 0   0           0       0         0 0 0     2             0   0               0 0   0     0   0 0 0           0       0 0 0         0             2             1   0 0       0 0   5     0                 0 1 0           2          
61 2020-02-29 1860 0   0           0   2 2 1   5     0 0                 0           0   2           428           2       0   1     0 0 0       0         1 19       1 10     1                       1 0 0 0 143 1 0   4 238   20           2       0         0 0 0     2             3   1               0 1   0     0   2 0 0           0       0 2 0         0             2             909   19 0       8 4   5     2                 2 8 6           0          
104 2020-04-12 75365 34 17 64 21 0 0 0 162 46 6 51 247 67 4 42 58 1 245 1029 3 0 2 0 24 0 47 0 1089 0 0 26 36 2 2 17 1168 1 8 0 0 426 93 236   0 19 53 39 56 0 21 170 11 177 37 0 139 96 145 0 0 0 46 4 0 0 0 136 3114 0 3 5 8 2821 30 2 70 0 0 3 16 9 38 3 5 2 1 100 14 909 330   1837 39 839 25 335 4694 4 743 0 9 40 2 33 161 38 2 18 10   11 1 0 54 47 49 0 3 184 0 18 20   0 1 426 122 0 0 6 0 97 0 3 0 0 1316 0 14 0 53 13 0 76 62 250 2 260 0 1 951 352 401 515 63 216 523 1667 2 0 0 0 12 0 382 13 275 0 2 390 0 13 28   0 25 62 1 3899 2 4 0 2 395 592 6 5   0 33 0 0 3 14 5138 0 0 308 356 4313 28391 1 7 172 0 0 4     0 0 3
106 2020-04-14 65255 58 21 69 8 0 0 2 69 28 0 44 106 50 2 225 182 1 341 537 4 0 0 0 24 1 21 0 1261 0 0 10 18 0 0 0 1298 0 0 0 8 312 94 76   0 17 52 50 57 0 29 68 1 144 84 0 200 63 125 24 0 0 23 3 0 0 0 90 2673 2 0 0 15 2082 0 0 31 0 0 1 11 1 69 0 2 7 10 54 10 1211 316   1617 26 992 14 441 3153 1 390 4 2 218 11 18 66 11 0 4 2   9 1 1 8 11 26 0 3 134 0 7 6   0 0 888 50 0 0 2 0 102 6 21 0 2 964 0 8 0 19 20 0 73 214 342 0 72 0 12 0 284 260 349 6 252 333 2558 1 0 0 0 0 0 472 11 424 0 1 386 2 27 7   0 99 27 0 3116 8 10 0 1 437 279 0 5   14 34 2 1 0 19 4093 1 0 325 377 3489 25023 0 7 133 0 8 3     0 2 3
211 2020-07-28 215347 105 117 616 10 2 0 4 0 239 0 532 64 396 40 351 2772 0 119 595 0 0 0 4 2382 0 429 53 23284 0 0 194 0 17 0 0 699 21 0 0 7 2133 213 8125 0 162 612 59 24 37 0 3 192 13 109 9 0 1248 467 420 405 0 2 4 579 23 0 0 5 2551 0 205 49 8 633 655 0 34 0 0 3 0 0 47 0 19 25 465 8 7 47703 1525   2434 2553 11 0 2502 168 11 0 2 8 1526 372 496 606 548 0 1 132 59 5 280 0 11 49 128 395 69 7 67 3 1   0 0 8413 120 0 1 324 0 609 32 0 68 139 205 0 1 0 0 648 0 32 1053 936 328 1146 0 104 4920 1592 337 135 298 292 1104 5635 58 0 0 0 0 2 1993 83 411 0 0 469 20 2 5   0 7096 28 43 1828 23 39 44 109 71 65 24 5 43 0 2 0 6 1 3 919 0 13 807 264 371 56243 3 10 686 0 525 11   0 10 71 192
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
294 2020-10-19 362046 59 281 199 0 240 0 0 10561 1694 18 7 1062 647 75 331 1274 3 1306 4277 38 0 0 2 61 0 716 0 10982 0 0 395 38 6 0 0 1827 114 0 0 14 1757 17 7201 0 0 0 22 819 50 29 265 5058 46 451 7 0 422 867 127 210 0 3 26 703 2 0 0 131 29837 0 0 0 1192 4325 78 13 438 0 0 58 332 0 40 0 24 0 831 1478 57 55722 4105   3890 3110 1284 0 1014 11705 79 471 0 1520 153 685 137 663 1036 0 58 1002 0 0 945 7 252 175 427 0 5 871 32 0 0   0 0 1320 398 5 0 188 0 2721 159 1150 30 2942 8439 0 0 0 1 133 0 0 1657 433 389 638 0 709 3126 2280 8536 1856 643 204 3920 15099 3 0 0 0 0 1 348 26 214 0 3 7 4 1567 728 0 0 1662 76 25 37889 63 0 7 15 321 195 44 5 38 0 5 0 8 16 0 1815 0 135 9997 1215 16981 47843 0 30 306 0 878 8 0 0 0 64 37

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