-- 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 ('EC.20','EC','Zamora-Chinchipe','Zamora-Chinchipe',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.19','EC','Tungurahua','Tungurahua',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.18','EC','Pichincha','Pichincha',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.17','EC','Pastaza','Pastaza',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.23','EC','Napo','Napo',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.15','EC','Morona-Santiago','Morona-Santiago',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.14','EC','Manabí','Manabi',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.13','EC','Los Ríos','Los Rios',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.12','EC','Loja','Loja',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.11','EC','Imbabura','Imbabura',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.10','EC','Guayas','Guayas',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.01','EC','Galápagos','Galapagos',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.09','EC','Esmeraldas','Esmeraldas',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.08','EC','El Oro','El Oro',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.07','EC','Cotopaxi','Cotopaxi',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.06','EC','Chimborazo','Chimborazo',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.05','EC','Carchi','Carchi',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.04','EC','Cañar','Canar',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.03','EC','Bolívar','Bolivar',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.02','EC','Azuay','Azuay',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.22','EC','Sucumbios','Sucumbios',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.24','EC','Orellana','Orellana',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.26','EC','Santo Domingo de los Tsáchilas','Santo Domingo de los Tsachilas',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('EC.25','EC','Santa Elena','Santa Elena',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 ('EC.08.0713','EC','EC.08','Cantón Zaruma','Canton Zaruma',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.20.1901','EC','EC.20','Cantón Zamora','Canton Zamora',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.20.1905','EC','EC.20','Cantón Yantzaza','Canton Yantzaza',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0920','EC','EC.10','Cantón Yaguachi','Canton Yaguachi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.20.1904','EC','EC.20','Cantón Yacuambi','Canton Yacuambi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.13.1208','EC','EC.13','Cantón Vinces','Canton Vinces',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.13.1207','EC','EC.13','Cantón Ventanas','Canton Ventanas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1316','EC','EC.14','Cantón Veinticuatro de Mayo','Canton Veinticuatro de Mayo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.24.2201','EC','EC.24','Francisco de Orellana Canton','Francisco de Orellana Canton',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.13.1206','EC','EC.13','Cantón Urdaneta','Canton Urdaneta',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0919','EC','EC.10','Cantón Salitre','Canton Salitre',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.05.0401','EC','EC.05','Cantón Tulcán','Canton Tulcan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.23.1501','EC','EC.23','Cantón Tena','Canton Tena',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.22.2105','EC','EC.22','Cantón Sucumbíos','Canton Sucumbios',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.15.1406','EC','EC.15','Cantón Sucúa','Canton Sucua',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1314','EC','EC.14','Cantón Sucre','Canton Sucre',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.12.1112','EC','EC.12','Cantón Sozoranga','Canton Sozoranga',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.02.0109','EC','EC.02','Cantón Sigsig','Canton Sigsig',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.12.1111','EC','EC.12','Cantón Saraguro','Canton Saraguro',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.26.2301','EC','EC.26','Cantón Santo Domingo de los Colorados','Canton Santo Domingo de los Colorados',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.15.1405','EC','EC.15','Santiago de Méndez','Santiago de Mendez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.08.0712','EC','EC.08','Cantón Santa Rosa','Canton Santa Rosa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.02.0108','EC','EC.02','Cantón Santa Isabel','Canton Santa Isabel',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.25.2401','EC','EC.25','Cantón Santa Elena','Canton Santa Elena',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.01.2003','EC','EC.01','Cantón Santa Cruz','Canton Santa Cruz',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1313','EC','EC.14','Cantón Santa Ana','Canton Santa Ana',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.03.0205','EC','EC.03','Cantón San Miguel','Canton San Miguel',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.09.0805','EC','EC.09','Cantón San Lorenzo','Canton San Lorenzo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.01.2001','EC','EC.01','Cantón San Cristóbal','Canton San Cristobal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0916','EC','EC.10','Cantón Samborondón','Canton Samborondon',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.25.2403','EC','EC.25','Cantón Salinas','Canton Salinas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.07.0505','EC','EC.07','Cantón Salcedo','Canton Salcedo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.18.1705','EC','EC.18','Cantón Rumiñahui','Canton Ruminahui',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1312','EC','EC.14','Cantón Rocafuerte','Canton Rocafuerte',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.06.0601','EC','EC.06','Cantón Riobamba','Canton Riobamba',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.18.1701','EC','EC.18','Cantón Quito','Canton Quito',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.09.0804','EC','EC.09','Cantón Quinindé','Canton Quininde',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.23.1507','EC','EC.23','Cantón Quijos','Canton Quijos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.13.1205','EC','EC.13','Cantón Quevedo','Canton Quevedo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.19.1806','EC','EC.19','Cantón Quero','Canton Quero',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.12.1110','EC','EC.12','Cantón Puyango','Canton Puyango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.22.2103','EC','EC.22','Cantón Putumayo','Canton Putumayo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.07.0504','EC','EC.07','Cantón Pujilí','Canton Pujili',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.13.1204','EC','EC.13','Cantón Puebloviejo','Canton Puebloviejo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1301','EC','EC.14','Cantón Portoviejo','Canton Portoviejo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.08.0711','EC','EC.08','Cantón Portovelo','Canton Portovelo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.08.0710','EC','EC.08','Cantón Piñas','Canton Pinas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.11.1005','EC','EC.11','Cantón Pimampiro','Canton Pimampiro',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.19.1808','EC','EC.19','Cantón Píllaro','Canton Pillaro',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.19.1807','EC','EC.19','Cantón Pelileo','Canton Pelileo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.18.1704','EC','EC.18','Cantón Pedro Moncayo','Canton Pedro Moncayo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.02.0105','EC','EC.02','Cantón Paute','Canton Paute',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.19.1805','EC','EC.19','Cantón Patate','Canton Patate',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.17.1601','EC','EC.17','Cantón Pastaza','Canton Pastaza',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.08.0709','EC','EC.08','Cantón Pasaje','Canton Pasaje',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.07.0503','EC','EC.07','Cantón Pangua','Canton Pangua',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.12.1109','EC','EC.12','Cantón Paltas','Canton Paltas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.15.1404','EC','EC.15','Cantón Palora','Canton Palora',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1310','EC','EC.14','Cantón Paján','Canton Pajan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.11.1004','EC','EC.11','Cantón Otavalo','Canton Otavalo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0912','EC','EC.10','Cantón Naranjito','Canton Naranjito',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0911','EC','EC.10','Cantón Naranjal','Canton Naranjal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.09.0803','EC','EC.09','Cantón Muisne','Canton Muisne',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.15.1401','EC','EC.15','Cantón Morona','Canton Morona',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.05.0405','EC','EC.05','Cantón Montúfar','Canton Montufar',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1309','EC','EC.14','Cantón Montecristi','Canton Montecristi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.05.0404','EC','EC.05','Cantón Mira','Canton Mira',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0910','EC','EC.10','Cantón Milagro','Canton Milagro',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.17.1602','EC','EC.17','Cantón Mera','Canton Mera',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.18.1703','EC','EC.18','Cantón Mejía','Canton Mejia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1308','EC','EC.14','Cantón Manta','Canton Manta',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.08.0701','EC','EC.08','Cantón Machala','Canton Machala',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.12.1108','EC','EC.12','Cantón Macará','Canton Macara',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.12.1101','EC','EC.12','Cantón Loja','Canton Loja',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.15.1403','EC','EC.15','Cantón Limón Indanza','Canton Limon Indanza',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.07.0501','EC','EC.07','Cantón Latacunga','Canton Latacunga',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.22.2101','EC','EC.22','Cantón Lago Agrio','Canton Lago Agrio',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1307','EC','EC.14','Cantón Junín','Canton Junin',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1306','EC','EC.14','Cantón Jipijapa','Canton Jipijapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.01.2002','EC','EC.01','Cantón Isabela','Canton Isabela',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.11.1001','EC','EC.11','Ibarra','Ibarra',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.08.0707','EC','EC.08','Cantón Huaquillas','Canton Huaquillas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0901','EC','EC.10','Cantón Guayaquil','Canton Guayaquil',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.03.0201','EC','EC.03','Cantón Guaranda','Canton Guaranda',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.06.0607','EC','EC.06','Cantón Guano','Canton Guano',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.06.0606','EC','EC.06','Cantón Guamote','Canton Guamote',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.15.1402','EC','EC.15','Cantón Gualaquiza','Canton Gualaquiza',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.02.0103','EC','EC.02','Cantón Gualaceo','Canton Gualaceo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.08.0706','EC','EC.08','Cantón Guabo','Canton Guabo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.12.1107','EC','EC.12','Cantón Gonzanamá','Canton Gonzanama',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.02.0102','EC','EC.02','Cantón Girón','Canton Giron',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.12.1106','EC','EC.12','Cantón Espindola','Canton Espindola',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.05.0403','EC','EC.05','Cantón Espejo','Canton Espejo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.09.0801','EC','EC.09','Cantón Esmeraldas','Canton Esmeraldas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.09.0802','EC','EC.09','Cantón Eloy Alfaro','Canton Eloy Alfaro',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0908','EC','EC.10','Cantón El Empalme','Canton El Empalme',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1304','EC','EC.14','Cantón El Carmen','Canton El Carmen',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0906','EC','EC.10','Cantón Daule','Canton Daule',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.02.0101','EC','EC.02','Cantón Cuenca','Canton Cuenca',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.11.1003','EC','EC.11','Cantón Cotacachi','Canton Cotacachi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.06.0603','EC','EC.06','Cantón Colta','Canton Colta',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.06.0605','EC','EC.06','Cantón Chunchi','Canton Chunchi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1303','EC','EC.14','Cantón Chone','Canton Chone',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.20.1902','EC','EC.20','Cantón Chinchipe','Canton Chinchipe',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.03.0203','EC','EC.03','Cantón Chimbo','Canton Chimbo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.03.0202','EC','EC.03','Cantón Chillanes','Canton Chillanes',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.12.1104','EC','EC.12','Cantón Celica','Canton Celica',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.18.1702','EC','EC.18','Cantón Cayambe','Canton Cayambe',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.12.1103','EC','EC.12','Cantón Catamayo','Canton Catamayo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.04.0303','EC','EC.04','Cantón Cañar','Canton Canar',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.12.1102','EC','EC.12','Cantón Calvas','Canton Calvas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1302','EC','EC.14','Cantón Bolívar','Canton Bolivar',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.04.0302','EC','EC.04','Cantón Biblián','Canton Biblian',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.19.1802','EC','EC.19','Cantón Baños','Canton Banos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0904','EC','EC.10','Cantón Balzar','Canton Balzar',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.13.1201','EC','EC.13','Cantón Babahoyo','Canton Babahoyo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.13.1202','EC','EC.13','Cantón Baba','Canton Baba',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.04.0301','EC','EC.04','Cantón Azogues','Canton Azogues',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.08.0702','EC','EC.08','Cantón Arenillas','Canton Arenillas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.23.1503','EC','EC.23','Cantón Archidona','Canton Archidona',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.11.1002','EC','EC.11','Cantón Antonio Ante','Canton Antonio Ante',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.19.1801','EC','EC.19','Cantón Ambato','Canton Ambato',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.06.0602','EC','EC.06','Cantón Alausí','Canton Alausi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.24.2202','EC','EC.24','Cantón Aguarico','Canton Aguarico',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.02.0107','EC','EC.02','Cantón San Fernando','Canton San Fernando',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.02.0104','EC','EC.02','Cantón Nabón','Canton Nabon',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.13.1211','EC','EC.13','Cantón Valencia','Canton Valencia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.13.1210','EC','EC.13','Cantón Buena Fe','Canton Buena Fe',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.23.1504','EC','EC.23','Cantón Chaco','Canton Chaco',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.07.0507','EC','EC.07','Cantón Sigchos','Canton Sigchos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.06.0610','EC','EC.06','Cumanda','Cumanda',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.05.0402','EC','EC.05','Canton Bolivar','Canton Bolivar',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0905','EC','EC.10','Canton Colimes','Canton Colimes',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.03.0206','EC','EC.03','Canton Caluma','Canton Caluma',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.03.0204','EC','EC.03','Canton Echeandia','Canton Echeandia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.04.0305','EC','EC.04','Canton El Tambo','Canton El Tambo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.03.0207','EC','EC.03','Canton Las Naves','Canton Las Naves',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.18.1708','EC','EC.18','Canton Pedro Vicente Maldonado','Canton Pedro Vicente Maldonado',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1317','EC','EC.14','Canton Pedernales','Canton Pedernales',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.11.1006','EC','EC.11','San Miguel de Urcuqui Canton','San Miguel de Urcuqui Canton',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.09.0807','EC','EC.09','Rio Verde','Rio Verde',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.24.2204','EC','EC.24','Loreto Canton','Loreto Canton',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.06.0608','EC','EC.06','Pallatanga','Pallatanga',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.06.0609','EC','EC.06','Penipe','Penipe',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.08.0703','EC','EC.08','Atahualpa','Atahualpa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.08.0705','EC','EC.08','Chilla','Chilla',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.08.0708','EC','EC.08','Marcabelí','Marcabeli',1);
INSERT INTO `<<prefix>>subadmin2` (`id`, `code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES (12517,'EC.10.0902','EC','EC.10','Alfredo Baquerizo Moreno (Juján)','Alfredo Baquerizo Moreno (Jujan)',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0903','EC','EC.10','Balao','Balao',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.09.0806','EC','EC.09','Atacames','Atacames',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0907','EC','EC.10','Durán','Duran',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0909','EC','EC.10','El Triunfo','El Triunfo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0913','EC','EC.10','Palestina','Palestina',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0914','EC','EC.10','Pedro Carbo','Pedro Carbo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0918','EC','EC.10','Santa Lucía','Santa Lucia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0923','EC','EC.10','Coronel Marcelino Maridueña','Coronel Marcelino Mariduena',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.12.1105','EC','EC.12','Chaguarpamba','Chaguarpamba',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0924','EC','EC.10','Lomas De Sargentillo','Lomas De Sargentillo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0921','EC','EC.10','Playas','Playas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0922','EC','EC.10','Simón Bolívar','Simon Bolivar',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0925','EC','EC.10','Nobol','Nobol',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0927','EC','EC.10','General Antonio Elizalde','General Antonio Elizalde',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.10.0928','EC','EC.10','Isidro Ayora','Isidro Ayora',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.02.0111','EC','EC.02','Chordeleg','Chordeleg',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.02.0112','EC','EC.02','El Pan','El Pan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.02.0113','EC','EC.02','Sevilla De Oro','Sevilla De Oro',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.02.0114','EC','EC.02','Guachapala','Guachapala',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.08.0714','EC','EC.08','Las Lajas','Las Lajas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.13.1212','EC','EC.13','Mocache','Mocache',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.15.1407','EC','EC.15','Huamboya','Huamboya',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1311','EC','EC.14','Pichincha','Pichincha',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.22.2106','EC','EC.22','Cascales','Cascales',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.22.2107','EC','EC.22','Cuyabeno','Cuyabeno',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.24.2203','EC','EC.24','La Joya De Los Sachas','La Joya De Los Sachas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1315','EC','EC.14','Tosagua','Tosagua',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1318','EC','EC.14','Olmedo','Olmedo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1319','EC','EC.14','Puerto López','Puerto Lopez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1320','EC','EC.14','Jama','Jama',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1321','EC','EC.14','Jaramijó','Jaramijo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.15.1408','EC','EC.15','San Juan Bosco','San Juan Bosco',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.15.1409','EC','EC.15','Taisha','Taisha',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.15.1410','EC','EC.15','Logroño','Logrono',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.23.1509','EC','EC.23','Carlos Julio Arosemena Tola','Carlos Julio Arosemena Tola',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.17.1604','EC','EC.17','Arajuno','Arajuno',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.18.1707','EC','EC.18','San Miguel De Los Bancos','San Miguel De Los Bancos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.18.1709','EC','EC.18','Puerto Quito','Puerto Quito',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.19.1803','EC','EC.19','Cevallos','Cevallos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.19.1804','EC','EC.19','Mocha','Mocha',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.19.1809','EC','EC.19','Tisaleo','Tisaleo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.20.1903','EC','EC.20','Nangaritza','Nangaritza',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.20.1906','EC','EC.20','El Pangui','El Pangui',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.20.1907','EC','EC.20','Centinela Del Cóndor','Centinela Del Condor',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.20.1908','EC','EC.20','Palanda','Palanda',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.22.2102','EC','EC.22','Gonzalo Pizarro','Gonzalo Pizarro',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.12.1113','EC','EC.12','Zapotillo','Zapotillo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.12.1114','EC','EC.12','Pindal','Pindal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.12.1115','EC','EC.12','Quilanga','Quilanga',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.12.1116','EC','EC.12','Olmedo','Olmedo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.13.1203','EC','EC.13','Montalvo','Montalvo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.13.1209','EC','EC.13','Palenque','Palenque',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1305','EC','EC.14','Flavio Alfaro','Flavio Alfaro',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.02.0106','EC','EC.02','Pucara','Pucara',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.04.0304','EC','EC.04','La Troncal','La Troncal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.04.0306','EC','EC.04','Déleg','Deleg',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.04.0307','EC','EC.04','Suscal','Suscal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.05.0406','EC','EC.05','San Pedro De Huaca','San Pedro De Huaca',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.07.0502','EC','EC.07','La Maná','La Mana',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.07.0506','EC','EC.07','Saquisilí','Saquisili',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.06.0604','EC','EC.06','Chambo','Chambo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.08.0704','EC','EC.08','Balsas','Balsas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.02.0110','EC','EC.02','Oña','Ona',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.22.2104','EC','EC.22','Shushufindi','Shushufindi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.02.0115','EC','EC.02','Camilo Ponce Enríquez','Camilo Ponce Enriquez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.13.1213','EC','EC.13','Quinsaloma','Quinsaloma',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.14.1322','EC','EC.14','San Vicente','San Vicente',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.15.1412','EC','EC.15','Tiwintza','Tiwintza',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.17.1603','EC','EC.17','Santa Clara','Santa Clara',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.20.1909','EC','EC.20','Paquisha','Paquisha',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.25.2402','EC','EC.25','La Libertad','La Libertad',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.15.1411','EC','EC.15','Pablo Sexto','Pablo Sexto',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('EC.26.2302','EC','EC.26','La Concordia','La Concordia',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 ('EC','Zaruma','Zaruma',-79.6117,-3.69132,'P','PPL','EC.08','EC.08.0713',12505,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Zamora','Zamora',-78.9549,-4.06685,'P','PPLA','EC.20','EC.20.1901',15276,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Yantzaza','Yantzaza',-78.7608,-3.83261,'P','PPL','EC.20','EC.20.1905',9970,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Yaguachi Nuevo','Yaguachi Nuevo',-79.6948,-2.0968,'P','PPL','EC.10','EC.10.0920',27947,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Vinces','Vinces',-79.7519,-1.55611,'P','PPL','EC.13','EC.13.1208',32497,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Ventanas','Ventanas',-79.4594,-1.44158,'P','PPL','EC.13','EC.13.1207',46708,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Velasco Ibarra','Velasco Ibarra',-79.6384,-1.04376,'P','PPL','EC.10','EC.10.0908',48754,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Valdez','Valdez',-78.9831,1.24917,'P','PPL','EC.09','EC.09.0802',11441,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Tulcán','Tulcan',-77.7173,0.81187,'P','PPLA','EC.05','EC.05.0401',86498,'America/Guayaquil',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 ('EC','Tosagua','Tosagua',-80.2347,-0.78679,'P','PPL','EC.14','EC.14.1315',14680,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Tena','Tena',-77.8129,-0.9938,'P','PPLA','EC.23','EC.23.1501',17172,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Sucúa','Sucua',-78.1717,-2.45866,'P','PPL','EC.15','EC.15.1406',7413,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Sucre','Sucre',-80.4189,-1.27974,'P','PPL','EC.14','EC.14.1316',15286,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Santo Domingo de los Colorados','Santo Domingo de los Colorados',-79.1754,-0.25305,'P','PPLA','EC.26','EC.26.2301',200421,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Santa Rosa','Santa Rosa',-79.9595,-3.44882,'P','PPL','EC.08','EC.08.0712',41816,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Santa Lucía','Santa Lucia',-80,-2.18333,'P','PPL','EC.10','EC.10.0901',12523,'America/Guayaquil',1,'2018-12-04 23:00:00','2018-12-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 ('EC','Santa Elena','Santa Elena',-80.8587,-2.22622,'P','PPLA','EC.25','EC.25.2401',42214,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Santa Ana','Santa Ana',-80.3713,-1.20726,'P','PPL','EC.14','EC.14.1313',12833,'America/Guayaquil',1,'2018-12-04 23:00:00','2018-12-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 ('EC','San Miguel de Salcedo','San Miguel de Salcedo',-78.5906,-1.04547,'P','PPL','EC.07','EC.07.0505',10838,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','San Miguel','San Miguel',-79.0431,-1.70884,'P','PPL','EC.03','EC.03.0205',12575,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','San Lorenzo de Esmeraldas','San Lorenzo de Esmeraldas',-78.8351,1.28626,'P','PPL','EC.09','EC.09.0805',20209,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Sangolquí','Sangolqui',-78.4522,-0.33405,'P','PPL','EC.18','EC.18.1705',5114,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','San Gabriel','San Gabriel',-77.8308,0.59318,'P','PPL','EC.05','EC.05.0405',15112,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Samborondón','Samborondon',-79.724,-1.96276,'P','PPL','EC.10','EC.10.0916',24118,'America/Guayaquil',1,'2018-04-09 23:00:00','2018-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 ('EC','Salinas','Salinas',-80.9515,-2.21452,'P','PPL','EC.25','EC.25.2403',43862,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Rosa Zarate','Rosa Zarate',-79.4741,0.32779,'P','PPL','EC.09','EC.09.0804',42121,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Rocafuerte','Rocafuerte',-80.4495,-0.9236,'P','PPL','EC.14','EC.14.1312',10274,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Riobamba','Riobamba',-78.6471,-1.67098,'P','PPLA','EC.06','EC.06.0601',124478,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Quito','Quito',-78.5249,-0.22985,'P','PPLC','EC.18','EC.18.1701',1399814,'America/Guayaquil',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 ('EC','Quevedo','Quevedo',-79.4635,-1.02863,'P','PPL','EC.13','EC.13.1205',119436,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Puyo','Puyo',-78.0026,-1.48369,'P','PPLA','EC.17','EC.17.1601',24881,'America/Guayaquil',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 ('EC','Pujilí','Pujili',-78.6964,-0.95759,'P','PPL','EC.07','EC.07.0504',16168,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Puerto Francisco de Orellana','Puerto Francisco de Orellana',-76.9872,-0.46645,'P','PPLA','EC.24','EC.24.2201',48144,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Puerto Bolívar','Puerto Bolivar',-79.9975,-3.26649,'P','PPL','EC.08','EC.08.0701',8300,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Puerto Baquerizo Moreno','Puerto Baquerizo Moreno',-89.6102,-0.90172,'P','PPLA','EC.01','EC.01.2001',4214,'Pacific/Galapagos',1,'2018-03-05 23:00:00','2018-03-05 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 ('EC','Puerto Ayora','Puerto Ayora',-90.3138,-0.74018,'P','PPL','EC.01','EC.01.2003',8996,'Pacific/Galapagos',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Portoviejo','Portoviejo',-80.4545,-1.05458,'P','PPLA','EC.14','EC.14.1301',170326,'America/Guayaquil',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 ('EC','Portovelo','Portovelo',-79.6219,-3.72145,'P','PPL','EC.08','EC.08.0711',9708,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Playas','Playas',-80.3881,-2.63199,'P','PPL','EC.10','EC.10.0921',30564,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Piñas','Pinas',-79.6808,-3.68107,'P','PPL','EC.08','EC.08.0710',16981,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Pimampiro','Pimampiro',-77.9407,0.39116,'P','PPL','EC.11','EC.11.1005',7408,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Píllaro','Pillaro',-78.5468,-1.17414,'P','PPL','EC.19','EC.19.1808',7462,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Pelileo','Pelileo',-78.5434,-1.3299,'P','PPL','EC.19','EC.19.1807',16572,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Pedro Carbo','Pedro Carbo',-80.2331,-1.81563,'P','PPL','EC.10','EC.10.0914',23372,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Pedernales','Pedernales',-80.0525,0.07167,'P','PPL','EC.14','EC.14.1317',5983,'America/Guayaquil',1,'2018-05-08 23:00:00','2018-05-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 ('EC','Pasaje','Pasaje',-79.807,-3.32561,'P','PPL','EC.08','EC.08.0709',44860,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Palora','Palora',-77.9652,-1.70131,'P','PPL','EC.15','EC.15.1404',6472,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Palestina','Palestina',-79.714,-1.93709,'P','PPL','EC.10','EC.10.0919',9364,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Palenque','Palenque',-79.7565,-1.43795,'P','PPL','EC.13','EC.13.1209',9083,'America/Guayaquil',1,'2018-07-03 23:00:00','2018-07-03 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 ('EC','Paján','Pajan',-80.4296,-1.55238,'P','PPL','EC.14','EC.14.1310',9183,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Otavalo','Otavalo',-78.2625,0.23457,'P','PPL','EC.11','EC.11.1004',32330,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Naranjito','Naranjito',-79.4654,-2.16671,'P','PPL','EC.10','EC.10.0912',34206,'America/Guayaquil',1,'2018-07-03 23:00:00','2018-07-03 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 ('EC','Naranjal','Naranjal',-79.6183,-2.67364,'P','PPL','EC.10','EC.10.0911',32045,'America/Guayaquil',1,'2018-05-08 23:00:00','2018-05-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 ('EC','Muisne','Muisne',-80.0186,0.61129,'P','PPL','EC.09','EC.09.0803',13393,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Montecristi','Montecristi',-80.6589,-1.04576,'P','PPL','EC.14','EC.14.1309',18351,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Montalvo','Montalvo',-79.2876,-1.79008,'P','PPL','EC.13','EC.13.1203',15547,'America/Guayaquil',1,'2018-07-03 23:00:00','2018-07-03 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 ('EC','Milagro','Milagro',-79.5941,-2.13404,'P','PPL','EC.10','EC.10.0910',133508,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Manta','Manta',-80.7127,-0.96212,'P','PPL','EC.14','EC.14.1308',183166,'America/Guayaquil',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 ('EC','Machala','Machala',-79.9605,-3.25861,'P','PPLA','EC.08','EC.08.0701',198123,'America/Guayaquil',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 ('EC','Machachi','Machachi',-78.5671,-0.51011,'P','PPL','EC.18','EC.18.1703',25742,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Macas','Macas',-78.1114,-2.30868,'P','PPLA','EC.15','EC.15.1401',23687,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Macará','Macara',-79.9437,-4.38181,'P','PPL','EC.12','EC.12.1108',13035,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Lomas de Sargentillo','Lomas de Sargentillo',-80.0833,-1.88333,'P','PPL','EC.10','EC.10.0924',7542,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Loja','Loja',-79.2042,-3.99313,'P','PPLA','EC.12','EC.12.1101',117796,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','La Troncal','La Troncal',-79.3398,-2.42355,'P','PPL','EC.04','EC.04.0304',36353,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Latacunga','Latacunga',-78.6155,-0.93521,'P','PPLA','EC.07','EC.07.0501',51717,'America/Guayaquil',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 ('EC','La Maná','La Mana',-79.2251,-0.94094,'P','PPL','EC.07','EC.07.0502',16450,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','La Libertad','La Libertad',-80.9104,-2.233,'P','PPL','EC.10',NULL,75881,'America/Guayaquil',1,'2013-01-10 23:00:00','2013-01-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 ('EC','Nueva Loja','Nueva Loja',-76.8953,0.086,'P','PPLA','EC.22','EC.22.2101',24211,'America/Guayaquil',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 ('EC','Junín','Junin',-80.2058,-0.92777,'P','PPL','EC.14','EC.14.1307',9128,'America/Guayaquil',1,'2018-12-04 23:00:00','2018-12-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 ('EC','Jipijapa','Jipijapa',-80.5788,-1.34872,'P','PPL','EC.14','EC.14.1306',35901,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Ibarra','Ibarra',-78.1223,0.35171,'P','PPLA','EC.11','EC.11.1001',132977,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Huaquillas','Huaquillas',-80.2308,-3.47523,'P','PPL','EC.08','EC.08.0707',39757,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Guayaquil','Guayaquil',-79.8862,-2.19616,'P','PPLA','EC.10','EC.10.0901',1952029,'America/Guayaquil',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 ('EC','Guaranda','Guaranda',-79.001,-1.59263,'P','PPLA','EC.03','EC.03.0201',22199,'America/Guayaquil',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 ('EC','Guano','Guano',-78.6311,-1.60789,'P','PPL','EC.06','EC.06.0607',12659,'America/Guayaquil',1,'2018-05-08 23:00:00','2018-05-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 ('EC','Gualaceo','Gualaceo',-78.7781,-2.89264,'P','PPL','EC.02','EC.02.0103',17122,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Esmeraldas','Esmeraldas',-79.654,0.9592,'P','PPLA','EC.09','EC.09.0801',165216,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','El Triunfo','El Triunfo',-79.9667,-1.93333,'P','PPL','EC.10','EC.10.0906',32282,'America/Guayaquil',1,'2018-05-08 23:00:00','2018-05-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 ('EC','Eloy Alfaro','Eloy Alfaro',-79.8552,-2.17579,'P','PPL','EC.10','EC.10.0907',167784,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Cuenca','Cuenca',-79.0045,-2.90055,'P','PPLA','EC.02','EC.02.0101',276964,'America/Guayaquil',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 ('EC','Cotacachi','Cotacachi',-78.2643,0.30107,'P','PPL','EC.11','EC.11.1003',8238,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Coronel Marcelino Maridueña','Coronel Marcelino Mariduena',-79.4325,-2.20924,'P','PPL','EC.10','EC.10.0923',7303,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Colimes','Colimes',-80.0117,-1.54553,'P','PPL','EC.10','EC.10.0905',9384,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Chone','Chone',-80.0936,-0.69819,'P','PPL','EC.14','EC.14.1303',44751,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Celica','Celica',-79.9566,-4.10266,'P','PPL','EC.12','EC.12.1104',5499,'America/Guayaquil',1,'2018-05-08 23:00:00','2018-05-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 ('EC','Cayambe','Cayambe',-78.1452,0.04084,'P','PPL','EC.18','EC.18.1702',26582,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Catarama','Catarama',-79.46,-1.57504,'P','PPL','EC.13','EC.13.1206',9723,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Catamayo','Catamayo',-79.3591,-3.98652,'P','PPL','EC.12','EC.12.1103',18565,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Catacocha','Catacocha',-79.6494,-4.04974,'P','PPL','EC.12','EC.12.1109',10872,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Cariamanga','Cariamanga',-79.5555,-4.32796,'P','PPL','EC.12','EC.12.1102',16862,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Cañar','Canar',-78.9394,-2.56062,'P','PPL','EC.04','EC.04.0303',9900,'America/Guayaquil',1,'2018-12-04 23:00:00','2018-12-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 ('EC','Calceta','Calceta',-80.1639,-0.84582,'P','PPL','EC.14','EC.14.1302',17286,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Boca Suno','Boca Suno',-77.1408,-0.69832,'P','PPL','EC.24',NULL,20313,'America/Guayaquil',1,'2013-01-10 23:00:00','2013-01-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 ('EC','Baños','Banos',-78.4229,-1.39699,'P','PPL','EC.19','EC.19.1802',9501,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Balzar','Balzar',-79.9049,-1.36501,'P','PPL','EC.10','EC.10.0904',40115,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Baláo','Balao',-79.8144,-2.911,'P','PPL','EC.10','EC.10.0903',12205,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Bahía de Caráquez','Bahia de Caraquez',-80.4237,-0.59792,'P','PPL','EC.14','EC.14.1314',37056,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Babahoyo','Babahoyo',-79.5344,-1.80217,'P','PPLA','EC.13','EC.13.1201',76279,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Azogues','Azogues',-78.8486,-2.73969,'P','PPLA','EC.04','EC.04.0301',34877,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Atuntaqui','Atuntaqui',-78.2137,0.33247,'P','PPL','EC.11','EC.11.1002',17456,'America/Guayaquil',1,'2018-05-08 23:00:00','2018-05-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 ('EC','Archidona','Archidona',-77.8077,-0.9095,'P','PPL','EC.23','EC.23.1503',7309,'America/Guayaquil',1,'2018-05-08 23:00:00','2018-05-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 ('EC','Ambato','Ambato',-78.6168,-1.24908,'P','PPLA','EC.19','EC.19.1801',154369,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Alfredo Baquerizo Moreno','Alfredo Baquerizo Moreno',-79.5167,-1.91667,'P','PPL','EC.10','EC.10.0902',12617,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Alausí','Alausi',-78.8471,-2.20329,'P','PPL','EC.06','EC.06.0602',14294,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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 ('EC','Tutamandahostel','Tutamandahostel',-78.4975,-0.19727,'P','PPLL','EC.18','EC.18.1701',140000,'America/Guayaquil',1,'2017-02-06 23:00:00','2017-02-06 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
