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

/*!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`, `active`) VALUES ('CH.ZH','CH','{\"en\":\"Zurich\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.ZG','CH','{\"en\":\"Zug\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.VD','CH','{\"en\":\"Vaud\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.VS','CH','{\"en\":\"Valais\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.UR','CH','{\"en\":\"Uri\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.TI','CH','{\"en\":\"Ticino\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.TG','CH','{\"en\":\"Thurgau\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.SO','CH','{\"en\":\"Solothurn\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.SZ','CH','{\"en\":\"Schwyz\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.SH','CH','{\"en\":\"Schaffhausen\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.SG','CH','{\"en\":\"Saint Gallen\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.OW','CH','{\"en\":\"Obwalden\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.NW','CH','{\"en\":\"Nidwalden\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.NE','CH','{\"en\":\"Neuchâtel\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.LU','CH','{\"en\":\"Lucerne\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.JU','CH','{\"en\":\"Jura\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.GR','CH','{\"en\":\"Grisons\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.GL','CH','{\"en\":\"Glarus\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.GE','CH','{\"en\":\"Geneva\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.FR','CH','{\"en\":\"Fribourg\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.BE','CH','{\"en\":\"Bern\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.BS','CH','{\"en\":\"Basel-City\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.BL','CH','{\"en\":\"Basel-Landschaft\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.AR','CH','{\"en\":\"Appenzell Ausserrhoden\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.AI','CH','{\"en\":\"Appenzell Innerrhoden\"}',1);
INSERT INTO `<<prefix>>subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('CH.AG','CH','{\"en\":\"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`, `active`) VALUES ('CH.TI.2108','CH','CH.TI','{\"en\":\"Vallemaggia District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SO.1110','CH','CH.SO','{\"en\":\"Bezirk Thierstein\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SG.1725','CH','CH.SG','{\"en\":\"Wahlkreis Sarganserland\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VS.2309','CH','CH.VS','{\"en\":\"Raron District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.ZH.107','CH','CH.ZH','{\"en\":\"Bezirk Meilen\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VS.2307','CH','CH.VS','{\"en\":\"Martigny District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.FR.1002','CH','CH.FR','{\"en\":\"Glâne District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.ZH.102','CH','CH.ZH','{\"en\":\"Bezirk Andelfingen\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SO.1101','CH','CH.SO','{\"en\":\"Bezirk Gäu\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.AI.1600','CH','CH.AI','{\"en\":\"Appenzell Inner Rhodes\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.JU.2601','CH','CH.JU','{\"en\":\"Delémont District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VS.2312','CH','CH.VS','{\"en\":\"Sion District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.AG.1910','CH','CH.AG','{\"en\":\"Bezirk Zofingen\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.GL.800','CH','CH.GL','{\"en\":\"Glarus\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.BL.1305','CH','CH.BL','{\"en\":\"Bezirk Waldenburg\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.TI.2104','CH','CH.TI','{\"en\":\"Locarno District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.ZH.109','CH','CH.ZH','{\"en\":\"Bezirk Uster\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VS.2306','CH','CH.VS','{\"en\":\"Leuk District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.FR.1001','CH','CH.FR','{\"en\":\"Broye District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.TI.2107','CH','CH.TI','{\"en\":\"Riviera District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.ZH.111','CH','CH.ZH','{\"en\":\"Bezirk Dietikon\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.NW.700','CH','CH.NW','{\"en\":\"Nidwalden\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.BS.1200','CH','CH.BS','{\"en\":\"Basel-Stadt\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VS.2304','CH','CH.VS','{\"en\":\"Goms District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.FR.1004','CH','CH.FR','{\"en\":\"Sarine District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VS.2303','CH','CH.VS','{\"en\":\"Entremont District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SH.1404','CH','CH.SH','{\"en\":\"Bezirk Schleitheim\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SG.1721','CH','CH.SG','{\"en\":\"Wahlkreis St. Gallen\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.TI.2105','CH','CH.TI','{\"en\":\"Lugano District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.AG.1905','CH','CH.AG','{\"en\":\"Bezirk Kulm\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.AG.1903','CH','CH.AG','{\"en\":\"Bezirk Bremgarten\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SZ.506','CH','CH.SZ','{\"en\":\"Bezirk Schwyz\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.JU.2603','CH','CH.JU','{\"en\":\"Porrentruy District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SO.1109','CH','CH.SO','{\"en\":\"Bezirk Solothurn\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SZ.505','CH','CH.SZ','{\"en\":\"Bezirk March\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.GE.2500','CH','CH.GE','{\"en\":\"Geneva\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.TI.2102','CH','CH.TI','{\"en\":\"Blenio District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.AG.1911','CH','CH.AG','{\"en\":\"Bezirk Zurzach\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.JU.2602','CH','CH.JU','{\"en\":\"Franches-Montagnes District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SH.1405','CH','CH.SH','{\"en\":\"Bezirk Stein\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VS.2311','CH','CH.VS','{\"en\":\"Sierre District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.FR.1003','CH','CH.FR','{\"en\":\"Gruyère District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.ZH.105','CH','CH.ZH','{\"en\":\"Bezirk Hinwil\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.ZH.112','CH','CH.ZH','{\"en\":\"Bezirk Zürich\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.UR.400','CH','CH.UR','{\"en\":\"Uri\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.AG.1907','CH','CH.AG','{\"en\":\"Bezirk Lenzburg\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.ZG.900','CH','CH.ZG','{\"en\":\"Zug\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.ZH.110','CH','CH.ZH','{\"en\":\"Bezirk Winterthur\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.NE.2403','CH','CH.NE','{\"en\":\"Le Locle District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SZ.502','CH','CH.SZ','{\"en\":\"Bezirk Gersau\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.NE.2405','CH','CH.NE','{\"en\":\"Val-de-Ruz District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.AG.1902','CH','CH.AG','{\"en\":\"Bezirk Baden\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SH.1401','CH','CH.SH','{\"en\":\"Bezirk Oberklettgau\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.OW.600','CH','CH.OW','{\"en\":\"Obwalden\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.ZH.101','CH','CH.ZH','{\"en\":\"Bezirk Affoltern\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.FR.1005','CH','CH.FR','{\"en\":\"See District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VS.2301','CH','CH.VS','{\"en\":\"Brig District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.BL.1304','CH','CH.BL','{\"en\":\"Bezirk Sissach\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.NE.2401','CH','CH.NE','{\"en\":\"Boudry District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.AG.1904','CH','CH.AG','{\"en\":\"Bezirk Brugg\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SO.1107','CH','CH.SO','{\"en\":\"Bezirk Lebern\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.AR.1502','CH','CH.AR','{\"en\":\"Bezirk Mittelland\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.NE.2402','CH','CH.NE','{\"en\":\"La Chaux-de-Fonds District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VS.2310','CH','CH.VS','{\"en\":\"Saint-Maurice District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.BL.1302','CH','CH.BL','{\"en\":\"Bezirk Laufen\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.NE.2406','CH','CH.NE','{\"en\":\"Val-de-Travers District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SH.1406','CH','CH.SH','{\"en\":\"Bezirk Unterklettgau\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.AR.1501','CH','CH.AR','{\"en\":\"Bezirk Hinterland\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SG.1722','CH','CH.SG','{\"en\":\"Wahlkreis Rorschach\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SZ.504','CH','CH.SZ','{\"en\":\"Bezirk Küssnacht\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SG.1728','CH','CH.SG','{\"en\":\"Wahlkreis Wil\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SO.1103','CH','CH.SO','{\"en\":\"Bezirk Bucheggberg\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.BL.1301','CH','CH.BL','{\"en\":\"Bezirk Arlesheim\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VS.2313','CH','CH.VS','{\"en\":\"Visp District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VS.2308','CH','CH.VS','{\"en\":\"Monthey District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.AG.1901','CH','CH.AG','{\"en\":\"Bezirk Aarau\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.ZH.106','CH','CH.ZH','{\"en\":\"Bezirk Horgen\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SZ.503','CH','CH.SZ','{\"en\":\"Bezirk Höfe\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VS.2302','CH','CH.VS','{\"en\":\"Conthey District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.ZH.108','CH','CH.ZH','{\"en\":\"Bezirk Pfäffikon\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.AG.1909','CH','CH.AG','{\"en\":\"Bezirk Rheinfelden\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.BL.1303','CH','CH.BL','{\"en\":\"Bezirk Liestal\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VD.2227','CH','CH.VD','{\"en\":\"Morges District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.AG.1906','CH','CH.AG','{\"en\":\"Bezirk Laufenburg\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.FR.1007','CH','CH.FR','{\"en\":\"Veveyse District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.AR.1503','CH','CH.AR','{\"en\":\"Bezirk Vorderland\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.ZH.104','CH','CH.ZH','{\"en\":\"Bezirk Dielsdorf\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VD.2225','CH','CH.VD','{\"en\":\"Lausanne District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.ZH.103','CH','CH.ZH','{\"en\":\"Bezirk Bülach\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SO.1102','CH','CH.SO','{\"en\":\"Bezirk Thal\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.TI.2101','CH','CH.TI','{\"en\":\"Bellinzona District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VS.2305','CH','CH.VS','{\"en\":\"Hérens District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SO.1105','CH','CH.SO','{\"en\":\"Bezirk Gösgen\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SZ.501','CH','CH.SZ','{\"en\":\"Bezirk Einsiedeln\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SG.1724','CH','CH.SG','{\"en\":\"Wahlkreis Werdenberg\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SH.1403','CH','CH.SH','{\"en\":\"Bezirk Schaffhausen\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SH.1402','CH','CH.SH','{\"en\":\"Bezirk Reiat\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SO.1106','CH','CH.SO','{\"en\":\"Bezirk Wasseramt\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.NE.2404','CH','CH.NE','{\"en\":\"Neuchâtel District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SO.1108','CH','CH.SO','{\"en\":\"Bezirk Olten\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.TI.2106','CH','CH.TI','{\"en\":\"Mendrisio District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VD.2221','CH','CH.VD','{\"en\":\"Aigle District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.FR.1006','CH','CH.FR','{\"en\":\"Sense District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.AG.1908','CH','CH.AG','{\"en\":\"Bezirk Muri\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.TI.2103','CH','CH.TI','{\"en\":\"Leventina District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SO.1104','CH','CH.SO','{\"en\":\"Bezirk Dorneck\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SG.1723','CH','CH.SG','{\"en\":\"Wahlkreis Rheintal\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SG.1727','CH','CH.SG','{\"en\":\"Wahlkreis Toggenburg\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VD.2222','CH','CH.VD','{\"en\":\"Broye-Vully District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VD.2223','CH','CH.VD','{\"en\":\"Gros-de-Vaud District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VD.2224','CH','CH.VD','{\"en\":\"Jura-Nord vaudois District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VD.2226','CH','CH.VD','{\"en\":\"Lavaux-Oron District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VD.2228','CH','CH.VD','{\"en\":\"Nyon District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VD.2229','CH','CH.VD','{\"en\":\"Ouest Lausannois District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.VD.2230','CH','CH.VD','{\"en\":\"Riviera-Pays-d\'Enhaut District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.SG.1726','CH','CH.SG','{\"en\":\"Wahlkreis See-Gaster\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.BE.245','CH','CH.BE','{\"en\":\"Emmental District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.BE.248','CH','CH.BE','{\"en\":\"Obersimmental-Saanen District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.BE.249','CH','CH.BE','{\"en\":\"Frutigen-Niedersimmental District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.BE.242','CH','CH.BE','{\"en\":\"Biel/Bienne District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.BE.243','CH','CH.BE','{\"en\":\"Seeland District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.BE.247','CH','CH.BE','{\"en\":\"Thun District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.BE.250','CH','CH.BE','{\"en\":\"Interlaken-Oberhasli District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.BE.241','CH','CH.BE','{\"en\":\"Jura bernois\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.BE.244','CH','CH.BE','{\"en\":\"Oberaargau\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.BE.246','CH','CH.BE','{\"en\":\"Bern-Mittelland District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.TG.2012','CH','CH.TG','{\"en\":\"Bezirk Frauenfeld\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.TG.2011','CH','CH.TG','{\"en\":\"Bezirk Arbon\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.TG.2014','CH','CH.TG','{\"en\":\"Bezirk Münchwilen\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.TG.2013','CH','CH.TG','{\"en\":\"Bezirk Kreuzlingen\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.TG.2015','CH','CH.TG','{\"en\":\"Bezirk Weinfelden\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.LU.312','CH','CH.LU','{\"en\":\"Lucerne-Land District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.LU.311','CH','CH.LU','{\"en\":\"Lucerne-Stadt District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.LU.316','CH','CH.LU','{\"en\":\"Entlebuch District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.LU.313','CH','CH.LU','{\"en\":\"Hochdorf District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.LU.314','CH','CH.LU','{\"en\":\"Sursee District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.LU.315','CH','CH.LU','{\"en\":\"Willisau District\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.GR.1850','CH','CH.GR','{\"en\":\"Region Surselva\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.GR.1851','CH','CH.GR','{\"en\":\"Region Viamala\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.GR.1843','CH','CH.GR','{\"en\":\"Region Engiadina Bassa / Val Müstair\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.GR.1848','CH','CH.GR','{\"en\":\"Region Plessur\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.GR.1844','CH','CH.GR','{\"en\":\"Region Imboden\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.GR.1841','CH','CH.GR','{\"en\":\"Region Albula\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.GR.1849','CH','CH.GR','{\"en\":\"Region Prättigau / Davos\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.GR.1845','CH','CH.GR','{\"en\":\"Region Landquart\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.GR.1842','CH','CH.GR','{\"en\":\"Region Bernina\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.GR.1847','CH','CH.GR','{\"en\":\"Region Moesa\"}',1);
INSERT INTO `<<prefix>>subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('CH.GR.1846','CH','CH.GR','{\"en\":\"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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich\"}',8.55,47.37,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zug\"}',8.52,47.17,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zuchwil\"}',7.57,47.20,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zollikon\"}',8.57,47.34,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zollikofen\"}',7.46,47.00,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zofingen\"}',7.95,47.29,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zermatt\"}',7.75,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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Yverdon-les-Bains\"}',6.64,46.78,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Würenlos\"}',8.36,47.44,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Worb\"}',7.56,46.93,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Wollerau\"}',8.72,47.19,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Wohlen\"}',8.28,47.35,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Wohlen\"}',7.36,46.97,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Wittenbach\"}',9.39,47.46,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 7) / Witikon\"}',8.59,47.36,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Winterthur\"}',8.72,47.51,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Windisch\"}',8.22,47.48,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Wil\"}',9.05,47.46,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 3) / Alt-Wiedikon\"}',8.51,47.36,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Wetzikon\"}',8.80,47.33,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Wettingen\"}',8.32,47.47,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Weinfelden\"}',9.10,47.57,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Wattwil\"}',9.09,47.30,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Wallisellen\"}',8.60,47.41,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Wädenswil\"}',8.67,47.23,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Visp\"}',7.88,46.29,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Villmergen\"}',8.25,47.35,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Villars-sur-Glâne\"}',7.12,46.79,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Viganello\"}',8.97,46.01,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Veyrier\"}',6.18,46.17,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Vevey\"}',6.84,46.46,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Versoix\"}',6.16,46.28,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Vernier\"}',6.08,46.22,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Veltheim (Kreis 5)\"}',8.72,47.51,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Uzwil\"}',9.13,47.44,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Uznach\"}',8.98,47.22,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Uster\"}',8.72,47.35,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Urtenen\"}',7.50,47.03,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Untersiggenthal\"}',8.26,47.50,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Unterseen\"}',7.85,46.69,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Unterägeri\"}',8.59,47.14,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Uetendorf\"}',7.57,46.77,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Trimbach\"}',7.89,47.37,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Töss (Kreis 4)\"}',8.70,47.48,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Thun\"}',7.62,46.75,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Therwil\"}',7.56,47.50,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Thalwil\"}',8.56,47.29,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Teufen\"}',9.39,47.39,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Sursee\"}',8.11,47.17,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Sumiswald\"}',7.75,47.03,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Suhr\"}',8.08,47.37,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Steinhausen\"}',8.49,47.20,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Steffisburg\"}',7.63,46.78,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Stans\"}',8.37,46.96,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Stäfa\"}',8.72,47.24,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Spreitenbach\"}',8.37,47.42,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Spiez\"}',7.69,46.68,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Solothurn\"}',7.54,47.21,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Sissach\"}',7.81,47.46,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Sirnach\"}',9.00,47.46,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Sitten\"}',7.36,46.23,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Sierre\"}',7.54,46.29,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Siebnen\"}',8.90,47.17,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 11) / Seebach\"}',8.55,47.42,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Schwyz\"}',8.65,47.02,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Schübelbach\"}',8.93,47.17,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Schlieren\"}',8.45,47.40,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Schaffhausen\"}',8.63,47.70,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Savièse\"}',7.35,46.25,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Sarnen\"}',8.25,46.90,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Sargans\"}',9.44,47.05,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Sankt Margrethen\"}',9.64,47.45,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Sankt Gallen\"}',9.37,47.42,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Saint-Imier\"}',7.00,47.15,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Saanen\"}',7.26,46.49,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Rüti\"}',8.86,47.26,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Ruswil\"}',8.13,47.08,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Rümlang\"}',8.53,47.45,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Rotkreuz\"}',8.43,47.14,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Rothrist\"}',7.89,47.31,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Rorschach\"}',9.49,47.48,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Romanshorn\"}',9.38,47.57,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Richterswil\"}',8.70,47.21,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Rheinfelden\"}',7.79,47.55,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Renens\"}',6.59,46.54,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Reinach\"}',8.18,47.26,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Regensdorf\"}',8.47,47.43,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Rapperswil\"}',8.82,47.23,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Pully\"}',6.66,46.51,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Prilly\"}',6.60,46.54,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Pregassona\"}',8.97,46.02,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Pratteln\"}',7.69,47.52,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Porrentruy\"}',7.08,47.42,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Plan-les-Ouates\"}',6.12,46.17,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Pfäffikon\"}',8.79,47.36,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Pfäffikon\"}',8.78,47.20,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Peseux\"}',6.89,46.99,'P','PPL','CH.NE','CH.NE.2404',5716,'Europe/Zurich',1,'2021-01-02 23:00:00','2021-01-02 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Payerne\"}',6.94,46.82,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Orbe\"}',6.53,46.73,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Onex\"}',6.10,46.18,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Olten\"}',7.90,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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Ollon\"}',6.99,46.30,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Oftringen\"}',7.93,47.31,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 11) / Oerlikon\"}',8.54,47.41,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Oberwil\"}',7.56,47.51,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Oberuzwil\"}',9.13,47.43,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Urdorf\"}',8.43,47.39,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Obersiggenthal\"}',8.30,47.49,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Oberriet\"}',9.57,47.32,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Oberentfelden\"}',8.05,47.36,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Oberengstringen\"}',8.47,47.41,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Nyon\"}',6.24,46.38,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Nidau\"}',7.24,47.13,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Neuhausen\"}',8.61,47.69,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Neuenkirch\"}',8.20,47.10,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Neuenhof\"}',8.33,47.45,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Neuchâtel\"}',6.93,46.99,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Naters\"}',7.99,46.33,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Muttenz\"}',7.65,47.52,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Murten/Morat\"}',7.12,46.93,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Muri\"}',8.34,47.27,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Muri\"}',7.49,46.93,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Münsingen\"}',7.56,46.87,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Münchenstein\"}',7.61,47.52,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Münchenbuchsee\"}',7.45,47.02,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Moutier\"}',7.37,47.28,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Morges\"}',6.50,46.51,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Montreux\"}',6.91,46.43,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Monthey\"}',6.95,46.25,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Möhlin\"}',7.84,47.56,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Minusio\"}',8.81,46.18,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Meyrin\"}',6.08,46.23,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Menziken\"}',8.19,47.24,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Mendrisio\"}',8.98,45.87,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Meggen\"}',8.37,47.05,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Massagno\"}',8.94,46.01,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Martigny-Ville\"}',7.07,46.10,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Marly\"}',7.16,46.78,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Männedorf\"}',8.70,47.26,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Malters\"}',8.18,47.04,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Lyss\"}',7.31,47.07,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Luzern\"}',8.31,47.05,'P','PPLA','CH.LU','CH.LU.311',81691,'Europe/Zurich',1,'2020-09-27 23:00:00','2020-09-27 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Lutry\"}',6.69,46.50,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Lugano\"}',8.96,46.01,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Losone\"}',8.76,46.17,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Locarno\"}',8.80,46.17,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Littau\"}',8.26,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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Liestal\"}',7.73,47.48,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Lenzburg\"}',8.18,47.39,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Lengnau\"}',7.37,47.18,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Le Mont-sur-Lausanne\"}',6.63,46.56,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Le Locle\"}',6.75,47.06,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Lausanne\"}',6.63,46.52,'P','PPLA','CH.VD','CH.VD.2225',139111,'Europe/Zurich',1,'2020-09-27 23:00:00','2020-09-27 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Laufen\"}',7.50,47.42,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"La Tour-de-Peilz\"}',6.86,46.45,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Langnau\"}',7.79,46.94,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Langenthal\"}',7.80,47.22,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Lachen\"}',8.85,47.19,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"La Chaux-de-Fonds\"}',6.83,47.10,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Küttigen\"}',8.05,47.41,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Küssnacht\"}',8.44,47.09,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Küsnacht\"}',8.58,47.32,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Kriens\"}',8.29,47.03,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Kreuzlingen\"}',9.18,47.65,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Köniz\"}',7.41,46.92,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Kloten\"}',8.58,47.45,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Kirchberg\"}',9.04,47.41,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Kirchberg\"}',7.58,47.09,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Kilchberg\"}',8.55,47.32,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Kerns\"}',8.28,46.90,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Jona\"}',8.84,47.23,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Interlaken\"}',7.87,46.68,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Ingenbohl\"}',8.62,47.00,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Igis\"}',9.57,46.95,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Hünenberg\"}',8.42,47.18,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Horw\"}',8.31,47.02,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Horgen\"}',8.60,47.26,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 10) / Höngg\"}',8.50,47.40,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Hochdorf\"}',8.29,47.17,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Hinwil\"}',8.84,47.29,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Herzogenbuchsee\"}',7.71,47.19,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Herrliberg\"}',8.61,47.29,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Herisau\"}',9.28,47.39,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Hergiswil\"}',8.31,46.98,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Heimberg\"}',7.60,46.79,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Gstaad\"}',7.29,46.47,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Grenchen\"}',7.40,47.19,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Greifensee\"}',8.68,47.37,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Gränichen\"}',8.10,47.36,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Le Grand-Saconnex\"}',6.12,46.23,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Grabs\"}',9.44,47.18,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Gossau\"}',9.25,47.42,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Goldau\"}',8.55,47.05,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Goldach\"}',9.47,47.47,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Glarus\"}',9.07,47.04,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Gland\"}',6.27,46.42,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Giubiasco\"}',9.01,46.17,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Genève\"}',6.15,46.20,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Gelterkinden\"}',7.85,47.46,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Fully\"}',7.11,46.14,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Frutigen\"}',7.65,46.59,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Fribourg\"}',7.15,46.80,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Frenkendorf\"}',7.72,47.51,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Freienbach\"}',8.76,47.21,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Frauenfeld\"}',8.90,47.56,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Flawil\"}',9.18,47.41,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Estavayer-le-Lac\"}',6.85,46.85,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Eschenbach\"}',8.92,47.24,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Epalinges\"}',6.67,46.55,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Emmen\"}',8.27,47.08,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Embrach\"}',8.59,47.51,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Einsiedeln\"}',8.75,47.13,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Effretikon\"}',8.69,47.43,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Ecublens\"}',6.81,46.61,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Ebikon\"}',8.34,47.08,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Düdingen\"}',7.19,46.85,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Dübendorf\"}',8.62,47.40,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Dornach\"}',7.62,47.48,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Domat\"}',9.45,46.83,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Dietlikon / Dietlikon (Dorf)\"}',8.62,47.42,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Dietikon\"}',8.40,47.40,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Diepoldsau\"}',9.66,47.39,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Derendingen\"}',7.59,47.20,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Delémont\"}',7.34,47.36,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Davos\"}',9.84,46.80,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Crissier\"}',6.58,46.55,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Conthey\"}',7.30,46.22,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Collombey\"}',6.95,46.27,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Chur\"}',9.53,46.85,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Chiasso\"}',9.03,45.83,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Chêne-Bourg\"}',6.19,46.20,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Chavannes\"}',6.57,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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Châtel-Saint-Denis\"}',6.90,46.53,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Cham\"}',8.46,47.18,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Carouge\"}',6.14,46.18,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Bussigny\"}',6.56,46.55,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Burgdorf\"}',7.63,47.06,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Buochs\"}',8.42,46.97,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Bulle\"}',7.06,46.62,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Bülach\"}',8.54,47.52,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Buchs\"}',8.08,47.39,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Buchs\"}',9.48,47.17,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Buchrain\"}',8.35,47.10,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Brugg\"}',8.21,47.48,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Bremgarten\"}',8.34,47.35,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Bottmingen\"}',7.57,47.52,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Bolligen\"}',7.50,46.98,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Blonay\"}',6.90,46.47,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Birsfelden\"}',7.62,47.55,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Binningen\"}',7.57,47.54,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Biel/Bienne\"}',7.25,47.14,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Biberist\"}',7.56,47.18,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Biasca\"}',8.97,46.36,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Bex\"}',7.01,46.25,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Bernex\"}',6.08,46.18,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Bern\"}',7.45,46.95,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Belp\"}',7.50,46.89,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Bellinzona\"}',9.02,46.19,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Bassersdorf\"}',8.63,47.44,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Basse-Nendaz\"}',7.31,46.19,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Basel\"}',7.57,47.56,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Balsthal\"}',7.69,47.32,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Bagnes\"}',7.22,46.08,'P','PPL','CH.VS','CH.VS.2303',6626,'Europe/Zurich',1,'2021-01-01 23:00:00','2021-01-01 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Bad Ragaz\"}',9.50,47.01,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Baden\"}',8.31,47.47,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Baar\"}',8.53,47.20,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 4) / Aussersihl\"}',8.52,47.38,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Au\"}',9.63,47.43,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Ascona\"}',8.77,46.15,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Arth\"}',8.52,47.06,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Arlesheim\"}',7.62,47.49,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Arbon\"}',9.43,47.52,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Appenzell\"}',9.41,47.33,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Amriswil\"}',9.30,47.55,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Altstätten\"}',9.55,47.38,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Altendorf\"}',8.84,47.19,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Altdorf\"}',8.64,46.88,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Alpnach\"}',8.27,46.94,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Allschwil\"}',7.54,47.55,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Aigle\"}',6.96,46.32,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Affoltern am Albis\"}',8.45,47.28,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Aesch\"}',7.60,47.47,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Adliswil\"}',8.52,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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Adligenswil\"}',8.36,47.07,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Aarburg\"}',7.90,47.32,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Aarau\"}',8.04,47.39,'P','PPLA','CH.AG','CH.AG.1901',15501,'Europe/Zurich',1,'2020-06-28 23:00:00','2020-06-28 23:00:00');
INSERT INTO `<<prefix>>cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Aadorf\"}',8.90,47.49,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Riehen\"}',7.65,47.58,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Chêne-Bougeries\"}',6.19,46.20,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Thônex\"}',6.20,46.19,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Ecublens\"}',6.56,46.53,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Wallisellen / Wallisellen-Ost\"}',8.60,47.41,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Horgen / Horgen (Dorfkern)\"}',8.60,47.26,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Thalwil / Dorfkern\"}',8.57,47.29,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Pfäffikon / Pfäffikon (Dorfkern)\"}',8.78,47.37,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Uster / Kirch-Uster\"}',8.72,47.35,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Uster / Ober-Uster\"}',8.73,47.35,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Oberwinterthur (Kreis 2) / Talacker\"}',8.75,47.51,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Oberwinterthur (Kreis 2) / Guggenbühl\"}',8.76,47.51,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Mattenbach (Kreis 7) / Deutweg\"}',8.74,47.49,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 10) / Wipkingen\"}',8.53,47.40,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 11) / Affoltern\"}',8.51,47.42,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 12) / Saatlen\"}',8.56,47.41,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 12) / Schwamendingen-Mitte\"}',8.57,47.41,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 12) / Hirzenbach\"}',8.59,47.40,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 2) / Wollishofen\"}',8.53,47.34,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 2) / Enge\"}',8.53,47.36,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 3) / Friesenberg\"}',8.50,47.36,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 3) / Sihlfeld\"}',8.51,47.37,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 4) / Langstrasse\"}',8.53,47.38,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 4) / Hard\"}',8.51,47.38,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 5) / Gewerbeschule\"}',8.53,47.38,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 6) / Unterstrass\"}',8.54,47.40,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 6) / Oberstrass\"}',8.55,47.39,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 7) / Fluntern\"}',8.56,47.38,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 7) / Hottingen\"}',8.56,47.37,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 7) / Hirslanden\"}',8.57,47.36,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 8) / Mühlebach\"}',8.56,47.36,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 9) / Albisrieden\"}',8.49,47.37,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 9) / Altstetten\"}',8.49,47.39,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Hegnau\"}',8.67,47.39,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Stadt Winterthur (Kreis 1)\"}',8.72,47.49,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 5)\"}',8.52,47.39,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 12)\"}',8.58,47.40,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Wülflingen (Kreis 6)\"}',8.68,47.51,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Seen (Kreis 3)\"}',8.77,47.48,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 3)\"}',8.50,47.36,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 11)\"}',8.52,47.42,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 9)\"}',8.48,47.38,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Oberwinterthur (Kreis 2)\"}',8.77,47.52,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 10)\"}',8.50,47.41,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 2)\"}',8.52,47.34,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 8)\"}',8.56,47.35,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 1)\"}',8.54,47.37,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Mattenbach (Kreis 7)\"}',8.75,47.49,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 7)\"}',8.58,47.37,'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` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Zürich (Kreis 6)\"}',8.54,47.39,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Thal\"}',9.57,47.47,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Langnau am Albis\"}',8.54,47.29,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Lancy\"}',6.11,46.19,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Les Avanchets\"}',6.11,46.22,'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`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('CH','{\"en\":\"Blécherette\"}',6.62,46.54,'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
