INSERT INTO `<<prefix>>cities` VALUES (2925630,'DE','Frankenberg','Frankenberg',50.913,13.0401,'P','PPL','DE.13','DE.13.00',16850,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2925832,'DE','Forst','Forst',51.7354,14.6397,'P','PPLA3','DE.11','DE.11.00',22843,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2925848,'DE','Forst','Forst',49.1586,8.58083,'P','PPLA4','DE.01','DE.01.082',7539,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2925905,'DE','Forchtenberg','Forchtenberg',49.2887,9.56026,'P','PPL','DE.01','DE.01.081',5105,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2925910,'DE','Forchheim','Forchheim',49.7175,11.0588,'P','PPLA3','DE.02','DE.02.094',30442,'Europe/Berlin',1,'2014-01-08 23:00:00','2014-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2925924,'DE','Forbach','Forbach',48.6833,8.35,'P','PPLA4','DE.01','DE.01.082',5477,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2926017,'DE','Fockbek','Fockbek',54.3,9.6,'P','PPLA4','DE.10','DE.10.00',6380,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2926120,'DE','Flörsheim','Floersheim',50.0131,8.42779,'P','PPL','DE.05','DE.05.064',20023,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2926147,'DE','Flöha','Floeha',50.8561,13.0741,'P','PPL','DE.13','DE.13.00',11143,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2926178,'DE','Flintbek','Flintbek',54.25,10.0667,'P','PPLA4','DE.10','DE.10.00',7276,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2926226,'DE','Flieden','Flieden',50.4239,9.5666,'P','PPLA4','DE.05','DE.05.066',8843,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2926271,'DE','Flensburg','Flensburg',54.7843,9.43961,'P','PPLA3','DE.10','DE.10.00',85838,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2926304,'DE','Flein','Flein',49.1031,9.21083,'P','PPLA4','DE.01','DE.01.081',6558,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2926586,'DE','Fischbachau','Fischbachau',47.7195,11.9508,'P','PPLA4','DE.02','DE.02.091',5471,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2926670,'DE','Finsterwalde','Finsterwalde',51.6339,13.7066,'P','PPL','DE.11','DE.11.00',18922,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2926716,'DE','Finnentrop','Finnentrop',51.168,7.973,'P','PPLA4','DE.07','DE.07.059',18427,'Europe/Berlin',1,'2015-09-05 23:00:00','2015-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2927043,'DE','Stuttgart Feuerbach','Stuttgart Feuerbach',48.8087,9.15719,'P','PPLX','DE.01','DE.01.081',28046,'Europe/Berlin',1,'2018-01-14 23:00:00','2018-01-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2927048,'DE','Feuchtwangen','Feuchtwangen',49.1629,10.3385,'P','PPL','DE.02','DE.02.095',12267,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2927054,'DE','Feucht','Feucht',49.376,11.2143,'P','PPL','DE.02','DE.02.095',13482,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2927226,'DE','Felsberg','Felsberg',51.1376,9.42139,'P','PPL','DE.05','DE.05.066',11219,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2927268,'DE','Fellbach','Fellbach',48.8091,9.27697,'P','PPL','DE.01','DE.01.081',43935,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2927339,'DE','Feldkirchen-Westerham','Feldkirchen-Westerham',47.9075,11.8427,'P','PPLA4','DE.02','DE.02.091',10399,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2927347,'DE','Feldkirchen','Feldkirchen',48.1481,11.731,'P','PPLA4','DE.02','DE.02.091',5573,'Europe/Berlin',1,'2017-09-19 23:00:00','2017-09-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2927564,'DE','Fehrbellin','Fehrbellin',52.8135,12.7644,'P','PPLA4','DE.11','DE.11.00',9413,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2927750,'DE','Faßberg','Fassberg',52.9,10.1667,'P','PPLA4','DE.06','DE.06.00',7299,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2927871,'DE','Bad Fallingbostel','Bad Fallingbostel',52.8664,9.69558,'P','PPLA3','DE.06','DE.06.00',13473,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2927913,'DE','Falkenstein','Falkenstein',50.4779,12.3713,'P','PPL','DE.13','DE.13.00',9528,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2927930,'DE','Falkensee','Falkensee',52.5601,13.0927,'P','PPL','DE.11','DE.11.00',37468,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928011,'DE','Falkenberg','Falkenberg',51.5856,13.2435,'P','PPL','DE.11','DE.11.00',7830,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928320,'DE','Everswinkel','Everswinkel',51.9259,7.8469,'P','PPLA4','DE.07','DE.07.055',9576,'Europe/Berlin',1,'2013-05-16 23:00:00','2013-05-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928379,'DE','Eutingen','Eutingen',48.9125,8.74898,'P','PPL','DE.01','DE.01.082',5583,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928381,'DE','Eutin','Eutin',54.1405,10.6075,'P','PPLA3','DE.10','DE.10.00',16984,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928396,'DE','Euskirchen','Euskirchen',50.6606,6.78722,'P','PPLA3','DE.07','DE.07.053',54889,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928615,'DE','Ettlingen','Ettlingen',48.9409,8.40763,'P','PPL','DE.01','DE.01.082',38942,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928659,'DE','Ettenheim','Ettenheim',48.257,7.81247,'P','PPL','DE.01','DE.01.083',11995,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928717,'DE','Esterwegen','Esterwegen',52.9929,7.63327,'P','PPLA4','DE.06','DE.06.00',5208,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928751,'DE','Esslingen','Esslingen',48.7396,9.30473,'P','PPLA3','DE.01','DE.01.081',92390,'Europe/Berlin',1,'2017-09-21 23:00:00','2017-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928761,'DE','Essingen','Essingen',48.8086,10.0277,'P','PPLA4','DE.01','DE.01.081',6383,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928804,'DE','Essenbach','Essenbach',48.6133,12.2183,'P','PPL','DE.02','DE.02.092',11070,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928809,'DE','Essen','Essen',52.7226,7.9371,'P','PPL','DE.06','DE.06.00',8185,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928810,'DE','Essen','Essen',51.4566,7.01228,'P','PPLA3','DE.07','DE.07.051',593085,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928874,'DE','Espelkamp','Espelkamp',52.3825,8.62127,'P','PPL','DE.07','DE.07.057',26378,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928890,'DE','Eslohe','Eslohe',51.2537,8.16949,'P','PPL','DE.07','DE.07.059',9304,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928911,'DE','Esens','Esens',53.6487,7.61267,'P','PPL','DE.06','DE.06.00',6856,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928963,'DE','Eschweiler','Eschweiler',50.8185,6.27184,'P','PPL','DE.07','DE.07.053',55778,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2928967,'DE','Eschwege','Eschwege',51.1839,10.0533,'P','PPLA3','DE.05','DE.05.066',21191,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929134,'DE','Eschborn','Eschborn',50.1433,8.57111,'P','PPL','DE.05','DE.05.064',20383,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929224,'DE','Erzhausen','Erzhausen',49.9553,8.6475,'P','PPLA4','DE.05','DE.05.064',7297,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929247,'DE','Erwitte','Erwitte',51.6127,8.3384,'P','PPL','DE.07','DE.07.059',16081,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929252,'DE','Ertingen','Ertingen',48.1,9.46667,'P','PPLA4','DE.01','DE.01.084',5516,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929370,'DE','Erndtebrück','Erndtebrueck',50.9893,8.25288,'P','PPLA4','DE.07','DE.07.059',7685,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929451,'DE','Erlensee','Erlensee',50.163,8.97823,'P','PPLA4','DE.05','DE.05.064',12663,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929484,'DE','Erlenbach am Main','Erlenbach am Main',49.8034,9.16311,'P','PPL','DE.02','DE.02.096',10208,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929567,'DE','Erlangen','Erlangen',49.591,11.0078,'P','PPLA3','DE.02','DE.02.095',102675,'Europe/Berlin',1,'2014-01-08 23:00:00','2014-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929600,'DE','Erkrath','Erkrath',51.2224,6.90831,'P','PPL','DE.07','DE.07.051',47815,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929602,'DE','Erkner','Erkner',52.42,13.7544,'P','PPL','DE.11','DE.11.00',11741,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929622,'DE','Erkelenz','Erkelenz',51.0795,6.31531,'P','PPL','DE.07','DE.07.053',44650,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929649,'DE','Ergoldsbach','Ergoldsbach',48.6926,12.2044,'P','PPL','DE.02','DE.02.092',7482,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929650,'DE','Ergolding','Ergolding',48.5765,12.171,'P','PPL','DE.02','DE.02.092',11438,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929670,'DE','Erfurt','Erfurt',50.9787,11.0328,'P','PPLA','DE.15','DE.15.00',203254,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929671,'DE','Erftstadt','Erftstadt',50.8148,6.79387,'P','PPL','DE.07','DE.07.053',51207,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929692,'DE','Erdweg','Erdweg',48.3318,11.3034,'P','PPLA4','DE.02','DE.02.091',5629,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929715,'DE','Erding','Erding',48.306,11.9069,'P','PPLA3','DE.02','DE.02.091',33519,'Europe/Berlin',1,'2017-12-27 23:00:00','2017-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929783,'DE','Erbendorf','Erbendorf',49.8398,12.0459,'P','PPL','DE.02','DE.02.093',5364,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929802,'DE','Erbach','Erbach',49.6615,8.99402,'P','PPLA3','DE.05','DE.05.064',13771,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929804,'DE','Erbach','Erbach',48.3284,9.88752,'P','PPL','DE.01','DE.01.084',13331,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929817,'DE','Eppstein','Eppstein',50.1428,8.39231,'P','PPL','DE.05','DE.05.064',13374,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929831,'DE','Eppingen','Eppingen',49.1365,8.91229,'P','PPL','DE.01','DE.01.081',21179,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929837,'DE','Eppertshausen','Eppertshausen',49.9506,8.85389,'P','PPLA4','DE.05','DE.05.064',5838,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929863,'DE','Eppelheim','Eppelheim',49.4019,8.63644,'P','PPL','DE.01','DE.01.082',14190,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2929865,'DE','Eppelborn','Eppelborn',49.4,6.96667,'P','PPLA4','DE.09','DE.09.00',18079,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930019,'DE','Ensdorf','Ensdorf',49.3,6.78333,'P','PPLA4','DE.09','DE.09.00',6631,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930030,'DE','Ennigerloh','Ennigerloh',51.8384,8.03093,'P','PPL','DE.07','DE.07.055',20713,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930043,'DE','Ennepetal','Ennepetal',51.2985,7.3629,'P','PPL','DE.07','DE.07.059',32607,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930071,'DE','Enkenbach-Alsenborn','Enkenbach-Alsenborn',49.4833,7.9,'P','PPLA4','DE.08','DE.08.00',7189,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930080,'DE','Eningen unter Achalm','Eningen unter Achalm',48.4869,9.25946,'P','PPLA4','DE.01','DE.01.084',10715,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930182,'DE','Enger','Enger',52.1406,8.55772,'P','PPL','DE.07','DE.07.057',19852,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930201,'DE','Engen','Engen',47.8553,8.77342,'P','PPL','DE.01','DE.01.083',10190,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930216,'DE','Engelskirchen','Engelskirchen',50.9885,7.41391,'P','PPLA4','DE.07','DE.07.053',20786,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930367,'DE','Bad Endorf','Bad Endorf',47.909,12.2979,'P','PPL','DE.02','DE.02.091',7465,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930383,'DE','Endingen','Endingen',48.1422,7.70049,'P','PPL','DE.01','DE.01.083',9034,'Europe/Berlin',1,'2017-09-21 23:00:00','2017-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930408,'DE','Bad Endbach','Bad Endbach',50.75,8.5,'P','PPLA4','DE.05','DE.05.065',8734,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930426,'DE','Emstek','Emstek',52.8333,8.15,'P','PPLA4','DE.06','DE.06.00',11257,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930432,'DE','Emskirchen','Emskirchen',49.5528,10.7128,'P','PPL','DE.02','DE.02.095',6197,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930449,'DE','Emsdetten','Emsdetten',52.1734,7.52781,'P','PPL','DE.07','DE.07.055',35582,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930454,'DE','Emsbüren','Emsburen',52.4,7.3,'P','PPLA4','DE.06','DE.06.00',9623,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930500,'DE','Emmering','Emmering',48.1833,11.2833,'P','PPLA4','DE.02','DE.02.091',6081,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930509,'DE','Emmerich','Emmerich',51.8393,6.24792,'P','PPL','DE.07','DE.07.051',29289,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930523,'DE','Emmendingen','Emmendingen',48.121,7.85359,'P','PPLA3','DE.01','DE.01.083',27383,'Europe/Berlin',1,'2017-01-08 23:00:00','2017-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930546,'DE','Emlichheim','Emlichheim',52.6167,6.85,'P','PPLA4','DE.06','DE.06.00',6820,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930596,'DE','Emden','Emden',53.3675,7.20778,'P','PPLA3','DE.06','DE.06.00',51526,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930623,'DE','Elze','Elze',52.1226,9.73595,'P','PPLA4','DE.06','DE.06.00',9582,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930626,'DE','Elzach','Elzach',48.1725,8.06992,'P','PPL','DE.01','DE.01.083',7088,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930628,'DE','Elz','Elz',50.4167,8.03333,'P','PPLA4','DE.05','DE.05.065',7972,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930646,'DE','Eltville','Eltville',50.0286,8.11754,'P','PPL','DE.05','DE.05.064',16845,'Europe/Berlin',1,'2017-09-19 23:00:00','2017-09-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930650,'DE','Eltmann','Eltmann',49.9715,10.6671,'P','PPL','DE.02','DE.02.096',5614,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930680,'DE','Elsterwerda','Elsterwerda',51.4604,13.52,'P','PPL','DE.11','DE.11.00',9694,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930687,'DE','Elsterberg','Elsterberg',50.6084,12.1679,'P','PPL','DE.13','DE.13.00',5153,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930726,'DE','Elsfleth','Elsfleth',53.2375,8.45664,'P','PPL','DE.06','DE.06.00',9310,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930747,'DE','Elsenfeld','Elsenfeld',49.8429,9.16355,'P','PPL','DE.02','DE.02.096',8727,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930778,'DE','Elsdorf','Elsdorf',50.9374,6.56828,'P','PPLA4','DE.07','DE.07.053',21967,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930821,'DE','Elmshorn','Elmshorn',53.754,9.65339,'P','PPL','DE.10','DE.10.00',48703,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930889,'DE','Ellwangen','Ellwangen',48.9616,10.1317,'P','PPL','DE.01','DE.01.081',25276,'Europe/Berlin',1,'2017-09-21 23:00:00','2017-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2930900,'DE','Ellrich','Ellrich',51.5866,10.6633,'P','PPL','DE.15','DE.15.00',6423,'Europe/Berlin',1,'2016-11-30 23:00:00','2016-11-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2931038,'DE','Ellerau','Ellerau',53.75,9.91667,'P','PPLA4','DE.10','DE.10.00',5500,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2931361,'DE','Eitorf','Eitorf',50.7667,7.45,'P','PPLA4','DE.07','DE.07.053',19761,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2931372,'DE','Eiterfeld','Eiterfeld',50.7667,9.8,'P','PPLA4','DE.05','DE.05.066',7613,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2931414,'DE','Eislingen','Eislingen',48.6951,9.70676,'P','PPL','DE.01','DE.01.081',20585,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2931433,'DE','Eisfeld','Eisfeld',50.4265,10.9069,'P','PPL','DE.15','DE.15.00',5855,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2931481,'DE','Eisenhüttenstadt','Eisenhuettenstadt',52.15,14.65,'P','PPLA4','DE.11','DE.11.00',32052,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2931521,'DE','Eisenberg','Eisenberg',50.9686,11.9021,'P','PPLA3','DE.15','DE.15.00',11438,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2931522,'DE','Eisenberg','Eisenberg',49.5586,8.07199,'P','PPL','DE.08','DE.08.00',10006,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2931574,'DE','Eisenach','Eisenach',50.9807,10.3152,'P','PPL','DE.15','DE.15.00',43846,'Europe/Berlin',1,'2017-10-23 23:00:00','2017-10-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2931753,'DE','Einhausen','Einhausen',49.6767,8.54833,'P','PPLA4','DE.05','DE.05.064',5933,'Europe/Berlin',1,'2014-09-20 23:00:00','2014-09-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2931804,'DE','Einbeck','Einbeck',51.8202,9.86961,'P','PPL','DE.06','DE.06.00',27931,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2931871,'DE','Eilenburg','Eilenburg',51.4598,12.6334,'P','PPL','DE.13','DE.13.00',17609,'Europe/Berlin',1,'2014-01-01 23:00:00','2014-01-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2931881,'DE','Eil','Eil',50.8936,7.07967,'P','PPL','DE.07','DE.07.053',8849,'Europe/Berlin',1,'2013-03-05 23:00:00','2013-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2932040,'DE','Eichwalde','Eichwalde',52.3667,13.6167,'P','PPLA4','DE.11','DE.11.00',5849,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2932069,'DE','Eichstätt','Eichstaett',48.8885,11.1967,'P','PPLA3','DE.02','DE.02.091',13125,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2932266,'DE','Eichenzell','Eichenzell',50.4954,9.69672,'P','PPLA4','DE.05','DE.05.066',11042,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2932321,'DE','Eichendorf','Eichendorf',48.6327,12.8559,'P','PPL','DE.02','DE.02.092',6617,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2932382,'DE','Eichenau','Eichenau',48.1667,11.3167,'P','PPLA4','DE.02','DE.02.091',11637,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2932738,'DE','Eibenstock','Eibenstock',50.4943,12.5998,'P','PPL','DE.13','DE.13.00',6706,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2932756,'DE','Eibau','Eibau',50.9827,14.6621,'P','PPL','DE.13','DE.13.00',5103,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2932788,'DE','Ehringshausen','Ehringshausen',50.6,8.38333,'P','PPLA4','DE.05','DE.05.065',9505,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2932828,'DE','Ehrenfriedersdorf','Ehrenfriedersdorf',50.6493,12.9701,'P','PPL','DE.13','DE.13.00',5360,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2932882,'DE','Ehningen','Ehningen',48.6588,8.94124,'P','PPLA4','DE.01','DE.01.081',7652,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2932924,'DE','Ehingen','Ehingen',48.2826,9.72749,'P','PPL','DE.01','DE.01.084',26097,'Europe/Berlin',1,'2017-09-21 23:00:00','2017-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2932992,'DE','Egling','Egling',47.9232,11.5052,'P','PPLA4','DE.02','DE.02.091',5061,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933019,'DE','Eggolsheim','Eggolsheim',49.7696,11.057,'P','PPL','DE.02','DE.02.094',6313,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933042,'DE','Eggesin','Eggesin',53.6797,14.0799,'P','PPL','DE.12','DE.12.00',5598,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933101,'DE','Eggenstein-Leopoldshafen','Eggenstein-Leopoldshafen',49.0901,8.39879,'P','PPLA4','DE.01','DE.01.082',15189,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933115,'DE','Eggenfelden','Eggenfelden',48.4051,12.7575,'P','PPL','DE.02','DE.02.092',12860,'Europe/Berlin',1,'2013-11-22 23:00:00','2013-11-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933188,'DE','Egestorf','Egestorf',52.2857,9.51676,'P','PPL','DE.06','DE.06.00',7959,'Europe/Berlin',1,'2012-08-03 23:00:00','2012-08-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933246,'DE','Egelsbach','Egelsbach',49.9679,8.66341,'P','PPLA4','DE.05','DE.05.064',9645,'Europe/Berlin',1,'2016-12-12 23:00:00','2016-12-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933274,'DE','Efringen-Kirchen','Efringen-Kirchen',47.65,7.56667,'P','PPLA4','DE.01','DE.01.083',8235,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933345,'DE','Edingen-Neckarhausen','Edingen-Neckarhausen',49.4572,8.60639,'P','PPLA4','DE.01','DE.01.082',14009,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933364,'DE','Edewecht','Edewecht',53.127,7.98406,'P','PPL','DE.06','DE.06.00',20658,'Europe/Berlin',1,'2017-09-18 23:00:00','2017-09-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933410,'DE','Edenkoben','Edenkoben',49.2839,8.12714,'P','PPL','DE.08','DE.08.00',6668,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933607,'DE','Eckersdorf','Eckersdorf',50.0287,11.3961,'P','PPL','DE.02','DE.02.094',5071,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933627,'DE','Eckernförde','Eckernfoerde',54.4685,9.83824,'P','PPL','DE.10','DE.10.00',23383,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933772,'DE','Echzell','Echzell',50.3889,8.88605,'P','PPLA4','DE.05','DE.05.064',5951,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933799,'DE','Eching','Eching',48.3,11.6167,'P','PPLA4','DE.02','DE.02.091',12804,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933817,'DE','Ebstorf','Ebstorf',53.0279,10.4184,'P','PPL','DE.06','DE.06.00',5471,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933882,'DE','Eberswalde','Eberswalde',52.8349,13.8195,'P','PPLA3','DE.11','DE.11.00',41980,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933922,'DE','Ebersdorf','Ebersdorf',50.329,11.1527,'P','PPL','DE.02','DE.02.094',6378,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933945,'DE','Ebersberg','Ebersberg',48.0771,11.9706,'P','PPLA3','DE.02','DE.02.091',11041,'Europe/Berlin',1,'2014-01-08 23:00:00','2014-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933959,'DE','Ebersbach an der Fils','Ebersbach an der Fils',48.716,9.5236,'P','PPL','DE.01','DE.01.081',15919,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933965,'DE','Ebersbach','Ebersbach',51.0076,14.5862,'P','PPL','DE.13','DE.13.00',8952,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2933986,'DE','Ebermannstadt','Ebermannstadt',49.7815,11.1817,'P','PPL','DE.02','DE.02.094',6864,'Europe/Berlin',1,'2013-11-02 23:00:00','2013-11-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2934014,'DE','Eberdingen','Eberdingen',48.8794,8.96502,'P','PPLA4','DE.01','DE.01.081',6518,'Europe/Berlin',1,'2015-10-20 23:00:00','2015-10-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2934020,'DE','Eberbach','Eberbach',49.4668,8.99016,'P','PPL','DE.01','DE.01.082',15624,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2934033,'DE','Ebensfeld','Ebensfeld',50.0664,10.9584,'P','PPL','DE.02','DE.02.094',5721,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2934163,'DE','Duvenstedt','Duvenstedt',53.7081,10.1044,'P','PPL','DE.04','DE.04.00',6022,'Europe/Berlin',1,'2017-10-12 23:00:00','2017-10-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2934235,'DE','Dußlingen','Dusslingen',48.4536,9.05552,'P','PPLA4','DE.01','DE.01.084',5286,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2934246,'DE','Düsseldorf','Duesseldorf',51.2217,6.77616,'P','PPLA','DE.07','DE.07.051',573057,'Europe/Berlin',1,'2016-07-04 23:00:00','2016-07-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2934462,'DE','Durmersheim','Durmersheim',48.9333,8.26667,'P','PPLA4','DE.01','DE.01.082',11675,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2934486,'DE','Düren','Dueren',50.8043,6.49299,'P','PPLA3','DE.07','DE.07.053',93440,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2934509,'DE','Durach','Durach',47.6944,10.3445,'P','PPLA4','DE.02','DE.02.097',6675,'Europe/Berlin',1,'2013-02-17 23:00:00','2013-02-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2934560,'DE','Dunningen','Dunningen',48.2124,8.50619,'P','PPLA4','DE.01','DE.01.083',6032,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2934662,'DE','Dülmen','Duelmen',51.8315,7.28075,'P','PPL','DE.07','DE.07.055',47495,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2934691,'DE','Duisburg','Duisburg',51.4325,6.76516,'P','PPLA3','DE.07','DE.07.051',504358,'Europe/Berlin',1,'2017-09-19 23:00:00','2017-09-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2934728,'DE','Duderstadt','Duderstadt',51.5131,10.2595,'P','PPL','DE.06','DE.06.00',22910,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2934737,'DE','Dudenhofen','Dudenhofen',49.3186,8.38861,'P','PPLA4','DE.08','DE.08.00',5709,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2934886,'DE','Drolshagen','Drolshagen',51.0236,7.77355,'P','PPL','DE.07','DE.07.059',12310,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2934915,'DE','Drochtersen','Drochtersen',53.7102,9.38463,'P','PPLA4','DE.06','DE.06.00',12364,'Europe/Berlin',1,'2011-08-25 23:00:00','2011-08-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2934965,'DE','Driedorf','Driedorf',50.6333,8.18333,'P','PPLA4','DE.05','DE.05.065',5213,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2935022,'DE','Dresden','Dresden',51.0509,13.7383,'P','PPLA','DE.13','DE.13.00',486854,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2935042,'DE','Drensteinfurt','Drensteinfurt',51.7953,7.73815,'P','PPL','DE.07','DE.07.055',15260,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2935220,'DE','Dreieich','Dreieich',50.02,8.69611,'P','PPL','DE.05','DE.05.064',40367,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2935298,'DE','Drebkau','Drebkau',51.6541,14.2232,'P','PPL','DE.11','DE.11.00',6336,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2935441,'DE','Dötlingen','Dotlingen',52.9333,8.38333,'P','PPLA4','DE.06','DE.06.00',6122,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2935453,'DE','Dossenheim','Dossenheim',49.4503,8.67472,'P','PPLA4','DE.01','DE.01.082',11612,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2935491,'DE','Dörverden','Dorverden',52.85,9.23333,'P','PPLA4','DE.06','DE.06.00',9710,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2935517,'DE','Dortmund','Dortmund',51.5149,7.466,'P','PPLA3','DE.07','DE.07.059',588462,'Europe/Berlin',1,'2016-03-16 23:00:00','2016-03-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2935530,'DE','Dorsten','Dorsten',51.6617,6.96514,'P','PPL','DE.07','DE.07.055',79981,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2935642,'DE','Dornstetten','Dornstetten',48.472,8.49817,'P','PPL','DE.01','DE.01.082',8215,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2935647,'DE','Dornstadt','Dornstadt',48.467,9.94434,'P','PPLA4','DE.01','DE.01.084',8502,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2935702,'DE','Dornhan','Dornhan',48.3501,8.50901,'P','PPL','DE.01','DE.01.083',6157,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2935825,'DE','Dormagen','Dormagen',51.0968,6.83167,'P','PPL','DE.07','DE.07.051',63582,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936103,'DE','Dorfen','Dorfen',48.2704,12.1606,'P','PPL','DE.02','DE.02.091',13487,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936153,'DE','Dörentrup','Dorentrup',52.0411,9.00278,'P','PPLA4','DE.07','DE.07.057',8713,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936186,'DE','Donzdorf','Donzdorf',48.6854,9.81053,'P','PPL','DE.01','DE.01.081',11051,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936253,'DE','Donauwörth','Donauwoerth',48.718,10.7793,'P','PPLA3','DE.02','DE.02.097',18364,'Europe/Berlin',1,'2014-01-08 23:00:00','2014-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936267,'DE','Donaueschingen','Donaueschingen',47.9551,8.49707,'P','PPL','DE.01','DE.01.083',21604,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936470,'DE','Dohna','Dohna',50.9562,13.8584,'P','PPL','DE.13','DE.13.00',6140,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936631,'DE','Doberlug-Kirchhain','Doberlug-Kirchhain',51.6258,13.5623,'P','PPL','DE.11','DE.11.00',10151,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936658,'DE','Döbeln','Doebeln',51.1221,13.1103,'P','PPL','DE.13','DE.13.00',21338,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936705,'DE','Ditzingen','Ditzingen',48.8267,9.06703,'P','PPL','DE.01','DE.01.081',24149,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936759,'DE','Dittelbrunn','Dittelbrunn',50.0721,10.2197,'P','PPLA4','DE.02','DE.02.096',7620,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936787,'DE','Dissen','Dissen',52.1159,8.19956,'P','PPL','DE.06','DE.06.00',9265,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936842,'DE','Dippoldiswalde','Dippoldiswalde',50.8962,13.6691,'P','PPL','DE.13','DE.13.00',10959,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936871,'DE','Dinslaken','Dinslaken',51.5623,6.7434,'P','PPL','DE.07','DE.07.051',70573,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936881,'DE','Dinklage','Dinklage',52.6622,8.1244,'P','PPL','DE.06','DE.06.00',12626,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936885,'DE','Dinkelscherben','Dinkelscherben',48.3483,10.5889,'P','PPL','DE.02','DE.02.097',6742,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936886,'DE','Dinkelsbühl','Dinkelsbuhl',49.0694,10.3198,'P','PPL','DE.02','DE.02.095',11724,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936909,'DE','Dingolfing','Dingolfing',48.6424,12.4928,'P','PPLA3','DE.02','DE.02.092',18805,'Europe/Berlin',1,'2017-04-04 23:00:00','2017-04-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936974,'DE','Dillingen an der Donau','Dillingen an der Donau',48.5815,10.4953,'P','PPLA3','DE.02','DE.02.097',18734,'Europe/Berlin',1,'2014-01-08 23:00:00','2014-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936977,'DE','Dillingen','Dillingen',49.3556,6.72781,'P','PPL','DE.09','DE.09.00',21526,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2936985,'DE','Dillenburg','Dillenburg',50.7411,8.28699,'P','PPL','DE.05','DE.05.065',24461,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937018,'DE','Diez','Diez',50.3742,8.00735,'P','PPL','DE.08','DE.08.00',10822,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937040,'DE','Dietzenbach','Dietzenbach',50.0098,8.77783,'P','PPLA3','DE.05','DE.05.064',33256,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937073,'DE','Dietramszell','Dietramszell',47.8487,11.5953,'P','PPLA4','DE.02','DE.02.091',5252,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937077,'DE','Dietmannsried','Dietmannsried',47.8079,10.2895,'P','PPL','DE.02','DE.02.097',8044,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937110,'DE','Dietfurt','Dietfurt',49.0358,11.5862,'P','PPL','DE.02','DE.02.093',6161,'Europe/Berlin',1,'2017-09-21 23:00:00','2017-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937160,'DE','Dietenhofen','Dietenhofen',49.4,10.6897,'P','PPL','DE.02','DE.02.095',5709,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937164,'DE','Dietenheim','Dietenheim',48.2107,10.0716,'P','PPL','DE.01','DE.01.084',6630,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937217,'DE','Dießen am Ammersee','Diessen am Ammersee',47.9509,11.1031,'P','PPL','DE.02','DE.02.091',10050,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937280,'DE','Dierdorf','Dierdorf',50.5465,7.65271,'P','PPL','DE.08','DE.08.00',6023,'Europe/Berlin',1,'2018-01-01 23:00:00','2018-01-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937317,'DE','Diepholz','Diepholz',52.6078,8.37005,'P','PPLA3','DE.06','DE.06.00',16783,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937407,'DE','Dielheim','Dielheim',49.2842,8.73806,'P','PPLA4','DE.01','DE.01.082',8999,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937449,'DE','Diekholzen','Diekholzen',52.0962,9.91945,'P','PPLA4','DE.06','DE.06.00',6941,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937553,'DE','Diedorf','Diedorf',48.3532,10.7821,'P','PPL','DE.02','DE.02.097',10006,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937591,'DE','Dieburg','Dieburg',49.8974,8.84613,'P','PPL','DE.05','DE.05.064',15168,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937790,'DE','Deutz','Deutz',50.9346,6.97495,'P','PPLX','DE.07','DE.07.053',15238,'Europe/Berlin',1,'2015-03-18 23:00:00','2015-03-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937896,'DE','Dettingen unter Teck','Dettingen unter Teck',48.6167,9.45,'P','PPLA4','DE.01','DE.01.081',5567,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937898,'DE','Dettingen an der Erms','Dettingen an der Erms',48.5308,9.34458,'P','PPLA4','DE.01','DE.01.084',9271,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937919,'DE','Dettenhausen','Dettenhausen',48.6076,9.10041,'P','PPLA4','DE.01','DE.01.084',5390,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937932,'DE','Dettelbach','Dettelbach',49.803,10.1652,'P','PPL','DE.02','DE.02.096',6888,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937936,'DE','Detmold','Detmold',51.9385,8.87318,'P','PPLA2','DE.07','DE.07.057',73680,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937937,'DE','Detmerode','Detmerode',52.3902,10.7448,'P','PPL','DE.06','DE.06.00',7640,'Europe/Berlin',1,'2016-03-16 23:00:00','2016-03-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2937959,'DE','Dessau','Dessau',51.8386,12.2456,'P','PPL','DE.14','DE.14.00',77315,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2938190,'DE','Denzlingen','Denzlingen',48.0667,7.88333,'P','PPLA4','DE.01','DE.01.083',13511,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2938253,'DE','Denkendorf','Denkendorf',48.6955,9.31675,'P','PPLA4','DE.01','DE.01.081',10357,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2938284,'DE','Demmin','Demmin',53.9076,13.0314,'P','PPL','DE.12','DE.12.00',12495,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2938323,'DE','Delmenhorst','Delmenhorst',53.0511,8.63091,'P','PPLA3','DE.06','DE.06.00',75893,'Europe/Berlin',1,'2017-01-31 23:00:00','2017-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2938344,'DE','Delligsen','Delligsen',51.9412,9.80272,'P','PPL','DE.06','DE.06.00',8986,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2938376,'DE','Delitzsch','Delitzsch',51.5255,12.3428,'P','PPL','DE.13','DE.13.00',24998,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2938389,'DE','Delbrück','Delbrueck',51.765,8.56223,'P','PPL','DE.07','DE.07.057',29884,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2938391,'DE','Deizisau','Deizisau',48.7122,9.3861,'P','PPLA4','DE.01','DE.01.081',6608,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2938403,'DE','Deißlingen','Deisslingen',48.1123,8.60736,'P','PPLA4','DE.01','DE.01.083',6129,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2938538,'DE','Deggingen','Deggingen',48.5971,9.71891,'P','PPLA4','DE.01','DE.01.081',5623,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2938540,'DE','Deggendorf','Deggendorf',48.8409,12.9607,'P','PPLA3','DE.02','DE.02.092',31081,'Europe/Berlin',1,'2014-01-08 23:00:00','2014-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2938714,'DE','Daun','Daun',50.1972,6.82942,'P','PPLA3','DE.08','DE.08.00',8523,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2938784,'DE','Datteln','Datteln',51.656,7.3453,'P','PPL','DE.07','DE.07.055',36338,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2938813,'DE','Dassel','Dassel',51.8018,9.68904,'P','PPL','DE.06','DE.06.00',11287,'Europe/Berlin',1,'2015-07-30 23:00:00','2015-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2938837,'DE','Dasing','Dasing',48.3848,11.0467,'P','PPLA4','DE.02','DE.02.097',5321,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2938913,'DE','Darmstadt','Darmstadt',49.8717,8.65027,'P','PPLA2','DE.05','DE.05.064',140385,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2938991,'DE','Dannenberg','Dannenberg',53.0967,11.09,'P','PPL','DE.06','DE.06.00',8413,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939167,'DE','Damme','Damme',52.5216,8.19793,'P','PPL','DE.06','DE.06.00',16024,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939388,'DE','Dahme','Dahme',51.8701,13.4274,'P','PPL','DE.11','DE.11.00',5924,'Europe/Berlin',1,'2017-07-23 23:00:00','2017-07-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939434,'DE','Dahlen','Dahlen',51.3649,12.9988,'P','PPL','DE.13','DE.13.00',5211,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939440,'DE','Dahlem','Dahlem',52.4581,13.287,'P','PPLX','DE.16','DE.16.00',15737,'Europe/Berlin',1,'2012-06-08 23:00:00','2012-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939623,'DE','Dachau','Dachau',48.26,11.434,'P','PPLA3','DE.02','DE.02.091',39740,'Europe/Berlin',1,'2014-01-08 23:00:00','2014-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939658,'DE','Cuxhaven','Cuxhaven',53.8718,8.69087,'P','PPLA3','DE.06','DE.06.00',52677,'Europe/Berlin',1,'2016-11-15 23:00:00','2016-11-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939687,'DE','Cunewalde','Cunewalde',51.1,14.5167,'P','PPLA4','DE.13','DE.13.00',5601,'Europe/Berlin',1,'2014-01-01 23:00:00','2014-01-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939747,'DE','Crimmitschau','Crimmitschau',50.8164,12.3904,'P','PPL','DE.13','DE.13.00',22442,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939763,'DE','Cremlingen','Cremlingen',52.25,10.65,'P','PPLA4','DE.06','DE.06.00',12808,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939797,'DE','Crailsheim','Crailsheim',49.1344,10.0719,'P','PPL','DE.01','DE.01.081',32262,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939811,'DE','Cottbus','Cottbus',51.7577,14.3289,'P','PPLA3','DE.11','DE.11.00',84754,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939819,'DE','Coswig','Coswig',51.8862,12.4501,'P','PPL','DE.14','DE.14.00',8495,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939820,'DE','Coswig','Coswig',51.132,13.5831,'P','PPL','DE.13','DE.13.00',22304,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939862,'DE','Coppenbrügge','Coppenbruegge',52.1185,9.5487,'P','PPL','DE.06','DE.06.00',7901,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939870,'DE','Contwig','Contwig',49.25,7.43333,'P','PPLA4','DE.08','DE.08.00',5029,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939927,'DE','Colditz','Colditz',51.1282,12.8029,'P','PPL','DE.13','DE.13.00',5173,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939942,'DE','Cölbe','Coelbe',50.851,8.78092,'P','PPLA4','DE.05','DE.05.065',7083,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939945,'DE','Coesfeld','Coesfeld',51.9435,7.16809,'P','PPLA3','DE.07','DE.07.055',36631,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939949,'DE','Cochem','Cochem',50.1451,7.16379,'P','PPLA3','DE.08','DE.08.00',5215,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939951,'DE','Coburg','Coburg',50.2594,10.9638,'P','PPLA3','DE.02','DE.02.094',41901,'Europe/Berlin',1,'2016-06-14 23:00:00','2016-06-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939969,'DE','Cloppenburg','Cloppenburg',52.8475,8.045,'P','PPLA3','DE.06','DE.06.00',31177,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2939995,'DE','Clausthal-Zellerfeld','Clausthal-Zellerfeld',51.8095,10.3382,'P','PPL','DE.06','DE.06.00',15345,'Europe/Berlin',1,'2015-11-28 23:00:00','2015-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940132,'DE','Chemnitz','Chemnitz',50.8357,12.9292,'P','PPLA3','DE.13','DE.13.00',247220,'Europe/Berlin',1,'2014-02-07 23:00:00','2014-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940187,'DE','Charlottenburg','Charlottenburg Bezirk',52.5167,13.2833,'P','PPLX','DE.16','DE.16.00',119857,'Europe/Berlin',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940204,'DE','Cham','Cham',49.2257,12.655,'P','PPLA3','DE.02','DE.02.093',17314,'Europe/Berlin',1,'2014-01-08 23:00:00','2014-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940213,'DE','Celle','Celle',52.6226,10.0805,'P','PPLA3','DE.06','DE.06.00',71010,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940231,'DE','Castrop-Rauxel','Castrop-Rauxel',51.5566,7.31155,'P','PPL','DE.07','DE.07.055',77924,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940317,'DE','Cappeln','Cappeln',52.8108,8.11474,'P','PPL','DE.06','DE.06.00',6274,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940381,'DE','Bad Camberg','Bad Camberg',50.297,8.26896,'P','PPL','DE.05','DE.05.065',14195,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940383,'DE','Calw','Calw',48.7142,8.74031,'P','PPLA3','DE.01','DE.01.082',23740,'Europe/Berlin',1,'2014-01-08 23:00:00','2014-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940397,'DE','Callenberg','Callenberg',50.85,12.6333,'P','PPLA4','DE.13','DE.13.00',5763,'Europe/Berlin',1,'2014-01-01 23:00:00','2014-01-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940412,'DE','Calden','Calden',51.4094,9.40189,'P','PPLA4','DE.05','DE.05.066',7752,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940419,'DE','Calbe','Calbe',51.9067,11.7748,'P','PPL','DE.14','DE.14.00',11322,'Europe/Berlin',1,'2015-12-08 23:00:00','2015-12-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940424,'DE','Calau','Calau',51.744,13.9533,'P','PPL','DE.11','DE.11.00',9299,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940428,'DE','Cadolzburg','Cadolzburg',49.4573,10.8533,'P','PPL','DE.02','DE.02.095',10164,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940451,'DE','Buxtehude','Buxtehude',53.4672,9.68636,'P','PPL','DE.06','DE.06.00',38192,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940476,'DE','Bützow','Buetzow',53.8483,11.9826,'P','PPL','DE.12','DE.12.00',8146,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940512,'DE','Butzbach','Butzbach',50.4339,8.67122,'P','PPL','DE.05','DE.05.064',25156,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940611,'DE','Buttenwiesen','Buttenwiesen',48.6,10.7167,'P','PPLA4','DE.02','DE.02.097',5750,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940633,'DE','Büttelborn','Buttelborn',49.9033,8.52333,'P','PPLA4','DE.05','DE.05.064',13338,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940938,'DE','Bürstadt','Buerstadt',49.6427,8.45936,'P','PPL','DE.05','DE.05.064',15348,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940942,'DE','Burscheid','Burscheid',51.0847,7.11393,'P','PPL','DE.07','DE.07.053',19215,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940977,'DE','Burladingen','Burladingen',48.2911,9.11286,'P','PPL','DE.01','DE.01.084',13131,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2940993,'DE','Burkhardtsdorf','Burkhardtsdorf',50.7333,12.9167,'P','PPLA4','DE.13','DE.13.00',7067,'Europe/Berlin',1,'2014-01-01 23:00:00','2014-01-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941034,'DE','Burkardroth','Burkardroth',50.2713,9.99162,'P','PPL','DE.02','DE.02.096',7893,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941090,'DE','Burgthann','Burgthann',49.352,11.3115,'P','PPLA4','DE.02','DE.02.095',11567,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941150,'DE','Burgstädt','Burgstaedt',50.9133,12.806,'P','PPL','DE.13','DE.13.00',12477,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941190,'DE','Burglengenfeld','Burglengenfeld',49.2038,12.0445,'P','PPL','DE.02','DE.02.093',12095,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941207,'DE','Burgkunstadt','Burgkunstadt',50.1409,11.2521,'P','PPL','DE.02','DE.02.094',6991,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941216,'DE','Burgkirchen an der Alz','Burgkirchen an der Alz',48.1675,12.7325,'P','PPL','DE.02','DE.02.091',10756,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941279,'DE','Burghausen','Burghausen',48.1693,12.8314,'P','PPL','DE.02','DE.02.091',18263,'Europe/Berlin',1,'2015-11-12 23:00:00','2015-11-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941283,'DE','Burghaun','Burghaun',50.6968,9.72453,'P','PPLA4','DE.05','DE.05.066',6713,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941403,'DE','Burgebrach','Burgebrach',49.8283,10.7434,'P','PPL','DE.02','DE.02.094',6412,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941405,'DE','Burgdorf','Burgdorf',52.4463,10.0064,'P','PPL','DE.06','DE.06.00',30218,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941485,'DE','Burgau','Burgau',48.4316,10.4099,'P','PPL','DE.02','DE.02.097',9576,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941496,'DE','Burg auf Fehmarn','Burg auf Fehmarn',54.4333,11.2,'P','PPLX','DE.10','DE.10.00',6000,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941501,'DE','Burg bei Magdeburg','Burg bei Magdeburg',52.2715,11.8549,'P','PPLA3','DE.14','DE.14.00',24958,'Europe/Berlin',1,'2016-09-26 23:00:00','2016-09-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941570,'DE','Büren','Bueren',51.5511,8.55956,'P','PPL','DE.07','DE.07.057',22263,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941595,'DE','Burbach','Burbach',50.751,8.07939,'P','PPLA4','DE.07','DE.07.059',14942,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941693,'DE','Bunde','Bunde',53.1833,7.26667,'P','PPLA4','DE.06','DE.06.00',7588,'Europe/Berlin',1,'2016-02-15 23:00:00','2016-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941694,'DE','Bünde','Buende',52.1984,8.58644,'P','PPL','DE.07','DE.07.057',45403,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941928,'DE','Bühlertal','Buhlertal',48.6857,8.18876,'P','PPLA4','DE.01','DE.01.082',8144,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2941976,'DE','Bühl','Buhl',48.6968,8.13523,'P','PPL','DE.01','DE.01.082',29193,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2942073,'DE','Büdingen','Buedingen',50.2901,9.1114,'P','PPL','DE.05','DE.05.064',21579,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2942087,'DE','Budenheim','Budenheim',50.0167,8.16667,'P','PPLA4','DE.08','DE.08.00',8598,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2942093,'DE','Büdelsdorf','Buedelsdorf',54.3184,9.67295,'P','PPL','DE.10','DE.10.00',10144,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2942122,'DE','Buckow','Buckow',52.432,13.4602,'P','PPLX','DE.16','DE.16.00',38474,'Europe/Berlin',1,'2012-06-08 23:00:00','2012-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2942159,'DE','Bückeburg','Buckeburg',52.2607,9.04939,'P','PPL','DE.06','DE.06.00',20700,'Europe/Berlin',1,'2016-04-18 23:00:00','2016-04-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2942281,'DE','Buchloe','Buchloe',48.0372,10.7255,'P','PPL','DE.02','DE.02.097',11978,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2942323,'DE','Buchholz in der Nordheide','Buchholz in der Nordheide',53.3264,9.86812,'P','PPL','DE.06','DE.06.00',37404,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2942341,'DE','Französisch Buchholz','Buchholz',52.6024,13.4302,'P','PPLX','DE.16','DE.16.00',19429,'Europe/Berlin',1,'2012-06-08 23:00:00','2012-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2942446,'DE','Buchheim','Buchheim',50.9515,7.02093,'P','PPLX','DE.07','DE.07.053',12840,'Europe/Berlin',1,'2015-03-18 23:00:00','2015-03-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2942612,'DE','Büchenbach','Buchenbach',49.2678,11.0589,'P','PPLA4','DE.02','DE.02.095',5255,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2942627,'DE','Büchen','Buchen',53.4801,10.6176,'P','PPLA4','DE.10','DE.10.00',5442,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2942634,'DE','Buchen','Buchen',49.5242,9.32293,'P','PPL','DE.01','DE.01.082',18890,'Europe/Berlin',1,'2017-09-21 23:00:00','2017-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2942827,'DE','Buch','Buch',52.6347,13.4968,'P','PPLX','DE.16','DE.16.00',12674,'Europe/Berlin',1,'2012-06-08 23:00:00','2012-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2943049,'DE','Brunsbüttel','Brunsbuettel',53.895,9.10484,'P','PPL','DE.10','DE.10.00',13950,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2943320,'DE','Brühl','Bruehl',50.8293,6.90499,'P','PPL','DE.07','DE.07.053',44137,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2943321,'DE','Brühl','Bruhl',49.3972,8.53361,'P','PPLA4','DE.01','DE.01.082',14262,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2943336,'DE','Brüggen','Bruggen',51.2405,6.18376,'P','PPLA4','DE.07','DE.07.051',16105,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2943408,'DE','Bruckmühl','Bruckmuhl',47.8786,11.911,'P','PPL','DE.02','DE.02.091',15851,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2943501,'DE','Bruckberg','Bruckberg',48.5224,11.9945,'P','PPLA4','DE.02','DE.02.092',5071,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2943560,'DE','Bruchsal','Bruchsal',49.1243,8.59804,'P','PPL','DE.01','DE.01.082',42785,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2943573,'DE','Bruchköbel','Bruchkoebel',50.1785,8.92315,'P','PPL','DE.05','DE.05.064',20892,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2943587,'DE','Bruchhausen-Vilsen','Bruchhausen-Vilsen',52.8293,8.99066,'P','PPL','DE.06','DE.06.00',6205,'Europe/Berlin',1,'2017-07-12 23:00:00','2017-07-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2944027,'DE','Britz','Britz',52.4429,13.4339,'P','PPLX','DE.16','DE.16.00',39488,'Europe/Berlin',1,'2012-06-08 23:00:00','2012-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2944079,'DE','Brilon','Brilon',51.3946,8.57146,'P','PPL','DE.07','DE.07.059',27030,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2944126,'DE','Brieselang','Brieselang',52.5833,13,'P','PPLA4','DE.11','DE.11.00',10379,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2944178,'DE','Bretzfeld','Bretzfeld',49.1794,9.43833,'P','PPLA4','DE.01','DE.01.081',12162,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2944200,'DE','Bretten','Bretten',49.0368,8.70745,'P','PPL','DE.01','DE.01.082',28144,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2944254,'DE','Brensbach','Brensbach',49.7739,8.88444,'P','PPLA4','DE.05','DE.05.064',5438,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2944354,'DE','Bremervörde','Bremervoerde',53.4846,9.14306,'P','PPL','DE.06','DE.06.00',19268,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2944368,'DE','Bremerhaven','Bremerhaven',53.5502,8.57673,'P','PPLA3','DE.03','DE.03.00',117446,'Europe/Berlin',1,'2016-10-04 23:00:00','2016-10-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2944388,'DE','Bremen','Bremen',53.0752,8.80777,'P','PPLA','DE.03','DE.03.00',546501,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2944440,'DE','Breitungen','Breitungen',50.7635,10.3272,'P','PPL','DE.15','DE.15.00',5281,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2944800,'DE','Breisach am Rhein','Breisach am Rhein',48.0328,7.58294,'P','PPL','DE.01','DE.01.083',14367,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2944820,'DE','Breidenbach','Breidenbach',50.8873,8.45748,'P','PPLA4','DE.05','DE.05.065',6866,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2944879,'DE','Bredstedt','Bredstedt',54.6187,8.96441,'P','PPL','DE.10','DE.10.00',5146,'Europe/Berlin',1,'2015-05-03 23:00:00','2015-05-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2944955,'DE','Breckerfeld','Breckerfeld',51.2593,7.46807,'P','PPL','DE.07','DE.07.059',9217,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945024,'DE','Braunschweig','Braunschweig',52.2659,10.5267,'P','PPLA3','DE.06','DE.06.00',244715,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945041,'DE','Braunsbedra','Braunsbedra',51.286,11.8899,'P','PPL','DE.14','DE.14.00',6599,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945051,'DE','Bräunlingen','Braunlingen',47.9296,8.44806,'P','PPL','DE.01','DE.01.083',6141,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945055,'DE','Braunlage','Braunlage',51.7265,10.6109,'P','PPL','DE.06','DE.06.00',5159,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945073,'DE','Braunfels','Braunfels',50.5154,8.38918,'P','PPL','DE.05','DE.05.065',11510,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945165,'DE','Brannenburg','Brannenburg',47.74,12.0917,'P','PPLA4','DE.02','DE.02.091',5646,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945270,'DE','Brandis','Brandis',51.336,12.6102,'P','PPL','DE.13','DE.13.00',9728,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945341,'DE','Brand-Erbisdorf','Brand-Erbisdorf',50.8664,13.3229,'P','PPL','DE.13','DE.13.00',11284,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945358,'DE','Brandenburg an der Havel','Brandenburg an der Havel',52.4167,12.55,'P','PPL','DE.11','DE.11.00',59826,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945474,'DE','Bramsche','Bramsche',52.4088,7.97288,'P','PPL','DE.06','DE.06.00',31394,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945542,'DE','Brakel','Brakel',51.7175,9.18596,'P','PPL','DE.07','DE.07.057',17808,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945545,'DE','Brake (Unterweser)','Brake (Unterweser)',53.3333,8.48333,'P','PPLA3','DE.06','DE.06.00',16150,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945591,'DE','Brackenheim','Brackenheim',49.0779,9.06601,'P','PPL','DE.01','DE.01.081',15083,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945703,'DE','Boxberg','Boxberg',49.4796,9.64006,'P','PPL','DE.01','DE.01.081',7209,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945726,'DE','Bovenden','Bovenden',51.5884,9.9222,'P','PPL','DE.06','DE.06.00',13964,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945730,'DE','Bous','Bous',49.2773,6.80131,'P','PPLA4','DE.09','DE.09.00',7605,'Europe/Berlin',1,'2016-01-01 23:00:00','2016-01-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945740,'DE','Bötzingen','Botzingen',48.0764,7.72485,'P','PPLA4','DE.01','DE.01.083',5239,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945756,'DE','Bottrop','Bottrop',51.5239,6.9285,'P','PPLA3','DE.07','DE.07.055',119909,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2945907,'DE','Bösel','Bosel',53,7.95,'P','PPLA4','DE.06','DE.06.00',7511,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946016,'DE','Borsdorf','Borsdorf',51.35,12.5333,'P','PPLA4','DE.13','DE.13.00',8489,'Europe/Berlin',1,'2014-01-01 23:00:00','2014-01-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946111,'DE','Bornheim','Bornheim',50.7631,6.99089,'P','PPL','DE.07','DE.07.053',48523,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946172,'DE','Borna','Borna',51.1242,12.4964,'P','PPLA3','DE.13','DE.13.00',18806,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946206,'DE','Borkum','Borkum',53.5809,6.69153,'P','PPL','DE.06','DE.06.00',5186,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946228,'DE','Borken','Borken',51.8438,6.85774,'P','PPLA3','DE.07','DE.07.055',40876,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946230,'DE','Borken','Borken',51.045,9.2844,'P','PPL','DE.05','DE.05.066',13531,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946270,'DE','Borgholzhausen','Borgholzhausen',52.1034,8.30211,'P','PPL','DE.07','DE.07.057',8754,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946281,'DE','Borgfelde','Borgfelde',53.5547,10.0345,'P','PPLX','DE.04','DE.04.00',7099,'Europe/Berlin',1,'2017-12-16 23:00:00','2017-12-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946291,'DE','Borgentreich','Borgentreich',51.5692,9.24113,'P','PPL','DE.07','DE.07.057',9713,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946321,'DE','Bordesholm','Bordesholm',54.1761,10.0315,'P','PPLA4','DE.10','DE.10.00',7709,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946366,'DE','Boppard','Boppard',50.2309,7.58992,'P','PPL','DE.08','DE.08.00',16215,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946368,'DE','Bopfingen','Bopfingen',48.8585,10.3542,'P','PPL','DE.01','DE.01.081',12606,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946428,'DE','Bönnigheim','Bonnigheim',49.0402,9.09386,'P','PPL','DE.01','DE.01.081',7477,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946445,'DE','Bonndorf im Schwarzwald','Bonndorf im Schwarzwald',47.8186,8.34139,'P','PPL','DE.01','DE.01.083',6875,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946447,'DE','Bonn','Bonn',50.7344,7.09549,'P','PPLA3','DE.07','DE.07.053',313125,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946478,'DE','Bönen','Bonen',51.6,7.76667,'P','PPLA4','DE.07','DE.07.059',19393,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946485,'DE','Bondorf','Bondorf',48.5206,8.83704,'P','PPLA4','DE.01','DE.01.081',5730,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946524,'DE','Bomlitz','Bomlitz',52.9,9.65,'P','PPLA4','DE.06','DE.06.00',7287,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946696,'DE','Boll','Boll',48.6436,9.61295,'P','PPLA4','DE.01','DE.01.081',5296,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946821,'DE','Boizenburg','Boizenburg',53.3815,10.7238,'P','PPL','DE.12','DE.12.00',10783,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946887,'DE','Bohnsdorf','Bohnsdorf',52.3943,13.5734,'P','PPLX','DE.16','DE.16.00',10805,'Europe/Berlin',1,'2012-06-08 23:00:00','2012-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946923,'DE','Bohmte','Bohmte',52.3667,8.31667,'P','PPLA4','DE.06','DE.06.00',13153,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946950,'DE','Böhmenkirch','Bohmenkirch',48.6833,9.93333,'P','PPLA4','DE.01','DE.01.081',5774,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2946980,'DE','Böhlen','Boehlen',51.2006,12.3862,'P','PPL','DE.13','DE.13.00',6982,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947022,'DE','Bogenhausen','Bogenhausen',48.1522,11.6159,'P','PPLX','DE.02','DE.02.091',77542,'Europe/Berlin',1,'2017-08-02 23:00:00','2017-08-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947026,'DE','Bogen','Bogen',48.9112,12.6896,'P','PPL','DE.02','DE.02.092',10259,'Europe/Berlin',1,'2012-09-23 23:00:00','2012-09-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947092,'DE','Bodenwerder','Bodenwerder',51.9716,9.51931,'P','PPL','DE.06','DE.06.00',6187,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947125,'DE','Bodenkirchen','Bodenkirchen',48.3833,12.3833,'P','PPLA4','DE.02','DE.02.092',5442,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947133,'DE','Bodenheim','Bodenheim',49.9353,8.32,'P','PPLA4','DE.08','DE.08.00',6907,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947172,'DE','Bodelshausen','Bodelshausen',48.3889,8.97703,'P','PPLA4','DE.01','DE.01.084',5929,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947312,'DE','Bockhorn','Bockhorn',53.4,8.01667,'P','PPLA4','DE.06','DE.06.00',8924,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947359,'DE','Bockenem','Bockenem',52.0099,10.132,'P','PPLA4','DE.06','DE.06.00',11177,'Europe/Berlin',1,'2011-03-23 23:00:00','2011-03-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947416,'DE','Bochum','Bochum',51.4817,7.21648,'P','PPLA3','DE.07','DE.07.059',385729,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947421,'DE','Bocholt','Bocholt',51.8388,6.61531,'P','PPL','DE.07','DE.07.055',73943,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947444,'DE','Böblingen','Boeblingen',48.6821,9.01171,'P','PPLA3','DE.01','DE.01.081',46282,'Europe/Berlin',1,'2014-01-08 23:00:00','2014-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947449,'DE','Bobingen','Bobingen',48.2709,10.8339,'P','PPL','DE.02','DE.02.097',16682,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947465,'DE','Bobenheim-Roxheim','Bobenheim-Roxheim',49.5875,8.35778,'P','PPLA4','DE.08','DE.08.00',10106,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947584,'DE','Blumberg','Blumberg',47.8406,8.53329,'P','PPL','DE.01','DE.01.083',10500,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947641,'DE','Blomberg','Blomberg',51.9433,9.09067,'P','PPL','DE.07','DE.07.057',17183,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947739,'DE','Blieskastel','Blieskastel',49.2372,7.25617,'P','PPL','DE.09','DE.09.00',23212,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947837,'DE','Bleicherode','Bleicherode',51.4403,10.572,'P','PPL','DE.15','DE.15.00',6456,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947894,'DE','Bleckede','Bleckede',53.2897,10.7337,'P','PPL','DE.06','DE.06.00',9793,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947919,'DE','Blaufelden','Blaufelden',49.2978,9.97389,'P','PPLA4','DE.01','DE.01.081',5348,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2947949,'DE','Blaubeuren','Blaubeuren',48.4122,9.78427,'P','PPL','DE.01','DE.01.084',11797,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948056,'DE','Blankenheim','Blankenheim',50.4333,6.65,'P','PPLA4','DE.07','DE.07.053',8770,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948058,'DE','Blankenhain','Blankenhain',50.8599,11.3439,'P','PPL','DE.15','DE.15.00',6920,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948069,'DE','Blankenburg','Blankenburg',52.5929,13.4552,'P','PPLX','DE.16','DE.16.00',6536,'Europe/Berlin',1,'2017-09-18 23:00:00','2017-09-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948071,'DE','Blankenburg','Blankenburg',51.7902,10.9551,'P','PPL','DE.14','DE.14.00',15963,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948114,'DE','Blaichach','Blaichach',47.5421,10.2585,'P','PPLA4','DE.02','DE.02.097',5625,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948164,'DE','Bitterfeld-Wolfen','Bitterfeld-Wolfen',51.6236,12.3239,'P','PPL','DE.14','DE.14.00',15608,'Europe/Berlin',1,'2017-12-30 23:00:00','2017-12-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948184,'DE','Bitburg','Bitburg',49.9679,6.52734,'P','PPLA4','DE.08','DE.08.00',12908,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948212,'DE','Bissendorf','Bissendorf',52.2333,8.16667,'P','PPLA4','DE.06','DE.06.00',14402,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948222,'DE','Bispingen','Bispingen',53.0831,9.99772,'P','PPLA4','DE.06','DE.06.00',6284,'Europe/Berlin',1,'2011-08-29 23:00:00','2011-08-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948246,'DE','Bisingen','Bisingen',48.3101,8.91738,'P','PPLA4','DE.01','DE.01.084',9321,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948265,'DE','Bischofswiesen','Bischofswiesen',47.6311,12.9831,'P','PPLA4','DE.02','DE.02.091',7535,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948267,'DE','Bischofswerda','Bischofswerda',51.1277,14.1797,'P','PPL','DE.13','DE.13.00',13085,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948287,'DE','Bischofsheim an der Rhön','Bischofsheim an der Rhon',50.4024,10.0075,'P','PPL','DE.02','DE.02.096',5181,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948290,'DE','Bischofsheim','Bischofsheim',49.9939,8.36722,'P','PPLA4','DE.05','DE.05.064',12075,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948339,'DE','Bischberg','Bischberg',49.9109,10.8321,'P','PPLA4','DE.02','DE.02.094',5819,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948351,'DE','Birstein','Birstein',50.35,9.3,'P','PPLA4','DE.05','DE.05.064',6581,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948384,'DE','Bad Birnbach','Bad Birnbach',48.4449,13.091,'P','PPL','DE.02','DE.02.092',5533,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948503,'DE','Birkenwerder','Birkenwerder',52.6833,13.2833,'P','PPLA4','DE.11','DE.11.00',7122,'Europe/Berlin',1,'2016-06-22 23:00:00','2016-06-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948595,'DE','Birkenfeld','Birkenfeld',49.6525,7.16668,'P','PPLA3','DE.08','DE.08.00',6947,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948598,'DE','Birkenfeld','Birkenfeld',48.8667,8.63333,'P','PPLA4','DE.01','DE.01.082',10609,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948652,'DE','Birkenau','Birkenau',49.5625,8.70694,'P','PPLA4','DE.05','DE.05.064',10318,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948825,'DE','Bingen am Rhein','Bingen am Rhein',49.9668,7.8992,'P','PPL','DE.08','DE.08.00',24657,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948840,'DE','Bindlach','Bindlach',49.9817,11.6139,'P','PPLA4','DE.02','DE.02.094',7229,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948934,'DE','Billigheim','Billigheim',49.3486,9.25389,'P','PPLA4','DE.01','DE.01.082',5899,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2948944,'DE','Billerbeck','Billerbeck',51.9783,7.29261,'P','PPL','DE.07','DE.07.055',11699,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949012,'DE','Bietigheim-Bissingen','Bietigheim-Bissingen',48.9441,9.11755,'P','PPL','DE.01','DE.01.081',41769,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949014,'DE','Bietigheim','Bietigheim',48.9092,8.25202,'P','PPLA4','DE.01','DE.01.082',6026,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949046,'DE','Biesenthal','Biesenthal',52.7662,13.6442,'P','PPL','DE.11','DE.11.00',5512,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949073,'DE','Biesdorf','Biesdorf',52.5091,13.5534,'P','PPLX','DE.16','DE.16.00',24988,'Europe/Berlin',1,'2017-09-18 23:00:00','2017-09-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949150,'DE','Bienenbüttel','Bienenbuttel',53.1416,10.4868,'P','PPLA4','DE.06','DE.06.00',6775,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949186,'DE','Bielefeld','Bielefeld',52.0333,8.53333,'P','PPLA4','DE.07','DE.07.057',331906,'Europe/Berlin',1,'2012-11-23 23:00:00','2012-11-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949229,'DE','Biedenkopf','Biedenkopf',50.9113,8.53016,'P','PPL','DE.05','DE.05.065',13788,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949240,'DE','Biebesheim','Biebesheim',49.7809,8.46696,'P','PPL','DE.05','DE.05.064',6626,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949296,'DE','Bickenbach','Bickenbach',49.7592,8.6175,'P','PPLA4','DE.05','DE.05.064',5338,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949367,'DE','Biblis','Biblis',49.6917,8.45861,'P','PPLA4','DE.05','DE.05.064',8953,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949423,'DE','Biberach an der Riß','Biberach an der Riss',48.0934,9.79053,'P','PPLA3','DE.01','DE.01.084',32333,'Europe/Berlin',1,'2014-01-08 23:00:00','2014-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949470,'DE','Bexbach','Bexbach',49.3461,7.25527,'P','PPL','DE.09','DE.09.00',19115,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949475,'DE','Beverungen','Beverungen',51.668,9.37417,'P','PPL','DE.07','DE.07.057',15266,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949511,'DE','Bad Bevensen','Bad Bevensen',53.0792,10.5813,'P','PPL','DE.06','DE.06.00',8700,'Europe/Berlin',1,'2015-03-23 23:00:00','2015-03-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949669,'DE','Betzdorf','Betzdorf',50.7909,7.87189,'P','PPL','DE.08','DE.08.00',10560,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949773,'DE','Bestwig','Bestwig',51.3608,8.40082,'P','PPLA4','DE.07','DE.07.059',11764,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949777,'DE','Bestensee','Bestensee',52.2398,13.6373,'P','PPLA4','DE.11','DE.11.00',6265,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949803,'DE','Besigheim','Besigheim',48.998,9.14268,'P','PPL','DE.01','DE.01.081',11883,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949906,'DE','Bersenbrück','Bersenbrueck',52.5516,7.94836,'P','PPL','DE.06','DE.06.00',7958,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949961,'DE','Bernsdorf','Bernsdorf',51.3735,14.0689,'P','PPL','DE.13','DE.13.00',5871,'Europe/Berlin',1,'2017-04-23 23:00:00','2017-04-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2949998,'DE','Bernkastel-Kues','Bernkastel-Kues',49.916,7.07664,'P','PPL','DE.08','DE.08.00',6880,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950019,'DE','Bernhardswald','Bernhardswald',49.0912,12.2474,'P','PPLA4','DE.02','DE.02.093',5596,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950073,'DE','Bernburg','Bernburg',51.7946,11.7401,'P','PPLA3','DE.14','DE.14.00',32113,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950095,'DE','Bernau am Chiemsee','Bernau am Chiemsee',47.8117,12.3757,'P','PPL','DE.02','DE.02.091',6645,'Europe/Berlin',1,'2013-11-24 23:00:00','2013-11-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950096,'DE','Bernau bei Berlin','Bernau bei Berlin',52.6798,13.5871,'P','PPL','DE.11','DE.11.00',34866,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950159,'DE','Berlin','Berlin',52.5244,13.4105,'P','PPLC','DE.16','DE.16.00',3426354,'Europe/Berlin',1,'2016-09-25 23:00:00','2016-09-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950265,'DE','Bergstedt','Bergstedt',53.6711,10.1269,'P','PPLX','DE.04','DE.04.00',9845,'Europe/Berlin',1,'2017-10-16 23:00:00','2017-10-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950294,'DE','Bergneustadt','Bergneustadt',51.025,7.65599,'P','PPL','DE.07','DE.07.053',20567,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950340,'DE','Bergkirchen','Bergkirchen',48.2567,11.3649,'P','PPLA4','DE.02','DE.02.091',6955,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950344,'DE','Bergkamen','Bergkamen',51.6163,7.64451,'P','PPL','DE.07','DE.07.059',52329,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950349,'DE','Bergisch Gladbach','Bergisch Gladbach',50.9856,7.13298,'P','PPLA3','DE.07','DE.07.053',106184,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950438,'DE','Bergheim','Bergheim',50.9557,6.63986,'P','PPLA3','DE.07','DE.07.053',63558,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950620,'DE','Bergen auf Rügen','Bergen auf Ruegen',54.4182,13.4335,'P','PPL','DE.12','DE.12.00',14771,'Europe/Berlin',1,'2016-05-22 23:00:00','2016-05-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950622,'DE','Bergen','Bergen',52.8084,9.96374,'P','PPL','DE.06','DE.06.00',13609,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950725,'DE','Berg','Berg',49.8142,12.1416,'P','PPL','DE.02','DE.02.093',7472,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950881,'DE','Berchtesgaden','Berchtesgaden',47.6324,13.0019,'P','PPL','DE.02','DE.02.091',7655,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950882,'DE','Berching','Berching',49.1069,11.4414,'P','PPL','DE.02','DE.02.093',8696,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950898,'DE','Beratzhausen','Beratzhausen',49.0952,11.8097,'P','PPL','DE.02','DE.02.093',5583,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2950978,'DE','Bensheim','Bensheim',49.6837,8.61839,'P','PPL','DE.05','DE.05.064',39439,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951013,'DE','Benningen am Neckar','Benningen am Neckar',48.9467,9.24212,'P','PPLA4','DE.01','DE.01.081',5481,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951026,'DE','Bennewitz','Bennewitz',51.3607,12.7138,'P','PPLX','DE.13','DE.13.00',5211,'Europe/Berlin',1,'2014-01-01 23:00:00','2014-01-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951111,'DE','Bendorf','Bendorf',50.4229,7.57924,'P','PPL','DE.08','DE.08.00',17495,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951134,'DE','Bad Belzig','Bad Belzig',52.1418,12.5927,'P','PPLA3','DE.11','DE.11.00',11999,'Europe/Berlin',1,'2015-11-05 23:00:00','2015-11-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951175,'DE','Belm','Belm',52.3,8.13333,'P','PPLA4','DE.06','DE.06.00',13897,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951206,'DE','Bellheim','Bellheim',49.1983,8.27944,'P','PPLA4','DE.08','DE.08.00',8494,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951258,'DE','Belgern','Belgern',51.4826,13.1238,'P','PPL','DE.13','DE.13.00',5148,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951346,'DE','Beilstein','Beilstein',49.0414,9.3137,'P','PPL','DE.01','DE.01.081',6103,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951528,'DE','Beeskow','Beeskow',52.1729,14.246,'P','PPLA3','DE.11','DE.11.00',8468,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951556,'DE','Beerfelden','Beerfelden',49.5686,8.97444,'P','PPL','DE.05','DE.05.064',6942,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951595,'DE','Beelitz','Beelitz',52.2381,12.9714,'P','PPL','DE.11','DE.11.00',12475,'Europe/Berlin',1,'2015-09-30 23:00:00','2015-09-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951596,'DE','Beelen','Beelen',51.9291,8.11117,'P','PPLA4','DE.07','DE.07.055',6344,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951648,'DE','Bedburg','Bedburg',50.9926,6.57128,'P','PPL','DE.07','DE.07.053',24937,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951654,'DE','Beckum','Beckum',51.7557,8.04075,'P','PPL','DE.07','DE.07.055',37814,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951679,'DE','Beckingen','Beckingen',49.4,6.7,'P','PPLA4','DE.09','DE.09.00',15983,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951793,'DE','Bebra','Bebra',50.9744,9.79562,'P','PPL','DE.05','DE.05.066',14839,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951825,'DE','Bayreuth','Bayreuth',49.9478,11.5789,'P','PPLA2','DE.02','DE.02.094',75061,'Europe/Berlin',1,'2014-02-07 23:00:00','2014-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951860,'DE','Bayenthal','Bayenthal',50.9122,6.96799,'P','PPLX','DE.07','DE.07.053',8714,'Europe/Berlin',1,'2015-03-18 23:00:00','2015-03-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951881,'DE','Bautzen','Bautzen',51.1804,14.4349,'P','PPLA3','DE.13','DE.13.00',41972,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951923,'DE','Baunatal','Baunatal',51.2518,9.40747,'P','PPL','DE.05','DE.05.066',28173,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2951935,'DE','Baumschulenweg','Baumschulenweg',52.4658,13.4852,'P','PPLX','DE.16','DE.16.00',17186,'Europe/Berlin',1,'2012-08-03 23:00:00','2012-08-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2952213,'DE','Battenberg','Battenberg',51.0139,8.64603,'P','PPL','DE.05','DE.05.066',5703,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2952252,'DE','Bassum','Bassum',52.8506,8.72791,'P','PPL','DE.06','DE.06.00',16191,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2952372,'DE','Barth','Barth',54.3635,12.7249,'P','PPL','DE.12','DE.12.00',9298,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2952398,'DE','Barßel','Barssel',53.1698,7.75012,'P','PPLA4','DE.06','DE.06.00',12475,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2952406,'DE','Barsinghausen','Barsinghausen',52.3,9.45,'P','PPLA4','DE.06','DE.06.00',14200,'Europe/Berlin',1,'2011-02-15 23:00:00','2011-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2952415,'DE','Barsbüttel','Barsbuettel',53.5667,10.1667,'P','PPLA4','DE.10','DE.10.00',12363,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2952444,'DE','Barntrup','Barntrup',51.9904,9.11642,'P','PPL','DE.07','DE.07.057',9513,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2952452,'DE','Barnstorf','Barnstorf',52.7101,8.50256,'P','PPL','DE.06','DE.06.00',6050,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2952531,'DE','Barmstedt','Barmstedt',53.7921,9.76739,'P','PPL','DE.10','DE.10.00',9521,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2952564,'DE','Barleben','Barleben',52.2019,11.6177,'P','PPLA4','DE.14','DE.14.00',5895,'Europe/Berlin',1,'2014-05-15 23:00:00','2014-05-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2952633,'DE','Bargteheide','Bargteheide',53.7286,10.2669,'P','PPL','DE.10','DE.10.00',13640,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2952814,'DE','Bardowick','Bardowick',53.2935,10.3881,'P','PPLA4','DE.06','DE.06.00',6026,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2952916,'DE','Bannewitz','Bannewitz',50.9929,13.7171,'P','PPLA4','DE.13','DE.13.00',10851,'Europe/Berlin',1,'2014-01-01 23:00:00','2014-01-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2952973,'DE','Bammental','Bammental',49.3561,8.77944,'P','PPLA4','DE.01','DE.01.082',6493,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2952984,'DE','Bamberg','Bamberg',49.8987,10.9007,'P','PPLA3','DE.02','DE.02.094',70047,'Europe/Berlin',1,'2014-01-08 23:00:00','2014-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953003,'DE','Balve','Balve',51.3315,7.86424,'P','PPL','DE.07','DE.07.059',12281,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953008,'DE','Baltmannsweiler','Baltmannsweiler',48.7421,9.4494,'P','PPLA4','DE.01','DE.01.081',5584,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953060,'DE','Ballenstedt','Ballenstedt',51.719,11.2326,'P','PPL','DE.14','DE.14.00',8064,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953089,'DE','Balingen','Balingen',48.2752,8.85464,'P','PPLA3','DE.01','DE.01.084',34414,'Europe/Berlin',1,'2014-01-17 23:00:00','2014-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953136,'DE','Bakum','Bakum',52.7412,8.19546,'P','PPLA4','DE.06','DE.06.00',5678,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953194,'DE','Baiersdorf','Baiersdorf',49.6581,11.0359,'P','PPL','DE.02','DE.02.095',7071,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953197,'DE','Baiersbronn','Baiersbronn',48.5032,8.37699,'P','PPLA4','DE.01','DE.01.082',16248,'Europe/Berlin',1,'2013-04-01 23:00:00','2013-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953222,'DE','Baienfurt','Baienfurt',47.8286,9.65157,'P','PPLA4','DE.01','DE.01.084',7342,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953302,'DE','Baesweiler','Baesweiler',50.9096,6.18874,'P','PPL','DE.07','DE.07.053',27834,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953310,'DE','Bad Zwischenahn','Bad Zwischenahn',53.1833,8,'P','PPLA4','DE.06','DE.06.00',27550,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953312,'DE','Bad Wurzach','Bad Wurzach',47.908,9.89686,'P','PPL','DE.01','DE.01.084',14323,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953313,'DE','Bad Wörishofen','Bad Worishofen',48.0067,10.5967,'P','PPL','DE.02','DE.02.097',14028,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953314,'DE','Bad Windsheim','Bad Windsheim',49.5027,10.4154,'P','PPL','DE.02','DE.02.095',12022,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953315,'DE','Bad Wimpfen','Bad Wimpfen',49.2297,9.15648,'P','PPL','DE.01','DE.01.081',6968,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953317,'DE','Bad Wildungen','Bad Wildungen',51.1196,9.12475,'P','PPL','DE.05','DE.05.066',18037,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953320,'DE','Bad Waldsee','Bad Waldsee',47.9203,9.7549,'P','PPL','DE.01','DE.01.084',19840,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953321,'DE','Bad Vilbel','Bad Vilbel',50.1787,8.73756,'P','PPL','DE.05','DE.05.064',30736,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953324,'DE','Bad Tölz','Bad Toelz',47.7611,11.5589,'P','PPLA3','DE.02','DE.02.091',17434,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953336,'DE','Bad Sooden-Allendorf','Bad Sooden-Allendorf',51.2709,9.97483,'P','PPL','DE.05','DE.05.066',8915,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953338,'DE','Bad Soden-Salmünster','Bad Soden-Salmuenster',50.2757,9.36705,'P','PPL','DE.05','DE.05.064',13953,'Europe/Berlin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953339,'DE','Bad Soden am Taunus','Bad Soden am Taunus',50.1408,8.50449,'P','PPL','DE.05','DE.05.064',21357,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953341,'DE','Bad Segeberg','Bad Segeberg',53.9431,10.3021,'P','PPLA3','DE.10','DE.10.00',16052,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953347,'DE','Bad Schwartau','Bad Schwartau',53.9189,10.6969,'P','PPL','DE.10','DE.10.00',19722,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953348,'DE','Bad Schwalbach','Bad Schwalbach',50.142,8.06964,'P','PPLA3','DE.05','DE.05.064',11112,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953355,'DE','Bad Sassendorf','Bad Sassendorf',51.5833,8.16667,'P','PPLA4','DE.07','DE.07.059',11659,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953357,'DE','Bad Salzungen','Bad Salzungen',50.8134,10.2361,'P','PPLA3','DE.15','DE.15.00',16410,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953358,'DE','Bad Salzuflen','Bad Salzuflen',52.0862,8.74434,'P','PPL','DE.07','DE.07.057',54899,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953362,'DE','Bad Salzdetfurth','Bad Salzdetfurth',52.0578,10.0058,'P','PPL','DE.06','DE.06.00',14349,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953363,'DE','Bad Säckingen','Bad Sackingen',47.5537,7.94612,'P','PPL','DE.01','DE.01.083',16549,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953364,'DE','Bad Sachsa','Bad Sachsa',51.595,10.5555,'P','PPL','DE.06','DE.06.00',8244,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953367,'DE','Bad Rothenfelde','Bad Rothenfelde',52.1167,8.16667,'P','PPLA4','DE.06','DE.06.00',7299,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953371,'DE','Bad Reichenhall','Bad Reichenhall',47.7295,12.8782,'P','PPLA3','DE.02','DE.02.091',16910,'Europe/Berlin',1,'2014-01-08 23:00:00','2014-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953374,'DE','Bad Rappenau','Bad Rappenau',49.2385,9.1018,'P','PPL','DE.01','DE.01.081',20581,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953379,'DE','Bad Pyrmont','Bad Pyrmont',51.9859,9.25246,'P','PPL','DE.06','DE.06.00',21629,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953384,'DE','Bad Orb','Bad Orb',50.2279,9.34782,'P','PPL','DE.05','DE.05.064',10186,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953385,'DE','Bad Oldesloe','Bad Oldesloe',53.8117,10.3742,'P','PPLA3','DE.10','DE.10.00',24322,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953386,'DE','Bad Oeynhausen','Bad Oeynhausen',52.207,8.80365,'P','PPL','DE.07','DE.07.057',49513,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953389,'DE','Bad Neustadt an der Saale','Bad Neustadt an der Saale',50.3217,10.2067,'P','PPL','DE.02','DE.02.096',16064,'Europe/Berlin',1,'2017-09-21 23:00:00','2017-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953391,'DE','Bad Neuenahr-Ahrweiler','Bad Neuenahr-Ahrweiler',50.5432,7.1113,'P','PPLA3','DE.08','DE.08.00',27823,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953394,'DE','Bad Nenndorf','Bad Nenndorf',52.337,9.37904,'P','PPL','DE.06','DE.06.00',10255,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953395,'DE','Bad Nauheim','Bad Nauheim',50.3646,8.73859,'P','PPL','DE.05','DE.05.064',30291,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953398,'DE','Bad Münstereifel','Bad Muenstereifel',50.5567,6.76424,'P','PPL','DE.07','DE.07.053',19051,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953400,'DE','Bad Münder am Deister','Bad Muender am Deister',52.1955,9.46421,'P','PPL','DE.06','DE.06.00',18726,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953402,'DE','Bad Mergentheim','Bad Mergentheim',49.4925,9.77361,'P','PPL','DE.01','DE.01.081',22472,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953404,'DE','Bad Marienberg','Bad Marienberg',50.6495,7.94958,'P','PPL','DE.08','DE.08.00',5838,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953405,'DE','Bad Lippspringe','Bad Lippspringe',51.7833,8.81683,'P','PPL','DE.07','DE.07.057',15175,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953407,'DE','Bad Liebenzell','Bad Liebenzell',48.7743,8.72971,'P','PPL','DE.01','DE.01.082',9616,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953408,'DE','Bad Liebenwerda','Bad Liebenwerda',51.5183,13.3946,'P','PPL','DE.11','DE.11.00',10890,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953410,'DE','Bad Lauterberg im Harz','Bad Lauterberg im Harz',51.6327,10.4703,'P','PPL','DE.06','DE.06.00',11784,'Europe/Berlin',1,'2017-10-17 23:00:00','2017-10-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953411,'DE','Bad Lausick','Bad Lausick',51.145,12.6445,'P','PPL','DE.13','DE.13.00',9026,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953412,'DE','Bad Lauchstädt','Bad Lauchstaedt',51.3865,11.8696,'P','PPL','DE.14','DE.14.00',5018,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953413,'DE','Bad Langensalza','Bad Langensalza',51.1077,10.646,'P','PPL','DE.15','DE.15.00',18183,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953416,'DE','Bad Kreuznach','Bad Kreuznach',49.8414,7.86713,'P','PPLA3','DE.08','DE.08.00',43213,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953418,'DE','Bad Kösen','Bad Koesen',51.1343,11.722,'P','PPL','DE.14','DE.14.00',5522,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953419,'DE','Bad König','Bad Koenig',49.7432,9.0075,'P','PPL','DE.05','DE.05.064',9687,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953424,'DE','Bad Kissingen','Bad Kissingen',50.2023,10.0778,'P','PPLA3','DE.02','DE.02.096',21328,'Europe/Berlin',1,'2014-01-08 23:00:00','2014-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953430,'DE','Bad Iburg','Bad Iburg',52.1549,8.04216,'P','PPL','DE.06','DE.06.00',11554,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953434,'DE','Bad Hönningen','Bad Hoenningen',50.5169,7.31195,'P','PPL','DE.08','DE.08.00',5772,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953435,'DE','Bad Honnef','Bad Honnef',50.6434,7.2278,'P','PPL','DE.07','DE.07.053',25348,'Europe/Berlin',1,'2016-09-26 23:00:00','2016-09-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953436,'DE','Bad Homburg vor der Höhe','Bad Homburg vor der Hoehe',50.2268,8.61816,'P','PPLA3','DE.05','DE.05.064',51859,'Europe/Berlin',1,'2014-01-14 23:00:00','2014-01-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953439,'DE','Bad Hersfeld','Bad Hersfeld',50.872,9.70891,'P','PPLA3','DE.05','DE.05.066',30725,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953440,'DE','Bad Herrenalb','Bad Herrenalb',48.7979,8.43617,'P','PPL','DE.01','DE.01.082',7521,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953449,'DE','Bad Harzburg','Bad Harzburg',51.8827,10.5616,'P','PPL','DE.06','DE.06.00',22954,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953456,'DE','Bad Gandersheim','Bad Gandersheim',51.8717,10.0254,'P','PPL','DE.06','DE.06.00',11099,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953458,'DE','Bad Freienwalde','Bad Freienwalde',52.7873,14.0304,'P','PPL','DE.11','DE.11.00',13075,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953459,'DE','Bad Frankenhausen','Bad Frankenhausen',51.3561,11.0998,'P','PPL','DE.15','DE.15.00',8824,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953460,'DE','Bad Feilnbach','Bad Feilnbach',47.7733,12.0097,'P','PPLA4','DE.02','DE.02.091',7203,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953464,'DE','Bad Essen','Bad Essen',52.3167,8.33333,'P','PPLA4','DE.06','DE.06.00',15732,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953504,'DE','Baden-Baden','Baden-Baden',48.7606,8.23975,'P','PPL','DE.01','DE.01.082',54239,'Europe/Berlin',1,'2013-05-03 23:00:00','2013-05-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953507,'DE','Bad Ems','Bad Ems',50.3354,7.71369,'P','PPLA3','DE.08','DE.08.00',9735,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953520,'DE','Bad Dürrheim','Bad Durrheim',48.0209,8.53056,'P','PPL','DE.01','DE.01.083',12829,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953521,'DE','Bad Dürrenberg','Bad Duerrenberg',51.2954,12.0658,'P','PPL','DE.14','DE.14.00',11479,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953522,'DE','Bad Dürkheim','Bad Duerkheim',49.4618,8.17236,'P','PPLA3','DE.08','DE.08.00',18698,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953524,'DE','Bad Düben','Bad Dueben',51.5917,12.5849,'P','PPL','DE.13','DE.13.00',8998,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953525,'DE','Bad Driburg','Bad Driburg',51.733,9.01969,'P','PPL','DE.07','DE.07.057',19553,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953528,'DE','Bad Doberan','Bad Doberan',54.1071,11.9005,'P','PPL','DE.12','DE.12.00',11559,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953535,'DE','Bad Brückenau','Bad Bruckenau',50.3085,9.78985,'P','PPL','DE.02','DE.02.096',7304,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953536,'DE','Bad Breisig','Bad Breisig',50.5052,7.28861,'P','PPL','DE.08','DE.08.00',8959,'Europe/Berlin',1,'2017-09-19 23:00:00','2017-09-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953537,'DE','Bad Bramstedt','Bad Bramstedt',53.9183,9.88424,'P','PPL','DE.10','DE.10.00',13177,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953541,'DE','Bad Blankenburg','Bad Blankenburg',50.6819,11.2737,'P','PPL','DE.15','DE.15.00',7625,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953545,'DE','Bad Berleburg','Bad Berleburg',51.0522,8.39227,'P','PPL','DE.07','DE.07.059',20757,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953548,'DE','Bad Berka','Bad Berka',50.8998,11.2824,'P','PPL','DE.15','DE.15.00',7744,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953549,'DE','Bad Bergzabern','Bad Bergzabern',49.1025,8.00092,'P','PPL','DE.08','DE.08.00',7641,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953552,'DE','Bad Bentheim','Bad Bentheim',52.3007,7.15763,'P','PPL','DE.06','DE.06.00',15508,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953558,'DE','Bad Aibling','Bad Aibling',47.8638,12.0105,'P','PPL','DE.02','DE.02.091',17672,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953559,'DE','Bad Abbach','Bad Abbach',48.9375,12.0449,'P','PPL','DE.02','DE.02.092',10882,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953568,'DE','Backnang','Backnang',48.9474,9.43718,'P','PPL','DE.01','DE.01.081',35778,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953770,'DE','Babenhausen','Babenhausen',49.9652,8.95129,'P','PPL','DE.05','DE.05.064',16575,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2953771,'DE','Babenhausen','Babenhausen',48.145,10.2533,'P','PPL','DE.02','DE.02.097',5342,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2954006,'DE','Aurich','Aurich',53.4692,7.48232,'P','PPLA3','DE.06','DE.06.00',40319,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2954065,'DE','Aulendorf','Aulendorf',47.9508,9.63745,'P','PPL','DE.01','DE.01.084',10063,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2954088,'DE','Au in der Hallertau','Au in der Hallertau',48.5584,11.7414,'P','PPL','DE.02','DE.02.091',5427,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2954127,'DE','Augustusburg','Augustusburg',50.8119,13.102,'P','PPL','DE.13','DE.13.00',5202,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2954164,'DE','Augustdorf','Augustdorf',51.9094,8.73173,'P','PPLA4','DE.07','DE.07.057',9889,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2954172,'DE','Augsburg','Augsburg',48.3715,10.8985,'P','PPLA2','DE.02','DE.02.097',259196,'Europe/Berlin',1,'2016-02-11 23:00:00','2016-02-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2954602,'DE','Auerbach','Auerbach',50.5116,12.4008,'P','PPL','DE.13','DE.13.00',21358,'Europe/Berlin',1,'2017-09-18 23:00:00','2017-09-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2954603,'DE','Auerbach','Auerbach',49.692,11.6333,'P','PPL','DE.02','DE.02.093',9089,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2954695,'DE','Aue','Aue',50.5903,12.7066,'P','PPL','DE.13','DE.13.00',18554,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2954932,'DE','Attendorn','Attendorn',51.1264,7.90333,'P','PPL','DE.07','DE.07.059',24773,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955009,'DE','Aßlar','Asslar',50.5916,8.46273,'P','PPL','DE.05','DE.05.065',13772,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955068,'DE','Asperg','Asperg',48.9053,9.13502,'P','PPL','DE.01','DE.01.081',12870,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955159,'DE','Aschheim','Aschheim',48.1711,11.7168,'P','PPLA4','DE.02','DE.02.091',6531,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955168,'DE','Aschersleben','Aschersleben',51.7574,11.4608,'P','PPL','DE.14','DE.14.00',24892,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955224,'DE','Ascheberg','Ascheberg',51.7833,7.61667,'P','PPLA4','DE.07','DE.07.055',15184,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955272,'DE','Aschaffenburg','Aschaffenburg',49.977,9.15214,'P','PPLA3','DE.02','DE.02.096',68551,'Europe/Berlin',1,'2017-08-01 23:00:00','2017-08-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955315,'DE','Asbach','Asbach',50.6667,7.41667,'P','PPLA4','DE.08','DE.08.00',7060,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955368,'DE','Arzberg','Arzberg',50.0577,12.1868,'P','PPL','DE.02','DE.02.094',6075,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955394,'DE','Artern','Artern',51.3643,11.2917,'P','PPL','DE.15','DE.15.00',6270,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955421,'DE','Bad Arolsen','Bad Arolsen',51.3798,9.01445,'P','PPL','DE.05','DE.05.066',16854,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955429,'DE','Arnstorf','Arnstorf',48.5584,12.8167,'P','PPL','DE.02','DE.02.092',6570,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955431,'DE','Arnstein','Arnstein',49.9777,9.96983,'P','PPL','DE.02','DE.02.096',8409,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955439,'DE','Arnstadt','Arnstadt',50.8405,10.952,'P','PPLA3','DE.15','DE.15.00',25678,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955471,'DE','Arnsberg','Arnsberg',51.3833,8.08333,'P','PPLA2','DE.07','DE.07.059',76612,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955745,'DE','Appen','Appen',53.6581,9.74582,'P','PPLA4','DE.10','DE.10.00',5838,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955770,'DE','Apolda','Apolda',51.0262,11.5164,'P','PPLA3','DE.15','DE.15.00',24793,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955817,'DE','Apen','Apen',53.2167,7.8,'P','PPLA4','DE.06','DE.06.00',10992,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955936,'DE','Ansbach','Ansbach',49.3048,10.5931,'P','PPLA2','DE.02','DE.02.095',31839,'Europe/Berlin',1,'2014-02-07 23:00:00','2014-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955940,'DE','Anröchte','Anroechte',51.5667,8.33333,'P','PPLA4','DE.07','DE.07.059',10847,'Europe/Berlin',1,'2015-05-21 23:00:00','2015-05-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2955951,'DE','Annweiler am Trifels','Annweiler am Trifels',49.2061,7.97527,'P','PPL','DE.08','DE.08.00',7316,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2956005,'DE','Annaberg-Buchholz','Annaberg-Buchholz',50.5795,13.0063,'P','PPLA3','DE.13','DE.13.00',23092,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2956014,'DE','Ankum','Ankum',52.55,7.88333,'P','PPLA4','DE.06','DE.06.00',7186,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2956018,'DE','Anklam','Anklam',53.8564,13.6896,'P','PPL','DE.12','DE.12.00',14694,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2956093,'DE','Angermünde','Angermuende',53.015,13.9992,'P','PPL','DE.11','DE.11.00',15453,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2956206,'DE','Andernach','Andernach',50.4311,7.40425,'P','PPL','DE.08','DE.08.00',29599,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2956378,'DE','Ampfing','Ampfing',48.254,12.4151,'P','PPLA4','DE.02','DE.02.091',6188,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2956404,'DE','Amöneburg','Amoeneburg',50.796,8.9233,'P','PPL','DE.05','DE.05.065',5390,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2956656,'DE','Amberg','Amberg',49.4429,11.8627,'P','PPLA3','DE.02','DE.02.093',44737,'Europe/Berlin',1,'2014-01-08 23:00:00','2014-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2956710,'DE','Alzey','Alzey',49.7466,8.11513,'P','PPLA3','DE.08','DE.08.00',18241,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2956715,'DE','Alzenau in Unterfranken','Alzenau in Unterfranken',50.0888,9.06455,'P','PPL','DE.02','DE.02.096',18932,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2956787,'DE','Altusried','Altusried',47.8041,10.2143,'P','PPL','DE.02','DE.02.097',9950,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2956891,'DE','Altrip','Altrip',49.4356,8.49472,'P','PPLA4','DE.08','DE.08.00',7802,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2956940,'DE','Altötting','Altoetting',48.2253,12.6767,'P','PPLA3','DE.02','DE.02.091',12902,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2956951,'DE','Altomünster','Altomunster',48.3877,11.2569,'P','PPL','DE.02','DE.02.091',7275,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2957021,'DE','Altlußheim','Altlussheim',49.3017,8.49917,'P','PPLA4','DE.01','DE.01.082',5289,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2957051,'DE','Altlandsberg','Altlandsberg',52.565,13.7282,'P','PPL','DE.11','DE.11.00',8804,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2957133,'DE','Althengstett','Althengstett',48.7233,8.79434,'P','PPLA4','DE.01','DE.01.082',8201,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2957185,'DE','Altglienicke','Altglienicke',52.4112,13.5355,'P','PPLX','DE.16','DE.16.00',26426,'Europe/Berlin',1,'2012-06-08 23:00:00','2012-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2957437,'DE','Altentreptow','Altentreptow',53.6942,13.265,'P','PPL','DE.12','DE.12.00',6486,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2957459,'DE','Altensteig','Altensteig',48.5865,8.60395,'P','PPL','DE.01','DE.01.082',11266,'Europe/Berlin',1,'2013-02-14 23:00:00','2013-02-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2957463,'DE','Altenstadt','Altenstadt',50.2875,8.94373,'P','PPLA4','DE.05','DE.05.064',12258,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2957555,'DE','Altenkunstadt','Altenkunstadt',50.125,11.2503,'P','PPLA4','DE.02','DE.02.094',5608,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2957567,'DE','Altenkirchen','Altenkirchen',50.6859,7.64176,'P','PPLA3','DE.08','DE.08.00',6385,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2957588,'DE','Altenholz','Altenholz',54.4,10.1333,'P','PPLA4','DE.10','DE.10.00',9737,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2957773,'DE','Altenburg','Altenburg',50.9876,12.4368,'P','PPLA3','DE.15','DE.15.00',38568,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2957829,'DE','Altenberge','Altenberge',52.05,7.46667,'P','PPLA4','DE.07','DE.07.055',9796,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2957834,'DE','Altenberg','Altenberg',50.7656,13.7533,'P','PPL','DE.13','DE.13.00',5167,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2957864,'DE','Altenbeken','Altenbeken',51.7645,8.94201,'P','PPLA4','DE.07','DE.07.057',9716,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2957886,'DE','Altena','Altena',51.2947,7.67337,'P','PPL','DE.07','DE.07.059',20862,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958024,'DE','Altdorf','Altdorf',49.3856,11.3573,'P','PPL','DE.02','DE.02.095',15312,'Europe/Berlin',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958032,'DE','Altdorf','Altdorf',48.1537,12.1842,'P','PPL','DE.02','DE.02.091',11355,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958085,'DE','Altbach','Altbach',48.7227,9.38078,'P','PPLA4','DE.01','DE.01.081',5793,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958105,'DE','Alsterdorf','Alsterdorf',53.6108,10.0131,'P','PPLX','DE.04','DE.04.00',13271,'Europe/Berlin',1,'2017-08-13 23:00:00','2017-08-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958128,'DE','Alsfeld','Alsfeld',50.7519,9.27082,'P','PPL','DE.05','DE.05.065',17771,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958141,'DE','Alsdorf','Alsdorf',50.8767,6.16399,'P','PPL','DE.07','DE.07.053',46340,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958173,'DE','Alpirsbach','Alpirsbach',48.3451,8.40197,'P','PPL','DE.01','DE.01.082',7011,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958188,'DE','Alpen','Alpen',51.5833,6.51667,'P','PPLA4','DE.07','DE.07.051',12908,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958391,'DE','Allersberg','Allersberg',49.2513,11.2366,'P','PPL','DE.02','DE.02.095',8054,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958429,'DE','Allensbach','Allensbach',47.7154,9.07145,'P','PPLA4','DE.01','DE.01.083',7053,'Europe/Berlin',1,'2011-09-24 23:00:00','2011-09-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958438,'DE','Allendorf','Allendorf',51.0299,8.67232,'P','PPL','DE.05','DE.05.066',5719,'Europe/Berlin',1,'2016-09-25 23:00:00','2016-09-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958494,'DE','Alheim','Alheim',51.0333,9.66667,'P','PPLA4','DE.05','DE.05.066',5292,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958509,'DE','Algermissen','Algermissen',52.2533,9.96915,'P','PPLA4','DE.06','DE.06.00',8280,'Europe/Berlin',1,'2014-07-21 23:00:00','2014-07-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958516,'DE','Alfter','Alfter',50.7333,7.01667,'P','PPLA4','DE.07','DE.07.053',21814,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958533,'DE','Alfeld','Alfeld',51.9838,9.81989,'P','PPLA4','DE.06','DE.06.00',19138,'Europe/Berlin',1,'2014-07-21 23:00:00','2014-07-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958535,'DE','Alfdorf','Alfdorf',48.8438,9.71857,'P','PPLA4','DE.01','DE.01.081',7187,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958575,'DE','Aldingen','Aldingen',48.1,8.7,'P','PPLA4','DE.01','DE.01.083',7589,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958580,'DE','Aldenhoven','Aldenhoven',50.9,6.28333,'P','PPLA4','DE.07','DE.07.053',7364,'Europe/Berlin',1,'2013-05-02 23:00:00','2013-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958595,'DE','Albstadt','Albstadt',48.2164,9.02596,'P','PPL','DE.01','DE.01.084',46664,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958744,'DE','Albbruck','Albbruck',47.5908,8.12954,'P','PPLA4','DE.01','DE.01.083',7372,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958781,'DE','Aken','Aken',51.8527,12.0446,'P','PPL','DE.14','DE.14.00',9240,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958831,'DE','Ainring','Ainring',47.8131,12.9405,'P','PPLA4','DE.02','DE.02.091',10028,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958904,'DE','Aidlingen','Aidlingen',48.6785,8.89524,'P','PPLA4','DE.01','DE.01.081',9285,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2958975,'DE','Aichach','Aichach',48.4576,11.1341,'P','PPLA3','DE.02','DE.02.097',21042,'Europe/Berlin',1,'2017-05-07 23:00:00','2017-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959083,'DE','Ahrensburg','Ahrensburg',53.6752,10.2259,'P','PPL','DE.10','DE.10.00',30103,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959084,'DE','Ahrensbök','Ahrensbok',54.0086,10.5743,'P','PPLA4','DE.10','DE.10.00',8643,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959205,'DE','Ahlerstedt','Ahlerstedt',53.4,9.45,'P','PPLA4','DE.06','DE.06.00',5063,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959223,'DE','Ahlen','Ahlen',51.7634,7.8887,'P','PPL','DE.07','DE.07.055',55280,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959279,'DE','Ahaus','Ahaus',52.0794,7.01344,'P','PPL','DE.07','DE.07.055',38165,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959343,'DE','Affing','Affing',48.4667,10.9833,'P','PPLA4','DE.02','DE.02.097',5171,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959374,'DE','Aerzen','Aerzen',52.0495,9.25856,'P','PPLA4','DE.06','DE.06.00',10755,'Europe/Berlin',1,'2014-07-10 23:00:00','2014-07-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959390,'DE','Adorf','Adorf',50.3201,12.2599,'P','PPL','DE.13','DE.13.00',5806,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959441,'DE','Adlershof','Adlershof',52.4355,13.5483,'P','PPLX','DE.16','DE.16.00',15294,'Europe/Berlin',1,'2017-09-18 23:00:00','2017-09-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959479,'DE','Adendorf','Adendorf',53.2819,10.4379,'P','PPLA4','DE.06','DE.06.00',9865,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959508,'DE','Adelsheim','Adelsheim',49.4015,9.3925,'P','PPL','DE.01','DE.01.082',5536,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959514,'DE','Adelsdorf','Adelsdorf',49.4702,10.6852,'P','PPL','DE.02','DE.02.095',7245,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959548,'DE','Adelebsen','Adelebsen',51.5827,9.75461,'P','PPLA4','DE.06','DE.06.00',6541,'Europe/Berlin',1,'2014-07-10 23:00:00','2014-07-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959681,'DE','Achim','Achim',53.0142,9.0263,'P','PPL','DE.06','DE.06.00',30013,'Europe/Berlin',1,'2011-03-14 23:00:00','2011-03-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959686,'DE','Achern','Achern',48.6311,8.07607,'P','PPL','DE.01','DE.01.083',24478,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959766,'DE','Abtsgmünd','Abtsgmund',48.895,10.0017,'P','PPLA4','DE.01','DE.01.081',7381,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959842,'DE','Abensberg','Abensberg',48.8168,11.8498,'P','PPL','DE.02','DE.02.092',12570,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959855,'DE','Abenberg','Abenberg',49.2428,10.964,'P','PPL','DE.02','DE.02.095',5484,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2959927,'DE','Aalen','Aalen',48.8378,10.0933,'P','PPLA3','DE.01','DE.01.081',67085,'Europe/Berlin',1,'2014-05-08 23:00:00','2014-05-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3205535,'DE','Höhenkirchen-Siegertsbrunn','Hohenkirchen-Siegertsbrunn',48.0193,11.7191,'P','PPLA4','DE.02','DE.02.091',9465,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3205641,'DE','Weiler-Simmerberg','Weiler-Simmerberg',47.5826,9.91352,'P','PPL','DE.02','DE.02.097',6510,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3205666,'DE','Lauchringen','Lauchringen',47.627,8.31442,'P','PPLA4','DE.01','DE.01.083',7416,'Europe/Berlin',1,'2011-07-17 23:00:00','2011-07-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3205690,'DE','Uhldingen-Mühlhofen','Uhldingen-Muhlhofen',47.7333,9.25,'P','PPLA4','DE.01','DE.01.084',8013,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3205691,'DE','Ühlingen-Birkendorf','Uhlingen-Birkendorf',47.7167,8.31667,'P','PPLA4','DE.01','DE.01.083',5269,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3206149,'DE','Altes Lager','Altes Lager',48.4175,9.53606,'P','PPL','DE.01','DE.01.084',14092,'Europe/Berlin',1,'2017-11-28 23:00:00','2017-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3206150,'DE','Aspach','Aspach',48.9667,9.4,'P','PPLA4','DE.01','DE.01.081',8131,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3206188,'DE','Königsbach-Stein','Konigsbach-Stein',48.9659,8.60573,'P','PPLA4','DE.01','DE.01.082',9906,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3206254,'DE','Niefern-Öschelbronn','Niefern-Oschelbronn',48.9167,8.78333,'P','PPLA4','DE.01','DE.01.082',12341,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3206285,'DE','Urbach','Urbach',48.8168,9.5769,'P','PPLA4','DE.01','DE.01.081',8593,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3206402,'DE','Giesen','Giesen',52.1972,9.8989,'P','PPLA4','DE.06','DE.06.00',9909,'Europe/Berlin',1,'2014-07-01 23:00:00','2014-07-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3206682,'DE','Mallersdorf-Pfaffenberg','Mallersdorf-Pfaffenberg',48.7664,12.231,'P','PPL','DE.02','DE.02.092',6742,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3206934,'DE','Postbauer-Heng','Postbauer-Heng',49.3053,11.3572,'P','PPLA4','DE.02','DE.02.093',7358,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3207077,'DE','Katlenburg-Lindau','Katlenburg-Lindau',51.6833,10.1,'P','PPLA4','DE.06','DE.06.00',7581,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3207197,'DE','Vellmar','Vellmar',51.3581,9.47974,'P','PPL','DE.05','DE.05.066',18623,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3207377,'DE','Möhnesee','Mohnesee',51.5,8.13333,'P','PPLA4','DE.07','DE.07.059',11559,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3207383,'DE','Schieder-Schwalenberg','Schieder-Schwalenberg',51.8771,9.19538,'P','PPL','DE.07','DE.07.057',9443,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3207410,'DE','Rödental','Rodental',50.2952,11.0412,'P','PPL','DE.02','DE.02.094',13712,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3207512,'DE','Bruchmühlbach-Miesau','Bruchmuhlbach-Miesau',49.3833,7.43333,'P','PPLA4','DE.08','DE.08.00',7800,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3207540,'DE','Schönenberg-Kübelberg','Schoenenberg-Kuebelberg',49.4074,7.37233,'P','PPLA4','DE.08','DE.08.00',5957,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3207806,'DE','Mülheim-Kärlich','Muelheim-Kaerlich',50.3851,7.4989,'P','PPL','DE.08','DE.08.00',10451,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3208053,'DE','Florstadt','Florstadt',50.3167,8.86667,'P','PPLA4','DE.05','DE.05.064',8905,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3208086,'DE','Liederbach','Liederbach',50.1222,8.49397,'P','PPL','DE.05','DE.05.064',8602,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3208118,'DE','Schöffengrund','Schoeffengrund',50.4935,8.47183,'P','PPLA4','DE.05','DE.05.065',6316,'Europe/Berlin',1,'2015-08-31 23:00:00','2015-08-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3208129,'DE','Waldbrunn','Waldbrunn',50.5187,8.10812,'P','PPL','DE.05','DE.05.065',6124,'Europe/Berlin',1,'2017-09-19 23:00:00','2017-09-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3208130,'DE','Waldems','Waldems',50.25,8.33333,'P','PPLA4','DE.05','DE.05.064',5782,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3208134,'DE','Walluf','Walluf',50.04,8.15545,'P','PPLA4','DE.05','DE.05.064',5698,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3208571,'DE','Sylt-Ost','Sylt-Ost',54.8611,8.41141,'P','PPL','DE.10','DE.10.00',5806,'Europe/Berlin',1,'2012-04-28 23:00:00','2012-04-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3208606,'DE','Ilsede','Ilsede',52.2634,10.1992,'P','PPLA4','DE.06','DE.06.00',12241,'Europe/Berlin',1,'2016-03-09 23:00:00','2016-03-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3208618,'DE','Sassenburg','Sassenburg',52.5167,10.6333,'P','PPLA4','DE.06','DE.06.00',10982,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3208620,'DE','Sickte','Sickte',52.2185,10.6424,'P','PPLA4','DE.06','DE.06.00',5755,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3209001,'DE','Ebersbach','Ebersbach',51.2333,13.65,'P','PPLA4','DE.13','DE.13.00',5077,'Europe/Berlin',1,'2014-01-01 23:00:00','2014-01-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3209083,'DE','Henstedt-Ulzburg','Henstedt-Ulzburg',53.805,9.97452,'P','PPLA4','DE.10','DE.10.00',26083,'Europe/Berlin',1,'2017-04-25 23:00:00','2017-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3209262,'DE','Rheinau','Rheinau',48.666,7.93659,'P','PPL','DE.01','DE.01.083',10997,'Europe/Berlin',1,'2015-02-08 23:00:00','2015-02-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3209418,'DE','Reichenau','Reichenau',47.6889,9.06355,'P','PPLA4','DE.01','DE.01.083',5144,'Europe/Berlin',1,'2017-06-30 23:00:00','2017-06-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3209420,'DE','Vogtsburg','Vogtsburg',48.0969,7.64185,'P','PPL','DE.01','DE.01.083',5686,'Europe/Berlin',1,'2017-12-18 23:00:00','2017-12-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3209911,'DE','Burg Hohenstein','Burg Hohenstein',50.1919,8.05732,'P','PPL','DE.05','DE.05.064',6256,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3225108,'DE','Ransbach-Baumbach','Ransbach-Baumbach',50.465,7.7283,'P','PPL','DE.08','DE.08.00',7327,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3225156,'DE','Ludweiler-Warndt','Ludweiler-Warndt',49.2207,6.81195,'P','PPLA4','DE.09','DE.09.00',5922,'Europe/Berlin',1,'2016-01-01 23:00:00','2016-01-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3247449,'DE','Aachen','Aachen',50.7766,6.08342,'P','PPLA3','DE.07','DE.07.053',265208,'Europe/Berlin',1,'2014-05-10 23:00:00','2014-05-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3272450,'DE','Ubstadt-Weiher','Ubstadt-Weiher',49.163,8.63165,'P','PPLA4','DE.01','DE.01.082',12730,'Europe/Berlin',1,'2013-04-09 23:00:00','2013-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3272455,'DE','Dannstadt-Schauernheim','Dannstadt-Schauernheim',49.4403,8.30861,'P','PPLA4','DE.08','DE.08.00',7228,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3272456,'DE','Sankt Leon-Rot','Sankt Leon-Rot',49.2659,8.61803,'P','PPL','DE.01','DE.01.082',12192,'Europe/Berlin',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3272458,'DE','Karlsdorf-Neuthard','Karlsdorf-Neuthard',49.1347,8.53028,'P','PPLA4','DE.01','DE.01.082',9329,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3272459,'DE','Graben-Neudorf','Graben-Neudorf',49.167,8.49243,'P','PPLA4','DE.01','DE.01.082',11697,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3272460,'DE','Mörfelden-Walldorf','Moerfelden-Walldorf',49.9947,8.58361,'P','PPL','DE.05','DE.05.064',32753,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3272461,'DE','Linkenheim-Hochstetten','Linkenheim-Hochstetten',49.132,8.41244,'P','PPLA4','DE.01','DE.01.082',11599,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3272463,'DE','Böhl-Iggelheim','Bohl-Iggelheim',49.3806,8.30389,'P','PPLA4','DE.08','DE.08.00',10797,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3272934,'DE','Alsbach-Hähnlein','Alsbach-Hahnlein',49.7386,8.59583,'P','PPLA4','DE.05','DE.05.064',9300,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3272941,'DE','Riedstadt','Riedstadt',49.8341,8.49621,'P','PPL','DE.05','DE.05.064',21362,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3274259,'DE','Leingarten','Leingarten',49.1464,9.11694,'P','PPLA4','DE.01','DE.01.081',10579,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3274966,'DE','Lauda-Königshofen','Lauda-Konigshofen',49.5653,9.70816,'P','PPL','DE.01','DE.01.081',15278,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3336891,'DE','Filderstadt','Filderstadt',48.657,9.22049,'P','PPLA4','DE.01','DE.01.081',43550,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3336892,'DE','Ostfildern','Ostfildern',48.727,9.24954,'P','PPLA4','DE.01','DE.01.081',33598,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3336893,'DE','Rodgau','Rodgau',50.0263,8.88588,'P','PPLA4','DE.05','DE.05.064',43315,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3336894,'DE','Butjadingen','Butjadingen',53.5472,8.335,'P','PPLA4','DE.06','DE.06.00',6597,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3336895,'DE','Kaufungen','Kaufungen',51.2811,9.61861,'P','PPLA4','DE.05','DE.05.066',12683,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3336896,'DE','Jettingen-Scheppach','Jettingen-Scheppach',48.3896,10.4381,'P','PPL','DE.02','DE.02.097',6865,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3337408,'DE','Gropiusstadt','Gropiusstadt',52.425,13.4667,'P','PPLX','DE.16','DE.16.00',36052,'Europe/Berlin',1,'2012-06-08 23:00:00','2012-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3337504,'DE','Seeheim-Jugenheim','Seeheim-Jugenheim',49.765,8.65194,'P','PPLA4','DE.05','DE.05.064',16395,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6545288,'DE','Charlottenburg-Nord','Charlottenburg-Nord',52.5305,13.2937,'P','PPLX','DE.16','DE.16.00',17942,'Europe/Berlin',1,'2012-06-08 23:00:00','2012-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6545310,'DE','Mitte','Mitte',52.52,13.4049,'P','PPLX','DE.16','DE.16.00',81205,'Europe/Berlin',1,'2017-05-09 23:00:00','2017-05-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6545311,'DE','Plänterwald','Plaenterwald',52.4811,13.4728,'P','PPLX','DE.16','DE.16.00',10754,'Europe/Berlin',1,'2012-06-08 23:00:00','2012-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6547590,'DE','Dallgow-Döberitz','Dallgow-Doeberitz',52.5427,13.0584,'P','PPL','DE.11','DE.11.00',7439,'Europe/Berlin',1,'2015-03-03 23:00:00','2015-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6558039,'DE','Rheinstetten','Rheinstetten',48.9685,8.30704,'P','PPL','DE.01','DE.01.082',20378,'Europe/Berlin',1,'2010-11-14 23:00:00','2010-11-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6559224,'DE','Münstertal/Schwarzwald','Muenstertal/Schwarzwald',47.8547,7.78417,'P','PPL','DE.01','DE.01.083',5199,'Europe/Berlin',1,'2017-09-21 23:00:00','2017-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6639586,'DE','Salem','Salem',47.7626,9.29031,'P','PPLA4','DE.01','DE.01.084',11164,'Europe/Berlin',1,'2013-08-30 23:00:00','2013-08-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6691072,'DE','Altstadt Sud','Altstadt Sud',50.9333,6.95954,'P','PPLX','DE.07','DE.07.053',27515,'Europe/Berlin',1,'2013-08-02 23:00:00','2013-08-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6691073,'DE','Altstadt Nord','Altstadt Nord',50.9389,6.95752,'P','PPLX','DE.07','DE.07.053',17922,'Europe/Berlin',1,'2013-08-02 23:00:00','2013-08-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6691076,'DE','Neuehrenfeld','Neuehrenfeld',50.9575,6.93611,'P','PPLX','DE.07','DE.07.053',23621,'Europe/Berlin',1,'2015-03-18 23:00:00','2015-03-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6691078,'DE','Bilderstoeckchen','Bilderstoeckchen',50.9698,6.92997,'P','PPLX','DE.07','DE.07.053',15430,'Europe/Berlin',1,'2017-07-24 23:00:00','2017-07-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6691734,'DE','Kloster Lehnin','Kloster Lehnin',52.3204,12.7432,'P','PPLS','DE.11','DE.11.00',10669,'Europe/Berlin',1,'2015-09-05 23:00:00','2015-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6694210,'DE','Neunkirchen am Brand','Neunkirchen am Brand',49.612,11.1297,'P','PPL','DE.02','DE.02.094',8243,'Europe/Berlin',1,'2013-02-18 23:00:00','2013-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6694704,'DE','Rothenburgsort','Rothenburgsort',53.535,10.0408,'P','PPLX','DE.04','DE.04.00',8938,'Europe/Berlin',1,'2017-08-13 23:00:00','2017-08-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6930414,'DE','Stuttgart-Ost','Stuttgart-Ost',48.7836,9.21032,'P','PPLX','DE.01','DE.01.081',47500,'Europe/Berlin',1,'2018-01-14 23:00:00','2018-01-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6941055,'DE','Bochum-Hordel','Bochum-Hordel',51.5017,7.1756,'P','PPLX','DE.07','DE.07.059',380000,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6944296,'DE','St. Pauli','St. Pauli',53.557,9.964,'P','PPLX','DE.04','DE.04.00',27612,'Europe/Berlin',1,'2017-08-13 23:00:00','2017-08-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7117230,'DE','Schwanau','Schwanau',48.3667,7.76244,'P','PPLA4','DE.01','DE.01.083',6858,'Europe/Berlin',1,'2011-07-30 23:00:00','2011-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7274677,'DE','Eidelstedt','Eidelstedt',53.607,9.90538,'P','PPLX','DE.04','DE.04.00',30100,'Europe/Berlin',1,'2017-08-13 23:00:00','2017-08-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7284168,'DE','Paulsstadt','Paulsstadt',53.6328,11.4037,'P','PPLX','DE.12','DE.12.00',8299,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7284171,'DE','Weststadt','Weststadt',53.6347,11.3956,'P','PPLX','DE.12','DE.12.00',12141,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7284571,'DE','Eisleben Lutherstadt','Eisleben Lutherstadt',51.5275,11.5484,'P','PPL','DE.14','DE.14.00',24346,'Europe/Berlin',1,'2016-07-05 23:00:00','2016-07-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7289614,'DE','Halle Neustadt','Halle Neustadt',51.4792,11.916,'P','PPL','DE.14','DE.14.00',44515,'Europe/Berlin',1,'2016-07-05 23:00:00','2016-07-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7290243,'DE','Bergedorf','Bergedorf',53.4846,10.229,'P','PPLX','DE.04','DE.04.00',119665,'Europe/Berlin',1,'2017-08-13 23:00:00','2017-08-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7290252,'DE','Spandau','Spandau',52.5511,13.1992,'P','PPLX','DE.16','DE.16.00',34506,'Europe/Berlin',1,'2017-09-18 23:00:00','2017-09-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7290254,'DE','Berlin Schöneberg','Berlin Schoeneberg',52.4839,13.3477,'P','PPLX','DE.16','DE.16.00',116286,'Europe/Berlin',1,'2012-08-27 23:00:00','2012-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7290255,'DE','Berlin Treptow','Berlin Treptow',52.4938,13.4447,'P','PPLX','DE.16','DE.16.00',50000,'Europe/Berlin',1,'2012-06-07 23:00:00','2012-06-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7290401,'DE','Niederrad','Niederrad',50.0831,8.62852,'P','PPLX','DE.05','DE.05.064',22370,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7302786,'DE','Haselbachtal','Haselbachtal',51.2357,14.0258,'P','PPLG','DE.13','DE.13.00',0,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7576812,'DE','Rabenau','Rabenau',50.6775,8.86425,'P','PPLA4','DE.05','DE.05.065',5239,'Europe/Berlin',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7732633,'DE','Garbsen-Mitte','Garbsen-Mitte',52.4266,9.60383,'P','PPLA4','DE.06','DE.06.00',7500,'Europe/Berlin',1,'2014-07-08 23:00:00','2014-07-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7932342,'DE','Barmbek-Nord','Barmbek-Nord',53.6052,10.0399,'P','PPLX','DE.04','DE.04.00',40261,'Europe/Berlin',1,'2017-08-13 23:00:00','2017-08-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7932386,'DE','Farmsen-Berne','Farmsen-Berne',53.6064,10.1197,'P','PPLX','DE.04','DE.04.00',33315,'Europe/Berlin',1,'2017-08-13 23:00:00','2017-08-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8051091,'DE','Fehmarn','Fehmarn',54.4378,11.1935,'P','PPL','DE.10','DE.10.00',12942,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8334620,'DE','Hansaviertel','Hansaviertel',52.5185,13.3418,'P','PPLX','DE.16','DE.16.00',5629,'Europe/Berlin',1,'2012-06-08 23:00:00','2012-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8334621,'DE','Falkenhagener Feld','Falkenhagener Feld',52.5519,13.168,'P','PPLX','DE.16','DE.16.00',35742,'Europe/Berlin',1,'2012-06-08 23:00:00','2012-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8334622,'DE','Neu-Hohenschönhausen','Neu-Hohenschoenhausen',52.5668,13.5126,'P','PPLX','DE.16','DE.16.00',53374,'Europe/Berlin',1,'2012-06-08 23:00:00','2012-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8334623,'DE','Waidmannslust','Waidmannslust',52.6069,13.3197,'P','PPLX','DE.16','DE.16.00',9715,'Europe/Berlin',1,'2012-06-08 23:00:00','2012-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8334624,'DE','Alt-Hohenschönhausen','Alt-Hohenschoenhausen',52.5461,13.5013,'P','PPLX','DE.16','DE.16.00',42609,'Europe/Berlin',1,'2012-06-08 23:00:00','2012-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8334625,'DE','Fennpfuhl','Fennpfuhl',52.5292,13.4727,'P','PPLX','DE.16','DE.16.00',31529,'Europe/Berlin',1,'2012-06-08 23:00:00','2012-06-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8354429,'DE','Neustadt an der Orla','Neustadt an der Orla',50.7364,11.7462,'P','PPL','DE.15','DE.15.00',7282,'Europe/Berlin',1,'2017-06-29 23:00:00','2017-06-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8354626,'DE','Hamburg-Nord','Hamburg-Nord',53.5894,9.984,'P','PPLX','DE.04','DE.04.00',280000,'Europe/Berlin',1,'2017-08-13 23:00:00','2017-08-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8378906,'DE','Burg Unter-Falkenstein','Burg Unter-Falkenstein',47.7044,12.1047,'P','PPLG','DE.02','DE.02.091',0,'Europe/Berlin',1,'2012-08-23 23:00:00','2012-08-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8593855,'DE','Neustadt/Nord','Neustadt/Nord',50.949,6.9479,'P','PPLX','DE.07','DE.07.053',28146,'Europe/Berlin',1,'2015-03-18 23:00:00','2015-03-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8593856,'DE','Neustadt/Süd','Neustadt/Sued',50.9251,6.94762,'P','PPLX','DE.07','DE.07.053',37939,'Europe/Berlin',1,'2015-03-18 23:00:00','2015-03-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8593860,'DE','Buchforst','Buchforst',50.9509,7.00579,'P','PPLX','DE.07','DE.07.053',7177,'Europe/Berlin',1,'2015-03-18 23:00:00','2015-03-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8593861,'DE','Kalk','Kalk',50.9401,7.00605,'P','PPLX','DE.07','DE.07.053',22802,'Europe/Berlin',1,'2015-03-18 23:00:00','2015-03-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8593865,'DE','Mülheim','Muelheim',50.9664,7.00384,'P','PPLX','DE.07','DE.07.053',41711,'Europe/Berlin',1,'2015-03-18 23:00:00','2015-03-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8642860,'DE','Gartenstadt','Gartenstadt',49.4594,8.40377,'P','PPLX','DE.08','DE.08.00',17745,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8642861,'DE','Lachen-Speyerdorf','Lachen-Speyerdorf',49.3305,8.19983,'P','PPL','DE.08','DE.08.00',5470,'Europe/Berlin',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8739828,'DE','Osternienburger Land','Osternienburger Land',51.8,12.0167,'P','PPLA4','DE.14','DE.14.00',9115,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (9072532,'DE','Auf der Horst','Auf der Horst',52.4194,9.60248,'P','PPLX','DE.06','DE.06.00',7050,'Europe/Berlin',1,'2014-07-08 23:00:00','2014-07-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (9222696,'DE','Dierkow-Neu','Dierkow-Neu',54.1057,12.1675,'P','PPLX','DE.12','DE.12.00',10552,'Europe/Berlin',1,'2014-07-18 23:00:00','2014-07-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (9973269,'DE','Solms','Solms',50.5362,8.40704,'P','PPL','DE.05','DE.05.065',13250,'Europe/Berlin',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (11101906,'DE','Westhagen','Westhagen',52.4043,10.7394,'P','PPLX','DE.06','DE.06.00',9206,'Europe/Berlin',1,'2016-03-16 23:00:00','2016-03-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (11258605,'DE','Düsseldorf-Pempelfort','Duesseldorf-Pempelfort',51.2381,6.78678,'P','PPLX','DE.07','DE.07.051',28941,'Europe/Berlin',1,'2016-10-08 23:00:00','2016-10-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (11594317,'DE','Burglesum','Burglesum',53.1653,8.68873,'P','PPLX','DE.03','DE.03.00',33000,'Europe/Berlin',1,'2017-09-19 23:00:00','2017-09-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (11670103,'DE','Grafenau','Grafenau',48.7143,8.91219,'P','PPLA4','DE.01','DE.01.081',6425,'Europe/Berlin',1,'2017-08-29 23:00:00','2017-08-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (11670104,'DE','Hirschberg an der Bergstraße','Hirschberg an der Bergstrasse',49.5071,8.65693,'P','PPLA4','DE.01','DE.01.082',9294,'Europe/Berlin',1,'2017-08-29 23:00:00','2017-08-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (11670105,'DE','Kraichtal','Kraichtal',49.1462,8.73276,'P','PPLA4','DE.01','DE.01.082',14416,'Europe/Berlin',1,'2017-08-29 23:00:00','2017-08-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (11670107,'DE','Lenningen','Lenningen',48.5505,9.47674,'P','PPLA4','DE.01','DE.01.081',7955,'Europe/Berlin',1,'2017-08-29 23:00:00','2017-08-29 23:00:00');


