Here is the Code to create a complete Country table in MySQL. NOTE that you need to change the [TABLEPREFIX] to whatever you want. For JOOMLA this would normally be jos_country :
CREATE TABLE IF NOT EXISTS `[TABLEPREFIX]country`(
`id` INTEGER unsigned NOT NULL auto_increment,
`cty_name_20` varchar(20) NOT NULL,
`cty_name_25` varchar(25) NOT NULL,
`cty_name_30` varchar(30) NOT NULL,
`cty_name_100` varchar(100) NOT NULL,
`cty_common_name_20` varchar(20) NOT NULL,
`cty_iso_3166_2` varchar(2) NOT NULL,
`cty_iso_3166_3` varchar(3) NOT NULL,
`cty_continent` varchar(15) NOT NULL default '',
`cty_has_states` varchar(10) NOT NULL default '',
`cty_has_postal_codes` varchar(7) NOT NULL default 'Unknown',
`cty_postal_code_format_javascript` text NOT NULL default '',
`cty_phone_number_format_javascript` text NOT NULL default '',
`cty_SSN_format_javascript` text NOT NULL default '',
PRIMARY KEY(`id`),
UNIQUE KEY `cty_iso_3166_2` (`cty_iso_3166_2`),
UNIQUE KEY `cty_iso_3166_3` (`cty_iso_3166_3`),
KEY `cty_name_20` (`cty_name_20`),
KEY `cty_name_25` (`cty_name_25`),
KEY `cty_name_30` (`cty_name_30`),
KEY `cty_name_100` (`cty_name_100`)
)
INSERT DELAYED INTO `jos_country` (`id`, `cty_name_20`, `cty_name_25`, `cty_name_30`, `cty_name_100`, `cty_common_name_20`, `cty_iso_3166_2`, `cty_iso_3166_3`, `cty_continent`, `cty_has_states`, `cty_has_postal_codes`, `cty_postal_code_format_javascript`, `cty_phone_number_format_javascript`, `cty_SSN_format_javascript`) VALUES
(1, 'Aruba', 'Aruba', 'Aruba', 'Aruba', 'Aruba', 'AW', 'ABW', 'North America', '', 'Unknown', '', '', ''),
(2, 'Afghanistan', 'Afghanistan', 'Afghanistan', 'Afghanistan', 'Afghanistan', 'AF', 'AFG', 'Asia', '', 'Unknown', '', '', ''),
(3, 'Angola', 'Angola', 'Angola', 'Angola', 'Angola', 'AO', 'AGO', 'Africa', '', 'Unknown', '', '', ''),
(4, 'Anguilla', 'Anguilla', 'Anguilla', 'Anguilla', 'Anguilla', 'AI', 'AIA', 'North America', '', 'Unknown', '', '', ''),
(5, 'Åland Islands', 'Åland Islands', 'Åland Islands', 'Åland Islands', 'Åland Islands', 'AX', 'ALA', 'Europe', '', 'Unknown', '', '', ''),
(6, 'Albania', 'Albania', 'Albania', 'Albania', 'Albania', 'AL', 'ALB', 'Europe', '', 'Unknown', '', '', ''),
(7, 'Andorra', 'Andorra', 'Andorra', 'Andorra', 'Andorra', 'AD', 'AND', 'Europe', '', 'Unknown', '', '', ''),
(8, 'Netherlands Antilles', 'Netherlands Antilles', 'Netherlands Antilles', 'Netherlands Antilles', 'Netherlands Antilles', 'AN', 'ANT', 'North America', '', 'Unknown', '', '', ''),
(9, 'United Arab Emirates', 'United Arab Emirates', 'United Arab Emirates', 'United Arab Emirates', 'United Arab Emirates', 'AE', 'ARE', 'Asia', '', 'Unknown', '', '', ''),
(10, 'Argentina', 'Argentina', 'Argentina', 'Argentina', 'Argentina', 'AR', 'ARG', 'South America', 'province', 'Unknown', '', '', ''),
(11, 'Armenia', 'Armenia', 'Armenia', 'Armenia', 'Armenia', 'AM', 'ARM', 'Asia', 'region', 'Unknown', '', '', ''),
(12, 'American Samoa', 'American Samoa', 'American Samoa', 'American Samoa', 'American Samoa', 'AS', 'ASM', 'Oceania', '', 'Unknown', '', '', ''),
(13, 'Antarctica', 'Antarctica', 'Antarctica', 'Antarctica', 'Antarctica', 'AQ', 'ATA', 'Antartica', '', 'Unknown', '', '', ''),
(14, 'French South Terr.', 'French South Terr.', 'French Southern Territories', 'French Southern Territories', 'French South Terr.', 'TF', 'ATF', 'Antartica', '', 'Unknown', '', '', ''),
(15, 'Antigua and Barbuda', 'Antigua and Barbuda', 'Antigua and Barbuda', 'Antigua and Barbuda', 'Antigua and Barbuda', 'AG', 'ATG', 'North America', '', 'Unknown', '', '', ''),
(16, 'Australia', 'Australia', 'Australia', 'Australia', 'Australia', 'AU', 'AUS', 'Oceania', 'state', 'Unknown', '', '', ''),
(17, 'Austria', 'Austria', 'Austria', 'Austria', 'Austria', 'AT', 'AUT', 'Europe', '', 'Unknown', '', '', ''),
(18, 'Azerbaijan', 'Azerbaijan', 'Azerbaijan', 'Azerbaijan', 'Azerbaijan', 'AZ', 'AZE', 'Asia', 'rayon', 'Unknown', '', '', ''),
(19, 'Burundi', 'Burundi', 'Burundi', 'Burundi', 'Burundi', 'BI', 'BDI', 'Africa', '', 'Unknown', '', '', ''),
(20, 'Belgium', 'Belgium', 'Belgium', 'Belgium', 'Belgium', 'BE', 'BEL', 'Europe', '', 'Unknown', '', '', ''),
(21, 'Benin', 'Benin', 'Benin', 'Benin', 'Benin', 'BJ', 'BEN', 'Africa', '', 'Unknown', '', '', ''),
(22, 'Burkina Faso', 'Burkina Faso', 'Burkina Faso', 'Burkina Faso', 'Burkina Faso', 'BF', 'BFA', 'Africa', '', 'Unknown', '', '', ''),
(23, 'Bangladesh', 'Bangladesh', 'Bangladesh', 'Bangladesh', 'Bangladesh', 'BD', 'BGD', 'Asia', '', 'Unknown', '', '', ''),
(24, 'Bulgaria', 'Bulgaria', 'Bulgaria', 'Bulgaria', 'Bulgaria', 'BG', 'BGR', 'Europe', '', 'Unknown', '', '', ''),
(25, 'Bahrain', 'Bahrain', 'Bahrain', 'Bahrain', 'Bahrain', 'BH', 'BHR', 'Asia', '', 'Unknown', '', '', ''),
(26, 'Bahamas', 'Bahamas', 'Bahamas', 'Bahamas', 'Bahamas', 'BS', 'BHS', 'North America', '', 'Unknown', '', '', ''),
(27, 'Bosnia Herzegovina', 'Bosnia and Herzegovina', 'Bosnia and Herzegovina', 'Bosnia and Herzegovina', 'Bosnia Herzegovina', 'BA', 'BIH', 'Europe', '', 'Unknown', '', '', ''),
(28, 'Saint Barthélemy', 'Saint Barthélemy', 'Saint Barthélemy', 'Saint Barthélemy', 'Saint Barthélemy', 'BL', 'BLM', 'North America', '', 'Unknown', '', '', ''),
(29, 'Belarus', 'Belarus', 'Belarus', 'Belarus', 'Belarus', 'BY', 'BLR', 'Europe', '', 'Unknown', '', '', ''),
(30, 'Belize', 'Belize', 'Belize', 'Belize', 'Belize', 'BZ', 'BLZ', 'North America', '', 'Unknown', '', '', ''),
(31, 'Bermuda', 'Bermuda', 'Bermuda', 'Bermuda', 'Bermuda', 'BM', 'BMU', 'North America', '', 'Unknown', '', '', ''),
(32, 'Bolivia', 'Bolivia', 'Bolivia', 'Bolivia, Plurinational State of', 'Bolivia', 'BO', 'BOL', 'South America', '', 'Unknown', '', '', ''),
(33, 'Brazil', 'Brazil', 'Brazil', 'Brazil', 'Brazil', 'BR', 'BRA', 'South America', 'state', 'Unknown', '', '', ''),
(34, 'Barbados', 'Barbados', 'Barbados', 'Barbados', 'Barbados', 'BB', 'BRB', 'North America', '', 'Unknown', '', '', ''),
(35, 'Brunei Darussalam', 'Brunei Darussalam', 'Brunei Darussalam', 'Brunei Darussalam', 'Brunei Darussalam', 'BN', 'BRN', 'Asia', '', 'Unknown', '', '', ''),
(36, 'Bhutan', 'Bhutan', 'Bhutan', 'Bhutan', 'Bhutan', 'BT', 'BTN', 'Asia', '', 'Unknown', '', '', ''),
(37, 'Bouvet Island', 'Bouvet Island', 'Bouvet Island', 'Bouvet Island', 'Bouvet Island', 'BV', 'BVT', 'Antartica', '', 'Unknown', '', '', ''),
(38, 'Botswana', 'Botswana', 'Botswana', 'Botswana', 'Botswana', 'BW', 'BWA', 'Africa', '', 'Unknown', '', '', ''),
(39, 'Central African Rep', 'Central African Republic', 'Central African Republic', 'Central African Republic', 'Central African Rep', 'CF', 'CAF', 'Africa', 'prefecture', 'Unknown', '', '', ''),
(40, 'Canada', 'Canada', 'Canada', 'Canada', 'Canada', 'CA', 'CAN', 'North America', 'province', 'Unknown', '', '', ''),
(41, 'Cocos (Keeling) Isl', 'Cocos (Keeling) Islands', 'Cocos (Keeling) Islands', 'Cocos (Keeling) Islands', 'Cocos (Keeling) Isl', 'CC', 'CCK', 'Asia', '', 'Unknown', '', '', ''),
(42, 'Switzerland', 'Switzerland', 'Switzerland', 'Switzerland', 'Switzerland', 'CH', 'CHE', 'Europe', '', 'Unknown', '', '', ''),
(43, 'Chile', 'Chile', 'Chile', 'Chile', 'Chile', 'CL', 'CHL', 'South America', '', 'Unknown', '', '', ''),
(44, 'China', 'China', 'China', 'China', 'China', 'CN', 'CHN', 'Asia', 'province', 'Unknown', '', '', ''),
(45, 'Côte d Ivoire', 'Côte d Ivoire', 'Côte d Ivoire', 'Côte d Ivoire', 'Côte d Ivoire', 'CI', 'CIV', 'Africa', '', 'Unknown', '', '', ''),
(46, 'Cameroon', 'Cameroon', 'Cameroon', 'Cameroon', 'Cameroon', 'CM', 'CMR', 'Africa', '', 'Unknown', '', '', ''),
(47, 'Congo', 'Congo', 'Congo, Democratic Republic', 'Congo, the Democratic Republic of the', 'Congo', 'CD', 'COD', 'Africa', 'province', 'Unknown', '', '', ''),
(48, 'Congo', 'Congo', 'Congo', 'Congo', 'Congo', 'CG', 'COG', 'Africa', 'region', 'Unknown', '', '', ''),
(49, 'Cook Islands', 'Cook Islands', 'Cook Islands', 'Cook Islands', 'Cook Islands', 'CK', 'COK', 'Oceania', '', 'Unknown', '', '', ''),
(50, 'Colombia', 'Colombia', 'Colombia', 'Colombia', 'Colombia', 'CO', 'COL', 'South America', 'department', 'Unknown', '', '', ''),
(51, 'Comoros', 'Comoros', 'Comoros', 'Comoros', 'Comoros', 'KM', 'COM', 'Africa', '', 'Unknown', '', '', ''),
(52, 'Cape Verde', 'Cape Verde', 'Cape Verde', 'Cape Verde', 'Cape Verde', 'CV', 'CPV', 'Africa', '', 'Unknown', '', '', ''),
(53, 'Costa Rica', 'Costa Rica', 'Costa Rica', 'Costa Rica', 'Costa Rica', 'CR', 'CRI', 'North America', '', 'Unknown', '', '', ''),
(54, 'Cuba', 'Cuba', 'Cuba', 'Cuba', 'Cuba', 'CU', 'CUB', 'North America', 'province', 'Unknown', '', '', ''),
(55, 'Christmas Island', 'Christmas Island', 'Christmas Island', 'Christmas Island', 'Christmas Island', 'CX', 'CXR', 'Asia', '', 'Unknown', '', '', ''),
(56, 'Cayman Islands', 'Cayman Islands', 'Cayman Islands', 'Cayman Islands', 'Cayman Islands', 'KY', 'CYM', 'North America', '', 'Unknown', '', '', ''),
(57, 'Cyprus', 'Cyprus', 'Cyprus', 'Cyprus', 'Cyprus', 'CY', 'CYP', 'Asia', '', 'Unknown', '', '', ''),
(58, 'Czech Republic', 'Czech Republic', 'Czech Republic', 'Czech Republic', 'Czech Republic', 'CZ', 'CZE', 'Europe', '', 'Unknown', '', '', ''),
(59, 'Germany', 'Germany', 'Germany', 'Germany', 'Germany', 'DE', 'DEU', 'Europe', '', 'Unknown', '', '', ''),
(60, 'Djibouti', 'Djibouti', 'Djibouti', 'Djibouti', 'Djibouti', 'DJ', 'DJI', 'Africa', 'region', 'Unknown', '', '', ''),
(61, 'Dominica', 'Dominica', 'Dominica', 'Dominica', 'Dominica', 'DM', 'DMA', 'North America', '', 'Unknown', '', '', ''),
(62, 'Denmark', 'Denmark', 'Denmark', 'Denmark', 'Denmark', 'DK', 'DNK', 'Europe', 'county', 'Unknown', '', '', ''),
(63, 'Dominican Republic', 'Dominican Republic', 'Dominican Republic', 'Dominican Republic', 'Dominican Republic', 'DO', 'DOM', 'North America', 'province', 'Unknown', '', '', ''),
(64, 'Algeria', 'Algeria', 'Algeria', 'Algeria', 'Algeria', 'DZ', 'DZA', 'Africa', '', 'Unknown', '', '', ''),
(65, 'Ecuador', 'Ecuador', 'Ecuador', 'Ecuador', 'Ecuador', 'EC', 'ECU', 'South America', '', 'Unknown', '', '', ''),
(66, 'Egypt', 'Egypt', 'Egypt', 'Egypt', 'Egypt', 'EG', 'EGY', 'Africa', '', 'Unknown', '', '', ''),
(67, 'Eritrea', 'Eritrea', 'Eritrea', 'Eritrea', 'Eritrea', 'ER', 'ERI', 'Africa', '', 'Unknown', '', '', ''),
(68, 'Western Sahara', 'Western Sahara', 'Western Sahara', 'Western Sahara', 'Western Sahara', 'EH', 'ESH', 'Africa', '', 'Unknown', '', '', ''),
(69, 'Spain', 'Spain', 'Spain', 'Spain', 'Spain', 'ES', 'ESP', 'Europe', 'province', 'Unknown', '', '', ''),
(70, 'Estonia', 'Estonia', 'Estonia', 'Estonia', 'Estonia', 'EE', 'EST', 'Europe', '', 'Unknown', '', '', ''),
(71, 'Ethiopia', 'Ethiopia', 'Ethiopia', 'Ethiopia', 'Ethiopia', 'ET', 'ETH', 'Africa', 'state', 'Unknown', '', '', ''),
(72, 'Finland', 'Finland', 'Finland', 'Finland', 'Finland', 'FI', 'FIN', 'Europe', '', 'Unknown', '', '', ''),
(73, 'Fiji', 'Fiji', 'Fiji', 'Fiji', 'Fiji', 'FJ', 'FJI', 'Oceania', 'division', 'Unknown', '', '', ''),
(74, 'Falkland Islands', 'Falkland Islands', 'Falkland Islands (Malvinas)', 'Falkland Islands (Malvinas)', 'Falkland Islands', 'FK', 'FLK', 'South America', '', 'Unknown', '', '', ''),
(75, 'France', 'France', 'France', 'France', 'France', 'FR', 'FRA', 'Europe', 'province', 'Unknown', '', '', ''),
(76, 'Faroe Islands', 'Faroe Islands', 'Faroe Islands', 'Faroe Islands', 'Faroe Islands', 'FO', 'FRO', 'Europe', '', 'Unknown', '', '', ''),
(77, 'Micronesia', 'Micronesia', 'Micronesia, Federated States', 'Micronesia, Federated States of', 'Micronesia', 'FM', 'FSM', 'Oceania', '', 'Unknown', '', '', ''),
(78, 'Gabon', 'Gabon', 'Gabon', 'Gabon', 'Gabon', 'GA', 'GAB', 'Africa', '', 'Unknown', '', '', ''),
(79, 'United Kingdom', 'United Kingdom', 'United Kingdom', 'United Kingdom', 'United Kingdom', 'GB', 'GBR', 'Europe', '', 'Unknown', '', '', ''),
(80, 'Georgia', 'Georgia', 'Georgia', 'Georgia', 'Georgia', 'GE', 'GEO', 'Asia', 'region', 'Unknown', '', '', ''),
(81, 'Guernsey', 'Guernsey', 'Guernsey', 'Guernsey', 'Guernsey', 'GG', 'GGY', 'Europe', '', 'Unknown', '', '', ''),
(82, 'Ghana', 'Ghana', 'Ghana', 'Ghana', 'Ghana', 'GH', 'GHA', 'Africa', '', 'Unknown', '', '', ''),
(83, 'Gibraltar', 'Gibraltar', 'Gibraltar', 'Gibraltar', 'Gibraltar', 'GI', 'GIB', 'Europe', '', 'Unknown', '', '', ''),
(84, 'Guinea', 'Guinea', 'Guinea', 'Guinea', 'Guinea', 'GN', 'GIN', 'Africa', '', 'Unknown', '', '', ''),
(85, 'Guadeloupe', 'Guadeloupe', 'Guadeloupe', 'Guadeloupe', 'Guadeloupe', 'GP', 'GLP', 'North America', '', 'Unknown', '', '', ''),
(86, 'Gambia', 'Gambia', 'Gambia', 'Gambia', 'Gambia', 'GM', 'GMB', 'Africa', 'division', 'Unknown', '', '', ''),
(87, 'Guinea-Bissau', 'Guinea-Bissau', 'Guinea-Bissau', 'Guinea-Bissau', 'Guinea-Bissau', 'GW', 'GNB', 'Africa', 'region', 'Unknown', '', '', ''),
(88, 'Equatorial Guinea', 'Equatorial Guinea', 'Equatorial Guinea', 'Equatorial Guinea', 'Equatorial Guinea', 'GQ', 'GNQ', 'Africa', 'province', 'Unknown', '', '', ''),
(89, 'Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'GR', 'GRC', 'Europe', 'department', 'Unknown', '', '', ''),
(90, 'Grenada', 'Grenada', 'Grenada', 'Grenada', 'Grenada', 'GD', 'GRD', 'North America', '', 'Unknown', '', '', ''),
(91, 'Greenland', 'Greenland', 'Greenland', 'Greenland', 'Greenland', 'GL', 'GRL', 'North America', '', 'Unknown', '', '', ''),
(92, 'Guatemala', 'Guatemala', 'Guatemala', 'Guatemala', 'Guatemala', 'GT', 'GTM', 'North America', '', 'Unknown', '', '', ''),
(93, 'French Guiana', 'French Guiana', 'French Guiana', 'French Guiana', 'French Guiana', 'GF', 'GUF', 'South America', '', 'Unknown', '', '', ''),
(94, 'Guam', 'Guam', 'Guam', 'Guam', 'Guam', 'GU', 'GUM', 'Oceania', '', 'Unknown', '', '', ''),
(95, 'Guyana', 'Guyana', 'Guyana', 'Guyana', 'Guyana', 'GY', 'GUY', 'South America', '', 'Unknown', '', '', ''),
(96, 'Hong Kong', 'Hong Kong', 'Hong Kong', 'Hong Kong', 'Hong Kong', 'HK', 'HKG', 'Asia', '', 'Unknown', '', '', ''),
(97, 'Heard McDonald Isl.', 'Heard McDonald Isl.', 'Heard and McDonald Islands', 'Heard Island and McDonald Islands', 'Heard McDonald Isl.', 'HM', 'HMD', 'Antartica', '', 'Unknown', '', '', ''),
(98, 'Honduras', 'Honduras', 'Honduras', 'Honduras', 'Honduras', 'HN', 'HND', 'North America', '', 'Unknown', '', '', ''),
(99, 'Croatia', 'Croatia', 'Croatia', 'Croatia', 'Croatia', 'HR', 'HRV', 'Europe', 'county', 'Unknown', '', '', ''),
(100, 'Haiti', 'Haiti', 'Haiti', 'Haiti', 'Haiti', 'HT', 'HTI', 'North America', '', 'Unknown', '', '', ''),
(101, 'Hungary', 'Hungary', 'Hungary', 'Hungary', 'Hungary', 'HU', 'HUN', 'Europe', 'division', 'Unknown', '', '', ''),
(102, 'Indonesia', 'Indonesia', 'Indonesia', 'Indonesia', 'Indonesia', 'ID', 'IDN', 'Asia', 'province', 'Unknown', '', '', ''),
(103, 'Isle of Man', 'Isle of Man', 'Isle of Man', 'Isle of Man', 'Isle of Man', 'IM', 'IMN', 'Europe', '', 'Unknown', '', '', ''),
(104, 'India', 'India', 'India', 'India', 'India', 'IN', 'IND', 'Asia', 'state', 'Unknown', '', '', ''),
(105, 'British Indian Terr', 'British Indian Oc. Terr.', 'British Indian Ocean Territory', 'British Indian Ocean Territory', 'British Indian Terr', 'IO', 'IOT', 'Asia', '', 'Unknown', '', '', ''),
(106, 'Ireland', 'Ireland', 'Ireland', 'Ireland', 'Ireland', 'IE', 'IRL', 'Europe', '', 'Unknown', '', '', ''),
(107, 'Iran', 'Iran, Islamic Republic of', 'Iran, Islamic Republic of', 'Iran, Islamic Republic of', 'Iran', 'IR', 'IRN', 'Asia', '', 'Unknown', '', '', ''),
(108, 'Iraq', 'Iraq', 'Iraq', 'Iraq', 'Iraq', 'IQ', 'IRQ', 'Asia', '', 'Unknown', '', '', ''),
(109, 'Iceland', 'Iceland', 'Iceland', 'Iceland', 'Iceland', 'IS', 'ISL', 'Europe', '', 'Unknown', '', '', ''),
(110, 'Israel', 'Israel', 'Israel', 'Israel', 'Israel', 'IL', 'ISR', 'Asia', '', 'Unknown', '', '', ''),
(111, 'Italy', 'Italy', 'Italy', 'Italy', 'Italy', 'IT', 'ITA', 'Europe', '', 'Unknown', '', '', ''),
(112, 'Jamaica', 'Jamaica', 'Jamaica', 'Jamaica', 'Jamaica', 'JM', 'JAM', 'North America', '', 'Unknown', '', '', ''),
(113, 'Jersey', 'Jersey', 'Jersey', 'Jersey', 'Jersey', 'JE', 'JEY', 'Europe', '', 'Unknown', '', '', ''),
(114, 'Jordan', 'Jordan', 'Jordan', 'Jordan', 'Jordan', 'JO', 'JOR', 'Asia', '', 'Unknown', '', '', ''),
(115, 'Japan', 'Japan', 'Japan', 'Japan', 'Japan', 'JP', 'JPN', 'Asia', '', 'Unknown', '', '', ''),
(116, 'Kazakhstan', 'Kazakhstan', 'Kazakhstan', 'Kazakhstan', 'Kazakhstan', 'KZ', 'KAZ', 'Asia', 'region', 'Unknown', '', '', ''),
(117, 'Kenya', 'Kenya', 'Kenya', 'Kenya', 'Kenya', 'KE', 'KEN', 'Africa', 'province', 'Unknown', '', '', ''),
(118, 'Kyrgyzstan', 'Kyrgyzstan', 'Kyrgyzstan', 'Kyrgyzstan', 'Kyrgyzstan', 'KG', 'KGZ', 'Asia', 'region', 'Unknown', '', '', ''),
(119, 'Cambodia', 'Cambodia', 'Cambodia', 'Cambodia', 'Cambodia', 'KH', 'KHM', 'Asia', 'province', 'Unknown', '', '', ''),
(120, 'Kiribati', 'Kiribati', 'Kiribati', 'Kiribati', 'Kiribati', 'KI', 'KIR', 'Oceania', '', 'Unknown', '', '', ''),
(121, 'St Kitts and Nevis', 'Saint Kitts and Nevis', 'Saint Kitts and Nevis', 'Saint Kitts and Nevis', 'Saint Kitts', 'KN', 'KNA', 'North America', '', 'Unknown', '', '', ''),
(122, 'Korea, Republic of', 'Korea, Republic of', 'Korea, Republic of', 'Korea, Republic of', 'Korea', 'KR', 'KOR', 'Asia', 'province', 'Unknown', '', '', ''),
(123, 'Kuwait', 'Kuwait', 'Kuwait', 'Kuwait', 'Kuwait', 'KW', 'KWT', 'Asia', '', 'Unknown', '', '', ''),
(124, 'Laos', 'Laos', 'Laos', 'Lao Peoples Democratic Republic', 'Laos', 'LA', 'LAO', 'Asia', 'province', 'Unknown', '', '', ''),
(125, 'Lebanon', 'Lebanon', 'Lebanon', 'Lebanon', 'Lebanon', 'LB', 'LBN', 'Asia', '', 'Unknown', '', '', ''),
(126, 'Liberia', 'Liberia', 'Liberia', 'Liberia', 'Liberia', 'LR', 'LBR', 'Africa', '', 'Unknown', '', '', ''),
(127, 'Libya', 'Libyan Arab Jamahiriya', 'Libyan Arab Jamahiriya', 'Libyan Arab Jamahiriya', 'Libya', 'LY', 'LBY', 'Africa', '', 'Unknown', '', '', ''),
(128, 'Saint Lucia', 'Saint Lucia', 'Saint Lucia', 'Saint Lucia', 'Saint Lucia', 'LC', 'LCA', 'North America', '', 'Unknown', '', '', ''),
(129, 'Liechtenstein', 'Liechtenstein', 'Liechtenstein', 'Liechtenstein', 'Liechtenstein', 'LI', 'LIE', 'Europe', '', 'Unknown', '', '', ''),
(130, 'Sri Lanka', 'Sri Lanka', 'Sri Lanka', 'Sri Lanka', 'Sri Lanka', 'LK', 'LKA', 'Asia', '', 'Unknown', '', '', ''),
(131, 'Lesotho', 'Lesotho', 'Lesotho', 'Lesotho', 'Lesotho', 'LS', 'LSO', 'Africa', '', 'Unknown', '', '', ''),
(132, 'Lithuania', 'Lithuania', 'Lithuania', 'Lithuania', 'Lithuania', 'LT', 'LTU', 'Europe', '', 'Unknown', '', '', ''),
(133, 'Luxembourg', 'Luxembourg', 'Luxembourg', 'Luxembourg', 'Luxembourg', 'LU', 'LUX', 'Europe', '', 'Unknown', '', '', ''),
(134, 'Latvia', 'Latvia', 'Latvia', 'Latvia', 'Latvia', 'LV', 'LVA', 'Europe', 'district', 'Unknown', '', '', ''),
(135, 'Macao', 'Macao', 'Macao', 'Macao', 'Macao', 'MO', 'MAC', 'Asia', '', 'Unknown', '', '', ''),
(136, 'Saint Martin', 'Saint Martin (French)', 'Saint Martin (French part)', 'Saint Martin (French part)', 'Saint Martin', 'MF', 'MAF', 'North America', '', 'Unknown', '', '', ''),
(137, 'Morocco', 'Morocco', 'Morocco', 'Morocco', 'Morocco', 'MA', 'MAR', 'Africa', '', 'Unknown', '', '', ''),
(138, 'Monaco', 'Monaco', 'Monaco', 'Monaco', 'Monaco', 'MC', 'MCO', 'Europe', '', 'Unknown', '', '', ''),
(139, 'Moldova, Republic of', 'Moldova, Republic of', 'Moldova, Republic of', 'Moldova, Republic of', 'Moldova', 'MD', 'MDA', 'Europe', 'district', 'Unknown', '', '', ''),
(140, 'Madagascar', 'Madagascar', 'Madagascar', 'Madagascar', 'Madagascar', 'MG', 'MDG', 'Africa', '', 'Unknown', '', '', ''),
(141, 'Maldives', 'Maldives', 'Maldives', 'Maldives', 'Maldives', 'MV', 'MDV', 'Asia', 'adm. atoll', 'Unknown', '', '', ''),
(142, 'Mexico', 'Mexico', 'Mexico', 'Mexico', 'Mexico', 'MX', 'MEX', 'North America', 'state', 'Unknown', '', '', ''),
(143, 'Marshall Islands', 'Marshall Islands', 'Marshall Islands', 'Marshall Islands', 'Marshall Islands', 'MH', 'MHL', 'Oceania', '', 'Unknown', '', '', ''),
(144, 'Macedonia', 'Macedonia', 'Macedonia', 'Macedonia, the former Yugoslav Republic of', 'Macedonia', 'MK', 'MKD', 'Europe', '', 'Unknown', '', '', ''),
(145, 'Mali', 'Mali', 'Mali', 'Mali', 'Mali', 'ML', 'MLI', 'Africa', 'region', 'Unknown', '', '', ''),
(146, 'Malta', 'Malta', 'Malta', 'Malta', 'Malta', 'MT', 'MLT', 'Europe', '', 'Unknown', '', '', ''),
(147, 'Myanmar', 'Myanmar', 'Myanmar', 'Myanmar', 'Myanmar', 'MM', 'MMR', 'Asia', 'province', 'Unknown', '', '', ''),
(148, 'Montenegro', 'Montenegro', 'Montenegro', 'Montenegro', 'Montenegro', 'ME', 'MNE', 'Europe', '', 'Unknown', '', '', ''),
(149, 'Mongolia', 'Mongolia', 'Mongolia', 'Mongolia', 'Mongolia', 'MN', 'MNG', 'Asia', 'province', 'Unknown', '', '', ''),
(150, 'North Mariana Isls', 'Northern Mariana Islands', 'Northern Mariana Islands', 'Northern Mariana Islands', 'North Mariana Isls', 'MP', 'MNP', 'Oceania', '', 'Unknown', '', '', ''),
(151, 'Mozambique', 'Mozambique', 'Mozambique', 'Mozambique', 'Mozambique', 'MZ', 'MOZ', 'Africa', 'province', 'Unknown', '', '', ''),
(152, 'Mauritania', 'Mauritania', 'Mauritania', 'Mauritania', 'Mauritania', 'MR', 'MRT', 'Africa', 'region', 'Unknown', '', '', ''),
(153, 'Montserrat', 'Montserrat', 'Montserrat', 'Montserrat', 'Montserrat', 'MS', 'MSR', 'North America', '', 'Unknown', '', '', ''),
(154, 'Martinique', 'Martinique', 'Martinique', 'Martinique', 'Martinique', 'MQ', 'MTQ', 'North America', '', 'Unknown', '', '', ''),
(155, 'Mauritius', 'Mauritius', 'Mauritius', 'Mauritius', 'Mauritius', 'MU', 'MUS', 'Africa', 'district', 'Unknown', '', '', ''),
(156, 'Malawi', 'Malawi', 'Malawi', 'Malawi', 'Malawi', 'MW', 'MWI', 'Africa', '', 'Unknown', '', '', ''),
(157, 'Malaysia', 'Malaysia', 'Malaysia', 'Malaysia', 'Malaysia', 'MY', 'MYS', 'Asia', 'state', 'Unknown', '', '', ''),
(158, 'Mayotte', 'Mayotte', 'Mayotte', 'Mayotte', 'Mayotte', 'YT', 'MYT', 'Africa', '', 'Unknown', '', '', ''),
(159, 'Namibia', 'Namibia', 'Namibia', 'Namibia', 'Namibia', 'NA', 'NAM', 'Africa', '', 'Unknown', '', '', ''),
(160, 'New Caledonia', 'New Caledonia', 'New Caledonia', 'New Caledonia', 'New Caledonia', 'NC', 'NCL', 'Oceania', '', 'Unknown', '', '', ''),
(161, 'Niger', 'Niger', 'Niger', 'Niger', 'Niger', 'NE', 'NER', 'Africa', 'department', 'Unknown', '', '', ''),
(162, 'Norfolk Island', 'Norfolk Island', 'Norfolk Island', 'Norfolk Island', 'Norfolk Island', 'NF', 'NFK', 'Oceania', '', 'Unknown', '', '', ''),
(163, 'Nigeria', 'Nigeria', 'Nigeria', 'Nigeria', 'Nigeria', 'NG', 'NGA', 'Africa', 'state', 'Unknown', '', '', ''),
(164, 'Nicaragua', 'Nicaragua', 'Nicaragua', 'Nicaragua', 'Nicaragua', 'NI', 'NIC', 'North America', 'department', 'Unknown', '', '', ''),
(165, 'Niue', 'Niue', 'Niue', 'Niue', 'Niue', 'NU', 'NIU', 'Oceania', '', 'Unknown', '', '', ''),
(166, 'Netherlands', 'Netherlands', 'Netherlands', 'Netherlands', 'Netherlands', 'NL', 'NLD', 'Europe', '', 'Unknown', '', '', ''),
(167, 'Norway', 'Norway', 'Norway', 'Norway', 'Norway', 'NO', 'NOR', 'Europe', '', 'Unknown', '', '', ''),
(168, 'Nepal', 'Nepal', 'Nepal', 'Nepal', 'Nepal', 'NP', 'NPL', 'Asia', '', 'Unknown', '', '', ''),
(169, 'Nauru', 'Nauru', 'Nauru', 'Nauru', 'Nauru', 'NR', 'NRU', 'Oceania', '', 'Unknown', '', '', ''),
(170, 'New Zealand', 'New Zealand', 'New Zealand', 'New Zealand', 'New Zealand', 'NZ', 'NZL', 'Oceania', '', 'Unknown', '', '', ''),
(171, 'Oman', 'Oman', 'Oman', 'Oman', 'Oman', 'OM', 'OMN', 'Asia', '', 'Unknown', '', '', ''),
(172, 'Pakistan', 'Pakistan', 'Pakistan', 'Pakistan', 'Pakistan', 'PK', 'PAK', 'Asia', 'province', 'Unknown', '', '', ''),
(173, 'Panama', 'Panama', 'Panama', 'Panama', 'Panama', 'PA', 'PAN', 'North America', 'province', 'Unknown', '', '', ''),
(174, 'Pitcairn', 'Pitcairn', 'Pitcairn', 'Pitcairn', 'Pitcairn', 'PN', 'PCN', 'Oceania', '', 'Unknown', '', '', ''),
(175, 'Peru', 'Peru', 'Peru', 'Peru', 'Peru', 'PE', 'PER', 'South America', 'department', 'Unknown', '', '', ''),
(176, 'Philippines', 'Philippines', 'Philippines', 'Philippines', 'Philippines', 'PH', 'PHL', 'Asia', '', 'Unknown', '', '', ''),
(177, 'Palau', 'Palau', 'Palau', 'Palau', 'Palau', 'PW', 'PLW', 'Oceania', '', 'Unknown', '', '', ''),
(178, 'Papua New Guinea', 'Papua New Guinea', 'Papua New Guinea', 'Papua New Guinea', 'Papua New Guinea', 'PG', 'PNG', 'Oceania', 'province', 'Unknown', '', '', ''),
(179, 'Poland', 'Poland', 'Poland', 'Poland', 'Poland', 'PL', 'POL', 'Europe', '', 'Unknown', '', '', ''),
(180, 'Puerto Rico', 'Puerto Rico', 'Puerto Rico', 'Puerto Rico', 'Puerto Rico', 'PR', 'PRI', 'North America', '', 'Unknown', '', '', ''),
(181, 'Korea', 'Korea', 'Korea', 'Korea, Democratic Peoples Republic of', 'Korea', 'KP', 'PRK', 'Asia', 'province', 'Unknown', '', '', ''),
(182, 'Portugal', 'Portugal', 'Portugal', 'Portugal', 'Portugal', 'PT', 'PRT', 'Europe', 'district', 'Unknown', '', '', ''),
(183, 'Paraguay', 'Paraguay', 'Paraguay', 'Paraguay', 'Paraguay', 'PY', 'PRY', 'South America', 'department', 'Unknown', '', '', ''),
(184, 'Palestinian Terr', 'Palestinian Territory', 'Palestinian Territory', 'Palestinian Territory, Occupied', 'Palestinian Terr', 'PS', 'PSE', 'Asia', '', 'Unknown', '', '', ''),
(185, 'French Polynesia', 'French Polynesia', 'French Polynesia', 'French Polynesia', 'French Polynesia', 'PF', 'PYF', 'Oceania', '', 'Unknown', '', '', ''),
(186, 'Qatar', 'Qatar', 'Qatar', 'Qatar', 'Qatar', 'QA', 'QAT', 'Asia', '', 'Unknown', '', '', ''),
(187, 'Réunion', 'Réunion', 'Réunion', 'Réunion', 'Réunion', 'RE', 'REU', 'Africa', '', 'Unknown', '', '', ''),
(188, 'Romania', 'Romania', 'Romania', 'Romania', 'Romania', 'RO', 'ROU', 'Europe', 'department', 'Unknown', '', '', ''),
(189, 'Russian Federation', 'Russian Federation', 'Russian Federation', 'Russian Federation', 'Russian Federation', 'RU', 'RUS', 'Europe', 'republic', 'Unknown', '', '', ''),
(190, 'Rwanda', 'Rwanda', 'Rwanda', 'Rwanda', 'Rwanda', 'RW', 'RWA', 'Africa', 'province', 'Unknown', '', '', ''),
(191, 'Saudi Arabia', 'Saudi Arabia', 'Saudi Arabia', 'Saudi Arabia', 'Saudi Arabia', 'SA', 'SAU', 'Asia', '', 'Unknown', '', '', ''),
(192, 'Sudan', 'Sudan', 'Sudan', 'Sudan', 'Sudan', 'SD', 'SDN', 'Africa', '', 'Unknown', '', '', ''),
(193, 'Senegal', 'Senegal', 'Senegal', 'Senegal', 'Senegal', 'SN', 'SEN', 'Africa', '', 'Unknown', '', '', ''),
(194, 'Singapore', 'Singapore', 'Singapore', 'Singapore', 'Singapore', 'SG', 'SGP', 'Asia', '', 'Unknown', '', '', ''),
(195, 'South Georgia', 'South Georgia Sandwich Is', 'South Georgia and Sandwich Is.', 'South Georgia and the South Sandwich Islands', 'South Georgia', 'GS', 'SGS', 'Antartica', '', 'Unknown', '', '', ''),
(196, 'Saint Helena', 'Saint Helena', 'Saint Helena', 'Saint Helena', 'Saint Helena', 'SH', 'SHN', 'Africa', '', 'Unknown', '', '', ''),
(197, 'Svalbard Jan Mayen', 'Svalbard and Jan Mayen', 'Svalbard and Jan Mayen', 'Svalbard and Jan Mayen', 'Svalbard Jan Mayen', 'SJ', 'SJM', 'Europe', '', 'Unknown', '', '', ''),
(198, 'Solomon Islands', 'Solomon Islands', 'Solomon Islands', 'Solomon Islands', 'Solomon Islands', 'SB', 'SLB', 'Oceania', 'province', 'Unknown', '', '', ''),
(199, 'Sierra Leone', 'Sierra Leone', 'Sierra Leone', 'Sierra Leone', 'Sierra Leone', 'SL', 'SLE', 'Africa', 'province', 'Unknown', '', '', ''),
(200, 'El Salvador', 'El Salvador', 'El Salvador', 'El Salvador', 'El Salvador', 'SV', 'SLV', 'North America', '', 'Unknown', '', '', ''),
(201, 'San Marino', 'San Marino', 'San Marino', 'San Marino', 'San Marino', 'SM', 'SMR', 'Europe', '', 'Unknown', '', '', ''),
(202, 'Somalia', 'Somalia', 'Somalia', 'Somalia', 'Somalia', 'SO', 'SOM', 'Africa', '', 'Unknown', '', '', ''),
(203, 'St Pierre Miquelon', 'Saint Pierre and Miquelon', 'Saint Pierre and Miquelon', 'Saint Pierre and Miquelon', 'St Pierre Miquelon', 'PM', 'SPM', 'North America', '', 'Unknown', '', '', ''),
(204, 'Serbia', 'Serbia', 'Serbia', 'Serbia', 'Serbia', 'RS', 'SRB', 'Europe', '', 'Unknown', '', '', ''),
(205, 'Sao Tome Principe', 'Sao Tome and Principe', 'Sao Tome and Principe', 'Sao Tome and Principe', 'Sao Tome Principe', 'ST', 'STP', 'Africa', '', 'Unknown', '', '', ''),
(206, 'Suriname', 'Suriname', 'Suriname', 'Suriname', 'Suriname', 'SR', 'SUR', 'South America', '', 'Unknown', '', '', ''),
(207, 'Slovakia', 'Slovakia', 'Slovakia', 'Slovakia', 'Slovakia', 'SK', 'SVK', 'Europe', '', 'Unknown', '', '', ''),
(208, 'Slovenia', 'Slovenia', 'Slovenia', 'Slovenia', 'Slovenia', 'SI', 'SVN', 'Europe', '', 'Unknown', '', '', ''),
(209, 'Sweden', 'Sweden', 'Sweden', 'Sweden', 'Sweden', 'SE', 'SWE', 'Europe', '', 'Unknown', '', '', ''),
(210, 'Swaziland', 'Swaziland', 'Swaziland', 'Swaziland', 'Swaziland', 'SZ', 'SWZ', 'Africa', '', 'Unknown', '', '', ''),
(211, 'Seychelles', 'Seychelles', 'Seychelles', 'Seychelles', 'Seychelles', 'SC', 'SYC', 'Africa', '', 'Unknown', '', '', ''),
(212, 'Syrian Arab Republic', 'Syrian Arab Republic', 'Syrian Arab Republic', 'Syrian Arab Republic', 'Syrian Arab Republic', 'SY', 'SYR', 'Asia', '', 'Unknown', '', '', ''),
(213, 'Turks Caicos Islands', 'Turks and Caicos Islands', 'Turks and Caicos Islands', 'Turks and Caicos Islands', 'Turks Caicos Islands', 'TC', 'TCA', 'North America', '', 'Unknown', '', '', ''),
(214, 'Chad', 'Chad', 'Chad', 'Chad', 'Chad', 'TD', 'TCD', 'Africa', '', 'Unknown', '', '', ''),
(215, 'Togo', 'Togo', 'Togo', 'Togo', 'Togo', 'TG', 'TGO', 'Africa', '', 'Unknown', '', '', ''),
(216, 'Thailand', 'Thailand', 'Thailand', 'Thailand', 'Thailand', 'TH', 'THA', 'Asia', 'province', 'Unknown', '', '', ''),
(217, 'Tajikistan', 'Tajikistan', 'Tajikistan', 'Tajikistan', 'Tajikistan', 'TJ', 'TJK', 'Asia', '', 'Unknown', '', '', ''),
(218, 'Tokelau', 'Tokelau', 'Tokelau', 'Tokelau', 'Tokelau', 'TK', 'TKL', 'Oceania', '', 'Unknown', '', '', ''),
(219, 'Turkmenistan', 'Turkmenistan', 'Turkmenistan', 'Turkmenistan', 'Turkmenistan', 'TM', 'TKM', 'Asia', '', 'Unknown', '', '', ''),
(220, 'Timor-Leste', 'Timor-Leste', 'Timor-Leste', 'Timor-Leste', 'Timor-Leste', 'TL', 'TLS', 'Asia', '', 'Unknown', '', '', ''),
(221, 'Tonga', 'Tonga', 'Tonga', 'Tonga', 'Tonga', 'TO', 'TON', 'Oceania', '', 'Unknown', '', '', ''),
(222, 'Trinidad and Tobago', 'Trinidad and Tobago', 'Trinidad and Tobago', 'Trinidad and Tobago', 'Trinidad and Tobago', 'TT', 'TTO', 'North America', 'region', 'Unknown', '', '', ''),
(223, 'Tunisia', 'Tunisia', 'Tunisia', 'Tunisia', 'Tunisia', 'TN', 'TUN', 'Africa', '', 'Unknown', '', '', ''),
(224, 'Turkey', 'Turkey', 'Turkey', 'Turkey', 'Turkey', 'TR', 'TUR', 'Asia', '', 'Unknown', '', '', ''),
(225, 'Tuvalu', 'Tuvalu', 'Tuvalu', 'Tuvalu', 'Tuvalu', 'TV', 'TUV', 'Oceania', '', 'Unknown', '', '', ''),
(226, 'Taiwan', 'Taiwan, Province of China', 'Taiwan, Province of China', 'Taiwan, Province of China', 'Taiwan', 'TW', 'TWN', 'Asia', 'district', 'Unknown', '', '', ''),
(227, 'Tanzania', 'Tanzania', 'Tanzania, United Republic of', 'Tanzania, United Republic of', 'Tanzania', 'TZ', 'TZA', 'Africa', '', 'Unknown', '', '', ''),
(228, 'Uganda', 'Uganda', 'Uganda', 'Uganda', 'Uganda', 'UG', 'UGA', 'Africa', '', 'Unknown', '', '', ''),
(229, 'Ukraine', 'Ukraine', 'Ukraine', 'Ukraine', 'Ukraine', 'UA', 'UKR', 'Europe', 'region', 'Unknown', '', '', ''),
(230, 'U.S. Minor Islands', 'U.S. Minor Islands', 'United States Minor Islands', 'United States Minor Outlying Islands', 'U.S. Minor Islands', 'UM', 'UMI', 'North America', '', 'Unknown', '', '', ''),
(231, 'Uruguay', 'Uruguay', 'Uruguay', 'Uruguay', 'Uruguay', 'UY', 'URY', 'South America', '', 'Unknown', '', '', ''),
(232, 'United States', 'United States', 'United States', 'United States', 'United States', 'US', 'USA', 'North America', 'state', 'Unknown', '', '', ''),
(233, 'Uzbekistan', 'Uzbekistan', 'Uzbekistan', 'Uzbekistan', 'Uzbekistan', 'UZ', 'UZB', 'Asia', 'region', 'Unknown', '', '', ''),
(234, 'Holy See (Vatican)', 'Holy See (Vatican)', 'Holy See (Vatican City State)', 'Holy See (Vatican City State)', 'Holy See (Vatican)', 'VA', 'VAT', 'Europe', '', 'Unknown', '', '', ''),
(235, 'St Vincent Grenadine', 'Saint Vincent Grenadines', 'Saint Vincent and Grenadines', 'Saint Vincent and the Grenadines', 'St Vincent Grenadine', 'VC', 'VCT', 'North America', '', 'Unknown', '', '', ''),
(236, 'Venezuela', 'Venezuela', 'Venezuela', 'Venezuela, Bolivarian Republic of', 'Venezuela', 'VE', 'VEN', 'South America', 'state', 'Unknown', '', '', ''),
(237, 'British Virgin Isl', 'Virgin Islands, British', 'Virgin Islands, British', 'Virgin Islands, British', 'British Virgin Isl', 'VG', 'VGB', 'North America', '', 'Unknown', '', '', ''),
(238, 'Virgin Islands, U.S.', 'Virgin Islands, U.S.', 'Virgin Islands, U.S.', 'Virgin Islands, U.S.', 'Virgin Islands, U.S.', 'VI', 'VIR', 'North America', '', 'Unknown', '', '', ''),
(239, 'Viet Nam', 'Viet Nam', 'Viet Nam', 'Viet Nam', 'Viet Nam', 'VN', 'VNM', 'Asia', '', 'Unknown', '', '', ''),
(240, 'Vanuatu', 'Vanuatu', 'Vanuatu', 'Vanuatu', 'Vanuatu', 'VU', 'VUT', 'Oceania', '', 'Unknown', '', '', ''),
(241, 'Wallis and Futuna', 'Wallis and Futuna', 'Wallis and Futuna', 'Wallis and Futuna', 'Wallis and Futuna', 'WF', 'WLF', 'Oceania', '', 'Unknown', '', '', ''),
(242, 'Samoa', 'Samoa', 'Samoa', 'Samoa', 'Samoa', 'WS', 'WSM', 'Oceania', '', 'Unknown', '', '', ''),
(243, 'Yemen', 'Yemen', 'Yemen', 'Yemen', 'Yemen', 'YE', 'YEM', 'Asia', '', 'Unknown', '', '', ''),
(244, 'South Africa', 'South Africa', 'South Africa', 'South Africa', 'South Africa', 'ZA', 'ZAF', 'Africa', '', 'Unknown', '', '', ''),
(245, 'Zambia', 'Zambia', 'Zambia', 'Zambia', 'Zambia', 'ZM', 'ZMB', 'Africa', '', 'Unknown', '', '', ''),
(246, 'Zimbabwe', 'Zimbabwe', 'Zimbabwe', 'Zimbabwe', 'Zimbabwe', 'ZW', 'ZWE', 'Africa', '', 'Unknown', '', '', '');
{jcomments on}