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

6 rows where Papua New Guinea = 3

View and edit SQL

Suggested facets: Andorra, Antigua and Barbuda, Barbados, Belize, Benin, Bhutan, Botswana, British Virgin Islands, Brunei, Burkina Faso, Burundi, Cambodia, Cameroon, Cayman Islands, Central African Republic, Chad, Comoros, Curacao, Cyprus, Djibouti, Ecuador, Equatorial Guinea, Eritrea, Faeroe Islands, French Polynesia, Gabon, Ghana, Gibraltar, Grenada, Guinea-Bissau, Haiti, Iceland, Isle of Man, Jersey, Kyrgyzstan, Latvia, Lesotho, Liberia, Libya, Liechtenstein, Luxembourg, Malawi, Mali, Monaco, Mongolia, New Zealand, Nicaragua, Niger, Northern Mariana Islands, Norway, Oman, Saint Lucia, Saint Vincent and the Grenadines, Sao Tome and Principe, Senegal, Seychelles, Sierra Leone, Sint Maarten (Dutch part), Somalia, South Sudan, Spain, Sudan, Swaziland, Thailand, Timor, Turks and Caicos Islands, Vietnam, Yemen, 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
206 2020-07-23 283890 188 68 594 5 30 0 0 5344 469 0 468 140 391 25 321 2744 0 173 553 0 0 0 0 1778 0 330 0 67860 0 0 330 1 0 1 365 543 47 0 13 0 1719 135 7390 0 0 550 0 108 13 0 0 246 92 48 3 0 1246 1040 667 393 0 0 3 561 0 0 0 11 998 0 155 34 24 569 683 2 29 0 0 2 906 0 95 0 11 21 757 14 1 45720 1882   2586 2706 17 0 2043 280 7 726 0 7 1646 637 409 751 967 0 4 124 0 6 88 0 11 129 135 614 153 16 59 17 2   0 0 8276 356 1 0 17 0 220 21 2 36 150 168 0 0 0 9 543 0 15 1660 1763 357 753 3 183 4463 1505 380 252 98 441 1030 5862 34 0 0 0 0 1 2331 136 426 0 4 310 2 37 38   26 13150 59 0 2615 22 0 45 44 297 141 21 0 48 0 8 0 16 2 5 902 4 3 829 236 751 68848 16 21 360 0 0 7   0 11 257 214
219 2020-08-05 256810 82 130 532 2 0 0 0 4824 196 8 411 131 226 36 297 1918 0 84 813 15 109 0 2 1515 0 562 0 51603 0 0 204 3 0 3 463 760 48 0 4 2 1469 107 7129 2 0 435 73 22 31 0 25 278 45 77 8 0 1178 922 112 419 0 0 11 588 2 0 0 17 1039 0 0 173 15 741 0 1 118 0 0 14 823 0 125 51 23 21 505 9 3 52509 1922   2751 2836 45 0 1739 190 15 1271 4 6 2861 605 225 475 569 0 3 0 8 2 0 0 17 53 0 235 74 1 153 0 16   59 0 7286 332 2 0 60 0 1021 56 1 64 259 540 0 2 230 0 304 0 65 0 675 604 968 3 128 6790 6263 680 112 533 216 1232 5159 7 0 0 0 0 1 1342 46 287 12 7 295 6 14 9   0 4456 33 8 2953 6 42 88 18 333 130 45 0 45 0 7 1 12 12 19 1083 0 8 1061 189 670 57525 24 9 764 0 1232 20   0 22 0 146
256 2020-09-11 305692 28 156 272 0 59 0 0 12259 174 89 48 497 142 0 672 1892 0 189 1143 34 0 0 4 860 0 286 126 40557 0 0 163 10 3 0 161 630 84 1 11 3 1642 27 7808 0 0 1325 54 291 92 15 3 1377 19 317 3 0 779 1040 154 86 5 20 15 878 0 0 0 39 9843 0 0 37 87 1484 0 1 372 0 0 88 684 0 61 0 47 45 205 476 4 96551 3861   2063 4597 196 0 3960 1597 74 680 -6 80 430 143 69 740 0 0 5 560 0 2 477 0 36 65 67 104 2 45 66 11 42   38 0 5482 560 4 1 128 0 1889 68 256 148 1246 823 0 1 0 0 197 0 122 398 516 1000 673 3 605 7291 3804 506 585 772 206 1380 5363 19 0 0 0 0 3 708 48 58 0 2 63 0 133 76   0 2007 176 3 12183 8 0 30 58 255 405 65 0 40 0 7 0 9 110 465 1512 10 190 3144 930 2919 37507 4 18 767 0 1072 0   0 4 102 24
258 2020-09-13 284136 35 164 255 0 62 0 0 11505 172 96 42 495 135 114 632 1282 0 191 617 23 0 0 3 810 0 300 0 33523 2 0 92 15 2 1 0 515 60 0 0 2 2131 23 6876 0 0 1485 71 261 60 10 3 1541 24 0 0 0 860 1719 148 77 6 0 23 521 2 0 0 45 10561 0 0 14 0 948 46 4 302 0 0 28 649 0 41 0 49 21 1087 916 1 94372 3817   2139 4106 159 0 4653 1501 112 674 0 117 420 176 70 736 53 0 5 686 0 1 440 0 53 0 141 68 9 58 62 4 27   44 0 2669 531 1 0 145 0 2238 122 351 167 1201 1231 0 2 0 0 160 1 0 0 526 650 711 3 812 6162 4899 603 497 511 236 1311 5488 31 0 0 0 0 0 643 44 72 2 9 42 2 201 105   0 1816 121 10 0 27 33 50 25 206 465 30 0 37 0 7 0 7 168 376 1509 3 326 3103 1007 3497 40820 19 7 544 0 967 0   0 4 143 29
290 2020-10-15 388352 32 203 185 195 192 0 1 14932 0 26 24 1606 369 222 349 1684 5 597 12248 34 67 0 3 219 0 482 0 27235 0 1 819 0 0 0 108 2506 117 4 0 8 1092 11 6061 0 0 1542 34 748 18 26 83 9543 63 492 12 0 654 912 128 286 2 0 39 712 1 0 0 204 22591 322 9 8 680 6638 0 17 435 0 0 75 714 0 54 0 24 21 606 950 89 67708 4127   4830 3857 1084 2 1979 7332 79 570 4 2423 110 604 80 532 388 0 102 1377 28 1 836 0 139 190 443 0 2 660 69 56 111   11 0 2640 1149 7 0 193 0 3387 134 888 69 2638 7271 0 2 0 2 179 0 152 563 755 532 832 3 648 2977 1823 6526 2072 976 198 4016 14231 32 0 2 0 0 0 501 24 245 0 6 5 10 1410 707   0 1877 99 0 13318 132 0 11 19 968 2724 57 0 39 0 13 0 11 27 2234 1671 0 124 5590 1431 19724 59386 0 1 316 0 614 9   0 1 29 19
293 2020-10-18 369451 68 273 215 0 126 0 7 13510 1540 15 12 2040 528 111 246 1209 0 0 7817 47 0 0 9 148 0 0 0 24062 0 0 603 0 5 0 0 2215 112 0 0 4 1813 30 7017 0 0 1166 26 1096 52 17 0 8715 6 500 3 0 475 763 138 191 0 0 35 600 1 0 0 160 32427 62 0 0 958 5587 59 14 482 0 2 0 597 0 116 0 38 0 903 1474 69 61871 4301   4103 3221 1251 0 936 10925 63 593 0 1505 301 616 148 739 0 0 188 1171 0 0 0 22 228 0 594 56 10 869 24 11 0   18 0 2800 792 5 4 146 0 3763 95 1387 48 3167 8105 0 3 0 0 113 6 0 0 567 312 609 3 533 3132 2588 9622 2153 238 235 3952 14922 6 0 1 2 0 0 359 24 227 0 2 3 3 1968 898 0 0 1928 91 0 0 121 0 10 19 697 0 46 0 41 0 7 0 22 40 5752 1723 1 121 6410 1538 16171 56611 6 51 540 0 289 2 0 0 2 130 11

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