Created
February 23, 2013 13:58
-
-
Save ntha314159/5019857 to your computer and use it in GitHub Desktop.
iso_country_list.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# iso_country_list.sql | |
# | |
# This will create and then populate a MySQL table with a list of the names and | |
# ISO 3166 codes for countries in existence as of the date below. | |
# | |
# Usage: | |
# mysql -u username -ppassword database_name < ./iso_country_list.sql | |
# | |
# For updates to this file, see http://27.org/isocountrylist/ | |
# For more about ISO 3166, see http://www.iso.ch/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-en1.html | |
# | |
# Created by getisocountrylist.pl on Sun Nov 2 14:59:20 2003. | |
# Wm. Rhodes <iso_country_list@27.org> | |
# | |
CREATE TABLE IF NOT EXISTS CountryCode3166 ( | |
CountryCode2 CHAR(2) NOT NULL PRIMARY KEY, | |
FormalName VARCHAR(80) NOT NULL, | |
Name VARCHAR(80) NOT NULL, | |
CountryCode3 CHAR(3), | |
countryNumCode SMALLINT | |
); | |
INSERT INTO CountryCode3166 VALUES ('AL','ALBANIA','Albania','ALB','008'); | |
INSERT INTO CountryCode3166 VALUES ('DZ','ALGERIA','Algeria','DZA','012'); | |
INSERT INTO CountryCode3166 VALUES ('AS','AMERICAN SAMOA','American Samoa','ASM','016'); | |
INSERT INTO CountryCode3166 VALUES ('AD','ANDORRA','Andorra','AND','020'); | |
INSERT INTO CountryCode3166 VALUES ('AO','ANGOLA','Angola','AGO','024'); | |
INSERT INTO CountryCode3166 VALUES ('AI','ANGUILLA','Anguilla','AIA','660'); | |
INSERT INTO CountryCode3166 VALUES ('AQ','ANTARCTICA','Antarctica',NULL,NULL); | |
INSERT INTO CountryCode3166 VALUES ('AG','ANTIGUA AND BARBUDA','Antigua and Barbuda','ATG','028'); | |
INSERT INTO CountryCode3166 VALUES ('AR','ARGENTINA','Argentina','ARG','032'); | |
INSERT INTO CountryCode3166 VALUES ('AF','AFGHANISTAN','Afghanistan','AFG','004'); | |
INSERT INTO CountryCode3166 VALUES ('AM','ARMENIA','Armenia','ARM','051'); | |
INSERT INTO CountryCode3166 VALUES ('AW','ARUBA','Aruba','ABW','533'); | |
INSERT INTO CountryCode3166 VALUES ('AU','AUSTRALIA','Australia','AUS','036'); | |
INSERT INTO CountryCode3166 VALUES ('AT','AUSTRIA','Austria','AUT','040'); | |
INSERT INTO CountryCode3166 VALUES ('AZ','AZERBAIJAN','Azerbaijan','AZE','031'); | |
INSERT INTO CountryCode3166 VALUES ('BS','BAHAMAS','Bahamas','BHS','044'); | |
INSERT INTO CountryCode3166 VALUES ('BH','BAHRAIN','Bahrain','BHR','048'); | |
INSERT INTO CountryCode3166 VALUES ('BD','BANGLADESH','Bangladesh','BGD','050'); | |
INSERT INTO CountryCode3166 VALUES ('BB','BARBADOS','Barbados','BRB','052'); | |
INSERT INTO CountryCode3166 VALUES ('BY','BELARUS','Belarus','BLR','112'); | |
INSERT INTO CountryCode3166 VALUES ('BE','BELGIUM','Belgium','BEL','056'); | |
INSERT INTO CountryCode3166 VALUES ('BZ','BELIZE','Belize','BLZ','084'); | |
INSERT INTO CountryCode3166 VALUES ('BJ','BENIN','Benin','BEN','204'); | |
INSERT INTO CountryCode3166 VALUES ('BM','BERMUDA','Bermuda','BMU','060'); | |
INSERT INTO CountryCode3166 VALUES ('BT','BHUTAN','Bhutan','BTN','064'); | |
INSERT INTO CountryCode3166 VALUES ('BO','BOLIVIA','Bolivia','BOL','068'); | |
INSERT INTO CountryCode3166 VALUES ('BA','BOSNIA AND HERZEGOVINA','Bosnia and Herzegovina','BIH','070'); | |
INSERT INTO CountryCode3166 VALUES ('BW','BOTSWANA','Botswana','BWA','072'); | |
INSERT INTO CountryCode3166 VALUES ('BV','BOUVET ISLAND','Bouvet Island',NULL,NULL); | |
INSERT INTO CountryCode3166 VALUES ('BR','BRAZIL','Brazil','BRA','076'); | |
INSERT INTO CountryCode3166 VALUES ('IO','BRITISH INDIAN OCEAN TERRITORY','British Indian Ocean Territory',NULL,NULL); | |
INSERT INTO CountryCode3166 VALUES ('BN','BRUNEI DARUSSALAM','Brunei Darussalam','BRN','096'); | |
INSERT INTO CountryCode3166 VALUES ('BG','BULGARIA','Bulgaria','BGR','100'); | |
INSERT INTO CountryCode3166 VALUES ('BF','BURKINA FASO','Burkina Faso','BFA','854'); | |
INSERT INTO CountryCode3166 VALUES ('BI','BURUNDI','Burundi','BDI','108'); | |
INSERT INTO CountryCode3166 VALUES ('KH','CAMBODIA','Cambodia','KHM','116'); | |
INSERT INTO CountryCode3166 VALUES ('CM','CAMEROON','Cameroon','CMR','120'); | |
INSERT INTO CountryCode3166 VALUES ('CA','CANADA','Canada','CAN','124'); | |
INSERT INTO CountryCode3166 VALUES ('CV','CAPE VERDE','Cape Verde','CPV','132'); | |
INSERT INTO CountryCode3166 VALUES ('KY','CAYMAN ISLANDS','Cayman Islands','CYM','136'); | |
INSERT INTO CountryCode3166 VALUES ('CF','CENTRAL AFRICAN REPUBLIC','Central African Republic','CAF','140'); | |
INSERT INTO CountryCode3166 VALUES ('TD','CHAD','Chad','TCD','148'); | |
INSERT INTO CountryCode3166 VALUES ('CL','CHILE','Chile','CHL','152'); | |
INSERT INTO CountryCode3166 VALUES ('CN','CHINA','China','CHN','156'); | |
INSERT INTO CountryCode3166 VALUES ('CX','CHRISTMAS ISLAND','Christmas Island',NULL,NULL); | |
INSERT INTO CountryCode3166 VALUES ('CC','COCOS (KEELING) ISLANDS','Cocos (Keeling) Islands',NULL,NULL); | |
INSERT INTO CountryCode3166 VALUES ('CO','COLOMBIA','Colombia','COL','170'); | |
INSERT INTO CountryCode3166 VALUES ('KM','COMOROS','Comoros','COM','174'); | |
INSERT INTO CountryCode3166 VALUES ('CG','CONGO','Congo','COG','178'); | |
INSERT INTO CountryCode3166 VALUES ('CD','CONGO, THE DEMOCRATIC REPUBLIC OF THE','Congo, the Democratic Republic of the','COD','180'); | |
INSERT INTO CountryCode3166 VALUES ('CK','COOK ISLANDS','Cook Islands','COK','184'); | |
INSERT INTO CountryCode3166 VALUES ('CR','COSTA RICA','Costa Rica','CRI','188'); | |
INSERT INTO CountryCode3166 VALUES ('CI','COTE D\'IVOIRE','Cote D\'Ivoire','CIV','384'); | |
INSERT INTO CountryCode3166 VALUES ('HR','CROATIA','Croatia','HRV','191'); | |
INSERT INTO CountryCode3166 VALUES ('CU','CUBA','Cuba','CUB','192'); | |
INSERT INTO CountryCode3166 VALUES ('CY','CYPRUS','Cyprus','CYP','196'); | |
INSERT INTO CountryCode3166 VALUES ('CZ','CZECH REPUBLIC','Czech Republic','CZE','203'); | |
INSERT INTO CountryCode3166 VALUES ('DK','DENMARK','Denmark','DNK','208'); | |
INSERT INTO CountryCode3166 VALUES ('DJ','DJIBOUTI','Djibouti','DJI','262'); | |
INSERT INTO CountryCode3166 VALUES ('DM','DOMINICA','Dominica','DMA','212'); | |
INSERT INTO CountryCode3166 VALUES ('DO','DOMINICAN REPUBLIC','Dominican Republic','DOM','214'); | |
INSERT INTO CountryCode3166 VALUES ('EC','ECUADOR','Ecuador','ECU','218'); | |
INSERT INTO CountryCode3166 VALUES ('EG','EGYPT','Egypt','EGY','818'); | |
INSERT INTO CountryCode3166 VALUES ('SV','EL SALVADOR','El Salvador','SLV','222'); | |
INSERT INTO CountryCode3166 VALUES ('GQ','EQUATORIAL GUINEA','Equatorial Guinea','GNQ','226'); | |
INSERT INTO CountryCode3166 VALUES ('ER','ERITREA','Eritrea','ERI','232'); | |
INSERT INTO CountryCode3166 VALUES ('EE','ESTONIA','Estonia','EST','233'); | |
INSERT INTO CountryCode3166 VALUES ('ET','ETHIOPIA','Ethiopia','ETH','231'); | |
INSERT INTO CountryCode3166 VALUES ('FK','FALKLAND ISLANDS (MALVINAS)','Falkland Islands (Malvinas)','FLK','238'); | |
INSERT INTO CountryCode3166 VALUES ('FO','FAROE ISLANDS','Faroe Islands','FRO','234'); | |
INSERT INTO CountryCode3166 VALUES ('FJ','FIJI','Fiji','FJI','242'); | |
INSERT INTO CountryCode3166 VALUES ('FI','FINLAND','Finland','FIN','246'); | |
INSERT INTO CountryCode3166 VALUES ('FR','FRANCE','France','FRA','250'); | |
INSERT INTO CountryCode3166 VALUES ('GF','FRENCH GUIANA','French Guiana','GUF','254'); | |
INSERT INTO CountryCode3166 VALUES ('PF','FRENCH POLYNESIA','French Polynesia','PYF','258'); | |
INSERT INTO CountryCode3166 VALUES ('TF','FRENCH SOUTHERN TERRITORIES','French Southern Territories',NULL,NULL); | |
INSERT INTO CountryCode3166 VALUES ('GA','GABON','Gabon','GAB','266'); | |
INSERT INTO CountryCode3166 VALUES ('GM','GAMBIA','Gambia','GMB','270'); | |
INSERT INTO CountryCode3166 VALUES ('GE','GEORGIA','Georgia','GEO','268'); | |
INSERT INTO CountryCode3166 VALUES ('DE','GERMANY','Germany','DEU','276'); | |
INSERT INTO CountryCode3166 VALUES ('GH','GHANA','Ghana','GHA','288'); | |
INSERT INTO CountryCode3166 VALUES ('GI','GIBRALTAR','Gibraltar','GIB','292'); | |
INSERT INTO CountryCode3166 VALUES ('GR','GREECE','Greece','GRC','300'); | |
INSERT INTO CountryCode3166 VALUES ('GL','GREENLAND','Greenland','GRL','304'); | |
INSERT INTO CountryCode3166 VALUES ('GD','GRENADA','Grenada','GRD','308'); | |
INSERT INTO CountryCode3166 VALUES ('GP','GUADELOUPE','Guadeloupe','GLP','312'); | |
INSERT INTO CountryCode3166 VALUES ('GU','GUAM','Guam','GUM','316'); | |
INSERT INTO CountryCode3166 VALUES ('GT','GUATEMALA','Guatemala','GTM','320'); | |
INSERT INTO CountryCode3166 VALUES ('GN','GUINEA','Guinea','GIN','324'); | |
INSERT INTO CountryCode3166 VALUES ('GW','GUINEA-BISSAU','Guinea-Bissau','GNB','624'); | |
INSERT INTO CountryCode3166 VALUES ('GY','GUYANA','Guyana','GUY','328'); | |
INSERT INTO CountryCode3166 VALUES ('HT','HAITI','Haiti','HTI','332'); | |
INSERT INTO CountryCode3166 VALUES ('HM','HEARD ISLAND AND MCDONALD ISLANDS','Heard Island and Mcdonald Islands',NULL,NULL); | |
INSERT INTO CountryCode3166 VALUES ('VA','HOLY SEE (VATICAN CITY STATE)','Holy See (Vatican City State)','VAT','336'); | |
INSERT INTO CountryCode3166 VALUES ('HN','HONDURAS','Honduras','HND','340'); | |
INSERT INTO CountryCode3166 VALUES ('HK','HONG KONG','Hong Kong','HKG','344'); | |
INSERT INTO CountryCode3166 VALUES ('HU','HUNGARY','Hungary','HUN','348'); | |
INSERT INTO CountryCode3166 VALUES ('IS','ICELAND','Iceland','ISL','352'); | |
INSERT INTO CountryCode3166 VALUES ('IN','INDIA','India','IND','356'); | |
INSERT INTO CountryCode3166 VALUES ('ID','INDONESIA','Indonesia','IDN','360'); | |
INSERT INTO CountryCode3166 VALUES ('IR','IRAN, ISLAMIC REPUBLIC OF','Iran, Islamic Republic of','IRN','364'); | |
INSERT INTO CountryCode3166 VALUES ('IQ','IRAQ','Iraq','IRQ','368'); | |
INSERT INTO CountryCode3166 VALUES ('IE','IRELAND','Ireland','IRL','372'); | |
INSERT INTO CountryCode3166 VALUES ('IL','ISRAEL','Israel','ISR','376'); | |
INSERT INTO CountryCode3166 VALUES ('IT','ITALY','Italy','ITA','380'); | |
INSERT INTO CountryCode3166 VALUES ('JM','JAMAICA','Jamaica','JAM','388'); | |
INSERT INTO CountryCode3166 VALUES ('JP','JAPAN','Japan','JPN','392'); | |
INSERT INTO CountryCode3166 VALUES ('JO','JORDAN','Jordan','JOR','400'); | |
INSERT INTO CountryCode3166 VALUES ('KZ','KAZAKHSTAN','Kazakhstan','KAZ','398'); | |
INSERT INTO CountryCode3166 VALUES ('KE','KENYA','Kenya','KEN','404'); | |
INSERT INTO CountryCode3166 VALUES ('KI','KIRIBATI','Kiribati','KIR','296'); | |
INSERT INTO CountryCode3166 VALUES ('KP','KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF','Korea, Democratic People\'s Republic of','PRK','408'); | |
INSERT INTO CountryCode3166 VALUES ('KR','KOREA, REPUBLIC OF','Korea, Republic of','KOR','410'); | |
INSERT INTO CountryCode3166 VALUES ('KW','KUWAIT','Kuwait','KWT','414'); | |
INSERT INTO CountryCode3166 VALUES ('KG','KYRGYZSTAN','Kyrgyzstan','KGZ','417'); | |
INSERT INTO CountryCode3166 VALUES ('LA','LAO PEOPLE\'S DEMOCRATIC REPUBLIC','Lao People\'s Democratic Republic','LAO','418'); | |
INSERT INTO CountryCode3166 VALUES ('LV','LATVIA','Latvia','LVA','428'); | |
INSERT INTO CountryCode3166 VALUES ('LB','LEBANON','Lebanon','LBN','422'); | |
INSERT INTO CountryCode3166 VALUES ('LS','LESOTHO','Lesotho','LSO','426'); | |
INSERT INTO CountryCode3166 VALUES ('LR','LIBERIA','Liberia','LBR','430'); | |
INSERT INTO CountryCode3166 VALUES ('LY','LIBYAN ARAB JAMAHIRIYA','Libyan Arab Jamahiriya','LBY','434'); | |
INSERT INTO CountryCode3166 VALUES ('LI','LIECHTENSTEIN','Liechtenstein','LIE','438'); | |
INSERT INTO CountryCode3166 VALUES ('LT','LITHUANIA','Lithuania','LTU','440'); | |
INSERT INTO CountryCode3166 VALUES ('LU','LUXEMBOURG','Luxembourg','LUX','442'); | |
INSERT INTO CountryCode3166 VALUES ('MO','MACAO','Macao','MAC','446'); | |
INSERT INTO CountryCode3166 VALUES ('MK','MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','Macedonia, the Former Yugoslav Republic of','MKD','807'); | |
INSERT INTO CountryCode3166 VALUES ('MG','MADAGASCAR','Madagascar','MDG','450'); | |
INSERT INTO CountryCode3166 VALUES ('MW','MALAWI','Malawi','MWI','454'); | |
INSERT INTO CountryCode3166 VALUES ('MY','MALAYSIA','Malaysia','MYS','458'); | |
INSERT INTO CountryCode3166 VALUES ('MV','MALDIVES','Maldives','MDV','462'); | |
INSERT INTO CountryCode3166 VALUES ('ML','MALI','Mali','MLI','466'); | |
INSERT INTO CountryCode3166 VALUES ('MT','MALTA','Malta','MLT','470'); | |
INSERT INTO CountryCode3166 VALUES ('MH','MARSHALL ISLANDS','Marshall Islands','MHL','584'); | |
INSERT INTO CountryCode3166 VALUES ('MQ','MARTINIQUE','Martinique','MTQ','474'); | |
INSERT INTO CountryCode3166 VALUES ('MR','MAURITANIA','Mauritania','MRT','478'); | |
INSERT INTO CountryCode3166 VALUES ('MU','MAURITIUS','Mauritius','MUS','480'); | |
INSERT INTO CountryCode3166 VALUES ('YT','MAYOTTE','Mayotte',NULL,NULL); | |
INSERT INTO CountryCode3166 VALUES ('MX','MEXICO','Mexico','MEX','484'); | |
INSERT INTO CountryCode3166 VALUES ('FM','MICRONESIA, FEDERATED STATES OF','Micronesia, Federated States of','FSM','583'); | |
INSERT INTO CountryCode3166 VALUES ('MD','MOLDOVA, REPUBLIC OF','Moldova, Republic of','MDA','498'); | |
INSERT INTO CountryCode3166 VALUES ('MC','MONACO','Monaco','MCO','492'); | |
INSERT INTO CountryCode3166 VALUES ('MN','MONGOLIA','Mongolia','MNG','496'); | |
INSERT INTO CountryCode3166 VALUES ('MS','MONTSERRAT','Montserrat','MSR','500'); | |
INSERT INTO CountryCode3166 VALUES ('MA','MOROCCO','Morocco','MAR','504'); | |
INSERT INTO CountryCode3166 VALUES ('MZ','MOZAMBIQUE','Mozambique','MOZ','508'); | |
INSERT INTO CountryCode3166 VALUES ('MM','MYANMAR','Myanmar','MMR','104'); | |
INSERT INTO CountryCode3166 VALUES ('NA','NAMIBIA','Namibia','NAM','516'); | |
INSERT INTO CountryCode3166 VALUES ('NR','NAURU','Nauru','NRU','520'); | |
INSERT INTO CountryCode3166 VALUES ('NP','NEPAL','Nepal','NPL','524'); | |
INSERT INTO CountryCode3166 VALUES ('NL','NETHERLANDS','Netherlands','NLD','528'); | |
INSERT INTO CountryCode3166 VALUES ('AN','NETHERLANDS ANTILLES','Netherlands Antilles','ANT','530'); | |
INSERT INTO CountryCode3166 VALUES ('NC','NEW CALEDONIA','New Caledonia','NCL','540'); | |
INSERT INTO CountryCode3166 VALUES ('NZ','NEW ZEALAND','New Zealand','NZL','554'); | |
INSERT INTO CountryCode3166 VALUES ('NI','NICARAGUA','Nicaragua','NIC','558'); | |
INSERT INTO CountryCode3166 VALUES ('NE','NIGER','Niger','NER','562'); | |
INSERT INTO CountryCode3166 VALUES ('NG','NIGERIA','Nigeria','NGA','566'); | |
INSERT INTO CountryCode3166 VALUES ('NU','NIUE','Niue','NIU','570'); | |
INSERT INTO CountryCode3166 VALUES ('NF','NORFOLK ISLAND','Norfolk Island','NFK','574'); | |
INSERT INTO CountryCode3166 VALUES ('MP','NORTHERN MARIANA ISLANDS','Northern Mariana Islands','MNP','580'); | |
INSERT INTO CountryCode3166 VALUES ('NO','NORWAY','Norway','NOR','578'); | |
INSERT INTO CountryCode3166 VALUES ('OM','OMAN','Oman','OMN','512'); | |
INSERT INTO CountryCode3166 VALUES ('PK','PAKISTAN','Pakistan','PAK','586'); | |
INSERT INTO CountryCode3166 VALUES ('PW','PALAU','Palau','PLW','585'); | |
INSERT INTO CountryCode3166 VALUES ('PS','PALESTINIAN TERRITORY, OCCUPIED','Palestinian Territory, Occupied',NULL,NULL); | |
INSERT INTO CountryCode3166 VALUES ('PA','PANAMA','Panama','PAN','591'); | |
INSERT INTO CountryCode3166 VALUES ('PG','PAPUA NEW GUINEA','Papua New Guinea','PNG','598'); | |
INSERT INTO CountryCode3166 VALUES ('PY','PARAGUAY','Paraguay','PRY','600'); | |
INSERT INTO CountryCode3166 VALUES ('PE','PERU','Peru','PER','604'); | |
INSERT INTO CountryCode3166 VALUES ('PH','PHILIPPINES','Philippines','PHL','608'); | |
INSERT INTO CountryCode3166 VALUES ('PN','PITCAIRN','Pitcairn','PCN','612'); | |
INSERT INTO CountryCode3166 VALUES ('PL','POLAND','Poland','POL','616'); | |
INSERT INTO CountryCode3166 VALUES ('PT','PORTUGAL','Portugal','PRT','620'); | |
INSERT INTO CountryCode3166 VALUES ('PR','PUERTO RICO','Puerto Rico','PRI','630'); | |
INSERT INTO CountryCode3166 VALUES ('QA','QATAR','Qatar','QAT','634'); | |
INSERT INTO CountryCode3166 VALUES ('RE','REUNION','Reunion','REU','638'); | |
INSERT INTO CountryCode3166 VALUES ('RO','ROMANIA','Romania','ROM','642'); | |
INSERT INTO CountryCode3166 VALUES ('RU','RUSSIAN FEDERATION','Russian Federation','RUS','643'); | |
INSERT INTO CountryCode3166 VALUES ('RW','RWANDA','Rwanda','RWA','646'); | |
INSERT INTO CountryCode3166 VALUES ('SH','SAINT HELENA','Saint Helena','SHN','654'); | |
INSERT INTO CountryCode3166 VALUES ('KN','SAINT KITTS AND NEVIS','Saint Kitts and Nevis','KNA','659'); | |
INSERT INTO CountryCode3166 VALUES ('LC','SAINT LUCIA','Saint Lucia','LCA','662'); | |
INSERT INTO CountryCode3166 VALUES ('PM','SAINT PIERRE AND MIQUELON','Saint Pierre and Miquelon','SPM','666'); | |
INSERT INTO CountryCode3166 VALUES ('VC','SAINT VINCENT AND THE GRENADINES','Saint Vincent and the Grenadines','VCT','670'); | |
INSERT INTO CountryCode3166 VALUES ('WS','SAMOA','Samoa','WSM','882'); | |
INSERT INTO CountryCode3166 VALUES ('SM','SAN MARINO','San Marino','SMR','674'); | |
INSERT INTO CountryCode3166 VALUES ('ST','SAO TOME AND PRINCIPE','Sao Tome and Principe','STP','678'); | |
INSERT INTO CountryCode3166 VALUES ('SA','SAUDI ARABIA','Saudi Arabia','SAU','682'); | |
INSERT INTO CountryCode3166 VALUES ('SN','SENEGAL','Senegal','SEN','686'); | |
INSERT INTO CountryCode3166 VALUES ('CS','SERBIA AND MONTENEGRO','Serbia and Montenegro',NULL,NULL); | |
INSERT INTO CountryCode3166 VALUES ('SC','SEYCHELLES','Seychelles','SYC','690'); | |
INSERT INTO CountryCode3166 VALUES ('SL','SIERRA LEONE','Sierra Leone','SLE','694'); | |
INSERT INTO CountryCode3166 VALUES ('SG','SINGAPORE','Singapore','SGP','702'); | |
INSERT INTO CountryCode3166 VALUES ('SK','SLOVAKIA','Slovakia','SVK','703'); | |
INSERT INTO CountryCode3166 VALUES ('SI','SLOVENIA','Slovenia','SVN','705'); | |
INSERT INTO CountryCode3166 VALUES ('SB','SOLOMON ISLANDS','Solomon Islands','SLB','090'); | |
INSERT INTO CountryCode3166 VALUES ('SO','SOMALIA','Somalia','SOM','706'); | |
INSERT INTO CountryCode3166 VALUES ('ZA','SOUTH AFRICA','South Africa','ZAF','710'); | |
INSERT INTO CountryCode3166 VALUES ('GS','SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','South Georgia and the South Sandwich Islands',NULL,NULL); | |
INSERT INTO CountryCode3166 VALUES ('ES','SPAIN','Spain','ESP','724'); | |
INSERT INTO CountryCode3166 VALUES ('LK','SRI LANKA','Sri Lanka','LKA','144'); | |
INSERT INTO CountryCode3166 VALUES ('SD','SUDAN','Sudan','SDN','736'); | |
INSERT INTO CountryCode3166 VALUES ('SR','SURINAME','Suriname','SUR','740'); | |
INSERT INTO CountryCode3166 VALUES ('SJ','SVALBARD AND JAN MAYEN','Svalbard and Jan Mayen','SJM','744'); | |
INSERT INTO CountryCode3166 VALUES ('SZ','SWAZILAND','Swaziland','SWZ','748'); | |
INSERT INTO CountryCode3166 VALUES ('SE','SWEDEN','Sweden','SWE','752'); | |
INSERT INTO CountryCode3166 VALUES ('CH','SWITZERLAND','Switzerland','CHE','756'); | |
INSERT INTO CountryCode3166 VALUES ('SY','SYRIAN ARAB REPUBLIC','Syrian Arab Republic','SYR','760'); | |
INSERT INTO CountryCode3166 VALUES ('TW','TAIWAN, PROVINCE OF CHINA','Taiwan, Province of China','TWN','158'); | |
INSERT INTO CountryCode3166 VALUES ('TJ','TAJIKISTAN','Tajikistan','TJK','762'); | |
INSERT INTO CountryCode3166 VALUES ('TZ','TANZANIA, UNITED REPUBLIC OF','Tanzania, United Republic of','TZA','834'); | |
INSERT INTO CountryCode3166 VALUES ('TH','THAILAND','Thailand','THA','764'); | |
INSERT INTO CountryCode3166 VALUES ('TL','TIMOR-LESTE','Timor-Leste',NULL,NULL); | |
INSERT INTO CountryCode3166 VALUES ('TG','TOGO','Togo','TGO','768'); | |
INSERT INTO CountryCode3166 VALUES ('TK','TOKELAU','Tokelau','TKL','772'); | |
INSERT INTO CountryCode3166 VALUES ('TO','TONGA','Tonga','TON','776'); | |
INSERT INTO CountryCode3166 VALUES ('TT','TRINIDAD AND TOBAGO','Trinidad and Tobago','TTO','780'); | |
INSERT INTO CountryCode3166 VALUES ('TN','TUNISIA','Tunisia','TUN','788'); | |
INSERT INTO CountryCode3166 VALUES ('TR','TURKEY','Turkey','TUR','792'); | |
INSERT INTO CountryCode3166 VALUES ('TM','TURKMENISTAN','Turkmenistan','TKM','795'); | |
INSERT INTO CountryCode3166 VALUES ('TC','TURKS AND CAICOS ISLANDS','Turks and Caicos Islands','TCA','796'); | |
INSERT INTO CountryCode3166 VALUES ('TV','TUVALU','Tuvalu','TUV','798'); | |
INSERT INTO CountryCode3166 VALUES ('UG','UGANDA','Uganda','UGA','800'); | |
INSERT INTO CountryCode3166 VALUES ('UA','UKRAINE','Ukraine','UKR','804'); | |
INSERT INTO CountryCode3166 VALUES ('AE','UNITED ARAB EMIRATES','United Arab Emirates','ARE','784'); | |
INSERT INTO CountryCode3166 VALUES ('GB','UNITED KINGDOM','United Kingdom','GBR','826'); | |
INSERT INTO CountryCode3166 VALUES ('US','UNITED STATES','United States','USA','840'); | |
INSERT INTO CountryCode3166 VALUES ('UM','UNITED STATES MINOR OUTLYING ISLANDS','United States Minor Outlying Islands',NULL,NULL); | |
INSERT INTO CountryCode3166 VALUES ('UY','URUGUAY','Uruguay','URY','858'); | |
INSERT INTO CountryCode3166 VALUES ('UZ','UZBEKISTAN','Uzbekistan','UZB','860'); | |
INSERT INTO CountryCode3166 VALUES ('VU','VANUATU','Vanuatu','VUT','548'); | |
INSERT INTO CountryCode3166 VALUES ('VE','VENEZUELA','Venezuela','VEN','862'); | |
INSERT INTO CountryCode3166 VALUES ('VN','VIET NAM','Viet Nam','VNM','704'); | |
INSERT INTO CountryCode3166 VALUES ('VG','VIRGIN ISLANDS, BRITISH','Virgin Islands, British','VGB','092'); | |
INSERT INTO CountryCode3166 VALUES ('VI','VIRGIN ISLANDS, U.S.','Virgin Islands, U.s.','VIR','850'); | |
INSERT INTO CountryCode3166 VALUES ('WF','WALLIS AND FUTUNA','Wallis and Futuna','WLF','876'); | |
INSERT INTO CountryCode3166 VALUES ('EH','WESTERN SAHARA','Western Sahara','ESH','732'); | |
INSERT INTO CountryCode3166 VALUES ('YE','YEMEN','Yemen','YEM','887'); | |
INSERT INTO CountryCode3166 VALUES ('ZM','ZAMBIA','Zambia','ZMB','894'); | |
INSERT INTO CountryCode3166 VALUES ('ZW','ZIMBABWE','Zimbabwe','ZWE','716'); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment