-- MySQL dump 10.13  Distrib 5.7.34, for osx10.12 (x86_64)
--
-- Host: 127.0.0.1    Database: laraclassifier
-- ------------------------------------------------------
-- Server version	5.7.34

/*!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`, `active`) VALUES ('EC.20','EC','{\"en\":\"Zamora-Chinchipe\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.19','EC','{\"en\":\"Tungurahua\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.18','EC','{\"en\":\"Pichincha\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.17','EC','{\"en\":\"Pastaza\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.23','EC','{\"en\":\"Napo\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.15','EC','{\"en\":\"Morona-Santiago\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.14','EC','{\"en\":\"Manabí\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.13','EC','{\"en\":\"Los Ríos\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.12','EC','{\"en\":\"Loja\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.11','EC','{\"en\":\"Imbabura\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.10','EC','{\"en\":\"Guayas\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.01','EC','{\"en\":\"Galápagos\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.09','EC','{\"en\":\"Esmeraldas\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.08','EC','{\"en\":\"El Oro\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.07','EC','{\"en\":\"Cotopaxi\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.06','EC','{\"en\":\"Chimborazo\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.05','EC','{\"en\":\"Carchi\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.04','EC','{\"en\":\"Cañar\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.03','EC','{\"en\":\"Bolívar\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.02','EC','{\"en\":\"Azuay\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.22','EC','{\"en\":\"Sucumbios\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.24','EC','{\"en\":\"Orellana\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.26','EC','{\"en\":\"Santo Domingo de los Tsáchilas\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('EC.25','EC','{\"en\":\"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`, `active`) VALUES ('EC.08.0713','EC','EC.08','{\"en\":\"Cantón Zaruma\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.20.1901','EC','EC.20','{\"en\":\"Cantón Zamora\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.20.1905','EC','EC.20','{\"en\":\"Cantón Yantzaza\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0920','EC','EC.10','{\"en\":\"Cantón Yaguachi\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.20.1904','EC','EC.20','{\"en\":\"Cantón Yacuambi\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.13.1208','EC','EC.13','{\"en\":\"Cantón Vinces\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.13.1207','EC','EC.13','{\"en\":\"Cantón Ventanas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1316','EC','EC.14','{\"en\":\"Cantón Veinticuatro de Mayo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.24.2201','EC','EC.24','{\"en\":\"Francisco de Orellana Canton\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.13.1206','EC','EC.13','{\"en\":\"Cantón Urdaneta\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0919','EC','EC.10','{\"en\":\"Cantón Salitre\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.05.0401','EC','EC.05','{\"en\":\"Cantón Tulcán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.23.1501','EC','EC.23','{\"en\":\"Cantón Tena\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.22.2105','EC','EC.22','{\"en\":\"Cantón Sucumbíos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.15.1406','EC','EC.15','{\"en\":\"Cantón Sucúa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1314','EC','EC.14','{\"en\":\"Cantón Sucre\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.12.1112','EC','EC.12','{\"en\":\"Cantón Sozoranga\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.02.0109','EC','EC.02','{\"en\":\"Cantón Sigsig\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.12.1111','EC','EC.12','{\"en\":\"Cantón Saraguro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.26.2301','EC','EC.26','{\"en\":\"Cantón Santo Domingo de los Colorados\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.15.1405','EC','EC.15','{\"en\":\"Santiago de Méndez\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.08.0712','EC','EC.08','{\"en\":\"Cantón Santa Rosa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.02.0108','EC','EC.02','{\"en\":\"Cantón Santa Isabel\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.25.2401','EC','EC.25','{\"en\":\"Cantón Santa Elena\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.01.2003','EC','EC.01','{\"en\":\"Cantón Santa Cruz\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1313','EC','EC.14','{\"en\":\"Cantón Santa Ana\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.03.0205','EC','EC.03','{\"en\":\"Cantón San Miguel\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.09.0805','EC','EC.09','{\"en\":\"Cantón San Lorenzo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.01.2001','EC','EC.01','{\"en\":\"Cantón San Cristóbal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0916','EC','EC.10','{\"en\":\"Cantón Samborondón\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.25.2403','EC','EC.25','{\"en\":\"Cantón Salinas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.07.0505','EC','EC.07','{\"en\":\"Cantón Salcedo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.18.1705','EC','EC.18','{\"en\":\"Cantón Rumiñahui\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1312','EC','EC.14','{\"en\":\"Cantón Rocafuerte\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.06.0601','EC','EC.06','{\"en\":\"Cantón Riobamba\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.18.1701','EC','EC.18','{\"en\":\"Cantón Quito\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.09.0804','EC','EC.09','{\"en\":\"Cantón Quinindé\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.23.1507','EC','EC.23','{\"en\":\"Cantón Quijos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.13.1205','EC','EC.13','{\"en\":\"Cantón Quevedo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.19.1806','EC','EC.19','{\"en\":\"Cantón Quero\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.12.1110','EC','EC.12','{\"en\":\"Cantón Puyango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.22.2103','EC','EC.22','{\"en\":\"Cantón Putumayo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.07.0504','EC','EC.07','{\"en\":\"Cantón Pujilí\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.13.1204','EC','EC.13','{\"en\":\"Cantón Puebloviejo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1301','EC','EC.14','{\"en\":\"Cantón Portoviejo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.08.0711','EC','EC.08','{\"en\":\"Cantón Portovelo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.08.0710','EC','EC.08','{\"en\":\"Cantón Piñas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.11.1005','EC','EC.11','{\"en\":\"Cantón Pimampiro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.19.1808','EC','EC.19','{\"en\":\"Cantón Píllaro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.19.1807','EC','EC.19','{\"en\":\"Cantón Pelileo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.18.1704','EC','EC.18','{\"en\":\"Cantón Pedro Moncayo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.02.0105','EC','EC.02','{\"en\":\"Cantón Paute\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.19.1805','EC','EC.19','{\"en\":\"Cantón Patate\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.17.1601','EC','EC.17','{\"en\":\"Cantón Pastaza\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.08.0709','EC','EC.08','{\"en\":\"Cantón Pasaje\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.07.0503','EC','EC.07','{\"en\":\"Cantón Pangua\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.12.1109','EC','EC.12','{\"en\":\"Cantón Paltas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.15.1404','EC','EC.15','{\"en\":\"Cantón Palora\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1310','EC','EC.14','{\"en\":\"Cantón Paján\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.11.1004','EC','EC.11','{\"en\":\"Cantón Otavalo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0912','EC','EC.10','{\"en\":\"Cantón Naranjito\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0911','EC','EC.10','{\"en\":\"Cantón Naranjal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.09.0803','EC','EC.09','{\"en\":\"Cantón Muisne\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.15.1401','EC','EC.15','{\"en\":\"Cantón Morona\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.05.0405','EC','EC.05','{\"en\":\"Cantón Montúfar\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1309','EC','EC.14','{\"en\":\"Cantón Montecristi\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.05.0404','EC','EC.05','{\"en\":\"Cantón Mira\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0910','EC','EC.10','{\"en\":\"Cantón Milagro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.17.1602','EC','EC.17','{\"en\":\"Cantón Mera\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.18.1703','EC','EC.18','{\"en\":\"Cantón Mejía\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1308','EC','EC.14','{\"en\":\"Cantón Manta\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.08.0701','EC','EC.08','{\"en\":\"Cantón Machala\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.12.1108','EC','EC.12','{\"en\":\"Cantón Macará\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.12.1101','EC','EC.12','{\"en\":\"Cantón Loja\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.15.1403','EC','EC.15','{\"en\":\"Cantón Limón Indanza\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.07.0501','EC','EC.07','{\"en\":\"Cantón Latacunga\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.22.2101','EC','EC.22','{\"en\":\"Cantón Lago Agrio\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1307','EC','EC.14','{\"en\":\"Cantón Junín\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1306','EC','EC.14','{\"en\":\"Cantón Jipijapa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.01.2002','EC','EC.01','{\"en\":\"Cantón Isabela\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.11.1001','EC','EC.11','{\"en\":\"Ibarra\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.08.0707','EC','EC.08','{\"en\":\"Cantón Huaquillas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0901','EC','EC.10','{\"en\":\"Cantón Guayaquil\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.03.0201','EC','EC.03','{\"en\":\"Cantón Guaranda\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.06.0607','EC','EC.06','{\"en\":\"Cantón Guano\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.06.0606','EC','EC.06','{\"en\":\"Cantón Guamote\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.15.1402','EC','EC.15','{\"en\":\"Cantón Gualaquiza\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.02.0103','EC','EC.02','{\"en\":\"Cantón Gualaceo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.08.0706','EC','EC.08','{\"en\":\"Cantón Guabo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.12.1107','EC','EC.12','{\"en\":\"Cantón Gonzanamá\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.02.0102','EC','EC.02','{\"en\":\"Cantón Girón\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.12.1106','EC','EC.12','{\"en\":\"Cantón Espindola\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.05.0403','EC','EC.05','{\"en\":\"Cantón Espejo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.09.0801','EC','EC.09','{\"en\":\"Cantón Esmeraldas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.09.0802','EC','EC.09','{\"en\":\"Cantón Eloy Alfaro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0908','EC','EC.10','{\"en\":\"Cantón El Empalme\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1304','EC','EC.14','{\"en\":\"Cantón El Carmen\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0906','EC','EC.10','{\"en\":\"Cantón Daule\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.02.0101','EC','EC.02','{\"en\":\"Cantón Cuenca\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.11.1003','EC','EC.11','{\"en\":\"Cantón Cotacachi\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.06.0603','EC','EC.06','{\"en\":\"Cantón Colta\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.06.0605','EC','EC.06','{\"en\":\"Cantón Chunchi\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1303','EC','EC.14','{\"en\":\"Cantón Chone\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.20.1902','EC','EC.20','{\"en\":\"Cantón Chinchipe\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.03.0203','EC','EC.03','{\"en\":\"Cantón Chimbo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.03.0202','EC','EC.03','{\"en\":\"Cantón Chillanes\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.12.1104','EC','EC.12','{\"en\":\"Cantón Celica\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.18.1702','EC','EC.18','{\"en\":\"Cantón Cayambe\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.12.1103','EC','EC.12','{\"en\":\"Cantón Catamayo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.04.0303','EC','EC.04','{\"en\":\"Cantón Cañar\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.12.1102','EC','EC.12','{\"en\":\"Cantón Calvas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1302','EC','EC.14','{\"en\":\"Cantón Bolívar\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.04.0302','EC','EC.04','{\"en\":\"Cantón Biblián\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.19.1802','EC','EC.19','{\"en\":\"Cantón Baños\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0904','EC','EC.10','{\"en\":\"Cantón Balzar\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.13.1201','EC','EC.13','{\"en\":\"Cantón Babahoyo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.13.1202','EC','EC.13','{\"en\":\"Cantón Baba\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.04.0301','EC','EC.04','{\"en\":\"Cantón Azogues\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.08.0702','EC','EC.08','{\"en\":\"Cantón Arenillas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.23.1503','EC','EC.23','{\"en\":\"Cantón Archidona\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.11.1002','EC','EC.11','{\"en\":\"Cantón Antonio Ante\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.19.1801','EC','EC.19','{\"en\":\"Cantón Ambato\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.06.0602','EC','EC.06','{\"en\":\"Cantón Alausí\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.24.2202','EC','EC.24','{\"en\":\"Cantón Aguarico\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.02.0107','EC','EC.02','{\"en\":\"Cantón San Fernando\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.02.0104','EC','EC.02','{\"en\":\"Cantón Nabón\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.13.1211','EC','EC.13','{\"en\":\"Cantón Valencia\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.13.1210','EC','EC.13','{\"en\":\"Cantón Buena Fe\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.23.1504','EC','EC.23','{\"en\":\"Cantón Chaco\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.07.0507','EC','EC.07','{\"en\":\"Cantón Sigchos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.06.0610','EC','EC.06','{\"en\":\"Cumanda\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.05.0402','EC','EC.05','{\"en\":\"Canton Bolivar\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0905','EC','EC.10','{\"en\":\"Canton Colimes\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.03.0206','EC','EC.03','{\"en\":\"Canton Caluma\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.03.0204','EC','EC.03','{\"en\":\"Canton Echeandia\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.04.0305','EC','EC.04','{\"en\":\"Canton El Tambo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.03.0207','EC','EC.03','{\"en\":\"Canton Las Naves\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.18.1708','EC','EC.18','{\"en\":\"Canton Pedro Vicente Maldonado\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1317','EC','EC.14','{\"en\":\"Canton Pedernales\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.11.1006','EC','EC.11','{\"en\":\"San Miguel de Urcuqui Canton\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.09.0807','EC','EC.09','{\"en\":\"Rio Verde\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.24.2204','EC','EC.24','{\"en\":\"Loreto Canton\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.06.0608','EC','EC.06','{\"en\":\"Pallatanga\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.06.0609','EC','EC.06','{\"en\":\"Penipe\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.08.0703','EC','EC.08','{\"en\":\"Atahualpa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.08.0705','EC','EC.08','{\"en\":\"Chilla\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.08.0708','EC','EC.08','{\"en\":\"Marcabelí\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0902','EC','EC.10','{\"en\":\"Alfredo Baquerizo Moreno (Juján)\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0903','EC','EC.10','{\"en\":\"Balao\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.09.0806','EC','EC.09','{\"en\":\"Atacames\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0907','EC','EC.10','{\"en\":\"Durán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0909','EC','EC.10','{\"en\":\"El Triunfo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0913','EC','EC.10','{\"en\":\"Palestina\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0914','EC','EC.10','{\"en\":\"Pedro Carbo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0918','EC','EC.10','{\"en\":\"Santa Lucía\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0923','EC','EC.10','{\"en\":\"Coronel Marcelino Maridueña\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.12.1105','EC','EC.12','{\"en\":\"Chaguarpamba\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0924','EC','EC.10','{\"en\":\"Lomas De Sargentillo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0921','EC','EC.10','{\"en\":\"Playas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0922','EC','EC.10','{\"en\":\"Simón Bolívar\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0925','EC','EC.10','{\"en\":\"Nobol\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0927','EC','EC.10','{\"en\":\"General Antonio Elizalde\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.10.0928','EC','EC.10','{\"en\":\"Isidro Ayora\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.02.0111','EC','EC.02','{\"en\":\"Chordeleg\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.02.0112','EC','EC.02','{\"en\":\"El Pan\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.02.0113','EC','EC.02','{\"en\":\"Sevilla De Oro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.02.0114','EC','EC.02','{\"en\":\"Guachapala\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.08.0714','EC','EC.08','{\"en\":\"Las Lajas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.13.1212','EC','EC.13','{\"en\":\"Mocache\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.15.1407','EC','EC.15','{\"en\":\"Huamboya\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1311','EC','EC.14','{\"en\":\"Pichincha\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.22.2106','EC','EC.22','{\"en\":\"Cascales\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.22.2107','EC','EC.22','{\"en\":\"Cuyabeno\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.24.2203','EC','EC.24','{\"en\":\"La Joya De Los Sachas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1315','EC','EC.14','{\"en\":\"Tosagua\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1318','EC','EC.14','{\"en\":\"Olmedo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1319','EC','EC.14','{\"en\":\"Puerto López\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1320','EC','EC.14','{\"en\":\"Jama\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1321','EC','EC.14','{\"en\":\"Jaramijó\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.15.1408','EC','EC.15','{\"en\":\"San Juan Bosco\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.15.1409','EC','EC.15','{\"en\":\"Taisha\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.15.1410','EC','EC.15','{\"en\":\"Logroño\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.23.1509','EC','EC.23','{\"en\":\"Carlos Julio Arosemena Tola\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.17.1604','EC','EC.17','{\"en\":\"Arajuno\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.18.1707','EC','EC.18','{\"en\":\"San Miguel De Los Bancos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.18.1709','EC','EC.18','{\"en\":\"Puerto Quito\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.19.1803','EC','EC.19','{\"en\":\"Cevallos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.19.1804','EC','EC.19','{\"en\":\"Mocha\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.19.1809','EC','EC.19','{\"en\":\"Tisaleo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.20.1903','EC','EC.20','{\"en\":\"Nangaritza\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.20.1906','EC','EC.20','{\"en\":\"El Pangui\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.20.1907','EC','EC.20','{\"en\":\"Centinela Del Cóndor\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.20.1908','EC','EC.20','{\"en\":\"Palanda\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.22.2102','EC','EC.22','{\"en\":\"Gonzalo Pizarro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.12.1113','EC','EC.12','{\"en\":\"Zapotillo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.12.1114','EC','EC.12','{\"en\":\"Pindal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.12.1115','EC','EC.12','{\"en\":\"Quilanga\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.12.1116','EC','EC.12','{\"en\":\"Olmedo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.13.1203','EC','EC.13','{\"en\":\"Montalvo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.13.1209','EC','EC.13','{\"en\":\"Palenque\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1305','EC','EC.14','{\"en\":\"Flavio Alfaro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.02.0106','EC','EC.02','{\"en\":\"Pucara\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.04.0304','EC','EC.04','{\"en\":\"La Troncal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.04.0306','EC','EC.04','{\"en\":\"Déleg\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.04.0307','EC','EC.04','{\"en\":\"Suscal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.05.0406','EC','EC.05','{\"en\":\"San Pedro De Huaca\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.07.0502','EC','EC.07','{\"en\":\"La Maná\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.07.0506','EC','EC.07','{\"en\":\"Saquisilí\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.06.0604','EC','EC.06','{\"en\":\"Chambo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.08.0704','EC','EC.08','{\"en\":\"Balsas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.02.0110','EC','EC.02','{\"en\":\"Oña\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.22.2104','EC','EC.22','{\"en\":\"Shushufindi\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.02.0115','EC','EC.02','{\"en\":\"Camilo Ponce Enríquez\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.13.1213','EC','EC.13','{\"en\":\"Quinsaloma\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.14.1322','EC','EC.14','{\"en\":\"San Vicente\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.15.1412','EC','EC.15','{\"en\":\"Tiwintza\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.17.1603','EC','EC.17','{\"en\":\"Santa Clara\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.20.1909','EC','EC.20','{\"en\":\"Paquisha\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.25.2402','EC','EC.25','{\"en\":\"La Libertad\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.15.1411','EC','EC.15','{\"en\":\"Pablo Sexto\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('EC.26.2302','EC','EC.26','{\"en\":\"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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Zaruma\"}',-79.61,-3.69,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Zamora\"}',-78.95,-4.07,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Yantzaza\"}',-78.76,-3.83,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Yaguachi Nuevo\"}',-79.69,-2.10,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Vinces\"}',-79.75,-1.56,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Ventanas\"}',-79.46,-1.44,'P','PPL','EC.13','EC.13.1207',38168,'America/Guayaquil',1,'2022-01-08 23:00:00','2022-01-08 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Velasco Ibarra\"}',-79.64,-1.04,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Valdez\"}',-78.98,1.25,'P','PPL','EC.09','EC.09.0802',11441,'America/Guayaquil',1,'2022-01-08 23:00:00','2022-01-08 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Tulcán\"}',-77.72,0.81,'P','PPLA','EC.05','EC.05.0401',86498,'America/Guayaquil',1,'2021-02-09 23:00:00','2021-02-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Tosagua\"}',-80.23,-0.79,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Tena\"}',-77.81,-0.99,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Sucúa\"}',-78.17,-2.46,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Sucre\"}',-80.42,-1.28,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Santo Domingo de los Colorados\"}',-79.18,-0.25,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Santa Rosa\"}',-79.96,-3.45,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Santa Lucía\"}',-80.00,-2.18,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Santa Elena\"}',-80.86,-2.23,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Santa Ana\"}',-80.37,-1.21,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"San Miguel de Salcedo\"}',-78.59,-1.05,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"San Miguel\"}',-79.04,-1.71,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"San Lorenzo de Esmeraldas\"}',-78.84,1.29,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Sangolquí\"}',-78.45,-0.33,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"San Gabriel\"}',-77.83,0.59,'P','PPL','EC.05','EC.05.0405',14487,'America/Guayaquil',1,'2022-01-08 23:00:00','2022-01-08 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Samborondón\"}',-79.72,-1.96,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Salinas\"}',-80.95,-2.21,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Rosa Zarate\"}',-79.47,0.33,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Rocafuerte\"}',-80.45,-0.92,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Riobamba\"}',-78.65,-1.67,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Quito\"}',-78.52,-0.23,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Quevedo\"}',-79.46,-1.03,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Puyo\"}',-78.00,-1.48,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Pujilí\"}',-78.70,-0.96,'P','PPL','EC.07','EC.07.0504',16168,'America/Guayaquil',1,'2020-06-09 23:00:00','2020-06-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Puerto Francisco de Orellana\"}',-76.99,-0.47,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Puerto Bolívar\"}',-80.00,-3.27,'P','PPL','EC.08','EC.08.0701',8300,'America/Guayaquil',1,'2020-06-09 23:00:00','2020-06-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Puerto Baquerizo Moreno\"}',-89.61,-0.90,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Puerto Ayora\"}',-90.31,-0.74,'P','PPL','EC.01','EC.01.2003',8996,'Pacific/Galapagos',1,'2020-10-31 23:00:00','2020-10-31 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Portoviejo\"}',-80.45,-1.05,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Portovelo\"}',-79.62,-3.72,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Playas\"}',-80.39,-2.63,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Piñas\"}',-79.68,-3.68,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Pimampiro\"}',-77.94,0.39,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Píllaro\"}',-78.55,-1.17,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Pelileo\"}',-78.54,-1.33,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Pedro Carbo\"}',-80.23,-1.82,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Pedernales\"}',-80.05,0.07,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Pasaje\"}',-79.81,-3.33,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Palora\"}',-77.97,-1.70,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Palestina\"}',-79.71,-1.94,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Palenque\"}',-79.76,-1.44,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Paján\"}',-80.43,-1.55,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Otavalo\"}',-78.26,0.23,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Naranjito\"}',-79.47,-2.17,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Naranjal\"}',-79.62,-2.67,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Muisne\"}',-80.02,0.61,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Montecristi\"}',-80.66,-1.05,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Montalvo\"}',-79.29,-1.79,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Milagro\"}',-79.59,-2.13,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Manta\"}',-80.71,-0.96,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Machala\"}',-79.96,-3.26,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Machachi\"}',-78.57,-0.51,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Macas\"}',-78.11,-2.31,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Macará\"}',-79.94,-4.38,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Lomas de Sargentillo\"}',-80.08,-1.88,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Loja\"}',-79.20,-3.99,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"La Troncal\"}',-79.34,-2.42,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Latacunga\"}',-78.62,-0.94,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"La Maná\"}',-79.23,-0.94,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"La Libertad\"}',-80.91,-2.23,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Nueva Loja\"}',-76.90,0.09,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Junín\"}',-80.21,-0.93,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Jipijapa\"}',-80.58,-1.35,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Ibarra\"}',-78.12,0.35,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Huaquillas\"}',-80.23,-3.48,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Guayaquil\"}',-79.89,-2.20,'P','PPLA','EC.10','EC.10.0901',1952029,'America/Guayaquil',1,'2021-07-31 23:00:00','2021-07-31 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Guaranda\"}',-79.00,-1.59,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Guano\"}',-78.63,-1.61,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Gualaceo\"}',-78.78,-2.89,'P','PPL','EC.02','EC.02.0103',17122,'America/Guayaquil',1,'2022-01-08 23:00:00','2022-01-08 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Esmeraldas\"}',-79.65,0.96,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"El Triunfo\"}',-79.97,-1.93,'P','PPL','EC.10','EC.10.0906',32282,'America/Guayaquil',1,'2022-01-08 23:00:00','2022-01-08 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Eloy Alfaro\"}',-79.86,-2.18,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Cuenca\"}',-79.00,-2.90,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Cotacachi\"}',-78.26,0.30,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Coronel Marcelino Maridueña\"}',-79.43,-2.21,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Colimes\"}',-80.01,-1.55,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Chone\"}',-80.09,-0.70,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Celica\"}',-79.96,-4.10,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Cayambe\"}',-78.15,0.04,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Catarama\"}',-79.46,-1.58,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Catamayo\"}',-79.36,-3.99,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Catacocha\"}',-79.65,-4.05,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Cariamanga\"}',-79.56,-4.33,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Cañar\"}',-78.94,-2.56,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Calceta\"}',-80.16,-0.85,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Boca Suno\"}',-77.14,-0.70,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Baños\"}',-78.42,-1.40,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Balzar\"}',-79.90,-1.37,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Baláo\"}',-79.81,-2.91,'P','PPL','EC.10','EC.10.0903',12205,'America/Guayaquil',1,'2020-06-09 23:00:00','2020-06-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Bahía de Caráquez\"}',-80.42,-0.60,'P','PPL','EC.14','EC.14.1314',37056,'America/Guayaquil',1,'2020-06-09 23:00:00','2020-06-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Babahoyo\"}',-79.53,-1.80,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Azogues\"}',-78.85,-2.74,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Atuntaqui\"}',-78.21,0.33,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Archidona\"}',-77.81,-0.91,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Ambato\"}',-78.62,-1.25,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Alfredo Baquerizo Moreno\"}',-79.52,-1.92,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Alausí\"}',-78.85,-2.20,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Tres Postes\"}',-79.60,-1.99,'P','PPL','EC.10','EC.10.0910',7000,'America/Guayaquil',1,'2021-05-25 23:00:00','2021-05-25 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('EC','{\"en\":\"Oyambarillo\"}',-78.33,-0.20,'P','PPL','EC.18','EC.18.1701',8000,'America/Guayaquil',1,'2021-06-11 23:00:00','2021-06-11 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
