MySQL Table of all Countries
Last Updated: October 27, 2009
The below-linked MySQL script contains the ISO2, ISO3, and ISO numerical codes, as well as the short and long names for the countries shown below. I have endeavored to list all of the countries in the world, but I know I've missed some--any additions or corrections would be welcome! The zip file contains all of the flags shown below.
Note: The short names use only the letters in the English alphabet, while the long names use the HTML entities.
Link to Script File: country.sql.txt
Link to Flags Zip File: country-flags.zip
| Flag | Short Name | Long Name | ISO 2 | ISO 3 | ISO # | UN Member |
|---|---|---|---|---|---|---|
 |
Afghanistan | Islamic Republic of Afghanistan | AF | AFG | 4 | yes |
 |
Aland Islands | Åland Islands | AX | ALA | 248 | no |
 |
Albania | Republic of Albania | AL | ALB | 8 | yes |
 |
Algeria | People's Democratic Republic of Algeria | DZ | DZA | 12 | yes |
 |
American Samoa | American Samoa | AS | ASM | 16 | no |
 |
Andorra | Principality of Andorra | AD | AND | 20 | yes |
 |
Angola | Republic of Angola | AO | AGO | 24 | yes |
 |
Anguilla | Anguilla | AI | AIA | 660 | no |
 |
Antarctica | Antarctica | AQ | no | ||
 |
Antigua and Barbuda | Antigua and Barbuda | AG | ATG | 28 | yes |
 |
Argentina | Argentine Republic | AR | ARG | 32 | yes |
 |
Armenia | Republic of Armenia | AM | ARM | 51 | yes |
 |
Aruba | Aruba | AW | ABW | 533 | no |
 |
Australia | Commonwealth of Australia | AU | AUS | 36 | yes |
 |
Austria | Republic of Austria | AT | AUT | 40 | yes |
 |
Azerbaijan | Republic of Azerbaijan | AZ | AZE | 31 | yes |
 |
Bahamas | Commonwealth of The Bahamas | BS | BHS | 44 | yes |
 |
Bahrain | Kingdom of Bahrain | BH | BHR | 48 | yes |
 |
Bangladesh | People's Republic of Bangladesh | BD | BGD | 50 | yes |
 |
Barbados | Barbados | BB | BRB | 52 | yes |
 |
Belarus | Republic of Belarus | BY | BLR | 112 | yes |
 |
Belgium | Kingdom of Belgium | BE | BEL | 56 | yes |
 |
Belize | Belize | BZ | BLZ | 84 | yes |
 |
Benin | Republic of Benin | BJ | BEN | 204 | yes |
 |
Bermuda | Bermuda Islands | BM | BMU | 60 | no |
 |
Bhutan | Kingdom of Bhutan | BT | BTN | 64 | yes |
 |
Bolivia | Plurinational State of Bolivia | BO | BOL | 68 | yes |
 |
Bosnia and Herzegovina | Bosnia and Herzegovina | BA | BIH | 70 | yes |
 |
Botswana | Republic of Botswana | BW | BWA | 72 | yes |
 |
Bouvet Island | Bouvet Island | BV | BVT | 74 | no |
 |
Brazil | Federative Republic of Brazil | BR | BRA | 76 | yes |
 |
British Indian Ocean Territory | British Indian Ocean Territory | IO | IOT | 86 | no |
 |
Brunei | State of Brunei Darussalam | BN | BRN | 96 | yes |
 |
Bulgaria | Republic of Bulgaria | BG | BGR | 100 | yes |
 |
Burkina Faso | Burkina Faso | BF | BFA | 854 | yes |
 |
Burundi | Republic of Burundi | BI | BDI | 108 | yes |
 |
Cambodia | Kingdom of Cambodia | KH | KHM | 116 | yes |
 |
Cameroon | Republic of Cameroon | CM | CMR | 120 | yes |
 |
Canada | Canada | CA | CAN | 124 | yes |
 |
Cape Verde | Republic of Cape Verde | CV | CPV | 132 | yes |
 |
Cayman Islands | The Cayman Islands | KY | CYM | 136 | no |
 |
Central African Republic | Central African Republic | CF | CAF | 140 | yes |
 |
Chad | Republic of Chad | TD | TCD | 148 | yes |
 |
Chile | Republic of Chile | CL | CHL | 152 | yes |
 |
China | People's Republic of China | CN | CHN | 156 | yes |
 |
Christmas Island | Christmas Island | CX | CXR | 162 | no |
 |
Cocos (Keeling) Islands | Cocos (Keeling) Islands | CC | CCK | 166 | no |
 |
Colombia | Republic of Colombia | CO | COL | 170 | yes |
 |
Comoros | Union of the Comoros | KM | COM | 174 | yes |
 |
Congo | Republic of the Congo | CG | COG | 178 | yes |
 |
Cook Islands | Cook Islands | CK | COK | 184 | no |
 |
Costa Rica | Republic of Costa Rica | CR | CRI | 188 | yes |
 |
Cote d'ivoire | Côte D'Ivoire | CI | CIV | 384 | yes |
 |
Croatia | Republic of Croatia | HR | HRV | 191 | yes |
 |
Cuba | Republic of Cuba | CU | CUB | 192 | yes |
 |
Cyprus | Republic of Cyprus | CY | CYP | 196 | yes |
 |
Czech Republic | Czech Republic | CZ | CZE | 203 | yes |
 |
Democratic Republic of the Congo | Democratic Republic of the Congo | CD | COD | 180 | yes |
 |
Denmark | Kingdom of Denmark | DK | DNK | 208 | yes |
 |
Djibouti | Republic of Djibouti | DJ | DJI | 262 | yes |
 |
Dominica | Commonwealth of Dominica | DM | DMA | 212 | yes |
 |
Dominican Republic | Dominican Republic | DO | DOM | 214 | yes |
 |
Ecuador | Republic of Ecuador | EC | ECU | 218 | yes |
 |
Egypt | Arab Republic of Egypt | EG | EGY | 818 | yes |
 |
El Salvador | Republic of El Salvador | SV | SLV | 222 | yes |
 |
Equatorial Guinea | Republic of Equatorial Guinea | GQ | GNQ | 226 | yes |
 |
Eritrea | State of Eritrea | ER | ERI | 232 | yes |
 |
Estonia | Republic of Estonia | EE | EST | 233 | yes |
 |
Ethiopia | Federal Democratic Republic of Ethiopia | ET | ETH | 231 | yes |
 |
Falkland Islands (Malvinas) | The Falkland Islands (Malvinas) | FK | FLK | 238 | no |
 |
Faroe Islands | The Faroe Islands | FO | FRO | 234 | no |
 |
Fiji | Republic of the Fiji Islands | FJ | FJI | 242 | yes |
 |
Finland | Republic of Finland | FI | FIN | 246 | yes |
 |
France | French Republic | FR | FRA | 250 | yes |
 |
French Guiana | French Guiana | GF | GUF | 254 | no |
 |
French Polynesia | French Polynesia | PF | PYF | 258 | no |
 |
French Southern Territories | French Southern Territories | TF | ATF | 260 | no |
 |
Gabon | Gabonese Republic | GA | GAB | 266 | yes |
 |
Gambia | Republic of The Gambia | GM | GMB | 270 | yes |
 |
Georgia | Georgia | GE | GEO | 268 | yes |
 |
Germany | Federal Republic of Germany | DE | DEU | 276 | yes |
 |
Ghana | Republic of Ghana | GH | GHA | 288 | yes |
 |
Gibraltar | Gibraltar | GI | GIB | 292 | no |
 |
Greece | Hellenic Republic | GR | GRC | 300 | yes |
 |
Greenland | Greenland | GL | GRL | 304 | no |
 |
Grenada | Grenada | GD | GRD | 308 | yes |
 |
Guadaloupe | Guadeloupe | GP | GLP | 312 | no |
 |
Guam | Guam | GU | GUM | 316 | no |
 |
Guatemala | Republic of Guatemala | GT | GTM | 320 | yes |
 |
Guinea | Republic of Guinea | GN | GIN | 324 | yes |
 |
Guinea-Bissau | Republic of Guinea-Bissau | GW | GNB | 624 | yes |
 |
Guyana | Co-operative Republic of Guyana | GY | GUY | 328 | yes |
 |
Haiti | Republic of Haiti | HT | HTI | 332 | yes |
 |
Heard Island and McDonald Islands | Heard Island and McDonald Islands | HM | HMD | 334 | no |
 |
Honduras | Republic of Honduras | HN | HND | 340 | yes |
 |
Hong Kong | Hong Kong | HK | HKG | 344 | no |
 |
Hungary | Republic of Hungary | HU | HUN | 348 | yes |
 |
Iceland | Republic of Iceland | IS | ISL | 352 | yes |
 |
India | Republic of India | IN | IND | 356 | yes |
 |
Indonesia | Republic of Indonesia | ID | IDN | 360 | yes |
 |
Iran | Islamic Republic of Iran | IR | IRN | 364 | yes |
 |
Iraq | Republic of Iraq | IQ | IRQ | 368 | yes |
 |
Ireland | Ireland | IE | IRL | 372 | yes |
 |
Isle of Man | Isle of Man | IM | IMN | 833 | no |
 |
Israel | State of Israel | IL | ISR | 376 | yes |
 |
Italy | Italian Republic | IT | ITA | 380 | yes |
 |
Jamaica | Jamaica | JM | JAM | 388 | yes |
 |
Japan | Japan | JP | JPN | 392 | yes |
 |
Jersey | The Bailiwick of Jersey | JE | JEY | 832 | no |
 |
Jordan | Hashemite Kingdom of Jordan | JO | JOR | 400 | yes |
 |
Kazakhstan | Republic of Kazakhstan | KZ | KAZ | 398 | yes |
 |
Kenya | Republic of Kenya | KE | KEN | 404 | yes |
 |
Kiribati | Republic of Kiribati | KI | KIR | 296 | yes |
 |
Kuwait | State of Kuwait | KW | KWT | 414 | yes |
 |
Kyrgyzstan | Kyrgyz Republic | KG | KGZ | 417 | yes |
 |
Laos | Lao People's Democratic Republic | LA | LAO | 418 | yes |
 |
Latvia | Republic of Latvia | LV | LVA | 428 | yes |
 |
Lebanon | Republic of Lebanon | LB | LBN | 422 | yes |
 |
Lesotho | Kingdom of Lesotho | LS | LSO | 426 | yes |
 |
Liberia | Republic of Liberia | LR | LBR | 430 | yes |
 |
Libya | Socialist People's Libyan Arab Great Jamahiriya | LY | LBY | 434 | yes |
 |
Liechtenstein | Principality of Liechtenstein | LI | LIE | 438 | yes |
 |
Lithuania | Republic of Lithuania | LT | LTU | 440 | yes |
 |
Luxembourg | Grand Duchy of Luxembourg | LU | LUX | 442 | yes |
 |
Macao | The Macao Special Administrative Region | MO | MAC | 446 | no |
 |
Macedonia | The Former Yugoslav Republic of Macedonia | MK | MKD | 807 | yes |
 |
Madagascar | Republic of Madagascar | MG | MDG | 450 | yes |
 |
Malawi | Republic of Malawi | MW | MWI | 454 | yes |
 |
Malaysia | Malaysia | MY | MYS | 458 | yes |
 |
Maldives | Republic of Maldives | MV | MDV | 462 | yes |
 |
Mali | Republic of Mali | ML | MLI | 466 | yes |
 |
Malta | Republic of Malta | MT | MLT | 470 | yes |
 |
Marshall Islands | Republic of the Marshall Islands | MH | MHL | 584 | yes |
 |
Martinique | Martinique | MQ | MTQ | 474 | no |
 |
Mauritania | Islamic Republic of Mauritania | MR | MRT | 478 | yes |
 |
Mauritius | Republic of Mauritius | MU | MUS | 480 | yes |
 |
Mayotte | Mayotte | YT | MYT | 175 | no |
 |
Mexico | United Mexican States | MX | MEX | 484 | yes |
 |
Micronesia | Federated States of Micronesia | FM | FSM | 583 | yes |
 |
Moldava | Republic of Moldova | MD | MDA | 498 | yes |
 |
Monaco | Principality of Monaco | MC | MCO | 492 | yes |
 |
Mongolia | Mongolia | MN | MNG | 496 | yes |
 |
Montenegro | Montenegro | ME | MNE | 499 | yes |
 |
Montserrat | Montserrat | MS | MSR | 500 | no |
 |
Morocco | Kingdom of Morocco | MA | MAR | 504 | yes |
 |
Mozambique | Republic of Mozambique | MZ | MOZ | 508 | yes |
 |
Myanmar | Myanmar | MM | MMR | 104 | yes |
 |
Namibia | Republic of Namibia | NA | NAM | 516 | yes |
 |
Nauru | Republic of Nauru | NR | NRU | 520 | yes |
 |
Nepal | Federal Democratic Republic of Nepal | NP | NPL | 524 | yes |
 |
Netherlands | Kingdom of the Netherlands | NL | NLD | 528 | yes |
 |
Netherlands Antilles | Netherlands Antilles | AN | ANT | 530 | no |
 |
New Caledonia | New Caledonia | NC | NCL | 540 | no |
 |
New Zealand | New Zealand | NZ | NZL | 554 | yes |
 |
Nicaragua | Republic of Nicaragua | NI | NIC | 558 | yes |
 |
Niger | Republic of Niger | NE | NER | 562 | yes |
 |
Nigeria | Federal Republic of Nigeria | NG | NGA | 566 | yes |
 |
Niue | Niue | NU | NIU | 570 | no |
 |
Norfolk Island | Norfolk Island | NF | NFK | 574 | no |
 |
North Korea | Democratic People's Republic of Korea | KP | PRK | 408 | yes |
 |
Northern Mariana Islands | Northern Mariana Islands | MP | MNP | 580 | no |
 |
Norway | Kingdom of Norway | NO | NOR | 578 | yes |
 |
Oman | Sultanate of Oman | OM | OMN | 512 | yes |
 |
Pakistan | Islamic Republic of Pakistan | PK | PAK | 586 | yes |
 |
Palau | Republic of Palau | PW | PLW | 585 | yes |
 |
Palestinian Territory | Occupied Palestinian Territory | PS | PSE | 275 | no |
 |
Panama | Republic of Panama | PA | PAN | 591 | yes |
 |
Papua New Guinea | Independent State of Papua New Guinea | PG | PNG | 598 | yes |
 |
Paraguay | Republic of Paraguay | PY | PRY | 600 | yes |
 |
Peru | Republic of Peru | PE | PER | 604 | yes |
 |
Phillipines | Republic of the Philippines | PH | PHL | 608 | yes |
 |
Pitcairn | Pitcairn, Henderson, Ducie, and Oeno Islands | PN | PCN | 612 | no |
 |
Poland | Republic of Poland | PL | POL | 616 | yes |
 |
Portugal | Portuguese Republic | PT | PRT | 620 | yes |
 |
Puerto Rico | Commonwealth of Puerto Rico | PR | PRI | 630 | no |
 |
Qatar | State of Qatar | QA | QAT | 634 | yes |
 |
Reunion | Réunion | RE | REU | 638 | no |
 |
Romania | Romania | RO | ROM | 642 | yes |
 |
Russia | Russian Federation | RU | RUS | 643 | yes |
 |
Rwanda | Republic of Rwanda | RW | RWA | 646 | yes |
 |
Saint Barthelemy | Saint Barthélemy | BL | BLM | 652 | no |
 |
Saint Helena | Saint Helena | SH | SHN | 654 | no |
 |
Saint Kitts and Nevis | Federation of Saint Christopher and Nevis | KN | KNA | 659 | yes |
 |
Saint Lucia | Saint Lucia | LC | LCA | 662 | yes |
 |
Saint Martin | Saint Martin | MF | MAF | 663 | no |
 |
Saint Pierre and Miquelon | Saint Pierre and Miquelon | PM | SPM | 666 | no |
 |
Saint Vincent and the Grenadines | Saint Vincent and the Grenadines | VC | VCT | 670 | yes |
 |
Samoa | Independent State of Samoa | WS | WSM | 882 | yes |
 |
San Marino | Republic of San Marino | SM | SMR | 674 | yes |
 |
Sao Tome and Principe | Democratic Republic of Säo Tomé and Principe | ST | STP | 678 | yes |
 |
Saudi Arabia | Kingdom of Saudi Arabia | SA | SAU | 682 | yes |
 |
Senegal | Republic of Senegal | SN | SEN | 686 | yes |
 |
Serbia | Republic of Serbia | RS | SRB | 688 | yes |
 |
Seychelles | Republic of Seychelles | SC | SYC | 690 | yes |
 |
Sierra Leone | Republic of Sierra Leone | SL | SLE | 694 | yes |
 |
Singapore | Republic of Singapore | SG | SGP | 702 | yes |
 |
Slovakia | Slovak Republic | SK | SVK | 703 | yes |
 |
Slovenia | Republic of Slovenia | SI | SVN | 705 | yes |
 |
Solomon Islands | Solomon Islands | SB | SLB | 90 | yes |
 |
Somalia | Federal Republic of Somalia | SO | SOM | 706 | yes |
 |
South Africa | Republic of South Africa | ZA | ZAF | 710 | yes |
 |
South Georgia and the South Sandwich Islands | South Georgia and the South Sandwich Islands | GS | SGS | 239 | no |
 |
South Korea | Republic of Korea | KR | KOR | 410 | yes |
 |
Spain | Kingdom of Spain | ES | ESP | 724 | yes |
 |
Sri Lanka | Democratic Socialist Republic of Sri Lanka | LK | LKA | 144 | yes |
 |
Sudan | Republic of the Sudan | SD | SDN | 736 | yes |
 |
Suriname | Republic of Suriname | SR | SUR | 740 | yes |
 |
Svalbard and Jan Mayen | Svalbard and Jan Mayen | SJ | SJM | 744 | no |
 |
Swaziland | Kingdom of Swaziland | SZ | SWZ | 748 | yes |
 |
Sweden | Kingdom of Sweden | SE | SWE | 752 | yes |
 |
Switzerland | Swiss Confederation | CH | CHE | 756 | yes |
 |
Syria | Syrian Arab Republic | SY | SYR | 760 | yes |
| Taiwan | Taiwan, Province of China | TW | TWN | 158 | no | |
 |
Tajikistan | Republic of Tajikistan | TJ | TJK | 762 | yes |
 |
Tanzania | United Republic of Tanzania | TZ | TZA | 834 | no |
 |
Thailand | Kingdom of Thailand | TH | THA | 764 | yes |
 |
Timor-Leste | Democratic Republic of Timor-Leste | TL | TLS | 626 | yes |
 |
Togo | Togolese Republic | TG | TGO | 768 | yes |
 |
Tokelau | Tokelau | TK | TKL | 772 | no |
 |
Tonga | Kingdom of Tonga | TO | TON | 776 | yes |
 |
Trinidad and Tobago | Republic of Trinidad and Tobago | TT | TTO | 780 | yes |
 |
Tunisia | Republic of Tunisia | TN | TUN | 788 | yes |
 |
Turkey | Republic of Turkey | TR | TUR | 792 | yes |
 |
Turkmenistan | Turkmenistan | TM | TKM | 795 | yes |
 |
Turks and Caicos Islands | Turks and Caicos Islands | TC | TCA | 796 | no |
 |
Tuvalu | Tuvalu | TV | TUV | 798 | yes |
 |
Uganda | Republic of Uganda | UG | UGA | 800 | yes |
 |
Ukraine | Ukraine | UA | UKR | 804 | yes |
 |
United Arab Emirates | United Arab Emirates | AE | ARE | 784 | yes |
 |
United Kingdom | United Kingdom of Great Britain and Nothern Ireland | GB | GBR | 826 | yes |
 |
United States | United States of America | US | USA | 840 | yes |
 |
United States Minor Outlying Islands | United States Minor Outlying Islands | UM | UMI | 581 | no |
 |
Uruguay | Eastern Republic of Uruguay | UY | URY | 858 | yes |
 |
Uzbekistan | Republic of Uzbekistan | UZ | UZB | 860 | yes |
 |
Vanuatu | Republic of Vanuatu | VU | VUT | 548 | yes |
| Vatican City | State of the Vatican City | VA | VAT | 336 | no | |
 |
Venezuela | Bolivarian Republic of Venezuela | VE | VEN | 862 | yes |
 |
Vietnam | Socialist Republic of Vietnam | VN | VNM | 704 | yes |
 |
Virgin Islands, British | Virgin Islands, British | VG | VGB | 92 | no |
 |
Virgin Islands, US | Virgin Islands, U.s. | VI | VIR | 850 | no |
 |
Wallis and Futuna | Wallis and Futuna | WF | WLF | 876 | no |
| Western Sahara | Western Sahara | EH | ESH | 732 | no | |
 |
Yemen | Republic of Yemen | YE | YEM | 887 | yes |
 |
Zambia | Republic of Zambia | ZM | ZMB | 894 | yes |
 |
Zimbabwe | Republic of Zimbabwe | ZW | ZWE | 716 | yes |