-- MySQL dump 10.13  Distrib 5.7.26, for osx10.10 (x86_64)
--
-- Host: 127.0.0.1    Database: laraclassified
-- ------------------------------------------------------
-- Server version	5.7.26

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

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

/*!40000 ALTER TABLE `<<prefix>>subadmin1` DISABLE KEYS */;
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.ZH','CH','Zurich','Zurich',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.ZG','CH','Zug','Zug',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.VD','CH','Vaud','Vaud',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.VS','CH','Valais','Valais',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.UR','CH','Uri','Uri',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.TI','CH','Ticino','Ticino',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.TG','CH','Thurgau','Thurgau',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.SO','CH','Solothurn','Solothurn',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.SZ','CH','Schwyz','Schwyz',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.SH','CH','Schaffhausen','Schaffhausen',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.SG','CH','Saint Gallen','Saint Gallen',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.OW','CH','Obwalden','Obwalden',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.NW','CH','Nidwalden','Nidwalden',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.NE','CH','Neuchâtel','Neuchatel',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.LU','CH','Lucerne','Lucerne',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.JU','CH','Jura','Jura',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.GR','CH','Grisons','Grisons',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.GL','CH','Glarus','Glarus',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.GE','CH','Geneva','Geneva',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.FR','CH','Fribourg','Fribourg',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.BE','CH','Bern','Bern',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.BS','CH','Basel-City','Basel-City',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.BL','CH','Basel-Landschaft','Basel-Landschaft',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.AR','CH','Appenzell Ausserrhoden','Appenzell Ausserrhoden',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.AI','CH','Appenzell Innerrhoden','Appenzell Innerrhoden',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `asciiname`, `active`) VALUES ('CH.AG','CH','Aargau','Aargau',1);
/*!40000 ALTER TABLE `<<prefix>>subadmin1` ENABLE KEYS */;

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

/*!40000 ALTER TABLE `<<prefix>>subadmin2` DISABLE KEYS */;
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.TI.2108','CH','CH.TI','Vallemaggia District','Vallemaggia District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SO.1110','CH','CH.SO','Bezirk Thierstein','Bezirk Thierstein',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SG.1725','CH','CH.SG','Wahlkreis Sarganserland','Wahlkreis Sarganserland',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VS.2309','CH','CH.VS','Raron District','Raron District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.ZH.107','CH','CH.ZH','Bezirk Meilen','Bezirk Meilen',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VS.2307','CH','CH.VS','Martigny District','Martigny District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.FR.1002','CH','CH.FR','Glâne District','Glane District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.ZH.102','CH','CH.ZH','Bezirk Andelfingen','Bezirk Andelfingen',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SO.1101','CH','CH.SO','Bezirk Gäu','Bezirk Gaeu',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.AI.1600','CH','CH.AI','Appenzell Inner Rhodes','Appenzell Inner Rhodes',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.JU.2601','CH','CH.JU','Delémont District','Delemont District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VS.2312','CH','CH.VS','Sion District','Sion District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.AG.1910','CH','CH.AG','Bezirk Zofingen','Bezirk Zofingen',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.GL.800','CH','CH.GL','Glarus','Glarus',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.BL.1305','CH','CH.BL','Bezirk Waldenburg','Bezirk Waldenburg',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.TI.2104','CH','CH.TI','Locarno District','Locarno District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.ZH.109','CH','CH.ZH','Bezirk Uster','Bezirk Uster',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VS.2306','CH','CH.VS','Leuk District','Leuk District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.FR.1001','CH','CH.FR','Broye District','Broye District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.TI.2107','CH','CH.TI','Riviera District','Riviera District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.ZH.111','CH','CH.ZH','Bezirk Dietikon','Bezirk Dietikon',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.NW.700','CH','CH.NW','Nidwalden','Nidwalden',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.BS.1200','CH','CH.BS','Basel-Stadt','Basel-Stadt',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VS.2304','CH','CH.VS','Goms District','Goms District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.FR.1004','CH','CH.FR','Sarine District','Sarine District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VS.2303','CH','CH.VS','Entremont District','Entremont District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SH.1404','CH','CH.SH','Bezirk Schleitheim','Bezirk Schleitheim',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SG.1721','CH','CH.SG','Wahlkreis St. Gallen','Wahlkreis St. Gallen',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.TI.2105','CH','CH.TI','Lugano District','Lugano District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.AG.1905','CH','CH.AG','Bezirk Kulm','Bezirk Kulm',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.AG.1903','CH','CH.AG','Bezirk Bremgarten','Bezirk Bremgarten',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SZ.506','CH','CH.SZ','Bezirk Schwyz','Bezirk Schwyz',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.JU.2603','CH','CH.JU','Porrentruy District','Porrentruy District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SO.1109','CH','CH.SO','Bezirk Solothurn','Bezirk Solothurn',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SZ.505','CH','CH.SZ','Bezirk March','Bezirk March',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.GE.2500','CH','CH.GE','Geneva','Geneva',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.TI.2102','CH','CH.TI','Blenio District','Blenio District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.AG.1911','CH','CH.AG','Bezirk Zurzach','Bezirk Zurzach',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.JU.2602','CH','CH.JU','Franches-Montagnes District','Franches-Montagnes District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SH.1405','CH','CH.SH','Bezirk Stein','Bezirk Stein',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VS.2311','CH','CH.VS','Sierre District','Sierre District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.FR.1003','CH','CH.FR','Gruyère District','Gruyere District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.ZH.105','CH','CH.ZH','Bezirk Hinwil','Bezirk Hinwil',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.ZH.112','CH','CH.ZH','Bezirk Zürich','Bezirk Zuerich',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.UR.400','CH','CH.UR','Uri','Uri',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.AG.1907','CH','CH.AG','Bezirk Lenzburg','Bezirk Lenzburg',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.ZG.900','CH','CH.ZG','Zug','Zug',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.ZH.110','CH','CH.ZH','Bezirk Winterthur','Bezirk Winterthur',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.NE.2403','CH','CH.NE','Le Locle District','Le Locle District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SZ.502','CH','CH.SZ','Bezirk Gersau','Bezirk Gersau',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.NE.2405','CH','CH.NE','Val-de-Ruz District','Val-de-Ruz District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.AG.1902','CH','CH.AG','Bezirk Baden','Bezirk Baden',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SH.1401','CH','CH.SH','Bezirk Oberklettgau','Bezirk Oberklettgau',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.OW.600','CH','CH.OW','Obwalden','Obwalden',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.ZH.101','CH','CH.ZH','Bezirk Affoltern','Bezirk Affoltern',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.FR.1005','CH','CH.FR','Lake District','Lake District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VS.2301','CH','CH.VS','Brig District','Brig District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.BL.1304','CH','CH.BL','Bezirk Sissach','Bezirk Sissach',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.NE.2401','CH','CH.NE','Boudry District','Boudry District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.AG.1904','CH','CH.AG','Bezirk Brugg','Bezirk Brugg',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SO.1107','CH','CH.SO','Bezirk Lebern','Bezirk Lebern',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.AR.1502','CH','CH.AR','Bezirk Mittelland','Bezirk Mittelland',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.NE.2402','CH','CH.NE','La Chaux-de-Fonds District','La Chaux-de-Fonds District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VS.2310','CH','CH.VS','Saint-Maurice District','Saint-Maurice District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.BL.1302','CH','CH.BL','Bezirk Laufen','Bezirk Laufen',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.NE.2406','CH','CH.NE','Val-de-Travers District','Val-de-Travers District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SH.1406','CH','CH.SH','Bezirk Unterklettgau','Bezirk Unterklettgau',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.AR.1501','CH','CH.AR','Bezirk Hinterland','Bezirk Hinterland',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SG.1722','CH','CH.SG','Wahlkreis Rorschach','Wahlkreis Rorschach',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SZ.504','CH','CH.SZ','Bezirk Küssnacht','Bezirk Kuessnacht',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SG.1728','CH','CH.SG','Wahlkreis Wil','Wahlkreis Wil',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SO.1103','CH','CH.SO','Bezirk Bucheggberg','Bezirk Bucheggberg',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.BL.1301','CH','CH.BL','Bezirk Arlesheim','Bezirk Arlesheim',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VS.2313','CH','CH.VS','Visp District','Visp District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VS.2308','CH','CH.VS','Monthey District','Monthey District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.AG.1901','CH','CH.AG','Bezirk Aarau','Bezirk Aarau',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.ZH.106','CH','CH.ZH','Bezirk Horgen','Bezirk Horgen',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SZ.503','CH','CH.SZ','Bezirk Höfe','Bezirk Hoefe',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VS.2302','CH','CH.VS','Conthey District','Conthey District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.ZH.108','CH','CH.ZH','Bezirk Pfäffikon','Bezirk Pfaeffikon',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.AG.1909','CH','CH.AG','Bezirk Rheinfelden','Bezirk Rheinfelden',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.BL.1303','CH','CH.BL','Bezirk Liestal','Bezirk Liestal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VD.2227','CH','CH.VD','Morges District','Morges District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.AG.1906','CH','CH.AG','Bezirk Laufenburg','Bezirk Laufenburg',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.FR.1007','CH','CH.FR','Veveyse District','Veveyse District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.AR.1503','CH','CH.AR','Bezirk Vorderland','Bezirk Vorderland',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.ZH.104','CH','CH.ZH','Bezirk Dielsdorf','Bezirk Dielsdorf',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VD.2225','CH','CH.VD','Lausanne District','Lausanne District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.ZH.103','CH','CH.ZH','Bezirk Bülach','Bezirk Buelach',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SO.1102','CH','CH.SO','Bezirk Thal','Bezirk Thal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.TI.2101','CH','CH.TI','Bellinzona District','Bellinzona District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VS.2305','CH','CH.VS','Hérens District','Herens District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SO.1105','CH','CH.SO','Bezirk Gösgen','Bezirk Goesgen',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SZ.501','CH','CH.SZ','Bezirk Einsiedeln','Bezirk Einsiedeln',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SG.1724','CH','CH.SG','Wahlkreis Werdenberg','Wahlkreis Werdenberg',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SH.1403','CH','CH.SH','Bezirk Schaffhausen','Bezirk Schaffhausen',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SH.1402','CH','CH.SH','Bezirk Reiat','Bezirk Reiat',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SO.1106','CH','CH.SO','Bezirk Wasseramt','Bezirk Wasseramt',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.NE.2404','CH','CH.NE','Neuchâtel District','Neuchatel District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SO.1108','CH','CH.SO','Bezirk Olten','Bezirk Olten',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.TI.2106','CH','CH.TI','Mendrisio District','Mendrisio District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VD.2221','CH','CH.VD','Aigle District','Aigle District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.FR.1006','CH','CH.FR','Sense District','Sense District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.AG.1908','CH','CH.AG','Bezirk Muri','Bezirk Muri',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.TI.2103','CH','CH.TI','Leventina District','Leventina District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SO.1104','CH','CH.SO','Bezirk Dorneck','Bezirk Dorneck',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SG.1723','CH','CH.SG','Wahlkreis Rheintal','Wahlkreis Rheintal',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SG.1727','CH','CH.SG','Wahlkreis Toggenburg','Wahlkreis Toggenburg',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VD.2222','CH','CH.VD','Broye-Vully District','Broye-Vully District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VD.2223','CH','CH.VD','Gros-de-Vaud District','Gros-de-Vaud District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VD.2224','CH','CH.VD','Jura-Nord vaudois District','Jura-Nord vaudois District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VD.2226','CH','CH.VD','Lavaux-Oron District','Lavaux-Oron District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VD.2228','CH','CH.VD','Nyon District','Nyon District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VD.2229','CH','CH.VD','Ouest Lausannois District','Ouest Lausannois District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.VD.2230','CH','CH.VD','Riviera-Pays-d\'Enhaut District','Riviera-Pays-d\'Enhaut District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.SG.1726','CH','CH.SG','Wahlkreis See-Gaster','Wahlkreis See-Gaster',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.BE.245','CH','CH.BE','Emmental District','Emmental District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.BE.248','CH','CH.BE','Obersimmental-Saanen District','Obersimmental-Saanen District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.BE.249','CH','CH.BE','Frutigen-Niedersimmental District','Frutigen-Niedersimmental District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.BE.242','CH','CH.BE','Biel/Bienne District','Biel/Bienne District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.BE.243','CH','CH.BE','Seeland District','Seeland District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.BE.247','CH','CH.BE','Thun District','Thun District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.BE.250','CH','CH.BE','Interlaken-Oberhasli District','Interlaken-Oberhasli District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.BE.241','CH','CH.BE','Jura bernois','Jura bernois',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.BE.244','CH','CH.BE','Oberaargau','Oberaargau',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.BE.246','CH','CH.BE','Bern-Mittelland District','Bern-Mittelland District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.TG.2012','CH','CH.TG','Bezirk Frauenfeld','Bezirk Frauenfeld',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.TG.2011','CH','CH.TG','Bezirk Arbon','Bezirk Arbon',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.TG.2014','CH','CH.TG','Bezirk Münchwilen','Bezirk Muenchwilen',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.TG.2013','CH','CH.TG','Bezirk Kreuzlingen','Bezirk Kreuzlingen',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.TG.2015','CH','CH.TG','Bezirk Weinfelden','Bezirk Weinfelden',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.LU.312','CH','CH.LU','Lucerne-Land District','Lucerne-Land District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.LU.311','CH','CH.LU','Lucerne-Stadt District','Lucerne-Stadt District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.LU.316','CH','CH.LU','Entlebuch District','Entlebuch District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.LU.313','CH','CH.LU','Hochdorf District','Hochdorf District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.LU.314','CH','CH.LU','Sursee District','Sursee District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.LU.315','CH','CH.LU','Willisau District','Willisau District',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.GR.1850','CH','CH.GR','Region Surselva','Region Surselva',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.GR.1851','CH','CH.GR','Region Viamala','Region Viamala',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.GR.1843','CH','CH.GR','Region Engiadina Bassa / Val Müstair','Region Engiadina Bassa / Val Muestair',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.GR.1848','CH','CH.GR','Region Plessur','Region Plessur',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.GR.1844','CH','CH.GR','Region Imboden','Region Imboden',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.GR.1841','CH','CH.GR','Region Albula','Region Albula',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.GR.1849','CH','CH.GR','Region Prättigau / Davos','Region Praettigau / Davos',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.GR.1845','CH','CH.GR','Region Landquart','Region Landquart',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.GR.1842','CH','CH.GR','Region Bernina','Region Bernina',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.GR.1847','CH','CH.GR','Region Moesa','Region Moesa',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `asciiname`, `active`) VALUES ('CH.GR.1846','CH','CH.GR','Region Maloja','Region Maloja',1);
/*!40000 ALTER TABLE `<<prefix>>subadmin2` ENABLE KEYS */;

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

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

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed
