Plain text list of countries

countries

Afghanistan
Albania
Algeria
Andorra
Angola
Antigua & Deps
Argentina
Armenia
Australia
Austria
Azerbaijan
Bahamas
Bahrain
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bhutan
Bolivia
Bosnia Herzegovina
Botswana
Brazil
Brunei
Bulgaria
Burkina
Burundi
Cambodia
Cameroon
Canada
Cape Verde
Central African Rep
Chad
Chile
China
Colombia
Comoros
Congo
Congo {Democratic Rep}
Costa Rica
Croatia
Cuba
Cyprus
Czech Republic
Denmark
Djibouti
Dominica
Dominican Republic
East Timor
Ecuador
Egypt
El Salvador
Equatorial Guinea
Eritrea
Estonia
Ethiopia
Fiji
Finland
France
Gabon
Gambia
Georgia
Germany
Ghana
Greece
Grenada
Guatemala
Guinea
Guinea-Bissau
Guyana
Haiti
Honduras
Hungary
Iceland
India
Indonesia
Iran
Iraq
Ireland {Republic}
Israel
Italy
Ivory Coast
Jamaica
Japan
Jordan
Kazakhstan
Kenya
Kiribati
Korea North
Korea South
Kosovo
Kuwait
Kyrgyzstan
Laos
Latvia
Lebanon
Lesotho
Liberia
Libya
Liechtenstein
Lithuania
Luxembourg
Macedonia
Madagascar
Malawi
Malaysia
Maldives
Mali
Malta
Marshall Islands
Mauritania
Mauritius
Mexico
Micronesia
Moldova
Monaco
Mongolia
Montenegro
Morocco
Mozambique
Myanmar, {Burma}
Namibia
Nauru
Nepal
Netherlands
New Zealand
Nicaragua
Niger
Nigeria
Norway
Oman
Pakistan
Palau
Panama
Papua New Guinea
Paraguay
Peru
Philippines
Poland
Portugal
Qatar
Romania
Russian Federation
Rwanda
St Kitts & Nevis
St Lucia
Saint Vincent & the Grenadines
Samoa
San Marino
Sao Tome & Principe
Saudi Arabia
Senegal
Serbia
Seychelles
Sierra Leone
Singapore
Slovakia
Slovenia
Solomon Islands
Somalia
South Africa
South Sudan
Spain
Sri Lanka
Sudan
Suriname
Swaziland
Sweden
Switzerland
Syria
Taiwan
Tajikistan
Tanzania
Thailand
Togo
Tonga
Trinidad & Tobago
Tunisia
Turkey
Turkmenistan
Tuvalu
Uganda
Ukraine
United Arab Emirates
United Kingdom
United States
Uruguay
Uzbekistan
Vanuatu
Vatican City
Venezuela
Vietnam
Yemen
Zambia
Zimbabwe

SQL Insert Statements:

INSERT INTO Country (Name, Code) VALUES ('Afghanistan', 'AF');
INSERT INTO Country (Name, Code) VALUES ('Aland Islands', 'AX');
INSERT INTO Country (Name, Code) VALUES ('Albania', 'AL');
INSERT INTO Country (Name, Code) VALUES ('Algeria', 'DZ');
INSERT INTO Country (Name, Code) VALUES ('American Samoa', 'AS');
INSERT INTO Country (Name, Code) VALUES ('Andorra', 'AD');
INSERT INTO Country (Name, Code) VALUES ('Angola', 'AO');
INSERT INTO Country (Name, Code) VALUES ('Anguilla', 'AI');
INSERT INTO Country (Name, Code) VALUES ('Antarctica', 'AQ');
INSERT INTO Country (Name, Code) VALUES ('Antigua and Barbuda', 'AG');
INSERT INTO Country (Name, Code) VALUES ('Argentina', 'AR');
INSERT INTO Country (Name, Code) VALUES ('Armenia', 'AM');
INSERT INTO Country (Name, Code) VALUES ('Aruba', 'AW');
INSERT INTO Country (Name, Code) VALUES ('Australia', 'AU');
INSERT INTO Country (Name, Code) VALUES ('Austria', 'AT');
INSERT INTO Country (Name, Code) VALUES ('Azerbaijan', 'AZ');
INSERT INTO Country (Name, Code) VALUES ('Bahamas', 'BS');
INSERT INTO Country (Name, Code) VALUES ('Bahrain', 'BH');
INSERT INTO Country (Name, Code) VALUES ('Bangladesh', 'BD');
INSERT INTO Country (Name, Code) VALUES ('Barbados', 'BB');
INSERT INTO Country (Name, Code) VALUES ('Belarus', 'BY');
INSERT INTO Country (Name, Code) VALUES ('Belgium', 'BE');
INSERT INTO Country (Name, Code) VALUES ('Belize', 'BZ');
INSERT INTO Country (Name, Code) VALUES ('Benin', 'BJ');
INSERT INTO Country (Name, Code) VALUES ('Bermuda', 'BM');
INSERT INTO Country (Name, Code) VALUES ('Bhutan', 'BT');
INSERT INTO Country (Name, Code) VALUES ('Bolivia', 'BO');
INSERT INTO Country (Name, Code) VALUES ('Bonaire, Sint Eustatius and Saba', 'BQ');
INSERT INTO Country (Name, Code) VALUES ('Bosnia and Herzegovina', 'BA');
INSERT INTO Country (Name, Code) VALUES ('Botswana', 'BW');
INSERT INTO Country (Name, Code) VALUES ('Bouvet Island', 'BV');
INSERT INTO Country (Name, Code) VALUES ('Brazil', 'BR');
INSERT INTO Country (Name, Code) VALUES ('British Indian Ocean Territory', 'IO');
INSERT INTO Country (Name, Code) VALUES ('Brunei Darussalam', 'BN');
INSERT INTO Country (Name, Code) VALUES ('Bulgaria', 'BG');
INSERT INTO Country (Name, Code) VALUES ('Burkina Faso', 'BF');
INSERT INTO Country (Name, Code) VALUES ('Burundi', 'BI');
INSERT INTO Country (Name, Code) VALUES ('Cambodia', 'KH');
INSERT INTO Country (Name, Code) VALUES ('Cameroon', 'CM');
INSERT INTO Country (Name, Code) VALUES ('Canada', 'CA');
INSERT INTO Country (Name, Code) VALUES ('Cape Verde', 'CV');
INSERT INTO Country (Name, Code) VALUES ('Cayman Islands', 'KY');
INSERT INTO Country (Name, Code) VALUES ('Central African Republic', 'CF');
INSERT INTO Country (Name, Code) VALUES ('Chad', 'TD');
INSERT INTO Country (Name, Code) VALUES ('Chile', 'CL');
INSERT INTO Country (Name, Code) VALUES ('China', 'CN');
INSERT INTO Country (Name, Code) VALUES ('Christmas Island', 'CX');
INSERT INTO Country (Name, Code) VALUES ('Cocos (Keeling) Islands', 'CC');
INSERT INTO Country (Name, Code) VALUES ('Colombia', 'CO');
INSERT INTO Country (Name, Code) VALUES ('Comoros', 'KM');
INSERT INTO Country (Name, Code) VALUES ('Congo', 'CG');
INSERT INTO Country (Name, Code) VALUES ('Congo, Democratic Republic of the Congo', 'CD');
INSERT INTO Country (Name, Code) VALUES ('Cook Islands', 'CK');
INSERT INTO Country (Name, Code) VALUES ('Costa Rica', 'CR');
INSERT INTO Country (Name, Code) VALUES ('Cote D'Ivoire', 'CI');
INSERT INTO Country (Name, Code) VALUES ('Croatia', 'HR');
INSERT INTO Country (Name, Code) VALUES ('Cuba', 'CU');
INSERT INTO Country (Name, Code) VALUES ('Curacao', 'CW');
INSERT INTO Country (Name, Code) VALUES ('Cyprus', 'CY');
INSERT INTO Country (Name, Code) VALUES ('Czech Republic', 'CZ');
INSERT INTO Country (Name, Code) VALUES ('Denmark', 'DK');
INSERT INTO Country (Name, Code) VALUES ('Djibouti', 'DJ');
INSERT INTO Country (Name, Code) VALUES ('Dominica', 'DM');
INSERT INTO Country (Name, Code) VALUES ('Dominican Republic', 'DO');
INSERT INTO Country (Name, Code) VALUES ('Ecuador', 'EC');
INSERT INTO Country (Name, Code) VALUES ('Egypt', 'EG');
INSERT INTO Country (Name, Code) VALUES ('El Salvador', 'SV');
INSERT INTO Country (Name, Code) VALUES ('Equatorial Guinea', 'GQ');
INSERT INTO Country (Name, Code) VALUES ('Eritrea', 'ER');
INSERT INTO Country (Name, Code) VALUES ('Estonia', 'EE');
INSERT INTO Country (Name, Code) VALUES ('Ethiopia', 'ET');
INSERT INTO Country (Name, Code) VALUES ('Falkland Islands (Malvinas)', 'FK');
INSERT INTO Country (Name, Code) VALUES ('Faroe Islands', 'FO');
INSERT INTO Country (Name, Code) VALUES ('Fiji', 'FJ');
INSERT INTO Country (Name, Code) VALUES ('Finland', 'FI');
INSERT INTO Country (Name, Code) VALUES ('France', 'FR');
INSERT INTO Country (Name, Code) VALUES ('French Guiana', 'GF');
INSERT INTO Country (Name, Code) VALUES ('French Polynesia', 'PF');
INSERT INTO Country (Name, Code) VALUES ('French Southern Territories', 'TF');
INSERT INTO Country (Name, Code) VALUES ('Gabon', 'GA');
INSERT INTO Country (Name, Code) VALUES ('Gambia', 'GM');
INSERT INTO Country (Name, Code) VALUES ('Georgia', 'GE');
INSERT INTO Country (Name, Code) VALUES ('Germany', 'DE');
INSERT INTO Country (Name, Code) VALUES ('Ghana', 'GH');
INSERT INTO Country (Name, Code) VALUES ('Gibraltar', 'GI');
INSERT INTO Country (Name, Code) VALUES ('Greece', 'GR');
INSERT INTO Country (Name, Code) VALUES ('Greenland', 'GL');
INSERT INTO Country (Name, Code) VALUES ('Grenada', 'GD');
INSERT INTO Country (Name, Code) VALUES ('Guadeloupe', 'GP');
INSERT INTO Country (Name, Code) VALUES ('Guam', 'GU');
INSERT INTO Country (Name, Code) VALUES ('Guatemala', 'GT');
INSERT INTO Country (Name, Code) VALUES ('Guernsey', 'GG');
INSERT INTO Country (Name, Code) VALUES ('Guinea', 'GN');
INSERT INTO Country (Name, Code) VALUES ('Guinea-Bissau', 'GW');
INSERT INTO Country (Name, Code) VALUES ('Guyana', 'GY');
INSERT INTO Country (Name, Code) VALUES ('Haiti', 'HT');
INSERT INTO Country (Name, Code) VALUES ('Heard Island and Mcdonald Islands', 'HM');
INSERT INTO Country (Name, Code) VALUES ('Holy See (Vatican City State)', 'VA');
INSERT INTO Country (Name, Code) VALUES ('Honduras', 'HN');
INSERT INTO Country (Name, Code) VALUES ('Hong Kong', 'HK');
INSERT INTO Country (Name, Code) VALUES ('Hungary', 'HU');
INSERT INTO Country (Name, Code) VALUES ('Iceland', 'IS');
INSERT INTO Country (Name, Code) VALUES ('India', 'IN');
INSERT INTO Country (Name, Code) VALUES ('Indonesia', 'ID');
INSERT INTO Country (Name, Code) VALUES ('Iran, Islamic Republic of', 'IR');
INSERT INTO Country (Name, Code) VALUES ('Iraq', 'IQ');
INSERT INTO Country (Name, Code) VALUES ('Ireland', 'IE');
INSERT INTO Country (Name, Code) VALUES ('Isle of Man', 'IM');
INSERT INTO Country (Name, Code) VALUES ('Israel', 'IL');
INSERT INTO Country (Name, Code) VALUES ('Italy', 'IT');
INSERT INTO Country (Name, Code) VALUES ('Jamaica', 'JM');
INSERT INTO Country (Name, Code) VALUES ('Japan', 'JP');
INSERT INTO Country (Name, Code) VALUES ('Jersey', 'JE');
INSERT INTO Country (Name, Code) VALUES ('Jordan', 'JO');
INSERT INTO Country (Name, Code) VALUES ('Kazakhstan', 'KZ');
INSERT INTO Country (Name, Code) VALUES ('Kenya', 'KE');
INSERT INTO Country (Name, Code) VALUES ('Kiribati', 'KI');
INSERT INTO Country (Name, Code) VALUES ('Korea, Democratic People's Republic of', 'KP');
INSERT INTO Country (Name, Code) VALUES ('Korea, Republic of', 'KR');
INSERT INTO Country (Name, Code) VALUES ('Kosovo', 'XK');
INSERT INTO Country (Name, Code) VALUES ('Kuwait', 'KW');
INSERT INTO Country (Name, Code) VALUES ('Kyrgyzstan', 'KG');
INSERT INTO Country (Name, Code) VALUES ('Lao People's Democratic Republic', 'LA');
INSERT INTO Country (Name, Code) VALUES ('Latvia', 'LV');
INSERT INTO Country (Name, Code) VALUES ('Lebanon', 'LB');
INSERT INTO Country (Name, Code) VALUES ('Lesotho', 'LS');
INSERT INTO Country (Name, Code) VALUES ('Liberia', 'LR');
INSERT INTO Country (Name, Code) VALUES ('Libyan Arab Jamahiriya', 'LY');
INSERT INTO Country (Name, Code) VALUES ('Liechtenstein', 'LI');
INSERT INTO Country (Name, Code) VALUES ('Lithuania', 'LT');
INSERT INTO Country (Name, Code) VALUES ('Luxembourg', 'LU');
INSERT INTO Country (Name, Code) VALUES ('Macao', 'MO');
INSERT INTO Country (Name, Code) VALUES ('Macedonia, the Former Yugoslav Republic of', 'MK');
INSERT INTO Country (Name, Code) VALUES ('Madagascar', 'MG');
INSERT INTO Country (Name, Code) VALUES ('Malawi', 'MW');
INSERT INTO Country (Name, Code) VALUES ('Malaysia', 'MY');
INSERT INTO Country (Name, Code) VALUES ('Maldives', 'MV');
INSERT INTO Country (Name, Code) VALUES ('Mali', 'ML');
INSERT INTO Country (Name, Code) VALUES ('Malta', 'MT');
INSERT INTO Country (Name, Code) VALUES ('Marshall Islands', 'MH');
INSERT INTO Country (Name, Code) VALUES ('Martinique', 'MQ');
INSERT INTO Country (Name, Code) VALUES ('Mauritania', 'MR');
INSERT INTO Country (Name, Code) VALUES ('Mauritius', 'MU');
INSERT INTO Country (Name, Code) VALUES ('Mayotte', 'YT');
INSERT INTO Country (Name, Code) VALUES ('Mexico', 'MX');
INSERT INTO Country (Name, Code) VALUES ('Micronesia, Federated States of', 'FM');
INSERT INTO Country (Name, Code) VALUES ('Moldova, Republic of', 'MD');
INSERT INTO Country (Name, Code) VALUES ('Monaco', 'MC');
INSERT INTO Country (Name, Code) VALUES ('Mongolia', 'MN');
INSERT INTO Country (Name, Code) VALUES ('Montenegro', 'ME');
INSERT INTO Country (Name, Code) VALUES ('Montserrat', 'MS');
INSERT INTO Country (Name, Code) VALUES ('Morocco', 'MA');
INSERT INTO Country (Name, Code) VALUES ('Mozambique', 'MZ');
INSERT INTO Country (Name, Code) VALUES ('Myanmar', 'MM');
INSERT INTO Country (Name, Code) VALUES ('Namibia', 'NA');
INSERT INTO Country (Name, Code) VALUES ('Nauru', 'NR');
INSERT INTO Country (Name, Code) VALUES ('Nepal', 'NP');
INSERT INTO Country (Name, Code) VALUES ('Netherlands', 'NL');
INSERT INTO Country (Name, Code) VALUES ('Netherlands Antilles', 'AN');
INSERT INTO Country (Name, Code) VALUES ('New Caledonia', 'NC');
INSERT INTO Country (Name, Code) VALUES ('New Zealand', 'NZ');
INSERT INTO Country (Name, Code) VALUES ('Nicaragua', 'NI');
INSERT INTO Country (Name, Code) VALUES ('Niger', 'NE');
INSERT INTO Country (Name, Code) VALUES ('Nigeria', 'NG');
INSERT INTO Country (Name, Code) VALUES ('Niue', 'NU');
INSERT INTO Country (Name, Code) VALUES ('Norfolk Island', 'NF');
INSERT INTO Country (Name, Code) VALUES ('Northern Mariana Islands', 'MP');
INSERT INTO Country (Name, Code) VALUES ('Norway', 'NO');
INSERT INTO Country (Name, Code) VALUES ('Oman', 'OM');
INSERT INTO Country (Name, Code) VALUES ('Pakistan', 'PK');
INSERT INTO Country (Name, Code) VALUES ('Palau', 'PW');
INSERT INTO Country (Name, Code) VALUES ('Palestinian Territory, Occupied', 'PS');
INSERT INTO Country (Name, Code) VALUES ('Panama', 'PA');
INSERT INTO Country (Name, Code) VALUES ('Papua New Guinea', 'PG');
INSERT INTO Country (Name, Code) VALUES ('Paraguay', 'PY');
INSERT INTO Country (Name, Code) VALUES ('Peru', 'PE');
INSERT INTO Country (Name, Code) VALUES ('Philippines', 'PH');
INSERT INTO Country (Name, Code) VALUES ('Pitcairn', 'PN');
INSERT INTO Country (Name, Code) VALUES ('Poland', 'PL');
INSERT INTO Country (Name, Code) VALUES ('Portugal', 'PT');
INSERT INTO Country (Name, Code) VALUES ('Puerto Rico', 'PR');
INSERT INTO Country (Name, Code) VALUES ('Qatar', 'QA');
INSERT INTO Country (Name, Code) VALUES ('Reunion', 'RE');
INSERT INTO Country (Name, Code) VALUES ('Romania', 'RO');
INSERT INTO Country (Name, Code) VALUES ('Russian Federation', 'RU');
INSERT INTO Country (Name, Code) VALUES ('Rwanda', 'RW');
INSERT INTO Country (Name, Code) VALUES ('Saint Barthelemy', 'BL');
INSERT INTO Country (Name, Code) VALUES ('Saint Helena', 'SH');
INSERT INTO Country (Name, Code) VALUES ('Saint Kitts and Nevis', 'KN');
INSERT INTO Country (Name, Code) VALUES ('Saint Lucia', 'LC');
INSERT INTO Country (Name, Code) VALUES ('Saint Martin', 'MF');
INSERT INTO Country (Name, Code) VALUES ('Saint Pierre and Miquelon', 'PM');
INSERT INTO Country (Name, Code) VALUES ('Saint Vincent and the Grenadines', 'VC');
INSERT INTO Country (Name, Code) VALUES ('Samoa', 'WS');
INSERT INTO Country (Name, Code) VALUES ('San Marino', 'SM');
INSERT INTO Country (Name, Code) VALUES ('Sao Tome and Principe', 'ST');
INSERT INTO Country (Name, Code) VALUES ('Saudi Arabia', 'SA');
INSERT INTO Country (Name, Code) VALUES ('Senegal', 'SN');
INSERT INTO Country (Name, Code) VALUES ('Serbia', 'RS');
INSERT INTO Country (Name, Code) VALUES ('Serbia and Montenegro', 'CS');
INSERT INTO Country (Name, Code) VALUES ('Seychelles', 'SC');
INSERT INTO Country (Name, Code) VALUES ('Sierra Leone', 'SL');
INSERT INTO Country (Name, Code) VALUES ('Singapore', 'SG');
INSERT INTO Country (Name, Code) VALUES ('Sint Maarten', 'SX');
INSERT INTO Country (Name, Code) VALUES ('Slovakia', 'SK');
INSERT INTO Country (Name, Code) VALUES ('Slovenia', 'SI');
INSERT INTO Country (Name, Code) VALUES ('Solomon Islands', 'SB');
INSERT INTO Country (Name, Code) VALUES ('Somalia', 'SO');
INSERT INTO Country (Name, Code) VALUES ('South Africa', 'ZA');
INSERT INTO Country (Name, Code) VALUES ('South Georgia and the South Sandwich Islands', 'GS');
INSERT INTO Country (Name, Code) VALUES ('South Sudan', 'SS');
INSERT INTO Country (Name, Code) VALUES ('Spain', 'ES');
INSERT INTO Country (Name, Code) VALUES ('Sri Lanka', 'LK');
INSERT INTO Country (Name, Code) VALUES ('Sudan', 'SD');
INSERT INTO Country (Name, Code) VALUES ('Suriname', 'SR');
INSERT INTO Country (Name, Code) VALUES ('Svalbard and Jan Mayen', 'SJ');
INSERT INTO Country (Name, Code) VALUES ('Swaziland', 'SZ');
INSERT INTO Country (Name, Code) VALUES ('Sweden', 'SE');
INSERT INTO Country (Name, Code) VALUES ('Switzerland', 'CH');
INSERT INTO Country (Name, Code) VALUES ('Syrian Arab Republic', 'SY');
INSERT INTO Country (Name, Code) VALUES ('Taiwan, Province of China', 'TW');
INSERT INTO Country (Name, Code) VALUES ('Tajikistan', 'TJ');
INSERT INTO Country (Name, Code) VALUES ('Tanzania, United Republic of', 'TZ');
INSERT INTO Country (Name, Code) VALUES ('Thailand', 'TH');
INSERT INTO Country (Name, Code) VALUES ('Timor-Leste', 'TL');
INSERT INTO Country (Name, Code) VALUES ('Togo', 'TG');
INSERT INTO Country (Name, Code) VALUES ('Tokelau', 'TK');
INSERT INTO Country (Name, Code) VALUES ('Tonga', 'TO');
INSERT INTO Country (Name, Code) VALUES ('Trinidad and Tobago', 'TT');
INSERT INTO Country (Name, Code) VALUES ('Tunisia', 'TN');
INSERT INTO Country (Name, Code) VALUES ('Turkey', 'TR');
INSERT INTO Country (Name, Code) VALUES ('Turkmenistan', 'TM');
INSERT INTO Country (Name, Code) VALUES ('Turks and Caicos Islands', 'TC');
INSERT INTO Country (Name, Code) VALUES ('Tuvalu', 'TV');
INSERT INTO Country (Name, Code) VALUES ('Uganda', 'UG');
INSERT INTO Country (Name, Code) VALUES ('Ukraine', 'UA');
INSERT INTO Country (Name, Code) VALUES ('United Arab Emirates', 'AE');
INSERT INTO Country (Name, Code) VALUES ('United Kingdom', 'GB');
INSERT INTO Country (Name, Code) VALUES ('United States', 'US');
INSERT INTO Country (Name, Code) VALUES ('United States Minor Outlying Islands', 'UM');
INSERT INTO Country (Name, Code) VALUES ('Uruguay', 'UY');
INSERT INTO Country (Name, Code) VALUES ('Uzbekistan', 'UZ');
INSERT INTO Country (Name, Code) VALUES ('Vanuatu', 'VU');
INSERT INTO Country (Name, Code) VALUES ('Venezuela', 'VE');
INSERT INTO Country (Name, Code) VALUES ('Viet Nam', 'VN');
INSERT INTO Country (Name, Code) VALUES ('Virgin Islands, British', 'VG');
INSERT INTO Country (Name, Code) VALUES ('Virgin Islands, U.s.', 'VI');
INSERT INTO Country (Name, Code) VALUES ('Wallis and Futuna', 'WF');
INSERT INTO Country (Name, Code) VALUES ('Western Sahara', 'EH');
INSERT INTO Country (Name, Code) VALUES ('Yemen', 'YE');
INSERT INTO Country (Name, Code) VALUES ('Zambia', 'ZM');
INSERT INTO Country (Name, Code) VALUES ('Zimbabwe', 'ZW');