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

/*!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 ('PT.19','PT','{\"en\":\"District of Setúbal\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.18','PT','{\"en\":\"Santarém\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.16','PT','{\"en\":\"Portalegre\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.14','PT','{\"en\":\"Lisbon\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.13','PT','{\"en\":\"Leiria\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.09','PT','{\"en\":\"Faro\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.08','PT','{\"en\":\"Évora\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.06','PT','{\"en\":\"Castelo Branco\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.03','PT','{\"en\":\"Beja\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.10','PT','{\"en\":\"Madeira\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.22','PT','{\"en\":\"Viseu\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.21','PT','{\"en\":\"Vila Real\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.20','PT','{\"en\":\"Viana do Castelo\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.17','PT','{\"en\":\"Porto\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.11','PT','{\"en\":\"Guarda\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.07','PT','{\"en\":\"Coimbra\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.05','PT','{\"en\":\"Bragança\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.04','PT','{\"en\":\"Braga\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.02','PT','{\"en\":\"Aveiro\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('PT.23','PT','{\"en\":\"Azores\"}',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 ('PT.16.1206','PT','PT.16','{\"en\":\"Crato\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1821','PT','PT.22','{\"en\":\"Tondela\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.11.0906','PT','PT.11','{\"en\":\"Gouveia\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.06.0504','PT','PT.06','{\"en\":\"Fundão\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.14.1106','PT','PT.14','{\"en\":\"Lisbon\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1312','PT','PT.17','{\"en\":\"Porto\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.14.1107','PT','PT.14','{\"en\":\"Loures\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.16.1212','PT','PT.16','{\"en\":\"Nisa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.06.0511','PT','PT.06','{\"en\":\"Vila Velha de Ródão\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.16.1205','PT','PT.16','{\"en\":\"Castelo de Vide\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.16.1210','PT','PT.16','{\"en\":\"Marvão\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.16.1214','PT','PT.16','{\"en\":\"Portalegre\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.16.1209','PT','PT.16','{\"en\":\"Gavião\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.16.1213','PT','PT.16','{\"en\":\"Ponte de Sor\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.16.1201','PT','PT.16','{\"en\":\"Alter do Chão\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.16.1211','PT','PT.16','{\"en\":\"Monforte\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1802','PT','PT.22','{\"en\":\"Carregal do Sal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.19.1510','PT','PT.19','{\"en\":\"Seixal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0101','PT','PT.02','{\"en\":\"Águeda\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0102','PT','PT.02','{\"en\":\"Albergaria-A-Velha\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0103','PT','PT.02','{\"en\":\"Anadia\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0104','PT','PT.02','{\"en\":\"Arouca\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0105','PT','PT.02','{\"en\":\"Aveiro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0106','PT','PT.02','{\"en\":\"Castelo de Paiva\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0107','PT','PT.02','{\"en\":\"Espinho\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0108','PT','PT.02','{\"en\":\"Estarreja\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0109','PT','PT.02','{\"en\":\"Santa Maria da Feira\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0110','PT','PT.02','{\"en\":\"Ílhavo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0111','PT','PT.02','{\"en\":\"Mealhada\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0112','PT','PT.02','{\"en\":\"Murtosa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0113','PT','PT.02','{\"en\":\"Oliveira de Azeméis\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0114','PT','PT.02','{\"en\":\"Oliveira do Bairro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0115','PT','PT.02','{\"en\":\"Ovar\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0116','PT','PT.02','{\"en\":\"São João da Madeira\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0117','PT','PT.02','{\"en\":\"Sever do Vouga\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0118','PT','PT.02','{\"en\":\"Vagos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.02.0119','PT','PT.02','{\"en\":\"Vale de Cambra\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.03.0201','PT','PT.03','{\"en\":\"Aljustrel\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.03.0202','PT','PT.03','{\"en\":\"Almodôvar\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.03.0203','PT','PT.03','{\"en\":\"Alvito\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.03.0204','PT','PT.03','{\"en\":\"Barrancos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.03.0205','PT','PT.03','{\"en\":\"Beja\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.03.0206','PT','PT.03','{\"en\":\"Castro Verde\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.03.0207','PT','PT.03','{\"en\":\"Cuba\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.03.0208','PT','PT.03','{\"en\":\"Ferreira do Alentejo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.03.0209','PT','PT.03','{\"en\":\"Mértola\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.03.0210','PT','PT.03','{\"en\":\"Moura\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.03.0211','PT','PT.03','{\"en\":\"Odemira\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.03.0212','PT','PT.03','{\"en\":\"Ourique\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.03.0213','PT','PT.03','{\"en\":\"Serpa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.03.0214','PT','PT.03','{\"en\":\"Vidigueira\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.04.0301','PT','PT.04','{\"en\":\"Amares\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.04.0302','PT','PT.04','{\"en\":\"Barcelos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.04.0303','PT','PT.04','{\"en\":\"Braga\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.04.0304','PT','PT.04','{\"en\":\"Cabeceiras de Basto\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.04.0305','PT','PT.04','{\"en\":\"Celorico de Basto\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.04.0306','PT','PT.04','{\"en\":\"Esposende\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.04.0307','PT','PT.04','{\"en\":\"Fafe\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.04.0308','PT','PT.04','{\"en\":\"Guimarães\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.04.0309','PT','PT.04','{\"en\":\"Póvoa de Lanhoso\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.04.0310','PT','PT.04','{\"en\":\"Terras de Bouro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.04.0311','PT','PT.04','{\"en\":\"Vieira do Minho\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.04.0312','PT','PT.04','{\"en\":\"Vila Nova de Famalicão\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.04.0313','PT','PT.04','{\"en\":\"Vila Verde\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.04.0314','PT','PT.04','{\"en\":\"Vizela\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.05.0401','PT','PT.05','{\"en\":\"Alfândega da Fé\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.05.0402','PT','PT.05','{\"en\":\"Bragança Municipality\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.05.0403','PT','PT.05','{\"en\":\"Carrazeda de Ansiães\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.05.0404','PT','PT.05','{\"en\":\"Freixo de Espada À Cinta\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.05.0405','PT','PT.05','{\"en\":\"Macedo de Cavaleiros\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.05.0406','PT','PT.05','{\"en\":\"Miranda do Douro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.05.0407','PT','PT.05','{\"en\":\"Mirandela\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.05.0408','PT','PT.05','{\"en\":\"Mogadouro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.05.0409','PT','PT.05','{\"en\":\"Torre de Moncorvo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.05.0410','PT','PT.05','{\"en\":\"Vila Flor\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.05.0411','PT','PT.05','{\"en\":\"Vimioso\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.05.0412','PT','PT.05','{\"en\":\"Vinhais\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.06.0501','PT','PT.06','{\"en\":\"Belmonte\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.06.0502','PT','PT.06','{\"en\":\"Castelo Branco\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.06.0503','PT','PT.06','{\"en\":\"Covilhã\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.06.0505','PT','PT.06','{\"en\":\"Idanha-A-Nova\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.06.0506','PT','PT.06','{\"en\":\"Oleiros\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.06.0507','PT','PT.06','{\"en\":\"Penamacor\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.06.0508','PT','PT.06','{\"en\":\"Proença-A-Nova\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.06.0509','PT','PT.06','{\"en\":\"Sertã\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.06.0510','PT','PT.06','{\"en\":\"Vila de Rei\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.07.0601','PT','PT.07','{\"en\":\"Arganil\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.07.0602','PT','PT.07','{\"en\":\"Cantanhede\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.07.0603','PT','PT.07','{\"en\":\"Coimbra\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.07.0604','PT','PT.07','{\"en\":\"Condeixa-A-Nova\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.07.0605','PT','PT.07','{\"en\":\"Figueira da Foz\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.07.0606','PT','PT.07','{\"en\":\"Góis\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.07.0607','PT','PT.07','{\"en\":\"Lousã\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.07.0608','PT','PT.07','{\"en\":\"Mira\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.07.0609','PT','PT.07','{\"en\":\"Miranda do Corvo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.07.0610','PT','PT.07','{\"en\":\"Montemor-O-Velho\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.07.0611','PT','PT.07','{\"en\":\"Oliveira do Hospital\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.07.0612','PT','PT.07','{\"en\":\"Pampilhosa da Serra\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.07.0613','PT','PT.07','{\"en\":\"Penacova\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.07.0614','PT','PT.07','{\"en\":\"Penela\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.07.0615','PT','PT.07','{\"en\":\"Soure\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.07.0616','PT','PT.07','{\"en\":\"Tábua\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.07.0617','PT','PT.07','{\"en\":\"Vila Nova de Poiares\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.08.0701','PT','PT.08','{\"en\":\"Alandroal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.08.0702','PT','PT.08','{\"en\":\"Arraiolos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.08.0703','PT','PT.08','{\"en\":\"Borba\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.08.0704','PT','PT.08','{\"en\":\"Estremoz\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.08.0705','PT','PT.08','{\"en\":\"Évora\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.08.0706','PT','PT.08','{\"en\":\"Montemor-O-Novo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.08.0707','PT','PT.08','{\"en\":\"Mora\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.08.0708','PT','PT.08','{\"en\":\"Mourão\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.08.0709','PT','PT.08','{\"en\":\"Portel\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.08.0710','PT','PT.08','{\"en\":\"Redondo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.08.0711','PT','PT.08','{\"en\":\"Reguengos de Monsaraz\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.08.0712','PT','PT.08','{\"en\":\"Vendas Novas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.08.0713','PT','PT.08','{\"en\":\"Viana do Alentejo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.08.0714','PT','PT.08','{\"en\":\"Vila Viçosa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.09.0801','PT','PT.09','{\"en\":\"Albufeira\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.09.0802','PT','PT.09','{\"en\":\"Alcoutim\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.09.0803','PT','PT.09','{\"en\":\"Aljezur\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.09.0804','PT','PT.09','{\"en\":\"Castro Marim\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.09.0805','PT','PT.09','{\"en\":\"Faro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.09.0806','PT','PT.09','{\"en\":\"Lagoa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.09.0807','PT','PT.09','{\"en\":\"Lagos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.09.0808','PT','PT.09','{\"en\":\"Loulé\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.09.0809','PT','PT.09','{\"en\":\"Monchique\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.09.0810','PT','PT.09','{\"en\":\"Olhão\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.09.0811','PT','PT.09','{\"en\":\"Portimão\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.09.0812','PT','PT.09','{\"en\":\"São Brás de Alportel\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.09.0813','PT','PT.09','{\"en\":\"Silves\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.09.0814','PT','PT.09','{\"en\":\"Tavira\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.09.0815','PT','PT.09','{\"en\":\"Vila do Bispo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.09.0816','PT','PT.09','{\"en\":\"Vila Real de Santo António\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.11.0901','PT','PT.11','{\"en\":\"Aguiar da Beira\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.11.0902','PT','PT.11','{\"en\":\"Almeida\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.11.0903','PT','PT.11','{\"en\":\"Celorico da Beira\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.11.0904','PT','PT.11','{\"en\":\"Figueira de Castelo Rodrigo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.11.0905','PT','PT.11','{\"en\":\"Fornos de Algodres\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.11.0907','PT','PT.11','{\"en\":\"Guarda\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.11.0908','PT','PT.11','{\"en\":\"Manteigas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.11.0909','PT','PT.11','{\"en\":\"Mêda\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.11.0910','PT','PT.11','{\"en\":\"Pinhel\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.11.0911','PT','PT.11','{\"en\":\"Sabugal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.11.0912','PT','PT.11','{\"en\":\"Seia\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.11.0913','PT','PT.11','{\"en\":\"Trancoso\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.11.0914','PT','PT.11','{\"en\":\"Vila Nova de Foz Côa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.13.1001','PT','PT.13','{\"en\":\"Alcobaça\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.13.1002','PT','PT.13','{\"en\":\"Alvaiázere\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.13.1003','PT','PT.13','{\"en\":\"Ansião\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.13.1004','PT','PT.13','{\"en\":\"Batalha\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.13.1005','PT','PT.13','{\"en\":\"Bombarral\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.13.1006','PT','PT.13','{\"en\":\"Caldas da Rainha\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.13.1007','PT','PT.13','{\"en\":\"Castanheira de Pêra\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.13.1008','PT','PT.13','{\"en\":\"Figueiró Dos Vinhos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.13.1009','PT','PT.13','{\"en\":\"Leiria\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.13.1010','PT','PT.13','{\"en\":\"Marinha Grande\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.13.1011','PT','PT.13','{\"en\":\"Nazaré\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.13.1012','PT','PT.13','{\"en\":\"Óbidos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.13.1013','PT','PT.13','{\"en\":\"Pedrógão Grande\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.13.1014','PT','PT.13','{\"en\":\"Peniche\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.13.1015','PT','PT.13','{\"en\":\"Pombal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.13.1016','PT','PT.13','{\"en\":\"Porto de Mós\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.14.1101','PT','PT.14','{\"en\":\"Alenquer\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.14.1102','PT','PT.14','{\"en\":\"Arruda Dos Vinhos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.14.1103','PT','PT.14','{\"en\":\"Azambuja\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.14.1104','PT','PT.14','{\"en\":\"Cadaval\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.14.1105','PT','PT.14','{\"en\":\"Cascais\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.14.1108','PT','PT.14','{\"en\":\"Lourinhã\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.14.1109','PT','PT.14','{\"en\":\"Mafra\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.14.1110','PT','PT.14','{\"en\":\"Oeiras\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.14.1111','PT','PT.14','{\"en\":\"Sintra\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.14.1112','PT','PT.14','{\"en\":\"Sobral de Monte Agraço\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.14.1113','PT','PT.14','{\"en\":\"Torres Vedras\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.14.1114','PT','PT.14','{\"en\":\"Vila Franca de Xira\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.14.1115','PT','PT.14','{\"en\":\"Amadora\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.14.1116','PT','PT.14','{\"en\":\"Odivelas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.16.1202','PT','PT.16','{\"en\":\"Arronches\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.16.1203','PT','PT.16','{\"en\":\"Avis\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.16.1204','PT','PT.16','{\"en\":\"Campo Maior\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.16.1207','PT','PT.16','{\"en\":\"Elvas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.16.1208','PT','PT.16','{\"en\":\"Fronteira\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.16.1215','PT','PT.16','{\"en\":\"Sousel\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1301','PT','PT.17','{\"en\":\"Amarante\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1302','PT','PT.17','{\"en\":\"Baião\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1303','PT','PT.17','{\"en\":\"Felgueiras\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1304','PT','PT.17','{\"en\":\"Gondomar\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1305','PT','PT.17','{\"en\":\"Lousada\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1306','PT','PT.17','{\"en\":\"Maia\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1307','PT','PT.17','{\"en\":\"Marco de Canaveses\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1308','PT','PT.17','{\"en\":\"Matosinhos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1309','PT','PT.17','{\"en\":\"Paços de Ferreira\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1310','PT','PT.17','{\"en\":\"Paredes\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1311','PT','PT.17','{\"en\":\"Penafiel\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1313','PT','PT.17','{\"en\":\"Póvoa de Varzim\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1314','PT','PT.17','{\"en\":\"Santo Tirso\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1315','PT','PT.17','{\"en\":\"Valongo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1316','PT','PT.17','{\"en\":\"Vila do Conde\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1317','PT','PT.17','{\"en\":\"Vila Nova de Gaia\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.17.1318','PT','PT.17','{\"en\":\"Trofa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1401','PT','PT.18','{\"en\":\"Abrantes\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1402','PT','PT.18','{\"en\":\"Alcanena\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1403','PT','PT.18','{\"en\":\"Almeirim\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1404','PT','PT.18','{\"en\":\"Alpiarça\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1405','PT','PT.18','{\"en\":\"Benavente\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1406','PT','PT.18','{\"en\":\"Cartaxo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1407','PT','PT.18','{\"en\":\"Chamusca\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1408','PT','PT.18','{\"en\":\"Constância\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1409','PT','PT.18','{\"en\":\"Coruche\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1410','PT','PT.18','{\"en\":\"Entroncamento\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1411','PT','PT.18','{\"en\":\"Ferreira do Zêzere\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1412','PT','PT.18','{\"en\":\"Golegã\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1413','PT','PT.18','{\"en\":\"Mação\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1414','PT','PT.18','{\"en\":\"Rio Maior\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1415','PT','PT.18','{\"en\":\"Salvaterra de Magos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1416','PT','PT.18','{\"en\":\"Santarém\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1417','PT','PT.18','{\"en\":\"Sardoal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1418','PT','PT.18','{\"en\":\"Tomar\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1419','PT','PT.18','{\"en\":\"Torres Novas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1420','PT','PT.18','{\"en\":\"Vila Nova da Barquinha\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.18.1421','PT','PT.18','{\"en\":\"Ourém\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.19.1501','PT','PT.19','{\"en\":\"Alcácer do Sal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.19.1502','PT','PT.19','{\"en\":\"Alcochete\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.19.1503','PT','PT.19','{\"en\":\"Almada\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.19.1504','PT','PT.19','{\"en\":\"Barreiro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.19.1505','PT','PT.19','{\"en\":\"Grândola\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.19.1506','PT','PT.19','{\"en\":\"Moita\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.19.1507','PT','PT.19','{\"en\":\"Montijo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.19.1508','PT','PT.19','{\"en\":\"Palmela\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.19.1509','PT','PT.19','{\"en\":\"Santiago do Cacém\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.19.1511','PT','PT.19','{\"en\":\"Sesimbra\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.19.1512','PT','PT.19','{\"en\":\"Setúbal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.19.1513','PT','PT.19','{\"en\":\"Sines\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.20.1601','PT','PT.20','{\"en\":\"Arcos de Valdevez\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.20.1602','PT','PT.20','{\"en\":\"Caminha\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.20.1603','PT','PT.20','{\"en\":\"Melgaço\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.20.1604','PT','PT.20','{\"en\":\"Monção\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.20.1605','PT','PT.20','{\"en\":\"Paredes de Coura\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.20.1606','PT','PT.20','{\"en\":\"Ponte da Barca\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.20.1607','PT','PT.20','{\"en\":\"Ponte de Lima\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.20.1608','PT','PT.20','{\"en\":\"Valença\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.20.1609','PT','PT.20','{\"en\":\"Viana do Castelo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.20.1610','PT','PT.20','{\"en\":\"Vila Nova de Cerveira\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.21.1701','PT','PT.21','{\"en\":\"Alijó\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.21.1702','PT','PT.21','{\"en\":\"Boticas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.21.1703','PT','PT.21','{\"en\":\"Chaves\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.21.1704','PT','PT.21','{\"en\":\"Mesão Frio\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.21.1705','PT','PT.21','{\"en\":\"Mondim de Basto\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.21.1706','PT','PT.21','{\"en\":\"Montalegre\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.21.1707','PT','PT.21','{\"en\":\"Murça\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.21.1708','PT','PT.21','{\"en\":\"Peso da Régua\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.21.1709','PT','PT.21','{\"en\":\"Ribeira de Pena\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.21.1710','PT','PT.21','{\"en\":\"Sabrosa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.21.1711','PT','PT.21','{\"en\":\"Santa Marta de Penaguião\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.21.1712','PT','PT.21','{\"en\":\"Valpaços\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.21.1713','PT','PT.21','{\"en\":\"Vila Pouca de Aguiar\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.21.1714','PT','PT.21','{\"en\":\"Vila Real\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1801','PT','PT.22','{\"en\":\"Armamar\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1803','PT','PT.22','{\"en\":\"Castro Daire\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1804','PT','PT.22','{\"en\":\"Cinfães\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1805','PT','PT.22','{\"en\":\"Lamego\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1806','PT','PT.22','{\"en\":\"Mangualde\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1807','PT','PT.22','{\"en\":\"Moimenta da Beira\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1808','PT','PT.22','{\"en\":\"Mortágua\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1809','PT','PT.22','{\"en\":\"Nelas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1810','PT','PT.22','{\"en\":\"Oliveira de Frades\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1811','PT','PT.22','{\"en\":\"Penalva do Castelo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1812','PT','PT.22','{\"en\":\"Penedono\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1813','PT','PT.22','{\"en\":\"Resende\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1814','PT','PT.22','{\"en\":\"Santa Comba Dão\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1815','PT','PT.22','{\"en\":\"São João da Pesqueira\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1816','PT','PT.22','{\"en\":\"São Pedro do Sul\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1817','PT','PT.22','{\"en\":\"Sátão\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1818','PT','PT.22','{\"en\":\"Sernancelhe\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1819','PT','PT.22','{\"en\":\"Tabuaço\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1820','PT','PT.22','{\"en\":\"Tarouca\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1822','PT','PT.22','{\"en\":\"Vila Nova de Paiva\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1823','PT','PT.22','{\"en\":\"Viseu\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.22.1824','PT','PT.22','{\"en\":\"Vouzela\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.10.3101','PT','PT.10','{\"en\":\"Calheta\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.10.3102','PT','PT.10','{\"en\":\"Câmara de Lobos\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.10.3103','PT','PT.10','{\"en\":\"Funchal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.10.3104','PT','PT.10','{\"en\":\"Machico\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.10.3105','PT','PT.10','{\"en\":\"Ponta do Sol\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.10.3106','PT','PT.10','{\"en\":\"Porto Moniz\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.10.3107','PT','PT.10','{\"en\":\"Ribeira Brava\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.10.3108','PT','PT.10','{\"en\":\"Santa Cruz\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.10.3109','PT','PT.10','{\"en\":\"Santana\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.10.3110','PT','PT.10','{\"en\":\"São Vicente\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.10.3201','PT','PT.10','{\"en\":\"Porto Santo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4101','PT','PT.23','{\"en\":\"Vila do Porto\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4201','PT','PT.23','{\"en\":\"Lagoa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4202','PT','PT.23','{\"en\":\"Nordeste\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4203','PT','PT.23','{\"en\":\"Ponta Delgada\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4204','PT','PT.23','{\"en\":\"Povoação\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4205','PT','PT.23','{\"en\":\"Ribeira Grande\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4206','PT','PT.23','{\"en\":\"Vila Franca do Campo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4301','PT','PT.23','{\"en\":\"Angra do Heroísmo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4302','PT','PT.23','{\"en\":\"Praia da Vitória\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4401','PT','PT.23','{\"en\":\"Santa Cruz da Graciosa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4501','PT','PT.23','{\"en\":\"Calheta de São Jorge\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4502','PT','PT.23','{\"en\":\"Velas\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4601','PT','PT.23','{\"en\":\"Lajes do Pico\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4602','PT','PT.23','{\"en\":\"Madalena\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4603','PT','PT.23','{\"en\":\"São Roque do Pico\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4701','PT','PT.23','{\"en\":\"Horta\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4801','PT','PT.23','{\"en\":\"Lajes Das Flores\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4802','PT','PT.23','{\"en\":\"Santa Cruz Das Flores\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('PT.23.4901','PT','PT.23','{\"en\":\"Corvo\"}',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 ('PT','{\"en\":\"Vila Viçosa\"}',-7.42,38.78,'P','PPLA2','PT.08','PT.08.0714',8319,'Europe/Lisbon',1,'2017-11-08 23:00:00','2017-11-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 ('PT','{\"en\":\"Vila Real de Santo António\"}',-7.42,37.20,'P','PPLA2','PT.09','PT.09.0816',11560,'Europe/Lisbon',1,'2018-04-30 23:00:00','2018-04-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 ('PT','{\"en\":\"Vila Nova da Barquinha\"}',-8.44,39.46,'P','PPLA2','PT.18','PT.18.1407',7322,'Europe/Lisbon',1,'2018-05-22 23:00:00','2018-05-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 ('PT','{\"en\":\"Vila Franca de Xira\"}',-8.99,38.96,'P','PPLA2','PT.14','PT.14.1114',18355,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Vieira de Leiria\"}',-8.93,39.87,'P','PPL','PT.13','PT.13.1010',5807,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Vidigueira\"}',-7.80,38.21,'P','PPLA2','PT.03','PT.03.0214',5932,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Vialonga\"}',-9.08,38.87,'P','PPL','PT.14','PT.14.1114',16088,'Europe/Lisbon',1,'2018-01-14 23:00:00','2018-01-14 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Ventosa\"}',-9.08,39.13,'P','PPL','PT.14','PT.14.1101',5215,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-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 ('PT','{\"en\":\"Vendas Novas\"}',-8.46,38.68,'P','PPLA2','PT.08','PT.08.0712',11248,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Vale da Amoreira\"}',-7.70,39.07,'P','PPL','PT.16','PT.16.1208',10828,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Unhos\"}',-9.12,38.82,'P','PPL','PT.14','PT.14.1107',10712,'Europe/Lisbon',1,'2018-01-30 23:00:00','2018-01-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 ('PT','{\"en\":\"Trafaria\"}',-9.23,38.67,'P','PPL','PT.19','PT.19.1503',5603,'Europe/Lisbon',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Torres Vedras\"}',-9.26,39.09,'P','PPLA2','PT.14','PT.14.1113',24443,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Torres Novas\"}',-8.54,39.48,'P','PPLA2','PT.18','PT.18.1419',15002,'Europe/Lisbon',1,'2019-02-17 23:00:00','2019-02-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 ('PT','{\"en\":\"Tomar\"}',-8.41,39.60,'P','PPLA2','PT.18','PT.18.1418',19168,'Europe/Lisbon',1,'2018-02-09 23:00:00','2018-02-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 ('PT','{\"en\":\"Tavira\"}',-7.65,37.13,'P','PPLA2','PT.09','PT.09.0814',15133,'Europe/Lisbon',1,'2018-08-23 23:00:00','2018-08-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 ('PT','{\"en\":\"Sobreda\"}',-9.19,38.65,'P','PPL','PT.19','PT.19.1503',11146,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-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 ('PT','{\"en\":\"Sintra\"}',-9.38,38.80,'P','PPLA2','PT.14','PT.14.1111',26193,'Europe/Lisbon',1,'2021-01-25 23:00:00','2021-01-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 ('PT','{\"en\":\"Sines\"}',-8.87,37.96,'P','PPLA2','PT.19','PT.19.1513',12791,'Europe/Lisbon',1,'2020-02-03 23:00:00','2020-02-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 ('PT','{\"en\":\"Silves\"}',-8.44,37.19,'P','PPLA2','PT.09','PT.09.0813',10917,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Silveira\"}',-9.36,39.11,'P','PPL','PT.14','PT.14.1113',6942,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Sesimbra\"}',-9.10,38.44,'P','PPL','PT.19','PT.19.1511',41134,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Setúbal\"}',-8.89,38.52,'P','PPLA','PT.19','PT.19.1512',117110,'Europe/Lisbon',1,'2019-09-13 23:00:00','2019-09-13 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Sertã\"}',-8.10,39.80,'P','PPLA2','PT.06','PT.06.0509',5636,'Europe/Lisbon',1,'2018-05-16 23:00:00','2018-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 ('PT','{\"en\":\"Serpa\"}',-7.60,37.95,'P','PPLA2','PT.03','PT.03.0213',6586,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"São Vicente\"}',-17.04,32.80,'P','PPL','PT.10','PT.10.3110',6063,'Atlantic/Madeira',1,'2020-01-15 23:00:00','2020-01-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 ('PT','{\"en\":\"São Roque\"}',-16.92,32.67,'P','PPL','PT.10','PT.10.3103',9385,'Atlantic/Madeira',1,'2018-01-10 23:00:00','2018-01-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 ('PT','{\"en\":\"São Martinho\"}',-16.94,32.64,'P','PPL','PT.10','PT.10.3103',26482,'Atlantic/Madeira',1,'2018-02-08 23:00:00','2018-02-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 ('PT','{\"en\":\"São João da Talha\"}',-9.10,38.82,'P','PPL','PT.14','PT.14.1107',18925,'Europe/Lisbon',1,'2018-01-28 23:00:00','2018-01-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 ('PT','{\"en\":\"São João das Lampas\"}',-9.40,38.87,'P','PPL','PT.14','PT.14.1111',10484,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-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 ('PT','{\"en\":\"São Domingos de Rana\"}',-9.34,38.70,'P','PPL','PT.14','PT.14.1105',46718,'Europe/Lisbon',1,'2018-02-12 23:00:00','2018-02-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 ('PT','{\"en\":\"São Brás de Alportel\"}',-7.89,37.15,'P','PPLA2','PT.09','PT.09.0812',11153,'Europe/Lisbon',1,'2020-06-09 23:00:00','2020-06-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 ('PT','{\"en\":\"São Bartolomeu de Messines\"}',-8.29,37.26,'P','PPL','PT.09','PT.09.0813',8381,'Europe/Lisbon',1,'2018-01-31 23:00:00','2018-01-31 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Santo António da Charneca\"}',-9.03,38.63,'P','PPL','PT.19','PT.19.1504',11143,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Santo André\"}',-8.24,39.06,'P','PPL','PT.16','PT.16.1213',11213,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Santo André\"}',-8.78,38.06,'P','PPL','PT.19','PT.19.1509',10601,'Europe/Lisbon',1,'2019-09-18 23:00:00','2019-09-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 ('PT','{\"en\":\"Santiago do Cacém\"}',-8.69,38.02,'P','PPLA2','PT.19','PT.19.1509',7797,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Santarém\"}',-8.68,39.23,'P','PPLA','PT.18','PT.18.1416',29385,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Santana\"}',-16.88,32.80,'P','PPL','PT.10','PT.10.3109',8804,'Atlantic/Madeira',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Santa Iria da Azóia\"}',-9.10,38.84,'P','PPL','PT.14','PT.14.1107',18573,'Europe/Lisbon',1,'2018-05-15 23:00:00','2018-05-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 ('PT','{\"en\":\"Santa Cruz\"}',-16.79,32.69,'P','PPL','PT.10','PT.10.3108',6010,'Atlantic/Madeira',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 ('PT','{\"en\":\"Samora Correia\"}',-8.87,38.94,'P','PPL','PT.18','PT.18.1405',14154,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Salvaterra de Magos\"}',-8.79,39.03,'P','PPLA2','PT.18','PT.18.1415',5165,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Sacavém\"}',-9.11,38.79,'P','PPL','PT.14','PT.14.1107',17718,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-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 ('PT','{\"en\":\"Rio Maior\"}',-8.94,39.34,'P','PPLA2','PT.18','PT.18.1414',12064,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Rio de Mouro\"}',-9.33,38.77,'P','PPL','PT.14','PT.14.1111',54695,'Europe/Lisbon',1,'2018-02-13 23:00:00','2018-02-13 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Ribeira Brava\"}',-17.06,32.67,'P','PPL','PT.10','PT.10.3107',5932,'Atlantic/Madeira',1,'2018-02-28 23:00:00','2018-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 ('PT','{\"en\":\"Riachos\"}',-8.51,39.44,'P','PPL','PT.18','PT.18.1419',5463,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Reguengos de Monsaraz\"}',-7.53,38.43,'P','PPLA2','PT.08','PT.08.0711',7217,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Redondo\"}',-7.55,38.65,'P','PPLA2','PT.08','PT.08.0710',5845,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Ramada\"}',-9.19,38.80,'P','PPL','PT.14','PT.14.1116',17535,'Europe/Lisbon',1,'2018-02-13 23:00:00','2018-02-13 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Quinta do Anjo\"}',-8.94,38.57,'P','PPL','PT.19','PT.19.1508',9124,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Queluz\"}',-9.25,38.76,'P','PPL','PT.14','PT.14.1111',103399,'Europe/Lisbon',1,'2020-07-14 23:00:00','2020-07-14 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Queijas\"}',-9.26,38.72,'P','PPLA3','PT.14','PT.14.1110',8828,'Europe/Lisbon',1,'2019-01-12 23:00:00','2019-01-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 ('PT','{\"en\":\"Quarteira\"}',-8.10,37.07,'P','PPL','PT.09','PT.09.0808',18783,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Pragal\"}',-9.17,38.67,'P','PPL','PT.19','PT.19.1503',7701,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-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 ('PT','{\"en\":\"Póvoa de Santo Adrião\"}',-9.17,38.80,'P','PPL','PT.14','PT.14.1116',14897,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Póvoa de Santa Iria\"}',-9.06,38.86,'P','PPL','PT.14','PT.14.1114',28901,'Europe/Lisbon',1,'2020-06-09 23:00:00','2020-06-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 ('PT','{\"en\":\"Porto Salvo\"}',-9.30,38.72,'P','PPL','PT.14','PT.14.1110',13867,'Europe/Lisbon',1,'2018-08-30 23:00:00','2018-08-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 ('PT','{\"en\":\"Porto de Mós\"}',-8.82,39.60,'P','PPLA2','PT.13','PT.13.1016',6032,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Portimão\"}',-8.54,37.14,'P','PPL','PT.09','PT.09.0811',38487,'Europe/Lisbon',1,'2018-06-04 23:00:00','2018-06-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 ('PT','{\"en\":\"Portalegre\"}',-7.43,39.29,'P','PPLA','PT.16','PT.16.1214',15581,'Europe/Lisbon',1,'2019-03-28 23:00:00','2019-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 ('PT','{\"en\":\"Pontinha\"}',-9.20,38.77,'P','PPL','PT.14','PT.14.1116',23249,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Ponte de Sôr\"}',-8.01,39.25,'P','PPLA2','PT.16','PT.16.1213',11062,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Pombal\"}',-8.63,39.92,'P','PPLA2','PT.13','PT.13.1015',17355,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Pinhal Novo\"}',-8.91,38.63,'P','PPL','PT.19','PT.19.1508',23510,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Piedade\"}',-9.16,38.67,'P','PPL','PT.19','PT.19.1503',19472,'Europe/Lisbon',1,'2018-01-30 23:00:00','2018-01-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 ('PT','{\"en\":\"Peniche\"}',-9.38,39.36,'P','PPL','PT.13','PT.13.1014',15662,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-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 ('PT','{\"en\":\"Pataias\"}',-9.00,39.67,'P','PPL','PT.13','PT.13.1001',5510,'Europe/Lisbon',1,'2020-07-19 23:00:00','2020-07-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 ('PT','{\"en\":\"Parede\"}',-9.35,38.69,'P','PPL','PT.14','PT.14.1105',17212,'Europe/Lisbon',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Palmela\"}',-8.90,38.57,'P','PPLA2','PT.19','PT.19.1508',16934,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Paço de Arcos\"}',-9.29,38.70,'P','PPL','PT.14','PT.14.1110',25974,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-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 ('PT','{\"en\":\"Ourém\"}',-8.59,39.64,'P','PPLA2','PT.18','PT.18.1421',12729,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Olival Basto\"}',-9.17,38.79,'P','PPL','PT.14','PT.14.1116',5959,'Europe/Lisbon',1,'2021-07-08 23:00:00','2021-07-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 ('PT','{\"en\":\"Olivais\"}',-9.11,38.77,'P','PPL','PT.14','PT.14.1106',33788,'Europe/Lisbon',1,'2018-03-14 23:00:00','2018-03-14 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Olhão\"}',-7.84,37.03,'P','PPLA2','PT.09','PT.09.0810',29239,'Europe/Lisbon',1,'2020-02-04 23:00:00','2020-02-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 ('PT','{\"en\":\"Oleiros\"}',-7.91,39.92,'P','PPLA2','PT.06','PT.06.0506',5721,'Europe/Lisbon',1,'2018-09-10 23:00:00','2018-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 ('PT','{\"en\":\"Oeiras\"}',-9.31,38.69,'P','PPLA2','PT.14','PT.14.1110',35000,'Europe/Lisbon',1,'2018-03-08 23:00:00','2018-03-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 ('PT','{\"en\":\"Odivelas\"}',-9.18,38.79,'P','PPL','PT.14','PT.14.1116',54624,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-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 ('PT','{\"en\":\"Odemira\"}',-8.64,37.60,'P','PPL','PT.03','PT.03.0211',5830,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Óbidos\"}',-9.16,39.36,'P','PPLA2','PT.13','PT.13.1012',11187,'Europe/Lisbon',1,'2018-02-09 23:00:00','2018-02-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 ('PT','{\"en\":\"Nossa Senhora do Monte\"}',-16.90,32.67,'P','PPL','PT.10','PT.10.3103',7444,'Atlantic/Madeira',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Nisa\"}',-7.65,39.51,'P','PPLA2','PT.16','PT.16.1212',7450,'Europe/Lisbon',1,'2018-06-26 23:00:00','2018-06-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 ('PT','{\"en\":\"Nazaré\"}',-9.07,39.60,'P','PPLA2','PT.13','PT.13.1011',8993,'Europe/Lisbon',1,'2018-02-09 23:00:00','2018-02-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 ('PT','{\"en\":\"Moura\"}',-7.45,38.14,'P','PPLA2','PT.03','PT.03.0210',9360,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Moscavide e Portela\"}',-9.10,38.78,'P','PPL','PT.14','PT.14.1107',22488,'Europe/Lisbon',1,'2018-03-14 23:00:00','2018-03-14 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Montijo\"}',-8.97,38.71,'P','PPLA2','PT.19','PT.19.1507',30011,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Monte Real\"}',-8.86,39.85,'P','PPL','PT.13','PT.13.1009',5756,'Europe/Lisbon',1,'2018-02-13 23:00:00','2018-02-13 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Montemor-o-Novo\"}',-8.21,38.65,'P','PPLA2','PT.08','PT.08.0706',12854,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Monte Estoril\"}',-9.41,38.71,'P','PPL','PT.14','PT.14.1105',23375,'Europe/Lisbon',1,'2018-02-05 23:00:00','2018-02-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 ('PT','{\"en\":\"Monsanto\"}',-8.71,39.46,'P','PPL','PT.18','PT.18.1402',50000,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Monchique\"}',-8.56,37.32,'P','PPLA2','PT.09','PT.09.0809',5421,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Moncarapacho\"}',-7.79,37.08,'P','PPL','PT.09','PT.09.0810',8545,'Europe/Lisbon',1,'2018-01-30 23:00:00','2018-01-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 ('PT','{\"en\":\"Moita\"}',-8.99,38.65,'P','PPLA2','PT.19','PT.19.1506',17795,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Milharado\"}',-9.20,38.95,'P','PPL','PT.14','PT.14.1109',5935,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Mértola\"}',-7.66,37.64,'P','PPLA2','PT.03','PT.03.0209',7274,'Europe/Lisbon',1,'2018-03-14 23:00:00','2018-03-14 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Mem Martins\"}',-9.34,38.79,'P','PPL','PT.14','PT.14.1111',9000,'Europe/Lisbon',1,'2018-05-17 23:00:00','2018-05-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 ('PT','{\"en\":\"Massamá\"}',-9.28,38.75,'P','PPL','PT.14','PT.14.1111',28112,'Europe/Lisbon',1,'2021-01-20 23:00:00','2021-01-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 ('PT','{\"en\":\"Marinhais\"}',-8.70,39.05,'P','PPL','PT.18','PT.18.1415',5788,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Marinha Grande\"}',-8.93,39.75,'P','PPLA2','PT.13','PT.13.1010',28916,'Europe/Lisbon',1,'2018-04-30 23:00:00','2018-04-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 ('PT','{\"en\":\"Mafra\"}',-9.33,38.94,'P','PPLA2','PT.14','PT.14.1109',12259,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Machico\"}',-16.77,32.72,'P','PPL','PT.10','PT.10.3104',12567,'Atlantic/Madeira',1,'2017-09-15 23:00:00','2017-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 ('PT','{\"en\":\"Maceira\"}',-8.89,39.69,'P','PPL','PT.13','PT.13.1009',9831,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Lourinhã\"}',-9.31,39.24,'P','PPLA2','PT.14','PT.14.1108',9196,'Europe/Lisbon',1,'2018-01-14 23:00:00','2018-01-14 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Louriçal\"}',-8.74,40.00,'P','PPL','PT.13','PT.13.1015',5085,'Europe/Lisbon',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Loures\"}',-9.17,38.83,'P','PPL','PT.14','PT.14.1107',66231,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Loulé\"}',-8.02,37.14,'P','PPLA2','PT.09','PT.09.0808',23109,'Europe/Lisbon',1,'2018-04-30 23:00:00','2018-04-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 ('PT','{\"en\":\"Lisbon\"}',-9.13,38.72,'P','PPLC','PT.14','PT.14.1106',517802,'Europe/Lisbon',1,'2019-07-11 23:00:00','2019-07-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 ('PT','{\"en\":\"Linda-a-Velha\"}',-9.24,38.71,'P','PPL','PT.14','PT.14.1110',20895,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Leiria\"}',-8.81,39.74,'P','PPLA','PT.13','PT.13.1009',45112,'Europe/Lisbon',1,'2017-04-01 23:00:00','2017-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 ('PT','{\"en\":\"Lavradio\"}',-9.05,38.67,'P','PPL','PT.19','PT.19.1504',21877,'Europe/Lisbon',1,'2018-02-21 23:00:00','2018-02-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 ('PT','{\"en\":\"Laranjeiro\"}',-7.81,37.07,'P','PPL','PT.09','PT.09.0810',20473,'Europe/Lisbon',1,'2018-01-30 23:00:00','2018-01-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 ('PT','{\"en\":\"Laranjeira\"}',-9.15,38.66,'P','PPL','PT.19','PT.19.1503',20988,'Europe/Lisbon',1,'2018-02-10 23:00:00','2018-02-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 ('PT','{\"en\":\"Lagos\"}',-8.67,37.10,'P','PPL','PT.09','PT.09.0807',18831,'Europe/Lisbon',1,'2018-09-13 23:00:00','2018-09-13 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Lagoa\"}',-8.45,37.14,'P','PPLA2','PT.09','PT.09.0806',6301,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Grândola\"}',-8.57,38.18,'P','PPLA2','PT.19','PT.19.1505',10737,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Funchal\"}',-16.93,32.67,'P','PPLA','PT.10','PT.10.3103',100847,'Atlantic/Madeira',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 ('PT','{\"en\":\"Fontanelas\"}',-9.44,38.85,'P','PPL','PT.14','PT.14.1111',6001,'Europe/Lisbon',1,'2018-11-10 23:00:00','2018-11-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 ('PT','{\"en\":\"Ferreiras\"}',-8.24,37.13,'P','PPL','PT.09','PT.09.0801',5157,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Fazendas de Almeirim\"}',-8.57,39.18,'P','PPL','PT.18','PT.18.1403',6635,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-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 ('PT','{\"en\":\"Fátima\"}',-8.65,39.62,'P','PPL','PT.18','PT.18.1421',11798,'Europe/Lisbon',1,'2018-03-14 23:00:00','2018-03-14 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Faro\"}',-7.93,37.02,'P','PPLA','PT.09','PT.09.0805',41355,'Europe/Lisbon',1,'2019-02-17 23:00:00','2019-02-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 ('PT','{\"en\":\"Famões\"}',-9.21,38.79,'P','PPL','PT.14','PT.14.1116',9435,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Évora\"}',-7.90,38.57,'P','PPLA','PT.08','PT.08.0705',55620,'Europe/Lisbon',1,'2018-04-30 23:00:00','2018-04-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 ('PT','{\"en\":\"Estremoz\"}',-7.59,38.84,'P','PPLA2','PT.08','PT.08.0704',9350,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Estoril\"}',-9.40,38.71,'P','PPL','PT.14','PT.14.1105',23700,'Europe/Lisbon',1,'2018-02-09 23:00:00','2018-02-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 ('PT','{\"en\":\"Estômbar\"}',-8.49,37.15,'P','PPL','PT.09','PT.09.0806',8590,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-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 ('PT','{\"en\":\"Ericeira\"}',-9.42,38.96,'P','PPL','PT.14','PT.14.1109',7538,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-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 ('PT','{\"en\":\"Entroncamento\"}',-8.47,39.47,'P','PPLA2','PT.18','PT.18.1410',19887,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Elvas\"}',-7.16,38.88,'P','PPLA2','PT.16','PT.16.1207',9904,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Costa de Caparica\"}',-9.24,38.64,'P','PPL','PT.19','PT.19.1503',14231,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-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 ('PT','{\"en\":\"Coruche\"}',-8.53,38.96,'P','PPLA2','PT.18','PT.18.1409',8776,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Corroios\"}',-9.15,38.64,'P','PPL','PT.19','PT.19.1510',52520,'Europe/Lisbon',1,'2018-01-30 23:00:00','2018-01-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 ('PT','{\"en\":\"Colares\"}',-9.45,38.80,'P','PPL','PT.14','PT.14.1111',7905,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Charneca\"}',-9.14,38.78,'P','PPL','PT.14','PT.14.1107',10509,'Europe/Lisbon',1,'2018-02-21 23:00:00','2018-02-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 ('PT','{\"en\":\"Charneca de Caparica\"}',-9.19,38.62,'P','PPL','PT.19','PT.19.1503',29763,'Europe/Lisbon',1,'2018-02-21 23:00:00','2018-02-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 ('PT','{\"en\":\"Caxias\"}',-9.28,38.70,'P','PPL','PT.14','PT.14.1110',9007,'Europe/Lisbon',1,'2018-01-30 23:00:00','2018-01-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 ('PT','{\"en\":\"Castro Marim\"}',-7.44,37.22,'P','PPLA2','PT.09','PT.09.0804',5089,'Europe/Lisbon',1,'2018-05-08 23:00:00','2018-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 ('PT','{\"en\":\"Castelo Branco\"}',-7.49,39.82,'P','PPLA','PT.06','PT.06.0502',33479,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Castanheira do Ribatejo\"}',-8.97,38.99,'P','PPL','PT.14','PT.14.1114',7651,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Cascais\"}',-9.42,38.70,'P','PPL','PT.14','PT.14.1105',36436,'Europe/Lisbon',1,'2017-07-02 23:00:00','2017-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 ('PT','{\"en\":\"Cartaxo\"}',-8.79,39.16,'P','PPLA2','PT.18','PT.18.1406',10502,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Carregado\"}',-8.98,39.02,'P','PPL','PT.14','PT.14.1101',10474,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Carnaxide\"}',-9.25,38.73,'P','PPL','PT.14','PT.14.1110',23698,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Carcavelos\"}',-9.32,38.69,'P','PPL','PT.14','PT.14.1110',20366,'Europe/Lisbon',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Caranguejeira\"}',-8.71,39.75,'P','PPL','PT.13','PT.13.1009',5248,'Europe/Lisbon',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Caparica\"}',-9.20,38.66,'P','PPL','PT.19','PT.19.1503',21167,'Europe/Lisbon',1,'2018-02-05 23:00:00','2018-02-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 ('PT','{\"en\":\"Caniço\"}',-16.84,32.65,'P','PPLA3','PT.10','PT.10.3108',23368,'Atlantic/Madeira',1,'2019-10-09 23:00:00','2019-10-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 ('PT','{\"en\":\"Caneças\"}',-9.23,38.81,'P','PPL','PT.14','PT.14.1116',10978,'Europe/Lisbon',1,'2016-03-09 23:00:00','2016-03-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 ('PT','{\"en\":\"Campo Maior\"}',-7.06,39.02,'P','PPLA2','PT.16','PT.16.1204',8235,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Camarate\"}',-9.13,38.80,'P','PPL','PT.14','PT.14.1107',20177,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Câmara de Lobos\"}',-16.98,32.65,'P','PPL','PT.10','PT.10.3102',32209,'Atlantic/Madeira',1,'2018-02-08 23:00:00','2018-02-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 ('PT','{\"en\":\"Camacha\"}',-16.84,32.68,'P','PPL','PT.10','PT.10.3108',7991,'Atlantic/Madeira',1,'2011-09-03 23:00:00','2011-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 ('PT','{\"en\":\"Caldas da Rainha\"}',-9.14,39.40,'P','PPLA2','PT.13','PT.13.1006',27378,'Europe/Lisbon',1,'2018-02-07 23:00:00','2018-02-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 ('PT','{\"en\":\"Cacilhas\"}',-9.15,38.69,'P','PPL','PT.19','PT.19.1503',6494,'Europe/Lisbon',1,'2018-02-10 23:00:00','2018-02-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 ('PT','{\"en\":\"Cacém\"}',-9.30,38.77,'P','PPL','PT.14','PT.14.1111',93982,'Europe/Lisbon',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Bombarral\"}',-9.16,39.27,'P','PPLA2','PT.13','PT.13.1005',5852,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Bobadela\"}',-9.10,38.81,'P','PPL','PT.14','PT.14.1107',8399,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-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 ('PT','{\"en\":\"Benedita\"}',-8.97,39.42,'P','PPL','PT.13','PT.13.1001',8556,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Benavente\"}',-8.81,38.98,'P','PPLA2','PT.18','PT.18.1405',8932,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Benfica\"}',-9.20,38.75,'P','PPL','PT.14','PT.14.1106',36985,'Europe/Lisbon',1,'2018-02-19 23:00:00','2018-02-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 ('PT','{\"en\":\"Belas\"}',-9.26,38.78,'P','PPL','PT.14','PT.14.1111',21019,'Europe/Lisbon',1,'2018-02-05 23:00:00','2018-02-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 ('PT','{\"en\":\"Beja\"}',-7.86,38.02,'P','PPLA','PT.03','PT.03.0205',34760,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Beato António\"}',-9.10,38.73,'P','PPL','PT.14','PT.14.1106',12737,'Europe/Lisbon',1,'2020-06-09 23:00:00','2020-06-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 ('PT','{\"en\":\"Batalha\"}',-8.82,39.66,'P','PPLA2','PT.13','PT.13.1004',7910,'Europe/Lisbon',1,'2018-04-30 23:00:00','2018-04-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 ('PT','{\"en\":\"Barreiro\"}',-9.07,38.66,'P','PPLA2','PT.19','PT.19.1504',51280,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Barcarena\"}',-9.28,38.73,'P','PPL','PT.14','PT.14.1110',11968,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Azambuja\"}',-8.87,39.07,'P','PPLA2','PT.14','PT.14.1103',7179,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Atouguia da Baleia\"}',-9.33,39.34,'P','PPL','PT.13','PT.13.1014',8313,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Arruda dos Vinhos\"}',-9.08,38.98,'P','PPLA2','PT.14','PT.14.1102',6170,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Arrentela\"}',-9.10,38.62,'P','PPL','PT.19','PT.19.1510',30156,'Europe/Lisbon',1,'2018-02-08 23:00:00','2018-02-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 ('PT','{\"en\":\"Apelação\"}',-9.13,38.81,'P','PPL','PT.14','PT.14.1107',7182,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Amora\"}',-9.12,38.63,'P','PPL','PT.19','PT.19.1510',52577,'Europe/Lisbon',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Amadora\"}',-9.23,38.75,'P','PPL','PT.14','PT.14.1115',178858,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Alvor\"}',-8.59,37.13,'P','PPL','PT.09','PT.09.0811',5272,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-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 ('PT','{\"en\":\"Alpiarça\"}',-8.58,39.26,'P','PPLA2','PT.18','PT.18.1404',7946,'Europe/Lisbon',1,'2018-03-20 23:00:00','2018-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 ('PT','{\"en\":\"Almodôvar\"}',-8.06,37.51,'P','PPLA2','PT.03','PT.03.0202',7449,'Europe/Lisbon',1,'2018-03-20 23:00:00','2018-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 ('PT','{\"en\":\"Almeirim\"}',-8.63,39.21,'P','PPLA2','PT.18','PT.18.1403',11557,'Europe/Lisbon',1,'2018-05-20 23:00:00','2018-05-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 ('PT','{\"en\":\"Almargem\"}',-9.27,38.84,'P','PPL','PT.14','PT.14.1111',8271,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Almancil\"}',-8.03,37.09,'P','PPL','PT.09','PT.09.0808',9898,'Europe/Lisbon',1,'2015-11-12 23:00:00','2015-11-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 ('PT','{\"en\":\"Almada\"}',-9.16,38.68,'P','PPLA2','PT.19','PT.19.1503',34008,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Aljustrel\"}',-8.17,37.88,'P','PPLA2','PT.03','PT.03.0201',5334,'Europe/Lisbon',1,'2018-03-20 23:00:00','2018-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 ('PT','{\"en\":\"Aljubarrota\"}',-8.93,39.57,'P','PPL','PT.13','PT.13.1001',6146,'Europe/Lisbon',1,'2016-03-09 23:00:00','2016-03-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 ('PT','{\"en\":\"Aljezur\"}',-8.80,37.32,'P','PPLA2','PT.09','PT.09.0803',5884,'Europe/Lisbon',1,'2018-03-14 23:00:00','2018-03-14 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Alhos Vedros\"}',-9.02,38.65,'P','PPL','PT.19','PT.19.1506',13384,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-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 ('PT','{\"en\":\"Alhandra\"}',-9.01,38.93,'P','PPL','PT.14','PT.14.1114',7226,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Algueirão\"}',-9.34,38.80,'P','PPL','PT.14','PT.14.1111',66250,'Europe/Lisbon',1,'2018-02-06 23:00:00','2018-02-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 ('PT','{\"en\":\"Algés\"}',-9.23,38.70,'P','PPL','PT.14','PT.14.1110',19327,'Europe/Lisbon',1,'2019-01-13 23:00:00','2019-01-13 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Alenquer\"}',-9.01,39.05,'P','PPLA2','PT.14','PT.14.1101',9626,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Aldeia de Paio Pires\"}',-9.08,38.62,'P','PPL','PT.19','PT.19.1510',12179,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Alcochete\"}',-8.96,38.76,'P','PPLA2','PT.19','PT.19.1502',9705,'Europe/Lisbon',1,'2019-01-13 23:00:00','2019-01-13 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Alcobaça\"}',-8.98,39.55,'P','PPLA2','PT.13','PT.13.1001',15800,'Europe/Lisbon',1,'2018-05-22 23:00:00','2018-05-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 ('PT','{\"en\":\"Alcanede\"}',-8.82,39.42,'P','PPL','PT.18','PT.18.1416',5020,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Alcains\"}',-7.46,39.92,'P','PPL','PT.11',NULL,5030,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-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 ('PT','{\"en\":\"Alcácer do Sal\"}',-8.51,38.37,'P','PPLA2','PT.19','PT.19.1501',9198,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Alcabideche\"}',-9.41,38.73,'P','PPL','PT.14','PT.14.1105',33315,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Albufeira\"}',-8.25,37.09,'P','PPL','PT.09','PT.09.0801',15851,'Europe/Lisbon',1,'2015-11-12 23:00:00','2015-11-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 ('PT','{\"en\":\"A dos Cunhados\"}',-9.30,39.15,'P','PPL','PT.14','PT.14.1113',6594,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Abrantes\"}',-8.20,39.47,'P','PPLA2','PT.18','PT.18.1401',13646,'Europe/Lisbon',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 ('PT','{\"en\":\"Viseu\"}',-7.91,40.66,'P','PPLA','PT.22','PT.22.1823',26364,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Vinhais\"}',-7.01,41.84,'P','PPLA2','PT.05','PT.05.0412',9066,'Europe/Lisbon',1,'2018-02-10 23:00:00','2018-02-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 ('PT','{\"en\":\"Vilela\"}',-7.60,41.23,'P','PPL','PT.21','PT.21.1710',5540,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Vila Real\"}',-7.74,41.30,'P','PPLA','PT.21','PT.21.1714',17001,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Vilar do Paraíso\"}',-8.62,41.09,'P','PPL','PT.17','PT.17.1317',14727,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-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 ('PT','{\"en\":\"Vilar de Andorinho\"}',-8.59,41.11,'P','PPL','PT.17','PT.17.1317',18944,'Europe/Lisbon',1,'2018-09-03 23:00:00','2018-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 ('PT','{\"en\":\"Vila Nova de Paiva\"}',-7.73,40.85,'P','PPLA2','PT.22','PT.22.1822',5176,'Europe/Lisbon',1,'2018-05-21 23:00:00','2018-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 ('PT','{\"en\":\"Vila Nova de Gaia\"}',-8.61,41.12,'P','PPLA2','PT.17','PT.17.1317',70811,'Europe/Lisbon',1,'2018-02-13 23:00:00','2018-02-13 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Vila Nova de Foz Côa\"}',-7.14,41.08,'P','PPLA2','PT.11','PT.11.0914',7312,'Europe/Lisbon',1,'2018-01-30 23:00:00','2018-01-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 ('PT','{\"en\":\"Vila Nova de Famalicão\"}',-8.52,41.41,'P','PPLA2','PT.04','PT.04.0312',9496,'Europe/Lisbon',1,'2018-04-30 23:00:00','2018-04-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 ('PT','{\"en\":\"Vila Nova da Telha\"}',-8.64,41.07,'P','PPL','PT.17','PT.17.1317',5848,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Vila do Conde\"}',-8.75,41.35,'P','PPLA2','PT.17','PT.17.1316',27642,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Viana do Castelo\"}',-8.83,41.69,'P','PPLA','PT.20','PT.20.1609',36148,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Valongo\"}',-8.50,41.19,'P','PPLA2','PT.17','PT.17.1315',21328,'Europe/Lisbon',1,'2018-02-05 23:00:00','2018-02-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 ('PT','{\"en\":\"Valongo\"}',-8.45,40.62,'P','PPL','PT.02','PT.02.0101',5085,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Válega\"}',-8.58,40.84,'P','PPL','PT.02','PT.02.0115',7005,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Vale de Cambra\"}',-8.39,40.85,'P','PPLA2','PT.02','PT.02.0119',7649,'Europe/Lisbon',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 ('PT','{\"en\":\"Valbom\"}',-8.56,41.13,'P','PPL','PT.17','PT.17.1304',14443,'Europe/Lisbon',1,'2018-02-20 23:00:00','2018-02-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 ('PT','{\"en\":\"Valadares\"}',-7.98,41.15,'P','PPL','PT.17','PT.17.1302',9255,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Urgeses\"}',-8.30,41.43,'P','PPL','PT.04','PT.04.0308',5457,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Trofa\"}',-8.56,41.34,'P','PPL','PT.17','PT.17.1318',20692,'Europe/Lisbon',1,'2018-05-16 23:00:00','2018-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 ('PT','{\"en\":\"Torre de Moncorvo\"}',-7.05,41.17,'P','PPLA2','PT.05','PT.05.0409',8572,'Europe/Lisbon',1,'2018-05-30 23:00:00','2018-05-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 ('PT','{\"en\":\"Tondela\"}',-8.08,40.52,'P','PPLA2','PT.22','PT.22.1821',8800,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Tavarede\"}',-8.85,40.17,'P','PPL','PT.07','PT.07.0605',8586,'Europe/Lisbon',1,'2018-02-13 23:00:00','2018-02-13 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Tabuaço\"}',-7.57,41.12,'P','PPLA2','PT.22','PT.22.1819',6350,'Europe/Lisbon',1,'2018-05-30 23:00:00','2018-05-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 ('PT','{\"en\":\"Tábua\"}',-8.03,40.36,'P','PPLA2','PT.07','PT.07.0616',12071,'Europe/Lisbon',1,'2018-02-26 23:00:00','2018-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 ('PT','{\"en\":\"Soure\"}',-8.63,40.06,'P','PPLA2','PT.07','PT.07.0615',8416,'Europe/Lisbon',1,'2020-02-02 23:00:00','2020-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 ('PT','{\"en\":\"Sobrado\"}',-8.45,41.21,'P','PPL','PT.17','PT.17.1315',6703,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Silvalde\"}',-8.63,40.99,'P','PPL','PT.02','PT.02.0107',7188,'Europe/Lisbon',1,'2018-02-20 23:00:00','2018-02-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 ('PT','{\"en\":\"Serzedo\"}',-8.23,41.41,'P','PPL','PT.04','PT.04.0308',8000,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Serzedo\"}',-8.62,41.05,'P','PPL','PT.17','PT.17.1317',7891,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Sernancelhe\"}',-7.49,40.90,'P','PPLA2','PT.22','PT.22.1818',5671,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Sequeira\"}',-7.23,40.55,'P','PPL','PT.11','PT.11.0907',28502,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Senhora da Hora\"}',-8.65,41.19,'P','PPL','PT.17','PT.17.1308',28930,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-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 ('PT','{\"en\":\"Semelhe\"}',-8.46,41.55,'P','PPL','PT.04','PT.04.0303',11700,'Europe/Lisbon',1,'2018-06-06 23:00:00','2018-06-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 ('PT','{\"en\":\"Selho\"}',-8.35,41.42,'P','PPL','PT.04','PT.04.0308',10223,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Seia\"}',-7.71,40.42,'P','PPLA2','PT.11','PT.11.0912',7082,'Europe/Lisbon',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 ('PT','{\"en\":\"São Roque\"}',-8.47,40.87,'P','PPL','PT.02','PT.02.0113',5575,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Coronado\"}',-8.56,41.29,'P','PPL','PT.17','PT.17.1318',8697,'Europe/Lisbon',1,'2021-12-14 23:00:00','2021-12-14 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"São Romão\"}',-7.71,40.40,'P','PPL','PT.11','PT.11.0912',6500,'Europe/Lisbon',1,'2018-02-26 23:00:00','2018-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 ('PT','{\"en\":\"São Pedro da Cova\"}',-8.50,41.14,'P','PPL','PT.17','PT.17.1304',17011,'Europe/Lisbon',1,'2018-01-23 23:00:00','2018-01-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 ('PT','{\"en\":\"São Miguel do Couto\"}',-8.46,41.33,'P','PPL','PT.17','PT.17.1314',5416,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-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 ('PT','{\"en\":\"São Mamede de Infesta\"}',-8.61,41.19,'P','PPL','PT.17','PT.17.1308',25940,'Europe/Lisbon',1,'2018-02-06 23:00:00','2018-02-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 ('PT','{\"en\":\"São João de Ver\"}',-8.55,40.96,'P','PPL','PT.02','PT.02.0109',9568,'Europe/Lisbon',1,'2016-03-09 23:00:00','2016-03-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 ('PT','{\"en\":\"São João da Pesqueira\"}',-7.40,41.15,'P','PPLA2','PT.22','PT.22.1815',7874,'Europe/Lisbon',1,'2018-01-30 23:00:00','2018-01-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 ('PT','{\"en\":\"São João da Madeira\"}',-8.49,40.90,'P','PPL','PT.02','PT.02.0116',22079,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"São João\"}',-8.61,40.87,'P','PPL','PT.02','PT.02.0115',6762,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"São Félix da Marinha\"}',-8.62,41.04,'P','PPL','PT.17','PT.17.1317',11685,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Santo Tirso\"}',-8.48,41.34,'P','PPLA2','PT.17','PT.17.1314',14021,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Santo António dos Olivais\"}',-8.41,40.22,'P','PPL','PT.07','PT.07.0603',38936,'Europe/Lisbon',1,'2018-02-13 23:00:00','2018-02-13 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Santa Cruz do Bispo\"}',-8.67,41.21,'P','PPL','PT.17','PT.17.1308',6230,'Europe/Lisbon',1,'2018-09-13 23:00:00','2018-09-13 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Santa Comba Dão\"}',-8.13,40.40,'P','PPLA2','PT.22','PT.22.1814',11597,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Santa Clara\"}',-8.44,40.20,'P','PPL','PT.07','PT.07.0603',9637,'Europe/Lisbon',1,'2018-02-18 23:00:00','2018-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 ('PT','{\"en\":\"Sandim\"}',-8.51,41.04,'P','PPL','PT.17','PT.17.1317',6449,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Sande\"}',-8.39,41.70,'P','PPL','PT.04','PT.04.0313',7789,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Sabrosa\"}',-7.58,41.27,'P','PPLA2','PT.21','PT.21.1710',6361,'Europe/Lisbon',1,'2018-05-30 23:00:00','2018-05-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 ('PT','{\"en\":\"Rio Tinto\"}',-8.56,41.18,'P','PPL','PT.17','PT.17.1304',49966,'Europe/Lisbon',1,'2018-02-12 23:00:00','2018-02-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 ('PT','{\"en\":\"Rio de Loba\"}',-7.88,40.67,'P','PPL','PT.22','PT.22.1823',9529,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Ribeirão\"}',-8.57,41.36,'P','PPL','PT.04','PT.04.0312',8735,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Refojos de Basto\"}',-8.00,41.51,'P','PPL','PT.04','PT.04.0304',5037,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Rebordosa\"}',-8.41,41.22,'P','PPL','PT.17','PT.17.1310',11491,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Real\"}',-8.44,41.56,'P','PPL','PT.04','PT.04.0303',11700,'Europe/Lisbon',1,'2018-03-14 23:00:00','2018-03-14 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Póvoa de Varzim\"}',-8.76,41.38,'P','PPLA2','PT.17','PT.17.1313',29044,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Póvoa de Lanhoso\"}',-8.27,41.58,'P','PPL','PT.04','PT.04.0309',5008,'Europe/Lisbon',1,'2019-06-13 23:00:00','2019-06-13 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Porto\"}',-8.61,41.15,'P','PPLA','PT.17','PT.17.1312',249633,'Europe/Lisbon',1,'2018-03-14 23:00:00','2018-03-14 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Ponte de Lima\"}',-8.58,41.77,'P','PPLA2','PT.20','PT.20.1607',44667,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Ponte\"}',-8.33,41.47,'P','PPL','PT.04','PT.04.0308',7041,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Poiares\"}',-8.26,40.21,'P','PPLA2','PT.07','PT.07.0617',5514,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Peso da Régua\"}',-7.79,41.16,'P','PPLA2','PT.21','PT.21.1708',5048,'Europe/Lisbon',1,'2019-10-29 23:00:00','2019-10-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 ('PT','{\"en\":\"Perozinho\"}',-8.59,41.07,'P','PPL','PT.17','PT.17.1317',6259,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Perafita\"}',-8.25,41.18,'P','PPL','PT.17','PT.17.1311',12538,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Penafiel\"}',-8.28,41.21,'P','PPLA2','PT.17','PT.17.1311',8065,'Europe/Lisbon',1,'2018-06-02 23:00:00','2018-06-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 ('PT','{\"en\":\"Pedrouços\"}',-8.59,41.19,'P','PPL','PT.17','PT.17.1306',12553,'Europe/Lisbon',1,'2018-02-06 23:00:00','2018-02-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 ('PT','{\"en\":\"Pedroso\"}',-8.75,41.41,'P','PPL','PT.17','PT.17.1313',18963,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Paredes\"}',-8.33,41.20,'P','PPLA2','PT.17','PT.17.1310',19834,'Europe/Lisbon',1,'2018-05-16 23:00:00','2018-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 ('PT','{\"en\":\"Paços de Ferreira\"}',-8.38,41.28,'P','PPLA2','PT.17','PT.17.1309',6782,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Ovar\"}',-8.63,40.86,'P','PPL','PT.02','PT.02.0115',18452,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Oliveira do Douro\"}',-8.58,41.12,'P','PPL','PT.17','PT.17.1317',24407,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Oliveira do Bairro\"}',-8.49,40.51,'P','PPLA2','PT.02','PT.02.0114',6239,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Oliveira de Azemeis\"}',-8.48,40.84,'P','PPLA2','PT.02','PT.02.0113',11771,'Europe/Lisbon',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 ('PT','{\"en\":\"Oliveira\"}',-8.47,41.48,'P','PPL','PT.04','PT.04.0303',6222,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Olival\"}',-8.54,41.05,'P','PPL','PT.17','PT.17.1317',5715,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Oiã\"}',-8.54,40.54,'P','PPL','PT.02','PT.02.0114',7118,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Nogueira da Regedoura\"}',-8.59,41.01,'P','PPL','PT.02','PT.02.0109',5328,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Negrelos\"}',-8.40,41.35,'P','PPL','PT.17','PT.17.1314',6664,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Murtosa\"}',-8.64,40.74,'P','PPLA2','PT.02','PT.02.0112',8282,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Mozelos\"}',-8.40,41.87,'P','PPL','PT.20','PT.20.1601',7230,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-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 ('PT','{\"en\":\"Moreira de Conegos\"}',-8.34,41.39,'P','PPL','PT.04','PT.04.0308',5607,'Europe/Lisbon',1,'2012-02-27 23:00:00','2012-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 ('PT','{\"en\":\"Moreira\"}',-8.65,41.25,'P','PPL','PT.17','PT.17.1306',12890,'Europe/Lisbon',1,'2018-02-28 23:00:00','2018-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 ('PT','{\"en\":\"Moreira\"}',-8.39,41.06,'P','PPL','PT.17','PT.17.1304',11336,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Mondim de Basto\"}',-7.95,41.41,'P','PPLA2','PT.21','PT.21.1705',7493,'Europe/Lisbon',1,'2018-06-07 23:00:00','2018-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 ('PT','{\"en\":\"Monção\"}',-8.48,42.08,'P','PPL','PT.20','PT.20.1604',19738,'Europe/Lisbon',1,'2021-07-26 23:00:00','2021-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 ('PT','{\"en\":\"Moimenta da Beira\"}',-7.62,40.98,'P','PPLA2','PT.22','PT.22.1807',10212,'Europe/Lisbon',1,'2018-05-16 23:00:00','2018-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 ('PT','{\"en\":\"Mirandela\"}',-7.19,41.49,'P','PPLA2','PT.05','PT.05.0407',12504,'Europe/Lisbon',1,'2018-04-30 23:00:00','2018-04-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 ('PT','{\"en\":\"Miranda do Douro\"}',-6.27,41.50,'P','PPLA2','PT.05','PT.05.0406',7482,'Europe/Lisbon',1,'2018-08-23 23:00:00','2018-08-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 ('PT','{\"en\":\"Miranda do Corvo\"}',-8.33,40.09,'P','PPLA2','PT.07','PT.07.0609',7857,'Europe/Lisbon',1,'2018-04-30 23:00:00','2018-04-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 ('PT','{\"en\":\"Mira\"}',-8.74,40.43,'P','PPLA2','PT.07','PT.07.0608',7682,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Merelim\"}',-8.47,41.59,'P','PPL','PT.04','PT.04.0303',5363,'Europe/Lisbon',1,'2018-09-17 23:00:00','2018-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 ('PT','{\"en\":\"Melres\"}',-8.40,41.07,'P','PPL','PT.17','PT.17.1304',10328,'Europe/Lisbon',1,'2018-05-30 23:00:00','2018-05-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 ('PT','{\"en\":\"Meadela\"}',-8.80,41.71,'P','PPL','PT.20','PT.20.1609',9981,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Matosinhos\"}',-8.69,41.18,'P','PPLA2','PT.17','PT.17.1308',28070,'Europe/Lisbon',1,'2020-02-06 23:00:00','2020-02-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 ('PT','{\"en\":\"Marinhas\"}',-8.78,41.56,'P','PPL','PT.04','PT.04.0306',6052,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Margaride\"}',-8.20,41.36,'P','PPL','PT.17','PT.17.1303',10652,'Europe/Lisbon',1,'2018-05-16 23:00:00','2018-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 ('PT','{\"en\":\"Marco de Canavezes\"}',-8.15,41.18,'P','PPLA2','PT.17','PT.17.1307',9042,'Europe/Lisbon',1,'2018-06-07 23:00:00','2018-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 ('PT','{\"en\":\"Mangualde\"}',-7.76,40.60,'P','PPLA2','PT.22','PT.22.1806',8895,'Europe/Lisbon',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 ('PT','{\"en\":\"Maia\"}',-8.62,41.24,'P','PPLA2','PT.17','PT.17.1306',36426,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Madalena\"}',-8.33,41.22,'P','PPL','PT.17','PT.17.1310',9618,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Macedo de Cavaleiros\"}',-6.96,41.54,'P','PPLA2','PT.05','PT.05.0405',6566,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Lousã\"}',-8.25,40.12,'P','PPL','PT.07','PT.07.0607',11445,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-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 ('PT','{\"en\":\"Lourosa\"}',-8.55,40.98,'P','PPL','PT.02','PT.02.0109',9619,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Lordelo\"}',-8.40,41.23,'P','PPL','PT.17','PT.17.1310',10035,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Lobão\"}',-8.49,40.99,'P','PPL','PT.02','PT.02.0109',6049,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Leça do Bailio\"}',-8.63,41.21,'P','PPL','PT.17','PT.17.1306',16103,'Europe/Lisbon',1,'2018-06-27 23:00:00','2018-06-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 ('PT','{\"en\":\"Leça da Palmeira\"}',-8.70,41.19,'P','PPL','PT.17','PT.17.1308',17996,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Lavra\"}',-8.72,41.26,'P','PPL','PT.17','PT.17.1308',9633,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Lamego\"}',-7.81,41.10,'P','PPLA2','PT.22','PT.22.1805',10928,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Lamas\"}',-8.57,40.99,'P','PPL','PT.02','PT.02.0109',5628,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Jovim\"}',-8.52,41.11,'P','PPL','PT.17','PT.17.1304',7067,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Joane\"}',-8.41,41.44,'P','PPL','PT.04','PT.04.0312',7869,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-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 ('PT','{\"en\":\"Ílhavo\"}',-8.67,40.60,'P','PPLA2','PT.02','PT.02.0110',17236,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Gulpilhares\"}',-8.63,41.08,'P','PPL','PT.17','PT.17.1317',10660,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-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 ('PT','{\"en\":\"Guimarães\"}',-8.30,41.44,'P','PPLA2','PT.04','PT.04.0308',40604,'Europe/Lisbon',1,'2018-04-30 23:00:00','2018-04-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 ('PT','{\"en\":\"Guifões\"}',-8.67,41.20,'P','PPL','PT.17','PT.17.1308',9231,'Europe/Lisbon',1,'2018-02-07 23:00:00','2018-02-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 ('PT','{\"en\":\"Guarda\"}',-7.27,40.54,'P','PPLA','PT.11','PT.11.0907',32111,'Europe/Lisbon',1,'2013-08-04 23:00:00','2013-08-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 ('PT','{\"en\":\"Grijó\"}',-8.58,41.03,'P','PPL','PT.17','PT.17.1317',10907,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Gondomar\"}',-8.53,41.14,'P','PPLA2','PT.17','PT.17.1304',27691,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Gondizalves\"}',-8.46,41.54,'P','PPL','PT.04','PT.04.0303',9148,'Europe/Lisbon',1,'2018-02-18 23:00:00','2018-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 ('PT','{\"en\":\"Gemunde\"}',-8.65,41.27,'P','PPL','PT.17','PT.17.1306',5284,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Gandra\"}',-8.43,41.20,'P','PPL','PT.17','PT.17.1310',6034,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Galegos\"}',-8.57,41.56,'P','PPL','PT.04','PT.04.0302',5404,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Gafanha\"}',-8.71,40.64,'P','PPL','PT.02','PT.02.0110',14840,'Europe/Lisbon',1,'2021-12-14 23:00:00','2021-12-14 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Fundão\"}',-7.50,40.14,'P','PPLA2','PT.06','PT.06.0504',9725,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Freamunde\"}',-8.34,41.29,'P','PPL','PT.17','PT.17.1309',7983,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Foz do Sousa\"}',-8.50,41.10,'P','PPL','PT.17','PT.17.1304',6315,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Foz do Douro\"}',-8.67,41.15,'P','PPLX','PT.17','PT.17.1312',10997,'Europe/Lisbon',1,'2018-02-20 23:00:00','2018-02-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 ('PT','{\"en\":\"Figueira da Foz\"}',-8.86,40.15,'P','PPLA2','PT.07','PT.07.0605',46600,'Europe/Lisbon',1,'2020-01-31 23:00:00','2020-01-31 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Fiães\"}',-8.53,40.99,'P','PPL','PT.02','PT.02.0109',8708,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Ferreiros\"}',-8.55,41.35,'P','PPL','PT.04','PT.04.0312',7870,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Felgueiras\"}',-8.19,41.37,'P','PPLA2','PT.17','PT.17.1303',58065,'Europe/Lisbon',1,'2018-05-16 23:00:00','2018-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 ('PT','{\"en\":\"Feira\"}',-8.54,40.93,'P','PPLA2','PT.02','PT.02.0109',16376,'Europe/Lisbon',1,'2018-06-06 23:00:00','2018-06-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 ('PT','{\"en\":\"Apúlia e Fão\"}',-8.77,41.51,'P','PPL','PT.04','PT.04.0306',7301,'Europe/Lisbon',1,'2018-01-14 23:00:00','2018-01-14 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Fânzeres\"}',-8.53,41.17,'P','PPL','PT.17','PT.17.1304',23916,'Europe/Lisbon',1,'2018-02-06 23:00:00','2018-02-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 ('PT','{\"en\":\"Fafe\"}',-8.17,41.45,'P','PPLA2','PT.04','PT.04.0307',16868,'Europe/Lisbon',1,'2018-01-14 23:00:00','2018-01-14 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Esposende\"}',-8.78,41.54,'P','PPLA2','PT.04','PT.04.0306',34625,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Espinho\"}',-8.64,41.01,'P','PPLA2','PT.02','PT.02.0107',32786,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Esmoriz\"}',-8.63,40.96,'P','PPL','PT.02','PT.02.0115',11393,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-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 ('PT','{\"en\":\"Esgueira\"}',-8.63,40.65,'P','PPL','PT.02','PT.02.0105',13431,'Europe/Lisbon',1,'2018-02-12 23:00:00','2018-02-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 ('PT','{\"en\":\"Ermesinde\"}',-8.55,41.22,'P','PPL','PT.17','PT.17.1315',39420,'Europe/Lisbon',1,'2020-02-02 23:00:00','2020-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 ('PT','{\"en\":\"Eixo\"}',-8.57,40.63,'P','PPL','PT.02','PT.02.0105',5978,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Darque\"}',-8.77,41.68,'P','PPL','PT.20','PT.20.1609',8092,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-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 ('PT','{\"en\":\"Custoias\"}',-7.32,41.11,'P','PPL','PT.11','PT.11.0914',19406,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Cucujães\"}',-8.51,40.87,'P','PPL','PT.02','PT.02.0113',11087,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Covilhã\"}',-7.51,40.28,'P','PPL','PT.06','PT.06.0503',17610,'Europe/Lisbon',1,'2018-01-24 23:00:00','2018-01-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 ('PT','{\"en\":\"Condeixa-a-Nova\"}',-8.50,40.11,'P','PPLA2','PT.07','PT.07.0604',17078,'Europe/Lisbon',1,'2018-02-13 23:00:00','2018-02-13 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Coimbra\"}',-8.42,40.21,'P','PPLA','PT.07','PT.07.0603',106582,'Europe/Lisbon',1,'2019-02-25 23:00:00','2019-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 ('PT','{\"en\":\"Chaves\"}',-7.47,41.74,'P','PPLA2','PT.21','PT.21.1703',17535,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Castelões de Cepeda\"}',-8.34,41.20,'P','PPL','PT.17','PT.17.1310',8322,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-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 ('PT','{\"en\":\"Carregal do Sal\"}',-8.00,40.43,'P','PPLA2','PT.22','PT.22.1802',5600,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-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 ('PT','{\"en\":\"Carrazeda de Anciães\"}',-7.31,41.24,'P','PPLA2','PT.05','PT.05.0403',6373,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Cantanhede\"}',-8.59,40.35,'P','PPLA2','PT.07','PT.07.0602',7347,'Europe/Lisbon',1,'2018-04-30 23:00:00','2018-04-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 ('PT','{\"en\":\"Canidelo\"}',-8.65,41.12,'P','PPL','PT.17','PT.17.1317',26431,'Europe/Lisbon',1,'2018-02-06 23:00:00','2018-02-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 ('PT','{\"en\":\"Canelas\"}',-8.60,41.08,'P','PPL','PT.17','PT.17.1317',14247,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Campo\"}',-8.46,41.19,'P','PPL','PT.17','PT.17.1315',8916,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Calendário\"}',-8.53,41.40,'P','PPL','PT.04','PT.04.0312',11357,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Caldelas\"}',-8.38,41.67,'P','PPL','PT.04','PT.04.0301',5724,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-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 ('PT','{\"en\":\"Caldas de Vizela\"}',-8.31,41.38,'P','PPL','PT.04','PT.04.0314',10239,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Taipas\"}',-8.35,41.48,'P','PPL','PT.04','PT.04.0308',5723,'Europe/Lisbon',1,'2021-12-14 23:00:00','2021-12-14 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Cabeceiras de Basto\"}',-7.99,41.51,'P','PPLA2','PT.04','PT.04.0304',16710,'Europe/Lisbon',1,'2018-02-10 23:00:00','2018-02-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 ('PT','{\"en\":\"Buarcos\"}',-8.88,40.17,'P','PPL','PT.07','PT.07.0605',7865,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Brito\"}',-8.36,41.46,'P','PPL','PT.04','PT.04.0308',5051,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-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 ('PT','{\"en\":\"Branca\"}',-8.48,40.77,'P','PPL','PT.02','PT.02.0102',5632,'Europe/Lisbon',1,'2018-07-03 23:00:00','2018-07-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 ('PT','{\"en\":\"Bragança\"}',-6.76,41.81,'P','PPLA','PT.05','PT.05.0402',34375,'Europe/Lisbon',1,'2018-08-18 23:00:00','2018-08-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 ('PT','{\"en\":\"Braga\"}',-8.42,41.55,'P','PPLA','PT.04','PT.04.0303',121394,'Europe/Lisbon',1,'2018-04-30 23:00:00','2018-04-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 ('PT','{\"en\":\"Bougado\"}',-8.55,41.34,'P','PPL','PT.17','PT.17.1318',21680,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Boticas\"}',-7.67,41.69,'P','PPLA2','PT.21','PT.21.1702',5750,'Europe/Lisbon',1,'2018-02-10 23:00:00','2018-02-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 ('PT','{\"en\":\"Beduido\"}',-8.56,40.76,'P','PPL','PT.02','PT.02.0108',8201,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Barrosas\"}',-8.30,41.36,'P','PPL','PT.17',NULL,5573,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Barcelos\"}',-8.62,41.53,'P','PPLA2','PT.04','PT.04.0302',19085,'Europe/Lisbon',1,'2018-01-28 23:00:00','2018-01-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 ('PT','{\"en\":\"Baião\"}',-8.03,41.16,'P','PPLA2','PT.17','PT.17.1302',20522,'Europe/Lisbon',1,'2018-06-07 23:00:00','2018-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 ('PT','{\"en\":\"Baguim do Monte\"}',-8.54,41.19,'P','PPL','PT.17','PT.17.1304',15850,'Europe/Lisbon',1,'2018-01-14 23:00:00','2018-01-14 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Azenha\"}',-8.62,41.08,'P','PPL','PT.17','PT.17.1317',12260,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Avintes\"}',-8.55,41.11,'P','PPL','PT.17','PT.17.1317',11577,'Europe/Lisbon',1,'2018-02-20 23:00:00','2018-02-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 ('PT','{\"en\":\"Aves\"}',-8.41,41.37,'P','PPL','PT.17','PT.17.1314',8507,'Europe/Lisbon',1,'2016-03-09 23:00:00','2016-03-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 ('PT','{\"en\":\"Aver-o-Mar\"}',-8.78,41.41,'P','PPL','PT.17','PT.17.1313',10501,'Europe/Lisbon',1,'2018-01-28 23:00:00','2018-01-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 ('PT','{\"en\":\"Aveleda\"}',-8.47,41.52,'P','PPL','PT.04','PT.04.0303',6671,'Europe/Lisbon',1,'2018-02-18 23:00:00','2018-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 ('PT','{\"en\":\"Aveiro\"}',-8.65,40.64,'P','PPLA','PT.02','PT.02.0105',54162,'Europe/Lisbon',1,'2018-04-29 23:00:00','2018-04-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 ('PT','{\"en\":\"Avanca\"}',-8.57,40.81,'P','PPL','PT.02','PT.02.0108',6540,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-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 ('PT','{\"en\":\"Assafarge\"}',-8.43,40.16,'P','PPL','PT.07','PT.07.0603',5302,'Europe/Lisbon',1,'2018-02-13 23:00:00','2018-02-13 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Árvore\"}',-8.72,41.34,'P','PPL','PT.17','PT.17.1316',5196,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Arrifana\"}',-8.50,40.92,'P','PPL','PT.02','PT.02.0109',6927,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Argoncilhe\"}',-8.54,41.03,'P','PPL','PT.02','PT.02.0109',8743,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Arcozelo\"}',-8.63,41.06,'P','PPL','PT.17','PT.17.1317',14352,'Europe/Lisbon',1,'2018-02-20 23:00:00','2018-02-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 ('PT','{\"en\":\"Arcos de Valdevez\"}',-8.42,41.85,'P','PPL','PT.20','PT.20.1601',22847,'Europe/Lisbon',1,'2018-05-16 23:00:00','2018-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 ('PT','{\"en\":\"Arcos\"}',-8.42,41.52,'P','PPL','PT.04','PT.04.0303',6805,'Europe/Lisbon',1,'2018-02-18 23:00:00','2018-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 ('PT','{\"en\":\"Arcos\"}',-8.44,40.45,'P','PPL','PT.02','PT.02.0103',6725,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Arazede\"}',-8.65,40.29,'P','PPL','PT.07','PT.07.0610',5906,'Europe/Lisbon',1,'2018-03-20 23:00:00','2018-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 ('PT','{\"en\":\"Aradas\"}',-8.64,40.62,'P','PPL','PT.02','PT.02.0105',7295,'Europe/Lisbon',1,'2016-03-09 23:00:00','2016-03-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 ('PT','{\"en\":\"Anta\"}',-8.63,41.27,'P','PPL','PT.17','PT.17.1306',10951,'Europe/Lisbon',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Amarante\"}',-8.08,41.27,'P','PPLA2','PT.17','PT.17.1301',6782,'Europe/Lisbon',1,'2018-05-08 23:00:00','2018-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 ('PT','{\"en\":\"Alpendurada\"}',-8.25,41.09,'P','PPL','PT.17','PT.17.1307',8485,'Europe/Lisbon',1,'2018-03-20 23:00:00','2018-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 ('PT','{\"en\":\"Alijó\"}',-7.47,41.28,'P','PPL','PT.21','PT.21.1701',11942,'Europe/Lisbon',1,'2019-07-17 23:00:00','2019-07-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 ('PT','{\"en\":\"Alfena\"}',-8.52,41.24,'P','PPL','PT.17','PT.17.1315',15211,'Europe/Lisbon',1,'2018-01-14 23:00:00','2018-01-14 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('PT','{\"en\":\"Albergaria-a-Velha\"}',-8.48,40.69,'P','PPLA2','PT.02','PT.02.0102',7974,'Europe/Lisbon',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 ('PT','{\"en\":\"Aguiar da Beira\"}',-7.54,40.82,'P','PPLA2','PT.11','PT.11.0901',5473,'Europe/Lisbon',1,'2018-05-16 23:00:00','2018-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 ('PT','{\"en\":\"Águeda\"}',-8.44,40.58,'P','PPLA2','PT.02','PT.02.0101',11941,'Europe/Lisbon',1,'2020-02-02 23:00:00','2020-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 ('PT','{\"en\":\"Águas Santas\"}',-8.58,41.21,'P','PPL','PT.17','PT.17.1306',27686,'Europe/Lisbon',1,'2018-03-20 23:00:00','2018-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 ('PT','{\"en\":\"Abraveses\"}',-7.92,40.68,'P','PPL','PT.22','PT.22.1823',9319,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-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 ('PT','{\"en\":\"Vila Franca do Campo\"}',-25.43,37.72,'P','PPL','PT.23','PT.23.4206',5035,'Atlantic/Azores',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Rosto de Cão\"}',-25.65,37.75,'P','PPL','PT.23','PT.23.4203',7880,'Atlantic/Azores',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Ribeira Grande\"}',-28.70,38.52,'P','PPL','PT.23',NULL,5198,'Atlantic/Azores',1,'2018-12-03 23:00:00','2018-12-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 ('PT','{\"en\":\"Rabo de Peixe\"}',-25.58,37.81,'P','PPL','PT.23','PT.23.4205',7681,'Atlantic/Azores',1,'2018-02-04 23:00:00','2018-02-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 ('PT','{\"en\":\"Praia da Vitória\"}',-27.07,38.73,'P','PPL','PT.23','PT.23.4302',6061,'Atlantic/Azores',1,'2020-06-09 23:00:00','2020-06-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 ('PT','{\"en\":\"Madalena\"}',-28.53,38.54,'P','PPL','PT.23','PT.23.4602',6136,'Atlantic/Azores',1,'2011-09-03 23:00:00','2011-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 ('PT','{\"en\":\"Lagoa\"}',-25.57,37.74,'P','PPL','PT.23','PT.23.4201',14442,'Atlantic/Azores',1,'2018-02-26 23:00:00','2018-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 ('PT','{\"en\":\"Horta\"}',-28.63,38.54,'P','PPL','PT.23','PT.23.4701',6572,'Atlantic/Azores',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 ('PT','{\"en\":\"Arrifes\"}',-25.70,37.77,'P','PPL','PT.23','PT.23.4203',6981,'Atlantic/Azores',1,'2012-01-16 23:00:00','2012-01-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 ('PT','{\"en\":\"Angra do Heroísmo\"}',-27.22,38.65,'P','PPL','PT.23','PT.23.4301',12045,'Atlantic/Azores',1,'2018-02-26 23:00:00','2018-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 ('PT','{\"en\":\"Quinta Do Conde\"}',-9.04,38.57,'P','PPL','PT.19','PT.19.1510',25606,'Europe/Lisbon',1,'2018-02-18 23:00:00','2018-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 ('PT','{\"en\":\"Prior Velho\"}',-9.12,38.79,'P','PPL','PT.14','PT.14.1107',6500,'Europe/Lisbon',1,'2018-05-17 23:00:00','2018-05-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 ('PT','{\"en\":\"Valenza\"}',-8.63,42.02,'P','PPL','PT.20','PT.20.1608',14172,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-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 ('PT','{\"en\":\"Alfragide\"}',-9.22,38.73,'P','PPLL','PT.14','PT.14.1115',17044,'Europe/Lisbon',1,'2018-02-19 23:00:00','2018-02-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 ('PT','{\"en\":\"Alvalade\"}',-9.14,38.75,'P','PPL','PT.14','PT.14.1106',31813,'Europe/Lisbon',1,'2018-03-20 23:00:00','2018-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 ('PT','{\"en\":\"Ponta Delgada\"}',-25.67,37.74,'P','PPLA','PT.23','PT.23.4203',20056,'Atlantic/Azores',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 ('PT','{\"en\":\"Azeitão\"}',-9.01,38.52,'P','PPL','PT.19','PT.19.1512',18877,'Europe/Lisbon',1,'2018-01-17 23:00:00','2018-01-17 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
