Here is our auto-generated table:
MySQL query generator demo
| Code | Name | Surface Area | Population | CountryCode | Language |
|---|---|---|---|---|---|
| ABW | Aruba | 193 | 103,000 | ABW | Dutch |
| AFG | Afghanistan | 652,090 | 22,720,000 | AFG | Dari |
| AFG | Afghanistan | 652,090 | 22,720,000 | AFG | Pashto |
| AGO | Angola | 1,246,700 | 12,878,000 | ||
| AIA | Anguilla | 96 | 8,000 | AIA | English |
| ALB | Albania | 28,748 | 3,401,200 | ALB | Albaniana |
| AND | Andorra | 468 | 78,000 | AND | Catalan |
| ANT | Netherlands Antilles | 800 | 217,000 | ANT | Dutch |
| ANT | Netherlands Antilles | 800 | 217,000 | ANT | Papiamento |
| ARE | United Arab Emirates | 83,600 | 2,441,000 | ARE | Arabic |
| ARG | Argentina | 2,780,400 | 37,032,000 | ARG | Spanish |
| ARM | Armenia | 29,800 | 3,520,000 | ARM | Armenian |
| ASM | American Samoa | 199 | 68,000 | ASM | English |
| ASM | American Samoa | 199 | 68,000 | ASM | Samoan |
| ATA | Antarctica | 13,120,000 | 0 | ||
| ATF | French Southern territories | 7,780 | 0 | ||
| ATG | Antigua and Barbuda | 442 | 68,000 | ATG | English |
| AUS | Australia | 7,741,220 | 18,886,000 | AUS | English |
| AUT | Austria | 83,859 | 8,091,800 | AUT | German |
| AZE | Azerbaijan | 86,600 | 7,734,000 | AZE | Azerbaijani |
| BDI | Burundi | 27,834 | 6,695,000 | BDI | French |
| BDI | Burundi | 27,834 | 6,695,000 | BDI | Kirundi |
| BEL | Belgium | 30,518 | 10,239,000 | BEL | Dutch |
| BEL | Belgium | 30,518 | 10,239,000 | BEL | French |
| BEL | Belgium | 30,518 | 10,239,000 | BEL | German |
| BEN | Benin | 112,622 | 6,097,000 | ||
| BFA | Burkina Faso | 274,000 | 11,937,000 | ||
| BGD | Bangladesh | 143,998 | 129,155,000 | BGD | Bengali |
| BGR | Bulgaria | 110,994 | 8,190,900 | BGR | Bulgariana |
| BHR | Bahrain | 694 | 617,000 | BHR | Arabic |
| BHS | Bahamas | 13,878 | 307,000 | ||
| BIH | Bosnia and Herzegovina | 51,197 | 3,972,000 | BIH | Serbo-Croatian |
| BLR | Belarus | 207,600 | 10,236,000 | BLR | Belorussian |
| BLR | Belarus | 207,600 | 10,236,000 | BLR | Russian |
| BLZ | Belize | 22,696 | 241,000 | BLZ | English |
| BMU | Bermuda | 53 | 65,000 | BMU | English |
| BOL | Bolivia | 1,098,581 | 8,329,000 | BOL | Aimará |
| BOL | Bolivia | 1,098,581 | 8,329,000 | BOL | Ketšua |
| BOL | Bolivia | 1,098,581 | 8,329,000 | BOL | Spanish |
| BRA | Brazil | 8,547,403 | 170,115,000 | BRA | Portuguese |
| BRB | Barbados | 430 | 270,000 | BRB | English |
| BRN | Brunei | 5,765 | 328,000 | BRN | Malay |
| BTN | Bhutan | 47,000 | 2,124,000 | BTN | Dzongkha |
| BVT | Bouvet Island | 59 | 0 | ||
| BWA | Botswana | 581,730 | 1,622,000 | ||
| CAF | Central African Republic | 622,984 | 3,615,000 | ||
| CAN | Canada | 9,970,610 | 31,147,000 | CAN | English |
| CAN | Canada | 9,970,610 | 31,147,000 | CAN | French |
| CCK | Cocos (Keeling) Islands | 14 | 600 | CCK | English |
| CHE | Switzerland | 41,284 | 7,160,400 | CHE | French |
| CHE | Switzerland | 41,284 | 7,160,400 | CHE | German |
| CHE | Switzerland | 41,284 | 7,160,400 | CHE | Italian |
| CHE | Switzerland | 41,284 | 7,160,400 | CHE | Romansh |
| CHL | Chile | 756,626 | 15,211,000 | CHL | Spanish |
| CHN | China | 9,572,900 | 1,277,558,000 | CHN | Chinese |
| CIV | Côte d’Ivoire | 322,463 | 14,786,000 | ||
| CMR | Cameroon | 475,442 | 15,085,000 | ||
| COD | Congo, The Democratic Republic of the | 2,344,858 | 51,654,000 | ||
| COG | Congo | 342,000 | 2,943,000 | ||
| COK | Cook Islands | 236 | 20,000 | COK | Maori |
| COL | Colombia | 1,138,914 | 42,321,000 | COL | Spanish |
| COM | Comoros | 1,862 | 578,000 | COM | Comorian |
| CPV | Cape Verde | 4,033 | 428,000 | CPV | Portuguese |
| CRI | Costa Rica | 51,100 | 4,023,000 | CRI | Spanish |
| CUB | Cuba | 110,861 | 11,201,000 | CUB | Spanish |
| CXR | Christmas Island | 135 | 2,500 | CXR | English |
| CYM | Cayman Islands | 264 | 38,000 | CYM | English |
| CYP | Cyprus | 9,251 | 754,700 | CYP | Greek |
| CYP | Cyprus | 9,251 | 754,700 | CYP | Turkish |
| CZE | Czech Republic | 78,866 | 10,278,100 | CZE | Czech |
| DEU | Germany | 357,022 | 82,164,700 | DEU | German |
| DJI | Djibouti | 23,200 | 638,000 | DJI | Arabic |
| DMA | Dominica | 751 | 71,000 | ||
| DNK | Denmark | 43,094 | 5,330,000 | DNK | Danish |
| DOM | Dominican Republic | 48,511 | 8,495,000 | DOM | Spanish |
| DZA | Algeria | 2,381,741 | 31,471,000 | DZA | Arabic |
| ECU | Ecuador | 283,561 | 12,646,000 | ECU | Spanish |
| EGY | Egypt | 1,001,449 | 68,470,000 | EGY | Arabic |
| ERI | Eritrea | 117,600 | 3,850,000 | ERI | Tigrinja |
| ESH | Western Sahara | 266,000 | 293,000 | ESH | Arabic |
| ESP | Spain | 505,992 | 39,441,700 | ESP | Spanish |
| EST | Estonia | 45,227 | 1,439,200 | EST | Estonian |
| ETH | Ethiopia | 1,104,300 | 62,565,000 | ||
| FIN | Finland | 338,145 | 5,171,300 | FIN | Finnish |
| FIN | Finland | 338,145 | 5,171,300 | FIN | Swedish |
| FJI | Fiji Islands | 18,274 | 817,000 | FJI | Fijian |
| FLK | Falkland Islands | 12,173 | 2,000 | FLK | English |
| FRA | France | 551,500 | 59,225,700 | FRA | French |
| FRO | Faroe Islands | 1,399 | 43,000 | FRO | Danish |
| FRO | Faroe Islands | 1,399 | 43,000 | FRO | Faroese |
| FSM | Micronesia, Federated States of | 702 | 119,000 | ||
| GAB | Gabon | 267,668 | 1,226,000 | ||
| GBR | United Kingdom | 242,900 | 59,623,400 | GBR | English |
| GEO | Georgia | 69,700 | 4,968,000 | GEO | Georgiana |
| GHA | Ghana | 238,533 | 20,212,000 | ||
| GIB | Gibraltar | 6 | 25,000 | GIB | English |
| GIN | Guinea | 245,857 | 7,430,000 | ||
| GLP | Guadeloupe | 1,705 | 456,000 | GLP | French |
| GMB | Gambia | 11,295 | 1,305,000 | ||
| GNB | Guinea-Bissau | 36,125 | 1,213,000 | GNB | Portuguese |
| GNQ | Equatorial Guinea | 28,051 | 453,000 | ||
| GRC | Greece | 131,626 | 10,545,700 | GRC | Greek |
| GRD | Grenada | 344 | 94,000 | ||
| GRL | Greenland | 2,166,090 | 56,000 | GRL | Danish |
| GRL | Greenland | 2,166,090 | 56,000 | GRL | Greenlandic |
| GTM | Guatemala | 108,889 | 11,385,000 | GTM | Spanish |
| GUF | French Guiana | 90,000 | 181,000 | ||
| GUM | Guam | 549 | 168,000 | GUM | Chamorro |
| GUM | Guam | 549 | 168,000 | GUM | English |
| GUY | Guyana | 214,969 | 861,000 | ||
| HKG | Hong Kong | 1,075 | 6,782,000 | HKG | English |
| HMD | Heard Island and McDonald Islands | 359 | 0 | ||
| HND | Honduras | 112,088 | 6,485,000 | HND | Spanish |
| HRV | Croatia | 56,538 | 4,473,000 | HRV | Serbo-Croatian |
| HTI | Haiti | 27,750 | 8,222,000 | HTI | French |
| HUN | Hungary | 93,030 | 10,043,200 | HUN | Hungarian |
| IDN | Indonesia | 1,904,569 | 212,107,000 | IDN | Malay |
| IND | India | 3,287,263 | 1,013,662,000 | IND | Hindi |
| IOT | British Indian Ocean Territory | 78 | 0 | ||
| IRL | Ireland | 70,273 | 3,775,100 | IRL | English |
| IRL | Ireland | 70,273 | 3,775,100 | IRL | Irish |
| IRN | Iran | 1,648,195 | 67,702,000 | IRN | Persian |
| IRQ | Iraq | 438,317 | 23,115,000 | IRQ | Arabic |
| ISL | Iceland | 103,000 | 279,000 | ISL | Icelandic |
| ISR | Israel | 21,056 | 6,217,000 | ISR | Arabic |
| ISR | Israel | 21,056 | 6,217,000 | ISR | Hebrew |
| ITA | Italy | 301,316 | 57,680,000 | ITA | Italian |
| JAM | Jamaica | 10,990 | 2,583,000 | ||
| JOR | Jordan | 88,946 | 5,083,000 | JOR | Arabic |
| JPN | Japan | 377,829 | 126,714,000 | JPN | Japanese |
| KAZ | Kazakstan | 2,724,900 | 16,223,000 | KAZ | Kazakh |
| KEN | Kenya | 580,367 | 30,080,000 | ||
| KGZ | Kyrgyzstan | 199,900 | 4,699,000 | KGZ | Kirgiz |
| KGZ | Kyrgyzstan | 199,900 | 4,699,000 | KGZ | Russian |
| KHM | Cambodia | 181,035 | 11,168,000 | KHM | Khmer |
| KIR | Kiribati | 726 | 83,000 | KIR | Kiribati |
| KNA | Saint Kitts and Nevis | 261 | 38,000 | KNA | English |
| KOR | South Korea | 99,434 | 46,844,000 | KOR | Korean |
| KWT | Kuwait | 17,818 | 1,972,000 | KWT | Arabic |
| LAO | Laos | 236,800 | 5,433,000 | LAO | Lao |
| LBN | Lebanon | 10,400 | 3,282,000 | LBN | Arabic |
| LBR | Liberia | 111,369 | 3,154,000 | ||
| LBY | Libyan Arab Jamahiriya | 1,759,540 | 5,605,000 | LBY | Arabic |
| LCA | Saint Lucia | 622 | 154,000 | LCA | English |
| LIE | Liechtenstein | 160 | 32,300 | LIE | German |
| LKA | Sri Lanka | 65,610 | 18,827,000 | LKA | Singali |
| LKA | Sri Lanka | 65,610 | 18,827,000 | LKA | Tamil |
| LSO | Lesotho | 30,355 | 2,153,000 | LSO | English |
| LSO | Lesotho | 30,355 | 2,153,000 | LSO | Sotho |
| LTU | Lithuania | 65,301 | 3,698,500 | LTU | Lithuanian |
| LUX | Luxembourg | 2,586 | 435,700 | LUX | French |
| LUX | Luxembourg | 2,586 | 435,700 | LUX | German |
| LUX | Luxembourg | 2,586 | 435,700 | LUX | Luxembourgish |
| LVA | Latvia | 64,589 | 2,424,200 | LVA | Latvian |
| MAC | Macao | 18 | 473,000 | MAC | Portuguese |
| MAR | Morocco | 446,550 | 28,351,000 | MAR | Arabic |
| MCO | Monaco | 1 | 34,000 | MCO | French |
| MDA | Moldova | 33,851 | 4,380,000 | MDA | Romanian |
| MDG | Madagascar | 587,041 | 15,942,000 | MDG | French |
| MDG | Madagascar | 587,041 | 15,942,000 | MDG | Malagasy |
| MDV | Maldives | 298 | 286,000 | MDV | Dhivehi |
| MEX | Mexico | 1,958,201 | 98,881,000 | MEX | Spanish |
| MHL | Marshall Islands | 181 | 64,000 | MHL | English |
| MHL | Marshall Islands | 181 | 64,000 | MHL | Marshallese |
| MKD | Macedonia | 25,713 | 2,024,000 | MKD | Macedonian |
| MLI | Mali | 1,240,192 | 11,234,000 | ||
| MLT | Malta | 316 | 380,200 | MLT | English |
| MLT | Malta | 316 | 380,200 | MLT | Maltese |
| MMR | Myanmar | 676,578 | 45,611,000 | MMR | Burmese |
| MNG | Mongolia | 1,566,500 | 2,662,000 | MNG | Mongolian |
| MNP | Northern Mariana Islands | 464 | 78,000 | MNP | English |
| MOZ | Mozambique | 801,590 | 19,680,000 | ||
| MRT | Mauritania | 1,025,520 | 2,670,000 | ||
| MSR | Montserrat | 102 | 11,000 | MSR | English |
| MTQ | Martinique | 1,102 | 395,000 | MTQ | French |
| MUS | Mauritius | 2,040 | 1,158,000 | ||
| MWI | Malawi | 118,484 | 10,925,000 | MWI | Chichewa |
| MYS | Malaysia | 329,758 | 22,244,000 | MYS | Malay |
| MYT | Mayotte | 373 | 149,000 | MYT | French |
| NAM | Namibia | 824,292 | 1,726,000 | ||
| NCL | New Caledonia | 18,575 | 214,000 | NCL | French |
| NER | Niger | 1,267,000 | 10,730,000 | ||
| NFK | Norfolk Island | 36 | 2,000 | NFK | English |
| NGA | Nigeria | 923,768 | 111,506,000 | ||
| NIC | Nicaragua | 130,000 | 5,074,000 | NIC | Spanish |
| NIU | Niue | 260 | 2,000 | NIU | English |
| NLD | Netherlands | 41,526 | 15,864,000 | NLD | Dutch |
| NOR | Norway | 323,877 | 4,478,500 | NOR | Norwegian |
| NPL | Nepal | 147,181 | 23,930,000 | NPL | Nepali |
| NRU | Nauru | 21 | 12,000 | NRU | English |
| NRU | Nauru | 21 | 12,000 | NRU | Nauru |
| NZL | New Zealand | 270,534 | 3,862,000 | NZL | English |
| OMN | Oman | 309,500 | 2,542,000 | OMN | Arabic |
| PAK | Pakistan | 796,095 | 156,483,000 | PAK | Urdu |
| PAN | Panama | 75,517 | 2,856,000 | PAN | Spanish |
| PCN | Pitcairn | 49 | 50 | ||
| PER | Peru | 1,285,216 | 25,662,000 | PER | Aimará |
| PER | Peru | 1,285,216 | 25,662,000 | PER | Ketšua |
| PER | Peru | 1,285,216 | 25,662,000 | PER | Spanish |
| PHL | Philippines | 300,000 | 75,967,000 | PHL | Pilipino |
| PLW | Palau | 459 | 19,000 | PLW | English |
| PLW | Palau | 459 | 19,000 | PLW | Palau |
| PNG | Papua New Guinea | 462,840 | 4,807,000 | ||
| POL | Poland | 323,250 | 38,653,600 | POL | Polish |
| PRI | Puerto Rico | 8,875 | 3,869,000 | PRI | Spanish |
| PRK | North Korea | 120,538 | 24,039,000 | PRK | Korean |
| PRT | Portugal | 91,982 | 9,997,600 | PRT | Portuguese |
| PRY | Paraguay | 406,752 | 5,496,000 | PRY | Guaraní |
| PRY | Paraguay | 406,752 | 5,496,000 | PRY | Spanish |
| PSE | Palestine | 6,257 | 3,101,000 | ||
| PYF | French Polynesia | 4,000 | 235,000 | PYF | French |
| QAT | Qatar | 11,000 | 599,000 | QAT | Arabic |
| REU | Réunion | 2,510 | 699,000 | ||
| ROM | Romania | 238,391 | 22,455,500 | ROM | Romani |
| ROM | Romania | 238,391 | 22,455,500 | ROM | Romanian |
| RUS | Russian Federation | 17,075,400 | 146,934,000 | RUS | Russian |
| RWA | Rwanda | 26,338 | 7,733,000 | RWA | French |
| RWA | Rwanda | 26,338 | 7,733,000 | RWA | Rwanda |
| SAU | Saudi Arabia | 2,149,690 | 21,607,000 | SAU | Arabic |
| SDN | Sudan | 2,505,813 | 29,490,000 | SDN | Arabic |
| SEN | Senegal | 196,722 | 9,481,000 | SEN | Wolof |
| SGP | Singapore | 618 | 3,567,000 | SGP | Chinese |
| SGP | Singapore | 618 | 3,567,000 | SGP | Malay |
| SGP | Singapore | 618 | 3,567,000 | SGP | Tamil |
| SGS | South Georgia and the South Sandwich Islands | 3,903 | 0 | ||
| SHN | Saint Helena | 314 | 6,000 | SHN | English |
| SJM | Svalbard and Jan Mayen | 62,422 | 3,200 | SJM | Norwegian |
| SLB | Solomon Islands | 28,896 | 444,000 | ||
| SLE | Sierra Leone | 71,740 | 4,854,000 | ||
| SLV | El Salvador | 21,041 | 6,276,000 | SLV | Spanish |
| SMR | San Marino | 61 | 27,000 | SMR | Italian |
| SOM | Somalia | 637,657 | 10,097,000 | SOM | Arabic |
| SOM | Somalia | 637,657 | 10,097,000 | SOM | Somali |
| SPM | Saint Pierre and Miquelon | 242 | 7,000 | SPM | French |
| STP | Sao Tome and Principe | 964 | 147,000 | ||
| SUR | Suriname | 163,265 | 417,000 | ||
| SVK | Slovakia | 49,012 | 5,398,700 | SVK | Slovak |
| SVN | Slovenia | 20,256 | 1,987,800 | SVN | Slovene |
| SWE | Sweden | 449,964 | 8,861,400 | SWE | Swedish |
| SWZ | Swaziland | 17,364 | 1,008,000 | SWZ | Swazi |
| SYC | Seychelles | 455 | 77,000 | SYC | English |
| SYC | Seychelles | 455 | 77,000 | SYC | French |
| SYR | Syria | 185,180 | 16,125,000 | SYR | Arabic |
| TCA | Turks and Caicos Islands | 430 | 17,000 | TCA | English |
| TCD | Chad | 1,284,000 | 7,651,000 | TCD | Arabic |
| TGO | Togo | 56,785 | 4,629,000 | TGO | Ewe |
| TGO | Togo | 56,785 | 4,629,000 | TGO | Kabyé |
| THA | Thailand | 513,115 | 61,399,000 | THA | Thai |
| TJK | Tajikistan | 143,100 | 6,188,000 | TJK | Tadzhik |
| TKL | Tokelau | 12 | 2,000 | TKL | English |
| TKM | Turkmenistan | 488,100 | 4,459,000 | TKM | Turkmenian |
| TMP | East Timor | 14,874 | 885,000 | TMP | Portuguese |
| TON | Tonga | 650 | 99,000 | TON | English |
| TON | Tonga | 650 | 99,000 | TON | Tongan |
| TTO | Trinidad and Tobago | 5,130 | 1,295,000 | ||
| TUN | Tunisia | 163,610 | 9,586,000 | TUN | Arabic |
| TUR | Turkey | 774,815 | 66,591,000 | TUR | Turkish |
| TUV | Tuvalu | 26 | 12,000 | TUV | English |
| TUV | Tuvalu | 26 | 12,000 | TUV | Tuvalu |
| TWN | Taiwan | 36,188 | 22,256,000 | TWN | Mandarin Chinese |
| TZA | Tanzania | 883,749 | 33,517,000 | TZA | Swahili |
| UGA | Uganda | 241,038 | 21,778,000 | ||
| UKR | Ukraine | 603,700 | 50,456,000 | UKR | Ukrainian |
| UMI | United States Minor Outlying Islands | 16 | 0 | UMI | English |
| URY | Uruguay | 175,016 | 3,337,000 | URY | Spanish |
| USA | United States | 9,363,520 | 278,357,000 | USA | English |
| UZB | Uzbekistan | 447,400 | 24,318,000 | UZB | Uzbek |
| VAT | Holy See (Vatican City State) | 0 | 1,000 | VAT | Italian |
| VCT | Saint Vincent and the Grenadines | 388 | 114,000 | VCT | English |
| VEN | Venezuela | 912,050 | 24,170,000 | VEN | Spanish |
| VGB | Virgin Islands, British | 151 | 21,000 | VGB | English |
| VIR | Virgin Islands, U.S. | 347 | 93,000 | VIR | English |
| VNM | Vietnam | 331,689 | 79,832,000 | VNM | Vietnamese |
| VUT | Vanuatu | 12,189 | 190,000 | VUT | Bislama |
| VUT | Vanuatu | 12,189 | 190,000 | VUT | English |
| VUT | Vanuatu | 12,189 | 190,000 | VUT | French |
| WLF | Wallis and Futuna | 200 | 15,000 | ||
| WSM | Samoa | 2,831 | 180,000 | WSM | English |
| WSM | Samoa | 2,831 | 180,000 | WSM | Samoan |
| YEM | Yemen | 527,968 | 18,112,000 | YEM | Arabic |
| YUG | Yugoslavia | 102,173 | 10,640,000 | YUG | Serbo-Croatian |
| ZAF | South Africa | 1,221,037 | 40,377,000 | ZAF | Afrikaans |
| ZAF | South Africa | 1,221,037 | 40,377,000 | ZAF | English |
| ZAF | South Africa | 1,221,037 | 40,377,000 | ZAF | Xhosa |
| ZAF | South Africa | 1,221,037 | 40,377,000 | ZAF | Zulu |
| ZMB | Zambia | 752,618 | 9,169,000 | ||
| ZWE | Zimbabwe | 390,757 | 11,669,000 | ZWE | English |
| Code | Name | Surface Area | Population | CountryCode | Language |