pvilas/iso3166.sql

## iso3166.sql
/*
# list taken from http://userpage.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
# this script generates
s=open('paisos.sql', 'r')
linia=s.readline()
while linia:
        #print linia
        descripcio=linia[0:47].strip().replace("\"", "").replace("\'", "")
        #print descripcio
        a2=linia[48:50].strip()
        #print a2
        a3=linia[56:59].strip()
        #print a3
        n=linia[64:67].strip()
        #print n
        print "INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('%s', '%s', %s, '%s');" % (a2, a3, n, descripcio)
        linia=s.readline()
s.close()
# this file
*/
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('AX', 'ALA', 248, 'AALAND ISLANDS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('AF', 'AFG', 004, 'AFGHANISTAN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('AL', 'ALB', 008, 'ALBANIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('DZ', 'DZA', 012, 'ALGERIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('AS', 'ASM', 016, 'AMERICAN SAMOA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('AD', 'AND', 020, 'ANDORRA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('AO', 'AGO', 024, 'ANGOLA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('AI', 'AIA', 660, 'ANGUILLA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('AQ', 'ATA', 010, 'ANTARCTICA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('AG', 'ATG', 028, 'ANTIGUA AND BARBUDA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('AR', 'ARG', 032, 'ARGENTINA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('AM', 'ARM', 051, 'ARMENIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('AW', 'ABW', 533, 'ARUBA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('AU', 'AUS', 036, 'AUSTRALIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('AT', 'AUT', 040, 'AUSTRIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('AZ', 'AZE', 031, 'AZERBAIJAN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BS', 'BHS', 044, 'BAHAMAS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BH', 'BHR', 048, 'BAHRAIN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BD', 'BGD', 050, 'BANGLADESH');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BB', 'BRB', 052, 'BARBADOS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BY', 'BLR', 112, 'BELARUS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BE', 'BEL', 056, 'BELGIUM');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BZ', 'BLZ', 084, 'BELIZE');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BJ', 'BEN', 204, 'BENIN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BM', 'BMU', 060, 'BERMUDA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BT', 'BTN', 064, 'BHUTAN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BO', 'BOL', 068, 'BOLIVIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BA', 'BIH', 070, 'BOSNIA AND HERZEGOWINA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BW', 'BWA', 072, 'BOTSWANA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BV', 'BVT', 074, 'BOUVET ISLAND');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BR', 'BRA', 076, 'BRAZIL');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('IO', 'IOT', 086, 'BRITISH INDIAN OCEAN TERRITORY');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BN', 'BRN', 096, 'BRUNEI DARUSSALAM');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BG', 'BGR', 100, 'BULGARIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BF', 'BFA', 854, 'BURKINA FASO');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('BI', 'BDI', 108, 'BURUNDI');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('KH', 'KHM', 116, 'CAMBODIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CM', 'CMR', 120, 'CAMEROON');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CA', 'CAN', 124, 'CANADA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CV', 'CPV', 132, 'CAPE VERDE');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('KY', 'CYM', 136, 'CAYMAN ISLANDS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CF', 'CAF', 140, 'CENTRAL AFRICAN REPUBLIC');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('TD', 'TCD', 148, 'CHAD');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CL', 'CHL', 152, 'CHILE');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CN', 'CHN', 156, 'CHINA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CX', 'CXR', 162, 'CHRISTMAS ISLAND');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CC', 'CCK', 166, 'COCOS (KEELING) ISLANDS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CO', 'COL', 170, 'COLOMBIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('KM', 'COM', 174, 'COMOROS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CD', 'COD', 180, 'CONGO, Democratic Republic of (was Zaire)');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CG', 'COG', 178, 'CONGO, Republic of');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CK', 'COK', 184, 'COOK ISLANDS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CR', 'CRI', 188, 'COSTA RICA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CI', 'CIV', 384, 'COTE DIVOIRE');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('HR', 'HRV', 191, 'CROATIA (local name: Hrvatska)');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CU', 'CUB', 192, 'CUBA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CY', 'CYP', 196, 'CYPRUS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CZ', 'CZE', 203, 'CZECH REPUBLIC');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('DK', 'DNK', 208, 'DENMARK');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('DJ', 'DJI', 262, 'DJIBOUTI');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('DM', 'DMA', 212, 'DOMINICA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('DO', 'DOM', 214, 'DOMINICAN REPUBLIC');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('EC', 'ECU', 218, 'ECUADOR');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('EG', 'EGY', 818, 'EGYPT');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SV', 'SLV', 222, 'EL SALVADOR');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GQ', 'GNQ', 226, 'EQUATORIAL GUINEA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('ER', 'ERI', 232, 'ERITREA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('EE', 'EST', 233, 'ESTONIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('ET', 'ETH', 231, 'ETHIOPIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('FK', 'FLK', 238, 'FALKLAND ISLANDS (MALVINAS)');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('FO', 'FRO', 234, 'FAROE ISLANDS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('FJ', 'FJI', 242, 'FIJI');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('FI', 'FIN', 246, 'FINLAND');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('FR', 'FRA', 250, 'FRANCE');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GF', 'GUF', 254, 'FRENCH GUIANA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('PF', 'PYF', 258, 'FRENCH POLYNESIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('TF', 'ATF', 260, 'FRENCH SOUTHERN TERRITORIES');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GA', 'GAB', 266, 'GABON');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GM', 'GMB', 270, 'GAMBIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GE', 'GEO', 268, 'GEORGIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('DE', 'DEU', 276, 'GERMANY');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GH', 'GHA', 288, 'GHANA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GI', 'GIB', 292, 'GIBRALTAR');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GR', 'GRC', 300, 'GREECE');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GL', 'GRL', 304, 'GREENLAND');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GD', 'GRD', 308, 'GRENADA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GP', 'GLP', 312, 'GUADELOUPE');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GU', 'GUM', 316, 'GUAM');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GT', 'GTM', 320, 'GUATEMALA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GN', 'GIN', 324, 'GUINEA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GW', 'GNB', 624, 'GUINEA-BISSAU');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GY', 'GUY', 328, 'GUYANA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('HT', 'HTI', 332, 'HAITI');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('HM', 'HMD', 334, 'HEARD AND MC DONALD ISLANDS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('HN', 'HND', 340, 'HONDURAS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('HK', 'HKG', 344, 'HONG KONG');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('HU', 'HUN', 348, 'HUNGARY');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('IS', 'ISL', 352, 'ICELAND');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('IN', 'IND', 356, 'INDIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('ID', 'IDN', 360, 'INDONESIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('IR', 'IRN', 364, 'IRAN (ISLAMIC REPUBLIC OF)');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('IQ', 'IRQ', 368, 'IRAQ');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('IE', 'IRL', 372, 'IRELAND');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('IL', 'ISR', 376, 'ISRAEL');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('IT', 'ITA', 380, 'ITALY');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('JM', 'JAM', 388, 'JAMAICA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('JP', 'JPN', 392, 'JAPAN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('JO', 'JOR', 400, 'JORDAN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('KZ', 'KAZ', 398, 'KAZAKHSTAN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('KE', 'KEN', 404, 'KENYA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('KI', 'KIR', 296, 'KIRIBATI');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('KP', 'PRK', 408, 'KOREA, DEMOCRATIC PEOPLES REPUBLIC OF');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('KR', 'KOR', 410, 'KOREA, REPUBLIC OF');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('KW', 'KWT', 414, 'KUWAIT');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('KG', 'KGZ', 417, 'KYRGYZSTAN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('LA', 'LAO', 418, 'LAO PEOPLES DEMOCRATIC REPUBLIC');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('LV', 'LVA', 428, 'LATVIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('LB', 'LBN', 422, 'LEBANON');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('LS', 'LSO', 426, 'LESOTHO');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('LR', 'LBR', 430, 'LIBERIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('LY', 'LBY', 434, 'LIBYAN ARAB JAMAHIRIYA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('LI', 'LIE', 438, 'LIECHTENSTEIN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('LT', 'LTU', 440, 'LITHUANIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('LU', 'LUX', 442, 'LUXEMBOURG');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MO', 'MAC', 446, 'MACAU');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MK', 'MKD', 807, 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MG', 'MDG', 450, 'MADAGASCAR');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MW', 'MWI', 454, 'MALAWI');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MY', 'MYS', 458, 'MALAYSIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MV', 'MDV', 462, 'MALDIVES');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('ML', 'MLI', 466, 'MALI');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MT', 'MLT', 470, 'MALTA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MH', 'MHL', 584, 'MARSHALL ISLANDS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MQ', 'MTQ', 474, 'MARTINIQUE');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MR', 'MRT', 478, 'MAURITANIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MU', 'MUS', 480, 'MAURITIUS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('YT', 'MYT', 175, 'MAYOTTE');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MX', 'MEX', 484, 'MEXICO');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('FM', 'FSM', 583, 'MICRONESIA, FEDERATED STATES OF');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MD', 'MDA', 498, 'MOLDOVA, REPUBLIC OF');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MC', 'MCO', 492, 'MONACO');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MN', 'MNG', 496, 'MONGOLIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MS', 'MSR', 500, 'MONTSERRAT');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MA', 'MAR', 504, 'MOROCCO');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MZ', 'MOZ', 508, 'MOZAMBIQUE');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MM', 'MMR', 104, 'MYANMAR');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('NA', 'NAM', 516, 'NAMIBIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('NR', 'NRU', 520, 'NAURU');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('NP', 'NPL', 524, 'NEPAL');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('NL', 'NLD', 528, 'NETHERLANDS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('AN', 'ANT', 530, 'NETHERLANDS ANTILLES');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('NC', 'NCL', 540, 'NEW CALEDONIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('NZ', 'NZL', 554, 'NEW ZEALAND');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('NI', 'NIC', 558, 'NICARAGUA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('NE', 'NER', 562, 'NIGER');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('NG', 'NGA', 566, 'NIGERIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('NU', 'NIU', 570, 'NIUE');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('NF', 'NFK', 574, 'NORFOLK ISLAND');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('MP', 'MNP', 580, 'NORTHERN MARIANA ISLANDS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('NO', 'NOR', 578, 'NORWAY');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('OM', 'OMN', 512, 'OMAN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('PK', 'PAK', 586, 'PAKISTAN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('PW', 'PLW', 585, 'PALAU');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('PS', 'PSE', 275, 'PALESTINIAN TERRITORY, Occupied');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('PA', 'PAN', 591, 'PANAMA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('PG', 'PNG', 598, 'PAPUA NEW GUINEA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('PY', 'PRY', 600, 'PARAGUAY');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('PE', 'PER', 604, 'PERU');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('PH', 'PHL', 608, 'PHILIPPINES');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('PN', 'PCN', 612, 'PITCAIRN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('PL', 'POL', 616, 'POLAND');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('PT', 'PRT', 620, 'PORTUGAL');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('PR', 'PRI', 630, 'PUERTO RICO');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('QA', 'QAT', 634, 'QATAR');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('RE', 'REU', 638, 'REUNION');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('RO', 'ROU', 642, 'ROMANIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('RU', 'RUS', 643, 'RUSSIAN FEDERATION');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('RW', 'RWA', 646, 'RWANDA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SH', 'SHN', 654, 'SAINT HELENA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('KN', 'KNA', 659, 'SAINT KITTS AND NEVIS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('LC', 'LCA', 662, 'SAINT LUCIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('PM', 'SPM', 666, 'SAINT PIERRE AND MIQUELON');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('VC', 'VCT', 670, 'SAINT VINCENT AND THE GRENADINES');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('WS', 'WSM', 882, 'SAMOA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SM', 'SMR', 674, 'SAN MARINO');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('ST', 'STP', 678, 'SAO TOME AND PRINCIPE');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SA', 'SAU', 682, 'SAUDI ARABIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SN', 'SEN', 686, 'SENEGAL');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CS', 'SCG', 891, 'SERBIA AND MONTENEGRO');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SC', 'SYC', 690, 'SEYCHELLES');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SL', 'SLE', 694, 'SIERRA LEONE');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SG', 'SGP', 702, 'SINGAPORE');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SK', 'SVK', 703, 'SLOVAKIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SI', 'SVN', 705, 'SLOVENIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SB', 'SLB', 090, 'SOLOMON ISLANDS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SO', 'SOM', 706, 'SOMALIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('ZA', 'ZAF', 710, 'SOUTH AFRICA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GS', 'SGS', 239, 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('ES', 'ESP', 724, 'SPAIN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('LK', 'LKA', 144, 'SRI LANKA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SD', 'SDN', 736, 'SUDAN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SR', 'SUR', 740, 'SURINAME');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SJ', 'SJM', 744, 'SVALBARD AND JAN MAYEN ISLANDS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SZ', 'SWZ', 748, 'SWAZILAND');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SE', 'SWE', 752, 'SWEDEN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('CH', 'CHE', 756, 'SWITZERLAND');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('SY', 'SYR', 760, 'SYRIAN ARAB REPUBLIC');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('TW', 'TWN', 158, 'TAIWAN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('TJ', 'TJK', 762, 'TAJIKISTAN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('TZ', 'TZA', 834, 'TANZANIA, UNITED REPUBLIC OF');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('TH', 'THA', 764, 'THAILAND');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('TL', 'TLS', 626, 'TIMOR-LESTE');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('TG', 'TGO', 768, 'TOGO');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('TK', 'TKL', 772, 'TOKELAU');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('TO', 'TON', 776, 'TONGA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('TT', 'TTO', 780, 'TRINIDAD AND TOBAGO');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('TN', 'TUN', 788, 'TUNISIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('TR', 'TUR', 792, 'TURKEY');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('TM', 'TKM', 795, 'TURKMENISTAN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('TC', 'TCA', 796, 'TURKS AND CAICOS ISLANDS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('TV', 'TUV', 798, 'TUVALU');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('UG', 'UGA', 800, 'UGANDA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('UA', 'UKR', 804, 'UKRAINE');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('AE', 'ARE', 784, 'UNITED ARAB EMIRATES');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('GB', 'GBR', 826, 'UNITED KINGDOM');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('US', 'USA', 840, 'UNITED STATES');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('UM', 'UMI', 581, 'UNITED STATES MINOR OUTLYING ISLANDS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('UY', 'URY', 858, 'URUGUAY');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('UZ', 'UZB', 860, 'UZBEKISTAN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('VU', 'VUT', 548, 'VANUATU');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('VA', 'VAT', 336, 'VATICAN CITY STATE (HOLY SEE)');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('VE', 'VEN', 862, 'VENEZUELA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('VN', 'VNM', 704, 'VIET NAM');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('VG', 'VGB', 092, 'VIRGIN ISLANDS (BRITISH)');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('VI', 'VIR', 850, 'VIRGIN ISLANDS (U.S.)');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('WF', 'WLF', 876, 'WALLIS AND FUTUNA ISLANDS');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('EH', 'ESH', 732, 'WESTERN SAHARA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('YE', 'YEM', 887, 'YEMEN');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('ZM', 'ZMB', 894, 'ZAMBIA');
INSERT INTO PAISES(A2, A3, N, DESCRIPCION) VALUES('ZW', 'ZWE', 716, 'ZIMBABWE');