/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `countries` (
  `country_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `code` char(2) NOT NULL,
  `name` varchar(255) NOT NULL,
  `currency_id` smallint(5) unsigned DEFAULT NULL,
  `timezone_id` smallint(5) unsigned DEFAULT NULL,
  `latitude` float DEFAULT NULL,
  `longitude` float DEFAULT NULL,
  PRIMARY KEY (`country_id`),
  UNIQUE KEY `code` (`code`),
  FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=251 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `countries` WRITE;
/*!40000 ALTER TABLE `countries` DISABLE KEYS */;
INSERT INTO `countries` VALUES (1,'AD','Andorra',49,1,42.5,1.5),(2,'AE','United Arab Emirates',1,2,24,54),(3,'AF','Afghanistan',2,3,33,65),(4,'AG','Antigua and Barbuda',168,4,17.05,-61.8),(5,'AI','Anguilla',168,5,18.25,-63.1667),(6,'AL','Albania',3,6,41,20),(7,'AM','Armenia',4,7,40,45),(8,'AO','Angola',6,8,-12.5,18.5),(9,'AQ','Antarctica',NULL,220,-90,0),(10,'AR','Argentina',7,223,-34,-64),(11,'AS','American Samoa',151,9,-14.3333,-170),(12,'AT','Austria',49,10,47.3333,13.3333),(13,'AU','Australia',8,224,-27,133),(14,'AW','Aruba',9,11,12.5,-69.9667),(15,'AX','Åland Islands',49,12,60.177,19.915),(16,'AZ','Azerbaijan',10,13,40.5,47.5),(17,'BA','Bosnia and Herzegovina',11,14,44,18),(18,'BB','Barbados',12,15,13.1667,-59.5333),(19,'BD','Bangladesh',13,16,24,90),(20,'BE','Belgium',49,17,50.8333,4),(21,'BF','Burkina Faso',171,18,13,-2),(22,'BG','Bulgaria',14,19,43,25),(23,'BH','Bahrain',15,20,26,50.55),(24,'BI','Burundi',16,21,-3.5,30),(25,'BJ','Benin',171,22,9.5,2.25),(26,'BL','Saint Barthélemy',49,23,17.9,-62.8333),(27,'BM','Bermuda',17,24,32.3333,-64.75),(28,'BN','Brunei',18,25,4.5,114.667),(29,'BO','Bolivia',19,26,-17,-65),(30,'BQ','Bonaire, Sint Eustatius and Saba',151,27,12.1784,-68.2385),(31,'BR','Brazil',21,233,-10,-55),(32,'BS','Bahamas',22,28,24.25,-76),(33,'BT','Bhutan',23,29,27.5,90.5),(34,'BV','Bouvet Island',109,146,-54.4333,3.4),(35,'BW','Botswana',24,30,-22,24),(36,'BY','Belarus',25,31,53,28),(37,'BZ','Belize',26,32,17.25,-88.75),(38,'CA','Canada',27,251,60,-95),(39,'CC','Cocos Islands',8,33,-12.5,96.8333),(40,'CD','DR Congo',28,255,0,25),(41,'CF','Central African Republic',161,34,7,21),(42,'CG','Congo',161,35,-1,15),(43,'CH','Switzerland',29,36,47,8),(44,'CI','Côte d\'Ivoire',171,37,8,-5),(45,'CK','Cook Islands',111,38,-21.2333,-159.767),(46,'CL','Chile',32,257,-30,-71),(47,'CM','Cameroon',161,39,6,12),(48,'CN','China',34,259,35,105),(49,'CO','Colombia',35,40,4,-72),(50,'CR','Costa Rica',37,41,10,-84),(51,'CU','Cuba',38,42,21.5,-80),(52,'CV','Cape Verde',40,43,16,-24),(53,'CW','Curaçao',5,44,12.1696,-68.99),(54,'CX','Christmas Island',8,45,-10.5,105.667),(55,'CY','Cyprus',49,46,35,33),(56,'CZ','Czech Republic',41,47,49.75,15.5),(57,'DE','Germany',49,48,51,9),(58,'DJ','Djibouti',42,49,11.5,43),(59,'DK','Denmark',43,50,56,10),(60,'DM','Dominica',168,51,15.4167,-61.3333),(61,'DO','Dominican Republic',44,52,19,-70.6667),(62,'DZ','Algeria',45,53,28,3),(63,'EC','Ecuador',151,262,-2,-77.5),(64,'EE','Estonia',49,54,59,26),(65,'EG','Egypt',46,55,27,30),(66,'EH','Western Sahara',91,56,24.5,-13),(67,'ER','Eritrea',47,57,15,39),(68,'ES','Spain',49,263,40,-4),(69,'ET','Ethiopia',48,58,8,38),(70,'EU','European Union',49,63,47,8),(71,'FI','Finland',49,59,64,26),(72,'FJ','Fiji',50,60,-18,175),(73,'FK','Falkland Islands',51,61,-51.75,-59),(74,'FM','Micronesia',151,221,6.9167,158.25),(75,'FO','Faroe Islands',43,62,62,-7),(76,'FR','France',49,63,46,2),(77,'GA','Gabon',161,64,-1,11.75),(78,'GB','United Kingdom',52,65,54,-2),(79,'GD','Grenada',168,66,12.1167,-61.6667),(80,'GE','Georgia',53,67,42,43.5),(81,'GF','French Guiana',49,68,4,-53),(82,'GG','Guernsey',52,69,49.4657,-2.58528),(83,'GH','Ghana',54,70,8,-2),(84,'GI','Gibraltar',55,71,36.1833,-5.3667),(85,'GL','Greenland',43,265,72,-40),(86,'GM','Gambia',56,72,13.4667,-16.5667),(87,'GN','Guinea',57,73,11,-10),(88,'GP','Guadeloupe',49,74,16.25,-61.5833),(89,'GQ','Equatorial Guinea',161,75,2,10),(90,'GR','Greece',49,76,39,22),(91,'GS','South Georgia and the South Sandwich Islands',NULL,77,-54.5,-37),(92,'GT','Guatemala',58,78,15.5,-90.25),(93,'GU','Guam',151,79,13.4667,144.783),(94,'GW','Guinea-Bissau',171,80,12,-15),(95,'GY','Guyana',59,81,5,-59),(96,'HK','Hong Kong',60,82,22.25,114.167),(97,'HM','Heard Island and McDonald Islands',8,190,-53.1,72.5167),(98,'HN','Honduras',61,83,15,-86.5),(99,'HR','Croatia',62,84,45.1667,15.5),(100,'HT','Haiti',63,85,19,-72.4167),(101,'HU','Hungary',64,86,47,20),(102,'ID','Indonesia',65,268,-5,120),(103,'IE','Ireland',49,87,53,-8),(104,'IL','Israel',66,88,31.5,34.75),(105,'IM','Isle of Man',52,89,54.2361,-4.54806),(106,'IN','India',67,90,20,77),(107,'IO','British Indian Ocean Territory',151,91,-6,71.5),(108,'IQ','Iraq',68,92,33,44),(109,'IR','Iran',69,93,32,53),(110,'IS','Iceland',70,94,65,-18),(111,'IT','Italy',49,95,42.8333,12.8333),(112,'JE','Jersey',52,96,49.2138,-2.13577),(113,'JM','Jamaica',71,97,18.25,-77.5),(114,'JO','Jordan',72,98,31,36),(115,'JP','Japan',73,99,36,138),(116,'KE','Kenya',74,100,1,38),(117,'KG','Kyrgyzstan',75,101,41,75),(118,'KH','Cambodia',76,102,13,105),(119,'KI','Kiribati',8,270,1.4167,173),(120,'KM','Comoros',77,103,-12.1667,44.25),(121,'KN','Saint Kitts and Nevis',168,104,17.3333,-62.75),(122,'KP','North Korea',78,105,40,127),(123,'KR','South Korea',79,106,37,127.5),(124,'KW','Kuwait',80,107,29.3375,47.6581),(125,'KY','Cayman Islands',81,108,19.5,-80.5),(126,'KZ','Kazakhstan',82,271,48,68),(127,'LA','Laos',83,109,18,105),(128,'LB','Lebanon',84,110,33.8333,35.8333),(129,'LC','Saint Lucia',168,111,13.8833,-61.1333),(130,'LI','Liechtenstein',30,112,47.1667,9.5333),(131,'LK','Sri Lanka',85,113,7,81),(132,'LR','Liberia',86,114,6.5,-9.5),(133,'LS','Lesotho',87,115,-29.5,28.5),(134,'LT','Lithuania',88,116,56,24),(135,'LU','Luxembourg',49,117,49.75,6.1667),(136,'LV','Latvia',89,118,57,25),(137,'LY','Libya',90,119,25,17),(138,'MA','Morocco',91,120,32,-5),(139,'MC','Monaco',49,121,43.7333,7.4),(140,'MD','Moldova',92,122,47,29),(141,'ME','Montenegro',49,123,42,19),(142,'MF','Saint Martin',49,124,18.0525,-63.0737),(143,'MG','Madagascar',93,125,-20,47),(144,'MH','Marshall Islands',151,276,9,168),(145,'MK','Macedonia',94,126,41.8333,22),(146,'ML','Mali',171,127,17,-4),(147,'MM','Myanmar',95,128,22,98),(148,'MN','Mongolia',96,277,46,105),(149,'MO','Macao',97,129,22.1667,113.55),(150,'MP','Northern Mariana Islands',151,130,15.2,145.75),(151,'MQ','Martinique',49,131,14.6667,-61),(152,'MR','Mauritania',98,132,20,-12),(153,'MS','Montserrat',168,133,16.75,-62.2),(154,'MT','Malta',49,134,35.8333,14.5833),(155,'MU','Mauritius',99,135,-20.2833,57.55),(156,'MV','Maldives',100,136,3.25,73),(157,'MW','Malawi',101,137,-13.5,34),(158,'MX','Mexico',102,278,23,-102),(159,'MY','Malaysia',104,287,2.5,112.5),(160,'MZ','Mozambique',105,138,-18.25,35),(161,'NA','Namibia',106,139,-22,17),(162,'NC','New Caledonia',173,140,-21.5,165.5),(163,'NE','Niger',171,141,16,8),(164,'NF','Norfolk Island',8,142,-29.0333,167.95),(165,'NG','Nigeria',107,143,10,8),(166,'NI','Nicaragua',108,144,13,-85),(167,'NL','Netherlands',49,145,52.5,5.75),(168,'NO','Norway',109,146,62,10),(169,'NP','Nepal',110,147,28,84),(170,'NR','Nauru',8,148,-0.5333,166.917),(171,'NU','Niue',111,149,-19.0333,-169.867),(172,'NZ','New Zealand',111,289,-41,174),(173,'OM','Oman',112,150,21,57),(174,'PA','Panama',113,151,9,-80),(175,'PE','Peru',114,152,-10,-76),(176,'PF','French Polynesia',173,290,-15,-140),(177,'PG','Papua New Guinea',115,153,-6,147),(178,'PH','Philippines',116,154,13,122),(179,'PK','Pakistan',117,155,30,70),(180,'PL','Poland',118,156,52,20),(181,'PM','Saint Pierre and Miquelon',49,157,46.8333,-56.3333),(182,'PN','Pitcairn',111,158,-24.7036,-127.439),(183,'PR','Puerto Rico',151,159,18.25,-66.5),(184,'PS','Palestine',NULL,291,32,35.25),(185,'PT','Portugal',49,292,39.5,-8),(186,'PW','Palau',151,160,7.5,134.5),(187,'PY','Paraguay',119,161,-23,-58),(188,'QA','Qatar',120,162,25.5,51.25),(189,'RE','Réunion',49,163,-21.1,55.6),(190,'RO','Romania',121,164,46,25),(191,'RS','Serbia',122,165,44,21),(192,'RU','Russia',123,298,60,100),(193,'RW','Rwanda',124,166,-2,30),(194,'SA','Saudi Arabia',125,167,25,45),(195,'SB','Solomon Islands',126,168,-8,159),(196,'SC','Seychelles',127,169,-4.5833,55.6667),(197,'SD','Sudan',128,170,15,30),(198,'SE','Sweden',129,171,62,15),(199,'SG','Singapore',130,172,1.3667,103.8),(200,'SH','Saint Helena, Ascension and Tristan da Cunha',131,173,-15.9333,-5.7),(201,'SI','Slovenia',49,174,46,15),(202,'SJ','Svalbard and Jan Mayen',109,175,78,20),(203,'SK','Slovakia',49,176,48.6667,19.5),(204,'SL','Sierra Leone',132,177,8.5,-11.5),(205,'SM','San Marino',49,178,43.9333,12.4667),(206,'SN','Senegal',171,179,14,-14),(207,'SO','Somalia',133,180,10,49),(208,'SR','Suriname',134,181,4,-56),(209,'SS','South Sudan',135,182,7.96309,30.1589),(210,'ST','Sao Tome and Principe',136,183,1,7),(211,'SV','El Salvador',151,184,13.8333,-88.9167),(212,'SX','Sint Maarten',5,185,18.0273,-63.0501),(213,'SY','Syrian Arab Republic',138,186,35,38),(214,'SZ','Swaziland',139,187,-26.5,31.5),(215,'TC','Turks and Caicos Islands',151,188,21.75,-71.5833),(216,'TD','Chad',161,189,15,19),(217,'TF','French Southern Territories',49,190,-43,67),(218,'TG','Togo',171,191,8,1.1667),(219,'TH','Thailand',140,192,15,100),(220,'TJ','Tajikistan',141,193,39,71),(221,'TK','Tokelau',111,194,-9,-172),(222,'TL','Timor-Leste',151,195,-8.87422,125.728),(223,'TM','Turkmenistan',142,196,40,60),(224,'TN','Tunisia',143,197,34,9),(225,'TO','Tonga',144,198,-20,-175),(226,'TR','Turkey',145,199,39,35),(227,'TT','Trinidad and Tobago',146,200,11,-61),(228,'TV','Tuvalu',8,201,-8,178),(229,'TW','Taiwan',147,202,23.5,121),(230,'TZ','Tanzania',148,203,-6,35),(231,'UA','Ukraine',149,309,49,32),(232,'UG','Uganda',150,204,1,32),(233,'UM','U.S. Minor Outlying Islands',151,222,19.2833,166.6),(234,'US','United States',151,318,38,-97),(235,'UY','Uruguay',154,205,-33,-56),(236,'UZ','Uzbekistan',156,321,41,64),(237,'VA','Vatican City',49,206,41.9,12.45),(238,'VC','Saint Vincent and the Grenadines',168,207,13.25,-61.2),(239,'VE','Venezuela',157,208,8,-66),(240,'VG','British Virgin Islands',151,209,18.5,-64.5),(241,'VI','U.S. Virgin Islands',151,210,18.3333,-64.8333),(242,'VN','Vietnam',158,211,16,106),(243,'VU','Vanuatu',159,212,-16,167),(244,'WF','Wallis and Futuna',173,213,-13.3,-176.2),(245,'WS','Samoa',160,214,-13.5833,-172.333),(246,'YE','Yemen',179,215,15,48),(247,'YT','Mayotte',49,216,-12.8333,45.1667),(248,'ZA','South Africa',180,217,-29,24),(249,'ZM','Zambia',181,218,-15,30),(250,'ZW','Zimbabwe',182,219,-20,30);
/*!40000 ALTER TABLE `countries` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `currencies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `currencies` (
  `currency_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `code` char(3) NOT NULL,
  `name` varchar(255) NOT NULL,
  `symbol` varchar(255) DEFAULT NULL,
  `country_id` smallint(5) unsigned DEFAULT NULL,
  `rate` double unsigned DEFAULT NULL,
  PRIMARY KEY (`currency_id`),
  UNIQUE KEY `code` (`code`),
  FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=183 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `currencies` WRITE;
/*!40000 ALTER TABLE `currencies` DISABLE KEYS */;
INSERT INTO `currencies` VALUES (1,'AED','UAE Dirham',NULL,2,3.6731499156),(2,'AFN','Afghani','؋',3,48.2799987793),(3,'ALL','Lek','Lek',6,106.04),(4,'AMD','Armenian Dram',NULL,7,392.1099853516),(5,'ANG','Netherlands Antillean Guilder','ƒ',NULL,1.7890000343),(6,'AOA','Kwanza',NULL,8,95.0920028687),(7,'ARS','Argentine Peso','$',10,4.4130001068),(8,'AUD','Australian Dollar','$',13,0.959329455),(9,'AWG','Aruban Florin','ƒ',14,1.79),(10,'AZN','Azerbaijanian Manat','ман',16,0.7857000232),(11,'BAM','Convertible Mark','KM',17,1.4770072615),(12,'BBD','Barbados Dollar','$',18,2),(13,'BDT','Taka',NULL,19,81.6500015259),(14,'BGN','Bulgarian Lev','лв',22,1.4770676861),(15,'BHD','Bahraini Dinar',NULL,23,0.3770249922),(16,'BIF','Burundi Franc',NULL,24,1402.49991168),(17,'BMD','Bermudian Dollar','$',27,1),(18,'BND','Brunei Dollar','$',28,1.2373139338),(19,'BOB','Boliviano','$b',29,6.8600001335),(20,'BOV','Mvdol',NULL,29,NULL),(21,'BRL','Brazilian Real','R$',31,1.904103446),(22,'BSD','Bahamian Dollar','$',32,1),(23,'BTN','Ngultrum',NULL,33,52.6686521751),(24,'BWP','Pula','P',35,7.5131478394),(25,'BYR','Belarussian Ruble','p.',36,8050),(26,'BZD','Belize Dollar','BZ$',37,1.959800005),(27,'CAD','Canadian Dollar','$',38,0.9871376911),(28,'CDF','Congolese Franc',NULL,40,929.9999488),(29,'CHE','WIR Euro',NULL,43,NULL),(30,'CHF','Swiss Franc',NULL,43,0.9073358418),(31,'CHW','WIR Franc',NULL,43,NULL),(32,'CLF','Unidades de fomento',NULL,46,NULL),(33,'CLP','Chilean Peso','$',46,484.5),(34,'CNY','Yuan Renminbi','¥',48,6.2802490949),(35,'COP','Colombian Peso','$',49,1763),(36,'COU','Unidad de Valor Real',NULL,49,NULL),(37,'CRC','Costa Rican Colon','₡',50,503.3999938965),(38,'CUC','Peso Convertible',NULL,51,1),(39,'CUP','Cuban Peso','₱',51,26.5),(40,'CVE','Cape Verde Escudo',NULL,52,83.4000015259),(41,'CZK','Czech Koruna','Kč',56,18.8364536693),(42,'DJF','Djibouti Franc',NULL,58,178.4499936744),(43,'DKK','Danish Krone','kr',59,5.6181915242),(44,'DOP','Dominican Peso','RD$',61,38.999999872),(45,'DZD','Algerian Dinar',NULL,62,74.1306780533),(46,'EGP','Egyptian Pound','£',65,6.0489954778),(47,'ERN','Nakfa',NULL,67,15),(48,'ETB','Ethiopian Birr',NULL,69,17.4752998352),(49,'EUR','Euro','€',70,0.7551818213),(50,'FJD','Fiji Dollar','$',72,1.7743080199),(51,'FKP','Falkland Islands Pound','£',73,0.6159816571),(52,'GBP','Pound Sterling','£',78,0.6159816571),(53,'GEL','Lari',NULL,80,1.6276999712),(54,'GHS','Ghana Cedi',NULL,83,1.8530000448),(55,'GIP','Gibraltar Pound','£',84,0.6159816571),(56,'GMD','Dalasi',NULL,86,30.0749876399),(57,'GNF','Guinea Franc',NULL,87,7042.498176),(58,'GTQ','Quetzal','Q',92,7.7824997902),(59,'GYD','Guyana Dollar','$',95,200.6999969482),(60,'HKD','Hong Kong Dollar','$',96,7.7585986246),(61,'HNL','Lempira','L',98,19.0550003052),(62,'HRK','Croatian Kuna','kn',99,5.6603486749),(63,'HTG','Gourde',NULL,100,41.8499984741),(64,'HUF','Forint','Ft',101,216.5509819202),(65,'IDR','Rupiah','Rp',102,9192.499712),(66,'ILS','New Israeli Sheqel','₪',104,3.7633617785),(67,'INR','Indian Rupee',NULL,106,52.6686521751),(68,'IQD','Iraqi Dinar',NULL,108,1164.9968023438),(69,'IRR','Iranian Rial','﷼',109,12287.498112),(70,'ISK','Iceland Krona','kr',110,125.85),(71,'JMD','Jamaican Dollar','J$',113,86.3000030518),(72,'JOD','Jordanian Dinar',NULL,114,0.7085005397),(73,'JPY','Yen','¥',115,79.8215619823),(74,'KES','Kenyan Shilling',NULL,116,83.2499872002),(75,'KGS','Som','лв',117,46.8370018005),(76,'KHR','Riel','៛',118,4033.000576),(77,'KMF','Comoro Franc',NULL,120,371.5251014587),(78,'KPW','North Korean Won','₩',122,130.0363251097),(79,'KRW','Won','₩',123,1130.2000496116),(80,'KWD','Kuwaiti Dinar',NULL,124,0.2775577617),(81,'KYD','Cayman Islands Dollar','$',125,0.8200393522),(82,'KZT','Tenge','лв',126,147.6999969482),(83,'LAK','Kip','₭',127,7997.99744),(84,'LBP','Lebanese Pound','£',128,1505.469856),(85,'LKR','Sri Lanka Rupee','₨',131,129.6300048828),(86,'LRD','Liberian Dollar','$',132,73.999968),(87,'LSL','Loti',NULL,133,7.7739989045),(88,'LTL','Lithuanian Litas','Lt',134,2.6074917925),(89,'LVL','Latvian Lats','Ls',136,0.5282001273),(90,'LYD','Libyan Dinar',NULL,137,1.2585236138),(91,'MAD','Moroccan Dirham',NULL,138,8.4175309004),(92,'MDL','Moldovan Leu',NULL,140,11.6199998856),(93,'MGA','Malagasy Ariary',NULL,143,2105),(94,'MKD','Denar','ден',145,46.2299995422),(95,'MMK','Kyat',NULL,147,823),(96,'MNT','Tugrik','₮',148,1308),(97,'MOP','Pataca',NULL,149,7.9913565833),(98,'MRO','Ouguiya',NULL,152,291.999872),(99,'MUR','Mauritius Rupee','₨',155,28.924895985),(100,'MVR','Rufiyaa',NULL,156,15.4799263909),(101,'MWK','Kwacha',NULL,157,165.1999969482),(102,'MXN','Mexican Peso','$',158,13.0232942149),(103,'MXV','Mexican Unidad de Inversion (UDI)',NULL,158,NULL),(104,'MYR','Malaysian Ringgit','RM',159,3.0295049243),(105,'MZN','Mozambique Metical','MT',160,27.5798943985),(106,'NAD','Namibia Dollar','$',161,7.7739989045),(107,'NGN','Naira','₦',165,157.3999945059),(108,'NIO','Cordoba Oro','C$',166,23.3400001526),(109,'NOK','Norwegian Krone','kr',168,5.721178781),(110,'NPR','Nepalese Rupee','₨',169,84.1399993896),(111,'NZD','New Zealand Dollar','$',172,1.2225941579),(112,'OMR','Rial Omani','﷼',173,0.3850249946),(113,'PAB','Balboa','B/.',174,1),(114,'PEN','Nuevo Sol','S/.',175,2.6380000114),(115,'PGK','Kina',NULL,177,2.1141649496),(116,'PHP','Philippine Peso','₱',178,42.2502538553),(117,'PKR','Pakistan Rupee','₨',179,91.0662825365),(118,'PLN','Zloty','zł',180,3.1519534745),(119,'PYG','Guarani','Gs',187,4315),(120,'QAR','Qatari Rial','﷼',188,3.6411983777),(121,'RON','New Romanian Leu','lei',190,3.3492871492),(122,'RSD','Serbian Dinar','Дин.',191,84.1854019165),(123,'RUB','Russian Ruble','руб',192,29.3592464799),(124,'RWF','Rwanda Franc',NULL,193,606.984),(125,'SAR','Saudi Riyal','﷼',194,3.750240032),(126,'SBD','Solomon Islands Dollar','$',195,7.1729226578),(127,'SCR','Seychelles Rupee','₨',196,14.0748119614),(128,'SDG','Sudanese Pound',NULL,197,2.6899680001),(129,'SEK','Swedish Krona','kr',198,6.7189532345),(130,'SGD','Singapore Dollar','$',199,1.2373139338),(131,'SHP','Saint Helena Pound','£',200,0.6159816571),(132,'SLL','Leone',NULL,204,4389.872),(133,'SOS','Somali Shilling','S',207,1627.0032),(134,'SRD','Surinam Dollar','$',208,3.25),(135,'SSP','South Sudanese Pound',NULL,209,NULL),(136,'STD','Dobra',NULL,210,18550.2),(137,'SVC','El Salvador Colon','$',211,8.75),(138,'SYP','Syrian Pound','£',213,57.2999992371),(139,'SZL','Lilangeni',NULL,214,7.7739989045),(140,'THB','Baht','฿',219,30.7450393289),(141,'TJS','Somoni',NULL,220,4.7582001686),(142,'TMT','Turkmenistan New Manat',NULL,223,2.85),(143,'TND','Tunisian Dinar',NULL,224,1.5405000448),(144,'TOP','Pa\'anga',NULL,225,1.7182130077),(145,'TRY','Turkish Lira','TL',226,1.7563527327),(146,'TTD','Trinidad and Tobago Dollar','TT$',227,6.3499999046),(147,'TWD','New Taiwan Dollar','NT$',229,29.1698576624),(148,'TZS','Tanzanian Shilling',NULL,230,1587),(149,'UAH','Hryvnia','₴',231,8.0329999924),(150,'UGX','Uganda Shilling',NULL,232,2498),(151,'USD','US Dollar','$',234,1),(152,'USN','US Dollar (Next day)',NULL,234,NULL),(153,'USS','US Dollar (Same day)',NULL,234,NULL),(154,'UYI','Uruguay Peso en Unidades Indexadas (URUIURUI)',NULL,235,NULL),(155,'UYU','Peso Uruguayo','$U',235,19.6499996185),(156,'UZS','Uzbekistan Sum','лв',236,1880),(157,'VEF','Bolivar Fuerte','Bs',239,4.3),(158,'VND','Dong','₫',242,20843.64),(159,'VUV','Vatu',NULL,243,90),(160,'WST','Tala',NULL,245,2.290950677),(161,'XAF','CFA Franc BEAC',NULL,NULL,495.3668019449),(162,'XAG','Silver',NULL,NULL,0.0322437191),(163,'XAU','Gold',NULL,NULL,0.000600767),(164,'XBA','Bond Markets Unit European Composite Unit (EURCO)',NULL,NULL,NULL),(165,'XBB','Bond Markets Unit European Monetary Unit (E.M.U.-6)',NULL,NULL,NULL),(166,'XBC','Bond Markets Unit European Unit of Account 9 (E.U.A.-9)',NULL,NULL,NULL),(167,'XBD','Bond Markets Unit European Unit of Account 17 (E.U.A.-17)',NULL,NULL,NULL),(168,'XCD','East Caribbean Dollar','$',NULL,2.7000000477),(169,'XDR','SDR (Special Drawing Right)',NULL,NULL,0.6449339986),(170,'XFU','UIC-Franc',NULL,NULL,NULL),(171,'XOF','CFA Franc BCEAO',NULL,NULL,495.3668019449),(172,'XPD','Palladium',NULL,NULL,0.0014665373),(173,'XPF','CFP Franc',NULL,NULL,90.1171624446),(174,'XPT','Platinum',NULL,NULL,0.0006378444),(175,'XSU','Sucre',NULL,NULL,NULL),(176,'XTS','Codes specifically reserved for testing purposes',NULL,NULL,NULL),(177,'XUA','ADB Unit of Account',NULL,NULL,NULL),(178,'XXX','The codes assigned for transactions where no currency is involved',NULL,NULL,NULL),(179,'YER','Yemeni Rial','﷼',246,215.2540015381),(180,'ZAR','Rand','R',248,7.7739989045),(181,'ZMK','Zambian Kwacha',NULL,249,5245.5),(182,'ZWL','Zimbabwe Dollar',NULL,250,NULL);
/*!40000 ALTER TABLE `currencies` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `languages` (
  `language_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `code` char(2) NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`language_id`),
  UNIQUE KEY `code` (`code`),
  FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=185 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `languages` WRITE;
/*!40000 ALTER TABLE `languages` DISABLE KEYS */;
INSERT INTO `languages` VALUES (1,'AA','Afar'),(2,'AB','Abkhaz'),(3,'AE','Avestan'),(4,'AF','Afrikaans'),(5,'AK','Akan'),(6,'AM','Amharic'),(7,'AN','Aragonese'),(8,'AR','Arabic'),(9,'AS','Assamese'),(10,'AV','Avaric'),(11,'AY','Aymara'),(12,'AZ','Azerbaijani'),(13,'BA','Bashkir'),(14,'BE','Belarusian'),(15,'BG','Bulgarian'),(16,'BH','Bihari'),(17,'BI','Bislama'),(18,'BM','Bambara'),(19,'BN','Bengali'),(20,'BO','Tibetan Standard'),(21,'BR','Breton'),(22,'BS','Bosnian'),(23,'CA','Catalan'),(24,'CE','Chechen'),(25,'CH','Chamorro'),(26,'CO','Corsican'),(27,'CR','Cree'),(28,'CS','Czech'),(29,'CU','Old Church Slavonic'),(30,'CV','Chuvash'),(31,'CY','Welsh'),(32,'DA','Danish'),(33,'DE','German'),(34,'DV','Divehi'),(35,'DZ','Dzongkha'),(36,'EE','Ewe'),(37,'EL','Greek'),(38,'EN','English'),(39,'EO','Esperanto'),(40,'ES','Spanish'),(41,'ET','Estonian'),(42,'EU','Basque'),(43,'FA','Persian'),(44,'FF','Fula'),(45,'FI','Finnish'),(46,'FJ','Fijian'),(47,'FO','Faroese'),(48,'FR','French'),(49,'FY','Western Frisian'),(50,'GA','Irish'),(51,'GD','Scottish Gaelic'),(52,'GL','Galician'),(53,'GN','Guaraní'),(54,'GU','Gujarati'),(55,'GV','Manx'),(56,'HA','Hausa'),(57,'HE','Hebrew'),(58,'HI','Hindi'),(59,'HO','Hiri Motu'),(60,'HR','Croatian'),(61,'HT','Haitian'),(62,'HU','Hungarian'),(63,'HY','Armenian'),(64,'HZ','Herero'),(65,'IA','Interlingua'),(66,'ID','Indonesian'),(67,'IE','Interlingue'),(68,'IG','Igbo'),(69,'II','Nuosu'),(70,'IK','Inupiaq'),(71,'IO','Ido'),(72,'IS','Icelandic'),(73,'IT','Italian'),(74,'IU','Inuktitut'),(75,'JA','Japanese'),(76,'JV','Javanese'),(77,'KA','Georgian'),(78,'KG','Kongo'),(79,'KI','Kikuyu'),(80,'KJ','Kwanyama'),(81,'KK','Kazakh'),(82,'KL','Kalaallisut'),(83,'KM','Khmer'),(84,'KN','Kannada'),(85,'KO','Korean'),(86,'KR','Kanuri'),(87,'KS','Kashmiri'),(88,'KU','Kurdish'),(89,'KV','Komi'),(90,'KW','Cornish'),(91,'KY','Kirghiz'),(92,'LA','Latin'),(93,'LB','Luxembourgish'),(94,'LG','Luganda'),(95,'LI','Limburgish'),(96,'LN','Lingala'),(97,'LO','Lao'),(98,'LT','Lithuanian'),(99,'LU','Luba-Katanga'),(100,'LV','Latvian'),(101,'MG','Malagasy'),(102,'MH','Marshallese'),(103,'MI','Māori'),(104,'MK','Macedonian'),(105,'ML','Malayalam'),(106,'MN','Mongolian'),(107,'MR','Marathi'),(108,'MS','Malay'),(109,'MT','Maltese'),(110,'MY','Burmese'),(111,'NA','Nauru'),(112,'NB','Norwegian Bokmål'),(113,'ND','North Ndebele'),(114,'NE','Nepali'),(115,'NG','Ndonga'),(116,'NL','Dutch'),(117,'NN','Norwegian Nynorsk'),(118,'NO','Norwegian'),(119,'NR','South Ndebele'),(120,'NV','Navajo'),(121,'NY','Chichewa'),(122,'OC','Occitan'),(123,'OJ','Ojibwe'),(124,'OM','Oromo'),(125,'OR','Oriya'),(126,'OS','Ossetian'),(127,'PA','Panjabi'),(128,'PI','Pāli'),(129,'PL','Polish'),(130,'PS','Pashto'),(131,'PT','Portuguese'),(132,'QU','Quechua'),(133,'RM','Romansh'),(134,'RN','Kirundi'),(135,'RO','Romanian'),(136,'RU','Russian'),(137,'RW','Kinyarwanda'),(138,'SA','Sanskrit'),(139,'SC','Sardinian'),(140,'SD','Sindhi'),(141,'SE','Northern Sami'),(142,'SG','Sango'),(143,'SI','Sinhala'),(144,'SK','Slovak'),(145,'SL','Slovene'),(146,'SM','Samoan'),(147,'SN','Shona'),(148,'SO','Somali'),(149,'SQ','Albanian'),(150,'SR','Serbian'),(151,'SS','Swati'),(152,'ST','Southern Sotho'),(153,'SU','Sundanese'),(154,'SV','Swedish'),(155,'SW','Swahili'),(156,'TA','Tamil'),(157,'TE','Telugu'),(158,'TG','Tajik'),(159,'TH','Thai'),(160,'TI','Tigrinya'),(161,'TK','Turkmen'),(162,'TL','Tagalog'),(163,'TN','Tswana'),(164,'TO','Tonga'),(165,'TR','Turkish'),(166,'TS','Tsonga'),(167,'TT','Tatar'),(168,'TW','Twi'),(169,'TY','Tahitian'),(170,'UG','Uighur'),(171,'UK','Ukrainian'),(172,'UR','Urdu'),(173,'UZ','Uzbek'),(174,'VE','Venda'),(175,'VI','Vietnamese'),(176,'VO','Volapük'),(177,'WA','Walloon'),(178,'WO','Wolof'),(179,'XH','Xhosa'),(180,'YI','Yiddish'),(181,'YO','Yoruba'),(182,'ZA','Zhuang'),(183,'ZH','Chinese'),(184,'ZU','Zulu');
/*!40000 ALTER TABLE `languages` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `metros`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `metros` (
  `metro_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `code` smallint(6) NOT NULL,
  `name` varchar(255) NOT NULL,
  `region_id` smallint(5) unsigned NOT NULL,
  PRIMARY KEY (`metro_id`),
  UNIQUE KEY `code` (`code`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=211 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `metros` WRITE;
/*!40000 ALTER TABLE `metros` DISABLE KEYS */;
INSERT INTO `metros` VALUES (1,524,'Atlanta, GA',3727),(2,630,'Birmingham, AL',3727),(3,522,'Columbus, GA',3727),(4,673,'Columbus-Tupelo-West Point, MS',3727),(5,606,'Dothan, AL',3727),(6,691,'Huntsville-Decatur (Florence), AL',3727),(7,711,'Meridian, MS',3727),(8,686,'Mobile, AL-Pensacola (Fort Walton Beach), FL',3727),(9,698,'Montgomery (Selma), AL',3727),(10,743,'Anchorage, AK',3728),(11,745,'Fairbanks, AK',3728),(12,747,'Juneau, AK',3728),(13,790,'Albuquerque-Santa Fe, NM',3729),(14,753,'Phoenix, AZ',3729),(15,789,'Tucson (Sierra Vista), AZ',3729),(16,771,'Yuma, AZ-El Centro, CA',3729),(17,670,'Fort Smith-Fayetteville-Springdale-Rogers, AR',3730),(18,647,'Greenwood-Greenville, MS',3730),(19,734,'Jonesboro, AR',3730),(20,693,'Little Rock-Pine Bluff, AR',3730),(21,640,'Memphis, TN',3730),(22,628,'Monroe, LA-El Dorado, AR',3730),(23,612,'Shreveport, LA',3730),(24,619,'Springfield, MO',3730),(25,800,'Bakersfield, CA',3731),(26,868,'Chico-Redding, CA',3731),(27,802,'Eureka, CA',3731),(28,866,'Fresno-Visalia, CA',3731),(29,803,'Los Angeles, CA',3731),(30,813,'Medford-Klamath Falls, OR',3731),(31,828,'Monterey-Salinas, CA',3731),(32,804,'Palm Springs, CA',3731),(33,811,'Reno, NV',3731),(34,862,'Sacramento-Stockton-Modesto, CA',3731),(35,825,'San Diego, CA',3731),(36,807,'San Francisco-Oakland-San Jose, CA',3731),(37,855,'Santa Barbara-Santa Maria-San Luis Obispo, CA',3731),(38,752,'Colorado Springs-Pueblo, CO',3732),(39,751,'Denver, CO',3732),(40,773,'Grand Junction-Montrose, CO',3732),(41,533,'Hartford & New Haven, CT',3733),(42,501,'New York, NY',3733),(43,504,'Philadelphia, PA',3734),(44,576,'Salisbury, MD',3734),(45,511,'Washington, DC (Hagerstown, MD)',3735),(46,571,'Fort Myers-Naples, FL',3736),(47,592,'Gainesville, FL',3736),(48,561,'Jacksonville, FL',3736),(49,528,'Miami-Fort Lauderdale, FL',3736),(50,534,'Orlando-Daytona Beach-Melbourne, FL',3736),(51,656,'Panama City, FL',3736),(52,530,'Tallahassee, FL-Thomasville, GA',3736),(53,539,'Tampa-St. Petersburg (Sarasota), FL',3736),(54,548,'West Palm Beach-Fort Pierce, FL',3736),(55,525,'Albany, GA',3737),(56,520,'Augusta, GA',3737),(57,575,'Chattanooga, TN',3737),(58,567,'Greenville-Spartanburg, SC-Asheville, NC-Anderson, SC',3737),(59,503,'Macon, GA',3737),(60,507,'Savannah, GA',3737),(61,744,'Honolulu, HI',3738),(62,757,'Boise, ID',3739),(63,758,'Idaho Falls-Pocatello, ID',3739),(64,770,'Salt Lake City, UT',3739),(65,881,'Spokane, WA',3739),(66,760,'Twin Falls, ID',3739),(67,648,'Champaign & Springfield-Decatur,IL',3740),(68,602,'Chicago, IL',3740),(69,682,'Davenport, IA-Rock Island-Moline, IL',3740),(70,649,'Evansville, IN',3740),(71,632,'Paducah, KY-Cape Girardeau, MO-Harrisburg-Mount Vernon, IL',3740),(72,675,'Peoria-Bloomington, IL',3740),(73,717,'Quincy, IL-Hannibal, MO-Keokuk, IA',3740),(74,610,'Rockford, IL',3740),(75,609,'St. Louis, MO',3740),(76,581,'Terre Haute, IN',3740),(77,515,'Cincinnati, OH',3741),(78,542,'Dayton, OH',3741),(79,509,'Fort Wayne, IN',3741),(80,527,'Indianapolis, IN',3741),(81,582,'Lafayette, IN',3741),(82,529,'Louisville, KY',3741),(83,588,'South Bend-Elkhart, IN',3741),(84,637,'Cedar Rapids-Waterloo-Iowa City & Dubuque, IA',3742),(85,679,'Des Moines-Ames, IA',3742),(86,737,'Mankato, MN',3742),(87,652,'Omaha, NE',3742),(88,631,'Ottumwa, IA-Kirksville, MO',3742),(89,611,'Rochester, MN-Mason City, IA-Austin, MN',3742),(90,624,'Sioux City, IA',3742),(91,725,'Sioux Falls(Mitchell), SD',3742),(92,634,'Amarillo, TX',3743),(93,603,'Joplin, MO-Pittsburg, KS',3743),(94,616,'Kansas City, MO',3743),(95,722,'Lincoln & Hastings-Kearney, NE',3743),(96,638,'St. Joseph, MO',3743),(97,605,'Topeka, KS',3743),(98,671,'Tulsa, OK',3743),(99,678,'Wichita-Hutchinson, KS',3743),(100,736,'Bowling Green, KY',3744),(101,564,'Charleston-Huntington, WV',3744),(102,557,'Knoxville, TN',3744),(103,541,'Lexington, KY',3744),(104,659,'Nashville, TN',3744),(105,531,'Tri-Cities, TN-VA',3744),(106,644,'Alexandria, LA',3745),(107,716,'Baton Rouge, LA',3745),(108,642,'Lafayette, LA',3745),(109,643,'Lake Charles, LA',3745),(110,622,'New Orleans, LA',3745),(111,537,'Bangor, ME',3746),(112,500,'Portland-Auburn, ME',3746),(113,552,'Presque Isle, ME',3746),(114,512,'Baltimore, MD',3747),(115,508,'Pittsburgh, PA',3747),(116,532,'Albany-Schenectady-Troy, NY',3748),(117,506,'Boston, MA-Manchester, NH',3748),(118,521,'Providence, RI-New Bedford, MA',3748),(119,543,'Springfield-Holyoke, MA',3748),(120,583,'Alpena, MI',3749),(121,505,'Detroit, MI',3749),(122,676,'Duluth, MN-Superior, WI',3749),(123,513,'Flint-Saginaw-Bay City, MI',3749),(124,563,'Grand Rapids-Kalamazoo-Battle Creek, MI',3749),(125,658,'Green Bay-Appleton, WI',3749),(126,551,'Lansing, MI',3749),(127,553,'Marquette, MI',3749),(128,547,'Toledo, OH',3749),(129,540,'Traverse City-Cadillac, MI',3749),(130,724,'Fargo-Valley City, ND',3750),(131,702,'La Crosse-Eau Claire, WI',3750),(132,613,'Minneapolis-St. Paul, MN',3750),(133,746,'Biloxi-Gulfport, MS',3751),(134,710,'Hattiesburg-Laurel, MS',3751),(135,718,'Jackson, MS',3751),(136,604,'Columbia-Jefferson City, MO',3752),(137,756,'Billings, MT',3753),(138,754,'Butte-Bozeman, MT',3753),(139,798,'Glendive, MT',3753),(140,755,'Great Falls, MT',3753),(141,766,'Helena, MT',3753),(142,687,'Minot-Bismarck-Dickinson(Williston), ND',3753),(143,762,'Missoula, MT',3753),(144,764,'Rapid City, SD',3753),(145,759,'Cheyenne, WY-Scottsbluff, NE',3754),(146,740,'North Platte, NE',3754),(147,839,'Las Vegas, NV',3755),(148,523,'Burlington, VT-Plattsburgh, NY',3756),(149,765,'El Paso, TX',3758),(150,633,'Odessa-Midland, TX',3758),(151,502,'Binghamton, NY',3759),(152,514,'Buffalo, NY',3759),(153,565,'Elmira, NY',3759),(154,538,'Rochester, NY',3759),(155,555,'Syracuse, NY',3759),(156,526,'Utica, NY',3759),(157,549,'Watertown, NY',3759),(158,517,'Charlotte, NC',3760),(159,570,'Florence-Myrtle Beach, SC',3760),(160,518,'Greensboro-High Point-Winston Salem, NC',3760),(161,545,'Greenville-New Bern-Washington, NC',3760),(162,544,'Norfolk-Portsmouth-Newport News, VA',3760),(163,560,'Raleigh-Durham (Fayetteville), NC',3760),(164,550,'Wilmington, NC',3760),(165,510,'Cleveland-Akron (Canton), OH',3762),(166,535,'Columbus, OH',3762),(167,558,'Lima, OH',3762),(168,597,'Parkersburg, WV',3762),(169,554,'Wheeling, WV-Steubenville, OH',3762),(170,536,'Youngstown, OH',3762),(171,596,'Zanesville, OH',3762),(172,650,'Oklahoma City, OK',3763),(173,657,'Sherman, TX-Ada, OK',3763),(174,627,'Wichita Falls, TX & Lawton, OK',3763),(175,821,'Bend, OR',3764),(176,801,'Eugene, OR',3764),(177,820,'Portland, OR',3764),(178,810,'Yakima-Pasco-Richland-Kennewick, WA',3764),(179,516,'Erie, PA',3765),(180,566,'Harrisburg-Lancaster-Lebanon-York, PA',3765),(181,574,'Johnstown-Altoona, PA',3765),(182,577,'Wilkes Barre-Scranton, PA',3765),(183,519,'Charleston, SC',3767),(184,546,'Columbia, SC',3767),(185,639,'Jackson, TN',3769),(186,662,'Abilene-Sweetwater, TX',3770),(187,635,'Austin, TX',3770),(188,692,'Beaumont-Port Arthur, TX',3770),(189,600,'Corpus Christi, TX',3770),(190,623,'Dallas-Fort Worth, TX',3770),(191,636,'Harlingen-Weslaco-Brownsville-McAllen, TX',3770),(192,618,'Houston, TX',3770),(193,749,'Laredo, TX',3770),(194,651,'Lubbock, TX',3770),(195,661,'San Angelo, TX',3770),(196,641,'San Antonio, TX',3770),(197,709,'Tyler-Longview(Lufkin & Nacogdoches), TX',3770),(198,626,'Victoria, TX',3770),(199,625,'Waco-Temple-Bryan, TX',3770),(200,559,'Bluefield-Beckley-Oak Hill, WV',3773),(201,584,'Charlottesville, VA',3773),(202,569,'Harrisonburg, VA',3773),(203,556,'Richmond-Petersburg, VA',3773),(204,573,'Roanoke-Lynchburg, VA',3773),(205,819,'Seattle-Tacoma, WA',3774),(206,598,'Clarksburg-Weston, WV',3775),(207,669,'Madison, WI',3776),(208,617,'Milwaukee, WI',3776),(209,705,'Wausau-Rhinelander, WI',3776),(210,767,'Casper-Riverton, WY',3777);
/*!40000 ALTER TABLE `metros` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `regions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `regions` (
  `region_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `country` char(2) NOT NULL,
  `fips` char(2) NOT NULL,
  `iso` varchar(5) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `timezone_id` smallint(5) unsigned DEFAULT NULL,
  PRIMARY KEY (`region_id`),
  KEY `country` (`country`,`fips`,`iso`),
  FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=3984 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `regions` WRITE;
/*!40000 ALTER TABLE `regions` DISABLE KEYS */;
INSERT INTO `regions` VALUES (1,'AD','02','02','Canillo',NULL),(2,'AD','03','03','Encamp',NULL),(3,'AD','04','04','La Massana',NULL),(4,'AD','05','05','Ordino',NULL),(5,'AD','06','06','Sant Julià de Lòria',NULL),(6,'AD','07','07','Andorra la Vella',NULL),(7,'AD','08','08','Escaldes-Engordany',NULL),(8,'AE','01','AZ','Abu Z¸aby',NULL),(9,'AE','02','AJ','Ajman',NULL),(10,'AE','03','DU','Dubayy',NULL),(11,'AE','04','FU','Al Fujayrah',NULL),(12,'AE','05',NULL,'Ras Al Khaimah',NULL),(13,'AE','06','SH','Ash Shariqah',NULL),(14,'AE','07','UQ','Umm al Qaywayn',NULL),(15,'AF','01','BDS','Badakhshan',NULL),(16,'AF','02','BDG','Badghis',NULL),(17,'AF','03','BGL','Baghlan',NULL),(18,'AF','05','BAM','Bamian',NULL),(19,'AF','06','FRA','Farah',NULL),(20,'AF','07','FYB','Faryab',NULL),(21,'AF','08','GHA','Ghazni',NULL),(22,'AF','09','GHO','Ghowr',NULL),(23,'AF','10','HEL','Helmand',NULL),(24,'AF','11','HER','Herat',NULL),(25,'AF','13','KAB','Kabul',NULL),(26,'AF','14','KAP','Kapisa',NULL),(27,'AF','17','LOW','Lowgar',NULL),(28,'AF','18','NAN','Nangrahar',NULL),(29,'AF','19','NIM','Nimruz',NULL),(30,'AF','23','KAN','Kandahar',NULL),(31,'AF','24','KDZ','Kondoz',NULL),(32,'AF','26','TAK','Takhar',NULL),(33,'AF','27','WAR','Wardak',NULL),(34,'AF','28','ZAB','Zabol',NULL),(35,'AF','29','PKA','Paktika',NULL),(36,'AF','30','BAL','Balkh',NULL),(37,'AF','31','JOW','Jowzjan',NULL),(38,'AF','32','SAM','Samangan',NULL),(39,'AF','33','SAR','Sar-e Pol',NULL),(40,'AF','34','KNR','Konar',NULL),(41,'AF','35','LAG','Laghman',NULL),(42,'AF','36','PIA','Paktia',NULL),(43,'AF','37','KHO','Khowst',NULL),(44,'AF','38','NUR','Nurestan',NULL),(45,'AF','39','ORU','Oruzgan',NULL),(46,'AF','40','PAR','Parwan',NULL),(47,'AF','41','DAY','Daykondi',NULL),(48,'AF','42','PAN','Panjshir',NULL),(49,'AG','01','10','Barbuda',NULL),(50,'AG','03','03','Saint George',NULL),(51,'AG','04',NULL,'Saint John',NULL),(52,'AG','05','05','Saint Mary',NULL),(53,'AG','06','06','Saint Paul',NULL),(54,'AG','07','07','Saint Peter',NULL),(55,'AG','08','08','Saint Philip',NULL),(56,'AG','09','11','Redonda',NULL),(57,'AL','40','BR','Berat',NULL),(58,'AL','41','DI','Dibër',NULL),(59,'AL','42','DR','Durrës',NULL),(60,'AL','43','EL','Elbasan',NULL),(61,'AL','44','FR','Fier',NULL),(62,'AL','45','GJ','Gjirokastër',NULL),(63,'AL','46','KO','Korçë',NULL),(64,'AL','47','KU','Kukës',NULL),(65,'AL','48','LE','Lezhë',NULL),(66,'AL','49','SH','Shkodër',NULL),(67,'AL','50','TR','Tiranë',NULL),(68,'AL','51','VL','Vlorë',NULL),(69,'AM','01','AG','Aragac?otn',NULL),(70,'AM','02','AR','Ararat',NULL),(71,'AM','03','AV','Armavir',NULL),(72,'AM','04','GR','Gegark\'unik\'',NULL),(73,'AM','05','KT','Kotayk\'',NULL),(74,'AM','06','LO','Lo?y',NULL),(75,'AM','07','SH','Širak',NULL),(76,'AM','08','SU','Syunik\'',NULL),(77,'AM','09','TV','Tavuš',NULL),(78,'AM','10','VD','Vayoc Jor',NULL),(79,'AM','11','ER','Erevan',NULL),(80,'AO','01','BGU','Benguela',NULL),(81,'AO','02','BIE','Bié',NULL),(82,'AO','03','CAB','Cabinda',NULL),(83,'AO','04','CCU','Cuando-Cubango',NULL),(84,'AO','05','CNO','Cuanza Norte',NULL),(85,'AO','06','CUS','Cuanza Sul',NULL),(86,'AO','07','CNN','Cunene',NULL),(87,'AO','08','HUA','Huambo',NULL),(88,'AO','09','HUI','Huíla',NULL),(89,'AO','12','MAL','Malange',NULL),(90,'AO','13','NAM','Namibe',NULL),(91,'AO','14','MOX','Moxico',NULL),(92,'AO','15','UIG','Uíge',NULL),(93,'AO','16','ZAI','Zaire',NULL),(94,'AO','17','LNO','Lunda Norte',NULL),(95,'AO','18','LSU','Lunda Sul',NULL),(96,'AO','19','BGO','Bengo',NULL),(97,'AO','20','LUA','Luanda',NULL),(98,'AR','01','B','Buenos Aires',NULL),(99,'AR','02','K','Catamarca',NULL),(100,'AR','03','H','Chaco',NULL),(101,'AR','04','U','Chubut',NULL),(102,'AR','05','X','Córdoba',NULL),(103,'AR','06','W','Corrientes',NULL),(104,'AR','07','C','Ciudad Autónoma de Buenos Aires',NULL),(105,'AR','08','E','Entre Ríos',NULL),(106,'AR','09','P','Formosa',NULL),(107,'AR','10','Y','Jujuy',NULL),(108,'AR','11','L','La Pampa',NULL),(109,'AR','12','F','La Rioja',NULL),(110,'AR','13','M','Mendoza',NULL),(111,'AR','14','N','Misiones',NULL),(112,'AR','15','Q','Neuquén',NULL),(113,'AR','16','R','Río Negro',NULL),(114,'AR','17','A','Salta',NULL),(115,'AR','18','J','San Juan',NULL),(116,'AR','19','D','San Luis',NULL),(117,'AR','20','Z','Santa Cruz',NULL),(118,'AR','21','S','Santa Fe',NULL),(119,'AR','22','G','Santiago del Estero',NULL),(120,'AR','23','V','Tierra del Fuego',NULL),(121,'AR','24','T','Tucumán',NULL),(122,'AT','01','1','Burgenland',NULL),(123,'AT','02','2','Kärnten',NULL),(124,'AT','03','3','Niederösterreich',NULL),(125,'AT','04','4','Oberösterreich',NULL),(126,'AT','05','5','Salzburg',NULL),(127,'AT','06','6','Steiermark',NULL),(128,'AT','07','7','Tirol',NULL),(129,'AT','08','8','Vorarlberg',NULL),(130,'AT','09','9','Wien',NULL),(131,'AU','01','ACT','Australian Capital Territory',224),(132,'AU','02','NSW','New South Wales',224),(133,'AU','03','NT','Northern Territory',225),(134,'AU','04','QLD','Queensland',226),(135,'AU','05','SA','South Australia',227),(136,'AU','06','TAS','Tasmania',228),(137,'AU','07','VIC','Victoria',229),(138,'AU','08','WA','Western Australia',230),(139,'AZ','01','ABS','Abseron',NULL),(140,'AZ','02','AGC','Agcabädi',NULL),(141,'AZ','03','AGM','Agdam',NULL),(142,'AZ','04','AGS','Agdas',NULL),(143,'AZ','05','AGA','Agstafa',NULL),(144,'AZ','06','AGU','Agsu',NULL),(145,'AZ','07','AB','Äli Bayramli',NULL),(146,'AZ','08','AST','Astara',NULL),(147,'AZ','09','BA','Baki',NULL),(148,'AZ','10','BAL','Balakän',NULL),(149,'AZ','11','BAR','Bärdä',NULL),(150,'AZ','12','BEY','Beyläqan',NULL),(151,'AZ','13','BIL','Biläsuvar',NULL),(152,'AZ','14','CAB','Cäbrayil',NULL),(153,'AZ','15',NULL,'Calilabad',NULL),(154,'AZ','16','DAS','Daskäsän',NULL),(155,'AZ','17','DAV','Däväçi',NULL),(156,'AZ','18','FUZ','Füzuli',NULL),(157,'AZ','19','GAD','Gädäbäy',NULL),(158,'AZ','20','GA','Gäncä',NULL),(159,'AZ','21','GOR','Goranboy',NULL),(160,'AZ','22','GOY','Göyçay',NULL),(161,'AZ','23','HAC','Haciqabul',NULL),(162,'AZ','24','IMI','Imisli',NULL),(163,'AZ','25','ISM','Ismayilli',NULL),(164,'AZ','26','KAL','Kälbäcär',NULL),(165,'AZ','27','KUR','Kürdämir',NULL),(166,'AZ','28','LAC','Laçin',NULL),(167,'AZ','29','LAN','Länkäran',NULL),(168,'AZ','30',NULL,'Lankaran',NULL),(169,'AZ','31','LER','Lerik',NULL),(170,'AZ','32','MAS','Masalli',NULL),(171,'AZ','33','MI','Mingäçevir',NULL),(172,'AZ','34','NA','Naftalan',NULL),(173,'AZ','35','NX','Naxçivan',NULL),(174,'AZ','36','NEF','Neftçala',NULL),(175,'AZ','37','OGU','Oguz',NULL),(176,'AZ','38','QAB','Qäbälä',NULL),(177,'AZ','39','QAX','Qax',NULL),(178,'AZ','40','QAZ','Qazax',NULL),(179,'AZ','41','QOB','Qobustan',NULL),(180,'AZ','42','QBA','Quba',NULL),(181,'AZ','43','QBI','Qubadli',NULL),(182,'AZ','44','QUS','Qusar',NULL),(183,'AZ','45','SAT','Saatli',NULL),(184,'AZ','46','SAB','Sabirabad',NULL),(185,'AZ','47','SAK','Säki',NULL),(186,'AZ','48',NULL,'Saki',NULL),(187,'AZ','49','SAL','Salyan',NULL),(188,'AZ','50','SMI','Samaxi',NULL),(189,'AZ','51','SKR','Sämkir',NULL),(190,'AZ','52','SMX','Samux',NULL),(191,'AZ','53','SIY','Siyäzän',NULL),(192,'AZ','54','SM','Sumqayit',NULL),(193,'AZ','55','SUS','Susa',NULL),(194,'AZ','56',NULL,'Susa',NULL),(195,'AZ','57','TAR','Tärtär',NULL),(196,'AZ','58','TOV','Tovuz',NULL),(197,'AZ','59','UCA','Ucar',NULL),(198,'AZ','60','XAC','Xaçmaz',NULL),(199,'AZ','61','XA','Xankändi',NULL),(200,'AZ','62','XAN','Xanlar',NULL),(201,'AZ','63','XIZ','Xizi',NULL),(202,'AZ','64','XCI','Xocali',NULL),(203,'AZ','65','XVD','Xocavänd',NULL),(204,'AZ','66','YAR','Yardimli',NULL),(205,'AZ','67','YEV','Yevlax',NULL),(206,'AZ','68',NULL,'Yevlax',NULL),(207,'AZ','69','ZAN','Zängilan',NULL),(208,'AZ','70','ZAQ','Zaqatala',NULL),(209,'AZ','71','ZAR','Zärdab',NULL),(210,'BA','01',NULL,'Federation of Bosnia and Herzegovina',NULL),(211,'BA','02','SRP','Republika Srpska',NULL),(212,'BB','01','01','Christ Church',NULL),(213,'BB','02','02','Saint Andrew',NULL),(214,'BB','03','03','Saint George',NULL),(215,'BB','04','04','Saint James',NULL),(216,'BB','05','05','Saint John',NULL),(217,'BB','06','06','Saint Joseph',NULL),(218,'BB','07','07','Saint Lucy',NULL),(219,'BB','08','08','Saint Michael',NULL),(220,'BB','09','09','Saint Peter',NULL),(221,'BB','10','10','Saint Philip',NULL),(222,'BB','11','11','Saint Thomas',NULL),(223,'BD','81',NULL,'Dhaka',NULL),(224,'BD','82',NULL,'Khulna',NULL),(225,'BD','83',NULL,'Rajshahi',NULL),(226,'BD','84',NULL,'Chittagong',NULL),(227,'BD','85',NULL,'Barisal',NULL),(228,'BD','86',NULL,'Sylhet',NULL),(229,'BE','01','VAN','Antwerpen',NULL),(230,'BE','03','WHT','Hainaut',NULL),(231,'BE','04','WLG','Liège',NULL),(232,'BE','05','VLI','Limburg',NULL),(233,'BE','06','WLX','Luxembourg',NULL),(234,'BE','07','WNA','Namur',NULL),(235,'BE','08','VOV','Oost-Vlaanderen',NULL),(236,'BE','09','VWV','West-Vlaanderen',NULL),(237,'BE','10','WBR','Brabant Wallon',NULL),(238,'BE','11','BRU','Brussels',NULL),(239,'BE','12','VBR','Vlaams Brabant',NULL),(240,'BE','13',NULL,'Flanders',NULL),(241,'BE','14',NULL,'Wallonia',NULL),(242,'BF','15','BAM','Bam',NULL),(243,'BF','19','BLK','Boulkiemdé',NULL),(244,'BF','20','GAN','Ganzourgou',NULL),(245,'BF','21','GNA','Gnagna',NULL),(246,'BF','28','KOT','Kouritenga',NULL),(247,'BF','33','OUD','Oudalan',NULL),(248,'BF','34','PAS','Passoré',NULL),(249,'BF','36','SNG','Sanguié',NULL),(250,'BF','40','SOM','Soum',NULL),(251,'BF','42','TAP','Tapoa',NULL),(252,'BF','44','ZOU','Zoundwéogo',NULL),(253,'BF','45','BAL','Balé',NULL),(254,'BF','46','BAN','Banwa',NULL),(255,'BF','47','BAZ','Bazèga',NULL),(256,'BF','48','BGR','Bougouriba',NULL),(257,'BF','49','BLG','Boulgou',NULL),(258,'BF','50','GOU','Gourma',NULL),(259,'BF','51','HOU','Houet',NULL),(260,'BF','52','IOB','Ioba',NULL),(261,'BF','53','KAD','Kadiogo',NULL),(262,'BF','54','KEN','Kénédougou',NULL),(263,'BF','55',NULL,'Komoe',NULL),(264,'BF','56','KMD','Komondjari',NULL),(265,'BF','57','KMP','Kompienga',NULL),(266,'BF','58','KOS','Kossi',NULL),(267,'BF','59','KOP','Koulpélogo',NULL),(268,'BF','60','KOW','Kourwéogo',NULL),(269,'BF','61','LER','Léraba',NULL),(270,'BF','62','LOR','Loroum',NULL),(271,'BF','63','MOU','Mouhoun',NULL),(272,'BF','64','NAM','Namentenga',NULL),(273,'BF','65',NULL,'Naouri',NULL),(274,'BF','66','NAY','Nayala',NULL),(275,'BF','67','NOU','Noumbiel',NULL),(276,'BF','68','OUB','Oubritenga',NULL),(277,'BF','69','PON','Poni',NULL),(278,'BF','70','SMT','Sanmatenga',NULL),(279,'BF','71','SEN','Séno',NULL),(280,'BF','72','SIS','Sissili',NULL),(281,'BF','73','SOR','Sourou',NULL),(282,'BF','74',NULL,'Tuy',NULL),(283,'BF','75','YAG','Yagha',NULL),(284,'BF','76','YAT','Yatenga',NULL),(285,'BF','77','ZIR','Ziro',NULL),(286,'BF','78','ZON','Zondoma',NULL),(287,'BG','33',NULL,'Mikhaylovgrad',NULL),(288,'BG','38','01','Blagoevgrad',NULL),(289,'BG','39','02','Burgas',NULL),(290,'BG','40','08','Dobrich',NULL),(291,'BG','41','07','Gabrovo',NULL),(292,'BG','42',NULL,'Grad Sofiya',NULL),(293,'BG','43',NULL,'Khaskovo',NULL),(294,'BG','44',NULL,'Kurdzhali',NULL),(295,'BG','45',NULL,'Kyustendil',NULL),(296,'BG','46','11','Lovech',NULL),(297,'BG','47','12','Montana',NULL),(298,'BG','48','13','Pazardzhik',NULL),(299,'BG','49','14','Pernik',NULL),(300,'BG','50','15','Pleven',NULL),(301,'BG','51','16','Plovdiv',NULL),(302,'BG','52','17','Razgrad',NULL),(303,'BG','53','18','Ruse',NULL),(304,'BG','54',NULL,'Shumen',NULL),(305,'BG','55','19','Silistra',NULL),(306,'BG','56','20','Sliven',NULL),(307,'BG','57','21','Smolyan',NULL),(308,'BG','58',NULL,'Sofiya',NULL),(309,'BG','59','24','Stara Zagora',NULL),(310,'BG','60',NULL,'Turgovishte',NULL),(311,'BG','61','03','Varna',NULL),(312,'BG','62',NULL,'Veliko Turnovo',NULL),(313,'BG','63','05','Vidin',NULL),(314,'BG','64','06','Vratsa',NULL),(315,'BG','65','28','Yambol',NULL),(316,'BH','01',NULL,'Al Hadd',NULL),(317,'BH','02','13','Al Manamah',NULL),(318,'BH','05',NULL,'Jidd Hafs',NULL),(319,'BH','06',NULL,'Sitrah',NULL),(320,'BH','08',NULL,'Al Mintaqah al Gharbiyah',NULL),(321,'BH','09',NULL,'Mintaqat Juzur Hawar',NULL),(322,'BH','10','17','Ash Shamaliyah',NULL),(323,'BH','11','16','Al Wustá',NULL),(324,'BH','12',NULL,'Madinat',NULL),(325,'BH','13',NULL,'Ar Rifa',NULL),(326,'BH','14',NULL,'Madinat Hamad',NULL),(327,'BH','15',NULL,'Al Muharraq',NULL),(328,'BH','16',NULL,'Al Asimah',NULL),(329,'BH','17','14','Al Janubiyah',NULL),(330,'BH','18',NULL,'Ash Shamaliyah',NULL),(331,'BH','19',NULL,'Al Wusta',NULL),(332,'BI','02',NULL,'Bujumbura',NULL),(333,'BI','09','BB','Bubanza',NULL),(334,'BI','10','BR','Bururi',NULL),(335,'BI','11','CA','Cankuzo',NULL),(336,'BI','12','CI','Cibitoke',NULL),(337,'BI','13','GI','Gitega',NULL),(338,'BI','14','KR','Karuzi',NULL),(339,'BI','15','KY','Kayanza',NULL),(340,'BI','16','KI','Kirundo',NULL),(341,'BI','17','MA','Makamba',NULL),(342,'BI','18','MY','Muyinga',NULL),(343,'BI','19','NG','Ngozi',NULL),(344,'BI','20','RT','Rutana',NULL),(345,'BI','21','RY','Ruyigi',NULL),(346,'BI','22','MU','Muramvya',NULL),(347,'BI','23','MW','Mwaro',NULL),(348,'BJ','07','AL','Alibori',NULL),(349,'BJ','08','AK','Atakora',NULL),(350,'BJ','09',NULL,'Atlanyique',NULL),(351,'BJ','10','BO','Borgou',NULL),(352,'BJ','11','CO','Collines',NULL),(353,'BJ','12','KO','Kouffo',NULL),(354,'BJ','13','DO','Donga',NULL),(355,'BJ','14','LI','Littoral',NULL),(356,'BJ','15','MO','Mono',NULL),(357,'BJ','16','OU','Ouémé',NULL),(358,'BJ','17','PL','Plateau',NULL),(359,'BJ','18','ZO','Zou',NULL),(360,'BM','01',NULL,'Devonshire',NULL),(361,'BM','02',NULL,'Hamilton',NULL),(362,'BM','03',NULL,'Hamilton',NULL),(363,'BM','04',NULL,'Paget',NULL),(364,'BM','05',NULL,'Pembroke',NULL),(365,'BM','06',NULL,'Saint George',NULL),(366,'BM','07',NULL,'Saint George\'s',NULL),(367,'BM','08',NULL,'Sandys',NULL),(368,'BM','09',NULL,'Smiths',NULL),(369,'BM','10',NULL,'Southampton',NULL),(370,'BM','11',NULL,'Warwick',NULL),(371,'BN','07',NULL,'Alibori',NULL),(372,'BN','08','BE','Belait',NULL),(373,'BN','09',NULL,'Brunei and Muara',NULL),(374,'BN','10','TE','Temburong',NULL),(375,'BN','11',NULL,'Collines',NULL),(376,'BN','12',NULL,'Kouffo',NULL),(377,'BN','13',NULL,'Donga',NULL),(378,'BN','14',NULL,'Littoral',NULL),(379,'BN','15','TU','Tutong',NULL),(380,'BN','16',NULL,'Oueme',NULL),(381,'BN','17',NULL,'Plateau',NULL),(382,'BN','18',NULL,'Zou',NULL),(383,'BO','01','H','Chuquisaca',NULL),(384,'BO','02','C','Cochabamba',NULL),(385,'BO','03','B','El Beni',NULL),(386,'BO','04','L','La Paz',NULL),(387,'BO','05','O','Oruro',NULL),(388,'BO','06','N','Pando',NULL),(389,'BO','07','P','Potosí',NULL),(390,'BO','08','S','Santa Cruz',NULL),(391,'BO','09','T','Tarija',NULL),(392,'BR','01','AC','Acre',231),(393,'BR','02','AL','Alagoas',232),(394,'BR','03','AP','Amapá',233),(395,'BR','04','AM','Amazonas',234),(396,'BR','05','BA','Bahia',235),(397,'BR','06','CE','Ceará',236),(398,'BR','07','DF','Distrito Federal',233),(399,'BR','08','ES','Espírito Santo',233),(400,'BR','11','MS','Mato Grosso do Sul',237),(401,'BR','13','MA','Maranhão',238),(402,'BR','14','MT','Mato Grosso',239),(403,'BR','15','MG','Minas Gerais',233),(404,'BR','16','PA','Pará',238),(405,'BR','17','PB','Paraíba',240),(406,'BR','18','PR','Paraná',233),(407,'BR','20','PI','Piauí',236),(408,'BR','21','RJ','Rio de Janeiro',233),(409,'BR','22','RN','Rio Grande do Norte',240),(410,'BR','23','RS','Rio Grande do Sul',233),(411,'BR','24','RO','Rondônia',241),(412,'BR','25','RR','Roraima',242),(413,'BR','26','SC','Santa Catarina',233),(414,'BR','27','SP','São Paulo',233),(415,'BR','28','SE','Sergipe',232),(416,'BR','29','GO','Goiás',233),(417,'BR','30','PE','Pernambuco',240),(418,'BR','31','TO','Tocantins',243),(419,'BS','05',NULL,'Bimini',NULL),(420,'BS','06','CI','Cat Island',NULL),(421,'BS','10','EX','Exuma',NULL),(422,'BS','13','IN','Inagua',NULL),(423,'BS','15','LI','Long Island',NULL),(424,'BS','16','MG','Mayaguana',NULL),(425,'BS','18','RI','Ragged Island',NULL),(426,'BS','22','HI','Harbour Island',NULL),(427,'BS','23',NULL,'New Providence',NULL),(428,'BS','24',NULL,'Acklins and Crooked Islands',NULL),(429,'BS','25',NULL,'Freeport',NULL),(430,'BS','26',NULL,'Fresh Creek',NULL),(431,'BS','27',NULL,'Governor\'s Harbour',NULL),(432,'BS','28','GT','Green Turtle Cay',NULL),(433,'BS','29',NULL,'High Rock',NULL),(434,'BS','30',NULL,'Kemps Bay',NULL),(435,'BS','31',NULL,'Marsh Harbour',NULL),(436,'BS','32',NULL,'Nichollstown and Berry Islands',NULL),(437,'BS','33',NULL,'Rock Sound',NULL),(438,'BS','34',NULL,'Sandy Point',NULL),(439,'BS','35',NULL,'San Salvador and Rum Cay',NULL),(440,'BT','05','33','Bumthang',NULL),(441,'BT','06','12','Chhukha',NULL),(442,'BT','07','21','Tsirang',NULL),(443,'BT','08','22','Dagana',NULL),(444,'BT','09',NULL,'Geylegphug',NULL),(445,'BT','10','13','Ha',NULL),(446,'BT','11','44','Lhuentse',NULL),(447,'BT','12','42','Monggar',NULL),(448,'BT','13','11','Paro',NULL),(449,'BT','14','43','Pemagatshel',NULL),(450,'BT','15','23','Punakha',NULL),(451,'BT','16','14','Samtse',NULL),(452,'BT','17','45','Samdrup Jongkha',NULL),(453,'BT','18','34','Zhemgang',NULL),(454,'BT','19','41','Trashigang',NULL),(455,'BT','20','15','Thimphu',NULL),(456,'BT','21','32','Trongsa',NULL),(457,'BT','22','24','Wangdue Phodrang',NULL),(458,'BW','01','CE','Central',NULL),(459,'BW','03','GH','Ghanzi',NULL),(460,'BW','04','KG','Kgalagadi',NULL),(461,'BW','05','KL','Kgatleng',NULL),(462,'BW','06','KW','Kweneng',NULL),(463,'BW','08','NE','North-East',NULL),(464,'BW','09','SE','South-East',NULL),(465,'BW','10','SO','Southern',NULL),(466,'BW','11','NW','North-West',NULL),(467,'BY','01',NULL,'Brestskaya Voblasts\'',NULL),(468,'BY','02',NULL,'Homyel\'skaya Voblasts\'',NULL),(469,'BY','03',NULL,'Hrodzyenskaya Voblasts\'',NULL),(470,'BY','04',NULL,'Minsk',NULL),(471,'BY','05',NULL,'Minskaya Voblasts\'',NULL),(472,'BY','06',NULL,'Mahilyowskaya Voblasts\'',NULL),(473,'BY','07',NULL,'Vitsyebskaya Voblasts\'',NULL),(474,'BZ','01','BZ','Belize',NULL),(475,'BZ','02','CY','Cayo',NULL),(476,'BZ','03','CZL','Corozal',NULL),(477,'BZ','04','OW','Orange Walk',NULL),(478,'BZ','05','SC','Stann Creek',NULL),(479,'BZ','06','TOL','Toledo',NULL),(480,'CA','01','AB','Alberta',244),(481,'CA','02','BC','British Columbia',245),(482,'CA','03','MB','Manitoba',246),(483,'CA','04','NB','New Brunswick',247),(484,'CA','05','NL','Newfoundland and Labrador',248),(485,'CA','07','NS','Nova Scotia',247),(486,'CA','08','ON','Ontario',251),(487,'CA','09','PE','Prince Edward Island',247),(488,'CA','10','QC','Quebec',252),(489,'CA','11','SK','Saskatchewan',253),(490,'CA','12','YT','Yukon Territory',254),(491,'CA','13','NT','Northwest Territories',249),(492,'CA','14','NU','Nunavut',250),(493,'CD','01','BN','Bandundu',NULL),(494,'CD','02','EQ','Équateur',255),(495,'CD','04','KE','Kasai-Oriental',NULL),(496,'CD','05','KA','Katanga',256),(497,'CD','06','KN','Kinshasa',255),(498,'CD','08','BC','Bas-Congo',255),(499,'CD','09','OR','Orientale',NULL),(500,'CD','10','MA','Maniema',256),(501,'CD','11','NK','Nord-Kivu',256),(502,'CD','12','SK','Sud-Kivu',256),(503,'CF','01','BB','Bamingui-Bangoran',NULL),(504,'CF','02','BK','Basse-Kotto',NULL),(505,'CF','03','HK','Haute-Kotto',NULL),(506,'CF','04',NULL,'Mambere-Kadei',NULL),(507,'CF','05','HM','Haut-Mbomou',NULL),(508,'CF','06',NULL,'Kemo',NULL),(509,'CF','07','LB','Lobaye',NULL),(510,'CF','08','MB','Mbomou',NULL),(511,'CF','09','NM','Nana-Mambéré',NULL),(512,'CF','11','UK','Ouaka',NULL),(513,'CF','12','AC','Ouham',NULL),(514,'CF','13','OP','Ouham-Pendé',NULL),(515,'CF','14',NULL,'Cuvette-Ouest',NULL),(516,'CF','15','KB','Gribingui',NULL),(517,'CF','16',NULL,'Sangha-Mbaere',NULL),(518,'CF','17','MP','Ombella-Mpoko',NULL),(519,'CF','18','BGF','Bangui',NULL),(520,'CG','01','11','Bouenza',NULL),(521,'CG','04','5','Kouilou',NULL),(522,'CG','05','2','Lékoumou',NULL),(523,'CG','06','7','Likouala',NULL),(524,'CG','07','9','Niari',NULL),(525,'CG','08','14','Plateaux',NULL),(526,'CG','10','13','Sangha',NULL),(527,'CG','11','12','Pool',NULL),(528,'CG','12','BZV','Brazzaville',NULL),(529,'CG','13','8','Cuvette',NULL),(530,'CG','14','15','Cuvette-Ouest',NULL),(531,'CH','01','AG','Aargau',NULL),(532,'CH','02',NULL,'Ausser-Rhoden',NULL),(533,'CH','03','BL','Basel-Landschaft',NULL),(534,'CH','04','BS','Basel-Stadt',NULL),(535,'CH','05','BE','Bern',NULL),(536,'CH','06','FR','Fribourg',NULL),(537,'CH','07','GE','Genève',NULL),(538,'CH','08','GL','Glarus',NULL),(539,'CH','09','GR','Graubünden',NULL),(540,'CH','10',NULL,'Inner-Rhoden',NULL),(541,'CH','11','LU','Luzern',NULL),(542,'CH','12','NE','Neuchâtel',NULL),(543,'CH','13','NW','Nidwalden',NULL),(544,'CH','14','OW','Obwalden',NULL),(545,'CH','15','SG','Sankt Gallen',NULL),(546,'CH','16','SH','Schaffhausen',NULL),(547,'CH','17','SZ','Schwyz',NULL),(548,'CH','18','SO','Solothurn',NULL),(549,'CH','19','TG','Thurgau',NULL),(550,'CH','20','TI','Ticino',NULL),(551,'CH','21','UR','Uri',NULL),(552,'CH','22','VS','Valais',NULL),(553,'CH','23','VD','Vaud',NULL),(554,'CH','24','ZG','Zug',NULL),(555,'CH','25','ZH','Zürich',NULL),(556,'CH','26','JU','Jura',NULL),(557,'CI','74',NULL,'Agneby',NULL),(558,'CI','75','17','Bafing',NULL),(559,'CI','76','09','Bas-Sassandra',NULL),(560,'CI','77','10','Denguélé',NULL),(561,'CI','78',NULL,'Dix-Huit Montagnes',NULL),(562,'CI','79','18','Fromager',NULL),(563,'CI','80','02','Haut-Sassandra',NULL),(564,'CI','81','07','Lacs',NULL),(565,'CI','82','01','Lagunes',NULL),(566,'CI','83','12','Marahoué',NULL),(567,'CI','84','19','Moyen-Cavally',NULL),(568,'CI','85','05','Moyen-Comoé',NULL),(569,'CI','86',NULL,'N\'zi-Comoe',NULL),(570,'CI','87','03','Savanes',NULL),(571,'CI','88','15','Sud-Bandama',NULL),(572,'CI','89','13','Sud-Comoé',NULL),(573,'CI','90','04','Vallée du Bandama',NULL),(574,'CI','91','14','Worodougou',NULL),(575,'CI','92','08','Zanzan',NULL),(576,'CL','01','VS','Valparaíso',NULL),(577,'CL','02','AI','Aisén del General Carlos Ibáñez del Campo',NULL),(578,'CL','03','AN','Antofagasta',NULL),(579,'CL','04','AR','Araucanía',NULL),(580,'CL','05','AT','Atacama',NULL),(581,'CL','06','BI','Bío-Bío',NULL),(582,'CL','07','CO','Coquimbo',NULL),(583,'CL','08','LI','Libertador General Bernardo O\'Higgins',NULL),(584,'CL','09','LL','Los Lagos',NULL),(585,'CL','10',NULL,'Magallanes y de la Antartica Chilena',NULL),(586,'CL','11','ML','Maule',NULL),(587,'CL','12',NULL,'Region Metropolitana',NULL),(588,'CL','13','TA','Tarapacá',NULL),(589,'CL','14',NULL,'Los Lagos',NULL),(590,'CL','15',NULL,'Tarapaca',NULL),(591,'CL','16','AP','Arica y Parinacota',NULL),(592,'CL','17','LR','Los Ríos',NULL),(593,'CM','04','ES','East',NULL),(594,'CM','05','LT','Littoral',NULL),(595,'CM','07','NW','North-West',NULL),(596,'CM','08','OU','West',NULL),(597,'CM','09','SW','South-West',NULL),(598,'CM','10','AD','Adamaoua',NULL),(599,'CM','11','CE','Centre',NULL),(600,'CM','12','EN','Far North',NULL),(601,'CM','13','NO','North',NULL),(602,'CM','14','SU','South',NULL),(603,'CN','01','34','Anhui',258),(604,'CN','02','33','Zhejiang',258),(605,'CN','03','36','Jiangxi',258),(606,'CN','04','32','Jiangsu',258),(607,'CN','05','22','Jilin',259),(608,'CN','06','63','Qinghai',260),(609,'CN','07','35','Fujian',258),(610,'CN','08','23','Heilongjiang',259),(611,'CN','09','41','Henan',258),(612,'CN','10','13','Hebei',258),(613,'CN','11','43','Hunan',260),(614,'CN','12','42','Hubei',258),(615,'CN','13','65','Xinjiang',261),(616,'CN','14','54','Xizang',260),(617,'CN','15','62','Gansu',260),(618,'CN','16','45','Guangxi',260),(619,'CN','18','52','Guizhou',260),(620,'CN','19','21','Liaoning',259),(621,'CN','20','15','Nei Mongol',259),(622,'CN','21','64','Ningxia',260),(623,'CN','22','11','Beijing',259),(624,'CN','23','31','Shanghai',258),(625,'CN','24','14','Shanxi',260),(626,'CN','25','37','Shandong',258),(627,'CN','26','61','Shaanxi',260),(628,'CN','28','12','Tianjin',258),(629,'CN','29','53','Yunnan',260),(630,'CN','30','44','Guangdong',260),(631,'CN','31','46','Hainan',260),(632,'CN','32','51','Sichuan',260),(633,'CN','33','50','Chongqing',260),(634,'CO','01','AMA','Amazonas',NULL),(635,'CO','02','ANT','Antioquia',NULL),(636,'CO','03','ARA','Arauca',NULL),(637,'CO','04','ATL','Atlántico',NULL),(638,'CO','08','CAQ','Caquetá',NULL),(639,'CO','09','CAU','Cauca',NULL),(640,'CO','10','CES','Cesar',NULL),(641,'CO','11','CHO','Chocó',NULL),(642,'CO','12','COR','Córdoba',NULL),(643,'CO','14','GUV','Guaviare',NULL),(644,'CO','15','GUA','Guainía',NULL),(645,'CO','16','HUI','Huila',NULL),(646,'CO','17','LAG','La Guajira',NULL),(647,'CO','19','MET','Meta',NULL),(648,'CO','20','NAR','Nariño',NULL),(649,'CO','21','NSA','Norte de Santander',NULL),(650,'CO','22','PUT','Putumayo',NULL),(651,'CO','23','QUI','Quindío',NULL),(652,'CO','24','RIS','Risaralda',NULL),(653,'CO','25','SAP','San Andrés, Providencia y Santa Catalina',NULL),(654,'CO','26','SAN','Santander',NULL),(655,'CO','27','SUC','Sucre',NULL),(656,'CO','28','TOL','Tolima',NULL),(657,'CO','29','VAC','Valle del Cauca',NULL),(658,'CO','30','VAU','Vaupés',NULL),(659,'CO','31','VID','Vichada',NULL),(660,'CO','32','CAS','Casanare',NULL),(661,'CO','33','CUN','Cundinamarca',NULL),(662,'CO','34','DC','Distrito Capital de Bogotá',NULL),(663,'CO','35','BOL','Bolívar',NULL),(664,'CO','36','BOY','Boyacá',NULL),(665,'CO','37','CAL','Caldas',NULL),(666,'CO','38','MAG','Magdalena',NULL),(667,'CR','01','A','Alajuela',NULL),(668,'CR','02','C','Cartago',NULL),(669,'CR','03','G','Guanacaste',NULL),(670,'CR','04','H','Heredia',NULL),(671,'CR','06','L','Limón',NULL),(672,'CR','07','P','Puntarenas',NULL),(673,'CR','08','SJ','San José',NULL),(674,'CU','01','01','Pinar del Río',NULL),(675,'CU','02','03','Ciudad de La Habana',NULL),(676,'CU','03','04','Matanzas',NULL),(677,'CU','04','99','Isla de la Juventud',NULL),(678,'CU','05','09','Camagüey',NULL),(679,'CU','07','08','Ciego de Ávila',NULL),(680,'CU','08','06','Cienfuegos',NULL),(681,'CU','09','12','Granma',NULL),(682,'CU','10','14','Guantánamo',NULL),(683,'CU','11','02','La Habana',NULL),(684,'CU','12','11','Holguín',NULL),(685,'CU','13','10','Las Tunas',NULL),(686,'CU','14','07','Sancti Spíritus',NULL),(687,'CU','15','13','Santiago de Cuba',NULL),(688,'CU','16','05','Villa Clara',NULL),(689,'CV','01','BV','Boa Vista',NULL),(690,'CV','02','BR','Brava',NULL),(691,'CV','04','MA','Maio',NULL),(692,'CV','05','PA','Paul',NULL),(693,'CV','07','RG','Ribeira Grande',NULL),(694,'CV','08','SL','São Lourenço dos Órgãos',NULL),(695,'CV','10',NULL,'Sao Nicolau',NULL),(696,'CV','11','SV','São Vicente',NULL),(697,'CV','13','MO','Mosteiros',NULL),(698,'CV','14','PR','Praia',NULL),(699,'CV','15','CA','Santa Catarina',NULL),(700,'CV','16','CR','Santa Cruz',NULL),(701,'CV','17','SD','São Domingos',NULL),(702,'CV','18','SF','São Filipe',NULL),(703,'CV','19','SM','São Miguel',NULL),(704,'CV','20','TA','Tarrafal',NULL),(705,'CY','01','04','Ammochostos',NULL),(706,'CY','02','06','Keryneia',NULL),(707,'CY','03','03','Larnaka',NULL),(708,'CY','04','01','Lefkosia',NULL),(709,'CY','05','02','Lemesos',NULL),(710,'CY','06','05','Pafos',NULL),(711,'CZ','52',NULL,'Hlavni mesto Praha',NULL),(712,'CZ','78','JM','Jihomoravský kraj',NULL),(713,'CZ','79','JC','Jihoceský kraj',NULL),(714,'CZ','80','VY','Vysocina',NULL),(715,'CZ','81','KA','Karlovarský kraj',NULL),(716,'CZ','82','KR','Královéhradecký kraj',NULL),(717,'CZ','83','LI','Liberecký kraj',NULL),(718,'CZ','84','OL','Olomoucký kraj',NULL),(719,'CZ','85','MO','Moravskoslezský kraj',NULL),(720,'CZ','86','PA','Pardubický kraj',NULL),(721,'CZ','87','PL','Plzenský kraj',NULL),(722,'CZ','88','ST','Stredoceský kraj',NULL),(723,'CZ','89','US','Ústecký kraj',NULL),(724,'CZ','90','ZL','Zlínský kraj',NULL),(725,'DE','01','BW','Baden-Württemberg',NULL),(726,'DE','02','BY','Bayern',NULL),(727,'DE','03','HB','Bremen',NULL),(728,'DE','04','HH','Hamburg',NULL),(729,'DE','05','HE','Hessen',NULL),(730,'DE','06','NI','Niedersachsen',NULL),(731,'DE','07','NW','Nordrhein-Westfalen',NULL),(732,'DE','08','RP','Rheinland-Pfalz',NULL),(733,'DE','09','SL','Saarland',NULL),(734,'DE','10','SH','Schleswig-Holstein',NULL),(735,'DE','11','BB','Brandenburg',NULL),(736,'DE','12','MV','Mecklenburg-Vorpommern',NULL),(737,'DE','13','SN','Sachsen',NULL),(738,'DE','14','ST','Sachsen-Anhalt',NULL),(739,'DE','15','TH','Thüringen',NULL),(740,'DE','16','BE','Berlin',NULL),(741,'DJ','01','AS','Ali Sabieh',NULL),(742,'DJ','04','OB','Obock',NULL),(743,'DJ','05','TA','Tadjourah',NULL),(744,'DJ','06','DI','Dikhil',NULL),(745,'DJ','07','DJ','Djibouti',NULL),(746,'DJ','08','AR','Arta',NULL),(747,'DK','17',NULL,'Hovedstaden',NULL),(748,'DK','18',NULL,'Midtjylland',NULL),(749,'DK','19','080','Nordjylland',NULL),(750,'DK','20',NULL,'Sjelland',NULL),(751,'DK','21',NULL,'Syddanmark',NULL),(752,'DM','02','02','Saint Andrew',NULL),(753,'DM','03','03','Saint David',NULL),(754,'DM','04','04','Saint George',NULL),(755,'DM','05','05','Saint John',NULL),(756,'DM','06','06','Saint Joseph',NULL),(757,'DM','07','07','Saint Luke',NULL),(758,'DM','08','08','Saint Mark',NULL),(759,'DM','09','09','Saint Patrick',NULL),(760,'DM','10','10','Saint Paul',NULL),(761,'DM','11','11','Saint Peter',NULL),(762,'DO','01','02','Azua',NULL),(763,'DO','02',NULL,'Baoruco',NULL),(764,'DO','03','04','Barahona',NULL),(765,'DO','04','05','Dajabón',NULL),(766,'DO','05','01','Distrito Nacional',NULL),(767,'DO','06','06','Duarte',NULL),(768,'DO','08','09','Espaillat',NULL),(769,'DO','09','10','Independencia',NULL),(770,'DO','10','11','La Altagracia',NULL),(771,'DO','11',NULL,'Elias Pina',NULL),(772,'DO','12','12','La Romana',NULL),(773,'DO','14','14','María Trinidad Sánchez',NULL),(774,'DO','15','15','Monte Cristi',NULL),(775,'DO','16','16','Pedernales',NULL),(776,'DO','17','17','Peravia',NULL),(777,'DO','18','18','Puerto Plata',NULL),(778,'DO','19','19','Salcedo',NULL),(779,'DO','20','20','Samaná',NULL),(780,'DO','21','24','Sánchez Ramírez',NULL),(781,'DO','23','22','San Juan',NULL),(782,'DO','24','23','San Pedro de Macorís',NULL),(783,'DO','25','25','Santiago',NULL),(784,'DO','26','26','Santiago Rodríguez',NULL),(785,'DO','27','27','Valverde',NULL),(786,'DO','28',NULL,'El Seibo',NULL),(787,'DO','29','30','Hato Mayor',NULL),(788,'DO','30','13','La Vega',NULL),(789,'DO','31','28','Monseñor Nouel',NULL),(790,'DO','32','29','Monte Plata',NULL),(791,'DO','33','21','San Cristóbal',NULL),(792,'DO','34',NULL,'Distrito Nacional',NULL),(793,'DO','35',NULL,'Peravia',NULL),(794,'DO','36','31','San Jose de Ocoa',NULL),(795,'DO','37',NULL,'Santo Domingo',NULL),(796,'DZ','01','16','Alger',NULL),(797,'DZ','03','05','Batna',NULL),(798,'DZ','04','25','Constantine',NULL),(799,'DZ','06','26','Médéa',NULL),(800,'DZ','07','27','Mostaganem',NULL),(801,'DZ','09','31','Oran',NULL),(802,'DZ','10','20','Saïda',NULL),(803,'DZ','12','19','Sétif',NULL),(804,'DZ','13','14','Tiaret',NULL),(805,'DZ','14','15','Tizi Ouzou',NULL),(806,'DZ','15','13','Tlemcen',NULL),(807,'DZ','18','06','Béjaïa',NULL),(808,'DZ','19','07','Biskra',NULL),(809,'DZ','20','09','Blida',NULL),(810,'DZ','21','10','Bouira',NULL),(811,'DZ','22','17','Djelfa',NULL),(812,'DZ','23','24','Guelma',NULL),(813,'DZ','24','18','Jijel',NULL),(814,'DZ','25','03','Laghouat',NULL),(815,'DZ','26','29','Mascara',NULL),(816,'DZ','27',NULL,'M\'sila',NULL),(817,'DZ','29','04','Oum el Bouaghi',NULL),(818,'DZ','30','22','Sidi Bel Abbès',NULL),(819,'DZ','31','21','Skikda',NULL),(820,'DZ','33','12','Tébessa',NULL),(821,'DZ','34','01','Adrar',NULL),(822,'DZ','35','44','Aïn Defla',NULL),(823,'DZ','36','46','Aïn Témouchent',NULL),(824,'DZ','37','23','Annaba',NULL),(825,'DZ','38','08','Béchar',NULL),(826,'DZ','39','34','Bordj Bou Arréridj',NULL),(827,'DZ','40','35','Boumerdès',NULL),(828,'DZ','41','02','Chlef',NULL),(829,'DZ','42','32','El Bayadh',NULL),(830,'DZ','43','39','El Oued',NULL),(831,'DZ','44','36','El Tarf',NULL),(832,'DZ','45','47','Ghardaïa',NULL),(833,'DZ','46','33','Illizi',NULL),(834,'DZ','47','40','Khenchela',NULL),(835,'DZ','48','43','Mila',NULL),(836,'DZ','49','45','Naama',NULL),(837,'DZ','50','30','Ouargla',NULL),(838,'DZ','51','48','Relizane',NULL),(839,'DZ','52','41','Souk Ahras',NULL),(840,'DZ','53','11','Tamanghasset',NULL),(841,'DZ','54','37','Tindouf',NULL),(842,'DZ','55','42','Tipaza',NULL),(843,'DZ','56','38','Tissemsilt',NULL),(844,'EC','01','W','Galápagos',323),(845,'EC','02','A','Azuay',NULL),(846,'EC','03','B','Bolívar',NULL),(847,'EC','04','F','Cañar',NULL),(848,'EC','05','C','Carchi',NULL),(849,'EC','06','H','Chimborazo',NULL),(850,'EC','07','X','Cotopaxi',NULL),(851,'EC','08','O','El Oro',NULL),(852,'EC','09','E','Esmeraldas',NULL),(853,'EC','10','G','Guayas',NULL),(854,'EC','11','I','Imbabura',NULL),(855,'EC','12','L','Loja',NULL),(856,'EC','13','R','Los Ríos',NULL),(857,'EC','14','M','Manabí',NULL),(858,'EC','15','S','Morona-Santiago',NULL),(859,'EC','17','Y','Pastaza',NULL),(860,'EC','18','P','Pichincha',NULL),(861,'EC','19','T','Tungurahua',NULL),(862,'EC','20','Z','Zamora-Chinchipe',NULL),(863,'EC','22','U','Sucumbíos',NULL),(864,'EC','23','N','Napo',NULL),(865,'EC','24','D','Orellana',NULL),(866,'EE','01','37','Harjumaa',NULL),(867,'EE','02','39','Hiiumaa',NULL),(868,'EE','03','44','Ida-Virumaa',NULL),(869,'EE','04','51','Järvamaa',NULL),(870,'EE','05','49','Jõgevamaa',NULL),(871,'EE','06',NULL,'Kohtla-Jarve',NULL),(872,'EE','07','57','Läänemaa',NULL),(873,'EE','08','59','Lääne-Virumaa',NULL),(874,'EE','09',NULL,'Narva',NULL),(875,'EE','10',NULL,'Parnu',NULL),(876,'EE','11','67','Pärnumaa',NULL),(877,'EE','12','65','Põlvamaa',NULL),(878,'EE','13','70','Raplamaa',NULL),(879,'EE','14','74','Saaremaa',NULL),(880,'EE','15',NULL,'Sillamae',NULL),(881,'EE','16',NULL,'Tallinn',NULL),(882,'EE','17',NULL,'Tartu',NULL),(883,'EE','18','78','Tartumaa',NULL),(884,'EE','19','82','Valgamaa',NULL),(885,'EE','20','84','Viljandimaa',NULL),(886,'EE','21','86','Võrumaa',NULL),(887,'EG','01','DK','Ad Daqahliyah',NULL),(888,'EG','02','BA','Al Bahr al Ahmar',NULL),(889,'EG','03','BH','Al Buhayrah',NULL),(890,'EG','04','FYM','Al Fayyum',NULL),(891,'EG','05','GH','Al Gharbiyah',NULL),(892,'EG','06','ALX','Al Iskandariyah',NULL),(893,'EG','07','IS','Al Ism?`?l?yah',NULL),(894,'EG','08','GZ','Al Jizah',NULL),(895,'EG','09','MNF','Al Minufiyah',NULL),(896,'EG','10','MN','Al Minya',NULL),(897,'EG','11','C','Al Qahirah',NULL),(898,'EG','12','KB','Al Qalyubiyah',NULL),(899,'EG','13','WAD','Al Wadi al Jadid',NULL),(900,'EG','14','SHR','Ash Sharqiyah',NULL),(901,'EG','15','SUZ','As Suways',NULL),(902,'EG','16','ASN','Aswan',NULL),(903,'EG','17','AST','Asyut',NULL),(904,'EG','18','BNS','Bani Suwayf',NULL),(905,'EG','19','PTS','B?r Sa`?d',NULL),(906,'EG','20','DT','Dumyat',NULL),(907,'EG','21','KFS','Kafr ash Shaykh',NULL),(908,'EG','22','MT','Matr?h',NULL),(909,'EG','23','KN','Qina',NULL),(910,'EG','24','SHG','Suhaj',NULL),(911,'EG','26','JS','Janub Sina\'',NULL),(912,'EG','27','SIN','Shamal Sina\'',NULL),(913,'ER','01','AN','Anseba',NULL),(914,'ER','02','DU','Debub',NULL),(915,'ER','03','DK','Debubawi Keyih Bahri',NULL),(916,'ER','04','GB','Gash-Barka',NULL),(917,'ER','05','MA','Maakel',NULL),(918,'ER','06','SK','Semenawi Keyih Bahri',NULL),(919,'ES','07',NULL,'Islas Baleares',NULL),(920,'ES','27','LO','La Rioja',NULL),(921,'ES','29','M','Madrid',NULL),(922,'ES','31','MU','Murcia',NULL),(923,'ES','32','NA','Navarra',NULL),(924,'ES','34','O','Asturias',NULL),(925,'ES','39','S','Cantabria',NULL),(926,'ES','51',NULL,'Andalucia',324),(927,'ES','52',NULL,'Aragon',NULL),(928,'ES','53',NULL,'Canarias',325),(929,'ES','54',NULL,'Castilla-La Mancha',NULL),(930,'ES','55',NULL,'Castilla y Leon',NULL),(931,'ES','56',NULL,'Catalonia',NULL),(932,'ES','57',NULL,'Extremadura',NULL),(933,'ES','58',NULL,'Galicia',NULL),(934,'ES','59',NULL,'Pais Vasco',NULL),(935,'ES','60',NULL,'Comunidad Valenciana',NULL),(936,'ET','44','AA','Adis Abeba',NULL),(937,'ET','45','AF','Afar',NULL),(938,'ET','46','AM','Amara',NULL),(939,'ET','47','BE','Binshangul Gumuz',NULL),(940,'ET','48','DD','Dire Dawa',NULL),(941,'ET','49','GA','Gambela Hizboch',NULL),(942,'ET','50','HA','Hareri Hizb',NULL),(943,'ET','51','OR','Oromiya',NULL),(944,'ET','52','SO','Sumale',NULL),(945,'ET','53','TI','Tigray',NULL),(946,'ET','54','SN','YeDebub Biheroch Bihereseboch na Hizboch',NULL),(947,'FI','01',NULL,'Aland',NULL),(948,'FI','06','LL','Lapin lääni',NULL),(949,'FI','08','OL','Oulun lääni',NULL),(950,'FI','13','ES','Etelä-Suomen lääni',NULL),(951,'FI','14','IS','Itä-Suomen lääni',NULL),(952,'FI','15','LS','Länsi-Suomen lääni',NULL),(953,'FJ','01','C','Central',NULL),(954,'FJ','02','E','Eastern',NULL),(955,'FJ','03','N','Northern',NULL),(956,'FJ','04','R','Rotuma',NULL),(957,'FJ','05','W','Western',NULL),(958,'FM','01','KSA','Kosrae',NULL),(959,'FM','02','PNI','Pohnpei',NULL),(960,'FM','03','TRK','Chuuk',NULL),(961,'FM','04','YAP','Yap',NULL),(962,'FR','97',NULL,'Aquitaine',NULL),(963,'FR','98',NULL,'Auvergne',NULL),(964,'FR','99',NULL,'Basse-Normandie',NULL),(965,'FR','A1',NULL,'Bourgogne',NULL),(966,'FR','A2',NULL,'Bretagne',NULL),(967,'FR','A3',NULL,'Centre',NULL),(968,'FR','A4',NULL,'Champagne-Ardenne',NULL),(969,'FR','A5',NULL,'Corse',NULL),(970,'FR','A6',NULL,'Franche-Comte',NULL),(971,'FR','A7',NULL,'Haute-Normandie',NULL),(972,'FR','A8','34','Hérault',NULL),(973,'FR','A9',NULL,'Languedoc-Roussillon',NULL),(974,'FR','B1',NULL,'Limousin',NULL),(975,'FR','B2',NULL,'Lorraine',NULL),(976,'FR','B3',NULL,'Midi-Pyrenees',NULL),(977,'FR','B4',NULL,'Nord-Pas-de-Calais',NULL),(978,'FR','B5',NULL,'Pays de la Loire',NULL),(979,'FR','B6',NULL,'Picardie',NULL),(980,'FR','B7',NULL,'Poitou-Charentes',NULL),(981,'FR','B8',NULL,'Provence-Alpes-Cote d\'Azur',NULL),(982,'FR','B9',NULL,'Rhone-Alpes',NULL),(983,'FR','C1',NULL,'Alsace',NULL),(984,'GA','01','1','Estuaire',NULL),(985,'GA','02','2','Haut-Ogooué',NULL),(986,'GA','03','3','Moyen-Ogooué',NULL),(987,'GA','04','4','Ngounié',NULL),(988,'GA','05','5','Nyanga',NULL),(989,'GA','06','6','Ogooué-Ivindo',NULL),(990,'GA','07','7','Ogooué-Lolo',NULL),(991,'GA','08','8','Ogooué-Maritime',NULL),(992,'GA','09','9','Woleu-Ntem',NULL),(993,'GB','A1','BDG','Barking and Dagenham',NULL),(994,'GB','A2','BNE','Barnet',NULL),(995,'GB','A3','BNS','Barnsley',NULL),(996,'GB','A4','BAS','Bath and North East Somerset',NULL),(997,'GB','A5','BDF','Bedfordshire',NULL),(998,'GB','A6','BEX','Bexley',NULL),(999,'GB','A7','BIR','Birmingham',NULL),(1000,'GB','A8','BBD','Blackburn with Darwen',NULL),(1001,'GB','A9','BPL','Blackpool',NULL),(1002,'GB','B1','BOL','Bolton',NULL),(1003,'GB','B2','BMH','Bournemouth',NULL),(1004,'GB','B3','BRC','Bracknell Forest',NULL),(1005,'GB','B4','BRD','Bradford',NULL),(1006,'GB','B5','BEN','Brent',NULL),(1007,'GB','B6','BNH','Brighton and Hove',NULL),(1008,'GB','B7','BST','Bristol, City of',NULL),(1009,'GB','B8','BRY','Bromley',NULL),(1010,'GB','B9','BKM','Buckinghamshire',NULL),(1011,'GB','C1','BUR','Bury',NULL),(1012,'GB','C2','CLD','Calderdale',NULL),(1013,'GB','C3','CAM','Cambridgeshire',NULL),(1014,'GB','C4','CMD','Camden',NULL),(1015,'GB','C5','CHS','Cheshire',NULL),(1016,'GB','C6','CON','Cornwall',NULL),(1017,'GB','C7','COV','Coventry',NULL),(1018,'GB','C8','CRY','Croydon',NULL),(1019,'GB','C9','CMA','Cumbria',NULL),(1020,'GB','D1','DAL','Darlington',NULL),(1021,'GB','D2','DER','Derby',NULL),(1022,'GB','D3','DBY','Derbyshire',NULL),(1023,'GB','D4','DEV','Devon',NULL),(1024,'GB','D5','DNC','Doncaster',NULL),(1025,'GB','D6','DOR','Dorset',NULL),(1026,'GB','D7','DUD','Dudley',NULL),(1027,'GB','D8','DUR','Durham',NULL),(1028,'GB','D9','EAL','Ealing',NULL),(1029,'GB','E1','ERY','East Riding of Yorkshire',NULL),(1030,'GB','E2','ESX','East Sussex',NULL),(1031,'GB','E3','ENF','Enfield',NULL),(1032,'GB','E4','ESS','Essex',NULL),(1033,'GB','E5','GAT','Gateshead',NULL),(1034,'GB','E6','GLS','Gloucestershire',NULL),(1035,'GB','E7','GRE','Greenwich',NULL),(1036,'GB','E8','HCK','Hackney',NULL),(1037,'GB','E9','HAL','Halton',NULL),(1038,'GB','F1','HMF','Hammersmith and Fulham',NULL),(1039,'GB','F2','HAM','Hampshire',NULL),(1040,'GB','F3','HRY','Haringey',NULL),(1041,'GB','F4','HRW','Harrow',NULL),(1042,'GB','F5','HPL','Hartlepool',NULL),(1043,'GB','F6','HAV','Havering',NULL),(1044,'GB','F7','HEF','Herefordshire, County of',NULL),(1045,'GB','F8','HRT','Hertfordshire',NULL),(1046,'GB','F9','HIL','Hillingdon',NULL),(1047,'GB','G1','HNS','Hounslow',NULL),(1048,'GB','G2','IOW','Isle of Wight',NULL),(1049,'GB','G3','ISL','Islington',NULL),(1050,'GB','G4','KEC','Kensington and Chelsea',NULL),(1051,'GB','G5','KEN','Kent',NULL),(1052,'GB','G6','KHL','Kingston upon Hull, City of',NULL),(1053,'GB','G7','KTT','Kingston upon Thames',NULL),(1054,'GB','G8','KIR','Kirklees',NULL),(1055,'GB','G9','KWL','Knowsley',NULL),(1056,'GB','H1','LBH','Lambeth',NULL),(1057,'GB','H2','LAN','Lancashire',NULL),(1058,'GB','H3','LDS','Leeds',NULL),(1059,'GB','H4','LCE','Leicester',NULL),(1060,'GB','H5','LEC','Leicestershire',NULL),(1061,'GB','H6','LEW','Lewisham',NULL),(1062,'GB','H7','LIN','Lincolnshire',NULL),(1063,'GB','H8','LIV','Liverpool',NULL),(1064,'GB','H9','LND','London, City of',NULL),(1065,'GB','I1','LUT','Luton',NULL),(1066,'GB','I2','MAN','Manchester',NULL),(1067,'GB','I3','MDW','Medway',NULL),(1068,'GB','I4','MRT','Merton',NULL),(1069,'GB','I5','MDB','Middlesbrough',NULL),(1070,'GB','I6','MIK','Milton Keynes',NULL),(1071,'GB','I7','NET','Newcastle upon Tyne',NULL),(1072,'GB','I8','NWM','Newham',NULL),(1073,'GB','I9','NFK','Norfolk',NULL),(1074,'GB','J1','NTH','Northamptonshire',NULL),(1075,'GB','J2','NEL','North East Lincolnshire',NULL),(1076,'GB','J3','NLN','North Lincolnshire',NULL),(1077,'GB','J4','NSM','North Somerset',NULL),(1078,'GB','J5','NTY','North Tyneside',NULL),(1079,'GB','J6','NBL','Northumberland',NULL),(1080,'GB','J7','NYK','North Yorkshire',NULL),(1081,'GB','J8','NGM','Nottingham',NULL),(1082,'GB','J9','NTT','Nottinghamshire',NULL),(1083,'GB','K1','OLD','Oldham',NULL),(1084,'GB','K2','OXF','Oxfordshire',NULL),(1085,'GB','K3','PTE','Peterborough',NULL),(1086,'GB','K4','PLY','Plymouth',NULL),(1087,'GB','K5','POL','Poole',NULL),(1088,'GB','K6','POR','Portsmouth',NULL),(1089,'GB','K7','RDG','Reading',NULL),(1090,'GB','K8','RDB','Redbridge',NULL),(1091,'GB','K9','RCC','Redcar and Cleveland',NULL),(1092,'GB','L1','RIC','Richmond upon Thames',NULL),(1093,'GB','L2','RCH','Rochdale',NULL),(1094,'GB','L3',NULL,'Rotherham',NULL),(1095,'GB','L4','RUT','Rutland',NULL),(1096,'GB','L5','SLF','Salford',NULL),(1097,'GB','L6',NULL,'Shropshire',NULL),(1098,'GB','L7','SAW','Sandwell',NULL),(1099,'GB','L8','SFT','Sefton',NULL),(1100,'GB','L9','SHF','Sheffield',NULL),(1101,'GB','M1','SLG','Slough',NULL),(1102,'GB','M2','SOL','Solihull',NULL),(1103,'GB','M3','SOM','Somerset',NULL),(1104,'GB','M4','STH','Southampton',NULL),(1105,'GB','M5','SOS','Southend-on-Sea',NULL),(1106,'GB','M6','SGC','South Gloucestershire',NULL),(1107,'GB','M7','STY','South Tyneside',NULL),(1108,'GB','M8','SWK','Southwark',NULL),(1109,'GB','M9','STS','Staffordshire',NULL),(1110,'GB','N1','SHN','St. Helens',NULL),(1111,'GB','N2','SKP','Stockport',NULL),(1112,'GB','N3','STT','Stockton-on-Tees',NULL),(1113,'GB','N4','STE','Stoke-on-Trent',NULL),(1114,'GB','N5','SFK','Suffolk',NULL),(1115,'GB','N6','SND','Sunderland',NULL),(1116,'GB','N7','SRY','Surrey',NULL),(1117,'GB','N8','STN','Sutton',NULL),(1118,'GB','N9','SWD','Swindon',NULL),(1119,'GB','O1','TAM','Tameside',NULL),(1120,'GB','O2','TFW','Telford and Wrekin',NULL),(1121,'GB','O3','THR','Thurrock',NULL),(1122,'GB','O4','TOB','Torbay',NULL),(1123,'GB','O5','TWH','Tower Hamlets',NULL),(1124,'GB','O6','TRF','Trafford',NULL),(1125,'GB','O7','WKF','Wakefield',NULL),(1126,'GB','O8','WLL','Walsall',NULL),(1127,'GB','O9','WFT','Waltham Forest',NULL),(1128,'GB','P1','WND','Wandsworth',NULL),(1129,'GB','P2','WRT','Warrington',NULL),(1130,'GB','P3','WAR','Warwickshire',NULL),(1131,'GB','P4','WBK','West Berkshire',NULL),(1132,'GB','P5','WSM','Westminster',NULL),(1133,'GB','P6','WSX','West Sussex',NULL),(1134,'GB','P7','WGN','Wigan',NULL),(1135,'GB','P8','WIL','Wiltshire',NULL),(1136,'GB','P9','WNM','Windsor and Maidenhead',NULL),(1137,'GB','Q1','WRL','Wirral',NULL),(1138,'GB','Q2','WOK','Wokingham',NULL),(1139,'GB','Q3','WLV','Wolverhampton',NULL),(1140,'GB','Q4','WOR','Worcestershire',NULL),(1141,'GB','Q5','YOR','York',NULL),(1142,'GB','Q6','ANT','Antrim',NULL),(1143,'GB','Q7','ARD','Ards',NULL),(1144,'GB','Q8','ARM','Armagh',NULL),(1145,'GB','Q9','BLA','Ballymena',NULL),(1146,'GB','R1','BLY','Ballymoney',NULL),(1147,'GB','R2','BNB','Banbridge',NULL),(1148,'GB','R3','BFS','Belfast',NULL),(1149,'GB','R4','CKF','Carrickfergus',NULL),(1150,'GB','R5','CSR','Castlereagh',NULL),(1151,'GB','R6','CLR','Coleraine',NULL),(1152,'GB','R7','CKT','Cookstown',NULL),(1153,'GB','R8','CGV','Craigavon',NULL),(1154,'GB','R9','DOW','Down',NULL),(1155,'GB','S1','DGN','Dungannon',NULL),(1156,'GB','S2','FER','Fermanagh',NULL),(1157,'GB','S3','LRN','Larne',NULL),(1158,'GB','S4','LMV','Limavady',NULL),(1159,'GB','S5','LSB','Lisburn',NULL),(1160,'GB','S6','DRY','Derry',NULL),(1161,'GB','S7','MFT','Magherafelt',NULL),(1162,'GB','S8','MYL','Moyle',NULL),(1163,'GB','S9','NYM','Newry and Mourne',NULL),(1164,'GB','T1','NTA','Newtownabbey',NULL),(1165,'GB','T2','NDN','North Down',NULL),(1166,'GB','T3','OMH','Omagh',NULL),(1167,'GB','T4','STB','Strabane',NULL),(1168,'GB','T5','ABE','Aberdeen City',NULL),(1169,'GB','T6','ABD','Aberdeenshire',NULL),(1170,'GB','T7','ANS','Angus',NULL),(1171,'GB','T8','AGB','Argyll and Bute',NULL),(1172,'GB','T9','SCB','Scottish Borders, The',NULL),(1173,'GB','U1','CLK','Clackmannanshire',NULL),(1174,'GB','U2','DGY','Dumfries and Galloway',NULL),(1175,'GB','U3','DND','Dundee City',NULL),(1176,'GB','U4','EAY','East Ayrshire',NULL),(1177,'GB','U5','EDU','East Dunbartonshire',NULL),(1178,'GB','U6','ELN','East Lothian',NULL),(1179,'GB','U7','ERW','East Renfrewshire',NULL),(1180,'GB','U8','EDH','Edinburgh, City of',NULL),(1181,'GB','U9','FAL','Falkirk',NULL),(1182,'GB','V1','FIF','Fife',NULL),(1183,'GB','V2','GLG','Glasgow City',NULL),(1184,'GB','V3','ROT','Rotherham',NULL),(1185,'GB','V4','IVC','Inverclyde',NULL),(1186,'GB','V5','MLN','Midlothian',NULL),(1187,'GB','V6','MRY','Moray',NULL),(1188,'GB','V7','NAY','North Ayrshire',NULL),(1189,'GB','V8','NLK','North Lanarkshire',NULL),(1190,'GB','V9','ORK','Orkney Islands',NULL),(1191,'GB','W1','PKN','Perth and Kinross',NULL),(1192,'GB','W2','RFW','Renfrewshire',NULL),(1193,'GB','W3','ZET','Shetland Islands',NULL),(1194,'GB','W4','SAY','South Ayrshire',NULL),(1195,'GB','W5','SLK','South Lanarkshire',NULL),(1196,'GB','W6','STG','Stirling',NULL),(1197,'GB','W7','WDU','West Dunbartonshire',NULL),(1198,'GB','W8','ELS','Eilean Siar',NULL),(1199,'GB','W9','WLN','West Lothian',NULL),(1200,'GB','X1','AGY','Isle of Anglesey',NULL),(1201,'GB','X2','BGW','Blaenau Gwent',NULL),(1202,'GB','X3','BGE','Bridgend',NULL),(1203,'GB','X4','CAY','Caerphilly',NULL),(1204,'GB','X5','CRF','Cardiff',NULL),(1205,'GB','X6','CGN','Ceredigion',NULL),(1206,'GB','X7','CMN','Carmarthenshire',NULL),(1207,'GB','X8','CWY','Conwy',NULL),(1208,'GB','X9','DEN','Denbighshire',NULL),(1209,'GB','Y1','FLN','Flintshire',NULL),(1210,'GB','Y2','GWN','Gwynedd',NULL),(1211,'GB','Y3','MTY','Merthyr Tydfil',NULL),(1212,'GB','Y4','MON','Monmouthshire',NULL),(1213,'GB','Y5','NTL','Neath Port Talbot',NULL),(1214,'GB','Y6','NWP','Newport',NULL),(1215,'GB','Y7','PEM','Pembrokeshire',NULL),(1216,'GB','Y8','POW','Powys',NULL),(1217,'GB','Y9','RCT','Rhondda, Cynon, Taff',NULL),(1218,'GB','Z1','SWA','Swansea',NULL),(1219,'GB','Z2','TOF','Torfaen',NULL),(1220,'GB','Z3','VGL','Vale of Glamorgan, The',NULL),(1221,'GB','Z4','WRX','Wrexham',NULL),(1222,'GD','01','01','Saint Andrew',NULL),(1223,'GD','02','02','Saint David',NULL),(1224,'GD','03','03','Saint George',NULL),(1225,'GD','04','04','Saint John',NULL),(1226,'GD','05','05','Saint Mark',NULL),(1227,'GD','06','06','Saint Patrick',NULL),(1228,'GE','01',NULL,'Abashis Raioni',NULL),(1229,'GE','02','AB','Abkhazia',NULL),(1230,'GE','03',NULL,'Adigenis Raioni',NULL),(1231,'GE','04','AJ','Ajaria',NULL),(1232,'GE','05',NULL,'Akhalgoris Raioni',NULL),(1233,'GE','06',NULL,'Akhalk\'alak\'is Raioni',NULL),(1234,'GE','07',NULL,'Akhalts\'ikhis Raioni',NULL),(1235,'GE','08',NULL,'Akhmetis Raioni',NULL),(1236,'GE','09',NULL,'Ambrolauris Raioni',NULL),(1237,'GE','10',NULL,'Aspindzis Raioni',NULL),(1238,'GE','11',NULL,'Baghdat\'is Raioni',NULL),(1239,'GE','12',NULL,'Bolnisis Raioni',NULL),(1240,'GE','13',NULL,'Borjomis Raioni',NULL),(1241,'GE','14',NULL,'Chiat\'ura',NULL),(1242,'GE','15',NULL,'Ch\'khorotsqus Raioni',NULL),(1243,'GE','16',NULL,'Ch\'okhatauris Raioni',NULL),(1244,'GE','17',NULL,'Dedop\'listsqaros Raioni',NULL),(1245,'GE','18',NULL,'Dmanisis Raioni',NULL),(1246,'GE','19',NULL,'Dushet\'is Raioni',NULL),(1247,'GE','20',NULL,'Gardabanis Raioni',NULL),(1248,'GE','21',NULL,'Gori',NULL),(1249,'GE','22',NULL,'Goris Raioni',NULL),(1250,'GE','23',NULL,'Gurjaanis Raioni',NULL),(1251,'GE','24',NULL,'Javis Raioni',NULL),(1252,'GE','25',NULL,'K\'arelis Raioni',NULL),(1253,'GE','26',NULL,'Kaspis Raioni',NULL),(1254,'GE','27',NULL,'Kharagaulis Raioni',NULL),(1255,'GE','28',NULL,'Khashuris Raioni',NULL),(1256,'GE','29',NULL,'Khobis Raioni',NULL),(1257,'GE','30',NULL,'Khonis Raioni',NULL),(1258,'GE','31',NULL,'K\'ut\'aisi',NULL),(1259,'GE','32',NULL,'Lagodekhis Raioni',NULL),(1260,'GE','33',NULL,'Lanch\'khut\'is Raioni',NULL),(1261,'GE','34',NULL,'Lentekhis Raioni',NULL),(1262,'GE','35',NULL,'Marneulis Raioni',NULL),(1263,'GE','36',NULL,'Martvilis Raioni',NULL),(1264,'GE','37',NULL,'Mestiis Raioni',NULL),(1265,'GE','38',NULL,'Mts\'khet\'is Raioni',NULL),(1266,'GE','39',NULL,'Ninotsmindis Raioni',NULL),(1267,'GE','40',NULL,'Onis Raioni',NULL),(1268,'GE','41',NULL,'Ozurget\'is Raioni',NULL),(1269,'GE','42',NULL,'P\'ot\'i',NULL),(1270,'GE','43',NULL,'Qazbegis Raioni',NULL),(1271,'GE','44',NULL,'Qvarlis Raioni',NULL),(1272,'GE','45',NULL,'Rust\'avi',NULL),(1273,'GE','46',NULL,'Sach\'kheris Raioni',NULL),(1274,'GE','47',NULL,'Sagarejos Raioni',NULL),(1275,'GE','48',NULL,'Samtrediis Raioni',NULL),(1276,'GE','49',NULL,'Senakis Raioni',NULL),(1277,'GE','50',NULL,'Sighnaghis Raioni',NULL),(1278,'GE','51',NULL,'T\'bilisi',NULL),(1279,'GE','52',NULL,'T\'elavis Raioni',NULL),(1280,'GE','53',NULL,'T\'erjolis Raioni',NULL),(1281,'GE','54',NULL,'T\'et\'ritsqaros Raioni',NULL),(1282,'GE','55',NULL,'T\'ianet\'is Raioni',NULL),(1283,'GE','56',NULL,'Tqibuli',NULL),(1284,'GE','57',NULL,'Ts\'ageris Raioni',NULL),(1285,'GE','58',NULL,'Tsalenjikhis Raioni',NULL),(1286,'GE','59',NULL,'Tsalkis Raioni',NULL),(1287,'GE','60',NULL,'Tsqaltubo',NULL),(1288,'GE','61',NULL,'Vanis Raioni',NULL),(1289,'GE','62',NULL,'Zestap\'onis Raioni',NULL),(1290,'GE','63',NULL,'Zugdidi',NULL),(1291,'GE','64',NULL,'Zugdidis Raioni',NULL),(1292,'GH','01','AA','Greater Accra',NULL),(1293,'GH','02','AH','Ashanti',NULL),(1294,'GH','03','BA','Brong-Ahafo',NULL),(1295,'GH','04','CP','Central',NULL),(1296,'GH','05','EP','Eastern',NULL),(1297,'GH','06','NP','Northern',NULL),(1298,'GH','08','TV','Volta',NULL),(1299,'GH','09','WP','Western',NULL),(1300,'GH','10','UE','Upper East',NULL),(1301,'GH','11','UW','Upper West',NULL),(1302,'GL','01',NULL,'Nordgronland',264),(1303,'GL','02',NULL,'Ostgronland',265),(1304,'GL','03',NULL,'Vestgronland',265),(1305,'GM','01','B','Banjul',NULL),(1306,'GM','02','L','Lower River',NULL),(1307,'GM','03','M','MacCarthy Island',NULL),(1308,'GM','04','U','Upper River',NULL),(1309,'GM','05','W','Western',NULL),(1310,'GM','07','N','North Bank',NULL),(1311,'GN','01','BE','Beyla',NULL),(1312,'GN','02','BF','Boffa',NULL),(1313,'GN','03','BK','Boké',NULL),(1314,'GN','04','C','Conakry',NULL),(1315,'GN','05','DB','Dabola',NULL),(1316,'GN','06','DL','Dalaba',NULL),(1317,'GN','07','DI','Dinguiraye',NULL),(1318,'GN','09','FA','Faranah',NULL),(1319,'GN','10','FO','Forécariah',NULL),(1320,'GN','11','FR','Fria',NULL),(1321,'GN','12','GA','Gaoual',NULL),(1322,'GN','13',NULL,'Gueckedou',NULL),(1323,'GN','15','KE','Kérouané',NULL),(1324,'GN','16','KD','Kindia',NULL),(1325,'GN','17','KS','Kissidougou',NULL),(1326,'GN','18','KN','Koundara',NULL),(1327,'GN','19','KO','Kouroussa',NULL),(1328,'GN','21','MC','Macenta',NULL),(1329,'GN','22','ML','Mali',NULL),(1330,'GN','23','MM','Mamou',NULL),(1331,'GN','25','PI','Pita',NULL),(1332,'GN','27','TE','Télimélé',NULL),(1333,'GN','28','TO','Tougué',NULL),(1334,'GN','29','YO','Yomou',NULL),(1335,'GN','30','CO','Coyah',NULL),(1336,'GN','31','DU','Dubréka',NULL),(1337,'GN','32','KA','Kankan',NULL),(1338,'GN','33','KB','Koubia',NULL),(1339,'GN','34','LA','Labé',NULL),(1340,'GN','35','LE','Lélouma',NULL),(1341,'GN','36','LO','Lola',NULL),(1342,'GN','37','MD','Mandiana',NULL),(1343,'GN','38','NZ','Nzérékoré',NULL),(1344,'GN','39','SI','Siguiri',NULL),(1345,'GQ','03','AN','Annobón',NULL),(1346,'GQ','04','BN','Bioko Norte',NULL),(1347,'GQ','05','BS','Bioko Sur',NULL),(1348,'GQ','06','CS','Centro Sur',NULL),(1349,'GQ','07','KN','Kie-Ntem',NULL),(1350,'GQ','08','LI','Litoral',NULL),(1351,'GQ','09','WN','Wele-Nzás',NULL),(1352,'GR','01','71','Evros',NULL),(1353,'GR','02','73','Rodopi',NULL),(1354,'GR','03','72','Xanthi',NULL),(1355,'GR','04','52','Drama',NULL),(1356,'GR','05','62','Serres',NULL),(1357,'GR','06','57','Kilkis',NULL),(1358,'GR','07','59','Pella',NULL),(1359,'GR','08','63','Florina',NULL),(1360,'GR','09','56','Kastoria',NULL),(1361,'GR','10','51','Grevena',NULL),(1362,'GR','11','58','Kozani',NULL),(1363,'GR','12','53','Imathia',NULL),(1364,'GR','13','54','Thessaloniki',NULL),(1365,'GR','14','55','Kavala',NULL),(1366,'GR','15','64','Chalkidiki',NULL),(1367,'GR','16','61','Pieria',NULL),(1368,'GR','17','33','Ioannina',NULL),(1369,'GR','18','32','Thesprotia',NULL),(1370,'GR','19','34','Preveza',NULL),(1371,'GR','20','31','Arta',NULL),(1372,'GR','21','42','Larisa',NULL),(1373,'GR','22','44','Trikala',NULL),(1374,'GR','23','41','Karditsa',NULL),(1375,'GR','24','43','Magnisia',NULL),(1376,'GR','25','22','Kerkyra',NULL),(1377,'GR','26','24','Lefkada',NULL),(1378,'GR','27','23','Kefallonia',NULL),(1379,'GR','28','21','Zakynthos',NULL),(1380,'GR','29','06','Fthiotida',NULL),(1381,'GR','30','05','Evrytania',NULL),(1382,'GR','31','01','Aitolia kai Akarnania',NULL),(1383,'GR','32','07','Fokida',NULL),(1384,'GR','33','03','Voiotia',NULL),(1385,'GR','34','04','Evvoia',NULL),(1386,'GR','35','A1','Attiki',NULL),(1387,'GR','36','11','Argolida',NULL),(1388,'GR','37','15','Korinthia',NULL),(1389,'GR','38','13','Achaïa',NULL),(1390,'GR','39','14','Ileia',NULL),(1391,'GR','40','17','Messinia',NULL),(1392,'GR','41','12','Arkadia',NULL),(1393,'GR','42','16','Lakonia',NULL),(1394,'GR','43','94','Chania',NULL),(1395,'GR','44','93','Rethymno',NULL),(1396,'GR','45','91','Irakleio',NULL),(1397,'GR','46','92','Lasithi',NULL),(1398,'GR','47','81','Dodekanisos',NULL),(1399,'GR','48','84','Samos',NULL),(1400,'GR','49','82','Kyklades',NULL),(1401,'GR','50','85','Chios',NULL),(1402,'GR','51','83','Lesvos',NULL),(1403,'GT','01','AV','Alta Verapaz',NULL),(1404,'GT','02','BV','Baja Verapaz',NULL),(1405,'GT','03','CM','Chimaltenango',NULL),(1406,'GT','04','CQ','Chiquimula',NULL),(1407,'GT','05','PR','El Progreso',NULL),(1408,'GT','06','ES','Escuintla',NULL),(1409,'GT','07','GU','Guatemala',NULL),(1410,'GT','08','HU','Huehuetenango',NULL),(1411,'GT','09','IZ','Izabal',NULL),(1412,'GT','10','JA','Jalapa',NULL),(1413,'GT','11','JU','Jutiapa',NULL),(1414,'GT','12','PE','Petén',NULL),(1415,'GT','13','QZ','Quetzaltenango',NULL),(1416,'GT','14','QC','Quiché',NULL),(1417,'GT','15','RE','Retalhuleu',NULL),(1418,'GT','16','SA','Sacatepéquez',NULL),(1419,'GT','17','SM','San Marcos',NULL),(1420,'GT','18','SR','Santa Rosa',NULL),(1421,'GT','19','SO','Sololá',NULL),(1422,'GT','20','SU','Suchitepéquez',NULL),(1423,'GT','21','TO','Totonicapán',NULL),(1424,'GT','22','ZA','Zacapa',NULL),(1425,'GW','01','BA','Bafatá',NULL),(1426,'GW','02','QU','Quinara',NULL),(1427,'GW','04','OI','Oio',NULL),(1428,'GW','05','BL','Bolama',NULL),(1429,'GW','06','CA','Cacheu',NULL),(1430,'GW','07','TO','Tombali',NULL),(1431,'GW','10','GA','Gabú',NULL),(1432,'GW','11','BS','Bissau',NULL),(1433,'GW','12','BM','Biombo',NULL),(1434,'GY','10','BA','Barima-Waini',NULL),(1435,'GY','11','CU','Cuyuni-Mazaruni',NULL),(1436,'GY','12','DE','Demerara-Mahaica',NULL),(1437,'GY','13','EB','East Berbice-Corentyne',NULL),(1438,'GY','14','ES','Essequibo Islands-West Demerara',NULL),(1439,'GY','15','MA','Mahaica-Berbice',NULL),(1440,'GY','16','PM','Pomeroon-Supenaam',NULL),(1441,'GY','17','PT','Potaro-Siparuni',NULL),(1442,'GY','18','UD','Upper Demerara-Berbice',NULL),(1443,'GY','19','UT','Upper Takutu-Upper Essequibo',NULL),(1444,'HN','01','AT','Atlántida',NULL),(1445,'HN','02','CH','Choluteca',NULL),(1446,'HN','03','CL','Colón',NULL),(1447,'HN','04','CM','Comayagua',NULL),(1448,'HN','05','CP','Copán',NULL),(1449,'HN','06','CR','Cortés',NULL),(1450,'HN','07','EP','El Paraíso',NULL),(1451,'HN','08','FM','Francisco Morazán',NULL),(1452,'HN','09','GD','Gracias a Dios',NULL),(1453,'HN','10','IN','Intibucá',NULL),(1454,'HN','11','IB','Islas de la Bahía',NULL),(1455,'HN','12','LP','La Paz',NULL),(1456,'HN','13','LE','Lempira',NULL),(1457,'HN','14','OC','Ocotepeque',NULL),(1458,'HN','15','OL','Olancho',NULL),(1459,'HN','16','SB','Santa Bárbara',NULL),(1460,'HN','17','VA','Valle',NULL),(1461,'HN','18','YO','Yoro',NULL),(1462,'HR','01','07','Bjelovarsko-bilogorska županija',NULL),(1463,'HR','02','12','Brodsko-posavska županija',NULL),(1464,'HR','03','19','Dubrovacko-neretvanska županija',NULL),(1465,'HR','04','18','Istarska županija',NULL),(1466,'HR','05','04','Karlovacka županija',NULL),(1467,'HR','06','06','Koprivnicko-križevacka županija',NULL),(1468,'HR','07','02','Krapinsko-zagorska županija',NULL),(1469,'HR','08','09','Licko-senjska županija',NULL),(1470,'HR','09','20','Medimurska županija',NULL),(1471,'HR','10','14','Osjecko-baranjska županija',NULL),(1472,'HR','11','11','Požeško-slavonska županija',NULL),(1473,'HR','12','08','Primorsko-goranska županija',NULL),(1474,'HR','13','15','Šibensko-kninska županija',NULL),(1475,'HR','14','03','Sisacko-moslavacka županija',NULL),(1476,'HR','15','17','Splitsko-dalmatinska županija',NULL),(1477,'HR','16','05','Varaždinska županija',NULL),(1478,'HR','17','10','Viroviticko-podravska županija',NULL),(1479,'HR','18','16','Vukovarsko-srijemska županija',NULL),(1480,'HR','19','13','Zadarska županija',NULL),(1481,'HR','20','01','Zagrebacka županija',NULL),(1482,'HR','21','21','Grad Zagreb',NULL),(1483,'HT','03','NO','Nord-Ouest',NULL),(1484,'HT','06','AR','Artibonite',NULL),(1485,'HT','07','CE','Centre',NULL),(1486,'HT','09','ND','Nord',NULL),(1487,'HT','10','NE','Nord-Est',NULL),(1488,'HT','11','OU','Ouest',NULL),(1489,'HT','12','SD','Sud',NULL),(1490,'HT','13','SE','Sud-Est',NULL),(1491,'HT','14',NULL,'Grand\' Anse',NULL),(1492,'HT','15',NULL,'Nippes',NULL),(1493,'HU','01','BK','Bács-Kiskun',NULL),(1494,'HU','02','BA','Baranya',NULL),(1495,'HU','03','BE','Békés',NULL),(1496,'HU','04','BZ','Borsod-Abaúj-Zemplén',NULL),(1497,'HU','05','BU','Budapest',NULL),(1498,'HU','06','CS','Csongrád',NULL),(1499,'HU','07','DE','Debrecen',NULL),(1500,'HU','08','FE','Fejér',NULL),(1501,'HU','09','GS','Gyor-Moson-Sopron',NULL),(1502,'HU','10','HB','Hajdú-Bihar',NULL),(1503,'HU','11','HE','Heves',NULL),(1504,'HU','12','KE','Komárom-Esztergom',NULL),(1505,'HU','13','MI','Miskolc',NULL),(1506,'HU','14','NO','Nógrád',NULL),(1507,'HU','15','PS','Pécs',NULL),(1508,'HU','16','PE','Pest',NULL),(1509,'HU','17','SO','Somogy',NULL),(1510,'HU','18','SZ','Szabolcs-Szatmár-Bereg',NULL),(1511,'HU','19','SD','Szeged',NULL),(1512,'HU','20','JN','Jász-Nagykun-Szolnok',NULL),(1513,'HU','21','TO','Tolna',NULL),(1514,'HU','22','VA','Vas',NULL),(1515,'HU','23','VE','Veszprém',NULL),(1516,'HU','24','ZA','Zala',NULL),(1517,'HU','25','GY','Gyor',NULL),(1518,'HU','26','BC','Békéscsaba',NULL),(1519,'HU','27','DU','Dunaújváros',NULL),(1520,'HU','28','EG','Eger',NULL),(1521,'HU','29','HV','Hódmezovásárhely',NULL),(1522,'HU','30','KV','Kaposvár',NULL),(1523,'HU','31','KM','Kecskemét',NULL),(1524,'HU','32','NK','Nagykanizsa',NULL),(1525,'HU','33','NY','Nyíregyháza',NULL),(1526,'HU','34','SN','Sopron',NULL),(1527,'HU','35','SF','Székesfehérvár',NULL),(1528,'HU','36','SK','Szolnok',NULL),(1529,'HU','37','SH','Szombathely',NULL),(1530,'HU','38','TB','Tatabánya',NULL),(1531,'HU','39','VM','Veszprém City',NULL),(1532,'HU','40','ZE','Zalaegerszeg',NULL),(1533,'HU','41','ST','Salgótarján',NULL),(1534,'HU','42','SS','Szekszárd',NULL),(1535,'HU','43','ER','Erd',NULL),(1536,'ID','01','AC','Aceh',266),(1537,'ID','02','BA','Bali',267),(1538,'ID','03','BE','Bengkulu',268),(1539,'ID','04','JK','Jakarta Raya',268),(1540,'ID','05','JA','Jambi',268),(1541,'ID','07','JT','Jawa Tengah',268),(1542,'ID','08','JI','Jawa Timur',268),(1543,'ID','10','YO','Yogyakarta',268),(1544,'ID','11','KB','Kalimantan Barat',266),(1545,'ID','12','KS','Kalimantan Selatan',267),(1546,'ID','13','KT','Kalimantan Tengah',267),(1547,'ID','14','KI','Kalimantan Timur',267),(1548,'ID','15','LA','Lampung',268),(1549,'ID','17','NB','Nusa Tenggara Barat',267),(1550,'ID','18','NT','Nusa Tenggara Timur',267),(1551,'ID','21','ST','Sulawesi Tengah',267),(1552,'ID','22','SG','Sulawesi Tenggara',267),(1553,'ID','24','SB','Sumatera Barat',268),(1554,'ID','26','SU','Sumatera Utara',266),(1555,'ID','28',NULL,'Maluku',NULL),(1556,'ID','29','MU','Maluku Utara',NULL),(1557,'ID','30','JB','Jawa Barat',268),(1558,'ID','31','SA','Sulawesi Utara',267),(1559,'ID','32','SS','Sumatera Selatan',NULL),(1560,'ID','33','BT','Banten',268),(1561,'ID','34','GO','Gorontalo',NULL),(1562,'ID','35',NULL,'Kepulauan Bangka Belitung',NULL),(1563,'ID','36','PA','Papua',NULL),(1564,'ID','37','RI','Riau',NULL),(1565,'ID','38','SN','Sulawesi Selatan',NULL),(1566,'ID','39','PB','Papua Barat',NULL),(1567,'ID','40','KR','Kepulauan Riau',NULL),(1568,'ID','41','SR','Sulawesi Barat',NULL),(1569,'IE','01','CW','Carlow',NULL),(1570,'IE','02','CN','Cavan',NULL),(1571,'IE','03','CE','Clare',NULL),(1572,'IE','04','C','Cork',NULL),(1573,'IE','06','DL','Donegal',NULL),(1574,'IE','07','D','Dublin',NULL),(1575,'IE','10','G','Galway',NULL),(1576,'IE','11','KY','Kerry',NULL),(1577,'IE','12','KE','Kildare',NULL),(1578,'IE','13','KK','Kilkenny',NULL),(1579,'IE','14','LM','Leitrim',NULL),(1580,'IE','15','LS','Laois',NULL),(1581,'IE','16','LK','Limerick',NULL),(1582,'IE','18','LD','Longford',NULL),(1583,'IE','19','LH','Louth',NULL),(1584,'IE','20','MO','Mayo',NULL),(1585,'IE','21','MH','Meath',NULL),(1586,'IE','22','MN','Monaghan',NULL),(1587,'IE','23','OY','Offaly',NULL),(1588,'IE','24','RN','Roscommon',NULL),(1589,'IE','25','SO','Sligo',NULL),(1590,'IE','26','TA','Tipperary',NULL),(1591,'IE','27','WD','Waterford',NULL),(1592,'IE','29','WH','Westmeath',NULL),(1593,'IE','30','WX','Wexford',NULL),(1594,'IE','31','WW','Wicklow',NULL),(1595,'IL','01','D','HaDarom',NULL),(1596,'IL','02','M','HaMerkaz',NULL),(1597,'IL','03','Z','HaZafon',NULL),(1598,'IL','04',NULL,'Hefa',NULL),(1599,'IL','05',NULL,'Tel Aviv',NULL),(1600,'IL','06','JM','Yerushalayim',NULL),(1601,'IN','01','AN','Andaman and Nicobar Islands',NULL),(1602,'IN','02','AP','Andhra Pradesh',NULL),(1603,'IN','03','AS','Assam',NULL),(1604,'IN','05','CH','Chandigarh',NULL),(1605,'IN','06','DN','Dadra and Nagar Haveli',NULL),(1606,'IN','07','DL','Delhi',NULL),(1607,'IN','09','GJ','Gujarat',NULL),(1608,'IN','10','HR','Haryana',NULL),(1609,'IN','11','HP','Himachal Pradesh',NULL),(1610,'IN','12','JK','Jammu and Kashmir',NULL),(1611,'IN','13','KL','Kerala',NULL),(1612,'IN','14','LD','Lakshadweep',NULL),(1613,'IN','16','MH','Maharashtra',NULL),(1614,'IN','17','MN','Manipur',NULL),(1615,'IN','18','ML','Meghalaya',NULL),(1616,'IN','19','KA','Karnataka',NULL),(1617,'IN','20','NL','Nagaland',NULL),(1618,'IN','21','OR','Orissa',NULL),(1619,'IN','22','PY','Pondicherry',NULL),(1620,'IN','23','PB','Punjab',NULL),(1621,'IN','24','RJ','Rajasthan',NULL),(1622,'IN','25','TN','Tamil Nadu',NULL),(1623,'IN','26','TR','Tripura',NULL),(1624,'IN','28','WB','West Bengal',NULL),(1625,'IN','29','SK','Sikkim',NULL),(1626,'IN','30','AR','Arunachal Pradesh',NULL),(1627,'IN','31','MZ','Mizoram',NULL),(1628,'IN','32','DD','Daman and Diu',NULL),(1629,'IN','33','GA','Goa',NULL),(1630,'IN','34','BR','Bihar',NULL),(1631,'IN','35','MP','Madhya Pradesh',NULL),(1632,'IN','36','UP','Uttar Pradesh',NULL),(1633,'IN','37','CT','Chhattisgarh',NULL),(1634,'IN','38','JH','Jharkhand',NULL),(1635,'IN','39','UL','Uttaranchal',NULL),(1636,'IQ','01','AN','Al Anbar',NULL),(1637,'IQ','02','BA','Al Basrah',NULL),(1638,'IQ','03','MU','Al Muthanná',NULL),(1639,'IQ','04','QA','Al Qadisiyah',NULL),(1640,'IQ','05','SU','As Sulaymaniyah',NULL),(1641,'IQ','06','BB','Babil',NULL),(1642,'IQ','07','BG','Baghdad',NULL),(1643,'IQ','08','DA','Dahuk',NULL),(1644,'IQ','09','DQ','Dhi Qar',NULL),(1645,'IQ','10','DI','Diyalá',NULL),(1646,'IQ','11','AR','Arbil',NULL),(1647,'IQ','12','KA','Karbala\'',NULL),(1648,'IQ','13','TS','At Ta\'mim',NULL),(1649,'IQ','14','MA','Maysan',NULL),(1650,'IQ','15','NI','Ninawá',NULL),(1651,'IQ','16','WA','Wasit',NULL),(1652,'IQ','17','NA','An Najaf',NULL),(1653,'IQ','18','SD','Salah ad Din',NULL),(1654,'IR','01','02','Az¯arbayjan-e Gharbi',NULL),(1655,'IR','03','08','Chahar Mah¸all va Bakhtiari',NULL),(1656,'IR','04','13','Sistan va Baluchestan',NULL),(1657,'IR','05','18','Kohkiluyeh va Buyer Ahmad',NULL),(1658,'IR','07','14','Fars',NULL),(1659,'IR','08','19','Gilan',NULL),(1660,'IR','09','24','Hamadan',NULL),(1661,'IR','10','05','Ilam',NULL),(1662,'IR','11','23','Hormozgan',NULL),(1663,'IR','12',NULL,'Kerman',NULL),(1664,'IR','13','17','Kermanshah',NULL),(1665,'IR','15','10','Khuzestan',NULL),(1666,'IR','16','16','Kordestan',NULL),(1667,'IR','17',NULL,'Mazandaran',NULL),(1668,'IR','18','12','Semnan',NULL),(1669,'IR','19',NULL,'Markazi',NULL),(1670,'IR','21',NULL,'Zanjan',NULL),(1671,'IR','22','06','Bushehr',NULL),(1672,'IR','23','20','Lorestan',NULL),(1673,'IR','24',NULL,'Markazi',NULL),(1674,'IR','25',NULL,'Semnan',NULL),(1675,'IR','26','07','Tehran',NULL),(1676,'IR','27',NULL,'Zanjan',NULL),(1677,'IR','28','04','Esfahan',NULL),(1678,'IR','29','15','Kerman',NULL),(1679,'IR','30','09','Khorasan',NULL),(1680,'IR','31',NULL,'Yazd',NULL),(1681,'IR','32','03','Ardabil',NULL),(1682,'IR','33',NULL,'East Azarbaijan',NULL),(1683,'IR','34','22','Markazi',NULL),(1684,'IR','35','21','Mazandaran',NULL),(1685,'IR','36','11','Zanjan',NULL),(1686,'IR','37','27','Golestan',NULL),(1687,'IR','38','28','Qazvin',NULL),(1688,'IR','39','26','Qom',NULL),(1689,'IR','40','25','Yazd',NULL),(1690,'IR','41','29','Khorasan-e Janubi',NULL),(1691,'IR','42','30','Khorasan-e Razavi',NULL),(1692,'IR','43','31','Khorasan-e Shemali',NULL),(1693,'IS','03',NULL,'Arnessysla',NULL),(1694,'IS','05',NULL,'Austur-Hunavatnssysla',NULL),(1695,'IS','06',NULL,'Austur-Skaftafellssysla',NULL),(1696,'IS','07',NULL,'Borgarfjardarsysla',NULL),(1697,'IS','09',NULL,'Eyjafjardarsysla',NULL),(1698,'IS','10',NULL,'Gullbringusysla',NULL),(1699,'IS','15',NULL,'Kjosarsysla',NULL),(1700,'IS','17',NULL,'Myrasysla',NULL),(1701,'IS','20',NULL,'Nordur-Mulasysla',NULL),(1702,'IS','21',NULL,'Nordur-Tingeyjarsysla',NULL),(1703,'IS','23',NULL,'Rangarvallasysla',NULL),(1704,'IS','28',NULL,'Skagafjardarsysla',NULL),(1705,'IS','29',NULL,'Snafellsnes- og Hnappadalssysla',NULL),(1706,'IS','30',NULL,'Strandasysla',NULL),(1707,'IS','31',NULL,'Sudur-Mulasysla',NULL),(1708,'IS','32',NULL,'Sudur-Tingeyjarsysla',NULL),(1709,'IS','34',NULL,'Vestur-Bardastrandarsysla',NULL),(1710,'IS','35',NULL,'Vestur-Hunavatnssysla',NULL),(1711,'IS','36',NULL,'Vestur-Isafjardarsysla',NULL),(1712,'IS','37',NULL,'Vestur-Skaftafellssysla',NULL),(1713,'IS','40',NULL,'Norourland Eystra',NULL),(1714,'IS','41',NULL,'Norourland Vestra',NULL),(1715,'IS','42',NULL,'Suourland',NULL),(1716,'IS','43',NULL,'Suournes',NULL),(1717,'IS','44',NULL,'Vestfiroir',NULL),(1718,'IS','45','3','Vesturland',NULL),(1719,'IT','01','65','Abruzzo',NULL),(1720,'IT','02','77','Basilicata',NULL),(1721,'IT','03','78','Calabria',NULL),(1722,'IT','04','72','Campania',NULL),(1723,'IT','05','45','Emilia-Romagna',NULL),(1724,'IT','06','36','Friuli-Venezia Giulia',NULL),(1725,'IT','07','62','Lazio',NULL),(1726,'IT','08','42','Liguria',NULL),(1727,'IT','09','25','Lombardia',NULL),(1728,'IT','10','57','Marche',NULL),(1729,'IT','11','67','Molise',NULL),(1730,'IT','12','21','Piemonte',NULL),(1731,'IT','13','75','Puglia',NULL),(1732,'IT','14','88','Sardegna',NULL),(1733,'IT','15','82','Sicilia',NULL),(1734,'IT','16','52','Toscana',NULL),(1735,'IT','17','32','Trentino-Alto Adige',NULL),(1736,'IT','18','55','Umbria',NULL),(1737,'IT','19','23','Valle d\'Aosta',NULL),(1738,'IT','20','34','Veneto',NULL),(1739,'JM','01','13','Clarendon',NULL),(1740,'JM','02','09','Hanover',NULL),(1741,'JM','04','12','Manchester',NULL),(1742,'JM','07','04','Portland',NULL),(1743,'JM','08','02','Saint Andrew',NULL),(1744,'JM','09','06','Saint Ann',NULL),(1745,'JM','10','14','Saint Catherine',NULL),(1746,'JM','11','11','Saint Elizabeth',NULL),(1747,'JM','12','08','Saint James',NULL),(1748,'JM','13','05','Saint Mary',NULL),(1749,'JM','14','03','Saint Thomas',NULL),(1750,'JM','15','07','Trelawny',NULL),(1751,'JM','16','10','Westmoreland',NULL),(1752,'JM','17','01','Kingston',NULL),(1753,'JO','02','BA','Al Balqa\'',NULL),(1754,'JO','09','KA','Al Karak',NULL),(1755,'JO','12','AT','At Tafilah',NULL),(1756,'JO','15',NULL,'Al Mafraq',NULL),(1757,'JO','16','AM','?Amman',NULL),(1758,'JO','17',NULL,'Az Zaraqa',NULL),(1759,'JO','18',NULL,'Irbid',NULL),(1760,'JO','19',NULL,'Ma\'an',NULL),(1761,'JO','20',NULL,'Ajlun',NULL),(1762,'JO','21','AQ','Aqaba',NULL),(1763,'JO','22','JA','Jarash',NULL),(1764,'JO','23','MD','Madaba',NULL),(1765,'JP','01',NULL,'Aichi',NULL),(1766,'JP','02','05','Akita',NULL),(1767,'JP','03','02','Aomori',NULL),(1768,'JP','04',NULL,'Chiba',NULL),(1769,'JP','05','38','Ehime',NULL),(1770,'JP','06',NULL,'Fukui',NULL),(1771,'JP','07',NULL,'Fukuoka',NULL),(1772,'JP','08',NULL,'Fukushima',NULL),(1773,'JP','09',NULL,'Gifu',NULL),(1774,'JP','10',NULL,'Gumma',NULL),(1775,'JP','11',NULL,'Hiroshima',NULL),(1776,'JP','12','01','Hokkaidô',NULL),(1777,'JP','13','28','Hyôgo',NULL),(1778,'JP','14','08','Ibaraki',NULL),(1779,'JP','15',NULL,'Ishikawa',NULL),(1780,'JP','16','03','Iwate',NULL),(1781,'JP','17','37','Kagawa',NULL),(1782,'JP','18',NULL,'Kagoshima',NULL),(1783,'JP','19','14','Kanagawa',NULL),(1784,'JP','20',NULL,'Kochi',NULL),(1785,'JP','21','43','Kumamoto',NULL),(1786,'JP','22','26','Kyôto',NULL),(1787,'JP','23','24','Mie',NULL),(1788,'JP','24','04','Miyagi',NULL),(1789,'JP','25','45','Miyazaki',NULL),(1790,'JP','26','20','Nagano',NULL),(1791,'JP','27','42','Nagasaki',NULL),(1792,'JP','28','29','Nara',NULL),(1793,'JP','29','15','Niigata',NULL),(1794,'JP','30','44','Ôita',NULL),(1795,'JP','31','33','Okayama',NULL),(1796,'JP','32','27','Ôsaka',NULL),(1797,'JP','33','41','Saga',NULL),(1798,'JP','34','11','Saitama',NULL),(1799,'JP','35',NULL,'Shiga',NULL),(1800,'JP','36',NULL,'Shimane',NULL),(1801,'JP','37',NULL,'Shizuoka',NULL),(1802,'JP','38',NULL,'Tochigi',NULL),(1803,'JP','39',NULL,'Tokushima',NULL),(1804,'JP','40','13','Tôkyô',NULL),(1805,'JP','41','31','Tottori',NULL),(1806,'JP','42','16','Toyama',NULL),(1807,'JP','43','30','Wakayama',NULL),(1808,'JP','44','06','Yamagata',NULL),(1809,'JP','45',NULL,'Yamaguchi',NULL),(1810,'JP','46',NULL,'Yamanashi',NULL),(1811,'JP','47','47','Okinawa',NULL),(1812,'KE','01','200','Central',NULL),(1813,'KE','02','300','Coast',NULL),(1814,'KE','03','400','Eastern',NULL),(1815,'KE','05','110','Nairobi',NULL),(1816,'KE','06','500','North-Eastern',NULL),(1817,'KE','07','600','Nyanza',NULL),(1818,'KE','08','700','Rift Valley',NULL),(1819,'KE','09','900','Western',NULL),(1820,'KG','01','GB','Bishkek',NULL),(1821,'KG','02',NULL,'Chuy',NULL),(1822,'KG','03','J','Jalal-Abad',NULL),(1823,'KG','04','N','Naryn',NULL),(1824,'KG','05',NULL,'Osh',NULL),(1825,'KG','06','T','Talas',NULL),(1826,'KG','07','Y','Ysyk-Köl',NULL),(1827,'KG','08','O','Osh',NULL),(1828,'KG','09','B','Batken',NULL),(1829,'KH','01',NULL,'Batdambang',NULL),(1830,'KH','02',NULL,'Kampong Cham',NULL),(1831,'KH','03','4','Kampong Chhnang',NULL),(1832,'KH','04',NULL,'Kampong Speu',NULL),(1833,'KH','05','6','Kampong Thum',NULL),(1834,'KH','06','7','Kampot',NULL),(1835,'KH','07',NULL,'Kandal',NULL),(1836,'KH','08',NULL,'Koh Kong',NULL),(1837,'KH','09','10','Kracheh',NULL),(1838,'KH','10',NULL,'Mondulkiri',NULL),(1839,'KH','11',NULL,'Phnum Penh',NULL),(1840,'KH','12',NULL,'Pursat',NULL),(1841,'KH','13','13','Preah Vihear',NULL),(1842,'KH','14',NULL,'Prey Veng',NULL),(1843,'KH','15',NULL,'Ratanakiri Kiri',NULL),(1844,'KH','16',NULL,'Siem Reap',NULL),(1845,'KH','17',NULL,'Stung Treng',NULL),(1846,'KH','18',NULL,'Svay Rieng',NULL),(1847,'KH','19',NULL,'Takeo',NULL),(1848,'KH','25',NULL,'Banteay Meanchey',NULL),(1849,'KH','29',NULL,'Batdambang',NULL),(1850,'KH','30',NULL,'Pailin',NULL),(1851,'KI','01',NULL,'Gilbert Islands',NULL),(1852,'KI','02','L','Line Islands',NULL),(1853,'KI','03','P','Phoenix Islands',NULL),(1854,'KM','01',NULL,'Anjouan',NULL),(1855,'KM','02',NULL,'Grande Comore',NULL),(1856,'KM','03',NULL,'Moheli',NULL),(1857,'KN','01','01','Christ Church Nichola Town',NULL),(1858,'KN','02','02','Saint Anne Sandy Point',NULL),(1859,'KN','03','03','Saint George Basseterre',NULL),(1860,'KN','04','04','Saint George Gingerland',NULL),(1861,'KN','05','05','Saint James Windward',NULL),(1862,'KN','06','06','Saint John Capisterre',NULL),(1863,'KN','07','07','Saint John Figtree',NULL),(1864,'KN','08','08','Saint Mary Cayon',NULL),(1865,'KN','09','09','Saint Paul Capisterre',NULL),(1866,'KN','10','10','Saint Paul Charlestown',NULL),(1867,'KN','11','11','Saint Peter Basseterre',NULL),(1868,'KN','12','12','Saint Thomas Lowland',NULL),(1869,'KN','13','13','Saint Thomas Middle Island',NULL),(1870,'KN','15','15','Trinity Palmetto Point',NULL),(1871,'KP','01','04','Chagang-do',NULL),(1872,'KP','03','08','Hamgyong-namdo',NULL),(1873,'KP','06','05','Hwanghae-namdo',NULL),(1874,'KP','07','06','Hwanghae-bukto',NULL),(1875,'KP','08',NULL,'Kaesong-si',NULL),(1876,'KP','09','07','Kangwon-do',NULL),(1877,'KP','11',NULL,'P\'yongan-bukto',NULL),(1878,'KP','12',NULL,'P\'yongyang-si',NULL),(1879,'KP','13','10','Yanggang-do',NULL),(1880,'KP','14',NULL,'Namp\'o-si',NULL),(1881,'KP','15',NULL,'P\'yongan-namdo',NULL),(1882,'KP','17',NULL,'Hamgyong-bukto',NULL),(1883,'KP','18',NULL,'Najin Sonbong-si',NULL),(1884,'KR','01',NULL,'Cheju-do',NULL),(1885,'KR','03',NULL,'Cholla-bukto',NULL),(1886,'KR','05',NULL,'Ch\'ungch\'ong-bukto',NULL),(1887,'KR','06',NULL,'Kangwon-do',NULL),(1888,'KR','10',NULL,'Pusan-jikhalsi',NULL),(1889,'KR','11',NULL,'Seoul-t\'ukpyolsi',NULL),(1890,'KR','12',NULL,'Inch\'on-jikhalsi',NULL),(1891,'KR','13',NULL,'Kyonggi-do',NULL),(1892,'KR','14',NULL,'Kyongsang-bukto',NULL),(1893,'KR','15',NULL,'Taegu-jikhalsi',NULL),(1894,'KR','16',NULL,'Cholla-namdo',NULL),(1895,'KR','17',NULL,'Ch\'ungch\'ong-namdo',NULL),(1896,'KR','18',NULL,'Kwangju-jikhalsi',NULL),(1897,'KR','19',NULL,'Taejon-jikhalsi',NULL),(1898,'KR','20',NULL,'Kyongsang-namdo',NULL),(1899,'KR','21','31','Ulsan Gwang\'yeogsi',NULL),(1900,'KW','01','AH','Al Ahmadi',NULL),(1901,'KW','02','KU','Al Kuwayt',NULL),(1902,'KW','05',NULL,'Al Jahra',NULL),(1903,'KW','07','FA','Al Farwaniyah',NULL),(1904,'KW','08',NULL,'Hawalli',NULL),(1905,'KW','09',NULL,'Mubarak al Kabir',NULL),(1906,'KY','01',NULL,'Creek',NULL),(1907,'KY','02',NULL,'Eastern',NULL),(1908,'KY','03',NULL,'Midland',NULL),(1909,'KY','04',NULL,'South Town',NULL),(1910,'KY','05',NULL,'Spot Bay',NULL),(1911,'KY','06',NULL,'Stake Bay',NULL),(1912,'KY','07',NULL,'West End',NULL),(1913,'KY','08',NULL,'Western',NULL),(1914,'KZ','01','ALA','Almaty',271),(1915,'KZ','02',NULL,'Almaty City',271),(1916,'KZ','03',NULL,'Aqmola',272),(1917,'KZ','04',NULL,'Aqtobe',273),(1918,'KZ','05','AST','Astana',272),(1919,'KZ','06',NULL,'Atyrau',274),(1920,'KZ','07',NULL,'West Kazakhstan',275),(1921,'KZ','08',NULL,'Bayqonyr',272),(1922,'KZ','09',NULL,'Mangghystau',274),(1923,'KZ','10',NULL,'South Kazakhstan',272),(1924,'KZ','11',NULL,'Pavlodar',271),(1925,'KZ','12',NULL,'Qaraghandy',272),(1926,'KZ','13',NULL,'Qostanay',273),(1927,'KZ','14','KZY','Qyzylorda oblysy',272),(1928,'KZ','15',NULL,'East Kazakhstan',271),(1929,'KZ','16',NULL,'North Kazakhstan',273),(1930,'KZ','17','ZHA','Zhambyl oblysy',271),(1931,'LA','01','AT','Attapu',NULL),(1932,'LA','02','CH','Champasak',NULL),(1933,'LA','03','HO','Houaphan',NULL),(1934,'LA','04',NULL,'Khammouan',NULL),(1935,'LA','05',NULL,'Louang Namtha',NULL),(1936,'LA','07','OU','Oudômxai',NULL),(1937,'LA','08',NULL,'Phongsali',NULL),(1938,'LA','09',NULL,'Saravan',NULL),(1939,'LA','10',NULL,'Savannakhet',NULL),(1940,'LA','11',NULL,'Vientiane',NULL),(1941,'LA','13','XA','Xaignabouli',NULL),(1942,'LA','14','XI','Xiangkhoang',NULL),(1943,'LA','17','LP','Louangphabang',NULL),(1944,'LB','01',NULL,'Beqaa',NULL),(1945,'LB','02',NULL,'Al Janub',NULL),(1946,'LB','03',NULL,'Liban-Nord',NULL),(1947,'LB','04',NULL,'Beyrouth',NULL),(1948,'LB','05',NULL,'Mont-Liban',NULL),(1949,'LB','06',NULL,'Liban-Sud',NULL),(1950,'LB','07','NA','Nabatîyé',NULL),(1951,'LB','08',NULL,'Beqaa',NULL),(1952,'LB','09',NULL,'Liban-Nord',NULL),(1953,'LB','10',NULL,'Aakk,r',NULL),(1954,'LB','11',NULL,'Baalbek-Hermel',NULL),(1955,'LC','01',NULL,'Anse-la-Raye',NULL),(1956,'LC','02',NULL,'Dauphin',NULL),(1957,'LC','03',NULL,'Castries',NULL),(1958,'LC','04',NULL,'Choiseul',NULL),(1959,'LC','05',NULL,'Dennery',NULL),(1960,'LC','06',NULL,'Gros-Islet',NULL),(1961,'LC','07',NULL,'Laborie',NULL),(1962,'LC','08',NULL,'Micoud',NULL),(1963,'LC','09',NULL,'Soufriere',NULL),(1964,'LC','10',NULL,'Vieux-Fort',NULL),(1965,'LC','11',NULL,'Praslin',NULL),(1966,'LI','01','01','Balzers',NULL),(1967,'LI','02','02','Eschen',NULL),(1968,'LI','03','03','Gamprin',NULL),(1969,'LI','04','04','Mauren',NULL),(1970,'LI','05','05','Planken',NULL),(1971,'LI','06','06','Ruggell',NULL),(1972,'LI','07','07','Schaan',NULL),(1973,'LI','08','08','Schellenberg',NULL),(1974,'LI','09','09','Triesen',NULL),(1975,'LI','10','10','Triesenberg',NULL),(1976,'LI','11','11','Vaduz',NULL),(1977,'LI','21',NULL,'Gbarpolu',NULL),(1978,'LI','22',NULL,'River Gee',NULL),(1979,'LK','01','52','Amp?ra',NULL),(1980,'LK','02','71','Anur?dhapura',NULL),(1981,'LK','03','81','Badulla',NULL),(1982,'LK','04','51','Madakalapuva',NULL),(1983,'LK','06','31','G?lla',NULL),(1984,'LK','07','33','Hambant??a',NULL),(1985,'LK','09','13','Kalutara',NULL),(1986,'LK','10','21','Mahanuvara',NULL),(1987,'LK','11','92','Kegalla',NULL),(1988,'LK','12','61','Kuru?ægala',NULL),(1989,'LK','14','22','M?tale',NULL),(1990,'LK','15','32','M?tara',NULL),(1991,'LK','16',NULL,'Moneragala',NULL),(1992,'LK','17','23','Nuvara ?liya',NULL),(1993,'LK','18','72','P???nnaruva',NULL),(1994,'LK','19','62','Puttalama',NULL),(1995,'LK','20','91','Ratnapura',NULL),(1996,'LK','21','53','Triku??malaya',NULL),(1997,'LK','23','11','K??amba',NULL),(1998,'LK','24','12','Gampaha',NULL),(1999,'LK','25','41','Y?panaya',NULL),(2000,'LK','26','43','Mann?rama',NULL),(2001,'LK','27','45','Mulativ',NULL),(2002,'LK','28','44','Vavuniy?va',NULL),(2003,'LK','29',NULL,'Central',NULL),(2004,'LK','30',NULL,'North Central',NULL),(2005,'LK','31',NULL,'Northern',NULL),(2006,'LK','32',NULL,'North Western',NULL),(2007,'LK','33',NULL,'Sabaragamuwa',NULL),(2008,'LK','34',NULL,'Southern',NULL),(2009,'LK','35',NULL,'Uva',NULL),(2010,'LK','36',NULL,'Western',NULL),(2011,'LR','01','BG','Bong',NULL),(2012,'LR','04','CM','Grand Cape Mount',NULL),(2013,'LR','05','LO','Lofa',NULL),(2014,'LR','06','MY','Maryland',NULL),(2015,'LR','07',NULL,'Monrovia',NULL),(2016,'LR','09','NI','Nimba',NULL),(2017,'LR','10',NULL,'Sino',NULL),(2018,'LR','11','GB','Grand Bassa',NULL),(2019,'LR','12',NULL,'Grand Cape Mount',NULL),(2020,'LR','13',NULL,'Maryland',NULL),(2021,'LR','14','MO','Montserrado',NULL),(2022,'LR','17','MG','Margibi',NULL),(2023,'LR','18',NULL,'River Cess',NULL),(2024,'LR','19','GG','Grand Gedeh',NULL),(2025,'LR','20',NULL,'Lofa',NULL),(2026,'LR','21','X1','Gbarpolu',NULL),(2027,'LR','22','X2','River Gee',NULL),(2028,'LS','10','D','Berea',NULL),(2029,'LS','11','B','Butha-Buthe',NULL),(2030,'LS','12','C','Leribe',NULL),(2031,'LS','13','E','Mafeteng',NULL),(2032,'LS','14','A','Maseru',NULL),(2033,'LS','15',NULL,'Mohales Hoek',NULL),(2034,'LS','16','J','Mokhotlong',NULL),(2035,'LS','17',NULL,'Qachas Nek',NULL),(2036,'LS','18','G','Quthing',NULL),(2037,'LS','19','K','Thaba-Tseka',NULL),(2038,'LT','56','AL','Alytaus Apskritis',NULL),(2039,'LT','57','KU','Kauno Apskritis',NULL),(2040,'LT','58','KL','Klaipedos Apskritis',NULL),(2041,'LT','59','MR','Marijampoles Apskritis',NULL),(2042,'LT','60','PN','Panevežio Apskritis',NULL),(2043,'LT','61','SA','Šiauliu Apskritis',NULL),(2044,'LT','62','TA','Taurages Apskritis',NULL),(2045,'LT','63','TE','Telšiu Apskritis',NULL),(2046,'LT','64','UT','Utenos Apskritis',NULL),(2047,'LT','65','VL','Vilniaus Apskritis',NULL),(2048,'LU','01','D','Diekirch',NULL),(2049,'LU','02','G','Grevenmacher',NULL),(2050,'LU','03','L','Luxembourg',NULL),(2051,'LV','01',NULL,'Aizkraukles',NULL),(2052,'LV','02',NULL,'Aluksnes',NULL),(2053,'LV','03',NULL,'Balvu',NULL),(2054,'LV','04',NULL,'Bauskas',NULL),(2055,'LV','05',NULL,'Cesu',NULL),(2056,'LV','06','DGV','Daugavpils',NULL),(2057,'LV','07',NULL,'Daugavpils',NULL),(2058,'LV','08',NULL,'Dobeles',NULL),(2059,'LV','09',NULL,'Gulbenes',NULL),(2060,'LV','10',NULL,'Jekabpils',NULL),(2061,'LV','11','JEL','Jelgava',NULL),(2062,'LV','12','JL','Jelgavas Aprinkis',NULL),(2063,'LV','13','JUR','Jurmala',NULL),(2064,'LV','14',NULL,'Kraslavas',NULL),(2065,'LV','15',NULL,'Kuldigas',NULL),(2066,'LV','16','LPX','Liepaja',NULL),(2067,'LV','17',NULL,'Liepajas',NULL),(2068,'LV','18',NULL,'Limbazu',NULL),(2069,'LV','19',NULL,'Ludzas',NULL),(2070,'LV','20',NULL,'Madonas',NULL),(2071,'LV','21',NULL,'Ogres',NULL),(2072,'LV','22',NULL,'Preilu',NULL),(2073,'LV','23','REZ','Rezekne',NULL),(2074,'LV','24',NULL,'Rezeknes',NULL),(2075,'LV','25','RIX','Riga',NULL),(2076,'LV','26',NULL,'Rigas',NULL),(2077,'LV','27',NULL,'Saldus',NULL),(2078,'LV','28',NULL,'Talsu',NULL),(2079,'LV','29',NULL,'Tukuma',NULL),(2080,'LV','30',NULL,'Valkas',NULL),(2081,'LV','31',NULL,'Valmieras',NULL),(2082,'LV','32','VEN','Ventspils',NULL),(2083,'LV','33',NULL,'Ventspils',NULL),(2084,'LY','03',NULL,'Al Aziziyah',NULL),(2085,'LY','05','JU','Al Jufrah',NULL),(2086,'LY','08','KF','Al Kufrah',NULL),(2087,'LY','13',NULL,'Ash Shati\'',NULL),(2088,'LY','30','MQ','Murzuq',NULL),(2089,'LY','34','SB','Sabha',NULL),(2090,'LY','41',NULL,'Tarhunah',NULL),(2091,'LY','42',NULL,'Tubruq',NULL),(2092,'LY','45',NULL,'Zlitan',NULL),(2093,'LY','47',NULL,'Ajdabiya',NULL),(2094,'LY','48',NULL,'Al Fatih',NULL),(2095,'LY','49',NULL,'Al Jabal al Akhdar',NULL),(2096,'LY','50',NULL,'Al Khums',NULL),(2097,'LY','51','NQ','An Nuqat al Khams',NULL),(2098,'LY','52',NULL,'Awbari',NULL),(2099,'LY','53','ZA','Az Zawiyah',NULL),(2100,'LY','54','BA','Banghazi',NULL),(2101,'LY','55','DR','Darnah',NULL),(2102,'LY','56',NULL,'Ghadamis',NULL),(2103,'LY','57',NULL,'Gharyan',NULL),(2104,'LY','58','MI','Misratah',NULL),(2105,'LY','59',NULL,'Sawfajjin',NULL),(2106,'LY','60','SR','Surt',NULL),(2107,'LY','61','TB','Tarabulus',NULL),(2108,'LY','62',NULL,'Yafran',NULL),(2109,'MA','45',NULL,'Grand Casablanca',NULL),(2110,'MA','46',NULL,'Fes-Boulemane',NULL),(2111,'MA','47',NULL,'Marrakech-Tensift-Al Haouz',NULL),(2112,'MA','48',NULL,'Meknes-Tafilalet',NULL),(2113,'MA','49',NULL,'Rabat-Sale-Zemmour-Zaer',NULL),(2114,'MA','50',NULL,'Chaouia-Ouardigha',NULL),(2115,'MA','51',NULL,'Doukkala-Abda',NULL),(2116,'MA','52',NULL,'Gharb-Chrarda-Beni Hssen',NULL),(2117,'MA','53',NULL,'Guelmim-Es Smara',NULL),(2118,'MA','54',NULL,'Oriental',NULL),(2119,'MA','55',NULL,'Souss-Massa-Dr,a',NULL),(2120,'MA','56',NULL,'Tadla-Azilal',NULL),(2121,'MA','57',NULL,'Tanger-Tetouan',NULL),(2122,'MA','58',NULL,'Taza-Al Hoceima-Taounate',NULL),(2123,'MA','59',NULL,'La,youne-Boujdour-Sakia El Hamra',NULL),(2124,'MC','01',NULL,'La Condamine',NULL),(2125,'MC','02',NULL,'Monaco',NULL),(2126,'MC','03',NULL,'Monte-Carlo',NULL),(2127,'MD','51',NULL,'Gagauzia',NULL),(2128,'MD','57','CU','Chisinau',NULL),(2129,'MD','58',NULL,'Stinga Nistrului',NULL),(2130,'MD','59','AN','Anenii Noi',NULL),(2131,'MD','60','BA','B?l?i',NULL),(2132,'MD','61','BS','Basarabeasca',NULL),(2133,'MD','62',NULL,'Bender',NULL),(2134,'MD','63','BR','Briceni',NULL),(2135,'MD','64','CA','Cahul',NULL),(2136,'MD','65','CT','Cantemir',NULL),(2137,'MD','66',NULL,'Calarasi',NULL),(2138,'MD','67',NULL,'Causeni',NULL),(2139,'MD','68','CM','Cimi?lia',NULL),(2140,'MD','69','CR','Criuleni',NULL),(2141,'MD','70',NULL,'Donduseni',NULL),(2142,'MD','71','DR','Drochia',NULL),(2143,'MD','72',NULL,'Dubasari',NULL),(2144,'MD','73','ED','Edinet',NULL),(2145,'MD','74','FA','F?le?ti',NULL),(2146,'MD','75','FL','Flore?ti',NULL),(2147,'MD','76','GL','Glodeni',NULL),(2148,'MD','77','HI','Hînce?ti',NULL),(2149,'MD','78','IA','Ialoveni',NULL),(2150,'MD','79','LE','Leova',NULL),(2151,'MD','80','NI','Nisporeni',NULL),(2152,'MD','81','OC','Ocni?a',NULL),(2153,'MD','82','OR','Orhei',NULL),(2154,'MD','83','RE','Rezina',NULL),(2155,'MD','84',NULL,'Riscani',NULL),(2156,'MD','85','SI','Sîngerei',NULL),(2157,'MD','86',NULL,'Soldanesti',NULL),(2158,'MD','87','SO','Soroca',NULL),(2159,'MD','88',NULL,'Stefan-Voda',NULL),(2160,'MD','89',NULL,'Straseni',NULL),(2161,'MD','90','TA','Taraclia',NULL),(2162,'MD','91',NULL,'Telenesti',NULL),(2163,'MD','92','UN','Ungheni',NULL),(2164,'MG','01','D','Antsiranana',NULL),(2165,'MG','02','F','Fianarantsoa',NULL),(2166,'MG','03','M','Mahajanga',NULL),(2167,'MG','04','A','Toamasina',NULL),(2168,'MG','05','T','Antananarivo',NULL),(2169,'MG','06','U','Toliara',NULL),(2170,'MK','01','AR','Aracinovo',NULL),(2171,'MK','02',NULL,'Bac',NULL),(2172,'MK','03',NULL,'Belcista',NULL),(2173,'MK','04','BR','Berovo',NULL),(2174,'MK','05',NULL,'Bistrica',NULL),(2175,'MK','06','TL','Bitola',NULL),(2176,'MK','07',NULL,'Blatec',NULL),(2177,'MK','08','BG','Bogdanci',NULL),(2178,'MK','09',NULL,'Bogomila',NULL),(2179,'MK','10','VJ','Bogovinje',NULL),(2180,'MK','11','BS','Bosilovo',NULL),(2181,'MK','12','BN','Brvenica',NULL),(2182,'MK','13','CI','Cair',NULL),(2183,'MK','14',NULL,'Capari',NULL),(2184,'MK','15','CA','Caška',NULL),(2185,'MK','16',NULL,'Cegrane',NULL),(2186,'MK','17','CE','Centar',NULL),(2187,'MK','18','CZ','Centar Župa',NULL),(2188,'MK','19',NULL,'Cesinovo',NULL),(2189,'MK','20',NULL,'Cucer-Sandevo',NULL),(2190,'MK','21','DB','Debar',NULL),(2191,'MK','22','DL','Delcevo',NULL),(2192,'MK','23',NULL,'Delogozdi',NULL),(2193,'MK','24','DM','Demir Hisar',NULL),(2194,'MK','25','DK','Demir Kapija',NULL),(2195,'MK','26',NULL,'Dobrusevo',NULL),(2196,'MK','27',NULL,'Dolna Banjica',NULL),(2197,'MK','28','DE','Dolneni',NULL),(2198,'MK','29',NULL,'Dorce Petrov',NULL),(2199,'MK','30','DR','Drugovo',NULL),(2200,'MK','31',NULL,'Dzepciste',NULL),(2201,'MK','32','GB','Gazi Baba',NULL),(2202,'MK','33','GV','Gevgelija',NULL),(2203,'MK','34','GT','Gostivar',NULL),(2204,'MK','35','GR','Gradsko',NULL),(2205,'MK','36','IL','Ilinden',NULL),(2206,'MK','37',NULL,'Izvor',NULL),(2207,'MK','38','JG','Jegunovce',NULL),(2208,'MK','39',NULL,'Kamenjane',NULL),(2209,'MK','40','KB','Karbinci',NULL),(2210,'MK','41','KX','Karpoš',NULL),(2211,'MK','42','AV','Kavadarci',NULL),(2212,'MK','43','KH','Kicevo',NULL),(2213,'MK','44','VD','Kisela Voda',NULL),(2214,'MK','45',NULL,'Klecevce',NULL),(2215,'MK','46','OC','Kocani',NULL),(2216,'MK','47','KN','Konce',NULL),(2217,'MK','48',NULL,'Kondovo',NULL),(2218,'MK','49',NULL,'Konopiste',NULL),(2219,'MK','50',NULL,'Kosel',NULL),(2220,'MK','51','KY','Kratovo',NULL),(2221,'MK','52','KZ','Kriva Palanka',NULL),(2222,'MK','53','KG','Krivogaštani',NULL),(2223,'MK','54','KS','Kruševo',NULL),(2224,'MK','55',NULL,'Kuklis',NULL),(2225,'MK','56',NULL,'Kukurecani',NULL),(2226,'MK','57','UM','Kumanovo',NULL),(2227,'MK','58',NULL,'Labunista',NULL),(2228,'MK','59','LI','Lipkovo',NULL),(2229,'MK','60','LO','Lozovo',NULL),(2230,'MK','61',NULL,'Lukovo',NULL),(2231,'MK','62','MK','Makedonska Kamenica',NULL),(2232,'MK','63','MD','Makedonski Brod',NULL),(2233,'MK','64',NULL,'Mavrovi Anovi',NULL),(2234,'MK','65',NULL,'Meseista',NULL),(2235,'MK','66',NULL,'Miravci',NULL),(2236,'MK','67','MG','Mogila',NULL),(2237,'MK','68',NULL,'Murtino',NULL),(2238,'MK','69','NG','Negotino',NULL),(2239,'MK','70',NULL,'Negotino-Polosko',NULL),(2240,'MK','71','NV','Novaci',NULL),(2241,'MK','72','NS','Novo Selo',NULL),(2242,'MK','73',NULL,'Oblesevo',NULL),(2243,'MK','74','OD','Ohrid',NULL),(2244,'MK','75',NULL,'Orasac',NULL),(2245,'MK','76',NULL,'Orizari',NULL),(2246,'MK','77','OS','Oslomej',NULL),(2247,'MK','78','PH','Pehcevo',NULL),(2248,'MK','79','PE','Petrovec',NULL),(2249,'MK','80','PN','Plasnica',NULL),(2250,'MK','81',NULL,'Podares',NULL),(2251,'MK','82','PP','Prilep',NULL),(2252,'MK','83','PT','Probištip',NULL),(2253,'MK','84','RV','Radoviš',NULL),(2254,'MK','85','RN','Rankovce',NULL),(2255,'MK','86','RE','Resen',NULL),(2256,'MK','87','RM','Rosoman',NULL),(2257,'MK','88',NULL,'Rostusa',NULL),(2258,'MK','89',NULL,'Samokov',NULL),(2259,'MK','90','AJ','Saraj',NULL),(2260,'MK','91',NULL,'Sipkovica',NULL),(2261,'MK','92','SS','Sopište',NULL),(2262,'MK','93',NULL,'Sopotnica',NULL),(2263,'MK','94',NULL,'Srbinovo',NULL),(2264,'MK','95',NULL,'Staravina',NULL),(2265,'MK','96',NULL,'Star Dojran',NULL),(2266,'MK','97','NA','Staro Nagoricane',NULL),(2267,'MK','98','ST','Štip',NULL),(2268,'MK','99','UG','Struga',NULL),(2269,'MK','A1','RU','Strumica',NULL),(2270,'MK','A2','SU','Studenicani',NULL),(2271,'MK','A3','SO','Šuto Orizari',NULL),(2272,'MK','A4','SL','Sveti Nikole',NULL),(2273,'MK','A5','TR','Tearce',NULL),(2274,'MK','A6','ET','Tetovo',NULL),(2275,'MK','A7',NULL,'Topolcani',NULL),(2276,'MK','A8','VA','Valandovo',NULL),(2277,'MK','A9','VL','Vasilevo',NULL),(2278,'MK','B1','VE','Veles',NULL),(2279,'MK','B2',NULL,'Velesta',NULL),(2280,'MK','B3','VV','Vevcani',NULL),(2281,'MK','B4','NI','Vinica',NULL),(2282,'MK','B5',NULL,'Vitoliste',NULL),(2283,'MK','B6','VC','Vraneštica',NULL),(2284,'MK','B7','VH','Vrapcište',NULL),(2285,'MK','B8',NULL,'Vratnica',NULL),(2286,'MK','B9',NULL,'Vrutok',NULL),(2287,'MK','C1','ZA','Zajas',NULL),(2288,'MK','C2','ZK','Zelenikovo',NULL),(2289,'MK','C3','ZE','Želino',NULL),(2290,'MK','C4',NULL,'Zitose',NULL),(2291,'MK','C5',NULL,'Zletovo',NULL),(2292,'MK','C6','ZR','Zrnovci',NULL),(2293,'ML','01','BKO','Bamako',NULL),(2294,'ML','03','1','Kayes',NULL),(2295,'ML','04','5','Mopti',NULL),(2296,'ML','05','4','Ségou',NULL),(2297,'ML','06','3','Sikasso',NULL),(2298,'ML','07','2','Koulikoro',NULL),(2299,'ML','08','6','Tombouctou',NULL),(2300,'ML','09','7','Gao',NULL),(2301,'ML','10','8','Kidal',NULL),(2302,'MM','01',NULL,'Rakhine State',NULL),(2303,'MM','02',NULL,'Chin State',NULL),(2304,'MM','03',NULL,'Irrawaddy',NULL),(2305,'MM','04',NULL,'Kachin State',NULL),(2306,'MM','05',NULL,'Karan State',NULL),(2307,'MM','06',NULL,'Kayah State',NULL),(2308,'MM','07',NULL,'Magwe',NULL),(2309,'MM','08','04','Mandalay',NULL),(2310,'MM','09',NULL,'Pegu',NULL),(2311,'MM','10','01','Sagaing',NULL),(2312,'MM','11',NULL,'Shan State',NULL),(2313,'MM','12',NULL,'Tenasserim',NULL),(2314,'MM','13',NULL,'Mon State',NULL),(2315,'MM','14',NULL,'Rangoon',NULL),(2316,'MM','17','06','Yangon',NULL),(2317,'MN','01','073','Arhangay',NULL),(2318,'MN','02','069','Bayanhongor',NULL),(2319,'MN','03','071','Bayan-Ölgiy',NULL),(2320,'MN','05',NULL,'Darhan',NULL),(2321,'MN','06','061','Dornod',NULL),(2322,'MN','07','063','Dornogovi',NULL),(2323,'MN','08','059','Dundgovi',NULL),(2324,'MN','09','057','Dzavhan',NULL),(2325,'MN','10','065','Govi-Altay',NULL),(2326,'MN','11','039','Hentiy',NULL),(2327,'MN','12','043','Hovd',NULL),(2328,'MN','13','041','Hövsgöl',NULL),(2329,'MN','14','053','Ömnögovi',NULL),(2330,'MN','15','055','Övörhangay',NULL),(2331,'MN','16','049','Selenge',NULL),(2332,'MN','17','051','Sühbaatar',NULL),(2333,'MN','18','047','Töv',NULL),(2334,'MN','19','046','Uvs',NULL),(2335,'MN','20','1','Ulaanbaatar',NULL),(2336,'MN','21','067','Bulgan',NULL),(2337,'MN','22',NULL,'Erdenet',NULL),(2338,'MN','23',NULL,'Darhan-Uul',NULL),(2339,'MN','24',NULL,'Govisumber',NULL),(2340,'MN','25','035','Orhon',NULL),(2341,'MO','01',NULL,'Ilhas',NULL),(2342,'MO','02',NULL,'Macau',NULL),(2343,'MR','01','01','Hodh ech Chargui',NULL),(2344,'MR','02','02','Hodh el Gharbi',NULL),(2345,'MR','03','03','Assaba',NULL),(2346,'MR','04','04','Gorgol',NULL),(2347,'MR','05','05','Brakna',NULL),(2348,'MR','06','06','Trarza',NULL),(2349,'MR','07',NULL,'Adrar',NULL),(2350,'MR','08','08','Dakhlet Nouâdhibou',NULL),(2351,'MR','09','09','Tagant',NULL),(2352,'MR','10','10','Guidimaka',NULL),(2353,'MR','11','11','Tiris Zemmour',NULL),(2354,'MR','12','12','Inchiri',NULL),(2355,'MS','01',NULL,'Saint Anthony',NULL),(2356,'MS','02',NULL,'Saint Georges',NULL),(2357,'MS','03',NULL,'Saint Peter',NULL),(2358,'MU','12','BL','Black River',NULL),(2359,'MU','13','FL','Flacq',NULL),(2360,'MU','14','GP','Grand Port',NULL),(2361,'MU','15','MO','Moka',NULL),(2362,'MU','16','PA','Pamplemousses',NULL),(2363,'MU','17','PW','Plaines Wilhems',NULL),(2364,'MU','18',NULL,'Port Louis',NULL),(2365,'MU','19','RR','Rivière du Rempart',NULL),(2366,'MU','20','SA','Savanne',NULL),(2367,'MU','21','AG','Agalega Islands',NULL),(2368,'MU','22',NULL,'Cargados Carajos',NULL),(2369,'MU','23',NULL,'Rodrigues',NULL),(2370,'MV','01','01','Seenu',NULL),(2371,'MV','05','05','Laamu',NULL),(2372,'MV','30','02','Alif',NULL),(2373,'MV','31','20','Baa',NULL),(2374,'MV','32','17','Dhaalu',NULL),(2375,'MV','33','14','Faafu',NULL),(2376,'MV','34','27','Gaaf Alif',NULL),(2377,'MV','35','28','Gaafu Dhaalu',NULL),(2378,'MV','36','07','Haa Alif',NULL),(2379,'MV','37','23','Haa Dhaalu',NULL),(2380,'MV','38','26','Kaafu',NULL),(2381,'MV','39','03','Lhaviyani',NULL),(2382,'MV','40','MLE','Male',NULL),(2383,'MV','41','12','Meemu',NULL),(2384,'MV','42','29','Gnaviyani',NULL),(2385,'MV','43','25','Noonu',NULL),(2386,'MV','44','13','Raa',NULL),(2387,'MV','45','24','Shaviyani',NULL),(2388,'MV','46','08','Thaa',NULL),(2389,'MV','47','04','Vaavu',NULL),(2390,'MW','02','CK','Chikwawa',NULL),(2391,'MW','03','CR','Chiradzulu',NULL),(2392,'MW','04','CT','Chitipa',NULL),(2393,'MW','05','TH','Thyolo',NULL),(2394,'MW','06','DE','Dedza',NULL),(2395,'MW','07','DO','Dowa',NULL),(2396,'MW','08','KR','Karonga',NULL),(2397,'MW','09','KS','Kasungu',NULL),(2398,'MW','11','LI','Lilongwe',NULL),(2399,'MW','12','MG','Mangochi',NULL),(2400,'MW','13','MC','Mchinji',NULL),(2401,'MW','15','MZ','Mzimba',NULL),(2402,'MW','16','NU','Ntcheu',NULL),(2403,'MW','17','NB','Nkhata Bay',NULL),(2404,'MW','18','NK','Nkhotakota',NULL),(2405,'MW','19','NS','Nsanje',NULL),(2406,'MW','20','NI','Ntchisi',NULL),(2407,'MW','21','RU','Rumphi',NULL),(2408,'MW','22','SA','Salima',NULL),(2409,'MW','23','ZO','Zomba',NULL),(2410,'MW','24','BL','Blantyre',NULL),(2411,'MW','25','MW','Mwanza',NULL),(2412,'MW','26','BA','Balaka',NULL),(2413,'MW','27','LK','Likoma',NULL),(2414,'MW','28','MH','Machinga',NULL),(2415,'MW','29','MU','Mulanje',NULL),(2416,'MW','30','PH','Phalombe',NULL),(2417,'MX','01','AGU','Aguascalientes',278),(2418,'MX','02','BCN','Baja California',279),(2419,'MX','03','BCS','Baja California Sur',280),(2420,'MX','04','CAM','Campeche',282),(2421,'MX','05','CHP','Chiapas',278),(2422,'MX','06','CHH','Chihuahua',281),(2423,'MX','07','COA','Coahuila',283),(2424,'MX','08','COL','Colima',278),(2425,'MX','09','DIF','Distrito Federal',278),(2426,'MX','10','DUR','Durango',278),(2427,'MX','11','GUA','Guanajuato',278),(2428,'MX','12','GRO','Guerrero',278),(2429,'MX','13','HID','Hidalgo',278),(2430,'MX','14','JAL','Jalisco',278),(2431,'MX','15','MEX','México',278),(2432,'MX','16','MIC','Michoacán',278),(2433,'MX','17','MOR','Morelos',278),(2434,'MX','18','NAY','Nayarit',280),(2435,'MX','19','NLE','Nuevo León',283),(2436,'MX','20','OAX','Oaxaca',278),(2437,'MX','21','PUE','Puebla',278),(2438,'MX','22','QUE','Querétaro',278),(2439,'MX','23','ROO','Quintana Roo',284),(2440,'MX','24','SLP','San Luis Potosí',278),(2441,'MX','25','SIN','Sinaloa',280),(2442,'MX','26','SON','Sonora',285),(2443,'MX','27','TAB','Tabasco',282),(2444,'MX','28','TAM','Tamaulipas',286),(2445,'MX','29','TLA','Tlaxcala',278),(2446,'MX','30','VER','Veracruz',278),(2447,'MX','31','YUC','Yucatán',282),(2448,'MX','32','ZAC','Zacatecas',278),(2449,'MY','01','01','Johor',287),(2450,'MY','02','02','Kedah',287),(2451,'MY','03','03','Kelantan',287),(2452,'MY','04','04','Melaka',287),(2453,'MY','05','05','Negeri Sembilan',287),(2454,'MY','06','06','Pahang',287),(2455,'MY','07','08','Perak',287),(2456,'MY','08','09','Perlis',287),(2457,'MY','09','07','Pulau Pinang',287),(2458,'MY','11','13','Sarawak',288),(2459,'MY','12','10','Selangor',287),(2460,'MY','13','11','Terengganu',287),(2461,'MY','14','14','Wilayah Persekutuan Kuala Lumpur',287),(2462,'MY','15','15','Wilayah Persekutuan Labuan',288),(2463,'MY','16','12','Sabah',288),(2464,'MY','17','16','Wilayah Persekutuan Putrajaya',NULL),(2465,'MZ','01','P','Cabo Delgado',NULL),(2466,'MZ','02','G','Gaza',NULL),(2467,'MZ','03','I','Inhambane',NULL),(2468,'MZ','04','L','Maputo',NULL),(2469,'MZ','05','S','Sofala',NULL),(2470,'MZ','06','N','Nampula',NULL),(2471,'MZ','07','A','Niassa',NULL),(2472,'MZ','08','T','Tete',NULL),(2473,'MZ','09','Q','Zambézia',NULL),(2474,'MZ','10','B','Manica',NULL),(2475,'MZ','11','MPM','Maputo City',NULL),(2476,'NA','01',NULL,'Bethanien',NULL),(2477,'NA','02',NULL,'Caprivi Oos',NULL),(2478,'NA','03',NULL,'Boesmanland',NULL),(2479,'NA','04',NULL,'Gobabis',NULL),(2480,'NA','05',NULL,'Grootfontein',NULL),(2481,'NA','06',NULL,'Kaokoland',NULL),(2482,'NA','07',NULL,'Karibib',NULL),(2483,'NA','08',NULL,'Keetmanshoop',NULL),(2484,'NA','09',NULL,'Luderitz',NULL),(2485,'NA','10',NULL,'Maltahohe',NULL),(2486,'NA','11',NULL,'Okahandja',NULL),(2487,'NA','12',NULL,'Omaruru',NULL),(2488,'NA','13',NULL,'Otjiwarongo',NULL),(2489,'NA','14',NULL,'Outjo',NULL),(2490,'NA','15',NULL,'Owambo',NULL),(2491,'NA','16',NULL,'Rehoboth',NULL),(2492,'NA','17',NULL,'Swakopmund',NULL),(2493,'NA','18',NULL,'Tsumeb',NULL),(2494,'NA','20',NULL,'Karasburg',NULL),(2495,'NA','21',NULL,'Windhoek',NULL),(2496,'NA','22',NULL,'Damaraland',NULL),(2497,'NA','23',NULL,'Hereroland Oos',NULL),(2498,'NA','24',NULL,'Hereroland Wes',NULL),(2499,'NA','25',NULL,'Kavango',NULL),(2500,'NA','26',NULL,'Mariental',NULL),(2501,'NA','27',NULL,'Namaland',NULL),(2502,'NA','28','CA','Caprivi',NULL),(2503,'NA','29','ER','Erongo',NULL),(2504,'NA','30','HA','Hardap',NULL),(2505,'NA','31','KA','Karas',NULL),(2506,'NA','32','KU','Kunene',NULL),(2507,'NA','33','OW','Ohangwena',NULL),(2508,'NA','34','OK','Okavango',NULL),(2509,'NA','35','OH','Omaheke',NULL),(2510,'NA','36','OS','Omusati',NULL),(2511,'NA','37','ON','Oshana',NULL),(2512,'NA','38','OT','Oshikoto',NULL),(2513,'NA','39','OD','Otjozondjupa',NULL),(2514,'NE','01','1','Agadez',NULL),(2515,'NE','02','2','Diffa',NULL),(2516,'NE','03','3','Dosso',NULL),(2517,'NE','04','4','Maradi',NULL),(2518,'NE','05','8','Niamey',NULL),(2519,'NE','06','5','Tahoua',NULL),(2520,'NE','07','7','Zinder',NULL),(2521,'NE','08',NULL,'Niamey',NULL),(2522,'NG','05','LA','Lagos',NULL),(2523,'NG','11',NULL,'Federal Capital Territory',NULL),(2524,'NG','16','OG','Ogun',NULL),(2525,'NG','21','AK','Akwa Ibom',NULL),(2526,'NG','22','CR','Cross River',NULL),(2527,'NG','23','KD','Kaduna',NULL),(2528,'NG','24','KT','Katsina',NULL),(2529,'NG','25','AN','Anambra',NULL),(2530,'NG','26','BE','Benue',NULL),(2531,'NG','27','BO','Borno',NULL),(2532,'NG','28','IM','Imo',NULL),(2533,'NG','29','KN','Kano',NULL),(2534,'NG','30','KW','Kwara',NULL),(2535,'NG','31','NI','Niger',NULL),(2536,'NG','32','OY','Oyo',NULL),(2537,'NG','35','AD','Adamawa',NULL),(2538,'NG','36','DE','Delta',NULL),(2539,'NG','37','ED','Edo',NULL),(2540,'NG','39','JI','Jigawa',NULL),(2541,'NG','40','KE','Kebbi',NULL),(2542,'NG','41','KO','Kogi',NULL),(2543,'NG','42','OS','Osun',NULL),(2544,'NG','43','TA','Taraba',NULL),(2545,'NG','44','YO','Yobe',NULL),(2546,'NG','45','AB','Abia',NULL),(2547,'NG','46','BA','Bauchi',NULL),(2548,'NG','47','EN','Enugu',NULL),(2549,'NG','48','ON','Ondo',NULL),(2550,'NG','49','PL','Plateau',NULL),(2551,'NG','50','RI','Rivers',NULL),(2552,'NG','51','SO','Sokoto',NULL),(2553,'NG','52','BY','Bayelsa',NULL),(2554,'NG','53','EB','Ebonyi',NULL),(2555,'NG','54','EK','Ekiti',NULL),(2556,'NG','55','GO','Gombe',NULL),(2557,'NG','56','NA','Nassarawa',NULL),(2558,'NG','57','ZA','Zamfara',NULL),(2559,'NI','01','BO','Boaco',NULL),(2560,'NI','02','CA','Carazo',NULL),(2561,'NI','03','CI','Chinandega',NULL),(2562,'NI','04','CO','Chontales',NULL),(2563,'NI','05','ES','Estelí',NULL),(2564,'NI','06','GR','Granada',NULL),(2565,'NI','07','JI','Jinotega',NULL),(2566,'NI','08','LE','León',NULL),(2567,'NI','09','MD','Madriz',NULL),(2568,'NI','10','MN','Managua',NULL),(2569,'NI','11','MS','Masaya',NULL),(2570,'NI','12','MT','Matagalpa',NULL),(2571,'NI','13','NS','Nueva Segovia',NULL),(2572,'NI','14','SJ','Río San Juan',NULL),(2573,'NI','15','RI','Rivas',NULL),(2574,'NI','16',NULL,'Zelaya',NULL),(2575,'NI','17',NULL,'Autonoma Atlantico Norte',NULL),(2576,'NI','18',NULL,'Region Autonoma Atlantico Sur',NULL),(2577,'NL','01','DR','Drenthe',NULL),(2578,'NL','02','FR','Friesland',NULL),(2579,'NL','03','GE','Gelderland',NULL),(2580,'NL','04','GR','Groningen',NULL),(2581,'NL','05','LI','Limburg',NULL),(2582,'NL','06','NB','Noord-Brabant',NULL),(2583,'NL','07','NH','Noord-Holland',NULL),(2584,'NL','09','UT','Utrecht',NULL),(2585,'NL','10','ZE','Zeeland',NULL),(2586,'NL','11','ZH','Zuid-Holland',NULL),(2587,'NL','15','OV','Overijssel',NULL),(2588,'NL','16','FL','Flevoland',NULL),(2589,'NO','01','02','Akershus',NULL),(2590,'NO','02','09','Aust-Agder',NULL),(2591,'NO','04','06','Buskerud',NULL),(2592,'NO','05','20','Finnmark',NULL),(2593,'NO','06','04','Hedmark',NULL),(2594,'NO','07','12','Hordaland',NULL),(2595,'NO','08','15','Møre og Romsdal',NULL),(2596,'NO','09','18','Nordland',NULL),(2597,'NO','10','17','Nord-Trøndelag',NULL),(2598,'NO','11','05','Oppland',NULL),(2599,'NO','12','03','Oslo',NULL),(2600,'NO','13','01','Østfold',NULL),(2601,'NO','14','11','Rogaland',NULL),(2602,'NO','15','14','Sogn og Fjordane',NULL),(2603,'NO','16','16','Sør-Trøndelag',NULL),(2604,'NO','17','08','Telemark',NULL),(2605,'NO','18','19','Troms',NULL),(2606,'NO','19','10','Vest-Agder',NULL),(2607,'NO','20','07','Vestfold',NULL),(2608,'NP','01','BA','Bagmati',NULL),(2609,'NP','02','BH','Bheri',NULL),(2610,'NP','03','DH','Dhawalagiri',NULL),(2611,'NP','04','GA','Gandaki',NULL),(2612,'NP','05','JA','Janakpur',NULL),(2613,'NP','06','KA','Karnali',NULL),(2614,'NP','07','KO','Kosi',NULL),(2615,'NP','08','LU','Lumbini',NULL),(2616,'NP','09','MA','Mahakali',NULL),(2617,'NP','10','ME','Mechi',NULL),(2618,'NP','11','NA','Narayani',NULL),(2619,'NP','12','RA','Rapti',NULL),(2620,'NP','13','SA','Sagarmatha',NULL),(2621,'NP','14','SE','Seti',NULL),(2622,'NR','01','01','Aiwo',NULL),(2623,'NR','02','02','Anabar',NULL),(2624,'NR','03','03','Anetan',NULL),(2625,'NR','04','04','Anibare',NULL),(2626,'NR','05','05','Baiti',NULL),(2627,'NR','06','06','Boe',NULL),(2628,'NR','07','07','Buada',NULL),(2629,'NR','08','08','Denigomodu',NULL),(2630,'NR','09','09','Ewa',NULL),(2631,'NR','10','10','Ijuw',NULL),(2632,'NR','11','11','Meneng',NULL),(2633,'NR','12','12','Nibok',NULL),(2634,'NR','13','13','Uaboe',NULL),(2635,'NR','14','14','Yaren',NULL),(2636,'NZ','10','CIT','Chatham Islands Territory',326),(2637,'NZ','E7','AUK','Auckland',NULL),(2638,'NZ','E8','BOP','Bay of Plenty',NULL),(2639,'NZ','E9','CAN','Canterbury',NULL),(2640,'NZ','F1','GIS','Gisborne District',NULL),(2641,'NZ','F2','HKB','Hawkes\'s Bay',NULL),(2642,'NZ','F3','MWT','Manawatu-Wanganui',NULL),(2643,'NZ','F4','MBH','Marlborough District',NULL),(2644,'NZ','F5','NSN','Nelson City',NULL),(2645,'NZ','F6','NTL','Northland',NULL),(2646,'NZ','F7','OTA','Otago',NULL),(2647,'NZ','F8','STL','Southland',NULL),(2648,'NZ','F9','TKI','Taranaki',NULL),(2649,'NZ','G1','WKO','Waikato',NULL),(2650,'NZ','G2','WGN','Wellington',NULL),(2651,'NZ','G3','WTC','West Coast',NULL),(2652,'OM','01','DA','Ad Dakhiliyah',NULL),(2653,'OM','02','BA','Al Batinah',NULL),(2654,'OM','03','WU','Al Wustá',NULL),(2655,'OM','04','SH','Ash Sharqiyah',NULL),(2656,'OM','05',NULL,'Az Zahirah',NULL),(2657,'OM','06','MA','Masqat',NULL),(2658,'OM','07','MU','Musandam',NULL),(2659,'OM','08',NULL,'Zufar',NULL),(2660,'PA','01','1','Bocas del Toro',NULL),(2661,'PA','02','4','Chiriquí',NULL),(2662,'PA','03','2','Coclé',NULL),(2663,'PA','04','3','Colón',NULL),(2664,'PA','05','5','Darién',NULL),(2665,'PA','06','6','Herrera',NULL),(2666,'PA','07','7','Los Santos',NULL),(2667,'PA','08','8','Panamá',NULL),(2668,'PA','09',NULL,'San Blas',NULL),(2669,'PA','10','9','Veraguas',NULL),(2670,'PE','01','AMA','Amazonas',NULL),(2671,'PE','02','ANC','Ancash',NULL),(2672,'PE','03','APU','Apurímac',NULL),(2673,'PE','04','ARE','Arequipa',NULL),(2674,'PE','05','AYA','Ayacucho',NULL),(2675,'PE','06','CAJ','Cajamarca',NULL),(2676,'PE','07','CAL','El Callao',NULL),(2677,'PE','08','CUS','Cusco',NULL),(2678,'PE','09','HUV','Huancavelica',NULL),(2679,'PE','10','HUC','Huánuco',NULL),(2680,'PE','11','ICA','Ica',NULL),(2681,'PE','12','JUN','Junín',NULL),(2682,'PE','13','LAL','La Libertad',NULL),(2683,'PE','14','LAM','Lambayeque',NULL),(2684,'PE','15','LIM','Lima',NULL),(2685,'PE','16','LOR','Loreto',NULL),(2686,'PE','17','MDD','Madre de Dios',NULL),(2687,'PE','18','MOQ','Moquegua',NULL),(2688,'PE','19','PAS','Pasco',NULL),(2689,'PE','20','PIU','Piura',NULL),(2690,'PE','21','PUN','Puno',NULL),(2691,'PE','22','SAM','San Martín',NULL),(2692,'PE','23','TAC','Tacna',NULL),(2693,'PE','24','TUM','Tumbes',NULL),(2694,'PE','25','UCA','Ucayali',NULL),(2695,'PG','01','CPM','Central',NULL),(2696,'PG','02','GPK','Gulf',NULL),(2697,'PG','03','MBA','Milne Bay',NULL),(2698,'PG','04','NPP','Northern',NULL),(2699,'PG','05','SHM','Southern Highlands',NULL),(2700,'PG','06','WPD','Western',NULL),(2701,'PG','07','NSA','North Solomons',NULL),(2702,'PG','08','CPK','Chimbu',NULL),(2703,'PG','09','EHG','Eastern Highlands',NULL),(2704,'PG','10','EBR','East New Britain',NULL),(2705,'PG','11','ESW','East Sepik',NULL),(2706,'PG','12','MPM','Madang',NULL),(2707,'PG','13','MRL','Manus',NULL),(2708,'PG','14','MPL','Morobe',NULL),(2709,'PG','15','NIK','New Ireland',NULL),(2710,'PG','16','WHM','Western Highlands',NULL),(2711,'PG','17','WBK','West New Britain',NULL),(2712,'PG','18','SAN','Sandaun',NULL),(2713,'PG','19','EPW','Enga',NULL),(2714,'PG','20',NULL,'National Capital',NULL),(2715,'PH','01','ABR','Abra',NULL),(2716,'PH','02','AGN','Agusan del Norte',NULL),(2717,'PH','03','AGS','Agusan del Sur',NULL),(2718,'PH','04','AKL','Aklan',NULL),(2719,'PH','05','ALB','Albay',NULL),(2720,'PH','06','ANT','Antique',NULL),(2721,'PH','07','BAN','Bataan',NULL),(2722,'PH','08','BTN','Batanes',NULL),(2723,'PH','09','BTG','Batangas',NULL),(2724,'PH','10','BEN','Benguet',NULL),(2725,'PH','11','BOH','Bohol',NULL),(2726,'PH','12','BUK','Bukidnon',NULL),(2727,'PH','13','BUL','Bulacan',NULL),(2728,'PH','14','CAG','Cagayan',NULL),(2729,'PH','15','CAN','Camarines Norte',NULL),(2730,'PH','16','CAS','Camarines Sur',NULL),(2731,'PH','17','CAM','Camiguin',NULL),(2732,'PH','18','CAP','Capiz',NULL),(2733,'PH','19','CAT','Catanduanes',NULL),(2734,'PH','20','CAV','Cavite',NULL),(2735,'PH','21','CEB','Cebu',NULL),(2736,'PH','22','BAS','Basilan',NULL),(2737,'PH','23','EAS','Eastern Samar',NULL),(2738,'PH','24','11','Davao',NULL),(2739,'PH','25','DAS','Davao del Sur',NULL),(2740,'PH','26','DAO','Davao Oriental',NULL),(2741,'PH','27','IFU','Ifugao',NULL),(2742,'PH','28','ILN','Ilocos Norte',NULL),(2743,'PH','29','ILS','Ilocos Sur',NULL),(2744,'PH','30','ILI','Iloilo',NULL),(2745,'PH','31','ISA','Isabela',NULL),(2746,'PH','32',NULL,'Kalinga-Apayao',NULL),(2747,'PH','33','LAG','Laguna',NULL),(2748,'PH','34','LAN','Lanao del Norte',NULL),(2749,'PH','35','LAS','Lanao del Sur',NULL),(2750,'PH','36','LUN','La Union',NULL),(2751,'PH','37','LEY','Leyte',NULL),(2752,'PH','38','MAD','Marinduque',NULL),(2753,'PH','39','MAS','Masbate',NULL),(2754,'PH','40','MDC','Mindoro Occidental',NULL),(2755,'PH','41','MDR','Mindoro Oriental',NULL),(2756,'PH','42','MSC','Misamis Occidental',NULL),(2757,'PH','43','MSR','Misamis Oriental',NULL),(2758,'PH','44',NULL,'Mountain',NULL),(2759,'PH','45','NEC','Negros Occidental',NULL),(2760,'PH','46','NER','Negros Oriental',NULL),(2761,'PH','47','NUE','Nueva Ecija',NULL),(2762,'PH','48','NUV','Nueva Vizcaya',NULL),(2763,'PH','49','PLW','Palawan',NULL),(2764,'PH','50','PAM','Pampanga',NULL),(2765,'PH','51','PAN','Pangasinan',NULL),(2766,'PH','53','RIZ','Rizal',NULL),(2767,'PH','54','ROM','Romblon',NULL),(2768,'PH','55',NULL,'Samar',NULL),(2769,'PH','56','MAG','Maguindanao',NULL),(2770,'PH','57','NCO','North Cotabato',NULL),(2771,'PH','58','SOR','Sorsogon',NULL),(2772,'PH','59','SLE','Southern Leyte',NULL),(2773,'PH','60','SLU','Sulu',NULL),(2774,'PH','61','SUN','Surigao del Norte',NULL),(2775,'PH','62','SUR','Surigao del Sur',NULL),(2776,'PH','63','TAR','Tarlac',NULL),(2777,'PH','64','ZMB','Zambales',NULL),(2778,'PH','65','ZAN','Zamboanga del Norte',NULL),(2779,'PH','66','ZAS','Zamboanga del Sur',NULL),(2780,'PH','67','NSA','Northern Samar',NULL),(2781,'PH','68','QUI','Quirino',NULL),(2782,'PH','69','SIG','Siquijor',NULL),(2783,'PH','70','SCO','South Cotabato',NULL),(2784,'PH','71','SUK','Sultan Kudarat',NULL),(2785,'PH','72',NULL,'Tawitawi',NULL),(2786,'PH','A1',NULL,'Angeles',NULL),(2787,'PH','A2',NULL,'Bacolod',NULL),(2788,'PH','A3',NULL,'Bago',NULL),(2789,'PH','A4',NULL,'Baguio',NULL),(2790,'PH','A5',NULL,'Bais',NULL),(2791,'PH','A6',NULL,'Basilan City',NULL),(2792,'PH','A7',NULL,'Batangas City',NULL),(2793,'PH','A8',NULL,'Butuan',NULL),(2794,'PH','A9',NULL,'Cabanatuan',NULL),(2795,'PH','B1',NULL,'Cadiz',NULL),(2796,'PH','B2',NULL,'Cagayan de Oro',NULL),(2797,'PH','B3',NULL,'Calbayog',NULL),(2798,'PH','B4',NULL,'Caloocan',NULL),(2799,'PH','B5',NULL,'Canlaon',NULL),(2800,'PH','B6',NULL,'Cavite City',NULL),(2801,'PH','B7',NULL,'Cebu City',NULL),(2802,'PH','B8',NULL,'Cotabato',NULL),(2803,'PH','B9',NULL,'Dagupan',NULL),(2804,'PH','C1',NULL,'Danao',NULL),(2805,'PH','C2',NULL,'Dapitan',NULL),(2806,'PH','C3',NULL,'Davao City',NULL),(2807,'PH','C4',NULL,'Dipolog',NULL),(2808,'PH','C5',NULL,'Dumaguete',NULL),(2809,'PH','C6',NULL,'General Santos',NULL),(2810,'PH','C7',NULL,'Gingoog',NULL),(2811,'PH','C8',NULL,'Iligan',NULL),(2812,'PH','C9',NULL,'Iloilo City',NULL),(2813,'PH','D1',NULL,'Iriga',NULL),(2814,'PH','D2',NULL,'La Carlota',NULL),(2815,'PH','D3',NULL,'Laoag',NULL),(2816,'PH','D4',NULL,'Lapu-Lapu',NULL),(2817,'PH','D5',NULL,'Legaspi',NULL),(2818,'PH','D6',NULL,'Lipa',NULL),(2819,'PH','D7',NULL,'Lucena',NULL),(2820,'PH','D8',NULL,'Mandaue',NULL),(2821,'PH','D9',NULL,'Manila',NULL),(2822,'PH','E1',NULL,'Marawi',NULL),(2823,'PH','E2',NULL,'Naga',NULL),(2824,'PH','E3',NULL,'Olongapo',NULL),(2825,'PH','E4',NULL,'Ormoc',NULL),(2826,'PH','E5',NULL,'Oroquieta',NULL),(2827,'PH','E6',NULL,'Ozamis',NULL),(2828,'PH','E7',NULL,'Pagadian',NULL),(2829,'PH','E8',NULL,'Palayan',NULL),(2830,'PH','E9',NULL,'Pasay',NULL),(2831,'PH','F1',NULL,'Puerto Princesa',NULL),(2832,'PH','F2',NULL,'Quezon City',NULL),(2833,'PH','F3',NULL,'Roxas',NULL),(2834,'PH','F4',NULL,'San Carlos',NULL),(2835,'PH','F5',NULL,'San Carlos',NULL),(2836,'PH','F6',NULL,'San Jose',NULL),(2837,'PH','F7',NULL,'San Pablo',NULL),(2838,'PH','F8',NULL,'Silay',NULL),(2839,'PH','F9',NULL,'Surigao',NULL),(2840,'PH','G1',NULL,'Tacloban',NULL),(2841,'PH','G2',NULL,'Tagaytay',NULL),(2842,'PH','G3',NULL,'Tagbilaran',NULL),(2843,'PH','G4',NULL,'Tangub',NULL),(2844,'PH','G5',NULL,'Toledo',NULL),(2845,'PH','G6',NULL,'Trece Martires',NULL),(2846,'PH','G7',NULL,'Zamboanga',NULL),(2847,'PH','G8','AUR','Aurora',NULL),(2848,'PH','H2','QUE','Quezon',NULL),(2849,'PH','H3',NULL,'Negros Occidental',NULL),(2850,'PK','01','TA','Federally Administered Tribal Areas',NULL),(2851,'PK','02','BA','Baluchistan',NULL),(2852,'PK','03','NW','North-West Frontier',NULL),(2853,'PK','04','PB','Punjab',NULL),(2854,'PK','05','SD','Sind',NULL),(2855,'PK','06','JK','Azad Kashmir',NULL),(2856,'PK','07','NA','Northern Areas',NULL),(2857,'PK','08','IS','Islamabad',NULL),(2858,'PL','72','DS','Dolnoslaskie',NULL),(2859,'PL','73','KP','Kujawsko-pomorskie',NULL),(2860,'PL','74','LU','Lubelskie',NULL),(2861,'PL','75','LB','Lubuskie',NULL),(2862,'PL','76','LD','Lódzkie',NULL),(2863,'PL','77','MA','Malopolskie',NULL),(2864,'PL','78','MZ','Mazowieckie',NULL),(2865,'PL','79','OP','Opolskie',NULL),(2866,'PL','80','PK','Podkarpackie',NULL),(2867,'PL','81','PD','Podlaskie',NULL),(2868,'PL','82','PM','Pomorskie',NULL),(2869,'PL','83','SL','Slaskie',NULL),(2870,'PL','84','SK','Swietokrzyskie',NULL),(2871,'PL','85','WN','Warminsko-mazurskie',NULL),(2872,'PL','86','WP','Wielkopolskie',NULL),(2873,'PL','87','ZP','Zachodniopomorskie',NULL),(2874,'PS','GZ',NULL,'Gaza',NULL),(2875,'PS','WE',NULL,'West Bank',NULL),(2876,'PT','02','01','Aveiro',NULL),(2877,'PT','03','02','Beja',NULL),(2878,'PT','04','03','Braga',NULL),(2879,'PT','05','04','Bragança',NULL),(2880,'PT','06','05','Castelo Branco',NULL),(2881,'PT','07','06','Coimbra',NULL),(2882,'PT','08','07','Évora',NULL),(2883,'PT','09','08','Faro',NULL),(2884,'PT','10',NULL,'Madeira',327),(2885,'PT','11','09','Guarda',NULL),(2886,'PT','13','10','Leiria',NULL),(2887,'PT','14','11','Lisboa',NULL),(2888,'PT','16','12','Portalegre',NULL),(2889,'PT','17','13','Porto',NULL),(2890,'PT','18','14','Santarém',NULL),(2891,'PT','19','15','Setúbal',NULL),(2892,'PT','20','16','Viana do Castelo',NULL),(2893,'PT','21','17','Vila Real',NULL),(2894,'PT','22','18','Viseu',NULL),(2895,'PT','23',NULL,'Azores',328),(2896,'PY','01','10','Alto Paraná',NULL),(2897,'PY','02','13','Amambay',NULL),(2898,'PY','03','19','Boquerón',NULL),(2899,'PY','04','5','Caaguazú',NULL),(2900,'PY','05','6','Caazapá',NULL),(2901,'PY','06','11','Central',NULL),(2902,'PY','07','1','Concepción',NULL),(2903,'PY','08','3','Cordillera',NULL),(2904,'PY','10','4','Guairá',NULL),(2905,'PY','11','7','Itapúa',NULL),(2906,'PY','12','8','Misiones',NULL),(2907,'PY','13','12','Ñeembucú',NULL),(2908,'PY','15','9','Paraguarí',NULL),(2909,'PY','16','15','Presidente Hayes',NULL),(2910,'PY','17','2','San Pedro',NULL),(2911,'PY','19','14','Canindeyú',NULL),(2912,'PY','20',NULL,'Chaco',NULL),(2913,'PY','21',NULL,'Nueva Asuncion',NULL),(2914,'PY','23','16','Alto Paraguay',NULL),(2915,'QA','01','DA','Ad Dawhah',NULL),(2916,'QA','02',NULL,'Al Ghuwariyah',NULL),(2917,'QA','03','JU','Al Jumayliyah',NULL),(2918,'QA','04','KH','Al Khawr',NULL),(2919,'QA','05','WA','Al Wakrah',NULL),(2920,'QA','06','RA','Ar Rayyan',NULL),(2921,'QA','08','MS','Madinat ash Shamal',NULL),(2922,'QA','09','US','Umm Salal',NULL),(2923,'QA','10',NULL,'Al Wakrah',NULL),(2924,'QA','11','JB','Jariyan al Batnah',NULL),(2925,'QA','12','X1','Umm Sa\'id',NULL),(2926,'RO','01','AB','Alba',NULL),(2927,'RO','02','AR','Arad',NULL),(2928,'RO','03','AG','Arges',NULL),(2929,'RO','04','BC','Bacau',NULL),(2930,'RO','05','BH','Bihor',NULL),(2931,'RO','06','BN','Bistrita-Nasaud',NULL),(2932,'RO','07','BT','Botosani',NULL),(2933,'RO','08','BR','Braila',NULL),(2934,'RO','09','BV','Brasov',NULL),(2935,'RO','10','B','Bucuresti',NULL),(2936,'RO','11','BZ','Buzau',NULL),(2937,'RO','12','CS','Caras-Severin',NULL),(2938,'RO','13','CJ','Cluj',NULL),(2939,'RO','14','CT','Constanta',NULL),(2940,'RO','15','CV','Covasna',NULL),(2941,'RO','16','DB','Dâmbovita',NULL),(2942,'RO','17','DJ','Dolj',NULL),(2943,'RO','18','GL','Galati',NULL),(2944,'RO','19','GJ','Gorj',NULL),(2945,'RO','20','HR','Harghita',NULL),(2946,'RO','21','HD','Hunedoara',NULL),(2947,'RO','22','IL','Ialomita',NULL),(2948,'RO','23','IS','Iasi',NULL),(2949,'RO','25','MM','Maramures',NULL),(2950,'RO','26','MH','Mehedinti',NULL),(2951,'RO','27','MS','Mures',NULL),(2952,'RO','28','NT','Neamt',NULL),(2953,'RO','29','OT','Olt',NULL),(2954,'RO','30','PH','Prahova',NULL),(2955,'RO','31','SJ','Salaj',NULL),(2956,'RO','32','SM','Satu Mare',NULL),(2957,'RO','33','SB','Sibiu',NULL),(2958,'RO','34','SV','Suceava',NULL),(2959,'RO','35','TR','Teleorman',NULL),(2960,'RO','36','TM','Timis',NULL),(2961,'RO','37','TL','Tulcea',NULL),(2962,'RO','38','VS','Vaslui',NULL),(2963,'RO','39','VL','Vâlcea',NULL),(2964,'RO','40','VN','Vrancea',NULL),(2965,'RO','41','CL','Calarasi',NULL),(2966,'RO','42','GR','Giurgiu',NULL),(2967,'RO','43','IF','Ilfov',NULL),(2968,'RS','01',NULL,'Kosovo',NULL),(2969,'RS','02',NULL,'Vojvodina',NULL),(2970,'RU','01',NULL,'Adygeya, Republic of',293),(2971,'RU','02',NULL,'Aginsky Buryatsky AO',294),(2972,'RU','03',NULL,'Gorno-Altay',295),(2973,'RU','04',NULL,'Altaisky krai',296),(2974,'RU','05',NULL,'Amur',297),(2975,'RU','06',NULL,'Arkhangel\'sk',298),(2976,'RU','07',NULL,'Astrakhan\'',293),(2977,'RU','08',NULL,'Bashkortostan',299),(2978,'RU','09',NULL,'Belgorod',298),(2979,'RU','10',NULL,'Bryansk',298),(2980,'RU','11',NULL,'Buryat',294),(2981,'RU','12',NULL,'Chechnya',NULL),(2982,'RU','13',NULL,'Chelyabinsk',300),(2983,'RU','14',NULL,'Chita',294),(2984,'RU','15',NULL,'Chukot',301),(2985,'RU','16',NULL,'Chuvashia',299),(2986,'RU','17',NULL,'Dagestan',293),(2987,'RU','18',NULL,'Evenk',302),(2988,'RU','19',NULL,'Ingush',NULL),(2989,'RU','20',NULL,'Irkutsk',294),(2990,'RU','21',NULL,'Ivanovo',298),(2991,'RU','22',NULL,'Kabardin-Balkar',293),(2992,'RU','23',NULL,'Kaliningrad',303),(2993,'RU','24',NULL,'Kalmyk',293),(2994,'RU','25',NULL,'Kaluga',298),(2995,'RU','26',NULL,'Kamchatka',304),(2996,'RU','27',NULL,'Karachay-Cherkess',293),(2997,'RU','28',NULL,'Karelia',298),(2998,'RU','29',NULL,'Kemerovo',295),(2999,'RU','30',NULL,'Khabarovsk',297),(3000,'RU','31',NULL,'Khakass',302),(3001,'RU','32',NULL,'Khanty-Mansiy',305),(3002,'RU','33',NULL,'Kirov',300),(3003,'RU','34',NULL,'Komi',300),(3004,'RU','35','X1','Komi-Permyak',300),(3005,'RU','36',NULL,'Koryak',301),(3006,'RU','37',NULL,'Kostroma',298),(3007,'RU','38',NULL,'Krasnodar',293),(3008,'RU','39',NULL,'Krasnoyarsk',302),(3009,'RU','40',NULL,'Kurgan',300),(3010,'RU','41',NULL,'Kursk',298),(3011,'RU','42',NULL,'Leningrad',298),(3012,'RU','43',NULL,'Lipetsk',298),(3013,'RU','44',NULL,'Magadan',306),(3014,'RU','45',NULL,'Mariy-El',299),(3015,'RU','46',NULL,'Mordovia',299),(3016,'RU','47','MOW','Moskva',298),(3017,'RU','48',NULL,'Moscow City',298),(3018,'RU','49',NULL,'Murmansk',298),(3019,'RU','50',NULL,'Nenets',300),(3020,'RU','51',NULL,'Nizhegorod',298),(3021,'RU','52',NULL,'Novgorod',298),(3022,'RU','53',NULL,'Novosibirsk',296),(3023,'RU','54',NULL,'Omsk',305),(3024,'RU','55',NULL,'Orenburg',299),(3025,'RU','56',NULL,'Orel',298),(3026,'RU','57',NULL,'Penza',299),(3027,'RU','58',NULL,'Perm\'',300),(3028,'RU','59',NULL,'Primor\'ye',297),(3029,'RU','60',NULL,'Pskov',303),(3030,'RU','61',NULL,'Rostov',293),(3031,'RU','62',NULL,'Ryazan\'',298),(3032,'RU','63',NULL,'Sakha',307),(3033,'RU','64',NULL,'Sakhalin',308),(3034,'RU','65',NULL,'Samara',299),(3035,'RU','66',NULL,'Saint Petersburg City',298),(3036,'RU','67',NULL,'Saratov',299),(3037,'RU','68',NULL,'North Ossetia',293),(3038,'RU','69',NULL,'Smolensk',298),(3039,'RU','70',NULL,'Stavropol\'',293),(3040,'RU','71',NULL,'Sverdlovsk',300),(3041,'RU','72',NULL,'Tambovskaya oblast',298),(3042,'RU','73',NULL,'Tatarstan',299),(3043,'RU','74',NULL,'Taymyr',302),(3044,'RU','75',NULL,'Tomsk',296),(3045,'RU','76',NULL,'Tula',298),(3046,'RU','77',NULL,'Tver\'',298),(3047,'RU','78',NULL,'Tyumen\'',300),(3048,'RU','79',NULL,'Tuva',294),(3049,'RU','80',NULL,'Udmurt',300),(3050,'RU','81',NULL,'Ul\'yanovsk',299),(3051,'RU','82',NULL,'Ust-Orda Buryat',294),(3052,'RU','83',NULL,'Vladimir',298),(3053,'RU','84',NULL,'Volgograd',293),(3054,'RU','85',NULL,'Vologda',298),(3055,'RU','86',NULL,'Voronezh',298),(3056,'RU','87',NULL,'Yamal-Nenets',296),(3057,'RU','88',NULL,'Yaroslavl\'',298),(3058,'RU','89',NULL,'Yevrey',297),(3059,'RU','90',NULL,'Permskiy Kray',NULL),(3060,'RU','91','KYA','Krasnoyarskiy kray',NULL),(3061,'RU','92',NULL,'Kamchatskiy Kray',NULL),(3062,'RU','93',NULL,'Zabaykal\'skiy Kray',NULL),(3063,'RW','01',NULL,'Butare',NULL),(3064,'RW','06',NULL,'Gitarama',NULL),(3065,'RW','07',NULL,'Kibungo',NULL),(3066,'RW','09',NULL,'Kigali',NULL),(3067,'RW','11','02','Est',NULL),(3068,'RW','12','01','Ville de Kigali',NULL),(3069,'RW','13','03','Nord',NULL),(3070,'RW','14','04','Ouest',NULL),(3071,'RW','15','05','Sud',NULL),(3072,'SA','02','11','Al Ba?ah',NULL),(3073,'SA','05','03','Al Madinah',NULL),(3074,'SA','06','04','Ash Sharqiyah',NULL),(3075,'SA','08','05','Al Qasim',NULL),(3076,'SA','10','01','Ar Riya?',NULL),(3077,'SA','11',NULL,'Asir Province',NULL),(3078,'SA','13','06','?a\'il',NULL),(3079,'SA','14','02','Makkah',NULL),(3080,'SA','15','08','Al ?udud ash Shamaliyah',NULL),(3081,'SA','16','10','Najran',NULL),(3082,'SA','17','09','Jizan',NULL),(3083,'SA','19','07','Tabuk',NULL),(3084,'SA','20','12','Al Jawf',NULL),(3085,'SB','03','ML','Malaita',NULL),(3086,'SB','06','GU','Guadalcanal',NULL),(3087,'SB','07','IS','Isabel',NULL),(3088,'SB','08','MK','Makira',NULL),(3089,'SB','09','TE','Temotu',NULL),(3090,'SB','10','CE','Central',NULL),(3091,'SB','11','WE','Western',NULL),(3092,'SB','12','CH','Choiseul',NULL),(3093,'SB','13','RB','Rennell and Bellona',NULL),(3094,'SC','01','01','Anse aux Pins',NULL),(3095,'SC','02','02','Anse Boileau',NULL),(3096,'SC','03','03','Anse Étoile',NULL),(3097,'SC','04',NULL,'Anse Louis',NULL),(3098,'SC','05','05','Anse Royale',NULL),(3099,'SC','06','06','Baie Lazare',NULL),(3100,'SC','07','07','Baie Sainte Anne',NULL),(3101,'SC','08','08','Beau Vallon',NULL),(3102,'SC','09','09','Bel Air',NULL),(3103,'SC','10','10','Bel Ombre',NULL),(3104,'SC','11','11','Cascade',NULL),(3105,'SC','12','12','Glacis',NULL),(3106,'SC','13',NULL,'Grand\' Anse',NULL),(3107,'SC','14',NULL,'Grand\' Anse',NULL),(3108,'SC','15','15','La Digue',NULL),(3109,'SC','16',NULL,'La Riviere Anglaise',NULL),(3110,'SC','17','17','Mont Buxton',NULL),(3111,'SC','18','18','Mont Fleuri',NULL),(3112,'SC','19','19','Plaisance',NULL),(3113,'SC','20','20','Pointe La Rue',NULL),(3114,'SC','21','21','Port Glaud',NULL),(3115,'SC','22','22','Saint Louis',NULL),(3116,'SC','23','23','Takamaka',NULL),(3117,'SD','27',NULL,'Al Wusta',NULL),(3118,'SD','28',NULL,'Al Istiwa\'iyah',NULL),(3119,'SD','29','03','Al Khartum',NULL),(3120,'SD','30','01','Ash Shamaliyah',NULL),(3121,'SD','31',NULL,'Ash Sharqiyah',NULL),(3122,'SD','32',NULL,'Bahr al Ghazal',NULL),(3123,'SD','33',NULL,'Darfur',NULL),(3124,'SD','34',NULL,'Kurdufan',NULL),(3125,'SD','35',NULL,'Upper Nile',NULL),(3126,'SD','40',NULL,'Al Wahadah State',NULL),(3127,'SD','44',NULL,'Central Equatoria State',NULL),(3128,'SE','02','K','Blekinge län',NULL),(3129,'SE','03','X','Gävleborgs län',NULL),(3130,'SE','05','I','Gotlands län',NULL),(3131,'SE','06','N','Hallands län',NULL),(3132,'SE','07','Z','Jämtlands län',NULL),(3133,'SE','08','F','Jönköpings län',NULL),(3134,'SE','09','H','Kalmar län',NULL),(3135,'SE','10','W','Dalarnas län',NULL),(3136,'SE','12','G','Kronobergs län',NULL),(3137,'SE','14','BD','Norrbottens län',NULL),(3138,'SE','15','T','Örebro län',NULL),(3139,'SE','16','E','Östergötlands län',NULL),(3140,'SE','18','D','Södermanlands län',NULL),(3141,'SE','21','C','Uppsala län',NULL),(3142,'SE','22','S','Värmlands län',NULL),(3143,'SE','23','AC','Västerbottens län',NULL),(3144,'SE','24','Y','Västernorrlands län',NULL),(3145,'SE','25','U','Västmanlands län',NULL),(3146,'SE','26','AB','Stockholms län',NULL),(3147,'SE','27','M','Skåne län',NULL),(3148,'SE','28',NULL,'Vastra Gotaland',NULL),(3149,'SH','01','AC','Ascension',NULL),(3150,'SH','02','SH','Saint Helena',NULL),(3151,'SH','03','TA','Tristan da Cunha',NULL),(3152,'SI','01','001','Ajdovšcina',NULL),(3153,'SI','02','002','Beltinci',NULL),(3154,'SI','03','003','Bled',NULL),(3155,'SI','04','004','Bohinj',NULL),(3156,'SI','05','005','Borovnica',NULL),(3157,'SI','06','006','Bovec',NULL),(3158,'SI','07','007','Brda',NULL),(3159,'SI','08','009','Brežice',NULL),(3160,'SI','09','008','Brezovica',NULL),(3161,'SI','11','011','Celje',NULL),(3162,'SI','12','012','Cerklje na Gorenjskem',NULL),(3163,'SI','13','013','Cerknica',NULL),(3164,'SI','14','014','Cerkno',NULL),(3165,'SI','15','015','Crenšovci',NULL),(3166,'SI','16','016','Crna na Koroškem',NULL),(3167,'SI','17','017','Crnomelj',NULL),(3168,'SI','19','019','Divaca',NULL),(3169,'SI','20','020','Dobrepolje',NULL),(3170,'SI','22','022','Dol pri Ljubljani',NULL),(3171,'SI','24','024','Dornava',NULL),(3172,'SI','25','025','Dravograd',NULL),(3173,'SI','26','026','Duplek',NULL),(3174,'SI','27','027','Gorenja vas-Poljane',NULL),(3175,'SI','28','028','Gorišnica',NULL),(3176,'SI','29','029','Gornja Radgona',NULL),(3177,'SI','30','030','Gornji Grad',NULL),(3178,'SI','31','031','Gornji Petrovci',NULL),(3179,'SI','32','032','Grosuplje',NULL),(3180,'SI','34','034','Hrastnik',NULL),(3181,'SI','35','035','Hrpelje-Kozina',NULL),(3182,'SI','36','036','Idrija',NULL),(3183,'SI','37','037','Ig',NULL),(3184,'SI','38','038','Ilirska Bistrica',NULL),(3185,'SI','39','039','Ivancna Gorica',NULL),(3186,'SI','40',NULL,'Izola-Isola',NULL),(3187,'SI','42','042','Juršinci',NULL),(3188,'SI','44','044','Kanal',NULL),(3189,'SI','45','045','Kidricevo',NULL),(3190,'SI','46','046','Kobarid',NULL),(3191,'SI','47','047','Kobilje',NULL),(3192,'SI','49','049','Komen',NULL),(3193,'SI','50',NULL,'Koper-Capodistria',NULL),(3194,'SI','51','051','Kozje',NULL),(3195,'SI','52','052','Kranj',NULL),(3196,'SI','53','053','Kranjska Gora',NULL),(3197,'SI','54','054','Krško',NULL),(3198,'SI','55','055','Kungota',NULL),(3199,'SI','57','057','Laško',NULL),(3200,'SI','61','061','Ljubljana',NULL),(3201,'SI','62','062','Ljubno',NULL),(3202,'SI','64','064','Logatec',NULL),(3203,'SI','66','066','Loški Potok',NULL),(3204,'SI','68','068','Lukovica',NULL),(3205,'SI','71','071','Medvode',NULL),(3206,'SI','72','072','Mengeš',NULL),(3207,'SI','73','073','Metlika',NULL),(3208,'SI','74','074','Mežica',NULL),(3209,'SI','76','076','Mislinja',NULL),(3210,'SI','77','077','Moravce',NULL),(3211,'SI','78','078','Moravske Toplice',NULL),(3212,'SI','79','079','Mozirje',NULL),(3213,'SI','80','080','Murska Sobota',NULL),(3214,'SI','81','081','Muta',NULL),(3215,'SI','82','082','Naklo',NULL),(3216,'SI','83','083','Nazarje',NULL),(3217,'SI','84','084','Nova Gorica',NULL),(3218,'SI','86','086','Odranci',NULL),(3219,'SI','87','087','Ormož',NULL),(3220,'SI','88','088','Osilnica',NULL),(3221,'SI','89','089','Pesnica',NULL),(3222,'SI','91','091','Pivka',NULL),(3223,'SI','92','092','Podcetrtek',NULL),(3224,'SI','94','094','Postojna',NULL),(3225,'SI','97','097','Puconci',NULL),(3226,'SI','98',NULL,'Racam',NULL),(3227,'SI','99','099','Radece',NULL),(3228,'SI','A1','100','Radenci',NULL),(3229,'SI','A2','101','Radlje ob Dravi',NULL),(3230,'SI','A3','102','Radovljica',NULL),(3231,'SI','A6','105','Rogašovci',NULL),(3232,'SI','A7','106','Rogaška Slatina',NULL),(3233,'SI','A8','107','Rogatec',NULL),(3234,'SI','B1','109','Semic',NULL),(3235,'SI','B2','117','Šencur',NULL),(3236,'SI','B3','118','Šentilj',NULL),(3237,'SI','B4','119','Šentjernej',NULL),(3238,'SI','B6','110','Sevnica',NULL),(3239,'SI','B7','111','Sežana',NULL),(3240,'SI','B8','121','Škocjan',NULL),(3241,'SI','B9','122','Škofja Loka',NULL),(3242,'SI','C1','123','Škofljica',NULL),(3243,'SI','C2','112','Slovenj Gradec',NULL),(3244,'SI','C4','114','Slovenske Konjice',NULL),(3245,'SI','C5','124','Šmarje pri Jelšah',NULL),(3246,'SI','C6','125','Šmartno ob Paki',NULL),(3247,'SI','C7','126','Šoštanj',NULL),(3248,'SI','C8','115','Starše',NULL),(3249,'SI','C9','127','Štore',NULL),(3250,'SI','D1','116','Sveti Jurij',NULL),(3251,'SI','D2','128','Tolmin',NULL),(3252,'SI','D3','129','Trbovlje',NULL),(3253,'SI','D4','130','Trebnje',NULL),(3254,'SI','D5','131','Tržic',NULL),(3255,'SI','D6','132','Turnišce',NULL),(3256,'SI','D7','133','Velenje',NULL),(3257,'SI','D8','134','Velike Lašce',NULL),(3258,'SI','E1','136','Vipava',NULL),(3259,'SI','E2','137','Vitanje',NULL),(3260,'SI','E3','138','Vodice',NULL),(3261,'SI','E5','140','Vrhnika',NULL),(3262,'SI','E6','141','Vuzenica',NULL),(3263,'SI','E7','142','Zagorje ob Savi',NULL),(3264,'SI','E9','143','Zavrc',NULL),(3265,'SI','F1','146','Železniki',NULL),(3266,'SI','F2','147','Žiri',NULL),(3267,'SI','F3','144','Zrece',NULL),(3268,'SI','G4',NULL,'Dobrova-Horjul-Polhov Gradec',NULL),(3269,'SI','G7','023','Domžale',NULL),(3270,'SI','H4','041','Jesenice',NULL),(3271,'SI','H6','043','Kamnik',NULL),(3272,'SI','H7','048','Kocevje',NULL),(3273,'SI','I2','056','Kuzma',NULL),(3274,'SI','I3','058','Lenart',NULL),(3275,'SI','I5','060','Litija',NULL),(3276,'SI','I6','063','Ljutomer',NULL),(3277,'SI','I7','065','Loška dolina',NULL),(3278,'SI','I9','067','Luce',NULL),(3279,'SI','J1','069','Majšperk',NULL),(3280,'SI','J2','070','Maribor',NULL),(3281,'SI','J5','075','Miren-Kostanjevica',NULL),(3282,'SI','J7','085','Novo mesto',NULL),(3283,'SI','J9',NULL,'Piran',NULL),(3284,'SI','K5','095','Preddvor',NULL),(3285,'SI','K7','096','Ptuj',NULL),(3286,'SI','L1','104','Ribnica',NULL),(3287,'SI','L3','108','Ruše',NULL),(3288,'SI','L7','120','Šentjur pri Celju',NULL),(3289,'SI','L8','113','Slovenska Bistrica',NULL),(3290,'SI','N2','135','Videm',NULL),(3291,'SI','N3','139','Vojnik',NULL),(3292,'SI','N5','190','Žalec',NULL),(3293,'SK','01',NULL,'Banska Bystrica',NULL),(3294,'SK','02',NULL,'Bratislava',NULL),(3295,'SK','03',NULL,'Kosice',NULL),(3296,'SK','04',NULL,'Nitra',NULL),(3297,'SK','05',NULL,'Presov',NULL),(3298,'SK','06',NULL,'Trencin',NULL),(3299,'SK','07',NULL,'Trnava',NULL),(3300,'SK','08',NULL,'Zilina',NULL),(3301,'SL','01','E','Eastern',NULL),(3302,'SL','02','N','Northern',NULL),(3303,'SL','03','S','Southern',NULL),(3304,'SL','04','W','Western Area',NULL),(3305,'SM','01','01','Acquaviva',NULL),(3306,'SM','02','02','Chiesanuova',NULL),(3307,'SM','03','03','Domagnano',NULL),(3308,'SM','04','04','Faetano',NULL),(3309,'SM','05','05','Fiorentino',NULL),(3310,'SM','06','06','Borgo Maggiore',NULL),(3311,'SM','07','07','San Marino',NULL),(3312,'SM','08',NULL,'Monte Giardino',NULL),(3313,'SM','09','09','Serravalle',NULL),(3314,'SN','01','DK','Dakar',NULL),(3315,'SN','03','DB','Diourbel',NULL),(3316,'SN','05','TC','Tambacounda',NULL),(3317,'SN','07','TH','Thiès',NULL),(3318,'SN','09','FK','Fatick',NULL),(3319,'SN','10','KL','Kaolack',NULL),(3320,'SN','11','KD','Kolda',NULL),(3321,'SN','12','ZG','Ziguinchor',NULL),(3322,'SN','13','LG','Louga',NULL),(3323,'SN','14','SL','Saint-Louis',NULL),(3324,'SN','15','MT','Matam',NULL),(3325,'SO','01','BK','Bakool',NULL),(3326,'SO','02','BN','Banaadir',NULL),(3327,'SO','03','BR','Bari',NULL),(3328,'SO','04','BY','Bay',NULL),(3329,'SO','05','GA','Galguduud',NULL),(3330,'SO','06','GE','Gedo',NULL),(3331,'SO','07','HI','Hiiraan',NULL),(3332,'SO','08','JD','Jubbada Dhexe',NULL),(3333,'SO','09','JH','Jubbada Hoose',NULL),(3334,'SO','10','MU','Mudug',NULL),(3335,'SO','11',NULL,'Nugaal',NULL),(3336,'SO','12','SA','Sanaag',NULL),(3337,'SO','13','SD','Shabeellaha Dhexe',NULL),(3338,'SO','14','SH','Shabeellaha Hoose',NULL),(3339,'SO','16',NULL,'Woqooyi Galbeed',NULL),(3340,'SO','18','NU','Nugaal',NULL),(3341,'SO','19','TO','Togdheer',NULL),(3342,'SO','20','WO','Woqooyi Galbeed',NULL),(3343,'SO','21','AW','Awdal',NULL),(3344,'SO','22','SO','Sool',NULL),(3345,'SR','10','BR','Brokopondo',NULL),(3346,'SR','11','CM','Commewijne',NULL),(3347,'SR','12','CR','Coronie',NULL),(3348,'SR','13','MA','Marowijne',NULL),(3349,'SR','14','NI','Nickerie',NULL),(3350,'SR','15','PR','Para',NULL),(3351,'SR','16','PM','Paramaribo',NULL),(3352,'SR','17','SA','Saramacca',NULL),(3353,'SR','18','SI','Sipaliwini',NULL),(3354,'SR','19','WA','Wanica',NULL),(3355,'ST','01','P','Príncipe',NULL),(3356,'ST','02','S','São Tomé',NULL),(3357,'SV','01','AH','Ahuachapán',NULL),(3358,'SV','02','CA','Cabañas',NULL),(3359,'SV','03','CH','Chalatenango',NULL),(3360,'SV','04','CU','Cuscatlán',NULL),(3361,'SV','05','LI','La Libertad',NULL),(3362,'SV','06','PA','La Paz',NULL),(3363,'SV','07','UN','La Unión',NULL),(3364,'SV','08','MO','Morazán',NULL),(3365,'SV','09','SM','San Miguel',NULL),(3366,'SV','10','SS','San Salvador',NULL),(3367,'SV','11','SA','Santa Ana',NULL),(3368,'SV','12','SV','San Vicente',NULL),(3369,'SV','13','SO','Sonsonate',NULL),(3370,'SV','14','US','Usulután',NULL),(3371,'SY','01','HA','Al ?asakah',NULL),(3372,'SY','02','LA','Al Ladhiqiyah',NULL),(3373,'SY','03','QU','Al Qunaytirah',NULL),(3374,'SY','04','RA','Ar Raqqah',NULL),(3375,'SY','05','SU','As Suwayda\'',NULL),(3376,'SY','06','DR','Dar?a',NULL),(3377,'SY','07','DY','Dayr az Zawr',NULL),(3378,'SY','08','RD','Rif Dimashq',NULL),(3379,'SY','09','HL','?alab',NULL),(3380,'SY','10','HM','?amah',NULL),(3381,'SY','11','HI','?ims',NULL),(3382,'SY','12','ID','Idlib',NULL),(3383,'SY','13','DI','Dimashq',NULL),(3384,'SY','14','TA','Tartus',NULL),(3385,'SZ','01','HH','Hhohho',NULL),(3386,'SZ','02','LU','Lubombo',NULL),(3387,'SZ','03','MA','Manzini',NULL),(3388,'SZ','04','SH','Shiselweni',NULL),(3389,'SZ','05',NULL,'Praslin',NULL),(3390,'TD','01',NULL,'Batha',NULL),(3391,'TD','02',NULL,'Biltine',NULL),(3392,'TD','03',NULL,'Borkou-Ennedi-Tibesti',NULL),(3393,'TD','04',NULL,'Chari-Baguirmi',NULL),(3394,'TD','05',NULL,'Guera',NULL),(3395,'TD','06',NULL,'Kanem',NULL),(3396,'TD','07',NULL,'Lac',NULL),(3397,'TD','08',NULL,'Logone Occidental',NULL),(3398,'TD','09',NULL,'Logone Oriental',NULL),(3399,'TD','10',NULL,'Mayo-Kebbi',NULL),(3400,'TD','11',NULL,'Moyen-Chari',NULL),(3401,'TD','12',NULL,'Ouaddai',NULL),(3402,'TD','13',NULL,'Salamat',NULL),(3403,'TD','14',NULL,'Tandjile',NULL),(3404,'TG','22',NULL,'Centrale',NULL),(3405,'TG','23','K','Kara',NULL),(3406,'TG','24','M','Maritime',NULL),(3407,'TG','25','P','Plateaux',NULL),(3408,'TG','26',NULL,'Savanes',NULL),(3409,'TH','01','58','Mae Hong Son',NULL),(3410,'TH','02','50','Chiang Mai',NULL),(3411,'TH','03','57','Chiang Rai',NULL),(3412,'TH','04','55','Nan',NULL),(3413,'TH','05','51','Lamphun',NULL),(3414,'TH','06','52','Lampang',NULL),(3415,'TH','07','54','Phrae',NULL),(3416,'TH','08','63','Tak',NULL),(3417,'TH','09','64','Sukhothai',NULL),(3418,'TH','10','53','Uttaradit',NULL),(3419,'TH','11','62','Kamphaeng Phet',NULL),(3420,'TH','12','65','Phitsanulok',NULL),(3421,'TH','13','66','Phichit',NULL),(3422,'TH','14','67','Phetchabun',NULL),(3423,'TH','15','61','Uthai Thani',NULL),(3424,'TH','16','60','Nakhon Sawan',NULL),(3425,'TH','17','43','Nong Khai',NULL),(3426,'TH','18','42','Loei',NULL),(3427,'TH','20','47','Sakon Nakhon',NULL),(3428,'TH','21',NULL,'Nakhon Phanom',NULL),(3429,'TH','22','40','Khon Kaen',NULL),(3430,'TH','23','46','Kalasin',NULL),(3431,'TH','24','44','Maha Sarakham',NULL),(3432,'TH','25','45','Roi Et',NULL),(3433,'TH','26','36','Chaiyaphum',NULL),(3434,'TH','27','30','Nakhon Ratchasima',NULL),(3435,'TH','28','31','Buri Ram',NULL),(3436,'TH','29','32','Surin',NULL),(3437,'TH','30','33','Si Sa Ket',NULL),(3438,'TH','31','96','Narathiwat',NULL),(3439,'TH','32','18','Chai Nat',NULL),(3440,'TH','33','17','Sing Buri',NULL),(3441,'TH','34','16','Lop Buri',NULL),(3442,'TH','35','15','Ang Thong',NULL),(3443,'TH','36','14','Phra Nakhon Si Ayutthaya',NULL),(3444,'TH','37','19','Saraburi',NULL),(3445,'TH','38','12','Nonthaburi',NULL),(3446,'TH','39','13','Pathum Thani',NULL),(3447,'TH','40','10','Krung Thep Maha Nakhon',NULL),(3448,'TH','41','56','Phayao',NULL),(3449,'TH','42','11','Samut Prakan',NULL),(3450,'TH','43','26','Nakhon Nayok',NULL),(3451,'TH','44','24','Chachoengsao',NULL),(3452,'TH','45','25','Prachin Buri',NULL),(3453,'TH','46','20','Chon Buri',NULL),(3454,'TH','47','21','Rayong',NULL),(3455,'TH','48','22','Chanthaburi',NULL),(3456,'TH','49','23','Trat',NULL),(3457,'TH','50','71','Kanchanaburi',NULL),(3458,'TH','51','72','Suphan Buri',NULL),(3459,'TH','52','70','Ratchaburi',NULL),(3460,'TH','53','48','Nakhon Phanom',NULL),(3461,'TH','54','75','Samut Songkhram',NULL),(3462,'TH','55','74','Samut Sakhon',NULL),(3463,'TH','56','76','Phetchaburi',NULL),(3464,'TH','57','77','Prachuap Khiri Khan',NULL),(3465,'TH','58','86','Chumphon',NULL),(3466,'TH','59','85','Ranong',NULL),(3467,'TH','60','84','Surat Thani',NULL),(3468,'TH','61','82','Phangnga',NULL),(3469,'TH','62','83','Phuket',NULL),(3470,'TH','63','81','Krabi',NULL),(3471,'TH','64','80','Nakhon Si Thammarat',NULL),(3472,'TH','65','92','Trang',NULL),(3473,'TH','66','93','Phatthalung',NULL),(3474,'TH','67','91','Satun',NULL),(3475,'TH','68','90','Songkhla',NULL),(3476,'TH','69','94','Pattani',NULL),(3477,'TH','70','95','Yala',NULL),(3478,'TH','71','34','Ubon Ratchathani',NULL),(3479,'TH','72','35','Yasothon',NULL),(3480,'TH','73','73','Nakhon Pathom',NULL),(3481,'TH','75',NULL,'Ubon Ratchathani',NULL),(3482,'TH','76','41','Udon Thani',NULL),(3483,'TH','77','37','Amnat Charoen',NULL),(3484,'TH','78','49','Mukdahan',NULL),(3485,'TH','79','39','Nong Bua Lam Phu',NULL),(3486,'TH','80','27','Sa Kaeo',NULL),(3487,'TJ','01',NULL,'Kuhistoni Badakhshon',NULL),(3488,'TJ','02','KT','Khatlon',NULL),(3489,'TJ','03','SU','Sughd',NULL),(3490,'TM','01','A','Ahal',NULL),(3491,'TM','02','B','Balkan',NULL),(3492,'TM','03',NULL,'Dashoguz',NULL),(3493,'TM','04','L','Lebap',NULL),(3494,'TM','05','M','Mary',NULL),(3495,'TN','02','42','Kasserine',NULL),(3496,'TN','03','41','Kairouan',NULL),(3497,'TN','06','32','Jendouba',NULL),(3498,'TN','10',NULL,'Qafsah',NULL),(3499,'TN','14',NULL,'El Kef',NULL),(3500,'TN','15',NULL,'Al Mahdia',NULL),(3501,'TN','16',NULL,'Al Munastir',NULL),(3502,'TN','17',NULL,'Bajah',NULL),(3503,'TN','18','23','Bizerte',NULL),(3504,'TN','19','21','Nabeul',NULL),(3505,'TN','22','34','Siliana',NULL),(3506,'TN','23','51','Sousse',NULL),(3507,'TN','27','13','Ben Arous',NULL),(3508,'TN','28',NULL,'Madanin',NULL),(3509,'TN','29','81','Gabès',NULL),(3510,'TN','31','73','Kebili',NULL),(3511,'TN','32','61','Sfax',NULL),(3512,'TN','33',NULL,'Sidi Bou Zid',NULL),(3513,'TN','34','83','Tataouine',NULL),(3514,'TN','35','72','Tozeur',NULL),(3515,'TN','36','11','Tunis',NULL),(3516,'TN','37','22','Zaghouan',NULL),(3517,'TN','38',NULL,'Aiana',NULL),(3518,'TN','39',NULL,'Manouba',NULL),(3519,'TO','01',NULL,'Ha',NULL),(3520,'TO','02','04','Tongatapu',NULL),(3521,'TO','03',NULL,'Vava',NULL),(3522,'TR','02','02','Adiyaman',NULL),(3523,'TR','03',NULL,'Afyonkarahisar',NULL),(3524,'TR','04','04','Agri',NULL),(3525,'TR','05','05','Amasya',NULL),(3526,'TR','07','07','Antalya',NULL),(3527,'TR','08','08','Artvin',NULL),(3528,'TR','09','09','Aydin',NULL),(3529,'TR','10','10','Balikesir',NULL),(3530,'TR','11','11','Bilecik',NULL),(3531,'TR','12','12','Bingöl',NULL),(3532,'TR','13','13','Bitlis',NULL),(3533,'TR','14','14','Bolu',NULL),(3534,'TR','15','15','Burdur',NULL),(3535,'TR','16','16','Bursa',NULL),(3536,'TR','17','17','Çanakkale',NULL),(3537,'TR','19','19','Çorum',NULL),(3538,'TR','20','20','Denizli',NULL),(3539,'TR','21','21','Diyarbakir',NULL),(3540,'TR','22','22','Edirne',NULL),(3541,'TR','23','23','Elazig',NULL),(3542,'TR','24','24','Erzincan',NULL),(3543,'TR','25','25','Erzurum',NULL),(3544,'TR','26','26','Eskisehir',NULL),(3545,'TR','28','28','Giresun',NULL),(3546,'TR','31','31','Hatay',NULL),(3547,'TR','32',NULL,'Mersin',NULL),(3548,'TR','33','32','Isparta',NULL),(3549,'TR','34','34','Istanbul',NULL),(3550,'TR','35','35','Izmir',NULL),(3551,'TR','37','37','Kastamonu',NULL),(3552,'TR','38','38','Kayseri',NULL),(3553,'TR','39','39','Kirklareli',NULL),(3554,'TR','40','40','Kirsehir',NULL),(3555,'TR','41','41','Kocaeli',NULL),(3556,'TR','43','43','Kütahya',NULL),(3557,'TR','44','44','Malatya',NULL),(3558,'TR','45','45','Manisa',NULL),(3559,'TR','46','46','Kahramanmaras',NULL),(3560,'TR','48','48','Mugla',NULL),(3561,'TR','49','49','Mus',NULL),(3562,'TR','50','50','Nevsehir',NULL),(3563,'TR','52','52','Ordu',NULL),(3564,'TR','53','53','Rize',NULL),(3565,'TR','54','54','Sakarya',NULL),(3566,'TR','55','55','Samsun',NULL),(3567,'TR','57','57','Sinop',NULL),(3568,'TR','58','58','Sivas',NULL),(3569,'TR','59','59','Tekirdag',NULL),(3570,'TR','60','60','Tokat',NULL),(3571,'TR','61','61','Trabzon',NULL),(3572,'TR','62','62','Tunceli',NULL),(3573,'TR','63','63','Sanliurfa',NULL),(3574,'TR','64','64','Usak',NULL),(3575,'TR','65','65','Van',NULL),(3576,'TR','66','66','Yozgat',NULL),(3577,'TR','68','06','Ankara',NULL),(3578,'TR','69','29','Gümüshane',NULL),(3579,'TR','70','30','Hakkâri',NULL),(3580,'TR','71','42','Konya',NULL),(3581,'TR','72','47','Mardin',NULL),(3582,'TR','73','51','Nigde',NULL),(3583,'TR','74','56','Siirt',NULL),(3584,'TR','75','68','Aksaray',NULL),(3585,'TR','76','72','Batman',NULL),(3586,'TR','77','69','Bayburt',NULL),(3587,'TR','78','70','Karaman',NULL),(3588,'TR','79','71','Kirikkale',NULL),(3589,'TR','80','73','Sirnak',NULL),(3590,'TR','81','01','Adana',NULL),(3591,'TR','82','18','Çankiri',NULL),(3592,'TR','83','27','Gaziantep',NULL),(3593,'TR','84','36','Kars',NULL),(3594,'TR','85','67','Zonguldak',NULL),(3595,'TR','86','75','Ardahan',NULL),(3596,'TR','87','74','Bartin',NULL),(3597,'TR','88','76','Igdir',NULL),(3598,'TR','89','78','Karabük',NULL),(3599,'TR','90','79','Kilis',NULL),(3600,'TR','91','80','Osmaniye',NULL),(3601,'TR','92','77','Yalova',NULL),(3602,'TR','93','81','Düzce',NULL),(3603,'TT','01','ARI','Arima',NULL),(3604,'TT','02',NULL,'Caroni',NULL),(3605,'TT','03',NULL,'Mayaro',NULL),(3606,'TT','04',NULL,'Nariva',NULL),(3607,'TT','05',NULL,'Port-of-Spain',NULL),(3608,'TT','06',NULL,'Saint Andrew',NULL),(3609,'TT','07',NULL,'Saint David',NULL),(3610,'TT','08',NULL,'Saint George',NULL),(3611,'TT','09',NULL,'Saint Patrick',NULL),(3612,'TT','10','SFO','San Fernando',NULL),(3613,'TT','11',NULL,'Tobago',NULL),(3614,'TT','12',NULL,'Victoria',NULL),(3615,'TW','01',NULL,'Fu-chien',NULL),(3616,'TW','02','KHH','Kaohsiung Special Municipality',NULL),(3617,'TW','03','TPE','Taipei Special Municipality',NULL),(3618,'TW','04','TNN','Tainan Municipality',NULL),(3619,'TZ','02','19','Pwani',NULL),(3620,'TZ','03','03','Dodoma',NULL),(3621,'TZ','04','04','Iringa',NULL),(3622,'TZ','05','08','Kigoma',NULL),(3623,'TZ','06','09','Kilimanjaro',NULL),(3624,'TZ','07','12','Lindi',NULL),(3625,'TZ','08','13','Mara',NULL),(3626,'TZ','09','14','Mbeya',NULL),(3627,'TZ','10','16','Morogoro',NULL),(3628,'TZ','11','17','Mtwara',NULL),(3629,'TZ','12','18','Mwanza',NULL),(3630,'TZ','13','06','Kaskazini Pemba',NULL),(3631,'TZ','14','21','Ruvuma',NULL),(3632,'TZ','15','22','Shinyanga',NULL),(3633,'TZ','16','23','Singida',NULL),(3634,'TZ','17','24','Tabora',NULL),(3635,'TZ','18','25','Tanga',NULL),(3636,'TZ','19','05','Kagera',NULL),(3637,'TZ','20',NULL,'Pemba South',NULL),(3638,'TZ','21',NULL,'Zanzibar Central',NULL),(3639,'TZ','22',NULL,'Zanzibar North',NULL),(3640,'TZ','23','02','Dar es Salaam',NULL),(3641,'TZ','24','20','Rukwa',NULL),(3642,'TZ','25',NULL,'Zanzibar Urban',NULL),(3643,'TZ','26','01','Arusha',NULL),(3644,'TZ','27','26','Manyara',NULL),(3645,'UA','01','71','Cherkas\'ka Oblast\'',309),(3646,'UA','02','74','Chernihivs\'ka Oblast\'',309),(3647,'UA','03','77','Chernivets\'ka Oblast\'',310),(3648,'UA','04','12','Dnipropetrovs\'ka Oblast\'',311),(3649,'UA','05','14','Donets\'ka Oblast\'',311),(3650,'UA','06','26','Ivano-Frankivs\'ka Oblast\'',310),(3651,'UA','07','63','Kharkivs\'ka Oblast\'',311),(3652,'UA','08','65','Khersons\'ka Oblast\'',312),(3653,'UA','09','68','Khmel\'nyts\'ka Oblast\'',309),(3654,'UA','10','35','Kirovohrads\'ka Oblast\'',311),(3655,'UA','11',NULL,'Krym',312),(3656,'UA','12',NULL,'Kyyiv',NULL),(3657,'UA','13',NULL,'Kyyivs\'ka Oblast\'',309),(3658,'UA','14','09','Luhans\'ka Oblast\'',311),(3659,'UA','15','46','L\'vivs\'ka Oblast\'',310),(3660,'UA','16',NULL,'Mykolayivs\'ka Oblast\'',311),(3661,'UA','17','51','Odes\'ka Oblast\'',312),(3662,'UA','18','53','Poltavs\'ka Oblast\'',311),(3663,'UA','19','56','Rivnens\'ka Oblast\'',309),(3664,'UA','20','40','Sevastopol\'',312),(3665,'UA','21','59','Sums\'ka Oblast\'',309),(3666,'UA','22','61','Ternopil\'s\'ka Oblast\'',310),(3667,'UA','23','05','Vinnyts\'ka Oblast\'',309),(3668,'UA','24','07','Volyns\'ka Oblast\'',310),(3669,'UA','25','21','Zakarpats\'ka Oblast\'',310),(3670,'UA','26','23','Zaporiz\'ka Oblast\'',311),(3671,'UA','27','18','Zhytomyrs\'ka Oblast\'',309),(3672,'UG','26','302','Apac',NULL),(3673,'UG','28','401','Bundibugyo',NULL),(3674,'UG','29','402','Bushenyi',NULL),(3675,'UG','30','304','Gulu',NULL),(3676,'UG','31','403','Hoima',NULL),(3677,'UG','33','204','Jinja',NULL),(3678,'UG','36','101','Kalangala',NULL),(3679,'UG','37','102','Kampala',NULL),(3680,'UG','38','205','Kamuli',NULL),(3681,'UG','39','206','Kapchorwa',NULL),(3682,'UG','40','406','Kasese',NULL),(3683,'UG','41',NULL,'Kibale',NULL),(3684,'UG','42','103','Kiboga',NULL),(3685,'UG','43','408','Kisoro',NULL),(3686,'UG','45','306','Kotido',NULL),(3687,'UG','46','208','Kumi',NULL),(3688,'UG','47','307','Lira',NULL),(3689,'UG','50','409','Masindi',NULL),(3690,'UG','52','410','Mbarara',NULL),(3691,'UG','56','107','Mubende',NULL),(3692,'UG','58','310','Nebbi',NULL),(3693,'UG','59','411','Ntungamo',NULL),(3694,'UG','60','210','Pallisa',NULL),(3695,'UG','61','110','Rakai',NULL),(3696,'UG','65','301','Adjumani',NULL),(3697,'UG','66','201','Bugiri',NULL),(3698,'UG','67','202','Busia',NULL),(3699,'UG','69','207','Katakwi',NULL),(3700,'UG','70','104','Luwero',NULL),(3701,'UG','71','105','Masaka',NULL),(3702,'UG','72','309','Moyo',NULL),(3703,'UG','73','109','Nakasongola',NULL),(3704,'UG','74','111','Sembabule',NULL),(3705,'UG','76','212','Tororo',NULL),(3706,'UG','77','303','Arua',NULL),(3707,'UG','78','203','Iganga',NULL),(3708,'UG','79','405','Kabarole',NULL),(3709,'UG','80','213','Kaberamaido',NULL),(3710,'UG','81','413','Kamwenge',NULL),(3711,'UG','82','414','Kanungu',NULL),(3712,'UG','83','112','Kayunga',NULL),(3713,'UG','84','305','Kitgum',NULL),(3714,'UG','85','415','Kyenjojo',NULL),(3715,'UG','86','214','Mayuge',NULL),(3716,'UG','87','209','Mbale',NULL),(3717,'UG','88','308','Moroto',NULL),(3718,'UG','89','106','Mpigi',NULL),(3719,'UG','90','108','Mukono',NULL),(3720,'UG','91','311','Nakapiripirit',NULL),(3721,'UG','92','312','Pader',NULL),(3722,'UG','93','412','Rukungiri',NULL),(3723,'UG','94','215','Sironko',NULL),(3724,'UG','95','211','Soroti',NULL),(3725,'UG','96','113','Wakiso',NULL),(3726,'UG','97','313','Yumbe',NULL),(3727,'US','01','AL','Alabama',313),(3728,'US','02','AK','Alaska',314),(3729,'US','04','AZ','Arizona',315),(3730,'US','05','AR','Arkansas',313),(3731,'US','06','CA','California',316),(3732,'US','08','CO','Colorado',317),(3733,'US','09','CT','Connecticut',318),(3734,'US','10','DE','Delaware',318),(3735,'US','11','DC','District of Columbia',318),(3736,'US','12','FL','Florida',318),(3737,'US','13','GA','Georgia',318),(3738,'US','15','HI','Hawaii',319),(3739,'US','16','ID','Idaho',317),(3740,'US','17','IL','Illinois',313),(3741,'US','18','IN','Indiana',320),(3742,'US','19','IA','Iowa',313),(3743,'US','20','KS','Kansas',313),(3744,'US','21','KY','Kentucky',318),(3745,'US','22','LA','Louisiana',313),(3746,'US','23','ME','Maine',318),(3747,'US','24','MD','Maryland',318),(3748,'US','25','MA','Massachusetts',318),(3749,'US','26','MI','Michigan',318),(3750,'US','27','MN','Minnesota',313),(3751,'US','28','MS','Mississippi',313),(3752,'US','29','MO','Missouri',313),(3753,'US','30','MT','Montana',317),(3754,'US','31','NE','Nebraska',313),(3755,'US','32','NV','Nevada',316),(3756,'US','33','NH','New Hampshire',318),(3757,'US','34','NJ','New Jersey',318),(3758,'US','35','NM','New Mexico',317),(3759,'US','36','NY','New York',318),(3760,'US','37','NC','North Carolina',318),(3761,'US','38','ND','North Dakota',313),(3762,'US','39','OH','Ohio',318),(3763,'US','40','OK','Oklahoma',313),(3764,'US','41','OR','Oregon',316),(3765,'US','42','PA','Pennsylvania',318),(3766,'US','44','RI','Rhode Island',318),(3767,'US','45','SC','South Carolina',318),(3768,'US','46','SD','South Dakota',313),(3769,'US','47','TN','Tennessee',313),(3770,'US','48','TX','Texas',313),(3771,'US','49','UT','Utah',317),(3772,'US','50','VT','Vermont',318),(3773,'US','51','VA','Virginia',318),(3774,'US','53','WA','Washington',316),(3775,'US','54','WV','West Virginia',318),(3776,'US','55','WI','Wisconsin',313),(3777,'US','56','WY','Wyoming',317),(3778,'UY','01','AR','Artigas',NULL),(3779,'UY','02',NULL,'Canelones',NULL),(3780,'UY','03',NULL,'Cerro Largo',NULL),(3781,'UY','04',NULL,'Colonia',NULL),(3782,'UY','05','DU','Durazno',NULL),(3783,'UY','06','FS','Flores',NULL),(3784,'UY','07','FD','Florida',NULL),(3785,'UY','08','LA','Lavalleja',NULL),(3786,'UY','09','MA','Maldonado',NULL),(3787,'UY','10','MO','Montevideo',NULL),(3788,'UY','11','PA','Paysandú',NULL),(3789,'UY','12','RN','Río Negro',NULL),(3790,'UY','13','RV','Rivera',NULL),(3791,'UY','14','RO','Rocha',NULL),(3792,'UY','15','SA','Salto',NULL),(3793,'UY','16','SJ','San José',NULL),(3794,'UY','17','SO','Soriano',NULL),(3795,'UY','18','TA','Tacuarembó',NULL),(3796,'UY','19','TT','Treinta y Tres',NULL),(3797,'UZ','01','AN','Andijon',321),(3798,'UZ','02','BU','Buxoro',322),(3799,'UZ','03','FA','Farg‘ona',321),(3800,'UZ','04',NULL,'Jizzakh',NULL),(3801,'UZ','05','XO','Xorazm',NULL),(3802,'UZ','06','NG','Namangan',321),(3803,'UZ','07','NW','Navoiy',322),(3804,'UZ','08','QA','Qashqadaryo',322),(3805,'UZ','09','QR','Qoraqalpog‘iston Respublikasi',322),(3806,'UZ','10','SA','Samarqand',322),(3807,'UZ','11',NULL,'Sirdaryo',NULL),(3808,'UZ','12','SU','Surxondaryo',322),(3809,'UZ','13','TK','Toshkent City',321),(3810,'UZ','14','TO','Toshkent',321),(3811,'VC','01','01','Charlotte',NULL),(3812,'VC','02','02','Saint Andrew',NULL),(3813,'VC','03','03','Saint David',NULL),(3814,'VC','04','04','Saint George',NULL),(3815,'VC','05','05','Saint Patrick',NULL),(3816,'VC','06','06','Grenadines',NULL),(3817,'VE','01','Z','Amazonas',NULL),(3818,'VE','02','B','Anzoátegui',NULL),(3819,'VE','03','C','Apure',NULL),(3820,'VE','04','D','Aragua',NULL),(3821,'VE','05','E','Barinas',NULL),(3822,'VE','06','F','Bolívar',NULL),(3823,'VE','07','G','Carabobo',NULL),(3824,'VE','08','H','Cojedes',NULL),(3825,'VE','09','Y','Delta Amacuro',NULL),(3826,'VE','11','I','Falcón',NULL),(3827,'VE','12','J','Guárico',NULL),(3828,'VE','13','K','Lara',NULL),(3829,'VE','14','L','Mérida',NULL),(3830,'VE','15','M','Miranda',NULL),(3831,'VE','16','N','Monagas',NULL),(3832,'VE','17','O','Nueva Esparta',NULL),(3833,'VE','18','P','Portuguesa',NULL),(3834,'VE','19','R','Sucre',NULL),(3835,'VE','20','S','Táchira',NULL),(3836,'VE','21','T','Trujillo',NULL),(3837,'VE','22','U','Yaracuy',NULL),(3838,'VE','23','V','Zulia',NULL),(3839,'VE','24','W','Dependencias Federales',NULL),(3840,'VE','25','A','Distrito Federal',NULL),(3841,'VE','26','X','Vargas',NULL),(3842,'VN','01','44','An Giang',NULL),(3843,'VN','03','50','Ben Tre',NULL),(3844,'VN','05','04','Cao Bang',NULL),(3845,'VN','09','45','Dong Thap',NULL),(3846,'VN','13',NULL,'Hai Phong',NULL),(3847,'VN','20',NULL,'Ho Chi Minh',NULL),(3848,'VN','21','47','Kien Giang',NULL),(3849,'VN','23','35','Lam Dong',NULL),(3850,'VN','24','41','Long An',NULL),(3851,'VN','30','13','Quang Ninh',NULL),(3852,'VN','32','05','Son La',NULL),(3853,'VN','33','37','Tay Ninh',NULL),(3854,'VN','34','21','Thanh Hoa',NULL),(3855,'VN','35','20','Thai Binh',NULL),(3856,'VN','37','46','Tien Giang',NULL),(3857,'VN','39','09','Lang Son',NULL),(3858,'VN','43',NULL,'An Giang',NULL),(3859,'VN','44','33','Dac Lac',NULL),(3860,'VN','45','39','Dong Nai',NULL),(3861,'VN','46',NULL,'Dong Thap',NULL),(3862,'VN','47',NULL,'Kien Giang',NULL),(3863,'VN','49',NULL,'Song Be',NULL),(3864,'VN','50',NULL,'Vinh Phu',NULL),(3865,'VN','51',NULL,'Ha Noi',NULL),(3866,'VN','52',NULL,'Ho Chi Minh',NULL),(3867,'VN','53',NULL,'Ba Ria-Vung Tau',NULL),(3868,'VN','54','31','Binh Dinh',NULL),(3869,'VN','55','40','Binh Thuan',NULL),(3870,'VN','58','03','Ha Giang',NULL),(3871,'VN','59','15','Ha Tay',NULL),(3872,'VN','60','23','Ha Tinh',NULL),(3873,'VN','61','14','Hoa Binh',NULL),(3874,'VN','62','34','Khanh Hoa',NULL),(3875,'VN','63','28','Kon Tum',NULL),(3876,'VN','64','25','Quang Tri',NULL),(3877,'VN','65',NULL,'Nam Ha',NULL),(3878,'VN','66','22','Nghe An',NULL),(3879,'VN','67','18','Ninh Binh',NULL),(3880,'VN','68','36','Ninh Thuan',NULL),(3881,'VN','69','32','Phu Yen',NULL),(3882,'VN','70','24','Quang Binh',NULL),(3883,'VN','71','29','Quang Ngai',NULL),(3884,'VN','72',NULL,'Quang Tri',NULL),(3885,'VN','73','52','Soc Trang',NULL),(3886,'VN','74',NULL,'Thua Thien',NULL),(3887,'VN','75','51','Tra Vinh',NULL),(3888,'VN','76','07','Tuyen Quang',NULL),(3889,'VN','77','49','Vinh Long',NULL),(3890,'VN','78',NULL,'Da Nang',NULL),(3891,'VN','79','61','Hai Duong',NULL),(3892,'VN','80','63','Ha Nam',NULL),(3893,'VN','81','66','Hung Yen',NULL),(3894,'VN','82','67','Nam Dinh',NULL),(3895,'VN','83','68','Phu Tho',NULL),(3896,'VN','84','27','Quang Nam',NULL),(3897,'VN','85','69','Thai Nguyen',NULL),(3898,'VN','86',NULL,'Vinh Puc Province',NULL),(3899,'VN','87','48','Can Tho',NULL),(3900,'VN','88',NULL,'Dak Lak',NULL),(3901,'VN','89','01','Lai Chau',NULL),(3902,'VN','90','02','Lao Cai',NULL),(3903,'VN','91','72','Dak Nong',NULL),(3904,'VN','92','71','Dien Bien',NULL),(3905,'VN','93','73','Hau Giang',NULL),(3906,'VU','05',NULL,'Ambrym',NULL),(3907,'VU','06',NULL,'Aoba',NULL),(3908,'VU','07','TOB','Torba',NULL),(3909,'VU','08',NULL,'Efate',NULL),(3910,'VU','09',NULL,'Epi',NULL),(3911,'VU','10',NULL,'Malakula',NULL),(3912,'VU','11',NULL,'Paama',NULL),(3913,'VU','12',NULL,'Pentecote',NULL),(3914,'VU','13','SAM','Sanma',NULL),(3915,'VU','14',NULL,'Shepherd',NULL),(3916,'VU','15','TAE','Taféa',NULL),(3917,'VU','16','MAP','Malampa',NULL),(3918,'VU','17','PAM','Pénama',NULL),(3919,'VU','18','SEE','Shéfa',NULL),(3920,'WS','02','AL','Aiga-i-le-Tai',NULL),(3921,'WS','03','AT','Atua',NULL),(3922,'WS','04',NULL,'Fa',NULL),(3923,'WS','05',NULL,'Gaga',NULL),(3924,'WS','06',NULL,'Va',NULL),(3925,'WS','07','GI','Gagaifomauga',NULL),(3926,'WS','08','PA','Palauli',NULL),(3927,'WS','09',NULL,'Satupa',NULL),(3928,'WS','10','TU','Tuamasaga',NULL),(3929,'WS','11','VS','Vaisigano',NULL),(3930,'YE','01','AB','Abyan',NULL),(3931,'YE','02',NULL,'Adan',NULL),(3932,'YE','03','MR','Al Mahrah',NULL),(3933,'YE','04','HD','Hadramawt',NULL),(3934,'YE','05','SH','Shabwah',NULL),(3935,'YE','06',NULL,'Lahij',NULL),(3936,'YE','07',NULL,'Al Bayda\'',NULL),(3937,'YE','08',NULL,'Al Hudaydah',NULL),(3938,'YE','09','JA','Al Jawf',NULL),(3939,'YE','10','MW','Al Mahwit',NULL),(3940,'YE','11','DH','Dhamar',NULL),(3941,'YE','12','HJ','Hajjah',NULL),(3942,'YE','13','IB','Ibb',NULL),(3943,'YE','14','MA','Ma\'rib',NULL),(3944,'YE','15',NULL,'Sa\'dah',NULL),(3945,'YE','16',NULL,'San\'a\'',NULL),(3946,'YE','17',NULL,'Taizz',NULL),(3947,'YE','18',NULL,'Ad Dali',NULL),(3948,'YE','19',NULL,'Amran',NULL),(3949,'YE','20',NULL,'Al Bayda\'',NULL),(3950,'YE','21',NULL,'Al Jawf',NULL),(3951,'YE','22',NULL,'Hajjah',NULL),(3952,'YE','23',NULL,'Ibb',NULL),(3953,'YE','24',NULL,'Lahij',NULL),(3954,'YE','25',NULL,'Taizz',NULL),(3955,'ZA','01',NULL,'North-Western Province',NULL),(3956,'ZA','02','NL','Kwazulu-Natal',NULL),(3957,'ZA','03','FS','Free State',NULL),(3958,'ZA','05','EC','Eastern Cape',NULL),(3959,'ZA','06','GT','Gauteng',NULL),(3960,'ZA','07','MP','Mpumalanga',NULL),(3961,'ZA','08','NC','Northern Cape',NULL),(3962,'ZA','09','LP','Limpopo',NULL),(3963,'ZA','10','NW','North-West',NULL),(3964,'ZA','11','WC','Western Cape',NULL),(3965,'ZM','01','01','Western',NULL),(3966,'ZM','02','02','Central',NULL),(3967,'ZM','03','03','Eastern',NULL),(3968,'ZM','04','04','Luapula',NULL),(3969,'ZM','05','05','Northern',NULL),(3970,'ZM','06','06','North-Western',NULL),(3971,'ZM','07','07','Southern',NULL),(3972,'ZM','08','08','Copperbelt',NULL),(3973,'ZM','09','09','Lusaka',NULL),(3974,'ZW','01','MA','Manicaland',NULL),(3975,'ZW','02','MI','Midlands',NULL),(3976,'ZW','03','MC','Mashonaland Central',NULL),(3977,'ZW','04','ME','Mashonaland East',NULL),(3978,'ZW','05','MW','Mashonaland West',NULL),(3979,'ZW','06','MN','Matabeleland North',NULL),(3980,'ZW','07','MS','Matabeleland South',NULL),(3981,'ZW','08','MV','Masvingo',NULL),(3982,'ZW','09','BU','Bulawayo',NULL),(3983,'ZW','10','HA','Harare',NULL);
/*!40000 ALTER TABLE `regions` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `timezones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `timezones` (
  `timezone_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `country_id` smallint(5) unsigned DEFAULT NULL,
  PRIMARY KEY (`timezone_id`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=329 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `timezones` WRITE;
/*!40000 ALTER TABLE `timezones` DISABLE KEYS */;
INSERT INTO `timezones` VALUES (1,'Europe/Andorra',1),(2,'Asia/Dubai',2),(3,'Asia/Kabul',3),(4,'America/Antigua',4),(5,'America/Anguilla',5),(6,'Europe/Tirane',6),(7,'Asia/Yerevan',7),(8,'Africa/Luanda',8),(9,'Pacific/Pago_Pago',11),(10,'Europe/Vienna',12),(11,'America/Aruba',14),(12,'Europe/Mariehamn',15),(13,'Asia/Baku',16),(14,'Europe/Sarajevo',17),(15,'America/Barbados',18),(16,'Asia/Dhaka',19),(17,'Europe/Brussels',20),(18,'Africa/Ouagadougou',21),(19,'Europe/Sofia',22),(20,'Asia/Bahrain',23),(21,'Africa/Bujumbura',24),(22,'Africa/Porto-Novo',25),(23,'America/St_Barthelemy',26),(24,'Atlantic/Bermuda',27),(25,'Asia/Brunei',28),(26,'America/La_Paz',29),(27,'America/Kralendijk',30),(28,'America/Nassau',32),(29,'Asia/Thimphu',33),(30,'Africa/Gaborone',35),(31,'Europe/Minsk',36),(32,'America/Belize',37),(33,'Indian/Cocos',39),(34,'Africa/Bangui',41),(35,'Africa/Brazzaville',42),(36,'Europe/Zurich',43),(37,'Africa/Abidjan',44),(38,'Pacific/Rarotonga',45),(39,'Africa/Douala',47),(40,'America/Bogota',49),(41,'America/Costa_Rica',50),(42,'America/Havana',51),(43,'Atlantic/Cape_Verde',52),(44,'America/Curacao',53),(45,'Indian/Christmas',54),(46,'Asia/Nicosia',55),(47,'Europe/Prague',56),(48,'Europe/Berlin',57),(49,'Africa/Djibouti',58),(50,'Europe/Copenhagen',59),(51,'America/Dominica',60),(52,'America/Santo_Domingo',61),(53,'Africa/Algiers',62),(54,'Europe/Tallinn',64),(55,'Africa/Cairo',65),(56,'Africa/El_Aaiun',66),(57,'Africa/Asmara',67),(58,'Africa/Addis_Ababa',69),(59,'Europe/Helsinki',71),(60,'Pacific/Fiji',72),(61,'Atlantic/Stanley',73),(62,'Atlantic/Faroe',75),(63,'Europe/Paris',76),(64,'Africa/Libreville',77),(65,'Europe/London',78),(66,'America/Grenada',79),(67,'Asia/Tbilisi',80),(68,'America/Cayenne',81),(69,'Europe/Guernsey',82),(70,'Africa/Accra',83),(71,'Europe/Gibraltar',84),(72,'Africa/Banjul',86),(73,'Africa/Conakry',87),(74,'America/Guadeloupe',88),(75,'Africa/Malabo',89),(76,'Europe/Athens',90),(77,'Atlantic/South_Georgia',91),(78,'America/Guatemala',92),(79,'Pacific/Guam',93),(80,'Africa/Bissau',94),(81,'America/Guyana',95),(82,'Asia/Hong_Kong',96),(83,'America/Tegucigalpa',98),(84,'Europe/Zagreb',99),(85,'America/Port-au-Prince',100),(86,'Europe/Budapest',101),(87,'Europe/Dublin',103),(88,'Asia/Jerusalem',104),(89,'Europe/Isle_of_Man',105),(90,'Asia/Kolkata',106),(91,'Indian/Chagos',107),(92,'Asia/Baghdad',108),(93,'Asia/Tehran',109),(94,'Atlantic/Reykjavik',110),(95,'Europe/Rome',111),(96,'Europe/Jersey',112),(97,'America/Jamaica',113),(98,'Asia/Amman',114),(99,'Asia/Tokyo',115),(100,'Africa/Nairobi',116),(101,'Asia/Bishkek',117),(102,'Asia/Phnom_Penh',118),(103,'Indian/Comoro',120),(104,'America/St_Kitts',121),(105,'Asia/Pyongyang',122),(106,'Asia/Seoul',123),(107,'Asia/Kuwait',124),(108,'America/Cayman',125),(109,'Asia/Vientiane',127),(110,'Asia/Beirut',128),(111,'America/St_Lucia',129),(112,'Europe/Vaduz',130),(113,'Asia/Colombo',131),(114,'Africa/Monrovia',132),(115,'Africa/Maseru',133),(116,'Europe/Vilnius',134),(117,'Europe/Luxembourg',135),(118,'Europe/Riga',136),(119,'Africa/Tripoli',137),(120,'Africa/Casablanca',138),(121,'Europe/Monaco',139),(122,'Europe/Chisinau',140),(123,'Europe/Podgorica',141),(124,'America/Marigot',142),(125,'Indian/Antananarivo',143),(126,'Europe/Skopje',145),(127,'Africa/Bamako',146),(128,'Asia/Rangoon',147),(129,'Asia/Macau',149),(130,'Pacific/Saipan',150),(131,'America/Martinique',151),(132,'Africa/Nouakchott',152),(133,'America/Montserrat',153),(134,'Europe/Malta',154),(135,'Indian/Mauritius',155),(136,'Indian/Maldives',156),(137,'Africa/Blantyre',157),(138,'Africa/Maputo',160),(139,'Africa/Windhoek',161),(140,'Pacific/Noumea',162),(141,'Africa/Niamey',163),(142,'Pacific/Norfolk',164),(143,'Africa/Lagos',165),(144,'America/Managua',166),(145,'Europe/Amsterdam',167),(146,'Europe/Oslo',168),(147,'Asia/Kathmandu',169),(148,'Pacific/Nauru',170),(149,'Pacific/Niue',171),(150,'Asia/Muscat',173),(151,'America/Panama',174),(152,'America/Lima',175),(153,'Pacific/Port_Moresby',177),(154,'Asia/Manila',178),(155,'Asia/Karachi',179),(156,'Europe/Warsaw',180),(157,'America/Miquelon',181),(158,'Pacific/Pitcairn',182),(159,'America/Puerto_Rico',183),(160,'Pacific/Palau',186),(161,'America/Asuncion',187),(162,'Asia/Qatar',188),(163,'Indian/Reunion',189),(164,'Europe/Bucharest',190),(165,'Europe/Belgrade',191),(166,'Africa/Kigali',193),(167,'Asia/Riyadh',194),(168,'Pacific/Guadalcanal',195),(169,'Indian/Mahe',196),(170,'Africa/Khartoum',197),(171,'Europe/Stockholm',198),(172,'Asia/Singapore',199),(173,'Atlantic/St_Helena',200),(174,'Europe/Ljubljana',201),(175,'Arctic/Longyearbyen',202),(176,'Europe/Bratislava',203),(177,'Africa/Freetown',204),(178,'Europe/San_Marino',205),(179,'Africa/Dakar',206),(180,'Africa/Mogadishu',207),(181,'America/Paramaribo',208),(182,'Africa/Juba',209),(183,'Africa/Sao_Tome',210),(184,'America/El_Salvador',211),(185,'America/Lower_Princes',212),(186,'Asia/Damascus',213),(187,'Africa/Mbabane',214),(188,'America/Grand_Turk',215),(189,'Africa/Ndjamena',216),(190,'Indian/Kerguelen',217),(191,'Africa/Lome',218),(192,'Asia/Bangkok',219),(193,'Asia/Dushanbe',220),(194,'Pacific/Fakaofo',221),(195,'Asia/Dili',222),(196,'Asia/Ashgabat',223),(197,'Africa/Tunis',224),(198,'Pacific/Tongatapu',225),(199,'Europe/Istanbul',226),(200,'America/Port_of_Spain',227),(201,'Pacific/Funafuti',228),(202,'Asia/Taipei',229),(203,'Africa/Dar_es_Salaam',230),(204,'Africa/Kampala',232),(205,'America/Montevideo',235),(206,'Europe/Vatican',237),(207,'America/St_Vincent',238),(208,'America/Caracas',239),(209,'America/Tortola',240),(210,'America/St_Thomas',241),(211,'Asia/Ho_Chi_Minh',242),(212,'Pacific/Efate',243),(213,'Pacific/Wallis',244),(214,'Pacific/Apia',245),(215,'Asia/Aden',246),(216,'Indian/Mayotte',247),(217,'Africa/Johannesburg',248),(218,'Africa/Lusaka',249),(219,'Africa/Harare',250),(220,'Antarctica/South_Pole',9),(221,'Pacific/Chuuk',74),(222,'Pacific/Wake',233),(223,'America/Argentina/Buenos_Aires',10),(224,'Australia/Sydney',13),(225,'Australia/Darwin',13),(226,'Australia/Brisbane',13),(227,'Australia/Adelaide',13),(228,'Australia/Hobart',13),(229,'Australia/Melbourne',13),(230,'Australia/Perth',13),(231,'America/Rio_Branco',31),(232,'America/Maceio',31),(233,'America/Sao_Paulo',31),(234,'America/Manaus',31),(235,'America/Bahia',31),(236,'America/Fortaleza',31),(237,'America/Campo_Grande',31),(238,'America/Belem',31),(239,'America/Cuiaba',31),(240,'America/Recife',31),(241,'America/Porto_Velho',31),(242,'America/Boa_Vista',31),(243,'America/Araguaina',31),(244,'America/Edmonton',38),(245,'America/Vancouver',38),(246,'America/Winnipeg',38),(247,'America/Halifax',38),(248,'America/St_Johns',38),(249,'America/Yellowknife',38),(250,'America/Rankin_Inlet',38),(251,'America/Toronto',38),(252,'America/Montreal',38),(253,'America/Regina',38),(254,'America/Whitehorse',38),(255,'Africa/Kinshasa',40),(256,'Africa/Lubumbashi',40),(257,'America/Santiago',46),(258,'Asia/Shanghai',48),(259,'Asia/Harbin',48),(260,'Asia/Chongqing',48),(261,'Asia/Urumqi',48),(262,'America/Guayaquil',63),(263,'Europe/Madrid',68),(264,'America/Thule',85),(265,'America/Godthab',85),(266,'Asia/Pontianak',102),(267,'Asia/Makassar',102),(268,'Asia/Jakarta',102),(269,'Asia/Jayapura',102),(270,'Pacific/Tarawa',119),(271,'Asia/Almaty',126),(272,'Asia/Qyzylorda',126),(273,'Asia/Aqtobe',126),(274,'Asia/Aqtau',126),(275,'Asia/Oral',126),(276,'Pacific/Majuro',144),(277,'Asia/Choibalsan',148),(278,'America/Mexico_City',158),(279,'America/Tijuana',158),(280,'America/Mazatlan',158),(281,'America/Chihuahua',158),(282,'America/Merida',158),(283,'America/Monterrey',158),(284,'America/Cancun',158),(285,'America/Hermosillo',158),(286,'America/Matamoros',158),(287,'Asia/Kuala_Lumpur',159),(288,'Asia/Kuching',159),(289,'Pacific/Auckland',172),(290,'Pacific/Marquesas',176),(291,'Asia/Gaza',184),(292,'Europe/Lisbon',185),(293,'Europe/Volgograd',192),(294,'Asia/Irkutsk',192),(295,'Asia/Novokuznetsk',192),(296,'Asia/Novosibirsk',192),(297,'Asia/Vladivostok',192),(298,'Europe/Moscow',192),(299,'Europe/Samara',192),(300,'Asia/Yekaterinburg',192),(301,'Asia/Anadyr',192),(302,'Asia/Krasnoyarsk',192),(303,'Europe/Kaliningrad',192),(304,'Asia/Kamchatka',192),(305,'Asia/Omsk',192),(306,'Asia/Magadan',192),(307,'Asia/Yakutsk',192),(308,'Asia/Sakhalin',192),(309,'Europe/Kiev',231),(310,'Europe/Uzhgorod',231),(311,'Europe/Zaporozhye',231),(312,'Europe/Simferopol',231),(313,'America/Chicago',234),(314,'America/Anchorage',234),(315,'America/Phoenix',234),(316,'America/Los_Angeles',234),(317,'America/Denver',234),(318,'America/New_York',234),(319,'Pacific/Honolulu',234),(320,'America/Indiana/Indianapolis',234),(321,'Asia/Tashkent',236),(322,'Asia/Samarkand',236),(323,'Pacific/Galapagos',63),(324,'Africa/Ceuta',68),(325,'Atlantic/Canary',68),(326,'Pacific/Chatham',172),(327,'Atlantic/Madeira',185),(328,'Atlantic/Azores',185);
/*!40000 ALTER TABLE `timezones` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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