CREATE TABLE `ma_DCountry` ( `id` char(2) NOT NULL, `isoAlpha3` char(3) NOT NULL, `name` varchar(255) NOT NULL, `sorter` int(11) NOT NULL, `visible` enum('n','y') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `ma_DCountry` (`id`, `isoAlpha3`, `name`, `sorter`, `visible`) VALUES ('AD', 'AND', 'ANDORRA', 5, 'n'), ('AE', 'ARE', 'UNITED ARAB EMIRATES', 192, 'n'), ('AF', 'AFG', 'AFGHANISTAN', 2, 'n'), ('AG', 'ATG', 'ANTIGUA AND BARBUDA', 8, 'n'), ('AL', 'ALB', 'ALBANIA', 3, 'n'), ('AM', 'ARM', 'ARMENIA', 10, 'n'), ('AO', 'AGO', 'ANGOLA', 6, 'n'), ('AQ', 'ATA', 'ANTARCTICA', 7, 'n'), ('AR', 'ARG', 'ARGENTINA', 9, 'n'), ('AT', 'AUT', 'AUSTRIA', 13, 'n'), ('AU', 'AUS', 'AUSTRALIA', 12, 'n'), ('AW', 'ABW', 'ARUBA', 11, 'n'), ('AZ', 'AZE', 'AZERBAIJAN', 14, 'n'), ('BA', 'BIH', 'BOSNIA AND HERZEGOVINA', 26, 'n'), ('BB', 'BRB', 'BARBADOS', 18, 'n'), ('BD', 'BGD', 'BANGLADESH', 17, 'n'), ('BE', 'BEL', 'BELGIUM', 20, 'n'), ('BF', 'BFA', 'BURKINA FASO', 32, 'n'), ('BG', 'BGR', 'BULGARIA', 31, 'n'), ('BH', 'BHR', 'BAHRAIN', 16, 'n'), ('BI', 'BDI', 'BURUNDI', 33, 'n'), ('BJ', 'BEN', 'BENIN', 22, 'n'), ('BM', 'BMU', 'BERMUDA', 23, 'n'), ('BN', 'BRN', 'BRUNEI DARUSSALAM', 30, 'n'), ('BO', 'BOL', 'BOLIVIA', 25, 'n'), ('BR', 'BRA', 'BRAZIL', 28, 'n'), ('BS', 'BHS', 'BAHAMAS', 15, 'n'), ('BT', 'BTN', 'BHUTAN', 24, 'n'), ('BW', 'BWA', 'BOTSWANA', 27, 'n'), ('BY', 'BLR', 'BELARUS', 19, 'n'), ('BZ', 'BLZ', 'BELIZE', 21, 'n'), ('CA', 'CAN', 'CANADA', 36, 'y'), ('CD', 'COD', 'CONGO, DEMOCRATIC REPUBLIC OF THE', 45, 'n'), ('CF', 'CAF', 'CENTRAL AFRICAN REPUBLIC', 38, 'n'), ('CG', 'COG', 'CONGO', 44, 'n'), ('CH', 'CHE', 'SWITZERLAND', 178, 'n'), ('CI', 'CIV', 'COTE D\'IVOIRE', 47, 'n'), ('CL', 'CHL', 'CHILE', 40, 'n'), ('CM', 'CMR', 'CAMEROON', 35, 'n'), ('CN', 'CHN', 'CHINA', 41, 'n'), ('CO', 'COL', 'COLOMBIA', 42, 'n'), ('CR', 'CRI', 'COSTA RICA', 46, 'n'), ('CU', 'CUB', 'CUBA', 49, 'n'), ('CV', 'CPV', 'CAPE VERDE', 37, 'n'), ('CY', 'CYP', 'CYPRUS', 50, 'n'), ('CZ', 'CZE', 'CZECH REPUBLIC', 51, 'n'), ('DE', 'DEU', 'GERMANY', 72, 'n'), ('DJ', 'DJI', 'DJIBOUTI', 53, 'n'), ('DK', 'DNK', 'DENMARK', 52, 'n'), ('DM', 'DMA', 'DOMINICA', 54, 'n'), ('DO', 'DOM', 'DOMINICAN REPUBLIC', 55, 'n'), ('DZ', 'DZA', 'ALGERIA', 4, 'n'), ('EC', 'ECU', 'ECUADOR', 56, 'n'), ('EE', 'EST', 'ESTONIA', 61, 'n'), ('EG', 'EGY', 'EGYPT', 57, 'n'), ('EH', 'ESH', 'WESTERN SAHARA', 200, 'n'), ('ER', 'ERI', 'ERITREA', 60, 'n'), ('ES', 'ESP', 'SPAIN', 172, 'n'), ('ET', 'ETH', 'ETHIOPIA', 62, 'n'), ('FI', 'FIN', 'FINLAND', 65, 'n'), ('FJ', 'FJI', 'FIJI', 64, 'n'), ('FM', 'FSM', 'MICRONESIA, FEDERATED STATES OF', 123, 'n'), ('FO', 'FRO', 'FAROE ISLANDS', 63, 'n'), ('FR', 'FRA', 'FRANCE', 66, 'n'), ('GA', 'GAB', 'GABON', 69, 'n'), ('GB', 'GBR', 'UNITED KINGDOM', 193, 'n'), ('GD', 'GRD', 'GRENADA', 75, 'n'), ('GE', 'GEO', 'GEORGIA', 71, 'n'), ('GF', 'GUF', 'FRENCH GUIANA', 67, 'n'), ('GH', 'GHA', 'GHANA', 73, 'n'), ('GM', 'GMB', 'GAMBIA', 70, 'n'), ('GN', 'GIN', 'GUINEA', 78, 'n'), ('GP', 'GLP', 'GUADELOUPE', 76, 'n'), ('GQ', 'GNQ', 'EQUATORIAL GUINEA', 59, 'n'), ('GR', 'GRC', 'GREECE', 74, 'n'), ('GT', 'GTM', 'GUATEMALA', 77, 'n'), ('GW', 'GNB', 'GUINEA-BISSAU', 79, 'n'), ('GY', 'GUY', 'GUYANA', 80, 'n'), ('HN', 'HND', 'HONDURAS', 82, 'n'), ('HR', 'HRV', 'CROATIA', 48, 'n'), ('HT', 'HTI', 'HAITI', 81, 'n'), ('HU', 'HUN', 'HUNGARY', 83, 'n'), ('ID', 'IDN', 'INDONESIA', 86, 'n'), ('IE', 'IRL', 'IRELAND', 89, 'n'), ('IL', 'ISR', 'ISRAEL', 90, 'n'), ('IN', 'IND', 'INDIA', 85, 'n'), ('IO', 'IOT', 'BRITISH INDIAN OCEAN TERRITORY', 29, 'n'), ('IQ', 'IRQ', 'IRAQ', 88, 'n'), ('IR', 'IRN', 'IRAN, ISLAMIC REPUBLIC OF', 87, 'n'), ('IS', 'ISL', 'ICELAND', 84, 'n'), ('IT', 'ITA', 'ITALY', 91, 'n'), ('JE', 'JEY', 'JERSEY', 94, 'n'), ('JM', 'JAM', 'JAMAICA', 92, 'n'), ('JO', 'JOR', 'JORDAN', 95, 'n'), ('JP', 'JPN', 'JAPAN', 93, 'n'), ('KE', 'KEN', 'KENYA', 97, 'n'), ('KG', 'KGZ', 'KYRGYZSTAN', 102, 'n'), ('KH', 'KHM', 'CAMBODIA', 34, 'n'), ('KI', 'KIR', 'KIRIBATI', 98, 'n'), ('KM', 'COM', 'COMOROS', 43, 'n'), ('KN', 'KNA', 'SAINT KITTS AND NEVIS', 157, 'n'), ('KP', 'PRK', 'KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF', 99, 'n'), ('KR', 'KOR', 'KOREA, REPUBLIC OF', 100, 'n'), ('KW', 'KWT', 'KUWAIT', 101, 'n'), ('KZ', 'KAZ', 'KAZAKHSTAN', 96, 'n'), ('LA', 'LAO', 'LAO PEOPLE\'S DEMOCRATIC REPUBLIC', 103, 'n'), ('LB', 'LBN', 'LEBANON', 105, 'n'), ('LC', 'LCA', 'SAINT LUCIA', 158, 'n'), ('LI', 'LIE', 'LIECHTENSTEIN', 109, 'n'), ('LK', 'LKA', 'SRI LANKA', 173, 'n'), ('LR', 'LBR', 'LIBERIA', 107, 'n'), ('LS', 'LSO', 'LESOTHO', 106, 'n'), ('LT', 'LTU', 'LITHUANIA', 110, 'n'), ('LU', 'LUX', 'LUXEMBOURG', 111, 'n'), ('LV', 'LVA', 'LATVIA', 104, 'n'), ('LY', 'LBY', 'LIBYAN ARAB JAMAHIRIYA', 108, 'n'), ('MA', 'MAR', 'MOROCCO', 129, 'n'), ('MC', 'MCO', 'MONACO', 125, 'n'), ('MD', 'MDA', 'MOLDOVA', 124, 'n'), ('ME', 'MNE', 'MONTENEGRO', 127, 'n'), ('MG', 'MDG', 'MADAGASCAR', 114, 'n'), ('MK', 'MKD', 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 113, 'n'), ('ML', 'MLI', 'MALI', 118, 'n'), ('MM', 'MMR', 'MYANMAR', 131, 'n'), ('MN', 'MNG', 'MONGOLIA', 126, 'n'), ('MO', 'MAC', 'MACAU', 112, 'n'), ('MQ', 'MTQ', 'MARTINIQUE', 119, 'n'), ('MR', 'MRT', 'MAURITANIA', 120, 'n'), ('MS', 'MSR', 'MONTSERRAT', 128, 'n'), ('MU', 'MUS', 'MAURITIUS', 121, 'n'), ('MV', 'MDV', 'MALDIVES', 117, 'n'), ('MW', 'MWI', 'MALAWI', 115, 'n'), ('MX', 'MEX', 'MEXICO', 122, 'n'), ('MY', 'MYS', 'MALAYSIA', 116, 'n'), ('MZ', 'MOZ', 'MOZAMBIQUE', 130, 'n'), ('NA', 'NAM', 'NAMIBIA', 132, 'n'), ('NE', 'NER', 'NIGER', 137, 'n'), ('NG', 'NGA', 'NIGERIA', 138, 'n'), ('NI', 'NIC', 'NICARAGUA', 136, 'n'), ('NL', 'NLD', 'NETHERLANDS', 134, 'n'), ('NO', 'NOR', 'NORWAY', 139, 'n'), ('NP', 'NPL', 'NEPAL', 133, 'n'), ('NZ', 'NZL', 'NEW ZEALAND', 135, 'n'), ('OM', 'OMN', 'OMAN', 140, 'n'), ('PA', 'PAN', 'PANAMA', 144, 'n'), ('PE', 'PER', 'PERU', 147, 'n'), ('PG', 'PNG', 'PAPUA NEW GUINEA', 145, 'n'), ('PH', 'PHL', 'PHILIPPINES', 148, 'n'), ('PK', 'PAK', 'PAKISTAN', 141, 'n'), ('PL', 'POL', 'POLAND', 149, 'n'), ('PS', 'PSE', 'PALESTINIAN TERRITORY', 143, 'n'), ('PT', 'PRT', 'PORTUGAL', 150, 'n'), ('PW', 'PLW', 'PALAU', 142, 'n'), ('PY', 'PRY', 'PARAGUAY', 146, 'n'), ('QA', 'QAT', 'QATAR', 151, 'n'), ('RE', 'REU', 'REUNION', 152, 'n'), ('RO', 'ROU', 'ROMANIA', 153, 'n'), ('RS', 'SRB', 'SERBIA', 164, 'n'), ('RU', 'RUS', 'RUSSIAN FEDERATION', 154, 'n'), ('RW', 'RWA', 'RWANDA', 155, 'n'), ('SA', 'SAU', 'SAUDI ARABIA', 162, 'n'), ('SB', 'SLB', 'SOLOMON ISLANDS', 169, 'n'), ('SC', 'SYC', 'SEYCHELLES', 165, 'n'), ('SD', 'SDN', 'SUDAN', 174, 'n'), ('SE', 'SWE', 'SWEDEN', 177, 'n'), ('SH', 'SHN', 'SAINT HELENA', 156, 'n'), ('SI', 'SVN', 'SLOVENIA', 168, 'n'), ('SK', 'SVK', 'SLOVAKIA', 167, 'n'), ('SL', 'SLE', 'SIERRA LEONE', 166, 'n'), ('SM', 'SMR', 'SAN MARINO', 160, 'n'), ('SN', 'SEN', 'SENEGAL', 163, 'n'), ('SO', 'SOM', 'SOMALIA', 170, 'n'), ('SR', 'SUR', 'SURINAME', 175, 'n'), ('ST', 'STP', 'SAO TOME AND PRINCIPE', 161, 'n'), ('SV', 'SLV', 'EL SALVADOR', 58, 'n'), ('SY', 'SYR', 'SYRIAN ARAB REPUBLIC', 179, 'n'), ('SZ', 'SWZ', 'SWAZILAND', 176, 'n'), ('TD', 'TCD', 'CHAD', 39, 'n'), ('TF', 'ATF', 'FRENCH SOUTHERN TERRITORIES', 68, 'n'), ('TG', 'TGO', 'TOGO', 185, 'n'), ('TH', 'THA', 'THAILAND', 183, 'n'), ('TJ', 'TJK', 'TAJIKISTAN', 181, 'n'), ('TL', 'TLS', 'TIMOR-LESTE (EAST TIMOR)', 184, 'n'), ('TM', 'TKM', 'TURKMENISTAN', 189, 'n'), ('TN', 'TUN', 'TUNISIA', 187, 'n'), ('TR', 'TUR', 'TURKEY', 188, 'n'), ('TT', 'TTO', 'TRINIDAD AND TOBAGO', 186, 'n'), ('TW', 'TWN', 'TAIWAN, PROVINCE OF CHINA', 180, 'n'), ('TZ', 'TZA', 'TANZANIA, UNITED REPUBLIC OF', 182, 'n'), ('UA', 'UKR', 'UKRAINE', 191, 'n'), ('UG', 'UGA', 'UGANDA', 190, 'n'), ('US', 'USA', 'UNITED STATES', 0, 'y'), ('UY', 'URY', 'URUGUAY', 195, 'n'), ('UZ', 'UZB', 'UZBEKISTAN', 196, 'n'), ('VC', 'VCT', 'SAINT VINCENT AND THE GRENADINES', 159, 'n'), ('VE', 'VEN', 'VENEZUELA', 198, 'n'), ('VN', 'VNM', 'VIETNAM', 199, 'n'), ('VU', 'VUT', 'VANUATU', 197, 'n'), ('YE', 'YEM', 'YEMEN', 201, 'n'), ('ZA', 'ZAF', 'SOUTH AFRICA', 171, 'n'), ('ZM', 'ZMB', 'ZAMBIA', 202, 'n'), ('ZW', 'ZWE', 'ZIMBABWE', 203, 'n'); ALTER TABLE `ma_DCountry` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `isoAlpha3` (`isoAlpha3`); COMMIT; CREATE TABLE `ma_DCountryState` ( `id` int(11) NOT NULL, `countryId` char(2) NOT NULL, `countryIsoAlpha3` char(3) NOT NULL, `abbreviation` char(2) DEFAULT NULL, `name` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `ma_DCountryState` (`id`, `countryId`, `countryIsoAlpha3`, `abbreviation`, `name`) VALUES (1, 'AD', 'AND', NULL, 'Parròquia d\'Andorra la Vella'), (2, 'AD', 'AND', NULL, 'Parròquia de Canillo'), (3, 'AD', 'AND', NULL, 'Parròquia de la Massana'), (4, 'AD', 'AND', NULL, 'Parròquia de Sant Julià de Lòria'), (5, 'AD', 'AND', NULL, 'Parròquia d\'Encamp'), (6, 'AD', 'AND', NULL, 'Parròquia d\'Escaldes-Engordany'), (7, 'AD', 'AND', NULL, 'Parròquia d\'Ordino'), (8, 'AE', 'ARE', NULL, '`Ajmān'), (9, 'AE', 'ARE', NULL, 'Abū Z̧aby'), (10, 'AE', 'ARE', NULL, 'Al Fujayrah'), (11, 'AE', 'ARE', NULL, 'Ash Shāriqah'), (12, 'AE', 'ARE', NULL, 'Dubayy'), (13, 'AE', 'ARE', NULL, 'Ra\'s al Khaymah'), (14, 'AE', 'ARE', NULL, 'Umm al Qaywayn'), (15, 'AF', 'AFG', NULL, 'Badakhshan'), (16, 'AF', 'AFG', NULL, 'Badghis Province'), (17, 'AF', 'AFG', NULL, 'Farah'), (18, 'AF', 'AFG', NULL, 'Faryab Province'), (19, 'AF', 'AFG', NULL, 'Herat Province'), (20, 'AF', 'AFG', NULL, 'Kabul'), (21, 'AF', 'AFG', NULL, 'Kunduz Province'), (22, 'AF', 'AFG', NULL, 'Orūzgān Province'), (23, 'AF', 'AFG', NULL, 'Paktia Province'), (24, 'AF', 'AFG', NULL, 'Velāyat-e [provisional] Khowst'), (25, 'AF', 'AFG', NULL, 'Velāyat-e [provisional] Nūrestān'), (26, 'AF', 'AFG', NULL, 'Velāyat-e Baghlān'), (27, 'AF', 'AFG', NULL, 'Velāyat-e Balkh'), (28, 'AF', 'AFG', NULL, 'Velāyat-e Bāmīān'), (29, 'AF', 'AFG', NULL, 'Velāyat-e Ghaznī'), (30, 'AF', 'AFG', NULL, 'Velāyat-e Ghowr'), (31, 'AF', 'AFG', NULL, 'Velāyat-e Helmand'), (32, 'AF', 'AFG', NULL, 'Velāyat-e Jowzjān'), (33, 'AF', 'AFG', NULL, 'Velāyat-e Kandahār'), (34, 'AF', 'AFG', NULL, 'Velāyat-e Kāpīsā'), (35, 'AF', 'AFG', NULL, 'Velāyat-e Konar'), (36, 'AF', 'AFG', NULL, 'Velāyat-e Laghmān'), (37, 'AF', 'AFG', NULL, 'Velāyat-e Lowgar'), (38, 'AF', 'AFG', NULL, 'Velāyat-e Nangarhār'), (39, 'AF', 'AFG', NULL, 'Velāyat-e Nīmrūz'), (40, 'AF', 'AFG', NULL, 'Velāyat-e Paktīkā'), (41, 'AF', 'AFG', NULL, 'Velāyat-e Parvān'), (42, 'AF', 'AFG', NULL, 'Velāyat-e Samangān'), (43, 'AF', 'AFG', NULL, 'Velāyat-e Sar-e Pol'), (44, 'AF', 'AFG', NULL, 'Velāyat-e Takhār'), (45, 'AF', 'AFG', NULL, 'Velāyat-e Vardak'), (46, 'AF', 'AFG', NULL, 'Zabul Province'), (47, 'AG', 'ATG', NULL, 'Barbuda'), (48, 'AG', 'ATG', NULL, 'Parish of Saint George'), (49, 'AG', 'ATG', NULL, 'Parish of Saint John'), (50, 'AG', 'ATG', NULL, 'Parish of Saint Mary'), (51, 'AG', 'ATG', NULL, 'Parish of Saint Paul'), (52, 'AG', 'ATG', NULL, 'Parish of Saint Peter'), (53, 'AG', 'ATG', NULL, 'Parish of Saint Philip'), (54, 'AL', 'ALB', NULL, 'Qarku i Beratit'), (55, 'AL', 'ALB', NULL, 'Qarku i Dibrës'), (56, 'AL', 'ALB', NULL, 'Qarku i Durrësit'), (57, 'AL', 'ALB', NULL, 'Qarku i Elbasanit'), (58, 'AL', 'ALB', NULL, 'Qarku i Fierit'), (59, 'AL', 'ALB', NULL, 'Qarku i Gjirokastrës'), (60, 'AL', 'ALB', NULL, 'Qarku i Korçës'), (61, 'AL', 'ALB', NULL, 'Qarku i Kukësit'), (62, 'AL', 'ALB', NULL, 'Qarku i Lezhës'), (63, 'AL', 'ALB', NULL, 'Qarku i Shkodrës'), (64, 'AL', 'ALB', NULL, 'Qarku i Tiranës'), (65, 'AL', 'ALB', NULL, 'Qarku i Vlorës'), (66, 'AM', 'ARM', NULL, 'Aragatsotni Marz'), (67, 'AM', 'ARM', NULL, 'Ararati Marz'), (68, 'AM', 'ARM', NULL, 'Armaviri Marz'), (69, 'AM', 'ARM', NULL, 'Geghark\'unik\'i Marz'), (70, 'AM', 'ARM', NULL, 'K\'aghak\' Yerevan'), (71, 'AM', 'ARM', NULL, 'Kotayk\'i Marz'), (72, 'AM', 'ARM', NULL, 'Lorru Marz'), (73, 'AM', 'ARM', NULL, 'Shiraki Marz'), (74, 'AM', 'ARM', NULL, 'Syunik\'i Marz'), (75, 'AM', 'ARM', NULL, 'Tavushi Marz'), (76, 'AM', 'ARM', NULL, 'Vayots\' Dzori Marz'), (77, 'AO', 'AGO', NULL, 'Província da Huíla'), (78, 'AO', 'AGO', NULL, 'Província da Lunda Norte'), (79, 'AO', 'AGO', NULL, 'Província da Lunda Sul'), (80, 'AO', 'AGO', NULL, 'Província de Benguela'), (81, 'AO', 'AGO', NULL, 'Província de Cabinda'), (82, 'AO', 'AGO', NULL, 'Província de Luanda'), (83, 'AO', 'AGO', NULL, 'Província de Malanje'), (84, 'AO', 'AGO', NULL, 'Província de Namibe'), (85, 'AO', 'AGO', NULL, 'Província do Bengo'), (86, 'AO', 'AGO', NULL, 'Província do Bié'), (87, 'AO', 'AGO', NULL, 'Província do Cuando Cubango'), (88, 'AO', 'AGO', NULL, 'Província do Cuanza Norte'), (89, 'AO', 'AGO', NULL, 'Província do Cuanza Sul'), (90, 'AO', 'AGO', NULL, 'Província do Cunene'), (91, 'AO', 'AGO', NULL, 'Província do Huambo'), (92, 'AO', 'AGO', NULL, 'Província do Moxico'), (93, 'AO', 'AGO', NULL, 'Província do Uíge'), (94, 'AO', 'AGO', NULL, 'Província do Zaire'), (95, 'AQ', 'ATA', NULL, 'Antarctica '), (96, 'AR', 'ARG', NULL, 'Distrito Federal'), (97, 'AR', 'ARG', NULL, 'Provincia de Buenos Aires'), (98, 'AR', 'ARG', NULL, 'Provincia de Catamarca'), (99, 'AR', 'ARG', NULL, 'Provincia de Córdoba'), (100, 'AR', 'ARG', NULL, 'Provincia de Corrientes'), (101, 'AR', 'ARG', NULL, 'Provincia de Entre Ríos'), (102, 'AR', 'ARG', NULL, 'Provincia de Formosa'), (103, 'AR', 'ARG', NULL, 'Provincia de Jujuy'), (104, 'AR', 'ARG', NULL, 'Provincia de La Pampa'), (105, 'AR', 'ARG', NULL, 'Provincia de La Rioja'), (106, 'AR', 'ARG', NULL, 'Provincia de Mendoza'), (107, 'AR', 'ARG', NULL, 'Provincia de Misiones'), (108, 'AR', 'ARG', NULL, 'Provincia de Río Negro'), (109, 'AR', 'ARG', NULL, 'Provincia de Salta'), (110, 'AR', 'ARG', NULL, 'Provincia de San Juan'), (111, 'AR', 'ARG', NULL, 'Provincia de San Luis'), (112, 'AR', 'ARG', NULL, 'Provincia de Santa Cruz'), (113, 'AR', 'ARG', NULL, 'Provincia de Santa Fe'), (114, 'AR', 'ARG', NULL, 'Provincia de Santiago del Estero'), (115, 'AR', 'ARG', NULL, 'Provincia de Tucumán'), (116, 'AR', 'ARG', NULL, 'Provincia del Chaco'), (117, 'AR', 'ARG', NULL, 'Provincia del Chubut'), (118, 'AR', 'ARG', NULL, 'Provincia del Neuquén'), (119, 'AT', 'AUT', NULL, 'Burgenland'), (120, 'AT', 'AUT', NULL, 'Carinthia'), (121, 'AT', 'AUT', NULL, 'Lower Austria'), (122, 'AT', 'AUT', NULL, 'Salzburg'), (123, 'AT', 'AUT', NULL, 'Styria'), (124, 'AT', 'AUT', NULL, 'Tyrol'), (125, 'AT', 'AUT', NULL, 'Upper Austria'), (126, 'AT', 'AUT', NULL, 'Vienna'), (127, 'AT', 'AUT', NULL, 'Vorarlberg'), (128, 'AU', 'AUS', NULL, 'Australian Capital Territory'), (129, 'AU', 'AUS', NULL, 'New South Wales'), (130, 'AU', 'AUS', NULL, 'Northern Territory'), (131, 'AU', 'AUS', NULL, 'Queensland'), (132, 'AU', 'AUS', NULL, 'South Australia'), (133, 'AU', 'AUS', NULL, 'Tasmania'), (134, 'AU', 'AUS', NULL, 'Victoria'), (135, 'AU', 'AUS', NULL, 'Western Australia'), (136, 'AW', 'ABW', NULL, 'Aruba '), (137, 'AZ', 'AZE', NULL, 'Abşeron Rayonu'), (138, 'AZ', 'AZE', NULL, 'Ağcabǝdi Rayonu'), (139, 'AZ', 'AZE', NULL, 'Ağdam Rayonu'), (140, 'AZ', 'AZE', NULL, 'Ağdaş Rayonu'), (141, 'AZ', 'AZE', NULL, 'Ağstafa Rayonu'), (142, 'AZ', 'AZE', NULL, 'Ağsu Rayonu'), (143, 'AZ', 'AZE', NULL, 'Astara Rayonu'), (144, 'AZ', 'AZE', NULL, 'Bakı Şähäri'), (145, 'AZ', 'AZE', NULL, 'Balakǝn Rayonu'), (146, 'AZ', 'AZE', NULL, 'Bǝrdǝ Rayonu'), (147, 'AZ', 'AZE', NULL, 'Beylǝqan Rayonu'), (148, 'AZ', 'AZE', NULL, 'Bilǝsuvar Rayonu'), (149, 'AZ', 'AZE', NULL, 'Cǝbrayıl Rayonu'), (150, 'AZ', 'AZE', NULL, 'Cǝlilabad Rayonu'), (151, 'AZ', 'AZE', NULL, 'Daşkǝsǝn Rayonu'), (152, 'AZ', 'AZE', NULL, 'Dǝvǝçi Rayonu'), (153, 'AZ', 'AZE', NULL, 'Əli Bayramlı Şǝhǝri'), (154, 'AZ', 'AZE', NULL, 'Füzuli Rayonu'), (155, 'AZ', 'AZE', NULL, 'Gǝdǝbǝy Rayonu'), (156, 'AZ', 'AZE', NULL, 'Gǝncǝ Şǝhǝri'), (157, 'AZ', 'AZE', NULL, 'Goranboy Rayonu'), (158, 'AZ', 'AZE', NULL, 'Göyçay Rayonu'), (159, 'AZ', 'AZE', NULL, 'Hacıqabul Rayonu'), (160, 'AZ', 'AZE', NULL, 'İmişli Rayonu'), (161, 'AZ', 'AZE', NULL, 'İsmayıllı Rayonu'), (162, 'AZ', 'AZE', NULL, 'Kǝlbǝcǝr Rayonu'), (163, 'AZ', 'AZE', NULL, 'Kürdǝmir Rayonu'), (164, 'AZ', 'AZE', NULL, 'Laçın Rayonu'), (165, 'AZ', 'AZE', NULL, 'Lǝnkǝran Rayonu'), (166, 'AZ', 'AZE', NULL, 'Lǝnkǝran Şǝhǝri'), (167, 'AZ', 'AZE', NULL, 'Lerik Rayonu'), (168, 'AZ', 'AZE', NULL, 'Masallı Rayonu'), (169, 'AZ', 'AZE', NULL, 'Mingǝcevir Şǝhǝri'), (170, 'AZ', 'AZE', NULL, 'Naftalan Şǝhǝri'), (171, 'AZ', 'AZE', NULL, 'Nakhichevan'), (172, 'AZ', 'AZE', NULL, 'Neftçala Rayonu'), (173, 'AZ', 'AZE', NULL, 'Oğuz Rayonu'), (174, 'AZ', 'AZE', NULL, 'Qax Rayonu'), (175, 'AZ', 'AZE', NULL, 'Qazax Rayonu'), (176, 'AZ', 'AZE', NULL, 'Qǝbǝlǝ Rayonu'), (177, 'AZ', 'AZE', NULL, 'Qobustan Rayonu'), (178, 'AZ', 'AZE', NULL, 'Quba Rayonu'), (179, 'AZ', 'AZE', NULL, 'Qubadlı Rayonu'), (180, 'AZ', 'AZE', NULL, 'Qusar Rayonu'), (181, 'AZ', 'AZE', NULL, 'Saatlı Rayonu'), (182, 'AZ', 'AZE', NULL, 'Sabirabad Rayonu'), (183, 'AZ', 'AZE', NULL, 'Salyan Rayonu'), (184, 'AZ', 'AZE', NULL, 'Şamaxı Rayonu'), (185, 'AZ', 'AZE', NULL, 'Samux Rayonu'), (186, 'AZ', 'AZE', NULL, 'Şǝki Rayonu'), (187, 'AZ', 'AZE', NULL, 'Şǝki Şǝhǝri'), (188, 'AZ', 'AZE', NULL, 'Şǝmkir Rayonu'), (189, 'AZ', 'AZE', NULL, 'Siyǝzǝn Rayonu'), (190, 'AZ', 'AZE', NULL, 'Sumqayıt Şǝhǝri'), (191, 'AZ', 'AZE', NULL, 'Şuşa Rayonu'), (192, 'AZ', 'AZE', NULL, 'Şuşa Şǝhǝri'), (193, 'AZ', 'AZE', NULL, 'Tǝrtǝr Rayonu'), (194, 'AZ', 'AZE', NULL, 'Tovuz Rayonu'), (195, 'AZ', 'AZE', NULL, 'Ucar Rayonu'), (196, 'AZ', 'AZE', NULL, 'Xaçmaz Rayonu'), (197, 'AZ', 'AZE', NULL, 'Xankǝndi Şǝhǝri'), (198, 'AZ', 'AZE', NULL, 'Xanlar Rayonu'), (199, 'AZ', 'AZE', NULL, 'Xızı Rayonu'), (200, 'AZ', 'AZE', NULL, 'Xocalı Rayonu'), (201, 'AZ', 'AZE', NULL, 'Xocavǝnd Rayonu'), (202, 'AZ', 'AZE', NULL, 'Yardımlı Rayonu'), (203, 'AZ', 'AZE', NULL, 'Yevlax Rayonu'), (204, 'AZ', 'AZE', NULL, 'Yevlax Şǝhǝri'), (205, 'AZ', 'AZE', NULL, 'Zaqatala Rayonu'), (206, 'AZ', 'AZE', NULL, 'Zǝngilan Rayonu'), (207, 'AZ', 'AZE', NULL, 'Zǝrdab Rayonu'), (208, 'BA', 'BIH', NULL, 'Federation of Bosnia and Herzegovina'), (209, 'BA', 'BIH', NULL, 'Republika Srpska'), (210, 'BB', 'BRB', NULL, 'Christ Church'), (211, 'BB', 'BRB', NULL, 'Saint Andrew'), (212, 'BB', 'BRB', NULL, 'Saint George'), (213, 'BB', 'BRB', NULL, 'Saint James'), (214, 'BB', 'BRB', NULL, 'Saint John'), (215, 'BB', 'BRB', NULL, 'Saint Joseph'), (216, 'BB', 'BRB', NULL, 'Saint Lucy'), (217, 'BB', 'BRB', NULL, 'Saint Michael'), (218, 'BB', 'BRB', NULL, 'Saint Peter'), (219, 'BB', 'BRB', NULL, 'Saint Philip'), (220, 'BB', 'BRB', NULL, 'Saint Thomas'), (221, 'BD', 'BGD', NULL, 'Borishal'), (222, 'BD', 'BGD', NULL, 'Chittagong'), (223, 'BD', 'BGD', NULL, 'Dhaka Division'), (224, 'BD', 'BGD', NULL, 'Khulna Division'), (225, 'BD', 'BGD', NULL, 'Rājshāhi Division'), (226, 'BD', 'BGD', NULL, 'Sylhet Division'), (227, 'BE', 'BEL', NULL, 'Flanders'), (228, 'BE', 'BEL', NULL, 'Région de Bruxelles-Capitale'), (229, 'BE', 'BEL', NULL, 'Wallonia'), (230, 'BF', 'BFA', NULL, 'Kadiogo'), (231, 'BF', 'BFA', NULL, 'Province d\' Oubritenga'), (232, 'BF', 'BFA', NULL, 'Province de l\' Oudalan'), (233, 'BF', 'BFA', NULL, 'Province de la Bougouriba'), (234, 'BF', 'BFA', NULL, 'Province de la Comoé'), (235, 'BF', 'BFA', NULL, 'Province de la Gnagna'), (236, 'BF', 'BFA', NULL, 'Province de la Komondjari'), (237, 'BF', 'BFA', NULL, 'Province de la Kompienga'), (238, 'BF', 'BFA', NULL, 'Province de la Kossi'), (239, 'BF', 'BFA', NULL, 'Province de la Léraba'), (240, 'BF', 'BFA', NULL, 'Province de la Sissili'), (241, 'BF', 'BFA', NULL, 'Province de la Tapoa'), (242, 'BF', 'BFA', NULL, 'Province des Balé'), (243, 'BF', 'BFA', NULL, 'Province des Banwa'), (244, 'BF', 'BFA', NULL, 'Province du Bam'), (245, 'BF', 'BFA', NULL, 'Province du Bazèga'), (246, 'BF', 'BFA', NULL, 'Province du Boulgou'), (247, 'BF', 'BFA', NULL, 'Province du Boulkiemdé'), (248, 'BF', 'BFA', NULL, 'Province du Ganzourgou'), (249, 'BF', 'BFA', NULL, 'Province du Gourma'), (250, 'BF', 'BFA', NULL, 'Province du Houet'), (251, 'BF', 'BFA', NULL, 'Province du Ioba'), (252, 'BF', 'BFA', NULL, 'Province du Kénédougou'), (253, 'BF', 'BFA', NULL, 'Province du Koulpélogo'), (254, 'BF', 'BFA', NULL, 'Province du Kouritenga'), (255, 'BF', 'BFA', NULL, 'Province du Kourwéogo'), (256, 'BF', 'BFA', NULL, 'Province du Loroum'), (257, 'BF', 'BFA', NULL, 'Province du Mouhoun'), (258, 'BF', 'BFA', NULL, 'Province du Nahouri'), (259, 'BF', 'BFA', NULL, 'Province du Namentenga'), (260, 'BF', 'BFA', NULL, 'Province du Nayala'), (261, 'BF', 'BFA', NULL, 'Province du Noumbiel'), (262, 'BF', 'BFA', NULL, 'Province du Passore'), (263, 'BF', 'BFA', NULL, 'Province du Poni'), (264, 'BF', 'BFA', NULL, 'Province du Sanguié'), (265, 'BF', 'BFA', NULL, 'Province du Sanmatenga'), (266, 'BF', 'BFA', NULL, 'Province du Séno'), (267, 'BF', 'BFA', NULL, 'Province du Soum'), (268, 'BF', 'BFA', NULL, 'Province du Sourou'), (269, 'BF', 'BFA', NULL, 'Province du Tuy'), (270, 'BF', 'BFA', NULL, 'Province du Yagha'), (271, 'BF', 'BFA', NULL, 'Province du Yatenga'), (272, 'BF', 'BFA', NULL, 'Province du Ziro'), (273, 'BF', 'BFA', NULL, 'Province du Zondoma'), (274, 'BF', 'BFA', NULL, 'Province du Zoundwéogo'), (275, 'BG', 'BGR', NULL, 'Oblast Blagoevgrad'), (276, 'BG', 'BGR', NULL, 'Oblast Burgas'), (277, 'BG', 'BGR', NULL, 'Oblast Dobrich'), (278, 'BG', 'BGR', NULL, 'Oblast Gabrovo'), (279, 'BG', 'BGR', NULL, 'Oblast Khaskovo'), (280, 'BG', 'BGR', NULL, 'Oblast Kŭrdzhali'), (281, 'BG', 'BGR', NULL, 'Oblast Kyustendil'), (282, 'BG', 'BGR', NULL, 'Oblast Lovech'), (283, 'BG', 'BGR', NULL, 'Oblast Montana'), (284, 'BG', 'BGR', NULL, 'Oblast Pazardzhik'), (285, 'BG', 'BGR', NULL, 'Oblast Pernik'), (286, 'BG', 'BGR', NULL, 'Oblast Pleven'), (287, 'BG', 'BGR', NULL, 'Oblast Plovdiv'), (288, 'BG', 'BGR', NULL, 'Oblast Razgrad'), (289, 'BG', 'BGR', NULL, 'Oblast Ruse'), (290, 'BG', 'BGR', NULL, 'Oblast Shumen'), (291, 'BG', 'BGR', NULL, 'Oblast Silistra'), (292, 'BG', 'BGR', NULL, 'Oblast Sliven'), (293, 'BG', 'BGR', NULL, 'Oblast Smolyan'), (294, 'BG', 'BGR', NULL, 'Oblast Sofiya'), (295, 'BG', 'BGR', NULL, 'Oblast Sofiya-Grad'), (296, 'BG', 'BGR', NULL, 'Oblast Stara Zagora'), (297, 'BG', 'BGR', NULL, 'Oblast Tŭrgovishte'), (298, 'BG', 'BGR', NULL, 'Oblast Varna'), (299, 'BG', 'BGR', NULL, 'Oblast Veliko Tŭrnovo'), (300, 'BG', 'BGR', NULL, 'Oblast Vidin'), (301, 'BG', 'BGR', NULL, 'Oblast Vratsa'), (302, 'BG', 'BGR', NULL, 'Oblast Yambol'), (303, 'BH', 'BHR', NULL, 'Ar Rifa’ and Southern Region'), (304, 'BH', 'BHR', NULL, 'Central Region'), (305, 'BH', 'BHR', NULL, 'Hamad town'), (306, 'BH', 'BHR', NULL, 'Hawar Islands'), (307, 'BH', 'BHR', NULL, 'Hedd'), (308, 'BH', 'BHR', NULL, 'Isa Town'), (309, 'BH', 'BHR', NULL, 'Jidd Haffs'), (310, 'BH', 'BHR', NULL, 'Manama'), (311, 'BH', 'BHR', NULL, 'Muharraq'), (312, 'BH', 'BHR', NULL, 'Northern Region'), (313, 'BH', 'BHR', NULL, 'Sitra'), (314, 'BH', 'BHR', NULL, 'Western Region'), (315, 'BI', 'BDI', NULL, 'iProvense ya Bubanza'), (316, 'BI', 'BDI', NULL, 'iProvense ya Bujumbura'), (317, 'BI', 'BDI', NULL, 'iProvense ya Bururi'), (318, 'BI', 'BDI', NULL, 'iProvense ya Cibitoke'), (319, 'BI', 'BDI', NULL, 'iProvense ya Gitega'), (320, 'BI', 'BDI', NULL, 'iProvense ya Karuzi'), (321, 'BI', 'BDI', NULL, 'iProvense ya Kayanza'), (322, 'BI', 'BDI', NULL, 'iProvense ya Kirundo'), (323, 'BI', 'BDI', NULL, 'iProvense ya Muramvya'), (324, 'BI', 'BDI', NULL, 'iProvense ya Muyinga'), (325, 'BI', 'BDI', NULL, 'iProvense ya Mwaro'), (326, 'BI', 'BDI', NULL, 'iProvense ya Rutana'), (327, 'BI', 'BDI', NULL, 'Province de Cankuzo'), (328, 'BI', 'BDI', NULL, 'Province de Makamba'), (329, 'BI', 'BDI', NULL, 'Province de Ngozi'), (330, 'BI', 'BDI', NULL, 'Province de Ruyigi'), (331, 'BJ', 'BEN', NULL, 'Département de l\' Alibori'), (332, 'BJ', 'BEN', NULL, 'Département de l\' Atakora'), (333, 'BJ', 'BEN', NULL, 'Département de l\' Atlantique'), (334, 'BJ', 'BEN', NULL, 'Département de l\' Ouémé'), (335, 'BJ', 'BEN', NULL, 'Département de la Donga'), (336, 'BJ', 'BEN', NULL, 'Département du Borgou'), (337, 'BJ', 'BEN', NULL, 'Département du Collines'), (338, 'BJ', 'BEN', NULL, 'Département du Kouffo'), (339, 'BJ', 'BEN', NULL, 'Département du Littoral'), (340, 'BJ', 'BEN', NULL, 'Département du Mono'), (341, 'BJ', 'BEN', NULL, 'Département du Plateau'), (342, 'BJ', 'BEN', NULL, 'Département du Zou'), (343, 'BM', 'BMU', NULL, 'Devonshire Parish'), (344, 'BM', 'BMU', NULL, 'Hamilton city'), (345, 'BM', 'BMU', NULL, 'Hamilton Parish'), (346, 'BM', 'BMU', NULL, 'Paget Parish'), (347, 'BM', 'BMU', NULL, 'Pembroke Parish'), (348, 'BM', 'BMU', NULL, 'Saint George'), (349, 'BM', 'BMU', NULL, 'Saint George\'s Parish'), (350, 'BM', 'BMU', NULL, 'Sandys Parish'), (351, 'BM', 'BMU', NULL, 'Smith\'s Parish'), (352, 'BM', 'BMU', NULL, 'Southampton Parish'), (353, 'BM', 'BMU', NULL, 'Warwick Parish'), (354, 'BN', 'BRN', NULL, 'Belait District'), (355, 'BN', 'BRN', NULL, 'Brunei and Muara District'), (356, 'BN', 'BRN', NULL, 'Temburong District'), (357, 'BN', 'BRN', NULL, 'Tutong District'), (358, 'BO', 'BOL', NULL, 'Departamento de Chuquisaca'), (359, 'BO', 'BOL', NULL, 'Departamento de Cochabamba'), (360, 'BO', 'BOL', NULL, 'Departamento de La Paz'), (361, 'BO', 'BOL', NULL, 'Departamento de Oruro'), (362, 'BO', 'BOL', NULL, 'Departamento de Pando'), (363, 'BO', 'BOL', NULL, 'Departamento de Potosí'), (364, 'BO', 'BOL', NULL, 'Departamento de Santa Cruz'), (365, 'BO', 'BOL', NULL, 'Departamento de Tarija'), (366, 'BO', 'BOL', NULL, 'Departamento del Beni'), (367, 'BR', 'BRA', NULL, 'Distrito Federal'), (368, 'BR', 'BRA', NULL, 'Estado da Bahia'), (369, 'BR', 'BRA', NULL, 'Estado da Paraíba'), (370, 'BR', 'BRA', NULL, 'Estado de Alagoas'), (371, 'BR', 'BRA', NULL, 'Estado de Espírito Santo'), (372, 'BR', 'BRA', NULL, 'Estado de Goiás'), (373, 'BR', 'BRA', NULL, 'Estado de Mato Grosso'), (374, 'BR', 'BRA', NULL, 'Estado de Mato Grosso do Sul'), (375, 'BR', 'BRA', NULL, 'Estado de Minas Gerais'), (376, 'BR', 'BRA', NULL, 'Estado de Pernambuco'), (377, 'BR', 'BRA', NULL, 'Estado de Rondônia'), (378, 'BR', 'BRA', NULL, 'Estado de Roraima'), (379, 'BR', 'BRA', NULL, 'Estado de Santa Catarina'), (380, 'BR', 'BRA', NULL, 'Estado de São Paulo'), (381, 'BR', 'BRA', NULL, 'Estado de Sergipe'), (382, 'BR', 'BRA', NULL, 'Estado de Tocantins'), (383, 'BR', 'BRA', NULL, 'Estado do Acre'), (384, 'BR', 'BRA', NULL, 'Estado do Amapá'), (385, 'BR', 'BRA', NULL, 'Estado do Amazonas'), (386, 'BR', 'BRA', NULL, 'Estado do Ceará'), (387, 'BR', 'BRA', NULL, 'Estado do Maranhão'), (388, 'BR', 'BRA', NULL, 'Estado do Pará'), (389, 'BR', 'BRA', NULL, 'Estado do Parana'), (390, 'BR', 'BRA', NULL, 'Estado do Piauí'), (391, 'BR', 'BRA', NULL, 'Estado do Rio de Janeiro'), (392, 'BR', 'BRA', NULL, 'Estado do Rio Grande do Norte'), (393, 'BR', 'BRA', NULL, 'Estado do Rio Grande do Sul'), (394, 'BS', 'BHS', NULL, 'Acklins and Crooked Islands District'), (395, 'BS', 'BHS', NULL, 'Bimini District'), (396, 'BS', 'BHS', NULL, 'Cat Island District'), (397, 'BS', 'BHS', NULL, 'Exuma District'), (398, 'BS', 'BHS', NULL, 'Freeport District'), (399, 'BS', 'BHS', NULL, 'Fresh Creek District'), (400, 'BS', 'BHS', NULL, 'Governor\'s Harbour District'), (401, 'BS', 'BHS', NULL, 'Green Turtle Cay District'), (402, 'BS', 'BHS', NULL, 'Harbour Island District'), (403, 'BS', 'BHS', NULL, 'High Rock District'), (404, 'BS', 'BHS', NULL, 'Inagua District'), (405, 'BS', 'BHS', NULL, 'Kemps Bay District'), (406, 'BS', 'BHS', NULL, 'Long Island District'), (407, 'BS', 'BHS', NULL, 'Marsh Harbour District'), (408, 'BS', 'BHS', NULL, 'Mayaguana District'), (409, 'BS', 'BHS', NULL, 'New Providence District'), (410, 'BS', 'BHS', NULL, 'Nichollstown and Berry Islands District'), (411, 'BS', 'BHS', NULL, 'Ragged Island District'), (412, 'BS', 'BHS', NULL, 'Rock Sound District'), (413, 'BS', 'BHS', NULL, 'San Salvador and Rum Cay District'), (414, 'BS', 'BHS', NULL, 'Sandy Point District'), (415, 'BT', 'BTN', NULL, 'Bumthang Dzongkhag'), (416, 'BT', 'BTN', NULL, 'Chhukha Dzongkhag'), (417, 'BT', 'BTN', NULL, 'Chirang Dzongkhag'), (418, 'BT', 'BTN', NULL, 'Daga Dzongkhag'), (419, 'BT', 'BTN', NULL, 'Gasa District'), (420, 'BT', 'BTN', NULL, 'Geylegphug Dzongkhag'), (421, 'BT', 'BTN', NULL, 'Ha Dzongkhag'), (422, 'BT', 'BTN', NULL, 'Lhuntshi Dzongkhag'), (423, 'BT', 'BTN', NULL, 'Mongar Dzongkhag'), (424, 'BT', 'BTN', NULL, 'Paro District'), (425, 'BT', 'BTN', NULL, 'Pemagatsel Dzongkhag'), (426, 'BT', 'BTN', NULL, 'Punakha Dzongkhag'), (427, 'BT', 'BTN', NULL, 'Samchi Dzongkhag'), (428, 'BT', 'BTN', NULL, 'Samdrup Jongkhar District'), (429, 'BT', 'BTN', NULL, 'Shemgang Dzongkhag'), (430, 'BT', 'BTN', NULL, 'Tashigang Dzongkhag'), (431, 'BT', 'BTN', NULL, 'Thimphu Dzongkhag'), (432, 'BT', 'BTN', NULL, 'Tongsa Dzongkhag'), (433, 'BT', 'BTN', NULL, 'Wangdi Phodrang Dzongkhag'), (434, 'BW', 'BWA', NULL, 'Central District'), (435, 'BW', 'BWA', NULL, 'Chobe District'), (436, 'BW', 'BWA', NULL, 'Ghanzi District'), (437, 'BW', 'BWA', NULL, 'Kgalagadi District'), (438, 'BW', 'BWA', NULL, 'Kgatleng District'), (439, 'BW', 'BWA', NULL, 'Kweneng District'), (440, 'BW', 'BWA', NULL, 'North East District'), (441, 'BW', 'BWA', NULL, 'North West District'), (442, 'BW', 'BWA', NULL, 'South East District'), (443, 'BW', 'BWA', NULL, 'Southern District'), (444, 'BY', 'BLR', NULL, 'Brestskaya Voblasts\''), (445, 'BY', 'BLR', NULL, 'Homyel\'skaya Voblasts\''), (446, 'BY', 'BLR', NULL, 'Horad Minsk'), (447, 'BY', 'BLR', NULL, 'Hrodzyenskaya Voblasts\''), (448, 'BY', 'BLR', NULL, 'Mahilyowskaya Voblasts\''), (449, 'BY', 'BLR', NULL, 'Minskaya Voblasts\''), (450, 'BY', 'BLR', NULL, 'Vitsyebskaya Voblasts\''), (451, 'BZ', 'BLZ', NULL, 'Belize District'), (452, 'BZ', 'BLZ', NULL, 'Cayo District'), (453, 'BZ', 'BLZ', NULL, 'Corozal District'), (454, 'BZ', 'BLZ', NULL, 'Orange Walk District'), (455, 'BZ', 'BLZ', NULL, 'Stann Creek District'), (456, 'BZ', 'BLZ', NULL, 'Toledo District'), (457, 'CA', 'CAN', 'AB', 'Alberta'), (458, 'CA', 'CAN', 'BC', 'British Columbia'), (459, 'CA', 'CAN', 'MB', 'Manitoba'), (460, 'CA', 'CAN', 'NB', 'New Brunswick'), (461, 'CA', 'CAN', 'NL', 'Newfoundland and Labrador'), (462, 'CA', 'CAN', 'NT', 'Northwest Territories'), (463, 'CA', 'CAN', 'NS', 'Nova Scotia'), (464, 'CA', 'CAN', 'NU', 'Nunavut Territory'), (465, 'CA', 'CAN', 'ON', 'Ontario'), (466, 'CA', 'CAN', 'PE', 'Prince Edward Island'), (467, 'CA', 'CAN', 'QC', 'Quebec'), (468, 'CA', 'CAN', 'SK', 'Saskatchewan'), (469, 'CA', 'CAN', 'YT', 'Yukon Territory'), (470, 'CD', 'COD', NULL, 'Kivu Région du'), (471, 'CD', 'COD', NULL, 'Province de Bandundu'), (472, 'CD', 'COD', NULL, 'Province de l\' Équateur'), (473, 'CD', 'COD', NULL, 'Province du Bas-Congo'), (474, 'CD', 'COD', NULL, 'Province du Kasaï-Occidental'), (475, 'CD', 'COD', NULL, 'Province du Kasaï-Oriental'), (476, 'CD', 'COD', NULL, 'Province du Katanga'), (477, 'CD', 'COD', NULL, 'Province du Maniema'), (478, 'CD', 'COD', NULL, 'Province du Nord-Kivu'), (479, 'CD', 'COD', NULL, 'Province du Sud-Kivu'), (480, 'CD', 'COD', NULL, 'Province Orientale'), (481, 'CD', 'COD', NULL, 'Ville de Kinshasa'), (482, 'CF', 'CAF', NULL, 'Commune de Bangui'), (483, 'CF', 'CAF', NULL, 'Préfecture de l\' Ombella-Mpoko'), (484, 'CF', 'CAF', NULL, 'Préfecture de l\' Ouham'), (485, 'CF', 'CAF', NULL, 'Préfecture de l\' Ouham-Pendé'), (486, 'CF', 'CAF', NULL, 'Préfecture de la Bamingui-Bangoran'), (487, 'CF', 'CAF', NULL, 'Préfecture de la Basse-Kotto'), (488, 'CF', 'CAF', NULL, 'Préfecture de la Haute-Kotto'), (489, 'CF', 'CAF', NULL, 'Préfecture de la Kémo'), (490, 'CF', 'CAF', NULL, 'Préfecture de la Lobaye'), (491, 'CF', 'CAF', NULL, 'Préfecture de la Mambéré-Kadéï'), (492, 'CF', 'CAF', NULL, 'Préfecture de la Nana-Grébizi'), (493, 'CF', 'CAF', NULL, 'Préfecture de la Nana-Mambéré'), (494, 'CF', 'CAF', NULL, 'Préfecture de la Ouaka'), (495, 'CF', 'CAF', NULL, 'Préfecture de la Sangha-Mbaéré'), (496, 'CF', 'CAF', NULL, 'Préfecture de la Vakaga'), (497, 'CF', 'CAF', NULL, 'Préfecture du Haut-Mbomou'), (498, 'CF', 'CAF', NULL, 'Préfecture du Mbomou'), (499, 'CG', 'COG', NULL, 'Commune de Brazzaville'), (500, 'CG', 'COG', NULL, 'Région de la Bouenza'), (501, 'CG', 'COG', NULL, 'Région de la Cuvette'), (502, 'CG', 'COG', NULL, 'Région de la Cuvette-Ouest'), (503, 'CG', 'COG', NULL, 'Région de la Lékoumou'), (504, 'CG', 'COG', NULL, 'Région de la Likouala'), (505, 'CG', 'COG', NULL, 'Région de la Sangha'), (506, 'CG', 'COG', NULL, 'Région des Plateaux'), (507, 'CG', 'COG', NULL, 'Région du Kouilou'), (508, 'CG', 'COG', NULL, 'Région du Niari'), (509, 'CG', 'COG', NULL, 'Région du Pool'), (510, 'CH', 'CHE', NULL, 'Canton de Fribourg'), (511, 'CH', 'CHE', NULL, 'Canton de Genève'), (512, 'CH', 'CHE', NULL, 'Canton de Neuchâtel'), (513, 'CH', 'CHE', NULL, 'Canton de Vaud'), (514, 'CH', 'CHE', NULL, 'Canton du Jura'), (515, 'CH', 'CHE', NULL, 'Canton du Valais'), (516, 'CH', 'CHE', NULL, 'Cantone Ticino'), (517, 'CH', 'CHE', NULL, 'Kanton Aargau'), (518, 'CH', 'CHE', NULL, 'Kanton Appenzell Ausserrhoden'), (519, 'CH', 'CHE', NULL, 'Kanton Appenzell Innerrhoden'), (520, 'CH', 'CHE', NULL, 'Kanton Basel-Landschaft'), (521, 'CH', 'CHE', NULL, 'Kanton Basel-Stadt'), (522, 'CH', 'CHE', NULL, 'Kanton Bern'), (523, 'CH', 'CHE', NULL, 'Kanton Glarus'), (524, 'CH', 'CHE', NULL, 'Kanton Graubünden'), (525, 'CH', 'CHE', NULL, 'Kanton Luzern'), (526, 'CH', 'CHE', NULL, 'Kanton Nidwalden'), (527, 'CH', 'CHE', NULL, 'Kanton Obwalden'), (528, 'CH', 'CHE', NULL, 'Kanton Schaffhausen'), (529, 'CH', 'CHE', NULL, 'Kanton Schwyz'), (530, 'CH', 'CHE', NULL, 'Kanton Solothurn'), (531, 'CH', 'CHE', NULL, 'Kanton St. Gallen'), (532, 'CH', 'CHE', NULL, 'Kanton Thurgau'), (533, 'CH', 'CHE', NULL, 'Kanton Uri'), (534, 'CH', 'CHE', NULL, 'Kanton Zürich'), (535, 'CH', 'CHE', NULL, 'Kanton Zug'), (536, 'CI', 'CIV', NULL, 'Région de l\' Agnéby'), (537, 'CI', 'CIV', NULL, 'Région de la Marahoué'), (538, 'CI', 'CIV', NULL, 'Région de la Vallée du Bandama'), (539, 'CI', 'CIV', NULL, 'Région des Dix-Huit Montagnes'), (540, 'CI', 'CIV', NULL, 'Région des Lacs'), (541, 'CI', 'CIV', NULL, 'Région des Lagunes'), (542, 'CI', 'CIV', NULL, 'Région des Savanes'), (543, 'CI', 'CIV', NULL, 'Région du Bafing'), (544, 'CI', 'CIV', NULL, 'Région du Bas-Sassandra'), (545, 'CI', 'CIV', NULL, 'Région du Denguélé'), (546, 'CI', 'CIV', NULL, 'Région du Fromager'), (547, 'CI', 'CIV', NULL, 'Région du Haut-Sassandra'), (548, 'CI', 'CIV', NULL, 'Région du Moyen-Cavally'), (549, 'CI', 'CIV', NULL, 'Région du Moyen-Comoé'), (550, 'CI', 'CIV', NULL, 'Région du N\'zi-Comoé'), (551, 'CI', 'CIV', NULL, 'Région du Sud-Bandama'), (552, 'CI', 'CIV', NULL, 'Région du Sud-Comoé'), (553, 'CI', 'CIV', NULL, 'Région du Worodougou'), (554, 'CI', 'CIV', NULL, 'Région du Zanzan'), (555, 'CL', 'CHL', NULL, 'Región Aisén del General Carlos Ibáñez del Campo'), (556, 'CL', 'CHL', NULL, 'Región de Antofagasta'), (557, 'CL', 'CHL', NULL, 'Región de Arica y Parinacota'), (558, 'CL', 'CHL', NULL, 'Región de Atacama'), (559, 'CL', 'CHL', NULL, 'Región de Coquimbo'), (560, 'CL', 'CHL', NULL, 'Región de la Araucanía'), (561, 'CL', 'CHL', NULL, 'Región de Los Lagos'), (562, 'CL', 'CHL', NULL, 'Región de Los Ríos'), (563, 'CL', 'CHL', NULL, 'Región de Magallanes y de la Antártica Chilena'), (564, 'CL', 'CHL', NULL, 'Región de Tarapacá'), (565, 'CL', 'CHL', NULL, 'Región de Valparaíso'), (566, 'CL', 'CHL', NULL, 'Región del Biobío'), (567, 'CL', 'CHL', NULL, 'Región del Libertador General Bernardo O\'Higgins'), (568, 'CL', 'CHL', NULL, 'Región del Maule'), (569, 'CL', 'CHL', NULL, 'Región Metropolitana de Santiago'), (570, 'CM', 'CMR', NULL, 'Adamaoua Province'), (571, 'CM', 'CMR', NULL, 'Centre Province'), (572, 'CM', 'CMR', NULL, 'East Province'), (573, 'CM', 'CMR', NULL, 'Far North Province'), (574, 'CM', 'CMR', NULL, 'Littoral Province'), (575, 'CM', 'CMR', NULL, 'North Province'), (576, 'CM', 'CMR', NULL, 'North-West Province'), (577, 'CM', 'CMR', NULL, 'South Province'), (578, 'CM', 'CMR', NULL, 'South-West Province'), (579, 'CM', 'CMR', NULL, 'West Province'), (580, 'CN', 'CHN', NULL, 'Anhui Sheng'), (581, 'CN', 'CHN', NULL, 'Beijing Shi'), (582, 'CN', 'CHN', NULL, 'Chongqing Shi'), (583, 'CN', 'CHN', NULL, 'Fujian'), (584, 'CN', 'CHN', NULL, 'Gansu Sheng'), (585, 'CN', 'CHN', NULL, 'Guangdong Sheng'), (586, 'CN', 'CHN', NULL, 'Guangxi Zhuangzu Zizhiqu'), (587, 'CN', 'CHN', NULL, 'Guizhou Sheng'), (588, 'CN', 'CHN', NULL, 'Hainan Province'), (589, 'CN', 'CHN', NULL, 'Hebei Sheng'), (590, 'CN', 'CHN', NULL, 'Heilongjiang Sheng'), (591, 'CN', 'CHN', NULL, 'Henan Sheng'), (592, 'CN', 'CHN', NULL, 'Hubei'), (593, 'CN', 'CHN', NULL, 'Hunan Province'), (594, 'CN', 'CHN', NULL, 'Inner Mongolia Autonomous Region'), (595, 'CN', 'CHN', NULL, 'Jiangsu Sheng'), (596, 'CN', 'CHN', NULL, 'Jiangxi Sheng'), (597, 'CN', 'CHN', NULL, 'Jilin Sheng'), (598, 'CN', 'CHN', NULL, 'Liaoning Province'), (599, 'CN', 'CHN', NULL, 'Ningxia Huizu Zizhiqu'), (600, 'CN', 'CHN', NULL, 'Qinghai Sheng'), (601, 'CN', 'CHN', NULL, 'Shaanxi Sheng'), (602, 'CN', 'CHN', NULL, 'Shandong Sheng'), (603, 'CN', 'CHN', NULL, 'Shanghai Shi'), (604, 'CN', 'CHN', NULL, 'Shanxi Sheng'), (605, 'CN', 'CHN', NULL, 'Sichuan Sheng'), (606, 'CN', 'CHN', NULL, 'Tianjin Shi'), (607, 'CN', 'CHN', NULL, 'Tibet Autonomous Region'), (608, 'CN', 'CHN', NULL, 'Xinjiang Uygur Zizhiqu'), (609, 'CN', 'CHN', NULL, 'Yunnan Province'), (610, 'CN', 'CHN', NULL, 'Zhejiang Sheng'), (611, 'CO', 'COL', NULL, 'Atlántico'), (612, 'CO', 'COL', NULL, 'Bogota D.C.'), (613, 'CO', 'COL', NULL, 'Cundinamarca'), (614, 'CO', 'COL', NULL, 'Departamento de Antioquia'), (615, 'CO', 'COL', NULL, 'Departamento de Arauca'), (616, 'CO', 'COL', NULL, 'Departamento de Bolívar'), (617, 'CO', 'COL', NULL, 'Departamento de Boyacá'), (618, 'CO', 'COL', NULL, 'Departamento de Caldas'), (619, 'CO', 'COL', NULL, 'Departamento de Casanare'), (620, 'CO', 'COL', NULL, 'Departamento de Córdoba'), (621, 'CO', 'COL', NULL, 'Departamento de La Guajira'), (622, 'CO', 'COL', NULL, 'Departamento de Nariño'), (623, 'CO', 'COL', NULL, 'Departamento de Norte de Santander'), (624, 'CO', 'COL', NULL, 'Departamento de Risaralda'), (625, 'CO', 'COL', NULL, 'Departamento de Santander'), (626, 'CO', 'COL', NULL, 'Departamento de Sucre'), (627, 'CO', 'COL', NULL, 'Departamento de Tolima'), (628, 'CO', 'COL', NULL, 'Departamento del Amazonas'), (629, 'CO', 'COL', NULL, 'Departamento del Caquetá'), (630, 'CO', 'COL', NULL, 'Departamento del Cauca'), (631, 'CO', 'COL', NULL, 'Departamento del Cesar'), (632, 'CO', 'COL', NULL, 'Departamento del Chocó'), (633, 'CO', 'COL', NULL, 'Departamento del Guainía'), (634, 'CO', 'COL', NULL, 'Departamento del Guaviare'), (635, 'CO', 'COL', NULL, 'Departamento del Huila'), (636, 'CO', 'COL', NULL, 'Departamento del Magdalena'), (637, 'CO', 'COL', NULL, 'Departamento del Meta'), (638, 'CO', 'COL', NULL, 'Departamento del Putumayo'), (639, 'CO', 'COL', NULL, 'Departamento del Quindío'), (640, 'CO', 'COL', NULL, 'Departamento del Valle del Cauca'), (641, 'CO', 'COL', NULL, 'Departamento del Vaupés'), (642, 'CO', 'COL', NULL, 'Departamento del Vichada'), (643, 'CR', 'CRI', NULL, 'Provincia de Alajuela'), (644, 'CR', 'CRI', NULL, 'Provincia de Cartago'), (645, 'CR', 'CRI', NULL, 'Provincia de Guanacaste'), (646, 'CR', 'CRI', NULL, 'Provincia de Heredia'), (647, 'CR', 'CRI', NULL, 'Provincia de Limón'), (648, 'CR', 'CRI', NULL, 'Provincia de Puntarenas'), (649, 'CR', 'CRI', NULL, 'Provincia de San José'), (650, 'CU', 'CUB', NULL, 'Municipio Especial Isla de la Juventud'), (651, 'CU', 'CUB', NULL, 'Provincia de Camagüey'), (652, 'CU', 'CUB', NULL, 'Provincia de Ciego de Ávila'), (653, 'CU', 'CUB', NULL, 'Provincia de Cienfuegos'), (654, 'CU', 'CUB', NULL, 'Provincia de Ciudad de La Habana'), (655, 'CU', 'CUB', NULL, 'Provincia de Guantánamo'), (656, 'CU', 'CUB', NULL, 'Provincia de Holguín'), (657, 'CU', 'CUB', NULL, 'Provincia de La Habana'), (658, 'CU', 'CUB', NULL, 'Provincia de Matanzas'), (659, 'CU', 'CUB', NULL, 'Provincia de Pinar del Río'), (660, 'CU', 'CUB', NULL, 'Provincia de Sancti Spíritus'), (661, 'CU', 'CUB', NULL, 'Provincia de Santiago de Cuba'), (662, 'CU', 'CUB', NULL, 'Provincia de Villa Clara'), (663, 'CU', 'CUB', NULL, 'Provincia Granma'), (664, 'CU', 'CUB', NULL, 'pueto padre'), (665, 'CV', 'CPV', NULL, 'Concelho da Boa Vista'), (666, 'CV', 'CPV', NULL, 'Concelho da Brava'), (667, 'CV', 'CPV', NULL, 'Concelho da Praia'), (668, 'CV', 'CPV', NULL, 'Concelho da Ribeira Grande'), (669, 'CV', 'CPV', NULL, 'Concelho de Santa Catarina'), (670, 'CV', 'CPV', NULL, 'Concelho de Santa Cruz'), (671, 'CV', 'CPV', NULL, 'Concelho de São Domingos'), (672, 'CV', 'CPV', NULL, 'Concelho de São Filipe'), (673, 'CV', 'CPV', NULL, 'Concelho de São Miguel'), (674, 'CV', 'CPV', NULL, 'Concelho de São Nicolau'), (675, 'CV', 'CPV', NULL, 'Concelho de São Vicente'), (676, 'CV', 'CPV', NULL, 'Concelho do Maio'), (677, 'CV', 'CPV', NULL, 'Concelho do Paul'), (678, 'CV', 'CPV', NULL, 'Concelho do Sal'), (679, 'CV', 'CPV', NULL, 'Concelho do Tarrafal'), (680, 'CV', 'CPV', NULL, 'Concelho dos Mosteiros'), (681, 'CY', 'CYP', NULL, 'Famagusta District'), (682, 'CY', 'CYP', NULL, 'Kyrenia District'), (683, 'CY', 'CYP', NULL, 'Larnaca District'), (684, 'CY', 'CYP', NULL, 'Limassol District'), (685, 'CY', 'CYP', NULL, 'Nicosia District'), (686, 'CY', 'CYP', NULL, 'Paphos District'), (687, 'CZ', 'CZE', NULL, 'Hlavní město Praha'), (688, 'CZ', 'CZE', NULL, 'Jihočeský Kraj'), (689, 'CZ', 'CZE', NULL, 'Karlovarský kraj'), (690, 'CZ', 'CZE', NULL, 'Kraj Vysočina'), (691, 'CZ', 'CZE', NULL, 'Královéhradecký kraj'), (692, 'CZ', 'CZE', NULL, 'Liberecký kraj'), (693, 'CZ', 'CZE', NULL, 'Moravskoslezský kraj'), (694, 'CZ', 'CZE', NULL, 'Olomoucký kraj'), (695, 'CZ', 'CZE', NULL, 'Pardubický kraj'), (696, 'CZ', 'CZE', NULL, 'Plzeňský kraj'), (697, 'CZ', 'CZE', NULL, 'South Moravian Region'), (698, 'CZ', 'CZE', NULL, 'Středočeský kraj'), (699, 'CZ', 'CZE', NULL, 'Ústecký kraj'), (700, 'CZ', 'CZE', NULL, 'Zlínský kraj'), (701, 'DE', 'DEU', NULL, 'Baden-Württemberg'), (702, 'DE', 'DEU', NULL, 'Bavaria'), (703, 'DE', 'DEU', NULL, 'Brandenburg'), (704, 'DE', 'DEU', NULL, 'Hamburg'), (705, 'DE', 'DEU', NULL, 'Hesse'), (706, 'DE', 'DEU', NULL, 'Land Berlin'), (707, 'DE', 'DEU', NULL, 'Land Bremen'), (708, 'DE', 'DEU', NULL, 'Lower Saxony'), (709, 'DE', 'DEU', NULL, 'Mecklenburg-Vorpommern'), (710, 'DE', 'DEU', NULL, 'North Rhine-Westphalia'), (711, 'DE', 'DEU', NULL, 'Rhineland-Palatinate'), (712, 'DE', 'DEU', NULL, 'Saarland'), (713, 'DE', 'DEU', NULL, 'Saxony'), (714, 'DE', 'DEU', NULL, 'Saxony-Anhalt'), (715, 'DE', 'DEU', NULL, 'Schleswig-Holstein'), (716, 'DE', 'DEU', NULL, 'Thuringia'), (717, 'DJ', 'DJI', NULL, 'Région d\' Ali Sabieh'), (718, 'DJ', 'DJI', NULL, 'Région d\' Arta'), (719, 'DJ', 'DJI', NULL, 'Région d\' Obock'), (720, 'DJ', 'DJI', NULL, 'Région de Dikhil'), (721, 'DJ', 'DJI', NULL, 'Région de Tadjourah'), (722, 'DJ', 'DJI', NULL, 'Ville de Djibouti'), (723, 'DK', 'DNK', NULL, 'Capital Region'), (724, 'DK', 'DNK', NULL, 'Central Jutland'), (725, 'DK', 'DNK', NULL, 'North Jutland'), (726, 'DK', 'DNK', NULL, 'South Denmark'), (727, 'DK', 'DNK', NULL, 'Zealand'), (728, 'DM', 'DMA', NULL, 'Saint Andrew'), (729, 'DM', 'DMA', NULL, 'Saint David'), (730, 'DM', 'DMA', NULL, 'Saint George'), (731, 'DM', 'DMA', NULL, 'Saint John'), (732, 'DM', 'DMA', NULL, 'Saint Joseph'), (733, 'DM', 'DMA', NULL, 'Saint Luke'), (734, 'DM', 'DMA', NULL, 'Saint Mark'), (735, 'DM', 'DMA', NULL, 'Saint Patrick'), (736, 'DM', 'DMA', NULL, 'Saint Paul'), (737, 'DM', 'DMA', NULL, 'Saint Peter'), (738, 'DO', 'DOM', NULL, 'Distrito Nacional'), (739, 'DO', 'DOM', NULL, 'Provincia de Azua'), (740, 'DO', 'DOM', NULL, 'Provincia de Baoruco'), (741, 'DO', 'DOM', NULL, 'Provincia de Barahona'), (742, 'DO', 'DOM', NULL, 'Provincia de Dajabón'), (743, 'DO', 'DOM', NULL, 'Provincia de El Seíbo'), (744, 'DO', 'DOM', NULL, 'Provincia de Elías Piña'), (745, 'DO', 'DOM', NULL, 'Provincia de Hato Mayor'), (746, 'DO', 'DOM', NULL, 'Provincia de Independencia'), (747, 'DO', 'DOM', NULL, 'Provincia de La Altagracia'), (748, 'DO', 'DOM', NULL, 'Provincia de La Romana'), (749, 'DO', 'DOM', NULL, 'Provincia de La Vega'), (750, 'DO', 'DOM', NULL, 'Provincia de Monseñor Nouel'), (751, 'DO', 'DOM', NULL, 'Provincia de Monte Cristi'), (752, 'DO', 'DOM', NULL, 'Provincia de Monte Plata'), (753, 'DO', 'DOM', NULL, 'Provincia de Pedernales'), (754, 'DO', 'DOM', NULL, 'Provincia de Peravia'), (755, 'DO', 'DOM', NULL, 'Provincia de Puerto Plata'), (756, 'DO', 'DOM', NULL, 'Provincia de Salcedo'), (757, 'DO', 'DOM', NULL, 'Provincia de Samaná'), (758, 'DO', 'DOM', NULL, 'Provincia de San Cristóbal'), (759, 'DO', 'DOM', NULL, 'Provincia de San José de Ocoa'), (760, 'DO', 'DOM', NULL, 'Provincia de San Juan'), (761, 'DO', 'DOM', NULL, 'Provincia de San Pedro de Macorís'), (762, 'DO', 'DOM', NULL, 'Provincia de Santiago'), (763, 'DO', 'DOM', NULL, 'Provincia de Santiago Rodríguez'), (764, 'DO', 'DOM', NULL, 'Provincia de Santo Domingo'), (765, 'DO', 'DOM', NULL, 'Provincia de Valverde'), (766, 'DO', 'DOM', NULL, 'Provincia Duarte'), (767, 'DO', 'DOM', NULL, 'Provincia Espaillat'), (768, 'DO', 'DOM', NULL, 'Provincia María Trinidad Sánchez'), (769, 'DO', 'DOM', NULL, 'Provincia Sánchez Ramírez'), (770, 'DZ', 'DZA', NULL, 'Wilaya d\' Adrar'), (771, 'DZ', 'DZA', NULL, 'Wilaya d\' Alger'), (772, 'DZ', 'DZA', NULL, 'Wilaya d\' Annaba'), (773, 'DZ', 'DZA', NULL, 'Wilaya d\' El Bayadh'), (774, 'DZ', 'DZA', NULL, 'Wilaya d\' El Oued'), (775, 'DZ', 'DZA', NULL, 'Wilaya d\' El Tarf'), (776, 'DZ', 'DZA', NULL, 'Wilaya d\' Illizi'), (777, 'DZ', 'DZA', NULL, 'Wilaya d\' Oran'), (778, 'DZ', 'DZA', NULL, 'Wilaya d\' Oum el Bouaghi'), (779, 'DZ', 'DZA', NULL, 'Wilaya de Aïn Defla'), (780, 'DZ', 'DZA', NULL, 'Wilaya de Aïn Temouchent'), (781, 'DZ', 'DZA', NULL, 'Wilaya de Batna'), (782, 'DZ', 'DZA', NULL, 'Wilaya de Béchar'), (783, 'DZ', 'DZA', NULL, 'Wilaya de Bejaïa'), (784, 'DZ', 'DZA', NULL, 'Wilaya de Biskra'), (785, 'DZ', 'DZA', NULL, 'Wilaya de Blida'), (786, 'DZ', 'DZA', NULL, 'Wilaya de Bordj Bou Arréridj'), (787, 'DZ', 'DZA', NULL, 'Wilaya de Bouira'), (788, 'DZ', 'DZA', NULL, 'Wilaya de Boumerdes'), (789, 'DZ', 'DZA', NULL, 'Wilaya de Chlef'), (790, 'DZ', 'DZA', NULL, 'Wilaya de Constantine'), (791, 'DZ', 'DZA', NULL, 'Wilaya de Djelfa'), (792, 'DZ', 'DZA', NULL, 'Wilaya de Ghardaïa'), (793, 'DZ', 'DZA', NULL, 'Wilaya de Guelma'), (794, 'DZ', 'DZA', NULL, 'Wilaya de Jijel'), (795, 'DZ', 'DZA', NULL, 'Wilaya de Khenchela'), (796, 'DZ', 'DZA', NULL, 'Wilaya de Laghouat'), (797, 'DZ', 'DZA', NULL, 'Wilaya de Mascara'), (798, 'DZ', 'DZA', NULL, 'Wilaya de Médéa'), (799, 'DZ', 'DZA', NULL, 'Wilaya de Mila'), (800, 'DZ', 'DZA', NULL, 'Wilaya de Mostaganem'), (801, 'DZ', 'DZA', NULL, 'Wilaya de M\'Sila'), (802, 'DZ', 'DZA', NULL, 'Wilaya de Naama'), (803, 'DZ', 'DZA', NULL, 'Wilaya de Ouargla'), (804, 'DZ', 'DZA', NULL, 'Wilaya de Relizane'), (805, 'DZ', 'DZA', NULL, 'Wilaya de Saïda'), (806, 'DZ', 'DZA', NULL, 'Wilaya de Sétif'), (807, 'DZ', 'DZA', NULL, 'Wilaya de Sidi Bel Abbès'), (808, 'DZ', 'DZA', NULL, 'Wilaya de Skikda'), (809, 'DZ', 'DZA', NULL, 'Wilaya de Souk Ahras'), (810, 'DZ', 'DZA', NULL, 'Wilaya de Tamanghasset'), (811, 'DZ', 'DZA', NULL, 'Wilaya de Tébessa'), (812, 'DZ', 'DZA', NULL, 'Wilaya de Tiaret'), (813, 'DZ', 'DZA', NULL, 'Wilaya de Tindouf'), (814, 'DZ', 'DZA', NULL, 'Wilaya de Tipaza'), (815, 'DZ', 'DZA', NULL, 'Wilaya de Tissemsilt'), (816, 'DZ', 'DZA', NULL, 'Wilaya de Tizi Ouzou'), (817, 'DZ', 'DZA', NULL, 'Wilaya de Tlemcen'), (818, 'EC', 'ECU', NULL, 'Provincia de Bolívar'), (819, 'EC', 'ECU', NULL, 'Provincia de Cotopaxi'), (820, 'EC', 'ECU', NULL, 'Provincia de El Oro'), (821, 'EC', 'ECU', NULL, 'Provincia de Esmeraldas'), (822, 'EC', 'ECU', NULL, 'Provincia de Francisco de Orellana'), (823, 'EC', 'ECU', NULL, 'Provincia de Galápagos'), (824, 'EC', 'ECU', NULL, 'Provincia de Imbabura'), (825, 'EC', 'ECU', NULL, 'Provincia de Loja'), (826, 'EC', 'ECU', NULL, 'Provincia de Los Ríos'), (827, 'EC', 'ECU', NULL, 'Provincia de Manabí'), (828, 'EC', 'ECU', NULL, 'Provincia de Morona Santiago'), (829, 'EC', 'ECU', NULL, 'Provincia de Napo'), (830, 'EC', 'ECU', NULL, 'Provincia de Pichincha'), (831, 'EC', 'ECU', NULL, 'Provincia de Sucumbíos'), (832, 'EC', 'ECU', NULL, 'Provincia de Zamora Chinchipe'), (833, 'EC', 'ECU', NULL, 'Provincia del Azuay'), (834, 'EC', 'ECU', NULL, 'Provincia del Cañar'), (835, 'EC', 'ECU', NULL, 'Provincia del Carchi'), (836, 'EC', 'ECU', NULL, 'Provincia del Chimborazo'), (837, 'EC', 'ECU', NULL, 'Provincia del Guayas'), (838, 'EC', 'ECU', NULL, 'Provincia del Pastaza'), (839, 'EC', 'ECU', NULL, 'Provincia del Tungurahua'), (840, 'EE', 'EST', NULL, 'Harjumaa'), (841, 'EE', 'EST', NULL, 'Hiiumaa'), (842, 'EE', 'EST', NULL, 'Ida-Virumaa'), (843, 'EE', 'EST', NULL, 'Järvamaa'), (844, 'EE', 'EST', NULL, 'Jõgevamaa'), (845, 'EE', 'EST', NULL, 'Läänemaa'), (846, 'EE', 'EST', NULL, 'Lääne-Virumaa'), (847, 'EE', 'EST', NULL, 'Pärnumaa'), (848, 'EE', 'EST', NULL, 'Põlvamaa'), (849, 'EE', 'EST', NULL, 'Raplamaa'), (850, 'EE', 'EST', NULL, 'Saaremaa'), (851, 'EE', 'EST', NULL, 'Tartumaa'), (852, 'EE', 'EST', NULL, 'Valgamaa'), (853, 'EE', 'EST', NULL, 'Viljandimaa'), (854, 'EE', 'EST', NULL, 'Võrumaa'), (855, 'EG', 'EGY', NULL, 'Alexandria'), (856, 'EG', 'EGY', NULL, 'Eastern Province'), (857, 'EG', 'EGY', NULL, 'Muḩāfaz̧at ad Daqahlīyah'), (858, 'EG', 'EGY', NULL, 'Muḩāfaz̧at al Baḩr al Aḩmar'), (859, 'EG', 'EGY', NULL, 'Muḩāfaz̧at al Buḩayrah'), (860, 'EG', 'EGY', NULL, 'Muḩāfaz̧at al Fayyūm'), (861, 'EG', 'EGY', NULL, 'Muḩāfaz̧at al Gharbīyah'), (862, 'EG', 'EGY', NULL, 'Muḩāfaz̧at al Ismā`īlīyah'), (863, 'EG', 'EGY', NULL, 'Muḩāfaz̧at al Jīzah'), (864, 'EG', 'EGY', NULL, 'Muḩāfaz̧at al Minūfīyah'), (865, 'EG', 'EGY', NULL, 'Muḩāfaz̧at al Minyā'), (866, 'EG', 'EGY', NULL, 'Muḩāfaz̧at al Qāhirah'), (867, 'EG', 'EGY', NULL, 'Muḩāfaz̧at al Qalyūbīyah'), (868, 'EG', 'EGY', NULL, 'Muḩāfaz̧at al Wādī al Jadīd'), (869, 'EG', 'EGY', NULL, 'Muḩāfaz̧at as Suways'), (870, 'EG', 'EGY', NULL, 'Muḩāfaz̧at Aswān'), (871, 'EG', 'EGY', NULL, 'Muḩāfaz̧at Asyūţ'), (872, 'EG', 'EGY', NULL, 'Muḩāfaz̧at Banī Suwayf'), (873, 'EG', 'EGY', NULL, 'Muḩāfaz̧at Būr Sa`īd'), (874, 'EG', 'EGY', NULL, 'Muḩāfaz̧at Dumyāţ'), (875, 'EG', 'EGY', NULL, 'Muḩāfaz̧at Janūb Sīnā\''), (876, 'EG', 'EGY', NULL, 'Muḩāfaz̧at Kafr ash Shaykh'), (877, 'EG', 'EGY', NULL, 'Muḩāfaz̧at Maţrūḩ'), (878, 'EG', 'EGY', NULL, 'Muḩāfaz̧at Qinā'), (879, 'EG', 'EGY', NULL, 'Muḩāfaz̧at Shamāl Sīnā\''), (880, 'EG', 'EGY', NULL, 'Muḩāfaz̧at Sūhāj'), (881, 'EH', 'ESH', NULL, 'Oued Ed-Dahab-Lagouira'), (882, 'ER', 'ERI', NULL, 'Zoba Ānseba'), (883, 'ER', 'ERI', NULL, 'Zoba Debub'), (884, 'ER', 'ERI', NULL, 'Zoba Debubawī K\'eyih Bahrī'), (885, 'ER', 'ERI', NULL, 'Zoba Gash Barka'), (886, 'ER', 'ERI', NULL, 'Zoba Ma\'ākel'), (887, 'ER', 'ERI', NULL, 'Zoba Semēnawī K\'eyih Bahrī'), (888, 'ES', 'ESP', NULL, 'Andalusia'), (889, 'ES', 'ESP', NULL, 'Aragon'), (890, 'ES', 'ESP', NULL, 'Autonomous Region of Madrid'), (891, 'ES', 'ESP', NULL, 'Autonomous Region of Navarre'), (892, 'ES', 'ESP', NULL, 'Balearic Islands'), (893, 'ES', 'ESP', NULL, 'Basque Country'), (894, 'ES', 'ESP', NULL, 'Canary Islands'), (895, 'ES', 'ESP', NULL, 'Cantabria'), (896, 'ES', 'ESP', NULL, 'Castille and León'), (897, 'ES', 'ESP', NULL, 'Castille-La Mancha'), (898, 'ES', 'ESP', NULL, 'Catalonia'), (899, 'ES', 'ESP', NULL, 'Ceuta'), (900, 'ES', 'ESP', NULL, 'Estremadura'), (901, 'ES', 'ESP', NULL, 'Galicia'), (902, 'ES', 'ESP', NULL, 'La Rioja'), (903, 'ES', 'ESP', NULL, 'Melilla'), (904, 'ES', 'ESP', NULL, 'Principality of Asturias'), (905, 'ES', 'ESP', NULL, 'Region of Murcia'), (906, 'ES', 'ESP', NULL, 'Valencian Community'), (907, 'ET', 'ETH', NULL, 'Ādīs Ābeba Āstedader'), (908, 'ET', 'ETH', NULL, 'Āfar Kilil'), (909, 'ET', 'ETH', NULL, 'Āmara Kilil'), (910, 'ET', 'ETH', NULL, 'Bīnshangul Gumuz Kilil'), (911, 'ET', 'ETH', NULL, 'Dirē Dawa Āstedader'), (912, 'ET', 'ETH', NULL, 'Gambēla Hizboch Kilil'), (913, 'ET', 'ETH', NULL, 'Hārerī Hizb Kilil'), (914, 'ET', 'ETH', NULL, 'Oromīya Kilil'), (915, 'ET', 'ETH', NULL, 'Sumalē Kilil'), (916, 'ET', 'ETH', NULL, 'Tigray Kilil'), (917, 'ET', 'ETH', NULL, 'Welega Kifle Hāger'), (918, 'ET', 'ETH', NULL, 'YeDebub Bihēroch Bihēreseboch na Hizboch Kilil'), (919, 'FI', 'FIN', NULL, 'Åland'), (920, 'FI', 'FIN', NULL, 'Åland '), (921, 'FI', 'FIN', NULL, 'Eastern Finland'), (922, 'FI', 'FIN', NULL, 'Lapponia'), (923, 'FI', 'FIN', NULL, 'Oulu'), (924, 'FI', 'FIN', NULL, 'Southern Finland'), (925, 'FI', 'FIN', NULL, 'Western Finland'), (926, 'FJ', 'FJI', NULL, 'Central'), (927, 'FJ', 'FJI', NULL, 'Eastern'), (928, 'FJ', 'FJI', NULL, 'Northern'), (929, 'FJ', 'FJI', NULL, 'Rotuma'), (930, 'FJ', 'FJI', NULL, 'Western'), (931, 'FM', 'FSM', NULL, 'Chuuk'), (932, 'FM', 'FSM', NULL, 'State of Kosrae'), (933, 'FM', 'FSM', NULL, 'State of Pohnpei'), (934, 'FM', 'FSM', NULL, 'State of Yap'), (935, 'FO', 'FRO', NULL, 'Faroe Islands'), (936, 'FR', 'FRA', NULL, 'Alsace'), (937, 'FR', 'FRA', NULL, 'Aquitaine'), (938, 'FR', 'FRA', NULL, 'Basse-Normandie'), (939, 'FR', 'FRA', NULL, 'Bourgogne'), (940, 'FR', 'FRA', NULL, 'Brittany'), (941, 'FR', 'FRA', NULL, 'Champagne-Ardenne'), (942, 'FR', 'FRA', NULL, 'Corsica'), (943, 'FR', 'FRA', NULL, 'Franche-Comté'), (944, 'FR', 'FRA', NULL, 'Haute-Normandie'), (945, 'FR', 'FRA', NULL, 'Languedoc-Roussillon'), (946, 'FR', 'FRA', NULL, 'Midi-Pyrénées'), (947, 'FR', 'FRA', NULL, 'Picardie'), (948, 'FR', 'FRA', NULL, 'Poitou-Charentes'), (949, 'FR', 'FRA', NULL, 'Provence-Alpes-Côte d\'Azur'), (950, 'FR', 'FRA', NULL, 'Région Auvergne'), (951, 'FR', 'FRA', NULL, 'Région Centre'), (952, 'FR', 'FRA', NULL, 'Région Île-de-France'), (953, 'FR', 'FRA', NULL, 'Région Limousin'), (954, 'FR', 'FRA', NULL, 'Région Lorraine'), (955, 'FR', 'FRA', NULL, 'Région Nord-Pas-de-Calais'), (956, 'FR', 'FRA', NULL, 'Région Pays de la Loire'), (957, 'FR', 'FRA', NULL, 'Rhône-Alpes'), (958, 'GA', 'GAB', NULL, 'Province de l\' Estuaire'), (959, 'GA', 'GAB', NULL, 'Province de l\' Ogooué-Ivindo'), (960, 'GA', 'GAB', NULL, 'Province de l\' Ogooué-Lolo'), (961, 'GA', 'GAB', NULL, 'Province de l\' Ogooué-Maritime'), (962, 'GA', 'GAB', NULL, 'Province de la Ngounié'), (963, 'GA', 'GAB', NULL, 'Province de la Nyanga'), (964, 'GA', 'GAB', NULL, 'Province du Haut-Ogooué'), (965, 'GA', 'GAB', NULL, 'Province du Moyen-Ogooué'), (966, 'GA', 'GAB', NULL, 'Province du Woleu-Ntem'), (967, 'GB', 'GBR', NULL, 'England'), (968, 'GB', 'GBR', NULL, 'Northern Ireland'), (969, 'GB', 'GBR', NULL, 'Scotland'), (970, 'GB', 'GBR', NULL, 'Wales'), (971, 'GD', 'GRD', NULL, 'Saint Andrew'), (972, 'GD', 'GRD', NULL, 'Saint David'), (973, 'GD', 'GRD', NULL, 'Saint George'), (974, 'GD', 'GRD', NULL, 'Saint John'), (975, 'GD', 'GRD', NULL, 'Saint Mark'), (976, 'GD', 'GRD', NULL, 'Saint Patrick'), (977, 'GE', 'GEO', NULL, 'Abkhazia'), (978, 'GE', 'GEO', NULL, 'Ajaria [provisional]'), (979, 'GE', 'GEO', NULL, 'Ch\'khorotsqus Raioni'), (980, 'GE', 'GEO', NULL, 'K\'alak\'i T\'bilisi'), (981, 'GE', 'GEO', NULL, 'Martvilis Raioni'), (982, 'GE', 'GEO', NULL, 'Samegrelo and Zemo Svaneti'), (983, 'GE', 'GEO', NULL, 'Zugdidis Raioni'), (984, 'GF', 'GUF', NULL, 'Guyane'), (985, 'GH', 'GHA', NULL, 'Ashanti Region'), (986, 'GH', 'GHA', NULL, 'Brong-Ahafo Region'), (987, 'GH', 'GHA', NULL, 'Central Region'), (988, 'GH', 'GHA', NULL, 'Eastern Region'), (989, 'GH', 'GHA', NULL, 'Greater Accra Region'), (990, 'GH', 'GHA', NULL, 'Northern Region'), (991, 'GH', 'GHA', NULL, 'Upper East Region'), (992, 'GH', 'GHA', NULL, 'Upper West Region'), (993, 'GH', 'GHA', NULL, 'Volta Region'), (994, 'GH', 'GHA', NULL, 'Western Region'), (995, 'GM', 'GMB', NULL, 'Central River Division'), (996, 'GM', 'GMB', NULL, 'City of Banjul'), (997, 'GM', 'GMB', NULL, 'Lower River Division'), (998, 'GM', 'GMB', NULL, 'North Bank Division'), (999, 'GM', 'GMB', NULL, 'Upper River'), (1000, 'GM', 'GMB', NULL, 'Western Division'), (1001, 'GN', 'GIN', NULL, 'Capitale d\'État-Zone Spéciale de Conakry'), (1002, 'GN', 'GIN', NULL, 'Préfecture de Beyla'), (1003, 'GN', 'GIN', NULL, 'Préfecture de Boffa'), (1004, 'GN', 'GIN', NULL, 'Préfecture de Boké'), (1005, 'GN', 'GIN', NULL, 'Préfecture de Coyah'), (1006, 'GN', 'GIN', NULL, 'Préfecture de Dabola'), (1007, 'GN', 'GIN', NULL, 'Préfecture de Dalaba'), (1008, 'GN', 'GIN', NULL, 'Préfecture de Dinguiraye'), (1009, 'GN', 'GIN', NULL, 'Préfecture de Dubréka'), (1010, 'GN', 'GIN', NULL, 'Préfecture de Faranah'), (1011, 'GN', 'GIN', NULL, 'Préfecture de Forécariah'), (1012, 'GN', 'GIN', NULL, 'Préfecture de Fria'), (1013, 'GN', 'GIN', NULL, 'Préfecture de Gaoual'), (1014, 'GN', 'GIN', NULL, 'Préfecture de Guékédou'), (1015, 'GN', 'GIN', NULL, 'Préfecture de Kankan'), (1016, 'GN', 'GIN', NULL, 'Préfecture de Kérouané'), (1017, 'GN', 'GIN', NULL, 'Préfecture de Kindia'), (1018, 'GN', 'GIN', NULL, 'Préfecture de Kissidougou'), (1019, 'GN', 'GIN', NULL, 'Préfecture de Koubia'), (1020, 'GN', 'GIN', NULL, 'Préfecture de Koundara'), (1021, 'GN', 'GIN', NULL, 'Préfecture de Kouroussa'), (1022, 'GN', 'GIN', NULL, 'Préfecture de Labé'), (1023, 'GN', 'GIN', NULL, 'Préfecture de Lélouma'), (1024, 'GN', 'GIN', NULL, 'Préfecture de Lola'), (1025, 'GN', 'GIN', NULL, 'Préfecture de Macenta'), (1026, 'GN', 'GIN', NULL, 'Préfecture de Mali'), (1027, 'GN', 'GIN', NULL, 'Préfecture de Mamou'), (1028, 'GN', 'GIN', NULL, 'Préfecture de Mandiana'), (1029, 'GN', 'GIN', NULL, 'Préfecture de Nzérékoré'), (1030, 'GN', 'GIN', NULL, 'Préfecture de Pita'), (1031, 'GN', 'GIN', NULL, 'Préfecture de Siguiri'), (1032, 'GN', 'GIN', NULL, 'Préfecture de Télimélé'), (1033, 'GN', 'GIN', NULL, 'Préfecture de Tougué'), (1034, 'GN', 'GIN', NULL, 'Préfecture de Yomou'), (1035, 'GP', 'GLP', NULL, 'Région Guadeloupe'), (1036, 'GQ', 'GNQ', NULL, 'Provincia de Annobón'), (1037, 'GQ', 'GNQ', NULL, 'Provincia de Bioko Norte'), (1038, 'GQ', 'GNQ', NULL, 'Provincia de Bioko Sur'), (1039, 'GQ', 'GNQ', NULL, 'Provincia de Centro Sur'), (1040, 'GQ', 'GNQ', NULL, 'Provincia de Kié-Ntem'), (1041, 'GQ', 'GNQ', NULL, 'Provincia de Litoral'), (1042, 'GQ', 'GNQ', NULL, 'Provincia de Wele-Nzas'), (1043, 'GR', 'GRC', NULL, 'Attica'), (1044, 'GR', 'GRC', NULL, 'Central Greece'), (1045, 'GR', 'GRC', NULL, 'Central Macedonia'), (1046, 'GR', 'GRC', NULL, 'Crete'), (1047, 'GR', 'GRC', NULL, 'East Macedonia and Thrace'), (1048, 'GR', 'GRC', NULL, 'Epirus'), (1049, 'GR', 'GRC', NULL, 'Ionian Islands'), (1050, 'GR', 'GRC', NULL, 'North Aegean'), (1051, 'GR', 'GRC', NULL, 'Peloponnese'), (1052, 'GR', 'GRC', NULL, 'South Aegean'), (1053, 'GR', 'GRC', NULL, 'Thessaly'), (1054, 'GR', 'GRC', NULL, 'West Greece'), (1055, 'GR', 'GRC', NULL, 'West Macedonia'), (1056, 'GT', 'GTM', NULL, 'Departamento de Alta Verapaz'), (1057, 'GT', 'GTM', NULL, 'Departamento de Baja Verapaz'), (1058, 'GT', 'GTM', NULL, 'Departamento de Chimaltenango'), (1059, 'GT', 'GTM', NULL, 'Departamento de Chiquimula'), (1060, 'GT', 'GTM', NULL, 'Departamento de El Progreso'), (1061, 'GT', 'GTM', NULL, 'Departamento de Escuintla'), (1062, 'GT', 'GTM', NULL, 'Departamento de Guatemala'), (1063, 'GT', 'GTM', NULL, 'Departamento de Huehuetenango'), (1064, 'GT', 'GTM', NULL, 'Departamento de Izabal'), (1065, 'GT', 'GTM', NULL, 'Departamento de Jalapa'), (1066, 'GT', 'GTM', NULL, 'Departamento de Jutiapa'), (1067, 'GT', 'GTM', NULL, 'Departamento de Quetzaltenango'), (1068, 'GT', 'GTM', NULL, 'Departamento de Retalhuleu'), (1069, 'GT', 'GTM', NULL, 'Departamento de Sacatepéquez'), (1070, 'GT', 'GTM', NULL, 'Departamento de San Marcos'), (1071, 'GT', 'GTM', NULL, 'Departamento de Santa Rosa'), (1072, 'GT', 'GTM', NULL, 'Departamento de Sololá'), (1073, 'GT', 'GTM', NULL, 'Departamento de Suchitepéquez'), (1074, 'GT', 'GTM', NULL, 'Departamento de Totonicapán'), (1075, 'GT', 'GTM', NULL, 'Departamento de Zacapa'), (1076, 'GT', 'GTM', NULL, 'Departamento del Petén'), (1077, 'GT', 'GTM', NULL, 'Departamento del Quiché'), (1078, 'GW', 'GNB', NULL, 'Bafatá'), (1079, 'GW', 'GNB', NULL, 'Biombo'), (1080, 'GW', 'GNB', NULL, 'Bissau'), (1081, 'GW', 'GNB', NULL, 'Bolama'), (1082, 'GW', 'GNB', NULL, 'Cacheu'), (1083, 'GW', 'GNB', NULL, 'Gabú'), (1084, 'GW', 'GNB', NULL, 'Oio'), (1085, 'GW', 'GNB', NULL, 'Quinara'), (1086, 'GW', 'GNB', NULL, 'Tombali'), (1087, 'GY', 'GUY', NULL, 'Barima-Waini Region'), (1088, 'GY', 'GUY', NULL, 'Cuyuni-Mazaruni Region'), (1089, 'GY', 'GUY', NULL, 'Demerara-Mahaica Region'), (1090, 'GY', 'GUY', NULL, 'East Berbice-Corentyne Region'), (1091, 'GY', 'GUY', NULL, 'Essequibo Islands-West Demerara Region'); INSERT INTO `ma_DCountryState` (`id`, `countryId`, `countryIsoAlpha3`, `abbreviation`, `name`) VALUES (1092, 'GY', 'GUY', NULL, 'Mahaica-Berbice Region'), (1093, 'GY', 'GUY', NULL, 'Pomeroon-Supenaam Region'), (1094, 'GY', 'GUY', NULL, 'Potaro-Siparuni Region'), (1095, 'GY', 'GUY', NULL, 'Upper Demerara-Berbice Region'), (1096, 'GY', 'GUY', NULL, 'Upper Takutu-Upper Essequibo Region'), (1097, 'HN', 'HND', NULL, 'Departamento de Atlántida'), (1098, 'HN', 'HND', NULL, 'Departamento de Choluteca'), (1099, 'HN', 'HND', NULL, 'Departamento de Colón'), (1100, 'HN', 'HND', NULL, 'Departamento de Comayagua'), (1101, 'HN', 'HND', NULL, 'Departamento de Copán'), (1102, 'HN', 'HND', NULL, 'Departamento de Cortés'), (1103, 'HN', 'HND', NULL, 'Departamento de El Paraíso'), (1104, 'HN', 'HND', NULL, 'Departamento de Gracias a Dios'), (1105, 'HN', 'HND', NULL, 'Departamento de Intibucá'), (1106, 'HN', 'HND', NULL, 'Departamento de Islas de la Bahía'), (1107, 'HN', 'HND', NULL, 'Departamento de Lempira'), (1108, 'HN', 'HND', NULL, 'Departamento de Ocotepeque'), (1109, 'HN', 'HND', NULL, 'Departamento de Olancho'), (1110, 'HN', 'HND', NULL, 'Departamento de Santa Bárbara'), (1111, 'HN', 'HND', NULL, 'Departamento de Valle'), (1112, 'HN', 'HND', NULL, 'Departamento de Yoro'), (1113, 'HN', 'HND', NULL, 'Departmento de Francisco Morazán'), (1114, 'HN', 'HND', NULL, 'Departmento de La Paz'), (1115, 'HR', 'HRV', NULL, 'Bjelovarsko-Bilogorska Županija'), (1116, 'HR', 'HRV', NULL, 'Brodsko-Posavska Županija'), (1117, 'HR', 'HRV', NULL, 'Dubrovačko-Neretvanska Županija'), (1118, 'HR', 'HRV', NULL, 'Grad Zagreb'), (1119, 'HR', 'HRV', NULL, 'Istarska Županija'), (1120, 'HR', 'HRV', NULL, 'Karlovačka Županija'), (1121, 'HR', 'HRV', NULL, 'Koprivničko-Križevačka Županija'), (1122, 'HR', 'HRV', NULL, 'Krapinsko-Zagorska Županija'), (1123, 'HR', 'HRV', NULL, 'Ličko-Senjska Županija'), (1124, 'HR', 'HRV', NULL, 'Međimurska Županija'), (1125, 'HR', 'HRV', NULL, 'Osječko-Baranjska Županija'), (1126, 'HR', 'HRV', NULL, 'Požeško-Slavonska Županija'), (1127, 'HR', 'HRV', NULL, 'Primorsko-Goranska Županija'), (1128, 'HR', 'HRV', NULL, 'Šibensko-Kninska Županija'), (1129, 'HR', 'HRV', NULL, 'Sisačko-Moslavačka Županija'), (1130, 'HR', 'HRV', NULL, 'Splitsko-Dalmatinska Županija'), (1131, 'HR', 'HRV', NULL, 'Varaždinska Županija'), (1132, 'HR', 'HRV', NULL, 'Virovitičko-Podravska Županija'), (1133, 'HR', 'HRV', NULL, 'Vukovarsko-Srijemska Županija'), (1134, 'HR', 'HRV', NULL, 'Zadarska Županija'), (1135, 'HR', 'HRV', NULL, 'Zagrebačka Županija'), (1136, 'HT', 'HTI', NULL, 'Département de l\' Artibonite'), (1137, 'HT', 'HTI', NULL, 'Département de l\' Ouest'), (1138, 'HT', 'HTI', NULL, 'Département de la Grand\'Anse'), (1139, 'HT', 'HTI', NULL, 'Département du Centre'), (1140, 'HT', 'HTI', NULL, 'Département du Nord'), (1141, 'HT', 'HTI', NULL, 'Département du Nord-Est'), (1142, 'HT', 'HTI', NULL, 'Département du Nord-Ouest'), (1143, 'HT', 'HTI', NULL, 'Département du Sud'), (1144, 'HT', 'HTI', NULL, 'Département du Sud-Est'), (1145, 'HU', 'HUN', NULL, 'Bács-Kiskun'), (1146, 'HU', 'HUN', NULL, 'Baranya megye'), (1147, 'HU', 'HUN', NULL, 'Békés megye'), (1148, 'HU', 'HUN', NULL, 'Borsod-Abaúj-Zemplén'), (1149, 'HU', 'HUN', NULL, 'Budapest főváros'), (1150, 'HU', 'HUN', NULL, 'Csongrád megye'), (1151, 'HU', 'HUN', NULL, 'Fejér'), (1152, 'HU', 'HUN', NULL, 'Győr-Moson-Sopron'), (1153, 'HU', 'HUN', NULL, 'Hajdú-Bihar'), (1154, 'HU', 'HUN', NULL, 'Heves megye'), (1155, 'HU', 'HUN', NULL, 'Jász-Nagykun-Szolnok'), (1156, 'HU', 'HUN', NULL, 'Komárom-Esztergom'), (1157, 'HU', 'HUN', NULL, 'Nógrád megye'), (1158, 'HU', 'HUN', NULL, 'Pest megye'), (1159, 'HU', 'HUN', NULL, 'Somogy megye'), (1160, 'HU', 'HUN', NULL, 'Szabolcs-Szatmár-Bereg'), (1161, 'HU', 'HUN', NULL, 'Tolna megye'), (1162, 'HU', 'HUN', NULL, 'Vas'), (1163, 'HU', 'HUN', NULL, 'Veszprém megye'), (1164, 'HU', 'HUN', NULL, 'Zala'), (1165, 'ID', 'IDN', NULL, 'Bangka-Belitung'), (1166, 'ID', 'IDN', NULL, 'Central Java'), (1167, 'ID', 'IDN', NULL, 'Central Sulawesi'), (1168, 'ID', 'IDN', NULL, 'Daerah Istimewa Aceh'), (1169, 'ID', 'IDN', NULL, 'Daerah Istimewa Yogyakarta'), (1170, 'ID', 'IDN', NULL, 'Daerah Khusus Ibukota Jakarta Raya'), (1171, 'ID', 'IDN', NULL, 'East Java'), (1172, 'ID', 'IDN', NULL, 'East Kalimantan'), (1173, 'ID', 'IDN', NULL, 'East Nusa Tenggara'), (1174, 'ID', 'IDN', NULL, 'Kotamadya Tegal'), (1175, 'ID', 'IDN', NULL, 'North Sulawesi'), (1176, 'ID', 'IDN', NULL, 'North Sumatra'), (1177, 'ID', 'IDN', NULL, 'Propinsi Bali'), (1178, 'ID', 'IDN', NULL, 'Propinsi Banten'), (1179, 'ID', 'IDN', NULL, 'Propinsi Bengkulu'), (1180, 'ID', 'IDN', NULL, 'Propinsi Jambi'), (1181, 'ID', 'IDN', NULL, 'Propinsi Kalimantan Tengah'), (1182, 'ID', 'IDN', NULL, 'Propinsi Lampung'), (1183, 'ID', 'IDN', NULL, 'Propinsi Maluku'), (1184, 'ID', 'IDN', NULL, 'Propinsi Maluku Utara'), (1185, 'ID', 'IDN', NULL, 'Propinsi Nusa Tenggara Barat'), (1186, 'ID', 'IDN', NULL, 'Propinsi Sulawesi Tenggara'), (1187, 'ID', 'IDN', NULL, 'Provinsi Gorontalo'), (1188, 'ID', 'IDN', NULL, 'Provinsi Irian Jaya Barat'), (1189, 'ID', 'IDN', NULL, 'Provinsi Papua'), (1190, 'ID', 'IDN', NULL, 'Provinsi Riau'), (1191, 'ID', 'IDN', NULL, 'Provinsi Sulawesi Barat'), (1192, 'ID', 'IDN', NULL, 'Riau Islands'), (1193, 'ID', 'IDN', NULL, 'South Kalimantan'), (1194, 'ID', 'IDN', NULL, 'South Sulawesi'), (1195, 'ID', 'IDN', NULL, 'South Sumatra'), (1196, 'ID', 'IDN', NULL, 'West Java'), (1197, 'ID', 'IDN', NULL, 'West Kalimantan'), (1198, 'ID', 'IDN', NULL, 'West Sumatra'), (1199, 'IE', 'IRL', NULL, 'County Carlow'), (1200, 'IE', 'IRL', NULL, 'County Cavan'), (1201, 'IE', 'IRL', NULL, 'County Clare'), (1202, 'IE', 'IRL', NULL, 'County Cork'), (1203, 'IE', 'IRL', NULL, 'County Donegal'), (1204, 'IE', 'IRL', NULL, 'County Dublin'), (1205, 'IE', 'IRL', NULL, 'County Galway'), (1206, 'IE', 'IRL', NULL, 'County Kerry'), (1207, 'IE', 'IRL', NULL, 'County Kildare'), (1208, 'IE', 'IRL', NULL, 'County Kilkenny'), (1209, 'IE', 'IRL', NULL, 'County Laois'), (1210, 'IE', 'IRL', NULL, 'County Leitrim'), (1211, 'IE', 'IRL', NULL, 'County Limerick'), (1212, 'IE', 'IRL', NULL, 'County Longford'), (1213, 'IE', 'IRL', NULL, 'County Louth'), (1214, 'IE', 'IRL', NULL, 'County Mayo'), (1215, 'IE', 'IRL', NULL, 'County Meath'), (1216, 'IE', 'IRL', NULL, 'County Monaghan'), (1217, 'IE', 'IRL', NULL, 'County Offaly'), (1218, 'IE', 'IRL', NULL, 'County Roscommon'), (1219, 'IE', 'IRL', NULL, 'County Sligo'), (1220, 'IE', 'IRL', NULL, 'County Tipperary'), (1221, 'IE', 'IRL', NULL, 'County Waterford'), (1222, 'IE', 'IRL', NULL, 'County Westmeath'), (1223, 'IE', 'IRL', NULL, 'County Wexford'), (1224, 'IE', 'IRL', NULL, 'County Wicklow'), (1225, 'IL', 'ISR', NULL, 'Central District'), (1226, 'IL', 'ISR', NULL, 'Haifa District'), (1227, 'IL', 'ISR', NULL, 'Jerusalem District'), (1228, 'IL', 'ISR', NULL, 'Northern District'), (1229, 'IL', 'ISR', NULL, 'Southern District'), (1230, 'IL', 'ISR', NULL, 'Tel Aviv District'), (1231, 'IN', 'IND', NULL, ' Union Territory of Andaman and Nicobar Islands'), (1232, 'IN', 'IND', NULL, 'Bengal'), (1233, 'IN', 'IND', NULL, 'Bihār State of'), (1234, 'IN', 'IND', NULL, 'Daman and Diu'), (1235, 'IN', 'IND', NULL, 'Goa'), (1236, 'IN', 'IND', NULL, 'Himāchal Pradesh'), (1237, 'IN', 'IND', NULL, 'Laccadives'), (1238, 'IN', 'IND', NULL, 'State of Andhra Pradesh'), (1239, 'IN', 'IND', NULL, 'State of Arunāchal Pradesh'), (1240, 'IN', 'IND', NULL, 'State of Assam'), (1241, 'IN', 'IND', NULL, 'State of Chhattīsgarh'), (1242, 'IN', 'IND', NULL, 'State of Gujarāt'), (1243, 'IN', 'IND', NULL, 'State of Haryāna'), (1244, 'IN', 'IND', NULL, 'State of Jammu and Kashmīr'), (1245, 'IN', 'IND', NULL, 'State of Jharkhand'), (1246, 'IN', 'IND', NULL, 'State of Karnātaka'), (1247, 'IN', 'IND', NULL, 'State of Kerala'), (1248, 'IN', 'IND', NULL, 'State of Madhya Pradesh'), (1249, 'IN', 'IND', NULL, 'State of Mahārāshtra'), (1250, 'IN', 'IND', NULL, 'State of Manipur'), (1251, 'IN', 'IND', NULL, 'State of Meghālaya'), (1252, 'IN', 'IND', NULL, 'State of Mizoram'), (1253, 'IN', 'IND', NULL, 'State of Nāgāland'), (1254, 'IN', 'IND', NULL, 'State of Orissa'), (1255, 'IN', 'IND', NULL, 'State of Punjab'), (1256, 'IN', 'IND', NULL, 'State of Rājasthān'), (1257, 'IN', 'IND', NULL, 'State of Sikkim'), (1258, 'IN', 'IND', NULL, 'State of Tamil Nādu'), (1259, 'IN', 'IND', NULL, 'State of Tripura'), (1260, 'IN', 'IND', NULL, 'State of Uttar Pradesh'), (1261, 'IN', 'IND', NULL, 'Union Territory of Chandīgarh'), (1262, 'IN', 'IND', NULL, 'Union Territory of Dādra and Nagar Haveli'), (1263, 'IN', 'IND', NULL, 'Union Territory of Delhi'), (1264, 'IN', 'IND', NULL, 'Union Territory of Puducherry'), (1265, 'IN', 'IND', NULL, 'Uttarakhand'), (1266, 'IO', 'IOT', NULL, 'British Indian Ocean Territory '), (1267, 'IQ', 'IRQ', NULL, 'Diyala'), (1268, 'IQ', 'IRQ', NULL, 'Muḩāfaz̧at al Anbār'), (1269, 'IQ', 'IRQ', NULL, 'Muḩāfaz̧at al Başrah'), (1270, 'IQ', 'IRQ', NULL, 'Muḩāfaz̧at al Muthanná'), (1271, 'IQ', 'IRQ', NULL, 'Muḩāfaz̧at al Qādisīyah'), (1272, 'IQ', 'IRQ', NULL, 'Muḩāfaz̧at an Najaf'), (1273, 'IQ', 'IRQ', NULL, 'Muḩāfaz̧at Arbīl'), (1274, 'IQ', 'IRQ', NULL, 'Muḩāfaz̧at as Sulaymānīyah'), (1275, 'IQ', 'IRQ', NULL, 'Muḩāfaz̧at at Ta\'mīm'), (1276, 'IQ', 'IRQ', NULL, 'Muḩāfaz̧at Bābil'), (1277, 'IQ', 'IRQ', NULL, 'Muḩāfaz̧at Baghdād'), (1278, 'IQ', 'IRQ', NULL, 'Muḩāfaz̧at Dahūk'), (1279, 'IQ', 'IRQ', NULL, 'Muḩāfaz̧at Dhī Qār'), (1280, 'IQ', 'IRQ', NULL, 'Muḩāfaz̧at Karbalā\''), (1281, 'IQ', 'IRQ', NULL, 'Muḩāfaz̧at Maysān'), (1282, 'IQ', 'IRQ', NULL, 'Muḩāfaz̧at Nīnawá'), (1283, 'IQ', 'IRQ', NULL, 'Muḩāfaz̧at Şalāḩ ad Dīn'), (1284, 'IQ', 'IRQ', NULL, 'Muḩāfaz̧at Wāsiţ'), (1285, 'IQ', 'IRQ', NULL, 'Ostān-e Dīāleh'), (1286, 'IQ', 'IRQ', NULL, 'Ostān-e Soleymānīyeh'), (1287, 'IR', 'IRN', NULL, 'Bushehr Province'), (1288, 'IR', 'IRN', NULL, 'Fārs Province'), (1289, 'IR', 'IRN', NULL, 'Hormozgān Province'), (1290, 'IR', 'IRN', NULL, 'Khorasan Ostan-e'), (1291, 'IR', 'IRN', NULL, 'Markazi Province'), (1292, 'IR', 'IRN', NULL, 'Māzandarān Province'), (1293, 'IR', 'IRN', NULL, 'Ostān-e Ardabīl'), (1294, 'IR', 'IRN', NULL, 'Ostān-e Āz̄arbāyjān-e Gharbī'), (1295, 'IR', 'IRN', NULL, 'Ostān-e Āz̄arbāyjān-e Sharqī'), (1296, 'IR', 'IRN', NULL, 'Ostān-e Chahār Maḩāll va Bakhtīārī'), (1297, 'IR', 'IRN', NULL, 'Ostān-e Eşfahān'), (1298, 'IR', 'IRN', NULL, 'Ostān-e Gīlān'), (1299, 'IR', 'IRN', NULL, 'Ostān-e Golestān'), (1300, 'IR', 'IRN', NULL, 'Ostān-e Hamadān'), (1301, 'IR', 'IRN', NULL, 'Ostān-e Īlām'), (1302, 'IR', 'IRN', NULL, 'Ostān-e Kermān'), (1303, 'IR', 'IRN', NULL, 'Ostān-e Kermānshāh'), (1304, 'IR', 'IRN', NULL, 'Ostān-e Khorāsān-e Jonūbī'), (1305, 'IR', 'IRN', NULL, 'Ostān-e Khorāsān-e Shomālī'), (1306, 'IR', 'IRN', NULL, 'Ostān-e Khūzestān'), (1307, 'IR', 'IRN', NULL, 'Ostān-e Kohgīlūyeh va Būyer Aḩmad'), (1308, 'IR', 'IRN', NULL, 'Ostān-e Kordestān'), (1309, 'IR', 'IRN', NULL, 'Ostān-e Lorestān'), (1310, 'IR', 'IRN', NULL, 'Ostān-e Qazvīn'), (1311, 'IR', 'IRN', NULL, 'Ostān-e Qom'), (1312, 'IR', 'IRN', NULL, 'Ostān-e Sīstān va Balūchestān'), (1313, 'IR', 'IRN', NULL, 'Ostān-e Tehrān'), (1314, 'IR', 'IRN', NULL, 'Ostān-e Yazd'), (1315, 'IR', 'IRN', NULL, 'Razavi Khorasan Province'), (1316, 'IR', 'IRN', NULL, 'Semnān Province'), (1317, 'IR', 'IRN', NULL, 'Zanjan Province'), (1318, 'IS', 'ISL', NULL, 'Capital Region'), (1319, 'IS', 'ISL', NULL, 'East'), (1320, 'IS', 'ISL', NULL, 'Northeast'), (1321, 'IS', 'ISL', NULL, 'Northwest'), (1322, 'IS', 'ISL', NULL, 'South'), (1323, 'IS', 'ISL', NULL, 'Southern Peninsula'), (1324, 'IS', 'ISL', NULL, 'West'), (1325, 'IS', 'ISL', NULL, 'Westfjords'), (1326, 'IT', 'ITA', NULL, 'Abruzzo'), (1327, 'IT', 'ITA', NULL, 'Aosta Valley'), (1328, 'IT', 'ITA', NULL, 'Apulia'), (1329, 'IT', 'ITA', NULL, 'Basilicate'), (1330, 'IT', 'ITA', NULL, 'Calabria'), (1331, 'IT', 'ITA', NULL, 'Campania'), (1332, 'IT', 'ITA', NULL, 'Friuli'), (1333, 'IT', 'ITA', NULL, 'Latium'), (1334, 'IT', 'ITA', NULL, 'Liguria'), (1335, 'IT', 'ITA', NULL, 'Lombardy'), (1336, 'IT', 'ITA', NULL, 'Piedmont'), (1337, 'IT', 'ITA', NULL, 'Regione Emilia-Romagna'), (1338, 'IT', 'ITA', NULL, 'Regione Molise'), (1339, 'IT', 'ITA', NULL, 'Sardinia'), (1340, 'IT', 'ITA', NULL, 'Sicily'), (1341, 'IT', 'ITA', NULL, 'The Marches'), (1342, 'IT', 'ITA', NULL, 'Trentino-Alto Adige'), (1343, 'IT', 'ITA', NULL, 'Tuscany'), (1344, 'IT', 'ITA', NULL, 'Umbria'), (1345, 'IT', 'ITA', NULL, 'Veneto'), (1346, 'JE', 'JEY', NULL, 'Jersey '), (1347, 'JM', 'JAM', NULL, 'Hanover Parish'), (1348, 'JM', 'JAM', NULL, 'Kingston'), (1349, 'JM', 'JAM', NULL, 'Parish of Clarendon'), (1350, 'JM', 'JAM', NULL, 'Parish of Manchester'), (1351, 'JM', 'JAM', NULL, 'Parish of Portland'), (1352, 'JM', 'JAM', NULL, 'Parish of Saint Andrew'), (1353, 'JM', 'JAM', NULL, 'Parish of Saint Ann'), (1354, 'JM', 'JAM', NULL, 'Parish of Saint Catherine'), (1355, 'JM', 'JAM', NULL, 'Parish of Saint Elizabeth'), (1356, 'JM', 'JAM', NULL, 'Parish of Saint James'), (1357, 'JM', 'JAM', NULL, 'Parish of Saint Mary'), (1358, 'JM', 'JAM', NULL, 'Parish of Saint Thomas'), (1359, 'JM', 'JAM', NULL, 'Parish of Trelawny'), (1360, 'JM', 'JAM', NULL, 'Parish of Westmoreland'), (1361, 'JO', 'JOR', NULL, 'Ajlun'), (1362, 'JO', 'JOR', NULL, 'Amman'), (1363, 'JO', 'JOR', NULL, 'Aqaba'), (1364, 'JO', 'JOR', NULL, 'Balqa'), (1365, 'JO', 'JOR', NULL, 'Irbid'), (1366, 'JO', 'JOR', NULL, 'Jerash'), (1367, 'JO', 'JOR', NULL, 'Karak'), (1368, 'JO', 'JOR', NULL, 'Ma\'an'), (1369, 'JO', 'JOR', NULL, 'Madaba'), (1370, 'JO', 'JOR', NULL, 'Mafraq'), (1371, 'JO', 'JOR', NULL, 'Tafielah'), (1372, 'JO', 'JOR', NULL, 'Zarqa'), (1373, 'JP', 'JPN', NULL, 'Aichi-ken'), (1374, 'JP', 'JPN', NULL, 'Akita-ken'), (1375, 'JP', 'JPN', NULL, 'Aomori-ken'), (1376, 'JP', 'JPN', NULL, 'Chiba-ken'), (1377, 'JP', 'JPN', NULL, 'Ehime'), (1378, 'JP', 'JPN', NULL, 'Fukui-ken'), (1379, 'JP', 'JPN', NULL, 'Fukuoka-ken'), (1380, 'JP', 'JPN', NULL, 'Fukushima-ken'), (1381, 'JP', 'JPN', NULL, 'Gifu-ken'), (1382, 'JP', 'JPN', NULL, 'Gumma-ken'), (1383, 'JP', 'JPN', NULL, 'Hiroshima-ken'), (1384, 'JP', 'JPN', NULL, 'Hokkaidō'), (1385, 'JP', 'JPN', NULL, 'Hyōgo-ken'), (1386, 'JP', 'JPN', NULL, 'Ibaraki-ken'), (1387, 'JP', 'JPN', NULL, 'Ishikawa-ken'), (1388, 'JP', 'JPN', NULL, 'Iwate-ken'), (1389, 'JP', 'JPN', NULL, 'Kagawa-ken'), (1390, 'JP', 'JPN', NULL, 'Kagoshima-ken'), (1391, 'JP', 'JPN', NULL, 'Kanagawa-ken'), (1392, 'JP', 'JPN', NULL, 'Kōchi-ken'), (1393, 'JP', 'JPN', NULL, 'Kumamoto-ken'), (1394, 'JP', 'JPN', NULL, 'Kyōto-fu'), (1395, 'JP', 'JPN', NULL, 'Mie-ken'), (1396, 'JP', 'JPN', NULL, 'Miyagi-ken'), (1397, 'JP', 'JPN', NULL, 'Miyazaki-ken'), (1398, 'JP', 'JPN', NULL, 'Nagano-ken'), (1399, 'JP', 'JPN', NULL, 'Nagasaki-ken'), (1400, 'JP', 'JPN', NULL, 'Nara'), (1401, 'JP', 'JPN', NULL, 'Niigata-ken'), (1402, 'JP', 'JPN', NULL, 'Ōita-ken'), (1403, 'JP', 'JPN', NULL, 'Okayama-ken'), (1404, 'JP', 'JPN', NULL, 'Okinawa-ken'), (1405, 'JP', 'JPN', NULL, 'Ōsaka-fu'), (1406, 'JP', 'JPN', NULL, 'Saga-ken'), (1407, 'JP', 'JPN', NULL, 'Saitama-ken'), (1408, 'JP', 'JPN', NULL, 'Shiga-ken'), (1409, 'JP', 'JPN', NULL, 'Shimane-ken'), (1410, 'JP', 'JPN', NULL, 'Shizuoka-ken'), (1411, 'JP', 'JPN', NULL, 'Tochigi-ken'), (1412, 'JP', 'JPN', NULL, 'Tokushima-ken'), (1413, 'JP', 'JPN', NULL, 'Tōkyō-to'), (1414, 'JP', 'JPN', NULL, 'Tottori-ken'), (1415, 'JP', 'JPN', NULL, 'Toyama-ken'), (1416, 'JP', 'JPN', NULL, 'Wakayama-ken'), (1417, 'JP', 'JPN', NULL, 'Yamagata-ken'), (1418, 'JP', 'JPN', NULL, 'Yamaguchi-ken'), (1419, 'JP', 'JPN', NULL, 'Yamanashi-ken'), (1420, 'KE', 'KEN', NULL, 'Central Province'), (1421, 'KE', 'KEN', NULL, 'Coast Province'), (1422, 'KE', 'KEN', NULL, 'Eastern'), (1423, 'KE', 'KEN', NULL, 'Nairobi Area'), (1424, 'KE', 'KEN', NULL, 'North Eastern Province'), (1425, 'KE', 'KEN', NULL, 'Nyanza Province'), (1426, 'KE', 'KEN', NULL, 'Rift Valley Province'), (1427, 'KE', 'KEN', NULL, 'Western Province'), (1428, 'KG', 'KGZ', NULL, 'Batkenskaya Oblast\''), (1429, 'KG', 'KGZ', NULL, 'Bishkek Shaary'), (1430, 'KG', 'KGZ', NULL, 'Chuyskaya Oblast\''), (1431, 'KG', 'KGZ', NULL, 'Jalal-Abad Oblasty'), (1432, 'KG', 'KGZ', NULL, 'Narynskaya Oblast\''), (1433, 'KG', 'KGZ', NULL, 'Oshskaya Oblast\''), (1434, 'KG', 'KGZ', NULL, 'Talasskaya Oblast\''), (1435, 'KG', 'KGZ', NULL, 'Ysyk-Köl Oblasty'), (1436, 'KH', 'KHM', NULL, 'Khêt Siĕmréab-Ŏtâr Méanchey'), (1437, 'KH', 'KHM', NULL, 'Khétt Bântéay Méan Cheăy'), (1438, 'KH', 'KHM', NULL, 'Khétt Bătdâmbâng'), (1439, 'KH', 'KHM', NULL, 'Khétt Kâmpóng Cham'), (1440, 'KH', 'KHM', NULL, 'Khétt Kâmpóng Chhnăng'), (1441, 'KH', 'KHM', NULL, 'Khétt Kâmpóng Spœ'), (1442, 'KH', 'KHM', NULL, 'Khétt Kâmpóng Thum'), (1443, 'KH', 'KHM', NULL, 'Khétt Kâmpôt'), (1444, 'KH', 'KHM', NULL, 'Khétt Kândal'), (1445, 'KH', 'KHM', NULL, 'Khétt Kaôh Kŏng'), (1446, 'KH', 'KHM', NULL, 'Khétt Krâchéh'), (1447, 'KH', 'KHM', NULL, 'Khétt Môndôl Kiri'), (1448, 'KH', 'KHM', NULL, 'Khétt Poŭthĭsăt'), (1449, 'KH', 'KHM', NULL, 'Khétt Preăh Vĭhéar'), (1450, 'KH', 'KHM', NULL, 'Khétt Prey Vêng'), (1451, 'KH', 'KHM', NULL, 'Khétt Rôtânăh Kiri'), (1452, 'KH', 'KHM', NULL, 'Khétt Siĕm Réab'), (1453, 'KH', 'KHM', NULL, 'Khétt Stœ̆ng Trêng'), (1454, 'KH', 'KHM', NULL, 'Khétt Svay Riĕng'), (1455, 'KH', 'KHM', NULL, 'Khétt Takêv'), (1456, 'KH', 'KHM', NULL, 'Krŏng Phnum Pénh'), (1457, 'KH', 'KHM', NULL, 'Krŏng Preăh Seihânŭ'), (1458, 'KI', 'KIR', NULL, 'Gilbert Islands'), (1459, 'KI', 'KIR', NULL, 'Line Islands'), (1460, 'KM', 'COM', NULL, 'Anjouan'), (1461, 'KM', 'COM', NULL, 'Grande Comore'), (1462, 'KM', 'COM', NULL, 'Mohéli'), (1463, 'KN', 'KNA', NULL, 'Christ Church Nichola Town'), (1464, 'KN', 'KNA', NULL, 'Saint Anne Sandy Point'), (1465, 'KN', 'KNA', NULL, 'Saint George Basseterre'), (1466, 'KN', 'KNA', NULL, 'Saint George Gingerland'), (1467, 'KN', 'KNA', NULL, 'Saint James Windward'), (1468, 'KN', 'KNA', NULL, 'Saint John Capesterre'), (1469, 'KN', 'KNA', NULL, 'Saint John Figtree'), (1470, 'KN', 'KNA', NULL, 'Saint Mary Cayon'), (1471, 'KN', 'KNA', NULL, 'Saint Paul Capesterre'), (1472, 'KN', 'KNA', NULL, 'Saint Paul Charlestown'), (1473, 'KN', 'KNA', NULL, 'Saint Peter Basseterre'), (1474, 'KN', 'KNA', NULL, 'Saint Thomas Lowland'), (1475, 'KN', 'KNA', NULL, 'Saint Thomas Middle Island'), (1476, 'KN', 'KNA', NULL, 'Trinity Palmetto Point'), (1477, 'KP', 'PRK', NULL, 'Chagang-do'), (1478, 'KP', 'PRK', NULL, 'Gangwon'), (1479, 'KP', 'PRK', NULL, 'Hamgyŏng-bukto'), (1480, 'KP', 'PRK', NULL, 'Hamgyŏng-namdo'), (1481, 'KP', 'PRK', NULL, 'Hwanghae-bukto'), (1482, 'KP', 'PRK', NULL, 'Hwanghae-namdo'), (1483, 'KP', 'PRK', NULL, 'Kaesŏng-si'), (1484, 'KP', 'PRK', NULL, 'Najin Sŏnbong-si'), (1485, 'KP', 'PRK', NULL, 'Namp’o-si'), (1486, 'KP', 'PRK', NULL, 'P’yŏngan-bukto'), (1487, 'KP', 'PRK', NULL, 'P’yŏngan-namdo'), (1488, 'KP', 'PRK', NULL, 'P’yŏngyang-si'), (1489, 'KP', 'PRK', NULL, 'Yanggang-do'), (1490, 'KR', 'KOR', NULL, 'Busan'), (1491, 'KR', 'KOR', NULL, 'Daegu'), (1492, 'KR', 'KOR', NULL, 'Daejeon'), (1493, 'KR', 'KOR', NULL, 'Gangwon'), (1494, 'KR', 'KOR', NULL, 'Gwangju'), (1495, 'KR', 'KOR', NULL, 'Gyeonggi'), (1496, 'KR', 'KOR', NULL, 'Incheon'), (1497, 'KR', 'KOR', NULL, 'Jeju'), (1498, 'KR', 'KOR', NULL, 'North Chungcheong'), (1499, 'KR', 'KOR', NULL, 'North Gyeongsang'), (1500, 'KR', 'KOR', NULL, 'North Jeolla'), (1501, 'KR', 'KOR', NULL, 'Seoul'), (1502, 'KR', 'KOR', NULL, 'South Chungcheong'), (1503, 'KR', 'KOR', NULL, 'South Gyeongsang'), (1504, 'KR', 'KOR', NULL, 'South Jeolla'), (1505, 'KR', 'KOR', NULL, 'Ulsan'), (1506, 'KW', 'KWT', NULL, 'Al Farwaniyah'), (1507, 'KW', 'KWT', NULL, 'Muḩāfaz̧at al `Āşimah'), (1508, 'KW', 'KWT', NULL, 'Muḩāfaz̧at al Aḩmadī'), (1509, 'KW', 'KWT', NULL, 'Muḩāfaz̧at Ḩawallī'), (1510, 'KW', 'KWT', NULL, 'Muḩāfaz̧at Jahrā\''), (1511, 'KW', 'KWT', NULL, 'Muḩāfaz̧atalWafrah'), (1512, 'KZ', 'KAZ', NULL, 'Akmolinskaya Oblast\''), (1513, 'KZ', 'KAZ', NULL, 'Almatinskaya Oblast\''), (1514, 'KZ', 'KAZ', NULL, 'Aqtöbe Oblysy'), (1515, 'KZ', 'KAZ', NULL, 'Atyraū Oblysy'), (1516, 'KZ', 'KAZ', NULL, 'Batys Qazaqstan Oblysy'), (1517, 'KZ', 'KAZ', NULL, 'East Kazakhstan'), (1518, 'KZ', 'KAZ', NULL, 'Gorod Almaty'), (1519, 'KZ', 'KAZ', NULL, 'Gorod Astana'), (1520, 'KZ', 'KAZ', NULL, 'Kökshetaū Oblysy'), (1521, 'KZ', 'KAZ', NULL, 'Kostanayskaya Oblast\''), (1522, 'KZ', 'KAZ', NULL, 'Mangghystaū Oblysy'), (1523, 'KZ', 'KAZ', NULL, 'Pavlodar Oblysy'), (1524, 'KZ', 'KAZ', NULL, 'Qaraghandy Oblysy'), (1525, 'KZ', 'KAZ', NULL, 'Qyzylorda Oblysy'), (1526, 'KZ', 'KAZ', NULL, 'Semey Oblysy'), (1527, 'KZ', 'KAZ', NULL, 'Severo-Kazakhstanskaya Oblast\''), (1528, 'KZ', 'KAZ', NULL, 'Taldyqorghan Oblysy'), (1529, 'KZ', 'KAZ', NULL, 'Torghay Oblysy'), (1530, 'KZ', 'KAZ', NULL, 'Yuzhno-Kazakhstanskaya Oblast\''), (1531, 'KZ', 'KAZ', NULL, 'Zhambyl Oblysy'), (1532, 'KZ', 'KAZ', NULL, 'Zhezqazghan Oblysy'), (1533, 'LA', 'LAO', NULL, 'Kamphèng Nakhon Viangchan'), (1534, 'LA', 'LAO', NULL, 'Khétphisét Xaisômboun'), (1535, 'LA', 'LAO', NULL, 'Khouèng Attapu'), (1536, 'LA', 'LAO', NULL, 'Khouèng Bokéo'), (1537, 'LA', 'LAO', NULL, 'Khouèng Bolikhamxai'), (1538, 'LA', 'LAO', NULL, 'Khouèng Champasak'), (1539, 'LA', 'LAO', NULL, 'Khouèng Houaphan'), (1540, 'LA', 'LAO', NULL, 'Khouèng Khammouan'), (1541, 'LA', 'LAO', NULL, 'Khouèng Louangnamtha'), (1542, 'LA', 'LAO', NULL, 'Khouèng Louangphrabang'), (1543, 'LA', 'LAO', NULL, 'Khouèng Oudômxai'), (1544, 'LA', 'LAO', NULL, 'Khouèng Phôngsali'), (1545, 'LA', 'LAO', NULL, 'Khouèng Salavan'), (1546, 'LA', 'LAO', NULL, 'Khouèng Savannakhét'), (1547, 'LA', 'LAO', NULL, 'Khouèng Viangchan'), (1548, 'LA', 'LAO', NULL, 'Khouèng Xaignabouli'), (1549, 'LA', 'LAO', NULL, 'Khouèng Xékong'), (1550, 'LA', 'LAO', NULL, 'Khouèng Xiangkhoang'), (1551, 'LB', 'LBN', NULL, 'Mohafazat Aakâr'), (1552, 'LB', 'LBN', NULL, 'Mohafazat Baalbek-Hermel'), (1553, 'LB', 'LBN', NULL, 'Mohafazat Béqaa'), (1554, 'LB', 'LBN', NULL, 'Mohafazat Beyrouth'), (1555, 'LB', 'LBN', NULL, 'Mohafazat Liban-Nord'), (1556, 'LB', 'LBN', NULL, 'Mohafazat Liban-Sud'), (1557, 'LB', 'LBN', NULL, 'Mohafazat Mont-Liban'), (1558, 'LB', 'LBN', NULL, 'Mohafazat Nabatîyé'), (1559, 'LC', 'LCA', NULL, 'Quarter of Anse-la-Raye'), (1560, 'LC', 'LCA', NULL, 'Quarter of Castries'), (1561, 'LC', 'LCA', NULL, 'Quarter of Choiseul'), (1562, 'LC', 'LCA', NULL, 'Quarter of Dauphin'), (1563, 'LC', 'LCA', NULL, 'Quarter of Dennery'), (1564, 'LC', 'LCA', NULL, 'Quarter of Gros-Islet'), (1565, 'LC', 'LCA', NULL, 'Quarter of Laborie'), (1566, 'LC', 'LCA', NULL, 'Quarter of Micoud'), (1567, 'LC', 'LCA', NULL, 'Quarter of Praslin'), (1568, 'LC', 'LCA', NULL, 'Quarter of Soufrière'), (1569, 'LC', 'LCA', NULL, 'Quarter of Vieux-Fort'), (1570, 'LI', 'LIE', NULL, 'Gemeinde Balzers'), (1571, 'LI', 'LIE', NULL, 'Gemeinde Eschen'), (1572, 'LI', 'LIE', NULL, 'Gemeinde Gamprin'), (1573, 'LI', 'LIE', NULL, 'Gemeinde Mauren'), (1574, 'LI', 'LIE', NULL, 'Gemeinde Planken'), (1575, 'LI', 'LIE', NULL, 'Gemeinde Ruggell'), (1576, 'LI', 'LIE', NULL, 'Gemeinde Schaan'), (1577, 'LI', 'LIE', NULL, 'Gemeinde Schellenberg'), (1578, 'LI', 'LIE', NULL, 'Gemeinde Triesen'), (1579, 'LI', 'LIE', NULL, 'Gemeinde Triesenberg'), (1580, 'LI', 'LIE', NULL, 'Gemeinde Vaduz'), (1581, 'LK', 'LKA', NULL, 'Central Province'), (1582, 'LK', 'LKA', NULL, 'North Central Province'), (1583, 'LK', 'LKA', NULL, 'North Eastern Province'), (1584, 'LK', 'LKA', NULL, 'North Western Province'), (1585, 'LK', 'LKA', NULL, 'Province of Sabaragamuwa'), (1586, 'LK', 'LKA', NULL, 'Province of Uva'), (1587, 'LK', 'LKA', NULL, 'Southern Province'), (1588, 'LK', 'LKA', NULL, 'Western Province'), (1589, 'LR', 'LBR', NULL, 'Bomi County'), (1590, 'LR', 'LBR', NULL, 'Bong County'), (1591, 'LR', 'LBR', NULL, 'Gbarpolu County'), (1592, 'LR', 'LBR', NULL, 'Grand Bassa County'), (1593, 'LR', 'LBR', NULL, 'Grand Cape Mount County'), (1594, 'LR', 'LBR', NULL, 'Grand Gedeh County'), (1595, 'LR', 'LBR', NULL, 'Grand Kru County'), (1596, 'LR', 'LBR', NULL, 'Lofa County'), (1597, 'LR', 'LBR', NULL, 'Margibi County'), (1598, 'LR', 'LBR', NULL, 'Maryland County'), (1599, 'LR', 'LBR', NULL, 'Montserrado County'), (1600, 'LR', 'LBR', NULL, 'Nimba County'), (1601, 'LR', 'LBR', NULL, 'River Cess County'), (1602, 'LR', 'LBR', NULL, 'River Gee County'), (1603, 'LR', 'LBR', NULL, 'Sinoe County'), (1604, 'LS', 'LSO', NULL, 'Berea District'), (1605, 'LS', 'LSO', NULL, 'Butha-Buthe District'), (1606, 'LS', 'LSO', NULL, 'Leribe District'), (1607, 'LS', 'LSO', NULL, 'Mafeteng District'), (1608, 'LS', 'LSO', NULL, 'Maseru District'), (1609, 'LS', 'LSO', NULL, 'Mohale\'s Hoek District'), (1610, 'LS', 'LSO', NULL, 'Mokhotlong District'), (1611, 'LS', 'LSO', NULL, 'Qacha\'s Nek District'), (1612, 'LS', 'LSO', NULL, 'Quthing District'), (1613, 'LS', 'LSO', NULL, 'Thaba-Tseka District'), (1614, 'LT', 'LTU', NULL, 'Alytaus Apskritis'), (1615, 'LT', 'LTU', NULL, 'Kauno Apskritis'), (1616, 'LT', 'LTU', NULL, 'Klaipėdos Apskritis'), (1617, 'LT', 'LTU', NULL, 'Marijampolės Apskritis'), (1618, 'LT', 'LTU', NULL, 'Panevėžio Apskritis'), (1619, 'LT', 'LTU', NULL, 'Šiaulių Apskritis'), (1620, 'LT', 'LTU', NULL, 'Tauragės Apskritis'), (1621, 'LT', 'LTU', NULL, 'Telšių Apskritis'), (1622, 'LT', 'LTU', NULL, 'Utenos Apskritis'), (1623, 'LT', 'LTU', NULL, 'Vilniaus Apskritis'), (1624, 'LU', 'LUX', NULL, 'District de Diekirch'), (1625, 'LU', 'LUX', NULL, 'District de Grevenmacher'), (1626, 'LU', 'LUX', NULL, 'District de Luxembourg'), (1627, 'LV', 'LVA', NULL, 'Aizkraukles Rajons'), (1628, 'LV', 'LVA', NULL, 'Alūksnes Rajons'), (1629, 'LV', 'LVA', NULL, 'Balvu Rajons'), (1630, 'LV', 'LVA', NULL, 'Bauskas Rajons'), (1631, 'LV', 'LVA', NULL, 'Cēsu Rajons'), (1632, 'LV', 'LVA', NULL, 'Daugavpils'), (1633, 'LV', 'LVA', NULL, 'Daugavpils Rajons'), (1634, 'LV', 'LVA', NULL, 'Dobeles Rajons'), (1635, 'LV', 'LVA', NULL, 'Gulbenes Rajons'), (1636, 'LV', 'LVA', NULL, 'Jēkabpils Rajons'), (1637, 'LV', 'LVA', NULL, 'Jelgava'), (1638, 'LV', 'LVA', NULL, 'Jelgavas Rajons'), (1639, 'LV', 'LVA', NULL, 'Jūrmala'), (1640, 'LV', 'LVA', NULL, 'Krāslavas Rajons'), (1641, 'LV', 'LVA', NULL, 'Kuldīgas Rajons'), (1642, 'LV', 'LVA', NULL, 'Liepāja'), (1643, 'LV', 'LVA', NULL, 'Liepājas Rajons'), (1644, 'LV', 'LVA', NULL, 'Limbažu Rajons'), (1645, 'LV', 'LVA', NULL, 'Ludzas Rajons'), (1646, 'LV', 'LVA', NULL, 'Madonas Rajons'), (1647, 'LV', 'LVA', NULL, 'Ogres Rajons'), (1648, 'LV', 'LVA', NULL, 'Preiļu Rajons'), (1649, 'LV', 'LVA', NULL, 'Rēzekne'), (1650, 'LV', 'LVA', NULL, 'Rēzeknes Rajons'), (1651, 'LV', 'LVA', NULL, 'Rīga'), (1652, 'LV', 'LVA', NULL, 'Rīgas Rajons'), (1653, 'LV', 'LVA', NULL, 'Saldus Rajons'), (1654, 'LV', 'LVA', NULL, 'Talsu Rajons'), (1655, 'LV', 'LVA', NULL, 'Tukuma Rajons'), (1656, 'LV', 'LVA', NULL, 'Valkas Rajons'), (1657, 'LV', 'LVA', NULL, 'Valmieras Rajons'), (1658, 'LV', 'LVA', NULL, 'Ventspils'), (1659, 'LV', 'LVA', NULL, 'Ventspils Rajons'), (1660, 'LY', 'LBY', NULL, 'Baladīyat Ajdābiyā'), (1661, 'LY', 'LBY', NULL, 'Baladīyat al `Azīzīyah'), (1662, 'LY', 'LBY', NULL, 'Baladīyat al `Ujaylāt'), (1663, 'LY', 'LBY', NULL, 'Baladīyat al Abyār'), (1664, 'LY', 'LBY', NULL, 'Baladīyat al Bayḑā\''), (1665, 'LY', 'LBY', NULL, 'Baladīyat al Fātiḩ'), (1666, 'LY', 'LBY', NULL, 'Baladīyat al Jabal al Akhḑar'), (1667, 'LY', 'LBY', NULL, 'Baladīyat al Jufrah'), (1668, 'LY', 'LBY', NULL, 'Baladīyat al Jumayl'), (1669, 'LY', 'LBY', NULL, 'Baladīyat al Khums'), (1670, 'LY', 'LBY', NULL, 'Baladīyat al Kufrah'), (1671, 'LY', 'LBY', NULL, 'Baladīyat al Marj'), (1672, 'LY', 'LBY', NULL, 'Baladīyat al Qarābūll'), (1673, 'LY', 'LBY', NULL, 'Baladīyat al Qubbah'), (1674, 'LY', 'LBY', NULL, 'Baladīyat an Nuqāţ al Khams'), (1675, 'LY', 'LBY', NULL, 'Baladīyat ash Shāţi\''), (1676, 'LY', 'LBY', NULL, 'Baladīyat Awbārī'), (1677, 'LY', 'LBY', NULL, 'Baladīyat az Zahrā\''), (1678, 'LY', 'LBY', NULL, 'Baladīyat az Zāwiyah'), (1679, 'LY', 'LBY', NULL, 'Baladīyat Banghāzī'), (1680, 'LY', 'LBY', NULL, 'Baladīyat Banī Walīd'), (1681, 'LY', 'LBY', NULL, 'Baladīyat Bin Jawwād'), (1682, 'LY', 'LBY', NULL, 'Baladīyat Darnah'), (1683, 'LY', 'LBY', NULL, 'Baladīyat Ghadāmis'), (1684, 'LY', 'LBY', NULL, 'Baladīyat Gharyān'), (1685, 'LY', 'LBY', NULL, 'Baladīyat Ghāt'), (1686, 'LY', 'LBY', NULL, 'Baladīyat Jādū'), (1687, 'LY', 'LBY', NULL, 'Baladīyat Jālū'), (1688, 'LY', 'LBY', NULL, 'Baladīyat Janzūr'), (1689, 'LY', 'LBY', NULL, 'Baladīyat Mişrātah'), (1690, 'LY', 'LBY', NULL, 'Baladīyat Mizdah'), (1691, 'LY', 'LBY', NULL, 'Baladīyat Murzuq'), (1692, 'LY', 'LBY', NULL, 'Baladīyat Nālūt'), (1693, 'LY', 'LBY', NULL, 'Baladīyat Qamīnis'), (1694, 'LY', 'LBY', NULL, 'Baladīyat Qaşr Bin Ghashīr'), (1695, 'LY', 'LBY', NULL, 'Baladīyat Sabhā'), (1696, 'LY', 'LBY', NULL, 'Baladīyat Şabrātah'), (1697, 'LY', 'LBY', NULL, 'Baladīyat Sawfajjīn'), (1698, 'LY', 'LBY', NULL, 'Baladīyat Shaḩḩāt'), (1699, 'LY', 'LBY', NULL, 'Baladīyat Şurmān'), (1700, 'LY', 'LBY', NULL, 'Baladīyat Surt'), (1701, 'LY', 'LBY', NULL, 'Baladīyat Ţarābulus'), (1702, 'LY', 'LBY', NULL, 'Baladīyat Tarhūnah'), (1703, 'LY', 'LBY', NULL, 'Baladīyat Ţubruq'), (1704, 'LY', 'LBY', NULL, 'Baladīyat Tūkrah'), (1705, 'LY', 'LBY', NULL, 'Baladīyat Yafran'), (1706, 'LY', 'LBY', NULL, 'Baladīyat Zlīţan'), (1707, 'LY', 'LBY', NULL, 'Baladīyat Zuwārah'), (1708, 'MA', 'MAR', NULL, 'Laâyoune-Boujdour-Sakia El Hamra'), (1709, 'MA', 'MAR', NULL, 'Région de Chaouia-Ouardigha'), (1710, 'MA', 'MAR', NULL, 'Région de Doukkala-Abda'), (1711, 'MA', 'MAR', NULL, 'Région de Fès-Boulemane'), (1712, 'MA', 'MAR', NULL, 'Région de Gharb-Chrarda-Beni Hssen'), (1713, 'MA', 'MAR', NULL, 'Région de Guelmim-Es Smara'), (1714, 'MA', 'MAR', NULL, 'Région de l\' Oriental'), (1715, 'MA', 'MAR', NULL, 'Région de Marrakech-Tensift-Al Haouz'), (1716, 'MA', 'MAR', NULL, 'Région de Meknès-Tafilalet'), (1717, 'MA', 'MAR', NULL, 'Région de Rabat-Salé-Zemmour-Zaër'), (1718, 'MA', 'MAR', NULL, 'Région de Souss-Massa-Drâa'), (1719, 'MA', 'MAR', NULL, 'Région de Tadla-Azilal'), (1720, 'MA', 'MAR', NULL, 'Région de Tanger-Tétouan'), (1721, 'MA', 'MAR', NULL, 'Région de Taza-Al Hoceima-Taounate'), (1722, 'MA', 'MAR', NULL, 'Région du Grand Casablanca'), (1723, 'MC', 'MCO', NULL, 'Commune de Monaco'), (1724, 'MD', 'MDA', NULL, 'Balti Judetul'), (1725, 'MD', 'MDA', NULL, 'Cahul Judetul'), (1726, 'MD', 'MDA', NULL, 'Cainari Raionul'), (1727, 'MD', 'MDA', NULL, 'Camenca Raionul'), (1728, 'MD', 'MDA', NULL, 'Ceadîr-Lunga Raionul'), (1729, 'MD', 'MDA', NULL, 'Comrat Raionul'), (1730, 'MD', 'MDA', NULL, 'Edinet Judetul'), (1731, 'MD', 'MDA', NULL, 'Grigoriopol Raionul'), (1732, 'MD', 'MDA', NULL, 'Lapusna Judetul'), (1733, 'MD', 'MDA', NULL, 'Municipiul Bender'), (1734, 'MD', 'MDA', NULL, 'Municipiul Chişinău'), (1735, 'MD', 'MDA', NULL, 'Municipul Bălţi'), (1736, 'MD', 'MDA', NULL, 'Orhei Judetul'), (1737, 'MD', 'MDA', NULL, 'Raionul Anenii Noi'), (1738, 'MD', 'MDA', NULL, 'Raionul Basarabeasca'), (1739, 'MD', 'MDA', NULL, 'Raionul Briceni'), (1740, 'MD', 'MDA', NULL, 'Raionul Cahul'), (1741, 'MD', 'MDA', NULL, 'Raionul Călăraşi'), (1742, 'MD', 'MDA', NULL, 'Raionul Cantemir'), (1743, 'MD', 'MDA', NULL, 'Raionul Căuşeni'), (1744, 'MD', 'MDA', NULL, 'Raionul Cimişlia'), (1745, 'MD', 'MDA', NULL, 'Raionul Criuleni'), (1746, 'MD', 'MDA', NULL, 'Raionul Donduşeni'), (1747, 'MD', 'MDA', NULL, 'Raionul Drochia'), (1748, 'MD', 'MDA', NULL, 'Raionul Dubăsari'), (1749, 'MD', 'MDA', NULL, 'Raionul Edineţ'), (1750, 'MD', 'MDA', NULL, 'Raionul Făleşti'), (1751, 'MD', 'MDA', NULL, 'Raionul Floreşti'), (1752, 'MD', 'MDA', NULL, 'Raionul Glodeni'), (1753, 'MD', 'MDA', NULL, 'Raionul Hînceşti'), (1754, 'MD', 'MDA', NULL, 'Raionul Ialoveni'), (1755, 'MD', 'MDA', NULL, 'Raionul Leova'), (1756, 'MD', 'MDA', NULL, 'Raionul Nisporeni'), (1757, 'MD', 'MDA', NULL, 'Raionul Ocniţa'), (1758, 'MD', 'MDA', NULL, 'Raionul Orhei'), (1759, 'MD', 'MDA', NULL, 'Raionul Rezina'), (1760, 'MD', 'MDA', NULL, 'Raionul Rîşcani'), (1761, 'MD', 'MDA', NULL, 'Raionul Sîngerei'), (1762, 'MD', 'MDA', NULL, 'Raionul Şoldăneşti'), (1763, 'MD', 'MDA', NULL, 'Raionul Soroca'), (1764, 'MD', 'MDA', NULL, 'Raionul Ştefan-Vodă'), (1765, 'MD', 'MDA', NULL, 'Raionul Străşeni'), (1766, 'MD', 'MDA', NULL, 'Raionul Taraclia'), (1767, 'MD', 'MDA', NULL, 'Raionul Teleneşti'), (1768, 'MD', 'MDA', NULL, 'Raionul Ungheni'), (1769, 'MD', 'MDA', NULL, 'Rîbnita Raionul'), (1770, 'MD', 'MDA', NULL, 'Slobozia Raionul'), (1771, 'MD', 'MDA', NULL, 'Soroca Judetul'), (1772, 'MD', 'MDA', NULL, 'Tighina Judetul'), (1773, 'MD', 'MDA', NULL, 'Tiraspol Municipiul'), (1774, 'MD', 'MDA', NULL, 'Ungheni Judetul'), (1775, 'MD', 'MDA', NULL, 'Unitate Teritorială Autonomă Găgăuzia'), (1776, 'MD', 'MDA', NULL, 'Unitatea Teritorială din Stînga Nistrului'), (1777, 'MD', 'MDA', NULL, 'Vulcanes Raionul'), (1778, 'ME', 'MNE', NULL, 'Opština Andrijevica'), (1779, 'ME', 'MNE', NULL, 'Opština Bar'), (1780, 'ME', 'MNE', NULL, 'Opština Berane'), (1781, 'ME', 'MNE', NULL, 'Opština Bijelo Polje'), (1782, 'ME', 'MNE', NULL, 'Opština Budva'), (1783, 'ME', 'MNE', NULL, 'Opština Cetinje'), (1784, 'ME', 'MNE', NULL, 'Opština Danilovgrad'), (1785, 'ME', 'MNE', NULL, 'Opština Herceg-Novi'), (1786, 'ME', 'MNE', NULL, 'Opština Kolašin'), (1787, 'ME', 'MNE', NULL, 'Opština Kotor'), (1788, 'ME', 'MNE', NULL, 'Opština Mojkovac'), (1789, 'ME', 'MNE', NULL, 'Opština Nikšić'), (1790, 'ME', 'MNE', NULL, 'Opština Pljevlja'), (1791, 'ME', 'MNE', NULL, 'Opština Plužine'), (1792, 'ME', 'MNE', NULL, 'Opština Podgorica'), (1793, 'ME', 'MNE', NULL, 'Opština Šavnik'), (1794, 'ME', 'MNE', NULL, 'Opština Tivat'), (1795, 'ME', 'MNE', NULL, 'Opština Ulcinj'), (1796, 'ME', 'MNE', NULL, 'Opština Žabljak'), (1797, 'MG', 'MDG', NULL, 'Faritanin\' Antananarivo'), (1798, 'MG', 'MDG', NULL, 'Faritanin\' i Fianarantsoa'), (1799, 'MG', 'MDG', NULL, 'Faritanin\' i Mahajanga'), (1800, 'MG', 'MDG', NULL, 'Faritanin\' i Toamasina'), (1801, 'MG', 'MDG', NULL, 'Faritanin\' i Toliara'), (1802, 'MG', 'MDG', NULL, 'Faritany d\' Antsiranana'), (1803, 'MK', 'MKD', NULL, 'Opština Aračinovo'), (1804, 'MK', 'MKD', NULL, 'Opština Bač'), (1805, 'MK', 'MKD', NULL, 'Opština Belčišta'), (1806, 'MK', 'MKD', NULL, 'Opština Berovo'), (1807, 'MK', 'MKD', NULL, 'Opština Bistrica'), (1808, 'MK', 'MKD', NULL, 'Opština Bitola'), (1809, 'MK', 'MKD', NULL, 'Opština Blatec'), (1810, 'MK', 'MKD', NULL, 'Opština Bogdanci'), (1811, 'MK', 'MKD', NULL, 'Opstina Bogomila'), (1812, 'MK', 'MKD', NULL, 'Opština Bogovinje'), (1813, 'MK', 'MKD', NULL, 'Opština Bosilovo'), (1814, 'MK', 'MKD', NULL, 'Opština Brvenica'), (1815, 'MK', 'MKD', NULL, 'Opština Čair'), (1816, 'MK', 'MKD', NULL, 'Opština Capari'), (1817, 'MK', 'MKD', NULL, 'Opština Čaška'), (1818, 'MK', 'MKD', NULL, 'Opština Čegrane'), (1819, 'MK', 'MKD', NULL, 'Opština Centar Župa'), (1820, 'MK', 'MKD', NULL, 'Opština Češinovo'), (1821, 'MK', 'MKD', NULL, 'Opština Čučer-Sandevo'), (1822, 'MK', 'MKD', NULL, 'Opština Debar'), (1823, 'MK', 'MKD', NULL, 'Opština Delčevo'), (1824, 'MK', 'MKD', NULL, 'Opština Delogoždi'), (1825, 'MK', 'MKD', NULL, 'Opština Demir Hisar'), (1826, 'MK', 'MKD', NULL, 'Opština Demir Kapija'), (1827, 'MK', 'MKD', NULL, 'Opština Dobruševo'), (1828, 'MK', 'MKD', NULL, 'Opština Dolna Banjica'), (1829, 'MK', 'MKD', NULL, 'Opština Dolneni'), (1830, 'MK', 'MKD', NULL, 'Opština Drugovo'), (1831, 'MK', 'MKD', NULL, 'Opština Džepčište'), (1832, 'MK', 'MKD', NULL, 'Opština Gazi Baba'), (1833, 'MK', 'MKD', NULL, 'Opština Gevgelija'), (1834, 'MK', 'MKD', NULL, 'Opstina Gjorce Petrov'), (1835, 'MK', 'MKD', NULL, 'Opština Gostivar'), (1836, 'MK', 'MKD', NULL, 'Opština Gradsko'), (1837, 'MK', 'MKD', NULL, 'Opština Ilinden'), (1838, 'MK', 'MKD', NULL, 'Opština Izvor'), (1839, 'MK', 'MKD', NULL, 'Opština Jegunovce'), (1840, 'MK', 'MKD', NULL, 'Opština Kamenjane'), (1841, 'MK', 'MKD', NULL, 'Opština Karbinci'), (1842, 'MK', 'MKD', NULL, 'Opština Kavadarci'), (1843, 'MK', 'MKD', NULL, 'Opština Kičevo'), (1844, 'MK', 'MKD', NULL, 'Opština Kisela Voda'), (1845, 'MK', 'MKD', NULL, 'Opština Klečevce'), (1846, 'MK', 'MKD', NULL, 'Opština Kočani'), (1847, 'MK', 'MKD', NULL, 'Opština Konče'), (1848, 'MK', 'MKD', NULL, 'Opština Kondovo'), (1849, 'MK', 'MKD', NULL, 'Opština Konopište'), (1850, 'MK', 'MKD', NULL, 'Opština Kosel'), (1851, 'MK', 'MKD', NULL, 'Opština Kratovo'), (1852, 'MK', 'MKD', NULL, 'Opština Kriva Palanka'), (1853, 'MK', 'MKD', NULL, 'Opština Krivogaštani'), (1854, 'MK', 'MKD', NULL, 'Opština Kruševo'), (1855, 'MK', 'MKD', NULL, 'Opština Kukliš'), (1856, 'MK', 'MKD', NULL, 'Opština Kukurečani'), (1857, 'MK', 'MKD', NULL, 'Opština Kumanovo'), (1858, 'MK', 'MKD', NULL, 'Opština Labuništa'), (1859, 'MK', 'MKD', NULL, 'Opstina Lipkovo'), (1860, 'MK', 'MKD', NULL, 'Opština Lozovo'), (1861, 'MK', 'MKD', NULL, 'Opština Lukovo'), (1862, 'MK', 'MKD', NULL, 'Opština Makedonska Kamenica'), (1863, 'MK', 'MKD', NULL, 'Opština Makedonski Brod'), (1864, 'MK', 'MKD', NULL, 'Opština Mavrovi Anovi'), (1865, 'MK', 'MKD', NULL, 'Opština Mešeišta'), (1866, 'MK', 'MKD', NULL, 'Opština Miravci'), (1867, 'MK', 'MKD', NULL, 'Opština Mogila'), (1868, 'MK', 'MKD', NULL, 'Opština Murtino'), (1869, 'MK', 'MKD', NULL, 'Opština Negotino'), (1870, 'MK', 'MKD', NULL, 'Opština Negotino-Pološko'), (1871, 'MK', 'MKD', NULL, 'Opština Novaci'), (1872, 'MK', 'MKD', NULL, 'Opština Novo Selo'), (1873, 'MK', 'MKD', NULL, 'Opština Obleševo'), (1874, 'MK', 'MKD', NULL, 'Opština Ohrid'), (1875, 'MK', 'MKD', NULL, 'Opština Orašac'), (1876, 'MK', 'MKD', NULL, 'Opština Orizari'), (1877, 'MK', 'MKD', NULL, 'Opština Oslomej'), (1878, 'MK', 'MKD', NULL, 'Opština Pehčevo'), (1879, 'MK', 'MKD', NULL, 'Opština Petrovec'), (1880, 'MK', 'MKD', NULL, 'Opština Plasnica'), (1881, 'MK', 'MKD', NULL, 'Opština Podareš'), (1882, 'MK', 'MKD', NULL, 'Opština Prilep'), (1883, 'MK', 'MKD', NULL, 'Opština Probištip'), (1884, 'MK', 'MKD', NULL, 'Opština Radoviš'), (1885, 'MK', 'MKD', NULL, 'Opstina Rankovce'), (1886, 'MK', 'MKD', NULL, 'Opština Resen'), (1887, 'MK', 'MKD', NULL, 'Opština Rosoman'), (1888, 'MK', 'MKD', NULL, 'Opština Rostuša'), (1889, 'MK', 'MKD', NULL, 'Opština Samokov'), (1890, 'MK', 'MKD', NULL, 'Opština Saraj'), (1891, 'MK', 'MKD', NULL, 'Opština Šipkovica'), (1892, 'MK', 'MKD', NULL, 'Opština Sopište'), (1893, 'MK', 'MKD', NULL, 'Opština Sopotnica'), (1894, 'MK', 'MKD', NULL, 'Opština Srbinovo'), (1895, 'MK', 'MKD', NULL, 'Opština Star Dojran'), (1896, 'MK', 'MKD', NULL, 'Opština Staravina'), (1897, 'MK', 'MKD', NULL, 'Opština Staro Nagoričane'), (1898, 'MK', 'MKD', NULL, 'Opština Štip'), (1899, 'MK', 'MKD', NULL, 'Opština Struga'), (1900, 'MK', 'MKD', NULL, 'Opština Strumica'), (1901, 'MK', 'MKD', NULL, 'Opština Studeničani'), (1902, 'MK', 'MKD', NULL, 'Opština Šuto Orizari'), (1903, 'MK', 'MKD', NULL, 'Opština Sveti Nikole'), (1904, 'MK', 'MKD', NULL, 'Opština Tearce'), (1905, 'MK', 'MKD', NULL, 'Opština Tetovo'), (1906, 'MK', 'MKD', NULL, 'Opština Topolčani'), (1907, 'MK', 'MKD', NULL, 'Opština Valandovo'), (1908, 'MK', 'MKD', NULL, 'Opština Vasilevo'), (1909, 'MK', 'MKD', NULL, 'Opština Veles'), (1910, 'MK', 'MKD', NULL, 'Opština Velešta'), (1911, 'MK', 'MKD', NULL, 'Opština Vevčani'), (1912, 'MK', 'MKD', NULL, 'Opština Vinica'), (1913, 'MK', 'MKD', NULL, 'Opština Vitolište'), (1914, 'MK', 'MKD', NULL, 'Opština Vraneštica'), (1915, 'MK', 'MKD', NULL, 'Opština Vrapčište'), (1916, 'MK', 'MKD', NULL, 'Opština Vratnica'), (1917, 'MK', 'MKD', NULL, 'Opština Vrutok'), (1918, 'MK', 'MKD', NULL, 'Opština Zajas'), (1919, 'MK', 'MKD', NULL, 'Opština Zelenikovo'), (1920, 'MK', 'MKD', NULL, 'Opština Želino'), (1921, 'MK', 'MKD', NULL, 'Opština Žitoše'), (1922, 'MK', 'MKD', NULL, 'Opština Zletovo'), (1923, 'MK', 'MKD', NULL, 'Opština Zrnovci'), (1924, 'MK', 'MKD', NULL, 'Општина Карпош'), (1925, 'MK', 'MKD', NULL, 'Општина Центар'), (1926, 'ML', 'MLI', NULL, 'District de Bamako'), (1927, 'ML', 'MLI', NULL, 'Région de Gao'), (1928, 'ML', 'MLI', NULL, 'Région de Kayes'), (1929, 'ML', 'MLI', NULL, 'Région de Kidal'), (1930, 'ML', 'MLI', NULL, 'Région de Koulikoro'), (1931, 'ML', 'MLI', NULL, 'Région de Mopti'), (1932, 'ML', 'MLI', NULL, 'Région de Ségou'), (1933, 'ML', 'MLI', NULL, 'Région de Sikasso'), (1934, 'ML', 'MLI', NULL, 'Région de Tombouctou'), (1935, 'MM', 'MMR', NULL, 'Ayeyarwady Division'), (1936, 'MM', 'MMR', NULL, 'Bago Division'), (1937, 'MM', 'MMR', NULL, 'Chin State'), (1938, 'MM', 'MMR', NULL, 'Kachin State'), (1939, 'MM', 'MMR', NULL, 'Kayah State'), (1940, 'MM', 'MMR', NULL, 'Kayin State'), (1941, 'MM', 'MMR', NULL, 'Magway Division'), (1942, 'MM', 'MMR', NULL, 'Mandalay Division'), (1943, 'MM', 'MMR', NULL, 'Mon State'), (1944, 'MM', 'MMR', NULL, 'Rakhine State'), (1945, 'MM', 'MMR', NULL, 'Sagaing Division'), (1946, 'MM', 'MMR', NULL, 'Shan State'), (1947, 'MM', 'MMR', NULL, 'Tanintharyi Division'), (1948, 'MM', 'MMR', NULL, 'Yangon Division'), (1949, 'MN', 'MNG', NULL, 'Arhangay Aymag'), (1950, 'MN', 'MNG', NULL, 'Bayanhongor Aymag'), (1951, 'MN', 'MNG', NULL, 'Bayan-Ölgiy Aymag'), (1952, 'MN', 'MNG', NULL, 'Bulgan Aymag'), (1953, 'MN', 'MNG', NULL, 'Central Aymag'), (1954, 'MN', 'MNG', NULL, 'Darhan Hot (historical)'), (1955, 'MN', 'MNG', NULL, 'Dzavhan Aymag'), (1956, 'MN', 'MNG', NULL, 'East Gobi Aymag'), (1957, 'MN', 'MNG', NULL, 'Eastern'), (1958, 'MN', 'MNG', NULL, 'Erdenet Hot (historical)'), (1959, 'MN', 'MNG', NULL, 'Govĭ-Altay Aymag'), (1960, 'MN', 'MNG', NULL, 'Govĭ-Sumber'), (1961, 'MN', 'MNG', NULL, 'Hentiy Aymag'), (1962, 'MN', 'MNG', NULL, 'Hovd Aymag'), (1963, 'MN', 'MNG', NULL, 'Hövsgöl Aymag'), (1964, 'MN', 'MNG', NULL, 'Middle Govĭ'), (1965, 'MN', 'MNG', NULL, 'Selenge Aymag'), (1966, 'MN', 'MNG', NULL, 'South Gobi Aimak'), (1967, 'MN', 'MNG', NULL, 'South Hangay'), (1968, 'MN', 'MNG', NULL, 'Sühbaatar Aymag'), (1969, 'MN', 'MNG', NULL, 'Ulaanbaatar Hot'), (1970, 'MN', 'MNG', NULL, 'Uvs Aymag'), (1971, 'MN', 'MNG', NULL, 'Дархан-Уул Аймаг'), (1972, 'MN', 'MNG', NULL, 'Орхон Аймаг'), (1973, 'MO', 'MAC', NULL, 'Concelho das Ilhas'), (1974, 'MO', 'MAC', NULL, 'Concelho de Macau'), (1975, 'MQ', 'MTQ', NULL, 'Région Martinique'), (1976, 'MR', 'MRT', NULL, 'Nouakchott District de'), (1977, 'MR', 'MRT', NULL, 'Région de Dakhlet Nouadhibou'), (1978, 'MR', 'MRT', NULL, 'Région de l\' Adrar'), (1979, 'MR', 'MRT', NULL, 'Région de l\' Assaba'), (1980, 'MR', 'MRT', NULL, 'Région de l\' Inchiri'), (1981, 'MR', 'MRT', NULL, 'Région du Brakna'), (1982, 'MR', 'MRT', NULL, 'Région du Gorgol'), (1983, 'MR', 'MRT', NULL, 'Région du Guidimaka'), (1984, 'MR', 'MRT', NULL, 'Région du Hodh Ech Chargui'), (1985, 'MR', 'MRT', NULL, 'Région du Hodh El Gharbi'), (1986, 'MR', 'MRT', NULL, 'Région du Tagant'), (1987, 'MR', 'MRT', NULL, 'Région du Tiris Zemmour'), (1988, 'MR', 'MRT', NULL, 'Région du Trarza'), (1989, 'MS', 'MSR', NULL, 'Parish of Saint Anthony'), (1990, 'MS', 'MSR', NULL, 'Parish of Saint Georges'), (1991, 'MS', 'MSR', NULL, 'Parish of Saint Peter'), (1992, 'MU', 'MUS', NULL, 'Agalega Islands'), (1993, 'MU', 'MUS', NULL, 'Black River District'), (1994, 'MU', 'MUS', NULL, 'Cargados Carajos'), (1995, 'MU', 'MUS', NULL, 'Flacq District'), (1996, 'MU', 'MUS', NULL, 'Grand Port District'), (1997, 'MU', 'MUS', NULL, 'Moka District'), (1998, 'MU', 'MUS', NULL, 'Pamplemousses District'), (1999, 'MU', 'MUS', NULL, 'Plaines Wilhems District'), (2000, 'MU', 'MUS', NULL, 'Port Louis District'), (2001, 'MU', 'MUS', NULL, 'Rivière du Rempart District'), (2002, 'MU', 'MUS', NULL, 'Rodrigues'), (2003, 'MU', 'MUS', NULL, 'Savanne District'), (2004, 'MV', 'MDV', NULL, 'Alifu Atholhu'), (2005, 'MV', 'MDV', NULL, 'Baa Atholhu'), (2006, 'MV', 'MDV', NULL, 'Dhaalu Atholhu'), (2007, 'MV', 'MDV', NULL, 'Faafu Atholhu'), (2008, 'MV', 'MDV', NULL, 'Gaafu Alifu Atholhu'), (2009, 'MV', 'MDV', NULL, 'Gaafu Dhaalu Atholhu'), (2010, 'MV', 'MDV', NULL, 'Gnyaviyani Atoll'), (2011, 'MV', 'MDV', NULL, 'Haa Alifu Atholhu'), (2012, 'MV', 'MDV', NULL, 'Haa Dhaalu Atholhu'), (2013, 'MV', 'MDV', NULL, 'Laamu Atholhu'), (2014, 'MV', 'MDV', NULL, 'Lhaviyani Atholhu'), (2015, 'MV', 'MDV', NULL, 'Maale'), (2016, 'MV', 'MDV', NULL, 'Meemu Atholhu'), (2017, 'MV', 'MDV', NULL, 'Noonu Atholhu'), (2018, 'MV', 'MDV', NULL, 'Raa Atholhu'), (2019, 'MV', 'MDV', NULL, 'Seenu Atholhu'), (2020, 'MV', 'MDV', NULL, 'Shaviyani Atholhu'), (2021, 'MV', 'MDV', NULL, 'Thaa Atholhu'), (2022, 'MV', 'MDV', NULL, 'Vaavu Atholhu'), (2023, 'MW', 'MWI', NULL, 'Balaka District'), (2024, 'MW', 'MWI', NULL, 'Blantyre District'), (2025, 'MW', 'MWI', NULL, 'Chikwawa District'), (2026, 'MW', 'MWI', NULL, 'Chiradzulu District'), (2027, 'MW', 'MWI', NULL, 'Chitipa District'), (2028, 'MW', 'MWI', NULL, 'Dedza District'), (2029, 'MW', 'MWI', NULL, 'Dowa District'), (2030, 'MW', 'MWI', NULL, 'Karonga District'), (2031, 'MW', 'MWI', NULL, 'Kasungu District'), (2032, 'MW', 'MWI', NULL, 'Likoma District'), (2033, 'MW', 'MWI', NULL, 'Lilongwe District'), (2034, 'MW', 'MWI', NULL, 'Machinga District'), (2035, 'MW', 'MWI', NULL, 'Mangochi District'), (2036, 'MW', 'MWI', NULL, 'Mchinji District'), (2037, 'MW', 'MWI', NULL, 'Mulanje District'), (2038, 'MW', 'MWI', NULL, 'Mwanza District'), (2039, 'MW', 'MWI', NULL, 'Mzimba District'), (2040, 'MW', 'MWI', NULL, 'Nkhata Bay District'), (2041, 'MW', 'MWI', NULL, 'Nkhotakota District'), (2042, 'MW', 'MWI', NULL, 'Nsanje District'), (2043, 'MW', 'MWI', NULL, 'Ntcheu District'), (2044, 'MW', 'MWI', NULL, 'Ntchisi District'), (2045, 'MW', 'MWI', NULL, 'Phalombe District'), (2046, 'MW', 'MWI', NULL, 'Rumphi District'), (2047, 'MW', 'MWI', NULL, 'Salima District'), (2048, 'MW', 'MWI', NULL, 'Thyolo District'), (2049, 'MW', 'MWI', NULL, 'Zomba District'), (2050, 'MX', 'MEX', NULL, 'Aguascalientes'), (2051, 'MX', 'MEX', NULL, 'Baja California Sur'), (2052, 'MX', 'MEX', NULL, 'Campeche'), (2053, 'MX', 'MEX', NULL, 'Chiapas'), (2054, 'MX', 'MEX', NULL, 'Chihuahua'), (2055, 'MX', 'MEX', NULL, 'Coahuila'), (2056, 'MX', 'MEX', NULL, 'Colima'), (2057, 'MX', 'MEX', NULL, 'Durango'), (2058, 'MX', 'MEX', NULL, 'Estado de Baja California'), (2059, 'MX', 'MEX', NULL, 'Estado de México'), (2060, 'MX', 'MEX', NULL, 'Estado de Veracruz-Llave'), (2061, 'MX', 'MEX', NULL, 'Guanajuato'), (2062, 'MX', 'MEX', NULL, 'Guerrero'), (2063, 'MX', 'MEX', NULL, 'Hidalgo'), (2064, 'MX', 'MEX', NULL, 'Jalisco'), (2065, 'MX', 'MEX', NULL, 'Michoacán'), (2066, 'MX', 'MEX', NULL, 'Morelos'), (2067, 'MX', 'MEX', NULL, 'Nayarit'), (2068, 'MX', 'MEX', NULL, 'Nuevo León'), (2069, 'MX', 'MEX', NULL, 'Oaxaca'), (2070, 'MX', 'MEX', NULL, 'Puebla'), (2071, 'MX', 'MEX', NULL, 'Querétaro'), (2072, 'MX', 'MEX', NULL, 'Quintana Roo'), (2073, 'MX', 'MEX', NULL, 'San Luis Potosí'), (2074, 'MX', 'MEX', NULL, 'Sinaloa'), (2075, 'MX', 'MEX', NULL, 'Sonora'), (2076, 'MX', 'MEX', NULL, 'Tabasco'), (2077, 'MX', 'MEX', NULL, 'Tamaulipas'), (2078, 'MX', 'MEX', NULL, 'The Federal District'), (2079, 'MX', 'MEX', NULL, 'Tlaxcala'), (2080, 'MX', 'MEX', NULL, 'Yucatán'), (2081, 'MX', 'MEX', NULL, 'Zacatecas'), (2082, 'MY', 'MYS', NULL, 'Federal Territory of Labuan'), (2083, 'MY', 'MYS', NULL, 'Negeri Johor'), (2084, 'MY', 'MYS', NULL, 'Negeri Kedah'), (2085, 'MY', 'MYS', NULL, 'Negeri Kelantan'), (2086, 'MY', 'MYS', NULL, 'Negeri Melaka'), (2087, 'MY', 'MYS', NULL, 'Negeri Pahang'), (2088, 'MY', 'MYS', NULL, 'Negeri Perak'), (2089, 'MY', 'MYS', NULL, 'Negeri Perlis, Pauh'), (2090, 'MY', 'MYS', NULL, 'Negeri Pulau Pinang'), (2091, 'MY', 'MYS', NULL, 'Negeri Selangor'), (2092, 'MY', 'MYS', NULL, 'Negeri Sembilan'), (2093, 'MY', 'MYS', NULL, 'Negeri Terengganu'), (2094, 'MY', 'MYS', NULL, 'Putrajaya'), (2095, 'MY', 'MYS', NULL, 'State of Sabah'), (2096, 'MY', 'MYS', NULL, 'State of Sarawak'), (2097, 'MY', 'MYS', NULL, 'Wilayah Persekutuan Kuala Lumpur'), (2098, 'MZ', 'MOZ', NULL, 'Cidade de Maputo'), (2099, 'MZ', 'MOZ', NULL, 'Maputo Province'), (2100, 'MZ', 'MOZ', NULL, 'Província de Cabo Delgado'), (2101, 'MZ', 'MOZ', NULL, 'Província de Gaza'), (2102, 'MZ', 'MOZ', NULL, 'Província de Inhambane'), (2103, 'MZ', 'MOZ', NULL, 'Província de Manica'), (2104, 'MZ', 'MOZ', NULL, 'Província de Nampula'), (2105, 'MZ', 'MOZ', NULL, 'Província de Niassa'), (2106, 'MZ', 'MOZ', NULL, 'Província de Sofala'), (2107, 'MZ', 'MOZ', NULL, 'Província de Tete'), (2108, 'MZ', 'MOZ', NULL, 'Província de Zambézia'), (2109, 'NA', 'NAM', NULL, 'Bethanien'), (2110, 'NA', 'NAM', NULL, 'Caprivi'), (2111, 'NA', 'NAM', NULL, 'Caprivi Oos'), (2112, 'NA', 'NAM', NULL, 'Erongo'), (2113, 'NA', 'NAM', NULL, 'Hardap'), (2114, 'NA', 'NAM', NULL, 'Kaokoland'), (2115, 'NA', 'NAM', NULL, 'Karas'), (2116, 'NA', 'NAM', NULL, 'Kavango'), (2117, 'NA', 'NAM', NULL, 'Khomas'), (2118, 'NA', 'NAM', NULL, 'Kunene'), (2119, 'NA', 'NAM', NULL, 'Ohangwena'), (2120, 'NA', 'NAM', NULL, 'Okavango'), (2121, 'NA', 'NAM', NULL, 'Omaheke'), (2122, 'NA', 'NAM', NULL, 'Omusati'), (2123, 'NA', 'NAM', NULL, 'Oshana'), (2124, 'NA', 'NAM', NULL, 'Oshikoto'), (2125, 'NA', 'NAM', NULL, 'Otjiwarongo'), (2126, 'NA', 'NAM', NULL, 'Otjozondjupa'), (2127, 'NA', 'NAM', NULL, 'Outjo'), (2128, 'NA', 'NAM', NULL, 'Owambo'), (2129, 'NE', 'NER', NULL, 'Département d\' Agadez'), (2130, 'NE', 'NER', NULL, 'Département de Diffa'), (2131, 'NE', 'NER', NULL, 'Département de Dosso'), (2132, 'NE', 'NER', NULL, 'Département de Maradi'), (2133, 'NE', 'NER', NULL, 'Département de Tahoua'), (2134, 'NE', 'NER', NULL, 'Département de Tillabéri'), (2135, 'NE', 'NER', NULL, 'Département de Zinder'), (2136, 'NE', 'NER', NULL, 'Niamey'), (2137, 'NE', 'NER', NULL, 'Niamey Département de'), (2138, 'NG', 'NGA', NULL, 'Abia State'), (2139, 'NG', 'NGA', NULL, 'Abuja Federal Capital Territory'), (2140, 'NG', 'NGA', NULL, 'Adamawa State'), (2141, 'NG', 'NGA', NULL, 'Akwa Ibom State'), (2142, 'NG', 'NGA', NULL, 'Anambra State'), (2143, 'NG', 'NGA', NULL, 'Bauchi State'), (2144, 'NG', 'NGA', NULL, 'Bayelsa State'), (2145, 'NG', 'NGA', NULL, 'Bendel State'), (2146, 'NG', 'NGA', NULL, 'Benue State'), (2147, 'NG', 'NGA', NULL, 'Benue-Plateau State'), (2148, 'NG', 'NGA', NULL, 'Borno State'), (2149, 'NG', 'NGA', NULL, 'Cross River State'), (2150, 'NG', 'NGA', NULL, 'Delta State'), (2151, 'NG', 'NGA', NULL, 'East-Central State'), (2152, 'NG', 'NGA', NULL, 'Ebonyi State'), (2153, 'NG', 'NGA', NULL, 'Ekiti State'), (2154, 'NG', 'NGA', NULL, 'Ekpoma'), (2155, 'NG', 'NGA', NULL, 'Enugu State'), (2156, 'NG', 'NGA', NULL, 'Gombe State'), (2157, 'NG', 'NGA', NULL, 'Gongola State'), (2158, 'NG', 'NGA', NULL, 'Imo State'), (2159, 'NG', 'NGA', NULL, 'Jigawa State'), (2160, 'NG', 'NGA', NULL, 'Kaduna State'), (2161, 'NG', 'NGA', NULL, 'Kano State'), (2162, 'NG', 'NGA', NULL, 'Katsina State'), (2163, 'NG', 'NGA', NULL, 'Kebbi State'), (2164, 'NG', 'NGA', NULL, 'Kogi State'), (2165, 'NG', 'NGA', NULL, 'Kwara State'), (2166, 'NG', 'NGA', NULL, 'Lagos State'), (2167, 'NG', 'NGA', NULL, 'Nassarawa State'), (2168, 'NG', 'NGA', NULL, 'Niger State'), (2169, 'NG', 'NGA', NULL, 'North-Eastern State'), (2170, 'NG', 'NGA', NULL, 'North-Western State'), (2171, 'NG', 'NGA', NULL, 'Ogun State'), (2172, 'NG', 'NGA', NULL, 'Ondo State'), (2173, 'NG', 'NGA', NULL, 'Osun State'), (2174, 'NG', 'NGA', NULL, 'Oyo State'), (2175, 'NG', 'NGA', NULL, 'Plateau State'), (2176, 'NG', 'NGA', NULL, 'Rivers State'), (2177, 'NG', 'NGA', NULL, 'Sokoto State'), (2178, 'NG', 'NGA', NULL, 'Taraba State'), (2179, 'NG', 'NGA', NULL, 'Western State'), (2180, 'NG', 'NGA', NULL, 'Yobe State'), (2181, 'NG', 'NGA', NULL, 'Zamfara State'), (2182, 'NI', 'NIC', NULL, 'Departamento de Boaco'), (2183, 'NI', 'NIC', NULL, 'Departamento de Carazo'), (2184, 'NI', 'NIC', NULL, 'Departamento de Chinandega'), (2185, 'NI', 'NIC', NULL, 'Departamento de Chontales'), (2186, 'NI', 'NIC', NULL, 'Departamento de Estelí'), (2187, 'NI', 'NIC', NULL, 'Departamento de Granada'), (2188, 'NI', 'NIC', NULL, 'Departamento de Jinotega'), (2189, 'NI', 'NIC', NULL, 'Departamento de León'), (2190, 'NI', 'NIC', NULL, 'Departamento de Madriz'), (2191, 'NI', 'NIC', NULL, 'Departamento de Managua'), (2192, 'NI', 'NIC', NULL, 'Departamento de Masaya'), (2193, 'NI', 'NIC', NULL, 'Departamento de Matagalpa'), (2194, 'NI', 'NIC', NULL, 'Departamento de Nueva Segovia'), (2195, 'NI', 'NIC', NULL, 'Departamento de Río San Juan'), (2196, 'NI', 'NIC', NULL, 'Departamento de Rivas'), (2197, 'NI', 'NIC', NULL, 'Región Autónoma Atlántico Norte'); INSERT INTO `ma_DCountryState` (`id`, `countryId`, `countryIsoAlpha3`, `abbreviation`, `name`) VALUES (2198, 'NI', 'NIC', NULL, 'Región Autónoma Atlántico Sur'), (2199, 'NL', 'NLD', NULL, 'North Brabant'), (2200, 'NL', 'NLD', NULL, 'North Holland'), (2201, 'NL', 'NLD', NULL, 'Provincie Drenthe'), (2202, 'NL', 'NLD', NULL, 'Provincie Flevoland'), (2203, 'NL', 'NLD', NULL, 'Provincie Friesland'), (2204, 'NL', 'NLD', NULL, 'Provincie Gelderland'), (2205, 'NL', 'NLD', NULL, 'Provincie Groningen'), (2206, 'NL', 'NLD', NULL, 'Provincie Limburg'), (2207, 'NL', 'NLD', NULL, 'Provincie Overijssel'), (2208, 'NL', 'NLD', NULL, 'Provincie Utrecht'), (2209, 'NL', 'NLD', NULL, 'Provincie Zeeland'), (2210, 'NL', 'NLD', NULL, 'South Holland'), (2211, 'NO', 'NOR', NULL, 'Akershus Fylke'), (2212, 'NO', 'NOR', NULL, 'Aust-Agder Fylke'), (2213, 'NO', 'NOR', NULL, 'Bouvetøya '), (2214, 'NO', 'NOR', NULL, 'Buskerud Fylke'), (2215, 'NO', 'NOR', NULL, 'Finnmark Fylke'), (2216, 'NO', 'NOR', NULL, 'Hedmark Fylke'), (2217, 'NO', 'NOR', NULL, 'Hordaland Fylke'), (2218, 'NO', 'NOR', NULL, 'Jan Mayen'), (2219, 'NO', 'NOR', NULL, 'Møre og Romsdal Fylke'), (2220, 'NO', 'NOR', NULL, 'Nordland Fylke'), (2221, 'NO', 'NOR', NULL, 'Nord-Trøndelag Fylke'), (2222, 'NO', 'NOR', NULL, 'Oppland Fylke'), (2223, 'NO', 'NOR', NULL, 'Oslo Fylke'), (2224, 'NO', 'NOR', NULL, 'Østfold'), (2225, 'NO', 'NOR', NULL, 'Rogaland Fylke'), (2226, 'NO', 'NOR', NULL, 'Sogn og Fjordane Fylke'), (2227, 'NO', 'NOR', NULL, 'Sør-Trøndelag Fylke'), (2228, 'NO', 'NOR', NULL, 'Telemark Fylke'), (2229, 'NO', 'NOR', NULL, 'Troms Fylke'), (2230, 'NO', 'NOR', NULL, 'Vest-Agder Fylke'), (2231, 'NO', 'NOR', NULL, 'Vestfold Fylke'), (2232, 'NP', 'NPL', NULL, 'Bāgmatī Zone'), (2233, 'NP', 'NPL', NULL, 'Bherī Zone'), (2234, 'NP', 'NPL', NULL, 'Dhawalāgiri Zone'), (2235, 'NP', 'NPL', NULL, 'Gandakī Zone'), (2236, 'NP', 'NPL', NULL, 'Janakpur Zone'), (2237, 'NP', 'NPL', NULL, 'Karnālī Zone'), (2238, 'NP', 'NPL', NULL, 'Kosī Zone'), (2239, 'NP', 'NPL', NULL, 'Lumbinī Zone'), (2240, 'NP', 'NPL', NULL, 'Mahākālī Zone'), (2241, 'NP', 'NPL', NULL, 'Mechī Zone'), (2242, 'NP', 'NPL', NULL, 'Nārāyanī Zone'), (2243, 'NP', 'NPL', NULL, 'Rāptī Zone'), (2244, 'NP', 'NPL', NULL, 'Sagarmāthā Zone'), (2245, 'NP', 'NPL', NULL, 'Setī Zone'), (2246, 'NZ', 'NZL', NULL, 'Auckland'), (2247, 'NZ', 'NZL', NULL, 'Bay of Plenty'), (2248, 'NZ', 'NZL', NULL, 'Canterbury'), (2249, 'NZ', 'NZL', NULL, 'Chatham Islands'), (2250, 'NZ', 'NZL', NULL, 'Gisborne'), (2251, 'NZ', 'NZL', NULL, 'Hawkes Bay'), (2252, 'NZ', 'NZL', NULL, 'Marlborough'), (2253, 'NZ', 'NZL', NULL, 'Nelson'), (2254, 'NZ', 'NZL', NULL, 'Otago'), (2255, 'NZ', 'NZL', NULL, 'Southland'), (2256, 'NZ', 'NZL', NULL, 'Taranaki'), (2257, 'NZ', 'NZL', NULL, 'Waikato'), (2258, 'NZ', 'NZL', NULL, 'Wanganui'), (2259, 'NZ', 'NZL', NULL, 'Wellington'), (2260, 'NZ', 'NZL', NULL, 'West Coast'), (2261, 'NZ', 'NZL', NULL, 'Whangarei'), (2262, 'OM', 'OMN', NULL, 'Al Minţaqah ad Dākhilīyah'), (2263, 'OM', 'OMN', NULL, 'Al Minţaqah al Wusţá'), (2264, 'OM', 'OMN', NULL, 'Al Minţaqah ash Sharqīyah'), (2265, 'OM', 'OMN', NULL, 'Minţaqat al Bāţinah'), (2266, 'OM', 'OMN', NULL, 'Minţaqat az̧ Z̧āhirah'), (2267, 'OM', 'OMN', NULL, 'Minţaqat Masqaţ'), (2268, 'OM', 'OMN', NULL, 'Muḩāfaz̧at Z̧ufār'), (2269, 'PA', 'PAN', NULL, 'Comarca de San Blas'), (2270, 'PA', 'PAN', NULL, 'Provincia de Bocas del Toro'), (2271, 'PA', 'PAN', NULL, 'Provincia de Chiriquí'), (2272, 'PA', 'PAN', NULL, 'Provincia de Coclé'), (2273, 'PA', 'PAN', NULL, 'Provincia de Colón'), (2274, 'PA', 'PAN', NULL, 'Provincia de Herrera'), (2275, 'PA', 'PAN', NULL, 'Provincia de Los Santos'), (2276, 'PA', 'PAN', NULL, 'Provincia de Panamá'), (2277, 'PA', 'PAN', NULL, 'Provincia de Veraguas'), (2278, 'PA', 'PAN', NULL, 'Provincia del Darién'), (2279, 'PE', 'PER', NULL, 'Departamento de Amazonas'), (2280, 'PE', 'PER', NULL, 'Departamento de Ancash'), (2281, 'PE', 'PER', NULL, 'Departamento de Apurímac'), (2282, 'PE', 'PER', NULL, 'Departamento de Arequipa'), (2283, 'PE', 'PER', NULL, 'Departamento de Ayacucho'), (2284, 'PE', 'PER', NULL, 'Departamento de Cajamarca'), (2285, 'PE', 'PER', NULL, 'Departamento de Cusco'), (2286, 'PE', 'PER', NULL, 'Departamento de Huancavelica'), (2287, 'PE', 'PER', NULL, 'Departamento de Huánuco'), (2288, 'PE', 'PER', NULL, 'Departamento de Ica'), (2289, 'PE', 'PER', NULL, 'Departamento de Junín'), (2290, 'PE', 'PER', NULL, 'Departamento de La Libertad'), (2291, 'PE', 'PER', NULL, 'Departamento de Lambayeque'), (2292, 'PE', 'PER', NULL, 'Departamento de Lima'), (2293, 'PE', 'PER', NULL, 'Departamento de Loreto'), (2294, 'PE', 'PER', NULL, 'Departamento de Madre de Dios'), (2295, 'PE', 'PER', NULL, 'Departamento de Moquegua'), (2296, 'PE', 'PER', NULL, 'Departamento de Pasco'), (2297, 'PE', 'PER', NULL, 'Departamento de Piura'), (2298, 'PE', 'PER', NULL, 'Departamento de Puno'), (2299, 'PE', 'PER', NULL, 'Departamento de San Martín'), (2300, 'PE', 'PER', NULL, 'Departamento de Tacna'), (2301, 'PE', 'PER', NULL, 'Departamento de Tumbes'), (2302, 'PE', 'PER', NULL, 'Departamento de Ucayali'), (2303, 'PE', 'PER', NULL, 'Provincia Constitucional del Callao'), (2304, 'PG', 'PNG', NULL, 'Sandaun Province'), (2305, 'PH', 'PHL', NULL, 'Angeles City'), (2306, 'PH', 'PHL', NULL, 'Bacolod City'), (2307, 'PH', 'PHL', NULL, 'Bago City'), (2308, 'PH', 'PHL', NULL, 'Baguio City'), (2309, 'PH', 'PHL', NULL, 'Bais City'), (2310, 'PH', 'PHL', NULL, 'Batangas City'), (2311, 'PH', 'PHL', NULL, 'Butuan City'), (2312, 'PH', 'PHL', NULL, 'Cabanatuan City'), (2313, 'PH', 'PHL', NULL, 'Cadiz City'), (2314, 'PH', 'PHL', NULL, 'Cagayan de Oro City'), (2315, 'PH', 'PHL', NULL, 'Calbayog City'), (2316, 'PH', 'PHL', NULL, 'Caloocan City'), (2317, 'PH', 'PHL', NULL, 'Canlaon City'), (2318, 'PH', 'PHL', NULL, 'Cavite City'), (2319, 'PH', 'PHL', NULL, 'Cebu City'), (2320, 'PH', 'PHL', NULL, 'Chartered City of Cagayan de Oro'), (2321, 'PH', 'PHL', NULL, 'Chartered City of Iligan'), (2322, 'PH', 'PHL', NULL, 'Chartered City of Marawi'), (2323, 'PH', 'PHL', NULL, 'City of Manila'), (2324, 'PH', 'PHL', NULL, 'Cotabato City'), (2325, 'PH', 'PHL', NULL, 'Dagupan City'), (2326, 'PH', 'PHL', NULL, 'Danao City'), (2327, 'PH', 'PHL', NULL, 'Dapitan City'), (2328, 'PH', 'PHL', NULL, 'Davao City'), (2329, 'PH', 'PHL', NULL, 'Dipolog City'), (2330, 'PH', 'PHL', NULL, 'Dumaguete City'), (2331, 'PH', 'PHL', NULL, 'Eastern Samar'), (2332, 'PH', 'PHL', NULL, 'General Santos City'), (2333, 'PH', 'PHL', NULL, 'Gingoog City'), (2334, 'PH', 'PHL', NULL, 'Iligan City'), (2335, 'PH', 'PHL', NULL, 'Iloilo City'), (2336, 'PH', 'PHL', NULL, 'Iriga City'), (2337, 'PH', 'PHL', NULL, 'La Carlota City'), (2338, 'PH', 'PHL', NULL, 'Laoag City'), (2339, 'PH', 'PHL', NULL, 'Lapu-Lapu City'), (2340, 'PH', 'PHL', NULL, 'Legaspi City'), (2341, 'PH', 'PHL', NULL, 'Lipa City'), (2342, 'PH', 'PHL', NULL, 'Lucena City'), (2343, 'PH', 'PHL', NULL, 'Mandaue City'), (2344, 'PH', 'PHL', NULL, 'Marawi City'), (2345, 'PH', 'PHL', NULL, 'Mountain Province'), (2346, 'PH', 'PHL', NULL, 'Naga City'), (2347, 'PH', 'PHL', NULL, 'Northern Samar'), (2348, 'PH', 'PHL', NULL, 'Olongapo City'), (2349, 'PH', 'PHL', NULL, 'Ormoc City'), (2350, 'PH', 'PHL', NULL, 'Oroquieta City'), (2351, 'PH', 'PHL', NULL, 'Ozamis City'), (2352, 'PH', 'PHL', NULL, 'Pagadian City'), (2353, 'PH', 'PHL', NULL, 'Palayan City'), (2354, 'PH', 'PHL', NULL, 'Pasay City'), (2355, 'PH', 'PHL', NULL, 'Province of Zamboanga del Sur'), (2356, 'PH', 'PHL', NULL, 'Province of Abra'), (2357, 'PH', 'PHL', NULL, 'Province of Agusan del Norte'), (2358, 'PH', 'PHL', NULL, 'Province of Agusan del Sur'), (2359, 'PH', 'PHL', NULL, 'Province of Aklan'), (2360, 'PH', 'PHL', NULL, 'Province of Albay'), (2361, 'PH', 'PHL', NULL, 'Province of Antique'), (2362, 'PH', 'PHL', NULL, 'Province of Aurora'), (2363, 'PH', 'PHL', NULL, 'Province of Basilan'), (2364, 'PH', 'PHL', NULL, 'Province of Bataan'), (2365, 'PH', 'PHL', NULL, 'Province of Batanes'), (2366, 'PH', 'PHL', NULL, 'Province of Batangas'), (2367, 'PH', 'PHL', NULL, 'Province of Benguet'), (2368, 'PH', 'PHL', NULL, 'Province of Bohol'), (2369, 'PH', 'PHL', NULL, 'Province of Bukidnon'), (2370, 'PH', 'PHL', NULL, 'Province of Bulacan'), (2371, 'PH', 'PHL', NULL, 'Province of Cagayan'), (2372, 'PH', 'PHL', NULL, 'Province of Camarines Norte'), (2373, 'PH', 'PHL', NULL, 'Province of Camarines Sur'), (2374, 'PH', 'PHL', NULL, 'Province of Camiguin'), (2375, 'PH', 'PHL', NULL, 'Province of Capiz'), (2376, 'PH', 'PHL', NULL, 'Province of Catanduanes'), (2377, 'PH', 'PHL', NULL, 'Province of Cavite'), (2378, 'PH', 'PHL', NULL, 'Province of Cebu'), (2379, 'PH', 'PHL', NULL, 'Province of Davao del Norte'), (2380, 'PH', 'PHL', NULL, 'Province of Davao del Sur'), (2381, 'PH', 'PHL', NULL, 'Province of Davao Oriental'), (2382, 'PH', 'PHL', NULL, 'Province of Ifugao'), (2383, 'PH', 'PHL', NULL, 'Province of Ilocos Norte'), (2384, 'PH', 'PHL', NULL, 'Province of Ilocos Sur'), (2385, 'PH', 'PHL', NULL, 'Province of Iloilo'), (2386, 'PH', 'PHL', NULL, 'Province of Isabela'), (2387, 'PH', 'PHL', NULL, 'Province of Kalinga-Apayao'), (2388, 'PH', 'PHL', NULL, 'Province of La Union'), (2389, 'PH', 'PHL', NULL, 'Province of Laguna'), (2390, 'PH', 'PHL', NULL, 'Province of Lanao del Norte'), (2391, 'PH', 'PHL', NULL, 'Province of Lanao del Sur'), (2392, 'PH', 'PHL', NULL, 'Province of Leyte'), (2393, 'PH', 'PHL', NULL, 'Province of Maguindanao'), (2394, 'PH', 'PHL', NULL, 'Province of Marinduque'), (2395, 'PH', 'PHL', NULL, 'Province of Masbate'), (2396, 'PH', 'PHL', NULL, 'Province of Mindoro Occidental'), (2397, 'PH', 'PHL', NULL, 'Province of Mindoro Oriental'), (2398, 'PH', 'PHL', NULL, 'Province of Misamis Occidental'), (2399, 'PH', 'PHL', NULL, 'Province of Misamis Oriental'), (2400, 'PH', 'PHL', NULL, 'Province of Negros Occidental'), (2401, 'PH', 'PHL', NULL, 'Province of Negros Oriental'), (2402, 'PH', 'PHL', NULL, 'Province of North Cotabato'), (2403, 'PH', 'PHL', NULL, 'Province of Nueva Ecija'), (2404, 'PH', 'PHL', NULL, 'Province of Nueva Vizcaya'), (2405, 'PH', 'PHL', NULL, 'Province of Palawan'), (2406, 'PH', 'PHL', NULL, 'Province of Pampanga'), (2407, 'PH', 'PHL', NULL, 'Province of Pangasinan'), (2408, 'PH', 'PHL', NULL, 'Province of Quezon'), (2409, 'PH', 'PHL', NULL, 'Province of Quirino'), (2410, 'PH', 'PHL', NULL, 'Province of Rizal'), (2411, 'PH', 'PHL', NULL, 'Province of Romblon'), (2412, 'PH', 'PHL', NULL, 'Province of Samar'), (2413, 'PH', 'PHL', NULL, 'Province of Siquijor'), (2414, 'PH', 'PHL', NULL, 'Province of Sorsogon'), (2415, 'PH', 'PHL', NULL, 'Province of South Cotabato'), (2416, 'PH', 'PHL', NULL, 'Province of Sultan Kudarat'), (2417, 'PH', 'PHL', NULL, 'Province of Sulu'), (2418, 'PH', 'PHL', NULL, 'Province of Surigao del Norte'), (2419, 'PH', 'PHL', NULL, 'Province of Surigao del Sur'), (2420, 'PH', 'PHL', NULL, 'Province of Tarlac'), (2421, 'PH', 'PHL', NULL, 'Province of Tawi-Tawi'), (2422, 'PH', 'PHL', NULL, 'Province of Zambales'), (2423, 'PH', 'PHL', NULL, 'Province of Zamboanga del Norte'), (2424, 'PH', 'PHL', NULL, 'Puerto Princesa City'), (2425, 'PH', 'PHL', NULL, 'Quezon City'), (2426, 'PH', 'PHL', NULL, 'Roxas City'), (2427, 'PH', 'PHL', NULL, 'San Carlos City'), (2428, 'PH', 'PHL', NULL, 'San Jose City'), (2429, 'PH', 'PHL', NULL, 'San Pablo City'), (2430, 'PH', 'PHL', NULL, 'Silay City'), (2431, 'PH', 'PHL', NULL, 'Southern Leyte'), (2432, 'PH', 'PHL', NULL, 'Surigao City'), (2433, 'PH', 'PHL', NULL, 'Tacloban City'), (2434, 'PH', 'PHL', NULL, 'Tagaytay City'), (2435, 'PH', 'PHL', NULL, 'Tagbilaran City'), (2436, 'PH', 'PHL', NULL, 'Tangub City'), (2437, 'PH', 'PHL', NULL, 'Toledo City'), (2438, 'PH', 'PHL', NULL, 'Trece Martires City'), (2439, 'PH', 'PHL', NULL, 'Zamboanga City'), (2440, 'PK', 'PAK', NULL, 'Azad Kashmir'), (2441, 'PK', 'PAK', NULL, 'Balochistān'), (2442, 'PK', 'PAK', NULL, 'Federally Administered Tribal Areas'), (2443, 'PK', 'PAK', NULL, 'Islāmābād Capital Territory'), (2444, 'PK', 'PAK', NULL, 'North-West Frontier Province'), (2445, 'PK', 'PAK', NULL, 'Punjab'), (2446, 'PK', 'PAK', NULL, 'Sind'), (2447, 'PL', 'POL', NULL, 'Greater Poland Voivodeship'), (2448, 'PL', 'POL', NULL, 'Kuyavian-Pomeranian Voivodeship'), (2449, 'PL', 'POL', NULL, 'Lesser Poland Voivodeship'), (2450, 'PL', 'POL', NULL, 'Łódź Voivodeship'), (2451, 'PL', 'POL', NULL, 'Lower Silesian Voivodeship'), (2452, 'PL', 'POL', NULL, 'Lublin Voivodeship'), (2453, 'PL', 'POL', NULL, 'Lubusz Voivodeship'), (2454, 'PL', 'POL', NULL, 'Masovian Voivodeship'), (2455, 'PL', 'POL', NULL, 'Opole Voivodeship'), (2456, 'PL', 'POL', NULL, 'Podlachian Voivodeship'), (2457, 'PL', 'POL', NULL, 'Pomeranian Voivodeship'), (2458, 'PL', 'POL', NULL, 'Silesian Voivodeship'), (2459, 'PL', 'POL', NULL, 'Subcarpathian Voivodeship'), (2460, 'PL', 'POL', NULL, 'Świętokrzyskie Voivodeship'), (2461, 'PL', 'POL', NULL, 'Warmian-Masurian Voivodeship'), (2462, 'PL', 'POL', NULL, 'West Pomeranian Voivodeship'), (2463, 'PS', 'PSE', NULL, 'Gaza Strip'), (2464, 'PS', 'PSE', NULL, 'West Bank'), (2465, 'PT', 'PRT', NULL, 'Bragança'), (2466, 'PT', 'PRT', NULL, 'Distrito da Guarda'), (2467, 'PT', 'PRT', NULL, 'Distrito de Aveiro'), (2468, 'PT', 'PRT', NULL, 'Distrito de Beja'), (2469, 'PT', 'PRT', NULL, 'Distrito de Braga'), (2470, 'PT', 'PRT', NULL, 'Distrito de Castelo Branco'), (2471, 'PT', 'PRT', NULL, 'Distrito de Coimbra'), (2472, 'PT', 'PRT', NULL, 'Distrito de Évora'), (2473, 'PT', 'PRT', NULL, 'Distrito de Faro'), (2474, 'PT', 'PRT', NULL, 'Distrito de Leiria'), (2475, 'PT', 'PRT', NULL, 'Distrito de Portalegre'), (2476, 'PT', 'PRT', NULL, 'Distrito de Santarém'), (2477, 'PT', 'PRT', NULL, 'Distrito de Setúbal'), (2478, 'PT', 'PRT', NULL, 'Distrito de Viana do Castelo'), (2479, 'PT', 'PRT', NULL, 'Distrito de Vila Real'), (2480, 'PT', 'PRT', NULL, 'Distrito de Viseu'), (2481, 'PT', 'PRT', NULL, 'Distrito do Porto'), (2482, 'PT', 'PRT', NULL, 'Lisbon'), (2483, 'PT', 'PRT', NULL, 'Região Autónoma da Madeira'), (2484, 'PT', 'PRT', NULL, 'Região Autónoma dos Açores'), (2485, 'PW', 'PLW', NULL, 'Hatohobei State'), (2486, 'PW', 'PLW', NULL, 'State of Airai'), (2487, 'PW', 'PLW', NULL, 'State of Angaur'), (2488, 'PW', 'PLW', NULL, 'State of Koror'), (2489, 'PW', 'PLW', NULL, 'State of Melekeok'), (2490, 'PW', 'PLW', NULL, 'State of Ngaraard'), (2491, 'PW', 'PLW', NULL, 'State of Ngarchelong'), (2492, 'PW', 'PLW', NULL, 'State of Ngchesar'), (2493, 'PW', 'PLW', NULL, 'State of Ngeremlengui'), (2494, 'PW', 'PLW', NULL, 'State of Ngiwal'), (2495, 'PW', 'PLW', NULL, 'State of Peleliu'), (2496, 'PY', 'PRY', NULL, 'Asunción'), (2497, 'PY', 'PRY', NULL, 'Departamento Central'), (2498, 'PY', 'PRY', NULL, 'Departamento de Alto Paraguay'), (2499, 'PY', 'PRY', NULL, 'Departamento de Boquerón'), (2500, 'PY', 'PRY', NULL, 'Departamento de Caaguazú'), (2501, 'PY', 'PRY', NULL, 'Departamento de Caazapá'), (2502, 'PY', 'PRY', NULL, 'Departamento de Canindeyú'), (2503, 'PY', 'PRY', NULL, 'Departamento de Concepción'), (2504, 'PY', 'PRY', NULL, 'Departamento de Itapúa'), (2505, 'PY', 'PRY', NULL, 'Departamento de la Cordillera'), (2506, 'PY', 'PRY', NULL, 'Departamento de Misiones'), (2507, 'PY', 'PRY', NULL, 'Departamento de Ñeembucú'), (2508, 'PY', 'PRY', NULL, 'Departamento de Paraguarí'), (2509, 'PY', 'PRY', NULL, 'Departamento de Presidente Hayes'), (2510, 'PY', 'PRY', NULL, 'Departamento de San Pedro'), (2511, 'PY', 'PRY', NULL, 'Departamento del Alto Paraná'), (2512, 'PY', 'PRY', NULL, 'Departamento del Amambay'), (2513, 'PY', 'PRY', NULL, 'Departamento del Guairá'), (2514, 'QA', 'QAT', NULL, 'Baladīyat ad Dawḩah'), (2515, 'QA', 'QAT', NULL, 'Baladīyat al Ghuwayrīyah'), (2516, 'QA', 'QAT', NULL, 'Baladīyat al Jumaylīyah'), (2517, 'QA', 'QAT', NULL, 'Baladīyat al Khawr'), (2518, 'QA', 'QAT', NULL, 'Baladīyat al Wakrah'), (2519, 'QA', 'QAT', NULL, 'Baladīyat ar Rayyān'), (2520, 'QA', 'QAT', NULL, 'Baladīyat Jarayān al Bāţinah'), (2521, 'QA', 'QAT', NULL, 'Baladīyat Madīnat ash Shamāl'), (2522, 'QA', 'QAT', NULL, 'Baladīyat Umm Sa`īd'), (2523, 'QA', 'QAT', NULL, 'Baladīyat Umm Şalāl'), (2524, 'RE', 'REU', NULL, 'Région Réunion'), (2525, 'RO', 'ROU', NULL, 'Judeţul Alba'), (2526, 'RO', 'ROU', NULL, 'Judeţul Arad'), (2527, 'RO', 'ROU', NULL, 'Judeţul Argeş'), (2528, 'RO', 'ROU', NULL, 'Judeţul Bacău'), (2529, 'RO', 'ROU', NULL, 'Judeţul Bihor'), (2530, 'RO', 'ROU', NULL, 'Judeţul Bistriţa-Năsăud'), (2531, 'RO', 'ROU', NULL, 'Judeţul Botoşani'), (2532, 'RO', 'ROU', NULL, 'Judeţul Brăila'), (2533, 'RO', 'ROU', NULL, 'Judeţul Braşov'), (2534, 'RO', 'ROU', NULL, 'Judeţul Buzău'), (2535, 'RO', 'ROU', NULL, 'Judeţul Călăraşi'), (2536, 'RO', 'ROU', NULL, 'Judeţul Caraş-Severin'), (2537, 'RO', 'ROU', NULL, 'Judeţul Cluj'), (2538, 'RO', 'ROU', NULL, 'Judeţul Constanţa'), (2539, 'RO', 'ROU', NULL, 'Judeţul Covasna'), (2540, 'RO', 'ROU', NULL, 'Judeţul Dâmboviţa'), (2541, 'RO', 'ROU', NULL, 'Judeţul Dolj'), (2542, 'RO', 'ROU', NULL, 'Judeţul Galaţi'), (2543, 'RO', 'ROU', NULL, 'Judeţul Giurgiu'), (2544, 'RO', 'ROU', NULL, 'Judeţul Gorj'), (2545, 'RO', 'ROU', NULL, 'Judeţul Harghita'), (2546, 'RO', 'ROU', NULL, 'Judeţul Hunedoara'), (2547, 'RO', 'ROU', NULL, 'Judeţul Ialomiţa'), (2548, 'RO', 'ROU', NULL, 'Judeţul Iaşi'), (2549, 'RO', 'ROU', NULL, 'Judeţul Ilfov'), (2550, 'RO', 'ROU', NULL, 'Judeţul Mehedinţi'), (2551, 'RO', 'ROU', NULL, 'Judeţul Mureş'), (2552, 'RO', 'ROU', NULL, 'Judeţul Neamţ'), (2553, 'RO', 'ROU', NULL, 'Judeţul Olt'), (2554, 'RO', 'ROU', NULL, 'Judeţul Prahova'), (2555, 'RO', 'ROU', NULL, 'Judeţul Sălaj'), (2556, 'RO', 'ROU', NULL, 'Judeţul Satu Mare'), (2557, 'RO', 'ROU', NULL, 'Judeţul Sibiu'), (2558, 'RO', 'ROU', NULL, 'Judeţul Suceava'), (2559, 'RO', 'ROU', NULL, 'Judeţul Teleorman'), (2560, 'RO', 'ROU', NULL, 'Judeţul Timiş'), (2561, 'RO', 'ROU', NULL, 'Judeţul Tulcea'), (2562, 'RO', 'ROU', NULL, 'Judeţul Vâlcea'), (2563, 'RO', 'ROU', NULL, 'Judeţul Vaslui'), (2564, 'RO', 'ROU', NULL, 'Judeţul Vrancea'), (2565, 'RO', 'ROU', NULL, 'Maramureş'), (2566, 'RO', 'ROU', NULL, 'Municipiul Bucureşti'), (2567, 'RS', 'SRB', NULL, 'Autonomna Pokrajina Vojvodina'), (2568, 'RS', 'SRB', NULL, 'Central Serbia'), (2569, 'RS', 'SRB', NULL, 'Kosovo'), (2570, 'RU', 'RUS', NULL, 'Aginskiy Buryatskiy Avtonomnyy Okrug'), (2571, 'RU', 'RUS', NULL, 'Altayskiy Kray'), (2572, 'RU', 'RUS', NULL, 'Amurskaya Oblast\''), (2573, 'RU', 'RUS', NULL, 'Arkhangelskaya oblast'), (2574, 'RU', 'RUS', NULL, 'Astrakhanskaya Oblast\''), (2575, 'RU', 'RUS', NULL, 'Belgorodskaya Oblast\''), (2576, 'RU', 'RUS', NULL, 'Belgorodskiy Rayon'), (2577, 'RU', 'RUS', NULL, 'Borisovskiy Rayon'), (2578, 'RU', 'RUS', NULL, 'Bryanskaya Oblast\''), (2579, 'RU', 'RUS', NULL, 'Chechnya'), (2580, 'RU', 'RUS', NULL, 'Chelyabinskaya Oblast\''), (2581, 'RU', 'RUS', NULL, 'Chitinskaya Oblast\''), (2582, 'RU', 'RUS', NULL, 'Chukotskiy Avtonomnyy Okrug'), (2583, 'RU', 'RUS', NULL, 'Chuvashia'), (2584, 'RU', 'RUS', NULL, 'Dagestan'), (2585, 'RU', 'RUS', NULL, 'Evenkiyskiy Avtonomnyy Okrug'), (2586, 'RU', 'RUS', NULL, 'Irkutskaya Oblast\''), (2587, 'RU', 'RUS', NULL, 'Ivanovskaya Oblast’'), (2588, 'RU', 'RUS', NULL, 'Jewish Autonomous Oblast'), (2589, 'RU', 'RUS', NULL, 'Kabardino-Balkarskaya Respublika'), (2590, 'RU', 'RUS', NULL, 'Kaliningradskaya Oblast\''), (2591, 'RU', 'RUS', NULL, 'Kaluzhskaya Oblast’'), (2592, 'RU', 'RUS', NULL, 'Kamchatskaya Oblast\''), (2593, 'RU', 'RUS', NULL, 'Karachayevo-Cherkesskaya Respublika'), (2594, 'RU', 'RUS', NULL, 'Kemerovskaya Oblast\''), (2595, 'RU', 'RUS', NULL, 'Khabarovsk Krai'), (2596, 'RU', 'RUS', NULL, 'Khanty-Mansiyskiy Avtonomnyy Okrug'), (2597, 'RU', 'RUS', NULL, 'Kirovskaya Oblast\''), (2598, 'RU', 'RUS', NULL, 'Koryakskiy Avtonomnyy Okrug'), (2599, 'RU', 'RUS', NULL, 'Kostromskaya Oblast\''), (2600, 'RU', 'RUS', NULL, 'Krasnodarskiy Kray'), (2601, 'RU', 'RUS', NULL, 'Krasnoyarskiy Kray'), (2602, 'RU', 'RUS', NULL, 'Kurganskaya Oblast\''), (2603, 'RU', 'RUS', NULL, 'Kurskaya Oblast\''), (2604, 'RU', 'RUS', NULL, 'Leningradskaya Oblast\''), (2605, 'RU', 'RUS', NULL, 'Lipetskaya Oblast\''), (2606, 'RU', 'RUS', NULL, 'Magadanskaya Oblast\''), (2607, 'RU', 'RUS', NULL, 'Moscow'), (2608, 'RU', 'RUS', NULL, 'Moskovskaya Oblast\''), (2609, 'RU', 'RUS', NULL, 'Murmansk Oblast'), (2610, 'RU', 'RUS', NULL, 'Nenetskiy Avtonomnyy Okrug'), (2611, 'RU', 'RUS', NULL, 'Nizhegorodskaya Oblast’'), (2612, 'RU', 'RUS', NULL, 'Novgorodskaya Oblast\''), (2613, 'RU', 'RUS', NULL, 'Novosibirskaya Oblast\''), (2614, 'RU', 'RUS', NULL, 'Omskaya Oblast\''), (2615, 'RU', 'RUS', NULL, 'Orenburgskaya Oblast\''), (2616, 'RU', 'RUS', NULL, 'Orlovskaya Oblast\''), (2617, 'RU', 'RUS', NULL, 'Penzenskaya Oblast\''), (2618, 'RU', 'RUS', NULL, 'Permskaya Oblast’'), (2619, 'RU', 'RUS', NULL, 'Permskiy Kray'), (2620, 'RU', 'RUS', NULL, 'Primorskiy Kray'), (2621, 'RU', 'RUS', NULL, 'Pskovskaya Oblast\''), (2622, 'RU', 'RUS', NULL, 'Respublika Adygeya'), (2623, 'RU', 'RUS', NULL, 'Respublika Altay'), (2624, 'RU', 'RUS', NULL, 'Respublika Bashkortostan'), (2625, 'RU', 'RUS', NULL, 'Respublika Buryatiya'), (2626, 'RU', 'RUS', NULL, 'Respublika Ingushetiya'), (2627, 'RU', 'RUS', NULL, 'Respublika Kalmykiya'), (2628, 'RU', 'RUS', NULL, 'Respublika Kareliya'), (2629, 'RU', 'RUS', NULL, 'Respublika Khakasiya'), (2630, 'RU', 'RUS', NULL, 'Respublika Komi'), (2631, 'RU', 'RUS', NULL, 'Respublika Mariy-El'), (2632, 'RU', 'RUS', NULL, 'Respublika Mordoviya'), (2633, 'RU', 'RUS', NULL, 'Respublika Sakha (Yakutiya)'), (2634, 'RU', 'RUS', NULL, 'Respublika Severnaya Osetiya-Alaniya'), (2635, 'RU', 'RUS', NULL, 'Respublika Tatarstan'), (2636, 'RU', 'RUS', NULL, 'Respublika Tyva'), (2637, 'RU', 'RUS', NULL, 'Rostovskaya Oblast\''), (2638, 'RU', 'RUS', NULL, 'Ryazanskaya Oblast\''), (2639, 'RU', 'RUS', NULL, 'Sakhalinskaya Oblast\''), (2640, 'RU', 'RUS', NULL, 'Samarskaya Oblast\''), (2641, 'RU', 'RUS', NULL, 'Sankt-Peterburg'), (2642, 'RU', 'RUS', NULL, 'Saratovskaya Oblast\''), (2643, 'RU', 'RUS', NULL, 'Shebekinskiy Rayon'), (2644, 'RU', 'RUS', NULL, 'Smolenskaya Oblast\''), (2645, 'RU', 'RUS', NULL, 'Stavropol\'skiy Kray'), (2646, 'RU', 'RUS', NULL, 'Sverdlovskaya Oblast\''), (2647, 'RU', 'RUS', NULL, 'Tambovskaya Oblast\''), (2648, 'RU', 'RUS', NULL, 'Taymyrskiy (Dolgano-Nenetskiy) Avtonomnyy Okrug'), (2649, 'RU', 'RUS', NULL, 'Tomskaya Oblast\''), (2650, 'RU', 'RUS', NULL, 'Tul\'skaya Oblast\''), (2651, 'RU', 'RUS', NULL, 'Tverskaya Oblast’'), (2652, 'RU', 'RUS', NULL, 'Tyumenskaya Oblast\''), (2653, 'RU', 'RUS', NULL, 'Udmurtskaya Respublika'), (2654, 'RU', 'RUS', NULL, 'Ul’yanovskaya Oblast’'), (2655, 'RU', 'RUS', NULL, 'Ust\'-Ordynskiy Buryatskiy Avtonomnyy Okrug'), (2656, 'RU', 'RUS', NULL, 'Vladimirskaya Oblast\''), (2657, 'RU', 'RUS', NULL, 'Volgogradskaya Oblast\''), (2658, 'RU', 'RUS', NULL, 'Vologodskaya Oblast\''), (2659, 'RU', 'RUS', NULL, 'Voronezhskaya Oblast\''), (2660, 'RU', 'RUS', NULL, 'Yamalo-Nenetskiy Avtonomnyy Okrug'), (2661, 'RU', 'RUS', NULL, 'Yaroslavskaya Oblast\''), (2662, 'RW', 'RWA', NULL, 'Eastern Province'), (2663, 'RW', 'RWA', NULL, 'Kigali City'), (2664, 'RW', 'RWA', NULL, 'Northern Province'), (2665, 'RW', 'RWA', NULL, 'Préfecture de Kibuye'), (2666, 'RW', 'RWA', NULL, 'Préfecture de Kigali'), (2667, 'RW', 'RWA', NULL, 'Préfecture de Ruhengeri'), (2668, 'RW', 'RWA', NULL, 'Prefegitura ya Butare'), (2669, 'RW', 'RWA', NULL, 'Prefegitura ya Byumba'), (2670, 'RW', 'RWA', NULL, 'Prefegitura ya Cyangugu'), (2671, 'RW', 'RWA', NULL, 'Prefegitura ya Gikongoro'), (2672, 'RW', 'RWA', NULL, 'Prefegitura ya Gisenyi'), (2673, 'RW', 'RWA', NULL, 'Prefegitura ya Gitarama'), (2674, 'RW', 'RWA', NULL, 'Prefegitura ya Kibungo'), (2675, 'RW', 'RWA', NULL, 'Southern Province'), (2676, 'RW', 'RWA', NULL, 'Western Province'), (2677, 'SA', 'SAU', NULL, 'Al Minţaqah ash Sharqīyah'), (2678, 'SA', 'SAU', NULL, 'Minţaqat `Asīr'), (2679, 'SA', 'SAU', NULL, 'Minţaqat al Bāḩah'), (2680, 'SA', 'SAU', NULL, 'Minţaqat al Jawf'), (2681, 'SA', 'SAU', NULL, 'Minţaqat al Madīnah'), (2682, 'SA', 'SAU', NULL, 'Minţaqat al Qaşīm'), (2683, 'SA', 'SAU', NULL, 'Minţaqat ar Riyāḑ'), (2684, 'SA', 'SAU', NULL, 'Minţaqat Ḩā\'il'), (2685, 'SA', 'SAU', NULL, 'Minţaqat Jīzān'), (2686, 'SA', 'SAU', NULL, 'Minţaqat Makkah'), (2687, 'SA', 'SAU', NULL, 'Minţaqat Najrān'), (2688, 'SA', 'SAU', NULL, 'Minţaqat Tabūk'), (2689, 'SA', 'SAU', NULL, 'Northern Borders Region'), (2690, 'SB', 'SLB', NULL, 'Central Province'), (2691, 'SB', 'SLB', NULL, 'Guadalcanal Province'), (2692, 'SB', 'SLB', NULL, 'Isabel Province'), (2693, 'SB', 'SLB', NULL, 'Makira Province'), (2694, 'SB', 'SLB', NULL, 'Malaita Province'), (2695, 'SB', 'SLB', NULL, 'Temotu Province'), (2696, 'SB', 'SLB', NULL, 'Western Province'), (2697, 'SC', 'SYC', NULL, 'Anse aux Pins'), (2698, 'SC', 'SYC', NULL, 'Anse Boileau'), (2699, 'SC', 'SYC', NULL, 'Anse Etoile'), (2700, 'SC', 'SYC', NULL, 'Anse Louis'), (2701, 'SC', 'SYC', NULL, 'Anse Royale'), (2702, 'SC', 'SYC', NULL, 'Au Cap'), (2703, 'SC', 'SYC', NULL, 'Baie Lazare'), (2704, 'SC', 'SYC', NULL, 'Baie Sainte Anne'), (2705, 'SC', 'SYC', NULL, 'Beau Vallon'), (2706, 'SC', 'SYC', NULL, 'Bel Air'), (2707, 'SC', 'SYC', NULL, 'Bel Ombre'), (2708, 'SC', 'SYC', NULL, 'Cascade'), (2709, 'SC', 'SYC', NULL, 'English River'), (2710, 'SC', 'SYC', NULL, 'Glacis'), (2711, 'SC', 'SYC', NULL, 'Grand Anse Mahe'), (2712, 'SC', 'SYC', NULL, 'Grand Anse Praslin'), (2713, 'SC', 'SYC', NULL, 'Inner Islands'), (2714, 'SC', 'SYC', NULL, 'Les Mamelles'), (2715, 'SC', 'SYC', NULL, 'Mont Buxton'), (2716, 'SC', 'SYC', NULL, 'Mont Fleuri'), (2717, 'SC', 'SYC', NULL, 'Plaisance'), (2718, 'SC', 'SYC', NULL, 'Pointe Larue'), (2719, 'SC', 'SYC', NULL, 'Port Glaud'), (2720, 'SC', 'SYC', NULL, 'Roche Caiman'), (2721, 'SC', 'SYC', NULL, 'Saint Louis'), (2722, 'SC', 'SYC', NULL, 'Takamaka'), (2723, 'SD', 'SDN', NULL, 'Al Jazirah'), (2724, 'SD', 'SDN', NULL, 'Al Qadarif'), (2725, 'SD', 'SDN', NULL, 'Al Wilāyah al Istiwā\'īyah'), (2726, 'SD', 'SDN', NULL, 'Al Wilāyah al Wusţá'), (2727, 'SD', 'SDN', NULL, 'Al Wilāyah ash Sharqīyah'), (2728, 'SD', 'SDN', NULL, 'Ba?r al Ghazal Wilayat'), (2729, 'SD', 'SDN', NULL, 'Blue Nile'), (2730, 'SD', 'SDN', NULL, 'Central Equatoria'), (2731, 'SD', 'SDN', NULL, 'Darfur Wilayat'), (2732, 'SD', 'SDN', NULL, 'Eastern Equatoria'), (2733, 'SD', 'SDN', NULL, 'Khartoum'), (2734, 'SD', 'SDN', NULL, 'Kurdufan Wilayat'), (2735, 'SD', 'SDN', NULL, 'Lakes'), (2736, 'SD', 'SDN', NULL, 'Northern'), (2737, 'SD', 'SDN', NULL, 'Red Sea'), (2738, 'SD', 'SDN', NULL, 'Unity'), (2739, 'SD', 'SDN', NULL, 'Upper Nile'), (2740, 'SD', 'SDN', NULL, 'Western Bahr al Ghazal'), (2741, 'SD', 'SDN', NULL, 'White Nile'), (2742, 'SD', 'SDN', NULL, 'Wilāyat Gharb al Istiwā\'īyah'), (2743, 'SD', 'SDN', NULL, 'Wilāyat Gharb Dārfūr'), (2744, 'SD', 'SDN', NULL, 'Wilāyat Gharb Kurdufān'), (2745, 'SD', 'SDN', NULL, 'Wilāyat Janūb Dārfūr'), (2746, 'SD', 'SDN', NULL, 'Wilāyat Janūb Kurdufān'), (2747, 'SD', 'SDN', NULL, 'Wilāyat Junqalī'), (2748, 'SD', 'SDN', NULL, 'Wilāyat Kassalā'), (2749, 'SD', 'SDN', NULL, 'Wilāyat Nahr an Nīl'), (2750, 'SD', 'SDN', NULL, 'Wilāyat Shamāl Baḩr al Ghazāl'), (2751, 'SD', 'SDN', NULL, 'Wilāyat Shamāl Dārfūr'), (2752, 'SD', 'SDN', NULL, 'Wilāyat Shamāl Kurdufān'), (2753, 'SD', 'SDN', NULL, 'Wilāyat Sinnār'), (2754, 'SD', 'SDN', NULL, 'Wilāyat Warab'), (2755, 'SE', 'SWE', NULL, 'Blekinge Län'), (2756, 'SE', 'SWE', NULL, 'Dalarnas Län'), (2757, 'SE', 'SWE', NULL, 'Gävleborgs Län'), (2758, 'SE', 'SWE', NULL, 'Gotlands Län'), (2759, 'SE', 'SWE', NULL, 'Hallands Län'), (2760, 'SE', 'SWE', NULL, 'Jämtlands Län'), (2761, 'SE', 'SWE', NULL, 'Jönköpings Län'), (2762, 'SE', 'SWE', NULL, 'Kalmar Län'), (2763, 'SE', 'SWE', NULL, 'Kronobergs Län'), (2764, 'SE', 'SWE', NULL, 'Norrbottens Län'), (2765, 'SE', 'SWE', NULL, 'Örebro Län'), (2766, 'SE', 'SWE', NULL, 'Östergötlands Län'), (2767, 'SE', 'SWE', NULL, 'Skåne Län'), (2768, 'SE', 'SWE', NULL, 'Södermanlands Län'), (2769, 'SE', 'SWE', NULL, 'Stockholms Län'), (2770, 'SE', 'SWE', NULL, 'Uppsala Län'), (2771, 'SE', 'SWE', NULL, 'Värmlands Län'), (2772, 'SE', 'SWE', NULL, 'Västerbottens Län'), (2773, 'SE', 'SWE', NULL, 'Västernorrlands Län'), (2774, 'SE', 'SWE', NULL, 'Västmanlands Län'), (2775, 'SE', 'SWE', NULL, 'Västra Götalands Län'), (2776, 'SH', 'SHN', NULL, 'Ascension'), (2777, 'SH', 'SHN', NULL, 'Saint Helena'), (2778, 'SH', 'SHN', NULL, 'Tristan da Cunha'), (2779, 'SI', 'SVN', NULL, 'Bohinj'), (2780, 'SI', 'SVN', NULL, 'Ljubljana'), (2781, 'SI', 'SVN', NULL, 'Mestna Občina Celje'), (2782, 'SI', 'SVN', NULL, 'Mestna Občina Koper-Capodistria'), (2783, 'SI', 'SVN', NULL, 'Mestna Občina Kranj'), (2784, 'SI', 'SVN', NULL, 'Mestna Občina Maribor'), (2785, 'SI', 'SVN', NULL, 'Mestna Občina Murska Sobota'), (2786, 'SI', 'SVN', NULL, 'Mestna Občina Nova Gorica'), (2787, 'SI', 'SVN', NULL, 'Mestna Občina Novo Mesto'), (2788, 'SI', 'SVN', NULL, 'Mestna Občina Ptuj'), (2789, 'SI', 'SVN', NULL, 'Mestna Občina Slovenj Gradec'), (2790, 'SI', 'SVN', NULL, 'Mestna Občina Velenje'), (2791, 'SI', 'SVN', NULL, 'Občina [historical] Cankova-Tišina'), (2792, 'SI', 'SVN', NULL, 'Občina [historical] Destrnik-Trnovska Vas'), (2793, 'SI', 'SVN', NULL, 'Občina [historical] Hodoš Šalovci'), (2794, 'SI', 'SVN', NULL, 'Občina [historical] Lendava'), (2795, 'SI', 'SVN', NULL, 'Občina [historical] Podvelka-Ribnica'), (2796, 'SI', 'SVN', NULL, 'Občina Ajdovščina'), (2797, 'SI', 'SVN', NULL, 'Občina Beltinci'), (2798, 'SI', 'SVN', NULL, 'Občina Benedikt'), (2799, 'SI', 'SVN', NULL, 'Občina Bistrica ob Sotli'), (2800, 'SI', 'SVN', NULL, 'Občina Bled'), (2801, 'SI', 'SVN', NULL, 'Občina Bloke'), (2802, 'SI', 'SVN', NULL, 'Občina Borovnica'), (2803, 'SI', 'SVN', NULL, 'Občina Bovec'), (2804, 'SI', 'SVN', NULL, 'Občina Braslovče'), (2805, 'SI', 'SVN', NULL, 'Občina Brda'), (2806, 'SI', 'SVN', NULL, 'Občina Brežice'), (2807, 'SI', 'SVN', NULL, 'Občina Brezovica'), (2808, 'SI', 'SVN', NULL, 'Občina Cankova'), (2809, 'SI', 'SVN', NULL, 'Občina Cerklje na Gorenjskem'), (2810, 'SI', 'SVN', NULL, 'Občina Cerknica'), (2811, 'SI', 'SVN', NULL, 'Občina Cerkno'), (2812, 'SI', 'SVN', NULL, 'Občina Cerkvenjak'), (2813, 'SI', 'SVN', NULL, 'Občina Črenšovci'), (2814, 'SI', 'SVN', NULL, 'Občina Črna na Koroškem'), (2815, 'SI', 'SVN', NULL, 'Občina Črnomelj'), (2816, 'SI', 'SVN', NULL, 'Občina Destrnik'), (2817, 'SI', 'SVN', NULL, 'Občina Divača'), (2818, 'SI', 'SVN', NULL, 'Občina Dobje'), (2819, 'SI', 'SVN', NULL, 'Občina Dobrepolje'), (2820, 'SI', 'SVN', NULL, 'Občina Dobrna'), (2821, 'SI', 'SVN', NULL, 'Občina Dobrova-Horjul-Polhov Gradec'), (2822, 'SI', 'SVN', NULL, 'Občina Dobrovnik-Dobronak'), (2823, 'SI', 'SVN', NULL, 'Občina Dol pri Ljubljani'), (2824, 'SI', 'SVN', NULL, 'Občina Dolenjske Toplice'), (2825, 'SI', 'SVN', NULL, 'Občina Domžale'), (2826, 'SI', 'SVN', NULL, 'Občina Dornava'), (2827, 'SI', 'SVN', NULL, 'Občina Dravograd'), (2828, 'SI', 'SVN', NULL, 'Občina Duplek'), (2829, 'SI', 'SVN', NULL, 'Občina Gorenja Vas-Poljane'), (2830, 'SI', 'SVN', NULL, 'Občina Gorišnica'), (2831, 'SI', 'SVN', NULL, 'Občina Gornja Radgona'), (2832, 'SI', 'SVN', NULL, 'Občina Gornji Grad'), (2833, 'SI', 'SVN', NULL, 'Občina Gornji Petrovci'), (2834, 'SI', 'SVN', NULL, 'Občina Grad'), (2835, 'SI', 'SVN', NULL, 'Občina Grosuplje'), (2836, 'SI', 'SVN', NULL, 'Občina Hajdina'), (2837, 'SI', 'SVN', NULL, 'Občina Hoče-Slivnica'), (2838, 'SI', 'SVN', NULL, 'Občina Hodoš-Hodos'), (2839, 'SI', 'SVN', NULL, 'Občina Horjul'), (2840, 'SI', 'SVN', NULL, 'Občina Hrastnik'), (2841, 'SI', 'SVN', NULL, 'Občina Hrpelje-Kozina'), (2842, 'SI', 'SVN', NULL, 'Občina Idrija'), (2843, 'SI', 'SVN', NULL, 'Občina Ig'), (2844, 'SI', 'SVN', NULL, 'Občina Ilirska Bistrica'), (2845, 'SI', 'SVN', NULL, 'Občina Ivančna Gorica'), (2846, 'SI', 'SVN', NULL, 'Občina Izola-Isola'), (2847, 'SI', 'SVN', NULL, 'Občina Jesenice'), (2848, 'SI', 'SVN', NULL, 'Občina Jezersko'), (2849, 'SI', 'SVN', NULL, 'Občina Juršinci'), (2850, 'SI', 'SVN', NULL, 'Občina Kamnik'), (2851, 'SI', 'SVN', NULL, 'Občina Kanal'), (2852, 'SI', 'SVN', NULL, 'Občina Kidričevo'), (2853, 'SI', 'SVN', NULL, 'Občina Kobarid'), (2854, 'SI', 'SVN', NULL, 'Občina Kobilje'), (2855, 'SI', 'SVN', NULL, 'Občina Kočevje'), (2856, 'SI', 'SVN', NULL, 'Občina Komen'), (2857, 'SI', 'SVN', NULL, 'Občina Komenda'), (2858, 'SI', 'SVN', NULL, 'Občina Kostel'), (2859, 'SI', 'SVN', NULL, 'Občina Kozje'), (2860, 'SI', 'SVN', NULL, 'Občina Kranjska Gora'), (2861, 'SI', 'SVN', NULL, 'Občina Križevci'), (2862, 'SI', 'SVN', NULL, 'Občina Krško'), (2863, 'SI', 'SVN', NULL, 'Občina Kungota'), (2864, 'SI', 'SVN', NULL, 'Občina Kuzma'), (2865, 'SI', 'SVN', NULL, 'Občina Laško'), (2866, 'SI', 'SVN', NULL, 'Občina Lenart'), (2867, 'SI', 'SVN', NULL, 'Občina Lendava-Lendva'), (2868, 'SI', 'SVN', NULL, 'Občina Litija'), (2869, 'SI', 'SVN', NULL, 'Občina Ljubno'), (2870, 'SI', 'SVN', NULL, 'Občina Ljutomer'), (2871, 'SI', 'SVN', NULL, 'Občina Logatec'), (2872, 'SI', 'SVN', NULL, 'Občina Loška Dolina'), (2873, 'SI', 'SVN', NULL, 'Občina Loški Potok'), (2874, 'SI', 'SVN', NULL, 'Občina Lovrenc na Pohorju'), (2875, 'SI', 'SVN', NULL, 'Občina Luče'), (2876, 'SI', 'SVN', NULL, 'Občina Lukovica'), (2877, 'SI', 'SVN', NULL, 'Občina Majšperk'), (2878, 'SI', 'SVN', NULL, 'Občina Markovci'), (2879, 'SI', 'SVN', NULL, 'Občina Medvode'), (2880, 'SI', 'SVN', NULL, 'Občina Mengeš'), (2881, 'SI', 'SVN', NULL, 'Občina Metlika'), (2882, 'SI', 'SVN', NULL, 'Občina Mežica'), (2883, 'SI', 'SVN', NULL, 'Občina Miklavž na Dravskem Polju'), (2884, 'SI', 'SVN', NULL, 'Občina Miren-Kostanjevica'), (2885, 'SI', 'SVN', NULL, 'Občina Mirna Peč'), (2886, 'SI', 'SVN', NULL, 'Občina Mislinja'), (2887, 'SI', 'SVN', NULL, 'Občina Moravče'), (2888, 'SI', 'SVN', NULL, 'Občina MoravskeToplice'), (2889, 'SI', 'SVN', NULL, 'Občina Mozirje'), (2890, 'SI', 'SVN', NULL, 'Občina Muta'), (2891, 'SI', 'SVN', NULL, 'Občina Naklo'), (2892, 'SI', 'SVN', NULL, 'Občina Nazarje'), (2893, 'SI', 'SVN', NULL, 'Občina Odranci'), (2894, 'SI', 'SVN', NULL, 'Občina Oplotnica'), (2895, 'SI', 'SVN', NULL, 'Občina Ormož'), (2896, 'SI', 'SVN', NULL, 'Občina Osilnica'), (2897, 'SI', 'SVN', NULL, 'Občina Pesnica'), (2898, 'SI', 'SVN', NULL, 'Občina Piran-Pirano'), (2899, 'SI', 'SVN', NULL, 'Občina Pivka'), (2900, 'SI', 'SVN', NULL, 'Občina Podčetrtek'), (2901, 'SI', 'SVN', NULL, 'Občina Podlehnik'), (2902, 'SI', 'SVN', NULL, 'Občina Podvelka'), (2903, 'SI', 'SVN', NULL, 'Občina Polzela'), (2904, 'SI', 'SVN', NULL, 'Občina Postojna'), (2905, 'SI', 'SVN', NULL, 'Občina Prebold'), (2906, 'SI', 'SVN', NULL, 'Občina Preddvor'), (2907, 'SI', 'SVN', NULL, 'Občina Prevalje'), (2908, 'SI', 'SVN', NULL, 'Občina Puconci'), (2909, 'SI', 'SVN', NULL, 'Občina Rače-Fram'), (2910, 'SI', 'SVN', NULL, 'Občina Radeče'), (2911, 'SI', 'SVN', NULL, 'Občina Radenci'), (2912, 'SI', 'SVN', NULL, 'Občina Radlje ob Dravi'), (2913, 'SI', 'SVN', NULL, 'Občina Radovljica'), (2914, 'SI', 'SVN', NULL, 'Občina Ravne na Koroškem'), (2915, 'SI', 'SVN', NULL, 'Občina Razkrižje'), (2916, 'SI', 'SVN', NULL, 'Občina Ribnica'), (2917, 'SI', 'SVN', NULL, 'Občina Ribnica na Pohorju'), (2918, 'SI', 'SVN', NULL, 'Občina Rogaška Slatina'), (2919, 'SI', 'SVN', NULL, 'Občina Rogašovci'), (2920, 'SI', 'SVN', NULL, 'Občina Rogatec'), (2921, 'SI', 'SVN', NULL, 'Občina Ruše'), (2922, 'SI', 'SVN', NULL, 'Občina Šalovci'), (2923, 'SI', 'SVN', NULL, 'Občina Selnica ob Dravi'), (2924, 'SI', 'SVN', NULL, 'Občina Semič'), (2925, 'SI', 'SVN', NULL, 'Občina Šempeter-Vrtojba'), (2926, 'SI', 'SVN', NULL, 'Občina Šenčur'), (2927, 'SI', 'SVN', NULL, 'Občina Šentilj'), (2928, 'SI', 'SVN', NULL, 'Občina Šentjernej'), (2929, 'SI', 'SVN', NULL, 'Občina Šentjur pri Celju'), (2930, 'SI', 'SVN', NULL, 'Občina Sevnica'), (2931, 'SI', 'SVN', NULL, 'Občina Sežana'), (2932, 'SI', 'SVN', NULL, 'Občina Škocjan'), (2933, 'SI', 'SVN', NULL, 'Občina Škofja Loka'), (2934, 'SI', 'SVN', NULL, 'Občina Škofljica'), (2935, 'SI', 'SVN', NULL, 'Občina Slovenska Bistrica'), (2936, 'SI', 'SVN', NULL, 'Občina Slovenske Konjice'), (2937, 'SI', 'SVN', NULL, 'Občina Šmarje pri Jelšah'), (2938, 'SI', 'SVN', NULL, 'Občina Šmartno ob Paki'), (2939, 'SI', 'SVN', NULL, 'Občina Šmartno pri Litiji'), (2940, 'SI', 'SVN', NULL, 'Občina Sodražica'), (2941, 'SI', 'SVN', NULL, 'Občina Solčava'), (2942, 'SI', 'SVN', NULL, 'Občina Šoštanj'), (2943, 'SI', 'SVN', NULL, 'Občina Starše'), (2944, 'SI', 'SVN', NULL, 'Občina Štore'), (2945, 'SI', 'SVN', NULL, 'Občina Sveta Ana'), (2946, 'SI', 'SVN', NULL, 'Občina Sveti Andraž v Slovenskih Goricah'), (2947, 'SI', 'SVN', NULL, 'Občina Sveti Jurij'), (2948, 'SI', 'SVN', NULL, 'Občina Tabor'), (2949, 'SI', 'SVN', NULL, 'Občina Tišina'), (2950, 'SI', 'SVN', NULL, 'Občina Tolmin'), (2951, 'SI', 'SVN', NULL, 'Občina Trbovlje'), (2952, 'SI', 'SVN', NULL, 'Občina Trebnje'), (2953, 'SI', 'SVN', NULL, 'Občina Trnovska Vas'), (2954, 'SI', 'SVN', NULL, 'Občina Tržič'), (2955, 'SI', 'SVN', NULL, 'Občina Trzin'), (2956, 'SI', 'SVN', NULL, 'Občina Turnišče'), (2957, 'SI', 'SVN', NULL, 'Občina Velika Polana'), (2958, 'SI', 'SVN', NULL, 'Občina Velike Lašče'), (2959, 'SI', 'SVN', NULL, 'Občina Veržej'), (2960, 'SI', 'SVN', NULL, 'Občina Videm'), (2961, 'SI', 'SVN', NULL, 'Občina Vipava'), (2962, 'SI', 'SVN', NULL, 'Občina Vitanje'), (2963, 'SI', 'SVN', NULL, 'Občina Vodice'), (2964, 'SI', 'SVN', NULL, 'Občina Vojnik'), (2965, 'SI', 'SVN', NULL, 'Občina Vransko'), (2966, 'SI', 'SVN', NULL, 'Občina Vrhnika'), (2967, 'SI', 'SVN', NULL, 'Občina Vuzenica'), (2968, 'SI', 'SVN', NULL, 'Občina Zagorje ob Savi'), (2969, 'SI', 'SVN', NULL, 'Občina Žalec'), (2970, 'SI', 'SVN', NULL, 'Občina Zavrč'), (2971, 'SI', 'SVN', NULL, 'Občina Železniki'), (2972, 'SI', 'SVN', NULL, 'Občina Žetale'), (2973, 'SI', 'SVN', NULL, 'Občina Žiri'), (2974, 'SI', 'SVN', NULL, 'Občina Žirovnica'), (2975, 'SI', 'SVN', NULL, 'Občina Zreče'), (2976, 'SI', 'SVN', NULL, 'Občina Žužemberk'), (2977, 'SK', 'SVK', NULL, 'Banskobystrický Kraj'), (2978, 'SK', 'SVK', NULL, 'Bratislavský Kraj'), (2979, 'SK', 'SVK', NULL, 'Košický Kraj'), (2980, 'SK', 'SVK', NULL, 'Nitriansky Kraj'), (2981, 'SK', 'SVK', NULL, 'Prešovský Kraj'), (2982, 'SK', 'SVK', NULL, 'Trenčiansky Kraj'), (2983, 'SK', 'SVK', NULL, 'Trnavský Kraj'), (2984, 'SK', 'SVK', NULL, 'Žilinský Kraj'), (2985, 'SL', 'SLE', NULL, 'Eastern Province'), (2986, 'SL', 'SLE', NULL, 'Northern Province'), (2987, 'SL', 'SLE', NULL, 'Southern Province'), (2988, 'SL', 'SLE', NULL, 'Western Area'), (2989, 'SM', 'SMR', NULL, 'Castello di Acquaviva'), (2990, 'SM', 'SMR', NULL, 'Castello di Borgo Maggiore'), (2991, 'SM', 'SMR', NULL, 'Castello di Domagnano'), (2992, 'SM', 'SMR', NULL, 'Castello di Faetano'), (2993, 'SM', 'SMR', NULL, 'Castello di Fiorentino'), (2994, 'SM', 'SMR', NULL, 'Castello di Montegiardino'), (2995, 'SM', 'SMR', NULL, 'Castello di San Marino Città'), (2996, 'SM', 'SMR', NULL, 'Castello di Serravalle'), (2997, 'SM', 'SMR', NULL, 'Chiesanuova'), (2998, 'SN', 'SEN', NULL, 'Kolda Region'), (2999, 'SN', 'SEN', NULL, 'Région de Dakar'), (3000, 'SN', 'SEN', NULL, 'Région de Diourbel'), (3001, 'SN', 'SEN', NULL, 'Région de Fatick'), (3002, 'SN', 'SEN', NULL, 'Région de Kaolack'), (3003, 'SN', 'SEN', NULL, 'Région de Louga'), (3004, 'SN', 'SEN', NULL, 'Région de Matam'), (3005, 'SN', 'SEN', NULL, 'Région de Saint-Louis'), (3006, 'SN', 'SEN', NULL, 'Région de Tambacounda'), (3007, 'SN', 'SEN', NULL, 'Région de Thiès'), (3008, 'SN', 'SEN', NULL, 'Région de Ziguinchor'), (3009, 'SO', 'SOM', NULL, 'Gobolka Awdal'), (3010, 'SO', 'SOM', NULL, 'Gobolka Bakool'), (3011, 'SO', 'SOM', NULL, 'Gobolka Banaadir'), (3012, 'SO', 'SOM', NULL, 'Gobolka Bari'), (3013, 'SO', 'SOM', NULL, 'Gobolka Bay'), (3014, 'SO', 'SOM', NULL, 'Gobolka Galguduud'), (3015, 'SO', 'SOM', NULL, 'Gobolka Gedo'), (3016, 'SO', 'SOM', NULL, 'Gobolka Hiiraan'), (3017, 'SO', 'SOM', NULL, 'Gobolka Mudug'), (3018, 'SO', 'SOM', NULL, 'Gobolka Nugaal'), (3019, 'SO', 'SOM', NULL, 'Gobolka Sanaag'), (3020, 'SO', 'SOM', NULL, 'Gobolka Shabeellaha Hoose'), (3021, 'SO', 'SOM', NULL, 'Gobolka Sool'), (3022, 'SO', 'SOM', NULL, 'Gobolka Togdheer'), (3023, 'SO', 'SOM', NULL, 'Gobolka Woqooyi Galbeed'), (3024, 'SO', 'SOM', NULL, 'Lower Juba'), (3025, 'SO', 'SOM', NULL, 'Middle Juba'), (3026, 'SO', 'SOM', NULL, 'Middle Shabele'), (3027, 'SR', 'SUR', NULL, 'Distrikt Brokopondo'), (3028, 'SR', 'SUR', NULL, 'Distrikt Commewijne'), (3029, 'SR', 'SUR', NULL, 'Distrikt Coronie'), (3030, 'SR', 'SUR', NULL, 'Distrikt Marowijne'), (3031, 'SR', 'SUR', NULL, 'Distrikt Nickerie'), (3032, 'SR', 'SUR', NULL, 'Distrikt Para'), (3033, 'SR', 'SUR', NULL, 'Distrikt Paramaribo'), (3034, 'SR', 'SUR', NULL, 'Distrikt Saramacca'), (3035, 'SR', 'SUR', NULL, 'Distrikt Sipaliwini'), (3036, 'SR', 'SUR', NULL, 'Distrikt Wanica'), (3037, 'ST', 'STP', NULL, 'Príncipe'), (3038, 'ST', 'STP', NULL, 'São Tomé'), (3039, 'SV', 'SLV', NULL, 'Departamento de Ahuachapán'), (3040, 'SV', 'SLV', NULL, 'Departamento de Cabañas'), (3041, 'SV', 'SLV', NULL, 'Departamento de Chalatenango'), (3042, 'SV', 'SLV', NULL, 'Departamento de Cuscatlán'), (3043, 'SV', 'SLV', NULL, 'Departamento de La Libertad'), (3044, 'SV', 'SLV', NULL, 'Departamento de La Paz'), (3045, 'SV', 'SLV', NULL, 'Departamento de La Unión'), (3046, 'SV', 'SLV', NULL, 'Departamento de Morazán'), (3047, 'SV', 'SLV', NULL, 'Departamento de San Miguel'), (3048, 'SV', 'SLV', NULL, 'Departamento de San Salvador'), (3049, 'SV', 'SLV', NULL, 'Departamento de San Vicente'), (3050, 'SV', 'SLV', NULL, 'Departamento de Santa Ana'), (3051, 'SV', 'SLV', NULL, 'Departamento de Sonsonate'), (3052, 'SV', 'SLV', NULL, 'Departamento de Usulután'), (3053, 'SY', 'SYR', NULL, 'Aleppo'), (3054, 'SY', 'SYR', NULL, 'Al-Hasakah'), (3055, 'SY', 'SYR', NULL, 'Ar-Raqqah'), (3056, 'SY', 'SYR', NULL, 'As-Suwayda'), (3057, 'SY', 'SYR', NULL, 'Damascus City'), (3058, 'SY', 'SYR', NULL, 'Daraa'), (3059, 'SY', 'SYR', NULL, 'Deir ez-Zor'), (3060, 'SY', 'SYR', NULL, 'Hama Governorate'), (3061, 'SY', 'SYR', NULL, 'Homs'), (3062, 'SY', 'SYR', NULL, 'Idlib'), (3063, 'SY', 'SYR', NULL, 'Latakia'), (3064, 'SY', 'SYR', NULL, 'Quneitra'), (3065, 'SY', 'SYR', NULL, 'Rif-dimashq'), (3066, 'SY', 'SYR', NULL, 'Tartus'), (3067, 'SZ', 'SWZ', NULL, 'Hhohho District'), (3068, 'SZ', 'SWZ', NULL, 'Lubombo District'), (3069, 'SZ', 'SWZ', NULL, 'Manzini District'), (3070, 'SZ', 'SWZ', NULL, 'Shiselweni District'), (3071, 'TD', 'TCD', NULL, 'Préfecture du Batha'), (3072, 'TD', 'TCD', NULL, 'Préfecture du Biltine'), (3073, 'TD', 'TCD', NULL, 'Préfecture du Borkou-Ennedi-Tibesti'), (3074, 'TD', 'TCD', NULL, 'Préfecture du Chari-Baguirmi'), (3075, 'TD', 'TCD', NULL, 'Préfecture du Guéra'), (3076, 'TD', 'TCD', NULL, 'Préfecture du Kanem'), (3077, 'TD', 'TCD', NULL, 'Préfecture du Lac'), (3078, 'TD', 'TCD', NULL, 'Préfecture du Logone Occidental'), (3079, 'TD', 'TCD', NULL, 'Préfecture du Logone Oriental'), (3080, 'TD', 'TCD', NULL, 'Préfecture du Mayo-Kébbi'), (3081, 'TD', 'TCD', NULL, 'Préfecture du Moyen-Chari'), (3082, 'TD', 'TCD', NULL, 'Préfecture du Ouaddaï'), (3083, 'TD', 'TCD', NULL, 'Préfecture du Salamat'), (3084, 'TD', 'TCD', NULL, 'Préfecture du Tandjilé'), (3085, 'TF', 'ATF', NULL, 'District de Crozet'), (3086, 'TF', 'ATF', NULL, 'District de Kerguelen'), (3087, 'TF', 'ATF', NULL, 'District de Saint-Paul-et-Amsterdam'), (3088, 'TF', 'ATF', NULL, 'District de Terre Adélie'), (3089, 'TF', 'ATF', NULL, 'District des Îles Éparses'), (3090, 'TG', 'TGO', NULL, 'Région Centrale'), (3091, 'TG', 'TGO', NULL, 'Région de la Kara'), (3092, 'TG', 'TGO', NULL, 'Région des Plateaux'), (3093, 'TG', 'TGO', NULL, 'Région des Savanes'), (3094, 'TG', 'TGO', NULL, 'Région Maritime'), (3095, 'TH', 'THA', NULL, 'Bangkok'), (3096, 'TH', 'THA', NULL, 'Changawat Chanthaburi'), (3097, 'TH', 'THA', NULL, 'Changwat Amnat Charoen'), (3098, 'TH', 'THA', NULL, 'Changwat Ang Thong'), (3099, 'TH', 'THA', NULL, 'Changwat Buriram'), (3100, 'TH', 'THA', NULL, 'Changwat Chachoengsao'), (3101, 'TH', 'THA', NULL, 'Changwat Chai Nat'), (3102, 'TH', 'THA', NULL, 'Changwat Chaiyaphum'), (3103, 'TH', 'THA', NULL, 'Changwat Chiang Mai'), (3104, 'TH', 'THA', NULL, 'Changwat Chiang Rai'), (3105, 'TH', 'THA', NULL, 'Changwat Chon Buri'), (3106, 'TH', 'THA', NULL, 'Changwat Chumphon'), (3107, 'TH', 'THA', NULL, 'Changwat Kalasin'), (3108, 'TH', 'THA', NULL, 'Changwat Kamphaeng Phet'), (3109, 'TH', 'THA', NULL, 'Changwat Kanchanaburi'), (3110, 'TH', 'THA', NULL, 'Changwat Khon Kaen'), (3111, 'TH', 'THA', NULL, 'Changwat Krabi'), (3112, 'TH', 'THA', NULL, 'Changwat Lampang'), (3113, 'TH', 'THA', NULL, 'Changwat Lamphun'), (3114, 'TH', 'THA', NULL, 'Changwat Loei'), (3115, 'TH', 'THA', NULL, 'Changwat Lop Buri'), (3116, 'TH', 'THA', NULL, 'Changwat Mae Hong Son'), (3117, 'TH', 'THA', NULL, 'Changwat Maha Sarakham'), (3118, 'TH', 'THA', NULL, 'Changwat Mukdahan'), (3119, 'TH', 'THA', NULL, 'Changwat Nakhon Nayok'), (3120, 'TH', 'THA', NULL, 'Changwat Nakhon Pathom'), (3121, 'TH', 'THA', NULL, 'Changwat Nakhon Phanom'), (3122, 'TH', 'THA', NULL, 'Changwat Nakhon Ratchasima'), (3123, 'TH', 'THA', NULL, 'Changwat Nakhon Sawan'), (3124, 'TH', 'THA', NULL, 'Changwat Nakhon Si Thammarat'), (3125, 'TH', 'THA', NULL, 'Changwat Nan'), (3126, 'TH', 'THA', NULL, 'Changwat Narathiwat'), (3127, 'TH', 'THA', NULL, 'Changwat Nong Bua Lamphu'), (3128, 'TH', 'THA', NULL, 'Changwat Nong Khai'), (3129, 'TH', 'THA', NULL, 'Changwat Nonthaburi'), (3130, 'TH', 'THA', NULL, 'Changwat Pathum Thani'), (3131, 'TH', 'THA', NULL, 'Changwat Pattani'), (3132, 'TH', 'THA', NULL, 'Changwat Phangnga'), (3133, 'TH', 'THA', NULL, 'Changwat Phatthalung'), (3134, 'TH', 'THA', NULL, 'Changwat Phayao'), (3135, 'TH', 'THA', NULL, 'Changwat Phetchabun'), (3136, 'TH', 'THA', NULL, 'Changwat Phetchaburi'), (3137, 'TH', 'THA', NULL, 'Changwat Phichit'), (3138, 'TH', 'THA', NULL, 'Changwat Phitsanulok'), (3139, 'TH', 'THA', NULL, 'Changwat Phra Nakhon'), (3140, 'TH', 'THA', NULL, 'Changwat Phra Nakhon Si Ayutthaya'), (3141, 'TH', 'THA', NULL, 'Changwat Phrae'), (3142, 'TH', 'THA', NULL, 'Changwat Phuket'), (3143, 'TH', 'THA', NULL, 'Changwat Prachin Buri'), (3144, 'TH', 'THA', NULL, 'Changwat Prachuap Khiri Khan'), (3145, 'TH', 'THA', NULL, 'Changwat Ranong'), (3146, 'TH', 'THA', NULL, 'Changwat Ratchaburi'), (3147, 'TH', 'THA', NULL, 'Changwat Rayong'), (3148, 'TH', 'THA', NULL, 'Changwat Roi Et'), (3149, 'TH', 'THA', NULL, 'Changwat Sa Kaeo'), (3150, 'TH', 'THA', NULL, 'Changwat Sakon Nakhon'), (3151, 'TH', 'THA', NULL, 'Changwat Samut Prakan'), (3152, 'TH', 'THA', NULL, 'Changwat Samut Sakhon'), (3153, 'TH', 'THA', NULL, 'Changwat Samut Songkhram'), (3154, 'TH', 'THA', NULL, 'Changwat Sara Buri'), (3155, 'TH', 'THA', NULL, 'Changwat Satun'), (3156, 'TH', 'THA', NULL, 'Changwat Sing Buri'), (3157, 'TH', 'THA', NULL, 'Changwat Sisaket'), (3158, 'TH', 'THA', NULL, 'Changwat Songkhla'), (3159, 'TH', 'THA', NULL, 'Changwat Sukhothai'), (3160, 'TH', 'THA', NULL, 'Changwat Suphan Buri'), (3161, 'TH', 'THA', NULL, 'Changwat Surat Thani'), (3162, 'TH', 'THA', NULL, 'Changwat Surin'), (3163, 'TH', 'THA', NULL, 'Changwat Tak'), (3164, 'TH', 'THA', NULL, 'Changwat Trang'), (3165, 'TH', 'THA', NULL, 'Changwat Trat'), (3166, 'TH', 'THA', NULL, 'Changwat Ubon Ratchathani'), (3167, 'TH', 'THA', NULL, 'Changwat Udon Thani'), (3168, 'TH', 'THA', NULL, 'Changwat Uthai Thani'), (3169, 'TH', 'THA', NULL, 'Changwat Uttaradit'), (3170, 'TH', 'THA', NULL, 'Changwat Yala'), (3171, 'TH', 'THA', NULL, 'Changwat Yasothon'), (3172, 'TJ', 'TJK', NULL, 'Gorno-Badakhshan'), (3173, 'TJ', 'TJK', NULL, 'Kulyabskaya Oblast\''), (3174, 'TJ', 'TJK', NULL, 'Kurgan-Tyubinskaya Oblast\''), (3175, 'TJ', 'TJK', NULL, 'Region of Republican Subordination'), (3176, 'TJ', 'TJK', NULL, 'Viloyati Khatlon'), (3177, 'TJ', 'TJK', NULL, 'Viloyati Sughd'), (3178, 'TL', 'TLS', NULL, 'Aileu'), (3179, 'TL', 'TLS', NULL, 'Ainaro'), (3180, 'TL', 'TLS', NULL, 'Baucau'), (3181, 'TL', 'TLS', NULL, 'Bobonaro'), (3182, 'TL', 'TLS', NULL, 'Cova Lima'), (3183, 'TL', 'TLS', NULL, 'Dili'), (3184, 'TL', 'TLS', NULL, 'Ermera'), (3185, 'TL', 'TLS', NULL, 'Lautem'), (3186, 'TL', 'TLS', NULL, 'Liquica'), (3187, 'TL', 'TLS', NULL, 'Manatuto'), (3188, 'TL', 'TLS', NULL, 'Manufahi'), (3189, 'TL', 'TLS', NULL, 'Oecussi'), (3190, 'TL', 'TLS', NULL, 'Viqueque'), (3191, 'TM', 'TKM', NULL, 'Ahal Welaýaty'), (3192, 'TM', 'TKM', NULL, 'Balkan Welaýaty'), (3193, 'TM', 'TKM', NULL, 'Daşoguz Welaýaty'), (3194, 'TM', 'TKM', NULL, 'Lebap Welaýaty'), (3195, 'TM', 'TKM', NULL, 'Mary Welaýaty'), (3196, 'TN', 'TUN', NULL, 'Gouvernorat de Ariana'), (3197, 'TN', 'TUN', NULL, 'Gouvernorat de Béja'), (3198, 'TN', 'TUN', NULL, 'Gouvernorat de Ben Arous'), (3199, 'TN', 'TUN', NULL, 'Gouvernorat de Bizerte'), (3200, 'TN', 'TUN', NULL, 'Gouvernorat de Gabès'), (3201, 'TN', 'TUN', NULL, 'Gouvernorat de Gafsa'), (3202, 'TN', 'TUN', NULL, 'Gouvernorat de Jendouba'), (3203, 'TN', 'TUN', NULL, 'Gouvernorat de Kairouan'), (3204, 'TN', 'TUN', NULL, 'Gouvernorat de Kasserine'), (3205, 'TN', 'TUN', NULL, 'Gouvernorat de Kebili'), (3206, 'TN', 'TUN', NULL, 'Gouvernorat de Kef'), (3207, 'TN', 'TUN', NULL, 'Gouvernorat de la Manouba'), (3208, 'TN', 'TUN', NULL, 'Gouvernorat de Mahdia'), (3209, 'TN', 'TUN', NULL, 'Gouvernorat de Médenine'), (3210, 'TN', 'TUN', NULL, 'Gouvernorat de Monastir'), (3211, 'TN', 'TUN', NULL, 'Gouvernorat de Nabeul'), (3212, 'TN', 'TUN', NULL, 'Gouvernorat de Sfax'), (3213, 'TN', 'TUN', NULL, 'Gouvernorat de Sidi Bou Zid'), (3214, 'TN', 'TUN', NULL, 'Gouvernorat de Siliana'), (3215, 'TN', 'TUN', NULL, 'Gouvernorat de Sousse'), (3216, 'TN', 'TUN', NULL, 'Gouvernorat de Tataouine'), (3217, 'TN', 'TUN', NULL, 'Gouvernorat de Tozeur'), (3218, 'TN', 'TUN', NULL, 'Gouvernorat de Tunis'), (3219, 'TN', 'TUN', NULL, 'Gouvernorat de Zaghouan'), (3220, 'TN', 'TUN', NULL, 'Tunis al Janubiyah Wilayat'), (3221, 'TR', 'TUR', NULL, 'Adana Province'), (3222, 'TR', 'TUR', NULL, 'Adıyaman'), (3223, 'TR', 'TUR', NULL, 'Afyonkarahisar'), (3224, 'TR', 'TUR', NULL, 'Ağrı Province'), (3225, 'TR', 'TUR', NULL, 'Aksaray Province'), (3226, 'TR', 'TUR', NULL, 'Amasya Province'), (3227, 'TR', 'TUR', NULL, 'Ankara Province'), (3228, 'TR', 'TUR', NULL, 'Antalya Province'), (3229, 'TR', 'TUR', NULL, 'Ardahan Province'), (3230, 'TR', 'TUR', NULL, 'Artvin Province'), (3231, 'TR', 'TUR', NULL, 'Aydın Province'), (3232, 'TR', 'TUR', NULL, 'Balıkesir Province'), (3233, 'TR', 'TUR', NULL, 'Bartın Province'), (3234, 'TR', 'TUR', NULL, 'Batman Province'), (3235, 'TR', 'TUR', NULL, 'Bayburt'), (3236, 'TR', 'TUR', NULL, 'Bilecik Province'), (3237, 'TR', 'TUR', NULL, 'Bingöl Province'), (3238, 'TR', 'TUR', NULL, 'Bitlis Province'), (3239, 'TR', 'TUR', NULL, 'Bolu Province'), (3240, 'TR', 'TUR', NULL, 'Burdur Province'), (3241, 'TR', 'TUR', NULL, 'Bursa'), (3242, 'TR', 'TUR', NULL, 'Çanakkale Province'), (3243, 'TR', 'TUR', NULL, 'Çankırı Province'), (3244, 'TR', 'TUR', NULL, 'Çorum Province'), (3245, 'TR', 'TUR', NULL, 'Denizli Province'), (3246, 'TR', 'TUR', NULL, 'Diyarbakır'), (3247, 'TR', 'TUR', NULL, 'Düzce'), (3248, 'TR', 'TUR', NULL, 'Edirne Province'), (3249, 'TR', 'TUR', NULL, 'Elazığ'), (3250, 'TR', 'TUR', NULL, 'Erzincan Province'), (3251, 'TR', 'TUR', NULL, 'Erzurum Province'), (3252, 'TR', 'TUR', NULL, 'Gaziantep Province'), (3253, 'TR', 'TUR', NULL, 'Giresun Province'), (3254, 'TR', 'TUR', NULL, 'Gümüşhane'), (3255, 'TR', 'TUR', NULL, 'Hakkâri Province'), (3256, 'TR', 'TUR', NULL, 'Hatay Province'), (3257, 'TR', 'TUR', NULL, 'Iğdır Province'), (3258, 'TR', 'TUR', NULL, 'Isparta Province'), (3259, 'TR', 'TUR', NULL, 'Istanbul'), (3260, 'TR', 'TUR', NULL, 'İzmir'), (3261, 'TR', 'TUR', NULL, 'Kahramanmaraş Province'), (3262, 'TR', 'TUR', NULL, 'Karabük'), (3263, 'TR', 'TUR', NULL, 'Karaman Province'), (3264, 'TR', 'TUR', NULL, 'Kars'), (3265, 'TR', 'TUR', NULL, 'Kastamonu Province'), (3266, 'TR', 'TUR', NULL, 'Kayseri Province'), (3267, 'TR', 'TUR', NULL, 'Kilis Province'), (3268, 'TR', 'TUR', NULL, 'Kırıkkale Province'), (3269, 'TR', 'TUR', NULL, 'Kırklareli Province'), (3270, 'TR', 'TUR', NULL, 'Kırşehir Province'), (3271, 'TR', 'TUR', NULL, 'Kocaeli Province'), (3272, 'TR', 'TUR', NULL, 'Konya Province'); INSERT INTO `ma_DCountryState` (`id`, `countryId`, `countryIsoAlpha3`, `abbreviation`, `name`) VALUES (3273, 'TR', 'TUR', NULL, 'Kütahya Province'), (3274, 'TR', 'TUR', NULL, 'Malatya Province'), (3275, 'TR', 'TUR', NULL, 'Manisa Province'), (3276, 'TR', 'TUR', NULL, 'Mardin Province'), (3277, 'TR', 'TUR', NULL, 'Mersin Province'), (3278, 'TR', 'TUR', NULL, 'Muğla Province'), (3279, 'TR', 'TUR', NULL, 'Muş Province'), (3280, 'TR', 'TUR', NULL, 'Nevşehir'), (3281, 'TR', 'TUR', NULL, 'Niğde'), (3282, 'TR', 'TUR', NULL, 'Ordu'), (3283, 'TR', 'TUR', NULL, 'Osmaniye Province'), (3284, 'TR', 'TUR', NULL, 'Rize'), (3285, 'TR', 'TUR', NULL, 'Sakarya Province'), (3286, 'TR', 'TUR', NULL, 'Samsun Province'), (3287, 'TR', 'TUR', NULL, 'Şanlıurfa Province'), (3288, 'TR', 'TUR', NULL, 'Siirt Province'), (3289, 'TR', 'TUR', NULL, 'Sinop Province'), (3290, 'TR', 'TUR', NULL, 'Şırnak Province'), (3291, 'TR', 'TUR', NULL, 'Sivas Province'), (3292, 'TR', 'TUR', NULL, 'Tekirdağ Province'), (3293, 'TR', 'TUR', NULL, 'Tokat'), (3294, 'TR', 'TUR', NULL, 'Trabzon Province'), (3295, 'TR', 'TUR', NULL, 'Tunceli Province'), (3296, 'TR', 'TUR', NULL, 'Uşak Province'), (3297, 'TR', 'TUR', NULL, 'Van Province'), (3298, 'TR', 'TUR', NULL, 'Yalova Province'), (3299, 'TR', 'TUR', NULL, 'Yozgat Province'), (3300, 'TR', 'TUR', NULL, 'Zonguldak'), (3301, 'TT', 'TTO', NULL, 'Arima'), (3302, 'TT', 'TTO', NULL, 'County of Caroni'), (3303, 'TT', 'TTO', NULL, 'County of Mayaro'), (3304, 'TT', 'TTO', NULL, 'County of Nariva'), (3305, 'TT', 'TTO', NULL, 'County of Saint Andrew'), (3306, 'TT', 'TTO', NULL, 'County of Saint David'), (3307, 'TT', 'TTO', NULL, 'County of Saint George'), (3308, 'TT', 'TTO', NULL, 'County of Saint Patrick'), (3309, 'TT', 'TTO', NULL, 'County of Victoria'), (3310, 'TT', 'TTO', NULL, 'Port-of-Spain'), (3311, 'TT', 'TTO', NULL, 'San Fernando'), (3312, 'TT', 'TTO', NULL, 'Ward of Tobago'), (3313, 'TW', 'TWN', NULL, 'Chang-hua Hsien'), (3314, 'TW', 'TWN', NULL, 'Chia-i Hsien'), (3315, 'TW', 'TWN', NULL, 'Chia-i Shih'), (3316, 'TW', 'TWN', NULL, 'Chi-lung Shih'), (3317, 'TW', 'TWN', NULL, 'Chin-men Hsien'), (3318, 'TW', 'TWN', NULL, 'Hsin-chu Hsien'), (3319, 'TW', 'TWN', NULL, 'Hsin-chu Shih'), (3320, 'TW', 'TWN', NULL, 'Hua-lien Hsien'), (3321, 'TW', 'TWN', NULL, 'I-lan Hsien'), (3322, 'TW', 'TWN', NULL, 'Kao-hsiung Hsien'), (3323, 'TW', 'TWN', NULL, 'Kao-hsiung Shih'), (3324, 'TW', 'TWN', NULL, 'Lien-chiang Hsien'), (3325, 'TW', 'TWN', NULL, 'Miao-li Hsien'), (3326, 'TW', 'TWN', NULL, 'Nan-t’ou Hsien'), (3327, 'TW', 'TWN', NULL, 'P’eng-hu Hsien'), (3328, 'TW', 'TWN', NULL, 'P’ing-tung Hsien'), (3329, 'TW', 'TWN', NULL, 'T’ai-chung Hsien'), (3330, 'TW', 'TWN', NULL, 'T’ai-chung Shih'), (3331, 'TW', 'TWN', NULL, 'T’ai-nan Hsien'), (3332, 'TW', 'TWN', NULL, 'T’ai-nan Shih'), (3333, 'TW', 'TWN', NULL, 'T’ai-pei Hsien'), (3334, 'TW', 'TWN', NULL, 'T’ai-pei Shih'), (3335, 'TW', 'TWN', NULL, 'T’ai-tung Hsien'), (3336, 'TW', 'TWN', NULL, 'T’ao-yüan Hsien'), (3337, 'TW', 'TWN', NULL, 'Yün-lin Hsien'), (3338, 'TZ', 'TZA', NULL, 'Arusha Region'), (3339, 'TZ', 'TZA', NULL, 'Dar es Salaam Region'), (3340, 'TZ', 'TZA', NULL, 'Dodoma Region'), (3341, 'TZ', 'TZA', NULL, 'Iringa Region'), (3342, 'TZ', 'TZA', NULL, 'Kagera Region'), (3343, 'TZ', 'TZA', NULL, 'Kigoma Region'), (3344, 'TZ', 'TZA', NULL, 'Kilimanjaro Region'), (3345, 'TZ', 'TZA', NULL, 'Lindi Region'), (3346, 'TZ', 'TZA', NULL, 'Manyara Region'), (3347, 'TZ', 'TZA', NULL, 'Mara Region'), (3348, 'TZ', 'TZA', NULL, 'Mbeya Region'), (3349, 'TZ', 'TZA', NULL, 'Morogoro Region'), (3350, 'TZ', 'TZA', NULL, 'Mtwara Region'), (3351, 'TZ', 'TZA', NULL, 'Mwanza Region'), (3352, 'TZ', 'TZA', NULL, 'Pemba North Region'), (3353, 'TZ', 'TZA', NULL, 'Pemba South Region'), (3354, 'TZ', 'TZA', NULL, 'Pwani Region'), (3355, 'TZ', 'TZA', NULL, 'Rukwa Region'), (3356, 'TZ', 'TZA', NULL, 'Ruvuma Region'), (3357, 'TZ', 'TZA', NULL, 'Shinyanga Region'), (3358, 'TZ', 'TZA', NULL, 'Singida Region'), (3359, 'TZ', 'TZA', NULL, 'Tabora Region'), (3360, 'TZ', 'TZA', NULL, 'Tanga Region'), (3361, 'TZ', 'TZA', NULL, 'Zanzibar Central/South Region'), (3362, 'TZ', 'TZA', NULL, 'Zanzibar North Region'), (3363, 'TZ', 'TZA', NULL, 'Zanzibar Urban/West Region'), (3364, 'UA', 'UKR', NULL, 'Avtonomna Respublika Krym'), (3365, 'UA', 'UKR', NULL, 'Cherkas\'ka Oblast\''), (3366, 'UA', 'UKR', NULL, 'Chernihivs\'ka Oblast\''), (3367, 'UA', 'UKR', NULL, 'Chernivets\'ka Oblast\''), (3368, 'UA', 'UKR', NULL, 'Dnipropetrovs\'ka Oblast\''), (3369, 'UA', 'UKR', NULL, 'Donets\'ka Oblast\''), (3370, 'UA', 'UKR', NULL, 'Ivano-Frankivs\'ka Oblast\''), (3371, 'UA', 'UKR', NULL, 'Kharkivs\'ka Oblast\''), (3372, 'UA', 'UKR', NULL, 'Kherson Oblast'), (3373, 'UA', 'UKR', NULL, 'Khmel\'nyts\'ka Oblast\''), (3374, 'UA', 'UKR', NULL, 'Kiev Oblast'), (3375, 'UA', 'UKR', NULL, 'Kirovohrads\'ka Oblast\''), (3376, 'UA', 'UKR', NULL, 'Luhans\'ka Oblast\''), (3377, 'UA', 'UKR', NULL, 'L\'vivs\'ka Oblast\''), (3378, 'UA', 'UKR', NULL, 'Misto Kyyiv'), (3379, 'UA', 'UKR', NULL, 'Misto Sevastopol\''), (3380, 'UA', 'UKR', NULL, 'Mykolayivs\'ka Oblast\''), (3381, 'UA', 'UKR', NULL, 'Odessa Oblast'), (3382, 'UA', 'UKR', NULL, 'Poltava Oblast'), (3383, 'UA', 'UKR', NULL, 'Rivnens\'ka Oblast\''), (3384, 'UA', 'UKR', NULL, 'Sumy Oblast'), (3385, 'UA', 'UKR', NULL, 'Ternopil\'s\'ka Oblast\''), (3386, 'UA', 'UKR', NULL, 'Vinnyts\'ka Oblast\''), (3387, 'UA', 'UKR', NULL, 'Volyns\'ka Oblast\''), (3388, 'UA', 'UKR', NULL, 'Zakarpats\'ka Oblast\''), (3389, 'UA', 'UKR', NULL, 'Zaporiz\'ka Oblast\''), (3390, 'UA', 'UKR', NULL, 'Zhytomyrs\'ka Oblast\''), (3391, 'UG', 'UGA', NULL, 'Apac District'), (3392, 'UG', 'UGA', NULL, 'Arua District'), (3393, 'UG', 'UGA', NULL, 'Bugiri District'), (3394, 'UG', 'UGA', NULL, 'Bundibugyo District'), (3395, 'UG', 'UGA', NULL, 'Bushenyi District'), (3396, 'UG', 'UGA', NULL, 'Busia District'), (3397, 'UG', 'UGA', NULL, 'Busoga Province'), (3398, 'UG', 'UGA', NULL, 'Eastern Province'), (3399, 'UG', 'UGA', NULL, 'Gulu District'), (3400, 'UG', 'UGA', NULL, 'Hoima District'), (3401, 'UG', 'UGA', NULL, 'Iganga District'), (3402, 'UG', 'UGA', NULL, 'Jinja District'), (3403, 'UG', 'UGA', NULL, 'Kabale District'), (3404, 'UG', 'UGA', NULL, 'Kabarole District'), (3405, 'UG', 'UGA', NULL, 'Kaberamaido District'), (3406, 'UG', 'UGA', NULL, 'Kalangala District'), (3407, 'UG', 'UGA', NULL, 'Kampala District'), (3408, 'UG', 'UGA', NULL, 'Kamuli District'), (3409, 'UG', 'UGA', NULL, 'Kamwenge District'), (3410, 'UG', 'UGA', NULL, 'Kanungu District'), (3411, 'UG', 'UGA', NULL, 'Kapchorwa District'), (3412, 'UG', 'UGA', NULL, 'Kasese District'), (3413, 'UG', 'UGA', NULL, 'Katakwi District'), (3414, 'UG', 'UGA', NULL, 'Kayunga District'), (3415, 'UG', 'UGA', NULL, 'Kibale District'), (3416, 'UG', 'UGA', NULL, 'Kiboga District'), (3417, 'UG', 'UGA', NULL, 'Kisoro District'), (3418, 'UG', 'UGA', NULL, 'Kitgum District'), (3419, 'UG', 'UGA', NULL, 'Kotido District'), (3420, 'UG', 'UGA', NULL, 'Kumi District'), (3421, 'UG', 'UGA', NULL, 'Kyenjojo District'), (3422, 'UG', 'UGA', NULL, 'Lira District'), (3423, 'UG', 'UGA', NULL, 'Luwero District'), (3424, 'UG', 'UGA', NULL, 'Masaka District'), (3425, 'UG', 'UGA', NULL, 'Masindi District'), (3426, 'UG', 'UGA', NULL, 'Mayuge District'), (3427, 'UG', 'UGA', NULL, 'Mbale District'), (3428, 'UG', 'UGA', NULL, 'Mbarara District'), (3429, 'UG', 'UGA', NULL, 'Moroto'), (3430, 'UG', 'UGA', NULL, 'Moroto District'), (3431, 'UG', 'UGA', NULL, 'Moyo District'), (3432, 'UG', 'UGA', NULL, 'Mpigi District'), (3433, 'UG', 'UGA', NULL, 'Mubende District'), (3434, 'UG', 'UGA', NULL, 'Mukono District'), (3435, 'UG', 'UGA', NULL, 'Nakapiripirit District'), (3436, 'UG', 'UGA', NULL, 'Nakasongola District'), (3437, 'UG', 'UGA', NULL, 'Nebbi District'), (3438, 'UG', 'UGA', NULL, 'Nile Province'), (3439, 'UG', 'UGA', NULL, 'North Buganda Province'), (3440, 'UG', 'UGA', NULL, 'Northern Province'), (3441, 'UG', 'UGA', NULL, 'Ntungamo District'), (3442, 'UG', 'UGA', NULL, 'Pader District'), (3443, 'UG', 'UGA', NULL, 'Pallisa District'), (3444, 'UG', 'UGA', NULL, 'Rakai District'), (3445, 'UG', 'UGA', NULL, 'Rukungiri District'), (3446, 'UG', 'UGA', NULL, 'Sembabule District'), (3447, 'UG', 'UGA', NULL, 'Sironko District'), (3448, 'UG', 'UGA', NULL, 'Soroti District'), (3449, 'UG', 'UGA', NULL, 'Southern Province'), (3450, 'UG', 'UGA', NULL, 'Tororo District'), (3451, 'UG', 'UGA', NULL, 'Wakiso District'), (3452, 'UG', 'UGA', NULL, 'Western Province'), (3453, 'UG', 'UGA', NULL, 'Yumbe District'), (3454, 'US', 'USA', 'AL', 'Alabama'), (3455, 'US', 'USA', 'AK', 'Alaska'), (3456, 'US', 'USA', 'AZ', 'Arizona'), (3457, 'US', 'USA', 'AR', 'Arkansas'), (3458, 'US', 'USA', 'CA', 'California'), (3459, 'US', 'USA', 'CO', 'Colorado'), (3460, 'US', 'USA', 'CT', 'Connecticut'), (3461, 'US', 'USA', 'DE', 'Delaware'), (3462, 'US', 'USA', 'DC', 'District of Columbia'), (3463, 'US', 'USA', 'FL', 'Florida'), (3464, 'US', 'USA', 'GA', 'Georgia'), (3465, 'US', 'USA', 'HI', 'Hawaii'), (3466, 'US', 'USA', 'ID', 'Idaho'), (3467, 'US', 'USA', 'IL', 'Illinois'), (3468, 'US', 'USA', 'IN', 'Indiana'), (3469, 'US', 'USA', 'IA', 'Iowa'), (3470, 'US', 'USA', 'KS', 'Kansas'), (3471, 'US', 'USA', 'KY', 'Kentucky'), (3472, 'US', 'USA', 'LA', 'Louisiana'), (3473, 'US', 'USA', 'ME', 'Maine'), (3474, 'US', 'USA', 'MD', 'Maryland'), (3475, 'US', 'USA', 'MA', 'Massachusetts'), (3476, 'US', 'USA', 'MI', 'Michigan'), (3477, 'US', 'USA', 'MN', 'Minnesota'), (3478, 'US', 'USA', 'MS', 'Mississippi'), (3479, 'US', 'USA', 'MO', 'Missouri'), (3480, 'US', 'USA', 'MT', 'Montana'), (3481, 'US', 'USA', 'NE', 'Nebraska'), (3482, 'US', 'USA', 'NV', 'Nevada'), (3483, 'US', 'USA', 'NH', 'New Hampshire'), (3484, 'US', 'USA', 'NJ', 'New Jersey'), (3485, 'US', 'USA', 'NM', 'New Mexico'), (3486, 'US', 'USA', 'NY', 'New York'), (3487, 'US', 'USA', 'NC', 'North Carolina'), (3488, 'US', 'USA', 'ND', 'North Dakota'), (3489, 'US', 'USA', 'OH', 'Ohio'), (3490, 'US', 'USA', 'OK', 'Oklahoma'), (3491, 'US', 'USA', 'OR', 'Oregon'), (3492, 'US', 'USA', 'PA', 'Pennsylvania'), (3493, 'US', 'USA', 'RI', 'Rhode Island'), (3494, 'US', 'USA', 'SC', 'South Carolina'), (3495, 'US', 'USA', 'SD', 'South Dakota'), (3496, 'US', 'USA', 'TN', 'Tennessee'), (3497, 'US', 'USA', 'TX', 'Texas'), (3498, 'US', 'USA', 'UT', 'Utah'), (3499, 'US', 'USA', 'VT', 'Vermont'), (3500, 'US', 'USA', 'VA', 'Virginia'), (3501, 'US', 'USA', 'WA', 'Washington'), (3502, 'US', 'USA', 'WV', 'West Virginia'), (3503, 'US', 'USA', 'WI', 'Wisconsin'), (3504, 'US', 'USA', 'WY', 'Wyoming'), (3505, 'UY', 'URY', NULL, 'Artigas Department'), (3506, 'UY', 'URY', NULL, 'Canelones Department'), (3507, 'UY', 'URY', NULL, 'Cerro Largo Department'), (3508, 'UY', 'URY', NULL, 'Colonia Department'), (3509, 'UY', 'URY', NULL, 'Departamento de Durazno'), (3510, 'UY', 'URY', NULL, 'Departamento de Flores'), (3511, 'UY', 'URY', NULL, 'Departamento de Montevideo'), (3512, 'UY', 'URY', NULL, 'Departamento de Paysandú'), (3513, 'UY', 'URY', NULL, 'Departamento de Río Negro'), (3514, 'UY', 'URY', NULL, 'Departamento de Rivera'), (3515, 'UY', 'URY', NULL, 'Departamento de Rocha'), (3516, 'UY', 'URY', NULL, 'Departamento de Salto'), (3517, 'UY', 'URY', NULL, 'Departamento de San José'), (3518, 'UY', 'URY', NULL, 'Departamento de Tacuarembó'), (3519, 'UY', 'URY', NULL, 'Departamento de Treinta y Tres'), (3520, 'UY', 'URY', NULL, 'Florida Department'), (3521, 'UY', 'URY', NULL, 'Lavalleja Department'), (3522, 'UY', 'URY', NULL, 'Maldonado Department'), (3523, 'UY', 'URY', NULL, 'Soriano Department'), (3524, 'UZ', 'UZB', NULL, 'Andijon Viloyati'), (3525, 'UZ', 'UZB', NULL, 'Buxoro Viloyati'), (3526, 'UZ', 'UZB', NULL, 'Farg`ona Viloyati'), (3527, 'UZ', 'UZB', NULL, 'Jizzax Viloyati'), (3528, 'UZ', 'UZB', NULL, 'Karakalpakstan'), (3529, 'UZ', 'UZB', NULL, 'Namangan Viloyati'), (3530, 'UZ', 'UZB', NULL, 'Navoiy Viloyati'), (3531, 'UZ', 'UZB', NULL, 'Qashqadaryo Viloyati'), (3532, 'UZ', 'UZB', NULL, 'Samarqand Viloyati'), (3533, 'UZ', 'UZB', NULL, 'Sirdaryo Viloyati'), (3534, 'UZ', 'UZB', NULL, 'Surxondaryo Viloyati'), (3535, 'UZ', 'UZB', NULL, 'Toshkent Shahri'), (3536, 'UZ', 'UZB', NULL, 'Toshkent Viloyati'), (3537, 'UZ', 'UZB', NULL, 'Xorazm Viloyati'), (3538, 'VC', 'VCT', NULL, 'Grenadines'), (3539, 'VC', 'VCT', NULL, 'Parish of Charlotte'), (3540, 'VC', 'VCT', NULL, 'Parish of Saint Andrew'), (3541, 'VC', 'VCT', NULL, 'Parish of Saint David'), (3542, 'VC', 'VCT', NULL, 'Parish of Saint George'), (3543, 'VC', 'VCT', NULL, 'Parish of Saint Patrick'), (3544, 'VE', 'VEN', NULL, 'Dependencias Federales'), (3545, 'VE', 'VEN', NULL, 'Distrito Federal'), (3546, 'VE', 'VEN', NULL, 'Estado Amazonas'), (3547, 'VE', 'VEN', NULL, 'Estado Anzoátegui'), (3548, 'VE', 'VEN', NULL, 'Estado Apure'), (3549, 'VE', 'VEN', NULL, 'Estado Aragua'), (3550, 'VE', 'VEN', NULL, 'Estado Barinas'), (3551, 'VE', 'VEN', NULL, 'Estado Bolívar'), (3552, 'VE', 'VEN', NULL, 'Estado Carabobo'), (3553, 'VE', 'VEN', NULL, 'Estado Cojedes'), (3554, 'VE', 'VEN', NULL, 'Estado Falcón'), (3555, 'VE', 'VEN', NULL, 'Estado Guárico'), (3556, 'VE', 'VEN', NULL, 'Estado Lara'), (3557, 'VE', 'VEN', NULL, 'Estado Mérida'), (3558, 'VE', 'VEN', NULL, 'Estado Miranda'), (3559, 'VE', 'VEN', NULL, 'Estado Monagas'), (3560, 'VE', 'VEN', NULL, 'Estado Portuguesa'), (3561, 'VE', 'VEN', NULL, 'Estado Sucre'), (3562, 'VE', 'VEN', NULL, 'Estado Táchira'), (3563, 'VE', 'VEN', NULL, 'Estado Trujillo'), (3564, 'VE', 'VEN', NULL, 'Estado Vargas'), (3565, 'VE', 'VEN', NULL, 'Estado Yaracuy'), (3566, 'VE', 'VEN', NULL, 'Estado Zulia'), (3567, 'VE', 'VEN', NULL, 'Isla Margarita'), (3568, 'VE', 'VEN', NULL, 'Territorio Federal Delta Amacuro'), (3569, 'VN', 'VNM', NULL, 'B?c Thái T?nh'), (3570, 'VN', 'VNM', NULL, 'H?i Hung T?nh'), (3571, 'VN', 'VNM', NULL, 'Hà B?c T?nh'), (3572, 'VN', 'VNM', NULL, 'Minh H?i T?nh'), (3573, 'VN', 'VNM', NULL, 'Nam Hà T?nh'), (3574, 'VN', 'VNM', NULL, 'Qu?ng Nam-Ðà N?ng T?nh'), (3575, 'VN', 'VNM', NULL, 'Sông Bé T?nh'), (3576, 'VN', 'VNM', NULL, 'Thành Phố Hải Phòng'), (3577, 'VN', 'VNM', NULL, 'Thành phố Hồ Chí Minh'), (3578, 'VN', 'VNM', NULL, 'Thủ Ðô Hà Nội'), (3579, 'VN', 'VNM', NULL, 'Tỉnh An Giang'), (3580, 'VN', 'VNM', NULL, 'Tỉnh Bà Rịa-Vũng Tàu'), (3581, 'VN', 'VNM', NULL, 'Tỉnh Bắc Giang'), (3582, 'VN', 'VNM', NULL, 'Tỉnh Bắc Kạn'), (3583, 'VN', 'VNM', NULL, 'Tỉnh Bạc Liêu'), (3584, 'VN', 'VNM', NULL, 'Tỉnh Bắc Ninh'), (3585, 'VN', 'VNM', NULL, 'Tỉnh Bến Tre'), (3586, 'VN', 'VNM', NULL, 'Tỉnh Bình Ðịnh'), (3587, 'VN', 'VNM', NULL, 'Tỉnh Bình Dương'), (3588, 'VN', 'VNM', NULL, 'Tỉnh Bình Phước'), (3589, 'VN', 'VNM', NULL, 'Tỉnh Bình Thuận'), (3590, 'VN', 'VNM', NULL, 'Tỉnh Cà Mau'), (3591, 'VN', 'VNM', NULL, 'Tỉnh Cần Thơ'), (3592, 'VN', 'VNM', NULL, 'Tỉnh Cao Bằng'), (3593, 'VN', 'VNM', NULL, 'Tỉnh Ðà Nẵng'), (3594, 'VN', 'VNM', NULL, 'Tỉnh Ðắc Lắk'), (3595, 'VN', 'VNM', NULL, 'Tỉnh Ðồng Nai'), (3596, 'VN', 'VNM', NULL, 'Tỉnh Ðồng Tháp'), (3597, 'VN', 'VNM', NULL, 'Tỉnh Gia Lai'), (3598, 'VN', 'VNM', NULL, 'Tỉnh Hà Giang'), (3599, 'VN', 'VNM', NULL, 'Tỉnh Hà Nam'), (3600, 'VN', 'VNM', NULL, 'Tỉnh Hà Tây'), (3601, 'VN', 'VNM', NULL, 'Tỉnh Hà Tĩnh'), (3602, 'VN', 'VNM', NULL, 'Tỉnh Hải Dương'), (3603, 'VN', 'VNM', NULL, 'Tỉnh Hòa Bình'), (3604, 'VN', 'VNM', NULL, 'Tỉnh Hưng Yên'), (3605, 'VN', 'VNM', NULL, 'Tỉnh Khánh Hòa'), (3606, 'VN', 'VNM', NULL, 'Tỉnh Kiến Giang'), (3607, 'VN', 'VNM', NULL, 'Tỉnh Kon Tum'), (3608, 'VN', 'VNM', NULL, 'Tỉnh Lai Châu'), (3609, 'VN', 'VNM', NULL, 'Tỉnh Lâm Ðồng'), (3610, 'VN', 'VNM', NULL, 'Tỉnh Lạng Sơn'), (3611, 'VN', 'VNM', NULL, 'Tỉnh Lào Cai'), (3612, 'VN', 'VNM', NULL, 'Tỉnh Long An'), (3613, 'VN', 'VNM', NULL, 'Tỉnh Nam Ðịnh'), (3614, 'VN', 'VNM', NULL, 'Tỉnh Nghệ An'), (3615, 'VN', 'VNM', NULL, 'Tỉnh Ninh Bình'), (3616, 'VN', 'VNM', NULL, 'Tỉnh Ninh Thuận'), (3617, 'VN', 'VNM', NULL, 'Tỉnh Phú Thọ'), (3618, 'VN', 'VNM', NULL, 'Tỉnh Phú Yên'), (3619, 'VN', 'VNM', NULL, 'Tỉnh Quảng Bình'), (3620, 'VN', 'VNM', NULL, 'Tỉnh Quảng Nam'), (3621, 'VN', 'VNM', NULL, 'Tỉnh Quảng Ngãi'), (3622, 'VN', 'VNM', NULL, 'Tỉnh Quảng Ninh'), (3623, 'VN', 'VNM', NULL, 'Tỉnh Quảng Trị'), (3624, 'VN', 'VNM', NULL, 'Tỉnh Sóc Trăng'), (3625, 'VN', 'VNM', NULL, 'Tỉnh Sơn La'), (3626, 'VN', 'VNM', NULL, 'Tỉnh Tây Ninh'), (3627, 'VN', 'VNM', NULL, 'Tỉnh Thái Bình'), (3628, 'VN', 'VNM', NULL, 'Tỉnh Thái Nguyên'), (3629, 'VN', 'VNM', NULL, 'Tỉnh Thanh Hóa'), (3630, 'VN', 'VNM', NULL, 'Tỉnh Thừa Thiên-Huế'), (3631, 'VN', 'VNM', NULL, 'Tỉnh Tiền Giang'), (3632, 'VN', 'VNM', NULL, 'Tỉnh Trà Vinh'), (3633, 'VN', 'VNM', NULL, 'Tỉnh Tuyên Quang'), (3634, 'VN', 'VNM', NULL, 'Tỉnh Vĩnh Long'), (3635, 'VN', 'VNM', NULL, 'Tỉnh Vĩnh Phúc'), (3636, 'VN', 'VNM', NULL, 'Tỉnh Yên Bái'), (3637, 'VN', 'VNM', NULL, 'Vinh Phú T?nh'), (3638, 'VU', 'VUT', NULL, 'Ambrym'), (3639, 'VU', 'VUT', NULL, 'Aoba/Maéwo'), (3640, 'VU', 'VUT', NULL, 'Éfaté'), (3641, 'VU', 'VUT', NULL, 'Épi'), (3642, 'VU', 'VUT', NULL, 'Malakula'), (3643, 'VU', 'VUT', NULL, 'Malampa Province'), (3644, 'VU', 'VUT', NULL, 'Paama'), (3645, 'VU', 'VUT', NULL, 'Penama Province'), (3646, 'VU', 'VUT', NULL, 'Pentecôte'), (3647, 'VU', 'VUT', NULL, 'Sanma Province'), (3648, 'VU', 'VUT', NULL, 'Shefa Province'), (3649, 'VU', 'VUT', NULL, 'Shepherd'), (3650, 'VU', 'VUT', NULL, 'Tafea Province'), (3651, 'VU', 'VUT', NULL, 'Torba Province'), (3652, 'YE', 'YEM', NULL, 'Aden Municipality'), (3653, 'YE', 'YEM', NULL, 'Muḩāfaz̧at `Adan'), (3654, 'YE', 'YEM', NULL, 'Muḩāfaz̧at Abyan'), (3655, 'YE', 'YEM', NULL, 'Muḩāfaz̧at aḑ Ḑāli`'), (3656, 'YE', 'YEM', NULL, 'Muḩāfaz̧at al Bayḑā\''), (3657, 'YE', 'YEM', NULL, 'Muḩāfaz̧at al Ḩudaydah'), (3658, 'YE', 'YEM', NULL, 'Muḩāfaz̧at al Jawf'), (3659, 'YE', 'YEM', NULL, 'Muḩāfaz̧at al Mahrah'), (3660, 'YE', 'YEM', NULL, 'Muḩāfaz̧at al Maḩwīt'), (3661, 'YE', 'YEM', NULL, 'Muḩāfaz̧at Ḩaḑramawt'), (3662, 'YE', 'YEM', NULL, 'Muḩāfaz̧at Ḩajjah'), (3663, 'YE', 'YEM', NULL, 'Muḩāfaz̧at Ibb'), (3664, 'YE', 'YEM', NULL, 'Muḩāfaz̧at Laḩij'), (3665, 'YE', 'YEM', NULL, 'Muḩāfaz̧at Shabwah'), (3666, 'YE', 'YEM', NULL, 'Muḩāfaz̧at Ta`izz'), (3667, 'YE', 'YEM', NULL, 'Omran'), (3668, 'YE', 'YEM', NULL, 'Qaḑā\' al Ḩudaydah'), (3669, 'ZA', 'ZAF', NULL, 'Free State'), (3670, 'ZA', 'ZAF', NULL, 'Gauteng'), (3671, 'ZA', 'ZAF', NULL, 'Limpopo Province'), (3672, 'ZA', 'ZAF', NULL, 'Mpumalanga'), (3673, 'ZA', 'ZAF', NULL, 'Province of Eastern Cape'), (3674, 'ZA', 'ZAF', NULL, 'Province of KwaZulu-Natal'), (3675, 'ZA', 'ZAF', NULL, 'Province of Northern Cape'), (3676, 'ZA', 'ZAF', NULL, 'Province of North-West'), (3677, 'ZA', 'ZAF', NULL, 'Province of the Western Cape'), (3678, 'ZM', 'ZMB', NULL, 'Central Province'), (3679, 'ZM', 'ZMB', NULL, 'Copperbelt Province'), (3680, 'ZM', 'ZMB', NULL, 'Eastern Province'), (3681, 'ZM', 'ZMB', NULL, 'Luapula Province'), (3682, 'ZM', 'ZMB', NULL, 'Lusaka Province'), (3683, 'ZM', 'ZMB', NULL, 'Northern Province'), (3684, 'ZM', 'ZMB', NULL, 'North-Western Province'), (3685, 'ZM', 'ZMB', NULL, 'Southern Province'), (3686, 'ZM', 'ZMB', NULL, 'Western Province'), (3687, 'ZW', 'ZWE', NULL, 'Bulawayo Province'), (3688, 'ZW', 'ZWE', NULL, 'Harare Province'), (3689, 'ZW', 'ZWE', NULL, 'Manicaland Province'), (3690, 'ZW', 'ZWE', NULL, 'Mashonaland Central Province'), (3691, 'ZW', 'ZWE', NULL, 'Mashonaland East Province'), (3692, 'ZW', 'ZWE', NULL, 'Mashonaland West Province'), (3693, 'ZW', 'ZWE', NULL, 'Masvingo Province'), (3694, 'ZW', 'ZWE', NULL, 'Matabeleland North Province'), (3695, 'ZW', 'ZWE', NULL, 'Matabeleland South Province'), (3696, 'ZW', 'ZWE', NULL, 'Midlands Province'); ALTER TABLE `ma_DCountryState` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `shortName` (`abbreviation`), ADD KEY `countryId` (`countryId`), ADD KEY `countryIsoAlpha3` (`countryIsoAlpha3`); ALTER TABLE `ma_DCountryState` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3697; -- --- -- --- ALTER TABLE `ma_VendorBusinessReference` DROP FOREIGN KEY `ma_VendorBusinessReference_ibfk_2`; ALTER TABLE `ma_VendorBusinessReference` ADD CONSTRAINT `ma_VendorBusinessReference_ibfk_2` FOREIGN KEY (`state`) REFERENCES `ma_DCountryState`(`abbreviation`) ON DELETE RESTRICT ON UPDATE CASCADE;