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


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

INSERT INTO `<<prefix>>subadmin1` VALUES (258,'BF.01','BF','Boucle du Mouhoun','Boucle du Mouhoun',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (259,'BF.02','BF','Cascades','Cascades',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (260,'BF.03','BF','Centre','Centre',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (261,'BF.04','BF','Centre-Est','Centre-Est',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (262,'BF.05','BF','Centre-Nord','Centre-Nord',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (263,'BF.06','BF','Centre-Ouest','Centre-Ouest',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (264,'BF.07','BF','Centre-Sud','Centre-Sud',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (265,'BF.08','BF','Est','Est',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (266,'BF.09','BF','Hauts-Bassins','Hauts-Bassins',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (267,'BF.10','BF','Nord','Nord',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (268,'BF.11','BF','Plateau-Central','Plateau-Central',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (269,'BF.12','BF','Sahel','Sahel',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (270,'BF.13','BF','Sud-Ouest','Sud-Ouest',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (2092,'BF.07.44','BF','BF.07','Zoundweogo Province','Zoundweogo Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2093,'BF.10.76','BF','BF.10','Province du Yatenga','Province du Yatenga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2094,'BF.08.42','BF','BF.08','Province de la Tapoa','Province de la Tapoa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2095,'BF.01.73','BF','BF.01','Province du Sourou','Province du Sourou',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2096,'BF.12.40','BF','BF.12','Province du Soum','Province du Soum',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2097,'BF.06.72','BF','BF.06','Province de la Sissili','Province de la Sissili',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2098,'BF.12.71','BF','BF.12','Province du Séno','Province du Seno',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2099,'BF.05.70','BF','BF.05','Province du Sanmatenga','Province du Sanmatenga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2100,'BF.06.36','BF','BF.06','Province du Sanguié','Province du Sanguie',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2101,'BF.13.69','BF','BF.13','Province du Poni','Province du Poni',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2102,'BF.10.34','BF','BF.10','Province du Passoré','Province du Passore',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2103,'BF.12.33','BF','BF.12','Province de l’Oudalan','Province de l\'Oudalan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2104,'BF.11.68','BF','BF.11','Province d’Oubritenga','Province d\'Oubritenga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2105,'BF.07.65','BF','BF.07','Nahouri Province','Nahouri Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2106,'BF.05.64','BF','BF.05','Province du Namentenga','Province du Namentenga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2107,'BF.01.63','BF','BF.01','Province du Mouhoun','Province du Mouhoun',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2108,'BF.04.28','BF','BF.04','Kouritenga Province','Kouritenga Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2109,'BF.01.58','BF','BF.01','Province de la Kossi','Province de la Kossi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2110,'BF.02.55','BF','BF.02','Province de la Comoé','Province de la Comoe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2111,'BF.09.54','BF','BF.09','Province du Kénédougou','Province du Kenedougou',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2112,'BF.03.53','BF','BF.03','Kadiogo Province','Kadiogo Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2113,'BF.09.51','BF','BF.09','Province du Houet','Province du Houet',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2114,'BF.08.50','BF','BF.08','Province du Gourma','Province du Gourma',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2115,'BF.08.21','BF','BF.08','Gnagna Province','Gnagna Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2116,'BF.11.20','BF','BF.11','Province du Ganzourgou','Province du Ganzourgou',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2117,'BF.06.19','BF','BF.06','Province du Boulkiemdé','Province du Boulkiemde',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2118,'BF.04.49','BF','BF.04','Province du Boulgou','Province du Boulgou',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2119,'BF.13.48','BF','BF.13','Province de la Bougouriba','Province de la Bougouriba',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2120,'BF.07.47','BF','BF.07','Bazega Province','Bazega Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2121,'BF.05.15','BF','BF.05','Province du Bam','Province du Bam',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2122,'BF.01.45','BF','BF.01','Province des Balé','Province des Bale',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2123,'BF.01.46','BF','BF.01','Province des Banwa','Province des Banwa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2124,'BF.13.52','BF','BF.13','Province du Ioba','Province du Ioba',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2125,'BF.08.56','BF','BF.08','Province de la Komandjoari','Province de la Komandjoari',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2126,'BF.08.57','BF','BF.08','Province de la Kompienga','Province de la Kompienga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2127,'BF.04.59','BF','BF.04','Province du Koulpélogo','Province du Koulpelogo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2128,'BF.11.60','BF','BF.11','Province du Kourwéogo','Province du Kourweogo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2129,'BF.02.61','BF','BF.02','Province de la Léraba','Province de la Leraba',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2130,'BF.10.62','BF','BF.10','Province du Loroum','Province du Loroum',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2131,'BF.01.66','BF','BF.01','Province du Nayala','Province du Nayala',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2132,'BF.13.67','BF','BF.13','Province du Noumbièl','Province du Noumbiel',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2133,'BF.09.74','BF','BF.09','Province du Tuy','Province du Tuy',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2134,'BF.12.75','BF','BF.12','Province du Yagha','Province du Yagha',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2135,'BF.06.77','BF','BF.06','Province du Ziro','Province du Ziro',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2136,'BF.10.78','BF','BF.10','Province du Zondoma','Province du Zondoma',1);

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

INSERT INTO `<<prefix>>cities` VALUES (2353197,'BF','Zorgo','Zorgo',12.2492,-0.61527,'P','PPLA2','BF.11','BF.11.20',23892,'Africa/Ouagadougou',1,'2013-02-07 23:00:00','2013-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2353257,'BF','Ziniaré','Ziniare',12.5819,-1.2971,'P','PPLA','BF.11','BF.11.68',12703,'Africa/Ouagadougou',1,'2013-02-07 23:00:00','2013-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2353688,'BF','Yako','Yako',12.9591,-2.26075,'P','PPLA2','BF.10','BF.10.34',22904,'Africa/Ouagadougou',1,'2013-02-07 23:00:00','2013-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2354176,'BF','Tougan','Tougan',13.0725,-3.0694,'P','PPLA2','BF.01','BF.01.73',17590,'Africa/Ouagadougou',1,'2012-06-04 23:00:00','2012-06-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2354265,'BF','Toma','Toma',12.7584,-2.89879,'P','PPLA2','BF.01','BF.01.66',12401,'Africa/Ouagadougou',1,'2013-02-07 23:00:00','2013-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2354349,'BF','Titao','Titao',13.7667,-2.06667,'P','PPLA2','BF.10','BF.10.62',19131,'Africa/Ouagadougou',1,'2010-08-01 23:00:00','2010-08-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2354675,'BF','Tenkodogo','Tenkodogo',11.78,-0.36972,'P','PPLA','BF.04','BF.04.49',37658,'Africa/Ouagadougou',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2355404,'BF','Salanso','Salanso',12.1742,-4.08477,'P','PPLA2','BF.01','BF.01.46',10385,'Africa/Ouagadougou',1,'2013-02-07 23:00:00','2013-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2356228,'BF','Réo','Reo',12.3196,-2.47094,'P','PPLA2','BF.06','BF.06.36',37535,'Africa/Ouagadougou',1,'2013-02-07 23:00:00','2013-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2356454,'BF','Pô','Po',11.1697,-1.145,'P','PPLA2','BF.07','BF.07.65',17924,'Africa/Ouagadougou',1,'2017-05-20 23:00:00','2017-05-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2356459,'BF','Pitmoaga','Pitmoaga',12.2397,-1.87667,'P','PPL','BF.06','BF.06.19',7991,'Africa/Ouagadougou',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2356738,'BF','Pama','Pama',11.2497,0.7075,'P','PPLA2','BF.08','BF.08.57',8902,'Africa/Ouagadougou',1,'2012-06-04 23:00:00','2012-06-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2357012,'BF','Ouargaye','Ouargaye',11.502,0.05886,'P','PPLA2','BF.04','BF.04.59',10103,'Africa/Ouagadougou',1,'2013-01-09 23:00:00','2013-01-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2357043,'BF','Ouahigouya','Ouahigouya',13.5828,-2.42158,'P','PPLA','BF.10','BF.10.76',61096,'Africa/Ouagadougou',1,'2010-08-09 23:00:00','2010-08-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2357048,'BF','Ouagadougou','Ouagadougou',12.3657,-1.53388,'P','PPLC','BF.03','BF.03.53',1086505,'Africa/Ouagadougou',1,'2015-06-02 23:00:00','2015-06-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2357163,'BF','Nouna','Nouna',12.7294,-3.86305,'P','PPLA2','BF.01','BF.01.58',29048,'Africa/Ouagadougou',1,'2013-02-07 23:00:00','2013-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2358100,'BF','Manga','Manga',11.6636,-1.07306,'P','PPLA','BF.07','BF.07.44',15173,'Africa/Ouagadougou',1,'2012-02-01 23:00:00','2012-02-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2358382,'BF','Léo','Leo',11.1003,-2.10654,'P','PPLA2','BF.06','BF.06.72',26884,'Africa/Ouagadougou',1,'2017-05-20 23:00:00','2017-05-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2358738,'BF','Koupéla','Koupela',12.1786,-0.35103,'P','PPLA2','BF.04','BF.04.28',32052,'Africa/Ouagadougou',1,'2013-02-07 23:00:00','2013-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2358946,'BF','Koudougou','Koudougou',12.2526,-2.36272,'P','PPLA','BF.06','BF.06.19',87347,'Africa/Ouagadougou',1,'2013-02-07 23:00:00','2013-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2359142,'BF','Kongoussi','Kongoussi',13.3258,-1.53472,'P','PPLA2','BF.05','BF.05.15',26338,'Africa/Ouagadougou',1,'2012-06-04 23:00:00','2012-06-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2359227,'BF','Kombissiri','Kombissiri',12.061,-1.33355,'P','PPLA2','BF.07','BF.07.47',30137,'Africa/Ouagadougou',1,'2013-02-07 23:00:00','2013-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2359317,'BF','Kokologo','Kokologo',12.1897,-1.88556,'P','PPL','BF.06','BF.06.19',25958,'Africa/Ouagadougou',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2359608,'BF','Kaya','Kaya',13.0917,-1.08444,'P','PPLA','BF.05','BF.05.70',39229,'Africa/Ouagadougou',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2360073,'BF','Houndé','Hounde',11.5,-3.51667,'P','PPLA2','BF.09','BF.09.74',36593,'Africa/Ouagadougou',1,'2012-06-04 23:00:00','2012-06-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2360238,'BF','Gourcy','Gourcy',13.2078,-2.35893,'P','PPLA2','BF.10','BF.10.78',16765,'Africa/Ouagadougou',1,'2012-06-04 23:00:00','2012-06-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2360286,'BF','Goulouré','Gouloure',12.2276,-1.92922,'P','PPL','BF.06','BF.06.19',6677,'Africa/Ouagadougou',1,'2013-02-07 23:00:00','2013-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2360372,'BF','Gorom-Gorom','Gorom-Gorom',14.4429,-0.23468,'P','PPLA2','BF.12','BF.12.33',6691,'Africa/Ouagadougou',1,'2013-09-05 23:00:00','2013-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2360615,'BF','Garango','Garango',11.8,-0.55056,'P','PPL','BF.04','BF.04.49',29076,'Africa/Ouagadougou',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2360886,'BF','Fada N\'gourma','Fada N\'gourma',12.0616,0.35843,'P','PPLA','BF.08','BF.08.50',33910,'Africa/Ouagadougou',1,'2013-05-17 23:00:00','2013-05-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2361082,'BF','Dori','Dori',14.0354,-0.0345,'P','PPLA','BF.12','BF.12.71',37806,'Africa/Ouagadougou',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2361177,'BF','Djibo','Djibo',14.0994,-1.62554,'P','PPLA2','BF.12','BF.12.40',22223,'Africa/Ouagadougou',1,'2012-12-04 23:00:00','2012-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2361342,'BF','Diébougou','Diebougou',10.9621,-3.24967,'P','PPLA2','BF.13','BF.13.48',12732,'Africa/Ouagadougou',1,'2017-05-20 23:00:00','2017-05-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2361373,'BF','Diapaga','Diapaga',12.073,1.78838,'P','PPLA2','BF.08','BF.08.42',26013,'Africa/Ouagadougou',1,'2012-06-04 23:00:00','2012-06-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2361477,'BF','Dédougou','Dedougou',12.4634,-3.46075,'P','PPLA','BF.01','BF.01.63',45341,'Africa/Ouagadougou',1,'2013-05-17 23:00:00','2013-05-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2361586,'BF','Dano','Dano',11.1464,-3.05784,'P','PPLA2','BF.13','BF.13.52',11153,'Africa/Ouagadougou',1,'2013-01-09 23:00:00','2013-01-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2361845,'BF','Boussé','Bousse',12.6576,-1.89288,'P','PPLA2','BF.11','BF.11.60',15868,'Africa/Ouagadougou',1,'2013-02-07 23:00:00','2013-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2361946,'BF','Boulsa','Boulsa',12.6666,-0.57469,'P','PPLA2','BF.05','BF.05.64',17489,'Africa/Ouagadougou',1,'2013-02-07 23:00:00','2013-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2362150,'BF','Boromo','Boromo',11.7454,-2.93006,'P','PPLA2','BF.01','BF.01.45',13157,'Africa/Ouagadougou',1,'2013-01-09 23:00:00','2013-01-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2362323,'BF','Bogandé','Bogande',12.9704,-0.14953,'P','PPLA2','BF.08','BF.08.21',9854,'Africa/Ouagadougou',1,'2017-05-20 23:00:00','2017-05-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2362344,'BF','Bobo-Dioulasso','Bobo-Dioulasso',11.1771,-4.2979,'P','PPLA','BF.09','BF.09.51',360106,'Africa/Ouagadougou',1,'2017-05-20 23:00:00','2017-05-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2362669,'BF','Batié','Batie',9.88333,-2.91667,'P','PPLA2','BF.13','BF.13.67',6483,'Africa/Ouagadougou',1,'2010-08-01 23:00:00','2010-08-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2362909,'BF','Banfora','Banfora',10.6333,-4.76667,'P','PPLA','BF.02','BF.02.55',60288,'Africa/Ouagadougou',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2577162,'BF','Gaoua','Gaoua',10.2992,-3.25083,'P','PPLA','BF.13','BF.13.69',25104,'Africa/Ouagadougou',1,'2010-08-01 23:00:00','2010-08-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2577164,'BF','Orodara','Orodara',10.9492,-4.93417,'P','PPLA2','BF.09','BF.09.54',18632,'Africa/Ouagadougou',1,'2012-06-05 23:00:00','2012-06-05 23:00:00');


