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


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

INSERT INTO `<<prefix>>subadmin1` VALUES (1399,'IS.41','IS','Northwest','Northwest',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1400,'IS.40','IS','Northeast','Northeast',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1401,'IS.38','IS','East','East',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1402,'IS.42','IS','South','South',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1403,'IS.39','IS','Capital Region','Capital Region',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1404,'IS.43','IS','Southern Peninsula','Southern Peninsula',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1405,'IS.45','IS','West','West',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1406,'IS.44','IS','Westfjords','Westfjords',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (17042,'IS.38.7502','IS','IS.38','Vopnafjarðarhreppur','Vopnafjardarhreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17043,'IS.40.6611','IS','IS.40','Tjörneshreppur','Tjoerneshreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17044,'IS.40.6601','IS','IS.40','Svalbarðsstrandarhreppur','Svalbardsstrandarhreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17045,'IS.40.6706','IS','IS.40','Svalbarðshreppur','Svalbardshreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17046,'IS.40.6607','IS','IS.40','Skútustaðahreppur','Skutustadahreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17047,'IS.42.8509','IS','IS.42','Skaftárhreppur','Skaftarhreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17048,'IS.38.7000','IS','IS.38','Seyðisfjarðarkaupstaður','Seydisfjardarkaupstadur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17049,'IS.40.6602','IS','IS.40','Grýtubakkahreppur','Grytubakkahreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17050,'IS.38.7505','IS','IS.38','Fljótsdalshreppur','Fljotsdalshreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17051,'IS.40.6400','IS','IS.40','Dalvíkurbyggð','Dalvikurbyggd',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17052,'IS.38.7613','IS','IS.38','Breiðdalshreppur','Breiddalshreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17053,'IS.38.7509','IS','IS.38','Borgarfjarðarhreppur','Borgarfjardarhreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17054,'IS.40.6000','IS','IS.40','Akureyrarkaupstaður','Akureyrarkaupstadur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17055,'IS.41.5706','IS','IS.41','Akrahreppur','Akrahreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17056,'IS.41.5200','IS','IS.41','Sveitarfélagið Skagafjörður','Sveitarfelagid Skagafjoerdur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17057,'IS.40.6513','IS','IS.40','Eyjafjarðarsveit','Eyjafjardarsveit',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17058,'IS.40.6612','IS','IS.40','Þingeyjarsveit','THingeyjarsveit',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17059,'IS.38.7617','IS','IS.38','Djúpavogshreppur','Djupavogshreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17060,'IS.38.7300','IS','IS.38','Fjarðabyggð','Fjardabyggd',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17061,'IS.38.7708','IS','IS.38','Sveitarfélagið Hornafjörður','Sveitarfelagid Hornafjoerdur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17062,'IS.42.8508','IS','IS.42','Mýrdalshreppur','Myrdalshreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17063,'IS.42.8613','IS','IS.42','Rangárþing Eystra','Rangarthing Eystra',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17064,'IS.42.8614','IS','IS.42','Rangárþing Ytra','Rangarthing Ytra',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17065,'IS.42.8720','IS','IS.42','Skeiða- og Gnúpverjahreppur','Skeida- og Gnupverjahreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17066,'IS.42.8000','IS','IS.42','Vestmannaeyjabær','Vestmannaeyjabaer',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17067,'IS.44.4604','IS','IS.44','Tálknafjarðarhreppur','Talknafjardarhreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17068,'IS.44.4803','IS','IS.44','Súðavíkurhreppur','Sudavikurhreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17069,'IS.45.3506','IS','IS.45','Skorradalshreppur','Skorradalshreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17070,'IS.41.5611','IS','IS.41','Skagabyggð','Skagabyggd',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17071,'IS.39.1100','IS','IS.39','Seltjarnarneskaupstaður','Seltjarnarneskaupstadur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17072,'IS.39.0000','IS','IS.39','Reykjavíkurborg','Reykjavikurborg',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17073,'IS.44.4502','IS','IS.44','Reykhólahreppur','Reykholahreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17074,'IS.42.8717','IS','IS.42','Sveitarfélagið Ölfus','Sveitarfelagid OElfus',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17075,'IS.39.1604','IS','IS.39','Mosfellsbaer','Mosfellsbaer',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17076,'IS.39.1000','IS','IS.39','Kópavogsbær','Kopavogsbaer',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17077,'IS.39.1606','IS','IS.39','Kjósarhreppur','Kjosarhreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17078,'IS.44.4902','IS','IS.44','Kaldrananeshreppur','Kaldrananeshreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17079,'IS.44.4200','IS','IS.44','Ísafjarðarbær','Isafjardarbaer',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17080,'IS.42.8716','IS','IS.42','Hveragerðisbær','Hveragerdisbaer',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17081,'IS.42.8710','IS','IS.42','Hrunamannahreppur','Hrunamannahreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17082,'IS.45.3710','IS','IS.45','Helgafellssveit','Helgafellssveit',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17083,'IS.39.1400','IS','IS.39','Hafnarfjarðarkaupstaður','Hafnarfjardarkaupstadur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17084,'IS.39.1300','IS','IS.39','Garðabær','Gardabaer',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17085,'IS.45.3713','IS','IS.45','Eyja- og Miklaholtshreppur','Eyja- og Miklaholtshreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17086,'IS.45.3609','IS','IS.45','Borgarbyggð','Borgarbyggd',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17087,'IS.42.8610','IS','IS.42','Ásahreppur','Asahreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17088,'IS.44.4901','IS','IS.44','Árneshreppur','Arneshreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17089,'IS.45.3000','IS','IS.45','Akraneskaupstaður','Akraneskaupstadur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17090,'IS.41.5604','IS','IS.41','Blönduósbær','Bloenduosbaer',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17091,'IS.44.4100','IS','IS.44','Bolungarvíkurkaupstaður','Bolungarvikurkaupstadur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17092,'IS.45.3811','IS','IS.45','Dalabyggð','Dalabyggd',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17093,'IS.45.3709','IS','IS.45','Grundarfjarðarbær','Grundarfjardarbaer',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17094,'IS.45.3714','IS','IS.45','Snæfellsbær','Snaefellsbaer',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17095,'IS.41.5508','IS','IS.41','Húnaþing Vestra','Hunathing Vestra',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17096,'IS.43.2000','IS','IS.43','Reykjanesbær','Reykjanesbaer',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17097,'IS.43.2503','IS','IS.43','Sandgerðisbær','Sandgerdisbaer',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17098,'IS.43.2504','IS','IS.43','Sveitarfélagið Garður','Sveitarfelagid Gardur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17099,'IS.44.4607','IS','IS.44','Vesturbyggð','Vesturbyggd',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17100,'IS.42.8721','IS','IS.42','Bláskógabyggð','Blaskogabyggd',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17101,'IS.42.8719','IS','IS.42','Grímsnes- og Grafningshreppur','Grimsnes- og Grafningshreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17102,'IS.42.8200','IS','IS.42','Sveitarfélagið Árborg','Sveitarfelagid Arborg',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17103,'IS.40.6709','IS','IS.40','Langanesbyggð','Langanesbyggd',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17104,'IS.38.7620','IS','IS.38','Fljótsdalshérað','Fljotsdalsherad',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17105,'IS.40.6100','IS','IS.40','Norðurþing','Nordurthing',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17106,'IS.40.6515','IS','IS.40','Hörgársveit','Hoergarsveit',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17107,'IS.40.6250','IS','IS.40','Fjallabyggð','Fjallabyggd',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17108,'IS.41.5609','IS','IS.41','Sveitarfélagið Skagaströnd','Sveitarfelagid Skagastroend',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17109,'IS.44.4911','IS','IS.44','Strandabyggð','Strandabyggd',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17110,'IS.45.3511','IS','IS.45','Hvalfjarðarsveit','Hvalfjardarsveit',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17111,'IS.43.2506','IS','IS.43','Sveitarfélagið Vogar','Sveitarfelagid Vogar',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17112,'IS.43.2300','IS','IS.43','Grindavíkurbær','Grindavikurbaer',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17113,'IS.42.8722','IS','IS.42','Flóahreppur','Floahreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17114,'IS.41.5612','IS','IS.41','Húnavatnshreppur','Hunavatnshreppur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (17115,'IS.45.3711','IS','IS.45','Stykkishólmsbær','Stykkisholmsbaer',1);

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

INSERT INTO `<<prefix>>cities` VALUES (2627309,'IS','Sauðárkrókur','Saudarkrokur',65.7461,-19.6394,'P','PPLA','IS.41','IS.41.5200',2575,'Atlantic/Reykjavik',1,'2017-09-16 23:00:00','2017-09-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2632132,'IS','Egilsstaðir','Egilsstadir',65.2669,-14.3948,'P','PPLA','IS.38','IS.38.7620',2303,'Atlantic/Reykjavik',1,'2016-12-02 23:00:00','2016-12-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2633274,'IS','Akureyri','Akureyri',65.6835,-18.0878,'P','PPLA','IS.40','IS.40.6000',17693,'Atlantic/Reykjavik',1,'2016-12-02 23:00:00','2016-12-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3413604,'IS','Selfoss','Selfoss',63.9331,-20.9971,'P','PPLA','IS.42','IS.42.8200',6510,'Atlantic/Reykjavik',1,'2016-12-02 23:00:00','2016-12-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3413829,'IS','Reykjavík','Reykjavik',64.1355,-21.8954,'P','PPLC','IS.39','IS.39.0000',118918,'Atlantic/Reykjavik',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3415021,'IS','Mosfellsbær','Mosfellsbaer',64.1667,-21.7,'P','PPL','IS.39','IS.39.1604',8651,'Atlantic/Reykjavik',1,'2016-12-02 23:00:00','2016-12-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3415212,'IS','Kópavogur','Kopavogur',64.1123,-21.913,'P','PPL','IS.39','IS.39.1000',31719,'Atlantic/Reykjavik',1,'2017-09-25 23:00:00','2017-09-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3415496,'IS','Keflavík','Keflavik',64.0049,-22.5624,'P','PPLA','IS.43','IS.43.2000',0,'Atlantic/Reykjavik',1,'2016-12-02 23:00:00','2016-12-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3415667,'IS','Ísafjörður','Isafjoerdur',66.0748,-23.135,'P','PPLA','IS.44','IS.44.4200',2624,'Atlantic/Reykjavik',1,'2017-10-03 23:00:00','2017-10-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3416706,'IS','Hafnarfjörður','Hafnarfjoerdur',64.0671,-21.9377,'P','PPL','IS.39','IS.39.1400',26808,'Atlantic/Reykjavik',1,'2016-12-02 23:00:00','2016-12-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3417195,'IS','Garðabær','Gardabaer',64.0887,-21.923,'P','PPL','IS.39','IS.39.1300',11421,'Atlantic/Reykjavik',1,'2016-12-02 23:00:00','2016-12-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3418076,'IS','Borgarnes','Borgarnes',64.5383,-21.9206,'P','PPLA','IS.45','IS.45.3609',1759,'Atlantic/Reykjavik',1,'2016-12-02 23:00:00','2016-12-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3418653,'IS','Akranes','Akranes',64.3218,-22.0749,'P','PPL','IS.45','IS.45.3000',6612,'Atlantic/Reykjavik',1,'2016-12-02 23:00:00','2016-12-02 23:00:00');


