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


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

INSERT INTO `<<prefix>>subadmin1` VALUES (1216,'HT.13','HT','Sud-Est','Sud-Est',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1217,'HT.12','HT','Sud','Sud',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1218,'HT.11','HT','Ouest','Ouest',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1219,'HT.03','HT','Nord-Ouest','Nord-Ouest',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1220,'HT.10','HT','Nord-Est','Nord-Est',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1221,'HT.09','HT','Nord','Nord',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1222,'HT.14','HT','GrandʼAnse','Grandans',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1223,'HT.07','HT','Centre','Centre',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1224,'HT.06','HT','Artibonite','Artibonite',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1225,'HT.15','HT','Nippes','Nippes',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (15083,'HT.10.3716114','HT','HT.10','Arrondissement de Vallières','Arrondissement de Vallieres',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15084,'HT.10.3716223','HT','HT.10','Arrondissement du Trou du Nord','Arrondissement du Trou du Nord',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15085,'HT.09.3717545','HT','HT.09','Arrondissement de Saint-Raphaël','Arrondissement de Saint-Raphael',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15086,'HT.06.3717563','HT','HT.06','Arrondissement de Marmelade','Arrondissement de Marmelade',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15087,'HT.06.3717587','HT','HT.06','Arrondissement de Saint-Marc','Arrondissement de Saint-Marc',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15088,'HT.03.3717599','HT','HT.03','Arrondissement de Saint-Louis du Nord','Arrondissement de Saint-Louis du Nord',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15089,'HT.12.3718404','HT','HT.12','Arrondissement de Port-Salut','Arrondissement de Port-Salut',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15090,'HT.03.3718419','HT','HT.03','Arrondissement de Port-de-Paix','Arrondissement de Port-de-Paix',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15091,'HT.11.3718425','HT','HT.11','Arrondissement de Port-au-Prince','Arrondissement de Port-au-Prince',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15092,'HT.09.3718665','HT','HT.09','Arrondissement de Plaisance','Arrondissement de Plaisance',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15093,'HT.10.3719435','HT','HT.10','Wanament','Wanament',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15094,'HT.03.3720764','HT','HT.03','Arrondissement du Môle Saint-Nicolas','Arrondissement du Mole Saint-Nicolas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15095,'HT.07.3720809','HT','HT.07','Arrondissement de Mirebalais','Arrondissement de Mirebalais',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15096,'HT.15.3720823','HT','HT.15','Arrondissement de Miragoâne','Arrondissement de Miragoane',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15097,'HT.09.3722122','HT','HT.09','Lenbe','Lenbe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15098,'HT.11.3722285','HT','HT.11','Arrondissement de Léogâne','Arrondissement de Leogane',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15099,'HT.07.3722578','HT','HT.07','Arrondissement de Lascahobas','Arrondissement de Lascahobas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15100,'HT.11.3723019','HT','HT.11','Lagonav','Lagonav',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15101,'HT.14.3723592','HT','HT.14','Jeremi','Jeremi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15102,'HT.13.3723778','HT','HT.13','Arrondissement de Jacmel','Arrondissement de Jacmel',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15103,'HT.07.3723840','HT','HT.07','Arrondissement de Hinche','Arrondissement de Hinche',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15104,'HT.06.3724144','HT','HT.06','Arrondissement de Gros Morne','Arrondissement de Gros Morne',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15105,'HT.09.3724438','HT','HT.09','Arrondissement de la Grande Rivière du Nord','Arrondissement de la Grande Riviere du Nord',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15106,'HT.06.3724695','HT','HT.06','Gonayiv','Gonayiv',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15107,'HT.10.3725169','HT','HT.10','Arrondissement de Fort Liberté','Arrondissement de Fort Liberte',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15108,'HT.06.3726539','HT','HT.06','Arrondissement de Dessalines','Arrondissement de Dessalines',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15109,'HT.11.3727134','HT','HT.11','Arrondissement de Croix des Bouquets','Arrondissement de Croix des Bouquets',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15110,'HT.12.3727295','HT','HT.12','Arrondissement des Coteaux','Arrondissement des Coteaux',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15111,'HT.14.3727381','HT','HT.14','Arrondissement de Corail','Arrondissement de Corail',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15112,'HT.12.3727900','HT','HT.12','Arrondissement des Chardonnières','Arrondissement des Chardonnieres',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15113,'HT.07.3728053','HT','HT.07','Arrondissement de Cerca La Source','Arrondissement de Cerca La Source',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15114,'HT.12.3728096','HT','HT.12','Arrondissement des Cayes','Arrondissement des Cayes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15115,'HT.09.3728473','HT','HT.09','Okap','Okap',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15116,'HT.09.3729454','HT','HT.09','Arrondissement du Borgne','Arrondissement du Borgne',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15117,'HT.13.3730361','HT','HT.13','Arrondissement de Belle-Anse','Arrondissement de Belle-Anse',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15118,'HT.15.3730801','HT','HT.15','Arrondissement de Baradères','Arrondissement de Baraderes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15119,'HT.13.3730910','HT','HT.13','Arrondissement de Bainet','Arrondissement de Bainet',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15120,'HT.11.3731086','HT','HT.11','Arcahaie','Arcahaie',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15121,'HT.12.3731094','HT','HT.12','Aken','Aken',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15122,'HT.14.3731116','HT','HT.14','Ansdeno','Ansdeno',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15123,'HT.15.3731122','HT','HT.15','Ansavo','Ansavo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15124,'HT.09.3731232','HT','HT.09','Acul du Nord','Acul du Nord',1);

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

INSERT INTO `<<prefix>>cities` VALUES (3716044,'HT','Verrettes','Verrettes',19.0505,-72.4659,'P','PPL','HT.06','HT.06.3717587',48724,'America/Port-au-Prince',1,'2017-05-07 23:00:00','2017-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3716224,'HT','Trou du Nord','Trou du Nord',19.6167,-72.0244,'P','PPL','HT.10','HT.10.3716223',10569,'America/Port-au-Prince',1,'2017-05-07 23:00:00','2017-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3716667,'HT','Thomazeau','Thomazeau',18.653,-72.0939,'P','PPL','HT.11','HT.11.3727134',52017,'America/Port-au-Prince',1,'2017-04-06 23:00:00','2017-04-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3717546,'HT','Saint-Raphaël','Saint-Raphael',19.4388,-72.1991,'P','PPL','HT.09','HT.09.3717545',37739,'America/Port-au-Prince',1,'2017-05-07 23:00:00','2017-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3717588,'HT','Saint-Marc','Saint-Marc',19.1082,-72.6938,'P','PPL','HT.06','HT.06.3717587',66226,'America/Port-au-Prince',1,'2016-01-29 23:00:00','2016-01-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3717600,'HT','Saint-Louis du Nord','Saint-Louis du Nord',19.934,-72.7214,'P','PPL','HT.03','HT.03.3717599',11849,'America/Port-au-Prince',1,'2017-03-04 23:00:00','2017-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3718420,'HT','Port-de-Paix','Port-de-Paix',19.9389,-72.8326,'P','PPLA','HT.03','HT.03.3718419',250000,'America/Port-au-Prince',1,'2016-01-29 23:00:00','2016-01-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3718426,'HT','Port-au-Prince','Port-au-Prince',18.5392,-72.335,'P','PPLC','HT.11','HT.11.3718425',1234742,'America/Port-au-Prince',1,'2016-01-29 23:00:00','2016-01-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3718834,'HT','Pignon','Pignon',19.3359,-72.1166,'P','PPL','HT.09','HT.09.3717545',6731,'America/Port-au-Prince',1,'2016-10-23 23:00:00','2016-10-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3718962,'HT','Tigwav','Tigwav',18.4312,-72.8652,'P','PPL','HT.11','HT.11.3722285',117504,'America/Port-au-Prince',1,'2017-04-06 23:00:00','2017-04-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3719028,'HT','Pétionville','Petionville',18.5125,-72.2853,'P','PPL','HT.11','HT.11.3718425',283052,'America/Port-au-Prince',1,'2016-01-29 23:00:00','2016-01-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3719436,'HT','Ouanaminthe','Ouanaminthe',19.5493,-71.7247,'P','PPL','HT.10','HT.10.3719435',10118,'America/Port-au-Prince',1,'2017-03-04 23:00:00','2017-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3720811,'HT','Mirebalais','Mirebalais',18.8346,-72.1048,'P','PPL','HT.07','HT.07.3720809',9082,'America/Port-au-Prince',1,'2017-05-07 23:00:00','2017-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3720824,'HT','Miragoâne','Miragoane',18.4423,-73.0876,'P','PPLA','HT.15','HT.15.3720823',89202,'America/Port-au-Prince',1,'2016-01-29 23:00:00','2016-01-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3720854,'HT','Milot','Milot',19.6084,-72.2132,'P','PPL','HT.09','HT.09.3731232',5534,'America/Port-au-Prince',1,'2017-05-07 23:00:00','2017-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3721711,'HT','Mayisad','Mayisad',19.1761,-72.1396,'P','PPL','HT.07','HT.07.3723840',5204,'America/Port-au-Prince',1,'2017-05-07 23:00:00','2017-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3722124,'HT','Lenbe','Lenbe',19.706,-72.4034,'P','PPL','HT.09','HT.09.3722122',32645,'America/Port-au-Prince',1,'2017-05-07 23:00:00','2017-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3722253,'HT','Les Anglais','Les Anglais',18.3054,-74.2197,'P','PPL','HT.12','HT.12.3727900',8247,'America/Port-au-Prince',1,'2016-01-29 23:00:00','2016-01-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3722286,'HT','Léogâne','Leogane',18.5111,-72.6334,'P','PPL','HT.11','HT.11.3722285',134190,'America/Port-au-Prince',1,'2017-04-06 23:00:00','2017-04-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3722579,'HT','Lascahobas','Lascahobas',18.8305,-71.9356,'P','PPL','HT.07','HT.07.3722578',7574,'America/Port-au-Prince',1,'2017-04-06 23:00:00','2017-04-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3723440,'HT','Kenscoff','Kenscoff',18.4477,-72.284,'P','PPL','HT.11','HT.11.3718425',42175,'America/Port-au-Prince',1,'2017-04-06 23:00:00','2017-04-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3723593,'HT','Jérémie','Jeremie',18.65,-74.1167,'P','PPLA','HT.14','HT.14.3723592',97503,'America/Port-au-Prince',1,'2016-01-29 23:00:00','2016-01-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3723618,'HT','Jean-Rabel','Jean-Rabel',19.8538,-73.1913,'P','PPL','HT.03','HT.03.3720764',5419,'America/Port-au-Prince',1,'2017-03-04 23:00:00','2017-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3723779,'HT','Jacmel','Jacmel',18.2343,-72.5354,'P','PPLA','HT.13','HT.13.3723778',137966,'America/Port-au-Prince',1,'2016-01-29 23:00:00','2016-01-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3723841,'HT','Hinche','Hinche',19.15,-72.0167,'P','PPLA','HT.07','HT.07.3723840',18590,'America/Port-au-Prince',1,'2016-01-29 23:00:00','2016-01-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3724145,'HT','Gros Morne','Gros Morne',19.6708,-72.6781,'P','PPL','HT.06','HT.06.3724144',7294,'America/Port-au-Prince',1,'2017-03-04 23:00:00','2017-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3724233,'HT','Gressier','Gressier',18.5409,-72.5268,'P','PPL','HT.11',NULL,25947,'America/Port-au-Prince',1,'2017-04-06 23:00:00','2017-04-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3724337,'HT','Grangwav','Grangwav',18.4259,-72.77,'P','PPL','HT.11','HT.11.3722285',49288,'America/Port-au-Prince',1,'2017-04-06 23:00:00','2017-04-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3724439,'HT','Grande Rivière du Nord','Grande Riviere du Nord',19.5774,-72.1687,'P','PPL','HT.09','HT.09.3724438',8836,'America/Port-au-Prince',1,'2017-05-07 23:00:00','2017-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3724696,'HT','Gonayiv','Gonayiv',19.4475,-72.689,'P','PPLA','HT.06','HT.06.3724695',84961,'America/Port-au-Prince',1,'2016-01-29 23:00:00','2016-01-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3725170,'HT','Fort Liberté','Fort Liberte',19.6627,-71.838,'P','PPLA','HT.10','HT.10.3725169',11465,'America/Port-au-Prince',1,'2016-01-29 23:00:00','2016-01-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3725276,'HT','Fond Parisien','Fond Parisien',18.5055,-71.9812,'P','PPL','HT.11','HT.11.3727134',18256,'America/Port-au-Prince',1,'2017-04-06 23:00:00','2017-04-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3726263,'HT','Dondon','Dondon',19.5273,-72.2434,'P','PPL','HT.09','HT.09.3717545',5029,'America/Port-au-Prince',1,'2017-05-07 23:00:00','2017-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3726540,'HT','Dessalines','Dessalines',19.2618,-72.5161,'P','PPL','HT.06','HT.06.3726539',12288,'America/Port-au-Prince',1,'2017-05-07 23:00:00','2017-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3726674,'HT','Désarmes','Desarmes',18.9935,-72.3906,'P','PPL','HT.06','HT.06.3717587',15594,'America/Port-au-Prince',1,'2017-05-07 23:00:00','2017-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3726786,'HT','Delmas 73','Delmas 73',18.5447,-72.3028,'P','PPL','HT.11','HT.11.3718425',382920,'America/Port-au-Prince',1,'2016-01-29 23:00:00','2016-01-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3727055,'HT','Dame-Marie','Dame-Marie',18.5611,-74.4217,'P','PPL','HT.14','HT.14.3731116',6036,'America/Port-au-Prince',1,'2016-01-29 23:00:00','2016-01-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3727135,'HT','Croix-des-Bouquets','Croix-des-Bouquets',18.5768,-72.2262,'P','PPL','HT.11','HT.11.3727134',229127,'America/Port-au-Prince',1,'2017-04-06 23:00:00','2017-04-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3727327,'HT','Cornillon','Cornillon',18.6755,-71.9527,'P','PPL','HT.11','HT.11.3727134',7572,'America/Port-au-Prince',1,'2017-04-06 23:00:00','2017-04-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3728097,'HT','Les Cayes','Les Cayes',18.1933,-73.746,'P','PPLA','HT.12','HT.12.3728096',125799,'America/Port-au-Prince',1,'2016-01-29 23:00:00','2016-01-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3728338,'HT','Carrefour','Carrefour',18.5411,-72.3992,'P','PPLX','HT.11','HT.11.3718425',442156,'America/Port-au-Prince',1,'2016-01-29 23:00:00','2016-01-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3728474,'HT','Okap','Okap',19.7594,-72.1982,'P','PPLA','HT.09','HT.09.3728473',134815,'America/Port-au-Prince',1,'2016-10-11 23:00:00','2016-10-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3731095,'HT','Aquin','Aquin',18.2797,-73.3943,'P','PPL','HT.12','HT.12.3731094',5246,'America/Port-au-Prince',1,'2017-04-06 23:00:00','2017-04-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3731132,'HT','Anse à Galets','Anse a Galets',18.8345,-72.8664,'P','PPL','HT.11','HT.11.3723019',7178,'America/Port-au-Prince',1,'2017-01-04 23:00:00','2017-01-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3740016,'HT','Ti Port-de-Paix','Ti Port-de-Paix',19.9333,-72.8333,'P','PPL','HT.03','HT.03.3718419',34657,'America/Port-au-Prince',1,'2016-01-29 23:00:00','2016-01-29 23:00:00');


