--
-- Host: localhost    Database: laraclassified
-- ------------------------------------------------------


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

INSERT INTO `<<prefix>>subadmin1` VALUES (2740,'PY.17','PY','San Pedro','San Pedro',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2741,'PY.16','PY','Presidente Hayes','Presidente Hayes',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2742,'PY.15','PY','Paraguarí','Paraguari',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2743,'PY.13','PY','Ñeembucú','Neembucu',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2744,'PY.12','PY','Misiones','Misiones',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2745,'PY.11','PY','Itapúa','Itapua',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2746,'PY.10','PY','Guairá','Guaira',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2747,'PY.08','PY','Cordillera','Cordillera',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2748,'PY.07','PY','Concepción','Concepcion',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2749,'PY.06','PY','Central','Central',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2750,'PY.19','PY','Canindeyú','Canindeyu',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2751,'PY.05','PY','Caazapá','Caazapa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2752,'PY.04','PY','Caaguazú','Caaguazu',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2753,'PY.02','PY','Amambay','Amambay',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2754,'PY.01','PY','Alto Paraná','Alto Parana',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2755,'PY.23','PY','Alto Paraguay','Alto Paraguay',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2756,'PY.22','PY','Asunción','Asuncion',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2757,'PY.24','PY','Boquerón','Boqueron',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (30785,'PY.01.10293321','PY','PY.01','Minga Pora District','Minga Pora District',1);

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

INSERT INTO `<<prefix>>cities` VALUES (3436585,'PY','Ypacarai','Ypacarai',-25.4078,-57.2889,'P','PPL','PY.06',NULL,9655,'America/Asuncion',1,'2015-06-12 23:00:00','2015-06-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3436674,'PY','Yaguarón','Yaguaron',-25.5614,-57.2834,'P','PPL','PY.15',NULL,7181,'America/Asuncion',1,'2017-10-03 23:00:00','2017-10-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3436714,'PY','Villarrica','Villarrica',-25.7495,-56.4352,'P','PPLA','PY.10',NULL,41157,'America/Asuncion',1,'2015-06-13 23:00:00','2015-06-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3436725,'PY','Villa Hayes','Villa Hayes',-25.0931,-57.5236,'P','PPLA','PY.16',NULL,57217,'America/Asuncion',1,'2013-08-04 23:00:00','2013-08-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3436728,'PY','Villa Elisa','Villa Elisa',-25.3676,-57.5927,'P','PPL','PY.06',NULL,64099,'America/Asuncion',1,'2012-03-21 23:00:00','2012-03-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3436812,'PY','Tobatí','Tobati',-25.2611,-57.0833,'P','PPL','PY.08',NULL,9952,'America/Asuncion',1,'2017-10-03 23:00:00','2017-10-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3436959,'PY','Santa Rosa Misiones','Santa Rosa Misiones',-26.8873,-56.849,'P','PPL','PY.12',NULL,7257,'America/Asuncion',1,'2017-10-03 23:00:00','2017-10-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3436968,'PY','Santa Rita','Santa Rita',-25.7833,-55.0667,'P','PPL','PY.01',NULL,11823,'America/Asuncion',1,'2006-01-16 23:00:00','2006-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437021,'PY','San Pedro de Ycuamandiyú','San Pedro de Ycuamandiyu',-24.0853,-57.0874,'P','PPLA','PY.17',NULL,9360,'America/Asuncion',1,'2014-07-26 23:00:00','2014-07-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437022,'PY','San Pedro del Paraná','San Pedro del Parana',-26.8327,-56.2057,'P','PPL','PY.11',NULL,5722,'America/Asuncion',1,'2017-10-03 23:00:00','2017-10-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437056,'PY','San Lorenzo','San Lorenzo',-25.3397,-57.5088,'P','PPL','PY.06',NULL,227876,'America/Asuncion',1,'2012-03-21 23:00:00','2012-03-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437059,'PY','San Juan Nepomuceno','San Juan Nepomuceno',-26.1123,-55.9386,'P','PPL','PY.05',NULL,7893,'America/Asuncion',1,'2017-08-22 23:00:00','2017-08-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437063,'PY','San Juan Bautista','San Juan Bautista',-26.6694,-57.1458,'P','PPLA','PY.12',NULL,16593,'America/Asuncion',1,'2013-08-04 23:00:00','2013-08-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437074,'PY','San José','San Jose',-25.5333,-56.7333,'P','PPL','PY.04',NULL,5117,'America/Asuncion',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437088,'PY','San Isidro de Curuguaty','San Isidro de Curuguaty',-24.4718,-55.6923,'P','PPL','PY.19',NULL,11095,'America/Asuncion',1,'2017-08-22 23:00:00','2017-08-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437127,'PY','San Antonio','San Antonio',-25.4213,-57.5472,'P','PPL','PY.06',NULL,55754,'America/Asuncion',1,'2012-03-21 23:00:00','2012-03-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437148,'PY','Salto del Guairá','Salto del Guaira',-24.0625,-54.3069,'P','PPLA','PY.19',NULL,7385,'America/Asuncion',1,'2012-04-04 23:00:00','2012-04-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437197,'PY','Repatriación','Repatriacion',-25.5333,-55.95,'P','PPL','PY.04',NULL,7085,'America/Asuncion',1,'2012-02-01 23:00:00','2012-02-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437215,'PY','Quiindy','Quiindy',-25.9761,-57.2335,'P','PPL','PY.15',NULL,5137,'America/Asuncion',1,'2017-08-22 23:00:00','2017-08-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437342,'PY','Puerto Rosario','Puerto Rosario',-24.4413,-57.1427,'P','PPL','PY.17',NULL,5123,'America/Asuncion',1,'2017-11-07 23:00:00','2017-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437444,'PY','Presidente Franco','Presidente Franco',-25.5638,-54.611,'P','PPL','PY.01',NULL,54292,'America/Asuncion',1,'2017-09-04 23:00:00','2017-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437495,'PY','Piribebuy','Piribebuy',-25.465,-57.0418,'P','PPL','PY.08',NULL,10337,'America/Asuncion',1,'2017-10-03 23:00:00','2017-10-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437526,'PY','Pilar','Pilar',-26.8688,-58.2935,'P','PPLA','PY.13',NULL,28716,'America/Asuncion',1,'2013-06-28 23:00:00','2013-06-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437547,'PY','Pedro Juan Caballero','Pedro Juan Caballero',-22.5472,-55.7333,'P','PPLA','PY.02',NULL,75109,'America/Asuncion',1,'2014-08-17 23:00:00','2014-08-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437600,'PY','Paraguarí','Paraguari',-25.6208,-57.1472,'P','PPLA','PY.15',NULL,10079,'America/Asuncion',1,'2012-04-04 23:00:00','2012-04-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437637,'PY','Obligado','Obligado',-27.0333,-55.6333,'P','PPL','PY.11',NULL,6350,'America/Asuncion',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437665,'PY','Nemby','Nemby',-25.3949,-57.5357,'P','PPL','PY.06',NULL,94641,'America/Asuncion',1,'2012-03-21 23:00:00','2012-03-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437696,'PY','Nanawua','Nanawua',-25.2793,-57.7031,'P','PPL','PY.16',NULL,5587,'America/Asuncion',1,'2017-10-03 23:00:00','2017-10-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437842,'PY','Limpio','Limpio',-25.1661,-57.4856,'P','PPL','PY.06',NULL,96143,'America/Asuncion',1,'2012-03-21 23:00:00','2012-03-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437846,'PY','Lima','Lima',-23.8833,-56.4822,'P','PPL','PY.17',NULL,10367,'America/Asuncion',1,'2017-11-07 23:00:00','2017-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437863,'PY','Lambaré','Lambare',-25.3468,-57.6065,'P','PPL','PY.06',NULL,126377,'America/Asuncion',1,'2012-01-23 23:00:00','2012-01-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437918,'PY','Itauguá','Itaugua',-25.3926,-57.3542,'P','PPL','PY.06',NULL,64997,'America/Asuncion',1,'2017-10-03 23:00:00','2017-10-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437954,'PY','Itá','Ita',-25.5005,-57.3672,'P','PPL','PY.06',NULL,18459,'America/Asuncion',1,'2015-06-12 23:00:00','2015-06-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3437997,'PY','Hohenau','Hohenau',-27.0732,-55.6425,'P','PPL','PY.11',NULL,5306,'America/Asuncion',1,'2017-10-03 23:00:00','2017-10-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3438043,'PY','Guarambaré','Guarambare',-25.491,-57.4557,'P','PPL','PY.06',NULL,9065,'America/Asuncion',1,'2017-10-03 23:00:00','2017-10-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3438102,'PY','Fuerte Olimpo','Fuerte Olimpo',-21.0415,-57.8738,'P','PPLA','PY.23',NULL,2475,'America/Asuncion',1,'2012-04-09 23:00:00','2012-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3438115,'PY','Fernando de la Mora','Fernando de la Mora',-25.3386,-57.5217,'P','PPL','PY.06',NULL,120167,'America/Asuncion',1,'2014-07-06 23:00:00','2014-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3438123,'PY','Eusebio Ayala','Eusebio Ayala',-25.3828,-56.9609,'P','PPL','PY.08',NULL,8253,'America/Asuncion',1,'2017-10-03 23:00:00','2017-10-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3438735,'PY','Encarnación','Encarnacion',-27.3306,-55.8667,'P','PPLA','PY.11',NULL,74983,'America/Asuncion',1,'2017-05-23 23:00:00','2017-05-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3438738,'PY','Emboscada','Emboscada',-25.15,-57.35,'P','PPL','PY.08',NULL,5911,'America/Asuncion',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3438754,'PY','Doctor Juan León Mallorquín','Doctor Juan Leon Mallorquin',-25.4305,-55.2541,'P','PPL','PY.01',NULL,7481,'America/Asuncion',1,'2017-11-07 23:00:00','2017-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3438819,'PY','Coronel Oviedo','Coronel Oviedo',-25.4444,-56.4403,'P','PPLA','PY.04',NULL,51286,'America/Asuncion',1,'2012-04-04 23:00:00','2012-04-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3438834,'PY','Concepción','Concepcion',-23.3999,-57.4324,'P','PPLA','PY.07',NULL,48123,'America/Asuncion',1,'2017-05-23 23:00:00','2017-05-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3438981,'PY','Colonia Menno','Colonia Menno',-22.3667,-59.8167,'P','PPL','PY.24',NULL,5615,'America/Asuncion',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3438995,'PY','Mariano Roque Alonso','Mariano Roque Alonso',-25.2079,-57.532,'P','PPL','PY.06',NULL,72008,'America/Asuncion',1,'2017-09-04 23:00:00','2017-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3439032,'PY','Colonia General Alfredo Stroessner','Colonia General Alfredo Stroessner',-25.364,-55.7069,'P','PPLL','PY.04',NULL,11558,'America/Asuncion',1,'2017-11-07 23:00:00','2017-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3439101,'PY','Ciudad del Este','Ciudad del Este',-25.5097,-54.6111,'P','PPLA','PY.01',NULL,320782,'America/Asuncion',1,'2013-08-04 23:00:00','2013-08-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3439167,'PY','Carapeguá','Carapegua',-25.8,-57.2333,'P','PPL','PY.15',NULL,5784,'America/Asuncion',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3439189,'PY','Capitán Bado','Capitan Bado',-23.2667,-55.5333,'P','PPL','PY.02',NULL,9114,'America/Asuncion',1,'2012-02-01 23:00:00','2012-02-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3439214,'PY','Capiatá','Capiata',-25.3552,-57.4454,'P','PPL','PY.06',NULL,198553,'America/Asuncion',1,'2012-03-21 23:00:00','2012-03-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3439297,'PY','Caazapá','Caazapa',-26.1958,-56.3681,'P','PPLA','PY.05',NULL,23996,'America/Asuncion',1,'2013-08-04 23:00:00','2013-08-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3439317,'PY','Caaguazú','Caaguazu',-25.471,-56.016,'P','PPL','PY.04',NULL,54808,'America/Asuncion',1,'2017-11-07 23:00:00','2017-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3439320,'PY','Caacupé','Caacupe',-25.3857,-57.1422,'P','PPLA','PY.08',NULL,21696,'America/Asuncion',1,'2014-12-27 23:00:00','2014-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3439348,'PY','Benjamín Aceval','Benjamin Aceval',-24.9667,-57.5667,'P','PPL','PY.16',NULL,7751,'America/Asuncion',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3439353,'PY','Bella Vista','Bella Vista',-22.1333,-56.5167,'P','PPL','PY.02',NULL,5653,'America/Asuncion',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3439378,'PY','Juan de Ayolas','Juan de Ayolas',-27.3866,-56.8472,'P','PPL','PY.12',NULL,12061,'America/Asuncion',1,'2017-10-03 23:00:00','2017-10-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3439389,'PY','Asunción','Asuncion',-25.3007,-57.6359,'P','PPLC','PY.22',NULL,1482200,'America/Asuncion',1,'2010-07-05 23:00:00','2010-07-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3439402,'PY','Arquitecto Tomás Romero Pereira','Arquitecto Tomas Romero Pereira',-26.4833,-55.25,'P','PPL','PY.11',NULL,5533,'America/Asuncion',1,'2006-01-16 23:00:00','2006-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3439403,'PY','Areguá','Aregua',-25.3125,-57.3847,'P','PPLA','PY.06',NULL,11222,'America/Asuncion',1,'2012-04-04 23:00:00','2012-04-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3480780,'PY','Horqueta','Horqueta',-23.3428,-57.0597,'P','PPL','PY.07',NULL,10531,'America/Asuncion',1,'2012-01-19 23:00:00','2012-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3867291,'PY','Filadelfia','Filadelfia',-22.3394,-60.0316,'P','PPLA','PY.24',NULL,8048,'America/Asuncion',1,'2015-06-13 23:00:00','2015-06-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (11205611,'PY','Nueva Esperanza','Nueva Esperanza',-24.5076,-54.8551,'P','PPL','PY.19',NULL,12717,'America/Asuncion',1,'2016-08-02 23:00:00','2016-08-02 23:00:00');


