--
-- Host: localhost    Database: Quickadclassified
-- ------------------------------------------------------


--
-- Dumping data for table `<<prefix>>subadmin1`
--

INSERT INTO `<<prefix>>subadmin1` VALUES (480,'CD.31','CD','Tshuapa','Tshuapa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (481,'CD.30','CD','Tshopo','Tshopo',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (482,'CD.29','CD','Tanganika','Tanganika',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (483,'CD.12','CD','South Kivu','South Kivu',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (484,'CD.27','CD','Sankuru','Sankuru',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (485,'CD.11','CD','Nord Kivu','Nord Kivu',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (486,'CD.25','CD','Mongala','Mongala',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (487,'CD.10','CD','Maniema','Maniema',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (488,'CD.23','CD','Kasaï-Central','Kasai-Central',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (489,'CD.04','CD','Kasaï-Oriental','Kasai-Oriental',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (490,'CD.18','CD','Kasai','Kasai',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (491,'CD.17','CD','Ituri','Ituri',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (492,'CD.16','CD','Haut Uele','Haut Uele',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (493,'CD.15','CD','Haut-Lomani','Haut-Lomani',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (494,'CD.02','CD','Équateur','Equateur',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (495,'CD.13','CD','Bas Uele','Bas Uele',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (496,'CD.22','CD','Lualaba','Lualaba',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (497,'CD.24','CD','Mai Ndombe','Mai Ndombe',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (498,'CD.20','CD','Kwilu','Kwilu',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (499,'CD.19','CD','Kwango','Kwango',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (500,'CD.06','CD','Kinshasa','Kinshasa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (501,'CD.08','CD','Bas-Congo','Bas-Congo',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (502,'CD.14','CD','Haut-Katanga','Haut-Katanga',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (503,'CD.21','CD','Lomami','Lomami',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (504,'CD.26','CD','Nord-Ubangi','Nord-Ubangi',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (505,'CD.28','CD','Sud-Ubangi','Sud-Ubangi',1);

--
-- Dumping data for table `<<prefix>>subadmin2`
--

INSERT INTO `<<prefix>>subadmin2` VALUES (9004,'CD.04.209226','CD','CD.04','Mbuji-Mayi City','Mbuji-Mayi City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9005,'CD.11.211067','CD','CD.11','Lubero','Lubero',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9006,'CD.30.212726','CD','CD.30','Ville de Kisangani','Ville de Kisangani',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9007,'CD.04.19','CD','CD.04','Kabinda','Sous-Region du Kabinda',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9008,'CD.11.216279','CD','CD.11','Goma','Goma',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9009,'CD.11.219056','CD','CD.11','Beni','Beni',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9010,'CD.22.922772','CD','CD.22','Kolwezi City','Kolwezi City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9011,'CD.05.923173','CD','CD.05','Sous-Région du Haut-Shaba','Sous-Region du Haut-Shaba',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9012,'CD.02.2310762','CD','CD.02','Ville de Zongo','Ville de Zongo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9013,'CD.02.2312894','CD','CD.02','Ville de Mbandaka','Ville de Mbandaka',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9014,'CD.02.14','CD','CD.02','Equateur','Sous-Region de l\' Equateur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9015,'CD.08.2316119','CD','CD.08','Sous-Région des Catarates','Sous-Region des Catarates',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9016,'CD.08.2316701','CD','CD.08','Ville de Boma','Ville de Boma',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9017,'CD.08.2317281','CD','CD.08','Sous-Région du Bas-Fleuve','Sous-Region du Bas-Fleuve',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9018,'CD.15.15','CD','CD.15','Haut Lomami','Haut-Lomami',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9019,'CD.14.16','CD','CD.14','Haut Katanga','Haut-Katanga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9020,'CD.02.32','CD','CD.02','Nord Ubangi','Nord-Ubangi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9021,'CD.02.36','CD','CD.02','Sud Ubangi','Sud-Ubangi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9022,'CD.01.7731962','CD','CD.01','Plateaux','Plateaux',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9023,'CD.08.27','CD','CD.08','Lukaya','Lukaya',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9024,'CD.08.13','CD','CD.08','Cataractes District','Cataractes District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9025,'CD.08.10','CD','CD.08','Bas Fleuve District','Bas Fleuve District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9026,'CD.08.7731981','CD','CD.08','Matadi (city)','Matadi (city)',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9027,'CD.08.12','CD','CD.08','Boma (city)','Boma (city)',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9028,'CD.09.7910143','CD','CD.09','Tumba','Tumba',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9029,'CD.05.23','CD','CD.05','Kolwezi','Kolwezi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9030,'CD.11.33','CD','CD.11','North Kivu','North Kivu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9031,'CD.10.30','CD','CD.10','Maniema','Maniema',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9032,'CD.04.38','CD','CD.04','Tshilenge District','Tshilenge District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9033,'CD.12.35','CD','CD.12','South Kivu','South Kivu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9034,'CD.06.22','CD','CD.06','Kinshasa rural','Kinshasa rural',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9035,'CD.06.21','CD','CD.06','Kinshasa Urban','Kinshasa Urban',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9036,'CD.11.8260598','CD','CD.11','Nyirangongo','Nyirangongo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9037,'CD.11.8260604','CD','CD.11','Butembo','Butembo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9038,'CD.11.8260605','CD','CD.11','Oicha','Oicha',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9039,'CD.03.8335010','CD','CD.03','Kananga City','Kananga City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9040,'CD.18.8335011','CD','CD.18','Tshikapa City','Tshikapa City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9041,'CD.05.9165800','CD','CD.05','Lubumbashi (city)','Lubumbashi (city)',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9042,'CD.06.9166122','CD','CD.06','Lukunga District','Lukunga District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9043,'CD.06.9166123','CD','CD.06','Tshangu District','Tshangu District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9044,'CD.05.9179186','CD','CD.05','Kalemie Ville','Kalemie Ville',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9045,'CD.05.9179188','CD','CD.05','Kipushi Ville','Kipushi Ville',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9046,'CD.05.9179189','CD','CD.05','Kongolo Ville','Kongolo Ville',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9047,'CD.05.9179191','CD','CD.05','Kambove Ville','Kambove Ville',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9048,'CD.05.9179195','CD','CD.05','Likasi','Likasi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9049,'CD.12.9179197','CD','CD.12','Bukavu','Bukavu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9050,'CD.06.9179198','CD','CD.06','Makala District','Makala District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9051,'CD.05.9179199','CD','CD.05','Mutumba District','Mutumba District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9052,'CD.03.9179202','CD','CD.03','Mutumba District','Mutumba District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9053,'CD.12.9179463','CD','CD.12','Kalehe','Kalehe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9054,'CD.10.9179465','CD','CD.10','Maniema','Maniema',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9055,'CD.12.9179476','CD','CD.12','Mwenga','Mwenga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9056,'CD.12.9179483','CD','CD.12','Fizi','Fizi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9057,'CD.12.9179531','CD','CD.12','Kabare','Kabare',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9058,'CD.11.9179534','CD','CD.11','Masisi Territory','Masisi Territory',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9059,'CD.11.9179537','CD','CD.11','Rutshuru Territory','Rutshuru Territory',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9060,'CD.05.9179562','CD','CD.05','Kasaji','Kasaji',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9061,'CD.23.9179898','CD','CD.23','Ville de Kananga','Ville de Kananga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9062,'CD.05.9179907','CD','CD.05','Manono','Manono',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9063,'CD.02.9212657','CD','CD.02','Akula','Akula',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9064,'CD.02.10376945','CD','CD.02','Tshuapa District','Tshuapa District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9065,'CD.06.10400552','CD','CD.06','Funa','Funa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9066,'CD.02.10402604','CD','CD.02','Nord-Ubangi District','Nord-Ubangi District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9067,'CD.06.10861174','CD','CD.06','Mont Amba District','Mont Amba District',1);

--
-- Dumping data for table `<<prefix>>cities`
--

INSERT INTO `<<prefix>>cities` VALUES (203717,'CD','Yangambi','Yangambi',0.76755,24.4397,'P','PPL','CD.30',NULL,35531,'Africa/Lubumbashi',1,'2016-11-28 23:00:00','2016-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (204283,'CD','Watsa','Watsa',3.03716,29.5355,'P','PPL','CD.16',NULL,24516,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (204318,'CD','Wamba','Wamba',2.14838,27.9947,'P','PPL','CD.16',NULL,17373,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (204405,'CD','Uvira','Uvira',-3.39534,29.1378,'P','PPL','CD.12',NULL,170391,'Africa/Lubumbashi',1,'2012-12-04 23:00:00','2012-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (204953,'CD','Tshikapa','Tshikapa',-6.41621,20.7999,'P','PPLA2','CD.18','CD.18.8335011',267462,'Africa/Lubumbashi',1,'2016-11-27 23:00:00','2016-11-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (205970,'CD','Sake','Sake',-1.57386,29.0434,'P','PPL','CD.11',NULL,17151,'Africa/Lubumbashi',1,'2012-12-04 23:00:00','2012-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (207570,'CD','Mwene-Ditu','Mwene-Ditu',-7.00906,23.4528,'P','PPL','CD.21',NULL,189177,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (207596,'CD','Mweka','Mweka',-4.85187,21.5595,'P','PPL','CD.18',NULL,50675,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (209228,'CD','Mbuji-Mayi','Mbuji-Mayi',-6.13603,23.5898,'P','PPLA','CD.04',NULL,874761,'Africa/Lubumbashi',1,'2012-06-10 23:00:00','2012-06-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (210379,'CD','Lusambo','Lusambo',-4.97503,23.4439,'P','PPLA','CD.27',NULL,41416,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (210939,'CD','Luebo','Luebo',-5.35218,21.4219,'P','PPLA','CD.18',NULL,35183,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (211098,'CD','Lubao','Lubao',-5.38771,25.7488,'P','PPL','CD.21',NULL,43068,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (211647,'CD','Lodja','Lodja',-3.52105,23.6005,'P','PPL','CD.27',NULL,68244,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (211734,'CD','Lisala','Lisala',2.15127,21.5167,'P','PPL','CD.02',NULL,70087,'Africa/Kinshasa',1,'2012-05-30 23:00:00','2012-05-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (212360,'CD','Kongolo','Kongolo',-5.38532,27.0003,'P','PPL','CD.29',NULL,31943,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (212730,'CD','Kisangani','Kisangani',0.51528,25.191,'P','PPLA','CD.30',NULL,539158,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (212902,'CD','Kindu','Kindu',-2.94373,25.9224,'P','PPLA','CD.10',NULL,135698,'Africa/Lubumbashi',1,'2013-02-07 23:00:00','2013-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (213940,'CD','Kasongo','Kasongo',-4.42741,26.6666,'P','PPL','CD.10',NULL,55118,'Africa/Lubumbashi',1,'2012-04-04 23:00:00','2012-04-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (214481,'CD','Kananga','Kananga',-5.89624,22.4166,'P','PPLA','CD.23','CD.23.9179898',463546,'Africa/Lubumbashi',1,'2016-12-30 23:00:00','2016-12-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (214575,'CD','Kampene','Kampene',-3.59678,26.6672,'P','PPL','CD.10',NULL,37034,'Africa/Lubumbashi',1,'2012-12-04 23:00:00','2012-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (214614,'CD','Kamina','Kamina',-8.73508,24.998,'P','PPLA','CD.15',NULL,73557,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (214974,'CD','Kalemie','Kalemie',-5.94749,29.1947,'P','PPL','CD.29',NULL,146974,'Africa/Lubumbashi',1,'2016-11-27 23:00:00','2016-11-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (215527,'CD','Kabinda','Kabinda',-6.13791,24.4818,'P','PPL','CD.04',NULL,59004,'Africa/Lubumbashi',1,'2013-06-08 23:00:00','2013-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (215605,'CD','Kabare','Kabare',-2.49682,28.7908,'P','PPL','CD.12',NULL,37034,'Africa/Lubumbashi',1,'2012-12-04 23:00:00','2012-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (215668,'CD','Kabalo','Kabalo',-6.05255,26.9143,'P','PPL','CD.29',NULL,29833,'Africa/Lubumbashi',1,'2016-11-28 23:00:00','2016-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (215771,'CD','Isiro','Isiro',2.77391,27.616,'P','PPLA','CD.16',NULL,127076,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (215976,'CD','Ilebo','Ilebo',-4.33111,20.5864,'P','PPL','CD.18',NULL,107093,'Africa/Lubumbashi',1,'2017-07-09 23:00:00','2017-07-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (216281,'CD','Goma','Goma',-1.67409,29.2285,'P','PPLA','CD.11',NULL,144124,'Africa/Lubumbashi',1,'2012-12-04 23:00:00','2012-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (216404,'CD','Gbadolite','Gbadolite',4.279,21.0028,'P','PPLA','CD.26',NULL,50493,'Africa/Kinshasa',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (216449,'CD','Gandajika','Gandajika',-6.74504,23.9533,'P','PPL','CD.04',NULL,154425,'Africa/Lubumbashi',1,'2015-01-06 23:00:00','2015-01-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (217389,'CD','Demba','Demba',-5.49573,22.2696,'P','PPL','CD.23',NULL,22263,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (217562,'CD','Butembo','Butembo',0.14164,29.2912,'P','PPLA3','CD.11','CD.11.33',154621,'Africa/Lubumbashi',1,'2013-01-01 23:00:00','2013-01-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (217570,'CD','Buta','Buta',2.78582,24.73,'P','PPLA','CD.13',NULL,50130,'Africa/Lubumbashi',1,'2017-07-09 23:00:00','2017-07-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (217637,'CD','Businga','Businga',3.33863,20.8858,'P','PPL','CD.26',NULL,28919,'Africa/Kinshasa',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (217695,'CD','Bunia','Bunia',1.55941,30.2522,'P','PPLA','CD.17',NULL,96764,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (217745,'CD','Bumba','Bumba',2.18771,22.4683,'P','PPL','CD.25',NULL,95520,'Africa/Kinshasa',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (217831,'CD','Bukavu','Bukavu',-2.49077,28.8428,'P','PPLA','CD.12',NULL,225389,'Africa/Lubumbashi',1,'2015-05-24 23:00:00','2015-05-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (217834,'CD','Bukama','Bukama',-9.20443,25.8547,'P','PPL','CD.15',NULL,38770,'Africa/Lubumbashi',1,'2016-11-28 23:00:00','2016-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (218253,'CD','Bondo','Bondo',3.81461,23.6866,'P','PPL','CD.13',NULL,17860,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (218680,'CD','Boende','Boende',-0.28163,20.8805,'P','PPLA','CD.31',NULL,32091,'Africa/Kinshasa',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (219057,'CD','Beni','Beni',0.49113,29.4731,'P','PPL','CD.11',NULL,89648,'Africa/Lubumbashi',1,'2012-06-04 23:00:00','2012-06-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (219414,'CD','Basoko','Basoko',1.23909,23.616,'P','PPL','CD.30',NULL,43709,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (220448,'CD','Aketi','Aketi',2.73877,23.7833,'P','PPL','CD.13',NULL,35161,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (922704,'CD','Lubumbashi','Lubumbashi',-11.6609,27.4794,'P','PPLA','CD.14',NULL,1373770,'Africa/Lubumbashi',1,'2016-11-22 23:00:00','2016-11-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (922741,'CD','Likasi','Likasi',-10.983,26.7384,'P','PPL','CD.14',NULL,422414,'Africa/Lubumbashi',1,'2016-11-27 23:00:00','2016-11-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (922773,'CD','Kolwezi','Kolwezi',-10.7148,25.4667,'P','PPLA2','CD.22','CD.22.922772',418000,'Africa/Lubumbashi',1,'2016-11-27 23:00:00','2016-11-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (922806,'CD','Kipushi','Kipushi',-11.761,27.2514,'P','PPL','CD.14',NULL,62332,'Africa/Lubumbashi',1,'2016-11-28 23:00:00','2016-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (923058,'CD','Kambove','Kambove',-10.8735,26.5975,'P','PPL','CD.14',NULL,36702,'Africa/Lubumbashi',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2311127,'CD','Tshela','Tshela',-4.99707,12.9484,'P','PPL','CD.08',NULL,38845,'Africa/Kinshasa',1,'2013-01-09 23:00:00','2013-01-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2311968,'CD','Nioki','Nioki',-2.72037,17.69,'P','PPL','CD.24',NULL,40695,'Africa/Kinshasa',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2312249,'CD','Mushie','Mushie',-3.01728,16.9224,'P','PPL','CD.24',NULL,33062,'Africa/Kinshasa',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2312393,'CD','Moanda','Moanda',-5.92753,12.3715,'P','PPL','CD.08',NULL,50000,'Africa/Kinshasa',1,'2017-08-31 23:00:00','2017-08-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2312888,'CD','Mbanza-Ngungu','Mbanza-Ngungu',-5.25837,14.8584,'P','PPL','CD.08',NULL,86356,'Africa/Kinshasa',1,'2012-06-04 23:00:00','2012-06-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2312895,'CD','Mbandaka','Mbandaka',0.04865,18.2603,'P','PPLA','CD.02','CD.02.2312894',184185,'Africa/Kinshasa',1,'2016-12-29 23:00:00','2016-12-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2313002,'CD','Matadi','Matadi',-5.83861,13.4631,'P','PPLA','CD.08',NULL,180109,'Africa/Kinshasa',1,'2017-01-03 23:00:00','2017-01-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2313084,'CD','Mangai','Mangai',-4.02328,19.5338,'P','PPL','CD.20',NULL,37188,'Africa/Kinshasa',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2313371,'CD','Lukolela','Lukolela',-1.06046,17.1821,'P','PPL','CD.02',NULL,15000,'Africa/Kinshasa',1,'2013-06-06 23:00:00','2013-06-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2313762,'CD','Libenge','Libenge',3.65332,18.6357,'P','PPL','CD.28',NULL,27053,'Africa/Kinshasa',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2314302,'CD','Kinshasa','Kinshasa',-4.32758,15.3136,'P','PPLC','CD.06',NULL,7785965,'Africa/Kinshasa',1,'2016-10-26 23:00:00','2016-10-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2314705,'CD','Kikwit','Kikwit',-5.04098,18.8162,'P','PPL','CD.20',NULL,186991,'Africa/Kinshasa',1,'2017-07-09 23:00:00','2017-07-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2315026,'CD','Kasongo-Lunda','Kasongo-Lunda',-6.47833,16.8174,'P','PPL','CD.19',NULL,20060,'Africa/Kinshasa',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2315057,'CD','Kasangulu','Kasangulu',-4.5833,15.1655,'P','PPL','CD.08',NULL,27961,'Africa/Kinshasa',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2315417,'CD','Inongo','Inongo',-1.9275,18.2881,'P','PPLA','CD.24',NULL,40113,'Africa/Kinshasa',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2315728,'CD','Gemena','Gemena',3.25651,19.7723,'P','PPL','CD.02',NULL,117639,'Africa/Kinshasa',1,'2012-04-04 23:00:00','2012-04-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2316259,'CD','Bulungu','Bulungu',-4.54437,18.6036,'P','PPL','CD.20',NULL,48344,'Africa/Kinshasa',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2316473,'CD','Bosobolo','Bosobolo',4.1898,19.8833,'P','PPL','CD.26',NULL,14553,'Africa/Kinshasa',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2316702,'CD','Boma','Boma',-5.85098,13.0536,'P','PPL','CD.08',NULL,162521,'Africa/Kinshasa',1,'2017-08-31 23:00:00','2017-08-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2316748,'CD','Bolobo','Bolobo',-2.158,16.2325,'P','PPL','CD.24',NULL,27862,'Africa/Kinshasa',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2317397,'CD','Bandundu','Bandundu',-3.31687,17.3806,'P','PPL','CD.20',NULL,118211,'Africa/Kinshasa',1,'2016-11-21 23:00:00','2016-11-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2593460,'CD','Masina','Masina',-4.38361,15.3914,'P','PPL','CD.06',NULL,485167,'Africa/Kinshasa',1,'2007-05-30 23:00:00','2007-05-30 23:00:00');


