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


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

INSERT INTO `<<prefix>>subadmin1` VALUES (959,'FI.19','FI','Lapland','Lapland',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (960,'FI.18','FI','Kainuu','Kainuu',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (961,'FI.17','FI','Northern Ostrobothnia','Northern Ostrobothnia',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (962,'FI.16','FI','Central Ostrobothnia','Central Ostrobothnia',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (963,'FI.15','FI','Ostrobothnia','Ostrobothnia',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (964,'FI.14','FI','Southern Ostrobothnia','Southern Ostrobothnia',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (965,'FI.13','FI','Central Finland','Central Finland',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (966,'FI.12','FI','North Karelia','North Karelia',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (967,'FI.11','FI','Northern Savo','Northern Savo',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (968,'FI.10','FI','Southern Savonia','Southern Savonia',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (969,'FI.09','FI','South Karelia','South Karelia',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (970,'FI.08','FI','Kymenlaakso','Kymenlaakso',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (971,'FI.06','FI','Pirkanmaa','Pirkanmaa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (972,'FI.05','FI','Tavastia Proper','Tavastia Proper',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (973,'FI.02','FI','Finland Proper','Finland Proper',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (974,'FI.01','FI','Uusimaa','Uusimaa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (975,'FI.07','FI','Päijänne Tavastia','Paijanne Tavastia',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (976,'FI.04','FI','Satakunta','Satakunta',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (12856,'FI.15.153','FI','FI.15','Sydösterbotten','Sydosterbotten',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12857,'FI.02.021','FI','FI.02','Åboland-Turunmaa','Aboland-Turunmaa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12858,'FI.02.022','FI','FI.02','Salo','Salo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12859,'FI.10.103','FI','FI.10','Savonlinna','Savonlinna',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12860,'FI.10.105','FI','FI.10','Pieksämäki','Pieksaemaeki',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12861,'FI.11.111','FI','FI.11','Ylä-Savo','Ylae-Savo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12862,'FI.11.112','FI','FI.11','Kuopio','Kuopio',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12863,'FI.11.113','FI','FI.11','Koillis-Savo','Koillis-Savo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12864,'FI.11.114','FI','FI.11','Varkaus','Varkaus',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12865,'FI.11.115','FI','FI.11','Sisä-Savo','Sisae-Savo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12866,'FI.12.122','FI','FI.12','Joensuu','Joensuu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12867,'FI.12.124','FI','FI.12','Keski-Karjala','Keski-Karjala',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12868,'FI.12.125','FI','FI.12','Pielisen Karjala','Pielisen Karjala',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12869,'FI.13.131','FI','FI.13','Jyväskylä','Jyvaeskylae',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12870,'FI.13.132','FI','FI.13','Joutsa','Joutsa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12871,'FI.13.133','FI','FI.13','Keuruu','Keuruu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12872,'FI.13.134','FI','FI.13','Jämsä','Jaemsae',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12873,'FI.13.135','FI','FI.13','Äänekoski','AEaenekoski',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12874,'FI.13.138','FI','FI.13','Saarijärvi-Viitasaari','Saarijaervi-Viitasaari',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12875,'FI.14.141','FI','FI.14','Suupohja','Suupohja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12876,'FI.14.142','FI','FI.14','Seinäjoki','Seinaejoki',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12877,'FI.14.144','FI','FI.14','Kuusiokunnat','Kuusiokunnat',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12878,'FI.14.146','FI','FI.14','Järviseutu','Jaerviseutu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12879,'FI.15.151','FI','FI.15','Kyrönmaa','Kyroenmaa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12880,'FI.15.152','FI','FI.15','Vaasa','Vaasa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12881,'FI.15.154','FI','FI.15','Jakobstadsregionen','Jakobstadsregionen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12882,'FI.16.161','FI','FI.16','Kaustinen','Kaustinen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12883,'FI.16.162','FI','FI.16','Kokkola','Kokkola',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12884,'FI.17.171','FI','FI.17','Oulu','Oulu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12885,'FI.17.173','FI','FI.17','Oulunkaari','Oulunkaari',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12886,'FI.02.023','FI','FI.02','Turku','Turku',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12887,'FI.02.024','FI','FI.02','Vakka-Suomi','Vakka-Suomi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12888,'FI.02.025','FI','FI.02','Loimaa','Loimaa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12889,'FI.01.011','FI','FI.01','Helsinki','Helsinki',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12890,'FI.04.041','FI','FI.04','Rauma','Rauma',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12891,'FI.04.043','FI','FI.04','Pori','Pori',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12892,'FI.04.044','FI','FI.04','Pohjois-Satakunta','Pohjois-Satakunta',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12893,'FI.05.051','FI','FI.05','Hämeenlinna','Haemeenlinna',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12894,'FI.05.052','FI','FI.05','Riihimäki','Riihimaeki',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12895,'FI.05.053','FI','FI.05','Forssa','Forssa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12896,'FI.06.061','FI','FI.06','Luoteis-Pirkanmaa','Luoteis-Pirkanmaa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12897,'FI.06.063','FI','FI.06','Etelä-Pirkanmaa','Etelae-Pirkanmaa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12898,'FI.06.064','FI','FI.06','Tampere','Tampere',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12899,'FI.06.068','FI','FI.06','Lounais-Pirkanmaa','Lounais-Pirkanmaa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12900,'FI.06.069','FI','FI.06','Ylä-Pirkanmaa','Ylae-Pirkanmaa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12901,'FI.07.071','FI','FI.07','Lahti','Lahti',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12902,'FI.08.081','FI','FI.08','Kouvola','Kouvola',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12903,'FI.08.082','FI','FI.08','Kotka-Hamina','Kotka-Hamina',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12904,'FI.09.091','FI','FI.09','Lappeenranta','Lappeenranta',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12905,'FI.09.093','FI','FI.09','Imatra','Imatra',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12906,'FI.10.101','FI','FI.10','Mikkeli','Mikkeli',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12907,'FI.01.014','FI','FI.01','Raaseporin','Raaseporin',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12908,'FI.01.015','FI','FI.01','Porvoo','Porvoo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12909,'FI.01.016','FI','FI.01','Loviisa','Loviisa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12910,'FI.17.174','FI','FI.17','Raahe','Raahe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12911,'FI.17.175','FI','FI.17','Haapavesi-Siikalatva','Haapavesi-Siikalatva',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12912,'FI.17.176','FI','FI.17','Nivala-Haapajärvi','Nivala-Haapajaervi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12913,'FI.17.177','FI','FI.17','Ylivieska','Ylivieska',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12914,'FI.17.178','FI','FI.17','Koillismaa','Koillismaa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12915,'FI.18.181','FI','FI.18','Kehys-Kainuu','Kehys-Kainuu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12916,'FI.18.182','FI','FI.18','Kajaani','Kajaani',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12917,'FI.19.191','FI','FI.19','Rovaniemi','Rovaniemi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12918,'FI.19.192','FI','FI.19','Kemi-Tornio','Kemi-Tornio',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12919,'FI.19.193','FI','FI.19','Torniolaakso','Torniolaakso',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12920,'FI.19.194','FI','FI.19','Itä-Lappi','Itae-Lappi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12921,'FI.19.196','FI','FI.19','Tunturi-Lappi','Tunturi-Lappi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12922,'FI.19.197','FI','FI.19','Pohjois-Lappi','Pohjois-Lappi',1);

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

INSERT INTO `<<prefix>>cities` VALUES (630752,'FI','Ylöjärvi','Yloejaervi',61.5563,23.5961,'P','PPLA3','FI.06','FI.06.064',22140,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (630768,'FI','Ylivieska','Ylivieska',64.0833,24.55,'P','PPLA3','FI.17','FI.17.177',13159,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (630779,'FI','Ylitornio','Ylitornio',66.3089,23.6773,'P','PPLA3','FI.19','FI.19.193',5104,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (630805,'FI','Ylistaro','Ylistaro',62.9396,22.5131,'P','PPL','FI.14','FI.14.142',5580,'Europe/Helsinki',1,'2015-01-16 23:00:00','2015-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (631077,'FI','Vuosaari','Vuosaari',60.2096,25.142,'P','PPL','FI.01','FI.01.011',35826,'Europe/Helsinki',1,'2017-12-13 23:00:00','2017-12-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (631204,'FI','Vuokatti','Vuokatti',64.1447,28.282,'P','PPL','FI.18','FI.18.182',6183,'Europe/Helsinki',1,'2015-01-16 23:00:00','2015-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (631376,'FI','Virrat','Virrat',62.2476,23.78,'P','PPLA3','FI.06','FI.06.069',7707,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (631459,'FI','Vilppula','Vilppula',62.0212,24.5048,'P','PPLA3','FI.06','FI.06.069',5422,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (631560,'FI','Viitasaari','Viitasaari',63.0667,25.8667,'P','PPLA3','FI.13','FI.13.138',7511,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (631693,'FI','Viiala','Viiala',61.2102,23.7674,'P','PPL','FI.06','FI.06.063',5472,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (631707,'FI','Vihti','Vihti',60.417,24.3197,'P','PPLA3','FI.01','FI.01.011',26280,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (632370,'FI','Varkaus','Varkaus',62.3153,27.873,'P','PPLA3','FI.11','FI.11.114',22365,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (632453,'FI','Vantaa','Vantaa',60.2941,25.041,'P','PPLA3','FI.01','FI.01.011',190058,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (632542,'FI','Vammala','Vammala',61.3333,22.9,'P','PPLA3','FI.06','FI.06.068',14982,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (632672,'FI','Valkeakoski','Valkeakoski',61.2642,24.0312,'P','PPLA3','FI.06','FI.06.063',20376,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (632978,'FI','Vaasa','Vaasa',63.096,21.6158,'P','PPLA','FI.15','FI.15.152',57014,'Europe/Helsinki',1,'2015-04-20 23:00:00','2015-04-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (633221,'FI','Uusikaupunki','Uusikaupunki',60.8004,21.4084,'P','PPLA3','FI.02','FI.02.024',16226,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (633332,'FI','Urjala','Urjala',61.0833,23.5333,'P','PPLA3','FI.06','FI.06.063',5542,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (633395,'FI','Ulvila','Ulvila',61.4284,21.871,'P','PPLA3','FI.04','FI.04.043',12314,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (633541,'FI','Tyrnävä','Tyrnaevae',64.7647,25.6523,'P','PPLA3','FI.17','FI.17.171',5636,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (633591,'FI','Tuusula','Tuusula',60.4037,25.0264,'P','PPLA3','FI.01','FI.01.011',34725,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (633679,'FI','Turku','Turku',60.4515,22.2687,'P','PPLA','FI.02','FI.02.023',175945,'Europe/Helsinki',1,'2016-07-22 23:00:00','2016-07-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (634093,'FI','Tornio','Tornio',65.8481,24.1466,'P','PPLA3','FI.19','FI.19.192',21236,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (634317,'FI','Akaa','Akaa',61.1667,23.8667,'P','PPL','FI.06','FI.06.063',8258,'Europe/Helsinki',1,'2017-05-14 23:00:00','2017-05-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (634561,'FI','Teuva','Teuva',62.4819,21.7416,'P','PPLA3','FI.14','FI.14.141',6092,'Europe/Helsinki',1,'2015-02-28 23:00:00','2015-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (634963,'FI','Tampere','Tampere',61.4991,23.7871,'P','PPLA','FI.06','FI.06.064',202687,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (634992,'FI','Tammela','Tammela',60.8103,23.7682,'P','PPLA3','FI.05','FI.05.053',6519,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (635692,'FI','Suonenjoki','Suonenjoki',62.6167,27.1333,'P','PPLA3','FI.11','FI.11.115',7568,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (635696,'FI','Suomussalmi','Suomussalmi',64.8868,28.9078,'P','PPLA3','FI.18','FI.18.181',9974,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (635745,'FI','Suolahti','Suolahti',62.5642,25.8536,'P','PPL','FI.13','FI.13.135',5399,'Europe/Helsinki',1,'2015-01-16 23:00:00','2015-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (636173,'FI','Sotkamo','Sotkamo',64.1333,28.4167,'P','PPLA3','FI.18','FI.18.182',10368,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (636345,'FI','Somero','Somero',60.6167,23.5333,'P','PPLA3','FI.02','FI.02.022',9840,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (636464,'FI','Sodankylä','Sodankylae',67.4167,26.6,'P','PPLA3','FI.19','FI.19.197',8942,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (636608,'FI','Siuntio','Siuntio',60.1386,24.2271,'P','PPLA3','FI.01','FI.01.011',5229,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (636947,'FI','Siilinjärvi','Siilinjaervi',63.0833,27.6667,'P','PPLA3','FI.11','FI.11.112',20209,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (637035,'FI','Sievi','Sievi',63.9,24.5,'P','PPLA3','FI.17','FI.17.177',5281,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (637067,'FI','Sibbo','Sibbo',60.3775,25.2691,'P','PPLA3','FI.01','FI.01.011',19430,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (637219,'FI','Seinäjoki','Seinaejoki',62.7945,22.8282,'P','PPLA','FI.14','FI.14.142',32149,'Europe/Helsinki',1,'2015-08-23 23:00:00','2015-08-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (637292,'FI','Savonlinna','Savonlinna',61.8699,28.88,'P','PPLA3','FI.10','FI.10.103',27353,'Europe/Helsinki',1,'2015-03-11 23:00:00','2015-03-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (637948,'FI','Salo','Salo',60.3833,23.1333,'P','PPLA3','FI.02','FI.02.022',24900,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (638321,'FI','Saarijärvi','Saarijaervi',62.7049,25.254,'P','PPLA3','FI.13','FI.13.138',10011,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (638691,'FI','Ruovesi','Ruovesi',61.9857,24.0571,'P','PPLA3','FI.06','FI.06.069',5314,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (638803,'FI','Ruokolahti','Ruokolahti',61.2833,28.8333,'P','PPLA3','FI.09','FI.09.093',5780,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (638936,'FI','Rovaniemi','Rovaniemi',66.5,25.7167,'P','PPLA','FI.19','FI.19.191',34781,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (639248,'FI','Ristiina','Ristiina',61.5058,27.2464,'P','PPL','FI.10','FI.10.101',5171,'Europe/Helsinki',1,'2015-07-05 23:00:00','2015-07-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (639406,'FI','Riihimäki','Riihimaeki',60.7377,24.7773,'P','PPLA3','FI.05','FI.05.052',26451,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (639734,'FI','Rauma','Rauma',61.1272,21.5113,'P','PPLA3','FI.04','FI.04.041',36550,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (640124,'FI','Raisio','Raisio',60.4859,22.1689,'P','PPLA3','FI.02','FI.02.023',23597,'Europe/Helsinki',1,'2015-06-17 23:00:00','2015-06-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (640276,'FI','Raahe','Raahe',64.6833,24.4833,'P','PPLA3','FI.17','FI.17.174',22217,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (640398,'FI','Pyhäselkä','Pyhaeselkae',62.4333,29.9667,'P','PPLA3','FI.12','FI.12.122',7210,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (640440,'FI','Pyhäjärvi','Pyhaejaervi',67.0701,27.2176,'P','PPL','FI.19','FI.19.194',6094,'Europe/Helsinki',1,'2015-01-16 23:00:00','2015-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (640441,'FI','Pyhäjärvi','Pyhaejaervi',63.6667,25.9,'P','PPL','FI.17','FI.17.176',6138,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (640803,'FI','Pudasjärvi','Pudasjaervi',65.3833,26.9167,'P','PPLA3','FI.17','FI.17.173',9459,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (640999,'FI','Pori','Pori',61.4833,21.7833,'P','PPLA','FI.04','FI.04.043',76772,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (641124,'FI','Pohja','Pohja',60.0963,23.5276,'P','PPL','FI.01','FI.01.014',5257,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (641489,'FI','Pirkkala','Pirkkala',61.4613,23.6323,'P','PPLA3','FI.06','FI.06.064',15615,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (641651,'FI','Piikkiö','Piikkioe',60.4248,22.516,'P','PPLA3','FI.02','FI.02.023',6553,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (641861,'FI','Pielavesi','Pielavesi',63.2333,26.75,'P','PPLA3','FI.11','FI.11.111',5521,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (641869,'FI','Pieksämäki','Pieksaemaeki',62.3,27.1333,'P','PPLA3','FI.10','FI.10.105',12167,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (642113,'FI','Perniö','Pernioe',60.2,23.1333,'P','PPLA3','FI.02','FI.02.022',5809,'Europe/Helsinki',1,'2016-08-06 23:00:00','2016-08-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (642455,'FI','Pedersöre','Pedersoere',63.65,22.6833,'P','PPLA3','FI.15','FI.15.154',10436,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (642657,'FI','Parkano','Parkano',62.0167,23.0167,'P','PPLA3','FI.06','FI.06.061',7213,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (642673,'FI','Pargas','Pargas',60.3067,22.301,'P','PPLA3','FI.02','FI.02.021',11962,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (643153,'FI','Paimio','Paimio',60.4567,22.6869,'P','PPLA3','FI.02','FI.02.023',10126,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (643453,'FI','Outokumpu','Outokumpu',62.7268,29.0159,'P','PPLA3','FI.12','FI.12.122',7738,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (643481,'FI','Oulunsalo','Oulunsalo',64.9346,25.4112,'P','PPL','FI.17','FI.17.171',9556,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (643492,'FI','Oulu','Oulu',65.0124,25.4682,'P','PPLA','FI.17','FI.17.171',128618,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (643497,'FI','Oulainen','Oulainen',64.2667,24.8,'P','PPLA3','FI.17','FI.17.177',8300,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (643629,'FI','Orivesi','Orivesi',61.6777,24.3572,'P','PPLA3','FI.06','FI.06.064',8846,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (643644,'FI','Orimattila','Orimattila',60.8049,25.7296,'P','PPLA3','FI.07','FI.07.071',14603,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (644100,'FI','Nykarleby','Nykarleby',63.5228,22.5307,'P','PPLA3','FI.15','FI.15.154',7338,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (644159,'FI','Nurmo','Nurmo',62.8287,22.9099,'P','PPL','FI.14','FI.14.142',11908,'Europe/Helsinki',1,'2015-01-16 23:00:00','2015-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (644171,'FI','Nurmijärvi','Nurmijaervi',60.4641,24.8073,'P','PPLA3','FI.01','FI.01.011',37073,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (644187,'FI','Nurmes','Nurmes',63.542,29.1397,'P','PPLA3','FI.12','FI.12.125',8804,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (644436,'FI','Noormarkku','Noormarkku',61.5927,21.8685,'P','PPL','FI.04','FI.04.043',6076,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (644450,'FI','Nokia','Nokia',61.4667,23.5,'P','PPLA3','FI.06','FI.06.064',28676,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (644499,'FI','Nivala','Nivala',63.9167,24.9667,'P','PPLA3','FI.17','FI.17.176',10610,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (644632,'FI','Nilsiä','Nilsiae',63.2075,28.0822,'P','PPL','FI.11','FI.11.112',6474,'Europe/Helsinki',1,'2015-01-16 23:00:00','2015-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (645035,'FI','Nastola','Nastola',60.95,25.9333,'P','PPL','FI.07','FI.07.071',14911,'Europe/Helsinki',1,'2016-02-02 23:00:00','2016-02-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (645148,'FI','Nakkila','Nakkila',61.3667,22,'P','PPLA3','FI.04','FI.04.043',5792,'Europe/Helsinki',1,'2015-04-11 23:00:00','2015-04-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (645211,'FI','Naantali','Naantali',60.4674,22.0243,'P','PPLA3','FI.02','FI.02.023',13607,'Europe/Helsinki',1,'2015-05-13 23:00:00','2015-05-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (645243,'FI','Mynämäki','Mynaemaeki',60.6791,21.9927,'P','PPLA3','FI.02','FI.02.023',6271,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (645385,'FI','Muurame','Muurame',62.1333,25.6667,'P','PPLA3','FI.13','FI.13.131',8826,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (645691,'FI','Munkkiniemi','Munkkiniemi',60.1986,24.8777,'P','PPLX','FI.01','FI.01.011',17334,'Europe/Helsinki',1,'2017-12-12 23:00:00','2017-12-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (645765,'FI','Muhos','Muhos',64.808,25.9931,'P','PPL','FI.17','FI.17.171',8232,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (646005,'FI','Mikkeli','Mikkeli',61.6886,27.2723,'P','PPLA','FI.10','FI.10.101',46550,'Europe/Helsinki',1,'2015-05-13 23:00:00','2015-05-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (646218,'FI','Mellunkylä','Mellunkylae',60.2336,25.0995,'P','PPLX','FI.01','FI.01.011',36360,'Europe/Helsinki',1,'2017-12-13 23:00:00','2017-12-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (646486,'FI','Masku','Masku',60.5708,22.0988,'P','PPLA3','FI.02','FI.02.023',5974,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (646699,'FI','Mäntyharju','Maentyharju',61.4167,26.8833,'P','PPLA3','FI.10','FI.10.101',6871,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (646705,'FI','Mänttä','Maenttae',62.0301,24.6279,'P','PPLA3','FI.06','FI.06.069',6459,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (646723,'FI','Mäntsälä','Maentsaelae',60.6333,25.3167,'P','PPLA3','FI.01','FI.01.011',18074,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (646875,'FI','Malax','Malax',62.9422,21.5731,'P','PPLA3','FI.15','FI.15.152',5517,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (647288,'FI','Luumäki','Luumaeki',60.9262,27.5814,'P','PPLA3','FI.09','FI.09.091',5305,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (647571,'FI','Lovisa','Lovisa',60.4566,26.225,'P','PPLA3','FI.01','FI.01.016',15466,'Europe/Helsinki',1,'2015-04-13 23:00:00','2015-04-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (647660,'FI','Loppi','Loppi',60.7167,24.45,'P','PPLA3','FI.05','FI.05.052',7768,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (647751,'FI','Lohja','Lohja',60.2486,24.0653,'P','PPLA3','FI.01','FI.01.011',35960,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (647851,'FI','Liperi','Liperi',62.5333,29.3667,'P','PPLA3','FI.12','FI.12.122',11386,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (647930,'FI','Liminka','Liminka',64.8099,25.4154,'P','PPLA3','FI.17','FI.17.171',7058,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (648056,'FI','Lieto','Lieto',60.5103,22.4618,'P','PPLA3','FI.02','FI.02.023',15258,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (648090,'FI','Lieksa','Lieksa',63.3167,30.0167,'P','PPLA3','FI.12','FI.12.125',13703,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (648227,'FI','Leppävirta','Leppaevirta',62.4901,27.7826,'P','PPLA3','FI.11','FI.11.114',10936,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (648366,'FI','Lempäälä','Lempaeaelae',61.3167,23.75,'P','PPLA3','FI.06','FI.06.064',18096,'Europe/Helsinki',1,'2015-11-08 23:00:00','2015-11-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (648635,'FI','Lauttasaari','Lauttasaari',60.159,24.868,'P','PPLX','FI.01','FI.01.011',20000,'Europe/Helsinki',1,'2017-12-12 23:00:00','2017-12-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (648738,'FI','Laukaa','Laukaa',62.4141,25.9519,'P','PPLA3','FI.13','FI.13.131',17093,'Europe/Helsinki',1,'2015-02-28 23:00:00','2015-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (648855,'FI','Lapua','Lapua',62.9693,23.0088,'P','PPLA3','FI.14','FI.14.142',14091,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (648900,'FI','Lappeenranta','Lappeenranta',61.0587,28.1887,'P','PPLA','FI.09','FI.09.091',59276,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (648953,'FI','Lapinlahti','Lapinlahti',63.3667,27.4,'P','PPLA3','FI.11','FI.11.111',7350,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (649223,'FI','Lammi','Lammi',61.0833,25.0167,'P','PPLA3','FI.05','FI.05.051',5634,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (649302,'FI','Laitila','Laitila',60.8758,21.6977,'P','PPLA3','FI.02','FI.02.024',8403,'Europe/Helsinki',1,'2016-08-20 23:00:00','2016-08-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (649348,'FI','Laihia','Laihia',62.9761,22.0114,'P','PPLA3','FI.15','FI.15.151',7782,'Europe/Helsinki',1,'2015-04-20 23:00:00','2015-04-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (649360,'FI','Lahti','Lahti',60.9827,25.6615,'P','PPLA','FI.07','FI.07.071',98826,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (649630,'FI','Kirkkonummi','Kirkkonummi',60.1238,24.4385,'P','PPLA3','FI.01','FI.01.011',32920,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (649924,'FI','Kuusamo','Kuusamo',65.9667,29.1833,'P','PPLA3','FI.17','FI.17.178',17400,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (650095,'FI','Kurikka','Kurikka',62.6167,22.4167,'P','PPLA3','FI.14','FI.14.142',10628,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (650224,'FI','Kuopio','Kuopio',62.8924,27.677,'P','PPLA','FI.11','FI.11.112',89104,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (650705,'FI','Kuhmo','Kuhmo',64.1333,29.5167,'P','PPLA3','FI.18','FI.18.181',10214,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (650754,'FI','Kronoby','Kronoby',63.7286,23.0339,'P','PPLA3','FI.15','FI.15.154',6813,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (650769,'FI','Kristinestad','Kristinestad',62.2743,21.376,'P','PPLA3','FI.15','FI.15.153',7712,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (650859,'FI','Kouvola','Kouvola',60.8667,26.7,'P','PPLA','FI.08','FI.08.081',31133,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (650946,'FI','Kotka','Kotka',60.4664,26.9458,'P','PPLA3','FI.08','FI.08.082',54616,'Europe/Helsinki',1,'2017-03-20 23:00:00','2017-03-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (651299,'FI','Korsholm','Korsholm',63.1142,21.6822,'P','PPL','FI.15','FI.15.152',17176,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (651350,'FI','Korpilahti','Korpilahti',62.0167,25.55,'P','PPLA3','FI.13','FI.13.131',5050,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (651659,'FI','Kontiolahti','Kontiolahti',62.7602,29.8471,'P','PPLA3','FI.12','FI.12.122',12411,'Europe/Helsinki',1,'2015-03-11 23:00:00','2015-03-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (651943,'FI','Kokkola','Kokkola',63.8385,23.1307,'P','PPLA','FI.16','FI.16.162',35586,'Europe/Helsinki',1,'2014-12-28 23:00:00','2014-12-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (651980,'FI','Kokemäki','Kokemaeki',61.2565,22.3564,'P','PPLA3','FI.04','FI.04.043',8390,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (652559,'FI','Kiuruvesi','Kiuruvesi',63.65,26.6167,'P','PPLA3','FI.11','FI.11.111',9730,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (652590,'FI','Kittilä','Kittilae',67.6647,24.8936,'P','PPLA3','FI.19','FI.19.196',5713,'Europe/Helsinki',1,'2016-10-22 23:00:00','2016-10-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (652615,'FI','Kitee','Kitee',62.1,30.15,'P','PPLA3','FI.12','FI.12.124',9777,'Europe/Helsinki',1,'2015-02-28 23:00:00','2015-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (652858,'FI','Kiiminki','Kiiminki',65.1314,25.7974,'P','PPL','FI.17','FI.17.171',12069,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (652977,'FI','Keuruu','Keuruu',62.2667,24.7,'P','PPLA3','FI.13','FI.13.133',10942,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (653180,'FI','Kerimäki','Kerimaeki',61.9107,29.2823,'P','PPL','FI.10','FI.10.103',5841,'Europe/Helsinki',1,'2015-01-16 23:00:00','2015-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (653185,'FI','Kerava','Kerava',60.4034,25.105,'P','PPLA3','FI.01','FI.01.011',31347,'Europe/Helsinki',1,'2016-04-09 23:00:00','2016-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (653252,'FI','Kempele','Kempele',64.9131,25.5034,'P','PPLA3','FI.17','FI.17.171',14293,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (653272,'FI','Kemijärvi','Kemijaervi',66.6667,27.4167,'P','PPLA3','FI.19','FI.19.194',8883,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (653280,'FI','Keminmaa','Keminmaa',65.8016,24.5448,'P','PPLA3','FI.19','FI.19.192',8980,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (653281,'FI','Kemi','Kemi',65.7364,24.5637,'P','PPLA3','FI.19','FI.19.192',22641,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (653559,'FI','Kauniainen','Kauniainen',60.2121,24.7276,'P','PPLA3','FI.01','FI.01.011',8688,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (653616,'FI','Kauhava','Kauhava',63.103,23.0713,'P','PPLA3','FI.14','FI.14.142',7896,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (653627,'FI','Kauhajoki','Kauhajoki',62.4333,22.1833,'P','PPLA3','FI.14','FI.14.141',14526,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (653960,'FI','Karkkila','Karkkila',60.5342,24.2098,'P','PPLA3','FI.01','FI.01.011',8811,'Europe/Helsinki',1,'2015-05-13 23:00:00','2015-05-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (654047,'FI','Karis','Karis',60.0718,23.6616,'P','PPL','FI.01','FI.01.014',8853,'Europe/Helsinki',1,'2016-10-13 23:00:00','2016-10-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (654137,'FI','Karhula','Karhula',60.5216,26.9312,'P','PPL','FI.08','FI.08.082',22867,'Europe/Helsinki',1,'2015-01-16 23:00:00','2015-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (654314,'FI','Kannus','Kannus',63.9,23.9,'P','PPLA3','FI.16','FI.16.162',5968,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (654363,'FI','Kankaanpää','Kankaanpaeae',61.8,22.4167,'P','PPLA3','FI.04','FI.04.044',12381,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (654405,'FI','Kangasniemi','Kangasniemi',61.9936,26.6479,'P','PPLA3','FI.10','FI.10.101',6211,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (654440,'FI','Kangasala','Kangasala',61.4638,24.076,'P','PPLA3','FI.06','FI.06.064',24291,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (654706,'FI','Kallio','Kallio',60.1843,24.9503,'P','PPLX','FI.01','FI.01.011',27051,'Europe/Helsinki',1,'2017-12-12 23:00:00','2017-12-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (654837,'FI','Kalajoki','Kalajoki',64.25,23.95,'P','PPLA3','FI.17','FI.17.177',8869,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (654899,'FI','Kajaani','Kajaani',64.2273,27.7285,'P','PPLA','FI.18','FI.18.182',35375,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (655130,'FI','Kaarina','Kaarina',60.4072,22.369,'P','PPLA3','FI.02','FI.02.023',21684,'Europe/Helsinki',1,'2015-05-13 23:00:00','2015-05-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (655143,'FI','Kaarela','Kaarela',60.2517,24.8811,'P','PPL','FI.01','FI.01.011',26414,'Europe/Helsinki',1,'2017-12-13 23:00:00','2017-12-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (655194,'FI','Jyväskylä','Jyvaeskylae',62.2415,25.7209,'P','PPLA','FI.13','FI.13.131',85026,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (655253,'FI','Juva','Juva',61.9,27.85,'P','PPLA3','FI.10','FI.10.105',7165,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (655312,'FI','Juuka','Juuka',63.2333,29.25,'P','PPLA3','FI.12','FI.12.122',6035,'Europe/Helsinki',1,'2015-02-28 23:00:00','2015-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (655533,'FI','Juankoski','Juankoski',63.0667,28.35,'P','PPL','FI.11','FI.11.112',5514,'Europe/Helsinki',1,'2017-01-03 23:00:00','2017-01-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (655563,'FI','Joutseno','Joutseno',61.118,28.5076,'P','PPL','FI.09','FI.09.091',10603,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (655626,'FI','Joroinen','Joroinen',62.1782,27.8316,'P','PPLA3','FI.10','FI.10.105',5536,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (655692,'FI','Jokioinen','Jokioinen',60.8016,23.48,'P','PPLA3','FI.05','FI.05.053',5568,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (655808,'FI','Joensuu','Joensuu',62.6012,29.7632,'P','PPLA','FI.12','FI.12.122',53388,'Europe/Helsinki',1,'2016-11-22 23:00:00','2016-11-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (655958,'FI','Järvenpää','Jaervenpaeae',60.4737,25.0899,'P','PPLA3','FI.01','FI.01.011',38148,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (656073,'FI','Janakkala','Janakkala',60.9,24.6,'P','PPLA3','FI.05','FI.05.051',15698,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (656076,'FI','Jämsänkoski','Jaemsaenkoski',61.919,25.1701,'P','PPLA3','FI.13','FI.13.134',7442,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (656083,'FI','Jämsä','Jaemsae',61.8642,25.19,'P','PPLA3','FI.13','FI.13.134',15261,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (656117,'FI','Jalasjärvi','Jalasjaervi',62.5,22.75,'P','PPL','FI.14','FI.14.142',8662,'Europe/Helsinki',1,'2016-02-02 23:00:00','2016-02-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (656130,'FI','Jakobstad','Jakobstad',63.6749,22.7026,'P','PPLA3','FI.15','FI.15.154',19238,'Europe/Helsinki',1,'2018-01-10 23:00:00','2018-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (656456,'FI','Isokyrö','Isokyroe',63.0117,22.3333,'P','PPLA3','FI.15','FI.15.151',5040,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (656652,'FI','Ingå','Inga',60.0459,24.0046,'P','PPLA3','FI.01','FI.01.014',5205,'Europe/Helsinki',1,'2016-06-04 23:00:00','2016-06-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (656657,'FI','Inari','Inari',68.906,27.0288,'P','PPLA3','FI.19','FI.19.197',7049,'Europe/Helsinki',1,'2016-12-12 23:00:00','2016-12-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (656688,'FI','Imatra','Imatra',61.1718,28.7524,'P','PPLA3','FI.09','FI.09.093',29615,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (656709,'FI','Ilomantsi','Ilomantsi',62.6716,30.9328,'P','PPLA3','FI.12','FI.12.122',6408,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (656739,'FI','Ilmajoki','Ilmajoki',62.7333,22.5667,'P','PPLA3','FI.14','FI.14.142',11693,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (656789,'FI','Ikaalinen','Ikaalinen',61.7695,23.0658,'P','PPLA3','FI.06','FI.06.061',7309,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (656807,'FI','Iitti','Iitti',60.8949,26.3387,'P','PPLA3','FI.08','FI.08.081',7246,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (656820,'FI','Iisalmi','Iisalmi',63.5592,27.1907,'P','PPLA3','FI.11','FI.11.111',22588,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (656851,'FI','Ii','Ii',65.3174,25.3731,'P','PPLA3','FI.17','FI.17.173',6546,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (656913,'FI','Hyvinge','Hyvinge',60.6333,24.8667,'P','PPLA3','FI.01','FI.01.011',43515,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (657180,'FI','Huittinen','Huittinen',61.1833,22.7,'P','PPLA3','FI.04','FI.04.043',8952,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (657530,'FI','Hollola','Hollola',61.05,25.4333,'P','PPLA3','FI.07','FI.07.071',20405,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (658225,'FI','Helsinki','Helsinki',60.1695,24.9354,'P','PPLC','FI.01','FI.01.011',558457,'Europe/Helsinki',1,'2017-06-13 23:00:00','2017-06-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (658288,'FI','Heinola','Heinola',61.2056,26.0381,'P','PPLA3','FI.07','FI.07.071',20849,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (658581,'FI','Hausjärvi','Hausjaervi',60.7833,24.9333,'P','PPLA3','FI.05','FI.05.052',8151,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (658629,'FI','Haukipudas','Haukipudas',65.1765,25.3523,'P','PPL','FI.17','FI.17.171',17298,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (658921,'FI','Harjavalta','Harjavalta',61.3167,22.1333,'P','PPLA3','FI.04','FI.04.043',7572,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (659024,'FI','Hankasalmi','Hankasalmi',62.3833,26.4333,'P','PPLA3','FI.13','FI.13.131',5372,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (659101,'FI','Hanko','Hanko',59.8333,22.95,'P','PPLA3','FI.01','FI.01.014',9962,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (659169,'FI','Hamina','Hamina',60.5697,27.1979,'P','PPLA3','FI.08','FI.08.082',21712,'Europe/Helsinki',1,'2015-11-22 23:00:00','2015-11-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (659180,'FI','Hämeenlinna','Haemeenlinna',60.996,24.4643,'P','PPLA','FI.05','FI.05.051',47261,'Europe/Helsinki',1,'2017-01-25 23:00:00','2017-01-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (659184,'FI','Hämeenkyrö','Haemeenkyroe',61.6391,23.1953,'P','PPLA3','FI.06','FI.06.064',9996,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (659350,'FI','Halikko','Halikko',60.4,23.0833,'P','PPLA3','FI.02','FI.02.022',9344,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (659554,'FI','Haapavesi','Haapavesi',64.1333,25.3667,'P','PPLA3','FI.17','FI.17.175',7717,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (659681,'FI','Haapajärvi','Haapajaervi',63.75,25.3333,'P','PPLA3','FI.17','FI.17.176',7627,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (659935,'FI','Forssa','Forssa',60.8146,23.6215,'P','PPLA3','FI.05','FI.05.053',17852,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (660073,'FI','Eurajoki','Eurajoki',61.2,21.7333,'P','PPLA3','FI.04','FI.04.041',5656,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (660077,'FI','Eura','Eura',61.1333,22.1333,'P','PPLA3','FI.04','FI.04.041',9338,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (660158,'FI','Espoo','Espoo',60.2052,24.6522,'P','PPLA3','FI.01','FI.01.011',256760,'Europe/Helsinki',1,'2016-06-10 23:00:00','2016-06-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (660242,'FI','Eno','Eno',62.8051,30.1542,'P','PPL','FI.12','FI.12.122',6891,'Europe/Helsinki',1,'2015-01-16 23:00:00','2015-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (660294,'FI','Elimäki','Elimaeki',60.7167,26.4667,'P','PPLA3','FI.08','FI.08.081',8751,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (660325,'FI','Ekenäs','Ekenaes',59.9736,23.4339,'P','PPLA3','FI.01','FI.01.014',14377,'Europe/Helsinki',1,'2016-06-04 23:00:00','2016-06-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (660561,'FI','Porvoo','Porvoo',60.3923,25.6651,'P','PPLA3','FI.01','FI.01.015',47192,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (660949,'FI','Asikkala','Asikkala',61.2167,25.5,'P','PPLA3','FI.07','FI.07.071',8540,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (661164,'FI','Anjala','Anjala',60.6833,26.8333,'P','PPL','FI.08','FI.08.081',16779,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (661352,'FI','Alavus','Alavus',62.5833,23.6167,'P','PPLA3','FI.14','FI.14.144',9422,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (661576,'FI','Alajärvi','Alajaervi',63,23.8167,'P','PPLA3','FI.14','FI.14.146',8793,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (661896,'FI','Ähtäri','AEhtaeri',62.554,24.0619,'P','PPLA3','FI.14','FI.14.144',6835,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (662095,'FI','Äänekoski','AEaenekoski',62.6,25.7333,'P','PPLA3','FI.13','FI.13.135',13406,'Europe/Helsinki',1,'2014-09-24 23:00:00','2014-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7910855,'FI','Toijala','Toijala',61.1678,23.8382,'P','PPLX','FI.06','FI.06.063',8300,'Europe/Helsinki',1,'2015-02-13 23:00:00','2015-02-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7911309,'FI','Länsi-Turunmaa','Laensi-Turunmaa',60.2997,22.3004,'P','PPL','FI.02','FI.02.021',15498,'Europe/Helsinki',1,'2015-11-22 23:00:00','2015-11-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (11593510,'FI','Älajärvi','AElajaervi',63.0003,23.8159,'P','PPLL','FI.14','FI.14.146',10308,'Europe/Helsinki',1,'2017-06-21 23:00:00','2017-06-21 23:00:00');


