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

/*!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`, `active`) VALUES ('LV.33','LV','{\"en\":\"Ventspils Rajons\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.32','LV','{\"en\":\"Ventspils\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.31','LV','{\"en\":\"Valmiera\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.30','LV','{\"en\":\"Valka\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.29','LV','{\"en\":\"Tukuma novads\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.28','LV','{\"en\":\"Talsi Municipality\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.27','LV','{\"en\":\"Saldus Rajons\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.25','LV','{\"en\":\"Riga\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.24','LV','{\"en\":\"Rēzeknes Novads\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.23','LV','{\"en\":\"Rēzekne\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.22','LV','{\"en\":\"Preiļu novads\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.21','LV','{\"en\":\"Ogre\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.20','LV','{\"en\":\"Madona Municipality\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.19','LV','{\"en\":\"Ludzas novads\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.18','LV','{\"en\":\"Limbažu novads\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.16','LV','{\"en\":\"Liepāja\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.15','LV','{\"en\":\"Kuldīgas novads\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.14','LV','{\"en\":\"Krāslavas novads\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.13','LV','{\"en\":\"Jūrmala\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.12','LV','{\"en\":\"Jelgavas novads\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.11','LV','{\"en\":\"Jelgava\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.10','LV','{\"en\":\"Jēkabpils Municipality\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.09','LV','{\"en\":\"Gulbenes novads\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.08','LV','{\"en\":\"Dobeles novads\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.07','LV','{\"en\":\"Daugavpils municipality\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.06','LV','{\"en\":\"Daugavpils\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.05','LV','{\"en\":\"Cēsu Rajons\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.04','LV','{\"en\":\"Bauskas Rajons\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.03','LV','{\"en\":\"Balvu Novads\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.02','LV','{\"en\":\"Alūksnes Novads\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.01','LV','{\"en\":\"Aizkraukles novads\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.60','LV','{\"en\":\"Dundaga\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.40','LV','{\"en\":\"Alsunga\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.A5','LV','{\"en\":\"Pāvilostas\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.99','LV','{\"en\":\"Nīca\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.B6','LV','{\"en\":\"Rucavas\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.65','LV','{\"en\":\"Grobiņa\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.61','LV','{\"en\":\"Durbe\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.37','LV','{\"en\":\"Aizpute\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.A8','LV','{\"en\":\"Priekule\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.D7','LV','{\"en\":\"Vaiņode\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.C9','LV','{\"en\":\"Skrunda\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.51','LV','{\"en\":\"Brocēni\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.B4','LV','{\"en\":\"Rojas\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.77','LV','{\"en\":\"Kandava\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.44','LV','{\"en\":\"Auces\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.73','LV','{\"en\":\"Jaunpils\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.62','LV','{\"en\":\"Engure\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.D5','LV','{\"en\":\"Tērvete\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.A3','LV','{\"en\":\"Ozolnieku\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.B9','LV','{\"en\":\"Rundāles\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.45','LV','{\"en\":\"Babīte\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.95','LV','{\"en\":\"Mārupe\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.A2','LV','{\"en\":\"Olaine\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.67','LV','{\"en\":\"Lecava\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.80','LV','{\"en\":\"Ķekava\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.C3','LV','{\"en\":\"Salaspils\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.46','LV','{\"en\":\"Baldone\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.D2','LV','{\"en\":\"Stopiņi\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.53','LV','{\"en\":\"Carnikava\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.34','LV','{\"en\":\"Ādaži\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.64','LV','{\"en\":\"Garkalne\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.E4','LV','{\"en\":\"Vecumnieki\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.79','LV','{\"en\":\"Ķegums\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.87','LV','{\"en\":\"Lielvārde\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.C8','LV','{\"en\":\"Skrīveri\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.71','LV','{\"en\":\"Jaunjelgava\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.98','LV','{\"en\":\"Nereta\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.E6','LV','{\"en\":\"Viesīte\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.C2','LV','{\"en\":\"Salas\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.74','LV','{\"en\":\"Jēkabpils\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.38','LV','{\"en\":\"Aknīste\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.69','LV','{\"en\":\"Ilūkste\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.E2','LV','{\"en\":\"Vārkava\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.90','LV','{\"en\":\"Līvāni\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.E1','LV','{\"en\":\"Varakļāni\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.E8','LV','{\"en\":\"Vilanu\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.B3','LV','{\"en\":\"Riebiņu\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.35','LV','{\"en\":\"Aglona\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.56','LV','{\"en\":\"Cibla\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.E9','LV','{\"en\":\"Zilupes\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.E7','LV','{\"en\":\"Viļaka\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.47','LV','{\"en\":\"Baltinava\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.57','LV','{\"en\":\"Dagda\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.78','LV','{\"en\":\"Karsava\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.B7','LV','{\"en\":\"Rugāju\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.55','LV','{\"en\":\"Cesvaine\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.91','LV','{\"en\":\"Lubāna\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.85','LV','{\"en\":\"Krustpils\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.A6','LV','{\"en\":\"Pļaviņu\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.82','LV','{\"en\":\"Koknese\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.68','LV','{\"en\":\"Ikšķile\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.B5','LV','{\"en\":\"Ropažu\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.70','LV','{\"en\":\"Inčukalns\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.84','LV','{\"en\":\"Krimulda\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.C7','LV','{\"en\":\"Sigulda\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.88','LV','{\"en\":\"Līgatne\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.94','LV','{\"en\":\"Mālpils\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.C6','LV','{\"en\":\"Sēja\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.C5','LV','{\"en\":\"Saulkrastu\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.C1','LV','{\"en\":\"Salacgrīvas\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.39','LV','{\"en\":\"Aloja\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.97','LV','{\"en\":\"Naukšēni\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.B8','LV','{\"en\":\"Rūjienas\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.96','LV','{\"en\":\"Mazsalaca\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.52','LV','{\"en\":\"Burtnieki\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.A4','LV','{\"en\":\"Pārgaujas\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.81','LV','{\"en\":\"Kocēni\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.42','LV','{\"en\":\"Amatas\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.A9','LV','{\"en\":\"Priekuļi\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.B1','LV','{\"en\":\"Raunas\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.D3','LV','{\"en\":\"Strenči\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.50','LV','{\"en\":\"Beverīna\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.D1','LV','{\"en\":\"Smiltene\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.72','LV','{\"en\":\"Jaunpiebalga\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.63','LV','{\"en\":\"Ērgļi\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.E3','LV','{\"en\":\"Vecpiebalga\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.43','LV','{\"en\":\"Apes\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.F1','LV','{\"en\":\"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`, `active`) VALUES ('LV.01.0320201','LV','LV.01','{\"en\":\"Aizkraukle\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.35.0604372','LV','LV.35','{\"en\":\"Kastuļinas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.35.0604394','LV','LV.35','{\"en\":\"Šķeltovas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.01.0320244','LV','LV.01','{\"en\":\"Aizkraukles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.37.0640605','LV','LV.37','{\"en\":\"Aizpute\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.37.0640642','LV','LV.37','{\"en\":\"Aizputes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.37.0640648','LV','LV.37','{\"en\":\"Cīravas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.37.0640666','LV','LV.37','{\"en\":\"Kalvenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.37.0640668','LV','LV.37','{\"en\":\"Kazdangas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.02.0360276','LV','LV.02','{\"en\":\"Mārkalnes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.37.0640672','LV','LV.37','{\"en\":\"Lažas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.38.0560825','LV','LV.38','{\"en\":\"Aknīstes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.38.0560844','LV','LV.38','{\"en\":\"Asares pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.38.0560862','LV','LV.38','{\"en\":\"Gārsenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.39.0661007','LV','LV.39','{\"en\":\"Aloja\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.39.0661027','LV','LV.39','{\"en\":\"Alojas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.39.0661044','LV','LV.39','{\"en\":\"Braslavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.39.0661048','LV','LV.39','{\"en\":\"Brīvzemnieku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.39.0661017','LV','LV.39','{\"en\":\"Staicele\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.39.0661037','LV','LV.39','{\"en\":\"Staiceles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.40.0624200','LV','LV.40','{\"en\":\"Alsungas novads\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.02.0360201','LV','LV.02','{\"en\":\"Alūksne\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.02.0360242','LV','LV.02','{\"en\":\"Alsviķu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.02.0360244','LV','LV.02','{\"en\":\"Annas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.02.0360252','LV','LV.02','{\"en\":\"Ilzenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.02.0360280','LV','LV.02','{\"en\":\"Pededzes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.02.0360256','LV','LV.02','{\"en\":\"Jaunalūksnes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.02.0360258','LV','LV.02','{\"en\":\"Jaunannas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.02.0360260','LV','LV.02','{\"en\":\"Jaunlaicenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.02.0360264','LV','LV.02','{\"en\":\"Kalncempju pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.02.0360268','LV','LV.02','{\"en\":\"Liepnas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.02.0360272','LV','LV.02','{\"en\":\"Malienas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.02.0360274','LV','LV.02','{\"en\":\"Mālupes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.02.0360288','LV','LV.02','{\"en\":\"Veclaicenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.02.0360294','LV','LV.02','{\"en\":\"Zeltiņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.02.0360296','LV','LV.02','{\"en\":\"Ziemera pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C9.0621209','LV','LV.C9','{\"en\":\"Skrunda\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.42.0424742','LV','LV.42','{\"en\":\"Amatas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.42.0424746','LV','LV.42','{\"en\":\"Drabešu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.42.0424768','LV','LV.42','{\"en\":\"Nītaures pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.42.0424778','LV','LV.42','{\"en\":\"Skujenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.42.0424796','LV','LV.42','{\"en\":\"Zaubes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.44.0460805','LV','LV.44','{\"en\":\"Auce\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.43.0360805','LV','LV.43','{\"en\":\"Ape\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.44.0460850','LV','LV.44','{\"en\":\"Bēnes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.43.0360825','LV','LV.43','{\"en\":\"Apes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.43.0360848','LV','LV.43','{\"en\":\"Gaujienas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.43.0360884','LV','LV.43','{\"en\":\"Trapenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.43.0360890','LV','LV.43','{\"en\":\"Virešu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.44.0460864','LV','LV.44','{\"en\":\"Īles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.44.0460876','LV','LV.44','{\"en\":\"Lielauces pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.44.0460890','LV','LV.44','{\"en\":\"Ukru pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.44.0460825','LV','LV.44','{\"en\":\"Vecauces pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.44.0460894','LV','LV.44','{\"en\":\"Vītiņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.45.0804948','LV','LV.45','{\"en\":\"Babītes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.45.0804988','LV','LV.45','{\"en\":\"Salas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.46.0800625','LV','LV.46','{\"en\":\"Baldones pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.47.0384400','LV','LV.47','{\"en\":\"Baltinavas novads\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0380246','LV','LV.03','{\"en\":\"Balvu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0380248','LV','LV.03','{\"en\":\"Bērzkalnes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0380250','LV','LV.03','{\"en\":\"Bērzpils pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0380252','LV','LV.03','{\"en\":\"Briežuciema pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0380256','LV','LV.03','{\"en\":\"Krišjāņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0380258','LV','LV.03','{\"en\":\"Kubulu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0380266','LV','LV.03','{\"en\":\"Lazdulejas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0380286','LV','LV.03','{\"en\":\"Tilžas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0380290','LV','LV.03','{\"en\":\"Vectilžas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0380294','LV','LV.03','{\"en\":\"Vīksnas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0400201','LV','LV.04','{\"en\":\"Bauska\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0400246','LV','LV.04','{\"en\":\"Brunavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0400250','LV','LV.04','{\"en\":\"Ceraukstes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.09.0500201','LV','LV.09','{\"en\":\"Gulbene\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0400252','LV','LV.04','{\"en\":\"Codes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0400256','LV','LV.04','{\"en\":\"Dāviņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0400260','LV','LV.04','{\"en\":\"Gailīšu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0400268','LV','LV.04','{\"en\":\"Īslīces pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0400272','LV','LV.04','{\"en\":\"Mežotnes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0400292','LV','LV.04','{\"en\":\"Vecsaules pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.50.0964746','LV','LV.50','{\"en\":\"Brenguļu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.50.0964762','LV','LV.50','{\"en\":\"Kauguru pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.50.0964784','LV','LV.50','{\"en\":\"Trikātas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.51.0840644','LV','LV.51','{\"en\":\"Blīdenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.51.0840605','LV','LV.51','{\"en\":\"Brocēni\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.51.0840625','LV','LV.51','{\"en\":\"Cieceres pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.51.0840652','LV','LV.51','{\"en\":\"Gaiķu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.51.0840680','LV','LV.51','{\"en\":\"Remtes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.52.0967148','LV','LV.52','{\"en\":\"Burtnieku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.52.0967154','LV','LV.52','{\"en\":\"Ēveles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.52.0967170','LV','LV.52','{\"en\":\"Matīšu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.52.0967178','LV','LV.52','{\"en\":\"Rencēnu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.52.0967190','LV','LV.52','{\"en\":\"Valmieras pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0420201','LV','LV.05','{\"en\":\"Cēsis\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.52.0967192','LV','LV.52','{\"en\":\"Vecates pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.53.0805200','LV','LV.53','{\"en\":\"Carnikavas novads\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0420290','LV','LV.05','{\"en\":\"Vaives pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.55.0700807','LV','LV.55','{\"en\":\"Cesvaine\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.55.0700827','LV','LV.55','{\"en\":\"Cesvaines pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.56.0684944','LV','LV.56','{\"en\":\"Blontu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.56.0684948','LV','LV.56','{\"en\":\"Ciblas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.56.0684966','LV','LV.56','{\"en\":\"Līdumnieku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.56.0684990','LV','LV.56','{\"en\":\"Pušmucovas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.56.0684998','LV','LV.56','{\"en\":\"Zvirgzdenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.57.0601042','LV','LV.57','{\"en\":\"Andrupenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.69.0440807','LV','LV.69','{\"en\":\"Ilūkste\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.57.0601044','LV','LV.57','{\"en\":\"Andzeļu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.70.0801817','LV','LV.70','{\"en\":\"Vangaži\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.57.0601046','LV','LV.57','{\"en\":\"Asūnes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.57.0601050','LV','LV.57','{\"en\":\"Bērziņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.57.0601009','LV','LV.57','{\"en\":\"Dagda\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440242','LV','LV.07','{\"en\":\"Ambeļu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.57.0601054','LV','LV.57','{\"en\":\"Dagdas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.57.0601056','LV','LV.57','{\"en\":\"Ezernieku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.57.0601080','LV','LV.57','{\"en\":\"Ķepovas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.57.0601076','LV','LV.57','{\"en\":\"Konstantinovas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.57.0601092','LV','LV.57','{\"en\":\"Šķaunes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.57.0601090','LV','LV.57','{\"en\":\"Svariņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.06.0050000','LV','LV.06','{\"en\":\"Daugavpils\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440246','LV','LV.07','{\"en\":\"Biķernieku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440250','LV','LV.07','{\"en\":\"Demenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440252','LV','LV.07','{\"en\":\"Dubnas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460201','LV','LV.08','{\"en\":\"Dobele\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.12.0540258','LV','LV.12','{\"en\":\"Kalnciema pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440260','LV','LV.07','{\"en\":\"Kalkūnes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440262','LV','LV.07','{\"en\":\"Kalupes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440264','LV','LV.07','{\"en\":\"Laucesas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460252','LV','LV.08','{\"en\":\"Bērzes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440268','LV','LV.07','{\"en\":\"Līksnas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440270','LV','LV.07','{\"en\":\"Maļinovas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E8.0781848','LV','LV.E8','{\"en\":\"Dekšāres pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440272','LV','LV.07','{\"en\":\"Medumu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440274','LV','LV.07','{\"en\":\"Naujenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440276','LV','LV.07','{\"en\":\"Nīcgales pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440284','LV','LV.07','{\"en\":\"Salienas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440286','LV','LV.07','{\"en\":\"Skrudalienas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440288','LV','LV.07','{\"en\":\"Sventes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440292','LV','LV.07','{\"en\":\"Tabores pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440294','LV','LV.07','{\"en\":\"Vaboles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440296','LV','LV.07','{\"en\":\"Vecsalienas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.07.0440298','LV','LV.07','{\"en\":\"Višķu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460242','LV','LV.08','{\"en\":\"Annenieku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460246','LV','LV.08','{\"en\":\"Auru pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460254','LV','LV.08','{\"en\":\"Bikstu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460260','LV','LV.08','{\"en\":\"Dobeles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.61.0640807','LV','LV.61','{\"en\":\"Durbe\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460268','LV','LV.08','{\"en\":\"Jaunbērzes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460272','LV','LV.08','{\"en\":\"Krimūnu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460280','LV','LV.08','{\"en\":\"Naudītes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460284','LV','LV.08','{\"en\":\"Penkules pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.71.0321050','LV','LV.71','{\"en\":\"Daudzeses pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460298','LV','LV.08','{\"en\":\"Zebrenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.33.0980233','LV','LV.33','{\"en\":\"Piltenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.60.0885150','LV','LV.60','{\"en\":\"Dundagas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.60.0885162','LV','LV.60','{\"en\":\"Kolkas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.61.0640850','LV','LV.61','{\"en\":\"Dunalkas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.61.0640827','LV','LV.61','{\"en\":\"Durbes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.61.0640888','LV','LV.61','{\"en\":\"Tadaiķu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.61.0640894','LV','LV.61','{\"en\":\"Vecpils pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.73.0905790','LV','LV.73','{\"en\":\"Viesatu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.62.0905150','LV','LV.62','{\"en\":\"Engures pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.62.0905166','LV','LV.62','{\"en\":\"Lapmežciema pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.71.0321007','LV','LV.71','{\"en\":\"Jaunjelgava\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.62.0905182','LV','LV.62','{\"en\":\"Smārdes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.63.0705554','LV','LV.63','{\"en\":\"Ērgļu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.63.0705560','LV','LV.63','{\"en\":\"Jumurdas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.63.0705592','LV','LV.63','{\"en\":\"Sausnējas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.71.0321027','LV','LV.71','{\"en\":\"Jaunjelgavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.64.0806000','LV','LV.64','{\"en\":\"Garkalnes novads\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.65.0641044','LV','LV.65','{\"en\":\"Bārtas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.65.0641056','LV','LV.65','{\"en\":\"Gaviezes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.65.0641060','LV','LV.65','{\"en\":\"Grobiņas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E8.0781817','LV','LV.E8','{\"en\":\"Viļāni\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.65.0641076','LV','LV.65','{\"en\":\"Medzes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.09.0500244','LV','LV.09','{\"en\":\"Beļavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.09.0500248','LV','LV.09','{\"en\":\"Daukstu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.09.0500252','LV','LV.09','{\"en\":\"Druvienas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.09.0500256','LV','LV.09','{\"en\":\"Galgauskas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.09.0500260','LV','LV.09','{\"en\":\"Jaungulbenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.09.0500264','LV','LV.09','{\"en\":\"Lejasciema pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.68.0740605','LV','LV.68','{\"en\":\"Ikšķile\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.09.0500276','LV','LV.09','{\"en\":\"Līgo pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.09.0500268','LV','LV.09','{\"en\":\"Litenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.09.0500272','LV','LV.09','{\"en\":\"Lizuma pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.09.0500284','LV','LV.09','{\"en\":\"Rankas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.09.0500288','LV','LV.09','{\"en\":\"Stāmerienas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.09.0500290','LV','LV.09','{\"en\":\"Stradu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.69.0440815','LV','LV.69','{\"en\":\"Subate\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.09.0500294','LV','LV.09','{\"en\":\"Tirzas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.69.0440856','LV','LV.69','{\"en\":\"Eglaines pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.69.0440890','LV','LV.69','{\"en\":\"Šēderes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.67.0406400','LV','LV.67','{\"en\":\"Iecavas novads\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.68.0740625','LV','LV.68','{\"en\":\"Tīnūžu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.72.0425798','LV','LV.72','{\"en\":\"Zosēnu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.69.0440844','LV','LV.69','{\"en\":\"Bebrenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.69.0440854','LV','LV.69','{\"en\":\"Dvietes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.69.0440880','LV','LV.69','{\"en\":\"Pilskalnes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.69.0440835','LV','LV.69','{\"en\":\"Prodes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.70.0801864','LV','LV.70','{\"en\":\"Inčukalna pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.71.0321078','LV','LV.71','{\"en\":\"Seces pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.71.0321080','LV','LV.71','{\"en\":\"Sērenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.71.0321084','LV','LV.71','{\"en\":\"Staburaga pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.71.0321086','LV','LV.71','{\"en\":\"Sunākstes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.72.0425756','LV','LV.72','{\"en\":\"Jaunpiebalgas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.73.0905756','LV','LV.73','{\"en\":\"Jaunpils pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.74.0110000','LV','LV.74','{\"en\":\"Jēkabpils\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0560248','LV','LV.10','{\"en\":\"Ābeļu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0560252','LV','LV.10','{\"en\":\"Dignājas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0560254','LV','LV.10','{\"en\":\"Dunavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0560266','LV','LV.10','{\"en\":\"Kalna pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0560274','LV','LV.10','{\"en\":\"Leimaņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0560282','LV','LV.10','{\"en\":\"Rubenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0560298','LV','LV.10','{\"en\":\"Zasas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.11.0090000','LV','LV.11','{\"en\":\"Jelgava\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.12.0540248','LV','LV.12','{\"en\":\"Elejas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.12.0540252','LV','LV.12','{\"en\":\"Glūdas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.12.0540256','LV','LV.12','{\"en\":\"Jaunsvirlaukas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.12.0540260','LV','LV.12','{\"en\":\"Lielplatones pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.12.0540262','LV','LV.12','{\"en\":\"Līvbērzes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880286','LV','LV.28','{\"en\":\"Strazdes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.78.0681009','LV','LV.78','{\"en\":\"Kārsava\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.12.0540270','LV','LV.12','{\"en\":\"Platones pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.12.0540274','LV','LV.12','{\"en\":\"Sesavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.12.0540282','LV','LV.12','{\"en\":\"Svētes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.12.0540286','LV','LV.12','{\"en\":\"Valgundes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.12.0540290','LV','LV.12','{\"en\":\"Vilces pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.12.0540292','LV','LV.12','{\"en\":\"Vircavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.90.0761282','LV','LV.90','{\"en\":\"Sutru pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.12.0540296','LV','LV.12','{\"en\":\"Zaļenieku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.13.0130000','LV','LV.13','{\"en\":\"Jūrmala\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.77.0901244','LV','LV.77','{\"en\":\"Cēres pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.77.0901211','LV','LV.77','{\"en\":\"Kandava\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.77.0901262','LV','LV.77','{\"en\":\"Kandavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.77.0901270','LV','LV.77','{\"en\":\"Matkules pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.77.0901288','LV','LV.77','{\"en\":\"Vānes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.77.0901292','LV','LV.77','{\"en\":\"Zantes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.77.0901294','LV','LV.77','{\"en\":\"Zemītes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.78.0681054','LV','LV.78','{\"en\":\"Goliševas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.78.0681068','LV','LV.78','{\"en\":\"Malnavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.78.0681072','LV','LV.78','{\"en\":\"Mērdzenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.78.0681070','LV','LV.78','{\"en\":\"Mežvidu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.82.0326154','LV','LV.82','{\"en\":\"Iršu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.78.0681094','LV','LV.78','{\"en\":\"Salnavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A2.0801009','LV','LV.A2','{\"en\":\"Olaine\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.79.0741044','LV','LV.79','{\"en\":\"Birzgales pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.79.0741009','LV','LV.79','{\"en\":\"Ķegums\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.79.0741084','LV','LV.79','{\"en\":\"Rembates pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.79.0741029','LV','LV.79','{\"en\":\"Tomes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.80.0800807','LV','LV.80','{\"en\":\"Baloži\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.80.0800856','LV','LV.80','{\"en\":\"Daugmales pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.82.0326146','LV','LV.82','{\"en\":\"Bebru pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.87.0741413','LV','LV.87','{\"en\":\"Lielvārde\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.80.0800870','LV','LV.80','{\"en\":\"Ķekavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.81.0960244','LV','LV.81','{\"en\":\"Bērzaines pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.81.0960252','LV','LV.81','{\"en\":\"Dikļu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.88.0421211','LV','LV.88','{\"en\":\"Līgatne\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.81.0960264','LV','LV.81','{\"en\":\"Kocēnu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.81.0960288','LV','LV.81','{\"en\":\"Vaidavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.81.0960296','LV','LV.81','{\"en\":\"Zilākalna pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.87.0741433','LV','LV.87','{\"en\":\"Lielvārdes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.82.0326160','LV','LV.82','{\"en\":\"Kokneses pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0600248','LV','LV.14','{\"en\":\"Aulejas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0600262','LV','LV.14','{\"en\":\"Indras pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.85.0566970','LV','LV.85','{\"en\":\"Kūku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0600264','LV','LV.14','{\"en\":\"Izvaltas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0600268','LV','LV.14','{\"en\":\"Kalniešu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0600270','LV','LV.14','{\"en\":\"Kaplavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0600274','LV','LV.14','{\"en\":\"Kombuļu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0600201','LV','LV.14','{\"en\":\"Krāslava\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0600278','LV','LV.14','{\"en\":\"Krāslavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0600284','LV','LV.14','{\"en\":\"Piedrujas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0600286','LV','LV.14','{\"en\":\"Robežnieku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.16.0170000','LV','LV.16','{\"en\":\"Liepāja\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0600288','LV','LV.14','{\"en\":\"Skaistas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0600296','LV','LV.14','{\"en\":\"Ūdrīšu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.84.0806968','LV','LV.84','{\"en\":\"Krimuldas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0620290','LV','LV.15','{\"en\":\"Snēpeles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0250000','LV','LV.31','{\"en\":\"Valmiera\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.84.0806956','LV','LV.84','{\"en\":\"Lēdurgas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.85.0566946','LV','LV.85','{\"en\":\"Atašienes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.85.0566968','LV','LV.85','{\"en\":\"Krustpils pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.85.0566976','LV','LV.85','{\"en\":\"Mežāres pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.87.0741448','LV','LV.87','{\"en\":\"Jumpravas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0620254','LV','LV.15','{\"en\":\"Īvandes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.85.0566994','LV','LV.85','{\"en\":\"Variešu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.85.0566996','LV','LV.85','{\"en\":\"Vīpes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0620246','LV','LV.15','{\"en\":\"Ēdoles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.33.0980260','LV','LV.33','{\"en\":\"Puzes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0620250','LV','LV.15','{\"en\":\"Gudenieku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0620274','LV','LV.15','{\"en\":\"Pelču pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0620258','LV','LV.15','{\"en\":\"Kabiles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0620201','LV','LV.15','{\"en\":\"Kuldīga\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0620260','LV','LV.15','{\"en\":\"Kurmāles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0620264','LV','LV.15','{\"en\":\"Laidu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0620272','LV','LV.15','{\"en\":\"Padures pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0620280','LV','LV.15','{\"en\":\"Rendas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0620284','LV','LV.15','{\"en\":\"Rumbas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0620292','LV','LV.15','{\"en\":\"Turlavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0620296','LV','LV.15','{\"en\":\"Vārmes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.87.0741464','LV','LV.87','{\"en\":\"Lēdmanes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.88.0421262','LV','LV.88','{\"en\":\"Līgatnes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.18.0660252','LV','LV.18','{\"en\":\"Katvaru pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.18.0660201','LV','LV.18','{\"en\":\"Limbaži\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.18.0660264','LV','LV.18','{\"en\":\"Limbažu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.18.0660268','LV','LV.18','{\"en\":\"Pāles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.18.0660276','LV','LV.18','{\"en\":\"Skultes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.90.0761268','LV','LV.90','{\"en\":\"Rudzātu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.18.0660280','LV','LV.18','{\"en\":\"Umurgas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.18.0660284','LV','LV.18','{\"en\":\"Vidrižu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.18.0660288','LV','LV.18','{\"en\":\"Viļķenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.90.0761286','LV','LV.90','{\"en\":\"Turku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.90.0761252','LV','LV.90','{\"en\":\"Jersikas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.90.0761211','LV','LV.90','{\"en\":\"Līvāni\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.90.0761266','LV','LV.90','{\"en\":\"Rožupes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.91.0701458','LV','LV.91','{\"en\":\"Indrānu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.91.0701413','LV','LV.91','{\"en\":\"Lubāna\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0680246','LV','LV.19','{\"en\":\"Briģu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0680250','LV','LV.19','{\"en\":\"Cirmas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0680258','LV','LV.19','{\"en\":\"Isnaudas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0680260','LV','LV.19','{\"en\":\"Istras pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0680201','LV','LV.19','{\"en\":\"Ludza\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0680278','LV','LV.19','{\"en\":\"Nirzas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0680280','LV','LV.19','{\"en\":\"Ņukšu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0680286','LV','LV.19','{\"en\":\"Pildas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0680288','LV','LV.19','{\"en\":\"Pureņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0680292','LV','LV.19','{\"en\":\"Rundēnu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0700242','LV','LV.20','{\"en\":\"Aronas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0700244','LV','LV.20','{\"en\":\"Barkavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0700246','LV','LV.20','{\"en\":\"Bērzaunes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0700250','LV','LV.20','{\"en\":\"Dzelzavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0700262','LV','LV.20','{\"en\":\"Kalsnavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0700270','LV','LV.20','{\"en\":\"Ļaudonas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0700266','LV','LV.20','{\"en\":\"Lazdonas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.95.0807600','LV','LV.95','{\"en\":\"Mārupes novads\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0700290','LV','LV.20','{\"en\":\"Sarkaņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0700268','LV','LV.20','{\"en\":\"Liezēres pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0700201','LV','LV.20','{\"en\":\"Madona\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0700274','LV','LV.20','{\"en\":\"Mārcienas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0700276','LV','LV.20','{\"en\":\"Mētrienas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.21.0740201','LV','LV.21','{\"en\":\"Ogre\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0700282','LV','LV.20','{\"en\":\"Ošupes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0700286','LV','LV.20','{\"en\":\"Praulienas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880201','LV','LV.28','{\"en\":\"Talsi\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0700296','LV','LV.20','{\"en\":\"Vestienas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.94.0807400','LV','LV.94','{\"en\":\"Mālpils novads\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.96.0961031','LV','LV.96','{\"en\":\"Mazsalacas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E6.0561815','LV','LV.E6','{\"en\":\"Viesīte\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.96.0961076','LV','LV.96','{\"en\":\"Ramatas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.96.0961082','LV','LV.96','{\"en\":\"Sēļu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.96.0961084','LV','LV.96','{\"en\":\"Skaņkalnes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.F1.0887600','LV','LV.F1','{\"en\":\"Mērsraga novads\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.97.0967366','LV','LV.97','{\"en\":\"Ķoņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.97.0967372','LV','LV.97','{\"en\":\"Naukšēnu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A5.0641413','LV','LV.A5','{\"en\":\"Pāvilosta\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.98.0327166','LV','LV.98','{\"en\":\"Mazzalves pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.98.0327170','LV','LV.98','{\"en\":\"Neretas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.33.0980213','LV','LV.33','{\"en\":\"Piltene\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.98.0327174','LV','LV.98','{\"en\":\"Pilskalnes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.98.0327196','LV','LV.98','{\"en\":\"Zalves pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880217','LV','LV.28','{\"en\":\"Valdemārpils\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.99.0647978','LV','LV.99','{\"en\":\"Nīcas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A6.0321413','LV','LV.A6','{\"en\":\"Pļaviņas\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.99.0647980','LV','LV.99','{\"en\":\"Otaņķu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.21.0740256','LV','LV.21','{\"en\":\"Ķeipenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.21.0740252','LV','LV.21','{\"en\":\"Krapes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.21.0740260','LV','LV.21','{\"en\":\"Lauberes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.21.0740268','LV','LV.21','{\"en\":\"Madlienas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.21.0740272','LV','LV.21','{\"en\":\"Mazozolu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.22.0760201','LV','LV.22','{\"en\":\"Preiļi\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780246','LV','LV.24','{\"en\":\"Čornajas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.21.0740276','LV','LV.21','{\"en\":\"Meņģeles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.21.0740280','LV','LV.21','{\"en\":\"Ogresgala pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.21.0740288','LV','LV.21','{\"en\":\"Suntažu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.21.0740292','LV','LV.21','{\"en\":\"Taurupes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.33.0980290','LV','LV.33','{\"en\":\"Ziru pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A2.0801080','LV','LV.A2','{\"en\":\"Olaines pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A3.0546744','LV','LV.A3','{\"en\":\"Cenu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A3.0546778','LV','LV.A3','{\"en\":\"Salgales pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A4.0427574','LV','LV.A4','{\"en\":\"Raiskuma pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.33.0980294','LV','LV.33','{\"en\":\"Zlēku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.23.0210000','LV','LV.23','{\"en\":\"Rēzekne\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A4.0427580','LV','LV.A4','{\"en\":\"Stalbes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A4.0427582','LV','LV.A4','{\"en\":\"Straupes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.22.0760274','LV','LV.22','{\"en\":\"Saunas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A5.0641486','LV','LV.A5','{\"en\":\"Sakas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A5.0641496','LV','LV.A5','{\"en\":\"Vērgales pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A6.0321442','LV','LV.A6','{\"en\":\"Aiviekstes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A6.0321458','LV','LV.A6','{\"en\":\"Klintaines pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A6.0321492','LV','LV.A6','{\"en\":\"Vietalvas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.22.0760244','LV','LV.22','{\"en\":\"Aizkalnes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.22.0760256','LV','LV.22','{\"en\":\"Pelēču pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.22.0760258','LV','LV.22','{\"en\":\"Preiļu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780274','LV','LV.24','{\"en\":\"Nagļu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A8.0641646','LV','LV.A8','{\"en\":\"Bunkas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A8.0641658','LV','LV.A8','{\"en\":\"Gramzdas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A8.0641664','LV','LV.A8','{\"en\":\"Kalētu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A8.0641682','LV','LV.A8','{\"en\":\"Priekules pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B9.0407788','LV','LV.B9','{\"en\":\"Svitenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A8.0641698','LV','LV.A8','{\"en\":\"Virgas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A9.0427360','LV','LV.A9','{\"en\":\"Liepas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A9.0427364','LV','LV.A9','{\"en\":\"Mārsnēnu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A9.0427372','LV','LV.A9','{\"en\":\"Priekuļu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A9.0427394','LV','LV.A9','{\"en\":\"Veselavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B1.0427748','LV','LV.B1','{\"en\":\"Drustu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B1.0427776','LV','LV.B1','{\"en\":\"Raunas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780242','LV','LV.24','{\"en\":\"Audriņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780244','LV','LV.24','{\"en\":\"Bērzgales pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780250','LV','LV.24','{\"en\":\"Dricānu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780252','LV','LV.24','{\"en\":\"Feimaņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780254','LV','LV.24','{\"en\":\"Gaigalavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780256','LV','LV.24','{\"en\":\"Griškānu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C1.0661405','LV','LV.C1','{\"en\":\"Ainaži\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780258','LV','LV.24','{\"en\":\"Ilzeskalna pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780260','LV','LV.24','{\"en\":\"Kantinieku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780262','LV','LV.24','{\"en\":\"Kaunatas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780266','LV','LV.24','{\"en\":\"Lendžu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780268','LV','LV.24','{\"en\":\"Lūznavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780272','LV','LV.24','{\"en\":\"Mākoņkalna pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780270','LV','LV.24','{\"en\":\"Maltas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B8.0961615','LV','LV.B8','{\"en\":\"Rūjiena\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B8.0961668','LV','LV.B8','{\"en\":\"Lodes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780284','LV','LV.24','{\"en\":\"Nautrēnu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780276','LV','LV.24','{\"en\":\"Ozolaines pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780278','LV','LV.24','{\"en\":\"Ozolmuižas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780280','LV','LV.24','{\"en\":\"Pušas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780282','LV','LV.24','{\"en\":\"Rikavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780286','LV','LV.24','{\"en\":\"Sakstagala pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C1.0661425','LV','LV.C1','{\"en\":\"Ainažu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780288','LV','LV.24','{\"en\":\"Silmalas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C3.0801211','LV','LV.C3','{\"en\":\"Salaspils\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780292','LV','LV.24','{\"en\":\"Stoļerovas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780294','LV','LV.24','{\"en\":\"Stružānu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0780296','LV','LV.24','{\"en\":\"Vērēmu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B3.0766348','LV','LV.B3','{\"en\":\"Galēnu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B3.0766362','LV','LV.B3','{\"en\":\"Riebiņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B3.0766370','LV','LV.B3','{\"en\":\"Rušonas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B3.0766376','LV','LV.B3','{\"en\":\"Silajāņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D1.0941674','LV','LV.D1','{\"en\":\"Palsmanes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B3.0766378','LV','LV.B3','{\"en\":\"Sīļukalna pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B3.0766380','LV','LV.B3','{\"en\":\"Stabulnieku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B9.0407796','LV','LV.B9','{\"en\":\"Viesturu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840201','LV','LV.27','{\"en\":\"Saldus\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.25.0010000','LV','LV.25','{\"en\":\"Rīga\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B4.0888301','LV','LV.B4','{\"en\":\"Rojas novads\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B8.0961658','LV','LV.B8','{\"en\":\"Jeru pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B5.0808400','LV','LV.B5','{\"en\":\"Ropažu novads\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C7.0801615','LV','LV.C7','{\"en\":\"Sigulda\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B6.0648552','LV','LV.B6','{\"en\":\"Dunikas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B6.0648584','LV','LV.B6','{\"en\":\"Rucavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B7.0387564','LV','LV.B7','{\"en\":\"Lazdukalna pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B7.0387574','LV','LV.B7','{\"en\":\"Rugāju pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B8.0961656','LV','LV.B8','{\"en\":\"Ipiķu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B8.0961694','LV','LV.B8','{\"en\":\"Vilpulkas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B9.0407776','LV','LV.B9','{\"en\":\"Rundāles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C1.0661460','LV','LV.C1','{\"en\":\"Liepupes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C1.0661415','LV','LV.C1','{\"en\":\"Salacgrīva\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C1.0661435','LV','LV.C1','{\"en\":\"Salacgrīvas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C2.0568786','LV','LV.C2','{\"en\":\"Salas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C2.0568790','LV','LV.C2','{\"en\":\"Sēlpils pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C9.0621282','LV','LV.C9','{\"en\":\"Rudbāržu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C3.0801231','LV','LV.C3','{\"en\":\"Salaspils pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840248','LV','LV.27','{\"en\":\"Ezeres pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840256','LV','LV.27','{\"en\":\"Jaunauces pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840258','LV','LV.27','{\"en\":\"Jaunlutriņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840262','LV','LV.27','{\"en\":\"Kursīšu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840266','LV','LV.27','{\"en\":\"Lutriņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D1.0941615','LV','LV.D1','{\"en\":\"Smiltene\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840270','LV','LV.27','{\"en\":\"Nīgrandes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C7.0801666','LV','LV.C7','{\"en\":\"Mores pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840272','LV','LV.27','{\"en\":\"Novadnieku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840276','LV','LV.27','{\"en\":\"Pampāļu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D3.0941813','LV','LV.D3','{\"en\":\"Seda\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D3.0941817','LV','LV.D3','{\"en\":\"Strenči\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840282','LV','LV.27','{\"en\":\"Rubas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840286','LV','LV.27','{\"en\":\"Saldus pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D1.0941680','LV','LV.D1','{\"en\":\"Smiltenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840288','LV','LV.27','{\"en\":\"Šķēdes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840292','LV','LV.27','{\"en\":\"Vadakstes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840294','LV','LV.27','{\"en\":\"Zaņas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880258','LV','LV.28','{\"en\":\"Īves pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840296','LV','LV.27','{\"en\":\"Zirņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840298','LV','LV.27','{\"en\":\"Zvārdes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C5.0801413','LV','LV.C5','{\"en\":\"Saulkrasti\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C5.0801433','LV','LV.C5','{\"en\":\"Saulkrastu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C6.0809200','LV','LV.C6','{\"en\":\"Sējas novads\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C7.0801642','LV','LV.C7','{\"en\":\"Allažu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C7.0801694','LV','LV.C7','{\"en\":\"Siguldas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C8.0328200','LV','LV.C8','{\"en\":\"Skrīveru novads\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C9.0621268','LV','LV.C9','{\"en\":\"Nīkrāces pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C9.0621278','LV','LV.C9','{\"en\":\"Raņķu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D1.0941690','LV','LV.D1','{\"en\":\"Variņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C9.0621229','LV','LV.C9','{\"en\":\"Skrundas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D1.0941644','LV','LV.D1','{\"en\":\"Bilskas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D1.0941646','LV','LV.D1','{\"en\":\"Blomes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D1.0941648','LV','LV.D1','{\"en\":\"Brantu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D1.0941658','LV','LV.D1','{\"en\":\"Grundzāles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D1.0941670','LV','LV.D1','{\"en\":\"Launkalnes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D2.0809600','LV','LV.D2','{\"en\":\"Stopiņu novads\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D3.0941860','LV','LV.D3','{\"en\":\"Jērcēnu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D3.0941876','LV','LV.D3','{\"en\":\"Plāņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880242','LV','LV.28','{\"en\":\"Abavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880237','LV','LV.28','{\"en\":\"Ārlavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880246','LV','LV.28','{\"en\":\"Balgales pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.30.0940266','LV','LV.30','{\"en\":\"Kārķu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880254','LV','LV.28','{\"en\":\"Ģibuļu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880264','LV','LV.28','{\"en\":\"Ķūļciema pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880268','LV','LV.28','{\"en\":\"Laidzes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880270','LV','LV.28','{\"en\":\"Laucienes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E1.0701878','LV','LV.E1','{\"en\":\"Murmastienes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880272','LV','LV.28','{\"en\":\"Lībagu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880274','LV','LV.28','{\"en\":\"Lubes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880213','LV','LV.28','{\"en\":\"Sabile\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880215','LV','LV.28','{\"en\":\"Stende\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880292','LV','LV.28','{\"en\":\"Valdgales pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E6.0561858','LV','LV.E6','{\"en\":\"Elkšņu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E3.0429350','LV','LV.E3','{\"en\":\"Dzērbenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880294','LV','LV.28','{\"en\":\"Vandzenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0880296','LV','LV.28','{\"en\":\"Virbu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D5.0468944','LV','LV.D5','{\"en\":\"Augstkalnes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D5.0468956','LV','LV.D5','{\"en\":\"Bukaišu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D5.0468988','LV','LV.D5','{\"en\":\"Tērvetes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E4.0409580','LV','LV.E4','{\"en\":\"Skaistkalnes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0900246','LV','LV.29','{\"en\":\"Degoles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0900248','LV','LV.29','{\"en\":\"Džūkstes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0900254','LV','LV.29','{\"en\":\"Irlavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0900258','LV','LV.29','{\"en\":\"Jaunsātu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E6.0561880','LV','LV.E6','{\"en\":\"Rites pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0900274','LV','LV.29','{\"en\":\"Pūres pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0900278','LV','LV.29','{\"en\":\"Sēmes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0900280','LV','LV.29','{\"en\":\"Slampes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0900201','LV','LV.29','{\"en\":\"Tukums\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0900284','LV','LV.29','{\"en\":\"Tumes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0900296','LV','LV.29','{\"en\":\"Zentenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E6.0561888','LV','LV.E6','{\"en\":\"Saukas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D7.0649354','LV','LV.D7','{\"en\":\"Embūtes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D7.0649392','LV','LV.D7','{\"en\":\"Vaiņodes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E4.0409544','LV','LV.E4','{\"en\":\"Bārbeles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.30.0940252','LV','LV.30','{\"en\":\"Ērģemes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.30.0940288','LV','LV.30','{\"en\":\"Valkas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.30.0940292','LV','LV.30','{\"en\":\"Vijciema pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E8.0781890','LV','LV.E8','{\"en\":\"Sokolku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.30.0940296','LV','LV.30','{\"en\":\"Zvārtavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E1.0701817','LV','LV.E1','{\"en\":\"Varakļāni\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E1.0701894','LV','LV.E1','{\"en\":\"Varakļānu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E2.0769164','LV','LV.E2','{\"en\":\"Rožkalnu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E2.0769190','LV','LV.E2','{\"en\":\"Upmalas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E2.0769194','LV','LV.E2','{\"en\":\"Vārkavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E3.0429354','LV','LV.E3','{\"en\":\"Inešu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E3.0429358','LV','LV.E3','{\"en\":\"Kaives pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E3.0429386','LV','LV.E3','{\"en\":\"Taurenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E3.0429392','LV','LV.E3','{\"en\":\"Vecpiebalgas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E4.0409562','LV','LV.E4','{\"en\":\"Kurmenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E4.0409584','LV','LV.E4','{\"en\":\"Stelpes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.34.0804400','LV','LV.34','{\"en\":\"Ādažu novads\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.35.0604342','LV','LV.35','{\"en\":\"Aglonas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.35.0604358','LV','LV.35','{\"en\":\"Grāveru pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.38.0560805','LV','LV.38','{\"en\":\"Aknīste\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0380201','LV','LV.03','{\"en\":\"Balvi\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.46.0800605','LV','LV.46','{\"en\":\"Baldone\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.65.0641009','LV','LV.65','{\"en\":\"Grobiņa\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.96.0961011','LV','LV.96','{\"en\":\"Mazsalaca\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A3.0546766','LV','LV.A3','{\"en\":\"Ozolnieku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.A8.0641615','LV','LV.A8','{\"en\":\"Priekule\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0900268','LV','LV.29','{\"en\":\"Lestenes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.30.0940201','LV','LV.30','{\"en\":\"Valka\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.33.0980256','LV','LV.33','{\"en\":\"Popes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E7.0381660','LV','LV.E7','{\"en\":\"Kupravas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E7.0381615','LV','LV.E7','{\"en\":\"Viļaka\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E4.0409590','LV','LV.E4','{\"en\":\"Valles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E4.0409594','LV','LV.E4','{\"en\":\"Vecumnieku pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.32.0270000','LV','LV.32','{\"en\":\"Ventspils\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.33.0980244','LV','LV.33','{\"en\":\"Ances pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.33.0980250','LV','LV.33','{\"en\":\"Jūrkalnes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E9.0681817','LV','LV.E9','{\"en\":\"Zilupe\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.33.0980266','LV','LV.33','{\"en\":\"Tārgales pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.33.0980270','LV','LV.33','{\"en\":\"Ugāles pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.33.0980274','LV','LV.33','{\"en\":\"Usmas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.33.0980278','LV','LV.33','{\"en\":\"Užavas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.33.0980284','LV','LV.33','{\"en\":\"Vārves pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E6.0561835','LV','LV.E6','{\"en\":\"Viesītes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E7.0381670','LV','LV.E7','{\"en\":\"Medņevas pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E7.0381682','LV','LV.E7','{\"en\":\"Šķilbēnu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E7.0381678','LV','LV.E7','{\"en\":\"Susāju pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E7.0381692','LV','LV.E7','{\"en\":\"Vecumu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E7.0381698','LV','LV.E7','{\"en\":\"Žīguru pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E8.0781898','LV','LV.E8','{\"en\":\"Viļānu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E9.0681864','LV','LV.E9','{\"en\":\"Lauderu pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E9.0681884','LV','LV.E9','{\"en\":\"Pasienes pagasts\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.E9.0681896','LV','LV.E9','{\"en\":\"Zaļesjes 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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Valmiera\"}',25.43,57.54,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Zilupe\"}',28.12,56.39,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Zelmeņi\"}',23.35,56.45,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Viļaka\"}',27.67,57.18,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Viļāni\"}',26.92,56.55,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Viesīte\"}',25.56,56.35,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Vecumnieki\"}',24.52,56.61,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Ventspils\"}',21.56,57.39,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Vecvārkava\"}',26.51,56.20,'P','PPLA','LV.E2','LV.E2.0769190',0,'Europe/Riga',1,'2020-06-09 23:00:00','2020-06-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Vecpiebalga\"}',25.82,57.06,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Varakļāni\"}',26.75,56.61,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Valka\"}',26.01,57.78,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Vaiņode\"}',21.85,56.42,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Ulbroka\"}',24.30,56.94,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Tukums\"}',23.16,56.97,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Talsi\"}',22.58,57.25,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Strenči\"}',25.69,57.63,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Stalbe\"}',25.03,57.37,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Smiltene\"}',25.90,57.42,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Smārde\"}',23.34,56.95,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Skrunda\"}',22.02,56.68,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Skrīveri\"}',25.12,56.65,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Sigulda\"}',24.86,57.15,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Saulkrasti\"}',24.41,57.26,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Saldus\"}',22.49,56.66,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Salaspils\"}',24.37,56.86,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Salacgrīva\"}',24.36,57.75,'P','PPLA','LV.C1','LV.C1.0661415',3427,'Europe/Riga',1,'2020-06-09 23:00:00','2020-06-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Sala\"}',25.76,56.51,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Rūjiena\"}',25.33,57.90,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Rugāji\"}',27.13,57.00,'P','PPLA','LV.B7','LV.B7.0387574',0,'Europe/Riga',1,'2020-06-09 23:00:00','2020-06-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Rucava\"}',21.16,56.16,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Garkalne\"}',24.42,57.04,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Ropaži\"}',24.63,56.97,'P','PPLA','LV.B5','LV.B5.0808400',0,'Europe/Riga',1,'2020-06-09 23:00:00','2020-06-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Roja\"}',22.81,57.50,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Riga\"}',24.11,56.95,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Riebiņi\"}',26.80,56.34,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Rēzekne\"}',27.34,56.51,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Rauna\"}',25.61,57.33,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Ragana\"}',24.71,57.18,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Priekuļi\"}',25.36,57.31,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Priekule\"}',21.59,56.45,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Preiļi\"}',26.72,56.29,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Pļaviņas\"}',25.73,56.62,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Piņķi\"}',23.91,56.94,'P','PPLA','LV.45','LV.45.0804948',3033,'Europe/Riga',1,'2020-06-09 23:00:00','2020-06-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Pilsrundāle\"}',24.02,56.42,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Pāvilosta\"}',21.19,56.89,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Ozolnieki\"}',23.78,56.69,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Olaine\"}',23.94,56.79,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Ogre\"}',24.61,56.82,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Nīca\"}',21.06,56.35,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Nereta\"}',25.31,56.20,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Naukšēni\"}',25.46,57.88,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Mūrmuiža\"}',25.49,57.47,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Mērsrags\"}',23.12,57.34,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Mazsalaca\"}',25.05,57.86,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Matīši\"}',25.16,57.70,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Mālpils\"}',24.96,57.01,'P','PPLA','LV.94','LV.94.0807400',0,'Europe/Riga',1,'2020-06-09 23:00:00','2020-06-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Madona\"}',26.22,56.85,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Ludza\"}',27.72,56.54,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Lubāna\"}',26.72,56.90,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Loja\"}',24.64,57.15,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Līvāni\"}',26.18,56.35,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Limbaži\"}',24.72,57.51,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Līgatne\"}',25.04,57.23,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Liepāja\"}',21.01,56.50,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Lielvārde\"}',24.81,56.72,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Lieģi\"}',21.33,56.58,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Kuldīga\"}',21.96,56.97,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Krustpils\"}',25.86,56.51,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Krāslava\"}',27.17,55.90,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Koknese\"}',25.44,56.65,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Kocēni\"}',25.34,57.52,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Ķekava\"}',24.23,56.83,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Ķegums\"}',24.72,56.75,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Kārsava\"}',27.69,56.78,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Karosta\"}',21.01,56.55,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Kandava\"}',22.77,57.04,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Jūrmala\"}',23.77,56.97,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Jelgava\"}',23.71,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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Jēkabpils\"}',25.86,56.50,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Jaunpils\"}',23.01,56.73,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Jaunpiebalga\"}',26.03,57.18,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Jaunjelgava\"}',25.08,56.61,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Inčukalns\"}',24.69,57.10,'P','PPLA','LV.70','LV.70.0801864',2028,'Europe/Riga',1,'2020-06-09 23:00:00','2020-06-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Ilūkste\"}',26.30,55.98,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Ikšķile\"}',24.50,56.83,'P','PPLA','LV.68','LV.68.0740605',3368,'Europe/Riga',1,'2020-06-09 23:00:00','2020-06-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Iecava\"}',24.21,56.60,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Gulbene\"}',26.75,57.18,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Grobiņa\"}',21.17,56.54,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Cibla\"}',27.88,56.55,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Ērgļi\"}',25.64,56.90,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Dundaga\"}',22.35,57.50,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Drabeši\"}',25.28,57.24,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Dobele\"}',23.28,56.62,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Daugavpils\"}',26.53,55.88,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Daugavgrīva\"}',24.04,57.04,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Dagda\"}',27.54,56.10,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Cesvaine\"}',26.31,56.97,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Cēsis\"}',25.27,57.31,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Carnikava\"}',24.28,57.13,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Brocēni\"}',22.57,56.68,'P','PPLA','LV.51','LV.51.0840625',3486,'Europe/Riga',1,'2020-06-09 23:00:00','2020-06-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Bolderaja\"}',24.06,57.03,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Berģi\"}',24.30,56.99,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Bauska\"}',24.19,56.41,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Balvi\"}',27.27,57.13,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Baltinava\"}',27.64,56.94,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Baldone\"}',24.40,56.74,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Auce\"}',22.90,56.46,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Ape\"}',26.69,57.54,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Alūksne\"}',27.05,57.42,'P','PPLA','LV.02','LV.02.0360201',2264,'Europe/Riga',1,'2020-06-09 23:00:00','2020-06-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Alsunga\"}',21.56,56.98,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Aloja\"}',24.88,57.77,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Aknīste\"}',25.75,56.16,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Aizpute\"}',21.60,56.72,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Aizkraukle\"}',25.26,56.60,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Aglona\"}',27.01,56.13,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Ādaži\"}',24.34,57.07,'P','PPLA','LV.34','LV.34.0804400',0,'Europe/Riga',1,'2020-06-09 23:00:00','2020-06-09 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('LV','{\"en\":\"Mārupe\"}',24.05,56.91,'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
