-- MySQL dump 10.13  Distrib 5.7.26, for osx10.10 (x86_64)
--
-- Host: 127.0.0.1    Database: laraclassified
-- ------------------------------------------------------
-- Server version	5.7.26

/*!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` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.17','PY','San Pedro','San Pedro',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.16','PY','Presidente Hayes','Presidente Hayes',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.15','PY','Paraguarí','Paraguari',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.13','PY','Ñeembucú','Neembucu',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.12','PY','Misiones','Misiones',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.11','PY','Itapúa','Itapua',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.10','PY','Guairá','Guaira',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.08','PY','Cordillera','Cordillera',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.07','PY','Concepción','Concepcion',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.06','PY','Central','Central',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.19','PY','Canindeyú','Canindeyu',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.05','PY','Caazapá','Caazapa',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.04','PY','Caaguazú','Caaguazu',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.02','PY','Amambay','Amambay',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.01','PY','Alto Paraná','Alto Parana',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.23','PY','Alto Paraguay','Alto Paraguay',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.22','PY','Asunción','Asuncion',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('PY.24','PY','Boquerón','Boqueron',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` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1016','PY','PY.01','Minga Pora District','Minga Pora District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0719','PY','PY.11','San Cosme y Damian','San Cosme y Damian',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0208','PY','PY.17','San Estanislao','San Estanislao',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.16.1504','PY','PY.16','Villa Hayes','Villa Hayes',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.12.0805','PY','PY.12','San Patricio','San Patricio',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0308','PY','PY.08','Isla Pucu','Isla Pucu',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.13.1211','PY','PY.13','Paso De Patria','Paso De Patria',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.13.1202','PY','PY.13','Alberdi','Alberdi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.15.0911','PY','PY.15','Quyquyho','Quyquyho',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0401','PY','PY.10','Villarrica','Villarrica',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1003','PY','PY.01','Domingo Martinez De Irala','Domingo Martinez De Irala',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0414','PY','PY.10','San Salvador','San Salvador',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0715','PY','PY.11','Jesus','Jesus',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1113','PY','PY.06','San Antonio','San Antonio',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0213','PY','PY.17','Villa Del Rosario','Villa Del Rosario',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0513','PY','PY.04','R.I. 3 Corrales','R.I. 3 Corrales',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0717','PY','PY.11','Obligado','Obligado',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.05.0602','PY','PY.05','Abai','Abai',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1010','PY','PY.01','Los Cedrales','Los Cedrales',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1102','PY','PY.06','Capiata','Capiata',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0211','PY','PY.17','Union','Union',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0519','PY','PY.04','Simon Bolivar','Simon Bolivar',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.19.1401','PY','PY.19','Saltos Del Guaira','Saltos Del Guaira',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0720','PY','PY.11','San Pedro Del Parana','San Pedro Del Parana',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0504','PY','PY.04','Cecilio Baez','Cecilio Baez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0708','PY','PY.11','Coronel Bogado','Coronel Bogado',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1018','PY','PY.01','San Alberto','San Alberto',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1017','PY','PY.01','Mbaracayu','Mbaracayu',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.13.1213','PY','PY.13','Tacuaras','Tacuaras',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.15.0905','PY','PY.15','Carapegua','Carapegua',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.19.1407','PY','PY.19','Francisco Caballero Alvarez','Francisco Caballero Alvarez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0507','PY','PY.04','Repatriacion','Repatriacion',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.13.1205','PY','PY.13','General Diaz','General Diaz',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.13.1204','PY','PY.13','Desmochados','Desmochados',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0501','PY','PY.04','Coronel Oviedo','Coronel Oviedo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0728','PY','PY.11','San Juan del Parana','San Juan del Parana',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0217','PY','PY.17','Capiibary','Capiibary',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0207','PY','PY.17','Nueva Germania','Nueva Germania',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.15.0908','PY','PY.15','Mbuyapey','Mbuyapey',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.19.1410','PY','PY.19','Nueva Esperanza','Nueva Esperanza',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.13.1208','PY','PY.13','Isla Umbu','Isla Umbu',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.24.1605','PY','PY.24','Loma Plata','Loma Plata',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1020','PY','PY.01','Santa Fe Del Parana','Santa Fe Del Parana',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0318','PY','PY.08','Tobati','Tobati',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.19.1403','PY','PY.19','Curuguaty','Curuguaty',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.19.1405','PY','PY.19','Itanara','Itanara',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.19.1406','PY','PY.19','Ype Jhu','Ype Jhu',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0412','PY','PY.10','Natalicio Talavera','Natalicio Talavera',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0505','PY','PY.04','Santa Rosa Del Mbutuy','Santa Rosa Del Mbutuy',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0725','PY','PY.11','Alto Vera','Alto Vera',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.15.0916','PY','PY.15','Yvycui','Yvycui',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0403','PY','PY.10','Mauricio Jose Troche','Mauricio Jose Troche',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.15.0912','PY','PY.15','San Roque Gonzalez','San Roque Gonzalez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.15.0902','PY','PY.15','Acahay','Acahay',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1112','PY','PY.06','Ñemby','Nemby',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1101','PY','PY.06','Aregua','Aregua',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.02.1303','PY','PY.02','Capitan Bado','Capitan Bado',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.16.1508','PY','PY.16','Tte. Esteban Martinez','Tte. Esteban Martinez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0313','PY','PY.08','Nueva Colombia','Nueva Colombia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0310','PY','PY.08','Juan De Mena','Juan De Mena',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0515','PY','PY.04','Jose Domingo Ocampos','Jose Domingo Ocampos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.16.1506','PY','PY.16','Jose Falcon','Jose Falcon',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0701','PY','PY.11','Encarnacion','Encarnacion',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0305','PY','PY.08','Caraguatay','Caraguatay',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0314','PY','PY.08','Piribebuy','Piribebuy',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0413','PY','PY.10','Ñumi','Numi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.19.1408','PY','PY.19','Katuete','Katuete',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0716','PY','PY.11','Leandro Oviedo','Leandro Oviedo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0703','PY','PY.11','Cambyreta','Cambyreta',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0516','PY','PY.04','Mcal. Francisco Solano Lopez','Mcal. Francisco Solano Lopez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0220','PY','PY.17','Liberacion','Liberacion',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0714','PY','PY.11','Hohenau','Hohenau',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.05.0604','PY','PY.05','Moises Bertoni','Moises Bertoni',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.12.0804','PY','PY.12','San Miguel','San Miguel',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.07.0109','PY','PY.07','Sgto. Jose Felix Lopez','Sgto. Jose Felix Lopez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0215','PY','PY.17','Yataity Del Norte','Yataity Del Norte',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.24.1604','PY','PY.24','Filadelfia','Filadelfia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1013','PY','PY.01','Santa Rita','Santa Rita',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0510','PY','PY.04','San Jose De Los Arroyos','San Jose De Los Arroyos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0302','PY','PY.08','Altos','Altos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.02.1304','PY','PY.02','Zanja Pyta','Zanja Pyta',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.15.0909','PY','PY.15','Pirayu','Pirayu',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.05.0603','PY','PY.05','Buena Vista','Buena Vista',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.05.0607','PY','PY.05','San Juan Nepomuceno','San Juan Nepomuceno',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.12.0803','PY','PY.12','San Ignacio','San Ignacio',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.13.1207','PY','PY.13','Humaita','Humaita',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.23.1705','PY','PY.23','Carmelo Peralta','Carmelo Peralta',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0724','PY','PY.11','Tomas Romero Pereira','Tomas Romero Pereira',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1009','PY','PY.01','Yguazu','Yguazu',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.15.0901','PY','PY.15','Paraguari','Paraguari',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0216','PY','PY.17','Guajayvi','Guajayvi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.07.0107','PY','PY.07','Yvy Ya´U','Yvy Ya\'U',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0212','PY','PY.17','25 De Diciembre','25 De Diciembre',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0311','PY','PY.08','Loma Grande','Loma Grande',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.15.0904','PY','PY.15','General Bernardino Caballero','General Bernardino Caballero',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.12.0806','PY','PY.12','Santa Maria','Santa Maria',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.16.1507','PY','PY.16','Tte 1ro Manuel Irala Fernandez','Tte 1ro Manuel Irala Fernandez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0502','PY','PY.04','Caaguazu','Caaguazu',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0406','PY','PY.10','General Eugenio A. Garay','General Eugenio A. Garay',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0711','PY','PY.11','Fram','Fram',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0418','PY','PY.10','Tebicuary','Tebicuary',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1103','PY','PY.06','Fernando De La Mora','Fernando De La Mora',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.05.0608','PY','PY.05','Tavai','Tavai',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.16.1502','PY','PY.16','Benjamin Aceval','Benjamin Aceval',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0704','PY','PY.11','Capitan Meza','Capitan Meza',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1104','PY','PY.06','Guarambare','Guarambare',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.24.1602','PY','PY.24','Mariscal Estigarribia','Mariscal Estigarribia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.15.0915','PY','PY.15','Yaguaron','Yaguaron',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0410','PY','PY.10','Jose Fassardi','Jose Fassardi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.07.0101','PY','PY.07','Concepcion','Concepcion',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.12.0809','PY','PY.12','Villa Florida','Villa Florida',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.13.1212','PY','PY.13','San Juan Bautista De Ñeembucu','San Juan Bautista De Neembucu',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.13.1209','PY','PY.13','Los Laureles','Los Laureles',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1118','PY','PY.06','Ypane','Ypane',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0206','PY','PY.17','Lima','Lima',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1115','PY','PY.06','Villa Elisa','Villa Elisa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0417','PY','PY.10','Paso Yobai','Paso Yobai',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0712','PY','PY.11','General Artigas','General Artigas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0306','PY','PY.08','Emboscada','Emboscada',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0320','PY','PY.08','San Jose Obrero','San Jose Obrero',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.16.1509','PY','PY.16','General Jose Maria Bruguez','General Jose Maria Bruguez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0319','PY','PY.08','Valenzuela','Valenzuela',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.15.0914','PY','PY.15','Tebicuary-Mi','Tebicuary-Mi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.15.0903','PY','PY.15','Caapucu','Caapucu',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.05.0605','PY','PY.05','General Higinio Morinigo','General Higinio Morinigo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1109','PY','PY.06','Luque','Luque',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0723','PY','PY.11','Edelira','Edelira',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.19.1404','PY','PY.19','Villa Ygatimí','Villa Ygatimi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.22.0000','PY','PY.22','Asuncion','Asuncion',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.19.1409','PY','PY.19','La Paloma','La Paloma',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.13.1210','PY','PY.13','Mayor Martinez','Mayor Martinez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1022','PY','PY.01','Dr. Raul Peña','Dr. Raul Pena',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.12.0802','PY','PY.12','Ayolas','Ayolas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0522','PY','PY.04','Nueva Toledo','Nueva Toledo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0402','PY','PY.10','Borja','Borja',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.19.1411','PY','PY.19','Yasy Kañy','Yasy Kany',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.07.0102','PY','PY.07','Belen','Belen',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0404','PY','PY.10','Coronel Martinez','Coronel Martinez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.15.0907','PY','PY.15','La Colmena','La Colmena',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0512','PY','PY.04','J Eulogio Estigarribia','J Eulogio Estigarribia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.16.1505','PY','PY.16','Nanawa','Nanawa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1119','PY','PY.06','J Augusto Saldivar','J Augusto Saldivar',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1107','PY','PY.06','Lambare','Lambare',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0316','PY','PY.08','San Bernardino','San Bernardino',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0702','PY','PY.11','Bella Vista','Bella Vista',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0416','PY','PY.10','Dr. Bottrell','Dr. Bottrell',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1014','PY','PY.01','Naranjal','Naranjal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.23.1704','PY','PY.23','Bahia Negra','Bahia Negra',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.07.0104','PY','PY.07','Loreto','Loreto',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0214','PY','PY.17','General Resquin','General Resquin',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1021','PY','PY.01','Tavapy','Tavapy',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0722','PY','PY.11','Trinidad','Trinidad',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.12.0808','PY','PY.12','Santiago','Santiago',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0707','PY','PY.11','Carmen Del Parana','Carmen Del Parana',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.12.0810','PY','PY.12','Yabebyry','Yabebyry',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.13.1214','PY','PY.13','Villa Franca','Villa Franca',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0721','PY','PY.11','San Rafael Del Parana','San Rafael Del Parana',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0203','PY','PY.17','Chore','Chore',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0315','PY','PY.08','Primero De Marzo','Primero De Marzo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0730','PY','PY.11','Itapua Poty','Itapua Poty',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.05.0610','PY','PY.05','Yuty','Yuty',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0718','PY','PY.11','Mayor Otaño','Mayor Otano',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.13.1215','PY','PY.13','Villa Oliva','Villa Oliva',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.12.0801','PY','PY.12','San Juan Bautista','San Juan Bautista',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0307','PY','PY.08','Eusebio Ayala','Eusebio Ayala',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.07.0108','PY','PY.07','Azotey','Azotey',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.02.1301','PY','PY.02','Pedro Juan Caballero','Pedro Juan Caballero',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.05.0609','PY','PY.05','Fulgencio Yegros','Fulgencio Yegros',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1110','PY','PY.06','Mariano Roque Alonso','Mariano Roque Alonso',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0706','PY','PY.11','Nueva Alborada','Nueva Alborada',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.15.0910','PY','PY.15','Quiindy','Quiindy',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0509','PY','PY.04','San Joaquin','San Joaquin',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1002','PY','PY.01','Presidente Franco','Presidente Franco',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1012','PY','PY.01','San Cristobal','San Cristobal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0209','PY','PY.17','San Pablo','San Pablo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.13.1203','PY','PY.13','Cerrito','Cerrito',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.07.0106','PY','PY.07','San Lazaro','San Lazaro',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0312','PY','PY.08','Mbocayaty Del Yhaguy','Mbocayaty Del Yhaguy',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1019','PY','PY.01','Iruña','Iruna',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0508','PY','PY.04','Nueva Londres','Nueva Londres',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1006','PY','PY.01','Itakyry','Itakyry',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.07.0105','PY','PY.07','San Carlos','San Carlos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.05.0606','PY','PY.05','Maciel','Maciel',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0205','PY','PY.17','Itacurubi Del Rosario','Itacurubi Del Rosario',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1114','PY','PY.06','San Lorenzo','San Lorenzo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0210','PY','PY.17','Tacuati','Tacuati',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0727','PY','PY.11','Yatytay','Yatytay',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0407','PY','PY.10','Colonia Independencia','Colonia Independencia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1007','PY','PY.01','Juan E. O´Leary','Juan E. O\'Leary',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0317','PY','PY.08','Santa Elena','Santa Elena',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0705','PY','PY.11','Capitan Miranda','Capitan Miranda',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1001','PY','PY.01','Ciudad Del Este','Ciudad Del Este',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.19.1402','PY','PY.19','Corpus Christi','Corpus Christi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0304','PY','PY.08','Atyra','Atyra',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0204','PY','PY.17','General Elizardo Aquino','General Elizardo Aquino',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.13.1216','PY','PY.13','Villalbin','Villalbin',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1011','PY','PY.01','Minga Guazu','Minga Guazu',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0521','PY','PY.04','Tembiapora','Tembiapora',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.15.0906','PY','PY.15','Escobar','Escobar',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.15.0913','PY','PY.15','Sapucai','Sapucai',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0201','PY','PY.17','San Pedro Del Ykuamandiyu','San Pedro Del Ykuamandiyu',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.19.1412','PY','PY.19','Ybyrarobana','Ybyrarobana',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0411','PY','PY.10','Mbocayaty','Mbocayaty',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.23.1702','PY','PY.23','Puerto Casado','Puerto Casado',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0518','PY','PY.04','3 De Febrero','3 De Febrero',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1004','PY','PY.01','Dr. Juan Leon Mallorquin','Dr. Juan Leon Mallorquin',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.07.0103','PY','PY.07','Horqueta','Horqueta',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.15.0917','PY','PY.15','Yvytimi','Yvytimi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1111','PY','PY.06','Nueva Italia','Nueva Italia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0503','PY','PY.04','Carayao','Carayao',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0219','PY','PY.17','Yryvu Cua','Yryvu Cua',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0408','PY','PY.10','Itape','Itape',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.13.1201','PY','PY.13','Pilar','Pilar',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1015','PY','PY.01','Santa Rosa Del Monday','Santa Rosa Del Monday',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1105','PY','PY.06','Ita','Ita',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0506','PY','PY.04','Dr. Juan Manuel Frutos','Dr. Juan Manuel Frutos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0514','PY','PY.04','Raul Arsenio Oviedo','Raul Arsenio Oviedo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0405','PY','PY.10','Felix Perez Cardozo','Felix Perez Cardozo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0709','PY','PY.11','Carlos Antonio Lopez','Carlos Antonio Lopez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1116','PY','PY.06','Villeta','Villeta',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.13.1206','PY','PY.13','Guazu Cua','Guazu Cua',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0517','PY','PY.04','La Pastora','La Pastora',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1108','PY','PY.06','Limpio','Limpio',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.23.1701','PY','PY.23','Fuerte Olimpo','Fuerte Olimpo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0301','PY','PY.08','Caacupe','Caacupe',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0202','PY','PY.17','Antequera','Antequera',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1008','PY','PY.01','Ñacunday','Nacunday',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.05.0611','PY','PY.05','3 De Mayo','3 De Mayo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.12.0807','PY','PY.12','Santa Rosa','Santa Rosa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.05.0601','PY','PY.05','Caazapa','Caazapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0303','PY','PY.08','Arroyos Y Esteros','Arroyos Y Esteros',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0415','PY','PY.10','Yataity','Yataity',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0511','PY','PY.04','Yhu','Yhu',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1117','PY','PY.06','Ypacarai','Ypacarai',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.16.1503','PY','PY.16','Puerto Pinasco','Puerto Pinasco',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0710','PY','PY.11','Natalio','Natalio',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0729','PY','PY.11','Pirapo','Pirapo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.17.0218','PY','PY.17','Santa Rosa Del Aguaray','Santa Rosa Del Aguaray',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.01.1005','PY','PY.01','Hernandarias','Hernandarias',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.02.1302','PY','PY.02','Bella Vista','Bella Vista',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.04.0520','PY','PY.04','Vaqueria','Vaqueria',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0726','PY','PY.11','La Paz','La Paz',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.10.0409','PY','PY.10','Iturbe','Iturbe',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.08.0309','PY','PY.08','Itacurubi De La Cordillera','Itacurubi De La Cordillera',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.06.1106','PY','PY.06','Itaugua','Itaugua',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('PY.11.0713','PY','PY.11','General Delgado','General Delgado',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` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Ypacarai','Ypacarai',-57.2889,-25.4078,'P','PPL','PY.06','PY.06.1117',9655,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Yaguarón','Yaguaron',-57.2834,-25.5614,'P','PPL','PY.15','PY.15.0915',7181,'America/Asuncion',1,'2019-03-28 23:00:00','2019-03-28 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Villarrica','Villarrica',-56.4352,-25.7495,'P','PPLA','PY.10','PY.10.0401',41157,'America/Asuncion',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Villa Hayes','Villa Hayes',-57.5236,-25.0931,'P','PPLA','PY.16','PY.16.1504',57217,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Villa Elisa','Villa Elisa',-57.5927,-25.3676,'P','PPL','PY.06','PY.06.1115',64099,'America/Asuncion',1,'2019-03-28 23:00:00','2019-03-28 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Tobatí','Tobati',-57.0833,-25.2611,'P','PPL','PY.08','PY.08.0318',9952,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Santa Rosa Misiones','Santa Rosa Misiones',-56.849,-26.8873,'P','PPL','PY.12','PY.12.0807',7257,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Santa Rita','Santa Rita',-55.0667,-25.7833,'P','PPL','PY.01','PY.01.1013',11823,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','San Pedro de Ycuamandiyú','San Pedro de Ycuamandiyu',-57.0874,-24.0853,'P','PPLA','PY.17','PY.17.0201',9360,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','San Pedro del Paraná','San Pedro del Parana',-56.2057,-26.8327,'P','PPL','PY.11','PY.11.0720',5722,'America/Asuncion',1,'2019-03-28 23:00:00','2019-03-28 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','San Lorenzo','San Lorenzo',-57.5088,-25.3397,'P','PPL','PY.06','PY.06.1114',227876,'America/Asuncion',1,'2019-02-25 23:00:00','2019-02-25 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','San Juan Nepomuceno','San Juan Nepomuceno',-55.9386,-26.1123,'P','PPL','PY.05','PY.05.0607',7893,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','San Juan Bautista','San Juan Bautista',-57.1458,-26.6694,'P','PPLA','PY.12','PY.12.0801',16593,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','San José','San Jose',-56.7333,-25.5333,'P','PPL','PY.04','PY.04.0510',5117,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','San Isidro de Curuguaty','San Isidro de Curuguaty',-55.6923,-24.4718,'P','PPL','PY.19','PY.19.1403',11095,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','San Antonio','San Antonio',-57.5472,-25.4213,'P','PPL','PY.06','PY.06.1113',55754,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Salto del Guairá','Salto del Guaira',-54.3069,-24.0625,'P','PPLA','PY.19','PY.19.1401',7385,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Repatriación','Repatriacion',-55.95,-25.5333,'P','PPL','PY.04','PY.04.0507',7085,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Quiindy','Quiindy',-57.2335,-25.9761,'P','PPL','PY.15','PY.15.0910',5137,'America/Asuncion',1,'2019-03-28 23:00:00','2019-03-28 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Puerto Rosario','Puerto Rosario',-57.1427,-24.4413,'P','PPL','PY.17','PY.17.0213',5123,'America/Asuncion',1,'2018-11-29 23:00:00','2018-11-29 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Presidente Franco','Presidente Franco',-54.611,-25.5638,'P','PPL','PY.01','PY.01.1002',54292,'America/Asuncion',1,'2019-03-28 23:00:00','2019-03-28 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Piribebuy','Piribebuy',-57.0418,-25.465,'P','PPL','PY.08','PY.08.0314',10337,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Pilar','Pilar',-58.3064,-26.8587,'P','PPLA','PY.13','PY.13.1201',28716,'America/Asuncion',1,'2018-11-29 23:00:00','2018-11-29 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Pedro Juan Caballero','Pedro Juan Caballero',-55.7333,-22.5472,'P','PPLA','PY.02','PY.02.1301',75109,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Paraguarí','Paraguari',-57.1472,-25.6208,'P','PPLA','PY.15','PY.15.0901',10079,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Obligado','Obligado',-55.6333,-27.0333,'P','PPL','PY.11','PY.11.0717',6350,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Nemby','Nemby',-57.5357,-25.3949,'P','PPL','PY.06','PY.06.1112',94641,'America/Asuncion',1,'2019-03-28 23:00:00','2019-03-28 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Nanawua','Nanawua',-57.7031,-25.2793,'P','PPL','PY.16','PY.16.1505',5587,'America/Asuncion',1,'2019-03-28 23:00:00','2019-03-28 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Limpio','Limpio',-57.4856,-25.1661,'P','PPL','PY.06','PY.06.1108',96143,'America/Asuncion',1,'2019-02-26 23:00:00','2019-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Lima','Lima',-56.4822,-23.8833,'P','PPL','PY.17','PY.17.0206',10367,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Lambaré','Lambare',-57.6065,-25.3468,'P','PPL','PY.06','PY.06.1107',126377,'America/Asuncion',1,'2019-02-25 23:00:00','2019-02-25 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Itauguá','Itaugua',-57.3542,-25.3926,'P','PPL','PY.06','PY.06.1106',64997,'America/Asuncion',1,'2019-03-27 23:00:00','2019-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Itá','Ita',-57.3672,-25.5005,'P','PPL','PY.06','PY.06.1105',18459,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Hohenau','Hohenau',-55.6425,-27.0732,'P','PPLA2','PY.11','PY.11.0714',5306,'America/Asuncion',1,'2018-04-10 23:00:00','2018-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Guarambaré','Guarambare',-57.4557,-25.491,'P','PPL','PY.06','PY.06.1104',9065,'America/Asuncion',1,'2019-03-27 23:00:00','2019-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Fuerte Olimpo','Fuerte Olimpo',-57.8738,-21.0415,'P','PPLA','PY.23','PY.23.1701',2475,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Fernando de la Mora','Fernando de la Mora',-57.5217,-25.3386,'P','PPL','PY.06','PY.06.1114',120167,'America/Asuncion',1,'2019-02-26 23:00:00','2019-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Eusebio Ayala','Eusebio Ayala',-56.9609,-25.3828,'P','PPL','PY.08','PY.08.0307',8253,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Encarnación','Encarnacion',-55.8667,-27.3306,'P','PPLA','PY.11','PY.11.0701',74983,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Emboscada','Emboscada',-57.35,-25.15,'P','PPL','PY.08','PY.08.0306',5911,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Doctor Juan León Mallorquín','Doctor Juan Leon Mallorquin',-55.2541,-25.4305,'P','PPL','PY.01','PY.01.1004',7481,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Coronel Oviedo','Coronel Oviedo',-56.4403,-25.4444,'P','PPLA','PY.04','PY.04.0501',51286,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Concepción','Concepcion',-57.4324,-23.3999,'P','PPLA','PY.07','PY.07.0101',48123,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Colonia Menno','Colonia Menno',-59.8167,-22.3667,'P','PPL','PY.24','PY.24.1605',5615,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Mariano Roque Alonso','Mariano Roque Alonso',-57.532,-25.2079,'P','PPL','PY.06','PY.06.1110',72008,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Colonia General Alfredo Stroessner','Colonia General Alfredo Stroessner',-55.7069,-25.364,'P','PPLL','PY.04','PY.04.0512',11558,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Ciudad del Este','Ciudad del Este',-54.6111,-25.5097,'P','PPLA','PY.01','PY.01.1001',320782,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Carapeguá','Carapegua',-57.2333,-25.8,'P','PPL','PY.15','PY.15.0905',5784,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Capitán Bado','Capitan Bado',-55.5333,-23.2667,'P','PPL','PY.02','PY.02.1303',9114,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Capiatá','Capiata',-57.4454,-25.3552,'P','PPL','PY.06','PY.06.1102',198553,'America/Asuncion',1,'2019-02-25 23:00:00','2019-02-25 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Caazapá','Caazapa',-56.3681,-26.1958,'P','PPLA','PY.05','PY.05.0601',23996,'America/Asuncion',1,'2019-03-27 23:00:00','2019-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Caaguazú','Caaguazu',-56.016,-25.471,'P','PPL','PY.04','PY.04.0502',54808,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Caacupé','Caacupe',-57.1422,-25.3857,'P','PPLA','PY.08','PY.08.0301',21696,'America/Asuncion',1,'2019-03-27 23:00:00','2019-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Benjamín Aceval','Benjamin Aceval',-57.5667,-24.9667,'P','PPL','PY.16','PY.16.1502',7751,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Bella Vista','Bella Vista',-56.5167,-22.1333,'P','PPL','PY.02','PY.02.1302',5653,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Juan de Ayolas','Juan de Ayolas',-56.8472,-27.3866,'P','PPL','PY.12','PY.12.0802',12061,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Asunción','Asuncion',-57.647,-25.2865,'P','PPLC','PY.22','PY.22.0000',1482200,'America/Asuncion',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Arquitecto Tomás Romero Pereira','Arquitecto Tomas Romero Pereira',-55.25,-26.4833,'P','PPL','PY.11','PY.11.0724',5533,'America/Asuncion',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Areguá','Aregua',-57.3847,-25.3125,'P','PPLA','PY.06','PY.06.1101',11222,'America/Asuncion',1,'2019-03-27 23:00:00','2019-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Horqueta','Horqueta',-57.0597,-23.3428,'P','PPL','PY.07','PY.07.0103',10531,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Filadelfia','Filadelfia',-60.0316,-22.3394,'P','PPLA','PY.24','PY.24.1604',8048,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PY','Nueva Esperanza','Nueva Esperanza',-54.8551,-24.5076,'P','PPL','PY.19','PY.19.1410',12717,'America/Asuncion',1,'2018-04-08 23:00:00','2018-04-08 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
