--
-- Host: localhost    Database: Quickadclassified
-- ------------------------------------------------------


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

INSERT INTO `<<prefix>>subadmin1` VALUES (1773,'LV.33','LV','Ventspils Rajons','Ventspils Rajons',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1774,'LV.32','LV','Ventspils','Ventspils',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1775,'LV.31','LV','Valmiera','Valmiera',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1776,'LV.30','LV','Valka','Valka',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1777,'LV.29','LV','Tukuma novads','Tukuma novads',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1778,'LV.28','LV','Talsi Municipality','Talsi Municipality',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1779,'LV.27','LV','Saldus Rajons','Saldus Rajons',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1780,'LV.25','LV','Riga','Riga',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1781,'LV.24','LV','Rēzeknes Novads','Rezeknes Novads',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1782,'LV.23','LV','Rēzekne','Rezekne',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1783,'LV.22','LV','Preiļu novads','Preilu novads',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1784,'LV.21','LV','Ogre','Ogre',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1785,'LV.20','LV','Madona Municipality','Madona Municipality',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1786,'LV.19','LV','Ludzas novads','Ludzas novads',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1787,'LV.18','LV','Limbažu novads','Limbazu novads',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1788,'LV.16','LV','Liepāja','Liepaja',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1789,'LV.15','LV','Kuldīgas novads','Kuldigas novads',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1790,'LV.14','LV','Krāslavas novads','Kraslavas novads',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1791,'LV.13','LV','Jūrmala','Jurmala',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1792,'LV.12','LV','Jelgavas novads','Jelgavas novads',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1793,'LV.11','LV','Jelgava','Jelgava',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1794,'LV.10','LV','Jēkabpils Municipality','Jekabpils Municipality',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1795,'LV.09','LV','Gulbenes novads','Gulbenes novads',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1796,'LV.08','LV','Dobeles novads','Dobeles novads',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1797,'LV.07','LV','Daugavpils municipality','Daugavpils municipality',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1798,'LV.06','LV','Daugavpils','Daugavpils',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1799,'LV.05','LV','Cēsu Rajons','Cesu Rajons',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1800,'LV.04','LV','Bauskas Rajons','Bauskas Rajons',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1801,'LV.03','LV','Balvu Novads','Balvu Novads',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1802,'LV.02','LV','Alūksnes Novads','Aluksnes Novads',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1803,'LV.01','LV','Aizkraukles novads','Aizkraukles novads',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1804,'LV.60','LV','Dundaga','Dundaga',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1805,'LV.40','LV','Alsunga','Alsunga',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1806,'LV.A5','LV','Pāvilostas','Pavilostas',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1807,'LV.99','LV','Nīca','Nica',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1808,'LV.B6','LV','Rucavas','Rucavas',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1809,'LV.65','LV','Grobiņa','Grobina',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1810,'LV.61','LV','Durbe','Durbe',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1811,'LV.37','LV','Aizpute','Aizpute',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1812,'LV.A8','LV','Priekule','Priekule',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1813,'LV.D7','LV','Vaiņode','Vainode',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1814,'LV.C9','LV','Skrunda','Skrunda',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1815,'LV.51','LV','Brocēni','Broceni',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1816,'LV.B4','LV','Rojas','Rojas',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1817,'LV.77','LV','Kandava','Kandava',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1818,'LV.44','LV','Auces','Auces',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1819,'LV.73','LV','Jaunpils','Jaunpils',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1820,'LV.62','LV','Engure','Engure',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1821,'LV.D5','LV','Tērvete','Tervete',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1822,'LV.A3','LV','Ozolnieku','Ozolnieku',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1823,'LV.B9','LV','Rundāles','Rundales',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1824,'LV.45','LV','Babīte','Babite',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1825,'LV.95','LV','Mārupe','Marupe',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1826,'LV.A2','LV','Olaine','Olaine',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1827,'LV.67','LV','Lecava','Lecava',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1828,'LV.80','LV','Ķekava','Kekava',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1829,'LV.C3','LV','Salaspils','Salaspils',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1830,'LV.46','LV','Baldone','Baldone',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1831,'LV.D2','LV','Stopiņi','Stopini',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1832,'LV.53','LV','Carnikava','Carnikava',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1833,'LV.34','LV','Ādaži','Adazi',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1834,'LV.64','LV','Garkalne','Garkalne',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1835,'LV.E4','LV','Vecumnieki','Vecumnieki',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1836,'LV.79','LV','Ķegums','Kegums',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1837,'LV.87','LV','Lielvārde','Lielvarde',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1838,'LV.C8','LV','Skrīveri','Skriveri',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1839,'LV.71','LV','Jaunjelgava','Jaunjelgava',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1840,'LV.98','LV','Nereta','Nereta',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1841,'LV.E6','LV','Viesīte','Viesite',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1842,'LV.C2','LV','Salas','Salas',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1843,'LV.74','LV','Jēkabpils','Jekabpils',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1844,'LV.38','LV','Aknīste','Akniste',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1845,'LV.69','LV','Ilūkste','Ilukste',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1846,'LV.E2','LV','Vārkava','Varkava',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1847,'LV.90','LV','Līvāni','Livani',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1848,'LV.E1','LV','Varakļāni','Varaklani',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1849,'LV.E8','LV','Vilanu','Vilanu',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1850,'LV.B3','LV','Riebiņu','Riebinu',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1851,'LV.35','LV','Aglona','Aglona',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1852,'LV.56','LV','Cibla','Cibla',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1853,'LV.E9','LV','Zilupes','Zilupes',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1854,'LV.E7','LV','Viļaka','Vilaka',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1855,'LV.47','LV','Baltinava','Baltinava',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1856,'LV.57','LV','Dagda','Dagda',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1857,'LV.78','LV','Karsava','Karsava',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1858,'LV.B7','LV','Rugāju','Rugaju',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1859,'LV.55','LV','Cesvaine','Cesvaine',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1860,'LV.91','LV','Lubāna','Lubana',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1861,'LV.85','LV','Krustpils','Krustpils',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1862,'LV.A6','LV','Pļaviņu','Plavinu',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1863,'LV.82','LV','Koknese','Koknese',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1864,'LV.68','LV','Ikšķile','Ikskile',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1865,'LV.B5','LV','Ropažu','Ropazu',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1866,'LV.70','LV','Inčukalns','Incukalns',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1867,'LV.84','LV','Krimulda','Krimulda',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1868,'LV.C7','LV','Sigulda','Sigulda',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1869,'LV.88','LV','Līgatne','Ligatne',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1870,'LV.94','LV','Mālpils','Malpils',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1871,'LV.C6','LV','Sēja','Seja',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1872,'LV.C5','LV','Saulkrastu','Saulkrastu',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1873,'LV.C1','LV','Salacgrīvas','Salacgrivas',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1874,'LV.39','LV','Aloja','Aloja',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1875,'LV.97','LV','Naukšēni','Naukseni',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1876,'LV.B8','LV','Rūjienas','Rujienas',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1877,'LV.96','LV','Mazsalaca','Mazsalaca',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1878,'LV.52','LV','Burtnieki','Burtnieki',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1879,'LV.A4','LV','Pārgaujas','Pargaujas',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1880,'LV.81','LV','Kocēni','Koceni',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1881,'LV.42','LV','Amatas','Amatas',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1882,'LV.A9','LV','Priekuļi','Priekuli',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1883,'LV.B1','LV','Raunas','Raunas',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1884,'LV.D3','LV','Strenči','Strenci',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1885,'LV.50','LV','Beverīna','Beverina',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1886,'LV.D1','LV','Smiltene','Smiltene',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1887,'LV.72','LV','Jaunpiebalga','Jaunpiebalga',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1888,'LV.63','LV','Ērgļi','Ergli',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1889,'LV.E3','LV','Vecpiebalga','Vecpiebalga',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1890,'LV.43','LV','Apes','Apes',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1891,'LV.F1','LV','Mesraga','Mesraga',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (21464,'LV.01.0320201','LV','LV.01','Aizkraukle','Aizkraukle',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21465,'LV.35.0604372','LV','LV.35','Kastuļinas pagasts','Kastulinas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21466,'LV.35.0604394','LV','LV.35','Šķeltovas pagasts','Skeltovas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21467,'LV.01.0320244','LV','LV.01','Aizkraukles pagasts','Aizkraukles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21468,'LV.37.0640605','LV','LV.37','Aizpute','Aizpute',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21469,'LV.37.0640642','LV','LV.37','Aizputes pagasts','Aizputes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21470,'LV.37.0640648','LV','LV.37','Cīravas pagasts','Ciravas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21471,'LV.37.0640666','LV','LV.37','Kalvenes pagasts','Kalvenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21472,'LV.37.0640668','LV','LV.37','Kazdangas pagasts','Kazdangas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21473,'LV.02.0360276','LV','LV.02','Mārkalnes pagasts','Markalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21474,'LV.37.0640672','LV','LV.37','Lažas pagasts','Lazas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21475,'LV.38.0560825','LV','LV.38','Aknīstes pagasts','Aknistes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21476,'LV.38.0560844','LV','LV.38','Asares pagasts','Asares pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21477,'LV.38.0560862','LV','LV.38','Gārsenes pagasts','Garsenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21478,'LV.39.0661007','LV','LV.39','Aloja','Aloja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21479,'LV.39.0661027','LV','LV.39','Alojas pagasts','Alojas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21480,'LV.39.0661044','LV','LV.39','Braslavas pagasts','Braslavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21481,'LV.39.0661048','LV','LV.39','Brīvzemnieku pagasts','Brivzemnieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21482,'LV.39.0661017','LV','LV.39','Staicele','Staicele',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21483,'LV.39.0661037','LV','LV.39','Staiceles pagasts','Staiceles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21484,'LV.40.0624200','LV','LV.40','Alsungas novads','Alsungas novads',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21485,'LV.02.0360201','LV','LV.02','Alūksne','Aluksne',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21486,'LV.02.0360242','LV','LV.02','Alsviķu pagasts','Alsviku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21487,'LV.02.0360244','LV','LV.02','Annas pagasts','Annas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21488,'LV.02.0360252','LV','LV.02','Ilzenes pagasts','Ilzenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21489,'LV.02.0360280','LV','LV.02','Pededzes pagasts','Pededzes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21490,'LV.02.0360256','LV','LV.02','Jaunalūksnes pagasts','Jaunaluksnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21491,'LV.02.0360258','LV','LV.02','Jaunannas pagasts','Jaunannas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21492,'LV.02.0360260','LV','LV.02','Jaunlaicenes pagasts','Jaunlaicenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21493,'LV.02.0360264','LV','LV.02','Kalncempju pagasts','Kalncempju pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21494,'LV.02.0360268','LV','LV.02','Liepnas pagasts','Liepnas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21495,'LV.02.0360272','LV','LV.02','Malienas pagasts','Malienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21496,'LV.02.0360274','LV','LV.02','Mālupes pagasts','Malupes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21497,'LV.02.0360288','LV','LV.02','Veclaicenes pagasts','Veclaicenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21498,'LV.02.0360294','LV','LV.02','Zeltiņu pagasts','Zeltinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21499,'LV.02.0360296','LV','LV.02','Ziemera pagasts','Ziemera pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21500,'LV.C9.0621209','LV','LV.C9','Skrunda','Skrunda',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21501,'LV.42.0424742','LV','LV.42','Amatas pagasts','Amatas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21502,'LV.42.0424746','LV','LV.42','Drabešu pagasts','Drabesu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21503,'LV.42.0424768','LV','LV.42','Nītaures pagasts','Nitaures pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21504,'LV.42.0424778','LV','LV.42','Skujenes pagasts','Skujenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21505,'LV.42.0424796','LV','LV.42','Zaubes pagasts','Zaubes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21506,'LV.44.0460805','LV','LV.44','Auce','Auce',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21507,'LV.43.0360805','LV','LV.43','Ape','Ape',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21508,'LV.44.0460850','LV','LV.44','Bēnes pagasts','Benes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21509,'LV.43.0360825','LV','LV.43','Apes pagasts','Apes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21510,'LV.43.0360848','LV','LV.43','Gaujienas pagasts','Gaujienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21511,'LV.43.0360884','LV','LV.43','Trapenes pagasts','Trapenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21512,'LV.43.0360890','LV','LV.43','Virešu pagasts','Viresu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21513,'LV.44.0460864','LV','LV.44','Īles pagasts','Iles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21514,'LV.44.0460876','LV','LV.44','Lielauces pagasts','Lielauces pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21515,'LV.44.0460890','LV','LV.44','Ukru pagasts','Ukru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21516,'LV.44.0460825','LV','LV.44','Vecauces pagasts','Vecauces pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21517,'LV.44.0460894','LV','LV.44','Vītiņu pagasts','Vitinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21518,'LV.45.0804948','LV','LV.45','Babītes pagasts','Babites pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21519,'LV.45.0804988','LV','LV.45','Salas pagasts','Salas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21520,'LV.46.0800625','LV','LV.46','Baldones pagasts','Baldones pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21521,'LV.47.0384400','LV','LV.47','Baltinavas novads','Baltinavas novads',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21522,'LV.03.0380246','LV','LV.03','Balvu pagasts','Balvu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21523,'LV.03.0380248','LV','LV.03','Bērzkalnes pagasts','Berzkalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21524,'LV.03.0380250','LV','LV.03','Bērzpils pagasts','Berzpils pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21525,'LV.03.0380252','LV','LV.03','Briežuciema pagasts','Briezuciema pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21526,'LV.03.0380256','LV','LV.03','Krišjāņu pagasts','Krisjanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21527,'LV.03.0380258','LV','LV.03','Kubulu pagasts','Kubulu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21528,'LV.03.0380266','LV','LV.03','Lazdulejas pagasts','Lazdulejas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21529,'LV.03.0380286','LV','LV.03','Tilžas pagasts','Tilzas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21530,'LV.03.0380290','LV','LV.03','Vectilžas pagasts','Vectilzas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21531,'LV.03.0380294','LV','LV.03','Vīksnas pagasts','Viksnas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21532,'LV.04.0400201','LV','LV.04','Bauska','Bauska',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21533,'LV.04.0400246','LV','LV.04','Brunavas pagasts','Brunavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21534,'LV.04.0400250','LV','LV.04','Ceraukstes pagasts','Ceraukstes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21535,'LV.09.0500201','LV','LV.09','Gulbene','Gulbene',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21536,'LV.04.0400252','LV','LV.04','Codes pagasts','Codes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21537,'LV.04.0400256','LV','LV.04','Dāviņu pagasts','Davinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21538,'LV.04.0400260','LV','LV.04','Gailīšu pagasts','Gailisu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21539,'LV.04.0400268','LV','LV.04','Īslīces pagasts','Islices pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21540,'LV.04.0400272','LV','LV.04','Mežotnes pagasts','Mezotnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21541,'LV.04.0400292','LV','LV.04','Vecsaules pagasts','Vecsaules pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21542,'LV.50.0964746','LV','LV.50','Brenguļu pagasts','Brengulu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21543,'LV.50.0964762','LV','LV.50','Kauguru pagasts','Kauguru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21544,'LV.50.0964784','LV','LV.50','Trikātas pagasts','Trikatas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21545,'LV.51.0840644','LV','LV.51','Blīdenes pagasts','Blidenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21546,'LV.51.0840605','LV','LV.51','Brocēni','Broceni',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21547,'LV.51.0840625','LV','LV.51','Cieceres pagasts','Cieceres pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21548,'LV.51.0840652','LV','LV.51','Gaiķu pagasts','Gaiku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21549,'LV.51.0840680','LV','LV.51','Remtes pagasts','Remtes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21550,'LV.52.0967148','LV','LV.52','Burtnieku pagasts','Burtnieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21551,'LV.52.0967154','LV','LV.52','Ēveles pagasts','Eveles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21552,'LV.52.0967170','LV','LV.52','Matīšu pagasts','Matisu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21553,'LV.52.0967178','LV','LV.52','Rencēnu pagasts','Rencenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21554,'LV.52.0967190','LV','LV.52','Valmieras pagasts','Valmieras pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21555,'LV.05.0420201','LV','LV.05','Cēsis','Cesis',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21556,'LV.52.0967192','LV','LV.52','Vecates pagasts','Vecates pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21557,'LV.53.0805200','LV','LV.53','Carnikavas novads','Carnikavas novads',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21558,'LV.05.0420290','LV','LV.05','Vaives pagasts','Vaives pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21559,'LV.55.0700807','LV','LV.55','Cesvaine','Cesvaine',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21560,'LV.55.0700827','LV','LV.55','Cesvaines pagasts','Cesvaines pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21561,'LV.56.0684944','LV','LV.56','Blontu pagasts','Blontu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21562,'LV.56.0684948','LV','LV.56','Ciblas pagasts','Ciblas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21563,'LV.56.0684966','LV','LV.56','Līdumnieku pagasts','Lidumnieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21564,'LV.56.0684990','LV','LV.56','Pušmucovas pagasts','Pusmucovas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21565,'LV.56.0684998','LV','LV.56','Zvirgzdenes pagasts','Zvirgzdenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21566,'LV.57.0601042','LV','LV.57','Andrupenes pagasts','Andrupenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21567,'LV.69.0440807','LV','LV.69','Ilūkste','Ilukste',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21568,'LV.57.0601044','LV','LV.57','Andzeļu pagasts','Andzelu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21569,'LV.70.0801817','LV','LV.70','Vangaži','Vangazi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21570,'LV.57.0601046','LV','LV.57','Asūnes pagasts','Asunes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21571,'LV.57.0601050','LV','LV.57','Bērziņu pagasts','Berzinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21572,'LV.57.0601009','LV','LV.57','Dagda','Dagda',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21573,'LV.07.0440242','LV','LV.07','Ambeļu pagasts','Ambelu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21574,'LV.57.0601054','LV','LV.57','Dagdas pagasts','Dagdas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21575,'LV.57.0601056','LV','LV.57','Ezernieku pagasts','Ezernieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21576,'LV.57.0601080','LV','LV.57','Ķepovas pagasts','Kepovas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21577,'LV.57.0601076','LV','LV.57','Konstantinovas pagasts','Konstantinovas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21578,'LV.57.0601092','LV','LV.57','Šķaunes pagasts','Skaunes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21579,'LV.57.0601090','LV','LV.57','Svariņu pagasts','Svarinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21580,'LV.06.0050000','LV','LV.06','Daugavpils','Daugavpils',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21581,'LV.07.0440246','LV','LV.07','Biķernieku pagasts','Bikernieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21582,'LV.07.0440250','LV','LV.07','Demenes pagasts','Demenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21583,'LV.07.0440252','LV','LV.07','Dubnas pagasts','Dubnas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21584,'LV.08.0460201','LV','LV.08','Dobele','Dobele',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21585,'LV.12.0540258','LV','LV.12','Kalnciema pagasts','Kalnciema pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21586,'LV.07.0440260','LV','LV.07','Kalkūnes pagasts','Kalkunes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21587,'LV.07.0440262','LV','LV.07','Kalupes pagasts','Kalupes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21588,'LV.07.0440264','LV','LV.07','Laucesas pagasts','Laucesas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21589,'LV.08.0460252','LV','LV.08','Bērzes pagasts','Berzes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21590,'LV.07.0440268','LV','LV.07','Līksnas pagasts','Liksnas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21591,'LV.07.0440270','LV','LV.07','Maļinovas pagasts','Malinovas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21592,'LV.E8.0781848','LV','LV.E8','Dekšāres pagasts','Deksares pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21593,'LV.07.0440272','LV','LV.07','Medumu pagasts','Medumu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21594,'LV.07.0440274','LV','LV.07','Naujenes pagasts','Naujenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21595,'LV.07.0440276','LV','LV.07','Nīcgales pagasts','Nicgales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21596,'LV.07.0440284','LV','LV.07','Salienas pagasts','Salienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21597,'LV.07.0440286','LV','LV.07','Skrudalienas pagasts','Skrudalienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21598,'LV.07.0440288','LV','LV.07','Sventes pagasts','Sventes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21599,'LV.07.0440292','LV','LV.07','Tabores pagasts','Tabores pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21600,'LV.07.0440294','LV','LV.07','Vaboles pagasts','Vaboles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21601,'LV.07.0440296','LV','LV.07','Vecsalienas pagasts','Vecsalienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21602,'LV.07.0440298','LV','LV.07','Višķu pagasts','Visku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21603,'LV.08.0460242','LV','LV.08','Annenieku pagasts','Annenieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21604,'LV.08.0460246','LV','LV.08','Auru pagasts','Auru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21605,'LV.08.0460254','LV','LV.08','Bikstu pagasts','Bikstu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21606,'LV.08.0460260','LV','LV.08','Dobeles pagasts','Dobeles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21607,'LV.61.0640807','LV','LV.61','Durbe','Durbe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21608,'LV.08.0460268','LV','LV.08','Jaunbērzes pagasts','Jaunberzes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21609,'LV.08.0460272','LV','LV.08','Krimūnu pagasts','Krimunu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21610,'LV.08.0460280','LV','LV.08','Naudītes pagasts','Naudites pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21611,'LV.08.0460284','LV','LV.08','Penkules pagasts','Penkules pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21612,'LV.71.0321050','LV','LV.71','Daudzeses pagasts','Daudzeses pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21613,'LV.08.0460298','LV','LV.08','Zebrenes pagasts','Zebrenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21614,'LV.33.0980233','LV','LV.33','Piltenes pagasts','Piltenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21615,'LV.60.0885150','LV','LV.60','Dundagas pagasts','Dundagas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21616,'LV.60.0885162','LV','LV.60','Kolkas pagasts','Kolkas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21617,'LV.61.0640850','LV','LV.61','Dunalkas pagasts','Dunalkas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21618,'LV.61.0640827','LV','LV.61','Durbes pagasts','Durbes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21619,'LV.61.0640888','LV','LV.61','Tadaiķu pagasts','Tadaiku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21620,'LV.61.0640894','LV','LV.61','Vecpils pagasts','Vecpils pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21621,'LV.73.0905790','LV','LV.73','Viesatu pagasts','Viesatu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21622,'LV.62.0905150','LV','LV.62','Engures pagasts','Engures pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21623,'LV.62.0905166','LV','LV.62','Lapmežciema pagasts','Lapmezciema pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21624,'LV.71.0321007','LV','LV.71','Jaunjelgava','Jaunjelgava',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21625,'LV.62.0905182','LV','LV.62','Smārdes pagasts','Smardes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21626,'LV.63.0705554','LV','LV.63','Ērgļu pagasts','Erglu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21627,'LV.63.0705560','LV','LV.63','Jumurdas pagasts','Jumurdas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21628,'LV.63.0705592','LV','LV.63','Sausnējas pagasts','Sausnejas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21629,'LV.71.0321027','LV','LV.71','Jaunjelgavas pagasts','Jaunjelgavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21630,'LV.64.0806000','LV','LV.64','Garkalnes novads','Garkalnes novads',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21631,'LV.65.0641044','LV','LV.65','Bārtas pagasts','Bartas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21632,'LV.65.0641056','LV','LV.65','Gaviezes pagasts','Gaviezes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21633,'LV.65.0641060','LV','LV.65','Grobiņas pagasts','Grobinas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21634,'LV.E8.0781817','LV','LV.E8','Viļāni','Vilani',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21635,'LV.65.0641076','LV','LV.65','Medzes pagasts','Medzes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21636,'LV.09.0500244','LV','LV.09','Beļavas pagasts','Belavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21637,'LV.09.0500248','LV','LV.09','Daukstu pagasts','Daukstu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21638,'LV.09.0500252','LV','LV.09','Druvienas pagasts','Druvienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21639,'LV.09.0500256','LV','LV.09','Galgauskas pagasts','Galgauskas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21640,'LV.09.0500260','LV','LV.09','Jaungulbenes pagasts','Jaungulbenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21641,'LV.09.0500264','LV','LV.09','Lejasciema pagasts','Lejasciema pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21642,'LV.68.0740605','LV','LV.68','Ikšķile','Ikskile',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21643,'LV.09.0500276','LV','LV.09','Līgo pagasts','Ligo pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21644,'LV.09.0500268','LV','LV.09','Litenes pagasts','Litenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21645,'LV.09.0500272','LV','LV.09','Lizuma pagasts','Lizuma pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21646,'LV.09.0500284','LV','LV.09','Rankas pagasts','Rankas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21647,'LV.09.0500288','LV','LV.09','Stāmerienas pagasts','Stamerienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21648,'LV.09.0500290','LV','LV.09','Stradu pagasts','Stradu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21649,'LV.69.0440815','LV','LV.69','Subate','Subate',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21650,'LV.09.0500294','LV','LV.09','Tirzas pagasts','Tirzas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21651,'LV.69.0440856','LV','LV.69','Eglaines pagasts','Eglaines pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21652,'LV.69.0440890','LV','LV.69','Šēderes pagasts','Sederes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21653,'LV.67.0406400','LV','LV.67','Iecavas novads','Iecavas novads',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21654,'LV.68.0740625','LV','LV.68','Tīnūžu pagasts','Tinuzu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21655,'LV.72.0425798','LV','LV.72','Zosēnu pagasts','Zosenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21656,'LV.69.0440844','LV','LV.69','Bebrenes pagasts','Bebrenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21657,'LV.69.0440854','LV','LV.69','Dvietes pagasts','Dvietes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21658,'LV.69.0440880','LV','LV.69','Pilskalnes pagasts','Pilskalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21659,'LV.69.0440835','LV','LV.69','Prodes pagasts','Prodes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21660,'LV.70.0801864','LV','LV.70','Inčukalna pagasts','Incukalna pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21661,'LV.71.0321078','LV','LV.71','Seces pagasts','Seces pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21662,'LV.71.0321080','LV','LV.71','Sērenes pagasts','Serenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21663,'LV.71.0321084','LV','LV.71','Staburaga pagasts','Staburaga pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21664,'LV.71.0321086','LV','LV.71','Sunākstes pagasts','Sunakstes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21665,'LV.72.0425756','LV','LV.72','Jaunpiebalgas pagasts','Jaunpiebalgas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21666,'LV.73.0905756','LV','LV.73','Jaunpils pagasts','Jaunpils pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21667,'LV.74.0110000','LV','LV.74','Jēkabpils','Jekabpils',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21668,'LV.10.0560248','LV','LV.10','Ābeļu pagasts','Abelu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21669,'LV.10.0560252','LV','LV.10','Dignājas pagasts','Dignajas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21670,'LV.10.0560254','LV','LV.10','Dunavas pagasts','Dunavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21671,'LV.10.0560266','LV','LV.10','Kalna pagasts','Kalna pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21672,'LV.10.0560274','LV','LV.10','Leimaņu pagasts','Leimanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21673,'LV.10.0560282','LV','LV.10','Rubenes pagasts','Rubenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21674,'LV.10.0560298','LV','LV.10','Zasas pagasts','Zasas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21675,'LV.11.0090000','LV','LV.11','Jelgava','Jelgava',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21676,'LV.12.0540248','LV','LV.12','Elejas pagasts','Elejas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21677,'LV.12.0540252','LV','LV.12','Glūdas pagasts','Gludas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21678,'LV.12.0540256','LV','LV.12','Jaunsvirlaukas pagasts','Jaunsvirlaukas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21679,'LV.12.0540260','LV','LV.12','Lielplatones pagasts','Lielplatones pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21680,'LV.12.0540262','LV','LV.12','Līvbērzes pagasts','Livberzes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21681,'LV.28.0880286','LV','LV.28','Strazdes pagasts','Strazdes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21682,'LV.78.0681009','LV','LV.78','Kārsava','Karsava',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21683,'LV.12.0540270','LV','LV.12','Platones pagasts','Platones pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21684,'LV.12.0540274','LV','LV.12','Sesavas pagasts','Sesavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21685,'LV.12.0540282','LV','LV.12','Svētes pagasts','Svetes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21686,'LV.12.0540286','LV','LV.12','Valgundes pagasts','Valgundes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21687,'LV.12.0540290','LV','LV.12','Vilces pagasts','Vilces pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21688,'LV.12.0540292','LV','LV.12','Vircavas pagasts','Vircavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21689,'LV.90.0761282','LV','LV.90','Sutru pagasts','Sutru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21690,'LV.12.0540296','LV','LV.12','Zaļenieku pagasts','Zalenieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21691,'LV.13.0130000','LV','LV.13','Jūrmala','Jurmala',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21692,'LV.77.0901244','LV','LV.77','Cēres pagasts','Ceres pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21693,'LV.77.0901211','LV','LV.77','Kandava','Kandava',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21694,'LV.77.0901262','LV','LV.77','Kandavas pagasts','Kandavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21695,'LV.77.0901270','LV','LV.77','Matkules pagasts','Matkules pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21696,'LV.77.0901288','LV','LV.77','Vānes pagasts','Vanes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21697,'LV.77.0901292','LV','LV.77','Zantes pagasts','Zantes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21698,'LV.77.0901294','LV','LV.77','Zemītes pagasts','Zemites pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21699,'LV.78.0681054','LV','LV.78','Goliševas pagasts','Golisevas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21700,'LV.78.0681068','LV','LV.78','Malnavas pagasts','Malnavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21701,'LV.78.0681072','LV','LV.78','Mērdzenes pagasts','Merdzenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21702,'LV.78.0681070','LV','LV.78','Mežvidu pagasts','Mezvidu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21703,'LV.82.0326154','LV','LV.82','Iršu pagasts','Irsu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21704,'LV.78.0681094','LV','LV.78','Salnavas pagasts','Salnavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21705,'LV.A2.0801009','LV','LV.A2','Olaine','Olaine',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21706,'LV.79.0741044','LV','LV.79','Birzgales pagasts','Birzgales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21707,'LV.79.0741009','LV','LV.79','Ķegums','Kegums',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21708,'LV.79.0741084','LV','LV.79','Rembates pagasts','Rembates pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21709,'LV.79.0741029','LV','LV.79','Tomes pagasts','Tomes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21710,'LV.80.0800807','LV','LV.80','Baloži','Balozi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21711,'LV.80.0800856','LV','LV.80','Daugmales pagasts','Daugmales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21712,'LV.82.0326146','LV','LV.82','Bebru pagasts','Bebru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21713,'LV.87.0741413','LV','LV.87','Lielvārde','Lielvarde',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21714,'LV.80.0800870','LV','LV.80','Ķekavas pagasts','Kekavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21715,'LV.81.0960244','LV','LV.81','Bērzaines pagasts','Berzaines pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21716,'LV.81.0960252','LV','LV.81','Dikļu pagasts','Diklu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21717,'LV.88.0421211','LV','LV.88','Līgatne','Ligatne',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21718,'LV.81.0960264','LV','LV.81','Kocēnu pagasts','Kocenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21719,'LV.81.0960288','LV','LV.81','Vaidavas pagasts','Vaidavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21720,'LV.81.0960296','LV','LV.81','Zilākalna pagasts','Zilakalna pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21721,'LV.87.0741433','LV','LV.87','Lielvārdes pagasts','Lielvardes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21722,'LV.82.0326160','LV','LV.82','Kokneses pagasts','Kokneses pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21723,'LV.14.0600248','LV','LV.14','Aulejas pagasts','Aulejas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21724,'LV.14.0600262','LV','LV.14','Indras pagasts','Indras pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21725,'LV.85.0566970','LV','LV.85','Kūku pagasts','Kuku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21726,'LV.14.0600264','LV','LV.14','Izvaltas pagasts','Izvaltas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21727,'LV.14.0600268','LV','LV.14','Kalniešu pagasts','Kalniesu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21728,'LV.14.0600270','LV','LV.14','Kaplavas pagasts','Kaplavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21729,'LV.14.0600274','LV','LV.14','Kombuļu pagasts','Kombulu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21730,'LV.14.0600201','LV','LV.14','Krāslava','Kraslava',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21731,'LV.14.0600278','LV','LV.14','Krāslavas pagasts','Kraslavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21732,'LV.14.0600284','LV','LV.14','Piedrujas pagasts','Piedrujas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21733,'LV.14.0600286','LV','LV.14','Robežnieku pagasts','Robeznieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21734,'LV.16.0170000','LV','LV.16','Liepāja','Liepaja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21735,'LV.14.0600288','LV','LV.14','Skaistas pagasts','Skaistas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21736,'LV.14.0600296','LV','LV.14','Ūdrīšu pagasts','Udrisu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21737,'LV.84.0806968','LV','LV.84','Krimuldas pagasts','Krimuldas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21738,'LV.15.0620290','LV','LV.15','Snēpeles pagasts','Snepeles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21739,'LV.31.0250000','LV','LV.31','Valmiera','Valmiera',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21740,'LV.84.0806956','LV','LV.84','Lēdurgas pagasts','Ledurgas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21741,'LV.85.0566946','LV','LV.85','Atašienes pagasts','Atasienes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21742,'LV.85.0566968','LV','LV.85','Krustpils pagasts','Krustpils pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21743,'LV.85.0566976','LV','LV.85','Mežāres pagasts','Mezares pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21744,'LV.87.0741448','LV','LV.87','Jumpravas pagasts','Jumpravas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21745,'LV.15.0620254','LV','LV.15','Īvandes pagasts','Ivandes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21746,'LV.85.0566994','LV','LV.85','Variešu pagasts','Variesu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21747,'LV.85.0566996','LV','LV.85','Vīpes pagasts','Vipes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21748,'LV.15.0620246','LV','LV.15','Ēdoles pagasts','Edoles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21749,'LV.33.0980260','LV','LV.33','Puzes pagasts','Puzes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21750,'LV.15.0620250','LV','LV.15','Gudenieku pagasts','Gudenieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21751,'LV.15.0620274','LV','LV.15','Pelču pagasts','Pelcu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21752,'LV.15.0620258','LV','LV.15','Kabiles pagasts','Kabiles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21753,'LV.15.0620201','LV','LV.15','Kuldīga','Kuldiga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21754,'LV.15.0620260','LV','LV.15','Kurmāles pagasts','Kurmales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21755,'LV.15.0620264','LV','LV.15','Laidu pagasts','Laidu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21756,'LV.15.0620272','LV','LV.15','Padures pagasts','Padures pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21757,'LV.15.0620280','LV','LV.15','Rendas pagasts','Rendas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21758,'LV.15.0620284','LV','LV.15','Rumbas pagasts','Rumbas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21759,'LV.15.0620292','LV','LV.15','Turlavas pagasts','Turlavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21760,'LV.15.0620296','LV','LV.15','Vārmes pagasts','Varmes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21761,'LV.87.0741464','LV','LV.87','Lēdmanes pagasts','Ledmanes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21762,'LV.88.0421262','LV','LV.88','Līgatnes pagasts','Ligatnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21763,'LV.18.0660252','LV','LV.18','Katvaru pagasts','Katvaru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21764,'LV.18.0660201','LV','LV.18','Limbaži','Limbazi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21765,'LV.18.0660264','LV','LV.18','Limbažu pagasts','Limbazu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21766,'LV.18.0660268','LV','LV.18','Pāles pagasts','Pales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21767,'LV.18.0660276','LV','LV.18','Skultes pagasts','Skultes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21768,'LV.90.0761268','LV','LV.90','Rudzātu pagasts','Rudzatu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21769,'LV.18.0660280','LV','LV.18','Umurgas pagasts','Umurgas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21770,'LV.18.0660284','LV','LV.18','Vidrižu pagasts','Vidrizu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21771,'LV.18.0660288','LV','LV.18','Viļķenes pagasts','Vilkenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21772,'LV.90.0761286','LV','LV.90','Turku pagasts','Turku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21773,'LV.90.0761252','LV','LV.90','Jersikas pagasts','Jersikas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21774,'LV.90.0761211','LV','LV.90','Līvāni','Livani',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21775,'LV.90.0761266','LV','LV.90','Rožupes pagasts','Rozupes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21776,'LV.91.0701458','LV','LV.91','Indrānu pagasts','Indranu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21777,'LV.91.0701413','LV','LV.91','Lubāna','Lubana',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21778,'LV.19.0680246','LV','LV.19','Briģu pagasts','Brigu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21779,'LV.19.0680250','LV','LV.19','Cirmas pagasts','Cirmas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21780,'LV.19.0680258','LV','LV.19','Isnaudas pagasts','Isnaudas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21781,'LV.19.0680260','LV','LV.19','Istras pagasts','Istras pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21782,'LV.19.0680201','LV','LV.19','Ludza','Ludza',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21783,'LV.19.0680278','LV','LV.19','Nirzas pagasts','Nirzas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21784,'LV.19.0680280','LV','LV.19','Ņukšu pagasts','Nuksu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21785,'LV.19.0680286','LV','LV.19','Pildas pagasts','Pildas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21786,'LV.19.0680288','LV','LV.19','Pureņu pagasts','Purenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21787,'LV.19.0680292','LV','LV.19','Rundēnu pagasts','Rundenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21788,'LV.20.0700242','LV','LV.20','Aronas pagasts','Aronas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21789,'LV.20.0700244','LV','LV.20','Barkavas pagasts','Barkavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21790,'LV.20.0700246','LV','LV.20','Bērzaunes pagasts','Berzaunes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21791,'LV.20.0700250','LV','LV.20','Dzelzavas pagasts','Dzelzavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21792,'LV.20.0700262','LV','LV.20','Kalsnavas pagasts','Kalsnavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21793,'LV.20.0700270','LV','LV.20','Ļaudonas pagasts','Laudonas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21794,'LV.20.0700266','LV','LV.20','Lazdonas pagasts','Lazdonas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21795,'LV.95.0807600','LV','LV.95','Mārupes novads','Marupes novads',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21796,'LV.20.0700290','LV','LV.20','Sarkaņu pagasts','Sarkanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21797,'LV.20.0700268','LV','LV.20','Liezēres pagasts','Liezeres pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21798,'LV.20.0700201','LV','LV.20','Madona','Madona',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21799,'LV.20.0700274','LV','LV.20','Mārcienas pagasts','Marcienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21800,'LV.20.0700276','LV','LV.20','Mētrienas pagasts','Metrienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21801,'LV.21.0740201','LV','LV.21','Ogre','Ogre',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21802,'LV.20.0700282','LV','LV.20','Ošupes pagasts','Osupes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21803,'LV.20.0700286','LV','LV.20','Praulienas pagasts','Praulienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21804,'LV.28.0880201','LV','LV.28','Talsi','Talsi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21805,'LV.20.0700296','LV','LV.20','Vestienas pagasts','Vestienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21806,'LV.94.0807400','LV','LV.94','Mālpils novads','Malpils novads',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21807,'LV.96.0961031','LV','LV.96','Mazsalacas pagasts','Mazsalacas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21808,'LV.E6.0561815','LV','LV.E6','Viesīte','Viesite',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21809,'LV.96.0961076','LV','LV.96','Ramatas pagasts','Ramatas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21810,'LV.96.0961082','LV','LV.96','Sēļu pagasts','Selu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21811,'LV.96.0961084','LV','LV.96','Skaņkalnes pagasts','Skankalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21812,'LV.F1.0887600','LV','LV.F1','Mērsraga novads','Mersraga novads',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21813,'LV.97.0967366','LV','LV.97','Ķoņu pagasts','Konu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21814,'LV.97.0967372','LV','LV.97','Naukšēnu pagasts','Nauksenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21815,'LV.A5.0641413','LV','LV.A5','Pāvilosta','Pavilosta',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21816,'LV.98.0327166','LV','LV.98','Mazzalves pagasts','Mazzalves pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21817,'LV.98.0327170','LV','LV.98','Neretas pagasts','Neretas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21818,'LV.33.0980213','LV','LV.33','Piltene','Piltene',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21819,'LV.98.0327174','LV','LV.98','Pilskalnes pagasts','Pilskalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21820,'LV.98.0327196','LV','LV.98','Zalves pagasts','Zalves pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21821,'LV.28.0880217','LV','LV.28','Valdemārpils','Valdemarpils',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21822,'LV.99.0647978','LV','LV.99','Nīcas pagasts','Nicas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21823,'LV.A6.0321413','LV','LV.A6','Pļaviņas','Plavinas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21824,'LV.99.0647980','LV','LV.99','Otaņķu pagasts','Otanku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21825,'LV.21.0740256','LV','LV.21','Ķeipenes pagasts','Keipenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21826,'LV.21.0740252','LV','LV.21','Krapes pagasts','Krapes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21827,'LV.21.0740260','LV','LV.21','Lauberes pagasts','Lauberes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21828,'LV.21.0740268','LV','LV.21','Madlienas pagasts','Madlienas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21829,'LV.21.0740272','LV','LV.21','Mazozolu pagasts','Mazozolu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21830,'LV.22.0760201','LV','LV.22','Preiļi','Preili',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21831,'LV.24.0780246','LV','LV.24','Čornajas pagasts','Cornajas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21832,'LV.21.0740276','LV','LV.21','Meņģeles pagasts','Mengeles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21833,'LV.21.0740280','LV','LV.21','Ogresgala pagasts','Ogresgala pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21834,'LV.21.0740288','LV','LV.21','Suntažu pagasts','Suntazu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21835,'LV.21.0740292','LV','LV.21','Taurupes pagasts','Taurupes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21836,'LV.33.0980290','LV','LV.33','Ziru pagasts','Ziru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21837,'LV.A2.0801080','LV','LV.A2','Olaines pagasts','Olaines pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21838,'LV.A3.0546744','LV','LV.A3','Cenu pagasts','Cenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21839,'LV.A3.0546778','LV','LV.A3','Salgales pagasts','Salgales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21840,'LV.A4.0427574','LV','LV.A4','Raiskuma pagasts','Raiskuma pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21841,'LV.33.0980294','LV','LV.33','Zlēku pagasts','Zleku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21842,'LV.23.0210000','LV','LV.23','Rēzekne','Rezekne',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21843,'LV.A4.0427580','LV','LV.A4','Stalbes pagasts','Stalbes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21844,'LV.A4.0427582','LV','LV.A4','Straupes pagasts','Straupes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21845,'LV.22.0760274','LV','LV.22','Saunas pagasts','Saunas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21846,'LV.A5.0641486','LV','LV.A5','Sakas pagasts','Sakas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21847,'LV.A5.0641496','LV','LV.A5','Vērgales pagasts','Vergales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21848,'LV.A6.0321442','LV','LV.A6','Aiviekstes pagasts','Aiviekstes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21849,'LV.A6.0321458','LV','LV.A6','Klintaines pagasts','Klintaines pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21850,'LV.A6.0321492','LV','LV.A6','Vietalvas pagasts','Vietalvas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21851,'LV.22.0760244','LV','LV.22','Aizkalnes pagasts','Aizkalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21852,'LV.22.0760256','LV','LV.22','Pelēču pagasts','Pelecu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21853,'LV.22.0760258','LV','LV.22','Preiļu pagasts','Preilu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21854,'LV.24.0780274','LV','LV.24','Nagļu pagasts','Naglu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21855,'LV.A8.0641646','LV','LV.A8','Bunkas pagasts','Bunkas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21856,'LV.A8.0641658','LV','LV.A8','Gramzdas pagasts','Gramzdas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21857,'LV.A8.0641664','LV','LV.A8','Kalētu pagasts','Kaletu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21858,'LV.A8.0641682','LV','LV.A8','Priekules pagasts','Priekules pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21859,'LV.B9.0407788','LV','LV.B9','Svitenes pagasts','Svitenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21860,'LV.A8.0641698','LV','LV.A8','Virgas pagasts','Virgas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21861,'LV.A9.0427360','LV','LV.A9','Liepas pagasts','Liepas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21862,'LV.A9.0427364','LV','LV.A9','Mārsnēnu pagasts','Marsnenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21863,'LV.A9.0427372','LV','LV.A9','Priekuļu pagasts','Priekulu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21864,'LV.A9.0427394','LV','LV.A9','Veselavas pagasts','Veselavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21865,'LV.B1.0427748','LV','LV.B1','Drustu pagasts','Drustu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21866,'LV.B1.0427776','LV','LV.B1','Raunas pagasts','Raunas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21867,'LV.24.0780242','LV','LV.24','Audriņu pagasts','Audrinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21868,'LV.24.0780244','LV','LV.24','Bērzgales pagasts','Berzgales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21869,'LV.24.0780250','LV','LV.24','Dricānu pagasts','Dricanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21870,'LV.24.0780252','LV','LV.24','Feimaņu pagasts','Feimanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21871,'LV.24.0780254','LV','LV.24','Gaigalavas pagasts','Gaigalavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21872,'LV.24.0780256','LV','LV.24','Griškānu pagasts','Griskanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21873,'LV.C1.0661405','LV','LV.C1','Ainaži','Ainazi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21874,'LV.24.0780258','LV','LV.24','Ilzeskalna pagasts','Ilzeskalna pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21875,'LV.24.0780260','LV','LV.24','Kantinieku pagasts','Kantinieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21876,'LV.24.0780262','LV','LV.24','Kaunatas pagasts','Kaunatas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21877,'LV.24.0780266','LV','LV.24','Lendžu pagasts','Lendzu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21878,'LV.24.0780268','LV','LV.24','Lūznavas pagasts','Luznavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21879,'LV.24.0780272','LV','LV.24','Mākoņkalna pagasts','Makonkalna pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21880,'LV.24.0780270','LV','LV.24','Maltas pagasts','Maltas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21881,'LV.B8.0961615','LV','LV.B8','Rūjiena','Rujiena',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21882,'LV.B8.0961668','LV','LV.B8','Lodes pagasts','Lodes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21883,'LV.24.0780284','LV','LV.24','Nautrēnu pagasts','Nautrenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21884,'LV.24.0780276','LV','LV.24','Ozolaines pagasts','Ozolaines pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21885,'LV.24.0780278','LV','LV.24','Ozolmuižas pagasts','Ozolmuizas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21886,'LV.24.0780280','LV','LV.24','Pušas pagasts','Pusas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21887,'LV.24.0780282','LV','LV.24','Rikavas pagasts','Rikavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21888,'LV.24.0780286','LV','LV.24','Sakstagala pagasts','Sakstagala pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21889,'LV.C1.0661425','LV','LV.C1','Ainažu pagasts','Ainazu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21890,'LV.24.0780288','LV','LV.24','Silmalas pagasts','Silmalas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21891,'LV.C3.0801211','LV','LV.C3','Salaspils','Salaspils',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21892,'LV.24.0780292','LV','LV.24','Stoļerovas pagasts','Stolerovas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21893,'LV.24.0780294','LV','LV.24','Stružānu pagasts','Struzanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21894,'LV.24.0780296','LV','LV.24','Vērēmu pagasts','Veremu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21895,'LV.B3.0766348','LV','LV.B3','Galēnu pagasts','Galenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21896,'LV.B3.0766362','LV','LV.B3','Riebiņu pagasts','Riebinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21897,'LV.B3.0766370','LV','LV.B3','Rušonas pagasts','Rusonas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21898,'LV.B3.0766376','LV','LV.B3','Silajāņu pagasts','Silajanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21899,'LV.D1.0941674','LV','LV.D1','Palsmanes pagasts','Palsmanes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21900,'LV.B3.0766378','LV','LV.B3','Sīļukalna pagasts','Silukalna pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21901,'LV.B3.0766380','LV','LV.B3','Stabulnieku pagasts','Stabulnieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21902,'LV.B9.0407796','LV','LV.B9','Viesturu pagasts','Viesturu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21903,'LV.27.0840201','LV','LV.27','Saldus','Saldus',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21904,'LV.25.0010000','LV','LV.25','Rīga','Riga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21905,'LV.B4.0888301','LV','LV.B4','Rojas novads','Rojas novads',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21906,'LV.B8.0961658','LV','LV.B8','Jeru pagasts','Jeru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21907,'LV.B5.0808400','LV','LV.B5','Ropažu novads','Ropazu novads',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21908,'LV.C7.0801615','LV','LV.C7','Sigulda','Sigulda',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21909,'LV.B6.0648552','LV','LV.B6','Dunikas pagasts','Dunikas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21910,'LV.B6.0648584','LV','LV.B6','Rucavas pagasts','Rucavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21911,'LV.B7.0387564','LV','LV.B7','Lazdukalna pagasts','Lazdukalna pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21912,'LV.B7.0387574','LV','LV.B7','Rugāju pagasts','Rugaju pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21913,'LV.B8.0961656','LV','LV.B8','Ipiķu pagasts','Ipiku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21914,'LV.B8.0961694','LV','LV.B8','Vilpulkas pagasts','Vilpulkas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21915,'LV.B9.0407776','LV','LV.B9','Rundāles pagasts','Rundales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21916,'LV.C1.0661460','LV','LV.C1','Liepupes pagasts','Liepupes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21917,'LV.C1.0661415','LV','LV.C1','Salacgrīva','Salacgriva',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21918,'LV.C1.0661435','LV','LV.C1','Salacgrīvas pagasts','Salacgrivas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21919,'LV.C2.0568786','LV','LV.C2','Salas pagasts','Salas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21920,'LV.C2.0568790','LV','LV.C2','Sēlpils pagasts','Selpils pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21921,'LV.C9.0621282','LV','LV.C9','Rudbāržu pagasts','Rudbarzu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21922,'LV.C3.0801231','LV','LV.C3','Salaspils pagasts','Salaspils pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21923,'LV.27.0840248','LV','LV.27','Ezeres pagasts','Ezeres pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21924,'LV.27.0840256','LV','LV.27','Jaunauces pagasts','Jaunauces pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21925,'LV.27.0840258','LV','LV.27','Jaunlutriņu pagasts','Jaunlutrinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21926,'LV.27.0840262','LV','LV.27','Kursīšu pagasts','Kursisu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21927,'LV.27.0840266','LV','LV.27','Lutriņu pagasts','Lutrinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21928,'LV.D1.0941615','LV','LV.D1','Smiltene','Smiltene',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21929,'LV.27.0840270','LV','LV.27','Nīgrandes pagasts','Nigrandes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21930,'LV.C7.0801666','LV','LV.C7','Mores pagasts','Mores pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21931,'LV.27.0840272','LV','LV.27','Novadnieku pagasts','Novadnieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21932,'LV.27.0840276','LV','LV.27','Pampāļu pagasts','Pampalu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21933,'LV.D3.0941813','LV','LV.D3','Seda','Seda',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21934,'LV.D3.0941817','LV','LV.D3','Strenči','Strenci',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21935,'LV.27.0840282','LV','LV.27','Rubas pagasts','Rubas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21936,'LV.27.0840286','LV','LV.27','Saldus pagasts','Saldus pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21937,'LV.D1.0941680','LV','LV.D1','Smiltenes pagasts','Smiltenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21938,'LV.27.0840288','LV','LV.27','Šķēdes pagasts','Skedes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21939,'LV.27.0840292','LV','LV.27','Vadakstes pagasts','Vadakstes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21940,'LV.27.0840294','LV','LV.27','Zaņas pagasts','Zanas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21941,'LV.28.0880258','LV','LV.28','Īves pagasts','Ives pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21942,'LV.27.0840296','LV','LV.27','Zirņu pagasts','Zirnu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21943,'LV.27.0840298','LV','LV.27','Zvārdes pagasts','Zvardes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21944,'LV.C5.0801413','LV','LV.C5','Saulkrasti','Saulkrasti',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21945,'LV.C5.0801433','LV','LV.C5','Saulkrastu pagasts','Saulkrastu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21946,'LV.C6.0809200','LV','LV.C6','Sējas novads','Sejas novads',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21947,'LV.C7.0801642','LV','LV.C7','Allažu pagasts','Allazu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21948,'LV.C7.0801694','LV','LV.C7','Siguldas pagasts','Siguldas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21949,'LV.C8.0328200','LV','LV.C8','Skrīveru novads','Skriveru novads',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21950,'LV.C9.0621268','LV','LV.C9','Nīkrāces pagasts','Nikraces pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21951,'LV.C9.0621278','LV','LV.C9','Raņķu pagasts','Ranku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21952,'LV.D1.0941690','LV','LV.D1','Variņu pagasts','Varinu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21953,'LV.C9.0621229','LV','LV.C9','Skrundas pagasts','Skrundas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21954,'LV.D1.0941644','LV','LV.D1','Bilskas pagasts','Bilskas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21955,'LV.D1.0941646','LV','LV.D1','Blomes pagasts','Blomes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21956,'LV.D1.0941648','LV','LV.D1','Brantu pagasts','Brantu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21957,'LV.D1.0941658','LV','LV.D1','Grundzāles pagasts','Grundzales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21958,'LV.D1.0941670','LV','LV.D1','Launkalnes pagasts','Launkalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21959,'LV.D2.0809600','LV','LV.D2','Stopiņu novads','Stopinu novads',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21960,'LV.D3.0941860','LV','LV.D3','Jērcēnu pagasts','Jercenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21961,'LV.D3.0941876','LV','LV.D3','Plāņu pagasts','Planu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21962,'LV.28.0880242','LV','LV.28','Abavas pagasts','Abavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21963,'LV.28.0880237','LV','LV.28','Ārlavas pagasts','Arlavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21964,'LV.28.0880246','LV','LV.28','Balgales pagasts','Balgales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21965,'LV.30.0940266','LV','LV.30','Kārķu pagasts','Karku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21966,'LV.28.0880254','LV','LV.28','Ģibuļu pagasts','Gibulu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21967,'LV.28.0880264','LV','LV.28','Ķūļciema pagasts','Kulciema pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21968,'LV.28.0880268','LV','LV.28','Laidzes pagasts','Laidzes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21969,'LV.28.0880270','LV','LV.28','Laucienes pagasts','Laucienes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21970,'LV.E1.0701878','LV','LV.E1','Murmastienes pagasts','Murmastienes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21971,'LV.28.0880272','LV','LV.28','Lībagu pagasts','Libagu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21972,'LV.28.0880274','LV','LV.28','Lubes pagasts','Lubes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21973,'LV.28.0880213','LV','LV.28','Sabile','Sabile',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21974,'LV.28.0880215','LV','LV.28','Stende','Stende',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21975,'LV.28.0880292','LV','LV.28','Valdgales pagasts','Valdgales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21976,'LV.E6.0561858','LV','LV.E6','Elkšņu pagasts','Elksnu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21977,'LV.E3.0429350','LV','LV.E3','Dzērbenes pagasts','Dzerbenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21978,'LV.28.0880294','LV','LV.28','Vandzenes pagasts','Vandzenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21979,'LV.28.0880296','LV','LV.28','Virbu pagasts','Virbu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21980,'LV.D5.0468944','LV','LV.D5','Augstkalnes pagasts','Augstkalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21981,'LV.D5.0468956','LV','LV.D5','Bukaišu pagasts','Bukaisu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21982,'LV.D5.0468988','LV','LV.D5','Tērvetes pagasts','Tervetes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21983,'LV.E4.0409580','LV','LV.E4','Skaistkalnes pagasts','Skaistkalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21984,'LV.29.0900246','LV','LV.29','Degoles pagasts','Degoles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21985,'LV.29.0900248','LV','LV.29','Džūkstes pagasts','Dzukstes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21986,'LV.29.0900254','LV','LV.29','Irlavas pagasts','Irlavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21987,'LV.29.0900258','LV','LV.29','Jaunsātu pagasts','Jaunsatu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21988,'LV.E6.0561880','LV','LV.E6','Rites pagasts','Rites pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21989,'LV.29.0900274','LV','LV.29','Pūres pagasts','Pures pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21990,'LV.29.0900278','LV','LV.29','Sēmes pagasts','Semes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21991,'LV.29.0900280','LV','LV.29','Slampes pagasts','Slampes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21992,'LV.29.0900201','LV','LV.29','Tukums','Tukums',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21993,'LV.29.0900284','LV','LV.29','Tumes pagasts','Tumes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21994,'LV.29.0900296','LV','LV.29','Zentenes pagasts','Zentenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21995,'LV.E6.0561888','LV','LV.E6','Saukas pagasts','Saukas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21996,'LV.D7.0649354','LV','LV.D7','Embūtes pagasts','Embutes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21997,'LV.D7.0649392','LV','LV.D7','Vaiņodes pagasts','Vainodes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21998,'LV.E4.0409544','LV','LV.E4','Bārbeles pagasts','Barbeles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21999,'LV.30.0940252','LV','LV.30','Ērģemes pagasts','Ergemes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22000,'LV.30.0940288','LV','LV.30','Valkas pagasts','Valkas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22001,'LV.30.0940292','LV','LV.30','Vijciema pagasts','Vijciema pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22002,'LV.E8.0781890','LV','LV.E8','Sokolku pagasts','Sokolku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22003,'LV.30.0940296','LV','LV.30','Zvārtavas pagasts','Zvartavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22004,'LV.E1.0701817','LV','LV.E1','Varakļāni','Varaklani',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22005,'LV.E1.0701894','LV','LV.E1','Varakļānu pagasts','Varaklanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22006,'LV.E2.0769164','LV','LV.E2','Rožkalnu pagasts','Rozkalnu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22007,'LV.E2.0769190','LV','LV.E2','Upmalas pagasts','Upmalas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22008,'LV.E2.0769194','LV','LV.E2','Vārkavas pagasts','Varkavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22009,'LV.E3.0429354','LV','LV.E3','Inešu pagasts','Inesu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22010,'LV.E3.0429358','LV','LV.E3','Kaives pagasts','Kaives pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22011,'LV.E3.0429386','LV','LV.E3','Taurenes pagasts','Taurenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22012,'LV.E3.0429392','LV','LV.E3','Vecpiebalgas pagasts','Vecpiebalgas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22013,'LV.E4.0409562','LV','LV.E4','Kurmenes pagasts','Kurmenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22014,'LV.E4.0409584','LV','LV.E4','Stelpes pagasts','Stelpes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22015,'LV.34.0804400','LV','LV.34','Ādažu novads','Adazu novads',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22016,'LV.35.0604342','LV','LV.35','Aglonas pagasts','Aglonas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22017,'LV.35.0604358','LV','LV.35','Grāveru pagasts','Graveru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22018,'LV.38.0560805','LV','LV.38','Aknīste','Akniste',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22019,'LV.03.0380201','LV','LV.03','Balvi','Balvi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22020,'LV.46.0800605','LV','LV.46','Baldone','Baldone',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22021,'LV.65.0641009','LV','LV.65','Grobiņa','Grobina',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22022,'LV.96.0961011','LV','LV.96','Mazsalaca','Mazsalaca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22023,'LV.A3.0546766','LV','LV.A3','Ozolnieku pagasts','Ozolnieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22024,'LV.A8.0641615','LV','LV.A8','Priekule','Priekule',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22025,'LV.29.0900268','LV','LV.29','Lestenes pagasts','Lestenes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22026,'LV.30.0940201','LV','LV.30','Valka','Valka',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22027,'LV.33.0980256','LV','LV.33','Popes pagasts','Popes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22028,'LV.E7.0381660','LV','LV.E7','Kupravas pagasts','Kupravas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22029,'LV.E7.0381615','LV','LV.E7','Viļaka','Vilaka',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22030,'LV.E4.0409590','LV','LV.E4','Valles pagasts','Valles pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22031,'LV.E4.0409594','LV','LV.E4','Vecumnieku pagasts','Vecumnieku pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22032,'LV.32.0270000','LV','LV.32','Ventspils','Ventspils',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22033,'LV.33.0980244','LV','LV.33','Ances pagasts','Ances pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22034,'LV.33.0980250','LV','LV.33','Jūrkalnes pagasts','Jurkalnes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22035,'LV.E9.0681817','LV','LV.E9','Zilupe','Zilupe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22036,'LV.33.0980266','LV','LV.33','Tārgales pagasts','Targales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22037,'LV.33.0980270','LV','LV.33','Ugāles pagasts','Ugales pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22038,'LV.33.0980274','LV','LV.33','Usmas pagasts','Usmas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22039,'LV.33.0980278','LV','LV.33','Užavas pagasts','Uzavas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22040,'LV.33.0980284','LV','LV.33','Vārves pagasts','Varves pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22041,'LV.E6.0561835','LV','LV.E6','Viesītes pagasts','Viesites pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22042,'LV.E7.0381670','LV','LV.E7','Medņevas pagasts','Mednevas pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22043,'LV.E7.0381682','LV','LV.E7','Šķilbēnu pagasts','Skilbenu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22044,'LV.E7.0381678','LV','LV.E7','Susāju pagasts','Susaju pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22045,'LV.E7.0381692','LV','LV.E7','Vecumu pagasts','Vecumu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22046,'LV.E7.0381698','LV','LV.E7','Žīguru pagasts','Ziguru pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22047,'LV.E8.0781898','LV','LV.E8','Viļānu pagasts','Vilanu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22048,'LV.E9.0681864','LV','LV.E9','Lauderu pagasts','Lauderu pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22049,'LV.E9.0681884','LV','LV.E9','Pasienes pagasts','Pasienes pagasts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22050,'LV.E9.0681896','LV','LV.E9','Zaļesjes pagasts','Zalesjes pagasts',1);

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

INSERT INTO `<<prefix>>cities` VALUES (453754,'LV','Valmiera','Valmiera',57.5411,25.4275,'P','PPLA','LV.31','LV.31.0250000',26963,'Europe/Riga',1,'2017-12-27 23:00:00','2017-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (453850,'LV','Zilupe','Zilupe',56.3862,28.1217,'P','PPLA','LV.E9','LV.E9.0681817',1897,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (453922,'LV','Zelmeņi','Zelmeni',56.4517,23.3519,'P','PPLA','LV.D5','LV.D5.0468988',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (454130,'LV','Viļaka','Vilaka',57.1846,27.6722,'P','PPLA','LV.E7','LV.E7.0381615',1525,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (454178,'LV','Viļāni','Vilani',56.5525,26.9245,'P','PPLA','LV.E8','LV.E8.0781817',3934,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (454216,'LV','Viesīte','Viesite',56.3475,25.5551,'P','PPLA','LV.E6','LV.E6.0561815',2162,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (454273,'LV','Vecumnieki','Vecumnieki',56.6061,24.5223,'P','PPLA','LV.E4','LV.E4.0409594',2487,'Europe/Riga',1,'2017-12-05 23:00:00','2017-12-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (454310,'LV','Ventspils','Ventspils',57.3899,21.5729,'P','PPLA','LV.32','LV.32.0270000',42644,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (454372,'LV','Vecvārkava','Vecvarkava',56.1984,26.5081,'P','PPLA','LV.E2','LV.E2.0769190',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (454408,'LV','Vecpiebalga','Vecpiebalga',57.0609,25.8162,'P','PPLA','LV.E3','LV.E3.0429392',596,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (454530,'LV','Varakļāni','Varaklani',56.6083,26.7538,'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` VALUES (454572,'LV','Valka','Valka',57.7752,26.0101,'P','PPLA','LV.30','LV.30.0940201',6589,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (454602,'LV','Vaiņode','Vainode',56.4333,21.8667,'P','PPLA','LV.D7','LV.D7.0649392',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (454714,'LV','Ulbroka','Ulbroka',56.9363,24.3039,'P','PPLA','LV.D2','LV.D2.0809600',2800,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (454768,'LV','Tukums','Tukums',56.9669,23.1553,'P','PPLA','LV.29','LV.29.0900201',18348,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (454970,'LV','Talsi','Talsi',57.2456,22.5814,'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` VALUES (455166,'LV','Strenči','Strenci',57.6257,25.6854,'P','PPLA','LV.D3','LV.D3.0941817',1593,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (455293,'LV','Stalbe','Stalbe',57.3707,25.0311,'P','PPLA','LV.A4','LV.A4.0427580',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (455406,'LV','Smiltene','Smiltene',57.4244,25.9016,'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` VALUES (455427,'LV','Smārde','Smarde',56.9542,23.3374,'P','PPLA','LV.62','LV.62.0905182',734,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (455520,'LV','Skrunda','Skrunda',56.6833,22.0167,'P','PPLA','LV.C9','LV.C9.0621209',2659,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (455523,'LV','Skrīveri','Skriveri',56.645,25.1206,'P','PPLA','LV.C8','LV.C8.0328200',2879,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (455718,'LV','Sigulda','Sigulda',57.1519,24.8647,'P','PPLA','LV.C7','LV.C7.0801615',10422,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (455812,'LV','Saulkrasti','Saulkrasti',57.2622,24.4147,'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` VALUES (455890,'LV','Saldus','Saldus',56.6636,22.4881,'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` VALUES (455898,'LV','Salaspils','Salaspils',56.8601,24.3654,'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` VALUES (455910,'LV','Salacgrīva','Salacgriva',57.7536,24.3581,'P','PPLA','LV.C1','LV.C1.0661415',3427,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (455915,'LV','Sala','Sala',56.5067,25.7642,'P','PPLA','LV.C2','LV.C2.0568786',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456008,'LV','Rūjiena','Rujiena',57.8975,25.3316,'P','PPLA','LV.B8','LV.B8.0961615',3638,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456015,'LV','Rugāji','Rugaji',57.0033,27.1337,'P','PPLA','LV.B7','LV.B7.0387574',0,'Europe/Riga',1,'2017-07-31 23:00:00','2017-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456050,'LV','Rucava','Rucava',56.1631,21.1616,'P','PPLA','LV.B6','LV.B6.0648584',547,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456089,'LV','Garkalne','Garkalne',57.0449,24.4195,'P','PPLA','LV.64','LV.64.0806000',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456090,'LV','Ropaži','Ropazi',56.9739,24.6336,'P','PPLA','LV.B5','LV.B5.0808400',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456107,'LV','Roja','Roja',57.5015,22.8088,'P','PPLA','LV.B4','LV.B4.0888301',1800,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456172,'LV','Riga','Riga',56.946,24.1059,'P','PPLC','LV.25','LV.25.0010000',742572,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456185,'LV','Riebiņi','Riebini',56.3428,26.7999,'P','PPLA','LV.B3','LV.B3.0766362',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456202,'LV','Rēzekne','Rezekne',56.5103,27.34,'P','PPLA','LV.23','LV.23.0210000',38340,'Europe/Riga',1,'2017-05-06 23:00:00','2017-05-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456272,'LV','Rauna','Rauna',57.3317,25.6095,'P','PPLA','LV.B1','LV.B1.0427776',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456341,'LV','Ragana','Ragana',57.1807,24.7073,'P','PPLA','LV.84','LV.84.0806968',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456503,'LV','Priekuļi','Priekuli',57.315,25.3615,'P','PPLA','LV.A9','LV.A9.0427372',2532,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456506,'LV','Priekule','Priekule',56.4468,21.5897,'P','PPLA','LV.A8','LV.A8.0641615',2550,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456530,'LV','Preiļi','Preili',56.2944,26.7246,'P','PPLA','LV.22','LV.22.0760201',8656,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456635,'LV','Pļaviņas','Plavinas',56.6178,25.7255,'P','PPLA','LV.A6','LV.A6.0321413',3848,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456685,'LV','Piņķi','Pinki',56.9419,23.9137,'P','PPLA','LV.45','LV.45.0804948',3033,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456698,'LV','Pilsrundāle','Pilsrundale',56.4167,24,'P','PPLA','LV.B9','LV.B9.0407776',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456827,'LV','Pāvilosta','Pavilosta',56.8879,21.1859,'P','PPLA','LV.A5','LV.A5.0641413',1171,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (456954,'LV','Ozolnieki','Ozolnieki',56.6864,23.7878,'P','PPLA','LV.A3','LV.A3.0546766',3400,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (457052,'LV','Olaine','Olaine',56.7853,23.9381,'P','PPLA','LV.A2','LV.A2.0801009',12584,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (457065,'LV','Ogre','Ogre',56.8162,24.614,'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` VALUES (457142,'LV','Nīca','Nica',56.346,21.064,'P','PPLA','LV.99','LV.99.0647978',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (457148,'LV','Nereta','Nereta',56.2028,25.3075,'P','PPLA','LV.98','LV.98.0327170',1282,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (457161,'LV','Naukšēni','Naukseni',57.8835,25.4561,'P','PPLA','LV.97','LV.97.0967372',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (457211,'LV','Mūrmuiža','Murmuiza',57.4731,25.4917,'P','PPLA','LV.50','LV.50.0964762',0,'Europe/Riga',1,'2017-12-05 23:00:00','2017-12-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (457408,'LV','Mērsrags','Mersrags',57.3354,23.1245,'P','PPLA','LV.F1','LV.F1.0887600',1860,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (457533,'LV','Mazsalaca','Mazsalaca',57.8633,25.0548,'P','PPLA','LV.96','LV.96.0961011',2412,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (457615,'LV','Matīši','Matisi',57.6989,25.1589,'P','PPLA','LV.52','LV.52.0967170',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (457676,'LV','Mālpils','Malpils',57.0111,24.9631,'P','PPLA','LV.94','LV.94.0807400',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (457714,'LV','Madona','Madona',56.8533,26.217,'P','PPLA','LV.20','LV.20.0700201',9280,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (457776,'LV','Ludza','Ludza',56.5396,27.7189,'P','PPLA','LV.19','LV.19.0680201',10514,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (457799,'LV','Lubāna','Lubana',56.9043,26.7161,'P','PPLA','LV.91','LV.91.0701413',1918,'Europe/Riga',1,'2017-07-31 23:00:00','2017-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (457822,'LV','Loja','Loja',57.1544,24.6444,'P','PPLA','LV.C6','LV.C6.0809200',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (457860,'LV','Līvāni','Livani',56.3543,26.1758,'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` VALUES (457890,'LV','Limbaži','Limbazi',57.5129,24.7194,'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` VALUES (457912,'LV','Līgatne','Ligatne',57.2343,25.0406,'P','PPLA','LV.88','LV.88.0421211',1433,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (457954,'LV','Liepāja','Liepaja',56.5271,21.0236,'P','PPLA','LV.16','LV.16.0170000',85132,'Europe/Riga',1,'2018-01-08 23:00:00','2018-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (457965,'LV','Lielvārde','Lielvarde',56.7207,24.8074,'P','PPLA','LV.87','LV.87.0741413',5114,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (458065,'LV','Lieģi','Liegi',56.5817,21.334,'P','PPLA','LV.61','LV.61.0640888',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (458460,'LV','Kuldīga','Kuldiga',56.974,21.9572,'P','PPLA','LV.15','LV.15.0620201',13289,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (458511,'LV','Krustpils','Krustpils',56.5107,25.8612,'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` VALUES (458623,'LV','Krāslava','Kraslava',55.8951,27.168,'P','PPLA','LV.14','LV.14.0600201',11088,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (458687,'LV','Koknese','Koknese',56.6516,25.4364,'P','PPLA','LV.82','LV.82.0326160',0,'Europe/Riga',1,'2017-11-06 23:00:00','2017-11-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (458695,'LV','Kocēni','Koceni',57.5206,25.3382,'P','PPLA','LV.81','LV.81.0960264',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (458880,'LV','Ķekava','Kekava',56.8266,24.23,'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` VALUES (458892,'LV','Ķegums','Kegums',56.7451,24.7244,'P','PPLA','LV.79','LV.79.0741009',2372,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (458972,'LV','Kārsava','Karsava',56.784,27.6883,'P','PPLA','LV.78','LV.78.0681009',2645,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (458995,'LV','Karosta','Karosta',56.5513,21.0129,'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` VALUES (459031,'LV','Kandava','Kandava',57.0409,22.7747,'P','PPLA','LV.77','LV.77.0901211',3592,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (459201,'LV','Jūrmala','Jurmala',56.968,23.7704,'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` VALUES (459279,'LV','Jelgava','Jelgava',56.65,23.7128,'P','PPLA','LV.11','LV.11.0090000',61791,'Europe/Riga',1,'2017-12-17 23:00:00','2017-12-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (459283,'LV','Jēkabpils','Jekabpils',56.499,25.8573,'P','PPLA','LV.10',NULL,27078,'Europe/Riga',1,'2015-10-24 23:00:00','2015-10-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (459357,'LV','Jaunpils','Jaunpils',56.7325,23.0136,'P','PPLA','LV.73','LV.73.0905756',1029,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (459359,'LV','Jaunpiebalga','Jaunpiebalga',57.1774,26.0284,'P','PPLA','LV.72','LV.72.0425756',0,'Europe/Riga',1,'2017-10-02 23:00:00','2017-10-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (459402,'LV','Jaunjelgava','Jaunjelgava',56.6132,25.0832,'P','PPLA','LV.71','LV.71.0321007',1938,'Europe/Riga',1,'2017-12-18 23:00:00','2017-12-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (459563,'LV','Inčukalns','Incukalns',57.0981,24.6864,'P','PPLA','LV.70','LV.70.0801864',2028,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (459586,'LV','Ilūkste','Ilukste',55.9775,26.2966,'P','PPLA','LV.69','LV.69.0440807',2898,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (459598,'LV','Ikšķile','Ikskile',56.8333,24.5,'P','PPLA','LV.68','LV.68.0740605',3368,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (459624,'LV','Iecava','Iecava',56.5986,24.2022,'P','PPLA','LV.67','LV.67.0406400',4000,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (459668,'LV','Gulbene','Gulbene',57.1777,26.7529,'P','PPLA','LV.09','LV.09.0500201',9355,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (459692,'LV','Grobiņa','Grobina',56.5352,21.1678,'P','PPLA','LV.65','LV.65.0641009',4203,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (459984,'LV','Cibla','Cibla',56.5498,27.8837,'P','PPLA','LV.56','LV.56.0684948',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (460001,'LV','Ērgļi','Ergli',56.8975,25.6367,'P','PPLA','LV.63','LV.63.0705554',2186,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (460187,'LV','Dundaga','Dundaga',57.505,22.3504,'P','PPLA','LV.60','LV.60.0885150',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (460285,'LV','Drabeši','Drabesi',57.2432,25.2775,'P','PPLA','LV.42','LV.42.0424746',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (460312,'LV','Dobele','Dobele',56.625,23.2786,'P','PPLA','LV.08','LV.08.0460201',11225,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (460413,'LV','Daugavpils','Daugavpils',55.8833,26.5333,'P','PPLA','LV.07',NULL,111564,'Europe/Riga',1,'2016-07-22 23:00:00','2016-07-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (460416,'LV','Daugavgrīva','Daugavgriva',57.0432,24.0361,'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` VALUES (460474,'LV','Dagda','Dagda',56.0951,27.5372,'P','PPLA','LV.57','LV.57.0601009',2740,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (460568,'LV','Cesvaine','Cesvaine',56.9675,26.3076,'P','PPLA','LV.55','LV.55.0700807',1811,'Europe/Riga',1,'2017-10-02 23:00:00','2017-10-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (460570,'LV','Cēsis','Cesis',57.3119,25.2746,'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` VALUES (460659,'LV','Carnikava','Carnikava',57.1293,24.2842,'P','PPLA','LV.53','LV.53.0805200',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (460786,'LV','Brocēni','Broceni',56.7,22.5333,'P','PPLA','LV.51','LV.51.0840625',3486,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (460885,'LV','Bolderaja','Bolderaja',57.0313,24.0557,'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` VALUES (461064,'LV','Berģi','Bergi',56.9864,24.2992,'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` VALUES (461114,'LV','Bauska','Bauska',56.4079,24.1944,'P','PPLA','LV.04','LV.04.0400201',10532,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (461163,'LV','Balvi','Balvi',57.1313,27.2658,'P','PPLA','LV.03','LV.03.0380201',8409,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (461180,'LV','Baltinava','Baltinava',56.9439,27.644,'P','PPLA','LV.47','LV.47.0384400',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (461224,'LV','Baldone','Baldone',56.7445,24.4008,'P','PPLA','LV.46','LV.46.0800605',2025,'Europe/Riga',1,'2017-12-05 23:00:00','2017-12-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (461336,'LV','Auce','Auce',56.4598,22.9017,'P','PPLA','LV.44','LV.44.0460805',3125,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (461442,'LV','Ape','Ape',57.5393,26.6929,'P','PPLA','LV.43','LV.43.0360805',1521,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (461528,'LV','Alūksne','Aluksne',57.4216,27.0466,'P','PPLA','LV.02','LV.02.0360201',2264,'Europe/Riga',1,'2017-01-03 23:00:00','2017-01-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (461534,'LV','Alsunga','Alsunga',56.9819,21.5594,'P','PPLA','LV.40','LV.40.0624200',940,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (461539,'LV','Aloja','Aloja',57.7672,24.8774,'P','PPLA','LV.39','LV.39.0661007',1509,'Europe/Riga',1,'2017-11-06 23:00:00','2017-11-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (461566,'LV','Aknīste','Akniste',56.1615,25.7478,'P','PPLA','LV.38','LV.38.0560805',1314,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (461602,'LV','Aizpute','Aizpute',56.7211,21.6016,'P','PPLA','LV.37','LV.37.0640605',5634,'Europe/Riga',1,'2018-01-08 23:00:00','2018-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (461615,'LV','Aizkraukle','Aizkraukle',56.6048,25.2553,'P','PPLA','LV.01','LV.01.0320201',8840,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (461631,'LV','Aglona','Aglona',56.1333,27.0167,'P','PPLA','LV.35','LV.35.0604342',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (461650,'LV','Ādaži','Adazi',57.0704,24.3371,'P','PPLA','LV.34','LV.34.0804400',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (864723,'LV','Mārupe','Marupe',56.9054,24.0511,'P','PPLA','LV.95','LV.95.0807600',0,'Europe/Riga',1,'2016-12-01 23:00:00','2016-12-01 23:00:00');


