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

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

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

/*!40000 ALTER TABLE `<<prefix>>subadmin1` DISABLE KEYS */;
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.33','LV','Ventspils Rajons','Ventspils Rajons',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.32','LV','Ventspils','Ventspils',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.31','LV','Valmiera','Valmiera',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.30','LV','Valka','Valka',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.29','LV','Tukuma novads','Tukuma novads',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.28','LV','Talsi Municipality','Talsi Municipality',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.27','LV','Saldus Rajons','Saldus Rajons',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.25','LV','Riga','Riga',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.24','LV','Rēzeknes Novads','Rezeknes Novads',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.23','LV','Rēzekne','Rezekne',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.22','LV','Preiļu novads','Preilu novads',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.21','LV','Ogre','Ogre',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.20','LV','Madona Municipality','Madona Municipality',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.19','LV','Ludzas novads','Ludzas novads',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.18','LV','Limbažu novads','Limbazu novads',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.16','LV','Liepāja','Liepaja',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.15','LV','Kuldīgas novads','Kuldigas novads',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.14','LV','Krāslavas novads','Kraslavas novads',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.13','LV','Jūrmala','Jurmala',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.12','LV','Jelgavas novads','Jelgavas novads',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.11','LV','Jelgava','Jelgava',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.10','LV','Jēkabpils Municipality','Jekabpils Municipality',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.09','LV','Gulbenes novads','Gulbenes novads',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.08','LV','Dobeles novads','Dobeles novads',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.07','LV','Daugavpils municipality','Daugavpils municipality',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.06','LV','Daugavpils','Daugavpils',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.05','LV','Cēsu Rajons','Cesu Rajons',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.04','LV','Bauskas Rajons','Bauskas Rajons',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.03','LV','Balvu Novads','Balvu Novads',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.02','LV','Alūksnes Novads','Aluksnes Novads',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.01','LV','Aizkraukles novads','Aizkraukles novads',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.60','LV','Dundaga','Dundaga',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.40','LV','Alsunga','Alsunga',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.A5','LV','Pāvilostas','Pavilostas',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.99','LV','Nīca','Nica',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.B6','LV','Rucavas','Rucavas',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.65','LV','Grobiņa','Grobina',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.61','LV','Durbe','Durbe',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.37','LV','Aizpute','Aizpute',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.A8','LV','Priekule','Priekule',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.D7','LV','Vaiņode','Vainode',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.C9','LV','Skrunda','Skrunda',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.51','LV','Brocēni','Broceni',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.B4','LV','Rojas','Rojas',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.77','LV','Kandava','Kandava',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.44','LV','Auces','Auces',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.73','LV','Jaunpils','Jaunpils',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.62','LV','Engure','Engure',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.D5','LV','Tērvete','Tervete',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.A3','LV','Ozolnieku','Ozolnieku',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.B9','LV','Rundāles','Rundales',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.45','LV','Babīte','Babite',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.95','LV','Mārupe','Marupe',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.A2','LV','Olaine','Olaine',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.67','LV','Lecava','Lecava',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.80','LV','Ķekava','Kekava',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.C3','LV','Salaspils','Salaspils',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.46','LV','Baldone','Baldone',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.D2','LV','Stopiņi','Stopini',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.53','LV','Carnikava','Carnikava',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.34','LV','Ādaži','Adazi',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.64','LV','Garkalne','Garkalne',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.E4','LV','Vecumnieki','Vecumnieki',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.79','LV','Ķegums','Kegums',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.87','LV','Lielvārde','Lielvarde',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.C8','LV','Skrīveri','Skriveri',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.71','LV','Jaunjelgava','Jaunjelgava',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.98','LV','Nereta','Nereta',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.E6','LV','Viesīte','Viesite',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.C2','LV','Salas','Salas',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.74','LV','Jēkabpils','Jekabpils',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.38','LV','Aknīste','Akniste',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.69','LV','Ilūkste','Ilukste',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.E2','LV','Vārkava','Varkava',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.90','LV','Līvāni','Livani',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.E1','LV','Varakļāni','Varaklani',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.E8','LV','Vilanu','Vilanu',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.B3','LV','Riebiņu','Riebinu',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.35','LV','Aglona','Aglona',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.56','LV','Cibla','Cibla',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.E9','LV','Zilupes','Zilupes',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.E7','LV','Viļaka','Vilaka',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.47','LV','Baltinava','Baltinava',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.57','LV','Dagda','Dagda',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.78','LV','Karsava','Karsava',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.B7','LV','Rugāju','Rugaju',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.55','LV','Cesvaine','Cesvaine',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.91','LV','Lubāna','Lubana',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.85','LV','Krustpils','Krustpils',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.A6','LV','Pļaviņu','Plavinu',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.82','LV','Koknese','Koknese',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.68','LV','Ikšķile','Ikskile',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.B5','LV','Ropažu','Ropazu',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.70','LV','Inčukalns','Incukalns',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.84','LV','Krimulda','Krimulda',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.C7','LV','Sigulda','Sigulda',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.88','LV','Līgatne','Ligatne',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.94','LV','Mālpils','Malpils',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.C6','LV','Sēja','Seja',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.C5','LV','Saulkrastu','Saulkrastu',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.C1','LV','Salacgrīvas','Salacgrivas',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.39','LV','Aloja','Aloja',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.97','LV','Naukšēni','Naukseni',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.B8','LV','Rūjienas','Rujienas',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.96','LV','Mazsalaca','Mazsalaca',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.52','LV','Burtnieki','Burtnieki',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.A4','LV','Pārgaujas','Pargaujas',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.81','LV','Kocēni','Koceni',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.42','LV','Amatas','Amatas',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.A9','LV','Priekuļi','Priekuli',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.B1','LV','Raunas','Raunas',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.D3','LV','Strenči','Strenci',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.50','LV','Beverīna','Beverina',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.D1','LV','Smiltene','Smiltene',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.72','LV','Jaunpiebalga','Jaunpiebalga',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.63','LV','Ērgļi','Ergli',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.E3','LV','Vecpiebalga','Vecpiebalga',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.43','LV','Apes','Apes',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('LV.F1','LV','Mesraga','Mesraga',1);
/*!40000 ALTER TABLE `<<prefix>>subadmin1` ENABLE KEYS */;

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

/*!40000 ALTER TABLE `<<prefix>>subadmin2` DISABLE KEYS */;
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.01.0320201','LV','LV.01','Aizkraukle','Aizkraukle',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.35.0604372','LV','LV.35','Kastuļinas pagasts','Kastulinas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.35.0604394','LV','LV.35','Šķeltovas pagasts','Skeltovas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.01.0320244','LV','LV.01','Aizkraukles pagasts','Aizkraukles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.37.0640605','LV','LV.37','Aizpute','Aizpute',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.37.0640642','LV','LV.37','Aizputes pagasts','Aizputes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.37.0640648','LV','LV.37','Cīravas pagasts','Ciravas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.37.0640666','LV','LV.37','Kalvenes pagasts','Kalvenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.37.0640668','LV','LV.37','Kazdangas pagasts','Kazdangas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.02.0360276','LV','LV.02','Mārkalnes pagasts','Markalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.37.0640672','LV','LV.37','Lažas pagasts','Lazas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.38.0560825','LV','LV.38','Aknīstes pagasts','Aknistes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.38.0560844','LV','LV.38','Asares pagasts','Asares pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.38.0560862','LV','LV.38','Gārsenes pagasts','Garsenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.39.0661007','LV','LV.39','Aloja','Aloja',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.39.0661027','LV','LV.39','Alojas pagasts','Alojas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.39.0661044','LV','LV.39','Braslavas pagasts','Braslavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.39.0661048','LV','LV.39','Brīvzemnieku pagasts','Brivzemnieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.39.0661017','LV','LV.39','Staicele','Staicele',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.39.0661037','LV','LV.39','Staiceles pagasts','Staiceles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.40.0624200','LV','LV.40','Alsungas novads','Alsungas novads',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.02.0360201','LV','LV.02','Alūksne','Aluksne',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.02.0360242','LV','LV.02','Alsviķu pagasts','Alsviku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.02.0360244','LV','LV.02','Annas pagasts','Annas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.02.0360252','LV','LV.02','Ilzenes pagasts','Ilzenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.02.0360280','LV','LV.02','Pededzes pagasts','Pededzes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.02.0360256','LV','LV.02','Jaunalūksnes pagasts','Jaunaluksnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.02.0360258','LV','LV.02','Jaunannas pagasts','Jaunannas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.02.0360260','LV','LV.02','Jaunlaicenes pagasts','Jaunlaicenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.02.0360264','LV','LV.02','Kalncempju pagasts','Kalncempju pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.02.0360268','LV','LV.02','Liepnas pagasts','Liepnas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.02.0360272','LV','LV.02','Malienas pagasts','Malienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.02.0360274','LV','LV.02','Mālupes pagasts','Malupes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.02.0360288','LV','LV.02','Veclaicenes pagasts','Veclaicenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.02.0360294','LV','LV.02','Zeltiņu pagasts','Zeltinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.02.0360296','LV','LV.02','Ziemera pagasts','Ziemera pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C9.0621209','LV','LV.C9','Skrunda','Skrunda',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.42.0424742','LV','LV.42','Amatas pagasts','Amatas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.42.0424746','LV','LV.42','Drabešu pagasts','Drabesu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.42.0424768','LV','LV.42','Nītaures pagasts','Nitaures pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.42.0424778','LV','LV.42','Skujenes pagasts','Skujenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.42.0424796','LV','LV.42','Zaubes pagasts','Zaubes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.44.0460805','LV','LV.44','Auce','Auce',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.43.0360805','LV','LV.43','Ape','Ape',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.44.0460850','LV','LV.44','Bēnes pagasts','Benes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.43.0360825','LV','LV.43','Apes pagasts','Apes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.43.0360848','LV','LV.43','Gaujienas pagasts','Gaujienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.43.0360884','LV','LV.43','Trapenes pagasts','Trapenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.43.0360890','LV','LV.43','Virešu pagasts','Viresu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.44.0460864','LV','LV.44','Īles pagasts','Iles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.44.0460876','LV','LV.44','Lielauces pagasts','Lielauces pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.44.0460890','LV','LV.44','Ukru pagasts','Ukru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.44.0460825','LV','LV.44','Vecauces pagasts','Vecauces pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.44.0460894','LV','LV.44','Vītiņu pagasts','Vitinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.45.0804948','LV','LV.45','Babītes pagasts','Babites pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.45.0804988','LV','LV.45','Salas pagasts','Salas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.46.0800625','LV','LV.46','Baldones pagasts','Baldones pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.47.0384400','LV','LV.47','Baltinavas novads','Baltinavas novads',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.03.0380246','LV','LV.03','Balvu pagasts','Balvu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.03.0380248','LV','LV.03','Bērzkalnes pagasts','Berzkalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.03.0380250','LV','LV.03','Bērzpils pagasts','Berzpils pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.03.0380252','LV','LV.03','Briežuciema pagasts','Briezuciema pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.03.0380256','LV','LV.03','Krišjāņu pagasts','Krisjanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.03.0380258','LV','LV.03','Kubulu pagasts','Kubulu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.03.0380266','LV','LV.03','Lazdulejas pagasts','Lazdulejas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.03.0380286','LV','LV.03','Tilžas pagasts','Tilzas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.03.0380290','LV','LV.03','Vectilžas pagasts','Vectilzas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.03.0380294','LV','LV.03','Vīksnas pagasts','Viksnas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.04.0400201','LV','LV.04','Bauska','Bauska',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.04.0400246','LV','LV.04','Brunavas pagasts','Brunavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.04.0400250','LV','LV.04','Ceraukstes pagasts','Ceraukstes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.09.0500201','LV','LV.09','Gulbene','Gulbene',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.04.0400252','LV','LV.04','Codes pagasts','Codes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.04.0400256','LV','LV.04','Dāviņu pagasts','Davinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.04.0400260','LV','LV.04','Gailīšu pagasts','Gailisu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.04.0400268','LV','LV.04','Īslīces pagasts','Islices pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.04.0400272','LV','LV.04','Mežotnes pagasts','Mezotnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.04.0400292','LV','LV.04','Vecsaules pagasts','Vecsaules pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.50.0964746','LV','LV.50','Brenguļu pagasts','Brengulu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.50.0964762','LV','LV.50','Kauguru pagasts','Kauguru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.50.0964784','LV','LV.50','Trikātas pagasts','Trikatas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.51.0840644','LV','LV.51','Blīdenes pagasts','Blidenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.51.0840605','LV','LV.51','Brocēni','Broceni',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.51.0840625','LV','LV.51','Cieceres pagasts','Cieceres pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.51.0840652','LV','LV.51','Gaiķu pagasts','Gaiku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.51.0840680','LV','LV.51','Remtes pagasts','Remtes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.52.0967148','LV','LV.52','Burtnieku pagasts','Burtnieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.52.0967154','LV','LV.52','Ēveles pagasts','Eveles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.52.0967170','LV','LV.52','Matīšu pagasts','Matisu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.52.0967178','LV','LV.52','Rencēnu pagasts','Rencenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.52.0967190','LV','LV.52','Valmieras pagasts','Valmieras pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.05.0420201','LV','LV.05','Cēsis','Cesis',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.52.0967192','LV','LV.52','Vecates pagasts','Vecates pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.53.0805200','LV','LV.53','Carnikavas novads','Carnikavas novads',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.05.0420290','LV','LV.05','Vaives pagasts','Vaives pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.55.0700807','LV','LV.55','Cesvaine','Cesvaine',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.55.0700827','LV','LV.55','Cesvaines pagasts','Cesvaines pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.56.0684944','LV','LV.56','Blontu pagasts','Blontu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.56.0684948','LV','LV.56','Ciblas pagasts','Ciblas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.56.0684966','LV','LV.56','Līdumnieku pagasts','Lidumnieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.56.0684990','LV','LV.56','Pušmucovas pagasts','Pusmucovas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.56.0684998','LV','LV.56','Zvirgzdenes pagasts','Zvirgzdenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.57.0601042','LV','LV.57','Andrupenes pagasts','Andrupenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.69.0440807','LV','LV.69','Ilūkste','Ilukste',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.57.0601044','LV','LV.57','Andzeļu pagasts','Andzelu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.70.0801817','LV','LV.70','Vangaži','Vangazi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.57.0601046','LV','LV.57','Asūnes pagasts','Asunes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.57.0601050','LV','LV.57','Bērziņu pagasts','Berzinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.57.0601009','LV','LV.57','Dagda','Dagda',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440242','LV','LV.07','Ambeļu pagasts','Ambelu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.57.0601054','LV','LV.57','Dagdas pagasts','Dagdas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.57.0601056','LV','LV.57','Ezernieku pagasts','Ezernieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.57.0601080','LV','LV.57','Ķepovas pagasts','Kepovas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.57.0601076','LV','LV.57','Konstantinovas pagasts','Konstantinovas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.57.0601092','LV','LV.57','Šķaunes pagasts','Skaunes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.57.0601090','LV','LV.57','Svariņu pagasts','Svarinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.06.0050000','LV','LV.06','Daugavpils','Daugavpils',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440246','LV','LV.07','Biķernieku pagasts','Bikernieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440250','LV','LV.07','Demenes pagasts','Demenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440252','LV','LV.07','Dubnas pagasts','Dubnas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.08.0460201','LV','LV.08','Dobele','Dobele',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.12.0540258','LV','LV.12','Kalnciema pagasts','Kalnciema pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440260','LV','LV.07','Kalkūnes pagasts','Kalkunes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440262','LV','LV.07','Kalupes pagasts','Kalupes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440264','LV','LV.07','Laucesas pagasts','Laucesas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.08.0460252','LV','LV.08','Bērzes pagasts','Berzes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440268','LV','LV.07','Līksnas pagasts','Liksnas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440270','LV','LV.07','Maļinovas pagasts','Malinovas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E8.0781848','LV','LV.E8','Dekšāres pagasts','Deksares pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440272','LV','LV.07','Medumu pagasts','Medumu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440274','LV','LV.07','Naujenes pagasts','Naujenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440276','LV','LV.07','Nīcgales pagasts','Nicgales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440284','LV','LV.07','Salienas pagasts','Salienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440286','LV','LV.07','Skrudalienas pagasts','Skrudalienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440288','LV','LV.07','Sventes pagasts','Sventes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440292','LV','LV.07','Tabores pagasts','Tabores pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440294','LV','LV.07','Vaboles pagasts','Vaboles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440296','LV','LV.07','Vecsalienas pagasts','Vecsalienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.07.0440298','LV','LV.07','Višķu pagasts','Visku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.08.0460242','LV','LV.08','Annenieku pagasts','Annenieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.08.0460246','LV','LV.08','Auru pagasts','Auru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.08.0460254','LV','LV.08','Bikstu pagasts','Bikstu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.08.0460260','LV','LV.08','Dobeles pagasts','Dobeles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.61.0640807','LV','LV.61','Durbe','Durbe',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.08.0460268','LV','LV.08','Jaunbērzes pagasts','Jaunberzes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.08.0460272','LV','LV.08','Krimūnu pagasts','Krimunu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.08.0460280','LV','LV.08','Naudītes pagasts','Naudites pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.08.0460284','LV','LV.08','Penkules pagasts','Penkules pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.71.0321050','LV','LV.71','Daudzeses pagasts','Daudzeses pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.08.0460298','LV','LV.08','Zebrenes pagasts','Zebrenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.33.0980233','LV','LV.33','Piltenes pagasts','Piltenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.60.0885150','LV','LV.60','Dundagas pagasts','Dundagas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.60.0885162','LV','LV.60','Kolkas pagasts','Kolkas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.61.0640850','LV','LV.61','Dunalkas pagasts','Dunalkas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.61.0640827','LV','LV.61','Durbes pagasts','Durbes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.61.0640888','LV','LV.61','Tadaiķu pagasts','Tadaiku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.61.0640894','LV','LV.61','Vecpils pagasts','Vecpils pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.73.0905790','LV','LV.73','Viesatu pagasts','Viesatu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.62.0905150','LV','LV.62','Engures pagasts','Engures pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.62.0905166','LV','LV.62','Lapmežciema pagasts','Lapmezciema pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.71.0321007','LV','LV.71','Jaunjelgava','Jaunjelgava',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.62.0905182','LV','LV.62','Smārdes pagasts','Smardes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.63.0705554','LV','LV.63','Ērgļu pagasts','Erglu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.63.0705560','LV','LV.63','Jumurdas pagasts','Jumurdas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.63.0705592','LV','LV.63','Sausnējas pagasts','Sausnejas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.71.0321027','LV','LV.71','Jaunjelgavas pagasts','Jaunjelgavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.64.0806000','LV','LV.64','Garkalnes novads','Garkalnes novads',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.65.0641044','LV','LV.65','Bārtas pagasts','Bartas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.65.0641056','LV','LV.65','Gaviezes pagasts','Gaviezes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.65.0641060','LV','LV.65','Grobiņas pagasts','Grobinas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E8.0781817','LV','LV.E8','Viļāni','Vilani',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.65.0641076','LV','LV.65','Medzes pagasts','Medzes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.09.0500244','LV','LV.09','Beļavas pagasts','Belavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.09.0500248','LV','LV.09','Daukstu pagasts','Daukstu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.09.0500252','LV','LV.09','Druvienas pagasts','Druvienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.09.0500256','LV','LV.09','Galgauskas pagasts','Galgauskas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.09.0500260','LV','LV.09','Jaungulbenes pagasts','Jaungulbenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.09.0500264','LV','LV.09','Lejasciema pagasts','Lejasciema pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.68.0740605','LV','LV.68','Ikšķile','Ikskile',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.09.0500276','LV','LV.09','Līgo pagasts','Ligo pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.09.0500268','LV','LV.09','Litenes pagasts','Litenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.09.0500272','LV','LV.09','Lizuma pagasts','Lizuma pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.09.0500284','LV','LV.09','Rankas pagasts','Rankas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.09.0500288','LV','LV.09','Stāmerienas pagasts','Stamerienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.09.0500290','LV','LV.09','Stradu pagasts','Stradu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.69.0440815','LV','LV.69','Subate','Subate',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.09.0500294','LV','LV.09','Tirzas pagasts','Tirzas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.69.0440856','LV','LV.69','Eglaines pagasts','Eglaines pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.69.0440890','LV','LV.69','Šēderes pagasts','Sederes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.67.0406400','LV','LV.67','Iecavas novads','Iecavas novads',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.68.0740625','LV','LV.68','Tīnūžu pagasts','Tinuzu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.72.0425798','LV','LV.72','Zosēnu pagasts','Zosenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.69.0440844','LV','LV.69','Bebrenes pagasts','Bebrenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.69.0440854','LV','LV.69','Dvietes pagasts','Dvietes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.69.0440880','LV','LV.69','Pilskalnes pagasts','Pilskalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.69.0440835','LV','LV.69','Prodes pagasts','Prodes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.70.0801864','LV','LV.70','Inčukalna pagasts','Incukalna pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.71.0321078','LV','LV.71','Seces pagasts','Seces pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.71.0321080','LV','LV.71','Sērenes pagasts','Serenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.71.0321084','LV','LV.71','Staburaga pagasts','Staburaga pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.71.0321086','LV','LV.71','Sunākstes pagasts','Sunakstes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.72.0425756','LV','LV.72','Jaunpiebalgas pagasts','Jaunpiebalgas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.73.0905756','LV','LV.73','Jaunpils pagasts','Jaunpils pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.74.0110000','LV','LV.74','Jēkabpils','Jekabpils',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.10.0560248','LV','LV.10','Ābeļu pagasts','Abelu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.10.0560252','LV','LV.10','Dignājas pagasts','Dignajas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.10.0560254','LV','LV.10','Dunavas pagasts','Dunavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.10.0560266','LV','LV.10','Kalna pagasts','Kalna pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.10.0560274','LV','LV.10','Leimaņu pagasts','Leimanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.10.0560282','LV','LV.10','Rubenes pagasts','Rubenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.10.0560298','LV','LV.10','Zasas pagasts','Zasas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.11.0090000','LV','LV.11','Jelgava','Jelgava',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.12.0540248','LV','LV.12','Elejas pagasts','Elejas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.12.0540252','LV','LV.12','Glūdas pagasts','Gludas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.12.0540256','LV','LV.12','Jaunsvirlaukas pagasts','Jaunsvirlaukas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.12.0540260','LV','LV.12','Lielplatones pagasts','Lielplatones pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.12.0540262','LV','LV.12','Līvbērzes pagasts','Livberzes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880286','LV','LV.28','Strazdes pagasts','Strazdes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.78.0681009','LV','LV.78','Kārsava','Karsava',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.12.0540270','LV','LV.12','Platones pagasts','Platones pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.12.0540274','LV','LV.12','Sesavas pagasts','Sesavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.12.0540282','LV','LV.12','Svētes pagasts','Svetes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.12.0540286','LV','LV.12','Valgundes pagasts','Valgundes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.12.0540290','LV','LV.12','Vilces pagasts','Vilces pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.12.0540292','LV','LV.12','Vircavas pagasts','Vircavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.90.0761282','LV','LV.90','Sutru pagasts','Sutru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.12.0540296','LV','LV.12','Zaļenieku pagasts','Zalenieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.13.0130000','LV','LV.13','Jūrmala','Jurmala',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.77.0901244','LV','LV.77','Cēres pagasts','Ceres pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.77.0901211','LV','LV.77','Kandava','Kandava',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.77.0901262','LV','LV.77','Kandavas pagasts','Kandavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.77.0901270','LV','LV.77','Matkules pagasts','Matkules pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.77.0901288','LV','LV.77','Vānes pagasts','Vanes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.77.0901292','LV','LV.77','Zantes pagasts','Zantes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.77.0901294','LV','LV.77','Zemītes pagasts','Zemites pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.78.0681054','LV','LV.78','Goliševas pagasts','Golisevas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.78.0681068','LV','LV.78','Malnavas pagasts','Malnavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.78.0681072','LV','LV.78','Mērdzenes pagasts','Merdzenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.78.0681070','LV','LV.78','Mežvidu pagasts','Mezvidu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.82.0326154','LV','LV.82','Iršu pagasts','Irsu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.78.0681094','LV','LV.78','Salnavas pagasts','Salnavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A2.0801009','LV','LV.A2','Olaine','Olaine',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.79.0741044','LV','LV.79','Birzgales pagasts','Birzgales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.79.0741009','LV','LV.79','Ķegums','Kegums',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.79.0741084','LV','LV.79','Rembates pagasts','Rembates pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.79.0741029','LV','LV.79','Tomes pagasts','Tomes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.80.0800807','LV','LV.80','Baloži','Balozi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.80.0800856','LV','LV.80','Daugmales pagasts','Daugmales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.82.0326146','LV','LV.82','Bebru pagasts','Bebru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.87.0741413','LV','LV.87','Lielvārde','Lielvarde',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.80.0800870','LV','LV.80','Ķekavas pagasts','Kekavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.81.0960244','LV','LV.81','Bērzaines pagasts','Berzaines pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.81.0960252','LV','LV.81','Dikļu pagasts','Diklu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.88.0421211','LV','LV.88','Līgatne','Ligatne',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.81.0960264','LV','LV.81','Kocēnu pagasts','Kocenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.81.0960288','LV','LV.81','Vaidavas pagasts','Vaidavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.81.0960296','LV','LV.81','Zilākalna pagasts','Zilakalna pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.87.0741433','LV','LV.87','Lielvārdes pagasts','Lielvardes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.82.0326160','LV','LV.82','Kokneses pagasts','Kokneses pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.14.0600248','LV','LV.14','Aulejas pagasts','Aulejas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.14.0600262','LV','LV.14','Indras pagasts','Indras pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.85.0566970','LV','LV.85','Kūku pagasts','Kuku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.14.0600264','LV','LV.14','Izvaltas pagasts','Izvaltas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.14.0600268','LV','LV.14','Kalniešu pagasts','Kalniesu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.14.0600270','LV','LV.14','Kaplavas pagasts','Kaplavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.14.0600274','LV','LV.14','Kombuļu pagasts','Kombulu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.14.0600201','LV','LV.14','Krāslava','Kraslava',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.14.0600278','LV','LV.14','Krāslavas pagasts','Kraslavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.14.0600284','LV','LV.14','Piedrujas pagasts','Piedrujas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.14.0600286','LV','LV.14','Robežnieku pagasts','Robeznieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.16.0170000','LV','LV.16','Liepāja','Liepaja',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.14.0600288','LV','LV.14','Skaistas pagasts','Skaistas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.14.0600296','LV','LV.14','Ūdrīšu pagasts','Udrisu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.84.0806968','LV','LV.84','Krimuldas pagasts','Krimuldas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.15.0620290','LV','LV.15','Snēpeles pagasts','Snepeles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.31.0250000','LV','LV.31','Valmiera','Valmiera',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.84.0806956','LV','LV.84','Lēdurgas pagasts','Ledurgas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.85.0566946','LV','LV.85','Atašienes pagasts','Atasienes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.85.0566968','LV','LV.85','Krustpils pagasts','Krustpils pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.85.0566976','LV','LV.85','Mežāres pagasts','Mezares pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.87.0741448','LV','LV.87','Jumpravas pagasts','Jumpravas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.15.0620254','LV','LV.15','Īvandes pagasts','Ivandes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.85.0566994','LV','LV.85','Variešu pagasts','Variesu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.85.0566996','LV','LV.85','Vīpes pagasts','Vipes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.15.0620246','LV','LV.15','Ēdoles pagasts','Edoles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.33.0980260','LV','LV.33','Puzes pagasts','Puzes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.15.0620250','LV','LV.15','Gudenieku pagasts','Gudenieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.15.0620274','LV','LV.15','Pelču pagasts','Pelcu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.15.0620258','LV','LV.15','Kabiles pagasts','Kabiles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.15.0620201','LV','LV.15','Kuldīga','Kuldiga',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.15.0620260','LV','LV.15','Kurmāles pagasts','Kurmales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.15.0620264','LV','LV.15','Laidu pagasts','Laidu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.15.0620272','LV','LV.15','Padures pagasts','Padures pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.15.0620280','LV','LV.15','Rendas pagasts','Rendas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.15.0620284','LV','LV.15','Rumbas pagasts','Rumbas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.15.0620292','LV','LV.15','Turlavas pagasts','Turlavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.15.0620296','LV','LV.15','Vārmes pagasts','Varmes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.87.0741464','LV','LV.87','Lēdmanes pagasts','Ledmanes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.88.0421262','LV','LV.88','Līgatnes pagasts','Ligatnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.18.0660252','LV','LV.18','Katvaru pagasts','Katvaru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.18.0660201','LV','LV.18','Limbaži','Limbazi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.18.0660264','LV','LV.18','Limbažu pagasts','Limbazu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.18.0660268','LV','LV.18','Pāles pagasts','Pales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.18.0660276','LV','LV.18','Skultes pagasts','Skultes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.90.0761268','LV','LV.90','Rudzātu pagasts','Rudzatu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.18.0660280','LV','LV.18','Umurgas pagasts','Umurgas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.18.0660284','LV','LV.18','Vidrižu pagasts','Vidrizu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.18.0660288','LV','LV.18','Viļķenes pagasts','Vilkenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.90.0761286','LV','LV.90','Turku pagasts','Turku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.90.0761252','LV','LV.90','Jersikas pagasts','Jersikas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.90.0761211','LV','LV.90','Līvāni','Livani',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.90.0761266','LV','LV.90','Rožupes pagasts','Rozupes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.91.0701458','LV','LV.91','Indrānu pagasts','Indranu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.91.0701413','LV','LV.91','Lubāna','Lubana',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.19.0680246','LV','LV.19','Briģu pagasts','Brigu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.19.0680250','LV','LV.19','Cirmas pagasts','Cirmas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.19.0680258','LV','LV.19','Isnaudas pagasts','Isnaudas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.19.0680260','LV','LV.19','Istras pagasts','Istras pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.19.0680201','LV','LV.19','Ludza','Ludza',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.19.0680278','LV','LV.19','Nirzas pagasts','Nirzas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.19.0680280','LV','LV.19','Ņukšu pagasts','Nuksu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.19.0680286','LV','LV.19','Pildas pagasts','Pildas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.19.0680288','LV','LV.19','Pureņu pagasts','Purenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.19.0680292','LV','LV.19','Rundēnu pagasts','Rundenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.20.0700242','LV','LV.20','Aronas pagasts','Aronas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.20.0700244','LV','LV.20','Barkavas pagasts','Barkavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.20.0700246','LV','LV.20','Bērzaunes pagasts','Berzaunes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.20.0700250','LV','LV.20','Dzelzavas pagasts','Dzelzavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.20.0700262','LV','LV.20','Kalsnavas pagasts','Kalsnavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.20.0700270','LV','LV.20','Ļaudonas pagasts','Laudonas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.20.0700266','LV','LV.20','Lazdonas pagasts','Lazdonas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.95.0807600','LV','LV.95','Mārupes novads','Marupes novads',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.20.0700290','LV','LV.20','Sarkaņu pagasts','Sarkanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.20.0700268','LV','LV.20','Liezēres pagasts','Liezeres pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.20.0700201','LV','LV.20','Madona','Madona',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.20.0700274','LV','LV.20','Mārcienas pagasts','Marcienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.20.0700276','LV','LV.20','Mētrienas pagasts','Metrienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.21.0740201','LV','LV.21','Ogre','Ogre',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.20.0700282','LV','LV.20','Ošupes pagasts','Osupes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.20.0700286','LV','LV.20','Praulienas pagasts','Praulienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880201','LV','LV.28','Talsi','Talsi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.20.0700296','LV','LV.20','Vestienas pagasts','Vestienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.94.0807400','LV','LV.94','Mālpils novads','Malpils novads',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.96.0961031','LV','LV.96','Mazsalacas pagasts','Mazsalacas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E6.0561815','LV','LV.E6','Viesīte','Viesite',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.96.0961076','LV','LV.96','Ramatas pagasts','Ramatas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.96.0961082','LV','LV.96','Sēļu pagasts','Selu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.96.0961084','LV','LV.96','Skaņkalnes pagasts','Skankalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.F1.0887600','LV','LV.F1','Mērsraga novads','Mersraga novads',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.97.0967366','LV','LV.97','Ķoņu pagasts','Konu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.97.0967372','LV','LV.97','Naukšēnu pagasts','Nauksenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A5.0641413','LV','LV.A5','Pāvilosta','Pavilosta',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.98.0327166','LV','LV.98','Mazzalves pagasts','Mazzalves pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.98.0327170','LV','LV.98','Neretas pagasts','Neretas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.33.0980213','LV','LV.33','Piltene','Piltene',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.98.0327174','LV','LV.98','Pilskalnes pagasts','Pilskalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.98.0327196','LV','LV.98','Zalves pagasts','Zalves pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880217','LV','LV.28','Valdemārpils','Valdemarpils',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.99.0647978','LV','LV.99','Nīcas pagasts','Nicas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A6.0321413','LV','LV.A6','Pļaviņas','Plavinas',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.99.0647980','LV','LV.99','Otaņķu pagasts','Otanku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.21.0740256','LV','LV.21','Ķeipenes pagasts','Keipenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.21.0740252','LV','LV.21','Krapes pagasts','Krapes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.21.0740260','LV','LV.21','Lauberes pagasts','Lauberes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.21.0740268','LV','LV.21','Madlienas pagasts','Madlienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.21.0740272','LV','LV.21','Mazozolu pagasts','Mazozolu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.22.0760201','LV','LV.22','Preiļi','Preili',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780246','LV','LV.24','Čornajas pagasts','Cornajas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.21.0740276','LV','LV.21','Meņģeles pagasts','Mengeles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.21.0740280','LV','LV.21','Ogresgala pagasts','Ogresgala pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.21.0740288','LV','LV.21','Suntažu pagasts','Suntazu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.21.0740292','LV','LV.21','Taurupes pagasts','Taurupes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.33.0980290','LV','LV.33','Ziru pagasts','Ziru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A2.0801080','LV','LV.A2','Olaines pagasts','Olaines pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A3.0546744','LV','LV.A3','Cenu pagasts','Cenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A3.0546778','LV','LV.A3','Salgales pagasts','Salgales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A4.0427574','LV','LV.A4','Raiskuma pagasts','Raiskuma pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.33.0980294','LV','LV.33','Zlēku pagasts','Zleku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.23.0210000','LV','LV.23','Rēzekne','Rezekne',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A4.0427580','LV','LV.A4','Stalbes pagasts','Stalbes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A4.0427582','LV','LV.A4','Straupes pagasts','Straupes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.22.0760274','LV','LV.22','Saunas pagasts','Saunas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A5.0641486','LV','LV.A5','Sakas pagasts','Sakas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A5.0641496','LV','LV.A5','Vērgales pagasts','Vergales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A6.0321442','LV','LV.A6','Aiviekstes pagasts','Aiviekstes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A6.0321458','LV','LV.A6','Klintaines pagasts','Klintaines pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A6.0321492','LV','LV.A6','Vietalvas pagasts','Vietalvas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.22.0760244','LV','LV.22','Aizkalnes pagasts','Aizkalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.22.0760256','LV','LV.22','Pelēču pagasts','Pelecu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.22.0760258','LV','LV.22','Preiļu pagasts','Preilu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780274','LV','LV.24','Nagļu pagasts','Naglu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A8.0641646','LV','LV.A8','Bunkas pagasts','Bunkas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A8.0641658','LV','LV.A8','Gramzdas pagasts','Gramzdas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A8.0641664','LV','LV.A8','Kalētu pagasts','Kaletu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A8.0641682','LV','LV.A8','Priekules pagasts','Priekules pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B9.0407788','LV','LV.B9','Svitenes pagasts','Svitenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A8.0641698','LV','LV.A8','Virgas pagasts','Virgas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A9.0427360','LV','LV.A9','Liepas pagasts','Liepas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A9.0427364','LV','LV.A9','Mārsnēnu pagasts','Marsnenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A9.0427372','LV','LV.A9','Priekuļu pagasts','Priekulu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A9.0427394','LV','LV.A9','Veselavas pagasts','Veselavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B1.0427748','LV','LV.B1','Drustu pagasts','Drustu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B1.0427776','LV','LV.B1','Raunas pagasts','Raunas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780242','LV','LV.24','Audriņu pagasts','Audrinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780244','LV','LV.24','Bērzgales pagasts','Berzgales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780250','LV','LV.24','Dricānu pagasts','Dricanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780252','LV','LV.24','Feimaņu pagasts','Feimanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780254','LV','LV.24','Gaigalavas pagasts','Gaigalavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780256','LV','LV.24','Griškānu pagasts','Griskanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C1.0661405','LV','LV.C1','Ainaži','Ainazi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780258','LV','LV.24','Ilzeskalna pagasts','Ilzeskalna pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780260','LV','LV.24','Kantinieku pagasts','Kantinieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780262','LV','LV.24','Kaunatas pagasts','Kaunatas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780266','LV','LV.24','Lendžu pagasts','Lendzu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780268','LV','LV.24','Lūznavas pagasts','Luznavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780272','LV','LV.24','Mākoņkalna pagasts','Makonkalna pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780270','LV','LV.24','Maltas pagasts','Maltas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B8.0961615','LV','LV.B8','Rūjiena','Rujiena',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B8.0961668','LV','LV.B8','Lodes pagasts','Lodes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780284','LV','LV.24','Nautrēnu pagasts','Nautrenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780276','LV','LV.24','Ozolaines pagasts','Ozolaines pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780278','LV','LV.24','Ozolmuižas pagasts','Ozolmuizas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780280','LV','LV.24','Pušas pagasts','Pusas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780282','LV','LV.24','Rikavas pagasts','Rikavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780286','LV','LV.24','Sakstagala pagasts','Sakstagala pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C1.0661425','LV','LV.C1','Ainažu pagasts','Ainazu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780288','LV','LV.24','Silmalas pagasts','Silmalas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C3.0801211','LV','LV.C3','Salaspils','Salaspils',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780292','LV','LV.24','Stoļerovas pagasts','Stolerovas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780294','LV','LV.24','Stružānu pagasts','Struzanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.24.0780296','LV','LV.24','Vērēmu pagasts','Veremu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B3.0766348','LV','LV.B3','Galēnu pagasts','Galenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B3.0766362','LV','LV.B3','Riebiņu pagasts','Riebinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B3.0766370','LV','LV.B3','Rušonas pagasts','Rusonas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B3.0766376','LV','LV.B3','Silajāņu pagasts','Silajanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D1.0941674','LV','LV.D1','Palsmanes pagasts','Palsmanes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B3.0766378','LV','LV.B3','Sīļukalna pagasts','Silukalna pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B3.0766380','LV','LV.B3','Stabulnieku pagasts','Stabulnieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B9.0407796','LV','LV.B9','Viesturu pagasts','Viesturu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.27.0840201','LV','LV.27','Saldus','Saldus',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.25.0010000','LV','LV.25','Rīga','Riga',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B4.0888301','LV','LV.B4','Rojas novads','Rojas novads',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B8.0961658','LV','LV.B8','Jeru pagasts','Jeru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B5.0808400','LV','LV.B5','Ropažu novads','Ropazu novads',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C7.0801615','LV','LV.C7','Sigulda','Sigulda',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B6.0648552','LV','LV.B6','Dunikas pagasts','Dunikas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B6.0648584','LV','LV.B6','Rucavas pagasts','Rucavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B7.0387564','LV','LV.B7','Lazdukalna pagasts','Lazdukalna pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B7.0387574','LV','LV.B7','Rugāju pagasts','Rugaju pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B8.0961656','LV','LV.B8','Ipiķu pagasts','Ipiku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B8.0961694','LV','LV.B8','Vilpulkas pagasts','Vilpulkas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.B9.0407776','LV','LV.B9','Rundāles pagasts','Rundales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C1.0661460','LV','LV.C1','Liepupes pagasts','Liepupes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C1.0661415','LV','LV.C1','Salacgrīva','Salacgriva',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C1.0661435','LV','LV.C1','Salacgrīvas pagasts','Salacgrivas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C2.0568786','LV','LV.C2','Salas pagasts','Salas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C2.0568790','LV','LV.C2','Sēlpils pagasts','Selpils pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C9.0621282','LV','LV.C9','Rudbāržu pagasts','Rudbarzu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C3.0801231','LV','LV.C3','Salaspils pagasts','Salaspils pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.27.0840248','LV','LV.27','Ezeres pagasts','Ezeres pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.27.0840256','LV','LV.27','Jaunauces pagasts','Jaunauces pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.27.0840258','LV','LV.27','Jaunlutriņu pagasts','Jaunlutrinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.27.0840262','LV','LV.27','Kursīšu pagasts','Kursisu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.27.0840266','LV','LV.27','Lutriņu pagasts','Lutrinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D1.0941615','LV','LV.D1','Smiltene','Smiltene',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.27.0840270','LV','LV.27','Nīgrandes pagasts','Nigrandes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C7.0801666','LV','LV.C7','Mores pagasts','Mores pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.27.0840272','LV','LV.27','Novadnieku pagasts','Novadnieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.27.0840276','LV','LV.27','Pampāļu pagasts','Pampalu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D3.0941813','LV','LV.D3','Seda','Seda',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D3.0941817','LV','LV.D3','Strenči','Strenci',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.27.0840282','LV','LV.27','Rubas pagasts','Rubas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.27.0840286','LV','LV.27','Saldus pagasts','Saldus pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D1.0941680','LV','LV.D1','Smiltenes pagasts','Smiltenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.27.0840288','LV','LV.27','Šķēdes pagasts','Skedes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.27.0840292','LV','LV.27','Vadakstes pagasts','Vadakstes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.27.0840294','LV','LV.27','Zaņas pagasts','Zanas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880258','LV','LV.28','Īves pagasts','Ives pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.27.0840296','LV','LV.27','Zirņu pagasts','Zirnu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.27.0840298','LV','LV.27','Zvārdes pagasts','Zvardes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C5.0801413','LV','LV.C5','Saulkrasti','Saulkrasti',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C5.0801433','LV','LV.C5','Saulkrastu pagasts','Saulkrastu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C6.0809200','LV','LV.C6','Sējas novads','Sejas novads',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C7.0801642','LV','LV.C7','Allažu pagasts','Allazu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C7.0801694','LV','LV.C7','Siguldas pagasts','Siguldas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C8.0328200','LV','LV.C8','Skrīveru novads','Skriveru novads',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C9.0621268','LV','LV.C9','Nīkrāces pagasts','Nikraces pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C9.0621278','LV','LV.C9','Raņķu pagasts','Ranku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D1.0941690','LV','LV.D1','Variņu pagasts','Varinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.C9.0621229','LV','LV.C9','Skrundas pagasts','Skrundas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D1.0941644','LV','LV.D1','Bilskas pagasts','Bilskas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D1.0941646','LV','LV.D1','Blomes pagasts','Blomes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D1.0941648','LV','LV.D1','Brantu pagasts','Brantu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D1.0941658','LV','LV.D1','Grundzāles pagasts','Grundzales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D1.0941670','LV','LV.D1','Launkalnes pagasts','Launkalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D2.0809600','LV','LV.D2','Stopiņu novads','Stopinu novads',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D3.0941860','LV','LV.D3','Jērcēnu pagasts','Jercenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D3.0941876','LV','LV.D3','Plāņu pagasts','Planu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880242','LV','LV.28','Abavas pagasts','Abavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880237','LV','LV.28','Ārlavas pagasts','Arlavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880246','LV','LV.28','Balgales pagasts','Balgales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.30.0940266','LV','LV.30','Kārķu pagasts','Karku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880254','LV','LV.28','Ģibuļu pagasts','Gibulu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880264','LV','LV.28','Ķūļciema pagasts','Kulciema pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880268','LV','LV.28','Laidzes pagasts','Laidzes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880270','LV','LV.28','Laucienes pagasts','Laucienes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E1.0701878','LV','LV.E1','Murmastienes pagasts','Murmastienes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880272','LV','LV.28','Lībagu pagasts','Libagu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880274','LV','LV.28','Lubes pagasts','Lubes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880213','LV','LV.28','Sabile','Sabile',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880215','LV','LV.28','Stende','Stende',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880292','LV','LV.28','Valdgales pagasts','Valdgales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E6.0561858','LV','LV.E6','Elkšņu pagasts','Elksnu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E3.0429350','LV','LV.E3','Dzērbenes pagasts','Dzerbenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880294','LV','LV.28','Vandzenes pagasts','Vandzenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.28.0880296','LV','LV.28','Virbu pagasts','Virbu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D5.0468944','LV','LV.D5','Augstkalnes pagasts','Augstkalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D5.0468956','LV','LV.D5','Bukaišu pagasts','Bukaisu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D5.0468988','LV','LV.D5','Tērvetes pagasts','Tervetes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E4.0409580','LV','LV.E4','Skaistkalnes pagasts','Skaistkalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.29.0900246','LV','LV.29','Degoles pagasts','Degoles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.29.0900248','LV','LV.29','Džūkstes pagasts','Dzukstes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.29.0900254','LV','LV.29','Irlavas pagasts','Irlavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.29.0900258','LV','LV.29','Jaunsātu pagasts','Jaunsatu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E6.0561880','LV','LV.E6','Rites pagasts','Rites pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.29.0900274','LV','LV.29','Pūres pagasts','Pures pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.29.0900278','LV','LV.29','Sēmes pagasts','Semes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.29.0900280','LV','LV.29','Slampes pagasts','Slampes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.29.0900201','LV','LV.29','Tukums','Tukums',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.29.0900284','LV','LV.29','Tumes pagasts','Tumes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.29.0900296','LV','LV.29','Zentenes pagasts','Zentenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E6.0561888','LV','LV.E6','Saukas pagasts','Saukas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D7.0649354','LV','LV.D7','Embūtes pagasts','Embutes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.D7.0649392','LV','LV.D7','Vaiņodes pagasts','Vainodes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E4.0409544','LV','LV.E4','Bārbeles pagasts','Barbeles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.30.0940252','LV','LV.30','Ērģemes pagasts','Ergemes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.30.0940288','LV','LV.30','Valkas pagasts','Valkas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.30.0940292','LV','LV.30','Vijciema pagasts','Vijciema pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E8.0781890','LV','LV.E8','Sokolku pagasts','Sokolku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.30.0940296','LV','LV.30','Zvārtavas pagasts','Zvartavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E1.0701817','LV','LV.E1','Varakļāni','Varaklani',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E1.0701894','LV','LV.E1','Varakļānu pagasts','Varaklanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E2.0769164','LV','LV.E2','Rožkalnu pagasts','Rozkalnu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E2.0769190','LV','LV.E2','Upmalas pagasts','Upmalas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E2.0769194','LV','LV.E2','Vārkavas pagasts','Varkavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E3.0429354','LV','LV.E3','Inešu pagasts','Inesu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E3.0429358','LV','LV.E3','Kaives pagasts','Kaives pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E3.0429386','LV','LV.E3','Taurenes pagasts','Taurenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E3.0429392','LV','LV.E3','Vecpiebalgas pagasts','Vecpiebalgas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E4.0409562','LV','LV.E4','Kurmenes pagasts','Kurmenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E4.0409584','LV','LV.E4','Stelpes pagasts','Stelpes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.34.0804400','LV','LV.34','Ādažu novads','Adazu novads',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.35.0604342','LV','LV.35','Aglonas pagasts','Aglonas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.35.0604358','LV','LV.35','Grāveru pagasts','Graveru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.38.0560805','LV','LV.38','Aknīste','Akniste',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.03.0380201','LV','LV.03','Balvi','Balvi',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.46.0800605','LV','LV.46','Baldone','Baldone',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.65.0641009','LV','LV.65','Grobiņa','Grobina',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.96.0961011','LV','LV.96','Mazsalaca','Mazsalaca',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A3.0546766','LV','LV.A3','Ozolnieku pagasts','Ozolnieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.A8.0641615','LV','LV.A8','Priekule','Priekule',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.29.0900268','LV','LV.29','Lestenes pagasts','Lestenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.30.0940201','LV','LV.30','Valka','Valka',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.33.0980256','LV','LV.33','Popes pagasts','Popes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E7.0381660','LV','LV.E7','Kupravas pagasts','Kupravas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E7.0381615','LV','LV.E7','Viļaka','Vilaka',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E4.0409590','LV','LV.E4','Valles pagasts','Valles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E4.0409594','LV','LV.E4','Vecumnieku pagasts','Vecumnieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.32.0270000','LV','LV.32','Ventspils','Ventspils',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.33.0980244','LV','LV.33','Ances pagasts','Ances pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.33.0980250','LV','LV.33','Jūrkalnes pagasts','Jurkalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E9.0681817','LV','LV.E9','Zilupe','Zilupe',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.33.0980266','LV','LV.33','Tārgales pagasts','Targales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.33.0980270','LV','LV.33','Ugāles pagasts','Ugales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.33.0980274','LV','LV.33','Usmas pagasts','Usmas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.33.0980278','LV','LV.33','Užavas pagasts','Uzavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.33.0980284','LV','LV.33','Vārves pagasts','Varves pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E6.0561835','LV','LV.E6','Viesītes pagasts','Viesites pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E7.0381670','LV','LV.E7','Medņevas pagasts','Mednevas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E7.0381682','LV','LV.E7','Šķilbēnu pagasts','Skilbenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E7.0381678','LV','LV.E7','Susāju pagasts','Susaju pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E7.0381692','LV','LV.E7','Vecumu pagasts','Vecumu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E7.0381698','LV','LV.E7','Žīguru pagasts','Ziguru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E8.0781898','LV','LV.E8','Viļānu pagasts','Vilanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E9.0681864','LV','LV.E9','Lauderu pagasts','Lauderu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E9.0681884','LV','LV.E9','Pasienes pagasts','Pasienes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('LV.E9.0681896','LV','LV.E9','Zaļesjes pagasts','Zalesjes pagasts',1);
/*!40000 ALTER TABLE `<<prefix>>subadmin2` ENABLE KEYS */;

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

/*!40000 ALTER TABLE `<<prefix>>cities` DISABLE KEYS */;
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Valmiera','Valmiera',25.4275,57.5411,'P','PPLA','LV.31','LV.31.0250000',26963,'Europe/Riga',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Zilupe','Zilupe',28.1217,56.3862,'P','PPLA','LV.E9','LV.E9.0681817',1897,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Zelmeņi','Zelmeni',23.3519,56.4517,'P','PPLA','LV.D5','LV.D5.0468988',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Viļaka','Vilaka',27.6722,57.1846,'P','PPLA','LV.E7','LV.E7.0381615',1525,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Viļāni','Vilani',26.9245,56.5525,'P','PPLA','LV.E8','LV.E8.0781817',3934,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Viesīte','Viesite',25.5551,56.3475,'P','PPLA','LV.E6','LV.E6.0561815',2162,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Vecumnieki','Vecumnieki',24.5223,56.6061,'P','PPLA','LV.E4','LV.E4.0409594',2487,'Europe/Riga',1,'2017-12-05 23:00:00','2017-12-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Ventspils','Ventspils',21.5612,57.3949,'P','PPLA','LV.32','LV.32.0270000',42644,'Europe/Riga',1,'2019-11-24 23:00:00','2019-11-24 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Vecvārkava','Vecvarkava',26.5081,56.1984,'P','PPLA','LV.E2','LV.E2.0769190',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Vecpiebalga','Vecpiebalga',25.8162,57.0609,'P','PPLA','LV.E3','LV.E3.0429392',596,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Varakļāni','Varaklani',26.7538,56.6083,'P','PPLA','LV.E1','LV.E1.0701817',2106,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Valka','Valka',26.0101,57.7752,'P','PPLA','LV.30','LV.30.0940201',6589,'Europe/Riga',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Vaiņode','Vainode',21.854,56.4185,'P','PPLA','LV.D7','LV.D7.0649392',0,'Europe/Riga',1,'2018-05-07 23:00:00','2018-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Ulbroka','Ulbroka',24.3039,56.9363,'P','PPLA','LV.D2','LV.D2.0809600',2800,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Tukums','Tukums',23.1555,56.9676,'P','PPLA','LV.29','LV.29.0900201',18348,'Europe/Riga',1,'2020-05-06 23:00:00','2020-05-06 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Talsi','Talsi',22.5814,57.2456,'P','PPLA','LV.28','LV.28.0880201',12022,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Strenči','Strenci',25.6854,57.6257,'P','PPLA','LV.D3','LV.D3.0941817',1593,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Stalbe','Stalbe',25.0311,57.3707,'P','PPLA','LV.A4','LV.A4.0427580',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Smiltene','Smiltene',25.9016,57.4244,'P','PPLA','LV.D1','LV.D1.0941615',6108,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Smārde','Smarde',23.3374,56.9542,'P','PPLA','LV.62','LV.62.0905182',734,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Skrunda','Skrunda',22.0165,56.6775,'P','PPLA','LV.C9','LV.C9.0621209',2659,'Europe/Riga',1,'2018-05-07 23:00:00','2018-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Skrīveri','Skriveri',25.1206,56.645,'P','PPLA','LV.C8','LV.C8.0328200',2879,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Sigulda','Sigulda',24.8595,57.1538,'P','PPLA','LV.C7','LV.C7.0801615',10422,'Europe/Riga',1,'2018-03-05 23:00:00','2018-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Saulkrasti','Saulkrasti',24.4147,57.2622,'P','PPLA','LV.C5','LV.C5.0801413',3184,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Saldus','Saldus',22.4881,56.6636,'P','PPLA','LV.27','LV.27.0840201',12224,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Salaspils','Salaspils',24.3654,56.8601,'P','PPLA','LV.C3','LV.C3.0801211',17606,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Salacgrīva','Salacgriva',24.3589,57.7531,'P','PPLA','LV.C1','LV.C1.0661415',3427,'Europe/Riga',1,'2018-03-05 23:00:00','2018-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Sala','Sala',25.7642,56.5067,'P','PPLA','LV.C2','LV.C2.0568786',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Rūjiena','Rujiena',25.3316,57.8975,'P','PPLA','LV.B8','LV.B8.0961615',3638,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Rugāji','Rugaji',27.1337,57.0033,'P','PPLA','LV.B7','LV.B7.0387574',0,'Europe/Riga',1,'2017-07-31 23:00:00','2017-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Rucava','Rucava',21.1616,56.1631,'P','PPLA','LV.B6','LV.B6.0648584',547,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Garkalne','Garkalne',24.4195,57.0449,'P','PPLA','LV.64','LV.64.0806000',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Ropaži','Ropazi',24.6329,56.9747,'P','PPLA','LV.B5','LV.B5.0808400',0,'Europe/Riga',1,'2018-05-07 23:00:00','2018-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Roja','Roja',22.8088,57.5015,'P','PPLA','LV.B4','LV.B4.0888301',1800,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Riga','Riga',24.1059,56.946,'P','PPLC','LV.25','LV.25.0010000',742572,'Europe/Riga',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Riebiņi','Riebini',26.7999,56.3428,'P','PPLA','LV.B3','LV.B3.0766362',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Rēzekne','Rezekne',27.34,56.5103,'P','PPLA','LV.23','LV.23.0210000',38340,'Europe/Riga',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Rauna','Rauna',25.6095,57.3317,'P','PPLA','LV.B1','LV.B1.0427776',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Ragana','Ragana',24.7073,57.1807,'P','PPLA','LV.84','LV.84.0806968',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Priekuļi','Priekuli',25.3615,57.315,'P','PPLA','LV.A9','LV.A9.0427372',2532,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Priekule','Priekule',21.5897,56.4468,'P','PPLA','LV.A8','LV.A8.0641615',2550,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Preiļi','Preili',26.7246,56.2944,'P','PPLA','LV.22','LV.22.0760201',8656,'Europe/Riga',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Pļaviņas','Plavinas',25.7255,56.6178,'P','PPLA','LV.A6','LV.A6.0321413',3848,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Piņķi','Pinki',23.9137,56.9419,'P','PPLA','LV.45','LV.45.0804948',3033,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Pilsrundāle','Pilsrundale',24.0163,56.4181,'P','PPLA','LV.B9','LV.B9.0407776',0,'Europe/Riga',1,'2018-05-07 23:00:00','2018-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Pāvilosta','Pavilosta',21.1859,56.8879,'P','PPLA','LV.A5','LV.A5.0641413',1171,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Ozolnieki','Ozolnieki',23.7761,56.6899,'P','PPLA','LV.A3','LV.A3.0546766',3400,'Europe/Riga',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Olaine','Olaine',23.9358,56.7947,'P','PPLA','LV.A2','LV.A2.0801009',12584,'Europe/Riga',1,'2018-03-05 23:00:00','2018-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Ogre','Ogre',24.614,56.8162,'P','PPLA','LV.21','LV.21.0740201',26760,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Nīca','Nica',21.064,56.346,'P','PPLA','LV.99','LV.99.0647978',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Nereta','Nereta',25.3075,56.2028,'P','PPLA','LV.98','LV.98.0327170',1282,'Europe/Riga',1,'2020-05-06 23:00:00','2020-05-06 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Naukšēni','Naukseni',25.4561,57.8835,'P','PPLA','LV.97','LV.97.0967372',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Mūrmuiža','Murmuiza',25.4917,57.4731,'P','PPLA','LV.50','LV.50.0964762',0,'Europe/Riga',1,'2017-12-05 23:00:00','2017-12-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Mērsrags','Mersrags',23.1245,57.3354,'P','PPLA','LV.F1','LV.F1.0887600',1860,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Mazsalaca','Mazsalaca',25.0548,57.8633,'P','PPLA','LV.96','LV.96.0961011',2412,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Matīši','Matisi',25.1589,57.6989,'P','PPLA','LV.52','LV.52.0967170',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Mālpils','Malpils',24.9578,57.0101,'P','PPLA','LV.94','LV.94.0807400',0,'Europe/Riga',1,'2019-02-19 23:00:00','2019-02-19 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Madona','Madona',26.217,56.8533,'P','PPLA','LV.20','LV.20.0700201',9280,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Ludza','Ludza',27.7189,56.5396,'P','PPLA','LV.19','LV.19.0680201',10514,'Europe/Riga',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Lubāna','Lubana',26.7161,56.9043,'P','PPLA','LV.91','LV.91.0701413',1918,'Europe/Riga',1,'2017-07-31 23:00:00','2017-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Loja','Loja',24.6433,57.1534,'P','PPLA','LV.C6','LV.C6.0809200',0,'Europe/Riga',1,'2018-03-05 23:00:00','2018-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Līvāni','Livani',26.1758,56.3543,'P','PPLA','LV.90','LV.90.0761211',10073,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Limbaži','Limbazi',24.7194,57.5129,'P','PPLA','LV.18','LV.18.0660201',8974,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Līgatne','Ligatne',25.0406,57.2343,'P','PPLA','LV.88','LV.88.0421211',1433,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Liepāja','Liepaja',21.0109,56.5047,'P','PPLA','LV.16','LV.16.0170000',85132,'Europe/Riga',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Lielvārde','Lielvarde',24.8074,56.7207,'P','PPLA','LV.87','LV.87.0741413',5114,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Lieģi','Liegi',21.334,56.5817,'P','PPLA','LV.61','LV.61.0640888',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Kuldīga','Kuldiga',21.9572,56.974,'P','PPLA','LV.15','LV.15.0620201',13289,'Europe/Riga',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Krustpils','Krustpils',25.8612,56.5107,'P','PPL','LV.10',NULL,6680,'Europe/Riga',1,'2015-11-02 23:00:00','2015-11-02 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Krāslava','Kraslava',27.168,55.8951,'P','PPLA','LV.14','LV.14.0600201',11088,'Europe/Riga',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Koknese','Koknese',25.4364,56.6516,'P','PPLA','LV.82','LV.82.0326160',0,'Europe/Riga',1,'2017-11-06 23:00:00','2017-11-06 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Kocēni','Koceni',25.3382,57.5206,'P','PPLA','LV.81','LV.81.0960264',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Ķekava','Kekava',24.23,56.8266,'P','PPLA','LV.80','LV.80.0800870',4600,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Ķegums','Kegums',24.7244,56.7451,'P','PPLA','LV.79','LV.79.0741009',2372,'Europe/Riga',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Kārsava','Karsava',27.6883,56.784,'P','PPLA','LV.78','LV.78.0681009',2645,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Karosta','Karosta',21.0129,56.5513,'P','PPLX','LV.16','LV.16.0170000',7500,'Europe/Riga',1,'2018-01-08 23:00:00','2018-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Kandava','Kandava',22.7747,57.0409,'P','PPLA','LV.77','LV.77.0901211',3592,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Jūrmala','Jurmala',23.7704,56.968,'P','PPLA','LV.13','LV.13.0130000',54088,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Jelgava','Jelgava',23.7128,56.65,'P','PPLA','LV.11','LV.11.0090000',61791,'Europe/Riga',1,'2019-02-25 23:00:00','2019-02-25 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Jēkabpils','Jekabpils',25.8573,56.499,'P','PPLA','LV.10',NULL,27078,'Europe/Riga',1,'2019-02-25 23:00:00','2019-02-25 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Jaunpils','Jaunpils',23.0125,56.7314,'P','PPLA','LV.73','LV.73.0905756',1029,'Europe/Riga',1,'2018-05-07 23:00:00','2018-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Jaunpiebalga','Jaunpiebalga',26.0284,57.1774,'P','PPLA','LV.72','LV.72.0425756',0,'Europe/Riga',1,'2018-11-06 23:00:00','2018-11-06 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Jaunjelgava','Jaunjelgava',25.0832,56.6132,'P','PPLA','LV.71','LV.71.0321007',1938,'Europe/Riga',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Inčukalns','Incukalns',24.6863,57.0987,'P','PPLA','LV.70','LV.70.0801864',2028,'Europe/Riga',1,'2018-05-07 23:00:00','2018-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Ilūkste','Ilukste',26.2966,55.9775,'P','PPLA','LV.69','LV.69.0440807',2898,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Ikšķile','Ikskile',24.4968,56.834,'P','PPLA','LV.68','LV.68.0740605',3368,'Europe/Riga',1,'2018-05-07 23:00:00','2018-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Iecava','Iecava',24.2076,56.5977,'P','PPLA','LV.67','LV.67.0406400',4000,'Europe/Riga',1,'2018-05-07 23:00:00','2018-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Gulbene','Gulbene',26.7529,57.1777,'P','PPLA','LV.09','LV.09.0500201',9355,'Europe/Riga',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Grobiņa','Grobina',21.1678,56.5352,'P','PPLA','LV.65','LV.65.0641009',4203,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Cibla','Cibla',27.8837,56.5498,'P','PPLA','LV.56','LV.56.0684948',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Ērgļi','Ergli',25.6367,56.8975,'P','PPLA','LV.63','LV.63.0705554',2186,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Dundaga','Dundaga',22.3504,57.505,'P','PPLA','LV.60','LV.60.0885150',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Drabeši','Drabesi',25.2775,57.2432,'P','PPLA','LV.42','LV.42.0424746',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Dobele','Dobele',23.2751,56.6237,'P','PPLA','LV.08','LV.08.0460201',11225,'Europe/Riga',1,'2018-08-06 23:00:00','2018-08-06 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Daugavpils','Daugavpils',26.5333,55.8833,'P','PPLA','LV.07',NULL,111564,'Europe/Riga',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Daugavgrīva','Daugavgriva',24.0361,57.0432,'P','PPLX','LV.25','LV.25.0010000',9952,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Dagda','Dagda',27.5372,56.0951,'P','PPLA','LV.57','LV.57.0601009',2740,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Cesvaine','Cesvaine',26.3076,56.9675,'P','PPLA','LV.55','LV.55.0700807',1811,'Europe/Riga',1,'2017-10-02 23:00:00','2017-10-02 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Cēsis','Cesis',25.2746,57.3119,'P','PPLA','LV.05','LV.05.0420201',18198,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Carnikava','Carnikava',24.2842,57.1293,'P','PPLA','LV.53','LV.53.0805200',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Brocēni','Broceni',22.5695,56.6789,'P','PPLA','LV.51','LV.51.0840625',3486,'Europe/Riga',1,'2018-05-07 23:00:00','2018-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Bolderaja','Bolderaja',24.0557,57.0313,'P','PPLX','LV.25','LV.25.0010000',14771,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Berģi','Bergi',24.2992,56.9864,'P','PPLA','LV.25','LV.25.0010000',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Bauska','Bauska',24.1944,56.4079,'P','PPLA','LV.04','LV.04.0400201',10532,'Europe/Riga',1,'2020-05-06 23:00:00','2020-05-06 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Balvi','Balvi',27.2658,57.1313,'P','PPLA','LV.03','LV.03.0380201',8409,'Europe/Riga',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Baltinava','Baltinava',27.644,56.9439,'P','PPLA','LV.47','LV.47.0384400',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Baldone','Baldone',24.4008,56.7445,'P','PPLA','LV.46','LV.46.0800605',2025,'Europe/Riga',1,'2017-12-05 23:00:00','2017-12-05 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Auce','Auce',22.9017,56.4598,'P','PPLA','LV.44','LV.44.0460805',3125,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Ape','Ape',26.6929,57.5393,'P','PPLA','LV.43','LV.43.0360805',1521,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Alūksne','Aluksne',27.0466,57.4216,'P','PPLA','LV.02','LV.02.0360201',2264,'Europe/Riga',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Alsunga','Alsunga',21.5594,56.9819,'P','PPLA','LV.40','LV.40.0624200',940,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Aloja','Aloja',24.8774,57.7672,'P','PPLA','LV.39','LV.39.0661007',1509,'Europe/Riga',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Aknīste','Akniste',25.7478,56.1615,'P','PPLA','LV.38','LV.38.0560805',1314,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Aizpute','Aizpute',21.6016,56.7211,'P','PPLA','LV.37','LV.37.0640605',5634,'Europe/Riga',1,'2018-01-08 23:00:00','2018-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Aizkraukle','Aizkraukle',25.2553,56.6048,'P','PPLA','LV.01','LV.01.0320201',8840,'Europe/Riga',1,'2020-05-06 23:00:00','2020-05-06 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Aglona','Aglona',27.0068,56.1327,'P','PPLA','LV.35','LV.35.0604342',0,'Europe/Riga',1,'2019-04-09 23:00:00','2019-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Ādaži','Adazi',24.3371,57.0704,'P','PPLA','LV.34','LV.34.0804400',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `asciiname`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','Mārupe','Marupe',24.0511,56.9054,'P','PPLA','LV.95','LV.95.0807600',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 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
