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

7 rows where Turks and Caicos Islands = 4

View and edit SQL

Suggested facets: Andorra, Antigua and Barbuda, Aruba, Benin, Bermuda, Bhutan, Bonaire Sint Eustatius and Saba, Bosnia and Herzegovina, Botswana, British Virgin Islands, Burundi, Cambodia, Cameroon, Cayman Islands, Central African Republic, Comoros, Congo, Cuba, Curacao, Democratic Republic of Congo, Djibouti, Equatorial Guinea, Eritrea, Faeroe Islands, French Polynesia, Gabon, Gibraltar, Guernsey, Guinea-Bissau, Iceland, Iraq, Jersey, Kyrgyzstan, Latvia, Lesotho, Liberia, Liechtenstein, Maldives, Mali, Malta, Mauritania, Mauritius, Monaco, Mongolia, New Zealand, Nicaragua, Niger, Northern Mariana Islands, Papua New Guinea, Saint Lucia, Saint Vincent and the Grenadines, Sao Tome and Principe, Seychelles, Sint Maarten (Dutch part), Somalia, South Korea, South Sudan, Sri Lanka, Sudan, Suriname, Swaziland, Taiwan, Tajikistan, Thailand, Togo, Tunisia, United States Virgin Islands, 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
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
207 2020-07-24 275841 13 108 612 0 33 0 0 5782 451 0 410 164 347 55 359 2856 0 167 439 4 92 0 0 1117 1 344 164 59961 0 0 269 9 17 4 186 432 36 0 16 26 2357 139 7945 3 187 768 470 104 4 0 5 230 94 40 1 0 1572 891 668 402 0 10 2 452 0 0 0 10 1062 0 0 24 31 815 694 2 33 0 0 5 1057 0 59 0 1 30 800 18 1 49310 1906   2621 2361 7 0 1897 306 0 927 0 11 1687 796 181 687 921 0 6 156 0 3 138 0 0 98 122 219 84 9 0 0 1   104 0 7988 307 1 1 324 0 302 25 0 120 147 163 0 1 0 2 604 0 9 1099 1209 602 911 1 113 4546 2121 418 229 435 373 1112 5848 21 0 1 2 0 2 2238 145 412 0 21 354 3 31 18   10 13104 41 28 2255 1 110 58 83 220 117 23 3 45 0 10 0 22 0 12 913 4 0 856 254 773 63196 0 24 455 0 839 4   0 14 0 90
263 2020-09-18 318186 0 132 228 45 180 0 0 11674 295 54 34 922 119 90 841 1593 0 224 1750 31 0 0 6 547 4 394 104 36303 3 0 154 19 1 0 68 1120 85 0 0 25 1863 44 7568 10 46 1302 26 250 57 18 10 3123 41 822 2 0 615 732 141 86 0 0 22 689 1 0 0 49 10593 55 0 33 182 1916 59 9 359 0 0 79 740 0 0 0 69 15 460 941 17 96424 3635   2815 4326 224 0 5165 1583 223 485 2 279 320 275 43 825 91 0 8 685 0 1 886 0 62 147 186 0 10 21 67 0 35   13 0 6000 622 5 0 212 0 2488 167 405 114 1246 1750 0 0 0 0 131 1 106 557 752 966 672 0 694 5698 3355 837 770 13 244 1679 5762 19 0 0 0 0 0 593 50 82 1 0 18 8 161 98   0 2128 126 5 14389 5 0 26 36 389 530 37 0 43 0 7 0 10 107 470 1648 4 114 3584 786 3395 43567 0 20 609 0 868 3   0 3 41 35
264 2020-09-19 311968 47 125 219 81 40 0 0 12701 239 78 48 821 117 37 705 1541 0 243 1709 23 0 0 6 632 0 292 0 39797 0 0 189 30 0 0 0 1044 78 1 4 32 1677 14 6526 3 0 1556 42 234 71 18 7 2107 14 454 2 0 596 1872 131 97 2 0 36 602 1 0 0 59 13215 19 18 12 187 2297 143 0 338 0 0 0 680 1 77 28 75 44 491 809 24 93337 3891   3049 4305 248 0 2138 1907 197 579 2 213 300 148 57 704 91 0 4 750 0 1 616 1 61 177 143 100 5 95 74 25 38   29 1 5551 665 5 0 208 0 2760 103 322 129 2020 1972 0 2 0 2 221 0 146 0 645 692 741 0 1014 6314 3237 757 780 817 224 1527 5905 18 0 0 0 0 1 576 27 62 0 20 11 9 235 137   0 2055 110 10 0 5 0 20 24 437 487 40 3 45 0 3 0 22 217 0 1771 4 214 3228 865 4322 50209 4 14 259 0 890 2   0 1 94 14
268 2020-09-23 282710 71 131 191 0 119 0 0 12027 115 78 30 747 98 49 713 1557 0 206 2074 34 0 0 0 467 8 221 0 33536 0 0 109 11 0 0 0 1248 24 0 9 2 1055 18 7102 0 0 1087 16 144 81 9 15 2394 4 476 3 0 486 932 113 156 0 0 35 713 11 0 0 149 10008 0 0 0 227 1769 54 5 333 0 0 43 942 0 43 0 35 9 231 951 42 83347 4071   3712 4724 323 0 795 1391 129 330 2 634 440 139 66 719 88 0 34 865 0 0 650 2 45 100 87 63 4 82 48 6 38   0 0 5939 650 2 0 296 0 2227 202 488 81 1356 2243 0 4 112 4 176 0 104 660 532 557 474 1 568 3650 1599 711 463 120 313 1059 6215 16 0 0 0 0 0 552 21 61 0 6 21 3 175 88   0 1346 110 11 11289 14 23 19 25 438 284 44 0 44 0 3 0 14 81 0 1692 4 244 2884 852 4926 38307 9 7 560 0 1010 0   0 2 214 5
269 2020-09-24 311481 25 121 186 72 0 0 1 12638 210 56 31 661 146 151 650 1666 0 253 2096 37 31 1 0 537 5 344 0 33281 0 0 160 22 2 0 92 1090 131 0 0 9 1380 10 6731 0 3 1370 87 204 48 10 36 2306 14 558 0 0 468 2249 121 0 0 0 57 661 3 0 0 93 13072 0 12 2 259 2143 37 2 358 0 0 45 819 0 47 0 98 13 369 750 57 86508 4465   3605 5055 231 0 11316 1640 122 273 1 363 307 130 62 616 127 0 12 940 0 1 651 1 73 74 182 31 9 147 67 4 42   41 0 5495 786 2 0 290 0 2397 148 868 56 1172 2351 0 3 0 0 111 0 152 628 799 503 706 4 743 6149 2802 974 802 55 258 1767 6431 41 0 0 0 0 0 561 36 81 0 9 12 22 338 136   0 1906 125 0 10653 11 0 20 36 553 436 47 0 43 0 2 0 18 110 1219 1767 4 167 3497 1083 6178 37930 12 12 616 0 986 1   0 0 54 14
275 2020-09-30 293940 15 127 155 0 108 0 0 13477 327 62 19 722 58 65 574 1488 0 314 2984 52 0 0 1 333 0 225 0 32058 0 0 276 4 4 0 0 1660 83 0 19 8 1629 23 5839 1 0 890 28 135 48 6 30 1960 6 392 6 0 234 784 124 172 2 0 48 640 3 0 0 158 8051 0 0 10 0 1798 0 9 416 0 0 53 705 0 36 0 59 7 561 894 32 80472 4002   3677 4724 362 0 3661 1647 239 516 1 823 374 210 54 587 147 0 32 1105 11 1 801 2 88 55 112 29 2 101 37 0 29   10 14 5741 835 2 0 134 0 2076 268 794 19 1513 3001 0 1 97 0 187 0 90 528 747 420 576 2 669 3054 2015 1326 688 1045 222 1470 8232 4 0 0 0 0 0 539 26 65 0 7 27 14 231 93   0 903 113 8 11016 11 0 27 10 613 223 46 1 41 0 5 0 10 77 1291 1427 4 240 3627 995 7143 43017 0 23 451 0 835 17   0 0 55 21

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