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

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

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

/*!40000 ALTER TABLE `<<prefix>>subadmin1` DISABLE KEYS */;
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.22','GT','Zacapa','Zacapa',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.21','GT','Totonicapán','Totonicapan',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.20','GT','Suchitepeque','Suchitepeque',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.19','GT','Sololá','Solola',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.18','GT','Santa Rosa','Santa Rosa',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.17','GT','San Marcos','San Marcos',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.16','GT','Sacatepéquez','Sacatepequez',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.15','GT','Retalhuleu','Retalhuleu',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.14','GT','Quiché','Quiche',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.13','GT','Quetzaltenango','Quetzaltenango',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.12','GT','Petén','Peten',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.11','GT','Jutiapa','Jutiapa',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.10','GT','Jalapa','Jalapa',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.09','GT','Izabal','Izabal',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.08','GT','Huehuetenango','Huehuetenango',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.07','GT','Guatemala','Guatemala',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.06','GT','Escuintla','Escuintla',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.05','GT','El Progreso','El Progreso',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.04','GT','Chiquimula','Chiquimula',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.03','GT','Chimaltenango','Chimaltenango',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.02','GT','Baja Verapaz','Baja Verapaz',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('GT.01','GT','Alta Verapaz','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`, `asciiname`, `active`) VALUES ('GT.20.3587505','GT','GT.20','Municipio de Zunilito','Municipio de Zunilito',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3587508','GT','GT.13','Municipio de Zunil','Municipio de Zunil',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.03.3587541','GT','GT.03','Municipio de Zaragoza','Municipio de Zaragoza',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.11.3587545','GT','GT.11','Municipio de Zapotitlán','Municipio de Zapotitlan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.22.3587585','GT','GT.22','Municipio de Zacapa','Municipio de Zacapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.11.3587591','GT','GT.11','Municipio de Yupiltepeque','Municipio de Yupiltepeque',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.03.3587635','GT','GT.03','Municipio de Yepocapa','Municipio de Yepocapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.3587901','GT','GT.07','Municipio de Villa Nueva','Municipio de Villa Nueva',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.3587922','GT','GT.07','Municipio de Villa Canales','Municipio de Villa Canales',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.22.3588039','GT','GT.22','Municipio de Usumatlán','Municipio de Usumatlan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.3588042','GT','GT.14','Municipio de Uspantán','Municipio de Uspantan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.3588205','GT','GT.01','Municipio de Tucurú','Municipio de Tucuru',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.21.3588255','GT','GT.21','Municipio de Totonicapán','Municipio de Totonicapan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3588307','GT','GT.08','Municipio de Todos Santos Cuchumatán','Municipio de Todos Santos Cuchumatan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.06.3588341','GT','GT.06','Município de Tiquisate','Municipio de Tiquisate',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3588459','GT','GT.17','Municipio de Tejutla','Municipio de Tejutla',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.22.3588468','GT','GT.22','Municipio de Teculután','Municipio de Teculutan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3588473','GT','GT.08','Municipio de Tectitán','Municipio de Tectitan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.03.3588475','GT','GT.03','Municipio de Tecpán Guatemala','Municipio de Tecpan Guatemala',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.18.3588490','GT','GT.18','Municipio de Taxisco','Municipio de Taxisco',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.3588553','GT','GT.01','Municipio de Tamahú','Municipio de Tamahu',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3588587','GT','GT.17','Municipio de Tajumulco','Municipio de Tajumulco',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.3588602','GT','GT.01','Municipio de Tactic','Municipio de Tactic',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3588609','GT','GT.17','Municipio de Tacaná','Municipio de Tacana',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.16.3588652','GT','GT.16','Municipio de Sumpango','Municipio de Sumpango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3588693','GT','GT.08','San Pedro Soloma','San Pedro Soloma',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3588695','GT','GT.19','Municipio de Sololá','Municipio de Solola',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.06.3588719','GT','GT.06','Municipio de Siquinalá','Municipio de Siquinala',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3588725','GT','GT.17','Municipio de Sipacapa','Municipio de Sipacapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3588759','GT','GT.17','Municipio de Sibinal','Municipio de Sibinal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3588761','GT','GT.13','Municipio de Sibilia','Municipio de Sibilia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.3588857','GT','GT.01','Municipio de Senahú','Municipio de Senahu',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.12.3588983','GT','GT.12','Municipio de Sayaxché','Municipio de Sayaxche',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.06.3589034','GT','GT.06','Municipio de San Vicente Pacaya','Municipio de San Vicente Pacaya',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3589061','GT','GT.20','Municipio de Santo Tomás La Unión','Municipio de Santo Tomas La Union',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.16.3589071','GT','GT.16','Municipio de Santo Domingo Xenacoj','Municipio de Santo Domingo Xenacoj',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3589073','GT','GT.20','Municipio de Santo Domingo Suchitepéquez','Municipio de Santo Domingo Suchitepequez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.16.3589100','GT','GT.16','Municipio de Santiago Sacatepéquez','Municipio de Santiago Sacatepequez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3589102','GT','GT.08','Municipio de Santiago Chimaltenango','Municipio de Santiago Chimaltenango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3589104','GT','GT.19','Municipio de Santiago Atitlán','Municipio de Santiago Atitlan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.18.3589158','GT','GT.18','Municipio de Santa Rosa de Lima','Municipio de Santa Rosa de Lima',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3589246','GT','GT.19','Municipio de Santa María Visitación','Municipio de Santa Maria Visitacion',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.18.3589248','GT','GT.18','Municipio de Santa María Ixhuatán','Municipio de Santa Maria Ixhuatan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.16.3589251','GT','GT.16','Municipio de Santa María de Jesús','Municipio de Santa Maria de Jesus',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.21.3589255','GT','GT.21','Municipio de Santa María Chiquimula','Municipio de Santa Maria Chiquimula',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3589281','GT','GT.19','Municipio de Santa Lucía Utatlán','Municipio de Santa Lucia Utatlan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.16.3589284','GT','GT.16','Municipio de Santa Lucía Milpas Altas','Municipio de Santa Lucia Milpas Altas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.21.3589286','GT','GT.21','Municipio de Santa Lucía La Reforma','Municipio de Santa Lucia La Reforma',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.06.3589288','GT','GT.06','Municipio de Santa Lucía Cotzumalguapa','Municipio de Santa Lucia Cotzumalguapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3589354','GT','GT.08','Municipio de Santa Eulalia','Municipio de Santa Eulalia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.3589394','GT','GT.01','Municipio de Santa Cruz Verapaz','Municipio de Santa Cruz Verapaz',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.18.3589397','GT','GT.18','Municipio de Santa Cruz Naranjo','Municipio de Santa Cruz Naranjo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.15.3589399','GT','GT.15','Municipio de Santa Cruz Muluá','Municipio de Santa Cruz Mulua',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3589401','GT','GT.19','Municipio de Santa Cruz La Laguna','Municipio de Santa Cruz La Laguna',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.3589403','GT','GT.14','Municipio de Santa Cruz del Quiché','Municipio de Santa Cruz del Quiche',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.03.3589407','GT','GT.03','Municipio de Santa Cruz Balanyá','Municipio de Santa Cruz Balanya',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3589432','GT','GT.19','Municipio de Santa Clara La Laguna','Municipio de Santa Clara La Laguna',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.3589451','GT','GT.07','Municipio de Santa Catarina Pinula','Municipio de Santa Catarina Pinula',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3589453','GT','GT.19','Municipio de Santa Catarina Palopó','Municipio de Santa Catarina Palopo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.11.3589455','GT','GT.11','Municipio de Santa Catarina Mita','Municipio de Santa Catarina Mita',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3589457','GT','GT.19','Municipio de Santa Catarina Ixtahuacán','Municipio de Santa Catarina Ixtahuacan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.16.3589459','GT','GT.16','Municipio de Santa Catarina Barahona','Municipio de Santa Catarina Barahona',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3589464','GT','GT.08','Municipio de Santa Bárbara','Municipio de Santa Barbara',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3589465','GT','GT.20','Municipio de Santa Bárbara','Municipio de Santa Barbara',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.03.3589479','GT','GT.03','Municipio de Santa Apolonia','Municipio de Santa Apolonia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3589497','GT','GT.08','Municipio de Santa Ana Huista','Municipio de Santa Ana Huista',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.12.3589501','GT','GT.12','Municipio de Santa Ana','Municipio de Santa Ana',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3589540','GT','GT.08','Municipio de San Sebastián Huehuetenango','Municipio de San Sebastian Huehuetenango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3589542','GT','GT.08','Municipio de San Sebastián Coatán','Municipio de San Sebastian Coatan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.15.3589545','GT','GT.15','Municipio de San Sebastián','Municipio de San Sebastian',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.05.3589553','GT','GT.05','Municipio de Sansare','Municipio de Sansare',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.3589568','GT','GT.07','Municipio de San Raymundo','Municipio de San Raymundo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3589576','GT','GT.17','Municipio de San Rafael Pie de la Cuesta','Municipio de San Rafael Pie de la Cuesta',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3589578','GT','GT.08','Municipio de San Rafael Petzal','Municipio de San Rafael Petzal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.18.3589588','GT','GT.18','Municipio de San Rafael Las Flores','Municipio de San Rafael Las Flores',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3589594','GT','GT.08','Municipio de San Rafael La Independencia','Municipio de San Rafael La Independencia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3589624','GT','GT.17','Municipio de San Pedro Sacatepéquez','Municipio de San Pedro Sacatepequez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.3589625','GT','GT.07','Municipio de San Pedro Sacatepéquez','Municipio de San Pedro Sacatepequez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.10.3589628','GT','GT.10','Municipio de San Pedro Pinula','Municipio de San Pedro Pinula',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3589631','GT','GT.08','Municipio de San Pedro Necta','Municipio de San Pedro Necta',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3589636','GT','GT.19','Municipio de San Pedro La Laguna','Municipio de San Pedro La Laguna',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.3589639','GT','GT.14','Municipio de San Pedro Jocopilas','Municipio de San Pedro Jocopilas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.3589642','GT','GT.01','Municipio de San Pedro Carchá','Municipio de San Pedro Carcha',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.3589645','GT','GT.07','Municipio de San Pedro Ayampuc','Municipio de San Pedro Ayampuc',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3589668','GT','GT.19','Municipio de San Pablo La Laguna','Municipio de San Pablo La Laguna',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3589670','GT','GT.20','Municipio de San Pablo Jocopilas','Municipio de San Pablo Jocopilas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3589673','GT','GT.17','Municipio de San Pablo','Municipio de San Pablo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3589705','GT','GT.13','Municipio de San Miguel Sigüilá','Municipio de San Miguel Siguila',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3589708','GT','GT.20','Municipio de San Miguel Panán','Municipio de San Miguel Panan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3589719','GT','GT.17','Municipio de San Miguel Ixtahuacán','Municipio de San Miguel Ixtahuacan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.16.3589726','GT','GT.16','Municipio de San Miguel Dueñas','Municipio de San Miguel Duenas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.02.3589729','GT','GT.02','Municipio de San Miguel Chicaj','Municipio de San Miguel Chicaj',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3589733','GT','GT.08','Municipio de San Miguel Acatán','Municipio de San Miguel Acatan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3589769','GT','GT.08','Municipio de San Mateo Ixtatán','Municipio de San Mateo Ixtatan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3589772','GT','GT.13','Municipio de San Mateo','Municipio de San Mateo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.15.3589775','GT','GT.15','Municipio de San Martín Zapotitlán','Municipio de San Martin Zapotitlan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3589777','GT','GT.13','Municipio de San Martín Sacatepéquez','Municipio de San Martin Sacatepequez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.03.3589779','GT','GT.03','Municipio de San Martín Jilotepeque','Municipio de San Martin Jilotepeque',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3589794','GT','GT.19','Municipio de San Marcos La Laguna','Municipio de San Marcos La Laguna',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3589799','GT','GT.17','Municipio de San Marcos','Municipio de San Marcos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.10.3589811','GT','GT.10','Municipio de San Manuel Chaparrón','Municipio de San Manuel Chaparron',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.10.3589821','GT','GT.10','Municipio de San Luis Jilotepeque','Municipio de San Luis Jilotepeque',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.12.3589835','GT','GT.12','Municipio de San Luis','Municipio de San Luis',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3589849','GT','GT.19','Municipio de San Lucas Tolimán','Municipio de San Lucas Toliman',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.16.3589851','GT','GT.16','Municipio de San Lucas Sacatepéquez','Municipio de San Lucas Sacatepequez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3589860','GT','GT.17','Municipio de San Lorenzo','Municipio de San Lorenzo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3589861','GT','GT.20','Municipio de San Lorenzo','Municipio de San Lorenzo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.18.3589879','GT','GT.18','Municipio de San Juan Tecuaco','Municipio de San Juan Tecuaco',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.3589884','GT','GT.07','Municipio de San Juan Sacatepéquez','Municipio de San Juan Sacatepequez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3589895','GT','GT.19','Municipio de San Juan La Laguna','Municipio de San Juan La Laguna',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3589899','GT','GT.08','Municipio de San Juan Ixcoy','Municipio de San Juan Ixcoy',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.04.3589902','GT','GT.04','Municipio de San Juan la Ermita','Municipio de San Juan la Ermita',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.3589912','GT','GT.14','Municipio de San Juan Cotzal','Municipio de San Juan Cotzal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.3589916','GT','GT.01','Municipio de San Juan Chamelco','Municipio de San Juan Chamelco',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3589920','GT','GT.20','Municipio de San Juan Bautista','Municipio de San Juan Bautista',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3589924','GT','GT.08','Municipio de San Juan Atitán','Municipio de San Juan Atitan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.03.3589974','GT','GT.03','Municipio de San José Poaquil','Municipio de San Jose Poaquil',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.3589976','GT','GT.07','Municipio de San José Pinula','Municipio de San Jose Pinula',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3589984','GT','GT.17','Municipio de San José Ojetenam','Municipio de San Jose Ojetenam',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.04.3590016','GT','GT.04','Municipio de San José La Arada','Municipio de San Jose La Arada',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3590028','GT','GT.20','Municipio de San José El Ídolo','Municipio de San Jose El Idolo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.3590033','GT','GT.07','Municipio de San José del Golfo','Municipio de San Jose del Golfo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3590040','GT','GT.19','Municipio de San José Chacayá','Municipio de San Jose Chacaya',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.11.3590052','GT','GT.11','Municipio de San José Acatempa','Municipio de San Jose Acatempa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.12.3590058','GT','GT.12','Municipio de San José','Municipio de San Jose',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.06.3590059','GT','GT.06','Municipio de San José','Municipio de San Jose',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.02.3590106','GT','GT.02','Municipio de San Jerónimo','Municipio de San Jeronimo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.04.3590124','GT','GT.04','Municipio de San Jacinto','Municipio de San Jacinto',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3590187','GT','GT.08','Municipio de San Gaspar Ixchil','Municipio de San Gaspar Ixchil',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3590192','GT','GT.20','Municipio de San Gabriel','Municipio de San Gabriel',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3590196','GT','GT.20','Municipio de San Francisco Zapotitlán','Municipio de San Francisco Zapotitlan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3590210','GT','GT.13','Municipio de San Francisco La Unión','Municipio de San Francisco La Union',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.21.3590218','GT','GT.21','Municipio de San Francisco El Alto','Municipio de San Francisco El Alto',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.12.3590233','GT','GT.12','Municipio de San Francisco','Municipio de San Francisco',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.15.3590281','GT','GT.15','Municipio de San Felipe','Municipio de San Felipe',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.22.3590305','GT','GT.22','Municipio de San Diego','Municipio de San Diego',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.3590315','GT','GT.01','Municipio de San Cristóbal Verapaz','Municipio de San Cristobal Verapaz',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.21.3590317','GT','GT.21','Municipio de San Cristóbal Totonicapán','Municipio de San Cristobal Totonicapan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3590322','GT','GT.17','Municipio de San Cristóbal Cucho','Municipio de San Cristobal Cucho',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.05.3590324','GT','GT.05','Municipio de San Cristóbal Acasaguastlán','Municipio de San Cristobal Acasaguastlan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3590346','GT','GT.13','Municipio de San Carlos Sija','Municipio de San Carlos Sija',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.10.3590354','GT','GT.10','Municipio de San Carlos Alzatate','Municipio de San Carlos Alzatate',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3590382','GT','GT.20','Municipio de San Bernardino','Municipio de San Bernardino',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.12.3590386','GT','GT.12','Municipio de San Benito','Municipio de San Benito',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.16.3590392','GT','GT.16','Municipio de San Bartolomé Milpas Altas','Municipio de San Bartolome Milpas Altas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.3590394','GT','GT.14','Municipio de San Bartolomé Jocotenango','Municipio de San Bartolome Jocotenango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.21.3590397','GT','GT.21','Municipio de San Bartolo Aguas Calientes','Municipio de San Bartolo Aguas Calientes',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.05.3590405','GT','GT.05','Municipio de Sanarate','Municipio de Sanarate',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3590411','GT','GT.20','Municipio de San Antonio Suchitepéquez','Municipio de San Antonio Suchitepequez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3590418','GT','GT.17','Municipio de San Antonio Sacatepéquez','Municipio de San Antonio Sacatepequez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3590423','GT','GT.19','Municipio de San Antonio Palopó','Municipio de San Antonio Palopo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.05.3590447','GT','GT.05','Municipio de San Antonio La Paz','Municipio de San Antonio La Paz',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.3590455','GT','GT.14','Municipio de San Antonio Ilotenango','Municipio de San Antonio Ilotenango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3590457','GT','GT.08','Municipio de San Antonio Huista','Municipio de San Antonio Huista',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.16.3590474','GT','GT.16','Municipio de San Antonio Aguas Calientes','Municipio de San Antonio Aguas Calientes',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.21.3590519','GT','GT.21','Municipio de San Andrés Xecul','Municipio de San Andres Xecul',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.15.3590521','GT','GT.15','Municipio de San Andrés Villa Seca','Municipio de San Andres Villa Seca',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3590523','GT','GT.19','Municipio de San Andrés Semetabaj','Municipio de San Andres Semetabaj',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.3590525','GT','GT.14','Municipio de San Andrés Sajcabajá','Municipio de San Andres Sajcabaja',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.03.3590528','GT','GT.03','Municipio de San Andrés Itzapa','Municipio de San Andres Itzapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.12.3590534','GT','GT.12','Municipio de San Andrés','Municipio de San Andres',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.05.3590546','GT','GT.05','Municipio de San Agustín Acasaguastlán','Municipio de San Agustin Acasaguastlan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3590566','GT','GT.20','Municipio de Samayac','Municipio de Samayac',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3590604','GT','GT.13','Municipio de Salcajá','Municipio de Salcaja',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.02.3590615','GT','GT.02','Municipio de Salamá','Municipio de Salama',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.3590689','GT','GT.14','Municipio de Sacapulas','Municipio de Sacapulas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.22.3590786','GT','GT.22','Municipio de Río Hondo','Municipio de Rio Hondo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3590802','GT','GT.20','Municipio de Río Bravo','Municipio de Rio Bravo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3590807','GT','GT.17','Municipio de Río Blanco','Municipio de Rio Blanco',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.15.3590856','GT','GT.15','Municipio de Retalhuleu','Municipio de Retalhuleu',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.02.3590923','GT','GT.02','Municipio de Rabinal','Municipio de Rabinal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.04.3590972','GT','GT.04','Municipio de Quezaltepeque','Municipio de Quezaltepeque',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3590977','GT','GT.13','Municipio de Quetzaltenango','Municipio de Quetzaltenango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.11.3590986','GT','GT.11','Municipio de Quesada','Municipio de Quesada',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.02.3591027','GT','GT.02','Municipio de Purulhá','Municipio de Purulha',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.09.3591061','GT','GT.09','Municipio de Puerto Barrios','Municipio de Puerto Barrios',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.18.3591091','GT','GT.18','Municipio de Pueblo Nuevo Viñas','Municipio de Pueblo Nuevo Vinas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3591096','GT','GT.20','Municipio de Pueblo Nuevo','Municipio de Pueblo Nuevo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.12.3591180','GT','GT.12','Municipio de Poptún','Municipio de Poptun',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.03.3591209','GT','GT.03','Municipio de Pochuta','Municipio de Pochuta',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.3591414','GT','GT.07','Municipio de Petapa','Municipio de Petapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.03.3591511','GT','GT.03','Municipio de Patzún','Municipio de Patzun',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.3591516','GT','GT.14','Municipio de Patzité','Municipio de Patzite',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.03.3591521','GT','GT.03','Municipio de Patzicía','Municipio de Patzicia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3591540','GT','GT.20','Municipio de Patulul','Municipio de Patulul',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.16.3591573','GT','GT.16','Municipio de Pastores','Municipio de Pastores',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.11.3591617','GT','GT.11','Municipio de Pasaco','Municipio de Pasaco',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.03.3591628','GT','GT.03','Municipio de Parramos','Municipio de Parramos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.3591675','GT','GT.01','Municipio de Panzós','Municipio de Panzos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3591748','GT','GT.19','Municipio de Panajachel','Municipio de Panajachel',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.06.3591830','GT','GT.06','Municipio de Palín','Municipio de Palin',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3591840','GT','GT.13','Municipio de Palestina de los Altos','Municipio de Palestina de los Altos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.3591849','GT','GT.07','Municipio de Palencia','Municipio de Palencia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3591884','GT','GT.17','Municipio de Pajapita','Municipio de Pajapita',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3591996','GT','GT.13','Municipio de San Juan Ostuncalco','Municipio de San Juan Ostuncalco',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.18.3592017','GT','GT.18','Municipio de Oratorio','Municipio de Oratorio',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.04.3592034','GT','GT.04','Municipio de Olopa','Municipio de Olopa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3592040','GT','GT.13','Municipio de Olintepeque','Municipio de Olintepeque',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3592084','GT','GT.17','Municipio de Ocós','Municipio de Ocos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.15.3592104','GT','GT.15','Municipio de Nuevo San Carlos','Municipio de Nuevo San Carlos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3592107','GT','GT.17','Municipio de Nuevo Progreso','Municipio de Nuevo Progreso',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.18.3592125','GT','GT.18','Municipio de Nueva Santa Rosa','Municipio de Nueva Santa Rosa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.06.3592142','GT','GT.06','Municipio de Nueva Concepción','Municipio de Nueva Concepcion',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3592216','GT','GT.08','Municipio de Nentón','Municipio de Nenton',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.3592236','GT','GT.14','Municipio de Nebaj','Municipio de Nebaj',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3592285','GT','GT.19','Municipio de Nahualá','Municipio de Nahuala',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.11.3592320','GT','GT.11','Municipio de Moyuta','Municipio de Moyuta',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.05.3592348','GT','GT.05','Municipio de Morazán','Municipio de Morazan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.09.3592361','GT','GT.09','Municipio de Morales','Municipio de Morales',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.10.3592476','GT','GT.10','Municipio de Monjas','Municipio de Monjas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.21.3592482','GT','GT.21','Municipio de Momostenango','Municipio de Momostenango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.3592517','GT','GT.07','Municipio de Mixco','Municipio de Mixco',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.12.3592595','GT','GT.12','Municipio de Melchor de Mencos','Municipio de Melchor de Mencos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3592608','GT','GT.20','Municipio de Mazatenango','Municipio de Mazatenango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.10.3592634','GT','GT.10','Municipio de Mataquescuintla','Municipio de Mataquescuintla',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.06.3592641','GT','GT.06','Municipio de Masagua','Municipio de Masagua',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3592750','GT','GT.08','Municipio de Malacatancito','Municipio de Malacatancito',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3592752','GT','GT.17','Municipio de Malacatán','Municipio de Malacatan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.16.3592769','GT','GT.16','Municipio de Magdalena Milpas Altas','Municipio de Magdalena Milpas Altas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.09.3593233','GT','GT.09','Municipio de Los Amates','Municipio de Los Amates',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.09.3593375','GT','GT.09','Municipio de Lívingston','Municipio de Livingston',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.22.3593488','GT','GT.22','Municipio de La Unión','Municipio de La Union',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3594137','GT','GT.17','Municipio de La Reforma','Municipio de La Reforma',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.3594314','GT','GT.01','Municipio de Lanquín','Municipio de Lanquin',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.12.3594418','GT','GT.12','Municipio de La Libertad','Municipio de La Libertad',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3594419','GT','GT.08','Municipio de La Libertad','Municipio de La Libertad',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.06.3594574','GT','GT.06','Municipio de La Gomera','Municipio de La Gomera',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3594666','GT','GT.13','Municipio de La Esperanza','Municipio de La Esperanza',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3594749','GT','GT.08','Municipio de La Democracia','Municipio de La Democracia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.06.3594750','GT','GT.06','Municipio de La Democracia','Municipio de La Democracia',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.11.3595065','GT','GT.11','Municipio de Jutiapa','Municipio de Jutiapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.3595147','GT','GT.14','Municipio de Joyabaj','Municipio de Joyabaj',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.16.3595170','GT','GT.16','Municipio de Jocotenango','Municipio de Jocotenango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.04.3595180','GT','GT.04','Municipio de Jocotán','Municipio de Jocotan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.11.3595222','GT','GT.11','Municipio de Jerez','Municipio de Jerez',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.11.3595231','GT','GT.11','Municipio de Jalpatagua','Municipio de Jalpatagua',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.10.3595235','GT','GT.10','Municipio de Jalapa','Municipio de Jalapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3595247','GT','GT.08','Municipio de Jacaltenango','Municipio de Jacaltenango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.06.3595254','GT','GT.06','Municipio de Iztapa','Municipio de Iztapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3595281','GT','GT.08','San Ildefonso Ixtahuacán','San Ildefonso Ixtahuacan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3595328','GT','GT.17','Municipio de Ixchiguán','Municipio de Ixchiguan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.04.3595363','GT','GT.04','Municipio de Ipala','Municipio de Ipala',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.22.3595402','GT','GT.22','Municipio de Huité','Municipio de Huite',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3595404','GT','GT.13','Municipio de Huitán','Municipio de Huitan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3595414','GT','GT.08','Municipio de Huehuetenango','Municipio de Huehuetenango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.18.3595502','GT','GT.18','Municipio de Guazacapán','Municipio de Guazacapan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.3595529','GT','GT.07','Municipio de Guatemala','Municipio de Guatemala',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.06.3595553','GT','GT.06','Municipio de Guanagazapa','Municipio de Guanagazapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.22.3595559','GT','GT.22','Municipio de Gualán','Municipio de Gualan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.02.3595630','GT','GT.02','Municipio de Granados','Municipio de Granados',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3595670','GT','GT.13','Municipio de Génova','Municipio de Genova',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.3595713','GT','GT.07','Municipio de Fraijanes','Municipio de Fraijanes',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3595720','GT','GT.13','Municipio de Flores Costa Cuca','Municipio de Flores Costa Cuca',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.12.3595722','GT','GT.12','Municipio de Flores','Municipio de Flores',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.22.3595755','GT','GT.22','Municipio de Estanzuela','Municipio de Estanzuela',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3595777','GT','GT.17','Municipio de Esquipulas Palo Gordo','Municipio de Esquipulas Palo Gordo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.04.3595780','GT','GT.04','Municipio de Esquipulas','Municipio de Esquipulas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.06.3595801','GT','GT.06','Municipio de Escuintla','Municipio de Escuintla',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3595928','GT','GT.17','Municipio de El Tumbador','Municipio de El Tumbador',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.03.3596040','GT','GT.03','Municipio de El Tejar','Municipio de El Tejar',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3596243','GT','GT.17','Municipio de El Rodeo','Municipio de El Rodeo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3596386','GT','GT.17','Municipio de El Quetzal','Municipio de El Quetzal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.05.3596410','GT','GT.05','Municipio de El Progreso','Municipio de El Progreso',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.11.3596411','GT','GT.11','Municipio de El Progreso','Municipio de El Progreso',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3596634','GT','GT.13','Municipio de El Palmar','Municipio de El Palmar',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.05.3596938','GT','GT.05','Municipio de El Jícaro','Municipio de El Jicaro',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.09.3597077','GT','GT.09','Municipio de El Estor','Municipio de El Estor',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.02.3597300','GT','GT.02','Municipio de El Chol','Municipio de El Chol',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.15.3597586','GT','GT.15','Municipio de El Asintal','Municipio de El Asintal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.11.3597674','GT','GT.11','Municipio de El Adelanto','Municipio de El Adelanto',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.12.3597716','GT','GT.12','Municipio de Dolores','Municipio de Dolores',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3597749','GT','GT.20','Municipio de Cuyotenango','Municipio de Cuyotenango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.3597771','GT','GT.14','Municipio de Cunén','Municipio de Cunen',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3597800','GT','GT.08','Municipio de Cuilco','Municipio de Cuilco',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.18.3597803','GT','GT.18','Municipio de Cuilapa','Municipio de Cuilapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.02.3597836','GT','GT.02','Municipio de Cubulco','Municipio de Cubulco',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.11.3597965','GT','GT.11','Municipio de Conguaco','Municipio de Conguaco',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3597975','GT','GT.17','Municipio de Concepción Tutuapa','Municipio de Concepcion Tutuapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.04.3597984','GT','GT.04','Municipio de Concepción Las Minas','Municipio de Concepcion Las Minas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3597992','GT','GT.13','Municipio de Concepción Chiquirichapa','Municipio de Concepcion Chiquirichapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3598001','GT','GT.08','Municipio de Concepción Huista','Municipio de Concepcion Huista',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.3598002','GT','GT.19','Municipio de Concepción','Municipio de Concepcion',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3598023','GT','GT.17','Municipio de Comitancillo','Municipio de Comitancillo',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.11.3598030','GT','GT.11','Municipio de Comapa','Municipio de Comapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.03.3598032','GT','GT.03','Municipio de Comalapa','Municipio de Comalapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3598040','GT','GT.08','Municipio de Colotenango','Municipio de Colotenango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3598072','GT','GT.13','Municipio de Colomba','Municipio de Colomba',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.3598116','GT','GT.01','Municipio de Cobán','Municipio de Coban',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3598121','GT','GT.13','Municipio de Coatepeque','Municipio de Coatepeque',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.16.3598127','GT','GT.16','Municipio de Ciudad Vieja','Municipio de Ciudad Vieja',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.3598276','GT','GT.07','Municipio de Chuarrancho','Municipio de Chuarrancho',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.3598414','GT','GT.01','Municipio de Chisec','Municipio de Chisec',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.18.3598459','GT','GT.18','Municipio de Chiquimulilla','Municipio de Chiquimulilla',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.04.3598463','GT','GT.04','Municipio de Chiquimula','Municipio de Chiquimula',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.3598512','GT','GT.14','Municipio de Chinique','Municipio de Chinique',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.3598528','GT','GT.07','Municipio de Chinautla','Municipio de Chinautla',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.03.3598570','GT','GT.03','Municipio de Chimaltenango','Municipio de Chimaltenango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.3598654','GT','GT.14','Municipio de Chichicastenango','Municipio de Chichicastenango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.3598658','GT','GT.14','Municipio de Chiché','Municipio de Chiche',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.3598677','GT','GT.20','Municipio de Chicacao','Municipio de Chicacao',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3598691','GT','GT.08','Municipio de Chiantla','Municipio de Chiantla',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.15.3598786','GT','GT.15','Municipio de Champerico','Municipio de Champerico',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.3598803','GT','GT.14','Municipio de Chajul','Municipio de Chajul',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.3598824','GT','GT.01','Municipio de Chahal','Municipio de Chahal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3598956','GT','GT.17','Municipio de Catarina','Municipio de Catarina',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.18.3598967','GT','GT.18','Municipio de Casillas','Municipio de Casillas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3599066','GT','GT.13','Municipio de Cantel','Municipio de Cantel',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.3599093','GT','GT.14','Municipio de Canillá','Municipio de Canilla',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.04.3599180','GT','GT.04','Municipio de Camotán','Municipio de Camotan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3599252','GT','GT.13','Municipio de Cajolá','Municipio de Cajola',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.3599264','GT','GT.01','Municipio de Cahabón','Municipio de Cahabon',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3599286','GT','GT.13','Municipio de Cabricán','Municipio de Cabrican',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.22.3599294','GT','GT.22','Municipio de Cabañas','Municipio de Cabanas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3599574','GT','GT.08','Municipio de Barillas','Municipio de Barillas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.18.3599580','GT','GT.18','Municipio de Barberena','Municipio de Barberena',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.3599614','GT','GT.17','Municipio de Ayutla','Municipio de Ayutla',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.11.3599631','GT','GT.11','Municipio de Atescatempa','Municipio de Atescatempa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.11.3599638','GT','GT.11','Municipio de Asunción Mita','Municipio de Asuncion Mita',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.16.3599698','GT','GT.16','Municipio de Antigua Guatemala','Municipio de Antigua Guatemala',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.3599732','GT','GT.07','Municipio de Amatitlán','Municipio de Amatitlan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.16.3599786','GT','GT.16','Municipio de Alotenango','Municipio de Alotenango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.3599791','GT','GT.13','Municipio de Almolonga','Municipio de Almolonga',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.3599911','GT','GT.08','Municipio de Aguacatán','Municipio de Aguacatan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.11.3599963','GT','GT.11','Municipio de Agua Blanca','Municipio de Agua Blanca',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.03.3600007','GT','GT.03','Municipio de Acatenango','Municipio de Acatenango',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.9166134','GT','GT.01','Municipio de Fray Bartolome de las Casas','Municipio de Fray Bartolome de las Casas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.9166161','GT','GT.14','Municipio de Ixcan','Municipio de Ixcan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.9166182','GT','GT.14','Municipio de Chicaman','Municipio de Chicaman',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.9253724','GT','GT.08','Municipio de Union Cantinil','Municipio de Union Cantinil',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.9253725','GT','GT.01','Raxruja','Raxruja',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.9253733','GT','GT.14','Municipio de Zacualpa','Municipio de Zacualpa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.05.9253734','GT','GT.05','San Cristobal Acasguastlan','San Cristobal Acasguastlan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.14.9253735','GT','GT.14','Municipio de Pachalum','Municipio de Pachalum',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.19.9253744','GT','GT.19','Lago de Atitlan','Lago de Atitlan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.07.9253756','GT','GT.07','Lago de Amatitlan','Lago de Amatitlan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.9253762','GT','GT.01','Santa Catarina La Tinta','Santa Catarina La Tinta',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.05.9253768','GT','GT.05','Municipio de Guastatoya','Municipio de Guastatoya',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.03.9253822','GT','GT.03','San Juan Comalapa','San Juan Comalapa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.12.9253824','GT','GT.12','Las Cruces','Las Cruces',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.9975174','GT','GT.08','Municipio de Unión Cantinil','Municipio de Union Cantinil',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.9975220','GT','GT.01','Municipio de Santa Catalina la Tinta','Municipio de Santa Catalina la Tinta',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.13.9975221','GT','GT.13','Municipo de San Juan Ostuncalco','Municipo de San Juan Ostuncalco',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.9975223','GT','GT.08','Municipo de San Ildefonso Ixtahuacan','Municipo de San Ildefonso Ixtahuacan',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.01.9975224','GT','GT.01','Municipio de Raxruhá','Municipio de Raxruha',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.20.9975225','GT','GT.20','La Máquina','La Maquina',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.17.9975227','GT','GT.17','Municipio de La Blanca','Municipio de La Blanca',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.22.9975228','GT','GT.22','Municipio de San Jorge','Municipio de San Jorge',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.12.9975229','GT','GT.12','Municipio de El Chal','Municipio de El Chal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.06.12017928','GT','GT.06','Sipacate','Sipacate',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('GT.08.12017929','GT','GT.08','Petatán','Petatan',1);
/*!40000 ALTER TABLE `<<prefix>>subadmin2` ENABLE KEYS */;

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

/*!40000 ALTER TABLE `<<prefix>>cities` DISABLE KEYS */;
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Zunil','Zunil',-91.4835,14.7846,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Zaragoza','Zaragoza',-90.8903,14.6497,'P','PPLA2','GT.03','GT.03.3587541',9361,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Zacualpa','Zacualpa',-90.8782,15.0268,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Zacapa','Zacapa',-89.5306,14.9722,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Yepocapa','Yepocapa',-90.954,14.502,'P','PPLA2','GT.03',NULL,8961,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Villa Nueva','Villa Nueva',-90.5854,14.5251,'P','PPLA2','GT.07',NULL,406830,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Villa Canales','Villa Canales',-90.5342,14.4829,'P','PPLA2','GT.07',NULL,122194,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Totonicapán','Totonicapan',-91.3611,14.9117,'P','PPLA','GT.21','GT.21.3588255',69734,'America/Guatemala',1,'2012-12-04 23:00:00','2012-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Teculután','Teculutan',-89.7194,14.989,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Tecpán Guatemala','Tecpan Guatemala',-90.9925,14.7618,'P','PPLA2','GT.03',NULL,21978,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Taxisco','Taxisco',-90.4679,14.0672,'P','PPL','GT.18','GT.18.3588490',6518,'America/Guatemala',1,'2014-06-30 23:00:00','2014-06-30 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Tactic','Tactic',-90.3545,15.3222,'P','PPL','GT.01','GT.01.3588602',8999,'America/Guatemala',1,'2014-07-23 23:00:00','2014-07-23 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Tacaná','Tacana',-92.0672,15.2406,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Sumpango','Sumpango',-90.7343,14.6462,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Soloma','Soloma',-91.4299,15.6584,'P','PPLA2','GT.08',NULL,10916,'America/Guatemala',1,'2017-03-03 23:00:00','2017-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Sololá','Solola',-91.1833,14.7722,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Senahú','Senahu',-89.8333,15.4,'P','PPLA2','GT.01',NULL,5633,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Sayaxché','Sayaxche',-90.188,16.5245,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Vicente Pacaya','San Vicente Pacaya',-90.6361,14.4147,'P','PPLA2','GT.06',NULL,7162,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santo Tomás La Unión','Santo Tomas La Union',-91.4108,14.6322,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santo Domingo Xenacoj','Santo Domingo Xenacoj',-90.7001,14.6806,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santo Domingo Suchitepéquez','Santo Domingo Suchitepequez',-91.4833,14.479,'P','PPLA2','GT.20',NULL,6270,'America/Guatemala',1,'2019-01-08 23:00:00','2019-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santiago Sacatepéquez','Santiago Sacatepequez',-90.6765,14.6351,'P','PPLA2','GT.16',NULL,24210,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santiago Atitlán','Santiago Atitlan',-91.229,14.6382,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santa Rosa de Lima','Santa Rosa de Lima',-90.2956,14.3881,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santa María de Jesús','Santa Maria de Jesus',-90.7104,14.4945,'P','PPLA2','GT.16','GT.16.3589251',15529,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santa María Chiquimula','Santa Maria Chiquimula',-91.3292,15.0299,'P','PPLA2','GT.21','GT.21.3589255',6980,'America/Guatemala',1,'2017-03-03 23:00:00','2017-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santa Lucía Milpas Altas','Santa Lucia Milpas Altas',-90.6763,14.5765,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santa Lucía Cotzumalguapa','Santa Lucia Cotzumalguapa',-91.0234,14.335,'P','PPLA2','GT.06',NULL,62097,'America/Guatemala',1,'2019-01-08 23:00:00','2019-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santa Cruz Verapaz','Santa Cruz Verapaz',-90.4286,15.3734,'P','PPLA2','GT.01',NULL,5843,'America/Guatemala',1,'2019-11-05 23:00:00','2019-11-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santa Cruz Naranjo','Santa Cruz Naranjo',-90.3697,14.3881,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santa Cruz del Quiché','Santa Cruz del Quiche',-91.1487,15.0309,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santa Cruz Balanyá','Santa Cruz Balanya',-90.9191,14.6852,'P','PPLA2','GT.03','GT.03.3589407',7825,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santa Clara La Laguna','Santa Clara La Laguna',-91.3036,14.7151,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santa Catarina Pinula','Santa Catarina Pinula',-90.4993,14.5705,'P','PPLA2','GT.07',NULL,67994,'America/Guatemala',1,'2019-06-04 23:00:00','2019-06-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santa Catarina Mita','Santa Catarina Mita',-89.7429,14.4513,'P','PPLA2','GT.11',NULL,10817,'America/Guatemala',1,'2020-02-06 23:00:00','2020-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santa Catarina Ixtahuacán','Santa Catarina Ixtahuacan',-91.3587,14.798,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santa Bárbara','Santa Barbara',-91.2269,14.4356,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Santa Ana','Santa Ana',-89.8333,16.8,'P','PPLA2','GT.12','GT.12.3589501',9523,'America/Guatemala',1,'2012-02-06 23:00:00','2012-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Sebastián','San Sebastian',-91.6487,14.5618,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Raimundo','San Raimundo',-90.5949,14.7646,'P','PPLA2','GT.07',NULL,8689,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Pedro Sacatepéquez','San Pedro Sacatepequez',-91.7617,14.9681,'P','PPLA2','GT.17',NULL,40021,'America/Guatemala',1,'2018-12-04 23:00:00','2018-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Pedro Sacatepéquez','San Pedro Sacatepequez',-90.6425,14.6861,'P','PPLA2','GT.07',NULL,14315,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Pedro La Laguna','San Pedro La Laguna',-91.272,14.693,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Pedro Carchá','San Pedro Carcha',-90.3111,15.4775,'P','PPLA2','GT.01',NULL,13332,'America/Guatemala',1,'2019-11-05 23:00:00','2019-11-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Pedro Ayampuc','San Pedro Ayampuc',-90.4532,14.7794,'P','PPLA2','GT.07',NULL,46803,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Pablo La Laguna','San Pablo La Laguna',-91.2724,14.7209,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Pablo Jocopilas','San Pablo Jocopilas',-91.4519,14.5888,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Pablo','San Pablo',-92.0042,14.9327,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Miguel Sigüilá','San Miguel Siguila',-91.6146,14.8955,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Miguel Dueñas','San Miguel Duenas',-90.7994,14.5224,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Miguel Chicaj','San Miguel Chicaj',-90.3944,15.0947,'P','PPLA2','GT.02',NULL,13747,'America/Guatemala',1,'2019-07-09 23:00:00','2019-07-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Mateo Ixtatán','San Mateo Ixtatan',-91.4781,15.8319,'P','PPLA2','GT.08',NULL,13213,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Mateo','San Mateo',-91.59,14.858,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Martín Jilotepeque','San Martin Jilotepeque',-90.7926,14.7801,'P','PPLA2','GT.03',NULL,9846,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Marcos','San Marcos',-91.7944,14.9639,'P','PPLA','GT.17','GT.17.3589799',25088,'America/Guatemala',1,'2012-12-04 23:00:00','2012-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Luis Jilotepeque','San Luis Jilotepeque',-89.7246,14.6472,'P','PPLA2','GT.10',NULL,10306,'America/Guatemala',1,'2020-02-06 23:00:00','2020-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Luis Ixcán','San Luis Ixcan',-91.095,15.7872,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Luis','San Luis',-89.4403,16.1989,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Lucas Tolimán','San Lucas Toliman',-91.1466,14.5947,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Lucas Sacatepéquez','San Lucas Sacatepequez',-90.6568,14.6108,'P','PPLA2','GT.16',NULL,17959,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Juan Sacatepéquez','San Juan Sacatepequez',-90.6442,14.7189,'P','PPLA2','GT.07',NULL,136886,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Juan Cotzal','San Juan Cotzal',-91.0348,15.4337,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Juan Chamelco','San Juan Chamelco',-90.3304,15.4243,'P','PPLA2','GT.01',NULL,11944,'America/Guatemala',1,'2019-11-05 23:00:00','2019-11-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San José Poaquil','San Jose Poaquil',-90.9125,14.8181,'P','PPLA2','GT.03',NULL,5987,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San José Pinula','San Jose Pinula',-90.4129,14.546,'P','PPLA2','GT.07',NULL,47247,'America/Guatemala',1,'2019-06-04 23:00:00','2019-06-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San José Acatempa','San Jose Acatempa',-90.1269,14.2653,'P','PPLA2','GT.11',NULL,6367,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Jerónimo','San Jeronimo',-90.2405,15.0603,'P','PPLA2','GT.02',NULL,8093,'America/Guatemala',1,'2015-04-23 23:00:00','2015-04-23 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Francisco Zapotitlán','San Francisco Zapotitlan',-91.5214,14.5894,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Francisco El Alto','San Francisco El Alto',-91.4431,14.9449,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Felipe','San Felipe',-91.595,14.623,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Cristóbal Verapaz','San Cristobal Verapaz',-90.5651,15.3963,'P','PPL','GT.01',NULL,19664,'America/Guatemala',1,'2014-07-23 23:00:00','2014-07-23 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Cristóbal Cucho','San Cristobal Cucho',-91.7812,14.9051,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Carlos Sija','San Carlos Sija',-91.5491,14.9844,'P','PPLA2','GT.13','GT.13.3590346',6831,'America/Guatemala',1,'2018-12-04 23:00:00','2018-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Bernardino','San Bernardino',-91.4581,14.5424,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Benito','San Benito',-89.919,16.9167,'P','PPLA2','GT.12','GT.12.3590386',30764,'America/Guatemala',1,'2015-03-27 23:00:00','2015-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Bartolomé Milpas Altas','San Bartolome Milpas Altas',-90.6781,14.6069,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Sanarate','Sanarate',-90.1988,14.7883,'P','PPLA2','GT.05',NULL,15843,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Antonio Suchitepéquez','San Antonio Suchitepequez',-91.4144,14.5394,'P','PPLA2','GT.20','GT.20.3590411',10951,'America/Guatemala',1,'2019-01-08 23:00:00','2019-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Antonio La Paz','San Antonio La Paz',-90.2849,14.7589,'P','PPLA2','GT.05',NULL,7781,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Antonio Huista','San Antonio Huista',-91.7716,15.6501,'P','PPLA2','GT.08',NULL,5669,'America/Guatemala',1,'2015-03-07 23:00:00','2015-03-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Antonio Aguas Calientes','San Antonio Aguas Calientes',-90.7805,14.5468,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Andrés Xecul','San Andres Xecul',-91.4831,14.9048,'P','PPLA2','GT.21','GT.21.3590519',12133,'America/Guatemala',1,'2018-12-04 23:00:00','2018-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Andrés Villa Seca','San Andres Villa Seca',-91.5854,14.578,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Andrés Itzapa','San Andres Itzapa',-90.8431,14.6222,'P','PPLA2','GT.03',NULL,18647,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Andrés','San Andres',-89.9167,16.9667,'P','PPLA2','GT.12','GT.12.3590534',7235,'America/Guatemala',1,'2012-02-06 23:00:00','2012-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','San Agustín Acasaguastlán','San Agustin Acasaguastlan',-89.9667,14.95,'P','PPLA2','GT.05',NULL,10335,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Samayac','Samayac',-91.4613,14.5808,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Salcajá','Salcaja',-91.457,14.8796,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Salamá','Salama',-90.3181,15.1028,'P','PPLA','GT.02',NULL,40000,'America/Guatemala',1,'2013-08-03 23:00:00','2013-08-03 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Sacapulas','Sacapulas',-91.0891,15.288,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Río Hondo','Rio Hondo',-89.5852,15.045,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Río Bravo','Rio Bravo',-91.3171,14.4004,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Retalhuleu','Retalhuleu',-91.6778,14.5361,'P','PPLA','GT.15','GT.15.3590856',36656,'America/Guatemala',1,'2018-04-22 23:00:00','2018-04-22 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Rabinal','Rabinal',-90.4926,15.0853,'P','PPLA2','GT.02',NULL,10737,'America/Guatemala',1,'2019-07-09 23:00:00','2019-07-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Quetzaltenango','Quetzaltenango',-91.5181,14.8347,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Purulhá','Purulha',-90.2357,15.2357,'P','PPLA2','GT.02',NULL,5370,'America/Guatemala',1,'2019-12-02 23:00:00','2019-12-02 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Puerto San José','Puerto San Jose',-90.8217,13.9274,'P','PPL','GT.06',NULL,18655,'America/Guatemala',1,'2013-06-21 23:00:00','2013-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Puerto Barrios','Puerto Barrios',-88.5944,15.7278,'P','PPLA','GT.09','GT.09.3591061',56605,'America/Guatemala',1,'2012-12-04 23:00:00','2012-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Tiquisate','Tiquisate',-91.3606,14.2836,'P','PPL','GT.06','GT.06.3588341',18189,'America/Guatemala',1,'2014-07-19 23:00:00','2014-07-19 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Poptún','Poptun',-89.4169,16.3311,'P','PPLA2','GT.12',NULL,17320,'America/Guatemala',1,'2017-09-01 23:00:00','2017-09-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Petapa','Petapa',-90.562,14.5019,'P','PPLA2','GT.07',NULL,141455,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Patzún','Patzun',-91.014,14.6819,'P','PPLA2','GT.03',NULL,18704,'America/Guatemala',1,'2019-01-08 23:00:00','2019-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Patzicía','Patzicia',-90.9266,14.6319,'P','PPLA2','GT.03','GT.03.3591521',16494,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Patulul','Patulul',-91.1605,14.4232,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Pastores','Pastores',-90.7547,14.5943,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Parramos','Parramos',-90.803,14.6089,'P','PPLA2','GT.03',NULL,9613,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Panzos','Panzos',-89.6415,15.3986,'P','PPLA2','GT.01',NULL,25569,'America/Guatemala',1,'2020-03-07 23:00:00','2020-03-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Panajachel','Panajachel',-91.1568,14.7418,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Palín','Palin',-90.6966,14.4036,'P','PPLA2','GT.06',NULL,31329,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Palencia','Palencia',-90.3572,14.6671,'P','PPLA2','GT.07',NULL,18574,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Pajapita','Pajapita',-92.0352,14.7215,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Ostuncalco','Ostuncalco',-91.6214,14.869,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Oratorio','Oratorio',-90.1758,14.2281,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Ocós','Ocos',-92.193,14.51,'P','PPLA2','GT.17',NULL,9463,'America/Guatemala',1,'2018-04-22 23:00:00','2018-04-22 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Nuevo San Carlos','Nuevo San Carlos',-91.6939,14.593,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Nuevo Progreso','Nuevo Progreso',-91.9195,14.7917,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Nueva Santa Rosa','Nueva Santa Rosa',-90.2761,14.3811,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Nueva Concepción','Nueva Concepcion',-91.3,14.2,'P','PPLA2','GT.06',NULL,11121,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Nebaj','Nebaj',-91.1468,15.4061,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Nahualá','Nahuala',-91.318,14.8429,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Moyuta','Moyuta',-90.0808,14.0386,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Morales','Morales',-88.8407,15.4722,'P','PPLA2','GT.09',NULL,18994,'America/Guatemala',1,'2019-10-09 23:00:00','2019-10-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Monjas','Monjas',-89.8725,14.5031,'P','PPLA2','GT.10',NULL,10351,'America/Guatemala',1,'2020-04-07 23:00:00','2020-04-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Momostenango','Momostenango',-91.4086,15.0444,'P','PPLA2','GT.21','GT.21.3592482',31739,'America/Guatemala',1,'2017-03-03 23:00:00','2017-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Mixco','Mixco',-90.6071,14.6308,'P','PPLA2','GT.07',NULL,473080,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Mazatenango','Mazatenango',-91.5033,14.5342,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Mataquescuintla','Mataquescuintla',-90.1842,14.5292,'P','PPLA2','GT.10',NULL,7539,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Masagua','Masagua',-90.8481,14.2031,'P','PPLA2','GT.06','GT.06.3592641',10045,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Malacatán','Malacatan',-92.0579,14.9113,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Magdalena Milpas Altas','Magdalena Milpas Altas',-90.6748,14.548,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Lívingston','Livingston',-88.7504,15.8283,'P','PPLA2','GT.09','GT.09.3593375',14350,'America/Guatemala',1,'2012-02-06 23:00:00','2012-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','La Libertad','La Libertad',-90.117,16.7885,'P','PPLA2','GT.12','GT.12.3594418',8646,'America/Guatemala',1,'2017-01-03 23:00:00','2017-01-03 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','La Libertad','La Libertad',-91.8694,15.5142,'P','PPLA2','GT.08',NULL,6439,'America/Guatemala',1,'2015-03-07 23:00:00','2015-03-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','La Gomera','La Gomera',-91.0538,14.0821,'P','PPLA2','GT.06',NULL,24001,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','La Esperanza','La Esperanza',-91.5614,14.8717,'P','PPLA2','GT.13','GT.13.3594666',16461,'America/Guatemala',1,'2018-12-04 23:00:00','2018-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','La Democracia','La Democracia',-90.9481,14.2292,'P','PPLA2','GT.06','GT.06.3594750',5479,'America/Guatemala',1,'2020-03-07 23:00:00','2020-03-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Jutiapa','Jutiapa',-89.8958,14.2917,'P','PPLA','GT.11',NULL,34332,'America/Guatemala',1,'2018-04-22 23:00:00','2018-04-22 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Joyabaj','Joyabaj',-90.8016,14.9931,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Jocotenango','Jocotenango',-90.738,14.5781,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Jalpatagua','Jalpatagua',-90.0091,14.1369,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Jalapa','Jalapa',-89.9889,14.6347,'P','PPLA','GT.10',NULL,45834,'America/Guatemala',1,'2012-12-04 23:00:00','2012-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Jacaltenango','Jacaltenango',-91.7118,15.6666,'P','PPLA2','GT.08',NULL,34084,'America/Guatemala',1,'2017-03-03 23:00:00','2017-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Ipala','Ipala',-89.6194,14.6199,'P','PPLA2','GT.04',NULL,5283,'America/Guatemala',1,'2020-02-06 23:00:00','2020-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Huitán','Huitan',-91.6394,15.0492,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Huehuetenango','Huehuetenango',-91.4724,15.3192,'P','PPLA','GT.08','GT.08.3595414',79426,'America/Guatemala',1,'2017-03-03 23:00:00','2017-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Guazacapán','Guazacapan',-90.4167,14.0742,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Gualán','Gualan',-89.3572,15.1195,'P','PPL','GT.22','GT.22.3587585',19354,'America/Guatemala',1,'2014-07-20 23:00:00','2014-07-20 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Fraijanes','Fraijanes',-90.4408,14.4653,'P','PPLA2','GT.07',NULL,28492,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Flores Costa Cuca','Flores Costa Cuca',-91.8634,14.6324,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Flores','Flores',-89.8994,16.9226,'P','PPLA','GT.12','GT.12.3595722',20464,'America/Guatemala',1,'2012-02-06 23:00:00','2012-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Estanzuela','Estanzuela',-89.5729,14.9978,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Esquipulas','Esquipulas',-89.3517,14.5657,'P','PPLA2','GT.04',NULL,20674,'America/Guatemala',1,'2019-07-09 23:00:00','2019-07-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Escuintla','Escuintla',-90.7858,14.3009,'P','PPLA','GT.06','GT.06.3595801',103165,'America/Guatemala',1,'2020-03-07 23:00:00','2020-03-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','El Tumbador','El Tumbador',-91.9342,14.8638,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','El Tejar','El Tejar',-90.7912,14.6468,'P','PPLA2','GT.03',NULL,15770,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','El Quetzal','El Quetzal',-91.8176,14.7687,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Guastatoya','Guastatoya',-90.0694,14.8542,'P','PPLA','GT.05',NULL,13467,'America/Guatemala',1,'2012-12-04 23:00:00','2012-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','El Progreso','El Progreso',-89.8485,14.356,'P','PPLA2','GT.11',NULL,7350,'America/Guatemala',1,'2020-04-07 23:00:00','2020-04-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','El Palmar','El Palmar',-91.578,14.6508,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','El Estor','El Estor',-89.3311,15.5322,'P','PPLA2','GT.09',NULL,15842,'America/Guatemala',1,'2019-10-09 23:00:00','2019-10-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','El Asintal','El Asintal',-91.7274,14.5963,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Dolores','Dolores',-89.417,16.5118,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Cuyotenango','Cuyotenango',-91.5718,14.5401,'P','PPLA2','GT.20','GT.20.3597749',10825,'America/Guatemala',1,'2019-01-08 23:00:00','2019-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Cunén','Cunen',-91.0278,15.3363,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Cuilapa','Cuilapa',-90.2989,14.2764,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Cubulco','Cubulco',-90.6287,15.1045,'P','PPLA2','GT.02',NULL,9753,'America/Guatemala',1,'2019-06-04 23:00:00','2019-06-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Concepción Chiquirichapa','Concepcion Chiquirichapa',-91.6236,14.8551,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Concepción Huista','Concepcion Huista',-91.6652,15.6238,'P','PPLA2','GT.08',NULL,8925,'America/Guatemala',1,'2018-04-22 23:00:00','2018-04-22 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Comitancillo','Comitancillo',-91.7497,15.0894,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Comalapa','Comalapa',-90.8876,14.7409,'P','PPLA2','GT.03','GT.03.3598032',20738,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Colomba','Colomba',-91.7317,14.7073,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Cobán','Coban',-90.3708,15.4708,'P','PPLA','GT.01',NULL,53375,'America/Guatemala',1,'2017-09-08 23:00:00','2017-09-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Coatepeque','Coatepeque',-91.8643,14.7041,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Ciudad Vieja','Ciudad Vieja',-90.7631,14.524,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Ciudad Tecún Umán','Ciudad Tecun Uman',-92.1404,14.6774,'P','PPLA2','GT.17',NULL,11432,'America/Guatemala',1,'2017-06-06 23:00:00','2017-06-06 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Melchor de Mencos','Melchor de Mencos',-89.1523,17.0661,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Guatemala City','Guatemala City',-90.5133,14.6407,'P','PPLC','GT.07',NULL,994938,'America/Guatemala',1,'2017-06-19 23:00:00','2017-06-19 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Chuarrancho','Chuarrancho',-90.5157,14.8179,'P','PPLA2','GT.07',NULL,7149,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Chisec','Chisec',-90.289,15.8131,'P','PPLA2','GT.01',NULL,17018,'America/Guatemala',1,'2019-12-02 23:00:00','2019-12-02 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Chiquimulilla','Chiquimulilla',-90.3855,14.0838,'P','PPL','GT.18','GT.18.3598459',12842,'America/Guatemala',1,'2014-06-30 23:00:00','2014-06-30 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Chiquimula','Chiquimula',-89.5458,14.8,'P','PPLA','GT.04','GT.04.3598463',41521,'America/Guatemala',1,'2018-04-22 23:00:00','2018-04-22 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Chinautla','Chinautla',-90.4998,14.7029,'P','PPLA2','GT.07',NULL,97172,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Chimaltenango','Chimaltenango',-90.8194,14.6611,'P','PPLA','GT.03','GT.03.3598570',82370,'America/Guatemala',1,'2012-12-04 23:00:00','2012-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Chichicastenango','Chichicastenango',-91.1112,14.9433,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Chicacao','Chicacao',-91.3264,14.5429,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Chiantla','Chiantla',-91.4581,15.3548,'P','PPLA2','GT.08','GT.08.3598691',8465,'America/Guatemala',1,'2017-03-03 23:00:00','2017-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Champerico','Champerico',-91.9121,14.2934,'P','PPLA2','GT.15','GT.15.3598786',7761,'America/Guatemala',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Chajul','Chajul',-91.0352,15.4852,'P','PPLA2','GT.14','GT.14.3598803',11657,'America/Guatemala',1,'2017-03-03 23:00:00','2017-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Chahal Guatemala','Chahal Guatemala',-89.6052,15.7912,'P','PPL','GT.01',NULL,7465,'America/Guatemala',1,'2014-07-01 23:00:00','2014-07-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Casillas','Casillas',-90.2433,14.4192,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Cantel','Cantel',-91.4554,14.8115,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Cabricán','Cabrican',-91.648,15.0749,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Barillas','Barillas',-91.3158,15.8036,'P','PPLA2','GT.08',NULL,14100,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Barberena','Barberena',-90.3616,14.3074,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Atescatempa','Atescatempa',-89.7418,14.1755,'P','PPLA2','GT.11',NULL,11543,'America/Guatemala',1,'2020-02-06 23:00:00','2020-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Asunción Mita','Asuncion Mita',-89.7109,14.3336,'P','PPLA2','GT.11',NULL,15608,'America/Guatemala',1,'2020-02-06 23:00:00','2020-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Antigua Guatemala','Antigua Guatemala',-90.7344,14.5611,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Amatitlán','Amatitlan',-90.6349,14.4774,'P','PPLA2','GT.07','GT.07.9253756',71836,'America/Guatemala',1,'2017-01-14 23:00:00','2017-01-14 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Alotenango','Alotenango',-90.8044,14.4859,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Almolonga','Almolonga',-91.4946,14.8159,'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`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Aguacatán','Aguacatan',-91.3114,15.3422,'P','PPLA2','GT.08',NULL,5572,'America/Guatemala',1,'2017-03-03 23:00:00','2017-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('GT','Acatenango','Acatenango',-90.9437,14.5545,'P','PPLA2','GT.03',NULL,7050,'America/Guatemala',1,'2019-05-07 23:00:00','2019-05-07 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
