MYSQL table of coutry codes and names

countries.sql

# This is a list of countries found at http://opengeocode.org/download/countrynames.txt
# ************************************************************
# Sequel Pro SQL dump
# Version 4096
#
# http://www.sequelpro.com/
# http://code.google.com/p/sequel-pro/
#
# ************************************************************


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Dump of table countries
# ------------------------------------------------------------

DROP TABLE IF EXISTS `countries`;

CREATE TABLE `countries` (
  `alpha2` char(2) NOT NULL DEFAULT '',
  `alpha3` char(3) DEFAULT NULL,
  `numeric` int(11) DEFAULT NULL,
  `short` varchar(255) DEFAULT NULL,
  `formal` varchar(255) DEFAULT NULL,
  `local_short` varchar(255) DEFAULT NULL,
  `local_formal` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`alpha2`),
  KEY `alpha3` (`alpha3`),
  KEY `numeric` (`numeric`),
  KEY `short` (`short`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `countries` WRITE;
/*!40000 ALTER TABLE `countries` DISABLE KEYS */;

INSERT INTO `countries` (`alpha2`, `alpha3`, `numeric`, `short`, `formal`, `local_short`, `local_formal`)
VALUES
	('AD','AND',20,'Andorra','the Principality of Andorra','Andorra','Principat d’Andorra'),
	('AE','ARE',784,'United Arab Emirates','the United Arab Emirates','Al Imārāt','Al Imārāt al ‘Arabīyah al Muttaḩidah'),
	('AF','AFG',4,'Afghanistan','the Islamic Republic of Afghanistan','Afghā̄nestā̄n(fa)/Afghā̄nistān(ps)','Jomhūrī-ye Eslā̄mī̄-ye Afghā̄nestā̄n(fa)/Afghānistān Islāmī Jumhūrīyat(ps)'),
	('AG','ATG',28,'Antigua and Barbuda','Antigua and Barbuda','Antigua and Barbuda','Antigua and Barbuda'),
	('AI','AIA',660,'Anguilla','','',''),
	('AL','ALB',8,'Albania','the Republic of Albania','Shqipëri','Republika e Shqipërisë'),
	('AM','ARM',51,'Armenia','the Republic of Armenia','Hayastan','Hayastani Hanrapetut’yun'),
	('AO','AGO',24,'Angola','the Republic of Angola','Angola','República de Angola'),
	('AQ','ATA',10,'Antarctica','','',''),
	('AR','ARG',32,'Argentina','the Argentine Republic','Argentina','la República Argentina'),
	('AS','ASM',16,'American Samoa','','',''),
	('AT','AUT',40,'Austria','the Republic of Austria','Österreich','Republik Österreich'),
	('AU','AUS',36,'Australia','Australia','Australia','Australia'),
	('AW','ABW',533,'Aruba','','',''),
	('AX','ALA',248,'Aland Islands','','',''),
	('AZ','AZE',31,'Azerbaijan','the Republic of Azerbaijan','Azǝrbaycan','Azǝrbaycan Respublikası'),
	('BA','BIH',70,'Bosnia and Herzegovina','Bosnia and Herzegovina','Bosna i Hercegovina','Bosna i Hercegovina'),
	('BB','BRB',52,'Barbados','Barbados','Barbados','Barbados'),
	('BD','BGD',50,'Bangladesh','the People\'s Republic of Bangladesh','Bāṁlādesh','Gaṇaprajātantrī Bāṁlādesh'),
	('BE','BEL',56,'Belgium','the Kingdom of Belgium','België(nl)/Belgique(fr)/Belgien(de)','Koninkrijk België(nl)/le Royaume de Belgique(fr)/Königreich Belgien(de)'),
	('BF','BFA',854,'Burkina Faso','Burkina Faso','Burkina','le Burkina Faso'),
	('BG','BGR',100,'Bulgaria','the Republic of Bulgaria','Bǎlgarija','Republika Bǎlgarija'),
	('BH','BHR',48,'Bahrain','The Kingdom of Bahrain','Al Baḩrayn','Mamlakat al Baḩrayn'),
	('BI','BDI',108,'Burundi','the Republic of Burundi','Burundi','la République du Burundi(fr)/Republika y\'Uburundi'),
	('BJ','BEN',204,'Benin','the Republic of Benin','Bénin','la République du Bénin'),
	('BL','534',703,'Saint Barthelemy','','',''),
	('BM','BMU',60,'Bermuda','','',''),
	('BN','BRN',96,'Brunei Darussalam','Brunei Darussalam','Brunei Darussalam(en)/Brunei(ms)','Brunei Darussalam(en)/Negara Brunei Darussalam(ms)'),
	('BO','BOL',68,'Bolivia, Plurinational State of','Plurinational State of Bolivia','Bolivia','Estado Plurinacional de Bolivia'),
	('BQ','BES',535,'Bonaire, Saint Eustatius and Saba','','',''),
	('BR','BRA',76,'Brazil','the Federative Republic of Brazil','Brasil','República Federativa do Brasil'),
	('BS','BHS',44,'Bahamas','the Commonwealth of the Bahamas','Bahamas','the Commonwealth of the Bahamas'),
	('BT','BTN',64,'Bhutan','the Kingdom of Bhutan','Druk Yul','Druk Gyalkhap'),
	('BV','BVT',74,'Bouvet Island','','',''),
	('BW','BWA',72,'Botswana','the Republic of Botswana','Botswana','the Republic of Botswana'),
	('BY','BLR',112,'Belarus','the Republic of Belarus','Bielaruś(be)/Belarus\'(ru)','Respublika Bielaruś (be)/Respublika Belarus\'(ru)'),
	('BZ','BLZ',84,'Belize','Belize','Belize','Belize'),
	('CA','CAN',124,'Canada','Canada','Canada','Canada(en)/le Canada(fr)'),
	('CC','CCK',166,'Cocos (Keeling) Islands','','',''),
	('CD','COD',180,'Congo, The Democratic Republic of the','the Democratic Republic of The Congo','République démocratique du Congo','la République démocratique du Congo'),
	('CF','CAF',140,'Central African Republic','the Central African Republic','République centrafricaine(fr)/Ködörösêse tî Bêafrîka(sg)','la République centrafricaine(fr)/Ködörösêse tî Bêafrîka(sg)'),
	('CG','COG',178,'Congo','the Republic of the Congo','Congo','la République du Congo'),
	('CH','CHE',756,'Switzerland','the Confederation of Switzerland','Suisse(fr)/Schweiz(de)/Svizzera(it)/Svizra(rm)','la Confédération suisse(fr)/Schweizerische Eidgenossenschaft(de)/Confederazione Svizzera(it)/Confederaziun Svizra(rm)'),
	('CI','CIV',384,'Cote d\'Ivoire','the Republic of Cote d\'Ivoire','Côte d’Ivoire','la République de Côte d’Ivoire'),
	('CK','COK',184,'Cook Islands','','',''),
	('CL','CHL',152,'Chile','the Republica de Chile','Chile','la República de Chile'),
	('CM','CMR',120,'Cameroon','the Republic of Cameroon','Cameroon(en)/Cameroun(fr)','Republic of Cameroon(en)/la République du Cameroun(fr)'),
	('CN','CHN',156,'China','the People\'s Republic of China','Zhongguo','Zhonghua Renmin Gongheguo'),
	('CO','COL',170,'Colombia','the Republic of Columbia','Colombia','la República de Colombia'),
	('CR','CRI',188,'Costa Rica','the Republic of Costa Rica','Costa Rica','la República de Costa Rica'),
	('CU','CUB',192,'Cuba','the Republic of Cuba','Cuba','la República de Cuba'),
	('CV','CPV',132,'Cape Verde','the Republic of Cape Verde','Cabo Verde','República de Cabo Verde'),
	('CW','CUW',531,'Curacao','','',''),
	('CX','CXR',162,'Christmas Island','','',''),
	('CY','CYP',196,'Cyprus','the Republic of Cyprus','Kýpros(el)/K?br?s(tr)','Kypriakí Dimokratía(el)/K?br?s Cumhuriyeti(tr)'),
	('CZ','CZE',203,'Czech Republic','the Czech Republic','Česko','Česká republika'),
	('DE','DEU',276,'Germany','the Federal Republic of Germany','Deutschland','Bundesrepublik Deutschland'),
	('DJ','DJI',262,'Djibouti','the Republic of Djibouti','Jī̄bū̄tī̄(ar)/Djibouti(fr)','Jumhū̄rī̄yat Jī̄bū̄tī̄(ar)/la Républic of Djibouti(fr)'),
	('DK','DNK',208,'Denmark','the Kingdom of Denmark','Danmark','Kongeriget Danmark'),
	('DM','DMA',212,'Dominica','the Commonwealth of Dominica','Dominica','the Commonwealth of Dominica'),
	('DO','DOM',214,'Dominican Republic','the Dominican Republic','Dominicana','la República Dominicana'),
	('DZ','DZA',12,'Algeria','the People\'s Democratic Republic of Algeria','Al Jazā̄\'ir','Al Jumhū̄rī̄yah al Jazā̄\'irī̄yah ad Dī̄muqrāţ̧īyah ash Sha‘bī̄yah'),
	('EC','ECU',218,'Ecuador','the Republic of Ecuador','Ecuador','la República del Ecuador'),
	('EE','EST',233,'Estonia','the Republic of Estonia','Eesti','Eesti Vabariik'),
	('EG','EGY',818,'Egypt','the Arab Republic of Egypt','Mişr','Jumhūrīyat Mişr al ‘Arabīyah'),
	('EH','ESH',732,'Western Sahara','','',''),
	('ER','ERI',232,'Eritrea','Eritrea','Iertra(ti)/Irī̄trī̄yā̄(ar)/Eritrea(en)','Hagere Iertra(ti)/Dawlat Irī̄trī̄yā̄(ar)/Eritrea(en)'),
	('ES','ESP',724,'Spain','the Kingdom of Spain','España','el Reino de España'),
	('ET','ETH',231,'Ethiopia','the Federal Democratic Republic of Ethiopia','Ityop\'iya','Ye̱Ityop\'iya Fe̱de̱ralawi Dimokrasiyawi Ripe̱blik'),
	('FI','FIN',246,'Finland','the Republic of Finland','Suomi(fi)/Finland(sv)','Suomen tasavalta(fi)/Republiken Finland(sv)'),
	('FJ','FJI',242,'Fiji','the Republic of the Fiji Islands','Fijo(en)/Viti(fj)','the Republic of the Fiji Islands(en)/Matanitu ko Viti(fj)'),
	('FK','FLK',238,'Falkland Islands (Malvinas)','','',''),
	('FM','FSM',583,'Micronesia, Federated States of','the Federated States of Micronesia','Micronesia','the Federated States of Micronesia'),
	('FO','534',703,'Faroe Islands','','',''),
	('FR','FRA',250,'France','the French Republic','France','la République française'),
	('GA','GAB',266,'Gabon','the Gabonese Republic','Gabon','la République gabonaise'),
	('GB','GBR',826,'United Kingdom','the United Kingdom of Great Britain and Northern Ireland','United Kingdom of Great Britain and Northern Ireland','the United Kingdom of Great Britain and Northern Ireland'),
	('GD','GRD',308,'Grenada','Grenada','Grenada','Grenada'),
	('GE','GEO',268,'Georgia','Georgia','Sak\'art\'velo','Sak\'art\'velo'),
	('GF','GUF',254,'French Guiana','','',''),
	('GG','GGY',831,'Guernsey','','',''),
	('GH','GHA',288,'Ghana','the Republic of Ghana','Ghana','the Republic of Ghana'),
	('GI','GIB',292,'Gibraltar','','',''),
	('GL','GRL',304,'Greenland','','',''),
	('GM','GMB',270,'Gambia','the Republic of The Gambia','Gambia','The Republic of the Gambia'),
	('GN','GIN',324,'Guinea','the Republic of Guinea','Guinée','la République de Guinée'),
	('GP','GLP',312,'Guadeloupe','','',''),
	('GQ','GNQ',226,'Equatorial Guinea','the Republic of Equatorial Guinea','Guinée équatoriale(fr)/Guinea Ecuatorial(es)','la République de Guinée équatoriale(fr)/la República de Guinea Ecuatorial(es)/la République de Guinée équatoriale(fr)'),
	('GR','GRC',300,'Greece','the Hellenic Republic','Ellás','Ellinikí Dimokratía'),
	('GS','SGS',239,'South Georgia and the South Sandwich Islands','','',''),
	('GT','GTM',320,'Guatemala','the Republic of Guatemala','Guatemala','República de Guatemala'),
	('GU','GUM',316,'Guam','','',''),
	('GW','GNB',624,'Guinea-Bissau','the Republic of Guinea-Bissau','Guiné-Bissau','República da Guiné-Bissau'),
	('GY','GUY',328,'Guyana','the Republic of Guyana','Guyana','the Republic of Guyana'),
	('HK','HKG',344,'Hong Kong','','',''),
	('HM','HMD',334,'Heard Island and McDonald Islands','','',''),
	('HN','HND',340,'Honduras','the Republic of Honduras','Honduras','la República de Honduras'),
	('HR','HRV',191,'Croatia','the Republic of Crotia','Hrvatska','Republika Hrvatska'),
	('HT','HTI',332,'Haiti','the Republic of Haiti','Haïti(fr)/Atiyi(ht)','la République d’ Haïti(fr)/Repiblik d’Ayiti(ht)'),
	('HU','HUN',348,'Hungary','the Republic of Hungary','Magyarország','Magyar Köztársaság'),
	('ID','IDN',360,'Indonesia','the Republic of Indonesia','Indonesia','Republik Indonesia'),
	('IE','IRL',372,'Ireland','Ireland','Ireland(en)/Éire(ga)','Ireland(en)/Éire(ga)'),
	('IL','ISR',376,'Israel','the State of Israel','Yisra\'el(he)/Isrā\'īl(ar)','Medinat Yisra\'el(he)/Dawlat Isrā\'īl(ar)'),
	('IM','IMN',833,'Isle of Man','','',''),
	('IN','IND',356,'India','the Republic of India','India(en)/Bhārat(hi)','the Republic of India(en)/Bhāratīya Gaṇarājya(hi)'),
	('IO','IOT',86,'British Indian Ocean Territory','','',''),
	('IQ','IRQ',368,'Iraq','the Republic of Iraq','Al ‘Irāq','Al Jumhūrīyah al ‘Irāqīyah'),
	('IR','IRN',364,'Iran, Islamic Republic of','the Islamic Republic of Iran','Īrān','Jomhūrī-ye Eslāmī-ye Īrān'),
	('IS','ISL',352,'Iceland','the Republic of Iceland','Ísland','Lýðveldið Ísland'),
	('IT','ITA',380,'Italy','the Italian Republic','Italia','Repubblica Italiana'),
	('JE','JEY',832,'Jersey','','',''),
	('JM','JAM',388,'Jamaica','Jamaica','Jamaica','Jamaica'),
	('JO','JOR',400,'Jordan','the Hashemite Kingdom of Jordan','Al Urdun','Al Mamlakah al Urdunīyah al Hāshimīyah'),
	('JP','JPN',392,'Japan','Japan','Nihon/Nippon','Nihon-koku/Nippon-koku'),
	('KE','KEN',404,'Kenya','the Republic of Kenya','Kenya','the Republic of Kenya(en)/Jamhuri ya Kenya(sw)'),
	('KG','KGZ',417,'Kyrgyzstan','the Kyrgyz Republic','Kyrgyzstan','Kyrgyz Respublikasy(ky)/Kyrgyzskaja Respublika(ru)'),
	('KH','KHM',116,'Cambodia','the Kingdom of Cambodia','Kâmpŭchéa','Preăhréachéanachâkr Kâmpŭchéa'),
	('KI','KIR',296,'Kiribati','the Republic of Kiribati','Kiribati','the Republic of Kiribati(en)/Ribaberiki Kiribati(gil)'),
	('KM','COM',174,'Comoros','the Union of the Comoros','Al Qamar(ar)/Comores(fr)/Ndzwani/Komori','Ittiḩā̄d al Qamar(ar)/l\'Union des Comores(fr)/Udzima wa Komori'),
	('KN','KNA',659,'Saint Kitts and Nevis','Saint Kitts and Nevis','Saint Kitts and Nevis','Saint Kitts and Nevis'),
	('KP','PRK',408,'Korea, Democratic People\'s Republic of','the Democratic People\'s Republic of Korea','Chosŏn','Chosŏn-minjujuŭi-inmin-konghwaguk'),
	('KR','KOR',410,'Korea, Republic of','the Republic of Korea','Han’guk','Taehan Min’guk'),
	('KW','KWT',414,'Kuwait','the State of Kuwait','Al Kuwayt','Dawlat al Kuwayt'),
	('KY','CYM',136,'Cayman Islands','','',''),
	('KZ','KAZ',398,'Kazakhstan','the Republic of Kazakhstan','Qazaqstan(kk)/Kazahstan(ru)','Qazaqstan Respūblīkasy(kk)/Respublika Kazahstan(ru)'),
	('LA','LAO',418,'Lao People\'s Democratic Republic','the Lao People\'s Democratic Republic','','Sathalanalat Paxathipatai Paxaxôn Lao'),
	('LB','LBN',422,'Lebanon','the Lebanese Republic','Lubnān','Al Jumhūrīyah al Lubnānīyah'),
	('LC','LCA',662,'Saint Lucia','Saint Lucia','Saint Lucia','Saint Lucia'),
	('LI','LIE',438,'Liechtenstein','the Principality of Liechtenstein','Liechtenstein','Fürstentum Liechtenstein'),
	('LK','LKA',144,'Sri Lanka','the Democratic Socialist Republic of Sri Lanka','Shrī Laṁkāsi)/Ilaṅkai(ta)','Shrī Laṁkā Prajātāntrika Samājavā dī Janarajaya(si)/Ilaṅkai Jaṉanāyaka Choṣhalichak(ta)'),
	('LR','LBR',430,'Liberia','the Republic of Liberia','Liberia','the Republic of Liberia'),
	('LS','LSO',426,'Lesotho','the Kingdom of Lesotho','Lesotho','Kingdom of Lesotho'),
	('LT','LTU',440,'Lithuania','the Republic of Lithuania','Lietuva','Lietuvos Respublika'),
	('LU','LUX',442,'Luxembourg','the nGrand Duche de Luxembourg','Luxembourg(fr)/Luxemburg(de)/Lëtzebuerg(lb)','le Grand-Duché de Luxembourg(fr)/Großherzogtum Luxemburg(de)'),
	('LV','LVA',428,'Latvia','the Republic of Latvia','Latvija','Latvijas Republika'),
	('LY','LBY',434,'Libyan Arab Jamahiriya','the Socialist People\'s Libyan Arab Jamahiriya','Lībyā','Al Jamāhīrīyah al ‘Arabīyah al Lībīyah ash Sha‘bīyah al Ishtirākīyah al ‘Uz̧má'),
	('MA','MAR',504,'Morocco','the Kingdom of Morocco','Al Maghrib','Al Mamlakah al Maghribīyah'),
	('MC','MCO',492,'Monaco','the Principality of Monaco','Monaco','la Principauté de Monaco'),
	('MD','MDA',498,'Moldova, Republic of','the Republic of Moldova','Moldova','Republica Moldova'),
	('ME','MNE',499,'Montenegro','Montenegro','Crna Gora','Crna Gora'),
	('MF','MAF',663,'Saint Martin (French part)','','',''),
	('MG','MDG',450,'Madagascar','the Republic of Madagascar','Madagascar(fr)/Madagasikara(mg)','la République de Madagascar(fr)/Repoblikan\'i Madagasikara(mg)'),
	('MH','MHL',584,'Marshall Islands','the Republic of the Marshall Islands','Marshall Islands(en)/Aelōn̄ in M̧ajeļ(mh)','The Republic of the Marshall Islands(en)'),
	('MK','MKD',807,'Macedonia, The Former Yugoslav Republic of','The former Yugoslav Republic of Macedonia','','Poranešna Jugoslovenska Republika Makedonija'),
	('ML','MLI',466,'Mali','the Republic of Mali','Mali','la République du Mali'),
	('MM','MMR',104,'Myanmar','the Union of Myanmar','Myanma','Pyidaungzu Myanma Naingngandaw'),
	('MN','MNG',496,'Mongolia','Mongolia','Mongol','Mongol Uls'),
	('MO','MAC',446,'Macao','','',''),
	('MP','MNP',580,'Northern Mariana Islands','','',''),
	('MQ','MTQ',474,'Martinique','','',''),
	('MR','MRT',478,'Mauritania','the Islamic Republic of Mauritania','Mūrītānīya','Al Jumhūrīyah al Islāmīyah al Mūrītānīyah'),
	('MS','MSR',500,'Montserrat','','',''),
	('MT','MLT',470,'Malta','the Republic of Malta','Malta','the Republic of Malta(en)/Repubblika ta\' Malta(mt)'),
	('MU','MUS',480,'Mauritius','The Republic of Mauritius','Mauritius','The Republic of Mauritius'),
	('MV','MDV',462,'Maldives','the Republic of Maldives','Dhivehi Raajje','Dhivehi Raajjeyge Jumhooriyyaa'),
	('MW','MWI',454,'Malawi','the Republic of Malawi','Malaŵi(ny)/Malawi(en)','Dziko la Malaŵi(ny)/the Republic of Malawi(en)'),
	('MX','MEX',484,'Mexico','the United Mexican States','México','los Estados Unidos Méxicanos'),
	('MY','MYS',458,'Malaysia','Malaysia','Malaysia','Malaysia'),
	('MZ','MOZ',508,'Mozambique','the Republic of Mozambique','Moçambique','República de Moçambique'),
	('NA','NAM',516,'Namibia','the Republic of Namibia','Namibia','the Republic of Namibia'),
	('NC','NCL',540,'New Caledonia','','',''),
	('NE','NER',562,'Niger','the Republic of the Niger','Niger','la République du Niger'),
	('NF','NFK',574,'Norfolk Island','','',''),
	('NG','NGA',566,'Nigeria','the Federal Republic of Nigeria','Nigeria','the Federal Republic of Nigeria'),
	('NI','NIC',558,'Nicaragua','the Republic of Nicaragua','Nicaragua','la República de Nicaragua'),
	('NL','NLD',528,'Netherlands','the Kingdom of the Netherlands','Nederlan','Koninkrijk der Nederlanden'),
	('NO','NOR',578,'Norway','the Kingdom of Norway','Norge(nn)/Noreg(nb)','Kongeriket Norge(nn)/Kongeriket Noreg(nb)'),
	('NP','NPL',524,'Nepal','the Federal Democratic Republic of Nepal','Nepāl','Saṁghīya Loktāntrik Gaṇatantra Nepāl'),
	('NR','NRU',520,'Nauru','the Republic of Nauru','Nauru(en)/Naoero(na)','Republic of Nauru(en)'),
	('NU','NIU',570,'Niue','','',''),
	('NZ','NZL',554,'New Zealand','New Zealand','New Zealand(en)/Aotearoa(rar)','New Zealand(en)/Aotearoa(rar)'),
	('OM','OMN',512,'Oman','the Sultanate of Oman','‘Umān','Salţanat ‘Umān'),
	('PA','PAN',591,'Panama','the Republic of Panama','Panamá','la República de Panamá'),
	('PE','PER',604,'Peru','the Republic of Peru','Perú','la República del Perú'),
	('PF','PYF',258,'French Polynesia','','',''),
	('PG','PNG',598,'Papua New Guinea','Papua New Guinea','Papua New Guinea(en)/Papuaniugini(tpi)','Papua New Guinea(en)'),
	('PH','PHL',608,'Philippines','the Republic of the Philippines','Philippines(en)/Pilipinas(fil)','the Republic of the Philippines(en)/Republika ng Pilipinas(fil)'),
	('PK','PAK',586,'Pakistan','the Islamic Republic of Pakistan','Pakistan(en)/Pākistān(ur)','the Islamic Republic of Pakistan(en)/Jamhūryat Islāmī Pākistān(ur)'),
	('PL','POL',616,'Poland','the Republic of Poland','Polska','Rzeczpospolita Polska'),
	('PM','SPM',666,'Saint Pierre and Miquelon','','',''),
	('PN','PCN',612,'Pitcairn','','',''),
	('PR','PRI',630,'Puerto Rico','','',''),
	('PS','PSE',275,'Occupied Palestinian Territory','','',''),
	('PT','PRT',620,'Portugal','the Portuguese Republic','Portugal','República Portuguesa'),
	('PW','PLW',585,'Palau','the Republic of Palau','Palau(en)/Belau(pau)','the Republic of Palau(en)/Beluu er a Belau(pau)'),
	('PY','PRY',600,'Paraguay','the Republic of Paraguay','Paraguay','Paraguay Retãn(gn)/la República del Paraguay(es)'),
	('QA','QAT',634,'Qatar','the State of Qatar','Qaţar','Dawlat Qaţar'),
	('RE','REU',638,'Reunion','','',''),
	('RO','ROU',642,'Romania','Romania','România','România'),
	('RS','SRB',688,'Serbia','the Republic of Serbia','Srbija','Republika Srbija'),
	('RU','RUS',643,'Russian Federation','the Russian Federation','Rossija','Rossiyskaya Federatsiya'),
	('RW','RWA',646,'Rwanda','the Republic of Rwanda','Rwanda','the Republic of Rwanda(en)/la République du Rwanda (fr)/Republika y\'u Rwanda(rw)'),
	('SA','SAU',682,'Saudi Arabia','the Kingdom of Saudi Arabia','As Su‘ūdīyah','Al Mamlakah al ‘Arabīyah as Su‘ūdīyah'),
	('SB','SLB',90,'Solomon Islands','Solomon Islands','Solomon Islands','Solomon Islands'),
	('SC','SYC',690,'Seychelles','the Republic of Seychelles','Seychelles(en)/Seychelles(fr)/Sesel(cpe)','the Republic of Seychelles(en)/la République des Seychelles(fr)/Repiblik Sesel(cpe)'),
	('SD','SDN',736,'Sudan','the Republic of the Sudan','As Sūdān(ar)/Sudan(en)','Jumhūrīyat as Sūdān(ar)/Republic of the Sudan(en)'),
	('SE','SWE',752,'Sweden','the Kingdom of Sweden','Sverige','Konungariket Sverige'),
	('SG','SGP',702,'Singapore','the Republic of Singapore','Xinjiapo(zh)/Singapore(en)/Singapura(ms)/Chiṅkappūr(ta)','Xinjiapo Gongheguo(zh)/the Republic of Singapore(en)/Republik Singapura(ms)/Chiṅkappūr Kuṭiyarachu(ta)'),
	('SH','SHN',654,'Saint Helena, Ascension and Tristan da Cunha','','',''),
	('SI','SVN',705,'Slovenia','the Republic of Slovenia','Slovenija','Republika Slovenija'),
	('SJ','534',703,'Svalbard and Jan Mayen','','',''),
	('SK','SVK',703,'Slovakia','the Slovenska Republika','Slovensko','Slovenská republika'),
	('SL','SLE',694,'Sierra Leone','the Republic of Sierra Leone','Sierra Leone','the Republic of Sierra Leone'),
	('SM','SMR',674,'San Marino','the Republic of San Marino','San Marino','Repubblica di San Marino'),
	('SN','SEN',686,'Senegal','the Republic of Senegal','Sénégal','la République du Sénégal'),
	('SO','SOM',706,'Somalia','the Somalia Republic','Aş Şūmāl(ar)/Soomaaliya(so)','Jumhūrīyat aş Şūmāl (ar)/Jamhuuriyadda Soomaaliya(so)'),
	('SR','SUR',740,'Suriname','the Republic of Suriname','Suriname','Republiek Suriname'),
	('ST','STP',678,'Sao Tome and Principe','the Democratic Republic of Sao Tome and Principe','São Tomé e Príncipe','República Democrática de São Tomé e Príncipe'),
	('SV','SLV',222,'El Salvador','the Republic of El Salvador','El Salvador','la República de El Salvador'),
	('SX','SXM',534,'Sint Maarten (Dutch part)','','',''),
	('SY','SYR',760,'Syrian Arab Republic','the Syrian Arab Republic','Sūrīyah','Al Jumhūrīyah al ‘Arabīyah as Sūrīyah'),
	('SZ','SWZ',748,'Swaziland','the Kingdom of Swaziland','Swaziland(en)/eSwatini(ss)','the Kingdom of Swaziland(en)/Umbuso weSwatini(ss)'),
	('TC','TCA',796,'Turks and Caicos Islands','','',''),
	('TD','TCD',148,'Chad','the Republic of Chad','Tshā̄d','Jumhū̄rī̄yat Tshā̄d'),
	('TF','ATF',260,'French Southern Territories','','',''),
	('TG','TGO',768,'Togo','the Togolese Republic','Togo','la République togolaise'),
	('TH','THA',764,'Thailand','the Kingdom of Thailand','Prathet Thai','Ratcha Anachak Thai'),
	('TJ','TJK',762,'Tajikistan','the Republic of Tajikistan','',''),
	('TK','TKL',772,'Tokelau','','',''),
	('TL','TLS',626,'Timor-Leste','the Democratic Republic of Timor-Leste','Timor-Leste(pr)/Timor Lorosa’e(tet)','República Democrática de Timor-Leste(pr)/Repúblika Demokrátika Timor Lorosa\'e(tet)'),
	('TM','TKM',795,'Turkmenistan','Turkmenistan','Türkmenistan','Türkmenistan'),
	('TN','TUN',788,'Tunisia','the Republic of Tunisia','Tūnis','Al Jumhūrīyah at Tūnisīyah'),
	('TO','TON',776,'Tonga','the Kingdom of Tonga','Tonga','the Kingdom of Tonga(en)/Pule?anga Tonga(to)'),
	('TR','TUR',792,'Turkey','the Republic of Turkey','Türkiye','Türkiye Cumhuriyeti'),
	('TT','TTO',780,'Trinidad and Tobago','the Republic of Trinidad and Tobago','Trinidad and Tobago','the Republic of Trinidad and Tobago'),
	('TV','TUV',798,'Tuvalu','Tuvalu','Tuvalu','Tuvalu'),
	('TW','TWN',158,'Taiwan, Province of China','','',''),
	('TZ','TZA',834,'Tanzania, United Republic of','the United Republic of Tanzania','United Republic of Tanzania(en)/Tanzania(sw)','the United Republic of Tanzania(en)/Jamhuri ya Muungano wa Tanzania(sw)'),
	('UA','UKR',804,'Ukraine','Ukraine','Ukraina','Ukraina'),
	('UG','UGA',800,'Uganda','the Republic of Uganda','Uganda','the Republic of Uganda'),
	('UM','UMI',581,'United States Minor Outlying Islands','','',''),
	('US','USA',840,'United States','the United States of America','United States of America','the United States of America'),
	('UY','URY',858,'Uruguay','the Eastern Republic of Uruguay','Uruguay','la República Oriental del Uruguay'),
	('UZ','UZB',860,'Uzbekistan','the Republic of Uzbekistan','O‘zbekiston','O‘zbekiston Respublikasi'),
	('VA','VAT',336,'Holy See (Vatican City State)','','',''),
	('VC','VCT',670,'Saint Vincent and The Grenadines','Saint Vincent and the Grenadines','Saint Vincent and The Grenadines','Saint Vincent and The Grenadines'),
	('VE','VEN',862,'Venezuela, Bolivarian Republic of','the Bolivarian Republic of Venezuela','Venezuela','la República Bolivariana de Venezuela'),
	('VG','VGB',92,'Virgin Islands, British','','',''),
	('VI','VIR',850,'Virgin Islands, U.S.','','',''),
	('VN','VNM',704,'Viet Nam','the Socialist Republic of Vietnam','Việt Nam','Cộng Hòa Xã Hội Chủ Nghĩa Việt Nam'),
	('VU','VUT',548,'Vanuatu','the Republic of Vanuatu','Vanuatu','the Republic of Vanuatu(en)/la République de Vanuatu(fr)/Ripablik blong Vanuatu(bi)'),
	('WF','WLF',876,'Wallis and Futuna','','',''),
	('WS','WSM',882,'Samoa','the Independent State of Samoa','Samoa','the Independent State of Samoa(en)/Malo Sa?oloto Tuto?atasi o Samoa(sm)'),
	('YE','YEM',887,'Yemen','the Republic of Yemen','Al Yaman','Al Jumhūrīyah al Yamanīyah'),
	('YT','MYT',175,'Mayotte','','',''),
	('ZA','ZAF',710,'South Africa','Republic of South Africa','South Africa(en)/Suid-Afrika(af)/Ningizimu Afrika(zu)/uMzantsi Afrika(xh)/Afrika-Borwa(nso)','Republic of South Africa(en)/Republiek van Suid-Afrika(af)/iRiphabliki yaseNingizimu Afrika(zu)/iRiphabliki yaseMzantsi Afrika(xh)/Rephaboliki ya Afrika-Borwa(nso)'),
	('ZM','ZMB',894,'Zambia','the Republic of Zambia','Zambia','the Republic of Zambia'),
	('ZW','ZWE',716,'Zimbabwe','the Republic of Zimbabwe','Zimbabwe','the Republic of Zimbabwe');

/*!40000 ALTER TABLE `countries` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;