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


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

INSERT INTO `<<prefix>>subadmin1` VALUES (2704,'PT.19','PT','Setúbal','Setubal',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2705,'PT.18','PT','Santarém','Santarem',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2706,'PT.16','PT','Portalegre','Portalegre',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2707,'PT.14','PT','Lisbon','Lisbon',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2708,'PT.13','PT','Leiria','Leiria',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2709,'PT.09','PT','Faro','Faro',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2710,'PT.08','PT','Évora','Evora',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2711,'PT.06','PT','Castelo Branco','Castelo Branco',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2712,'PT.03','PT','Beja','Beja',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2713,'PT.10','PT','Madeira','Madeira',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2714,'PT.22','PT','Viseu','Viseu',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2715,'PT.21','PT','Vila Real','Vila Real',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2716,'PT.20','PT','Viana do Castelo','Viana do Castelo',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2717,'PT.17','PT','Porto','Porto',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2718,'PT.11','PT','Guarda','Guarda',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2719,'PT.07','PT','Coimbra','Coimbra',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2720,'PT.05','PT','Bragança','Braganca',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2721,'PT.04','PT','Braga','Braga',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2722,'PT.02','PT','Aveiro','Aveiro',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2723,'PT.23','PT','Azores','Azores',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (30476,'PT.16.1206','PT','PT.16','Crato','Crato',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30477,'PT.22.1821','PT','PT.22','Tondela','Concelho de Tondela',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30478,'PT.11.0906','PT','PT.11','Gouveia','Municipio de Gouveia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30479,'PT.06.0504','PT','PT.06','Fundão','Concelho do Fundao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30480,'PT.14.1106','PT','PT.14','Lisbon','Lisbon',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30481,'PT.17.1312','PT','PT.17','Porto','Porto',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30482,'PT.14.1107','PT','PT.14','Loures','Loures',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30483,'PT.16.1212','PT','PT.16','Nisa','Nisa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30484,'PT.06.0511','PT','PT.06','Vila Velha de Ródão','Vila Velha de Rodao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30485,'PT.16.1205','PT','PT.16','Castelo de Vide','Castelo de Vide',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30486,'PT.16.1210','PT','PT.16','Marvão','Marvao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30487,'PT.16.1214','PT','PT.16','Portalegre','Portalegre',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30488,'PT.16.1209','PT','PT.16','Gavião','Gaviao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30489,'PT.16.1213','PT','PT.16','Ponte de Sor','Ponte de Sor',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30490,'PT.16.1201','PT','PT.16','Alter do Chão','Alter do Chao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30491,'PT.16.1211','PT','PT.16','Monforte','Monforte',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30492,'PT.22.1802','PT','PT.22','Carregal do Sal','Concelho de Carregal do Sal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30493,'PT.19.1510','PT','PT.19','Seixal','Seixal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30494,'PT.02.0101','PT','PT.02','Águeda','Agueda',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30495,'PT.02.0102','PT','PT.02','Albergaria-A-Velha','Albergaria-A-Velha',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30496,'PT.02.0103','PT','PT.02','Anadia','Anadia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30497,'PT.02.0104','PT','PT.02','Arouca','Arouca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30498,'PT.02.0105','PT','PT.02','Aveiro','Aveiro',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30499,'PT.02.0106','PT','PT.02','Castelo de Paiva','Castelo de Paiva',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30500,'PT.02.0107','PT','PT.02','Espinho','Espinho',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30501,'PT.02.0108','PT','PT.02','Estarreja','Estarreja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30502,'PT.02.0109','PT','PT.02','Santa Maria da Feira','Santa Maria da Feira',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30503,'PT.02.0110','PT','PT.02','Ílhavo','Ilhavo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30504,'PT.02.0111','PT','PT.02','Mealhada','Mealhada',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30505,'PT.02.0112','PT','PT.02','Murtosa','Murtosa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30506,'PT.02.0113','PT','PT.02','Oliveira de Azeméis','Oliveira de Azemeis',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30507,'PT.02.0114','PT','PT.02','Oliveira do Bairro','Oliveira do Bairro',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30508,'PT.02.0115','PT','PT.02','Ovar','Ovar',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30509,'PT.02.0116','PT','PT.02','São João da Madeira','Sao Joao da Madeira',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30510,'PT.02.0117','PT','PT.02','Sever do Vouga','Sever do Vouga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30511,'PT.02.0118','PT','PT.02','Vagos','Vagos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30512,'PT.02.0119','PT','PT.02','Vale de Cambra','Vale de Cambra',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30513,'PT.03.0201','PT','PT.03','Aljustrel','Aljustrel',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30514,'PT.03.0202','PT','PT.03','Almodôvar','Almodovar',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30515,'PT.03.0203','PT','PT.03','Alvito','Alvito',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30516,'PT.03.0204','PT','PT.03','Barrancos','Barrancos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30517,'PT.03.0205','PT','PT.03','Beja','Beja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30518,'PT.03.0206','PT','PT.03','Castro Verde','Castro Verde',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30519,'PT.03.0207','PT','PT.03','Cuba','Cuba',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30520,'PT.03.0208','PT','PT.03','Ferreira do Alentejo','Ferreira do Alentejo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30521,'PT.03.0209','PT','PT.03','Mértola','Mertola',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30522,'PT.03.0210','PT','PT.03','Moura','Moura',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30523,'PT.03.0211','PT','PT.03','Odemira','Odemira',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30524,'PT.03.0212','PT','PT.03','Ourique','Ourique',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30525,'PT.03.0213','PT','PT.03','Serpa','Serpa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30526,'PT.03.0214','PT','PT.03','Vidigueira','Vidigueira',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30527,'PT.04.0301','PT','PT.04','Amares','Amares',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30528,'PT.04.0302','PT','PT.04','Barcelos','Barcelos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30529,'PT.04.0303','PT','PT.04','Braga','Braga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30530,'PT.04.0304','PT','PT.04','Cabeceiras de Basto','Cabeceiras de Basto',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30531,'PT.04.0305','PT','PT.04','Celorico de Basto','Celorico de Basto',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30532,'PT.04.0306','PT','PT.04','Esposende','Esposende',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30533,'PT.04.0307','PT','PT.04','Fafe','Fafe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30534,'PT.04.0308','PT','PT.04','Guimarães','Guimaraes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30535,'PT.04.0309','PT','PT.04','Póvoa de Lanhoso','Povoa de Lanhoso',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30536,'PT.04.0310','PT','PT.04','Terras de Bouro','Terras de Bouro',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30537,'PT.04.0311','PT','PT.04','Vieira do Minho','Vieira do Minho',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30538,'PT.04.0312','PT','PT.04','Vila Nova de Famalicão','Vila Nova de Famalicao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30539,'PT.04.0313','PT','PT.04','Vila Verde','Vila Verde',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30540,'PT.04.0314','PT','PT.04','Vizela','Vizela',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30541,'PT.05.0401','PT','PT.05','Alfândega da Fé','Alfandega da Fe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30542,'PT.05.0402','PT','PT.05','Bragança Municipality','Braganca Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30543,'PT.05.0403','PT','PT.05','Carrazeda de Ansiães','Carrazeda de Ansiaes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30544,'PT.05.0404','PT','PT.05','Freixo de Espada À Cinta','Freixo de Espada A Cinta',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30545,'PT.05.0405','PT','PT.05','Macedo de Cavaleiros','Macedo de Cavaleiros',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30546,'PT.05.0406','PT','PT.05','Miranda do Douro','Miranda do Douro',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30547,'PT.05.0407','PT','PT.05','Mirandela','Mirandela',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30548,'PT.05.0408','PT','PT.05','Mogadouro','Mogadouro',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30549,'PT.05.0409','PT','PT.05','Torre de Moncorvo','Torre de Moncorvo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30550,'PT.05.0410','PT','PT.05','Vila Flor','Vila Flor',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30551,'PT.05.0411','PT','PT.05','Vimioso','Vimioso',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30552,'PT.05.0412','PT','PT.05','Vinhais','Vinhais',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30553,'PT.06.0501','PT','PT.06','Belmonte','Belmonte',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30554,'PT.06.0502','PT','PT.06','Castelo Branco','Castelo Branco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30555,'PT.06.0503','PT','PT.06','Covilhã','Covilha',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30556,'PT.06.0505','PT','PT.06','Idanha-A-Nova','Idanha-A-Nova',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30557,'PT.06.0506','PT','PT.06','Oleiros','Oleiros',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30558,'PT.06.0507','PT','PT.06','Penamacor','Penamacor',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30559,'PT.06.0508','PT','PT.06','Proença-A-Nova','Proenca-A-Nova',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30560,'PT.06.0509','PT','PT.06','Sertã','Serta',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30561,'PT.06.0510','PT','PT.06','Vila de Rei','Vila de Rei',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30562,'PT.07.0601','PT','PT.07','Arganil','Arganil',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30563,'PT.07.0602','PT','PT.07','Cantanhede','Cantanhede',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30564,'PT.07.0603','PT','PT.07','Coimbra','Coimbra',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30565,'PT.07.0604','PT','PT.07','Condeixa-A-Nova','Condeixa-A-Nova',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30566,'PT.07.0605','PT','PT.07','Figueira da Foz','Figueira da Foz',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30567,'PT.07.0606','PT','PT.07','Góis','Gois',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30568,'PT.07.0607','PT','PT.07','Lousã','Lousa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30569,'PT.07.0608','PT','PT.07','Mira','Mira',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30570,'PT.07.0609','PT','PT.07','Miranda do Corvo','Miranda do Corvo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30571,'PT.07.0610','PT','PT.07','Montemor-O-Velho','Montemor-O-Velho',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30572,'PT.07.0611','PT','PT.07','Oliveira do Hospital','Oliveira do Hospital',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30573,'PT.07.0612','PT','PT.07','Pampilhosa da Serra','Pampilhosa da Serra',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30574,'PT.07.0613','PT','PT.07','Penacova','Penacova',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30575,'PT.07.0614','PT','PT.07','Penela','Penela',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30576,'PT.07.0615','PT','PT.07','Soure','Soure',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30577,'PT.07.0616','PT','PT.07','Tábua','Tabua',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30578,'PT.07.0617','PT','PT.07','Vila Nova de Poiares','Vila Nova de Poiares',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30579,'PT.08.0701','PT','PT.08','Alandroal','Alandroal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30580,'PT.08.0702','PT','PT.08','Arraiolos','Arraiolos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30581,'PT.08.0703','PT','PT.08','Borba','Borba',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30582,'PT.08.0704','PT','PT.08','Estremoz','Estremoz',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30583,'PT.08.0705','PT','PT.08','Évora','Evora',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30584,'PT.08.0706','PT','PT.08','Montemor-O-Novo','Montemor-O-Novo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30585,'PT.08.0707','PT','PT.08','Mora','Mora',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30586,'PT.08.0708','PT','PT.08','Mourão','Mourao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30587,'PT.08.0709','PT','PT.08','Portel','Portel',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30588,'PT.08.0710','PT','PT.08','Redondo','Redondo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30589,'PT.08.0711','PT','PT.08','Reguengos de Monsaraz','Reguengos de Monsaraz',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30590,'PT.08.0712','PT','PT.08','Vendas Novas','Vendas Novas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30591,'PT.08.0713','PT','PT.08','Viana do Alentejo','Viana do Alentejo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30592,'PT.08.0714','PT','PT.08','Vila Viçosa','Vila Vicosa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30593,'PT.09.0801','PT','PT.09','Albufeira','Albufeira',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30594,'PT.09.0802','PT','PT.09','Alcoutim','Alcoutim',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30595,'PT.09.0803','PT','PT.09','Aljezur','Aljezur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30596,'PT.09.0804','PT','PT.09','Castro Marim','Castro Marim',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30597,'PT.09.0805','PT','PT.09','Faro','Faro',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30598,'PT.09.0806','PT','PT.09','Lagoa','Lagoa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30599,'PT.09.0807','PT','PT.09','Lagos','Lagos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30600,'PT.09.0808','PT','PT.09','Loulé','Loule',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30601,'PT.09.0809','PT','PT.09','Monchique','Monchique',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30602,'PT.09.0810','PT','PT.09','Olhão','Olhao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30603,'PT.09.0811','PT','PT.09','Portimão','Portimao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30604,'PT.09.0812','PT','PT.09','São Brás de Alportel','Sao Bras de Alportel',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30605,'PT.09.0813','PT','PT.09','Silves','Silves',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30606,'PT.09.0814','PT','PT.09','Tavira','Tavira',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30607,'PT.09.0815','PT','PT.09','Vila do Bispo','Vila do Bispo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30608,'PT.09.0816','PT','PT.09','Vila Real de Santo António','Vila Real de Santo Antonio',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30609,'PT.11.0901','PT','PT.11','Aguiar da Beira','Aguiar da Beira',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30610,'PT.11.0902','PT','PT.11','Almeida','Almeida',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30611,'PT.11.0903','PT','PT.11','Celorico da Beira','Celorico da Beira',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30612,'PT.11.0904','PT','PT.11','Figueira de Castelo Rodrigo','Figueira de Castelo Rodrigo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30613,'PT.11.0905','PT','PT.11','Fornos de Algodres','Fornos de Algodres',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30614,'PT.11.0907','PT','PT.11','Guarda','Guarda',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30615,'PT.11.0908','PT','PT.11','Manteigas','Manteigas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30616,'PT.11.0909','PT','PT.11','Mêda','Meda',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30617,'PT.11.0910','PT','PT.11','Pinhel','Pinhel',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30618,'PT.11.0911','PT','PT.11','Sabugal','Sabugal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30619,'PT.11.0912','PT','PT.11','Seia','Seia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30620,'PT.11.0913','PT','PT.11','Trancoso','Trancoso',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30621,'PT.11.0914','PT','PT.11','Vila Nova de Foz Côa','Vila Nova de Foz Coa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30622,'PT.13.1001','PT','PT.13','Alcobaça','Alcobaca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30623,'PT.13.1002','PT','PT.13','Alvaiázere','Alvaiazere',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30624,'PT.13.1003','PT','PT.13','Ansião','Ansiao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30625,'PT.13.1004','PT','PT.13','Batalha','Batalha',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30626,'PT.13.1005','PT','PT.13','Bombarral','Bombarral',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30627,'PT.13.1006','PT','PT.13','Caldas da Rainha','Caldas da Rainha',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30628,'PT.13.1007','PT','PT.13','Castanheira de Pêra','Castanheira de Pera',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30629,'PT.13.1008','PT','PT.13','Figueiró Dos Vinhos','Figueiro Dos Vinhos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30630,'PT.13.1009','PT','PT.13','Leiria','Leiria',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30631,'PT.13.1010','PT','PT.13','Marinha Grande','Marinha Grande',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30632,'PT.13.1011','PT','PT.13','Nazaré','Nazare',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30633,'PT.13.1012','PT','PT.13','Óbidos','Obidos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30634,'PT.13.1013','PT','PT.13','Pedrógão Grande','Pedrogao Grande',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30635,'PT.13.1014','PT','PT.13','Peniche','Peniche',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30636,'PT.13.1015','PT','PT.13','Pombal','Pombal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30637,'PT.13.1016','PT','PT.13','Porto de Mós','Porto de Mos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30638,'PT.14.1101','PT','PT.14','Alenquer','Alenquer',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30639,'PT.14.1102','PT','PT.14','Arruda Dos Vinhos','Arruda Dos Vinhos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30640,'PT.14.1103','PT','PT.14','Azambuja','Azambuja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30641,'PT.14.1104','PT','PT.14','Cadaval','Cadaval',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30642,'PT.14.1105','PT','PT.14','Cascais','Cascais',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30643,'PT.14.1108','PT','PT.14','Lourinhã','Lourinha',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30644,'PT.14.1109','PT','PT.14','Mafra','Mafra',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30645,'PT.14.1110','PT','PT.14','Oeiras','Oeiras',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30646,'PT.14.1111','PT','PT.14','Sintra','Sintra',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30647,'PT.14.1112','PT','PT.14','Sobral de Monte Agraço','Sobral de Monte Agraco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30648,'PT.14.1113','PT','PT.14','Torres Vedras','Torres Vedras',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30649,'PT.14.1114','PT','PT.14','Vila Franca de Xira','Vila Franca de Xira',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30650,'PT.14.1115','PT','PT.14','Amadora','Amadora',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30651,'PT.14.1116','PT','PT.14','Odivelas','Odivelas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30652,'PT.16.1202','PT','PT.16','Arronches','Arronches',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30653,'PT.16.1203','PT','PT.16','Avis','Avis',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30654,'PT.16.1204','PT','PT.16','Campo Maior','Campo Maior',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30655,'PT.16.1207','PT','PT.16','Elvas','Elvas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30656,'PT.16.1208','PT','PT.16','Fronteira','Fronteira',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30657,'PT.16.1215','PT','PT.16','Sousel','Sousel',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30658,'PT.17.1301','PT','PT.17','Amarante','Amarante',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30659,'PT.17.1302','PT','PT.17','Baião','Baiao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30660,'PT.17.1303','PT','PT.17','Felgueiras','Felgueiras',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30661,'PT.17.1304','PT','PT.17','Gondomar','Gondomar',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30662,'PT.17.1305','PT','PT.17','Lousada','Lousada',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30663,'PT.17.1306','PT','PT.17','Maia','Maia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30664,'PT.17.1307','PT','PT.17','Marco de Canaveses','Marco de Canaveses',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30665,'PT.17.1308','PT','PT.17','Matosinhos','Matosinhos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30666,'PT.17.1309','PT','PT.17','Paços de Ferreira','Pacos de Ferreira',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30667,'PT.17.1310','PT','PT.17','Paredes','Paredes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30668,'PT.17.1311','PT','PT.17','Penafiel','Penafiel',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30669,'PT.17.1313','PT','PT.17','Póvoa de Varzim','Povoa de Varzim',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30670,'PT.17.1314','PT','PT.17','Santo Tirso','Santo Tirso',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30671,'PT.17.1315','PT','PT.17','Valongo','Valongo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30672,'PT.17.1316','PT','PT.17','Vila do Conde','Vila do Conde',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30673,'PT.17.1317','PT','PT.17','Vila Nova de Gaia','Vila Nova de Gaia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30674,'PT.17.1318','PT','PT.17','Trofa','Trofa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30675,'PT.18.1401','PT','PT.18','Abrantes','Abrantes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30676,'PT.18.1402','PT','PT.18','Alcanena','Alcanena',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30677,'PT.18.1403','PT','PT.18','Almeirim','Almeirim',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30678,'PT.18.1404','PT','PT.18','Alpiarça','Alpiarca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30679,'PT.18.1405','PT','PT.18','Benavente','Benavente',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30680,'PT.18.1406','PT','PT.18','Cartaxo','Cartaxo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30681,'PT.18.1407','PT','PT.18','Chamusca','Chamusca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30682,'PT.18.1408','PT','PT.18','Constância','Constancia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30683,'PT.18.1409','PT','PT.18','Coruche','Coruche',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30684,'PT.18.1410','PT','PT.18','Entroncamento','Entroncamento',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30685,'PT.18.1411','PT','PT.18','Ferreira do Zêzere','Ferreira do Zezere',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30686,'PT.18.1412','PT','PT.18','Golegã','Golega',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30687,'PT.18.1413','PT','PT.18','Mação','Macao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30688,'PT.18.1414','PT','PT.18','Rio Maior','Rio Maior',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30689,'PT.18.1415','PT','PT.18','Salvaterra de Magos','Salvaterra de Magos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30690,'PT.18.1416','PT','PT.18','Santarém','Santarem',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30691,'PT.18.1417','PT','PT.18','Sardoal','Sardoal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30692,'PT.18.1418','PT','PT.18','Tomar','Tomar',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30693,'PT.18.1419','PT','PT.18','Torres Novas','Torres Novas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30694,'PT.18.1420','PT','PT.18','Vila Nova da Barquinha','Vila Nova da Barquinha',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30695,'PT.18.1421','PT','PT.18','Ourém','Ourem',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30696,'PT.19.1501','PT','PT.19','Alcácer do Sal','Alcacer do Sal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30697,'PT.19.1502','PT','PT.19','Alcochete','Alcochete',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30698,'PT.19.1503','PT','PT.19','Almada','Almada',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30699,'PT.19.1504','PT','PT.19','Barreiro','Barreiro',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30700,'PT.19.1505','PT','PT.19','Grândola','Grandola',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30701,'PT.19.1506','PT','PT.19','Moita','Moita',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30702,'PT.19.1507','PT','PT.19','Montijo','Montijo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30703,'PT.19.1508','PT','PT.19','Palmela','Palmela',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30704,'PT.19.1509','PT','PT.19','Santiago do Cacém','Santiago do Cacem',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30705,'PT.19.1511','PT','PT.19','Sesimbra','Sesimbra',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30706,'PT.19.1512','PT','PT.19','Setúbal','Setubal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30707,'PT.19.1513','PT','PT.19','Sines','Sines',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30708,'PT.20.1601','PT','PT.20','Arcos de Valdevez','Arcos de Valdevez',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30709,'PT.20.1602','PT','PT.20','Caminha','Caminha',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30710,'PT.20.1603','PT','PT.20','Melgaço','Melgaco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30711,'PT.20.1604','PT','PT.20','Monção','Moncao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30712,'PT.20.1605','PT','PT.20','Paredes de Coura','Paredes de Coura',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30713,'PT.20.1606','PT','PT.20','Ponte da Barca','Ponte da Barca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30714,'PT.20.1607','PT','PT.20','Ponte de Lima','Ponte de Lima',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30715,'PT.20.1608','PT','PT.20','Valença','Valenca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30716,'PT.20.1609','PT','PT.20','Viana do Castelo','Viana do Castelo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30717,'PT.20.1610','PT','PT.20','Vila Nova de Cerveira','Vila Nova de Cerveira',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30718,'PT.21.1701','PT','PT.21','Alijó','Alijo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30719,'PT.21.1702','PT','PT.21','Boticas','Boticas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30720,'PT.21.1703','PT','PT.21','Chaves','Chaves',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30721,'PT.21.1704','PT','PT.21','Mesão Frio','Mesao Frio',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30722,'PT.21.1705','PT','PT.21','Mondim de Basto','Mondim de Basto',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30723,'PT.21.1706','PT','PT.21','Montalegre','Montalegre',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30724,'PT.21.1707','PT','PT.21','Murça','Murca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30725,'PT.21.1708','PT','PT.21','Peso da Régua','Peso da Regua',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30726,'PT.21.1709','PT','PT.21','Ribeira de Pena','Ribeira de Pena',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30727,'PT.21.1710','PT','PT.21','Sabrosa','Sabrosa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30728,'PT.21.1711','PT','PT.21','Santa Marta de Penaguião','Santa Marta de Penaguiao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30729,'PT.21.1712','PT','PT.21','Valpaços','Valpacos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30730,'PT.21.1713','PT','PT.21','Vila Pouca de Aguiar','Vila Pouca de Aguiar',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30731,'PT.21.1714','PT','PT.21','Vila Real','Vila Real',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30732,'PT.22.1801','PT','PT.22','Armamar','Armamar',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30733,'PT.22.1803','PT','PT.22','Castro Daire','Castro Daire',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30734,'PT.22.1804','PT','PT.22','Cinfães','Cinfaes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30735,'PT.22.1805','PT','PT.22','Lamego','Lamego',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30736,'PT.22.1806','PT','PT.22','Mangualde','Mangualde',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30737,'PT.22.1807','PT','PT.22','Moimenta da Beira','Moimenta da Beira',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30738,'PT.22.1808','PT','PT.22','Mortágua','Mortagua',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30739,'PT.22.1809','PT','PT.22','Nelas','Nelas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30740,'PT.22.1810','PT','PT.22','Oliveira de Frades','Oliveira de Frades',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30741,'PT.22.1811','PT','PT.22','Penalva do Castelo','Penalva do Castelo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30742,'PT.22.1812','PT','PT.22','Penedono','Penedono',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30743,'PT.22.1813','PT','PT.22','Resende','Resende',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30744,'PT.22.1814','PT','PT.22','Santa Comba Dão','Santa Comba Dao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30745,'PT.22.1815','PT','PT.22','São João da Pesqueira','Sao Joao da Pesqueira',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30746,'PT.22.1816','PT','PT.22','São Pedro do Sul','Sao Pedro do Sul',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30747,'PT.22.1817','PT','PT.22','Sátão','Satao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30748,'PT.22.1818','PT','PT.22','Sernancelhe','Sernancelhe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30749,'PT.22.1819','PT','PT.22','Tabuaço','Tabuaco',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30750,'PT.22.1820','PT','PT.22','Tarouca','Tarouca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30751,'PT.22.1822','PT','PT.22','Vila Nova de Paiva','Vila Nova de Paiva',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30752,'PT.22.1823','PT','PT.22','Viseu','Viseu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30753,'PT.22.1824','PT','PT.22','Vouzela','Vouzela',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30754,'PT.10.3101','PT','PT.10','Calheta','Calheta',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30755,'PT.10.3102','PT','PT.10','Câmara de Lobos','Camara de Lobos',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30756,'PT.10.3103','PT','PT.10','Funchal','Funchal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30757,'PT.10.3104','PT','PT.10','Machico','Machico',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30758,'PT.10.3105','PT','PT.10','Ponta do Sol','Ponta do Sol',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30759,'PT.10.3106','PT','PT.10','Porto Moniz','Porto Moniz',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30760,'PT.10.3107','PT','PT.10','Ribeira Brava','Ribeira Brava',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30761,'PT.10.3108','PT','PT.10','Santa Cruz','Santa Cruz',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30762,'PT.10.3109','PT','PT.10','Santana','Santana',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30763,'PT.10.3110','PT','PT.10','São Vicente','Sao Vicente',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30764,'PT.10.3201','PT','PT.10','Porto Santo','Porto Santo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30765,'PT.23.4101','PT','PT.23','Vila do Porto','Vila do Porto',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30766,'PT.23.4201','PT','PT.23','Lagoa','Lagoa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30767,'PT.23.4202','PT','PT.23','Nordeste','Nordeste',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30768,'PT.23.4203','PT','PT.23','Ponta Delgada','Ponta Delgada',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30769,'PT.23.4204','PT','PT.23','Povoação','Povoacao',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30770,'PT.23.4205','PT','PT.23','Ribeira Grande','Ribeira Grande',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30771,'PT.23.4206','PT','PT.23','Vila Franca do Campo','Vila Franca do Campo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30772,'PT.23.4301','PT','PT.23','Angra do Heroísmo','Angra do Heroismo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30773,'PT.23.4302','PT','PT.23','Praia da Vitória','Praia da Vitoria',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30774,'PT.23.4401','PT','PT.23','Santa Cruz da Graciosa','Santa Cruz da Graciosa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30775,'PT.23.4501','PT','PT.23','Calheta de São Jorge','Calheta de Sao Jorge',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30776,'PT.23.4502','PT','PT.23','Velas','Velas',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30777,'PT.23.4601','PT','PT.23','Lajes do Pico','Lajes do Pico',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30778,'PT.23.4602','PT','PT.23','Madalena','Madalena',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30779,'PT.23.4603','PT','PT.23','São Roque do Pico','Sao Roque do Pico',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30780,'PT.23.4701','PT','PT.23','Horta','Horta',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30781,'PT.23.4801','PT','PT.23','Lajes Das Flores','Lajes Das Flores',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30782,'PT.23.4802','PT','PT.23','Santa Cruz Das Flores','Santa Cruz Das Flores',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (30783,'PT.23.4901','PT','PT.23','Corvo','Corvo',1);

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

INSERT INTO `<<prefix>>cities` VALUES (2261577,'PT','Vila Viçosa','Vila Vicosa',38.7777,-7.41793,'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` VALUES (2261598,'PT','Vila Real de Santo António','Vila Real de Santo Antonio',37.195,-7.41766,'P','PPLA2','PT.09','PT.09.0816',11560,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2261639,'PT','Vila Franca de Xira','Vila Franca de Xira',38.9552,-8.98966,'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` VALUES (2261673,'PT','Vieira de Leiria','Vieira de Leiria',39.8694,-8.93238,'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` VALUES (2261697,'PT','Vialonga','Vialonga',38.8721,-9.07805,'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` VALUES (2261732,'PT','Ventosa','Ventosa',39.127,-9.08423,'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` VALUES (2261740,'PT','Vendas Novas','Vendas Novas',38.6771,-8.45792,'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` VALUES (2262373,'PT','Vale da Amoreira','Vale da Amoreira',39.0697,-7.69849,'P','PPL','PT.16','PT.16.1208',10828,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2262465,'PT','Unhos','Unhos',38.8259,-9.12231,'P','PPL','PT.14','PT.14.1107',10712,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2262544,'PT','Trafaria','Trafaria',38.6722,-9.23268,'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` VALUES (2262581,'PT','Torres Vedras','Torres Vedras',39.0911,-9.2586,'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` VALUES (2262582,'PT','Torres Novas','Torres Novas',39.4811,-8.53949,'P','PPLA2','PT.18','PT.18.1419',14526,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2262644,'PT','Tomar','Tomar',39.602,-8.40924,'P','PPLA2','PT.18','PT.18.1418',19168,'Europe/Lisbon',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2262744,'PT','Tavira','Tavira',37.1273,-7.64861,'P','PPLA2','PT.09','PT.09.0814',15133,'Europe/Lisbon',1,'2017-09-18 23:00:00','2017-09-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2262865,'PT','Sobreda','Sobreda',38.6496,-9.18977,'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` VALUES (2262912,'PT','Sintra','Sintra',38.801,-9.37826,'P','PPLA2','PT.14','PT.14.1111',26193,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2262917,'PT','Sines','Sines',37.9562,-8.86979,'P','PPLA2','PT.19','PT.19.1513',12791,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2262926,'PT','Silves','Silves',37.1892,-8.43822,'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` VALUES (2262944,'PT','Silveira','Silveira',39.1112,-9.3643,'P','PPL','PT.14','PT.14.1113',6942,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2262957,'PT','Sesimbra','Sesimbra',38.4445,-9.10149,'P','PPL','PT.19','PT.19.1511',41134,'Europe/Lisbon',1,'2015-02-19 23:00:00','2015-02-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2262963,'PT','Setúbal','Setubal',38.5244,-8.8882,'P','PPLA','PT.19','PT.19.1512',117110,'Europe/Lisbon',1,'2012-09-17 23:00:00','2012-09-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2262987,'PT','Sertã','Serta',39.8085,-8.09883,'P','PPLA2','PT.06','PT.06.0509',5636,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263049,'PT','Serpa','Serpa',37.9458,-7.59754,'P','PPLA2','PT.03','PT.03.0213',6586,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263197,'PT','São Vicente','Sao Vicente',32.7967,-17.0432,'P','PPL','PT.10','PT.10.3110',6063,'Atlantic/Madeira',1,'2011-09-03 23:00:00','2011-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263228,'PT','São Roque','Sao Roque',32.6667,-16.9167,'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` VALUES (2263326,'PT','São João da Talha','Sao Joao da Talha',38.8218,-9.09079,'P','PPL','PT.14','PT.14.1107',18925,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263327,'PT','São João das Lampas','Sao Joao das Lampas',38.8738,-9.39842,'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` VALUES (2263352,'PT','São Domingos de Rana','Sao Domingos de Rana',38.7012,-9.3276,'P','PPL','PT.14','PT.14.1105',46718,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263377,'PT','São Brás de Alportel','Sao Bras de Alportel',37.1531,-7.88751,'P','PPLA2','PT.09','PT.09.0812',11153,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263393,'PT','São Bartolomeu de Messines','Sao Bartolomeu de Messines',37.2602,-8.2867,'P','PPL','PT.09','PT.09.0813',8381,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263426,'PT','Santo António da Charneca','Santo Antonio da Charneca',38.6256,-9.03043,'P','PPL','PT.19','PT.19.1504',11143,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263438,'PT','Santo André','Santo Andre',39.0553,-8.24414,'P','PPL','PT.16','PT.16.1213',11213,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263439,'PT','Santo André','Santo Andre',38.0608,-8.7822,'P','PPL','PT.19','PT.19.1509',10601,'Europe/Lisbon',1,'2017-11-06 23:00:00','2017-11-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263458,'PT','Santiago do Cacém','Santiago do Cacem',38.0169,-8.69475,'P','PPLA2','PT.19','PT.19.1509',7797,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263480,'PT','Santarém','Santarem',39.2333,-8.68333,'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` VALUES (2263491,'PT','Santana','Santana',32.8,-16.8833,'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` VALUES (2263523,'PT','Santa Iria da Azóia','Santa Iria da Azoia',38.8463,-9.08748,'P','PPL','PT.14','PT.14.1107',18573,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263540,'PT','Santa Cruz','Santa Cruz',32.6833,-16.8,'P','PPL','PT.10','PT.10.3108',6010,'Atlantic/Madeira',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263586,'PT','Samora Correia','Samora Correia',38.9371,-8.87178,'P','PPL','PT.18','PT.18.1405',14154,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263596,'PT','Salvaterra de Magos','Salvaterra de Magos',39.0279,-8.7935,'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` VALUES (2263667,'PT','Sacavém','Sacavem',38.792,-9.10801,'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` VALUES (2263823,'PT','Rio Maior','Rio Maior',39.3373,-8.93906,'P','PPLA2','PT.18','PT.18.1414',12064,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263827,'PT','Rio de Mouro','Rio de Mouro',38.7746,-9.3276,'P','PPL','PT.14','PT.14.1111',54695,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263905,'PT','Ribeira Brava','Ribeira Brava',32.6776,-17.0667,'P','PPL','PT.10','PT.10.3107',5932,'Atlantic/Madeira',1,'2017-09-26 23:00:00','2017-09-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263923,'PT','Riachos','Riachos',39.4447,-8.5142,'P','PPL','PT.18','PT.18.1419',5463,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2263974,'PT','Reguengos de Monsaraz','Reguengos de Monsaraz',38.4253,-7.53494,'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` VALUES (2264009,'PT','Redondo','Redondo',38.6487,-7.54708,'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` VALUES (2264087,'PT','Ramada','Ramada',38.8023,-9.19216,'P','PPL','PT.14','PT.14.1116',17535,'Europe/Lisbon',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2264169,'PT','Quinta do Anjo','Quinta do Anjo',38.5675,-8.94228,'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` VALUES (2264268,'PT','Queluz','Queluz',38.7566,-9.25451,'P','PPL','PT.14','PT.14.1111',103399,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2264270,'PT','Quejas','Quejas',38.7224,-9.26593,'P','PPL','PT.14','PT.14.1110',8828,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2264299,'PT','Quarteira','Quarteira',37.0695,-8.10064,'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` VALUES (2264341,'PT','Pragal','Pragal',38.6746,-9.16981,'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` VALUES (2264357,'PT','Póvoa de Santo Adrião','Povoa de Santo Adriao',38.8,-9.16667,'P','PPL','PT.14','PT.14.1116',14897,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2264359,'PT','Póvoa de Santa Iria','Povoa de Santa Iria',38.861,-9.06453,'P','PPL','PT.14','PT.14.1114',28901,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2264403,'PT','Porto Salvo','Porto Salvo',38.7174,-9.29833,'P','PPL','PT.14','PT.14.1110',13867,'Europe/Lisbon',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2264427,'PT','Porto de Mós','Porto de Mos',39.6019,-8.81839,'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` VALUES (2264456,'PT','Portimão','Portimao',37.1386,-8.53775,'P','PPL','PT.09','PT.09.0811',38487,'Europe/Lisbon',1,'2018-01-12 23:00:00','2018-01-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2264508,'PT','Portalegre','Portalegre',39.2938,-7.43122,'P','PPLA','PT.16','PT.16.1214',15581,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2264526,'PT','Pontinha','Pontinha',38.7677,-9.19935,'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` VALUES (2264538,'PT','Ponte de Sôr','Ponte de Sor',39.2496,-8.01009,'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` VALUES (2264575,'PT','Pombal','Pombal',39.9167,-8.62847,'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` VALUES (2264718,'PT','Pinhal Novo','Pinhal Novo',38.6311,-8.91376,'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` VALUES (2264736,'PT','Piedade','Piedade',38.6667,-9.15,'P','PPL','PT.19','PT.19.1503',19472,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2264923,'PT','Peniche','Peniche',39.3558,-9.38112,'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` VALUES (2265120,'PT','Pataias','Pataias',39.6698,-8.9958,'P','PPL','PT.13','PT.13.1001',5510,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2265169,'PT','Parede','Parede',38.6928,-9.35412,'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` VALUES (2265223,'PT','Palmela','Palmela',38.569,-8.90126,'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` VALUES (2265326,'PT','Paço de Arcos','Paco de Arcos',38.6957,-9.29143,'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` VALUES (2265388,'PT','Ourém','Ourem',39.6417,-8.5919,'P','PPLA2','PT.18','PT.18.1421',12729,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2265422,'PT','Olival do Basto','Olival do Basto',38.7908,-9.16621,'P','PPL','PT.14','PT.14.1116',5959,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2265447,'PT','Olhão','Olhao',37.0286,-7.8411,'P','PPLA2','PT.09','PT.09.0810',29239,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2265467,'PT','Odivelas','Odivelas',38.7927,-9.1838,'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` VALUES (2265472,'PT','Odemira','Odemira',37.598,-8.63972,'P','PPL','PT.03','PT.03.0211',5830,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2265485,'PT','Óbidos','Obidos',39.3605,-9.1567,'P','PPLA2','PT.13','PT.13.1012',11187,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2265494,'PT','Nossa Senhora do Monte','Nossa Senhora do Monte',32.6667,-16.9,'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` VALUES (2265552,'PT','Nazaré','Nazare',39.6029,-9.06836,'P','PPLA2','PT.13','PT.13.1011',8993,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2265686,'PT','Moura','Moura',38.1401,-7.44856,'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` VALUES (2265726,'PT','Moscavide','Moscavide',38.7793,-9.10222,'P','PPL','PT.14','PT.14.1107',11488,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2265788,'PT','Montijo','Montijo',38.7067,-8.97388,'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` VALUES (2265888,'PT','Montemor-o-Novo','Montemor-o-Novo',38.6481,-8.21455,'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` VALUES (2265927,'PT','Monte Estoril','Monte Estoril',38.7028,-9.41606,'P','PPL','PT.14','PT.14.1105',23375,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2266249,'PT','Monsanto','Monsanto',39.462,-8.7118,'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` VALUES (2266268,'PT','Monchique','Monchique',37.3177,-8.55529,'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` VALUES (2266272,'PT','Moncarapacho','Moncarapacho',37.0886,-7.78722,'P','PPL','PT.09','PT.09.0810',8545,'Europe/Lisbon',1,'2012-08-03 23:00:00','2012-08-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2266319,'PT','Moita','Moita',38.6508,-8.99038,'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` VALUES (2266411,'PT','Milharado','Milharado',38.9473,-9.19914,'P','PPL','PT.14','PT.14.1109',5935,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2266702,'PT','Marinhais','Marinhais',39.0473,-8.70236,'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` VALUES (2266703,'PT','Marinha Grande','Marinha Grande',39.7477,-8.93228,'P','PPLA2','PT.13','PT.13.1010',28916,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2266865,'PT','Mafra','Mafra',38.9379,-9.32756,'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` VALUES (2266895,'PT','Machico','Machico',32.7162,-16.7676,'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` VALUES (2266914,'PT','Maceira','Maceira',39.6885,-8.89423,'P','PPL','PT.13','PT.13.1009',9831,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2266961,'PT','Lourinhã','Lourinha',39.2417,-9.31254,'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` VALUES (2266974,'PT','Louriçal','Lourical',40.0039,-8.73736,'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` VALUES (2266977,'PT','Loures','Loures',38.8309,-9.16845,'P','PPL','PT.14','PT.14.1107',66231,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2266988,'PT','Loulé','Loule',37.1377,-8.01968,'P','PPLA2','PT.09','PT.09.0808',23109,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2267057,'PT','Lisbon','Lisbon',38.7167,-9.13333,'P','PPLC','PT.14','PT.14.1106',517802,'Europe/Lisbon',1,'2015-03-07 23:00:00','2015-03-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2267067,'PT','Linda-a-Velha','Linda-a-Velha',38.7145,-9.2422,'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` VALUES (2267095,'PT','Leiria','Leiria',39.7436,-8.80705,'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` VALUES (2267131,'PT','Laranjeiro','Laranjeiro',37.0683,-7.7937,'P','PPL','PT.09','PT.09.0810',20473,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2267226,'PT','Lagos','Lagos',37.102,-8.67422,'P','PPL','PT.09','PT.09.0807',18831,'Europe/Lisbon',1,'2012-10-24 23:00:00','2012-10-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2267254,'PT','Lagoa','Lagoa',37.1353,-8.45319,'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` VALUES (2267538,'PT','Grândola','Grandola',38.1772,-8.56675,'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` VALUES (2267827,'PT','Funchal','Funchal',32.6657,-16.9255,'P','PPLA','PT.10','PT.10.3103',100847,'Atlantic/Madeira',1,'2016-12-09 23:00:00','2016-12-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2268250,'PT','Ferreiras','Ferreiras',37.1293,-8.23759,'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` VALUES (2268313,'PT','Fazendas de Almeirim','Fazendas de Almeirim',39.1755,-8.56927,'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` VALUES (2268326,'PT','Fátima','Fatima',39.6207,-8.65237,'P','PPL','PT.18','PT.18.1421',11798,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2268339,'PT','Faro','Faro',37.0194,-7.93223,'P','PPLA','PT.09','PT.09.0805',41355,'Europe/Lisbon',1,'2013-11-14 23:00:00','2013-11-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2268358,'PT','Famões','Famoes',38.788,-9.21033,'P','PPL','PT.14','PT.14.1116',9435,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2268406,'PT','Évora','Evora',38.5667,-7.9,'P','PPLA','PT.08','PT.08.0705',55620,'Europe/Lisbon',1,'2015-04-04 23:00:00','2015-04-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2268411,'PT','Estremoz','Estremoz',38.8443,-7.58585,'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` VALUES (2268436,'PT','Estoril','Estoril',38.7057,-9.39773,'P','PPL','PT.14','PT.14.1105',23700,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2268437,'PT','Estômbar','Estombar',37.1463,-8.48505,'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` VALUES (2268563,'PT','Ericeira','Ericeira',38.9627,-9.41563,'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` VALUES (2268575,'PT','Entroncamento','Entroncamento',39.4667,-8.46667,'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` VALUES (2268615,'PT','Elvas','Elvas',38.8815,-7.16282,'P','PPLA2','PT.16','PT.16.1207',9904,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2268916,'PT','Costa de Caparica','Costa de Caparica',38.6446,-9.23556,'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` VALUES (2268946,'PT','Coruche','Coruche',38.9595,-8.52524,'P','PPLA2','PT.18','PT.18.1409',8776,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2269041,'PT','Corroios','Corroios',38.645,-9.14843,'P','PPL','PT.19','PT.19.1510',52520,'Europe/Lisbon',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2269142,'PT','Colares','Colares',38.7992,-9.44691,'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` VALUES (2269282,'PT','Charneca','Charneca',38.6206,-9.19149,'P','PPL','PT.19','PT.19.1503',23714,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2269496,'PT','Castro Marim','Castro Marim',37.2207,-7.4435,'P','PPLA2','PT.09','PT.09.0804',5089,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2269514,'PT','Castelo Branco','Castelo Branco',39.8222,-7.49087,'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` VALUES (2269556,'PT','Castanheira do Ribatejo','Castanheira do Ribatejo',38.993,-8.97346,'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` VALUES (2269594,'PT','Cascais','Cascais',38.6968,-9.42147,'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` VALUES (2270023,'PT','Cartaxo','Cartaxo',39.1602,-8.78741,'P','PPLA2','PT.18','PT.18.1406',10502,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2270084,'PT','Carregado','Carregado',39.0236,-8.97692,'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` VALUES (2270157,'PT','Carnaxide','Carnaxide',38.7271,-9.24671,'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` VALUES (2270184,'PT','Carcavelos','Carcavelos',38.6911,-9.32215,'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` VALUES (2270211,'PT','Caranguejeira','Caranguejeira',39.7462,-8.7074,'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` VALUES (2270229,'PT','Caparica','Caparica',38.6667,-9.2,'P','PPL','PT.19','PT.19.1503',21167,'Europe/Lisbon',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2270258,'PT','Caniço','Canico',32.6508,-16.8375,'P','PPL','PT.10','PT.10.3108',23368,'Atlantic/Madeira',1,'2018-01-10 23:00:00','2018-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2270290,'PT','Caneças','Canecas',38.8132,-9.22679,'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` VALUES (2270336,'PT','Campo Maior','Campo Maior',39.0177,-7.06497,'P','PPLA2','PT.16','PT.16.1204',8235,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2270377,'PT','Camarate','Camarate',38.8036,-9.12809,'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` VALUES (2270380,'PT','Câmara de Lobos','Camara de Lobos',32.6333,-16.9667,'P','PPL','PT.10',NULL,32209,'Atlantic/Madeira',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2270385,'PT','Camacha','Camacha',33.0867,-16.3425,'P','PPL','PT.10','PT.10.3201',8635,'Atlantic/Madeira',1,'2014-10-14 23:00:00','2014-10-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2270386,'PT','Camacha','Camacha',32.6792,-16.8446,'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` VALUES (2270437,'PT','Caldas da Rainha','Caldas da Rainha',39.4033,-9.13839,'P','PPLA2','PT.13','PT.13.1006',26647,'Europe/Lisbon',1,'2016-08-30 23:00:00','2016-08-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2270486,'PT','Cacilhas','Cacilhas',38.6877,-9.14663,'P','PPL','PT.19','PT.19.1503',6494,'Europe/Lisbon',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2270503,'PT','Cacém','Cacem',38.767,-9.29793,'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` VALUES (2270770,'PT','Bombarral','Bombarral',39.2672,-9.15795,'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` VALUES (2270813,'PT','Bobadela','Bobadela',38.8077,-9.09925,'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` VALUES (2270935,'PT','Benedita','Benedita',39.4247,-8.96996,'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` VALUES (2270940,'PT','Benavente','Benavente',38.9792,-8.80759,'P','PPLA2','PT.18','PT.18.1405',8932,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2270981,'PT','Belas','Belas',38.7772,-9.26078,'P','PPL','PT.14','PT.14.1111',21019,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2270985,'PT','Beja','Beja',38.0151,-7.86323,'P','PPLA','PT.03','PT.03.0205',34760,'Europe/Lisbon',1,'2013-08-04 23:00:00','2013-08-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2271006,'PT','Batalha','Batalha',39.6603,-8.82475,'P','PPLA2','PT.13','PT.13.1004',7910,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2271071,'PT','Barreiro','Barreiro',38.6631,-9.0724,'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` VALUES (2271140,'PT','Barcarena','Barcarena',38.7324,-9.28,'P','PPL','PT.14','PT.14.1110',11968,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2271337,'PT','Azambuja','Azambuja',39.0703,-8.86822,'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` VALUES (2271354,'PT','Atouguia da Baleia','Atouguia da Baleia',39.3381,-9.3263,'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` VALUES (2271438,'PT','Arruda dos Vinhos','Arruda dos Vinhos',38.9841,-9.07746,'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` VALUES (2271473,'PT','Arrentela','Arrentela',38.6167,-9.1,'P','PPL','PT.19','PT.19.1510',30156,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2271623,'PT','Apelação','Apelacao',38.8139,-9.13225,'P','PPL','PT.14','PT.14.1107',7182,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2271680,'PT','Amora','Amora',38.6296,-9.11557,'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` VALUES (2271772,'PT','Amadora','Amadora',38.7538,-9.23083,'P','PPL','PT.14','PT.14.1115',178858,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2271782,'PT','Alvor','Alvor',37.1299,-8.59174,'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` VALUES (2271878,'PT','Alpiarça','Alpiarca',39.2571,-8.58187,'P','PPLA2','PT.18','PT.18.1404',7946,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2271912,'PT','Almodôvar','Almodovar',37.5128,-8.06008,'P','PPLA2','PT.03','PT.03.0202',7449,'Europe/Lisbon',1,'2017-11-08 23:00:00','2017-11-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2271926,'PT','Almeirim','Almeirim',39.209,-8.61643,'P','PPLA2','PT.18','PT.18.1403',11557,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2271945,'PT','Almargem','Almargem',38.8448,-9.27315,'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` VALUES (2271947,'PT','Almancil','Almancil',37.0869,-8.03074,'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` VALUES (2271961,'PT','Almada','Almada',38.679,-9.1569,'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` VALUES (2271965,'PT','Aljustrel','Aljustrel',37.8776,-8.16516,'P','PPLA2','PT.03','PT.03.0201',5334,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2271966,'PT','Aljubarrota','Aljubarrota',39.5672,-8.92925,'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` VALUES (2271968,'PT','Aljezur','Aljezur',37.3191,-8.8033,'P','PPLA2','PT.09','PT.09.0803',5884,'Europe/Lisbon',1,'2017-11-08 23:00:00','2017-11-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2271970,'PT','Alhos Vedros','Alhos Vedros',38.6549,-9.02368,'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` VALUES (2271975,'PT','Alhandra','Alhandra',38.9273,-9.00864,'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` VALUES (2271985,'PT','Algés','Alges',38.7024,-9.22936,'P','PPL','PT.14','PT.14.1110',19327,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2272036,'PT','Alenquer','Alenquer',39.0532,-9.00928,'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` VALUES (2272091,'PT','Aldeia de Paio Pires','Aldeia de Paio Pires',38.6167,-9.08333,'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` VALUES (2272144,'PT','Alcochete','Alcochete',38.7553,-8.96086,'P','PPLA2','PT.19','PT.19.1502',9705,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2272147,'PT','Alcobaça','Alcobaca',39.5522,-8.97749,'P','PPLA2','PT.13','PT.13.1001',5051,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2272190,'PT','Alcanede','Alcanede',39.415,-8.82189,'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` VALUES (2272197,'PT','Alcains','Alcains',39.9164,-7.45655,'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` VALUES (2272212,'PT','Alcácer do Sal','Alcacer do Sal',38.3733,-8.51444,'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` VALUES (2272215,'PT','Alcabideche','Alcabideche',38.7337,-9.40928,'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` VALUES (2272222,'PT','Albufeira','Albufeira',37.0882,-8.2503,'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` VALUES (2272379,'PT','A dos Cunhados','A dos Cunhados',39.1524,-9.2972,'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` VALUES (2272447,'PT','Abrantes','Abrantes',39.4667,-8.2,'P','PPLA2','PT.18','PT.18.1401',13646,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2732265,'PT','Viseu','Viseu',40.661,-7.90971,'P','PPLA','PT.22','PT.22.1823',26364,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2732312,'PT','Vilela','Vilela',41.2251,-7.60338,'P','PPL','PT.21','PT.21.1710',5540,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2732438,'PT','Vila Real','Vila Real',41.3006,-7.74413,'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` VALUES (2732444,'PT','Vilar do Paraíso','Vilar do Paraiso',41.0897,-8.6211,'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` VALUES (2732475,'PT','Vilar de Andorinho','Vilar de Andorinho',41.1075,-8.59632,'P','PPL','PT.17','PT.17.1317',18944,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2732544,'PT','Vila Nova de Gaia','Vila Nova de Gaia',41.1336,-8.61742,'P','PPLA2','PT.17','PT.17.1317',70811,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2732547,'PT','Vila Nova de Famalicão','Vila Nova de Famalicao',41.408,-8.51978,'P','PPLA2','PT.04','PT.04.0312',9496,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2732551,'PT','Vila Nova da Telha','Vila Nova da Telha',41.0717,-8.64146,'P','PPL','PT.17','PT.17.1317',5848,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2732649,'PT','Vila do Conde','Vila do Conde',41.3548,-8.7434,'P','PPLA2','PT.17','PT.17.1316',27642,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2732773,'PT','Viana do Castelo','Viana do Castelo',41.6932,-8.83287,'P','PPLA','PT.20','PT.20.1609',36148,'Europe/Lisbon',1,'2018-01-14 23:00:00','2018-01-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2732978,'PT','Valongo','Valongo',41.195,-8.51027,'P','PPLA2','PT.17','PT.17.1315',21328,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2732980,'PT','Valongo','Valongo',40.6167,-8.45,'P','PPL','PT.02','PT.02.0101',5085,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2733038,'PT','Válega','Valega',40.8363,-8.58061,'P','PPL','PT.02','PT.02.0115',7005,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2733153,'PT','Vale de Cambra','Vale de Cambra',40.8497,-8.39389,'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` VALUES (2733249,'PT','Valbom','Valbom',41.1325,-8.56414,'P','PPL','PT.17','PT.17.1304',14443,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2733262,'PT','Valadares','Valadares',41.1474,-7.9812,'P','PPL','PT.17','PT.17.1302',9255,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2733304,'PT','Urgeses','Urgeses',41.4272,-8.29796,'P','PPL','PT.04','PT.04.0308',5457,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2733533,'PT','Tondela','Tondela',40.5168,-8.08087,'P','PPLA2','PT.22','PT.22.1821',8800,'Europe/Lisbon',1,'2014-03-05 23:00:00','2014-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2733660,'PT','Tavarede','Tavarede',40.1708,-8.84566,'P','PPL','PT.07','PT.07.0605',8586,'Europe/Lisbon',1,'2013-04-02 23:00:00','2013-04-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2733851,'PT','Soure','Soure',40.0599,-8.62605,'P','PPLA2','PT.07','PT.07.0615',8416,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2733941,'PT','Sobrado','Sobrado',41.2104,-8.45488,'P','PPL','PT.17','PT.17.1315',6703,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2733992,'PT','Silvalde','Silvalde',40.994,-8.62608,'P','PPL','PT.02','PT.02.0107',7188,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2734028,'PT','Serzedo','Serzedo',41.405,-8.22926,'P','PPL','PT.04','PT.04.0308',8000,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2734074,'PT','Sernancelhe','Sernancelhe',40.8987,-7.49342,'P','PPLA2','PT.22','PT.22.1818',5671,'Europe/Lisbon',1,'2018-01-23 23:00:00','2018-01-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2734106,'PT','Sequeira','Sequeira',40.5536,-7.22594,'P','PPL','PT.11','PT.11.0907',28502,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2734140,'PT','Senhora da Hora','Senhora da Hora',41.1864,-8.65172,'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` VALUES (2734170,'PT','Selho','Selho',41.4194,-8.34599,'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` VALUES (2734215,'PT','Seia','Seia',40.4151,-7.70859,'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` VALUES (2734338,'PT','São Roque','Sao Roque',40.8722,-8.47149,'P','PPL','PT.02','PT.02.0113',5575,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2734339,'PT','São Romão do Coronado','Sao Romao do Coronado',41.2854,-8.5632,'P','PPL','PT.17','PT.17.1318',8697,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2734363,'PT','São Pedro da Cova','Sao Pedro da Cova',41.1433,-8.50033,'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` VALUES (2734395,'PT','São Miguel do Couto','Sao Miguel do Couto',41.3317,-8.46185,'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` VALUES (2734434,'PT','São Mamede de Infesta','Sao Mamede de Infesta',41.2004,-8.60251,'P','PPL','PT.17','PT.17.1308',25940,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2734473,'PT','São João de Ver','Sao Joao de Ver',40.9553,-8.55117,'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` VALUES (2734484,'PT','São João da Madeira','Sao Joao da Madeira',40.9023,-8.48969,'P','PPL','PT.02','PT.02.0116',22079,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2734493,'PT','São João','Sao Joao',40.868,-8.60672,'P','PPL','PT.02','PT.02.0115',6762,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2734523,'PT','São Félix da Marinha','Sao Felix da Marinha',41.0355,-8.62259,'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` VALUES (2734570,'PT','Santo Tirso','Santo Tirso',41.3426,-8.47746,'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` VALUES (2734729,'PT','Santa Cruz do Bispo','Santa Cruz do Bispo',41.2255,-8.68361,'P','PPL','PT.17','PT.17.1308',6230,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2734803,'PT','Sandim','Sandim',41.0351,-8.507,'P','PPL','PT.17','PT.17.1317',6449,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2734809,'PT','Sande','Sande',41.7019,-8.39246,'P','PPL','PT.04','PT.04.0313',7789,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2735083,'PT','Rio Tinto','Rio Tinto',41.1826,-8.55811,'P','PPL','PT.17','PT.17.1304',49966,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2735116,'PT','Rio de Loba','Rio de Loba',40.666,-7.87781,'P','PPL','PT.22','PT.22.1823',9529,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2735167,'PT','Ribeirão','Ribeirao',41.3608,-8.56774,'P','PPL','PT.04','PT.04.0312',8735,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2735340,'PT','Refojos de Basto','Refojos de Basto',41.5132,-7.99517,'P','PPL','PT.04','PT.04.0304',5037,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2735377,'PT','Rebordosa','Rebordosa',41.224,-8.40669,'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` VALUES (2735415,'PT','Real','Real',41.6388,-8.18098,'P','PPL','PT.04','PT.04.0311',5827,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2735787,'PT','Póvoa de Varzim','Povoa de Varzim',41.3834,-8.76364,'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` VALUES (2735803,'PT','Póvoa de Lanhoso','Povoa de Lanhoso',41.5787,-8.28197,'P','PPL','PT.04','PT.04.0309',5008,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2735943,'PT','Porto','Porto',41.1496,-8.61099,'P','PPLA','PT.17','PT.17.1312',249633,'Europe/Lisbon',1,'2017-06-12 23:00:00','2017-06-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2736041,'PT','Ponte de Lima','Ponte de Lima',41.7672,-8.58393,'P','PPLA2','PT.20','PT.20.1607',44667,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2736067,'PT','Ponte','Ponte',41.4706,-8.3299,'P','PPL','PT.04','PT.04.0308',7041,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2736124,'PT','Poiares','Poiares',40.2103,-8.25746,'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` VALUES (2736316,'PT','Peso da Régua','Peso da Regua',41.1649,-7.78703,'P','PPLA2','PT.21','PT.21.1708',5048,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2736327,'PT','Perozinho','Perozinho',41.0651,-8.58531,'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` VALUES (2736391,'PT','Perafita','Perafita',41.1825,-8.2545,'P','PPL','PT.17','PT.17.1311',12538,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2736469,'PT','Penafiel','Penafiel',41.2084,-8.28285,'P','PPLA2','PT.17','PT.17.1311',8065,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2736520,'PT','Pedrouços','Pedroucos',41.1931,-8.58167,'P','PPL','PT.17','PT.17.1306',12553,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2736521,'PT','Pedroso','Pedroso',41.411,-8.74897,'P','PPL','PT.17','PT.17.1313',18963,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2736883,'PT','Paços de Ferreira','Pacos de Ferreira',41.2766,-8.37617,'P','PPLA2','PT.17','PT.17.1309',6782,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2736930,'PT','Ovar','Ovar',40.8586,-8.62513,'P','PPL','PT.02','PT.02.0115',18452,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2737039,'PT','Oliveira do Douro','Oliveira do Douro',41.1247,-8.58463,'P','PPL','PT.17','PT.17.1317',24407,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2737042,'PT','Oliveira do Bairro','Oliveira do Bairro',40.5146,-8.49386,'P','PPLA2','PT.02','PT.02.0114',6239,'Europe/Lisbon',1,'2014-03-05 23:00:00','2014-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2737046,'PT','Oliveira de Azemeis','Oliveira de Azemeis',40.841,-8.47555,'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` VALUES (2737053,'PT','Oliveira','Oliveira',41.4782,-8.46965,'P','PPL','PT.04','PT.04.0303',6222,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2737064,'PT','Olival','Olival',41.0502,-8.54416,'P','PPL','PT.17','PT.17.1317',5715,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2737088,'PT','Oiã','Oia',40.5426,-8.53856,'P','PPL','PT.02','PT.02.0114',7118,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2737137,'PT','Nogueira da Regedoura','Nogueira da Regedoura',41.0053,-8.59195,'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` VALUES (2737194,'PT','Negrelos','Negrelos',41.3495,-8.40145,'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` VALUES (2737234,'PT','Murtosa','Murtosa',40.7369,-8.6377,'P','PPLA2','PT.02','PT.02.0112',8282,'Europe/Lisbon',1,'2018-01-11 23:00:00','2018-01-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2737268,'PT','Mozelos','Mozelos',41.8677,-8.39776,'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` VALUES (2737393,'PT','Moreira de Conegos','Moreira de Conegos',41.3868,-8.3394,'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` VALUES (2737399,'PT','Moreira','Moreira',41.056,-8.38939,'P','PPL','PT.17','PT.17.1304',11336,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2737523,'PT','Monção','Moncao',42.0789,-8.48076,'P','PPL','PT.20','PT.20.1604',19738,'Europe/Madrid',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2737639,'PT','Mirandela','Mirandela',41.4874,-7.18695,'P','PPLA2','PT.05','PT.05.0407',12504,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2737641,'PT','Miranda do Corvo','Miranda do Corvo',40.0932,-8.33261,'P','PPLA2','PT.07','PT.07.0609',7857,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2737651,'PT','Mira','Mira',40.4289,-8.73746,'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` VALUES (2737810,'PT','Meadela','Meadela',41.7065,-8.79628,'P','PPL','PT.20','PT.20.1609',9981,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2737824,'PT','Matosinhos','Matosinhos',41.1821,-8.68908,'P','PPLA2','PT.17','PT.17.1308',28070,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2737904,'PT','Marinhas','Marinhas',41.5591,-8.78297,'P','PPL','PT.04','PT.04.0306',6052,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2737914,'PT','Margaride','Margaride',41.3683,-8.20072,'P','PPL','PT.17','PT.17.1303',10652,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2737949,'PT','Mangualde','Mangualde',40.6043,-7.76115,'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` VALUES (2738014,'PT','Maia','Maia',41.2357,-8.6199,'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` VALUES (2738038,'PT','Madalena','Madalena',41.2162,-8.33451,'P','PPL','PT.17','PT.17.1310',9618,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2738082,'PT','Macedo de Cavaleiros','Macedo de Cavaleiros',41.5382,-6.9611,'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` VALUES (2738154,'PT','Lousã','Lousa',40.1167,-8.24921,'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` VALUES (2738159,'PT','Lourosa','Lourosa',40.9842,-8.55142,'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` VALUES (2738224,'PT','Lordelo','Lordelo',41.2345,-8.40297,'P','PPL','PT.17','PT.17.1310',10035,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2738277,'PT','Lobão','Lobao',40.9866,-8.48566,'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` VALUES (2738347,'PT','Leça do Bailio','Leca do Bailio',41.2146,-8.61348,'P','PPL','PT.17','PT.17.1306',16103,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2738348,'PT','Leça da Palmeira','Leca da Palmeira',41.191,-8.70027,'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` VALUES (2738360,'PT','Lavra','Lavra',41.2593,-8.71849,'P','PPL','PT.17','PT.17.1308',9633,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2738459,'PT','Lamego','Lamego',41.0974,-7.80991,'P','PPLA2','PT.22','PT.22.1805',10928,'Europe/Lisbon',1,'2014-03-05 23:00:00','2014-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2738479,'PT','Lamas','Lamas',40.986,-8.56923,'P','PPL','PT.02','PT.02.0109',5628,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2738643,'PT','Jovim','Jovim',41.111,-8.51903,'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` VALUES (2738658,'PT','Joane','Joane',41.4391,-8.40846,'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` VALUES (2738707,'PT','Ílhavo','Ilhavo',40.6019,-8.67021,'P','PPLA2','PT.02','PT.02.0110',17236,'Europe/Lisbon',1,'2018-01-23 23:00:00','2018-01-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2738737,'PT','Gulpilhares','Gulpilhares',41.0829,-8.62679,'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` VALUES (2738752,'PT','Guimarães','Guimaraes',41.4444,-8.29619,'P','PPLA2','PT.04','PT.04.0308',40604,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2738766,'PT','Guifões','Guifoes',41.2004,-8.66719,'P','PPL','PT.17','PT.17.1308',9231,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2738785,'PT','Guarda','Guarda',40.5373,-7.26575,'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` VALUES (2738803,'PT','Grijó','Grijo',41.0284,-8.58017,'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` VALUES (2738925,'PT','Gondomar','Gondomar',41.1445,-8.53223,'P','PPLA2','PT.17','PT.17.1304',27691,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2739034,'PT','Gemunde','Gemunde',41.2677,-8.64515,'P','PPL','PT.17','PT.17.1306',5284,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2739080,'PT','Gandra','Gandra',41.2012,-8.43376,'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` VALUES (2739118,'PT','Galegos','Galegos',41.5627,-8.57204,'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` VALUES (2739152,'PT','Gafanha da Nazaré','Gafanha da Nazare',40.6362,-8.71338,'P','PPL','PT.02','PT.02.0110',14840,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2739187,'PT','Fundão','Fundao',40.1403,-7.50135,'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` VALUES (2739285,'PT','Freamunde','Freamunde',41.2883,-8.33533,'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` VALUES (2739333,'PT','Foz do Sousa','Foz do Sousa',41.0967,-8.50184,'P','PPL','PT.17','PT.17.1304',6315,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2739590,'PT','Figueira da Foz','Figueira da Foz',40.1508,-8.86179,'P','PPLA2','PT.07','PT.07.0605',12050,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2739613,'PT','Fiães','Fiaes',40.9945,-8.52537,'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` VALUES (2739636,'PT','Ferreiros','Ferreiros',41.35,-8.55,'P','PPL','PT.04','PT.04.0312',7870,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2739723,'PT','Feira','Feira',40.9254,-8.54277,'P','PPLA2','PT.02','PT.02.0109',16376,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2739755,'PT','Apúlia e Fão','Apulia e Fao',41.5119,-8.77288,'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` VALUES (2739756,'PT','Fânzeres','Fanzeres',41.1709,-8.5257,'P','PPL','PT.17','PT.17.1304',23916,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2739788,'PT','Fafe','Fafe',41.4508,-8.17258,'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` VALUES (2739848,'PT','Esposende','Esposende',41.5361,-8.78201,'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` VALUES (2739868,'PT','Espinho','Espinho',41.0076,-8.64125,'P','PPLA2','PT.02','PT.02.0107',9566,'Europe/Lisbon',1,'2014-03-05 23:00:00','2014-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2739915,'PT','Esmoriz','Esmoriz',40.9577,-8.62753,'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` VALUES (2739997,'PT','Ermesinde','Ermesinde',41.2218,-8.55462,'P','PPL','PT.17','PT.17.1315',39420,'Europe/Lisbon',1,'2014-11-12 23:00:00','2014-11-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2740031,'PT','Eixo','Eixo',40.6276,-8.56922,'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` VALUES (2740159,'PT','Darque','Darque',41.6833,-8.76667,'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` VALUES (2740174,'PT','Custoias','Custoias',41.1053,-7.32097,'P','PPL','PT.11','PT.11.0914',19406,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2740221,'PT','Cucujães','Cucujaes',40.8741,-8.50687,'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` VALUES (2740313,'PT','Covilhã','Covilha',40.2811,-7.50504,'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` VALUES (2740593,'PT','Condeixa-a-Nova','Condeixa-a-Nova',40.1157,-8.49834,'P','PPLA2','PT.07','PT.07.0604',17078,'Europe/Lisbon',1,'2018-01-17 23:00:00','2018-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2740637,'PT','Coimbra','Coimbra',40.2056,-8.41955,'P','PPLA','PT.07','PT.07.0603',106582,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2740761,'PT','Chaves','Chaves',41.7402,-7.46879,'P','PPLA2','PT.21','PT.21.1703',13066,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2740992,'PT','Castelões de Cepeda','Casteloes de Cepeda',41.2026,-8.33516,'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` VALUES (2741405,'PT','Carregal do Sal','Carregal do Sal',40.4333,-8,'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` VALUES (2741547,'PT','Cantanhede','Cantanhede',40.3467,-8.59419,'P','PPLA2','PT.07','PT.07.0602',7347,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2741551,'PT','Canidelo','Canidelo',41.124,-8.65104,'P','PPL','PT.17','PT.17.1317',26431,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2741566,'PT','Canelas','Canelas',41.0833,-8.6,'P','PPL','PT.17','PT.17.1317',14247,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2741648,'PT','Campo','Campo',41.1852,-8.46493,'P','PPL','PT.17','PT.17.1315',8916,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2741724,'PT','Calendário','Calendario',41.4036,-8.52967,'P','PPL','PT.04','PT.04.0312',11357,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2741728,'PT','Caldelas','Caldelas',41.671,-8.38148,'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` VALUES (2741738,'PT','Caldas de Vizela','Caldas de Vizela',41.3821,-8.3089,'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` VALUES (2741961,'PT','Buarcos','Buarcos',40.166,-8.8768,'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` VALUES (2741985,'PT','Brito','Brito',41.4582,-8.36103,'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` VALUES (2742024,'PT','Branca','Branca',40.7665,-8.48262,'P','PPL','PT.02','PT.02.0102',5632,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2742027,'PT','Bragança','Braganca',41.8058,-6.75719,'P','PPLA','PT.05','PT.05.0402',34375,'Europe/Lisbon',1,'2017-01-28 23:00:00','2017-01-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2742032,'PT','Braga','Braga',41.5503,-8.42005,'P','PPLA','PT.04','PT.04.0303',121394,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2742051,'PT','Bougado','Bougado',41.3398,-8.5518,'P','PPL','PT.17','PT.17.1318',21680,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2742309,'PT','Beduido','Beduido',40.7643,-8.5611,'P','PPL','PT.02','PT.02.0108',8201,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2742330,'PT','Barrosas','Barrosas',41.3553,-8.29943,'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` VALUES (2742416,'PT','Barcelos','Barcelos',41.5388,-8.61505,'P','PPLA2','PT.04','PT.04.0302',19085,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2742506,'PT','Baguim do Monte','Baguim do Monte',41.192,-8.54118,'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` VALUES (2742557,'PT','Azenha','Azenha',41.0765,-8.62468,'P','PPL','PT.17','PT.17.1317',12260,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2742565,'PT','Avintes','Avintes',41.1175,-8.54986,'P','PPL','PT.17','PT.17.1317',11577,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2742577,'PT','Aves','Aves',41.3703,-8.4101,'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` VALUES (2742578,'PT','Aver-o-Mar','Aver-o-Mar',41.4078,-8.78118,'P','PPL','PT.17','PT.17.1313',10501,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2742611,'PT','Aveiro','Aveiro',40.6443,-8.64554,'P','PPLA','PT.02','PT.02.0105',54162,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2742617,'PT','Avanca','Avanca',40.8077,-8.5722,'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` VALUES (2742681,'PT','Arrifana','Arrifana',40.9156,-8.49657,'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` VALUES (2742750,'PT','Argoncilhe','Argoncilhe',41.0254,-8.53885,'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` VALUES (2742797,'PT','Arcozelo','Arcozelo',41.0533,-8.64326,'P','PPL','PT.17','PT.17.1317',13495,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2742811,'PT','Arcos','Arcos',40.4478,-8.44171,'P','PPL','PT.02','PT.02.0103',6725,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2742827,'PT','Arazede','Arazede',40.2863,-8.64999,'P','PPL','PT.07','PT.07.0610',5906,'Europe/Lisbon',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2742833,'PT','Aradas','Aradas',40.6208,-8.64195,'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` VALUES (2742856,'PT','Antas','Antas',41.7364,-8.30888,'P','PPL','PT.04','PT.04.0310',5569,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2742868,'PT','Anta','Anta',41.2663,-8.62844,'P','PPL','PT.17','PT.17.1306',10951,'Europe/Lisbon',1,'2011-08-27 23:00:00','2011-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2742965,'PT','Amarante','Amarante',41.2727,-8.08245,'P','PPLA2','PT.17','PT.17.1301',6782,'Europe/Lisbon',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2743095,'PT','Alfena','Alfena',41.2367,-8.52454,'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` VALUES (2743233,'PT','Albergaria-a-Velha','Albergaria-a-Velha',40.6932,-8.47994,'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` VALUES (2743292,'PT','Águeda','Agueda',40.5772,-8.44442,'P','PPLA2','PT.02','PT.02.0101',11941,'Europe/Lisbon',1,'2014-03-05 23:00:00','2014-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2743304,'PT','Águas Santas','Aguas Santas',41.2106,-8.5866,'P','PPL','PT.17','PT.17.1306',27686,'Europe/Lisbon',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2743428,'PT','Abraveses','Abraveses',40.6814,-7.92102,'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` VALUES (3372472,'PT','Vila Franca do Campo','Vila Franca do Campo',37.7167,-25.4333,'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` VALUES (3372677,'PT','Rosto de Cão','Rosto de Cao',37.75,-25.65,'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` VALUES (3372707,'PT','Ribeira Grande','Ribeira Grande',38.5167,-28.7,'P','PPL','PT.23',NULL,5198,'Atlantic/Azores',1,'2006-01-16 23:00:00','2006-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3372745,'PT','Rabo de Peixe','Rabo de Peixe',37.8,-25.5833,'P','PPL','PT.23','PT.23.4205',7681,'Atlantic/Azores',1,'2015-03-07 23:00:00','2015-03-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3372760,'PT','Praia da Vitória','Praia da Vitoria',38.7333,-27.0667,'P','PPL','PT.23','PT.23.4302',6061,'Atlantic/Azores',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3372783,'PT','Ponta Delgada','Ponta Delgada',37.7333,-25.6667,'P','PPLA','PT.23',NULL,20056,'Atlantic/Azores',1,'2012-05-04 23:00:00','2012-05-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3372908,'PT','Madalena','Madalena',38.5364,-28.5266,'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` VALUES (3372964,'PT','Lagoa','Lagoa',39.05,-27.9833,'P','PPL','PT.23','PT.23.4401',9239,'Atlantic/Azores',1,'2011-09-03 23:00:00','2011-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3372988,'PT','Horta','Horta',38.5333,-28.6333,'P','PPL','PT.23','PT.23.4701',6572,'Atlantic/Azores',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3373329,'PT','Arrifes','Arrifes',37.7667,-25.7,'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` VALUES (3373348,'PT','Angra do Heroísmo','Angra do Heroismo',38.65,-27.2167,'P','PPL','PT.23','PT.23.4301',12045,'Atlantic/Azores',1,'2012-11-22 23:00:00','2012-11-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6697257,'PT','Valenza','Valenza',42.0242,-8.63474,'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` VALUES (11808241,'PT','Azeitão','Azeitao',38.5192,-9.0139,'P','PPL','PT.19','PT.19.1512',18877,'Europe/Lisbon',1,'2018-01-17 23:00:00','2018-01-17 23:00:00');


