List of nationalities for use in profiles?

By netlynx on 15 Oct 2004 at 12:31 UTC

Anyone know where I can get a cut and paste list for the nationality
I need in the profile?
(Maybe Dries has one he could provide?...or is there something prepped earlier that I have'nt seen?)
thanks

Comments

sql code

pamphile commented 15 October 2004 at 14:33

try this

Ascension Island
Andorra
United Arab Emirates
Afghanistan
Antigua and Barbuda
Anguilla
Albania
Armenia
Netherlands Antilles
Angola
Antartica
Argentina
American Samoa
Australia
Aruba
Azerbaijan
Bosnia and Herzegovina
Barbados
Bangladesh
Belgium
Burkina Faso
Bulgaria
Bahrain
Burundi
Benin
Bermuda
Brunei Darussalam
Bolivia
Brazil
Bahamas
Bhutan
Bouvet Island
Botswana
Belarus
Belize
Canada
Cocos (Keeling) Islands
Congo, Democratic People's Republic
Central African Republic
Congo, Republic of
Switzerland
Cote d'Ivoire
Cook Islands
Chile
Cameroon
China
Colombia
Costa Rica
Cuba
Cap Verde
Christmas Island
Cyprus
Czeck Republic
Germany
Djibouti
Denmark
Dominica
Dominican Republic
Algeria
Ecuador
Estonia
Egypt
Western Sahara
Eritrea
Spain
Ethiopia
Finland
Fiji
Falkland Islands (Malvina)
Micronesia, Federal State of
Faroe Islands
France
Gabon
Grenada
Georgia
French Guiana
Guernsey
Ghana
Gibraltar
Greenland
Gambia
Guinea
Guadeloupe
Equatorial Guinea
Greece
South Georgia and the South Sandwich Islands
Guatemala
Guam
Guinea-Bissau
Guyana
Hong Kong
Heard and McDonald Islands
Honduras
Croatia/Hrvatska
Haiti
Hungary
Indonesia
Ireland
Israel
Isle of Man
India
British Indian Ocean Territory
Iraq
Iran (Islamic Republic of)
Iceland
Italy
Jersey
Jamaica
Jordan
Japan
Kenya
Kyrgyzstan
Cambodia
Kiribati
Comoros
Saint Kitts and Nevis
Korea, Democratic People's Republic
Korea, Republic of
Kuwait
Cayman Islands
Kazakhstan
Lao, People's Democratic Republic
Lebanon
Saint Lucia
Liechtenstein
Sri Lanka
Liberia
Lesotho
Lithuania
Luxembourg
Latvia
Libyan Arab Jamahiriya
Morocco
Monaco
Moldova, Republic of
Madagascar
Marshall Islands
Macedonia, Former Yugoslav Republic
Mali
Myanmar
Mongolia
Macau
Northern Mariana Islands
Martinique
Mauritania
Montserrat
Malta
Mauritius
Maldives
Malawi
Mexico
Malaysia
Mozambique
Namibia
New Caledonia
Niger
Norfolk Island
Nigeria
Nicaragua
Netherlands
Norway
Nepal
Nauru
Niue
New Zealand
Oman
Panama
Peru
French Polynesia
Papua New Guinea
Philippines
Pakistan
Poland
St. Pierre and Miquelon
Pitcairn Island
Puerto Rico
Portugal
Palau
Paraguay
Qatar
Reunion Island
Romania
Russian Federation
Rwanda
Saudi Arabia
Solomon Islands
Seychelles
Sudan
Sweden
Singapore
St. Helena
Slovenia
Svalbard and Jan Mayen Islands
Slovak Republic
Sierra Leone
San Marino
Senegal
Somalia
Suriname
Sao Tome and Principe
El Salvador
Syrian Arab Republic
Swaziland
Turks and Ciacos Islands
Chad
French Southern Territories
Togo
Thailand
Tajikistan
Tokelau
Turkmenistan
Tunisia
Tonga
East Timor
Turkey
Trinidad and Tobago
Tuvalu
Taiwan
Tanzania
Ukraine
Uganda
United Kingdom
United Kingdom
US Minor Outlying Islands
United States
Uruguay
Uzbekistan
Holy See (City Vatican State)
Saint Vincent and the Grenadines
Venezuela
Virgin Islands (British)
Virgin Islands (USA)
Vietnam
Vanuatu
Wallis and Futuna Islands
Western Samoa
Yemen
Mayotte
Yugoslavia
South Africa
Zambia
Zaire
Zimbabwe
Austria

or some sql code

-- phpMyAdmin SQL Dump
-- version 2.6.0-rc1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Oct 15, 2004 at 10:29 AM
-- Server version: 4.0.20
-- PHP Version: 4.3.8
-- 
-- Database: `01diarist`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `country`
-- 

CREATE TABLE `country` (
  `countryid` int(11) NOT NULL auto_increment,
  `country_code` varchar(10) NOT NULL default '',
  `country` varchar(64) NOT NULL default '',
  `currency` varchar(4) NOT NULL default '0',
  UNIQUE KEY `country_code` (`country_code`),
  UNIQUE KEY `ID` (`countryid`)
) TYPE=MyISAM AUTO_INCREMENT=251 ;

-- 
-- Dumping data for table `country`
-- 

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (1, 'ac', 'Ascension Island', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (2, 'ad', 'Andorra', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (3, 'ae', 'United Arab Emirates', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (4, 'af', 'Afghanistan', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (5, 'ag', 'Antigua and Barbuda', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (6, 'ai', 'Anguilla', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (7, 'al', 'Albania', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (8, 'am', 'Armenia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (9, 'an', 'Netherlands Antilles', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (10, 'ao', 'Angola', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (11, 'aq', 'Antartica', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (12, 'ar', 'Argentina', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (13, 'as', 'American Samoa', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (14, 'au', 'Australia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (15, 'aw', 'Aruba', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (16, 'az', 'Azerbaijan', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (17, 'ba', 'Bosnia and Herzegovina', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (18, 'bb', 'Barbados', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (19, 'bd', 'Bangladesh', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (20, 'be', 'Belgium', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (21, 'bf', 'Burkina Faso', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (22, 'bg', 'Bulgaria', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (23, 'bh', 'Bahrain', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (24, 'bi', 'Burundi', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (25, 'bj', 'Benin', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (26, 'bm', 'Bermuda', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (27, 'bn', 'Brunei Darussalam', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (28, 'bo', 'Bolivia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (29, 'br', 'Brazil', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (30, 'bs', 'Bahamas', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (31, 'bt', 'Bhutan', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (32, 'bv', 'Bouvet Island', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (33, 'bw', 'Botswana', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (34, 'by', 'Belarus', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (35, 'bz', 'Belize', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (36, 'ca', 'Canada', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (37, 'cc', 'Cocos (Keeling) Islands', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (38, 'cd', 'Congo, Democratic People''s Republic', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (39, 'cf', 'Central African Republic', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (40, 'cg', 'Congo, Republic of', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (41, 'ch', 'Switzerland', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (42, 'ci', 'Cote d''Ivoire', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (43, 'ck', 'Cook Islands', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (44, 'cl', 'Chile', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (45, 'cm', 'Cameroon', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (46, 'cn', 'China', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (47, 'co', 'Colombia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (48, 'cr', 'Costa Rica', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (49, 'cu', 'Cuba', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (50, 'cv', 'Cap Verde', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (51, 'cx', 'Christmas Island', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (52, 'cy', 'Cyprus', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (53, 'cz', 'Czeck Republic', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (54, 'de', 'Germany', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (55, 'dj', 'Djibouti', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (56, 'dk', 'Denmark', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (57, 'dm', 'Dominica', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (58, 'do', 'Dominican Republic', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (59, 'dz', 'Algeria', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (60, 'ec', 'Ecuador', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (61, 'ee', 'Estonia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (62, 'eg', 'Egypt', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (63, 'eh', 'Western Sahara', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (64, 'er', 'Eritrea', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (65, 'es', 'Spain', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (66, 'et', 'Ethiopia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (67, 'fi', 'Finland', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (68, 'fj', 'Fiji', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (69, 'fk', 'Falkland Islands (Malvina)', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (70, 'fm', 'Micronesia, Federal State of', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (71, 'fo', 'Faroe Islands', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (72, 'fr', 'France', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (73, 'ga', 'Gabon', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (74, 'gd', 'Grenada', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (75, 'ge', 'Georgia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (76, 'gf', 'French Guiana', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (77, 'gg', 'Guernsey', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (78, 'gh', 'Ghana', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (79, 'gi', 'Gibraltar', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (80, 'gl', 'Greenland', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (81, 'gm', 'Gambia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (82, 'gn', 'Guinea', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (83, 'gp', 'Guadeloupe', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (84, 'gq', 'Equatorial Guinea', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (85, 'gr', 'Greece', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (86, 'gs', 'South Georgia and the South Sandwich Islands', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (87, 'gt', 'Guatemala', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (88, 'gu', 'Guam', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (89, 'gw', 'Guinea-Bissau', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (90, 'gy', 'Guyana', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (91, 'hk', 'Hong Kong', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (92, 'hm', 'Heard and McDonald Islands', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (93, 'hn', 'Honduras', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (94, 'hr', 'Croatia/Hrvatska', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (95, 'ht', 'Haiti', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (96, 'hu', 'Hungary', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (97, 'id', 'Indonesia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (98, 'ie', 'Ireland', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (99, 'il', 'Israel', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (100, 'im', 'Isle of Man', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (101, 'in', 'India', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (102, 'io', 'British Indian Ocean Territory', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (103, 'iq', 'Iraq', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (104, 'ir', 'Iran (Islamic Republic of)', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (105, 'is', 'Iceland', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (106, 'it', 'Italy', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (107, 'je', 'Jersey', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (108, 'jm', 'Jamaica', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (109, 'jo', 'Jordan', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (110, 'jp', 'Japan', 'Yen');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (111, 'ke', 'Kenya', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (112, 'kg', 'Kyrgyzstan', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (113, 'kh', 'Cambodia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (114, 'ki', 'Kiribati', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (115, 'km', 'Comoros', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (116, 'kn', 'Saint Kitts and Nevis', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (117, 'kp', 'Korea, Democratic People''s Republic', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (118, 'kr', 'Korea, Republic of', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (119, 'kw', 'Kuwait', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (120, 'ky', 'Cayman Islands', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (121, 'kz', 'Kazakhstan', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (122, 'la', 'Lao, People''s Democratic Republic', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (123, 'lb', 'Lebanon', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (124, 'lc', 'Saint Lucia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (125, 'li', 'Liechtenstein', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (126, 'lk', 'Sri Lanka', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (127, 'lr', 'Liberia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (128, 'ls', 'Lesotho', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (129, 'lt', 'Lithuania', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (130, 'lu', 'Luxembourg', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (131, 'lv', 'Latvia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (132, 'ly', 'Libyan Arab Jamahiriya', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (133, 'ma', 'Morocco', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (134, 'mc', 'Monaco', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (135, 'md', 'Moldova, Republic of', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (136, 'mg', 'Madagascar', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (137, 'mh', 'Marshall Islands', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (138, 'mk', 'Macedonia, Former Yugoslav Republic', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (139, 'ml', 'Mali', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (140, 'mm', 'Myanmar', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (141, 'mn', 'Mongolia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (142, 'mo', 'Macau', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (143, 'mp', 'Northern Mariana Islands', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (144, 'mq', 'Martinique', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (145, 'mr', 'Mauritania', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (146, 'ms', 'Montserrat', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (147, 'mt', 'Malta', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (148, 'mu', 'Mauritius', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (149, 'mv', 'Maldives', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (150, 'mw', 'Malawi', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (151, 'mx', 'Mexico', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (152, 'my', 'Malaysia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (153, 'mz', 'Mozambique', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (154, 'na', 'Namibia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (155, 'nc', 'New Caledonia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (156, 'ne', 'Niger', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (157, 'nf', 'Norfolk Island', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (158, 'ng', 'Nigeria', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (159, 'ni', 'Nicaragua', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (160, 'nl', 'Netherlands', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (161, 'no', 'Norway', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (162, 'np', 'Nepal', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (163, 'nr', 'Nauru', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (164, 'nu', 'Niue', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (165, 'nz', 'New Zealand', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (166, 'om', 'Oman', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (167, 'pa', 'Panama', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (168, 'pe', 'Peru', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (169, 'pf', 'French Polynesia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (170, 'pg', 'Papua New Guinea', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (171, 'ph', 'Philippines', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (172, 'pk', 'Pakistan', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (173, 'pl', 'Poland', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (174, 'pm', 'St. Pierre and Miquelon', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (175, 'pn', 'Pitcairn Island', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (176, 'pr', 'Puerto Rico', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (177, 'pt', 'Portugal', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (178, 'pw', 'Palau', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (179, 'py', 'Paraguay', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (180, 'qa', 'Qatar', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (181, 're', 'Reunion Island', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (182, 'ro', 'Romania', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (183, 'ru', 'Russian Federation', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (184, 'rw', 'Rwanda', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (185, 'sa', 'Saudi Arabia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (186, 'sb', 'Solomon Islands', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (187, 'sc', 'Seychelles', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (188, 'sd', 'Sudan', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (189, 'se', 'Sweden', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (190, 'sg', 'Singapore', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (191, 'sh', 'St. Helena', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (192, 'si', 'Slovenia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (193, 'sj', 'Svalbard and Jan Mayen Islands', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (194, 'sk', 'Slovak Republic', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (195, 'sl', 'Sierra Leone', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (196, 'sm', 'San Marino', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (197, 'sn', 'Senegal', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (198, 'so', 'Somalia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (199, 'sr', 'Suriname', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (200, 'st', 'Sao Tome and Principe', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (201, 'sv', 'El Salvador', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (202, 'sy', 'Syrian Arab Republic', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (203, 'sz', 'Swaziland', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (204, 'tc', 'Turks and Ciacos Islands', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (205, 'td', 'Chad', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (206, 'tf', 'French Southern Territories', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (207, 'tg', 'Togo', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (208, 'th', 'Thailand', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (209, 'tj', 'Tajikistan', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (210, 'tk', 'Tokelau', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (211, 'tm', 'Turkmenistan', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (212, 'tn', 'Tunisia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (213, 'to', 'Tonga', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (214, 'tp', 'East Timor', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (215, 'tr', 'Turkey', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (216, 'tt', 'Trinidad and Tobago', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (217, 'tv', 'Tuvalu', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (218, 'tw', 'Taiwan', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (219, 'tz', 'Tanzania', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (220, 'ua', 'Ukraine', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (221, 'ug', 'Uganda', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (222, 'uk', 'United Kingdom', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (223, 'gb', 'United Kingdom', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (224, 'um', 'US Minor Outlying Islands', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (225, 'us', 'United States', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (226, 'uy', 'Uruguay', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (227, 'uz', 'Uzbekistan', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (228, 'va', 'Holy See (City Vatican State)', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (229, 'vc', 'Saint Vincent and the Grenadines', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (230, 've', 'Venezuela', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (231, 'vg', 'Virgin Islands (British)', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (232, 'vi', 'Virgin Islands (USA)', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (233, 'vn', 'Vietnam', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (234, 'vu', 'Vanuatu', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (235, 'wf', 'Wallis and Futuna Islands', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (236, 'ws', 'Western Samoa', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (237, 'ye', 'Yemen', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (238, 'yt', 'Mayotte', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (239, 'yu', 'Yugoslavia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (240, 'za', 'South Africa', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (241, 'zm', 'Zambia', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (242, 'zr', 'Zaire', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (243, 'zw', 'Zimbabwe', '');
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (250, 'at', 'Austria', '');

http://01ftp.com

South Africa???

dima-1 commented 11 May 2005 at 19:19

I want to know why South Africa is at the end of the list???

Cause of Dutch

kbahey commented 11 May 2005 at 19:57

Because the South African language (Afrikaans) is derived from Dutch, and South in that language starts with Z.
--
Consulting: 2bits.com
Personal: Baheyeldin.com

--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba

I shoud have known

dima-1 commented 15 May 2005 at 10:38

"Zuid Afrika" of course....

United Kingdom listed twice

RichinOhio commented 20 November 2006 at 08:15

Yes, thanks so much! Hard to find this data listed in this useful way.

BTW, United Kingdom is listed twice. In the SQL version, it is listed once using the code "gb" and once as "uk". But in the plain text version you'll probably want to remove this duplicate.

And for my site, I moved Austria into the proper alphabetical order in the text version..

I would edit the comment.

pamphile commented 11 December 2006 at 13:12

I would edit the comment. But there is no ability to edit my post.

Marcel
http://www.acmetutorials.com

Another (clean) list of countries

designguru commented 11 December 2006 at 03:46

I'm sure this list is fine, but I had just compiled one on my own when I came across this post :(

The source is the Washington Post's list of Countries. Here goes:

Afghanistan
Albania
Algeria
American Samoa
Andorra
Angola
Anguilla
Antarctica
Antigua
Argentina
Armenia
Aruba
Australia
Austria
Azerbaijan
Bahamas
Bahrain
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bermuda
Bhutan
Bolivia
Bosnia and Herzegovina
Botswana
Brazil
British Virgin Islands
Brunei
Bulgaria
Burkina Faso
Burma
Burundi
Cambodia
Cameroon
Canada
Cape Verde
Central African Republic
Chad
Chile
China
Colombia
Comoros
Congo (Zaire)
Congo
Cook Islands
Costa Rica
Cote d'Ivoire (Ivory Coast)
Croatia
Cuba
Cyprus
Czech Republic
Denmark
Djibouti
Dominica
Dominican Republic
Ecuador
Egypt
El Salvador
Equatorial Guinea
Eritrea
Estonia
Ethiopia
Falkland Islands
Fiji
Finland
France
French Guiana
French Polynesia
Gabon
The Gambia
Gaza Strip and West Bank
Georgia
Germany
Ghana
Gibraltar
Greece
Greenland
Grenada
Guadeloupe
Guam
Guatemala
Guinea
Guinea-Bissau
Guyana
Haiti
The Holy See
Honduras
Hong Kong
Hungary
Iceland
India
Indonesia
Iran
Iraq
Ireland
Israel
Italy
Jamaica
Japan
Jordan
Kazakhstan
Kenya
Kiribati
Kuwait
Kyrgyzstan
Laos
Latvia
Lebanon
Lesotho
Liberia
Libya
Liechtenstein
Lithuania
Luxembourg
Macau
Macedonia
Madagascar
Malawi
Malaysia
Maldives
Mali
Malta
Marshall Islands
Martinique
Mauritania
Mauritius
Mayotte
Mexico
Federated States of Micronesia
Moldova
Monaco
Mongolia
Montserrat
Morocco
Mozambique
Namibia
Nauru
Nepal
Netherlands
Netherlands Antilles
New Caledonia
New Zealand
Nicaragua
Niger
Nigeria
North Korea
Northern Mariana Islands
Norway
Oman
Pakistan
Palau
Panama
Papua New Guinea
Paraguay
Peru
Philippines
Pitcairn Islands
Poland
Portugal
Puerto Rico
Qatar
Reunion
Romania
Russia
Rwanda
Saint Kitts and Nevis
Saint Lucia
Saint Pierre and Miquelon
Saint Vincent and the Grenadines
Samoa
San Marino
Sao Tome and Principe
Saudi Arabia
Senegal
Serbia and Montenegro (Yugoslavia)
Seychelles
Sierra Leone
Singapore
Slovakia
Slovenia
Solomon Islands
Somalia
South Africa
South Korea
Spain
Sri Lanka
Sudan
Suriname
Swaziland
Sweden
Switzerland
Syria
Taiwan
Tajikistan
Tanzania
Thailand
Togo
Tonga
Trinidad and Tobago
Tunisia
Turkey
Turkmenistan
Turks and Caicos Islands
Tuvalu
Uganda
Ukraine
United Arab Emirates
United Kingdom
United States
United States Virgin Islands
Uruguay
Uzbekistan
Vanuatu
Venezuela
Vietnam
West Bank and Gaza Strip
Western Sahara
Yemen
Zambia
Zimbabwe