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


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

INSERT INTO `<<prefix>>subadmin1` VALUES (586,'CL.01','CL','Valparaíso','Valparaiso',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (587,'CL.15','CL','Tarapacá','Tarapaca',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (588,'CL.12','CL','Santiago Metropolitan','Santiago Metropolitan',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (589,'CL.11','CL','Maule','Maule',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (590,'CL.14','CL','Los Lagos','Los Lagos',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (591,'CL.08','CL','O\'Higgins Region','O\'Higgins Region',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (592,'CL.07','CL','Coquimbo','Coquimbo',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (593,'CL.06','CL','Biobío','Biobio',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (594,'CL.05','CL','Atacama','Atacama',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (595,'CL.04','CL','Araucanía','Araucania',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (596,'CL.03','CL','Antofagasta','Antofagasta',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (597,'CL.02','CL','Aysén','Aysen',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (598,'CL.10','CL','Magallanes','Magallanes',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (599,'CL.16','CL','Arica y Parinacota','Arica y Parinacota',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (600,'CL.17','CL','Los Ríos','Los Rios',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (9367,'CL.01.51','CL','CL.01','Provincia de Valparaíso','Provincia de Valparaiso',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9368,'CL.17.141','CL','CL.17','Provincia de Valdivia','Provincia de Valdivia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9369,'CL.10.124','CL','CL.10','Provincia de Última Esperanza','Provincia de Ultima Esperanza',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9370,'CL.03.23','CL','CL.03','Provincia de Tocopilla','Provincia de Tocopilla',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9371,'CL.10.123','CL','CL.10','Provincia de Tierra del Fuego','Provincia de Tierra del Fuego',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9372,'CL.11.71','CL','CL.11','Provincia de Talca','Provincia de Talca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9373,'CL.12.136','CL','CL.12','Provincia de Talagante','Provincia de Talagante',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9374,'CL.12.131','CL','CL.12','Provincia de Santiago','Provincia de Santiago',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9375,'CL.01.57','CL','CL.01','Provincia de San Felipe','Provincia de San Felipe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9376,'CL.01.56','CL','CL.01','San Antonio Province','San Antonio Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9377,'CL.01.55','CL','CL.01','Provincia de Quillota','Provincia de Quillota',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9378,'CL.01.54','CL','CL.01','Petorca Province','Petorca Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9379,'CL.14.103','CL','CL.14','Provincia de Osorno','Provincia de Osorno',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9380,'CL.06.84','CL','CL.06','Provincia de Ñuble','Provincia de Nuble',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9381,'CL.12.135','CL','CL.12','Provincia de Melipilla','Provincia de Melipilla',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9382,'CL.04.92','CL','CL.04','Provincia de Malleco','Provincia de Malleco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9383,'CL.12.134','CL','CL.12','Provincia de Maipo','Provincia de Maipo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9384,'CL.10.121','CL','CL.10','Provincia de Magallanes','Provincia de Magallanes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9385,'CL.01.53','CL','CL.01','Provincia de Los Andes','Provincia de Los Andes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9386,'CL.14.101','CL','CL.14','Provincia de Llanquihue','Provincia de Llanquihue',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9387,'CL.11.74','CL','CL.11','Provincia de Linares','Provincia de Linares',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9388,'CL.07.43','CL','CL.07','Provincia de Limarí','Provincia de Limari',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9389,'CL.15.11','CL','CL.15','Provincia de Iquique','Provincia de Iquique',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9390,'CL.05.33','CL','CL.05','Provincia de Huasco','Provincia de Huasco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9391,'CL.02.114','CL','CL.02','Provincia General Carrera','Provincia General Carrera',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9392,'CL.07.41','CL','CL.07','Provincia de Elqui','Provincia de Elqui',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9393,'CL.03.22','CL','CL.03','Provincia de El Loa','Provincia de El Loa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9394,'CL.11.73','CL','CL.11','Provincia de Curicó','Provincia de Curico',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9395,'CL.05.31','CL','CL.05','Provincia de Copiapó','Provincia de Copiapo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9396,'CL.06.81','CL','CL.06','Provincia de Concepción','Provincia de Concepcion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9397,'CL.08.63','CL','CL.08','Provincia de Colchagua','Provincia de Colchagua',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9398,'CL.07.42','CL','CL.07','Provincia de Choapa','Provincia de Choapa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9399,'CL.14.102','CL','CL.14','Provincia de Chiloé','Provincia de Chiloe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9400,'CL.05.32','CL','CL.05','Provincia de Chañaral','Provincia de Chanaral',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9401,'CL.04.91','CL','CL.04','Provincia de Cautín','Provincia de Cautin',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9402,'CL.02.113','CL','CL.02','Provincia Capitán Prat','Provincia Capitan Prat',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9403,'CL.08.61','CL','CL.08','Provincia de Cachapoal','Provincia de Cachapoal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9404,'CL.06.83','CL','CL.06','Provincia de Biobío','Provincia de Biobio',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9405,'CL.16.151','CL','CL.16','Provincia de Arica','Provincia de Arica',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9406,'CL.06.82','CL','CL.06','Provincia de Arauco','Provincia de Arauco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9407,'CL.03.21','CL','CL.03','Provincia de Antofagasta','Provincia de Antofagasta',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9408,'CL.02.112','CL','CL.02','Provincia de Aisén','Provincia de Aisen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9409,'CL.01.52','CL','CL.01','Provincia de Isla de Pascua','Provincia de Isla de Pascua',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9410,'CL.10.122','CL','CL.10','Provincia Antártica Chilena','Provincia Antartica Chilena',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9411,'CL.17.142','CL','CL.17','Provincia del Ranco','Provincia del Ranco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9412,'CL.16.152','CL','CL.16','Provincia de Parinacota','Provincia de Parinacota',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9413,'CL.15.14','CL','CL.15','Provincia del Tamarugal','Provincia del Tamarugal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9414,'CL.01.58','CL','CL.01','Provincia de Marga Marga','Provincia de Marga Marga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9415,'CL.08.62','CL','CL.08','Provincia de Cardenal Caro','Provincia de Cardenal Caro',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9416,'CL.11.72','CL','CL.11','Provincia de Cauquenes','Provincia de Cauquenes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9417,'CL.14.104','CL','CL.14','Provincia de Palena','Provincia de Palena',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9418,'CL.02.111','CL','CL.02','Provincia de Coyhaique','Provincia de Coyhaique',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9419,'CL.12.132','CL','CL.12','Provincia de Cordillera','Provincia de Cordillera',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9420,'CL.12.133','CL','CL.12','Provincia de Chacabuco','Provincia de Chacabuco',1);

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

INSERT INTO `<<prefix>>cities` VALUES (3867625,'CL','Yumbel','Yumbel',-37.0982,-72.5608,'P','PPL','CL.06','CL.06.83',11111,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3868121,'CL','Viña del Mar','Vina del Mar',-33.0246,-71.5518,'P','PPL','CL.01','CL.01.51',294551,'America/Santiago',1,'2017-02-19 23:00:00','2017-02-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3868158,'CL','Villarrica','Villarrica',-39.2857,-72.2279,'P','PPL','CL.04','CL.04.91',31602,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3868192,'CL','Villa Alemana','Villa Alemana',-33.0422,-71.3733,'P','PPLA3','CL.01','CL.01.58',97320,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3868210,'CL','Vilcún','Vilcun',-38.6688,-72.2256,'P','PPL','CL.04','CL.04.91',9241,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3868308,'CL','Vicuña','Vicuna',-30.0354,-70.7127,'P','PPL','CL.07','CL.07.41',13496,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3868326,'CL','Victoria','Victoria',-38.2329,-72.3329,'P','PPL','CL.04','CL.04.92',24555,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3868626,'CL','Valparaíso','Valparaiso',-33.036,-71.6296,'P','PPLA','CL.01','CL.01.51',282448,'America/Santiago',1,'2017-12-05 23:00:00','2017-12-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3868633,'CL','Vallenar','Vallenar',-28.5762,-70.7594,'P','PPL','CL.05','CL.05.33',44895,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3868707,'CL','Valdivia','Valdivia',-39.8142,-73.2459,'P','PPLA','CL.17','CL.17.141',133419,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3869381,'CL','Traiguén','Traiguen',-38.2496,-72.6703,'P','PPL','CL.04','CL.04.92',14481,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3869657,'CL','Tomé','Tome',-36.6176,-72.9559,'P','PPL','CL.06','CL.06.81',46698,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3869716,'CL','Tocopilla','Tocopilla',-22.092,-70.1979,'P','PPL','CL.03','CL.03.23',24460,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3869979,'CL','Teno','Teno',-34.8705,-71.1622,'P','PPL','CL.11','CL.11.73',6858,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3870011,'CL','Temuco','Temuco',-38.7397,-72.5984,'P','PPLA','CL.04','CL.04.91',238129,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3870243,'CL','Taltal','Taltal',-25.4087,-70.4836,'P','PPL','CL.03',NULL,10018,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3870282,'CL','Talcahuano','Talcahuano',-36.7249,-73.1168,'P','PPL','CL.06','CL.06.81',252968,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3870294,'CL','Talca','Talca',-35.4264,-71.6554,'P','PPLA','CL.11','CL.11.71',197479,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3870306,'CL','Talagante','Talagante',-33.6639,-70.9273,'P','PPL','CL.12','CL.12.136',51764,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3871276,'CL','San Vicente de Tagua Tagua','San Vicente de Tagua Tagua',-34.4386,-71.0775,'P','PPL','CL.08','CL.08.61',29560,'America/Santiago',1,'2015-10-27 23:00:00','2015-10-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3871286,'CL','San Vicente','San Vicente',-34.4333,-71.0833,'P','PPL','CL.08','CL.08.61',22572,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3871336,'CL','Santiago','Santiago',-33.4569,-70.6483,'P','PPLC','CL.12','CL.12.131',4837295,'America/Santiago',1,'2016-07-04 23:00:00','2016-07-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3871616,'CL','Santa Cruz','Santa Cruz',-34.6388,-71.3658,'P','PPL','CL.08','CL.08.63',33283,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3872154,'CL','San Javier','San Javier',-35.5952,-71.7292,'P','PPL','CL.11','CL.11.74',22427,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3872255,'CL','San Felipe','San Felipe',-32.7498,-70.7258,'P','PPL','CL.01','CL.01.57',59294,'America/Santiago',1,'2017-08-17 23:00:00','2017-08-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3872306,'CL','San Clemente','San Clemente',-35.5378,-71.487,'P','PPL','CL.11','CL.11.71',13656,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3872326,'CL','San Carlos','San Carlos',-36.4248,-71.958,'P','PPL','CL.06','CL.06.84',31517,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3872348,'CL','San Bernardo','San Bernardo',-33.5922,-70.6996,'P','PPL','CL.12','CL.12.134',249858,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3872395,'CL','San Antonio','San Antonio',-33.5947,-71.6075,'P','PPL','CL.01','CL.01.56',85651,'America/Santiago',1,'2016-02-27 23:00:00','2016-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3872594,'CL','Salamanca','Salamanca',-31.7792,-70.9639,'P','PPL','CL.07','CL.07.42',13265,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3873145,'CL','Río Bueno','Rio Bueno',-40.3349,-72.9556,'P','PPL','CL.17','CL.17.142',15456,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3873441,'CL','Rengo','Rengo',-34.4064,-70.8583,'P','PPL','CL.08','CL.08.61',38100,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3873668,'CL','Rauco','Rauco',-34.9255,-71.3172,'P','PPL','CL.11','CL.11.73',8566,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3873775,'CL','Rancagua','Rancagua',-34.1708,-70.7444,'P','PPLA','CL.08','CL.08.61',212695,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3874096,'CL','Quilpué','Quilpue',-33.0475,-71.4425,'P','PPL','CL.01','CL.01.58',130263,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3874119,'CL','Quillota','Quillota',-32.8834,-71.2488,'P','PPL','CL.01','CL.01.55',67779,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3874579,'CL','Purranque','Purranque',-40.9131,-73.1591,'P','PPL','CL.14','CL.14.103',13619,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3874787,'CL','Punta Arenas','Punta Arenas',-53.1548,-70.9113,'P','PPLA','CL.10','CL.10.121',117430,'America/Punta_Arenas',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3874930,'CL','Puerto Varas','Puerto Varas',-41.3195,-72.9854,'P','PPL','CL.14','CL.14.101',24958,'America/Santiago',1,'2013-01-25 23:00:00','2013-01-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3874943,'CL','Quellón','Quellon',-43.1182,-73.6166,'P','PPL','CL.14','CL.14.102',21823,'America/Santiago',1,'2016-11-22 23:00:00','2016-11-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3874958,'CL','Puerto Natales','Puerto Natales',-51.7299,-72.506,'P','PPL','CL.10','CL.10.124',20000,'America/Punta_Arenas',1,'2017-12-15 23:00:00','2017-12-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3874960,'CL','Puerto Montt','Puerto Montt',-41.4693,-72.9424,'P','PPLA','CL.14','CL.14.101',160054,'America/Santiago',1,'2017-12-10 23:00:00','2017-12-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3874997,'CL','Puerto Aisén','Puerto Aisen',-45.403,-72.6918,'P','PPL','CL.02','CL.02.112',16936,'America/Santiago',1,'2017-03-04 23:00:00','2017-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3875024,'CL','Puente Alto','Puente Alto',-33.6117,-70.5758,'P','PPL','CL.12','CL.12.132',510417,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3875070,'CL','Pucón','Pucon',-39.2822,-71.9543,'P','PPL','CL.04','CL.04.91',26953,'America/Santiago',1,'2017-02-19 23:00:00','2017-02-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3875746,'CL','Pitrufquén','Pitrufquen',-38.9864,-72.6372,'P','PPL','CL.04','CL.04.91',13743,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3876664,'CL','Penco','Penco',-36.7407,-72.9953,'P','PPL','CL.06','CL.06.81',46091,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3876685,'CL','Peñaflor','Penaflor',-33.6063,-70.8765,'P','PPL','CL.12','CL.12.136',65495,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3877146,'CL','Parral','Parral',-36.1431,-71.826,'P','PPL','CL.11','CL.11.74',26904,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3877348,'CL','Panguipulli','Panguipulli',-39.6436,-72.3327,'P','PPL','CL.04',NULL,16312,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3877739,'CL','Paine','Paine',-33.808,-70.7411,'P','PPL','CL.12','CL.12.134',32766,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3877918,'CL','Ovalle','Ovalle',-30.6011,-71.199,'P','PPL','CL.07','CL.07.43',77138,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3877949,'CL','Osorno','Osorno',-40.574,-73.1335,'P','PPL','CL.14','CL.14.103',135773,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3878456,'CL','Nueva Imperial','Nueva Imperial',-38.7445,-72.9502,'P','PPL','CL.04','CL.04.91',18777,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3879123,'CL','Nacimiento','Nacimiento',-37.5025,-72.6731,'P','PPL','CL.06','CL.06.83',21220,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3879200,'CL','Mulchén','Mulchen',-37.7189,-72.241,'P','PPL','CL.06','CL.06.83',22170,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3879429,'CL','Monte Patria','Monte Patria',-30.695,-70.9577,'P','PPL','CL.07','CL.07.43',13945,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3879627,'CL','Molina','Molina',-35.1143,-71.2823,'P','PPL','CL.11','CL.11.73',28775,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3880107,'CL','Melipilla','Melipilla',-33.6891,-71.2153,'P','PPL','CL.12','CL.12.135',63100,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3881102,'CL','Machalí','Machali',-34.1808,-70.6493,'P','PPL','CL.08','CL.08.61',27595,'America/Santiago',1,'2013-04-03 23:00:00','2013-04-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3881276,'CL','Lota','Lota',-37.0899,-73.1577,'P','PPL','CL.06','CL.06.81',49763,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3882428,'CL','Los Ángeles','Los Angeles',-37.4697,-72.3537,'P','PPLA2','CL.06','CL.06.83',125430,'America/Santiago',1,'2016-11-20 23:00:00','2016-11-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3882434,'CL','Los Andes','Los Andes',-32.8337,-70.5983,'P','PPL','CL.01','CL.01.53',56859,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3882559,'CL','Longaví','Longavi',-35.965,-71.6836,'P','PPL','CL.11','CL.11.74',6325,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3882582,'CL','Loncoche','Loncoche',-39.3671,-72.6309,'P','PPL','CL.04','CL.04.91',15590,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3883035,'CL','Llaillay','Llaillay',-32.8404,-70.9562,'P','PPL','CL.01','CL.01.57',16646,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3883167,'CL','Linares','Linares',-35.8467,-71.5931,'P','PPL','CL.11','CL.11.74',69535,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3883214,'CL','Limache','Limache',-33.0167,-71.2667,'P','PPLA3','CL.01','CL.01.58',35876,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3883457,'CL','Lebu','Lebu',-37.6082,-73.6536,'P','PPL','CL.06','CL.06.82',22345,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3883615,'CL','Lautaro','Lautaro',-38.5307,-72.4365,'P','PPL','CL.04','CL.04.91',21579,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3883629,'CL','La Unión','La Union',-40.2931,-73.0817,'P','PPL','CL.17',NULL,26298,'America/Santiago',1,'2016-01-26 23:00:00','2016-01-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3884373,'CL','La Serena','La Serena',-29.9045,-71.2489,'P','PPLA','CL.07','CL.07.41',154521,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3885273,'CL','Lampa','Lampa',-33.2863,-70.8756,'P','PPL','CL.12','CL.12.133',29250,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3885456,'CL','La Ligua','La Ligua',-32.4524,-71.2311,'P','PPL','CL.01','CL.01.54',24857,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3885509,'CL','La Laja','La Laja',-37.2841,-72.7111,'P','PPL','CL.06','CL.06.83',16550,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3887127,'CL','Iquique','Iquique',-20.2204,-70.1391,'P','PPLA','CL.15','CL.15.11',227499,'America/Santiago',1,'2012-12-04 23:00:00','2012-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3887344,'CL','Illapel','Illapel',-31.6335,-71.1697,'P','PPL','CL.07','CL.07.42',22816,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3888214,'CL','Hacienda La Calera','Hacienda La Calera',-32.7833,-71.2167,'P','PPL','CL.01','CL.01.55',49106,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3888749,'CL','Graneros','Graneros',-34.0686,-70.7275,'P','PPL','CL.08','CL.08.61',23301,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3889263,'CL','Frutillar','Frutillar',-41.1268,-73.0437,'P','PPL','CL.14','CL.14.101',16939,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3889322,'CL','Freire','Freire',-38.9525,-72.6265,'P','PPL','CL.04','CL.04.91',7813,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3890949,'CL','El Monte','El Monte',-33.6797,-70.9848,'P','PPL','CL.12','CL.12.136',23090,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3892454,'CL','Diego de Almagro','Diego de Almagro',-26.3667,-70.05,'P','PPL','CL.05','CL.05.32',18137,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3892870,'CL','Curicó','Curico',-34.9828,-71.2394,'P','PPL','CL.11','CL.11.73',102438,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3892892,'CL','Curanilahue','Curanilahue',-37.4779,-73.3449,'P','PPL','CL.06','CL.06.82',30611,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3893532,'CL','Coronel','Coronel',-37.0339,-73.1402,'P','PPL','CL.06','CL.06.81',92940,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3893629,'CL','Coquimbo','Coquimbo',-29.9533,-71.3395,'P','PPL','CL.07','CL.07.41',161317,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3893656,'CL','Copiapó','Copiapo',-27.3668,-70.3314,'P','PPLA','CL.05','CL.05.31',129280,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3893726,'CL','Constitución','Constitucion',-35.3332,-72.4116,'P','PPL','CL.11','CL.11.71',37917,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3893894,'CL','Concepción','Concepcion',-36.827,-73.0498,'P','PPLA','CL.06','CL.06.81',215413,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3894177,'CL','Collipulli','Collipulli',-37.9545,-72.4344,'P','PPL','CL.04','CL.04.92',16392,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3894406,'CL','Coihueco','Coihueco',-36.6278,-71.8307,'P','PPL','CL.06','CL.06.84',7346,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3894426,'CL','Coyhaique','Coyhaique',-45.5752,-72.0662,'P','PPLA','CL.02','CL.02.111',45787,'America/Santiago',1,'2017-04-07 23:00:00','2017-04-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3894871,'CL','Chonchi','Chonchi',-42.62,-73.7767,'P','PPL','CL.14','CL.14.102',12572,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3895061,'CL','Chimbarongo','Chimbarongo',-34.7125,-71.0434,'P','PPL','CL.08','CL.08.63',17356,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3895088,'CL','Chillán','Chillan',-36.6066,-72.1034,'P','PPL','CL.06','CL.06.84',150396,'America/Santiago',1,'2017-02-19 23:00:00','2017-02-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3895138,'CL','Chiguayante','Chiguayante',-36.9256,-73.0284,'P','PPL','CL.06','CL.06.81',82545,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3895165,'CL','Chicureo Abajo','Chicureo Abajo',-33.2838,-70.6533,'P','PPL','CL.12','CL.12.133',18000,'America/Santiago',1,'2013-04-24 23:00:00','2013-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3896105,'CL','Cauquenes','Cauquenes',-35.9671,-72.3225,'P','PPL','CL.11','CL.11.72',31362,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3896218,'CL','Castro','Castro',-42.4721,-73.7732,'P','PPL','CL.14','CL.14.102',29926,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3896433,'CL','Cartagena','Cartagena',-33.5538,-71.6076,'P','PPL','CL.01','CL.01.56',16875,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3896774,'CL','Carahue','Carahue',-38.7112,-73.161,'P','PPL','CL.04','CL.04.91',11875,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3896924,'CL','Cañete','Canete',-37.8013,-73.3962,'P','PPL','CL.06','CL.06.82',20158,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3897334,'CL','Calbuco','Calbuco',-41.7734,-73.1305,'P','PPL','CL.14',NULL,12490,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3897347,'CL','Calama','Calama',-22.4567,-68.9237,'P','PPL','CL.03','CL.03.22',143084,'America/Santiago',1,'2016-06-03 23:00:00','2016-06-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3897557,'CL','Cabrero','Cabrero',-37.0339,-72.4047,'P','PPL','CL.06','CL.06.83',18327,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3897724,'CL','Bulnes','Bulnes',-36.7423,-72.2985,'P','PPL','CL.06','CL.06.84',12715,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3897774,'CL','Buin','Buin',-33.7326,-70.7428,'P','PPL','CL.12','CL.12.134',55441,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3899361,'CL','Arica','Arica',-18.4746,-70.2979,'P','PPLA','CL.16','CL.16.151',185999,'America/Santiago',1,'2012-12-04 23:00:00','2012-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3899462,'CL','Arauco','Arauco',-37.2463,-73.3175,'P','PPL','CL.06','CL.06.82',24659,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3899539,'CL','Antofagasta','Antofagasta',-23.6524,-70.3954,'P','PPLA','CL.03','CL.03.21',309832,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3899629,'CL','Angol','Angol',-37.7952,-72.7164,'P','PPL','CL.04','CL.04.92',44856,'America/Santiago',1,'2013-03-12 23:00:00','2013-03-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3899695,'CL','Ancud','Ancud',-41.8707,-73.8162,'P','PPL','CL.14','CL.14.102',28020,'America/Santiago',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6458708,'CL','Las Animas','Las Animas',-39.8087,-73.2182,'P','PPL','CL.14',NULL,30000,'America/Santiago',1,'2007-04-14 23:00:00','2007-04-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7281017,'CL','La Pintana','La Pintana',-33.5833,-70.6342,'P','PPL','CL.12','CL.12.131',201178,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7281020,'CL','Lo Prado','Lo Prado',-33.4443,-70.7255,'P','PPL','CL.12','CL.12.131',104316,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7874740,'CL','Villa Presidente Frei, Ñuñoa, Santiago, Chile','Villa Presidente Frei, Nunoa, Santiago, Chile',-33.4607,-70.5802,'P','PPLX','CL.12','CL.12.131',15000,'America/Santiago',1,'2012-05-02 23:00:00','2012-05-02 23:00:00');


