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

/*!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.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.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.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.34','LV','{\"en\":\"Ādaži\"}',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.B5','LV','{\"en\":\"Ropažu\"}',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.C5','LV','{\"en\":\"Saulkrastu\"}',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.DN','LV','{\"en\":\"South Kurzeme Municipality\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('LV.AN','LV','{\"en\":\"Augšdaugava Municipality\"}',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.14.0604372','LV','LV.14','{\"en\":\"Kastuļinas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0604394','LV','LV.14','{\"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.DN.0640605','LV','LV.DN','{\"en\":\"Aizpute\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0640642','LV','LV.DN','{\"en\":\"Aizputes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0640648','LV','LV.DN','{\"en\":\"Cīravas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0640666','LV','LV.DN','{\"en\":\"Kalvenes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0640668','LV','LV.DN','{\"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.DN.0640672','LV','LV.DN','{\"en\":\"Lažas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0560825','LV','LV.10','{\"en\":\"Aknīstes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0560844','LV','LV.10','{\"en\":\"Asares pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0560862','LV','LV.10','{\"en\":\"Gārsenes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.18.0661007','LV','LV.18','{\"en\":\"Aloja\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.18.0661027','LV','LV.18','{\"en\":\"Alojas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.18.0661044','LV','LV.18','{\"en\":\"Braslavas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.18.0661048','LV','LV.18','{\"en\":\"Brīvzemnieku pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.18.0661017','LV','LV.18','{\"en\":\"Staicele\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.18.0661037','LV','LV.18','{\"en\":\"Staiceles pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0624200','LV','LV.15','{\"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.15.0621209','LV','LV.15','{\"en\":\"Skrunda\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0424742','LV','LV.05','{\"en\":\"Amatas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0424746','LV','LV.05','{\"en\":\"Drabešu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0424768','LV','LV.05','{\"en\":\"Nītaures pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0424778','LV','LV.05','{\"en\":\"Skujenes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0424796','LV','LV.05','{\"en\":\"Zaubes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460805','LV','LV.08','{\"en\":\"Auce\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D1.0360805','LV','LV.D1','{\"en\":\"Ape\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460850','LV','LV.08','{\"en\":\"Bēnes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D1.0360825','LV','LV.D1','{\"en\":\"Apes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D1.0360848','LV','LV.D1','{\"en\":\"Gaujienas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D1.0360884','LV','LV.D1','{\"en\":\"Trapenes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D1.0360890','LV','LV.D1','{\"en\":\"Virešu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460864','LV','LV.08','{\"en\":\"Īles pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460876','LV','LV.08','{\"en\":\"Lielauces pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460890','LV','LV.08','{\"en\":\"Ukru pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460825','LV','LV.08','{\"en\":\"Vecauces pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0460894','LV','LV.08','{\"en\":\"Vītiņu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.95.0804948','LV','LV.95','{\"en\":\"Babītes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.95.0804988','LV','LV.95','{\"en\":\"Salas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.80.0800625','LV','LV.80','{\"en\":\"Baldones pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0384400','LV','LV.03','{\"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.31.0964746','LV','LV.31','{\"en\":\"Brenguļu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0964762','LV','LV.31','{\"en\":\"Kauguru pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0964784','LV','LV.31','{\"en\":\"Trikātas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840644','LV','LV.27','{\"en\":\"Blīdenes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840605','LV','LV.27','{\"en\":\"Brocēni\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840625','LV','LV.27','{\"en\":\"Cieceres pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840652','LV','LV.27','{\"en\":\"Gaiķu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.27.0840680','LV','LV.27','{\"en\":\"Remtes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0967148','LV','LV.31','{\"en\":\"Burtnieku pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0967154','LV','LV.31','{\"en\":\"Ēveles pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0967170','LV','LV.31','{\"en\":\"Matīšu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0967178','LV','LV.31','{\"en\":\"Rencēnu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0967190','LV','LV.31','{\"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.31.0967192','LV','LV.31','{\"en\":\"Vecates pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.34.0805200','LV','LV.34','{\"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.20.0700807','LV','LV.20','{\"en\":\"Cesvaine\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0700827','LV','LV.20','{\"en\":\"Cesvaines pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0684944','LV','LV.19','{\"en\":\"Blontu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0684948','LV','LV.19','{\"en\":\"Ciblas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0684966','LV','LV.19','{\"en\":\"Līdumnieku pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0684990','LV','LV.19','{\"en\":\"Pušmucovas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0684998','LV','LV.19','{\"en\":\"Zvirgzdenes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0601042','LV','LV.14','{\"en\":\"Andrupenes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440807','LV','LV.AN','{\"en\":\"Ilūkste\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0601044','LV','LV.14','{\"en\":\"Andzeļu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B5.0801817','LV','LV.B5','{\"en\":\"Vangaži\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0601046','LV','LV.14','{\"en\":\"Asūnes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0601050','LV','LV.14','{\"en\":\"Bērziņu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0601009','LV','LV.14','{\"en\":\"Dagda\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440242','LV','LV.AN','{\"en\":\"Ambeļu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0601054','LV','LV.14','{\"en\":\"Dagdas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0601056','LV','LV.14','{\"en\":\"Ezernieku pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0601080','LV','LV.14','{\"en\":\"Ķepovas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0601076','LV','LV.14','{\"en\":\"Konstantinovas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0601092','LV','LV.14','{\"en\":\"Šķaunes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0601090','LV','LV.14','{\"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.AN.0440246','LV','LV.AN','{\"en\":\"Biķernieku pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440250','LV','LV.AN','{\"en\":\"Demenes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440252','LV','LV.AN','{\"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.AN.0440260','LV','LV.AN','{\"en\":\"Kalkūnes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440262','LV','LV.AN','{\"en\":\"Kalupes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440264','LV','LV.AN','{\"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.AN.0440268','LV','LV.AN','{\"en\":\"Līksnas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440270','LV','LV.AN','{\"en\":\"Maļinovas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0781848','LV','LV.24','{\"en\":\"Dekšāres pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440272','LV','LV.AN','{\"en\":\"Medumu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440274','LV','LV.AN','{\"en\":\"Naujenes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440276','LV','LV.AN','{\"en\":\"Nīcgales pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440284','LV','LV.AN','{\"en\":\"Salienas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440286','LV','LV.AN','{\"en\":\"Skrudalienas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440288','LV','LV.AN','{\"en\":\"Sventes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440292','LV','LV.AN','{\"en\":\"Tabores pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440294','LV','LV.AN','{\"en\":\"Vaboles pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440296','LV','LV.AN','{\"en\":\"Vecsalienas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440298','LV','LV.AN','{\"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.DN.0640807','LV','LV.DN','{\"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.01.0321050','LV','LV.01','{\"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.28.0885150','LV','LV.28','{\"en\":\"Dundagas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0885162','LV','LV.28','{\"en\":\"Kolkas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0640850','LV','LV.DN','{\"en\":\"Dunalkas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0640827','LV','LV.DN','{\"en\":\"Durbes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0640888','LV','LV.DN','{\"en\":\"Tadaiķu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0640894','LV','LV.DN','{\"en\":\"Vecpils pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0905790','LV','LV.29','{\"en\":\"Viesatu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0905150','LV','LV.29','{\"en\":\"Engures pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0905166','LV','LV.29','{\"en\":\"Lapmežciema pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.01.0321007','LV','LV.01','{\"en\":\"Jaunjelgava\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0905182','LV','LV.29','{\"en\":\"Smārdes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0705554','LV','LV.20','{\"en\":\"Ērgļu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0705560','LV','LV.20','{\"en\":\"Jumurdas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0705592','LV','LV.20','{\"en\":\"Sausnējas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.01.0321027','LV','LV.01','{\"en\":\"Jaunjelgavas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.B5.0806000','LV','LV.B5','{\"en\":\"Garkalnes novads\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0641044','LV','LV.DN','{\"en\":\"Bārtas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0641056','LV','LV.DN','{\"en\":\"Gaviezes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0641060','LV','LV.DN','{\"en\":\"Grobiņas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0781817','LV','LV.24','{\"en\":\"Viļāni\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0641076','LV','LV.DN','{\"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.21.0740605','LV','LV.21','{\"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.AN.0440815','LV','LV.AN','{\"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.AN.0440856','LV','LV.AN','{\"en\":\"Eglaines pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440890','LV','LV.AN','{\"en\":\"Šēderes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0406400','LV','LV.04','{\"en\":\"Iecavas novads\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.21.0740625','LV','LV.21','{\"en\":\"Tīnūžu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0425798','LV','LV.05','{\"en\":\"Zosēnu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440844','LV','LV.AN','{\"en\":\"Bebrenes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440854','LV','LV.AN','{\"en\":\"Dvietes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440880','LV','LV.AN','{\"en\":\"Pilskalnes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.AN.0440835','LV','LV.AN','{\"en\":\"Prodes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.C7.0801864','LV','LV.C7','{\"en\":\"Inčukalna pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.01.0321078','LV','LV.01','{\"en\":\"Seces pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.01.0321080','LV','LV.01','{\"en\":\"Sērenes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.01.0321084','LV','LV.01','{\"en\":\"Staburaga pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.01.0321086','LV','LV.01','{\"en\":\"Sunākstes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0425756','LV','LV.05','{\"en\":\"Jaunpiebalgas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0905756','LV','LV.29','{\"en\":\"Jaunpils pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0110000','LV','LV.10','{\"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.19.0681009','LV','LV.19','{\"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.29.0901244','LV','LV.29','{\"en\":\"Cēres pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0901211','LV','LV.29','{\"en\":\"Kandava\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0901262','LV','LV.29','{\"en\":\"Kandavas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0901270','LV','LV.29','{\"en\":\"Matkules pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0901288','LV','LV.29','{\"en\":\"Vānes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0901292','LV','LV.29','{\"en\":\"Zantes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.29.0901294','LV','LV.29','{\"en\":\"Zemītes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0681054','LV','LV.19','{\"en\":\"Goliševas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0681068','LV','LV.19','{\"en\":\"Malnavas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0681072','LV','LV.19','{\"en\":\"Mērdzenes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0681070','LV','LV.19','{\"en\":\"Mežvidu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.01.0326154','LV','LV.01','{\"en\":\"Iršu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0681094','LV','LV.19','{\"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.21.0741044','LV','LV.21','{\"en\":\"Birzgales pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.21.0741009','LV','LV.21','{\"en\":\"Ķegums\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.21.0741084','LV','LV.21','{\"en\":\"Rembates pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.21.0741029','LV','LV.21','{\"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.01.0326146','LV','LV.01','{\"en\":\"Bebru pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.21.0741413','LV','LV.21','{\"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.31.0960244','LV','LV.31','{\"en\":\"Bērzaines pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0960252','LV','LV.31','{\"en\":\"Dikļu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0421211','LV','LV.05','{\"en\":\"Līgatne\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0960264','LV','LV.31','{\"en\":\"Kocēnu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0960288','LV','LV.31','{\"en\":\"Vaidavas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0960296','LV','LV.31','{\"en\":\"Zilākalna pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.21.0741433','LV','LV.21','{\"en\":\"Lielvārdes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.01.0326160','LV','LV.01','{\"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.10.0566970','LV','LV.10','{\"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.C7.0806968','LV','LV.C7','{\"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.C7.0806956','LV','LV.C7','{\"en\":\"Lēdurgas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0566946','LV','LV.10','{\"en\":\"Atašienes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0566968','LV','LV.10','{\"en\":\"Krustpils pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0566976','LV','LV.10','{\"en\":\"Mežāres pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.21.0741448','LV','LV.21','{\"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.10.0566994','LV','LV.10','{\"en\":\"Variešu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0566996','LV','LV.10','{\"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.21.0741464','LV','LV.21','{\"en\":\"Lēdmanes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0421262','LV','LV.05','{\"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.20.0701458','LV','LV.20','{\"en\":\"Indrānu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.20.0701413','LV','LV.20','{\"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.C7.0807400','LV','LV.C7','{\"en\":\"Mālpils novads\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0961031','LV','LV.31','{\"en\":\"Mazsalacas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0561815','LV','LV.10','{\"en\":\"Viesīte\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0961076','LV','LV.31','{\"en\":\"Ramatas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0961082','LV','LV.31','{\"en\":\"Sēļu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0961084','LV','LV.31','{\"en\":\"Skaņkalnes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.28.0887600','LV','LV.28','{\"en\":\"Mērsraga novads\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0967366','LV','LV.31','{\"en\":\"Ķoņu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0967372','LV','LV.31','{\"en\":\"Naukšēnu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0641413','LV','LV.DN','{\"en\":\"Pāvilosta\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.01.0327166','LV','LV.01','{\"en\":\"Mazzalves pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.01.0327170','LV','LV.01','{\"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.01.0327174','LV','LV.01','{\"en\":\"Pilskalnes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.01.0327196','LV','LV.01','{\"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.DN.0647978','LV','LV.DN','{\"en\":\"Nīcas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.01.0321413','LV','LV.01','{\"en\":\"Pļaviņas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0647980','LV','LV.DN','{\"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.12.0546744','LV','LV.12','{\"en\":\"Cenu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.12.0546778','LV','LV.12','{\"en\":\"Salgales pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0427574','LV','LV.05','{\"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.05.0427580','LV','LV.05','{\"en\":\"Stalbes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0427582','LV','LV.05','{\"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.DN.0641486','LV','LV.DN','{\"en\":\"Sakas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0641496','LV','LV.DN','{\"en\":\"Vērgales pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.01.0321442','LV','LV.01','{\"en\":\"Aiviekstes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.01.0321458','LV','LV.01','{\"en\":\"Klintaines pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.01.0321492','LV','LV.01','{\"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.DN.0641646','LV','LV.DN','{\"en\":\"Bunkas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0641658','LV','LV.DN','{\"en\":\"Gramzdas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0641664','LV','LV.DN','{\"en\":\"Kalētu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0641682','LV','LV.DN','{\"en\":\"Priekules pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0407788','LV','LV.04','{\"en\":\"Svitenes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0641698','LV','LV.DN','{\"en\":\"Virgas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0427360','LV','LV.05','{\"en\":\"Liepas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0427364','LV','LV.05','{\"en\":\"Mārsnēnu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0427372','LV','LV.05','{\"en\":\"Priekuļu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0427394','LV','LV.05','{\"en\":\"Veselavas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D1.0427748','LV','LV.D1','{\"en\":\"Drustu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.D1.0427776','LV','LV.D1','{\"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.18.0661405','LV','LV.18','{\"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.31.0961615','LV','LV.31','{\"en\":\"Rūjiena\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0961668','LV','LV.31','{\"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.18.0661425','LV','LV.18','{\"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.22.0766348','LV','LV.22','{\"en\":\"Galēnu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.22.0766362','LV','LV.22','{\"en\":\"Riebiņu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.22.0766370','LV','LV.22','{\"en\":\"Rušonas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.22.0766376','LV','LV.22','{\"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.22.0766378','LV','LV.22','{\"en\":\"Sīļukalna pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.22.0766380','LV','LV.22','{\"en\":\"Stabulnieku pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0407796','LV','LV.04','{\"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.28.0888301','LV','LV.28','{\"en\":\"Rojas novads\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0961658','LV','LV.31','{\"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.DN.0648552','LV','LV.DN','{\"en\":\"Dunikas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0648584','LV','LV.DN','{\"en\":\"Rucavas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0387564','LV','LV.03','{\"en\":\"Lazdukalna pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0387574','LV','LV.03','{\"en\":\"Rugāju pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0961656','LV','LV.31','{\"en\":\"Ipiķu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0961694','LV','LV.31','{\"en\":\"Vilpulkas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0407776','LV','LV.04','{\"en\":\"Rundāles pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.18.0661460','LV','LV.18','{\"en\":\"Liepupes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.18.0661415','LV','LV.18','{\"en\":\"Salacgrīva\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.18.0661435','LV','LV.18','{\"en\":\"Salacgrīvas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0568786','LV','LV.10','{\"en\":\"Salas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0568790','LV','LV.10','{\"en\":\"Sēlpils pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0621282','LV','LV.15','{\"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.31.0941813','LV','LV.31','{\"en\":\"Seda\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0941817','LV','LV.31','{\"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.C5.0809200','LV','LV.C5','{\"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.01.0328200','LV','LV.01','{\"en\":\"Skrīveru novads\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0621268','LV','LV.15','{\"en\":\"Nīkrāces pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.15.0621278','LV','LV.15','{\"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.15.0621229','LV','LV.15','{\"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.B5.0809600','LV','LV.B5','{\"en\":\"Stopiņu novads\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0941860','LV','LV.31','{\"en\":\"Jērcēnu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0941876','LV','LV.31','{\"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.10.0561858','LV','LV.10','{\"en\":\"Elkšņu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0429350','LV','LV.05','{\"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.08.0468944','LV','LV.08','{\"en\":\"Augstkalnes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0468956','LV','LV.08','{\"en\":\"Bukaišu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.08.0468988','LV','LV.08','{\"en\":\"Tērvetes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0409580','LV','LV.04','{\"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.10.0561880','LV','LV.10','{\"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.10.0561888','LV','LV.10','{\"en\":\"Saukas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0649354','LV','LV.DN','{\"en\":\"Embūtes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0649392','LV','LV.DN','{\"en\":\"Vaiņodes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0409544','LV','LV.04','{\"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.24.0781890','LV','LV.24','{\"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.22.0769164','LV','LV.22','{\"en\":\"Rožkalnu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.22.0769190','LV','LV.22','{\"en\":\"Upmalas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.22.0769194','LV','LV.22','{\"en\":\"Vārkavas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0429354','LV','LV.05','{\"en\":\"Inešu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0429358','LV','LV.05','{\"en\":\"Kaives pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0429386','LV','LV.05','{\"en\":\"Taurenes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.05.0429392','LV','LV.05','{\"en\":\"Vecpiebalgas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0409562','LV','LV.04','{\"en\":\"Kurmenes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0409584','LV','LV.04','{\"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.22.0604342','LV','LV.22','{\"en\":\"Aglonas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.14.0604358','LV','LV.14','{\"en\":\"Grāveru pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.10.0560805','LV','LV.10','{\"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.80.0800605','LV','LV.80','{\"en\":\"Baldone\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0641009','LV','LV.DN','{\"en\":\"Grobiņa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.31.0961011','LV','LV.31','{\"en\":\"Mazsalaca\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.12.0546766','LV','LV.12','{\"en\":\"Ozolnieku pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.DN.0641615','LV','LV.DN','{\"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.03.0381660','LV','LV.03','{\"en\":\"Kupravas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0381615','LV','LV.03','{\"en\":\"Viļaka\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0409590','LV','LV.04','{\"en\":\"Valles pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.04.0409594','LV','LV.04','{\"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.19.0681817','LV','LV.19','{\"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.10.0561835','LV','LV.10','{\"en\":\"Viesītes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0381670','LV','LV.03','{\"en\":\"Medņevas pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0381682','LV','LV.03','{\"en\":\"Šķilbēnu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0381678','LV','LV.03','{\"en\":\"Susāju pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0381692','LV','LV.03','{\"en\":\"Vecumu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.03.0381698','LV','LV.03','{\"en\":\"Žīguru pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.24.0781898','LV','LV.24','{\"en\":\"Viļānu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0681864','LV','LV.19','{\"en\":\"Lauderu pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0681884','LV','LV.19','{\"en\":\"Pasienes pagasts\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('LV.19.0681896','LV','LV.19','{\"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\":\"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\":\"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\":\"Ulbroka\"}',24.30,56.94,'P','PPLA','LV.B5','LV.B5.0809600',2800,'Europe/Riga',1,'2021-08-03 23:00:00','2021-08-03 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\":\"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\":\"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\":\"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\":\"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\":\"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\":\"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\":\"Madona\"}',26.22,56.85,'P','PPLA','LV.20','LV.20.0700201',9280,'Europe/Riga',1,'2021-07-29 23:00:00','2021-07-29 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\":\"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\":\"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','PPLA2','LV.21','LV.21.0741413',5114,'Europe/Riga',1,'2021-08-15 23:00:00','2021-08-15 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\":\"Ķ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\":\"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\":\"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\":\"Ikšķile\"}',24.50,56.83,'P','PPL','LV.21','LV.21.0740605',7278,'Europe/Riga',1,'2021-11-08 23:00:00','2021-11-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\":\"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\":\"Dreiliņi\"}',24.24,56.94,'P','PPLX','LV.25',NULL,7376,'Europe/Riga',1,'2021-11-09 23:00:00','2021-11-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\":\"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.06',NULL,111564,'Europe/Riga',1,'2021-08-30 23:00:00','2021-08-30 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\":\"Dārzciems\"}',26.44,57.48,'P','PPL','LV.02',NULL,18956,'Europe/Riga',1,'2021-11-09 23:00:00','2021-11-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\":\"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\":\"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\":\"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\":\"Aizpute\"}',21.60,56.72,'P','PPLA2','LV.DN','LV.DN.0640605',5634,'Europe/Riga',1,'2021-08-15 23:00:00','2021-08-15 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,'2021-08-02 23:00:00','2021-08-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\":\"Ā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\":\"Baloži\"}',24.12,56.88,'P','PPL','LV.80','LV.80.0800807',6780,'Europe/Riga',1,'2021-11-08 23:00:00','2021-11-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\":\"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
