text: -- MySQL dump 10.13  Distrib 5.6.35, for osx10.9 (x86_64)
  --
  -- Host: localhost    Database: Quickadclassified
  -- ------------------------------------------------------
  -- Server version	5.6.35
  
  /*!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 */;
  
  --
  -- Dumping data for table `<<prefix>>subadmin1`
  --
  
  /*!40000 ALTER TABLE `<<prefix>>subadmin1` DISABLE KEYS */;
  INSERT INTO `<<prefix>>subadmin1` VALUES (3243,'SO.20','SO','Woqooyi Galbeed','Woqooyi Galbeed',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3244,'SO.19','SO','Togdheer','Togdheer',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3245,'SO.14','SO','Lower Shabeelle','Lower Shabeelle',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3246,'SO.13','SO','Middle Shabele','Middle Shabele',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3247,'SO.12','SO','Sanaag','Sanaag',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3248,'SO.18','SO','Nugaal','Nugaal',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3249,'SO.10','SO','Mudug','Mudug',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3250,'SO.09','SO','Lower Juba','Lower Juba',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3251,'SO.08','SO','Middle Juba','Middle Juba',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3252,'SO.07','SO','Hiiraan','Hiiraan',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3253,'SO.06','SO','Gedo','Gedo',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3254,'SO.05','SO','Galguduud','Galguduud',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3255,'SO.04','SO','Bay','Bay',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3256,'SO.03','SO','Bari','Bari',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3257,'SO.02','SO','Banaadir','Banaadir',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3258,'SO.01','SO','Bakool','Bakool',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3259,'SO.21','SO','Awdal','Awdal',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3260,'SO.22','SO','Sool','Sool',1);
  /*!40000 ALTER TABLE `<<prefix>>subadmin1` ENABLE KEYS */;
  
  --
  -- Dumping data for table `<<prefix>>subadmin2`
  --
  
  /*!40000 ALTER TABLE `<<prefix>>subadmin2` DISABLE KEYS */;
  INSERT INTO `<<prefix>>subadmin2` VALUES (36114,'SO.09.65061','SO','SO.09','Degmada Badhaadhe','Degmada Badhaadhe',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36115,'SO.06.8261487','SO','SO.06','El Wak District','El Wak District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36116,'SO.10.9179613','SO','SO.10','Xarardheere','Xarardheere',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36117,'SO.21.9179614','SO','SO.21','Baki','Baki',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36118,'SO.04.9179615','SO','SO.04','Qansax Dheere','Qansax Dheere',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36119,'SO.21.9179616','SO','SO.21','Borama District','Borama District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36120,'SO.18.9179617','SO','SO.18','Burtinle','Burtinle',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36121,'SO.14.9179618','SO','SO.14','Baraawe','Baraawe',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36122,'SO.21.9179619','SO','SO.21','Lughaya District','Lughaya District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36123,'SO.18.9179620','SO','SO.18','Eyl','Eyl',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36124,'SO.02.9179621','SO','SO.02','Banadir','Banadir',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36125,'SO.14.9179622','SO','SO.14','Kurtunwaarey','Kurtunwaarey',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36126,'SO.21.9179623','SO','SO.21','Zeila District','Zeila District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36127,'SO.18.9179624','SO','SO.18','Garoowe','Garoowe',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36128,'SO.14.9179625','SO','SO.14','Marka','Marka',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36129,'SO.05.9179626','SO','SO.05','Cabudwaaq','Cabudwaaq',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36130,'SO.01.9179627','SO','SO.01','Ceel Barde','Ceel Barde',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36131,'SO.12.9179628','SO','SO.12','Laasqoray','Laasqoray',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36132,'SO.14.9179629','SO','SO.14','Qoryooley','Qoryooley',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36133,'SO.01.9179630','SO','SO.01','Rab Dhuure','Rab Dhuure',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36134,'SO.10.9179631','SO','SO.10','Cadaado','Cadaado',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36135,'SO.12.9179632','SO','SO.12','Ceel Afweyn','Ceel Afweyn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36136,'SO.14.9179633','SO','SO.14','Sablaale','Sablaale',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36137,'SO.01.9179634','SO','SO.01','Tayeeglow','Tayeeglow',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36138,'SO.14.9179635','SO','SO.14','Wanla Weyn','Wanla Weyn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36139,'SO.12.9179636','SO','SO.12','Ceerigaabo','Ceerigaabo',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36140,'SO.01.9179637','SO','SO.01','Waajid','Waajid',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36141,'SO.08.9179638','SO','SO.08','Bu\'aale','Bu\'aale',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36142,'SO.22.9179639','SO','SO.22','Caynabo','Caynabo',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36143,'SO.01.9179640','SO','SO.01','Xudur','Xudur',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36144,'SO.05.9179641','SO','SO.05','Ceel Buur','Ceel Buur',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36145,'SO.08.9179642','SO','SO.08','Jilib','Jilib',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36146,'SO.22.9179643','SO','SO.22','Laas Caanood','Laas Caanood',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36147,'SO.03.9179644','SO','SO.03','Bandarbeyla','Bandarbeyla',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36148,'SO.08.9179645','SO','SO.08','Saakow','Saakow',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36149,'SO.05.9179646','SO','SO.05','Ceel Dheer','Ceel Dheer',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36150,'SO.22.9179647','SO','SO.22','Taleh District','Taleh District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36151,'SO.13.9179649','SO','SO.13','Adan Yabaal','Adan Yabaal',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36152,'SO.05.9179650','SO','SO.05','Dhuusamarreeb','Dhuusamarreeb',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36153,'SO.13.9179651','SO','SO.13','Balcad','Balcad',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36154,'SO.22.9179652','SO','SO.22','Xudun District','Xudun District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36155,'SO.03.9179653','SO','SO.03','Caluula','Caluula',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36156,'SO.13.9179654','SO','SO.13','Cadale','Cadale',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36157,'SO.08.9179655','SO','SO.08','Baardheere','Baardheere',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36158,'SO.19.9179656','SO','SO.19','Burao','Burao',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36159,'SO.03.9179657','SO','SO.03','Iskushuban','Iskushuban',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36160,'SO.13.9179658','SO','SO.13','Jowhar','Jowhar',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36161,'SO.19.9179659','SO','SO.19','Buuhoodle','Buuhoodle',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36162,'SO.06.9179660','SO','SO.06','Belet Xaawo','Belet Xaawo',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36163,'SO.10.9179661','SO','SO.10','Gaalkacyo','Gaalkacyo',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36164,'SO.03.9179662','SO','SO.03','Qandala','Qandala',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36165,'SO.19.9179663','SO','SO.19','Owdweyne','Owdweyne',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36166,'SO.06.9179664','SO','SO.06','Doolow','Doolow',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36167,'SO.19.9179665','SO','SO.19','Sheikh','Sheikh',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36168,'SO.03.9179666','SO','SO.03','Qardho','Qardho',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36169,'SO.10.9179667','SO','SO.10','Galdogob','Galdogob',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36170,'SO.06.9179668','SO','SO.06','Garbahaarey','Garbahaarey',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36171,'SO.20.9179669','SO','SO.20','Berbera','Berbera',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36172,'SO.10.9179670','SO','SO.10','Hobyo','Hobyo',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36173,'SO.04.9179671','SO','SO.04','Baydhaba','Baydhaba',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36174,'SO.20.9179672','SO','SO.20','Gebiley','Gebiley',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36175,'SO.06.9179673','SO','SO.06','Luuq','Luuq',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36176,'SO.10.9179674','SO','SO.10','Jariiban','Jariiban',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36177,'SO.20.9179675','SO','SO.20','Hargeysa','Hargeysa',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36178,'SO.04.9179676','SO','SO.04','Buur Hakaba','Buur Hakaba',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36179,'SO.04.9179677','SO','SO.04','Diinsoor','Diinsoor',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36180,'SO.07.9179678','SO','SO.07','Belet Weyne','Belet Weyne',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36181,'SO.07.9179679','SO','SO.07','Bulo Burto','Bulo Burto',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36182,'SO.07.9179680','SO','SO.07','Jalalaqsi','Jalalaqsi',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36183,'SO.09.9179681','SO','SO.09','Afmadow','Afmadow',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36184,'SO.09.9179682','SO','SO.09','Jamaame','Jamaame',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36185,'SO.09.9179683','SO','SO.09','Kismaayo','Kismaayo',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36186,'SO.14.9179684','SO','SO.14','Afgooye','Afgooye',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36187,'SO.03.9179981','SO','SO.03','Armo','Armo',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36188,'SO.05.9179982','SO','SO.05','Adado','Adado',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36189,'SO.14.9179984','SO','SO.14','Darkenley','Darkenley',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36190,'SO.09.9179985','SO','SO.09','Jamame','Jamame',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36191,'SO.04.9179986','SO','SO.04','Baidoa','Baidoa',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36192,'SO.01.9179988','SO','SO.01','Hudur','Hudur',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36193,'SO.12.9179989','SO','SO.12','Elafweyn','Elafweyn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36194,'SO.04.9179993','SO','SO.04','Dinsoor District','Dinsoor District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36195,'SO.10.9180000','SO','SO.10','Xarfo District','Xarfo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36196,'SO.12.9180002','SO','SO.12','Badhan District','Badhan District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36197,'SO.07.9180005','SO','SO.07','Beledweyne District','Beledweyne District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36198,'SO.05.9180013','SO','SO.05','Ceelbuur','Ceelbuur',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36199,'SO.06.9180014','SO','SO.06','Bula Hawa','Bula Hawa',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36200,'SO.02.9180017','SO','SO.02','Hodan','Hodan',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36201,'SO.03.9180027','SO','SO.03','Bossaso','Bossaso',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36202,'SO.04.9180028','SO','SO.04','Burdhubo','Burdhubo',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36203,'SO.02.9180039','SO','SO.02','Daynile','Daynile',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (36204,'SO.21.9259236','SO','SO.21','Diila District','Diila District',1);
  /*!40000 ALTER TABLE `<<prefix>>subadmin2` ENABLE KEYS */;
  
  --
  -- Dumping data for table `<<prefix>>cities`
  --
  
  /*!40000 ALTER TABLE `<<prefix>>cities` DISABLE KEYS */;
  INSERT INTO `<<prefix>>cities` VALUES (49593,'SO','Yeed','Yeed',4.55,43.0333,'P','PPL','SO.01',NULL,8429,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (49747,'SO','Xuddur','Xuddur',4.12129,43.8895,'P','PPLA','SO.01',NULL,12500,'Africa/Mogadishu',1,'2013-08-05 23:00:00','2013-08-05 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (50672,'SO','Wanlaweyn','Wanlaweyn',2.6185,44.8938,'P','PPL','SO.14',NULL,22022,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (50814,'SO','Waajid','Waajid',3.80958,43.2463,'P','PPL','SO.01',NULL,6666,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (52381,'SO','Saacow','Saacow',1.62794,42.4407,'P','PPL','SO.08',NULL,7893,'Africa/Mogadishu',1,'2012-02-27 23:00:00','2012-02-27 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (52867,'SO','Qoryooley','Qoryooley',1.78784,44.53,'P','PPLA2','SO.14',NULL,51720,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (53157,'SO','Qandala','Qandala',11.472,49.8728,'P','PPL','SO.03',NULL,15923,'Africa/Mogadishu',1,'2017-02-09 23:00:00','2017-02-09 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (53372,'SO','Oodweyne','Oodweyne',9.4092,45.064,'P','PPL','SO.19',NULL,5491,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (53654,'SO','Mogadishu','Mogadishu',2.03711,45.3438,'P','PPLC','SO.02',NULL,2587183,'Africa/Mogadishu',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (54225,'SO','Marka','Marka',1.71594,44.7717,'P','PPLA','SO.14',NULL,230100,'Africa/Mogadishu',1,'2014-05-27 23:00:00','2014-05-27 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (54460,'SO','Mahaddayweyne','Mahaddayweyne',2.9726,45.5347,'P','PPL','SO.13',NULL,8273,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (54715,'SO','Luuq','Luuq',3.80315,42.5442,'P','PPL','SO.06',NULL,33820,'Africa/Mogadishu',1,'2014-11-01 23:00:00','2014-11-01 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (55223,'SO','Las Khorey','Las Khorey',11.1595,48.1967,'P','PPLA2','SO.12',NULL,6941,'Africa/Mogadishu',1,'2013-11-09 23:00:00','2013-11-09 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (55671,'SO','Kismayo','Kismayo',-0.35817,42.5454,'P','PPLA','SO.09',NULL,234852,'Africa/Mogadishu',1,'2014-05-31 23:00:00','2014-05-31 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (56166,'SO','Jilib','Jilib',0.48829,42.7854,'P','PPL','SO.08',NULL,43694,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (56335,'SO','Jawhar','Jawhar',2.78087,45.5005,'P','PPLA','SO.13',NULL,47086,'Africa/Mogadishu',1,'2015-11-09 23:00:00','2015-11-09 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (56399,'SO','Jamaame','Jamaame',0.06968,42.745,'P','PPL','SO.09',NULL,185270,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (56414,'SO','Jalalaqsi','Jalalaqsi',3.3766,45.5996,'P','PPL','SO.07',NULL,9743,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (56505,'SO','Iskushuban','Iskushuban',10.2837,50.23,'P','PPL','SO.03',NULL,5759,'Africa/Mogadishu',1,'2016-12-02 23:00:00','2016-12-02 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (57000,'SO','Hobyo','Hobyo',5.3505,48.5268,'P','PPLA2','SO.10',NULL,12564,'Africa/Mogadishu',1,'2017-02-09 23:00:00','2017-02-09 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (57289,'SO','Hargeysa','Hargeysa',9.56,44.065,'P','PPLA','SO.20',NULL,477876,'Africa/Mogadishu',1,'2017-09-26 23:00:00','2017-09-26 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (58933,'SO','Garoowe','Garoowe',8.40207,48.4828,'P','PPLA','SO.18',NULL,57300,'Africa/Mogadishu',1,'2014-08-18 23:00:00','2014-08-18 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (58994,'SO','Garbahaarrey','Garbahaarrey',3.32892,42.2209,'P','PPLA','SO.06',NULL,12652,'Africa/Mogadishu',1,'2013-11-09 23:00:00','2013-11-09 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (59611,'SO','Gaalkacyo','Gaalkacyo',6.76972,47.4308,'P','PPLA','SO.10',NULL,61200,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (60019,'SO','Eyl','Eyl',7.9803,49.8164,'P','PPL','SO.18',NULL,18904,'Africa/Mogadishu',1,'2017-02-09 23:00:00','2017-02-09 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (60928,'SO','Dhuusamarreeb','Dhuusamarreeb',5.53597,46.3867,'P','PPLA','SO.05',NULL,9000,'Africa/Mogadishu',1,'2017-11-16 23:00:00','2017-11-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (62691,'SO','Ceerigaabo','Ceerigaabo',10.6162,47.368,'P','PPLA','SO.12',NULL,33853,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (62788,'SO','Ceeldheer','Ceeldheer',3.84878,47.1806,'P','PPL','SO.05',NULL,26562,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (62821,'SO','Ceelbuur','Ceelbuur',4.68501,46.6176,'P','PPL','SO.05',NULL,9031,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (63081,'SO','Caluula','Caluula',11.9661,50.7569,'P','PPLA2','SO.03','SO.03.9179653',6100,'Africa/Mogadishu',1,'2017-03-30 23:00:00','2017-03-30 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (63344,'SO','Cadale','Cadale',2.7603,46.3222,'P','PPL','SO.13',NULL,5385,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (63571,'SO','Buurhakaba','Buurhakaba',2.80257,44.078,'P','PPLA2','SO.04',NULL,27792,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (63689,'SO','Buulobarde','Buulobarde',3.85375,45.5674,'P','PPL','SO.07',NULL,16928,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (63795,'SO','Burao','Burao',9.52213,45.5336,'P','PPLA','SO.19',NULL,99270,'Africa/Mogadishu',1,'2014-05-31 23:00:00','2014-05-31 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (63949,'SO','Bu’aale','Bu\'aale',1.08333,42.5833,'P','PPLA','SO.08',NULL,0,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (64013,'SO','Bosaso','Bosaso',11.2842,49.1816,'P','PPLA','SO.03',NULL,74287,'Africa/Mogadishu',1,'2015-04-23 23:00:00','2015-04-23 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (64412,'SO','Bereeda','Bereeda',11.8704,51.0579,'P','PPL','SO.03',NULL,11262,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (64435,'SO','Berbera','Berbera',10.4396,45.0143,'P','PPL','SO.20',NULL,242344,'Africa/Mogadishu',1,'2014-07-11 23:00:00','2014-07-11 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (64460,'SO','Beledweyne','Beledweyne',4.73583,45.2036,'P','PPLA','SO.07',NULL,55410,'Africa/Mogadishu',1,'2017-04-01 23:00:00','2017-04-01 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (64536,'SO','Baidoa','Baidoa',3.11383,43.6498,'P','PPLA','SO.04',NULL,129839,'Africa/Mogadishu',1,'2013-09-20 23:00:00','2013-09-20 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (64670,'SO','Bargaal','Bargaal',11.2864,51.0773,'P','PPL','SO.03',NULL,6798,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (64814,'SO','Bandarbeyla','Bandarbeyla',9.4942,50.8122,'P','PPL','SO.03',NULL,13753,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (65170,'SO','Baardheere','Baardheere',2.34464,42.2764,'P','PPLL','SO.06',NULL,42240,'Africa/Mogadishu',1,'2006-01-26 23:00:00','2006-01-26 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (65785,'SO','Afgooye','Afgooye',2.1381,45.1212,'P','PPLA2','SO.14',NULL,65461,'Africa/Mogadishu',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (400769,'SO','Laascaanood','Laascaanood',8.47738,47.3597,'P','PPLA','SO.22',NULL,60100,'Africa/Mogadishu',1,'2012-01-18 23:00:00','2012-01-18 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (8045596,'SO','Baki','Baki',9.89206,43.3853,'P','PPLA','SO.21',NULL,20000,'Africa/Mogadishu',1,'2013-08-09 23:00:00','2013-08-09 23:00:00');
  /*!40000 ALTER TABLE `<<prefix>>cities` ENABLE KEYS */;
  /*!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 */;
  
  -- Dump completed
  