new_cases
Data license: ODbL · Data source: our world in data github owid/covid-19-data repository
3 rows where Turks and Caicos Islands = 6
This data as json, copyable, CSV (advanced)
Suggested facets: Antigua and Barbuda, Aruba, Barbados, Benin, Bermuda, Bhutan, Botswana, Cameroon, Central African Republic, Chad, Comoros, Curacao, Denmark, Estonia, Faeroe Islands, France, Gabon, Gambia, Hungary, Iceland, Lesotho, Liechtenstein, Mongolia, Niger, Norway, Papua New Guinea, Saint Vincent and the Grenadines, San Marino, Seychelles, Somalia, United States Virgin Islands, Vietnam, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192 | 192 | 2020-07-09 | 215912 | 59 | 68 | 469 | 0 | 33 | 0 | 3 | 2979 | 526 | 0 | 131 | 101 | 542 | 2 | 610 | 3489 | 0 | 221 | 137 | 0 | 86 | 1 | 0 | 1439 | 0 | 250 | 0 | 44571 | 0 | 0 | 240 | 2 | 0 | 0 | 0 | 267 | 43 | 0 | 38 | 0 | 2064 | 33 | 4144 | 0 | 264 | 350 | 538 | 53 | 4 | 0 | 3 | 129 | 77 | 12 | 11 | 0 | 1158 | 976 | 1025 | 259 | 0 | 0 | 8 | 108 | 0 | 0 | 2 | 7 | 663 | 0 | 128 | 2 | 5 | 442 | 854 | 0 | 33 | 0 | 0 | 6 | 624 | 0 | 0 | 0 | 0 | 54 | 550 | 5 | 0 | 24879 | 1853 | 2691 | 2741 | 4 | 0 | 1335 | 193 | 6 | 197 | 0 | 0 | 1962 | 278 | 183 | 762 | 361 | 0 | 7 | 39 | 0 | 9 | 0 | 0 | 10 | 47 | 161 | 101 | 52 | 3 | 16 | 10 | 0 | 145 | 0 | 7401 | 330 | 0 | 7 | 53 | 0 | 442 | 31 | 2 | 54 | 459 | 52 | 0 | 3 | 0 | 3 | 460 | 0 | 11 | 1210 | 3359 | 475 | 960 | 0 | 52 | 3633 | 2486 | 277 | 443 | 190 | 608 | 555 | 6562 | 22 | 0 | 0 | 0 | 1 | 0 | 3036 | 110 | 357 | 10 | 12 | 158 | 0 | 31 | 24 | 13 | 8810 | 49 | 8 | 543 | 13 | 87 | 51 | 82 | 533 | 129 | 0 | 0 | 49 | 0 | 5 | 0 | 6 | 0 | 16 | 1041 | 6 | 6 | 807 | 445 | 597 | 58906 | 22 | 9 | 421 | 0 | 317 | 0 | 0 | 21 | 0 | 98 | ||||
| 196 | 196 | 2020-07-13 | 194193 | 0 | 83 | 483 | 0 | 23 | 0 | 0 | 3449 | 182 | 0 | 244 | 52 | 520 | 0 | 471 | 2666 | 0 | 165 | 43 | 0 | 0 | 0 | 2 | 987 | 0 | 164 | 85 | 24831 | 0 | 0 | 77 | 3 | 0 | 0 | 257 | 244 | 107 | 0 | 0 | 6 | 3012 | 46 | 5083 | 0 | 75 | 365 | 323 | 50 | 6 | 0 | 7 | 59 | 62 | 0 | 17 | 0 | 1418 | 661 | 912 | 283 | 0 | 0 | 0 | 158 | 0 | 0 | 5 | 2 | 0 | 0 | 0 | 0 | 9 | 159 | 270 | 0 | 31 | 0 | 0 | 0 | 757 | 0 | 97 | 0 | 6 | 37 | 507 | 5 | 0 | 28701 | 1681 | 2186 | 2312 | 17 | 0 | 1207 | 234 | 0 | 366 | 0 | 3 | 1636 | 379 | 216 | 836 | 488 | 0 | 0 | 166 | 49 | 12 | 44 | 0 | 4 | 83 | 144 | 289 | 103 | 14 | 67 | 5 | 0 | 0 | 0 | 3176 | 174 | 0 | 0 | 57 | 0 | 203 | 22 | 1 | 117 | 82 | 101 | 0 | 0 | 0 | 0 | 571 | 0 | 0 | 1318 | 2753 | 341 | 1301 | 0 | 128 | 3616 | 2037 | 370 | 291 | 288 | 470 | 456 | 6615 | 38 | 0 | 0 | 6 | 0 | 2 | 2779 | 121 | 287 | 0 | 17 | 178 | 0 | 8 | 14 | 8 | 12058 | 62 | 10 | 2045 | 106 | 0 | 0 | 40 | 106 | 85 | 0 | 0 | 46 | 0 | 3 | 0 | 2 | 0 | 18 | 1012 | 6 | 12 | 678 | 401 | 442 | 57258 | 0 | 1 | 680 | 0 | 287 | 2 | 0 | 76 | 0 | 3 | ||||
| 203 | 203 | 2020-07-20 | 213628 | 174 | 82 | 535 | 0 | 18 | 0 | 0 | 3223 | 104 | 5 | 361 | 63 | 388 | 15 | 418 | 2459 | 1 | 142 | 64 | 0 | 0 | 0 | 2 | 1444 | 0 | 288 | 0 | 23529 | 0 | 0 | 95 | 13 | 0 | 0 | 0 | 680 | 29 | 0 | 0 | 0 | 2084 | 130 | 6578 | 6 | 0 | 563 | 207 | 119 | 1 | 2 | 1 | 90 | 79 | 0 | 8 | 0 | 1336 | 631 | 603 | 338 | 0 | 0 | 0 | 356 | 3 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 249 | 607 | 0 | 24 | 0 | 0 | 4 | 635 | 0 | 53 | 0 | 9 | 0 | 1042 | 18 | 1 | 40425 | 1639 | 2182 | 2310 | 10 | 0 | 924 | 218 | 16 | 454 | 0 | 4 | 1499 | 603 | 118 | 300 | 611 | 0 | 3 | 84 | 0 | 3 | 75 | 1 | 17 | 74 | 123 | 200 | 85 | 15 | 36 | 3 | 0 | 427 | 0 | 3389 | 186 | 0 | 0 | 107 | 0 | 221 | 56 | 0 | 44 | 156 | 144 | 0 | 1 | 0 | 0 | 556 | 0 | 0 | 1157 | 1587 | 465 | 1207 | 2 | 92 | 4090 | 2152 | 358 | 246 | 610 | 340 | 767 | 6109 | 43 | 0 | 0 | 6 | 0 | 3 | 2504 | 141 | 396 | 0 | 10 | 257 | 0 | 3 | 6 | 8 | 13449 | 26 | 9 | 4581 | 20 | 80 | 28 | 64 | 110 | 98 | 0 | 0 | 44 | 0 | 1 | 0 | 8 | 0 | 26 | 924 | 6 | 3 | 731 | 211 | 493 | 61796 | 0 | 10 | 537 | 0 | 408 | 0 | 0 | 25 | 0 | 133 |
Advanced export
JSON shape: default, array, newline-delimited
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 );