Welcome to WebmasterWorld Guest from 54.198.92.22

Forum Moderators: open

Message Too Old, No Replies

I need a list of every country for select drop down

     
9:58 am on Jul 22, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Oct 11, 2005
posts:174
votes: 0


Hi,

I was wondering if anyone had a current list of countries for drop down boxes in html.

I downloaded the official iso country list but couldn't get it to work properly in excel when adding the <option> tags.

I know its best to just let the user type in their county for certain reasons but i still would rather have the list.

Thanks for any links.

:)

11:06 am on July 22, 2006 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 26, 2004
posts:1497
votes: 0


I think the problem is going to be finding an up to date one. For example, only a month ago Montenegro voted for independence from Serbia so now there's two countries instead of one. However, I've also downloaded the ISO-3166 lists as they currently stand and converted then into a <select> element for you. The value attribute is set to the country code, but the selects are ordered by country name (which would be the expected behaviour).

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

Junior Member

10+ Year Member

joined:Oct 11, 2005
posts:174
votes: 0


Great, thanks alot for that Robin, very kind of you :)

I'll just insert the country codes into my db and convert them to ccountry names with my script.

I'm not to worried about the smaller off shoot countries, they dont seem to have a high internet user population and am yet to have one hit from any of them. Sounds a bit mean but i think i'll just add an "other" category with a script that lets them add their own manually just in case.

Thanks Again :)

5:04 pm on Aug 3, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:July 13, 2005
posts:55
votes: 0


CREATE TABLE countries (
country_id int(11) NOT NULL auto_increment,
country_name varchar(64) NOT NULL default '',
iso_code2 char(2) NOT NULL default '',
iso_code3 char(3) NOT NULL default '',
reserved1 int(11) NOT NULL default '0',
PRIMARY KEY (country_id),
KEY IDX_COUNTRIES_NAME (country_name)
) TYPE=MyISAM;

#
# Dumping data for table `countries`
#

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