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 (3937,'ZM.01','ZM','Western','Western',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3938,'ZM.07','ZM','Southern','Southern',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3939,'ZM.06','ZM','North-Western','North-Western',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3940,'ZM.05','ZM','Northern','Northern',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3941,'ZM.09','ZM','Lusaka','Lusaka',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3942,'ZM.04','ZM','Luapula','Luapula',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3943,'ZM.03','ZM','Eastern','Eastern',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3944,'ZM.08','ZM','Copperbelt','Copperbelt',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3945,'ZM.02','ZM','Central','Central',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3946,'ZM.10','ZM','Muchinga','Muchinga',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 (44312,'ZM.04.175497','ZM','ZM.04','Nchelenge District','Nchelenge District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44313,'ZM.05.175966','ZM','ZM.05','Mporokoso District','Mporokoso District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44314,'ZM.05.176143','ZM','ZM.05','Mbala District','Mbala District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44315,'ZM.04.176553','ZM','ZM.04','Kawambwa District','Kawambwa District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44316,'ZM.05.176756','ZM','ZM.05','Kaputa District','Kaputa District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44317,'ZM.06.895952','ZM','ZM.06','Zambezi District','Zambezi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44318,'ZM.06.897041','ZM','ZM.06','Solwezi District','Solwezi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44319,'ZM.01.898902','ZM','ZM.01','Sesheke District','Sesheke District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44320,'ZM.02.898909','ZM','ZM.02','Serenje District','Serenje District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44321,'ZM.01.898945','ZM','ZM.01','Senanga District','Senanga District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44322,'ZM.04.899273','ZM','ZM.04','Samfya District','Samfya District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44323,'ZM.03.899821','ZM','ZM.03','Petauke District','Petauke District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44324,'ZM.08.901339','ZM','ZM.08','Ndola Rural District','Ndola Rural District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44325,'ZM.08.901342','ZM','ZM.08','Ndola District','Ndola District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44326,'ZM.07.901764','ZM','ZM.07','Namwala District','Namwala District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44327,'ZM.06.902616','ZM','ZM.06','Mwinilunga District','Mwinilunga District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44328,'ZM.04.902718','ZM','ZM.04','Mwense District','Mwense District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44329,'ZM.02.904420','ZM','ZM.02','Mumbwa District','Mumbwa District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44330,'ZM.08.905389','ZM','ZM.08','Mufulira District','Mufulira District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44331,'ZM.10.905843','ZM','ZM.10','Mpika District','Mpika District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44332,'ZM.07.906042','ZM','ZM.07','Monze District','Monze District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44333,'ZM.01.906052','ZM','ZM.01','Mongu District','Mongu District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44334,'ZM.02.906219','ZM','ZM.02','Mkushi District','Mkushi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44335,'ZM.07.907108','ZM','ZM.07','Mazabuka District','Mazabuka District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44336,'ZM.04.907767','ZM','ZM.04','Mansa District','Mansa District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44337,'ZM.05.908911','ZM','ZM.05','Luwingu District','Luwingu District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44338,'ZM.09.909134','ZM','ZM.09','Lusaka District','Lusaka District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44339,'ZM.03.909296','ZM','ZM.03','Lundazi District','Lundazi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44340,'ZM.01.909482','ZM','ZM.01','Lukulu District','Lukulu District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44341,'ZM.08.909857','ZM','ZM.08','Luanshya District','Luanshya District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44342,'ZM.09.909886','ZM','ZM.09','Luangwa District','Luangwa District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44343,'ZM.07.910107','ZM','ZM.07','Livingstone District','Livingstone District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44344,'ZM.08.911144','ZM','ZM.08','Kitwe District','Kitwe District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44345,'ZM.03.912053','ZM','ZM.03','Katete District','Katete District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44346,'ZM.06.912623','ZM','ZM.06','Kasempa District','Kasempa District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44347,'ZM.05.912763','ZM','ZM.05','Kasama District','Kasama District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44348,'ZM.01.913321','ZM','ZM.01','Kaoma District','Kaoma District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44349,'ZM.08.914956','ZM','ZM.08','Kalulushi District','Kalulushi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44350,'ZM.07.915082','ZM','ZM.07','Kalomo District','Kalomo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44351,'ZM.01.915468','ZM','ZM.01','Kalabo District','Kalabo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44352,'ZM.02.916077','ZM','ZM.02','Kapiri Mposhi','Kapiri Mposhi',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44353,'ZM.02.916082','ZM','ZM.02','Kabwe District','Kabwe District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44354,'ZM.06.916244','ZM','ZM.06','Kabompo District','Kabompo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44355,'ZM.10.916666','ZM','ZM.10','Isoka District','Isoka District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44356,'ZM.07.917010','ZM','ZM.07','Gwembe District','Gwembe District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44357,'ZM.07.917743','ZM','ZM.07','Choma District','Choma District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44358,'ZM.03.918699','ZM','ZM.03','Chipata District','Chipata District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44359,'ZM.10.918903','ZM','ZM.10','Chinsali District','Chinsali District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44360,'ZM.08.919006','ZM','ZM.08','Chingola District','Chingola District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44361,'ZM.08.919540','ZM','ZM.08','Chililabombwe District','Chililabombwe District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44362,'ZM.10.920896','ZM','ZM.10','Chama District','Chama District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44363,'ZM.03.921026','ZM','ZM.03','Chadiza District','Chadiza District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44364,'ZM.07.7671219','ZM','ZM.07','Siavonga District','Siavonga District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44365,'ZM.09.7671220','ZM','ZM.09','Kafue district','Kafue district',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44366,'ZM.03.7732619','ZM','ZM.03','Nyimba District','Nyimba District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44367,'ZM.09.7910080','ZM','ZM.09','Chongwe District','Chongwe District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44368,'ZM.07.8260555','ZM','ZM.07','Kazungula District','Kazungula District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44369,'ZM.05.8260556','ZM','ZM.05','Mpulungu District','Mpulungu District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44370,'ZM.05.8260557','ZM','ZM.05','Mungwi District','Mungwi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44371,'ZM.02.8285556','ZM','ZM.02','Kapiri-Mposhi District','Kapiri-Mposhi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44372,'ZM.08.8285557','ZM','ZM.08','Masaiti District','Masaiti District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44373,'ZM.02.8714549','ZM','ZM.02','Chibombo District','Chibombo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44374,'ZM.07.8714550','ZM','ZM.07','Itezhi-Tezhi District','Itezhi-Tezhi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44375,'ZM.08.9072524','ZM','ZM.08','Mpongwe District','Mpongwe District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44376,'ZM.07.9072525','ZM','ZM.07','Sinazongwe District','Sinazongwe District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44377,'ZM.05.10800890','ZM','ZM.05','Chilubi','Chilubi',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44378,'ZM.04.10800891','ZM','ZM.04','Chienge','Chienge',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44379,'ZM.04.10800892','ZM','ZM.04','Milenge','Milenge',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44380,'ZM.03.10800895','ZM','ZM.03','Mambwe','Mambwe',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44381,'ZM.08.10801768','ZM','ZM.08','Lufwanyama','Lufwanyama',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44382,'ZM.06.10801775','ZM','ZM.06','Ikelenge','Ikelenge',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44383,'ZM.06.10801797','ZM','ZM.06','Chavuma','Chavuma',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44384,'ZM.06.10801798','ZM','ZM.06','Mufumbwe','Mufumbwe',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44385,'ZM.01.10801800','ZM','ZM.01','Shangombo','Shangombo',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44386,'ZM.06.10814730','ZM','ZM.06','Manyinga District','Manyinga District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44387,'ZM.01.10814741','ZM','ZM.01','Mitete District','Mitete District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44388,'ZM.01.10815319','ZM','ZM.01','Sikongo District','Sikongo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44389,'ZM.01.10815320','ZM','ZM.01','Limulunga District','Limulunga District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44390,'ZM.01.10815321','ZM','ZM.01','Nkeyema District','Nkeyema District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44391,'ZM.01.10815322','ZM','ZM.01','Luampa District','Luampa District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44392,'ZM.01.10815323','ZM','ZM.01','Nalolo District','Nalolo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44393,'ZM.01.10815324','ZM','ZM.01','Sioma District','Sioma District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44394,'ZM.01.10815325','ZM','ZM.01','Mulobezi District','Mulobezi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44395,'ZM.01.10815326','ZM','ZM.01','Mwandi District','Mwandi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44396,'ZM.07.10815849','ZM','ZM.07','Zimba District','Zimba District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44397,'ZM.07.10815850','ZM','ZM.07','Pemba District','Pemba District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44398,'ZM.07.10815851','ZM','ZM.07','Chikankata District','Chikankata District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44399,'ZM.09.10815852','ZM','ZM.09','Chirundu District','Chirundu District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44400,'ZM.09.10815853','ZM','ZM.09','Shibuyunji District','Shibuyunji District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44401,'ZM.09.10815854','ZM','ZM.09','Chilanga District','Chilanga District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44402,'ZM.09.10815855','ZM','ZM.09','Rufunsa District','Rufunsa District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44403,'ZM.02.10815856','ZM','ZM.02','Ngabwe District','Ngabwe District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44404,'ZM.02.10815857','ZM','ZM.02','Chisamba District','Chisamba District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44405,'ZM.02.10815858','ZM','ZM.02','Luano District','Luano District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44406,'ZM.02.10815859','ZM','ZM.02','Chitambo District','Chitambo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44407,'ZM.03.10815860','ZM','ZM.03','Sinda District','Sinda District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44408,'ZM.03.10815861','ZM','ZM.03','Vubwi District','Vubwi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44409,'ZM.04.10815862','ZM','ZM.04','Mwansabombwe District','Mwansabombwe District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44410,'ZM.04.10815863','ZM','ZM.04','Chipili District','Chipili District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44411,'ZM.04.10815864','ZM','ZM.04','Chembe District','Chembe District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44412,'ZM.04.10815865','ZM','ZM.04','Lunga District','Lunga District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44413,'ZM.05.10815866','ZM','ZM.05','Nsama District','Nsama District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44414,'ZM.10.11169206','ZM','ZM.10','Mafinga','Mafinga',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44415,'ZM.10.11169207','ZM','ZM.10','Nakonde','Nakonde',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (44416,'ZM.10.11169209','ZM','ZM.10','Shiwang’andu District','Shiwang\'andu 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 (175499,'ZM','Nchelenge','Nchelenge',-9.34506,28.734,'P','PPL','ZM.04',NULL,23693,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (175555,'ZM','Nakonde','Nakonde',-9.34213,32.745,'P','PPL','ZM.10',NULL,10652,'Africa/Lusaka',1,'2016-06-03 23:00:00','2016-06-03 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (175961,'ZM','Mpulungu','Mpulungu',-8.76234,31.114,'P','PPL','ZM.05',NULL,8547,'Africa/Lusaka',1,'2012-04-22 23:00:00','2012-04-22 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (176146,'ZM','Mbala','Mbala',-8.84024,31.3659,'P','PPL','ZM.05',NULL,20570,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (176555,'ZM','Kawambwa','Kawambwa',-9.7915,29.0791,'P','PPL','ZM.04',NULL,20589,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (895953,'ZM','Zambezi','Zambezi',-13.5432,23.1047,'P','PPL','ZM.06',NULL,7074,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (897045,'ZM','Solwezi','Solwezi',-12.1688,26.3894,'P','PPLA','ZM.06',NULL,4846,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (897456,'ZM','Sinazongwe','Sinazongwe',-17.2614,27.4618,'P','PPL','ZM.07',NULL,11528,'Africa/Lusaka',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (898188,'ZM','Siavonga','Siavonga',-16.5382,28.7088,'P','PPL','ZM.07',NULL,18638,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (898905,'ZM','Sesheke','Sesheke',-17.4759,24.2968,'P','PPL','ZM.01',NULL,20149,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (898912,'ZM','Serenje','Serenje',-13.2325,30.2352,'P','PPL','ZM.02',NULL,8779,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (898947,'ZM','Senanga','Senanga',-16.1167,23.2667,'P','PPL','ZM.01',NULL,10005,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (899274,'ZM','Samfya','Samfya',-11.3649,29.5565,'P','PPL','ZM.04',NULL,20470,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (899825,'ZM','Petauke','Petauke',-14.2412,31.3197,'P','PPL','ZM.03','ZM.03.899821',19296,'Africa/Lusaka',1,'2016-09-21 23:00:00','2016-09-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (901344,'ZM','Ndola','Ndola',-12.9587,28.6366,'P','PPLA','ZM.08',NULL,394518,'Africa/Lusaka',1,'2015-06-02 23:00:00','2015-06-02 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (902344,'ZM','Nakambala','Nakambala',-15.8324,27.7799,'P','PPL','ZM.07',NULL,10425,'Africa/Lusaka',1,'2011-03-05 23:00:00','2011-03-05 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (902620,'ZM','Mwinilunga','Mwinilunga',-11.7358,24.4293,'P','PPL','ZM.06',NULL,13798,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (904241,'ZM','Mungwi','Mungwi',-10.1732,31.3694,'P','PPL','ZM.05',NULL,6821,'Africa/Lusaka',1,'2011-03-05 23:00:00','2011-03-05 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (904422,'ZM','Mumbwa','Mumbwa',-14.9829,27.0619,'P','PPL','ZM.02',NULL,19086,'Africa/Lusaka',1,'2012-06-04 23:00:00','2012-06-04 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (905382,'ZM','Mufumbwe','Mufumbwe',-13.6833,24.8,'P','PPL','ZM.06',NULL,6155,'Africa/Lusaka',1,'2006-01-16 23:00:00','2006-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (905395,'ZM','Mufulira','Mufulira',-12.5498,28.2407,'P','PPL','ZM.08',NULL,120500,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (905789,'ZM','Mpongwe','Mpongwe',-13.5091,28.155,'P','PPL','ZM.08',NULL,8997,'Africa/Lusaka',1,'2011-04-17 23:00:00','2011-04-17 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (905846,'ZM','Mpika','Mpika',-11.8343,31.4529,'P','PPL','ZM.10',NULL,28445,'Africa/Lusaka',1,'2016-06-03 23:00:00','2016-06-03 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (906044,'ZM','Monze','Monze',-16.2833,27.4833,'P','PPL','ZM.07',NULL,30257,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (906054,'ZM','Mongu','Mongu',-15.2484,23.1274,'P','PPLA','ZM.01',NULL,52534,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (906221,'ZM','Mkushi','Mkushi',-13.6201,29.3939,'P','PPL','ZM.02',NULL,12306,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (907111,'ZM','Mazabuka','Mazabuka',-15.856,27.748,'P','PPL','ZM.07',NULL,64006,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (907770,'ZM','Mansa','Mansa',-11.1998,28.8943,'P','PPLA','ZM.04',NULL,42277,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (908718,'ZM','Maamba','Maamba',-17.3667,27.15,'P','PPL','ZM.07',NULL,12251,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (908913,'ZM','Luwingu','Luwingu',-10.2621,29.9271,'P','PPL','ZM.05',NULL,6161,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (909137,'ZM','Lusaka','Lusaka',-15.4067,28.2871,'P','PPLC','ZM.09',NULL,1267440,'Africa/Lusaka',1,'2011-10-26 23:00:00','2011-10-26 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (909299,'ZM','Lundazi','Lundazi',-12.2929,33.1782,'P','PPL','ZM.03',NULL,11635,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (909863,'ZM','Luanshya','Luanshya',-13.1367,28.4166,'P','PPL','ZM.08',NULL,113365,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (910111,'ZM','Livingstone','Livingstone',-17.8419,25.8542,'P','PPLA2','ZM.07','ZM.07.910107',109203,'Africa/Lusaka',1,'2016-06-02 23:00:00','2016-06-02 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (910361,'ZM','Limulunga','Limulunga',-15.0969,23.1376,'P','PPL','ZM.01',NULL,7461,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (911148,'ZM','Kitwe','Kitwe',-12.8024,28.2132,'P','PPL','ZM.08',NULL,400914,'Africa/Lusaka',1,'2012-06-19 23:00:00','2012-06-19 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (912226,'ZM','Kataba','Kataba',-11.8833,29.7833,'P','PPL','ZM.08',NULL,14000,'Africa/Lusaka',1,'2013-05-04 23:00:00','2013-05-04 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (912628,'ZM','Kasempa','Kasempa',-13.4584,25.8338,'P','PPL','ZM.06',NULL,5622,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (912764,'ZM','Kasama','Kasama',-10.2129,31.1808,'P','PPLA','ZM.05',NULL,91056,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (913029,'ZM','Kapiri Mposhi','Kapiri Mposhi',-13.9715,28.6698,'P','PPL','ZM.02',NULL,37942,'Africa/Lusaka',1,'2012-06-04 23:00:00','2012-06-04 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (913323,'ZM','Kaoma','Kaoma',-14.7833,24.8,'P','PPL','ZM.01',NULL,14212,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (913613,'ZM','Kansanshi','Kansanshi',-12.0951,26.4273,'P','PPL','ZM.06',NULL,40705,'Africa/Lusaka',1,'2011-10-26 23:00:00','2011-10-26 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (914959,'ZM','Kalulushi','Kalulushi',-12.8415,28.0948,'P','PPL','ZM.08',NULL,66575,'Africa/Lusaka',1,'2012-06-19 23:00:00','2012-06-19 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (915285,'ZM','Kalengwa','Kalengwa',-13.4659,25.0027,'P','PPL','ZM.06',NULL,7574,'Africa/Lusaka',1,'2011-03-05 23:00:00','2011-03-05 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (915471,'ZM','Kalabo','Kalabo',-14.9931,22.6793,'P','PPL','ZM.01',NULL,7731,'Africa/Lusaka',1,'2017-08-01 23:00:00','2017-08-01 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (915883,'ZM','Kafue','Kafue',-15.7691,28.1814,'P','PPL','ZM.09',NULL,47554,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (916095,'ZM','Kabwe','Kabwe',-14.4469,28.4464,'P','PPLA','ZM.02',NULL,188979,'Africa/Lusaka',1,'2011-10-19 23:00:00','2011-10-19 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (916246,'ZM','Kabompo','Kabompo',-13.5927,24.2008,'P','PPL','ZM.06',NULL,6592,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (916668,'ZM','Isoka','Isoka',-10.1606,32.6335,'P','PPL','ZM.10',NULL,13122,'Africa/Lusaka',1,'2016-06-03 23:00:00','2016-06-03 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (917688,'ZM','Chongwe','Chongwe',-15.3292,28.682,'P','PPL','ZM.09',NULL,6057,'Africa/Lusaka',1,'2011-03-05 23:00:00','2011-03-05 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (917748,'ZM','Choma','Choma',-16.8089,26.9875,'P','PPLA','ZM.07','ZM.07.917743',46746,'Africa/Lusaka',1,'2017-05-06 23:00:00','2017-05-06 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (918702,'ZM','Chipata','Chipata',-13.6333,32.65,'P','PPLA','ZM.03',NULL,85963,'Africa/Lusaka',1,'2015-06-02 23:00:00','2015-06-02 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (918905,'ZM','Chinsali','Chinsali',-10.5414,32.0816,'P','PPLA','ZM.10',NULL,14015,'Africa/Lusaka',1,'2016-06-02 23:00:00','2016-06-02 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (919009,'ZM','Chingola','Chingola',-12.529,27.8838,'P','PPLA2','ZM.08','ZM.08.919006',148564,'Africa/Lusaka',1,'2016-10-15 23:00:00','2016-10-15 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (919544,'ZM','Chililabombwe','Chililabombwe',-12.3647,27.8229,'P','PPL','ZM.08',NULL,57328,'Africa/Lusaka',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (920820,'ZM','Chambishi','Chambishi',-12.6325,28.0537,'P','PPL','ZM.08',NULL,11073,'Africa/Lusaka',1,'2011-10-19 23:00:00','2011-10-19 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
  