--
-- Host: localhost    Database: laraclassified
-- ------------------------------------------------------


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

INSERT INTO `<<prefix>>subadmin1` VALUES (1099,'GT.22','GT','Zacapa','Zacapa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1100,'GT.21','GT','Totonicapán','Totonicapan',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1101,'GT.20','GT','Suchitepeque','Suchitepeque',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1102,'GT.19','GT','Sololá','Solola',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1103,'GT.18','GT','Santa Rosa','Santa Rosa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1104,'GT.17','GT','San Marcos','San Marcos',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1105,'GT.16','GT','Sacatepéquez','Sacatepequez',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1106,'GT.15','GT','Retalhuleu','Retalhuleu',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1107,'GT.14','GT','Quiché','Quiche',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1108,'GT.13','GT','Quetzaltenango','Quetzaltenango',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1109,'GT.12','GT','Petén','Peten',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1110,'GT.11','GT','Jutiapa','Jutiapa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1111,'GT.10','GT','Jalapa','Jalapa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1112,'GT.09','GT','Izabal','Izabal',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1113,'GT.08','GT','Huehuetenango','Huehuetenango',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1114,'GT.07','GT','Guatemala','Guatemala',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1115,'GT.06','GT','Escuintla','Escuintla',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1116,'GT.05','GT','El Progreso','El Progreso',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1117,'GT.04','GT','Chiquimula','Chiquimula',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1118,'GT.03','GT','Chimaltenango','Chimaltenango',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1119,'GT.02','GT','Baja Verapaz','Baja Verapaz',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1120,'GT.01','GT','Alta Verapaz','Alta Verapaz',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (13826,'GT.20.3587505','GT','GT.20','Municipio de Zunilito','Municipio de Zunilito',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13827,'GT.13.3587508','GT','GT.13','Municipio de Zunil','Municipio de Zunil',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13828,'GT.03.3587541','GT','GT.03','Municipio de Zaragoza','Municipio de Zaragoza',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13829,'GT.11.3587545','GT','GT.11','Municipio de Zapotitlán','Municipio de Zapotitlan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13830,'GT.22.3587585','GT','GT.22','Municipio de Zacapa','Municipio de Zacapa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13831,'GT.11.3587591','GT','GT.11','Municipio de Yupiltepeque','Municipio de Yupiltepeque',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13832,'GT.03.3587635','GT','GT.03','Municipio de Yepocapa','Municipio de Yepocapa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13833,'GT.07.3587901','GT','GT.07','Municipio de Villa Nueva','Municipio de Villa Nueva',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13834,'GT.07.3587922','GT','GT.07','Municipio de Villa Canales','Municipio de Villa Canales',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13835,'GT.22.3588039','GT','GT.22','Municipio de Usumatlán','Municipio de Usumatlan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13836,'GT.14.3588042','GT','GT.14','Municipio de Uspantán','Municipio de Uspantan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13837,'GT.01.3588205','GT','GT.01','Municipio de Tucurú','Municipio de Tucuru',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13838,'GT.21.3588255','GT','GT.21','Municipio de Totonicapán','Municipio de Totonicapan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13839,'GT.08.3588307','GT','GT.08','Municipio de Todos Santos Cuchumatán','Municipio de Todos Santos Cuchumatan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13840,'GT.06.3588341','GT','GT.06','Município de Tiquisate','Municipio de Tiquisate',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13841,'GT.17.3588459','GT','GT.17','Municipio de Tejutla','Municipio de Tejutla',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13842,'GT.22.3588468','GT','GT.22','Municipio de Teculután','Municipio de Teculutan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13843,'GT.08.3588473','GT','GT.08','Municipio de Tectitán','Municipio de Tectitan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13844,'GT.03.3588475','GT','GT.03','Municipio de Tecpán Guatemala','Municipio de Tecpan Guatemala',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13845,'GT.18.3588490','GT','GT.18','Municipio de Taxisco','Municipio de Taxisco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13846,'GT.01.3588553','GT','GT.01','Municipio de Tamahú','Municipio de Tamahu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13847,'GT.17.3588587','GT','GT.17','Municipio de Tajumulco','Municipio de Tajumulco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13848,'GT.01.3588602','GT','GT.01','Municipio de Tactic','Municipio de Tactic',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13849,'GT.17.3588609','GT','GT.17','Municipio de Tacaná','Municipio de Tacana',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13850,'GT.16.3588652','GT','GT.16','Municipio de Sumpango','Municipio de Sumpango',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13851,'GT.08.3588693','GT','GT.08','Municipio de Soloma','Municipio de Soloma',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13852,'GT.19.3588695','GT','GT.19','Municipio de Sololá','Municipio de Solola',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13853,'GT.06.3588719','GT','GT.06','Municipio de Siquinalá','Municipio de Siquinala',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13854,'GT.17.3588725','GT','GT.17','Municipio de Sipacapa','Municipio de Sipacapa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13855,'GT.17.3588759','GT','GT.17','Municipio de Sibinal','Municipio de Sibinal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13856,'GT.13.3588761','GT','GT.13','Municipio de Sibilia','Municipio de Sibilia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13857,'GT.01.3588857','GT','GT.01','Municipio de Senahú','Municipio de Senahu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13858,'GT.12.3588983','GT','GT.12','Municipio de Sayaxché','Municipio de Sayaxche',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13859,'GT.06.3589034','GT','GT.06','Municipio de San Vicente Pacaya','Municipio de San Vicente Pacaya',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13860,'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` VALUES (13861,'GT.16.3589071','GT','GT.16','Municipio de Santo Domingo Xenacoj','Municipio de Santo Domingo Xenacoj',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13862,'GT.20.3589073','GT','GT.20','Municipio de Santo Domingo Suchitepéquez','Municipio de Santo Domingo Suchitepequez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13863,'GT.16.3589100','GT','GT.16','Municipio de Santiago Sacatepéquez','Municipio de Santiago Sacatepequez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13864,'GT.08.3589102','GT','GT.08','Municipio de Santiago Chimaltenango','Municipio de Santiago Chimaltenango',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13865,'GT.19.3589104','GT','GT.19','Municipio de Santiago Atitlán','Municipio de Santiago Atitlan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13866,'GT.18.3589158','GT','GT.18','Municipio de Santa Rosa de Lima','Municipio de Santa Rosa de Lima',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13867,'GT.19.3589246','GT','GT.19','Municipio de Santa María Visitación','Municipio de Santa Maria Visitacion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13868,'GT.18.3589248','GT','GT.18','Municipio de Santa María Ixhuatán','Municipio de Santa Maria Ixhuatan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13869,'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` VALUES (13870,'GT.21.3589255','GT','GT.21','Municipio de Santa María Chiquimula','Municipio de Santa Maria Chiquimula',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13871,'GT.19.3589281','GT','GT.19','Municipio de Santa Lucía Utatlán','Municipio de Santa Lucia Utatlan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13872,'GT.16.3589284','GT','GT.16','Municipio de Santa Lucía Milpas Altas','Municipio de Santa Lucia Milpas Altas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13873,'GT.21.3589286','GT','GT.21','Municipio de Santa Lucía La Reforma','Municipio de Santa Lucia La Reforma',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13874,'GT.06.3589288','GT','GT.06','Municipio de Santa Lucía Cotzumalguapa','Municipio de Santa Lucia Cotzumalguapa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13875,'GT.08.3589354','GT','GT.08','Municipio de Santa Eulalia','Municipio de Santa Eulalia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13876,'GT.01.3589394','GT','GT.01','Municipio de Santa Cruz Verapaz','Municipio de Santa Cruz Verapaz',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13877,'GT.18.3589397','GT','GT.18','Municipio de Santa Cruz Naranjo','Municipio de Santa Cruz Naranjo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13878,'GT.15.3589399','GT','GT.15','Municipio de Santa Cruz Muluá','Municipio de Santa Cruz Mulua',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13879,'GT.19.3589401','GT','GT.19','Municipio de Santa Cruz La Laguna','Municipio de Santa Cruz La Laguna',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13880,'GT.14.3589403','GT','GT.14','Municipio de Santa Cruz del Quiché','Municipio de Santa Cruz del Quiche',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13881,'GT.03.3589407','GT','GT.03','Municipio de Santa Cruz Balanyá','Municipio de Santa Cruz Balanya',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13882,'GT.19.3589432','GT','GT.19','Municipio de Santa Clara La Laguna','Municipio de Santa Clara La Laguna',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13883,'GT.07.3589451','GT','GT.07','Municipio de Santa Catarina Pinula','Municipio de Santa Catarina Pinula',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13884,'GT.19.3589453','GT','GT.19','Municipio de Santa Catarina Palopó','Municipio de Santa Catarina Palopo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13885,'GT.11.3589455','GT','GT.11','Municipio de Santa Catarina Mita','Municipio de Santa Catarina Mita',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13886,'GT.19.3589457','GT','GT.19','Municipio de Santa Catarina Ixtahuacán','Municipio de Santa Catarina Ixtahuacan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13887,'GT.16.3589459','GT','GT.16','Municipio de Santa Catarina Barahona','Municipio de Santa Catarina Barahona',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13888,'GT.08.3589464','GT','GT.08','Municipio de Santa Bárbara','Municipio de Santa Barbara',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13889,'GT.20.3589465','GT','GT.20','Municipio de Santa Bárbara','Municipio de Santa Barbara',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13890,'GT.03.3589479','GT','GT.03','Municipio de Santa Apolonia','Municipio de Santa Apolonia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13891,'GT.08.3589497','GT','GT.08','Municipio de Santa Ana Huista','Municipio de Santa Ana Huista',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13892,'GT.12.3589501','GT','GT.12','Municipio de Santa Ana','Municipio de Santa Ana',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13893,'GT.08.3589540','GT','GT.08','Municipio de San Sebastián Huehuetenango','Municipio de San Sebastian Huehuetenango',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13894,'GT.08.3589542','GT','GT.08','Municipio de San Sebastián Coatán','Municipio de San Sebastian Coatan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13895,'GT.15.3589545','GT','GT.15','Municipio de San Sebastián','Municipio de San Sebastian',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13896,'GT.05.3589553','GT','GT.05','Municipio de Sansare','Municipio de Sansare',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13897,'GT.07.3589568','GT','GT.07','Municipio de San Raimundo','Municipio de San Raimundo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13898,'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` VALUES (13899,'GT.08.3589578','GT','GT.08','Municipio de San Rafael Petzal','Municipio de San Rafael Petzal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13900,'GT.18.3589588','GT','GT.18','Municipio de San Rafael Las Flores','Municipio de San Rafael Las Flores',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13901,'GT.08.3589594','GT','GT.08','Municipio de San Rafael La Independencia','Municipio de San Rafael La Independencia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13902,'GT.17.3589624','GT','GT.17','Municipio de San Pedro Sacatepéquez','Municipio de San Pedro Sacatepequez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13903,'GT.07.3589625','GT','GT.07','Municipio de San Pedro Sacatepéquez','Municipio de San Pedro Sacatepequez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13904,'GT.10.3589628','GT','GT.10','Municipio de San Pedro Pinula','Municipio de San Pedro Pinula',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13905,'GT.08.3589631','GT','GT.08','Municipio de San Pedro Nectá','Municipio de San Pedro Necta',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13906,'GT.19.3589636','GT','GT.19','Municipio de San Pedro La Laguna','Municipio de San Pedro La Laguna',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13907,'GT.14.3589639','GT','GT.14','Municipio de San Pedro Jocopilas','Municipio de San Pedro Jocopilas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13908,'GT.01.3589642','GT','GT.01','Municipio de San Pedro Carchá','Municipio de San Pedro Carcha',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13909,'GT.07.3589645','GT','GT.07','Municipio de San Pedro Ayampuc','Municipio de San Pedro Ayampuc',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13910,'GT.19.3589668','GT','GT.19','Municipio de San Pablo La Laguna','Municipio de San Pablo La Laguna',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13911,'GT.20.3589670','GT','GT.20','Municipio de San Pablo Jocopilas','Municipio de San Pablo Jocopilas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13912,'GT.17.3589673','GT','GT.17','Municipio de San Pablo','Municipio de San Pablo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13913,'GT.13.3589705','GT','GT.13','Municipio de San Miguel Sigüilá','Municipio de San Miguel Siguila',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13914,'GT.20.3589708','GT','GT.20','Municipio de San Miguel Panán','Municipio de San Miguel Panan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13915,'GT.17.3589719','GT','GT.17','Municipio de San Miguel Ixtahuacán','Municipio de San Miguel Ixtahuacan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13916,'GT.16.3589726','GT','GT.16','Municipio de San Miguel Dueñas','Municipio de San Miguel Duenas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13917,'GT.02.3589729','GT','GT.02','Municipio de San Miguel Chicaj','Municipio de San Miguel Chicaj',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13918,'GT.08.3589733','GT','GT.08','Municipio de San Miguel Acatán','Municipio de San Miguel Acatan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13919,'GT.08.3589769','GT','GT.08','Municipio de San Mateo Ixtatán','Municipio de San Mateo Ixtatan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13920,'GT.13.3589772','GT','GT.13','Municipio de San Mateo','Municipio de San Mateo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13921,'GT.15.3589775','GT','GT.15','Municipio de San Martín Zapotitlán','Municipio de San Martin Zapotitlan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13922,'GT.13.3589777','GT','GT.13','Municipio de San Martín Sacatepéquez','Municipio de San Martin Sacatepequez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13923,'GT.03.3589779','GT','GT.03','Municipio de San Martín Jilotepeque','Municipio de San Martin Jilotepeque',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13924,'GT.19.3589794','GT','GT.19','Municipio de San Marcos La Laguna','Municipio de San Marcos La Laguna',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13925,'GT.17.3589799','GT','GT.17','Municipio de San Marcos','Municipio de San Marcos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13926,'GT.10.3589811','GT','GT.10','Municipio de San Manuel Chaparrón','Municipio de San Manuel Chaparron',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13927,'GT.10.3589821','GT','GT.10','Municipio de San Luis Jilotepeque','Municipio de San Luis Jilotepeque',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13928,'GT.12.3589835','GT','GT.12','Municipio de San Luis','Municipio de San Luis',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13929,'GT.19.3589849','GT','GT.19','Municipio de San Lucas Tolimán','Municipio de San Lucas Toliman',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13930,'GT.16.3589851','GT','GT.16','Municipio de San Lucas Sacatepéquez','Municipio de San Lucas Sacatepequez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13931,'GT.17.3589860','GT','GT.17','Municipio de San Lorenzo','Municipio de San Lorenzo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13932,'GT.20.3589861','GT','GT.20','Municipio de San Lorenzo','Municipio de San Lorenzo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13933,'GT.18.3589879','GT','GT.18','Municipio de San Juan Tecuaco','Municipio de San Juan Tecuaco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13934,'GT.07.3589884','GT','GT.07','Municipio de San Juan Sacatepéquez','Municipio de San Juan Sacatepequez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13935,'GT.19.3589895','GT','GT.19','Municipio de San Juan La Laguna','Municipio de San Juan La Laguna',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13936,'GT.08.3589899','GT','GT.08','Municipio de San Juan Ixcoy','Municipio de San Juan Ixcoy',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13937,'GT.04.3589902','GT','GT.04','Municipio de San Juan Ermita','Municipio de San Juan Ermita',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13938,'GT.14.3589912','GT','GT.14','Municipio de San Juan Cotzal','Municipio de San Juan Cotzal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13939,'GT.01.3589916','GT','GT.01','Municipio de San Juan Chamelco','Municipio de San Juan Chamelco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13940,'GT.20.3589920','GT','GT.20','Municipio de San Juan Bautista','Municipio de San Juan Bautista',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13941,'GT.08.3589924','GT','GT.08','Municipio de San Juan Atitán','Municipio de San Juan Atitan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13942,'GT.03.3589974','GT','GT.03','Municipio de San José Poaquil','Municipio de San Jose Poaquil',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13943,'GT.07.3589976','GT','GT.07','Municipio de San José Pinula','Municipio de San Jose Pinula',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13944,'GT.17.3589984','GT','GT.17','Municipio de San José Ojetenam','Municipio de San Jose Ojetenam',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13945,'GT.04.3590016','GT','GT.04','Municipio de San José La Arada','Municipio de San Jose La Arada',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13946,'GT.20.3590028','GT','GT.20','Municipio de San José El Ídolo','Municipio de San Jose El Idolo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13947,'GT.07.3590033','GT','GT.07','Municipio de San José del Golfo','Municipio de San Jose del Golfo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13948,'GT.19.3590040','GT','GT.19','Municipio de San José Chacayá','Municipio de San Jose Chacaya',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13949,'GT.11.3590052','GT','GT.11','Municipio de San José Acatempa','Municipio de San Jose Acatempa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13950,'GT.12.3590058','GT','GT.12','Municipio de San José','Municipio de San Jose',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13951,'GT.06.3590059','GT','GT.06','Municipio de San José','Municipio de San Jose',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13952,'GT.02.3590106','GT','GT.02','Municipio de San Jerónimo','Municipio de San Jeronimo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13953,'GT.04.3590124','GT','GT.04','Municipio de San Jacinto','Municipio de San Jacinto',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13954,'GT.08.3590187','GT','GT.08','Municipio de San Gaspar Ixchil','Municipio de San Gaspar Ixchil',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13955,'GT.20.3590192','GT','GT.20','Municipio de San Gabriel','Municipio de San Gabriel',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13956,'GT.20.3590196','GT','GT.20','Municipio de San Francisco Zapotitlán','Municipio de San Francisco Zapotitlan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13957,'GT.13.3590210','GT','GT.13','Municipio de San Francisco La Unión','Municipio de San Francisco La Union',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13958,'GT.21.3590218','GT','GT.21','Municipio de San Francisco El Alto','Municipio de San Francisco El Alto',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13959,'GT.12.3590233','GT','GT.12','Municipio de San Francisco','Municipio de San Francisco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13960,'GT.15.3590281','GT','GT.15','Municipio de San Felipe','Municipio de San Felipe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13961,'GT.22.3590305','GT','GT.22','Municipio de San Diego','Municipio de San Diego',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13962,'GT.01.3590315','GT','GT.01','Municipio de San Cristóbal Verapaz','Municipio de San Cristobal Verapaz',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13963,'GT.21.3590317','GT','GT.21','Municipio de San Cristóbal Totonicapán','Municipio de San Cristobal Totonicapan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13964,'GT.17.3590322','GT','GT.17','Municipio de San Cristóbal Cucho','Municipio de San Cristobal Cucho',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13965,'GT.05.3590324','GT','GT.05','Municipio de San Cristóbal Acasaguastlán','Municipio de San Cristobal Acasaguastlan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13966,'GT.13.3590346','GT','GT.13','Municipio de San Carlos Sija','Municipio de San Carlos Sija',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13967,'GT.10.3590354','GT','GT.10','Municipio de San Carlos Alzatate','Municipio de San Carlos Alzatate',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13968,'GT.20.3590382','GT','GT.20','Municipio de San Bernardino','Municipio de San Bernardino',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13969,'GT.12.3590386','GT','GT.12','Municipio de San Benito','Municipio de San Benito',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13970,'GT.16.3590392','GT','GT.16','Municipio de San Bartolomé Milpas Altas','Municipio de San Bartolome Milpas Altas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13971,'GT.14.3590394','GT','GT.14','Municipio de San Bartolomé Jocotenango','Municipio de San Bartolome Jocotenango',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13972,'GT.21.3590397','GT','GT.21','Municipio de San Bartolo','Municipio de San Bartolo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13973,'GT.05.3590405','GT','GT.05','Municipio de Sanarate','Municipio de Sanarate',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13974,'GT.20.3590411','GT','GT.20','Municipio de San Antonio Suchitepéquez','Municipio de San Antonio Suchitepequez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13975,'GT.17.3590418','GT','GT.17','Municipio de San Antonio Sacatepéquez','Municipio de San Antonio Sacatepequez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13976,'GT.19.3590423','GT','GT.19','Municipio de San Antonio Palopó','Municipio de San Antonio Palopo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13977,'GT.05.3590447','GT','GT.05','Municipio de San Antonio La Paz','Municipio de San Antonio La Paz',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13978,'GT.14.3590455','GT','GT.14','Municipio de San Antonio Ilotenango','Municipio de San Antonio Ilotenango',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13979,'GT.08.3590457','GT','GT.08','Municipio de San Antonio Huista','Municipio de San Antonio Huista',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13980,'GT.16.3590474','GT','GT.16','Municipio de San Antonio Aguas Calientes','Municipio de San Antonio Aguas Calientes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13981,'GT.21.3590519','GT','GT.21','Municipio de San Andrés Xecul','Municipio de San Andres Xecul',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13982,'GT.15.3590521','GT','GT.15','Municipio de San Andrés Villa Seca','Municipio de San Andres Villa Seca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13983,'GT.19.3590523','GT','GT.19','Municipio de San Andrés Semetabaj','Municipio de San Andres Semetabaj',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13984,'GT.14.3590525','GT','GT.14','Municipio de San Andrés Sajcabajá','Municipio de San Andres Sajcabaja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13985,'GT.03.3590528','GT','GT.03','Municipio de San Andrés Itzapa','Municipio de San Andres Itzapa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13986,'GT.12.3590534','GT','GT.12','Municipio de San Andrés','Municipio de San Andres',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13987,'GT.05.3590546','GT','GT.05','Municipio de San Agustín Acasaguastlán','Municipio de San Agustin Acasaguastlan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13988,'GT.20.3590566','GT','GT.20','Municipio de Samayac','Municipio de Samayac',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13989,'GT.13.3590604','GT','GT.13','Municipio de Salcajá','Municipio de Salcaja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13990,'GT.02.3590615','GT','GT.02','Municipio de Salamá','Municipio de Salama',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13991,'GT.14.3590689','GT','GT.14','Municipio de Sacapulas','Municipio de Sacapulas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13992,'GT.22.3590786','GT','GT.22','Municipio de Río Hondo','Municipio de Rio Hondo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13993,'GT.20.3590802','GT','GT.20','Municipio de Río Bravo','Municipio de Rio Bravo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13994,'GT.17.3590807','GT','GT.17','Municipio de Río Blanco','Municipio de Rio Blanco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13995,'GT.15.3590856','GT','GT.15','Municipio de Retalhuleu','Municipio de Retalhuleu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13996,'GT.02.3590923','GT','GT.02','Municipio de Rabinal','Municipio de Rabinal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13997,'GT.04.3590972','GT','GT.04','Municipio de Quezaltepeque','Municipio de Quezaltepeque',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13998,'GT.13.3590977','GT','GT.13','Municipio de Quetzaltenango','Municipio de Quetzaltenango',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (13999,'GT.11.3590986','GT','GT.11','Municipio de Quesada','Municipio de Quesada',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14000,'GT.02.3591027','GT','GT.02','Municipio de Purulhá','Municipio de Purulha',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14001,'GT.09.3591061','GT','GT.09','Municipio de Puerto Barrios','Municipio de Puerto Barrios',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14002,'GT.18.3591091','GT','GT.18','Municipio de Pueblo Nuevo Viñas','Municipio de Pueblo Nuevo Vinas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14003,'GT.20.3591096','GT','GT.20','Municipio de Pueblo Nuevo','Municipio de Pueblo Nuevo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14004,'GT.12.3591180','GT','GT.12','Municipio de Poptún','Municipio de Poptun',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14005,'GT.03.3591209','GT','GT.03','Municipio de Pochuta','Municipio de Pochuta',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14006,'GT.07.3591414','GT','GT.07','Municipio de Petapa','Municipio de Petapa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14007,'GT.03.3591511','GT','GT.03','Municipio de Patzún','Municipio de Patzun',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14008,'GT.14.3591516','GT','GT.14','Municipio de Patzité','Municipio de Patzite',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14009,'GT.03.3591521','GT','GT.03','Municipio de Patzicía','Municipio de Patzicia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14010,'GT.20.3591540','GT','GT.20','Municipio de Patulul','Municipio de Patulul',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14011,'GT.16.3591573','GT','GT.16','Municipio de Pastores','Municipio de Pastores',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14012,'GT.11.3591617','GT','GT.11','Municipio de Pasaco','Municipio de Pasaco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14013,'GT.03.3591628','GT','GT.03','Municipio de Parramos','Municipio de Parramos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14014,'GT.01.3591675','GT','GT.01','Municipio de Panzós','Municipio de Panzos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14015,'GT.19.3591748','GT','GT.19','Municipio de Panajachel','Municipio de Panajachel',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14016,'GT.06.3591830','GT','GT.06','Municipio de Palín','Municipio de Palin',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14017,'GT.13.3591840','GT','GT.13','Municipio de Palestina de los Altos','Municipio de Palestina de los Altos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14018,'GT.07.3591849','GT','GT.07','Municipio de Palencia','Municipio de Palencia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14019,'GT.17.3591884','GT','GT.17','Municipio de Pajapita','Municipio de Pajapita',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14020,'GT.13.3591996','GT','GT.13','Municipio de Ostuncalco','Municipio de Ostuncalco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14021,'GT.18.3592017','GT','GT.18','Municipio de Oratorio','Municipio de Oratorio',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14022,'GT.04.3592034','GT','GT.04','Municipio de Olopa','Municipio de Olopa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14023,'GT.13.3592040','GT','GT.13','Municipio de Olintepeque','Municipio de Olintepeque',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14024,'GT.17.3592084','GT','GT.17','Municipio de Ocós','Municipio de Ocos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14025,'GT.15.3592104','GT','GT.15','Municipio de Nuevo San Carlos','Municipio de Nuevo San Carlos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14026,'GT.17.3592107','GT','GT.17','Municipio de Nuevo Progreso','Municipio de Nuevo Progreso',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14027,'GT.18.3592125','GT','GT.18','Municipio de Nueva Santa Rosa','Municipio de Nueva Santa Rosa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14028,'GT.06.3592142','GT','GT.06','Municipio de Nueva Concepción','Municipio de Nueva Concepcion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14029,'GT.08.3592216','GT','GT.08','Municipio de Nentón','Municipio de Nenton',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14030,'GT.14.3592236','GT','GT.14','Municipio de Nebaj','Municipio de Nebaj',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14031,'GT.19.3592285','GT','GT.19','Municipio de Nahualá','Municipio de Nahuala',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14032,'GT.11.3592320','GT','GT.11','Municipio de Moyuta','Municipio de Moyuta',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14033,'GT.05.3592348','GT','GT.05','Municipio de Morazán','Municipio de Morazan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14034,'GT.09.3592361','GT','GT.09','Municipio de Morales','Municipio de Morales',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14035,'GT.10.3592476','GT','GT.10','Municipio de Monjas','Municipio de Monjas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14036,'GT.21.3592482','GT','GT.21','Municipio de Momostenango','Municipio de Momostenango',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14037,'GT.07.3592517','GT','GT.07','Municipio de Mixco','Municipio de Mixco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14038,'GT.12.3592595','GT','GT.12','Municipio de Melchor de Mencos','Municipio de Melchor de Mencos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14039,'GT.20.3592608','GT','GT.20','Municipio de Mazatenango','Municipio de Mazatenango',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14040,'GT.10.3592634','GT','GT.10','Municipio de Mataquescuintla','Municipio de Mataquescuintla',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14041,'GT.06.3592641','GT','GT.06','Municipio de Masagua','Municipio de Masagua',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14042,'GT.08.3592750','GT','GT.08','Municipio de Malacatancito','Municipio de Malacatancito',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14043,'GT.17.3592752','GT','GT.17','Municipio de Malacatán','Municipio de Malacatan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14044,'GT.16.3592769','GT','GT.16','Municipio de Magdalena Milpas Altas','Municipio de Magdalena Milpas Altas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14045,'GT.09.3593233','GT','GT.09','Municipio de Los Amates','Municipio de Los Amates',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14046,'GT.09.3593375','GT','GT.09','Municipio de Lívingston','Municipio de Livingston',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14047,'GT.22.3593488','GT','GT.22','Municipio de La Unión','Municipio de La Union',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14048,'GT.17.3594137','GT','GT.17','Municipio de La Reforma','Municipio de La Reforma',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14049,'GT.01.3594314','GT','GT.01','Municipio de Lanquín','Municipio de Lanquin',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14050,'GT.12.3594418','GT','GT.12','Municipio de La Libertad','Municipio de La Libertad',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14051,'GT.08.3594419','GT','GT.08','Municipio de La Libertad','Municipio de La Libertad',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14052,'GT.06.3594574','GT','GT.06','Municipio de La Gomera','Municipio de La Gomera',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14053,'GT.13.3594666','GT','GT.13','Municipio de La Esperanza','Municipio de La Esperanza',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14054,'GT.08.3594749','GT','GT.08','Municipio de La Democracia','Municipio de La Democracia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14055,'GT.06.3594750','GT','GT.06','Municipio de La Democracia','Municipio de La Democracia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14056,'GT.11.3595065','GT','GT.11','Municipio de Jutiapa','Municipio de Jutiapa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14057,'GT.14.3595147','GT','GT.14','Municipio de Joyabaj','Municipio de Joyabaj',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14058,'GT.16.3595170','GT','GT.16','Municipio de Jocotenango','Municipio de Jocotenango',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14059,'GT.04.3595180','GT','GT.04','Municipio de Jocotán','Municipio de Jocotan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14060,'GT.11.3595222','GT','GT.11','Municipio de Jerez','Municipio de Jerez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14061,'GT.11.3595231','GT','GT.11','Municipio de Jalpatagua','Municipio de Jalpatagua',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14062,'GT.10.3595235','GT','GT.10','Municipio de Jalapa','Municipio de Jalapa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14063,'GT.08.3595247','GT','GT.08','Municipio de Jacaltenango','Municipio de Jacaltenango',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14064,'GT.06.3595254','GT','GT.06','Municipio de Iztapa','Municipio de Iztapa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14065,'GT.08.3595281','GT','GT.08','Municipio de San Ildefonso Ixtahuacan','Municipio de San Ildefonso Ixtahuacan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14066,'GT.17.3595328','GT','GT.17','Municipio de Ixchiguán','Municipio de Ixchiguan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14067,'GT.04.3595363','GT','GT.04','Municipio de Ipala','Municipio de Ipala',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14068,'GT.22.3595402','GT','GT.22','Municipio de Huité','Municipio de Huite',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14069,'GT.13.3595404','GT','GT.13','Municipio de Huitán','Municipio de Huitan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14070,'GT.08.3595414','GT','GT.08','Municipio de Huehuetenango','Municipio de Huehuetenango',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14071,'GT.18.3595502','GT','GT.18','Municipio de Guazacapán','Municipio de Guazacapan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14072,'GT.07.3595529','GT','GT.07','Municipio de Guatemala','Municipio de Guatemala',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14073,'GT.06.3595553','GT','GT.06','Municipio de Guanagazapa','Municipio de Guanagazapa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14074,'GT.22.3595559','GT','GT.22','Municipio de Gualán','Municipio de Gualan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14075,'GT.02.3595630','GT','GT.02','Municipio de Granados','Municipio de Granados',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14076,'GT.13.3595670','GT','GT.13','Municipio de Génova Costa Cuca','Municipio de Genova Costa Cuca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14077,'GT.07.3595713','GT','GT.07','Municipio de Fraijanes','Municipio de Fraijanes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14078,'GT.13.3595720','GT','GT.13','Municipio de Flores Costa Cuca','Municipio de Flores Costa Cuca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14079,'GT.12.3595722','GT','GT.12','Municipio de Flores','Municipio de Flores',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14080,'GT.22.3595755','GT','GT.22','Municipio de Estanzuela','Municipio de Estanzuela',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14081,'GT.17.3595777','GT','GT.17','Municipio de Esquipulas Palo Gordo','Municipio de Esquipulas Palo Gordo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14082,'GT.04.3595780','GT','GT.04','Municipio de Esquipulas','Municipio de Esquipulas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14083,'GT.06.3595801','GT','GT.06','Municipio de Escuintla','Municipio de Escuintla',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14084,'GT.17.3595928','GT','GT.17','Municipio de El Tumbador','Municipio de El Tumbador',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14085,'GT.03.3596040','GT','GT.03','Municipio de El Tejar','Municipio de El Tejar',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14086,'GT.17.3596243','GT','GT.17','Municipio de San Jose El Rodeo','Municipio de San Jose El Rodeo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14087,'GT.17.3596386','GT','GT.17','Municipio de El Quetzal','Municipio de El Quetzal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14088,'GT.05.3596410','GT','GT.05','Municipio de El Progreso','Municipio de El Progreso',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14089,'GT.11.3596411','GT','GT.11','Municipio de El Progreso','Municipio de El Progreso',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14090,'GT.13.3596634','GT','GT.13','Municipio de El Palmar','Municipio de El Palmar',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14091,'GT.05.3596938','GT','GT.05','Municipio de El Jícaro','Municipio de El Jicaro',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14092,'GT.09.3597077','GT','GT.09','Municipio de El Estor','Municipio de El Estor',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14093,'GT.02.3597300','GT','GT.02','Municipio de El Chol','Municipio de El Chol',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14094,'GT.15.3597586','GT','GT.15','Municipio de El Asintal','Municipio de El Asintal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14095,'GT.11.3597674','GT','GT.11','Municipio de El Adelanto','Municipio de El Adelanto',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14096,'GT.12.3597716','GT','GT.12','Municipio de Dolores','Municipio de Dolores',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14097,'GT.20.3597749','GT','GT.20','Municipio de Cuyotenango','Municipio de Cuyotenango',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14098,'GT.14.3597771','GT','GT.14','Municipio de Cunén','Municipio de Cunen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14099,'GT.08.3597800','GT','GT.08','Municipio de Cuilco','Municipio de Cuilco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14100,'GT.18.3597803','GT','GT.18','Municipio de Cuilapa','Municipio de Cuilapa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14101,'GT.02.3597836','GT','GT.02','Municipio de Cubulco','Municipio de Cubulco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14102,'GT.11.3597965','GT','GT.11','Municipio de Conguaco','Municipio de Conguaco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14103,'GT.17.3597975','GT','GT.17','Municipio de Concepción Tutuapa','Municipio de Concepcion Tutuapa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14104,'GT.04.3597984','GT','GT.04','Municipio de Concepción Las Minas','Municipio de Concepcion Las Minas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14105,'GT.13.3597992','GT','GT.13','Municipio de Concepción Chiquirichapa','Municipio de Concepcion Chiquirichapa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14106,'GT.08.3598001','GT','GT.08','Municipio de Concepción Huista','Municipio de Concepcion Huista',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14107,'GT.19.3598002','GT','GT.19','Municipio de Concepción','Municipio de Concepcion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14108,'GT.17.3598023','GT','GT.17','Municipio de Comitancillo','Municipio de Comitancillo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14109,'GT.11.3598030','GT','GT.11','Municipio de Comapa','Municipio de Comapa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14110,'GT.03.3598032','GT','GT.03','Municipio de San Juan Comalapa','Municipio de San Juan Comalapa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14111,'GT.08.3598040','GT','GT.08','Municipio de Colotenango','Municipio de Colotenango',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14112,'GT.13.3598072','GT','GT.13','Municipio de Colomba Costa Cuca','Municipio de Colomba Costa Cuca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14113,'GT.01.3598116','GT','GT.01','Municipio de Cobán','Municipio de Coban',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14114,'GT.13.3598121','GT','GT.13','Municipio de Coatepeque','Municipio de Coatepeque',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14115,'GT.16.3598127','GT','GT.16','Municipio de Ciudad Vieja','Municipio de Ciudad Vieja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14116,'GT.07.3598276','GT','GT.07','Municipio de Chuarrancho','Municipio de Chuarrancho',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14117,'GT.01.3598414','GT','GT.01','Municipio de Chisec','Municipio de Chisec',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14118,'GT.18.3598459','GT','GT.18','Municipio de Chiquimulilla','Municipio de Chiquimulilla',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14119,'GT.04.3598463','GT','GT.04','Municipio de Chiquimula','Municipio de Chiquimula',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14120,'GT.14.3598512','GT','GT.14','Municipio de Chinique','Municipio de Chinique',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14121,'GT.07.3598528','GT','GT.07','Municipio de Chinautla','Municipio de Chinautla',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14122,'GT.03.3598570','GT','GT.03','Municipio de Chimaltenango','Municipio de Chimaltenango',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14123,'GT.14.3598654','GT','GT.14','Municipio de Santo Tomas Chichicastenango','Municipio de Santo Tomas Chichicastenango',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14124,'GT.14.3598658','GT','GT.14','Municipio de Chiché','Municipio de Chiche',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14125,'GT.20.3598677','GT','GT.20','Municipio de Chicacao','Municipio de Chicacao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14126,'GT.08.3598691','GT','GT.08','Municipio de Chiantla','Municipio de Chiantla',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14127,'GT.15.3598786','GT','GT.15','Municipio de Champerico','Municipio de Champerico',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14128,'GT.14.3598803','GT','GT.14','Municipio de Chajul','Municipio de Chajul',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14129,'GT.01.3598824','GT','GT.01','Municipio de Chahal','Municipio de Chahal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14130,'GT.17.3598956','GT','GT.17','Municipio de Catarina','Municipio de Catarina',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14131,'GT.18.3598967','GT','GT.18','Municipio de Casillas','Municipio de Casillas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14132,'GT.13.3599066','GT','GT.13','Municipio de Cantel','Municipio de Cantel',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14133,'GT.14.3599093','GT','GT.14','Municipio de Canillá','Municipio de Canilla',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14134,'GT.04.3599180','GT','GT.04','Municipio de Camotán','Municipio de Camotan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14135,'GT.13.3599252','GT','GT.13','Municipio de Cajolá','Municipio de Cajola',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14136,'GT.01.3599264','GT','GT.01','Municipio de Santa Maria Cahabon','Municipio de Santa Maria Cahabon',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14137,'GT.13.3599286','GT','GT.13','Municipio de Cabricán','Municipio de Cabrican',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14138,'GT.22.3599294','GT','GT.22','Municipio de Cabañas','Municipio de Cabanas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14139,'GT.08.3599574','GT','GT.08','Municipio de Barillas','Municipio de Barillas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14140,'GT.18.3599580','GT','GT.18','Municipio de Barberena','Municipio de Barberena',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14141,'GT.17.3599614','GT','GT.17','Municipio de Ayutla','Municipio de Ayutla',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14142,'GT.11.3599631','GT','GT.11','Municipio de Atescatempa','Municipio de Atescatempa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14143,'GT.11.3599638','GT','GT.11','Municipio de Asunción Mita','Municipio de Asuncion Mita',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14144,'GT.16.3599698','GT','GT.16','Municipio de Antigua','Municipio de Antigua',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14145,'GT.07.3599732','GT','GT.07','Municipio de Amatitlán','Municipio de Amatitlan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14146,'GT.16.3599786','GT','GT.16','Municipio de Alotenango','Municipio de Alotenango',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14147,'GT.13.3599791','GT','GT.13','Municipio de Almolonga','Municipio de Almolonga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14148,'GT.08.3599911','GT','GT.08','Municipio de Aguacatán','Municipio de Aguacatan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14149,'GT.11.3599963','GT','GT.11','Municipio de Agua Blanca','Municipio de Agua Blanca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14150,'GT.03.3600007','GT','GT.03','Municipio de Acatenango','Municipio de Acatenango',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14151,'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` VALUES (14152,'GT.14.9166161','GT','GT.14','Municipio de Ixcan','Municipio de Ixcan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14153,'GT.14.9166182','GT','GT.14','Municipio de Chicaman','Municipio de Chicaman',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14154,'GT.08.9253724','GT','GT.08','Municipio de Union Cantinil','Municipio de Union Cantinil',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14155,'GT.01.9253725','GT','GT.01','Raxruja','Raxruja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14156,'GT.14.9253733','GT','GT.14','Municipio de Zacualpa','Municipio de Zacualpa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14157,'GT.05.9253734','GT','GT.05','San Cristobal Acasguastlan','San Cristobal Acasguastlan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14158,'GT.14.9253735','GT','GT.14','Municipio de Pachalum','Municipio de Pachalum',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14159,'GT.19.9253744','GT','GT.19','Lago de Atitlan','Lago de Atitlan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14160,'GT.07.9253756','GT','GT.07','Lago de Amatitlan','Lago de Amatitlan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14161,'GT.01.9253762','GT','GT.01','Santa Catarina La Tinta','Santa Catarina La Tinta',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14162,'GT.05.9253768','GT','GT.05','Municipio de Guastatoya','Municipio de Guastatoya',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14163,'GT.03.9253822','GT','GT.03','San Juan Comalapa','San Juan Comalapa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14164,'GT.12.9253824','GT','GT.12','Las Cruces','Las Cruces',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14165,'GT.08.9975174','GT','GT.08','Municipo de Unión Cantinil','Municipo de Union Cantinil',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14166,'GT.01.9975220','GT','GT.01','Municipo de La Tinta','Municipo de La Tinta',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14167,'GT.13.9975221','GT','GT.13','Municipo de San Juan Ostuncalco','Municipo de San Juan Ostuncalco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14168,'GT.08.9975223','GT','GT.08','Municipo de San Ildefonso Ixtahuacan','Municipo de San Ildefonso Ixtahuacan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14169,'GT.01.9975224','GT','GT.01','Municipo de Raxruhá','Municipo de Raxruha',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14170,'GT.20.9975225','GT','GT.20','Municipio de San José La Máquina','Municipio de San Jose La Maquina',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14171,'GT.17.9975227','GT','GT.17','Municipio de La Blanca','Municipio de La Blanca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14172,'GT.22.9975228','GT','GT.22','Municipio de San Jorge','Municipio de San Jorge',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (14173,'GT.12.9975229','GT','GT.12','Municipio de El Chal','Municipio de El Chal',1);

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

INSERT INTO `<<prefix>>cities` VALUES (3587510,'GT','Zunil','Zunil',14.7833,-91.4833,'P','PPLA2','GT.13',NULL,9986,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3587543,'GT','Zaragoza','Zaragoza',14.6544,-90.8894,'P','PPLA2','GT.03','GT.03.3587541',9361,'America/Guatemala',1,'2012-02-06 23:00:00','2012-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3587578,'GT','Zacualpa','Zacualpa',15.0833,-90.8333,'P','PPLA2','GT.14',NULL,9241,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3587587,'GT','Zacapa','Zacapa',14.9722,-89.5306,'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` VALUES (3587636,'GT','Yepocapa','Yepocapa',14.5042,-90.9569,'P','PPLA2','GT.03',NULL,8961,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3587902,'GT','Villa Nueva','Villa Nueva',14.5269,-90.5875,'P','PPLA2','GT.07',NULL,406830,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3587923,'GT','Villa Canales','Villa Canales',14.4814,-90.5317,'P','PPLA2','GT.07',NULL,122194,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3588258,'GT','Totonicapán','Totonicapan',14.9117,-91.3611,'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` VALUES (3588469,'GT','Teculután','Teculutan',14.9833,-89.7167,'P','PPLA2','GT.22',NULL,6407,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3588476,'GT','Tecpán Guatemala','Tecpan Guatemala',14.7669,-90.9942,'P','PPLA2','GT.03',NULL,21978,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3588491,'GT','Taxisco','Taxisco',14.0672,-90.4679,'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` VALUES (3588603,'GT','Tactic','Tactic',15.3222,-90.3545,'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` VALUES (3588612,'GT','Tacaná','Tacana',15.2406,-92.0672,'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` VALUES (3588653,'GT','Sumpango','Sumpango',14.6464,-90.7339,'P','PPLA2','GT.16',NULL,20884,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3588694,'GT','Soloma','Soloma',15.6584,-91.4299,'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` VALUES (3588698,'GT','Sololá','Solola',14.7722,-91.1833,'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` VALUES (3588858,'GT','Senahú','Senahu',15.4,-89.8333,'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` VALUES (3588984,'GT','Sayaxché','Sayaxche',16.5245,-90.188,'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` VALUES (3589036,'GT','San Vicente Pacaya','San Vicente Pacaya',14.4161,-90.6392,'P','PPLA2','GT.06',NULL,7162,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589062,'GT','Santo Tomás La Unión','Santo Tomas La Union',14.6333,-91.3833,'P','PPLA2','GT.20',NULL,7081,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589072,'GT','Santo Domingo Xenacoj','Santo Domingo Xenacoj',14.6778,-90.6978,'P','PPLA2','GT.16',NULL,8791,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589074,'GT','Santo Domingo Suchitepéquez','Santo Domingo Suchitepequez',14.4667,-91.4833,'P','PPLA2','GT.20',NULL,6270,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589101,'GT','Santiago Sacatepéquez','Santiago Sacatepequez',14.6353,-90.6764,'P','PPLA2','GT.16',NULL,24210,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589105,'GT','Santiago Atitlán','Santiago Atitlan',14.6382,-91.229,'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` VALUES (3589159,'GT','Santa Rosa de Lima','Santa Rosa de Lima',14.3881,-90.2956,'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` VALUES (3589253,'GT','Santa María de Jesús','Santa Maria de Jesus',14.5183,-90.7267,'P','PPLA2','GT.16','GT.16.3589251',15529,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589256,'GT','Santa María Chiquimula','Santa Maria Chiquimula',15.0299,-91.3292,'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` VALUES (3589285,'GT','Santa Lucía Milpas Altas','Santa Lucia Milpas Altas',14.5758,-90.6786,'P','PPLA2','GT.16',NULL,13001,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589289,'GT','Santa Lucía Cotzumalguapa','Santa Lucia Cotzumalguapa',14.3333,-91.0167,'P','PPLA2','GT.06',NULL,62097,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589395,'GT','Santa Cruz Verapaz','Santa Cruz Verapaz',15.3667,-90.4333,'P','PPLA2','GT.01',NULL,5843,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589398,'GT','Santa Cruz Naranjo','Santa Cruz Naranjo',14.3881,-90.3697,'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` VALUES (3589404,'GT','Santa Cruz del Quiché','Santa Cruz del Quiche',15.0309,-91.1487,'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` VALUES (3589408,'GT','Santa Cruz Balanyá','Santa Cruz Balanya',14.6872,-90.915,'P','PPLA2','GT.03','GT.03.3589407',7825,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589433,'GT','Santa Clara La Laguna','Santa Clara La Laguna',14.7167,-91.3,'P','PPLA2','GT.19',NULL,5306,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589452,'GT','Santa Catarina Pinula','Santa Catarina Pinula',14.5689,-90.4953,'P','PPLA2','GT.07',NULL,67994,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589456,'GT','Santa Catarina Mita','Santa Catarina Mita',14.45,-89.75,'P','PPLA2','GT.11',NULL,10817,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589458,'GT','Santa Catarina Ixtahuacán','Santa Catarina Ixtahuacan',14.8,-91.3667,'P','PPLA2','GT.19',NULL,14734,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589475,'GT','Santa Bárbara','Santa Barbara',14.4333,-91.2333,'P','PPLA2','GT.20',NULL,12906,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589507,'GT','Santa Ana','Santa Ana',16.8,-89.8333,'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` VALUES (3589548,'GT','San Sebastián','San Sebastian',14.5667,-91.65,'P','PPLA2','GT.15',NULL,14823,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589569,'GT','San Raimundo','San Raimundo',14.7647,-90.5956,'P','PPLA2','GT.07',NULL,8689,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589626,'GT','San Pedro Sacatepéquez','San Pedro Sacatepequez',14.9667,-91.7667,'P','PPLA2','GT.17',NULL,40021,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589627,'GT','San Pedro Sacatepéquez','San Pedro Sacatepequez',14.6842,-90.6442,'P','PPLA2','GT.07',NULL,14315,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589637,'GT','San Pedro La Laguna','San Pedro La Laguna',14.693,-91.272,'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` VALUES (3589643,'GT','San Pedro Carchá','San Pedro Carcha',15.4833,-90.2667,'P','PPLA2','GT.01',NULL,13332,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589646,'GT','San Pedro Ayampuc','San Pedro Ayampuc',14.7867,-90.4511,'P','PPLA2','GT.07',NULL,46803,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589669,'GT','San Pablo La Laguna','San Pablo La Laguna',14.7167,-91.2667,'P','PPLA2','GT.19',NULL,6186,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589671,'GT','San Pablo Jocopilas','San Pablo Jocopilas',14.5833,-91.45,'P','PPLA2','GT.20',NULL,20259,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589677,'GT','San Pablo','San Pablo',14.9328,-92.0041,'P','PPLA2','GT.17',NULL,13668,'America/Guatemala',1,'2017-06-06 23:00:00','2017-06-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589706,'GT','San Miguel Sigüilá','San Miguel Siguila',14.9,-91.6167,'P','PPLA2','GT.13',NULL,7551,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589727,'GT','San Miguel Dueñas','San Miguel Duenas',14.5239,-90.7983,'P','PPLA2','GT.16',NULL,8424,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589730,'GT','San Miguel Chicaj','San Miguel Chicaj',15.1,-90.4,'P','PPLA2','GT.02',NULL,13747,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589770,'GT','San Mateo Ixtatán','San Mateo Ixtatan',15.8319,-91.4781,'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` VALUES (3589774,'GT','San Mateo','San Mateo',14.8667,-91.5833,'P','PPLA2','GT.13',NULL,5534,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589780,'GT','San Martín Jilotepeque','San Martin Jilotepeque',14.7878,-90.7925,'P','PPLA2','GT.03',NULL,9846,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589805,'GT','San Marcos','San Marcos',14.9639,-91.7944,'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` VALUES (3589822,'GT','San Luis Jilotepeque','San Luis Jilotepeque',14.65,-89.7333,'P','PPLA2','GT.10',NULL,10306,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589824,'GT','San Luis Ixcán','San Luis Ixcan',15.7872,-91.095,'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` VALUES (3589841,'GT','San Luis','San Luis',16.1989,-89.4403,'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` VALUES (3589850,'GT','San Lucas Tolimán','San Lucas Toliman',14.5947,-91.1466,'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` VALUES (3589852,'GT','San Lucas Sacatepéquez','San Lucas Sacatepequez',14.6097,-90.6569,'P','PPLA2','GT.16',NULL,17959,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589885,'GT','San Juan Sacatepéquez','San Juan Sacatepequez',14.7189,-90.6442,'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` VALUES (3589913,'GT','San Juan Cotzal','San Juan Cotzal',15.4337,-91.0348,'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` VALUES (3589917,'GT','San Juan Chamelco','San Juan Chamelco',15.4333,-90.3333,'P','PPLA2','GT.01',NULL,11944,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589975,'GT','San José Poaquil','San Jose Poaquil',14.8197,-90.9064,'P','PPLA2','GT.03',NULL,5987,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3589977,'GT','San José Pinula','San Jose Pinula',14.5461,-90.4114,'P','PPLA2','GT.07',NULL,47247,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590053,'GT','San José Acatempa','San Jose Acatempa',14.2653,-90.1269,'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` VALUES (3590114,'GT','San Jerónimo','San Jeronimo',15.0603,-90.2405,'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` VALUES (3590197,'GT','San Francisco Zapotitlán','San Francisco Zapotitlan',14.5833,-91.5167,'P','PPLA2','GT.20',NULL,13855,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590219,'GT','San Francisco El Alto','San Francisco El Alto',14.95,-91.45,'P','PPLA2','GT.21',NULL,54493,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590288,'GT','San Felipe','San Felipe',14.6167,-91.6,'P','PPLA2','GT.15',NULL,8921,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590316,'GT','San Cristóbal Verapaz','San Cristobal Verapaz',15.3963,-90.5651,'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` VALUES (3590323,'GT','San Cristóbal Cucho','San Cristobal Cucho',14.9,-91.7833,'P','PPLA2','GT.17',NULL,9152,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590347,'GT','San Carlos Sija','San Carlos Sija',14.9833,-91.55,'P','PPLA2','GT.13','GT.13.3590346',6831,'America/Guatemala',1,'2012-02-06 23:00:00','2012-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590384,'GT','San Bernardino','San Bernardino',14.5333,-91.45,'P','PPLA2','GT.20',NULL,5501,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590389,'GT','San Benito','San Benito',16.9167,-89.919,'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` VALUES (3590393,'GT','San Bartolomé Milpas Altas','San Bartolome Milpas Altas',14.6061,-90.68,'P','PPLA2','GT.16',NULL,6261,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590406,'GT','Sanarate','Sanarate',14.795,-90.1922,'P','PPLA2','GT.05',NULL,15843,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590412,'GT','San Antonio Suchitepéquez','San Antonio Suchitepequez',14.5333,-91.4167,'P','PPLA2','GT.20','GT.20.3590411',10951,'America/Guatemala',1,'2012-02-06 23:00:00','2012-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590449,'GT','San Antonio La Paz','San Antonio La Paz',14.7497,-90.2867,'P','PPLA2','GT.05',NULL,7781,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590458,'GT','San Antonio Huista','San Antonio Huista',15.6501,-91.7716,'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` VALUES (3590475,'GT','San Antonio Aguas Calientes','San Antonio Aguas Calientes',14.5397,-90.7694,'P','PPLA2','GT.16',NULL,7811,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590520,'GT','San Andrés Xecul','San Andres Xecul',14.9,-91.4833,'P','PPLA2','GT.21','GT.21.3590519',12133,'America/Guatemala',1,'2012-02-06 23:00:00','2012-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590522,'GT','San Andrés Villa Seca','San Andres Villa Seca',14.5667,-91.5833,'P','PPLA2','GT.15',NULL,5102,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590529,'GT','San Andrés Itzapa','San Andres Itzapa',14.62,-90.8442,'P','PPLA2','GT.03',NULL,18647,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590537,'GT','San Andrés','San Andres',16.9667,-89.9167,'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` VALUES (3590547,'GT','San Agustín Acasaguastlán','San Agustin Acasaguastlan',14.95,-89.9667,'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` VALUES (3590567,'GT','Samayac','Samayac',14.5808,-91.4613,'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` VALUES (3590605,'GT','Salcajá','Salcaja',14.8833,-91.45,'P','PPLA2','GT.13',NULL,11966,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590616,'GT','Salamá','Salama',15.1028,-90.3181,'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` VALUES (3590690,'GT','Sacapulas','Sacapulas',15.288,-91.0891,'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` VALUES (3590788,'GT','Río Hondo','Rio Hondo',15.0667,-89.5833,'P','PPLA2','GT.22',NULL,5997,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590804,'GT','Río Bravo','Rio Bravo',14.4004,-91.3171,'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` VALUES (3590858,'GT','Retalhuleu','Retalhuleu',14.5361,-91.6778,'P','PPLA','GT.15','GT.15.3590856',36656,'America/Guatemala',1,'2012-12-04 23:00:00','2012-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590924,'GT','Rabinal','Rabinal',15.1,-90.45,'P','PPLA2','GT.02',NULL,10737,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3590979,'GT','Quetzaltenango','Quetzaltenango',14.8347,-91.5181,'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` VALUES (3591028,'GT','Purulhá','Purulha',15.2667,-90.2,'P','PPLA2','GT.02',NULL,5370,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3591060,'GT','Puerto San José','Puerto San Jose',13.9274,-90.8217,'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` VALUES (3591062,'GT','Puerto Barrios','Puerto Barrios',15.7278,-88.5944,'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` VALUES (3591093,'GT','Tiquisate','Tiquisate',14.2836,-91.3606,'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` VALUES (3591181,'GT','Poptún','Poptun',16.3311,-89.4169,'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` VALUES (3591415,'GT','Petapa','Petapa',14.5028,-90.5517,'P','PPLA2','GT.07',NULL,141455,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3591512,'GT','Patzún','Patzun',14.6833,-91.0167,'P','PPLA2','GT.03',NULL,18704,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3591523,'GT','Patzicía','Patzicia',14.6317,-90.9269,'P','PPLA2','GT.03','GT.03.3591521',16494,'America/Guatemala',1,'2012-02-06 23:00:00','2012-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3591541,'GT','Patulul','Patulul',14.4167,-91.1667,'P','PPLA2','GT.20',NULL,14196,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3591574,'GT','Pastores','Pastores',14.5967,-90.7547,'P','PPLA2','GT.16',NULL,10393,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3591629,'GT','Parramos','Parramos',14.6078,-90.8031,'P','PPLA2','GT.03',NULL,9613,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3591676,'GT','Panzós','Panzos',15.4,-89.6667,'P','PPLA2','GT.01',NULL,25569,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3591750,'GT','Panajachel','Panajachel',14.7333,-91.15,'P','PPLA2','GT.19',NULL,12863,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3591833,'GT','Palín','Palin',14.4056,-90.6983,'P','PPLA2','GT.06',NULL,31329,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3591851,'GT','Palencia','Palencia',14.6647,-90.3586,'P','PPLA2','GT.07',NULL,18574,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3591885,'GT','Pajapita','Pajapita',14.7215,-92.0352,'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` VALUES (3591997,'GT','Ostuncalco','Ostuncalco',14.8667,-91.6167,'P','PPLA2','GT.13',NULL,28894,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3592019,'GT','Oratorio','Oratorio',14.2281,-90.1758,'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` VALUES (3592086,'GT','Ocós','Ocos',14.51,-92.193,'P','PPLA2','GT.17',NULL,9463,'America/Guatemala',1,'2014-09-30 23:00:00','2014-09-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3592105,'GT','Nuevo San Carlos','Nuevo San Carlos',14.6,-91.7,'P','PPLA2','GT.15',NULL,19162,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3592108,'GT','Nuevo Progreso','Nuevo Progreso',14.8,-91.9167,'P','PPLA2','GT.17',NULL,8113,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3592126,'GT','Nueva Santa Rosa','Nueva Santa Rosa',14.3811,-90.2761,'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` VALUES (3592145,'GT','Nueva Concepción','Nueva Concepcion',14.2,-91.3,'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` VALUES (3592237,'GT','Nebaj','Nebaj',15.4061,-91.1468,'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` VALUES (3592286,'GT','Nahualá','Nahuala',14.85,-91.3167,'P','PPLA2','GT.19',NULL,27690,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3592322,'GT','Moyuta','Moyuta',14.0386,-90.0808,'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` VALUES (3592362,'GT','Morales','Morales',15.4833,-88.8167,'P','PPLA2','GT.09',NULL,18994,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3592477,'GT','Monjas','Monjas',14.5,-89.8667,'P','PPLA2','GT.10',NULL,10351,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3592483,'GT','Momostenango','Momostenango',15.0444,-91.4086,'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` VALUES (3592519,'GT','Mixco','Mixco',14.6333,-90.6064,'P','PPLA2','GT.07',NULL,473080,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3592609,'GT','Mazatenango','Mazatenango',14.5342,-91.5033,'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` VALUES (3592635,'GT','Mataquescuintla','Mataquescuintla',14.5292,-90.1842,'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` VALUES (3592642,'GT','Masagua','Masagua',14.2031,-90.8481,'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` VALUES (3592753,'GT','Malacatán','Malacatan',14.9107,-92.058,'P','PPLA2','GT.17',NULL,14923,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3592770,'GT','Magdalena Milpas Altas','Magdalena Milpas Altas',14.5453,-90.6753,'P','PPLA2','GT.16',NULL,5582,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3593376,'GT','Lívingston','Livingston',15.8283,-88.7504,'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` VALUES (3594422,'GT','La Libertad','La Libertad',16.7885,-90.117,'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` VALUES (3594423,'GT','La Libertad','La Libertad',15.5142,-91.8694,'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` VALUES (3594575,'GT','La Gomera','La Gomera',14.0833,-91.05,'P','PPLA2','GT.06',NULL,24001,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3594703,'GT','La Esperanza','La Esperanza',14.8667,-91.5667,'P','PPLA2','GT.13','GT.13.3594666',16461,'America/Guatemala',1,'2012-02-06 23:00:00','2012-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3594753,'GT','La Democracia','La Democracia',14.2308,-90.9472,'P','PPLA2','GT.06','GT.06.3594750',5479,'America/Guatemala',1,'2012-02-06 23:00:00','2012-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3595069,'GT','Jutiapa','Jutiapa',14.2917,-89.8958,'P','PPLA','GT.11',NULL,34332,'America/Guatemala',1,'2012-12-04 23:00:00','2012-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3595148,'GT','Joyabaj','Joyabaj',14.995,-90.8061,'P','PPLA2','GT.14',NULL,13164,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3595171,'GT','Jocotenango','Jocotenango',14.5819,-90.7436,'P','PPLA2','GT.16',NULL,17918,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3595232,'GT','Jalpatagua','Jalpatagua',14.1417,-90.0086,'P','PPLA2','GT.11',NULL,10469,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3595237,'GT','Jalapa','Jalapa',14.6347,-89.9889,'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` VALUES (3595248,'GT','Jacaltenango','Jacaltenango',15.6666,-91.7118,'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` VALUES (3595366,'GT','Ipala','Ipala',14.6167,-89.6167,'P','PPLA2','GT.04',NULL,5283,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3595406,'GT','Huitán','Huitan',15.0492,-91.6394,'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` VALUES (3595416,'GT','Huehuetenango','Huehuetenango',15.3192,-91.4724,'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` VALUES (3595503,'GT','Guazacapán','Guazacapan',14.0742,-90.4167,'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` VALUES (3595560,'GT','Gualán','Gualan',15.1195,-89.3572,'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` VALUES (3595714,'GT','Fraijanes','Fraijanes',14.4653,-90.4408,'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` VALUES (3595721,'GT','Flores Costa Cuca','Flores Costa Cuca',14.6324,-91.8634,'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` VALUES (3595725,'GT','Flores','Flores',16.9226,-89.8994,'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` VALUES (3595757,'GT','Estanzuela','Estanzuela',15,-89.5667,'P','PPLA2','GT.22',NULL,8937,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3595783,'GT','Esquipulas','Esquipulas',14.5667,-89.35,'P','PPLA2','GT.04',NULL,20674,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3595803,'GT','Escuintla','Escuintla',14.305,-90.785,'P','PPLA','GT.06','GT.06.3595801',103165,'America/Guatemala',1,'2012-02-06 23:00:00','2012-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3595929,'GT','El Tumbador','El Tumbador',14.8667,-91.9333,'P','PPLA2','GT.17',NULL,7562,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3596041,'GT','El Tejar','El Tejar',14.6478,-90.7928,'P','PPLA2','GT.03',NULL,15770,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3596389,'GT','El Quetzal','El Quetzal',14.7667,-91.8167,'P','PPLA2','GT.17',NULL,12122,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3596421,'GT','Guastatoya','Guastatoya',14.8542,-90.0694,'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` VALUES (3596423,'GT','El Progreso','El Progreso',14.35,-89.85,'P','PPLA2','GT.11',NULL,7350,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3596644,'GT','El Palmar','El Palmar',14.65,-91.5833,'P','PPLA2','GT.13',NULL,15167,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3597078,'GT','El Estor','El Estor',15.5333,-89.35,'P','PPLA2','GT.09',NULL,15842,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3597587,'GT','El Asintal','El Asintal',14.6,-91.7333,'P','PPLA2','GT.15',NULL,6156,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3597722,'GT','Dolores','Dolores',16.5142,-89.4158,'P','PPLA2','GT.12',NULL,10604,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3597750,'GT','Cuyotenango','Cuyotenango',14.5333,-91.5667,'P','PPLA2','GT.20','GT.20.3597749',10825,'America/Guatemala',1,'2012-02-06 23:00:00','2012-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3597772,'GT','Cunén','Cunen',15.3363,-91.0278,'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` VALUES (3597804,'GT','Cuilapa','Cuilapa',14.2764,-90.2989,'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` VALUES (3597837,'GT','Cubulco','Cubulco',15.1333,-90.5833,'P','PPLA2','GT.02',NULL,9753,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3597993,'GT','Concepción Chiquirichapa','Concepcion Chiquirichapa',14.85,-91.6167,'P','PPLA2','GT.13',NULL,8080,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3598005,'GT','Concepción Huista','Concepcion Huista',15.6238,-91.6652,'P','PPLA2','GT.08',NULL,8925,'America/Guatemala',1,'2017-03-03 23:00:00','2017-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3598025,'GT','Comitancillo','Comitancillo',15.0894,-91.7497,'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` VALUES (3598034,'GT','Comalapa','Comalapa',14.7411,-90.8875,'P','PPLA2','GT.03','GT.03.3598032',20738,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3598073,'GT','Colomba','Colomba',14.7167,-91.7333,'P','PPLA2','GT.13',NULL,19115,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3598119,'GT','Cobán','Coban',15.4708,-90.3708,'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` VALUES (3598122,'GT','Coatepeque','Coatepeque',14.7,-91.8667,'P','PPLA2','GT.13',NULL,45654,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3598128,'GT','Ciudad Vieja','Ciudad Vieja',14.5264,-90.7597,'P','PPLA2','GT.16',NULL,30203,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3598129,'GT','Ciudad Tecún Umán','Ciudad Tecun Uman',14.6774,-92.1404,'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` VALUES (3598131,'GT','Melchor de Mencos','Melchor de Mencos',17.0661,-89.1523,'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` VALUES (3598132,'GT','Guatemala City','Guatemala City',14.6407,-90.5133,'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` VALUES (3598277,'GT','Chuarrancho','Chuarrancho',14.8217,-90.5086,'P','PPLA2','GT.07',NULL,7149,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3598415,'GT','Chisec','Chisec',15.8167,-90.2833,'P','PPLA2','GT.01',NULL,17018,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3598462,'GT','Chiquimulilla','Chiquimulilla',14.0838,-90.3855,'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` VALUES (3598465,'GT','Chiquimula','Chiquimula',14.8,-89.5458,'P','PPLA','GT.04','GT.04.3598463',41521,'America/Guatemala',1,'2012-12-04 23:00:00','2012-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3598529,'GT','Chinautla','Chinautla',14.7083,-90.4994,'P','PPLA2','GT.07',NULL,97172,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3598572,'GT','Chimaltenango','Chimaltenango',14.6611,-90.8194,'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` VALUES (3598655,'GT','Chichicastenango','Chichicastenango',14.9333,-91.1167,'P','PPLA2','GT.14',NULL,79759,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3598678,'GT','Chicacao','Chicacao',14.5333,-91.3167,'P','PPLA2','GT.20',NULL,20426,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3598692,'GT','Chiantla','Chiantla',15.3548,-91.4581,'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` VALUES (3598787,'GT','Champerico','Champerico',14.3,-91.9167,'P','PPLA2','GT.15','GT.15.3598786',7761,'America/Guatemala',1,'2012-02-06 23:00:00','2012-02-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3598804,'GT','Chajul','Chajul',15.4852,-91.0352,'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` VALUES (3598825,'GT','Chahal Guatemala','Chahal Guatemala',15.7912,-89.6052,'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` VALUES (3598968,'GT','Casillas','Casillas',14.4222,-90.2442,'P','PPLA2','GT.18',NULL,8970,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3599069,'GT','Cantel','Cantel',14.8167,-91.45,'P','PPLA2','GT.13',NULL,26063,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3599287,'GT','Cabricán','Cabrican',15.0749,-91.648,'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` VALUES (3599575,'GT','Barillas','Barillas',15.8036,-91.3158,'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` VALUES (3599582,'GT','Barberena','Barberena',14.3094,-90.3611,'P','PPLA2','GT.18',NULL,30539,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3599633,'GT','Atescatempa','Atescatempa',14.1744,-89.7425,'P','PPLA2','GT.11',NULL,11543,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3599639,'GT','Asunción Mita','Asuncion Mita',14.3308,-89.7108,'P','PPLA2','GT.11',NULL,15608,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3599699,'GT','Antigua Guatemala','Antigua Guatemala',14.5611,-90.7344,'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` VALUES (3599735,'GT','Amatitlán','Amatitlan',14.4774,-90.6349,'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` VALUES (3599788,'GT','Alotenango','Alotenango',14.4803,-90.8075,'P','PPLA2','GT.16',NULL,17410,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3599793,'GT','Almolonga','Almolonga',14.8167,-91.5,'P','PPLA2','GT.13',NULL,11913,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3599912,'GT','Aguacatán','Aguacatan',15.3422,-91.3114,'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` VALUES (3600008,'GT','Acatenango','Acatenango',14.5519,-90.9422,'P','PPLA2','GT.03',NULL,7050,'America/Guatemala',1,'2015-02-05 23:00:00','2015-02-05 23:00:00');


