-- 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 ('GT.22','GT','{\"en\":\"Zacapa\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.21','GT','{\"en\":\"Totonicapán\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.20','GT','{\"en\":\"Suchitepeque\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.19','GT','{\"en\":\"Sololá\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.18','GT','{\"en\":\"Santa Rosa\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.17','GT','{\"en\":\"San Marcos\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.16','GT','{\"en\":\"Sacatepéquez\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.15','GT','{\"en\":\"Retalhuleu\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.14','GT','{\"en\":\"Quiché\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.13','GT','{\"en\":\"Quetzaltenango\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.12','GT','{\"en\":\"Petén\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.11','GT','{\"en\":\"Jutiapa\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.10','GT','{\"en\":\"Jalapa\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.09','GT','{\"en\":\"Izabal\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.08','GT','{\"en\":\"Huehuetenango\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.07','GT','{\"en\":\"Guatemala\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.06','GT','{\"en\":\"Escuintla\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.05','GT','{\"en\":\"El Progreso\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.04','GT','{\"en\":\"Chiquimula\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.03','GT','{\"en\":\"Chimaltenango\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.02','GT','{\"en\":\"Baja Verapaz\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('GT.01','GT','{\"en\":\"Alta Verapaz\"}',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 ('GT.20.1018','GT','GT.20','{\"en\":\"Municipio de Zunilito\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.916','GT','GT.13','{\"en\":\"Municipio de Zunil\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.03.415','GT','GT.03','{\"en\":\"Municipio de Zaragoza\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.11.2210','GT','GT.11','{\"en\":\"Municipio de Zapotitlán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.22.1901','GT','GT.22','{\"en\":\"Municipio de Zacapa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.11.2206','GT','GT.11','{\"en\":\"Municipio de Yupiltepeque\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.03.412','GT','GT.03','{\"en\":\"Municipio de Yepocapa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.07.115','GT','GT.07','{\"en\":\"Municipio de Villa Nueva\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.07.116','GT','GT.07','{\"en\":\"Municipio de Villa Canales\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.22.1906','GT','GT.22','{\"en\":\"Municipio de Usumatlán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1415','GT','GT.14','{\"en\":\"Municipio de Uspantán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.01.1606','GT','GT.01','{\"en\":\"Municipio de Tucurú\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.21.801','GT','GT.21','{\"en\":\"Municipio de Totonicapán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1315','GT','GT.08','{\"en\":\"Municipio de Todos Santos Cuchumatán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.06.506','GT','GT.06','{\"en\":\"Município de Tiquisate\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1210','GT','GT.17','{\"en\":\"Municipio de Tejutla\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.22.1905','GT','GT.22','{\"en\":\"Municipio de Teculután\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1321','GT','GT.08','{\"en\":\"Municipio de Tectitán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.03.406','GT','GT.03','{\"en\":\"Municipio de Tecpán Guatemala\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.18.609','GT','GT.18','{\"en\":\"Municipio de Taxisco\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.01.1605','GT','GT.01','{\"en\":\"Municipio de Tamahú\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1209','GT','GT.17','{\"en\":\"Municipio de Tajumulco\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.01.1604','GT','GT.01','{\"en\":\"Municipio de Tactic\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1207','GT','GT.17','{\"en\":\"Municipio de Tacaná\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.16.304','GT','GT.16','{\"en\":\"Municipio de Sumpango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1308','GT','GT.08','{\"en\":\"San Pedro Soloma\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.701','GT','GT.19','{\"en\":\"Municipio de Sololá\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.06.504','GT','GT.06','{\"en\":\"Municipio de Siquinalá\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1226','GT','GT.17','{\"en\":\"Municipio de Sipacapa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1208','GT','GT.17','{\"en\":\"Municipio de Sibinal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.905','GT','GT.13','{\"en\":\"Municipio de Sibilia\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.01.1608','GT','GT.01','{\"en\":\"Municipio de Senahú\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.12.1710','GT','GT.12','{\"en\":\"Municipio de Sayaxché\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.06.512','GT','GT.06','{\"en\":\"Municipio de San Vicente Pacaya\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1017','GT','GT.20','{\"en\":\"Municipio de Santo Tomás La Unión\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.16.305','GT','GT.16','{\"en\":\"Municipio de Santo Domingo Xenacoj\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1006','GT','GT.20','{\"en\":\"Municipio de Santo Domingo Suchitepéquez\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.16.306','GT','GT.16','{\"en\":\"Municipio de Santiago Sacatepéquez\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1330','GT','GT.08','{\"en\":\"Municipio de Santiago Chimaltenango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.719','GT','GT.19','{\"en\":\"Municipio de Santiago Atitlán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.18.603','GT','GT.18','{\"en\":\"Municipio de Santa Rosa de Lima\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.703','GT','GT.19','{\"en\":\"Municipio de Santa María Visitación\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.18.610','GT','GT.18','{\"en\":\"Municipio de Santa María Ixhuatán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.16.311','GT','GT.16','{\"en\":\"Municipio de Santa María de Jesús\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.21.806','GT','GT.21','{\"en\":\"Municipio de Santa María Chiquimula\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.704','GT','GT.19','{\"en\":\"Municipio de Santa Lucía Utatlán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.16.309','GT','GT.16','{\"en\":\"Municipio de Santa Lucía Milpas Altas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.21.807','GT','GT.21','{\"en\":\"Municipio de Santa Lucía La Reforma\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.06.502','GT','GT.06','{\"en\":\"Municipio de Santa Lucía Cotzumalguapa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1317','GT','GT.08','{\"en\":\"Municipio de Santa Eulalia\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.01.1602','GT','GT.01','{\"en\":\"Municipio de Santa Cruz Verapaz\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.18.612','GT','GT.18','{\"en\":\"Municipio de Santa Cruz Naranjo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.15.1103','GT','GT.15','{\"en\":\"Municipio de Santa Cruz Muluá\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.714','GT','GT.19','{\"en\":\"Municipio de Santa Cruz La Laguna\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1401','GT','GT.14','{\"en\":\"Municipio de Santa Cruz del Quiché\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.03.410','GT','GT.03','{\"en\":\"Municipio de Santa Cruz Balanyá\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.707','GT','GT.19','{\"en\":\"Municipio de Santa Clara La Laguna\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.07.102','GT','GT.07','{\"en\":\"Municipio de Santa Catarina Pinula\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.711','GT','GT.19','{\"en\":\"Municipio de Santa Catarina Palopó\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.11.2203','GT','GT.11','{\"en\":\"Municipio de Santa Catarina Mita\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.706','GT','GT.19','{\"en\":\"Municipio de Santa Catarina Ixtahuacán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.16.316','GT','GT.16','{\"en\":\"Municipio de Santa Catarina Barahona\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1310','GT','GT.08','{\"en\":\"Municipio de Santa Bárbara\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1015','GT','GT.20','{\"en\":\"Municipio de Santa Bárbara\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.03.405','GT','GT.03','{\"en\":\"Municipio de Santa Apolonia\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1331','GT','GT.08','{\"en\":\"Municipio de Santa Ana Huista\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.12.1707','GT','GT.12','{\"en\":\"Municipio de Santa Ana\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1320','GT','GT.08','{\"en\":\"Municipio de San Sebastián Huehuetenango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1325','GT','GT.08','{\"en\":\"Municipio de San Sebastián Coatán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.15.1102','GT','GT.15','{\"en\":\"Municipio de San Sebastián\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.05.207','GT','GT.05','{\"en\":\"Municipio de Sansare\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.07.111','GT','GT.07','{\"en\":\"Municipio de San Raymundo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1211','GT','GT.17','{\"en\":\"Municipio de San Rafael Pie de la Cuesta\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1328','GT','GT.08','{\"en\":\"Municipio de San Rafael Petzal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.18.605','GT','GT.18','{\"en\":\"Municipio de San Rafael Las Flores\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1314','GT','GT.08','{\"en\":\"Municipio de San Rafael La Independencia\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1202','GT','GT.17','{\"en\":\"Municipio de San Pedro Sacatepéquez\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.07.109','GT','GT.07','{\"en\":\"Municipio de San Pedro Sacatepéquez\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.10.2102','GT','GT.10','{\"en\":\"Municipio de San Pedro Pinula\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1306','GT','GT.08','{\"en\":\"Municipio de San Pedro Necta\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.718','GT','GT.19','{\"en\":\"Municipio de San Pedro La Laguna\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1409','GT','GT.14','{\"en\":\"Municipio de San Pedro Jocopilas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.01.1609','GT','GT.01','{\"en\":\"Municipio de San Pedro Carchá\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.07.107','GT','GT.07','{\"en\":\"Municipio de San Pedro Ayampuc\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.715','GT','GT.19','{\"en\":\"Municipio de San Pablo La Laguna\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1009','GT','GT.20','{\"en\":\"Municipio de San Pablo Jocopilas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1219','GT','GT.17','{\"en\":\"Municipio de San Pablo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.908','GT','GT.13','{\"en\":\"Municipio de San Miguel Sigüilá\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1011','GT','GT.20','{\"en\":\"Municipio de San Miguel Panán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1205','GT','GT.17','{\"en\":\"Municipio de San Miguel Ixtahuacán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.16.313','GT','GT.16','{\"en\":\"Municipio de San Miguel Dueñas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.02.1502','GT','GT.02','{\"en\":\"Municipio de San Miguel Chicaj\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1313','GT','GT.08','{\"en\":\"Municipio de San Miguel Acatán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1318','GT','GT.08','{\"en\":\"Municipio de San Mateo Ixtatán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.910','GT','GT.13','{\"en\":\"Municipio de San Mateo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.15.1104','GT','GT.15','{\"en\":\"Municipio de San Martín Zapotitlán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.912','GT','GT.13','{\"en\":\"Municipio de San Martín Sacatepéquez\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.03.403','GT','GT.03','{\"en\":\"Municipio de San Martín Jilotepeque\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.716','GT','GT.19','{\"en\":\"Municipio de San Marcos La Laguna\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1201','GT','GT.17','{\"en\":\"Municipio de San Marcos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.10.2104','GT','GT.10','{\"en\":\"Municipio de San Manuel Chaparrón\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.10.2103','GT','GT.10','{\"en\":\"Municipio de San Luis Jilotepeque\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.12.1709','GT','GT.12','{\"en\":\"Municipio de San Luis\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.713','GT','GT.19','{\"en\":\"Municipio de San Lucas Tolimán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.16.308','GT','GT.16','{\"en\":\"Municipio de San Lucas Sacatepéquez\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1229','GT','GT.17','{\"en\":\"Municipio de San Lorenzo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1007','GT','GT.20','{\"en\":\"Municipio de San Lorenzo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.18.607','GT','GT.18','{\"en\":\"Municipio de San Juan Tecuaco\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.07.110','GT','GT.07','{\"en\":\"Municipio de San Juan Sacatepéquez\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.717','GT','GT.19','{\"en\":\"Municipio de San Juan La Laguna\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1323','GT','GT.08','{\"en\":\"Municipio de San Juan Ixcoy\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.04.2003','GT','GT.04','{\"en\":\"Municipio de San Juan la Ermita\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1411','GT','GT.14','{\"en\":\"Municipio de San Juan Cotzal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.01.1610','GT','GT.01','{\"en\":\"Municipio de San Juan Chamelco\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1016','GT','GT.20','{\"en\":\"Municipio de San Juan Bautista\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1316','GT','GT.08','{\"en\":\"Municipio de San Juan Atitán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.03.402','GT','GT.03','{\"en\":\"Municipio de San José Poaquil\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.07.103','GT','GT.07','{\"en\":\"Municipio de San José Pinula\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1224','GT','GT.17','{\"en\":\"Municipio de San José Ojetenam\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.04.2002','GT','GT.04','{\"en\":\"Municipio de San José La Arada\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1005','GT','GT.20','{\"en\":\"Municipio de San José El Ídolo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.07.104','GT','GT.07','{\"en\":\"Municipio de San José del Golfo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.702','GT','GT.19','{\"en\":\"Municipio de San José Chacayá\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.11.2216','GT','GT.11','{\"en\":\"Municipio de San José Acatempa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.12.1702','GT','GT.12','{\"en\":\"Municipio de San José\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.06.509','GT','GT.06','{\"en\":\"Municipio de San José\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.02.1507','GT','GT.02','{\"en\":\"Municipio de San Jerónimo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.04.2010','GT','GT.04','{\"en\":\"Municipio de San Jacinto\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1329','GT','GT.08','{\"en\":\"Municipio de San Gaspar Ixchil\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1012','GT','GT.20','{\"en\":\"Municipio de San Gabriel\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1003','GT','GT.20','{\"en\":\"Municipio de San Francisco Zapotitlán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.918','GT','GT.13','{\"en\":\"Municipio de San Francisco La Unión\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.21.803','GT','GT.21','{\"en\":\"Municipio de San Francisco El Alto\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.12.1706','GT','GT.12','{\"en\":\"Municipio de San Francisco\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.15.1105','GT','GT.15','{\"en\":\"Municipio de San Felipe\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.22.1908','GT','GT.22','{\"en\":\"Municipio de San Diego\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.01.1603','GT','GT.01','{\"en\":\"Municipio de San Cristóbal Verapaz\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.21.802','GT','GT.21','{\"en\":\"Municipio de San Cristóbal Totonicapán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1225','GT','GT.17','{\"en\":\"Municipio de San Cristóbal Cucho\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.05.204','GT','GT.05','{\"en\":\"Municipio de San Cristóbal Acasaguastlán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.904','GT','GT.13','{\"en\":\"Municipio de San Carlos Sija\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.10.2105','GT','GT.10','{\"en\":\"Municipio de San Carlos Alzatate\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1004','GT','GT.20','{\"en\":\"Municipio de San Bernardino\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.12.1703','GT','GT.12','{\"en\":\"Municipio de San Benito\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.16.307','GT','GT.16','{\"en\":\"Municipio de San Bartolomé Milpas Altas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1417','GT','GT.14','{\"en\":\"Municipio de San Bartolomé Jocotenango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.21.808','GT','GT.21','{\"en\":\"Municipio de San Bartolo Aguas Calientes\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.05.206','GT','GT.05','{\"en\":\"Municipio de Sanarate\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1010','GT','GT.20','{\"en\":\"Municipio de San Antonio Suchitepéquez\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1203','GT','GT.17','{\"en\":\"Municipio de San Antonio Sacatepéquez\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.712','GT','GT.19','{\"en\":\"Municipio de San Antonio Palopó\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.05.208','GT','GT.05','{\"en\":\"Municipio de San Antonio La Paz\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1408','GT','GT.14','{\"en\":\"Municipio de San Antonio Ilotenango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1324','GT','GT.08','{\"en\":\"Municipio de San Antonio Huista\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.16.315','GT','GT.16','{\"en\":\"Municipio de San Antonio Aguas Calientes\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.21.804','GT','GT.21','{\"en\":\"Municipio de San Andrés Xecul\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.15.1106','GT','GT.15','{\"en\":\"Municipio de San Andrés Villa Seca\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.709','GT','GT.19','{\"en\":\"Municipio de San Andrés Semetabaj\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1414','GT','GT.14','{\"en\":\"Municipio de San Andrés Sajcabajá\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.03.413','GT','GT.03','{\"en\":\"Municipio de San Andrés Itzapa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.12.1704','GT','GT.12','{\"en\":\"Municipio de San Andrés\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.05.203','GT','GT.05','{\"en\":\"Municipio de San Agustín Acasaguastlán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1008','GT','GT.20','{\"en\":\"Municipio de Samayac\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.902','GT','GT.13','{\"en\":\"Municipio de Salcajá\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.02.1501','GT','GT.02','{\"en\":\"Municipio de Salamá\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1416','GT','GT.14','{\"en\":\"Municipio de Sacapulas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.22.1903','GT','GT.22','{\"en\":\"Municipio de Río Hondo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1020','GT','GT.20','{\"en\":\"Municipio de Río Bravo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1228','GT','GT.17','{\"en\":\"Municipio de Río Blanco\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.15.1101','GT','GT.15','{\"en\":\"Municipio de Retalhuleu\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.02.1503','GT','GT.02','{\"en\":\"Municipio de Rabinal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.04.2009','GT','GT.04','{\"en\":\"Municipio de Quezaltepeque\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.901','GT','GT.13','{\"en\":\"Municipio de Quetzaltenango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.11.2217','GT','GT.11','{\"en\":\"Municipio de Quesada\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.02.1508','GT','GT.02','{\"en\":\"Municipio de Purulhá\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.09.1801','GT','GT.09','{\"en\":\"Municipio de Puerto Barrios\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.18.613','GT','GT.18','{\"en\":\"Municipio de Pueblo Nuevo Viñas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1019','GT','GT.20','{\"en\":\"Municipio de Pueblo Nuevo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.12.1712','GT','GT.12','{\"en\":\"Municipio de Poptún\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.03.408','GT','GT.03','{\"en\":\"Municipio de Pochuta\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.07.117','GT','GT.07','{\"en\":\"Municipio de Petapa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.03.407','GT','GT.03','{\"en\":\"Municipio de Patzún\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1407','GT','GT.14','{\"en\":\"Municipio de Patzité\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.03.409','GT','GT.03','{\"en\":\"Municipio de Patzicía\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1014','GT','GT.20','{\"en\":\"Municipio de Patulul\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.16.303','GT','GT.16','{\"en\":\"Municipio de Pastores\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.11.2215','GT','GT.11','{\"en\":\"Municipio de Pasaco\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.03.414','GT','GT.03','{\"en\":\"Municipio de Parramos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.01.1607','GT','GT.01','{\"en\":\"Municipio de Panzós\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.710','GT','GT.19','{\"en\":\"Municipio de Panajachel\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.06.511','GT','GT.06','{\"en\":\"Municipio de Palín\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.924','GT','GT.13','{\"en\":\"Municipio de Palestina de los Altos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.07.105','GT','GT.07','{\"en\":\"Municipio de Palencia\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1222','GT','GT.17','{\"en\":\"Municipio de Pajapita\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.909','GT','GT.13','{\"en\":\"Municipio de San Juan Ostuncalco\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.18.606','GT','GT.18','{\"en\":\"Municipio de Oratorio\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.04.2006','GT','GT.04','{\"en\":\"Municipio de Olopa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.903','GT','GT.13','{\"en\":\"Municipio de Olintepeque\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1218','GT','GT.17','{\"en\":\"Municipio de Ocós\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.15.1108','GT','GT.15','{\"en\":\"Municipio de Nuevo San Carlos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1212','GT','GT.17','{\"en\":\"Municipio de Nuevo Progreso\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.18.614','GT','GT.18','{\"en\":\"Municipio de Nueva Santa Rosa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.06.513','GT','GT.06','{\"en\":\"Municipio de Nueva Concepción\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1305','GT','GT.08','{\"en\":\"Municipio de Nentón\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1413','GT','GT.14','{\"en\":\"Municipio de Nebaj\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.705','GT','GT.19','{\"en\":\"Municipio de Nahualá\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.11.2214','GT','GT.11','{\"en\":\"Municipio de Moyuta\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.05.202','GT','GT.05','{\"en\":\"Municipio de Morazán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.09.1804','GT','GT.09','{\"en\":\"Municipio de Morales\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.10.2106','GT','GT.10','{\"en\":\"Municipio de Monjas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.21.805','GT','GT.21','{\"en\":\"Municipio de Momostenango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.07.108','GT','GT.07','{\"en\":\"Municipio de Mixco\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.12.1711','GT','GT.12','{\"en\":\"Municipio de Melchor de Mencos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1001','GT','GT.20','{\"en\":\"Municipio de Mazatenango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.10.2107','GT','GT.10','{\"en\":\"Municipio de Mataquescuintla\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.06.505','GT','GT.06','{\"en\":\"Municipio de Masagua\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1303','GT','GT.08','{\"en\":\"Municipio de Malacatancito\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1215','GT','GT.17','{\"en\":\"Municipio de Malacatán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.16.310','GT','GT.16','{\"en\":\"Municipio de Magdalena Milpas Altas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.09.1805','GT','GT.09','{\"en\":\"Municipio de Los Amates\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.09.1802','GT','GT.09','{\"en\":\"Municipio de Lívingston\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.22.1909','GT','GT.22','{\"en\":\"Municipio de La Unión\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1221','GT','GT.17','{\"en\":\"Municipio de La Reforma\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.01.1611','GT','GT.01','{\"en\":\"Municipio de Lanquín\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.12.1705','GT','GT.12','{\"en\":\"Municipio de La Libertad\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1311','GT','GT.08','{\"en\":\"Municipio de La Libertad\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.06.507','GT','GT.06','{\"en\":\"Municipio de La Gomera\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.923','GT','GT.13','{\"en\":\"Municipio de La Esperanza\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1312','GT','GT.08','{\"en\":\"Municipio de La Democracia\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.06.503','GT','GT.06','{\"en\":\"Municipio de La Democracia\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.11.2201','GT','GT.11','{\"en\":\"Municipio de Jutiapa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1412','GT','GT.14','{\"en\":\"Municipio de Joyabaj\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.16.302','GT','GT.16','{\"en\":\"Municipio de Jocotenango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.04.2004','GT','GT.04','{\"en\":\"Municipio de Jocotán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.11.2208','GT','GT.11','{\"en\":\"Municipio de Jerez\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.11.2212','GT','GT.11','{\"en\":\"Municipio de Jalpatagua\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.10.2101','GT','GT.10','{\"en\":\"Municipio de Jalapa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1307','GT','GT.08','{\"en\":\"Municipio de Jacaltenango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.06.510','GT','GT.06','{\"en\":\"Municipio de Iztapa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1309','GT','GT.08','{\"en\":\"San Ildefonso Ixtahuacán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1223','GT','GT.17','{\"en\":\"Municipio de Ixchiguán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.04.2011','GT','GT.04','{\"en\":\"Municipio de Ipala\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.22.1910','GT','GT.22','{\"en\":\"Municipio de Huité\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.915','GT','GT.13','{\"en\":\"Municipio de Huitán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1301','GT','GT.08','{\"en\":\"Municipio de Huehuetenango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.18.611','GT','GT.18','{\"en\":\"Municipio de Guazacapán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.07.101','GT','GT.07','{\"en\":\"Municipio de Guatemala\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.06.508','GT','GT.06','{\"en\":\"Municipio de Guanagazapa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.22.1904','GT','GT.22','{\"en\":\"Municipio de Gualán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.02.1505','GT','GT.02','{\"en\":\"Municipio de Granados\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.921','GT','GT.13','{\"en\":\"Municipio de Génova\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.07.113','GT','GT.07','{\"en\":\"Municipio de Fraijanes\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.922','GT','GT.13','{\"en\":\"Municipio de Flores Costa Cuca\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.12.1701','GT','GT.12','{\"en\":\"Municipio de Flores\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.22.1902','GT','GT.22','{\"en\":\"Municipio de Estanzuela\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1227','GT','GT.17','{\"en\":\"Municipio de Esquipulas Palo Gordo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.04.2007','GT','GT.04','{\"en\":\"Municipio de Esquipulas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.06.501','GT','GT.06','{\"en\":\"Municipio de Escuintla\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1213','GT','GT.17','{\"en\":\"Municipio de El Tumbador\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.03.416','GT','GT.03','{\"en\":\"Municipio de El Tejar\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1214','GT','GT.17','{\"en\":\"Municipio de El Rodeo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1220','GT','GT.17','{\"en\":\"Municipio de El Quetzal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.11.2202','GT','GT.11','{\"en\":\"Municipio de El Progreso\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.919','GT','GT.13','{\"en\":\"Municipio de El Palmar\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.05.205','GT','GT.05','{\"en\":\"Municipio de El Jícaro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.09.1803','GT','GT.09','{\"en\":\"Municipio de El Estor\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.02.1506','GT','GT.02','{\"en\":\"Municipio de El Chol\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.15.1109','GT','GT.15','{\"en\":\"Municipio de El Asintal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.11.2209','GT','GT.11','{\"en\":\"Municipio de El Adelanto\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.12.1708','GT','GT.12','{\"en\":\"Municipio de Dolores\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1002','GT','GT.20','{\"en\":\"Municipio de Cuyotenango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1410','GT','GT.14','{\"en\":\"Municipio de Cunén\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1304','GT','GT.08','{\"en\":\"Municipio de Cuilco\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.18.601','GT','GT.18','{\"en\":\"Municipio de Cuilapa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.02.1504','GT','GT.02','{\"en\":\"Municipio de Cubulco\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.11.2213','GT','GT.11','{\"en\":\"Municipio de Conguaco\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1206','GT','GT.17','{\"en\":\"Municipio de Concepción Tutuapa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.04.2008','GT','GT.04','{\"en\":\"Municipio de Concepción Las Minas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.911','GT','GT.13','{\"en\":\"Municipio de Concepción Chiquirichapa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1322','GT','GT.08','{\"en\":\"Municipio de Concepción Huista\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.19.708','GT','GT.19','{\"en\":\"Municipio de Concepción\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1204','GT','GT.17','{\"en\":\"Municipio de Comitancillo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.11.2211','GT','GT.11','{\"en\":\"Municipio de Comapa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.03.404','GT','GT.03','{\"en\":\"Municipio de Comalapa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1319','GT','GT.08','{\"en\":\"Municipio de Colotenango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.917','GT','GT.13','{\"en\":\"Municipio de Colomba\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.01.1601','GT','GT.01','{\"en\":\"Municipio de Cobán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.920','GT','GT.13','{\"en\":\"Municipio de Coatepeque\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.16.312','GT','GT.16','{\"en\":\"Municipio de Ciudad Vieja\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.07.112','GT','GT.07','{\"en\":\"Municipio de Chuarrancho\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.01.1613','GT','GT.01','{\"en\":\"Municipio de Chisec\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.18.608','GT','GT.18','{\"en\":\"Municipio de Chiquimulilla\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.04.2001','GT','GT.04','{\"en\":\"Municipio de Chiquimula\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1403','GT','GT.14','{\"en\":\"Municipio de Chinique\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.07.106','GT','GT.07','{\"en\":\"Municipio de Chinautla\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.03.401','GT','GT.03','{\"en\":\"Municipio de Chimaltenango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1406','GT','GT.14','{\"en\":\"Municipio de Chichicastenango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1402','GT','GT.14','{\"en\":\"Municipio de Chiché\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1013','GT','GT.20','{\"en\":\"Municipio de Chicacao\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1302','GT','GT.08','{\"en\":\"Municipio de Chiantla\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.15.1107','GT','GT.15','{\"en\":\"Municipio de Champerico\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1405','GT','GT.14','{\"en\":\"Municipio de Chajul\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.01.1614','GT','GT.01','{\"en\":\"Municipio de Chahal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1216','GT','GT.17','{\"en\":\"Municipio de Catarina\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.18.604','GT','GT.18','{\"en\":\"Municipio de Casillas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.914','GT','GT.13','{\"en\":\"Municipio de Cantel\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1418','GT','GT.14','{\"en\":\"Municipio de Canillá\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.04.2005','GT','GT.04','{\"en\":\"Municipio de Camotán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.907','GT','GT.13','{\"en\":\"Municipio de Cajolá\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.01.1612','GT','GT.01','{\"en\":\"Municipio de Cahabón\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.906','GT','GT.13','{\"en\":\"Municipio de Cabricán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.22.1907','GT','GT.22','{\"en\":\"Municipio de Cabañas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1326','GT','GT.08','{\"en\":\"Municipio de Barillas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.18.602','GT','GT.18','{\"en\":\"Municipio de Barberena\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1217','GT','GT.17','{\"en\":\"Municipio de Ayutla\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.11.2207','GT','GT.11','{\"en\":\"Municipio de Atescatempa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.11.2205','GT','GT.11','{\"en\":\"Municipio de Asunción Mita\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.16.301','GT','GT.16','{\"en\":\"Municipio de Antigua Guatemala\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.07.114','GT','GT.07','{\"en\":\"Municipio de Amatitlán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.16.314','GT','GT.16','{\"en\":\"Municipio de Alotenango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.13.913','GT','GT.13','{\"en\":\"Municipio de Almolonga\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1327','GT','GT.08','{\"en\":\"Municipio de Aguacatán\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.11.2204','GT','GT.11','{\"en\":\"Municipio de Agua Blanca\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.03.411','GT','GT.03','{\"en\":\"Municipio de Acatenango\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.01.1615','GT','GT.01','{\"en\":\"Municipio de Fray Bartolome de las Casas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1420','GT','GT.14','{\"en\":\"Municipio de Ixcan\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1419','GT','GT.14','{\"en\":\"Municipio de Chicaman\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.01.1617','GT','GT.01','{\"en\":\"Raxruhá\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1404','GT','GT.14','{\"en\":\"Municipio de Zacualpa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.14.1421','GT','GT.14','{\"en\":\"Municipio de Pachalum\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.01.1616','GT','GT.01','{\"en\":\"Santa Catarina La Tinta\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.05.201','GT','GT.05','{\"en\":\"Municipio de Guastatoya\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.12.1713','GT','GT.12','{\"en\":\"Las Cruces\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1332','GT','GT.08','{\"en\":\"Municipio de Unión Cantinil\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.20.1021','GT','GT.20','{\"en\":\"La Máquina\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.17.1230','GT','GT.17','{\"en\":\"Municipio de La Blanca\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.22.1911','GT','GT.22','{\"en\":\"Municipio de San Jorge\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.12.1714','GT','GT.12','{\"en\":\"Municipio de El Chal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.06.514','GT','GT.06','{\"en\":\"Sipacate\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('GT.08.1333','GT','GT.08','{\"en\":\"Petatán\"}',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 ('GT','{\"en\":\"Zunil\"}',-91.48,14.78,'P','PPLA2','GT.13',NULL,9986,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"Zaragoza\"}',-90.89,14.65,'P','PPLA2','GT.03','GT.03.415',9361,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Zacualpa\"}',-90.88,15.03,'P','PPLA2','GT.14',NULL,9241,'America/Guatemala',1,'2019-06-04 23:00:00','2019-06-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 ('GT','{\"en\":\"Zacapa\"}',-89.53,14.97,'P','PPLA','GT.22',NULL,36088,'America/Guatemala',1,'2012-12-04 23:00:00','2012-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 ('GT','{\"en\":\"Yepocapa\"}',-90.95,14.50,'P','PPLA2','GT.03','GT.03.412',8961,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Villa Nueva\"}',-90.59,14.53,'P','PPLA2','GT.07','GT.07.115',406830,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Villa Canales\"}',-90.53,14.48,'P','PPLA2','GT.07','GT.07.116',122194,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Totonicapán\"}',-91.36,14.91,'P','PPLA','GT.21','GT.21.801',69734,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Teculután\"}',-89.72,14.99,'P','PPLA2','GT.22',NULL,6407,'America/Guatemala',1,'2020-03-07 23:00:00','2020-03-07 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 ('GT','{\"en\":\"Tecpán Guatemala\"}',-90.99,14.76,'P','PPLA2','GT.03','GT.03.406',21978,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Taxisco\"}',-90.47,14.07,'P','PPL','GT.18','GT.18.609',6518,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Tactic\"}',-90.35,15.32,'P','PPL','GT.01','GT.01.1604',8999,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Tacaná\"}',-92.07,15.24,'P','PPLA2','GT.17',NULL,6438,'America/Guatemala',1,'2017-06-06 23:00:00','2017-06-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 ('GT','{\"en\":\"Sumpango\"}',-90.73,14.65,'P','PPLA2','GT.16',NULL,20884,'America/Guatemala',1,'2019-04-09 23:00:00','2019-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 ('GT','{\"en\":\"Soloma\"}',-91.43,15.66,'P','PPLA2','GT.08','GT.08.1308',10916,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Sololá\"}',-91.18,14.77,'P','PPLA','GT.19',NULL,45373,'America/Guatemala',1,'2012-12-04 23:00:00','2012-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 ('GT','{\"en\":\"Senahú\"}',-89.82,15.42,'P','PPLA2','GT.01','GT.01.1608',5633,'America/Guatemala',1,'2020-10-13 23:00:00','2020-10-13 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 ('GT','{\"en\":\"Sayaxché\"}',-90.19,16.52,'P','PPLA2','GT.12',NULL,9100,'America/Guatemala',1,'2017-03-03 23:00:00','2017-03-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 ('GT','{\"en\":\"San Vicente Pacaya\"}',-90.64,14.41,'P','PPLA2','GT.06','GT.06.512',7162,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Santo Tomás La Unión\"}',-91.41,14.63,'P','PPLA2','GT.20',NULL,7081,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"Santo Domingo Xenacoj\"}',-90.70,14.68,'P','PPLA2','GT.16',NULL,8791,'America/Guatemala',1,'2019-04-09 23:00:00','2019-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 ('GT','{\"en\":\"Santo Domingo Suchitepéquez\"}',-91.48,14.48,'P','PPLA2','GT.20',NULL,6270,'America/Guatemala',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 ('GT','{\"en\":\"Santiago Sacatepéquez\"}',-90.68,14.64,'P','PPLA2','GT.16',NULL,24210,'America/Guatemala',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 ('GT','{\"en\":\"Santiago Atitlán\"}',-91.23,14.64,'P','PPL','GT.19',NULL,33309,'America/Guatemala',1,'2008-03-04 23:00:00','2008-03-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 ('GT','{\"en\":\"Santa Rosa de Lima\"}',-90.30,14.39,'P','PPLA2','GT.18',NULL,5984,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-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 ('GT','{\"en\":\"Santa María de Jesús\"}',-90.71,14.49,'P','PPLA2','GT.16','GT.16.311',15529,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Santa María Chiquimula\"}',-91.33,15.03,'P','PPLA2','GT.21','GT.21.806',6980,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Santa Lucía Milpas Altas\"}',-90.68,14.58,'P','PPLA2','GT.16',NULL,13001,'America/Guatemala',1,'2019-04-09 23:00:00','2019-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 ('GT','{\"en\":\"Santa Lucía Cotzumalguapa\"}',-91.02,14.34,'P','PPLA2','GT.06','GT.06.502',62097,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Santa Cruz Verapaz\"}',-90.43,15.37,'P','PPLA2','GT.01','GT.01.1602',5843,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Santa Cruz Naranjo\"}',-90.37,14.39,'P','PPLA2','GT.18',NULL,6254,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-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 ('GT','{\"en\":\"Santa Cruz del Quiché\"}',-91.15,15.03,'P','PPLA','GT.14',NULL,23618,'America/Guatemala',1,'2017-03-03 23:00:00','2017-03-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 ('GT','{\"en\":\"Santa Cruz Balanyá\"}',-90.92,14.69,'P','PPLA2','GT.03','GT.03.410',7825,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Santa Clara La Laguna\"}',-91.30,14.72,'P','PPLA2','GT.19',NULL,5306,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"Santa Catarina Pinula\"}',-90.50,14.57,'P','PPLA2','GT.07','GT.07.102',67994,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Santa Catarina Mita\"}',-89.74,14.45,'P','PPLA2','GT.11','GT.11.2203',10817,'America/Guatemala',1,'2020-07-19 23:00:00','2020-07-19 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 ('GT','{\"en\":\"Santa Catarina Ixtahuacán\"}',-91.36,14.80,'P','PPLA2','GT.19',NULL,14734,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"Santa Bárbara\"}',-91.23,14.44,'P','PPLA2','GT.20',NULL,12906,'America/Guatemala',1,'2019-08-07 23:00:00','2019-08-07 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 ('GT','{\"en\":\"Santa Ana\"}',-89.83,16.81,'P','PPLA2','GT.12','GT.12.1707',9523,'America/Guatemala',1,'2021-01-07 23:00:00','2021-01-07 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 ('GT','{\"en\":\"San Sebastián\"}',-91.65,14.56,'P','PPLA2','GT.15',NULL,14823,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"San Raimundo\"}',-90.59,14.76,'P','PPLA2','GT.07','GT.07.111',8689,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"San Pedro Sacatepéquez\"}',-91.76,14.97,'P','PPLA2','GT.17',NULL,40021,'America/Guatemala',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 ('GT','{\"en\":\"San Pedro Sacatepéquez\"}',-90.64,14.69,'P','PPLA2','GT.07','GT.07.109',14315,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"San Pedro La Laguna\"}',-91.27,14.69,'P','PPL','GT.19',NULL,9681,'America/Guatemala',1,'2015-03-25 23:00:00','2015-03-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 ('GT','{\"en\":\"San Pedro Carchá\"}',-90.31,15.48,'P','PPLA2','GT.01','GT.01.1609',13332,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"San Pedro Ayampuc\"}',-90.45,14.78,'P','PPLA2','GT.07','GT.07.107',46803,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"San Pablo La Laguna\"}',-91.27,14.72,'P','PPLA2','GT.19',NULL,6186,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"San Pablo Jocopilas\"}',-91.45,14.59,'P','PPLA2','GT.20',NULL,20259,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"San Pablo\"}',-92.00,14.93,'P','PPLA2','GT.17',NULL,13668,'America/Guatemala',1,'2018-11-05 23:00:00','2018-11-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 ('GT','{\"en\":\"San Miguel Sigüilá\"}',-91.61,14.90,'P','PPLA2','GT.13',NULL,7551,'America/Guatemala',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 ('GT','{\"en\":\"San Miguel Dueñas\"}',-90.80,14.52,'P','PPLA2','GT.16',NULL,8424,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 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 ('GT','{\"en\":\"San Miguel Chicaj\"}',-90.39,15.09,'P','PPLA2','GT.02','GT.02.1502',13747,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"San Mateo Ixtatán\"}',-91.48,15.83,'P','PPLA2','GT.08','GT.08.1318',13213,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"San Mateo\"}',-91.59,14.86,'P','PPLA2','GT.13',NULL,5534,'America/Guatemala',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 ('GT','{\"en\":\"San Martín Jilotepeque\"}',-90.79,14.78,'P','PPLA2','GT.03','GT.03.403',9846,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"San Marcos\"}',-91.79,14.96,'P','PPLA','GT.17','GT.17.1201',25088,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"San Luis Jilotepeque\"}',-89.72,14.65,'P','PPLA2','GT.10','GT.10.2103',10306,'America/Guatemala',1,'2020-07-19 23:00:00','2020-07-19 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 ('GT','{\"en\":\"San Luis Ixcán\"}',-91.09,15.79,'P','PPL','GT.14',NULL,7850,'America/Guatemala',1,'2006-01-16 23:00:00','2006-01-16 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 ('GT','{\"en\":\"San Luis\"}',-89.44,16.20,'P','PPLA2','GT.12',NULL,6776,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-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 ('GT','{\"en\":\"San Lucas Tolimán\"}',-91.15,14.59,'P','PPL','GT.19',NULL,14545,'America/Guatemala',1,'2014-07-22 23:00:00','2014-07-22 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 ('GT','{\"en\":\"San Lucas Sacatepéquez\"}',-90.66,14.61,'P','PPLA2','GT.16',NULL,17959,'America/Guatemala',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 ('GT','{\"en\":\"San Juan Sacatepéquez\"}',-90.64,14.72,'P','PPLA2','GT.07','GT.07.110',136886,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"San Juan Cotzal\"}',-91.03,15.43,'P','PPLA2','GT.14',NULL,11046,'America/Guatemala',1,'2017-03-03 23:00:00','2017-03-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 ('GT','{\"en\":\"San Juan Chamelco\"}',-90.33,15.42,'P','PPLA2','GT.01','GT.01.1610',11944,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"San José Poaquil\"}',-90.91,14.82,'P','PPLA2','GT.03','GT.03.402',5987,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"San José Pinula\"}',-90.41,14.55,'P','PPLA2','GT.07','GT.07.103',47247,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"San José Acatempa\"}',-90.13,14.27,'P','PPLA2','GT.11',NULL,6367,'America/Guatemala',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 ('GT','{\"en\":\"San Jerónimo\"}',-90.24,15.06,'P','PPLA2','GT.02','GT.02.1507',8093,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"San Francisco Zapotitlán\"}',-91.52,14.59,'P','PPLA2','GT.20',NULL,13855,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"San Francisco El Alto\"}',-91.44,14.94,'P','PPLA2','GT.21',NULL,54493,'America/Guatemala',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 ('GT','{\"en\":\"San Felipe\"}',-91.59,14.62,'P','PPLA2','GT.15',NULL,8921,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"San Cristóbal Verapaz\"}',-90.48,15.37,'P','PPL','GT.01','GT.01.1603',19664,'America/Guatemala',1,'2021-10-31 23:00:00','2021-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 ('GT','{\"en\":\"San Cristóbal Cucho\"}',-91.78,14.91,'P','PPLA2','GT.17',NULL,9152,'America/Guatemala',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 ('GT','{\"en\":\"San Carlos Sija\"}',-91.55,14.98,'P','PPLA2','GT.13','GT.13.904',6831,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"San Bernardino\"}',-91.46,14.54,'P','PPLA2','GT.20',NULL,5501,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"San Benito\"}',-89.92,16.92,'P','PPLA2','GT.12','GT.12.1703',30764,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"San Bartolomé Milpas Altas\"}',-90.68,14.61,'P','PPLA2','GT.16',NULL,6261,'America/Guatemala',1,'2019-04-09 23:00:00','2019-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 ('GT','{\"en\":\"Sanarate\"}',-90.20,14.79,'P','PPLA2','GT.05','GT.05.206',15843,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"San Antonio Suchitepéquez\"}',-91.41,14.54,'P','PPLA2','GT.20','GT.20.1010',10951,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"San Antonio La Paz\"}',-90.28,14.76,'P','PPLA2','GT.05','GT.05.208',7781,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"San Antonio Huista\"}',-91.77,15.65,'P','PPLA2','GT.08','GT.08.1324',5669,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"San Antonio Aguas Calientes\"}',-90.78,14.55,'P','PPLA2','GT.16',NULL,7811,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 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 ('GT','{\"en\":\"San Andrés Xecul\"}',-91.48,14.90,'P','PPLA2','GT.21','GT.21.804',12133,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"San Andrés Villa Seca\"}',-91.59,14.58,'P','PPLA2','GT.15',NULL,5102,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"San Andrés Itzapa\"}',-90.84,14.62,'P','PPLA2','GT.03','GT.03.413',18647,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"San Andrés\"}',-89.91,16.97,'P','PPLA2','GT.12','GT.12.1704',7235,'America/Guatemala',1,'2021-01-07 23:00:00','2021-01-07 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 ('GT','{\"en\":\"San Agustín Acasaguastlán\"}',-89.97,14.95,'P','PPLA2','GT.05','GT.05.203',10335,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Samayac\"}',-91.46,14.58,'P','PPL','GT.13',NULL,8994,'America/Guatemala',1,'2008-07-24 23:00:00','2008-07-24 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 ('GT','{\"en\":\"Salcajá\"}',-91.46,14.88,'P','PPLA2','GT.13',NULL,11966,'America/Guatemala',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 ('GT','{\"en\":\"Salamá\"}',-90.32,15.10,'P','PPLA','GT.02','GT.02.1501',40000,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Sacapulas\"}',-91.09,15.29,'P','PPLA2','GT.14',NULL,12088,'America/Guatemala',1,'2017-03-03 23:00:00','2017-03-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 ('GT','{\"en\":\"Río Hondo\"}',-89.59,15.05,'P','PPLA2','GT.22',NULL,5997,'America/Guatemala',1,'2020-03-07 23:00:00','2020-03-07 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 ('GT','{\"en\":\"Río Bravo\"}',-91.32,14.40,'P','PPL','GT.20',NULL,7568,'America/Guatemala',1,'2014-07-19 23:00:00','2014-07-19 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 ('GT','{\"en\":\"Retalhuleu\"}',-91.68,14.54,'P','PPLA','GT.15','GT.15.1101',36656,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Rabinal\"}',-90.49,15.09,'P','PPLA2','GT.02','GT.02.1503',10737,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Quetzaltenango\"}',-91.52,14.83,'P','PPLA','GT.13',NULL,132230,'America/Guatemala',1,'2012-12-04 23:00:00','2012-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 ('GT','{\"en\":\"Purulhá\"}',-90.24,15.24,'P','PPLA2','GT.02','GT.02.1508',5370,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Puerto San José\"}',-90.82,13.93,'P','PPL','GT.06','GT.06.509',18655,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Puerto Barrios\"}',-88.59,15.73,'P','PPLA','GT.09','GT.09.1801',56605,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Tiquisate\"}',-91.36,14.28,'P','PPL','GT.06','GT.06.506',18189,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Poptún\"}',-89.42,16.33,'P','PPLA2','GT.12',NULL,17320,'America/Guatemala',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 ('GT','{\"en\":\"Petapa\"}',-90.56,14.50,'P','PPLA2','GT.07','GT.07.117',141455,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Patzún\"}',-91.01,14.68,'P','PPLA2','GT.03','GT.03.407',18704,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Patzicía\"}',-90.93,14.63,'P','PPLA2','GT.03','GT.03.409',16494,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Patulul\"}',-91.16,14.42,'P','PPLA2','GT.20',NULL,14196,'America/Guatemala',1,'2019-08-07 23:00:00','2019-08-07 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 ('GT','{\"en\":\"Pastores\"}',-90.75,14.59,'P','PPLA2','GT.16',NULL,10393,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 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 ('GT','{\"en\":\"Parramos\"}',-90.80,14.61,'P','PPLA2','GT.03','GT.03.414',9613,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Panzos\"}',-89.64,15.40,'P','PPLA2','GT.01','GT.01.1607',25569,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Panajachel\"}',-91.16,14.74,'P','PPLA2','GT.19',NULL,12863,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"Palín\"}',-90.70,14.40,'P','PPLA2','GT.06','GT.06.511',31329,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Palencia\"}',-90.36,14.67,'P','PPLA2','GT.07','GT.07.105',18574,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Pajapita\"}',-92.04,14.72,'P','PPLA2','GT.17',NULL,8164,'America/Guatemala',1,'2014-09-30 23:00:00','2014-09-30 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 ('GT','{\"en\":\"Ostuncalco\"}',-91.62,14.87,'P','PPLA2','GT.13',NULL,28894,'America/Guatemala',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 ('GT','{\"en\":\"Oratorio\"}',-90.18,14.23,'P','PPLA2','GT.18',NULL,10155,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-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 ('GT','{\"en\":\"Ocós\"}',-92.19,14.51,'P','PPLA2','GT.17',NULL,9463,'America/Guatemala',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 ('GT','{\"en\":\"Nuevo San Carlos\"}',-91.69,14.59,'P','PPLA2','GT.15',NULL,19162,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"Nuevo Progreso\"}',-91.92,14.79,'P','PPLA2','GT.17',NULL,8113,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"Nueva Santa Rosa\"}',-90.28,14.38,'P','PPLA2','GT.18',NULL,10130,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-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 ('GT','{\"en\":\"Nueva Concepción\"}',-91.30,14.20,'P','PPLA2','GT.06','GT.06.513',11121,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Nebaj\"}',-91.15,15.41,'P','PPLA2','GT.14',NULL,23301,'America/Guatemala',1,'2017-03-03 23:00:00','2017-03-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 ('GT','{\"en\":\"Nahualá\"}',-91.32,14.84,'P','PPLA2','GT.19',NULL,27690,'America/Guatemala',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 ('GT','{\"en\":\"Moyuta\"}',-90.08,14.04,'P','PPLA2','GT.11',NULL,8145,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-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 ('GT','{\"en\":\"Morales\"}',-88.84,15.47,'P','PPLA2','GT.09','GT.09.1804',18994,'America/Guatemala',1,'2020-07-15 23:00:00','2020-07-15 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 ('GT','{\"en\":\"Monjas\"}',-89.87,14.50,'P','PPLA2','GT.10','GT.10.2106',10351,'America/Guatemala',1,'2020-07-19 23:00:00','2020-07-19 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 ('GT','{\"en\":\"Momostenango\"}',-91.41,15.04,'P','PPLA2','GT.21','GT.21.805',31739,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Mixco\"}',-90.61,14.63,'P','PPLA2','GT.07','GT.07.108',473080,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Mazatenango\"}',-91.50,14.53,'P','PPLA','GT.20',NULL,44132,'America/Guatemala',1,'2012-12-04 23:00:00','2012-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 ('GT','{\"en\":\"Mataquescuintla\"}',-90.18,14.53,'P','PPLA2','GT.10','GT.10.2107',7539,'America/Guatemala',1,'2020-07-19 23:00:00','2020-07-19 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 ('GT','{\"en\":\"Masagua\"}',-90.85,14.20,'P','PPLA2','GT.06','GT.06.505',10045,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Malacatán\"}',-92.06,14.91,'P','PPLA2','GT.17',NULL,14923,'America/Guatemala',1,'2018-11-05 23:00:00','2018-11-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 ('GT','{\"en\":\"Magdalena Milpas Altas\"}',-90.67,14.55,'P','PPLA2','GT.16',NULL,5582,'America/Guatemala',1,'2019-04-09 23:00:00','2019-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 ('GT','{\"en\":\"Lívingston\"}',-88.75,15.83,'P','PPLA2','GT.09','GT.09.1802',14350,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"La Libertad\"}',-90.12,16.79,'P','PPLA2','GT.12','GT.12.1705',8646,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"La Libertad\"}',-91.87,15.51,'P','PPLA2','GT.08','GT.08.1311',6439,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"La Gomera\"}',-91.05,14.08,'P','PPLA2','GT.06','GT.06.507',24001,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"La Esperanza\"}',-91.56,14.87,'P','PPLA2','GT.13','GT.13.923',16461,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"La Democracia\"}',-90.95,14.23,'P','PPLA2','GT.06','GT.06.503',5479,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Jutiapa\"}',-89.90,14.29,'P','PPLA','GT.11','GT.11.2201',34332,'America/Guatemala',1,'2020-07-19 23:00:00','2020-07-19 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 ('GT','{\"en\":\"Joyabaj\"}',-90.80,14.99,'P','PPLA2','GT.14',NULL,13164,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 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 ('GT','{\"en\":\"Jocotenango\"}',-90.74,14.58,'P','PPLA2','GT.16',NULL,17918,'America/Guatemala',1,'2019-04-09 23:00:00','2019-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 ('GT','{\"en\":\"Jalpatagua\"}',-90.01,14.14,'P','PPLA2','GT.11',NULL,10469,'America/Guatemala',1,'2020-03-07 23:00:00','2020-03-07 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 ('GT','{\"en\":\"Jalapa\"}',-89.99,14.63,'P','PPLA','GT.10','GT.10.2101',45834,'America/Guatemala',1,'2020-07-19 23:00:00','2020-07-19 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 ('GT','{\"en\":\"Jacaltenango\"}',-91.71,15.67,'P','PPLA2','GT.08','GT.08.1307',34084,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Ipala\"}',-89.62,14.62,'P','PPLA2','GT.04','GT.04.2011',5283,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Huitán\"}',-91.64,15.05,'P','PPLA2','GT.13',NULL,9958,'America/Guatemala',1,'2017-02-03 23:00:00','2017-02-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 ('GT','{\"en\":\"Huehuetenango\"}',-91.47,15.32,'P','PPLA','GT.08','GT.08.1301',79426,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Guazacapán\"}',-90.42,14.07,'P','PPLA2','GT.18',NULL,7080,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-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 ('GT','{\"en\":\"Gualán\"}',-89.36,15.12,'P','PPL','GT.22','GT.22.1904',19354,'America/Guatemala',1,'2021-11-11 23:00:00','2021-11-11 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 ('GT','{\"en\":\"Fraijanes\"}',-90.44,14.47,'P','PPLA2','GT.07','GT.07.113',28492,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Flores Costa Cuca\"}',-91.86,14.63,'P','PPL','GT.13',NULL,11984,'America/Guatemala',1,'2014-07-22 23:00:00','2014-07-22 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 ('GT','{\"en\":\"Flores\"}',-89.90,16.92,'P','PPLA','GT.12','GT.12.1701',20464,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Estanzuela\"}',-89.57,15.00,'P','PPLA2','GT.22',NULL,8937,'America/Guatemala',1,'2020-03-07 23:00:00','2020-03-07 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 ('GT','{\"en\":\"Esquipulas\"}',-89.35,14.57,'P','PPLA2','GT.04','GT.04.2007',20674,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Escuintla\"}',-90.79,14.30,'P','PPLA','GT.06','GT.06.501',103165,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"El Tumbador\"}',-91.93,14.86,'P','PPLA2','GT.17',NULL,7562,'America/Guatemala',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 ('GT','{\"en\":\"El Tejar\"}',-90.79,14.65,'P','PPLA2','GT.03','GT.03.416',15770,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"El Quetzal\"}',-91.82,14.77,'P','PPLA2','GT.17',NULL,12122,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"Guastatoya\"}',-90.07,14.85,'P','PPLA','GT.05','GT.05.201',13467,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"El Progreso\"}',-89.85,14.36,'P','PPLA2','GT.11','GT.11.2202',7350,'America/Guatemala',1,'2020-07-19 23:00:00','2020-07-19 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 ('GT','{\"en\":\"El Palmar\"}',-91.58,14.65,'P','PPLA2','GT.13',NULL,15167,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"El Estor\"}',-89.33,15.53,'P','PPLA2','GT.09','GT.09.1803',15842,'America/Guatemala',1,'2020-07-15 23:00:00','2020-07-15 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 ('GT','{\"en\":\"El Asintal\"}',-91.73,14.60,'P','PPLA2','GT.15',NULL,6156,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"Dolores\"}',-89.42,16.51,'P','PPLA2','GT.12',NULL,10604,'America/Guatemala',1,'2019-06-04 23:00:00','2019-06-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 ('GT','{\"en\":\"Cuyotenango\"}',-91.57,14.54,'P','PPLA2','GT.20','GT.20.1002',10825,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Cunén\"}',-91.03,15.34,'P','PPLA2','GT.14',NULL,8400,'America/Guatemala',1,'2017-03-03 23:00:00','2017-03-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 ('GT','{\"en\":\"Cuilapa\"}',-90.30,14.28,'P','PPLA','GT.18',NULL,16484,'America/Guatemala',1,'2012-12-04 23:00:00','2012-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 ('GT','{\"en\":\"Cubulco\"}',-90.63,15.10,'P','PPLA2','GT.02','GT.02.1504',9753,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Concepción Chiquirichapa\"}',-91.62,14.86,'P','PPLA2','GT.13',NULL,8080,'America/Guatemala',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 ('GT','{\"en\":\"Concepción Huista\"}',-91.67,15.62,'P','PPLA2','GT.08','GT.08.1322',8925,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Comitancillo\"}',-91.75,15.09,'P','PPLA2','GT.17',NULL,19669,'America/Guatemala',1,'2017-02-03 23:00:00','2017-02-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 ('GT','{\"en\":\"Comalapa\"}',-90.89,14.74,'P','PPLA2','GT.03','GT.03.404',20738,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Colomba\"}',-91.73,14.71,'P','PPLA2','GT.13',NULL,19115,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"Cobán\"}',-90.37,15.47,'P','PPLA','GT.01','GT.01.1601',53375,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Coatepeque\"}',-91.86,14.70,'P','PPLA2','GT.13',NULL,45654,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"Ciudad Vieja\"}',-90.76,14.52,'P','PPLA2','GT.16',NULL,30203,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 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 ('GT','{\"en\":\"Ciudad Tecún Umán\"}',-92.14,14.68,'P','PPLA2','GT.17',NULL,11432,'America/Guatemala',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 ('GT','{\"en\":\"Melchor de Mencos\"}',-89.15,17.07,'P','PPL','GT.12',NULL,11457,'America/Guatemala',1,'2013-12-14 23:00:00','2013-12-14 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 ('GT','{\"en\":\"Guatemala City\"}',-90.51,14.64,'P','PPLC','GT.07','GT.07.101',994938,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Chuarrancho\"}',-90.52,14.82,'P','PPLA2','GT.07','GT.07.112',7149,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Chisec\"}',-90.29,15.81,'P','PPLA2','GT.01','GT.01.1613',17018,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Chiquimulilla\"}',-90.39,14.08,'P','PPL','GT.18','GT.18.608',12842,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Chiquimula\"}',-89.55,14.80,'P','PPLA','GT.04','GT.04.2001',41521,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Chinautla\"}',-90.50,14.70,'P','PPLA2','GT.07','GT.07.106',97172,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Chimaltenango\"}',-90.82,14.66,'P','PPLA','GT.03','GT.03.401',82370,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Chichicastenango\"}',-91.11,14.94,'P','PPLA2','GT.14',NULL,79759,'America/Guatemala',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 ('GT','{\"en\":\"Chicacao\"}',-91.33,14.54,'P','PPLA2','GT.20',NULL,20426,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"Chiantla\"}',-91.46,15.35,'P','PPLA2','GT.08','GT.08.1302',8465,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Champerico\"}',-91.91,14.29,'P','PPLA2','GT.15','GT.15.1107',7761,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Chajul\"}',-91.04,15.49,'P','PPLA2','GT.14','GT.14.1405',11657,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Chahal\"}',-89.61,15.79,'P','PPL','GT.01','GT.01.1614',7465,'America/Guatemala',1,'2021-10-31 23:00:00','2021-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 ('GT','{\"en\":\"Casillas\"}',-90.24,14.42,'P','PPLA2','GT.18',NULL,8970,'America/Guatemala',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 ('GT','{\"en\":\"Cantel\"}',-91.46,14.81,'P','PPLA2','GT.13',NULL,26063,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"Cabricán\"}',-91.65,15.07,'P','PPLA2','GT.13',NULL,11946,'America/Guatemala',1,'2017-02-03 23:00:00','2017-02-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 ('GT','{\"en\":\"Barillas\"}',-91.32,15.80,'P','PPLA2','GT.08','GT.08.1326',14100,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Barberena\"}',-90.36,14.31,'P','PPLA2','GT.18',NULL,30539,'America/Guatemala',1,'2019-07-09 23:00:00','2019-07-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 ('GT','{\"en\":\"Atescatempa\"}',-89.74,14.18,'P','PPLA2','GT.11','GT.11.2207',11543,'America/Guatemala',1,'2020-07-19 23:00:00','2020-07-19 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 ('GT','{\"en\":\"Asunción Mita\"}',-89.71,14.33,'P','PPLA2','GT.11','GT.11.2205',15608,'America/Guatemala',1,'2020-07-19 23:00:00','2020-07-19 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 ('GT','{\"en\":\"Antigua Guatemala\"}',-90.73,14.56,'P','PPLA','GT.16',NULL,39368,'America/Guatemala',1,'2012-01-15 23:00:00','2012-01-15 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 ('GT','{\"en\":\"Amatitlán\"}',-90.63,14.48,'P','PPLA2','GT.07','GT.07.114',71836,'America/Guatemala',1,'2020-07-11 23:00:00','2020-07-11 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 ('GT','{\"en\":\"Alotenango\"}',-90.80,14.49,'P','PPLA2','GT.16',NULL,17410,'America/Guatemala',1,'2020-01-07 23:00:00','2020-01-07 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 ('GT','{\"en\":\"Almolonga\"}',-91.49,14.82,'P','PPLA2','GT.13',NULL,11913,'America/Guatemala',1,'2019-01-08 23:00:00','2019-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 ('GT','{\"en\":\"Aguacatán\"}',-91.31,15.34,'P','PPLA2','GT.08','GT.08.1327',5572,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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 ('GT','{\"en\":\"Acatenango\"}',-90.94,14.55,'P','PPLA2','GT.03','GT.03.411',7050,'America/Guatemala',1,'2020-07-14 23:00:00','2020-07-14 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
