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


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

INSERT INTO `<<prefix>>subadmin1` VALUES (1280,'IE.C','IE','Connaught','Connaught',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1281,'IE.L','IE','Leinster','Leinster',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1282,'IE.M','IE','Munster','Munster',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1283,'IE.U','IE','Ulster','Ulster',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (15815,'IE.L.31','IE','IE.L','Wicklow','Wicklow',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15816,'IE.L.30','IE','IE.L','Loch Garman','Loch Garman',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15817,'IE.L.29','IE','IE.L','An Iarmhí','An Iarmhi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15818,'IE.M.26','IE','IE.M','County Tipperary','County Tipperary',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15819,'IE.C.25','IE','IE.C','Sligo','Sligo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15820,'IE.C.24','IE','IE.C','Roscommon','Roscommon',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15821,'IE.L.23','IE','IE.L','Uíbh Fhailí','Uibh Fhaili',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15822,'IE.U.22','IE','IE.U','County Monaghan','County Monaghan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15823,'IE.L.21','IE','IE.L','An Mhí','An Mhi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15824,'IE.C.20','IE','IE.C','Mayo County','Mayo County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15825,'IE.L.19','IE','IE.L','Lú','Lu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15826,'IE.L.18','IE','IE.L','An Longfort','An Longfort',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15827,'IE.C.14','IE','IE.C','County Leitrim','County Leitrim',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15828,'IE.L.15','IE','IE.L','Laois','Laois',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15829,'IE.L.13','IE','IE.L','Kilkenny','Kilkenny',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15830,'IE.L.12','IE','IE.L','Kildare','Kildare',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15831,'IE.M.11','IE','IE.M','Ciarraí','Ciarrai',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15832,'IE.C.10','IE','IE.C','County Galway','County Galway',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15833,'IE.U.06','IE','IE.U','County Donegal','County Donegal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15834,'IE.M.04','IE','IE.M','County Cork','County Cork',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15835,'IE.M.03','IE','IE.M','An Clár','An Clar',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15836,'IE.U.02','IE','IE.U','An Cabhán','An Cabhan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15837,'IE.L.01','IE','IE.L','County Carlow','County Carlow',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15838,'IE.L.35','IE','IE.L','Fingal County','Fingal County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15839,'IE.L.34','IE','IE.L','Dún Laoghaire-Rathdown','Dun Laoghaire-Rathdown',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15840,'IE.L.39','IE','IE.L','South Dublin','South Dublin',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15841,'IE.C.36','IE','IE.C','Galway City','Galway City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15842,'IE.L.33','IE','IE.L','Dublin City','Dublin City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15843,'IE.M.32','IE','IE.M','Cork City','Cork City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15844,'IE.M.42','IE','IE.M','Limerick City and County Council','Limerick City and County Council',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (15845,'IE.M.44','IE','IE.M','Waterford City and County Council','Waterford City and County Council',1);

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

INSERT INTO `<<prefix>>cities` VALUES (2654332,'IE','Buncrana','Buncrana',55.1333,-7.45,'P','PPL','IE.U','IE.U.06',5546,'Europe/Dublin',1,'2016-04-09 23:00:00','2016-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960869,'IE','Youghal','Youghal',51.95,-7.85056,'P','PPL','IE.M','IE.M.04',6868,'Europe/Dublin',1,'2014-05-30 23:00:00','2014-05-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960936,'IE','Wicklow','Wicklow',52.975,-6.04944,'P','PPLA2','IE.L','IE.L.31',14048,'Europe/Dublin',1,'2013-12-07 23:00:00','2013-12-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960964,'IE','Loch Garman','Loch Garman',52.3342,-6.4575,'P','PPLA2','IE.L','IE.L.30',19913,'Europe/Dublin',1,'2013-08-13 23:00:00','2013-08-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960970,'IE','Westport','Westport',53.8,-9.51667,'P','PPL','IE.C','IE.C.20',6200,'Europe/Dublin',1,'2012-02-27 23:00:00','2012-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960992,'IE','Waterford','Waterford',52.2583,-7.11194,'P','PPLA2','IE.M','IE.M.44',47904,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961086,'IE','Tullamore','Tullamore',53.2739,-7.48889,'P','PPLA2','IE.L','IE.L.23',11575,'Europe/Dublin',1,'2012-02-29 23:00:00','2012-02-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961099,'IE','Tuam','Tuam',53.5167,-8.85,'P','PPL','IE.C','IE.C.10',6130,'Europe/Dublin',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961120,'IE','Trá Mhór','Tra Mhor',52.1623,-7.15244,'P','PPL','IE.M','IE.M.44',9164,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961123,'IE','Tralee','Tralee',52.2704,-9.70264,'P','PPLA2','IE.M','IE.M.11',22941,'Europe/Dublin',1,'2014-12-17 23:00:00','2014-12-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961214,'IE','Thurles','Thurles',52.6819,-7.80222,'P','PPL','IE.M','IE.M.26',7588,'Europe/Dublin',1,'2012-02-27 23:00:00','2012-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961235,'IE','Terenure','Terenure',53.3097,-6.28528,'P','PPL','IE.L','IE.L.39',7674,'Europe/Dublin',1,'2013-12-10 23:00:00','2013-12-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961284,'IE','Tallaght','Tallaght',53.2859,-6.37344,'P','PPLA2','IE.L','IE.L.39',64282,'Europe/Dublin',1,'2016-09-30 23:00:00','2016-09-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961297,'IE','Swords','Swords',53.4597,-6.21806,'P','PPLA','IE.L','IE.L.35',36924,'Europe/Dublin',1,'2014-07-07 23:00:00','2014-07-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961423,'IE','Sligo','Sligo',54.2697,-8.46943,'P','PPLA2','IE.C','IE.C.25',20228,'Europe/Dublin',1,'2014-07-15 23:00:00','2014-07-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961461,'IE','Skerries','Skerries',53.5828,-6.10833,'P','PPL','IE.L','IE.L.35',9671,'Europe/Dublin',1,'2013-11-25 23:00:00','2013-11-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961523,'IE','Shankill','Shankill',53.2261,-6.12444,'P','PPL','IE.L','IE.L.34',10102,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961589,'IE','Sandymount','Sandymount',53.335,-6.21139,'P','PPL','IE.L','IE.L.33',8967,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961607,'IE','Sallins','Sallins',53.2489,-6.66611,'P','PPL','IE.L','IE.L.12',5283,'Europe/Dublin',1,'2013-11-25 23:00:00','2013-11-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961651,'IE','An Ros','An Ros',53.5242,-6.10497,'P','PPL','IE.L','IE.L.35',9231,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961730,'IE','Roscrea','Roscrea',52.9511,-7.80167,'P','PPL','IE.M','IE.M.26',5403,'Europe/Dublin',1,'2015-05-23 23:00:00','2015-05-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961732,'IE','Roscommon','Roscommon',53.6333,-8.18333,'P','PPLA2','IE.C','IE.C.24',5693,'Europe/Dublin',1,'2013-11-25 23:00:00','2013-11-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961816,'IE','Ringsend','Ringsend',53.3419,-6.22639,'P','PPLX','IE.L','IE.L.33',8202,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961872,'IE','Ratoath','Ratoath',53.5081,-6.4625,'P','PPL','IE.L','IE.L.21',9043,'Europe/Dublin',1,'2013-11-25 23:00:00','2013-11-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961896,'IE','Rathmines','Rathmines',53.3203,-6.26333,'P','PPLX','IE.L','IE.L.33',11044,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2961960,'IE','Raheny','Raheny',53.3868,-6.18067,'P','PPL','IE.L','IE.L.33',7197,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962019,'IE','Portmarnock','Portmarnock',53.4231,-6.1375,'P','PPL','IE.L','IE.L.35',9285,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962026,'IE','Portlaoise','Portlaoise',53.0344,-7.29979,'P','PPLA2','IE.L','IE.L.15',13622,'Europe/Dublin',1,'2011-05-24 23:00:00','2011-05-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962029,'IE','Portarlington','Portarlington',53.1622,-7.19111,'P','PPL','IE.L','IE.L.15',7788,'Europe/Dublin',1,'2013-11-25 23:00:00','2013-11-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962222,'IE','Newtown Trim','Newtown Trim',53.5561,-6.77,'P','PPLX','IE.L','IE.L.21',6781,'Europe/Dublin',1,'2014-12-02 23:00:00','2014-12-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962252,'IE','New Ross','New Ross',52.3967,-6.93667,'P','PPL','IE.L','IE.L.30',6695,'Europe/Dublin',1,'2012-02-27 23:00:00','2012-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962283,'IE','Newcastle West','Newcastle West',52.4492,-9.06111,'P','PPL','IE.M','IE.M.42',6327,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962290,'IE','Droichead Nua','Droichead Nua',53.1819,-6.79667,'P','PPL','IE.L','IE.L.12',18860,'Europe/Dublin',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962304,'IE','Nenagh','Nenagh',52.8619,-8.19667,'P','PPLA','IE.M','IE.M.26',5500,'Europe/Dublin',1,'2015-05-23 23:00:00','2015-05-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962308,'IE','Navan','Navan',53.6528,-6.68139,'P','PPLA2','IE.L','IE.L.21',24545,'Europe/Dublin',1,'2017-07-29 23:00:00','2017-07-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962334,'IE','Naas','Naas',53.2158,-6.66694,'P','PPLA2','IE.L','IE.L.12',20713,'Europe/Dublin',1,'2013-12-07 23:00:00','2013-12-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962361,'IE','An Muileann gCearr','An Muileann gCearr',53.5333,-7.35,'P','PPLA2','IE.L','IE.L.29',17262,'Europe/Dublin',1,'2010-09-04 23:00:00','2010-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962543,'IE','Monkstown','Monkstown',53.2931,-6.15312,'P','PPL','IE.L','IE.L.34',5555,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962568,'IE','Monaghan','Monaghan',54.25,-6.96667,'P','PPL','IE.U','IE.U.22',5937,'Europe/Dublin',1,'2012-02-27 23:00:00','2012-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962630,'IE','Midleton','Midleton',51.9153,-8.18052,'P','PPL','IE.M','IE.M.04',8891,'Europe/Dublin',1,'2011-05-28 23:00:00','2011-05-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962638,'IE','Mount Merrion','Mount Merrion',53.3001,-6.21504,'P','PPLX','IE.L','IE.L.34',7846,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962668,'IE','Maynooth','Maynooth',53.385,-6.59361,'P','PPL','IE.L','IE.L.12',12510,'Europe/Dublin',1,'2013-11-25 23:00:00','2013-11-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962696,'IE','Marino','Marino',53.3702,-6.23646,'P','PPLX','IE.L','IE.L.33',11023,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962714,'IE','Mallow','Mallow',52.1333,-8.63333,'P','PPL','IE.M','IE.M.04',9495,'Europe/Dublin',1,'2012-02-27 23:00:00','2012-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962725,'IE','Malahide','Malahide',53.4508,-6.15444,'P','PPL','IE.L','IE.L.35',15846,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962769,'IE','Lusk','Lusk',53.5274,-6.16423,'P','PPL','IE.L','IE.L.35',7022,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962785,'IE','Lucan','Lucan',53.3574,-6.44859,'P','PPL','IE.L','IE.L.39',15269,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962800,'IE','Loughrea','Loughrea',53.1969,-8.56694,'P','PPL','IE.C','IE.C.10',5062,'Europe/Dublin',1,'2013-12-07 23:00:00','2013-12-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962840,'IE','Longford','Longford',53.7254,-7.79823,'P','PPLA2','IE.L','IE.L.18',7787,'Europe/Dublin',1,'2012-02-29 23:00:00','2012-02-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962943,'IE','Luimneach','Luimneach',52.6647,-8.62306,'P','PPLA2','IE.M','IE.M.42',90054,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962961,'IE','Letterkenny','Letterkenny',54.95,-7.73333,'P','PPL','IE.U','IE.U.06',16901,'Europe/Dublin',1,'2012-02-27 23:00:00','2012-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2962974,'IE','Leixlip','Leixlip',53.3658,-6.49556,'P','PPL','IE.L','IE.L.12',15452,'Europe/Dublin',1,'2013-12-07 23:00:00','2013-12-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2963007,'IE','Laytown','Laytown',53.6819,-6.23917,'P','PPL','IE.L','IE.L.21',10889,'Europe/Dublin',1,'2013-12-07 23:00:00','2013-12-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2963370,'IE','Cill Airne','Cill Airne',52.05,-9.51667,'P','PPL','IE.M','IE.M.11',7300,'Europe/Dublin',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2963398,'IE','Kilkenny','Kilkenny',52.6542,-7.25222,'P','PPLA2','IE.L','IE.L.13',21589,'Europe/Dublin',1,'2014-05-08 23:00:00','2014-05-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2963436,'IE','Kildare','Kildare',53.1561,-6.91444,'P','PPL','IE.L','IE.L.12',8142,'Europe/Dublin',1,'2013-11-25 23:00:00','2013-11-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2963472,'IE','Kilcock','Kilcock',53.4022,-6.67083,'P','PPL','IE.L','IE.L.12',5533,'Europe/Dublin',1,'2013-11-25 23:00:00','2013-11-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2963848,'IE','Greystones','Greystones',53.1408,-6.06306,'P','PPL','IE.L','IE.L.31',13492,'Europe/Dublin',1,'2013-12-07 23:00:00','2013-12-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2963962,'IE','Gorey','Gorey',52.6747,-6.2925,'P','PPL','IE.L','IE.L.30',6040,'Europe/Dublin',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2964180,'IE','Gaillimh','Gaillimh',53.2719,-9.04889,'P','PPLA','IE.C','IE.C.10',70686,'Europe/Dublin',1,'2012-02-27 23:00:00','2012-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2964303,'IE','Finglas','Finglas',53.3892,-6.29694,'P','PPL','IE.L','IE.L.33',19768,'Europe/Dublin',1,'2013-12-07 23:00:00','2013-12-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2964403,'IE','Enniscorthy','Enniscorthy',52.5008,-6.55778,'P','PPL','IE.L','IE.L.30',9709,'Europe/Dublin',1,'2012-02-27 23:00:00','2012-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2964405,'IE','Ennis','Ennis',52.8436,-8.98639,'P','PPLA2','IE.M','IE.M.32',24427,'Europe/Dublin',1,'2016-05-09 23:00:00','2016-05-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2964506,'IE','Dún Laoghaire','Dun Laoghaire',53.2939,-6.13586,'P','PPL','IE.L','IE.L.34',185400,'Europe/Dublin',1,'2014-02-27 23:00:00','2014-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2964528,'IE','Dungarvan','Dungarvan',52.0881,-7.62528,'P','PPL','IE.M','IE.M.44',7551,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2964532,'IE','Dundrum','Dundrum',53.2907,-6.25714,'P','PPL','IE.L','IE.L.34',12152,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2964540,'IE','Dundalk','Dundalk',54,-6.41667,'P','PPLA2','IE.L','IE.L.19',33428,'Europe/Dublin',1,'2012-02-29 23:00:00','2012-02-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2964547,'IE','Dunboyne','Dunboyne',53.419,-6.47375,'P','PPL','IE.L','IE.L.21',6959,'Europe/Dublin',1,'2017-08-04 23:00:00','2017-08-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2964574,'IE','Dublin','Dublin',53.3331,-6.24889,'P','PPLC','IE.L','IE.L.33',1024027,'Europe/Dublin',1,'2013-05-29 23:00:00','2013-05-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2964661,'IE','Drogheda','Drogheda',53.7189,-6.34778,'P','PPL','IE.L','IE.L.19',33441,'Europe/Dublin',1,'2012-02-27 23:00:00','2012-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2964745,'IE','Donnybrook','Donnybrook',53.3138,-6.22274,'P','PPL','IE.L','IE.L.33',10645,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2964765,'IE','Donabate','Donabate',53.4872,-6.15194,'P','PPL','IE.L','IE.L.35',6778,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2964767,'IE','Dollymount','Dollymount',53.3649,-6.18032,'P','PPL','IE.L','IE.L.33',5070,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2964820,'IE','Derry','Derry',51.5867,-9.05026,'P','PPL','IE.M','IE.M.04',10000,'Europe/Dublin',1,'2010-08-29 23:00:00','2010-08-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2964892,'IE','Dalkey','Dalkey',53.2783,-6.10028,'P','PPL','IE.L','IE.L.34',6622,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2964963,'IE','Crumlin','Crumlin',53.3242,-6.32861,'P','PPL','IE.L','IE.L.33',11294,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2965140,'IE','Cork','Cork',51.898,-8.47061,'P','PPLA2','IE.M','IE.M.04',190384,'Europe/Dublin',1,'2011-11-02 23:00:00','2011-11-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2965260,'IE','Cobh','Cobh',51.8572,-8.29917,'P','PPL','IE.M','IE.M.04',10501,'Europe/Dublin',1,'2014-10-02 23:00:00','2014-10-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2965353,'IE','Cluain Meala','Cluain Meala',52.355,-7.70389,'P','PPLA2','IE.M','IE.M.26',17394,'Europe/Dublin',1,'2015-05-23 23:00:00','2015-05-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2965381,'IE','Clondalkin','Clondalkin',53.3244,-6.39722,'P','PPL','IE.L','IE.L.39',14508,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2965484,'IE','Clane','Clane',53.2914,-6.68917,'P','PPL','IE.L','IE.L.12',6702,'Europe/Dublin',1,'2013-11-25 23:00:00','2013-11-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2965509,'IE','Cherryville','Cherryville',53.1569,-6.96667,'P','PPL','IE.L','IE.L.12',6380,'Europe/Dublin',1,'2010-08-13 23:00:00','2010-08-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2965525,'IE','Chapelizod','Chapelizod',53.3489,-6.34667,'P','PPL','IE.L','IE.L.33',5296,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2965529,'IE','Celbridge','Celbridge',53.3386,-6.54361,'P','PPL','IE.L','IE.L.12',19537,'Europe/Dublin',1,'2013-11-25 23:00:00','2013-11-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2965535,'IE','Cavan','Cavan',53.9908,-7.36056,'P','PPLA2','IE.U','IE.U.02',6388,'Europe/Dublin',1,'2012-03-29 23:00:00','2012-03-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2965599,'IE','Castleknock','Castleknock',53.3748,-6.36336,'P','PPL','IE.L','IE.L.35',8301,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2965654,'IE','Castlebar','Castlebar',53.85,-9.3,'P','PPLA2','IE.C','IE.C.20',12874,'Europe/Dublin',1,'2012-02-29 23:00:00','2012-02-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2965715,'IE','Carrigaline','Carrigaline',51.8117,-8.39861,'P','PPL','IE.M','IE.M.04',14775,'Europe/Dublin',1,'2013-11-25 23:00:00','2013-11-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2965726,'IE','Carrick-on-Suir','Carrick-on-Suir',52.3492,-7.41306,'P','PPL','IE.M','IE.M.26',5710,'Europe/Dublin',1,'2012-02-27 23:00:00','2012-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2965768,'IE','Carlow','Carlow',52.8408,-6.92611,'P','PPLA2','IE.L','IE.L.01',20055,'Europe/Dublin',1,'2011-05-28 23:00:00','2011-05-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2965882,'IE','Cabinteely','Cabinteely',53.2697,-6.16058,'P','PPL','IE.L','IE.L.34',10038,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2966022,'IE','Bray','Bray',53.2028,-6.09833,'P','PPL','IE.L','IE.L.31',6477,'Europe/Dublin',1,'2013-12-07 23:00:00','2013-12-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2966101,'IE','Blessington','Blessington',53.17,-6.5325,'P','PPL','IE.L','IE.L.31',5010,'Europe/Dublin',1,'2013-11-25 23:00:00','2013-11-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2966110,'IE','Blanchardstown','Blanchardstown',53.3881,-6.37556,'P','PPL','IE.L','IE.L.35',16511,'Europe/Dublin',1,'2013-12-07 23:00:00','2013-12-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2966131,'IE','Blackrock','Blackrock',53.3015,-6.1778,'P','PPL','IE.L','IE.L.34',8821,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2966370,'IE','Bandon','Bandon',51.7469,-8.7425,'P','PPL','IE.M','IE.M.04',5492,'Europe/Dublin',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2966670,'IE','Ballyboden','Ballyboden',53.2806,-6.31639,'P','PPL','IE.L','IE.L.39',9611,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2966753,'IE','Ballinasloe','Ballinasloe',53.3275,-8.21944,'P','PPL','IE.C','IE.C.10',6388,'Europe/Dublin',1,'2012-02-27 23:00:00','2012-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2966778,'IE','Ballina','Ballina',54.1167,-9.16667,'P','PPL','IE.C','IE.C.20',10087,'Europe/Dublin',1,'2012-02-27 23:00:00','2012-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2966793,'IE','Baldoyle','Baldoyle',53.3997,-6.12583,'P','PPL','IE.L','IE.L.35',8043,'Europe/Dublin',1,'2013-12-07 23:00:00','2013-12-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2966794,'IE','Balbriggan','Balbriggan',53.6128,-6.18194,'P','PPL','IE.L','IE.L.35',23364,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2966837,'IE','Athy','Athy',52.9914,-6.98028,'P','PPL','IE.L','IE.L.12',12855,'Europe/Dublin',1,'2013-12-07 23:00:00','2013-12-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2966839,'IE','Athlone','Athlone',53.4333,-7.95,'P','PPL','IE.L','IE.L.29',15951,'Europe/Dublin',1,'2012-02-27 23:00:00','2012-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2966870,'IE','Ashbourne','Ashbourne',53.5116,-6.39821,'P','PPL','IE.L','IE.L.21',11355,'Europe/Dublin',1,'2013-12-09 23:00:00','2013-12-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2966883,'IE','Arklow','Arklow',52.7931,-6.14139,'P','PPL','IE.L','IE.L.31',11761,'Europe/Dublin',1,'2013-12-07 23:00:00','2013-12-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3306439,'IE','Nenagh Bridge','Nenagh Bridge',52.8817,-8.19583,'P','PPL','IE.M','IE.M.26',6672,'Europe/Dublin',1,'2010-08-13 23:00:00','2010-08-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3310247,'IE','Shannon','Shannon',52.7039,-8.86417,'P','PPL','IE.M','IE.M.03',9673,'Europe/Dublin',1,'2014-07-20 23:00:00','2014-07-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3315200,'IE','Eadestown','Eadestown',53.2028,-6.57806,'P','PPL','IE.L','IE.L.12',5346,'Europe/Dublin',1,'2013-12-07 23:00:00','2013-12-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3315204,'IE','Little Bray','Little Bray',53.2044,-6.12083,'P','PPL','IE.L','IE.L.31',8015,'Europe/Dublin',1,'2017-07-25 23:00:00','2017-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3315276,'IE','Firhouse','Firhouse',53.2817,-6.33917,'P','PPL','IE.L','IE.L.39',6859,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3315278,'IE','Sandyford','Sandyford',53.2747,-6.2253,'P','PPL','IE.L','IE.L.34',22288,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3315280,'IE','Foxrock','Foxrock',53.2667,-6.17417,'P','PPL','IE.L','IE.L.34',12870,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3315282,'IE','Sallynoggin','Sallynoggin',53.2792,-6.14058,'P','PPL','IE.L','IE.L.34',6916,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3315287,'IE','Rathgar','Rathgar',53.3146,-6.275,'P','PPL','IE.L','IE.L.33',8394,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3315304,'IE','Artane','Artane',53.3871,-6.2138,'P','PPL','IE.L','IE.L.33',5328,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3315311,'IE','Beaumont','Beaumont',53.3914,-6.24056,'P','PPL','IE.L','IE.L.33',8609,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3315315,'IE','Ballymun','Ballymun',53.3981,-6.26693,'P','PPL','IE.L','IE.L.33',6262,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3315332,'IE','Hartstown','Hartstown',53.3931,-6.42694,'P','PPL','IE.L','IE.L.35',5882,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3315378,'IE','Ballyfermot','Ballyfermot',53.3453,-6.35889,'P','PPL','IE.L','IE.L.33',8558,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3315404,'IE','Templeogue','Templeogue',53.2953,-6.30889,'P','PPLX','IE.L','IE.L.39',7023,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3315430,'IE','Oldbawn','Oldbawn',53.2756,-6.3675,'P','PPL','IE.L','IE.L.39',9784,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6619871,'IE','Cherry Orchard','Cherry Orchard',53.336,-6.37799,'P','PPLX','IE.L','IE.L.33',7924,'Europe/Dublin',1,'2015-11-24 23:00:00','2015-11-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6691006,'IE','Booterstown','Booterstown',53.3045,-6.19985,'P','PPLX','IE.L','IE.L.34',7142,'Europe/Dublin',1,'2017-07-19 23:00:00','2017-07-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6691010,'IE','Ballinteer','Ballinteer',53.2741,-6.25397,'P','PPLX','IE.L','IE.L.34',8547,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6691017,'IE','Greenhills','Greenhills',53.3347,-6.30302,'P','PPLX','IE.L','IE.L.39',6876,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6691033,'IE','Donaghmede','Donaghmede',53.3984,-6.16179,'P','PPLX','IE.L','IE.L.33',15299,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6691035,'IE','Darndale','Darndale',53.3995,-6.18886,'P','PPLX','IE.L','IE.L.33',5667,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6691048,'IE','Donnycarney','Donnycarney',53.3735,-6.20976,'P','PPLX','IE.L','IE.L.33',7660,'Europe/Dublin',1,'2017-07-19 23:00:00','2017-07-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7838921,'IE','Knocklyon','Knocklyon',53.2803,-6.3313,'P','PPL','IE.L','IE.L.39',14628,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7838923,'IE','Palmerstown','Palmerstown',53.3502,-6.37778,'P','PPL','IE.L','IE.L.39',7197,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7869995,'IE','Jobstown','Jobstown',53.2787,-6.40803,'P','PPL','IE.L','IE.L.39',10825,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7869996,'IE','Killester','Killester',53.3732,-6.20431,'P','PPL','IE.L','IE.L.33',5099,'Europe/Dublin',1,'2016-09-11 23:00:00','2016-09-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7870938,'IE','Confey','Confey',53.3792,-6.49052,'P','PPL','IE.L','IE.L.12',5389,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7870988,'IE','Kilquade','Kilquade',53.0974,-6.08411,'P','PPL','IE.L','IE.L.31',14886,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8642910,'IE','Balally','Balally',53.275,-6.23594,'P','PPL','IE.L','IE.L.34',9051,'Europe/Dublin',1,'2017-07-19 23:00:00','2017-07-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8658946,'IE','Kinsealy-Drinan','Kinsealy-Drinan',53.444,-6.20334,'P','PPL','IE.L','IE.L.35',5814,'Europe/Dublin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');


