-- MySQL dump 10.13  Distrib 5.7.25, for osx10.9 (x86_64)
--
-- Host: localhost    Database: laraclassified
-- ------------------------------------------------------
-- Server version	5.7.25

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

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

/*!40000 ALTER TABLE `<<prefix>>subadmin1` DISABLE KEYS */;
INSERT INTO `<<prefix>>subadmin1` VALUES (347,'BO.09','BO','Tarija','Tarija',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (348,'BO.08','BO','Santa Cruz','Santa Cruz',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (349,'BO.07','BO','Potosí','Potosi',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (350,'BO.06','BO','Pando','Pando',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (351,'BO.05','BO','Oruro','Oruro',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (352,'BO.04','BO','La Paz','La Paz',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (353,'BO.02','BO','Cochabamba','Cochabamba',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (354,'BO.01','BO','Chuquisaca','Chuquisaca',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (355,'BO.03','BO','El Beni','El Beni',1);
/*!40000 ALTER TABLE `<<prefix>>subadmin1` ENABLE KEYS */;

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

/*!40000 ALTER TABLE `<<prefix>>subadmin2` DISABLE KEYS */;
INSERT INTO `<<prefix>>subadmin2` VALUES (2590,'BO.08.0705','BO','BO.08','Provincia Chiquitos','Provincia Chiquitos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2591,'BO.08.0712','BO','BO.08','Provincia Ángel Sandoval','Provincia Angel Sandoval',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2592,'BO.01.0103','BO','BO.01','Provincia Zudáñez','Provincia Zudanez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2593,'BO.01.0106','BO','BO.01','Provincia Yamparáez','Provincia Yamparaez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2594,'BO.03.0804','BO','BO.03','Provincia Yacuma','Provincia Yacuma',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2595,'BO.08.0702','BO','BO.08','Provincia Warnes','Provincia Warnes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2596,'BO.08.0703','BO','BO.08','Provincia Velasco','Provincia Velasco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2597,'BO.08.0708','BO','BO.08','Provincia Vallegrande','Provincia Vallegrande',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2598,'BO.03.0802','BO','BO.03','Provincia Vaca Diez','Provincia Vaca Diez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2599,'BO.01.0104','BO','BO.01','Provincia Tomina','Provincia Tomina',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2600,'BO.07.0501','BO','BO.07','Provincia Tomás Frías','Provincia Tomas Frias',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2601,'BO.05.0411','BO','BO.05','Provincia Tomás Barron','Provincia Tomas Barron',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2602,'BO.02.0311','BO','BO.02','Provincia Tapacarí','Provincia Tapacari',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2603,'BO.04.0211','BO','BO.04','Provincia Sud Yungas','Provincia Sud Yungas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2604,'BO.07.0510','BO','BO.07','Provincia Sud Lípez','Provincia Sud Lipez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2605,'BO.01.0109','BO','BO.01','Provincia Sud Cinti','Provincia Sud Cinti',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2606,'BO.07.0508','BO','BO.07','Provincia Sud Chichas','Provincia Sud Chichas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2607,'BO.05.0410','BO','BO.05','Provincia Saucari','Provincia Saucari',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2608,'BO.08.0706','BO','BO.08','Provincia Sara','Provincia Sara',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2609,'BO.08.3904660','BO','BO.08','Provincia Santiesteban','Provincia Santiesteban',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2610,'BO.05.0413','BO','BO.05','Provincia San Pedro de Totora','Provincia San Pedro de Totora',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2611,'BO.05.0404','BO','BO.05','Provincia Sajama','Provincia Sajama',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2612,'BO.07.0503','BO','BO.07','Provincia Saavedra','Provincia Saavedra',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2613,'BO.07.0502','BO','BO.07','Provincia Rafael Bustillo','Provincia Rafael Bustillo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2614,'BO.02.0309','BO','BO.02','Provincia Quillacollo','Provincia Quillacollo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2615,'BO.07.0512','BO','BO.07','Provincia Quijarro','Provincia Quijarro',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2616,'BO.02.0314','BO','BO.02','Provincia Punata','Provincia Punata',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2617,'BO.05.0406','BO','BO.05','Provincia Poopó','Provincia Poopo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2618,'BO.05.0407','BO','BO.05','Provincia Pantaleón Dalence','Provincia Pantaleon Dalence',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2619,'BO.04.0203','BO','BO.04','Provincia Pacajes','Provincia Pacajes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2620,'BO.01.0101','BO','BO.01','Provincia Oropeza','Provincia Oropeza',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2621,'BO.04.0202','BO','BO.04','Provincia Omasuyos','Provincia Omasuyos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2622,'BO.09.0606','BO','BO.09','Provincia O’Connor','Provincia O\'Connor',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2623,'BO.08.0711','BO','BO.08','Provincia Ñuflo de Chávez','Provincia Nuflo de Chavez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2624,'BO.04.0214','BO','BO.04','Provincia Nor Yungas','Provincia Nor Yungas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2625,'BO.07.0509','BO','BO.07','Provincia Nor Lípez','Provincia Nor Lipez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2626,'BO.01.0107','BO','BO.01','Provincia Nor Cinti','Provincia Nor Cinti',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2627,'BO.07.0506','BO','BO.07','Provincia Nor Chichas','Provincia Nor Chichas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2628,'BO.06.0901','BO','BO.06','Provincia Nicolás Suárez','Provincia Nicolas Suarez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2629,'BO.04.0201','BO','BO.04','Provincia Murillo','Provincia Murillo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2630,'BO.04.0205','BO','BO.04','Provincia Muñecas','Provincia Munecas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2631,'BO.03.0805','BO','BO.03','Provincia Moxos','Provincia Moxos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2632,'BO.07.0515','BO','BO.07','Provincia Modesto Omiste','Provincia Modesto Omiste',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2633,'BO.02.0313','BO','BO.02','Provincia Mizque','Provincia Mizque',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2634,'BO.09.0605','BO','BO.09','Provincia Méndez','Provincia Mendez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2635,'BO.03.0806','BO','BO.03','Provincia Marbán','Provincia Marban',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2636,'BO.06.0902','BO','BO.06','Provincia Manuripi','Provincia Manuripi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2637,'BO.08.0713','BO','BO.08','Provincia Manuel María Caballero','Provincia Manuel Maria Caballero',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2638,'BO.04.0217','BO','BO.04','Provincia Manco Kapac','Provincia Manco Kapac',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2639,'BO.03.0807','BO','BO.03','Provincia Mamoré','Provincia Mamore',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2640,'BO.06.0903','BO','BO.06','Provincia Madre de Dios','Provincia Madre de Dios',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2641,'BO.01.0110','BO','BO.01','Provincia Luis Calvo','Provincia Luis Calvo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2642,'BO.04.0212','BO','BO.04','Provincia Los Andes','Provincia Los Andes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2643,'BO.04.0209','BO','BO.04','Provincia Loayza','Provincia Loayza',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2644,'BO.05.0405','BO','BO.05','Sud Carangas Province','Sud Carangas Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2645,'BO.07.3911502','BO','BO.07','Provincia Linares','Provincia Linares',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2646,'BO.04.0206','BO','BO.04','Provincia Larecaja','Provincia Larecaja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2647,'BO.05.0408','BO','BO.05','Provincia Ladislao Cabrera','Provincia Ladislao Cabrera',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2648,'BO.04.0215','BO','BO.04','Provincia Iturralde','Provincia Iturralde',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2649,'BO.03.0808','BO','BO.03','Provincia Iténez','Provincia Itenez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2650,'BO.04.0210','BO','BO.04','Provincia Inquisivi','Provincia Inquisivi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2651,'BO.04.0208','BO','BO.04','Provincia Ingavi','Provincia Ingavi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2652,'BO.08.0704','BO','BO.08','Provincia Ichilo','Provincia Ichilo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2653,'BO.01.0105','BO','BO.01','Provincia Hernando Siles','Provincia Hernando Siles',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2654,'BO.04.0218','BO','BO.04','Provincia Gualberto Villarroel','Provincia Gualberto Villarroel',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2655,'BO.09.0603','BO','BO.09','Provincia Gran Chaco','Provincia Gran Chaco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2656,'BO.02.0308','BO','BO.02','Provincia Germán Jordán','Provincia German Jordan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2657,'BO.03.3915596','BO','BO.03','Provincia General José Ballivián','Provincia General Jose Ballivian',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2658,'BO.06.3915598','BO','BO.06','Provincia General Federico Román','Provincia General Federico Roman',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2659,'BO.07.3915603','BO','BO.07','Provincia General Bilbao','Provincia General Bilbao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2660,'BO.04.0207','BO','BO.04','Provincia Franz Tamayo','Provincia Franz Tamayo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2661,'BO.08.0709','BO','BO.08','Provincia Florida','Provincia Florida',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2662,'BO.02.0304','BO','BO.02','Provincia Esteban Arce','Provincia Esteban Arce',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2663,'BO.07.0514','BO','BO.07','Provincia Daniel Campos','Provincia Daniel Campos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2664,'BO.08.0707','BO','BO.08','Provincia Cordillera','Provincia Cordillera',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2665,'BO.07.0504','BO','BO.07','Provincia Chayanta','Provincia Chayanta',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2666,'BO.07.0505','BO','BO.07','Provincia Charcas','Provincia Charcas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2667,'BO.02.0310','BO','BO.02','Provincia Chaparé','Provincia Chapare',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2668,'BO.09.0601','BO','BO.09','Provincia Cercado','Provincia Cercado',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2669,'BO.05.0401','BO','BO.05','Provincia Cercado','Provincia Cercado',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2670,'BO.02.0301','BO','BO.02','Provincia Cercado','Provincia Cercado',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2671,'BO.03.0801','BO','BO.03','Provincia Cercado','Provincia Cercado',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2672,'BO.02.0312','BO','BO.02','Provincia Carrasco','Provincia Carrasco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2673,'BO.05.3922026','BO','BO.05','Provincia Carangas','Provincia Carangas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2674,'BO.02.0307','BO','BO.02','Provincia Capinota','Provincia Capinota',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2675,'BO.02.0302','BO','BO.02','Provincia Campero','Provincia Campero',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2676,'BO.04.0204','BO','BO.04','Provincia Camacho','Provincia Camacho',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2677,'BO.01.0108','BO','BO.01','Provincia Belisario Boeto','Provincia Belisario Boeto',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2678,'BO.04.0216','BO','BO.04','Provincia Bautista Saavedra','Provincia Bautista Saavedra',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2679,'BO.01.0102','BO','BO.01','Provincia Azurduy','Provincia Azurduy',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2680,'BO.02.0303','BO','BO.02','Provincia Ayopaya','Provincia Ayopaya',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2681,'BO.09.0604','BO','BO.09','Provincia Avilez','Provincia Avilez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2682,'BO.05.0402','BO','BO.05','Provincia Avaroa','Provincia Avaroa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2683,'BO.05.3923586','BO','BO.05','Provincia Sabaya','Provincia Sabaya',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2684,'BO.02.0306','BO','BO.02','Provincia Arque','Provincia Arque',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2685,'BO.04.0213','BO','BO.04','Provincia Aroma','Provincia Aroma',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2686,'BO.09.0602','BO','BO.09','Provincia Arce','Provincia Arce',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2687,'BO.02.0305','BO','BO.02','Provincia Arani','Provincia Arani',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2688,'BO.08.0701','BO','BO.08','Provincia Andrés Ibáñez','Provincia Andres Ibanez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2689,'BO.07.0507','BO','BO.07','Provincia Alonzo de Ibáñez','Provincia Alonzo de Ibanez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2690,'BO.06.0904','BO','BO.06','Provincia Abuná','Provincia Abuna',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2691,'BO.02.7576102','BO','BO.02','Bolivar','Bolivar',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2692,'BO.02.8335405','BO','BO.02','Tiraque Province','Tiraque Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2693,'BO.05.10400355','BO','BO.05','Nor Carangas Province','Nor Carangas Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2694,'BO.05.10400859','BO','BO.05','Sebastian Pagador Province','Sebastian Pagador Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2695,'BO.04.11184247','BO','BO.04','Caranavi','Caranavi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2696,'BO.04.11184248','BO','BO.04','José Manuel Pando','Jose Manuel Pando',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2697,'BO.05.11184249','BO','BO.05','Puerto de Mejillones','Puerto de Mejillones',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2698,'BO.05.11184250','BO','BO.05','Litoral de Atacama','Litoral de Atacama',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2699,'BO.07.11184251','BO','BO.07','Enrique Baldivieso','Enrique Baldivieso',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2700,'BO.08.11184252','BO','BO.08','German Busch','German Busch',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2701,'BO.08.11184253','BO','BO.08','Guarayos','Guarayos',1);
/*!40000 ALTER TABLE `<<prefix>>subadmin2` ENABLE KEYS */;

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

/*!40000 ALTER TABLE `<<prefix>>cities` DISABLE KEYS */;
INSERT INTO `<<prefix>>cities` VALUES (3444105,'BO','San Matías','San Matias',-16.3667,-58.4,'P','PPL','BO.08','BO.08.0712',6352,'America/La_Paz',1,'2017-02-11 23:00:00','2017-02-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3444176,'BO','Roboré','Robore',-18.3347,-59.7614,'P','PPL','BO.08','BO.08.0705',9882,'America/La_Paz',1,'2017-02-05 23:00:00','2017-02-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3444201,'BO','Puerto Quijarro','Puerto Quijarro',-17.7833,-57.7667,'P','PPL','BO.08',NULL,10392,'America/La_Paz',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3901178,'BO','Yacuiba','Yacuiba',-22.0164,-63.6775,'P','PPLA2','BO.09','BO.09.0603',82803,'America/La_Paz',1,'2014-11-29 23:00:00','2014-11-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3901301,'BO','Warnes','Warnes',-17.5163,-63.1678,'P','PPL','BO.08',NULL,22036,'America/La_Paz',1,'2015-06-11 23:00:00','2015-06-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3901501,'BO','Villazón','Villazon',-22.0866,-65.5942,'P','PPL','BO.07',NULL,30253,'America/La_Paz',1,'2019-03-31 23:00:00','2019-03-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3901504,'BO','Villa Yapacaní','Villa Yapacani',-17.4,-63.8333,'P','PPL','BO.08',NULL,18187,'America/La_Paz',1,'2012-02-01 23:00:00','2012-02-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3901547,'BO','Villamontes','Villamontes',-21.2624,-63.469,'P','PPL','BO.09',NULL,18761,'America/La_Paz',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3901874,'BO','Vallegrande','Vallegrande',-18.4892,-64.1061,'P','PPL','BO.08',NULL,8422,'America/La_Paz',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3901903,'BO','Uyuni','Uyuni',-20.4597,-66.825,'P','PPL','BO.07',NULL,10293,'America/La_Paz',1,'2013-10-26 23:00:00','2013-10-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3902202,'BO','Tupiza','Tupiza',-21.4435,-65.7188,'P','PPL','BO.07',NULL,22233,'America/La_Paz',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3902377,'BO','Trinidad','Trinidad',-14.8333,-64.9,'P','PPLA','BO.03',NULL,84259,'America/La_Paz',1,'2014-06-01 23:00:00','2014-06-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3902949,'BO','Tiquipaya','Tiquipaya',-17.338,-66.2158,'P','PPL','BO.02',NULL,53904,'America/La_Paz',1,'2017-12-13 23:00:00','2017-12-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3903320,'BO','Tarija','Tarija',-21.5355,-64.7296,'P','PPLA','BO.09',NULL,159269,'America/La_Paz',1,'2010-01-28 23:00:00','2010-01-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3903342,'BO','Tarata','Tarata',-17.609,-66.0213,'P','PPL','BO.02',NULL,8043,'America/La_Paz',1,'2013-05-07 23:00:00','2013-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3903987,'BO','Sucre','Sucre',-19.0333,-65.2627,'P','PPLC','BO.01',NULL,224838,'America/La_Paz',1,'2010-05-29 23:00:00','2010-05-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3904666,'BO','Santiago del Torno','Santiago del Torno',-17.9867,-63.3812,'P','PPL','BO.08',NULL,15543,'America/La_Paz',1,'2013-05-07 23:00:00','2013-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3904729,'BO','Santa Rosa del Sara','Santa Rosa del Sara',-17.1092,-63.5951,'P','PPL','BO.08',NULL,5251,'America/La_Paz',1,'2013-05-07 23:00:00','2013-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3904906,'BO','Santa Cruz de la Sierra','Santa Cruz de la Sierra',-17.7863,-63.1812,'P','PPLA','BO.08',NULL,1364389,'America/La_Paz',1,'2016-11-03 23:00:00','2016-11-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3905007,'BO','Santa Ana de Yacuma','Santa Ana de Yacuma',-13.7441,-65.4269,'P','PPL','BO.03',NULL,12783,'America/La_Paz',1,'2017-09-11 23:00:00','2017-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3905159,'BO','San Pedro','San Pedro',-16.2372,-68.8506,'P','PPL','BO.04',NULL,5002,'America/La_Paz',1,'2011-12-05 23:00:00','2011-12-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3905453,'BO','San Julian','San Julian',-17.7833,-62.8667,'P','PPL','BO.08',NULL,7706,'America/La_Paz',1,'2019-04-10 23:00:00','2019-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3905658,'BO','San Ignacio de Velasco','San Ignacio de Velasco',-16.3667,-60.95,'P','PPL','BO.08',NULL,23569,'America/La_Paz',1,'2017-05-07 23:00:00','2017-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3905792,'BO','San Borja','San Borja',-14.8167,-66.85,'P','PPL','BO.03',NULL,19640,'America/La_Paz',1,'2019-03-30 23:00:00','2019-03-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3906194,'BO','Sacaba','Sacaba',-17.398,-66.0383,'P','PPL','BO.02',NULL,107628,'America/La_Paz',1,'2017-12-05 23:00:00','2017-12-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3906209,'BO','Rurrenabaque','Rurrenabaque',-14.4412,-67.5278,'P','PPL','BO.03',NULL,11749,'America/La_Paz',1,'2008-03-21 23:00:00','2008-03-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3906466,'BO','Riberalta','Riberalta',-11.0065,-66.0631,'P','PPL','BO.03','BO.03.0802',74014,'America/La_Paz',1,'2016-12-20 23:00:00','2016-12-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3906478,'BO','Reyes','Reyes',-14.2952,-67.3362,'P','PPL','BO.03','BO.03.3915596',7376,'America/La_Paz',1,'2015-06-12 23:00:00','2015-06-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3906791,'BO','Quillacollo','Quillacollo',-17.3923,-66.2784,'P','PPL','BO.02',NULL,87309,'America/La_Paz',1,'2017-09-11 23:00:00','2017-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3907080,'BO','Punata','Punata',-17.5423,-65.8347,'P','PPL','BO.02',NULL,15194,'America/La_Paz',1,'2013-05-07 23:00:00','2013-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3907584,'BO','Potosí','Potosi',-19.5836,-65.7531,'P','PPLA','BO.07',NULL,141251,'America/La_Paz',1,'2017-02-11 23:00:00','2017-02-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3907646,'BO','Portachuelo','Portachuelo',-17.3517,-63.3928,'P','PPL','BO.08',NULL,11485,'America/La_Paz',1,'2013-05-07 23:00:00','2013-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3908339,'BO','Patacamaya','Patacamaya',-17.2358,-67.9217,'P','PPL','BO.04',NULL,12260,'America/La_Paz',1,'2013-05-07 23:00:00','2013-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3909010,'BO','Pailón','Pailon',-17.65,-62.75,'P','PPL','BO.08',NULL,9304,'America/La_Paz',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3909234,'BO','Oruro','Oruro',-17.9833,-67.15,'P','PPLA','BO.05',NULL,208684,'America/La_Paz',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3910027,'BO','Montero','Montero',-17.3387,-63.2505,'P','PPL','BO.08',NULL,88616,'America/La_Paz',1,'2013-05-07 23:00:00','2013-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3910094,'BO','Monteagudo','Monteagudo',-19.7999,-63.9546,'P','PPL','BO.01',NULL,8289,'America/La_Paz',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3910291,'BO','Mizque','Mizque',-17.941,-65.3402,'P','PPL','BO.02',NULL,30481,'America/La_Paz',1,'2009-10-15 23:00:00','2009-10-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3910343,'BO','Mineros','Mineros',-17.1188,-63.231,'P','PPL','BO.08',NULL,14385,'America/La_Paz',1,'2018-12-04 23:00:00','2018-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3911409,'BO','Llallagua','Llallagua',-18.4243,-66.5839,'P','PPL','BO.07',NULL,28069,'America/La_Paz',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3911925,'BO','La Paz','La Paz',-16.5,-68.15,'P','PPLG','BO.04',NULL,812799,'America/La_Paz',1,'2012-07-22 23:00:00','2012-07-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3912418,'BO','La Bélgica','La Belgica',-17.55,-63.2167,'P','PPL','BO.08',NULL,5501,'America/La_Paz',1,'2012-01-18 23:00:00','2012-01-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3914839,'BO','Huanuni','Huanuni',-18.289,-66.8358,'P','PPL','BO.05',NULL,15492,'America/La_Paz',1,'2019-03-31 23:00:00','2019-03-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3915350,'BO','Guayaramerín','Guayaramerin',-10.8258,-65.3581,'P','PPL','BO.03','BO.03.0802',36008,'America/La_Paz',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3918937,'BO','Cotoca','Cotoca',-17.8167,-63.05,'P','PPL','BO.08',NULL,18347,'America/La_Paz',1,'2019-02-20 23:00:00','2019-02-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3919352,'BO','Concepción','Concepcion',-16.4333,-60.9,'P','PPL','BO.08',NULL,6900,'America/La_Paz',1,'2019-04-10 23:00:00','2019-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3919884,'BO','Colchani','Colchani',-20.3,-66.9333,'P','PPL','BO.07',NULL,11988,'America/La_Paz',1,'2012-01-18 23:00:00','2012-01-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3919968,'BO','Cochabamba','Cochabamba',-17.3895,-66.1568,'P','PPLA','BO.02',NULL,900414,'America/La_Paz',1,'2012-01-18 23:00:00','2012-01-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3919998,'BO','Cobija','Cobija',-11.0267,-68.7692,'P','PPLA','BO.06',NULL,26585,'America/La_Paz',1,'2010-08-20 23:00:00','2010-08-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3920016,'BO','Cliza','Cliza',-17.5878,-65.9325,'P','PPL','BO.02',NULL,8654,'America/La_Paz',1,'2013-05-07 23:00:00','2013-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3920736,'BO','Chimoré','Chimore',-16.9942,-65.1533,'P','PPL','BO.02',NULL,5147,'America/La_Paz',1,'2016-10-01 23:00:00','2016-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3921355,'BO','Challapata','Challapata',-18.9021,-66.7705,'P','PPL','BO.05',NULL,8016,'America/La_Paz',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3922125,'BO','Capinota','Capinota',-17.7111,-66.2608,'P','PPL','BO.02',NULL,5157,'America/La_Paz',1,'2013-05-07 23:00:00','2013-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3922414,'BO','Camiri','Camiri',-20.0385,-63.5183,'P','PPL','BO.08',NULL,27961,'America/La_Paz',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3923154,'BO','Bermejo','Bermejo',-22.7321,-64.3372,'P','PPL','BO.09',NULL,35411,'America/La_Paz',1,'2017-12-13 23:00:00','2017-12-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3923644,'BO','Ascensión','Ascension',-15.7,-63.0833,'P','PPL','BO.08',NULL,14429,'America/La_Paz',1,'2012-01-18 23:00:00','2012-01-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3924341,'BO','Aiquile','Aiquile',-18.2041,-65.1807,'P','PPL','BO.02',NULL,8224,'America/La_Paz',1,'2009-10-15 23:00:00','2009-10-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3924610,'BO','Achacachi','Achacachi',-16.05,-68.6833,'P','PPL','BO.04',NULL,8447,'America/La_Paz',1,'2012-01-18 23:00:00','2012-01-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (9129422,'BO','Ascención de Guarayos','Ascencion de Guarayos',-15.893,-63.1885,'P','PPLL','BO.08',NULL,18816,'America/La_Paz',1,'2017-12-12 23:00:00','2017-12-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (11467676,'BO','San Borja','San Borja',-14.8519,-66.7495,'P','PPL','BO.03',NULL,24610,'America/La_Paz',1,'2017-12-12 23:00:00','2017-12-12 23:00:00');
/*!40000 ALTER TABLE `<<prefix>>cities` ENABLE KEYS */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed
