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


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

INSERT INTO `<<prefix>>subadmin1` VALUES (535,'CH.ZH','CH','Zurich','Zurich',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (536,'CH.ZG','CH','Zug','Zug',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (537,'CH.VD','CH','Vaud','Vaud',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (538,'CH.VS','CH','Valais','Valais',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (539,'CH.UR','CH','Uri','Uri',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (540,'CH.TI','CH','Ticino','Ticino',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (541,'CH.TG','CH','Thurgau','Thurgau',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (542,'CH.SO','CH','Solothurn','Solothurn',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (543,'CH.SZ','CH','Schwyz','Schwyz',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (544,'CH.SH','CH','Schaffhausen','Schaffhausen',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (545,'CH.SG','CH','Saint Gallen','Saint Gallen',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (546,'CH.OW','CH','Obwalden','Obwalden',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (547,'CH.NW','CH','Nidwalden','Nidwalden',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (548,'CH.NE','CH','Neuchâtel','Neuchatel',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (549,'CH.LU','CH','Lucerne','Lucerne',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (550,'CH.JU','CH','Jura','Jura',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (551,'CH.GR','CH','Grisons','Grisons',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (552,'CH.GL','CH','Glarus','Glarus',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (553,'CH.GE','CH','Geneva','Geneva',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (554,'CH.FR','CH','Fribourg','Fribourg',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (555,'CH.BE','CH','Bern','Bern',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (556,'CH.BS','CH','Basel-City','Basel-City',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (557,'CH.BL','CH','Basel-Landschaft','Basel-Landschaft',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (558,'CH.AR','CH','Appenzell Ausserrhoden','Appenzell Ausserrhoden',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (559,'CH.AI','CH','Appenzell Innerrhoden','Appenzell Innerrhoden',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (560,'CH.AG','CH','Aargau','Aargau',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (9180,'CH.TI.2108','CH','CH.TI','Vallemaggia District','Vallemaggia District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9181,'CH.SO.1110','CH','CH.SO','Bezirk Thierstein','Bezirk Thierstein',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9182,'CH.SG.1725','CH','CH.SG','Wahlkreis Sarganserland','Wahlkreis Sarganserland',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9183,'CH.VS.2309','CH','CH.VS','Raron District','Raron District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9184,'CH.ZH.107','CH','CH.ZH','Bezirk Meilen','Bezirk Meilen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9185,'CH.VS.2307','CH','CH.VS','Martigny District','Martigny District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9186,'CH.FR.1002','CH','CH.FR','Glâne District','Glane District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9187,'CH.ZH.102','CH','CH.ZH','Bezirk Andelfingen','Bezirk Andelfingen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9188,'CH.SO.1101','CH','CH.SO','Bezirk Gäu','Bezirk Gaeu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9189,'CH.AI.1600','CH','CH.AI','Appenzell Inner Rhodes','Appenzell Inner Rhodes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9190,'CH.JU.2601','CH','CH.JU','Delémont District','Delemont District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9191,'CH.VS.2312','CH','CH.VS','Sion District','Sion District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9192,'CH.AG.1910','CH','CH.AG','Bezirk Zofingen','Bezirk Zofingen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9193,'CH.GL.800','CH','CH.GL','Glarus','Glarus',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9194,'CH.BL.1305','CH','CH.BL','Bezirk Waldenburg','Bezirk Waldenburg',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9195,'CH.TI.2104','CH','CH.TI','Locarno District','Locarno District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9196,'CH.ZH.109','CH','CH.ZH','Bezirk Uster','Bezirk Uster',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9197,'CH.VS.2306','CH','CH.VS','Leuk District','Leuk District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9198,'CH.FR.1001','CH','CH.FR','Broye District','Broye District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9199,'CH.TI.2107','CH','CH.TI','Riviera District','Riviera District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9200,'CH.ZH.111','CH','CH.ZH','Bezirk Dietikon','Bezirk Dietikon',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9201,'CH.NW.700','CH','CH.NW','Nidwalden','Nidwalden',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9202,'CH.BS.1200','CH','CH.BS','Basel-Stadt','Basel-Stadt',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9203,'CH.VS.2304','CH','CH.VS','Goms District','Goms District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9204,'CH.FR.1004','CH','CH.FR','Sarine District','Sarine District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9205,'CH.VS.2303','CH','CH.VS','Entremont District','Entremont District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9206,'CH.SH.1404','CH','CH.SH','Bezirk Schleitheim','Bezirk Schleitheim',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9207,'CH.SG.1721','CH','CH.SG','Wahlkreis St. Gallen','Wahlkreis St. Gallen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9208,'CH.TI.2105','CH','CH.TI','Lugano District','Lugano District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9209,'CH.AG.1905','CH','CH.AG','Bezirk Kulm','Bezirk Kulm',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9210,'CH.AG.1903','CH','CH.AG','Bezirk Bremgarten','Bezirk Bremgarten',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9211,'CH.SZ.506','CH','CH.SZ','Bezirk Schwyz','Bezirk Schwyz',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9212,'CH.JU.2603','CH','CH.JU','Porrentruy District','Porrentruy District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9213,'CH.SO.1109','CH','CH.SO','Bezirk Solothurn','Bezirk Solothurn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9214,'CH.SZ.505','CH','CH.SZ','Bezirk March','Bezirk March',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9215,'CH.GE.2500','CH','CH.GE','Geneva','Geneva',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9216,'CH.TI.2102','CH','CH.TI','Blenio District','Blenio District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9217,'CH.AG.1911','CH','CH.AG','Bezirk Zurzach','Bezirk Zurzach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9218,'CH.JU.2602','CH','CH.JU','Franches-Montagnes District','Franches-Montagnes District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9219,'CH.SH.1405','CH','CH.SH','Bezirk Stein','Bezirk Stein',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9220,'CH.VS.2311','CH','CH.VS','Sierre District','Sierre District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9221,'CH.FR.1003','CH','CH.FR','Gruyère District','Gruyere District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9222,'CH.ZH.105','CH','CH.ZH','Bezirk Hinwil','Bezirk Hinwil',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9223,'CH.ZH.112','CH','CH.ZH','Bezirk Zürich','Bezirk Zuerich',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9224,'CH.UR.400','CH','CH.UR','Uri','Uri',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9225,'CH.AG.1907','CH','CH.AG','Bezirk Lenzburg','Bezirk Lenzburg',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9226,'CH.ZG.900','CH','CH.ZG','Zug','Zug',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9227,'CH.ZH.110','CH','CH.ZH','Bezirk Winterthur','Bezirk Winterthur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9228,'CH.NE.2403','CH','CH.NE','Le Locle District','Le Locle District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9229,'CH.SZ.502','CH','CH.SZ','Bezirk Gersau','Bezirk Gersau',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9230,'CH.NE.2405','CH','CH.NE','Val-de-Ruz District','Val-de-Ruz District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9231,'CH.AG.1902','CH','CH.AG','Bezirk Baden','Bezirk Baden',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9232,'CH.SH.1401','CH','CH.SH','Bezirk Oberklettgau','Bezirk Oberklettgau',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9233,'CH.OW.600','CH','CH.OW','Obwalden','Obwalden',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9234,'CH.ZH.101','CH','CH.ZH','Bezirk Affoltern','Bezirk Affoltern',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9235,'CH.FR.1005','CH','CH.FR','Lake District','Lake District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9236,'CH.VS.2301','CH','CH.VS','Brig District','Brig District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9237,'CH.BL.1304','CH','CH.BL','Bezirk Sissach','Bezirk Sissach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9238,'CH.NE.2401','CH','CH.NE','Boudry District','Boudry District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9239,'CH.AG.1904','CH','CH.AG','Bezirk Brugg','Bezirk Brugg',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9240,'CH.SO.1107','CH','CH.SO','Bezirk Lebern','Bezirk Lebern',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9241,'CH.AR.1502','CH','CH.AR','Bezirk Mittelland','Bezirk Mittelland',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9242,'CH.NE.2402','CH','CH.NE','La Chaux-de-Fonds District','La Chaux-de-Fonds District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9243,'CH.VS.2310','CH','CH.VS','Saint-Maurice District','Saint-Maurice District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9244,'CH.BL.1302','CH','CH.BL','Bezirk Laufen','Bezirk Laufen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9245,'CH.NE.2406','CH','CH.NE','Val-de-Travers District','Val-de-Travers District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9246,'CH.SH.1406','CH','CH.SH','Bezirk Unterklettgau','Bezirk Unterklettgau',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9247,'CH.AR.1501','CH','CH.AR','Bezirk Hinterland','Bezirk Hinterland',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9248,'CH.SG.1722','CH','CH.SG','Wahlkreis Rorschach','Wahlkreis Rorschach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9249,'CH.SZ.504','CH','CH.SZ','Bezirk Küssnacht','Bezirk Kuessnacht',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9250,'CH.SG.1728','CH','CH.SG','Wahlkreis Wil','Wahlkreis Wil',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9251,'CH.SO.1103','CH','CH.SO','Bezirk Bucheggberg','Bezirk Bucheggberg',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9252,'CH.BL.1301','CH','CH.BL','Bezirk Arlesheim','Bezirk Arlesheim',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9253,'CH.VS.2313','CH','CH.VS','Visp District','Visp District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9254,'CH.VS.2308','CH','CH.VS','Monthey District','Monthey District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9255,'CH.AG.1901','CH','CH.AG','Bezirk Aarau','Bezirk Aarau',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9256,'CH.ZH.106','CH','CH.ZH','Bezirk Horgen','Bezirk Horgen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9257,'CH.SZ.503','CH','CH.SZ','Bezirk Höfe','Bezirk Hoefe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9258,'CH.VS.2302','CH','CH.VS','Conthey District','Conthey District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9259,'CH.ZH.108','CH','CH.ZH','Bezirk Pfäffikon','Bezirk Pfaeffikon',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9260,'CH.AG.1909','CH','CH.AG','Bezirk Rheinfelden','Bezirk Rheinfelden',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9261,'CH.BL.1303','CH','CH.BL','Bezirk Liestal','Bezirk Liestal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9262,'CH.VD.2227','CH','CH.VD','Morges District','Morges District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9263,'CH.AG.1906','CH','CH.AG','Bezirk Laufenburg','Bezirk Laufenburg',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9264,'CH.FR.1007','CH','CH.FR','Veveyse District','Veveyse District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9265,'CH.AR.1503','CH','CH.AR','Bezirk Vorderland','Bezirk Vorderland',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9266,'CH.ZH.104','CH','CH.ZH','Bezirk Dielsdorf','Bezirk Dielsdorf',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9267,'CH.VD.2225','CH','CH.VD','Lausanne District','Lausanne District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9268,'CH.ZH.103','CH','CH.ZH','Bezirk Bülach','Bezirk Buelach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9269,'CH.SO.1102','CH','CH.SO','Bezirk Thal','Bezirk Thal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9270,'CH.TI.2101','CH','CH.TI','Bellinzona District','Bellinzona District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9271,'CH.VS.2305','CH','CH.VS','Hérens District','Herens District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9272,'CH.SO.1105','CH','CH.SO','Bezirk Gösgen','Bezirk Goesgen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9273,'CH.SZ.501','CH','CH.SZ','Bezirk Einsiedeln','Bezirk Einsiedeln',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9274,'CH.SG.1724','CH','CH.SG','Wahlkreis Werdenberg','Wahlkreis Werdenberg',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9275,'CH.SH.1403','CH','CH.SH','Bezirk Schaffhausen','Bezirk Schaffhausen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9276,'CH.SH.1402','CH','CH.SH','Bezirk Reiat','Bezirk Reiat',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9277,'CH.SO.1106','CH','CH.SO','Bezirk Wasseramt','Bezirk Wasseramt',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9278,'CH.NE.2404','CH','CH.NE','Neuchâtel District','Neuchatel District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9279,'CH.SO.1108','CH','CH.SO','Bezirk Olten','Bezirk Olten',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9280,'CH.TI.2106','CH','CH.TI','Mendrisio District','Mendrisio District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9281,'CH.VD.2221','CH','CH.VD','Aigle District','Aigle District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9282,'CH.FR.1006','CH','CH.FR','Sense District','Sense District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9283,'CH.AG.1908','CH','CH.AG','Bezirk Muri','Bezirk Muri',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9284,'CH.TI.2103','CH','CH.TI','Leventina District','Leventina District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9285,'CH.SO.1104','CH','CH.SO','Bezirk Dorneck','Bezirk Dorneck',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9286,'CH.SG.1723','CH','CH.SG','Wahlkreis Rheintal','Wahlkreis Rheintal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9287,'CH.SG.1727','CH','CH.SG','Wahlkreis Toggenburg','Wahlkreis Toggenburg',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9288,'CH.VD.2222','CH','CH.VD','Broye-Vully District','Broye-Vully District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9289,'CH.VD.2223','CH','CH.VD','Gros-de-Vaud District','Gros-de-Vaud District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9290,'CH.VD.2224','CH','CH.VD','Jura-Nord vaudois District','Jura-Nord vaudois District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9291,'CH.VD.2226','CH','CH.VD','Lavaux-Oron District','Lavaux-Oron District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9292,'CH.VD.2228','CH','CH.VD','Nyon District','Nyon District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9293,'CH.VD.2229','CH','CH.VD','Ouest Lausannois District','Ouest Lausannois District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9294,'CH.VD.2230','CH','CH.VD','Riviera-Pays-d\'Enhaut District','Riviera-Pays-d\'Enhaut District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9295,'CH.SG.1726','CH','CH.SG','Wahlkreis See-Gaster','Wahlkreis See-Gaster',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9296,'CH.BE.245','CH','CH.BE','Emmental District','Emmental District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9297,'CH.BE.248','CH','CH.BE','Obersimmental-Saanen District','Obersimmental-Saanen District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9298,'CH.BE.249','CH','CH.BE','Frutigen-Niedersimmental District','Frutigen-Niedersimmental District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9299,'CH.BE.242','CH','CH.BE','Biel/Bienne District','Biel/Bienne District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9300,'CH.BE.243','CH','CH.BE','Seeland District','Seeland District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9301,'CH.BE.247','CH','CH.BE','Thun District','Thun District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9302,'CH.BE.250','CH','CH.BE','Interlaken-Oberhasli District','Interlaken-Oberhasli District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9303,'CH.BE.241','CH','CH.BE','Jura bernois','Jura bernois',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9304,'CH.BE.244','CH','CH.BE','Oberaargau','Oberaargau',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9305,'CH.BE.246','CH','CH.BE','Bern-Mittelland District','Bern-Mittelland District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9306,'CH.TG.2012','CH','CH.TG','Frauenfeld District','Frauenfeld District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9307,'CH.TG.2011','CH','CH.TG','Arbon District','Arbon District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9308,'CH.TG.2014','CH','CH.TG','Münchwilen District','Muenchwilen District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9309,'CH.TG.2013','CH','CH.TG','Kreuzlingen District','Kreuzlingen District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9310,'CH.TG.2015','CH','CH.TG','Weinfelden District','Weinfelden District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9311,'CH.LU.312','CH','CH.LU','Lucerne-Land District','Lucerne-Land District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9312,'CH.LU.311','CH','CH.LU','Lucerne-Stadt District','Lucerne-Stadt District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9313,'CH.LU.316','CH','CH.LU','Entlebuch District','Entlebuch District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9314,'CH.LU.313','CH','CH.LU','Hochdorf District','Hochdorf District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9315,'CH.LU.314','CH','CH.LU','Sursee District','Sursee District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9316,'CH.LU.315','CH','CH.LU','Willisau District','Willisau District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9317,'CH.GR.1850','CH','CH.GR','Region Surselva','Region Surselva',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9318,'CH.GR.1851','CH','CH.GR','Region Viamala','Region Viamala',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9319,'CH.GR.1843','CH','CH.GR','Region Engiadina Bassa / Val Müstair','Region Engiadina Bassa / Val Muestair',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9320,'CH.GR.1848','CH','CH.GR','Region Plessur','Region Plessur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9321,'CH.GR.1844','CH','CH.GR','Region Imboden','Region Imboden',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9322,'CH.GR.1841','CH','CH.GR','Region Albula','Region Albula',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9323,'CH.GR.1849','CH','CH.GR','Region Prättigau / Davos','Region Praettigau / Davos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9324,'CH.GR.1845','CH','CH.GR','Region Landquart','Region Landquart',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9325,'CH.GR.1842','CH','CH.GR','Region Bernina','Region Bernina',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9326,'CH.GR.1847','CH','CH.GR','Region Moesa','Region Moesa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9327,'CH.GR.1846','CH','CH.GR','Region Maloja','Region Maloja',1);

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

INSERT INTO `<<prefix>>cities` VALUES (2657896,'CH','Zürich','Zurich',47.3667,8.55,'P','PPLA','CH.ZH','CH.ZH.112',341730,'Europe/Zurich',1,'2015-07-28 23:00:00','2015-07-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2657908,'CH','Zug','Zug',47.1724,8.51745,'P','PPLA','CH.ZG','CH.ZG.900',23435,'Europe/Zurich',1,'2014-03-05 23:00:00','2014-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2657910,'CH','Zuchwil','Zuchwil',47.2017,7.56649,'P','PPL','CH.SO','CH.SO.1106',9268,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2657912,'CH','Zollikon','Zollikon',47.3402,8.57407,'P','PPL','CH.ZH','CH.ZH.107',5812,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2657913,'CH','Zollikofen','Zollikofen',46.9991,7.45809,'P','PPL','CH.BE','CH.BE.246',9121,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2657915,'CH','Zofingen','Zofingen',47.2878,7.94586,'P','PPLA2','CH.AG','CH.AG.1910',11451,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2657928,'CH','Zermatt','Zermatt',46.02,7.74863,'P','PPL','CH.VS','CH.VS.2313',6629,'Europe/Zurich',1,'2016-09-12 23:00:00','2016-09-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2657941,'CH','Yverdon-les-Bains','Yverdon-les-Bains',46.7785,6.64115,'P','PPLA2','CH.VD','CH.VD.2224',23702,'Europe/Zurich',1,'2017-09-12 23:00:00','2017-09-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2657947,'CH','Würenlos','Wurenlos',47.4421,8.36261,'P','PPL','CH.AG','CH.AG.1902',5497,'Europe/Zurich',1,'2017-11-06 23:00:00','2017-11-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2657954,'CH','Worb','Worb',46.9298,7.56306,'P','PPL','CH.BE','CH.BE.246',11053,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2657955,'CH','Wollerau','Wollerau',47.1948,8.71903,'P','PPL','CH.SZ','CH.SZ.503',6883,'Europe/Zurich',1,'2015-09-05 23:00:00','2015-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2657963,'CH','Wohlen','Wohlen',47.3507,8.27517,'P','PPL','CH.AG','CH.AG.1903',13875,'Europe/Zurich',1,'2017-11-06 23:00:00','2017-11-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2657964,'CH','Wohlen','Wohlen',46.9712,7.35685,'P','PPL','CH.BE','CH.BE.246',9159,'Europe/Zurich',1,'2015-06-07 23:00:00','2015-06-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2657968,'CH','Wittenbach','Wittenbach',47.4611,9.38601,'P','PPL','CH.SG','CH.SG.1721',8542,'Europe/Zurich',1,'2015-09-05 23:00:00','2015-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2657969,'CH','Zürich (Kreis 7) / Witikon','Zuerich (Kreis 7) / Witikon',47.3575,8.59105,'P','PPLX','CH.ZH','CH.ZH.112',9099,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2657970,'CH','Winterthur','Winterthur',47.5056,8.72413,'P','PPLA2','CH.ZH','CH.ZH.110',91908,'Europe/Zurich',1,'2015-09-05 23:00:00','2015-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2657976,'CH','Windisch','Windisch',47.479,8.21842,'P','PPL','CH.AG','CH.AG.1904',6689,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2657996,'CH','Wil','Wil',47.4615,9.04552,'P','PPL','CH.SG','CH.SG.1728',16808,'Europe/Zurich',1,'2014-04-03 23:00:00','2014-04-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658007,'CH','Zürich (Kreis 3) / Alt-Wiedikon','Zuerich (Kreis 3) / Alt-Wiedikon',47.362,8.51497,'P','PPLX','CH.ZH','CH.ZH.112',14931,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658010,'CH','Wetzikon','Wetzikon',47.3264,8.79779,'P','PPL','CH.ZH','CH.ZH.105',12969,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658011,'CH','Wettingen','Wettingen',47.4705,8.31636,'P','PPL','CH.AG','CH.AG.1902',18191,'Europe/Zurich',1,'2017-10-26 23:00:00','2017-10-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658036,'CH','Weinfelden','Weinfelden',47.5667,9.1,'P','PPLA2','CH.TG','CH.TG.2015',9414,'Europe/Zurich',1,'2013-03-27 23:00:00','2013-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658042,'CH','Wattwil','Wattwil',47.2995,9.08657,'P','PPL','CH.SG','CH.SG.1727',8089,'Europe/Zurich',1,'2015-09-05 23:00:00','2015-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658060,'CH','Wallisellen','Wallisellen',47.415,8.59672,'P','PPL','CH.ZH','CH.ZH.103',11705,'Europe/Zurich',1,'2013-03-27 23:00:00','2013-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658082,'CH','Wädenswil','Wadenswil',47.2268,8.6687,'P','PPL','CH.ZH','CH.ZH.106',13269,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658112,'CH','Visp','Visp',46.2937,7.88149,'P','PPLA2','CH.VS','CH.VS.2313',6576,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658119,'CH','Villmergen','Villmergen',47.3501,8.24762,'P','PPL','CH.AG','CH.AG.1903',5489,'Europe/Zurich',1,'2017-11-06 23:00:00','2017-11-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658128,'CH','Villars-sur-Glâne','Villars-sur-Glane',46.7905,7.11717,'P','PPL','CH.FR','CH.FR.1004',10021,'Europe/Zurich',1,'2013-02-25 23:00:00','2013-02-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658135,'CH','Viganello','Viganello',46.0134,8.96879,'P','PPL','CH.TI','CH.TI.2105',6375,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658143,'CH','Veyrier','Veyrier',46.167,6.18436,'P','PPL','CH.GE','CH.GE.2500',9800,'Europe/Zurich',1,'2013-02-25 23:00:00','2013-02-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658145,'CH','Vevey','Vevey',46.463,6.84345,'P','PPLA2','CH.VD','CH.VD.2230',15812,'Europe/Zurich',1,'2017-09-12 23:00:00','2017-09-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658151,'CH','Versoix','Versoix',46.2838,6.16214,'P','PPL','CH.GE','CH.GE.2500',11467,'Europe/Zurich',1,'2016-08-02 23:00:00','2016-08-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658154,'CH','Vernier','Vernier',46.217,6.08497,'P','PPL','CH.GE','CH.GE.2500',30086,'Europe/Zurich',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658172,'CH','Veltheim (Kreis 5)','Veltheim',47.5142,8.717,'P','PPLX','CH.ZH','CH.ZH.110',8901,'Europe/Zurich',1,'2010-04-04 23:00:00','2010-04-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658209,'CH','Uzwil','Uzwil',47.4365,9.13422,'P','PPL','CH.SG','CH.SG.1728',12111,'Europe/Zurich',1,'2015-09-05 23:00:00','2015-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658210,'CH','Uznach','Uznach',47.2242,8.98263,'P','PPL','CH.SG','CH.SG.1726',5561,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658216,'CH','Uster','Uster',47.3471,8.72091,'P','PPLA2','CH.ZH','CH.ZH.109',23279,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658217,'CH','Urtenen','Urtenen',47.0267,7.50081,'P','PPL','CH.BE','CH.BE.246',5258,'Europe/Zurich',1,'2015-07-02 23:00:00','2015-07-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658237,'CH','Untersiggenthal','Untersiggenthal',47.5021,8.25554,'P','PPL','CH.AG','CH.AG.1902',6344,'Europe/Zurich',1,'2015-06-23 23:00:00','2015-06-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658240,'CH','Unterseen','Unterseen',46.6853,7.84722,'P','PPL','CH.BE','CH.BE.250',5150,'Europe/Zurich',1,'2015-05-24 23:00:00','2015-05-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658264,'CH','Unterägeri','Unterageri',47.1365,8.5853,'P','PPL','CH.ZG','CH.ZG.900',7973,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658277,'CH','Uetendorf','Uetendorf',46.7739,7.57251,'P','PPL','CH.BE','CH.BE.247',5654,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658312,'CH','Trimbach','Trimbach',47.3656,7.8868,'P','PPL','CH.SO','CH.SO.1105',6220,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658344,'CH','Töss (Kreis 4)','Toss',47.4789,8.70215,'P','PPLX','CH.ZH','CH.ZH.110',8672,'Europe/Zurich',1,'2016-09-21 23:00:00','2016-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658377,'CH','Thun','Thun',46.7512,7.62166,'P','PPLA2','CH.BE','CH.BE.247',42136,'Europe/Zurich',1,'2014-03-05 23:00:00','2014-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658386,'CH','Therwil','Therwil',47.4994,7.55669,'P','PPL','CH.BL','CH.BL.1301',9595,'Europe/Zurich',1,'2017-10-03 23:00:00','2017-10-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658388,'CH','Thalwil','Thalwil',47.2918,8.56351,'P','PPL','CH.ZH','CH.ZH.106',13296,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658397,'CH','Teufen','Teufen',47.3908,9.38644,'P','PPL','CH.AR','CH.AR.1502',5683,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658440,'CH','Sursee','Sursee',47.1709,8.11113,'P','PPLA2','CH.LU','CH.LU.314',8014,'Europe/Zurich',1,'2014-03-28 23:00:00','2014-03-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658449,'CH','Sumiswald','Sumiswald',47.0275,7.74526,'P','PPL','CH.BE','CH.BE.245',5159,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658457,'CH','Suhr','Suhr',47.3717,8.07967,'P','PPLA3','CH.AG','CH.AG.1901',9374,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658483,'CH','Steinhausen','Steinhausen',47.1951,8.48581,'P','PPL','CH.ZG','CH.ZG.900',8509,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658494,'CH','Steffisburg','Steffisburg',46.7781,7.63249,'P','PPL','CH.BE','CH.BE.247',15191,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658504,'CH','Stans','Stans',46.958,8.36609,'P','PPLA','CH.NW','CH.NW.700',7475,'Europe/Zurich',1,'2015-04-07 23:00:00','2015-04-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658518,'CH','Stäfa','Stafa',47.2425,8.72342,'P','PPL','CH.ZH','CH.ZH.107',5737,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658524,'CH','Spreitenbach','Spreitenbach',47.4229,8.36792,'P','PPL','CH.AG','CH.AG.1902',10562,'Europe/Zurich',1,'2017-09-03 23:00:00','2017-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658536,'CH','Spiez','Spiez',46.6847,7.69111,'P','PPL','CH.BE','CH.BE.249',12594,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658564,'CH','Solothurn','Solothurn',47.2079,7.53714,'P','PPLA','CH.SO','CH.SO.1109',14853,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658572,'CH','Sissach','Sissach',47.4641,7.80888,'P','PPLA2','CH.BL','CH.BL.1304',5873,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658575,'CH','Sirnach','Sirnach',47.4622,8.99763,'P','PPL','CH.TG','CH.TG.2014',6463,'Europe/Zurich',1,'2013-03-27 23:00:00','2013-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658576,'CH','Sitten','Sitten',46.2274,7.35559,'P','PPLA','CH.VS','CH.VS.2312',28045,'Europe/Zurich',1,'2016-08-05 23:00:00','2016-08-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658606,'CH','Sierre','Sierre',46.2919,7.53559,'P','PPLA2','CH.VS','CH.VS.2311',15752,'Europe/Zurich',1,'2018-01-04 23:00:00','2018-01-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658608,'CH','Siebnen','Siebnen',47.1745,8.89781,'P','PPL','CH.SZ','CH.SZ.505',7104,'Europe/Zurich',1,'2016-09-25 23:00:00','2016-09-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658656,'CH','Zürich (Kreis 11) / Seebach','Zuerich (Kreis 11) / Seebach',47.4218,8.54779,'P','PPLX','CH.ZH','CH.ZH.112',17851,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658665,'CH','Schwyz','Schwyz',47.0208,8.65414,'P','PPLA','CH.SZ','CH.SZ.506',14177,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658696,'CH','Schübelbach','Schubelbach',47.1733,8.92811,'P','PPL','CH.SZ','CH.SZ.505',7745,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658724,'CH','Schlieren','Schlieren',47.3967,8.44763,'P','PPL','CH.ZH','CH.ZH.111',12695,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658761,'CH','Schaffhausen','Schaffhausen',47.6973,8.63493,'P','PPLA','CH.SH','CH.SH.1403',33863,'Europe/Zurich',1,'2014-03-05 23:00:00','2014-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658775,'CH','Savièse','Saviese',46.2511,7.34558,'P','PPL','CH.VS','CH.VS.2312',5575,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658786,'CH','Sarnen','Sarnen',46.8961,8.24531,'P','PPLA','CH.OW','CH.OW.600',9410,'Europe/Zurich',1,'2015-07-02 23:00:00','2015-07-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658793,'CH','Sargans','Sargans',47.049,9.44103,'P','PPLA2','CH.SG','CH.SG.1725',5045,'Europe/Zurich',1,'2017-09-12 23:00:00','2017-09-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658816,'CH','Sankt Margrethen','Sankt Margrethen',47.4525,9.63741,'P','PPL','CH.SG','CH.SG.1723',5395,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658822,'CH','Sankt Gallen','Sankt Gallen',47.4239,9.37477,'P','PPLA','CH.SG','CH.SG.1721',70572,'Europe/Zurich',1,'2015-07-28 23:00:00','2015-07-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658871,'CH','Saint-Imier','Saint-Imier',47.1528,6.99692,'P','PPL','CH.BE','CH.BE.241',5220,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658904,'CH','Saanen','Saanen',46.4894,7.26003,'P','PPL','CH.BE','CH.BE.248',6621,'Europe/Zurich',1,'2017-02-02 23:00:00','2017-02-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658909,'CH','Rüti','Rueti',47.256,8.85552,'P','PPL','CH.ZH','CH.ZH.105',9576,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658914,'CH','Ruswil','Ruswil',47.0843,8.12645,'P','PPL','CH.LU','CH.LU.314',6432,'Europe/Zurich',1,'2014-03-28 23:00:00','2014-03-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658927,'CH','Rümlang','Rumlang',47.4504,8.52993,'P','PPL','CH.ZH','CH.ZH.104',5144,'Europe/Zurich',1,'2013-03-27 23:00:00','2013-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658950,'CH','Rotkreuz','Rotkreuz',47.1428,8.4314,'P','PPL','CH.ZG','CH.ZG.900',10439,'Europe/Zurich',1,'2017-09-03 23:00:00','2017-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658952,'CH','Rothrist','Rothrist',47.3051,7.89196,'P','PPL','CH.AG','CH.AG.1910',7423,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658969,'CH','Rorschach','Rorschach',47.478,9.4903,'P','PPL','CH.SG','CH.SG.1722',9000,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2658985,'CH','Romanshorn','Romanshorn',47.5659,9.37869,'P','PPLA3','CH.TG','CH.TG.2011',8956,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659050,'CH','Richterswil','Richterswil',47.2062,8.69686,'P','PPL','CH.ZH','CH.ZH.106',7103,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659060,'CH','Rheinfelden','Rheinfelden',47.5544,7.79403,'P','PPLA2','CH.AG','CH.AG.1909',10733,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659070,'CH','Renens','Renens',46.5399,6.5881,'P','PPLA2','CH.VD','CH.VD.2229',17811,'Europe/Zurich',1,'2014-03-05 23:00:00','2014-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659076,'CH','Reinach','Reinach',47.2573,8.18091,'P','PPL','CH.AG','CH.AG.1905',7845,'Europe/Zurich',1,'2017-06-05 23:00:00','2017-06-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659083,'CH','Regensdorf','Regensdorf',47.4341,8.46874,'P','PPL','CH.ZH','CH.ZH.104',7531,'Europe/Zurich',1,'2013-03-27 23:00:00','2013-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659099,'CH','Rapperswil','Rapperswil',47.2256,8.82228,'P','PPL','CH.SG','CH.SG.1726',34776,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659127,'CH','Pully','Pully',46.5103,6.66183,'P','PPL','CH.VD','CH.VD.2226',16263,'Europe/Zurich',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659136,'CH','Prilly','Prilly',46.537,6.60456,'P','PPL','CH.VD','CH.VD.2229',10524,'Europe/Zurich',1,'2017-09-19 23:00:00','2017-09-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659142,'CH','Pregassona','Pregassona',46.0202,8.97429,'P','PPL','CH.TI','CH.TI.2105',7548,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659147,'CH','Pratteln','Pratteln',47.5207,7.69356,'P','PPL','CH.BL','CH.BL.1303',14877,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659171,'CH','Porrentruy','Porrentruy',47.4173,7.07573,'P','PPLA2','CH.JU','CH.JU.2603',6521,'Europe/Zurich',1,'2017-09-12 23:00:00','2017-09-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659190,'CH','Plan-les-Ouates','Plan-les-Ouates',46.1679,6.11664,'P','PPL','CH.GE','CH.GE.2500',10540,'Europe/Zurich',1,'2016-08-02 23:00:00','2016-08-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659219,'CH','Pfäffikon','Pfaffikon',47.3645,8.79202,'P','PPLA2','CH.ZH','CH.ZH.108',7994,'Europe/Zurich',1,'2013-03-27 23:00:00','2013-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659220,'CH','Pfäffikon','Pfaeffikon',47.2011,8.77816,'P','PPL','CH.SZ','CH.SZ.503',7310,'Europe/Zurich',1,'2016-09-19 23:00:00','2016-09-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659227,'CH','Peseux','Peseux',46.987,6.88903,'P','PPL','CH.NE','CH.NE.2401',5716,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659243,'CH','Payerne','Payerne',46.8219,6.93817,'P','PPLA2','CH.VD','CH.VD.2222',7655,'Europe/Zurich',1,'2017-09-12 23:00:00','2017-09-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659289,'CH','Orbe','Orbe',46.725,6.53069,'P','PPL','CH.VD','CH.VD.2224',5132,'Europe/Zurich',1,'2013-02-25 23:00:00','2013-02-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659296,'CH','Onex','Onex',46.184,6.10237,'P','PPL','CH.GE','CH.GE.2500',17302,'Europe/Zurich',1,'2016-08-02 23:00:00','2016-08-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659297,'CH','Olten','Olten',47.35,7.90329,'P','PPLA2','CH.SO','CH.SO.1108',16411,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659298,'CH','Ollon','Ollon',46.2952,6.99314,'P','PPL','CH.VD','CH.VD.2221',6665,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659303,'CH','Oftringen','Oftringen',47.3138,7.92533,'P','PPL','CH.AG','CH.AG.1910',10390,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659310,'CH','Zürich (Kreis 11) / Oerlikon','Zuerich (Kreis 11) / Oerlikon',47.4082,8.54258,'P','PPLX','CH.ZH','CH.ZH.112',17922,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659321,'CH','Oberwil','Oberwil',47.5141,7.55786,'P','PPL','CH.BL','CH.BL.1301',10187,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659331,'CH','Oberuzwil','Oberuzwil',47.4308,9.12724,'P','PPL','CH.SG','CH.SG.1728',5616,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659332,'CH','Urdorf','Ober Urdorf',47.3851,8.42581,'P','PPL','CH.ZH','CH.ZH.111',9205,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659344,'CH','Obersiggenthal','Obersiggenthal',47.4875,8.29652,'P','PPL','CH.AG','CH.AG.1902',7990,'Europe/Zurich',1,'2013-03-03 23:00:00','2013-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659357,'CH','Oberriet','Oberriet',47.3209,9.56808,'P','PPL','CH.SG','CH.SG.1723',7675,'Europe/Zurich',1,'2015-09-05 23:00:00','2015-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659391,'CH','Oberentfelden','Oberentfelden',47.3564,8.04594,'P','PPL','CH.AG','CH.AG.1901',7553,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659392,'CH','Oberengstringen','Oberengstringen',47.4084,8.46515,'P','PPL','CH.ZH','CH.ZH.111',5805,'Europe/Zurich',1,'2013-03-27 23:00:00','2013-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659422,'CH','Nyon','Nyon',46.3832,6.23955,'P','PPLA2','CH.VD','CH.VD.2228',16797,'Europe/Zurich',1,'2017-09-12 23:00:00','2017-09-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659474,'CH','Nidau','Nidau',47.1255,7.24033,'P','PPL','CH.BE','CH.BE.242',6696,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659485,'CH','Neuhausen','Neuhausen',47.6858,8.61474,'P','PPL','CH.SH','CH.SH.1403',10019,'Europe/Zurich',1,'2014-05-27 23:00:00','2014-05-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659489,'CH','Neuenkirch','Neuenkirch',47.0999,8.20416,'P','PPL','CH.LU','CH.LU.314',5963,'Europe/Zurich',1,'2014-03-28 23:00:00','2014-03-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659490,'CH','Neuenhof','Neuenhof',47.4498,8.32682,'P','PPL','CH.AG','CH.AG.1902',7957,'Europe/Zurich',1,'2017-11-06 23:00:00','2017-11-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659496,'CH','Neuchâtel','Neuchatel',46.9918,6.931,'P','PPLA','CH.NE','CH.NE.2404',31270,'Europe/Zurich',1,'2015-03-15 23:00:00','2015-03-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659510,'CH','Naters','Naters',46.3254,7.98912,'P','PPL','CH.VS','CH.VS.2301',7552,'Europe/Zurich',1,'2017-06-21 23:00:00','2017-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659522,'CH','Muttenz','Muttenz',47.5227,7.64511,'P','PPL','CH.BL','CH.BL.1301',16927,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659529,'CH','Murten/Morat','Murten/Morat',46.9283,7.11715,'P','PPL','CH.FR','CH.FR.1005',5800,'Europe/Zurich',1,'2017-12-04 23:00:00','2017-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659531,'CH','Muri','Muri',47.2743,8.33854,'P','PPLA2','CH.AG','CH.AG.1908',6463,'Europe/Zurich',1,'2013-03-03 23:00:00','2013-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659532,'CH','Muri','Muri',46.9312,7.48658,'P','PPL','CH.BE','CH.BE.246',12374,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659546,'CH','Münsingen','Munsingen',46.873,7.561,'P','PPL','CH.BE','CH.BE.246',10928,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659551,'CH','Münchenstein','Munchenstein',47.5185,7.60966,'P','PPL','CH.BL','CH.BL.1301',11644,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659552,'CH','Münchenbuchsee','Munchenbuchsee',47.0218,7.45036,'P','PPL','CH.BE','CH.BE.246',9801,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659568,'CH','Moutier','Moutier',47.2782,7.36951,'P','PPL','CH.BE','CH.BE.241',7721,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659587,'CH','Morges','Morges',46.5113,6.49854,'P','PPLA2','CH.VD','CH.VD.2227',14117,'Europe/Zurich',1,'2017-09-12 23:00:00','2017-09-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659601,'CH','Montreux','Montreux',46.433,6.91143,'P','PPL','CH.VD','CH.VD.2230',22897,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659613,'CH','Monthey','Monthey',46.2545,6.95406,'P','PPLA2','CH.VS','CH.VS.2308',15106,'Europe/Zurich',1,'2017-09-12 23:00:00','2017-09-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659645,'CH','Möhlin','Mohlin',47.5592,7.84329,'P','PPL','CH.AG','CH.AG.1909',9382,'Europe/Zurich',1,'2017-12-19 23:00:00','2017-12-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659658,'CH','Minusio','Minusio',46.1777,8.81473,'P','PPL','CH.TI','CH.TI.2104',6653,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659667,'CH','Meyrin','Meyrin',46.2342,6.08025,'P','PPL','CH.GE','CH.GE.2500',19772,'Europe/Zurich',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659687,'CH','Menziken','Menziken',47.2397,8.18996,'P','PPL','CH.AG','CH.AG.1905',5415,'Europe/Zurich',1,'2018-01-08 23:00:00','2018-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659689,'CH','Mendrisio','Mendrisio',45.8702,8.9816,'P','PPLA2','CH.TI','CH.TI.2106',7310,'Europe/Zurich',1,'2017-09-12 23:00:00','2017-09-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659708,'CH','Meggen','Meggen',47.0469,8.37467,'P','PPL','CH.LU','CH.LU.312',6533,'Europe/Zurich',1,'2014-04-03 23:00:00','2014-04-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659739,'CH','Massagno','Massagno',46.0126,8.94354,'P','PPL','CH.TI','CH.TI.2105',5774,'Europe/Zurich',1,'2017-10-26 23:00:00','2017-10-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659748,'CH','Martigny-Ville','Martigny-Ville',46.1028,7.07245,'P','PPLA2','CH.VS','CH.VS.2307',14768,'Europe/Zurich',1,'2017-09-12 23:00:00','2017-09-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659758,'CH','Marly','Marly',46.7761,7.16459,'P','PPLA3','CH.FR','CH.FR.1004',7653,'Europe/Zurich',1,'2013-02-25 23:00:00','2013-02-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659772,'CH','Männedorf','Mannedorf',47.2569,8.69893,'P','PPL','CH.ZH','CH.ZH.107',7951,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659776,'CH','Malters','Malters',47.0363,8.18193,'P','PPL','CH.LU','CH.LU.312',6181,'Europe/Zurich',1,'2014-04-03 23:00:00','2014-04-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659808,'CH','Lyss','Lyss',47.0741,7.30655,'P','PPL','CH.BE','CH.BE.243',10937,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659811,'CH','Luzern','Luzern',47.0505,8.30635,'P','PPLA','CH.LU','CH.LU.311',57066,'Europe/Zurich',1,'2014-04-03 23:00:00','2014-04-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659819,'CH','Lutry','Lutry',46.5024,6.68647,'P','PPL','CH.VD','CH.VD.2226',8774,'Europe/Zurich',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659836,'CH','Lugano','Lugano',46.0101,8.96004,'P','PPLA2','CH.TI','CH.TI.2105',63000,'Europe/Zurich',1,'2017-12-18 23:00:00','2017-12-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659853,'CH','Losone','Losone',46.1687,8.75928,'P','PPL','CH.TI','CH.TI.2104',6070,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659869,'CH','Locarno','Locarno',46.1709,8.79953,'P','PPLA2','CH.TI','CH.TI.2104',14509,'Europe/Zurich',1,'2017-09-12 23:00:00','2017-09-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659873,'CH','Littau','Littau',47.05,8.26274,'P','PPL','CH.LU','CH.LU.311',16121,'Europe/Zurich',1,'2015-06-07 23:00:00','2015-06-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659891,'CH','Liestal','Liestal',47.4846,7.73446,'P','PPLA','CH.BL','CH.BL.1303',12832,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659952,'CH','Lenzburg','Lenzburg',47.3885,8.17503,'P','PPLA2','CH.AG','CH.AG.1907',7392,'Europe/Zurich',1,'2013-03-03 23:00:00','2013-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659957,'CH','Lengnau','Lengnau',47.1815,7.36814,'P','PPL','CH.BE','CH.BE.242',7336,'Europe/Zurich',1,'2016-01-01 23:00:00','2016-01-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659959,'CH','Le Mont-sur-Lausanne','Le Mont-sur-Lausanne',46.5582,6.63145,'P','PPL','CH.VD','CH.VD.2225',5270,'Europe/Zurich',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659960,'CH','Le Locle','Le Locle',47.0562,6.74913,'P','PPLA2','CH.NE','CH.NE.2403',10279,'Europe/Zurich',1,'2017-09-12 23:00:00','2017-09-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2659994,'CH','Lausanne','Lausanne',46.516,6.63282,'P','PPLA','CH.VD','CH.VD.2225',116751,'Europe/Zurich',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660001,'CH','Laufen','Laufen',47.4219,7.49946,'P','PPLA2','CH.BL','CH.BL.1302',5210,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660008,'CH','La Tour-de-Peilz','La Tour-de-Peilz',46.4531,6.85856,'P','PPL','CH.VD','CH.VD.2230',10522,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660032,'CH','Langnau','Langnau',46.9394,7.78738,'P','PPLA2','CH.BE','CH.BE.245',8784,'Europe/Zurich',1,'2014-03-05 23:00:00','2014-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660034,'CH','Langenthal','Langenthal',47.2153,7.79607,'P','PPL','CH.BE','CH.BE.244',14184,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660075,'CH','Lachen','Lachen',47.1993,8.85432,'P','PPLA2','CH.SZ','CH.SZ.505',6685,'Europe/Zurich',1,'2015-09-05 23:00:00','2015-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660076,'CH','La Chaux-de-Fonds','La Chaux-de-Fonds',47.0999,6.82586,'P','PPLA2','CH.NE','CH.NE.2402',36825,'Europe/Zurich',1,'2017-09-12 23:00:00','2017-09-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660086,'CH','Küttigen','Kuttigen',47.4148,8.04979,'P','PPL','CH.AG','CH.AG.1901',5234,'Europe/Zurich',1,'2017-11-06 23:00:00','2017-11-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660088,'CH','Küssnacht','Kussnacht',47.0856,8.44206,'P','PPLA2','CH.SZ','CH.SZ.504',11777,'Europe/Zurich',1,'2014-05-31 23:00:00','2014-05-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660089,'CH','Küsnacht','Kuesnacht',47.3181,8.58401,'P','PPL','CH.ZH','CH.ZH.107',11525,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660104,'CH','Kriens','Kriens',47.0311,8.28547,'P','PPL','CH.LU','CH.LU.312',25010,'Europe/Zurich',1,'2017-06-05 23:00:00','2017-06-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660108,'CH','Kreuzlingen','Kreuzlingen',47.6505,9.17504,'P','PPLA2','CH.TG','CH.TG.2013',17655,'Europe/Zurich',1,'2015-09-05 23:00:00','2015-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660119,'CH','Köniz','Koniz',46.9244,7.41457,'P','PPL','CH.BE','CH.BE.246',37196,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660127,'CH','Kloten','Kloten',47.4515,8.58491,'P','PPL','CH.ZH','CH.ZH.103',16289,'Europe/Zurich',1,'2013-03-27 23:00:00','2013-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660155,'CH','Kirchberg','Kirchberg',47.4116,9.0402,'P','PPL','CH.SG','CH.SG.1727',8127,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660156,'CH','Kirchberg','Kirchberg',47.0854,7.58288,'P','PPL','CH.BE','CH.BE.245',5335,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660161,'CH','Kilchberg','Kilchberg',47.3244,8.54548,'P','PPL','CH.ZH','CH.ZH.106',6511,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660171,'CH','Kerns','Kerns',46.9012,8.27514,'P','PPL','CH.OW','CH.OW.600',5217,'Europe/Zurich',1,'2017-06-05 23:00:00','2017-06-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660221,'CH','Jona','Jona',47.2298,8.83884,'P','PPL','CH.SG','CH.SG.1726',17655,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660253,'CH','Interlaken','Interlaken',46.6839,7.86638,'P','PPLA2','CH.BE','CH.BE.250',5067,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660261,'CH','Ingenbohl','Ingenbohl',46.9988,8.61529,'P','PPL','CH.SZ','CH.SZ.506',7967,'Europe/Zurich',1,'2015-08-07 23:00:00','2015-08-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660277,'CH','Igis','Igis',46.9453,9.57218,'P','PPL','CH.GR','CH.GR.1845',6828,'Europe/Zurich',1,'2017-07-26 23:00:00','2017-07-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660292,'CH','Hünenberg','Hunenberg',47.1754,8.42497,'P','PPL','CH.ZG','CH.ZG.900',9032,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660298,'CH','Horw','Horw',47.0169,8.30956,'P','PPL','CH.LU','CH.LU.312',12348,'Europe/Zurich',1,'2014-04-03 23:00:00','2014-04-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660305,'CH','Horgen','Horgen',47.2598,8.59778,'P','PPLA2','CH.ZH','CH.ZH.106',15973,'Europe/Zurich',1,'2015-07-02 23:00:00','2015-07-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660306,'CH','Zürich (Kreis 10) / Höngg','Zuerich (Kreis 10) / Hoengg',47.4031,8.4971,'P','PPLX','CH.ZH','CH.ZH.112',17117,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660332,'CH','Hochdorf','Hochdorf',47.1684,8.29179,'P','PPLA2','CH.LU','CH.LU.313',8192,'Europe/Zurich',1,'2014-03-28 23:00:00','2014-03-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660338,'CH','Hinwil','Hinwil',47.2943,8.84393,'P','PPLA2','CH.ZH','CH.ZH.105',5488,'Europe/Zurich',1,'2013-03-27 23:00:00','2013-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660355,'CH','Herzogenbuchsee','Herzogenbuchsee',47.188,7.7062,'P','PPL','CH.BE','CH.BE.244',5522,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660359,'CH','Herrliberg','Herrliberg',47.2906,8.61464,'P','PPL','CH.ZH','CH.ZH.107',5025,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660365,'CH','Herisau','Herisau',47.3862,9.27916,'P','PPLA','CH.AR','CH.AR.1501',15438,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660367,'CH','Hergiswil','Hergiswil',46.9843,8.30944,'P','PPL','CH.NW','CH.NW.700',5437,'Europe/Zurich',1,'2013-03-03 23:00:00','2013-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660390,'CH','Heimberg','Heimberg',46.7948,7.60433,'P','PPL','CH.BE','CH.BE.247',5501,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660461,'CH','Gstaad','Gstaad',46.4721,7.28685,'P','PPL','CH.BE','CH.BE.248',9200,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660512,'CH','Grenchen','Grenchen',47.1921,7.39586,'P','PPL','CH.SO','CH.SO.1107',15927,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660515,'CH','Greifensee','Greifensee',47.3672,8.68115,'P','PPL','CH.ZH','CH.ZH.109',5032,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660523,'CH','Gränichen','Graenichen',47.3593,8.10243,'P','PPLA3','CH.AG','CH.AG.1901',6557,'Europe/Zurich',1,'2013-03-03 23:00:00','2013-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660532,'CH','Le Grand-Saconnex','Le Grand-Saconnex',46.2319,6.12091,'P','PPL','CH.GE','CH.GE.2500',9781,'Europe/Zurich',1,'2016-08-02 23:00:00','2016-08-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660543,'CH','Grabs','Grabs',47.1825,9.44395,'P','PPL','CH.SG','CH.SG.1724',6384,'Europe/Zurich',1,'2013-06-19 23:00:00','2013-06-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660549,'CH','Gossau','Gossau',47.4155,9.25482,'P','PPL','CH.SG','CH.SG.1721',17043,'Europe/Zurich',1,'2015-09-05 23:00:00','2015-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660573,'CH','Goldau','Goldau',47.0476,8.54616,'P','PPL','CH.SZ','CH.SZ.506',5285,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660575,'CH','Goldach','Goldach',47.474,9.46711,'P','PPL','CH.SG','CH.SG.1722',9094,'Europe/Zurich',1,'2015-09-05 23:00:00','2015-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660594,'CH','Glarus','Glarus',47.0406,9.06804,'P','PPLA','CH.GL','CH.GL.800',5681,'Europe/Zurich',1,'2014-03-05 23:00:00','2014-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660600,'CH','Gland','Gland',46.4208,6.2701,'P','PPL','CH.VD','CH.VD.2228',10641,'Europe/Zurich',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660603,'CH','Giubiasco','Giubiasco',46.1725,9.00793,'P','PPL','CH.TI','CH.TI.2101',7752,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660646,'CH','Genève','Geneve',46.2022,6.14569,'P','PPLA','CH.GE','CH.GE.2500',183981,'Europe/Zurich',1,'2017-11-28 23:00:00','2017-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660656,'CH','Gelterkinden','Gelterkinden',47.465,7.85174,'P','PPL','CH.BL','CH.BL.1304',5709,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660700,'CH','Fully','Fully',46.1385,7.11468,'P','PPL','CH.VS','CH.VS.2307',5922,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660707,'CH','Frutigen','Frutigen',46.5872,7.64945,'P','PPL','CH.BE','CH.BE.249',6671,'Europe/Zurich',1,'2017-03-03 23:00:00','2017-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660718,'CH','Fribourg','Fribourg',46.8024,7.15128,'P','PPLA','CH.FR','CH.FR.1004',32827,'Europe/Zurich',1,'2014-05-27 23:00:00','2014-05-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660719,'CH','Frenkendorf','Frenkendorf',47.5069,7.71648,'P','PPL','CH.BL','CH.BL.1303',6180,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660721,'CH','Freienbach','Freienbach',47.2053,8.75842,'P','PPL','CH.SZ','CH.SZ.503',14302,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660727,'CH','Frauenfeld','Frauenfeld',47.5578,8.89893,'P','PPLA','CH.TG','CH.TG.2012',21979,'Europe/Zurich',1,'2015-09-12 23:00:00','2015-09-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660762,'CH','Flawil','Flawil',47.413,9.18324,'P','PPL','CH.SG','CH.SG.1728',9739,'Europe/Zurich',1,'2015-09-05 23:00:00','2015-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660851,'CH','Estavayer-le-Lac','Estavayer-le-Lac',46.8488,6.8465,'P','PPL','CH.FR','CH.FR.1001',5061,'Europe/Zurich',1,'2017-07-26 23:00:00','2017-07-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660860,'CH','Eschenbach','Eschenbach',47.2398,8.92156,'P','PPL','CH.SG','CH.SG.1726',9175,'Europe/Zurich',1,'2014-04-03 23:00:00','2014-04-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660884,'CH','Epalinges','Epalinges',46.549,6.66831,'P','PPL','CH.VD','CH.VD.2225',7706,'Europe/Zurich',1,'2017-02-02 23:00:00','2017-02-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660911,'CH','Emmen','Emmen',47.0782,8.27331,'P','PPL','CH.LU','CH.LU.313',26889,'Europe/Zurich',1,'2017-09-12 23:00:00','2017-09-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660913,'CH','Embrach','Embrach',47.5056,8.59406,'P','PPL','CH.ZH','CH.ZH.103',7088,'Europe/Zurich',1,'2013-03-27 23:00:00','2013-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660925,'CH','Einsiedeln','Einsiedeln',47.1285,8.74735,'P','PPLA2','CH.SZ','CH.SZ.501',13148,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660944,'CH','Effretikon','Effretikon',47.4258,8.69094,'P','PPLX','CH.ZH','CH.ZH.108',10119,'Europe/Zurich',1,'2017-07-26 23:00:00','2017-07-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660947,'CH','Ecublens','Ecublens',46.6073,6.80895,'P','PPL','CH.FR','CH.FR.1002',10065,'Europe/Zurich',1,'2015-06-07 23:00:00','2015-06-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660953,'CH','Ebikon','Ebikon',47.0794,8.34041,'P','PPL','CH.LU','CH.LU.312',11471,'Europe/Zurich',1,'2014-04-03 23:00:00','2014-04-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660970,'CH','Düdingen','Dudingen',46.8492,7.1915,'P','PPL','CH.FR','CH.FR.1006',7155,'Europe/Zurich',1,'2017-09-03 23:00:00','2017-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660971,'CH','Dübendorf','Dubendorf',47.3972,8.61872,'P','PPL','CH.ZH','CH.ZH.109',19882,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2660989,'CH','Dornach','Dornach',47.4804,7.61644,'P','PPL','CH.SO','CH.SO.1104',6449,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661001,'CH','Domat','Domat',46.8348,9.45075,'P','PPLA2','CH.GR','CH.GR.1844',6817,'Europe/Zurich',1,'2017-07-26 23:00:00','2017-07-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661014,'CH','Dietlikon / Dietlikon (Dorf)','Dietlikon / Dietlikon (Dorf)',47.4183,8.6188,'P','PPLX','CH.ZH','CH.ZH.103',6149,'Europe/Zurich',1,'2013-03-27 23:00:00','2013-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661015,'CH','Dietikon','Dietikon',47.4016,8.40015,'P','PPL','CH.ZH','CH.ZH.111',20893,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661021,'CH','Diepoldsau','Diepoldsau',47.386,9.65558,'P','PPL','CH.SG','CH.SG.1723',5401,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661030,'CH','Derendingen','Derendingen',47.1985,7.58844,'P','PPL','CH.SO','CH.SO.1106',6093,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661035,'CH','Delémont','Delemont',47.3649,7.34453,'P','PPLA','CH.JU','CH.JU.2601',11315,'Europe/Zurich',1,'2015-09-13 23:00:00','2015-09-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661039,'CH','Davos','Davos',46.8043,9.83723,'P','PPL','CH.GR','CH.GR.1849',11024,'Europe/Zurich',1,'2017-07-26 23:00:00','2017-07-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661072,'CH','Crissier','Crissier',46.5459,6.57567,'P','PPL','CH.VD','CH.VD.2229',6612,'Europe/Zurich',1,'2017-02-02 23:00:00','2017-02-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661129,'CH','Conthey','Conthey',46.2237,7.30283,'P','PPLA2','CH.VS','CH.VS.2302',6634,'Europe/Zurich',1,'2017-09-12 23:00:00','2017-09-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661144,'CH','Colombier','Colombier',46.5571,6.47284,'P','PPL','CH.VD','CH.VD.2227',9297,'Europe/Zurich',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661148,'CH','Collombey','Collombey',46.2738,6.94789,'P','PPL','CH.VS','CH.VS.2308',5926,'Europe/Zurich',1,'2016-08-02 23:00:00','2016-08-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661169,'CH','Chur','Chur',46.8499,9.53287,'P','PPLA','CH.GR','CH.GR.1848',32429,'Europe/Zurich',1,'2017-07-26 23:00:00','2017-07-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661176,'CH','Chiasso','Chiasso',45.832,9.03119,'P','PPL','CH.TI','CH.TI.2106',8060,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661191,'CH','Chêne-Bourg','Chene-Bourg',46.1953,6.19406,'P','PPL','CH.GE','CH.GE.2500',7959,'Europe/Zurich',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661197,'CH','Chavannes','Chavannes',46.53,6.57068,'P','PPL','CH.VD','CH.VD.2229',5454,'Europe/Zurich',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661202,'CH','Châtel-Saint-Denis','Chatel-Saint-Denis',46.5269,6.90083,'P','PPL','CH.FR','CH.FR.1007',5094,'Europe/Zurich',1,'2013-02-25 23:00:00','2013-02-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661228,'CH','Cham','Cham',47.1821,8.46358,'P','PPL','CH.ZG','CH.ZG.900',13495,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661265,'CH','Carouge','Carouge',46.181,6.13921,'P','PPL','CH.GE','CH.GE.2500',19344,'Europe/Zurich',1,'2015-06-07 23:00:00','2015-06-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661305,'CH','Bussigny','Bussigny',46.5511,6.55597,'P','PPL','CH.VD','CH.VD.2229',7408,'Europe/Zurich',1,'2017-12-21 23:00:00','2017-12-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661321,'CH','Burgdorf','Burgdorf',47.059,7.62786,'P','PPL','CH.BE','CH.BE.245',14788,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661328,'CH','Buochs','Buochs',46.974,8.42279,'P','PPL','CH.NW','CH.NW.700',5524,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661337,'CH','Bulle','Bulle',46.618,7.0569,'P','PPL','CH.FR','CH.FR.1003',12095,'Europe/Zurich',1,'2017-03-03 23:00:00','2017-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661338,'CH','Bülach','Bulach',47.522,8.54049,'P','PPLA2','CH.ZH','CH.ZH.103',13172,'Europe/Zurich',1,'2013-03-27 23:00:00','2013-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661348,'CH','Buchs','Buchs',47.3936,8.08233,'P','PPLA3','CH.AG','CH.AG.1901',6599,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661349,'CH','Buchs','Buchs',47.1674,9.47794,'P','PPL','CH.SG','CH.SG.1724',10418,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661350,'CH','Buchrain','Buchrain',47.0962,8.34729,'P','PPL','CH.LU','CH.LU.312',5341,'Europe/Zurich',1,'2014-04-03 23:00:00','2014-04-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661374,'CH','Brugg','Brugg',47.481,8.20869,'P','PPLA2','CH.AG','CH.AG.1904',9196,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661407,'CH','Bremgarten','Bremgarten',47.3511,8.34214,'P','PPLA2','CH.AG','CH.AG.1903',6543,'Europe/Zurich',1,'2013-03-03 23:00:00','2013-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661432,'CH','Bottmingen','Bottmingen',47.5234,7.57211,'P','PPL','CH.BL','CH.BL.1301',5912,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661456,'CH','Bolligen','Bolligen',46.9751,7.49697,'P','PPL','CH.BE','CH.BE.246',6086,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661468,'CH','Blonay','Blonay',46.4678,6.89615,'P','PPL','CH.VD','CH.VD.2230',5244,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661490,'CH','Birsfelden','Birsfelden',47.5529,7.62322,'P','PPL','CH.BL','CH.BL.1301',10232,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661499,'CH','Binningen','Binningen',47.5402,7.56932,'P','PPL','CH.BL','CH.BL.1301',14130,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661513,'CH','Biel/Bienne','Biel/Bienne',47.1371,7.24608,'P','PPLA2','CH.BE','CH.BE.242',48614,'Europe/Zurich',1,'2015-11-01 23:00:00','2015-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661519,'CH','Biberist','Biberist',47.1801,7.56246,'P','PPL','CH.SO','CH.SO.1106',7889,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661524,'CH','Biasca','Biasca',46.3597,8.96965,'P','PPL','CH.TI','CH.TI.2107',5885,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661527,'CH','Bex','Bex',46.2496,7.0098,'P','PPL','CH.VD','CH.VD.2221',5956,'Europe/Zurich',1,'2016-08-02 23:00:00','2016-08-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661547,'CH','Bernex','Bernex',46.1765,6.07544,'P','PPL','CH.GE','CH.GE.2500',9759,'Europe/Zurich',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661552,'CH','Bern','Bern',46.9481,7.44744,'P','PPLC','CH.BE','CH.BE.246',121631,'Europe/Zurich',1,'2013-11-07 23:00:00','2013-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661563,'CH','Belp','Belp',46.8913,7.49825,'P','PPL','CH.BE','CH.BE.246',9307,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661567,'CH','Bellinzona','Bellinzona',46.1928,9.01703,'P','PPLA','CH.TI','CH.TI.2101',16572,'Europe/Zurich',1,'2013-04-20 23:00:00','2013-04-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661599,'CH','Bassersdorf','Bassersdorf',47.4434,8.62851,'P','PPL','CH.ZH','CH.ZH.103',7010,'Europe/Zurich',1,'2013-03-27 23:00:00','2013-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661600,'CH','Basse-Nendaz','Basse-Nendaz',46.1899,7.31209,'P','PPL','CH.VS','CH.VS.2302',5410,'Europe/Zurich',1,'2013-02-26 23:00:00','2013-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661604,'CH','Basel','Basel',47.5584,7.57327,'P','PPLA','CH.BS','CH.BS.1200',164488,'Europe/Zurich',1,'2013-03-09 23:00:00','2013-03-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661626,'CH','Balsthal','Balsthal',47.3161,7.69318,'P','PPL','CH.SO','CH.SO.1102',5863,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661641,'CH','Bagnes','Bagnes',46.0833,7.21667,'P','PPL','CH.VS','CH.VS.2303',6626,'Europe/Zurich',1,'2015-06-08 23:00:00','2015-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661644,'CH','Bad Ragaz','Bad Ragaz',47.006,9.50266,'P','PPL','CH.SG','CH.SG.1725',5063,'Europe/Zurich',1,'2013-03-24 23:00:00','2013-03-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661646,'CH','Baden','Baden',47.4733,8.30592,'P','PPLA2','CH.AG','CH.AG.1902',16118,'Europe/Zurich',1,'2015-07-02 23:00:00','2015-07-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661653,'CH','Baar','Baar',47.1963,8.52954,'P','PPL','CH.ZG','CH.ZG.900',20546,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661666,'CH','Zürich (Kreis 4) / Aussersihl','Zuerich (Kreis 4) / Aussersihl',47.3775,8.52127,'P','PPLX','CH.ZH','CH.ZH.112',27273,'Europe/Zurich',1,'2016-03-22 23:00:00','2016-03-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661689,'CH','Au','Au',47.4309,9.63448,'P','PPL','CH.SG','CH.SG.1723',6673,'Europe/Zurich',1,'2017-10-26 23:00:00','2017-10-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661698,'CH','Ascona','Ascona',46.1545,8.77327,'P','PPL','CH.TI','CH.TI.2104',5084,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661708,'CH','Arth','Arth',47.0634,8.52349,'P','PPLA3','CH.SZ','CH.SZ.506',9850,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661719,'CH','Arlesheim','Arlesheim',47.4941,7.61979,'P','PPLA2','CH.BL','CH.BL.1301',9301,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661731,'CH','Arbon','Arbon',47.5167,9.43333,'P','PPLA2','CH.TG','CH.TG.2011',12933,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661740,'CH','Appenzell','Appenzell',47.331,9.40996,'P','PPLA','CH.AI','CH.AI.1600',5649,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661756,'CH','Amriswil','Amriswil',47.547,9.29586,'P','PPL','CH.TG','CH.TG.2011',11351,'Europe/Zurich',1,'2015-09-05 23:00:00','2015-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661766,'CH','Altstätten','Altstatten',47.3777,9.54746,'P','PPL','CH.SG','CH.SG.1723',10574,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661776,'CH','Altendorf','Altendorf',47.1899,8.83823,'P','PPL','CH.SZ','CH.SZ.505',5280,'Europe/Zurich',1,'2015-09-05 23:00:00','2015-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661780,'CH','Altdorf','Altdorf',46.8804,8.64441,'P','PPLA','CH.UR','CH.UR.400',8678,'Europe/Zurich',1,'2013-03-04 23:00:00','2013-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661789,'CH','Alpnach','Alpnach',46.9423,8.2718,'P','PPL','CH.OW','CH.OW.600',5218,'Europe/Zurich',1,'2015-04-07 23:00:00','2015-04-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661810,'CH','Allschwil','Allschwil',47.5507,7.53599,'P','PPL','CH.BL','CH.BL.1301',18189,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661834,'CH','Aigle','Aigle',46.3181,6.96457,'P','PPLA2','CH.VD','CH.VD.2221',7723,'Europe/Zurich',1,'2014-03-05 23:00:00','2014-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661842,'CH','Affoltern am Albis','Affoltern am Albis',47.2774,8.45128,'P','PPLA2','CH.ZH','CH.ZH.101',8928,'Europe/Zurich',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661852,'CH','Aesch','Aesch',47.471,7.5973,'P','PPL','CH.BL','CH.BL.1301',10138,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661861,'CH','Adliswil','Adliswil',47.31,8.52462,'P','PPL','CH.ZH','CH.ZH.106',15230,'Europe/Zurich',1,'2013-03-27 23:00:00','2013-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661862,'CH','Adligenswil','Adligenswil',47.0652,8.36124,'P','PPL','CH.LU','CH.LU.312',5576,'Europe/Zurich',1,'2014-04-03 23:00:00','2014-04-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661879,'CH','Aarburg','Aarburg',47.3207,7.89986,'P','PPL','CH.AG','CH.AG.1910',6828,'Europe/Zurich',1,'2013-02-28 23:00:00','2013-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661881,'CH','Aarau','Aarau',47.3925,8.04422,'P','PPLA','CH.AG','CH.AG.1901',15501,'Europe/Zurich',1,'2014-02-02 23:00:00','2014-02-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2661882,'CH','Aadorf','Aadorf',47.492,8.90099,'P','PPL','CH.TG','CH.TG.2014',7620,'Europe/Zurich',1,'2013-03-27 23:00:00','2013-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3206590,'CH','Riehen','Riehen',47.5788,7.64683,'P','PPL','CH.BS','CH.BS.1200',20000,'Europe/Zurich',1,'2013-02-27 23:00:00','2013-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3209498,'CH','Chêne-Bougeries','Chene-Bougeries',46.1984,6.18642,'P','PPL','CH.GE','CH.GE.2500',10487,'Europe/Zurich',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3209505,'CH','Thônex','Thonex',46.1881,6.19904,'P','PPL','CH.GE','CH.GE.2500',13057,'Europe/Zurich',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6285791,'CH','Ecublens','Ecublens',46.529,6.56261,'P','PPLA3','CH.VD','CH.VD.2229',10262,'Europe/Zurich',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6291374,'CH','Wallisellen / Wallisellen-Ost','Wallisellen / Wallisellen-Ost',47.4145,8.59727,'P','PPLX','CH.ZH','CH.ZH.103',5031,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6292757,'CH','Horgen / Horgen (Dorfkern)','Horgen / Horgen (Dorfkern)',47.256,8.60159,'P','PPLX','CH.ZH','CH.ZH.106',6140,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6293080,'CH','Thalwil / Dorfkern','Thalwil / Dorfkern',47.2905,8.56633,'P','PPLX','CH.ZH','CH.ZH.106',6829,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6293977,'CH','Pfäffikon / Pfäffikon (Dorfkern)','Pfaeffikon / Pfaeffikon (Dorfkern)',47.3694,8.78309,'P','PPLX','CH.ZH','CH.ZH.108',5595,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6294547,'CH','Uster / Kirch-Uster','Uster / Kirch-Uster',47.3458,8.71839,'P','PPLX','CH.ZH','CH.ZH.109',10428,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6294550,'CH','Uster / Ober-Uster','Uster / Ober-Uster',47.3487,8.73319,'P','PPLX','CH.ZH','CH.ZH.109',5100,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295092,'CH','Oberwinterthur (Kreis 2) / Talacker','Oberwinterthur (Kreis 2) / Talacker',47.506,8.7515,'P','PPLX','CH.ZH','CH.ZH.110',5375,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295102,'CH','Oberwinterthur (Kreis 2) / Guggenbühl','Oberwinterthur (Kreis 2) / Guggenbuehl',47.5134,8.75998,'P','PPLX','CH.ZH','CH.ZH.110',5376,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295183,'CH','Mattenbach (Kreis 7) / Deutweg','Mattenbach (Kreis 7) / Deutweg',47.4942,8.73948,'P','PPLX','CH.ZH','CH.ZH.110',5930,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295475,'CH','Zürich (Kreis 10) / Wipkingen','Zuerich (Kreis 10) / Wipkingen',47.395,8.52529,'P','PPLX','CH.ZH','CH.ZH.112',15718,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295484,'CH','Zürich (Kreis 11) / Affoltern','Zuerich (Kreis 11) / Affoltern',47.4181,8.5122,'P','PPLX','CH.ZH','CH.ZH.112',17241,'Europe/Zurich',1,'2017-12-20 23:00:00','2017-12-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295490,'CH','Zürich (Kreis 12) / Saatlen','Zuerich (Kreis 12) / Saatlen',47.4113,8.5648,'P','PPLX','CH.ZH','CH.ZH.112',5209,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295491,'CH','Zürich (Kreis 12) / Schwamendingen-Mitte','Zuerich (Kreis 12) / Schwamendingen-Mitte',47.4063,8.57242,'P','PPLX','CH.ZH','CH.ZH.112',10476,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295492,'CH','Zürich (Kreis 12) / Hirzenbach','Zuerich (Kreis 12) / Hirzenbach',47.4019,8.58633,'P','PPLX','CH.ZH','CH.ZH.112',11335,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295495,'CH','Zürich (Kreis 2) / Wollishofen','Zuerich (Kreis 2) / Wollishofen',47.3401,8.53134,'P','PPLX','CH.ZH','CH.ZH.112',16073,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295496,'CH','Zürich (Kreis 2) / Enge','Zuerich (Kreis 2) / Enge',47.3605,8.53127,'P','PPLX','CH.ZH','CH.ZH.112',8253,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295497,'CH','Zürich (Kreis 3) / Friesenberg','Zuerich (Kreis 3) / Friesenberg',47.3637,8.50417,'P','PPLX','CH.ZH','CH.ZH.112',9909,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295498,'CH','Zürich (Kreis 3) / Sihlfeld','Zuerich (Kreis 3) / Sihlfeld',47.3738,8.51164,'P','PPLX','CH.ZH','CH.ZH.112',20977,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295500,'CH','Zürich (Kreis 4) / Langstrasse','Zuerich (Kreis 4) / Langstrasse',47.3777,8.52854,'P','PPLX','CH.ZH','CH.ZH.112',10386,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295501,'CH','Zürich (Kreis 4) / Hard','Zuerich (Kreis 4) / Hard',47.3831,8.50942,'P','PPLX','CH.ZH','CH.ZH.112',12976,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295502,'CH','Zürich (Kreis 5) / Gewerbeschule','Zuerich (Kreis 5) / Gewerbeschule',47.3848,8.53011,'P','PPLX','CH.ZH','CH.ZH.112',9891,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295504,'CH','Zürich (Kreis 6) / Unterstrass','Zuerich (Kreis 6) / Unterstrass',47.3953,8.53721,'P','PPLX','CH.ZH','CH.ZH.112',20045,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295505,'CH','Zürich (Kreis 6) / Oberstrass','Zuerich (Kreis 6) / Oberstrass',47.3892,8.5504,'P','PPLX','CH.ZH','CH.ZH.112',9906,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295506,'CH','Zürich (Kreis 7) / Fluntern','Zuerich (Kreis 7) / Fluntern',47.3801,8.56133,'P','PPLX','CH.ZH','CH.ZH.112',7009,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295507,'CH','Zürich (Kreis 7) / Hottingen','Zuerich (Kreis 7) / Hottingen',47.3701,8.56306,'P','PPLX','CH.ZH','CH.ZH.112',9934,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295508,'CH','Zürich (Kreis 7) / Hirslanden','Zuerich (Kreis 7) / Hirslanden',47.3624,8.56755,'P','PPLX','CH.ZH','CH.ZH.112',6769,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295510,'CH','Zürich (Kreis 8) / Mühlebach','Zuerich (Kreis 8) / Muehlebach',47.3573,8.55744,'P','PPLX','CH.ZH','CH.ZH.112',5570,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295512,'CH','Zürich (Kreis 9) / Albisrieden','Zuerich (Kreis 9) / Albisrieden',47.374,8.49007,'P','PPLX','CH.ZH','CH.ZH.112',16480,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295513,'CH','Zürich (Kreis 9) / Altstetten','Zuerich (Kreis 9) / Altstetten',47.3895,8.48533,'P','PPLX','CH.ZH','CH.ZH.112',28307,'Europe/Zurich',1,'2006-10-20 23:00:00','2006-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295517,'CH','Hegnau','Hegnau',47.3923,8.66988,'P','PPL','CH.ZH','CH.ZH.109',7961,'Europe/Zurich',1,'2015-06-07 23:00:00','2015-06-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295520,'CH','Stadt Winterthur (Kreis 1)','Stadt Winterthur (Kreis 1)',47.4949,8.71954,'P','PPL','CH.ZH','CH.ZH.110',16182,'Europe/Zurich',1,'2006-10-04 23:00:00','2006-10-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295521,'CH','Zürich (Kreis 5)','Zuerich (Kreis 5)',47.3877,8.52152,'P','PPLX','CH.ZH','CH.ZH.112',11737,'Europe/Zurich',1,'2012-07-29 23:00:00','2012-07-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295523,'CH','Zürich (Kreis 12)','Zuerich (Kreis 12)',47.4037,8.57608,'P','PPLX','CH.ZH','CH.ZH.112',28189,'Europe/Zurich',1,'2012-07-29 23:00:00','2012-07-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295524,'CH','Wülflingen (Kreis 6)','Wuelflingen (Kreis 6)',47.5104,8.68333,'P','PPL','CH.ZH','CH.ZH.110',12598,'Europe/Zurich',1,'2006-10-04 23:00:00','2006-10-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295531,'CH','Seen (Kreis 3)','Seen (Kreis 3)',47.4765,8.76996,'P','PPL','CH.ZH','CH.ZH.110',15434,'Europe/Zurich',1,'2006-10-04 23:00:00','2006-10-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295532,'CH','Zürich (Kreis 3)','Zuerich (Kreis 3)',47.3578,8.50296,'P','PPLX','CH.ZH','CH.ZH.112',46018,'Europe/Zurich',1,'2012-07-29 23:00:00','2012-07-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295533,'CH','Zürich (Kreis 11)','Zuerich (Kreis 11)',47.4233,8.52166,'P','PPLX','CH.ZH','CH.ZH.112',54260,'Europe/Zurich',1,'2012-07-29 23:00:00','2012-07-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295534,'CH','Zürich (Kreis 9)','Zuerich (Kreis 9)',47.3825,8.47993,'P','PPLX','CH.ZH','CH.ZH.112',44878,'Europe/Zurich',1,'2012-07-29 23:00:00','2012-07-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295536,'CH','Oberwinterthur (Kreis 2)','Oberwinterthur (Kreis 2)',47.5169,8.76863,'P','PPLX','CH.ZH','CH.ZH.110',16356,'Europe/Zurich',1,'2016-07-26 23:00:00','2016-07-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295539,'CH','Zürich (Kreis 10)','Zuerich (Kreis 10)',47.4077,8.5005,'P','PPLX','CH.ZH','CH.ZH.112',36216,'Europe/Zurich',1,'2012-07-29 23:00:00','2012-07-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295540,'CH','Zürich (Kreis 2)','Zuerich (Kreis 2)',47.3376,8.5211,'P','PPLX','CH.ZH','CH.ZH.112',29215,'Europe/Zurich',1,'2012-07-18 23:00:00','2012-07-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295542,'CH','Zürich (Kreis 8)','Zuerich (Kreis 8)',47.3548,8.56097,'P','PPLX','CH.ZH','CH.ZH.112',15519,'Europe/Zurich',1,'2012-07-29 23:00:00','2012-07-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295546,'CH','Zürich (Kreis 1)','Zuerich (Kreis 1)',47.3705,8.54177,'P','PPLX','CH.ZH','CH.ZH.112',6185,'Europe/Zurich',1,'2012-07-18 23:00:00','2012-07-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295547,'CH','Mattenbach (Kreis 7)','Mattenbach (Kreis 7)',47.487,8.74681,'P','PPL','CH.ZH','CH.ZH.110',11043,'Europe/Zurich',1,'2006-10-04 23:00:00','2006-10-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295548,'CH','Zürich (Kreis 7)','Zuerich (Kreis 7)',47.3733,8.58038,'P','PPLX','CH.ZH','CH.ZH.112',33820,'Europe/Zurich',1,'2012-07-29 23:00:00','2012-07-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295550,'CH','Zürich (Kreis 6)','Zuerich (Kreis 6)',47.3922,8.54381,'P','PPLX','CH.ZH','CH.ZH.112',29951,'Europe/Zurich',1,'2012-07-29 23:00:00','2012-07-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6620245,'CH','Thal','Thal',47.4668,9.56643,'P','PPL','CH.SG','CH.SG.1722',6433,'Europe/Zurich',1,'2015-11-09 23:00:00','2015-11-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6640317,'CH','Langnau am Albis','Langnau am Albis',47.2888,8.5411,'P','PPL','CH.ZH','CH.ZH.106',7000,'Europe/Zurich',1,'2013-03-27 23:00:00','2013-03-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6691640,'CH','Lancy','Lancy',46.1898,6.11441,'P','PPLX','CH.GE','CH.GE.2500',27291,'Europe/Zurich',1,'2015-05-24 23:00:00','2015-05-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7779000,'CH','Les Avanchets','Les Avanchets',46.2217,6.10814,'P','PPL','CH.GE','CH.GE.2500',5730,'Europe/Zurich',1,'2011-05-03 23:00:00','2011-05-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8521688,'CH','Blécherette','Blecherette',46.5393,6.62227,'P','PPLX','CH.VD','CH.VD.2225',6516,'Europe/Zurich',1,'2013-05-05 23:00:00','2013-05-05 23:00:00');


