-- Migration 005: Estados e Municípios do Brasil (fonte: IBGE)
SET NAMES utf8mb4;

CREATE TABLE IF NOT EXISTS states (
  uf CHAR(2) PRIMARY KEY,
  name VARCHAR(60) NOT NULL,
  ibge_id INT NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS cities (
  id INT PRIMARY KEY,
  uf CHAR(2) NOT NULL,
  name VARCHAR(120) NOT NULL,
  INDEX(uf), INDEX(name),
  FOREIGN KEY (uf) REFERENCES states(uf)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT IGNORE INTO states (uf,name,ibge_id) VALUES
('AC','Acre',12),
('AL','Alagoas',27),
('AM','Amazonas',13),
('AP','Amapá',16),
('BA','Bahia',29),
('CE','Ceará',23),
('DF','Distrito Federal',53),
('ES','Espírito Santo',32),
('GO','Goiás',52),
('MA','Maranhão',21),
('MG','Minas Gerais',31),
('MS','Mato Grosso do Sul',50),
('MT','Mato Grosso',51),
('PA','Pará',15),
('PB','Paraíba',25),
('PE','Pernambuco',26),
('PI','Piauí',22),
('PR','Paraná',41),
('RJ','Rio de Janeiro',33),
('RN','Rio Grande do Norte',24),
('RO','Rondônia',11),
('RR','Roraima',14),
('RS','Rio Grande do Sul',43),
('SC','Santa Catarina',42),
('SE','Sergipe',28),
('SP','São Paulo',35),
('TO','Tocantins',17);

INSERT IGNORE INTO cities (id,uf,name) VALUES
(5200050,'GO','Abadia de Goiás'),
(3100104,'MG','Abadia dos Dourados'),
(5200100,'GO','Abadiânia'),
(3100203,'MG','Abaeté'),
(1500107,'PA','Abaetetuba'),
(2300101,'CE','Abaiara'),
(2900108,'BA','Abaíra'),
(2900207,'BA','Abaré'),
(4100103,'PR','Abatiá'),
(4200051,'SC','Abdon Batista'),
(1500131,'PA','Abel Figueiredo'),
(4200101,'SC','Abelardo Luz'),
(3100302,'MG','Abre Campo'),
(2600054,'PE','Abreu e Lima'),
(1700251,'TO','Abreulândia'),
(3100401,'MG','Acaiaca'),
(2100055,'MA','Açailândia'),
(2900306,'BA','Acajutiba'),
(1500206,'PA','Acará'),
(2300150,'CE','Acarape'),
(2300200,'CE','Acaraú'),
(2400109,'RN','Acari'),
(2200053,'PI','Acauã'),
(4300034,'RS','Aceguá'),
(2300309,'CE','Acopiara'),
(5100102,'MT','Acorizal'),
(1200013,'AC','Acrelândia'),
(5200134,'GO','Acreúna'),
(3100500,'MG','Açucena'),
(3500105,'SP','Adamantina'),
(5200159,'GO','Adelândia'),
(3500204,'SP','Adolfo'),
(4100202,'PR','Adrianópolis'),
(2900355,'BA','Adustina'),
(2600104,'PE','Afogados da Ingazeira'),
(2400307,'RN','Afonso Bezerra'),
(3200102,'ES','Afonso Cláudio'),
(2100105,'MA','Afonso Cunha'),
(2600203,'PE','Afrânio'),
(1500305,'PA','Afuá'),
(2600302,'PE','Agrestina'),
(2200103,'PI','Agricolândia'),
(4200200,'SC','Agrolândia'),
(4200309,'SC','Agronômica'),
(1500347,'PA','Água Azul do Norte'),
(3100609,'MG','Água Boa'),
(5100201,'MT','Água Boa'),
(2700102,'AL','Água Branca'),
(2200202,'PI','Água Branca'),
(2500106,'PB','Água Branca'),
(5000203,'MS','Água Clara'),
(3100708,'MG','Água Comprida'),
(4200408,'SC','Água Doce'),
(2100154,'MA','Água Doce do Maranhão'),
(3200169,'ES','Água Doce do Norte'),
(2900405,'BA','Água Fria'),
(5200175,'GO','Água Fria de Goiás'),
(5200209,'GO','Água Limpa'),
(2400406,'RN','Água Nova'),
(2600401,'PE','Água Preta'),
(4300059,'RS','Água Santa'),
(3500303,'SP','Aguaí'),
(3100807,'MG','Aguanil'),
(2600500,'PE','Águas Belas'),
(3500402,'SP','Águas da Prata'),
(4200507,'SC','Águas de Chapecó'),
(3500501,'SP','Águas de Lindóia'),
(3500550,'SP','Águas de Santa Bárbara'),
(3500600,'SP','Águas de São Pedro'),
(3100906,'MG','Águas Formosas'),
(4200556,'SC','Águas Frias'),
(5200258,'GO','Águas Lindas de Goiás'),
(4200606,'SC','Águas Mornas'),
(3101003,'MG','Águas Vermelhas'),
(4300109,'RS','Agudo'),
(3500709,'SP','Agudos'),
(4100301,'PR','Agudos do Sul'),
(3200136,'ES','Águia Branca'),
(2500205,'PB','Aguiar'),
(1700301,'TO','Aguiarnópolis'),
(3101102,'MG','Aimorés'),
(2900603,'BA','Aiquara'),
(2300408,'CE','Aiuaba'),
(3101201,'MG','Aiuruoca'),
(4300208,'RS','Ajuricaba'),
(3101300,'MG','Alagoa'),
(2500304,'PB','Alagoa Grande'),
(2500403,'PB','Alagoa Nova'),
(2500502,'PB','Alagoinha'),
(2600609,'PE','Alagoinha'),
(2200251,'PI','Alagoinha do Piauí'),
(2900702,'BA','Alagoinhas'),
(3500758,'SP','Alambari'),
(3101409,'MG','Albertina'),
(2100204,'MA','Alcântara'),
(2300507,'CE','Alcântaras'),
(2500536,'PB','Alcantil'),
(5000252,'MS','Alcinópolis'),
(2900801,'BA','Alcobaça'),
(2100303,'MA','Aldeias Altas'),
(4300307,'RS','Alecrim'),
(3200201,'ES','Alegre'),
(4300406,'RS','Alegrete'),
(2200277,'PI','Alegrete do Piauí'),
(4300455,'RS','Alegria'),
(3101508,'MG','Além Paraíba'),
(1500404,'PA','Alenquer'),
(2400505,'RN','Alexandria'),
(5200308,'GO','Alexânia'),
(3101607,'MG','Alfenas'),
(3200300,'ES','Alfredo Chaves'),
(3500808,'SP','Alfredo Marcondes'),
(3101631,'MG','Alfredo Vasconcelos'),
(4200705,'SC','Alfredo Wagner'),
(2500577,'PB','Algodão de Jandaíra'),
(2500601,'PB','Alhandra'),
(2600708,'PE','Aliança'),
(1700350,'TO','Aliança do Tocantins'),
(2900900,'BA','Almadina'),
(1700400,'TO','Almas'),
(1500503,'PA','Almeirim'),
(3101706,'MG','Almenara'),
(2400604,'RN','Almino Afonso'),
(4100400,'PR','Almirante Tamandaré'),
(4300471,'RS','Almirante Tamandaré do Sul'),
(5200506,'GO','Aloândia'),
(3101805,'MG','Alpercata'),
(4300505,'RS','Alpestre'),
(3101904,'MG','Alpinópolis'),
(5100250,'MT','Alta Floresta'),
(1100015,'RO','Alta Floresta D''Oeste'),
(3500907,'SP','Altair'),
(1500602,'PA','Altamira'),
(2100402,'MA','Altamira do Maranhão'),
(4100459,'PR','Altamira do Paraná'),
(2300606,'CE','Altaneira'),
(3102001,'MG','Alterosa'),
(2600807,'PE','Altinho'),
(3501004,'SP','Altinópolis'),
(3501103,'SP','Alto Alegre'),
(4300554,'RS','Alto Alegre'),
(1400050,'RR','Alto Alegre'),
(2100436,'MA','Alto Alegre do Maranhão'),
(2100477,'MA','Alto Alegre do Pindaré'),
(1100379,'RO','Alto Alegre dos Parecis'),
(5100300,'MT','Alto Araguaia'),
(4200754,'SC','Alto Bela Vista'),
(5100359,'MT','Alto Boa Vista'),
(3102050,'MG','Alto Caparaó'),
(2400703,'RN','Alto do Rodrigues'),
(4300570,'RS','Alto Feliz'),
(5100409,'MT','Alto Garças'),
(5200555,'GO','Alto Horizonte'),
(3153509,'MG','Alto Jequitibá'),
(2200301,'PI','Alto Longá'),
(5100508,'MT','Alto Paraguai'),
(4128625,'PR','Alto Paraíso'),
(1100403,'RO','Alto Paraíso'),
(5200605,'GO','Alto Paraíso de Goiás'),
(4100608,'PR','Alto Paraná'),
(2100501,'MA','Alto Parnaíba'),
(4100707,'PR','Alto Piquiri'),
(3102100,'MG','Alto Rio Doce'),
(3200359,'ES','Alto Rio Novo'),
(2300705,'CE','Alto Santo'),
(5100607,'MT','Alto Taquari'),
(4100509,'PR','Altônia'),
(2200400,'PI','Altos'),
(3501152,'SP','Alumínio'),
(1300029,'AM','Alvarães'),
(3102209,'MG','Alvarenga'),
(3501202,'SP','Álvares Florence'),
(3501301,'SP','Álvares Machado'),
(3501400,'SP','Álvaro de Carvalho'),
(3501509,'SP','Alvinlândia'),
(3102308,'MG','Alvinópolis'),
(1700707,'TO','Alvorada'),
(4300604,'RS','Alvorada'),
(3102407,'MG','Alvorada de Minas'),
(2200459,'PI','Alvorada do Gurguéia'),
(5200803,'GO','Alvorada do Norte'),
(4100806,'PR','Alvorada do Sul'),
(1100346,'RO','Alvorada D''Oeste'),
(1400027,'RR','Amajari'),
(5000609,'MS','Amambai'),
(1600105,'AP','Amapá'),
(2100550,'MA','Amapá do Maranhão'),
(4100905,'PR','Amaporã'),
(2600906,'PE','Amaraji'),
(4300638,'RS','Amaral Ferrador'),
(5200829,'GO','Amaralina'),
(2200509,'PI','Amarante'),
(2100600,'MA','Amarante do Maranhão'),
(2901007,'BA','Amargosa'),
(1300060,'AM','Amaturá'),
(2901106,'BA','Amélia Rodrigues'),
(2901155,'BA','América Dourada'),
(3501608,'SP','Americana'),
(5200852,'GO','Americano do Brasil'),
(3501707,'SP','Américo Brasiliense'),
(3501806,'SP','Américo de Campos'),
(4300646,'RS','Ametista do Sul'),
(2300754,'CE','Amontada'),
(5200902,'GO','Amorinópolis'),
(3501905,'SP','Amparo'),
(2500734,'PB','Amparo'),
(2800100,'SE','Amparo do São Francisco'),
(3102506,'MG','Amparo do Serra'),
(4101002,'PR','Ampére'),
(2700201,'AL','Anadia'),
(2901205,'BA','Anagé'),
(4101051,'PR','Anahy'),
(1500701,'PA','Anajás'),
(2100709,'MA','Anajatuba'),
(3502002,'SP','Analândia'),
(1300086,'AM','Anamã'),
(1701002,'TO','Ananás'),
(1500800,'PA','Ananindeua'),
(5201108,'GO','Anápolis'),
(1500859,'PA','Anapu'),
(2100808,'MA','Anapurus'),
(5000708,'MS','Anastácio'),
(5000807,'MS','Anaurilândia'),
(4200804,'SC','Anchieta'),
(3200409,'ES','Anchieta'),
(2901304,'BA','Andaraí'),
(4101101,'PR','Andirá'),
(2901353,'BA','Andorinha'),
(3102605,'MG','Andradas'),
(3502101,'SP','Andradina'),
(4300661,'RS','André da Rocha'),
(3102803,'MG','Andrelândia'),
(3502200,'SP','Angatuba'),
(3102852,'MG','Angelândia'),
(5000856,'MS','Angélica'),
(2601003,'PE','Angelim'),
(4200903,'SC','Angelina'),
(2901403,'BA','Angical'),
(2200608,'PI','Angical do Piauí'),
(1701051,'TO','Angico'),
(2400802,'RN','Angicos'),
(3300100,'RJ','Angra dos Reis'),
(2901502,'BA','Anguera'),
(4101150,'PR','Ângulo'),
(5201207,'GO','Anhanguera'),
(3502309,'SP','Anhembi'),
(3502408,'SP','Anhumas'),
(5201306,'GO','Anicuns'),
(2200707,'PI','Anísio de Abreu'),
(4201000,'SC','Anita Garibaldi'),
(4201109,'SC','Anitápolis'),
(1300102,'AM','Anori'),
(4300703,'RS','Anta Gorda'),
(2901601,'BA','Antas'),
(4101200,'PR','Antonina'),
(2300804,'CE','Antonina do Norte'),
(2200806,'PI','Antônio Almeida'),
(2901700,'BA','Antônio Cardoso'),
(3102902,'MG','Antônio Carlos'),
(4201208,'SC','Antônio Carlos'),
(3103009,'MG','Antônio Dias'),
(2901809,'BA','Antônio Gonçalves'),
(5000906,'MS','Antônio João'),
(2400901,'RN','Antônio Martins'),
(4101309,'PR','Antônio Olinto'),
(4300802,'RS','Antônio Prado'),
(3103108,'MG','Antônio Prado de Minas'),
(2500775,'PB','Aparecida'),
(3502507,'SP','Aparecida'),
(5201405,'GO','Aparecida de Goiânia'),
(5201454,'GO','Aparecida do Rio Doce'),
(1701101,'TO','Aparecida do Rio Negro'),
(5001003,'MS','Aparecida do Taboado'),
(3502606,'SP','Aparecida d''Oeste'),
(3300159,'RJ','Aperibé'),
(3200508,'ES','Apiacá'),
(5100805,'MT','Apiacás'),
(3502705,'SP','Apiaí'),
(2100832,'MA','Apicum-Açu'),
(4201257,'SC','Apiúna'),
(2401008,'RN','Apodi'),
(2901908,'BA','Aporá'),
(5201504,'GO','Aporé'),
(2901957,'BA','Apuarema'),
(4101408,'PR','Apucarana'),
(1300144,'AM','Apuí'),
(2300903,'CE','Apuiarés'),
(2800209,'SE','Aquidabã'),
(5001102,'MS','Aquidauana'),
(2301000,'CE','Aquiraz'),
(4201273,'SC','Arabutã'),
(2500809,'PB','Araçagi'),
(3103207,'MG','Araçaí'),
(2800308,'SE','Aracaju'),
(3502754,'SP','Araçariguama'),
(2902054,'BA','Araçás'),
(2301109,'CE','Aracati'),
(2902005,'BA','Aracatu'),
(3502804,'SP','Araçatuba'),
(2902104,'BA','Araci'),
(3103306,'MG','Aracitaba'),
(2301208,'CE','Aracoiaba'),
(2601052,'PE','Araçoiaba'),
(3502903,'SP','Araçoiaba da Serra'),
(3200607,'ES','Aracruz'),
(5201603,'GO','Araçu'),
(3103405,'MG','Araçuaí'),
(5201702,'GO','Aragarças'),
(5201801,'GO','Aragoiânia'),
(1701309,'TO','Aragominas'),
(1701903,'TO','Araguacema'),
(1702000,'TO','Araguaçu'),
(5101001,'MT','Araguaiana'),
(1702109,'TO','Araguaína'),
(5101209,'MT','Araguainha'),
(1702158,'TO','Araguanã'),
(2100873,'MA','Araguanã'),
(5202155,'GO','Araguapaz'),
(3103504,'MG','Araguari'),
(1702208,'TO','Araguatins'),
(2100907,'MA','Araioses'),
(5001243,'MS','Aral Moreira'),
(2902203,'BA','Aramari'),
(4300851,'RS','Arambaré'),
(2100956,'MA','Arame'),
(3503000,'SP','Aramina'),
(3503109,'SP','Arandu'),
(3103603,'MG','Arantina'),
(3503158,'SP','Arapeí'),
(2700300,'AL','Arapiraca'),
(1702307,'TO','Arapoema'),
(3103702,'MG','Araponga'),
(4101507,'PR','Arapongas'),
(3103751,'MG','Araporã'),
(4101606,'PR','Arapoti'),
(3103801,'MG','Arapuá'),
(4101655,'PR','Arapuã'),
(5101258,'MT','Araputanga'),
(4201307,'SC','Araquari'),
(2500908,'PB','Arara'),
(4201406,'SC','Araranguá'),
(3503208,'SP','Araraquara'),
(3503307,'SP','Araras'),
(2301257,'CE','Ararendá'),
(2101004,'MA','Arari'),
(4300877,'RS','Araricá'),
(2301307,'CE','Araripe'),
(2601102,'PE','Araripina'),
(3300209,'RJ','Araruama'),
(4101705,'PR','Araruna'),
(2501005,'PB','Araruna'),
(2902252,'BA','Arataca'),
(4300901,'RS','Aratiba'),
(2301406,'CE','Aratuba'),
(2902302,'BA','Aratuípe'),
(2800407,'SE','Arauá'),
(4101804,'PR','Araucária'),
(3103900,'MG','Araújos'),
(3104007,'MG','Araxá'),
(3104106,'MG','Arceburgo'),
(3503356,'SP','Arco-Íris'),
(3104205,'MG','Arcos'),
(2601201,'PE','Arcoverde'),
(3104304,'MG','Areado'),
(3300225,'RJ','Areal'),
(3503406,'SP','Arealva'),
(2501104,'PB','Areia'),
(2401107,'RN','Areia Branca'),
(2800506,'SE','Areia Branca'),
(2501153,'PB','Areia de Baraúnas'),
(2501203,'PB','Areial'),
(3503505,'SP','Areias'),
(3503604,'SP','Areiópolis'),
(5101308,'MT','Arenápolis'),
(5202353,'GO','Arenópolis'),
(2401206,'RN','Arez'),
(3104403,'MG','Argirita'),
(3104452,'MG','Aricanduva'),
(3104502,'MG','Arinos'),
(5101407,'MT','Aripuanã'),
(1100023,'RO','Ariquemes'),
(3503703,'SP','Ariranha'),
(4101853,'PR','Ariranha do Ivaí'),
(3300233,'RJ','Armação dos Búzios'),
(4201505,'SC','Armazém'),
(2301505,'CE','Arneiroz'),
(2200905,'PI','Aroazes'),
(2501302,'PB','Aroeiras'),
(2200954,'PI','Aroeiras do Itaim'),
(2201002,'PI','Arraial'),
(3300258,'RJ','Arraial do Cabo'),
(1702406,'TO','Arraias'),
(4301008,'RS','Arroio do Meio'),
(4301073,'RS','Arroio do Padre'),
(4301057,'RS','Arroio do Sal'),
(4301206,'RS','Arroio do Tigre'),
(4301107,'RS','Arroio dos Ratos'),
(4301305,'RS','Arroio Grande'),
(4201604,'SC','Arroio Trinta'),
(3503802,'SP','Artur Nogueira'),
(5202502,'GO','Aruanã'),
(3503901,'SP','Arujá'),
(4201653,'SC','Arvoredo'),
(4301404,'RS','Arvorezinha'),
(4201703,'SC','Ascurra'),
(3503950,'SP','Aspásia'),
(4101903,'PR','Assaí'),
(2301604,'CE','Assaré'),
(3504008,'SP','Assis'),
(1200054,'AC','Assis Brasil'),
(4102000,'PR','Assis Chateaubriand'),
(2400208,'RN','Assú'),
(2501351,'PB','Assunção'),
(2201051,'PI','Assunção do Piauí'),
(3104601,'MG','Astolfo Dutra'),
(4102109,'PR','Astorga'),
(4102208,'PR','Atalaia'),
(2700409,'AL','Atalaia'),
(1300201,'AM','Atalaia do Norte'),
(4201802,'SC','Atalanta'),
(3104700,'MG','Ataléia'),
(3504107,'SP','Atibaia'),
(3200706,'ES','Atílio Vivácqua'),
(1702554,'TO','Augustinópolis'),
(1500909,'PA','Augusto Corrêa'),
(3104809,'MG','Augusto de Lima'),
(4301503,'RS','Augusto Pestana'),
(4301552,'RS','Áurea'),
(2902401,'BA','Aurelino Leal'),
(3504206,'SP','Auriflama'),
(5202601,'GO','Aurilândia'),
(4201901,'SC','Aurora'),
(2301703,'CE','Aurora'),
(1500958,'PA','Aurora do Pará'),
(1702703,'TO','Aurora do Tocantins'),
(1300300,'AM','Autazes'),
(3504305,'SP','Avaí'),
(3504404,'SP','Avanhandava'),
(3504503,'SP','Avaré'),
(1501006,'PA','Aveiro'),
(2201101,'PI','Avelino Lopes'),
(5202809,'GO','Avelinópolis'),
(2101103,'MA','Axixá'),
(1702901,'TO','Axixá do Tocantins'),
(1703008,'TO','Babaçulândia'),
(2101202,'MA','Bacabal'),
(2101251,'MA','Bacabeira'),
(2101301,'MA','Bacuri'),
(2101350,'MA','Bacurituba'),
(3504602,'SP','Bady Bassitt'),
(3104908,'MG','Baependi'),
(4301602,'RS','Bagé'),
(1501105,'PA','Bagre'),
(2501401,'PB','Baía da Traição'),
(2401404,'RN','Baía Formosa'),
(2902500,'BA','Baianópolis'),
(1501204,'PA','Baião'),
(2902609,'BA','Baixa Grande'),
(2201150,'PI','Baixa Grande do Ribeiro'),
(2301802,'CE','Baixio'),
(3200805,'ES','Baixo Guandu'),
(3504701,'SP','Balbinos'),
(3105004,'MG','Baldim'),
(5203104,'GO','Baliza'),
(4201950,'SC','Balneário Arroio do Silva'),
(4202057,'SC','Balneário Barra do Sul'),
(4202008,'SC','Balneário Camboriú'),
(4202073,'SC','Balneário Gaivota'),
(4212809,'SC','Balneário Piçarras'),
(4301636,'RS','Balneário Pinhal'),
(4220000,'SC','Balneário Rincão'),
(4102307,'PR','Balsa Nova'),
(3504800,'SP','Bálsamo'),
(2101400,'MA','Balsas'),
(3105103,'MG','Bambuí'),
(2301851,'CE','Banabuiú'),
(3504909,'SP','Bananal'),
(2501500,'PB','Bananeiras'),
(3105202,'MG','Bandeira'),
(3105301,'MG','Bandeira do Sul'),
(4202081,'SC','Bandeirante'),
(5001508,'MS','Bandeirantes'),
(4102406,'PR','Bandeirantes'),
(1703057,'TO','Bandeirantes do Tocantins'),
(1501253,'PA','Bannach'),
(2902658,'BA','Banzaê'),
(4301651,'RS','Barão'),
(3505005,'SP','Barão de Antonina'),
(3105400,'MG','Barão de Cocais'),
(4301701,'RS','Barão de Cotegipe'),
(2101509,'MA','Barão de Grajaú'),
(5101605,'MT','Barão de Melgaço'),
(3105509,'MG','Barão do Monte Alto'),
(4301750,'RS','Barão do Triunfo'),
(2501534,'PB','Baraúna'),
(2401453,'RN','Baraúna'),
(3105608,'MG','Barbacena'),
(2301901,'CE','Barbalha'),
(3505104,'SP','Barbosa'),
(4102505,'PR','Barbosa Ferraz');
INSERT IGNORE INTO cities (id,uf,name) VALUES
(1501303,'PA','Barcarena'),
(2401503,'RN','Barcelona'),
(1300409,'AM','Barcelos'),
(3505203,'SP','Bariri'),
(2902708,'BA','Barra'),
(3505302,'SP','Barra Bonita'),
(4202099,'SC','Barra Bonita'),
(2902807,'BA','Barra da Estiva'),
(2201176,'PI','Barra D''Alcântara'),
(2601300,'PE','Barra de Guabiraba'),
(2501609,'PB','Barra de Santa Rosa'),
(2501575,'PB','Barra de Santana'),
(2700508,'AL','Barra de Santo Antônio'),
(3200904,'ES','Barra de São Francisco'),
(2700607,'AL','Barra de São Miguel'),
(2501708,'PB','Barra de São Miguel'),
(5101704,'MT','Barra do Bugres'),
(3505351,'SP','Barra do Chapéu'),
(2902906,'BA','Barra do Choça'),
(2101608,'MA','Barra do Corda'),
(5101803,'MT','Barra do Garças'),
(4301859,'RS','Barra do Guarita'),
(4102703,'PR','Barra do Jacaré'),
(2903003,'BA','Barra do Mendes'),
(1703073,'TO','Barra do Ouro'),
(3300308,'RJ','Barra do Piraí'),
(4301875,'RS','Barra do Quaraí'),
(4301909,'RS','Barra do Ribeiro'),
(4301925,'RS','Barra do Rio Azul'),
(2903102,'BA','Barra do Rocha'),
(3505401,'SP','Barra do Turvo'),
(2800605,'SE','Barra dos Coqueiros'),
(4301958,'RS','Barra Funda'),
(3105707,'MG','Barra Longa'),
(3300407,'RJ','Barra Mansa'),
(4202107,'SC','Barra Velha'),
(4301800,'RS','Barracão'),
(4102604,'PR','Barracão'),
(2201200,'PI','Barras'),
(2301950,'CE','Barreira'),
(2903201,'BA','Barreiras'),
(2201309,'PI','Barreiras do Piauí'),
(1300508,'AM','Barreirinha'),
(2101707,'MA','Barreirinhas'),
(2601409,'PE','Barreiros'),
(3505500,'SP','Barretos'),
(3505609,'SP','Barrinha'),
(2302008,'CE','Barro'),
(2903235,'BA','Barro Alto'),
(5203203,'GO','Barro Alto'),
(2201408,'PI','Barro Duro'),
(2903300,'BA','Barro Preto'),
(2903276,'BA','Barrocas'),
(1703107,'TO','Barrolândia'),
(2302057,'CE','Barroquinha'),
(4302006,'RS','Barros Cassal'),
(3105905,'MG','Barroso'),
(3505708,'SP','Barueri'),
(3505807,'SP','Bastos'),
(5001904,'MS','Bataguassu'),
(2700706,'AL','Batalha'),
(2201507,'PI','Batalha'),
(3505906,'SP','Batatais'),
(5002001,'MS','Batayporã'),
(2302107,'CE','Baturité'),
(3506003,'SP','Bauru'),
(2501807,'PB','Bayeux'),
(3506102,'SP','Bebedouro'),
(2302206,'CE','Beberibe'),
(2302305,'CE','Bela Cruz'),
(5002100,'MS','Bela Vista'),
(4102752,'PR','Bela Vista da Caroba'),
(5203302,'GO','Bela Vista de Goiás'),
(3106002,'MG','Bela Vista de Minas'),
(2101772,'MA','Bela Vista do Maranhão'),
(4102802,'PR','Bela Vista do Paraíso'),
(2201556,'PI','Bela Vista do Piauí'),
(4202131,'SC','Bela Vista do Toldo'),
(2101731,'MA','Belágua'),
(1501402,'PA','Belém'),
(2501906,'PB','Belém'),
(2700805,'AL','Belém'),
(2601508,'PE','Belém de Maria'),
(2502003,'PB','Belém do Brejo do Cruz'),
(2201572,'PI','Belém do Piauí'),
(2601607,'PE','Belém do São Francisco'),
(3300456,'RJ','Belford Roxo'),
(3106101,'MG','Belmiro Braga'),
(2903409,'BA','Belmonte'),
(4202156,'SC','Belmonte'),
(2903508,'BA','Belo Campo'),
(3106200,'MG','Belo Horizonte'),
(2601706,'PE','Belo Jardim'),
(2700904,'AL','Belo Monte'),
(3106309,'MG','Belo Oriente'),
(3106408,'MG','Belo Vale'),
(1501451,'PA','Belterra'),
(2201606,'PI','Beneditinos'),
(2101806,'MA','Benedito Leite'),
(4202206,'SC','Benedito Novo'),
(1501501,'PA','Benevides'),
(1300607,'AM','Benjamin Constant'),
(4302055,'RS','Benjamin Constant do Sul'),
(3506201,'SP','Bento de Abreu'),
(2401602,'RN','Bento Fernandes'),
(4302105,'RS','Bento Gonçalves'),
(2101905,'MA','Bequimão'),
(3106507,'MG','Berilo'),
(3106655,'MG','Berizal'),
(2502052,'PB','Bernardino Batista'),
(3506300,'SP','Bernardino de Campos'),
(2101939,'MA','Bernardo do Mearim'),
(1703206,'TO','Bernardo Sayão'),
(3506359,'SP','Bertioga'),
(2201705,'PI','Bertolínia'),
(3106606,'MG','Bertópolis'),
(1300631,'AM','Beruri'),
(2601805,'PE','Betânia'),
(2201739,'PI','Betânia do Piauí'),
(3106705,'MG','Betim'),
(2601904,'PE','Bezerros'),
(3106804,'MG','Bias Fortes'),
(3106903,'MG','Bicas'),
(4202305,'SC','Biguaçu'),
(3506409,'SP','Bilac'),
(3107000,'MG','Biquinhas'),
(3506508,'SP','Birigui'),
(3506607,'SP','Biritiba Mirim'),
(2903607,'BA','Biritinga'),
(4102901,'PR','Bituruna'),
(4202404,'SC','Blumenau'),
(4103008,'PR','Boa Esperança'),
(3201001,'ES','Boa Esperança'),
(3107109,'MG','Boa Esperança'),
(4103024,'PR','Boa Esperança do Iguaçu'),
(5101837,'MT','Boa Esperança do Norte'),
(3506706,'SP','Boa Esperança do Sul'),
(2201770,'PI','Boa Hora'),
(2903706,'BA','Boa Nova'),
(2502102,'PB','Boa Ventura'),
(4103040,'PR','Boa Ventura de São Roque'),
(2302404,'CE','Boa Viagem'),
(2502151,'PB','Boa Vista'),
(1400100,'RR','Boa Vista'),
(4103057,'PR','Boa Vista da Aparecida'),
(4302154,'RS','Boa Vista das Missões'),
(4302204,'RS','Boa Vista do Buricá'),
(4302220,'RS','Boa Vista do Cadeado'),
(2101970,'MA','Boa Vista do Gurupi'),
(4302238,'RS','Boa Vista do Incra'),
(1300680,'AM','Boa Vista do Ramos'),
(4302253,'RS','Boa Vista do Sul'),
(2903805,'BA','Boa Vista do Tupim'),
(2701001,'AL','Boca da Mata'),
(1300706,'AM','Boca do Acre'),
(2201804,'PI','Bocaina'),
(3506805,'SP','Bocaina'),
(3107208,'MG','Bocaina de Minas'),
(4202438,'SC','Bocaina do Sul'),
(3107307,'MG','Bocaiúva'),
(4103107,'PR','Bocaiúva do Sul'),
(2401651,'RN','Bodó'),
(2602001,'PE','Bodocó'),
(5002159,'MS','Bodoquena'),
(3506904,'SP','Bofete'),
(3507001,'SP','Boituva'),
(2602100,'PE','Bom Conselho'),
(3107406,'MG','Bom Despacho'),
(2602209,'PE','Bom Jardim'),
(2102002,'MA','Bom Jardim'),
(3300506,'RJ','Bom Jardim'),
(4202503,'SC','Bom Jardim da Serra'),
(5203401,'GO','Bom Jardim de Goiás'),
(3107505,'MG','Bom Jardim de Minas'),
(2201903,'PI','Bom Jesus'),
(2401701,'RN','Bom Jesus'),
(2502201,'PB','Bom Jesus'),
(4202537,'SC','Bom Jesus'),
(4302303,'RS','Bom Jesus'),
(2903904,'BA','Bom Jesus da Lapa'),
(3107604,'MG','Bom Jesus da Penha'),
(2903953,'BA','Bom Jesus da Serra'),
(2102036,'MA','Bom Jesus das Selvas'),
(5203500,'GO','Bom Jesus de Goiás'),
(3107703,'MG','Bom Jesus do Amparo'),
(5101852,'MT','Bom Jesus do Araguaia'),
(3107802,'MG','Bom Jesus do Galho'),
(3300605,'RJ','Bom Jesus do Itabapoana'),
(3201100,'ES','Bom Jesus do Norte'),
(4202578,'SC','Bom Jesus do Oeste'),
(4103156,'PR','Bom Jesus do Sul'),
(1703305,'TO','Bom Jesus do Tocantins'),
(1501576,'PA','Bom Jesus do Tocantins'),
(3507100,'SP','Bom Jesus dos Perdões'),
(2102077,'MA','Bom Lugar'),
(4302352,'RS','Bom Princípio'),
(2201919,'PI','Bom Princípio do Piauí'),
(4302378,'RS','Bom Progresso'),
(3107901,'MG','Bom Repouso'),
(4202602,'SC','Bom Retiro'),
(4302402,'RS','Bom Retiro do Sul'),
(4103206,'PR','Bom Sucesso'),
(3108008,'MG','Bom Sucesso'),
(2502300,'PB','Bom Sucesso'),
(3507159,'SP','Bom Sucesso de Itararé'),
(4103222,'PR','Bom Sucesso do Sul'),
(4202453,'SC','Bombinhas'),
(1400159,'RR','Bonfim'),
(3108107,'MG','Bonfim'),
(2201929,'PI','Bonfim do Piauí'),
(5203559,'GO','Bonfinópolis'),
(3108206,'MG','Bonfinópolis de Minas'),
(2904001,'BA','Boninal'),
(2904050,'BA','Bonito'),
(2602308,'PE','Bonito'),
(1501600,'PA','Bonito'),
(5002209,'MS','Bonito'),
(3108255,'MG','Bonito de Minas'),
(2502409,'PB','Bonito de Santa Fé'),
(5203575,'GO','Bonópolis'),
(2502508,'PB','Boqueirão'),
(4302451,'RS','Boqueirão do Leão'),
(2201945,'PI','Boqueirão do Piauí'),
(2800670,'SE','Boquim'),
(2904100,'BA','Boquira'),
(3507209,'SP','Borá'),
(3507308,'SP','Boracéia'),
(1300805,'AM','Borba'),
(2502706,'PB','Borborema'),
(3507407,'SP','Borborema'),
(3108305,'MG','Borda da Mata'),
(3507456,'SP','Borebi'),
(4103305,'PR','Borrazópolis'),
(4302501,'RS','Bossoroca'),
(3108404,'MG','Botelhos'),
(3507506,'SP','Botucatu'),
(3108503,'MG','Botumirim'),
(2904209,'BA','Botuporã'),
(4202701,'SC','Botuverá'),
(4302584,'RS','Bozano'),
(4202800,'SC','Braço do Norte'),
(4202859,'SC','Braço do Trombudo'),
(4302600,'RS','Braga'),
(1501709,'PA','Bragança'),
(3507605,'SP','Bragança Paulista'),
(4103354,'PR','Braganey'),
(2701100,'AL','Branquinha'),
(3108701,'MG','Brás Pires'),
(1501725,'PA','Brasil Novo'),
(5002308,'MS','Brasilândia'),
(3108552,'MG','Brasilândia de Minas'),
(4103370,'PR','Brasilândia do Sul'),
(1703602,'TO','Brasilândia do Tocantins'),
(1200104,'AC','Brasiléia'),
(2201960,'PI','Brasileira'),
(5300108,'DF','Brasília'),
(3108602,'MG','Brasília de Minas'),
(5101902,'MT','Brasnorte'),
(3507704,'SP','Braúna'),
(3108800,'MG','Braúnas'),
(5203609,'GO','Brazabrantes'),
(3108909,'MG','Brazópolis'),
(2602407,'PE','Brejão'),
(3201159,'ES','Brejetuba'),
(2602506,'PE','Brejinho'),
(2401800,'RN','Brejinho'),
(1703701,'TO','Brejinho de Nazaré'),
(2102101,'MA','Brejo'),
(3507753,'SP','Brejo Alegre'),
(2602605,'PE','Brejo da Madre de Deus'),
(2102150,'MA','Brejo de Areia'),
(2502805,'PB','Brejo do Cruz'),
(2201988,'PI','Brejo do Piauí'),
(2502904,'PB','Brejo dos Santos'),
(2800704,'SE','Brejo Grande'),
(1501758,'PA','Brejo Grande do Araguaia'),
(2302503,'CE','Brejo Santo'),
(2904308,'BA','Brejões'),
(2904407,'BA','Brejolândia'),
(1501782,'PA','Breu Branco'),
(1501808,'PA','Breves'),
(5203807,'GO','Britânia'),
(4302659,'RS','Brochier'),
(3507803,'SP','Brodowski'),
(3507902,'SP','Brotas'),
(2904506,'BA','Brotas de Macaúbas'),
(3109006,'MG','Brumadinho'),
(2904605,'BA','Brumado'),
(4202875,'SC','Brunópolis'),
(4202909,'SC','Brusque'),
(3109105,'MG','Bueno Brandão'),
(3109204,'MG','Buenópolis'),
(2602704,'PE','Buenos Aires'),
(2904704,'BA','Buerarema'),
(3109253,'MG','Bugre'),
(2602803,'PE','Buíque'),
(1200138,'AC','Bujari'),
(1501907,'PA','Bujaru'),
(3508009,'SP','Buri'),
(3508108,'SP','Buritama'),
(2102200,'MA','Buriti'),
(5203906,'GO','Buriti Alegre'),
(2102309,'MA','Buriti Bravo'),
(5203939,'GO','Buriti de Goiás'),
(1703800,'TO','Buriti do Tocantins'),
(2202000,'PI','Buriti dos Lopes'),
(2202026,'PI','Buriti dos Montes'),
(2102325,'MA','Buriticupu'),
(5203962,'GO','Buritinópolis'),
(2904753,'BA','Buritirama'),
(2102358,'MA','Buritirana'),
(1100452,'RO','Buritis'),
(3109303,'MG','Buritis'),
(3508207,'SP','Buritizal'),
(3109402,'MG','Buritizeiro'),
(4302709,'RS','Butiá'),
(1300839,'AM','Caapiranga'),
(2503001,'PB','Caaporã'),
(5002407,'MS','Caarapó'),
(2904803,'BA','Caatiba'),
(2503100,'PB','Cabaceiras'),
(2904852,'BA','Cabaceiras do Paraguaçu'),
(3109451,'MG','Cabeceira Grande'),
(5204003,'GO','Cabeceiras'),
(2202059,'PI','Cabeceiras do Piauí'),
(2503209,'PB','Cabedelo'),
(1100031,'RO','Cabixi'),
(2602902,'PE','Cabo de Santo Agostinho'),
(3300704,'RJ','Cabo Frio'),
(3109501,'MG','Cabo Verde'),
(3508306,'SP','Cabrália Paulista'),
(3508405,'SP','Cabreúva'),
(2603009,'PE','Cabrobó'),
(4203006,'SC','Caçador'),
(3508504,'SP','Caçapava'),
(4302808,'RS','Caçapava do Sul'),
(1100601,'RO','Cacaulândia'),
(4302907,'RS','Cacequi'),
(5102504,'MT','Cáceres'),
(2904902,'BA','Cachoeira'),
(5204102,'GO','Cachoeira Alta'),
(3109600,'MG','Cachoeira da Prata'),
(5204201,'GO','Cachoeira de Goiás'),
(3109709,'MG','Cachoeira de Minas'),
(3102704,'MG','Cachoeira de Pajeú'),
(1502004,'PA','Cachoeira do Arari'),
(1501956,'PA','Cachoeira do Piriá'),
(4303004,'RS','Cachoeira do Sul'),
(2503308,'PB','Cachoeira dos Índios'),
(3109808,'MG','Cachoeira Dourada'),
(5204250,'GO','Cachoeira Dourada'),
(2102374,'MA','Cachoeira Grande'),
(3508603,'SP','Cachoeira Paulista'),
(3300803,'RJ','Cachoeiras de Macacu'),
(4303103,'RS','Cachoeirinha'),
(1703826,'TO','Cachoeirinha'),
(2603108,'PE','Cachoeirinha'),
(3201209,'ES','Cachoeiro de Itapemirim'),
(2503407,'PB','Cacimba de Areia'),
(2503506,'PB','Cacimba de Dentro'),
(2503555,'PB','Cacimbas'),
(2701209,'AL','Cacimbinhas'),
(4303202,'RS','Cacique Doble'),
(1100049,'RO','Cacoal'),
(3508702,'SP','Caconde'),
(5204300,'GO','Caçu'),
(2905008,'BA','Caculé'),
(2905107,'BA','Caém'),
(3109907,'MG','Caetanópolis'),
(2905156,'BA','Caetanos'),
(3110004,'MG','Caeté'),
(2603207,'PE','Caetés'),
(2905206,'BA','Caetité'),
(2905305,'BA','Cafarnaum'),
(4103404,'PR','Cafeara'),
(4103453,'PR','Cafelândia'),
(3508801,'SP','Cafelândia'),
(4103479,'PR','Cafezal do Sul'),
(3508900,'SP','Caiabu'),
(3110103,'MG','Caiana'),
(5204409,'GO','Caiapônia'),
(4303301,'RS','Caibaté'),
(4203105,'SC','Caibi'),
(4303400,'RS','Caiçara'),
(2503605,'PB','Caiçara'),
(2401859,'RN','Caiçara do Norte'),
(2401909,'RN','Caiçara do Rio do Vento'),
(2402006,'RN','Caicó'),
(3509007,'SP','Caieiras'),
(2905404,'BA','Cairu'),
(3509106,'SP','Caiuá'),
(3509205,'SP','Cajamar'),
(2102408,'MA','Cajapió'),
(2102507,'MA','Cajari'),
(3509254,'SP','Cajati'),
(2503704,'PB','Cajazeiras'),
(2202075,'PI','Cajazeiras do Piauí'),
(2503753,'PB','Cajazeirinhas'),
(3509304,'SP','Cajobi'),
(2701308,'AL','Cajueiro'),
(2202083,'PI','Cajueiro da Praia'),
(3110202,'MG','Cajuri'),
(3509403,'SP','Cajuru'),
(2603306,'PE','Calçado'),
(1600204,'AP','Calçoene'),
(3110301,'MG','Caldas'),
(2503803,'PB','Caldas Brandão'),
(5204508,'GO','Caldas Novas'),
(5204557,'GO','Caldazinha'),
(2905503,'BA','Caldeirão Grande'),
(2202091,'PI','Caldeirão Grande do Piauí'),
(4103503,'PR','Califórnia'),
(4203154,'SC','Calmon'),
(2603405,'PE','Calumbi'),
(2905602,'BA','Camacan'),
(2905701,'BA','Camaçari'),
(3110400,'MG','Camacho'),
(2503902,'PB','Camalaú'),
(2905800,'BA','Camamu'),
(3110509,'MG','Camanducaia'),
(5002605,'MS','Camapuã'),
(4303509,'RS','Camaquã'),
(2603454,'PE','Camaragibe'),
(4303558,'RS','Camargo'),
(4103602,'PR','Cambará'),
(4303608,'RS','Cambará do Sul'),
(4103701,'PR','Cambé'),
(4103800,'PR','Cambira'),
(4203204,'SC','Camboriú'),
(3300902,'RJ','Cambuci'),
(3110608,'MG','Cambuí'),
(3110707,'MG','Cambuquira'),
(1502103,'PA','Cametá'),
(2302602,'CE','Camocim'),
(2603504,'PE','Camocim de São Félix'),
(3110806,'MG','Campanário'),
(3110905,'MG','Campanha'),
(3111002,'MG','Campestre'),
(2701357,'AL','Campestre'),
(4303673,'RS','Campestre da Serra'),
(5204607,'GO','Campestre de Goiás'),
(2102556,'MA','Campestre do Maranhão'),
(4103909,'PR','Campina da Lagoa'),
(4303707,'RS','Campina das Missões'),
(3509452,'SP','Campina do Monte Alegre'),
(4103958,'PR','Campina do Simão'),
(2504009,'PB','Campina Grande'),
(4104006,'PR','Campina Grande do Sul'),
(3111101,'MG','Campina Verde'),
(5204656,'GO','Campinaçu'),
(5102603,'MT','Campinápolis'),
(3509502,'SP','Campinas'),
(2202109,'PI','Campinas do Piauí'),
(4303806,'RS','Campinas do Sul'),
(5204706,'GO','Campinorte'),
(4203303,'SC','Campo Alegre'),
(2701407,'AL','Campo Alegre'),
(5204805,'GO','Campo Alegre de Goiás'),
(2905909,'BA','Campo Alegre de Lourdes'),
(2202117,'PI','Campo Alegre do Fidalgo'),
(3111150,'MG','Campo Azul'),
(3111200,'MG','Campo Belo'),
(4203402,'SC','Campo Belo do Sul'),
(4303905,'RS','Campo Bom'),
(4104055,'PR','Campo Bonito'),
(2801009,'SE','Campo do Brito'),
(3111309,'MG','Campo do Meio'),
(4104105,'PR','Campo do Tenente'),
(4203501,'SC','Campo Erê'),
(3111408,'MG','Campo Florido'),
(2906006,'BA','Campo Formoso'),
(2701506,'AL','Campo Grande'),
(2401305,'RN','Campo Grande'),
(5002704,'MS','Campo Grande'),
(2202133,'PI','Campo Grande do Piauí'),
(4104204,'PR','Campo Largo'),
(2202174,'PI','Campo Largo do Piauí'),
(5204854,'GO','Campo Limpo de Goiás'),
(3509601,'SP','Campo Limpo Paulista'),
(4104253,'PR','Campo Magro'),
(2202208,'PI','Campo Maior'),
(4104303,'PR','Campo Mourão'),
(4304002,'RS','Campo Novo'),
(1100700,'RO','Campo Novo de Rondônia'),
(5102637,'MT','Campo Novo do Parecis'),
(2402105,'RN','Campo Redondo'),
(5102678,'MT','Campo Verde'),
(3111507,'MG','Campos Altos'),
(5204904,'GO','Campos Belos'),
(4304101,'RS','Campos Borges'),
(5102686,'MT','Campos de Júlio'),
(3509700,'SP','Campos do Jordão'),
(3301009,'RJ','Campos dos Goytacazes'),
(3111606,'MG','Campos Gerais'),
(1703842,'TO','Campos Lindos'),
(4203600,'SC','Campos Novos'),
(3509809,'SP','Campos Novos Paulista'),
(2302701,'CE','Campos Sales'),
(5204953,'GO','Campos Verdes'),
(2603603,'PE','Camutanga');
INSERT IGNORE INTO cities (id,uf,name) VALUES
(3111903,'MG','Cana Verde'),
(3111705,'MG','Canaã'),
(1502152,'PA','Canaã dos Carajás'),
(5102694,'MT','Canabrava do Norte'),
(3509908,'SP','Cananéia'),
(2701605,'AL','Canapi'),
(2906105,'BA','Canápolis'),
(3111804,'MG','Canápolis'),
(2906204,'BA','Canarana'),
(5102702,'MT','Canarana'),
(3509957,'SP','Canas'),
(2202251,'PI','Canavieira'),
(2906303,'BA','Canavieiras'),
(2906402,'BA','Candeal'),
(2906501,'BA','Candeias'),
(3112000,'MG','Candeias'),
(1100809,'RO','Candeias do Jamari'),
(4304200,'RS','Candelária'),
(2906600,'BA','Candiba'),
(4104402,'PR','Cândido de Abreu'),
(4304309,'RS','Cândido Godói'),
(2102606,'MA','Cândido Mendes'),
(3510005,'SP','Cândido Mota'),
(3510104,'SP','Cândido Rodrigues'),
(2906709,'BA','Cândido Sales'),
(4304358,'RS','Candiota'),
(4104428,'PR','Candói'),
(4304408,'RS','Canela'),
(4203709,'SC','Canelinha'),
(2402204,'RN','Canguaretama'),
(4304507,'RS','Canguçu'),
(2801108,'SE','Canhoba'),
(2603702,'PE','Canhotinho'),
(2302800,'CE','Canindé'),
(2801207,'SE','Canindé de São Francisco'),
(3510153,'SP','Canitar'),
(4304606,'RS','Canoas'),
(4203808,'SC','Canoinhas'),
(2906808,'BA','Cansanção'),
(1400175,'RR','Cantá'),
(3112059,'MG','Cantagalo'),
(3301108,'RJ','Cantagalo'),
(4104451,'PR','Cantagalo'),
(2102705,'MA','Cantanhede'),
(2202307,'PI','Canto do Buriti'),
(2906824,'BA','Canudos'),
(4304614,'RS','Canudos do Vale'),
(1300904,'AM','Canutama'),
(1502202,'PA','Capanema'),
(4104501,'PR','Capanema'),
(4203253,'SC','Capão Alto'),
(3510203,'SP','Capão Bonito'),
(4304622,'RS','Capão Bonito do Sul'),
(4304630,'RS','Capão da Canoa'),
(4304655,'RS','Capão do Cipó'),
(4304663,'RS','Capão do Leão'),
(3112109,'MG','Caparaó'),
(2801306,'SE','Capela'),
(2701704,'AL','Capela'),
(4304689,'RS','Capela de Santana'),
(3510302,'SP','Capela do Alto'),
(2906857,'BA','Capela do Alto Alegre'),
(3112208,'MG','Capela Nova'),
(3112307,'MG','Capelinha'),
(3112406,'MG','Capetinga'),
(2504033,'PB','Capim'),
(3112505,'MG','Capim Branco'),
(2906873,'BA','Capim Grosso'),
(3112604,'MG','Capinópolis'),
(4203907,'SC','Capinzal'),
(2102754,'MA','Capinzal do Norte'),
(2302909,'CE','Capistrano'),
(4304697,'RS','Capitão'),
(3112653,'MG','Capitão Andrade'),
(2202406,'PI','Capitão de Campos'),
(3112703,'MG','Capitão Enéas'),
(2202455,'PI','Capitão Gervásio Oliveira'),
(4104600,'PR','Capitão Leônidas Marques'),
(1502301,'PA','Capitão Poço'),
(3112802,'MG','Capitólio'),
(3510401,'SP','Capivari'),
(4203956,'SC','Capivari de Baixo'),
(4304671,'RS','Capivari do Sul'),
(1200179,'AC','Capixaba'),
(2603801,'PE','Capoeiras'),
(3112901,'MG','Caputira'),
(4304713,'RS','Caraá'),
(1400209,'RR','Caracaraí'),
(2202505,'PI','Caracol'),
(5002803,'MS','Caracol'),
(3510500,'SP','Caraguatatuba'),
(3113008,'MG','Caraí'),
(2906899,'BA','Caraíbas'),
(4104659,'PR','Carambeí'),
(3113107,'MG','Caranaíba'),
(3113206,'MG','Carandaí'),
(3113305,'MG','Carangola'),
(3300936,'RJ','Carapebus'),
(3510609,'SP','Carapicuíba'),
(3113404,'MG','Caratinga'),
(1301001,'AM','Carauari'),
(2504074,'PB','Caraúbas'),
(2402303,'RN','Caraúbas'),
(2202539,'PI','Caraúbas do Piauí'),
(2906907,'BA','Caravelas'),
(4304705,'RS','Carazinho'),
(3113503,'MG','Carbonita'),
(2907004,'BA','Cardeal da Silva'),
(3510708,'SP','Cardoso'),
(3301157,'RJ','Cardoso Moreira'),
(3113602,'MG','Careaçu'),
(1301100,'AM','Careiro'),
(1301159,'AM','Careiro da Várzea'),
(3201308,'ES','Cariacica'),
(2303006,'CE','Caridade'),
(2202554,'PI','Caridade do Piauí'),
(2907103,'BA','Carinhanha'),
(2801405,'SE','Carira'),
(2303105,'CE','Cariré'),
(1703867,'TO','Cariri do Tocantins'),
(2303204,'CE','Caririaçu'),
(2303303,'CE','Cariús'),
(5102793,'MT','Carlinda'),
(4104709,'PR','Carlópolis'),
(4304804,'RS','Carlos Barbosa'),
(3113701,'MG','Carlos Chagas'),
(4304853,'RS','Carlos Gomes'),
(3113800,'MG','Carmésia'),
(3301207,'RJ','Carmo'),
(3113909,'MG','Carmo da Cachoeira'),
(3114006,'MG','Carmo da Mata'),
(3114105,'MG','Carmo de Minas'),
(3114204,'MG','Carmo do Cajuru'),
(3114303,'MG','Carmo do Paranaíba'),
(3114402,'MG','Carmo do Rio Claro'),
(5205000,'GO','Carmo do Rio Verde'),
(1703883,'TO','Carmolândia'),
(2801504,'SE','Carmópolis'),
(3114501,'MG','Carmópolis de Minas'),
(2603900,'PE','Carnaíba'),
(2402402,'RN','Carnaúba dos Dantas'),
(2402501,'RN','Carnaubais'),
(2303402,'CE','Carnaubal'),
(2603926,'PE','Carnaubeira da Penha'),
(3114550,'MG','Carneirinho'),
(2701803,'AL','Carneiros'),
(1400233,'RR','Caroebe'),
(2102804,'MA','Carolina'),
(2604007,'PE','Carpina'),
(3114600,'MG','Carrancas'),
(2504108,'PB','Carrapateira'),
(1703891,'TO','Carrasco Bonito'),
(2604106,'PE','Caruaru'),
(2102903,'MA','Carutapera'),
(3114709,'MG','Carvalhópolis'),
(3114808,'MG','Carvalhos'),
(3510807,'SP','Casa Branca'),
(3114907,'MG','Casa Grande'),
(2907202,'BA','Casa Nova'),
(4304903,'RS','Casca'),
(3115003,'MG','Cascalho Rico'),
(2303501,'CE','Cascavel'),
(4104808,'PR','Cascavel'),
(1703909,'TO','Caseara'),
(4304952,'RS','Caseiros'),
(3301306,'RJ','Casimiro de Abreu'),
(2604155,'PE','Casinhas'),
(2504157,'PB','Casserengue'),
(3115102,'MG','Cássia'),
(3510906,'SP','Cássia dos Coqueiros'),
(5002902,'MS','Cassilândia'),
(1502400,'PA','Castanhal'),
(5102850,'MT','Castanheira'),
(1100908,'RO','Castanheiras'),
(5205059,'GO','Castelândia'),
(3201407,'ES','Castelo'),
(2202604,'PI','Castelo do Piauí'),
(3511003,'SP','Castilho'),
(4104907,'PR','Castro'),
(2907301,'BA','Castro Alves'),
(3115300,'MG','Cataguases'),
(5205109,'GO','Catalão'),
(3511102,'SP','Catanduva'),
(4105003,'PR','Catanduvas'),
(4204004,'SC','Catanduvas'),
(2303600,'CE','Catarina'),
(3115359,'MG','Catas Altas'),
(3115409,'MG','Catas Altas da Noruega'),
(2604205,'PE','Catende'),
(3511201,'SP','Catiguá'),
(2504207,'PB','Catingueira'),
(2907400,'BA','Catolândia'),
(2504306,'PB','Catolé do Rocha'),
(2907509,'BA','Catu'),
(4305009,'RS','Catuípe'),
(3115458,'MG','Catuji'),
(2303659,'CE','Catunda'),
(5205208,'GO','Caturaí'),
(2907558,'BA','Caturama'),
(2504355,'PB','Caturité'),
(3115474,'MG','Catuti'),
(2303709,'CE','Caucaia'),
(5205307,'GO','Cavalcante'),
(3115508,'MG','Caxambu'),
(4204103,'SC','Caxambu do Sul'),
(2103000,'MA','Caxias'),
(4305108,'RS','Caxias do Sul'),
(2202653,'PI','Caxingó'),
(2402600,'RN','Ceará-Mirim'),
(2103109,'MA','Cedral'),
(3511300,'SP','Cedral'),
(2303808,'CE','Cedro'),
(2604304,'PE','Cedro'),
(2801603,'SE','Cedro de São João'),
(3115607,'MG','Cedro do Abaeté'),
(4204152,'SC','Celso Ramos'),
(4305116,'RS','Centenário'),
(1704105,'TO','Centenário'),
(4105102,'PR','Centenário do Sul'),
(2907608,'BA','Central'),
(3115706,'MG','Central de Minas'),
(2103125,'MA','Central do Maranhão'),
(3115805,'MG','Centralina'),
(2103158,'MA','Centro do Guilherme'),
(2103174,'MA','Centro Novo do Maranhão'),
(1100056,'RO','Cerejeiras'),
(5205406,'GO','Ceres'),
(3511409,'SP','Cerqueira César'),
(3511508,'SP','Cerquilho'),
(4305124,'RS','Cerrito'),
(4105201,'PR','Cerro Azul'),
(4305132,'RS','Cerro Branco'),
(2402709,'RN','Cerro Corá'),
(4305157,'RS','Cerro Grande'),
(4305173,'RS','Cerro Grande do Sul'),
(4305207,'RS','Cerro Largo'),
(4204178,'SC','Cerro Negro'),
(3511607,'SP','Cesário Lange'),
(4105300,'PR','Céu Azul'),
(5205455,'GO','Cezarina'),
(2604403,'PE','Chã de Alegria'),
(2604502,'PE','Chã Grande'),
(2701902,'AL','Chã Preta'),
(3115904,'MG','Chácara'),
(3116001,'MG','Chalé'),
(4305306,'RS','Chapada'),
(1705102,'TO','Chapada da Natividade'),
(1704600,'TO','Chapada de Areia'),
(3116100,'MG','Chapada do Norte'),
(5103007,'MT','Chapada dos Guimarães'),
(3116159,'MG','Chapada Gaúcha'),
(5205471,'GO','Chapadão do Céu'),
(4204194,'SC','Chapadão do Lageado'),
(5002951,'MS','Chapadão do Sul'),
(2103208,'MA','Chapadinha'),
(4204202,'SC','Chapecó'),
(3511706,'SP','Charqueada'),
(4305355,'RS','Charqueadas'),
(4305371,'RS','Charrua'),
(2303907,'CE','Chaval'),
(3557204,'SP','Chavantes'),
(1502509,'PA','Chaves'),
(3116209,'MG','Chiador'),
(4305405,'RS','Chiapetta'),
(4105409,'PR','Chopinzinho'),
(2303931,'CE','Choró'),
(2303956,'CE','Chorozinho'),
(2907707,'BA','Chorrochó'),
(4305439,'RS','Chuí'),
(1100924,'RO','Chupinguaia'),
(4305447,'RS','Chuvisca'),
(4105508,'PR','Cianorte'),
(2907806,'BA','Cícero Dantas'),
(4105607,'PR','Cidade Gaúcha'),
(5205497,'GO','Cidade Ocidental'),
(2103257,'MA','Cidelândia'),
(4305454,'RS','Cidreira'),
(2907905,'BA','Cipó'),
(3116308,'MG','Cipotânea'),
(4305504,'RS','Ciríaco'),
(3116407,'MG','Claraval'),
(3116506,'MG','Claro dos Poções'),
(5103056,'MT','Cláudia'),
(3116605,'MG','Cláudio'),
(3511904,'SP','Clementina'),
(4105706,'PR','Clevelândia'),
(2908002,'BA','Coaraci'),
(1301209,'AM','Coari'),
(2202703,'PI','Cocal'),
(2202711,'PI','Cocal de Telha'),
(4204251,'SC','Cocal do Sul'),
(2202729,'PI','Cocal dos Alves'),
(5103106,'MT','Cocalinho'),
(5205513,'GO','Cocalzinho de Goiás'),
(2908101,'BA','Cocos'),
(1301308,'AM','Codajás'),
(2103307,'MA','Codó'),
(2103406,'MA','Coelho Neto'),
(3116704,'MG','Coimbra'),
(2702009,'AL','Coité do Nóia'),
(2202737,'PI','Coivaras'),
(1502608,'PA','Colares'),
(3201506,'ES','Colatina'),
(5103205,'MT','Colíder'),
(3512001,'SP','Colina'),
(4305587,'RS','Colinas'),
(2103505,'MA','Colinas'),
(5205521,'GO','Colinas do Sul'),
(1705508,'TO','Colinas do Tocantins'),
(1716703,'TO','Colméia'),
(5103254,'MT','Colniza'),
(3512100,'SP','Colômbia'),
(4105805,'PR','Colombo'),
(2202752,'PI','Colônia do Gurguéia'),
(2202778,'PI','Colônia do Piauí'),
(2702108,'AL','Colônia Leopoldina'),
(4105904,'PR','Colorado'),
(4305603,'RS','Colorado'),
(1100064,'RO','Colorado do Oeste'),
(3116803,'MG','Coluna'),
(1705557,'TO','Combinado'),
(3116902,'MG','Comendador Gomes'),
(3300951,'RJ','Comendador Levy Gasparian'),
(3117009,'MG','Comercinho'),
(5103304,'MT','Comodoro'),
(2504405,'PB','Conceição'),
(3117108,'MG','Conceição da Aparecida'),
(3201605,'ES','Conceição da Barra'),
(3115201,'MG','Conceição da Barra de Minas'),
(2908200,'BA','Conceição da Feira'),
(3117306,'MG','Conceição das Alagoas'),
(3117207,'MG','Conceição das Pedras'),
(3117405,'MG','Conceição de Ipanema'),
(3301405,'RJ','Conceição de Macabu'),
(2908309,'BA','Conceição do Almeida'),
(1502707,'PA','Conceição do Araguaia'),
(2202802,'PI','Conceição do Canindé'),
(3201704,'ES','Conceição do Castelo'),
(2908408,'BA','Conceição do Coité'),
(2908507,'BA','Conceição do Jacuípe'),
(2103554,'MA','Conceição do Lago-Açu'),
(3117504,'MG','Conceição do Mato Dentro'),
(3117603,'MG','Conceição do Pará'),
(3117702,'MG','Conceição do Rio Verde'),
(1705607,'TO','Conceição do Tocantins'),
(3117801,'MG','Conceição dos Ouros'),
(3512209,'SP','Conchal'),
(3512308,'SP','Conchas'),
(4204301,'SC','Concórdia'),
(1502756,'PA','Concórdia do Pará'),
(2504504,'PB','Condado'),
(2604601,'PE','Condado'),
(2908606,'BA','Conde'),
(2504603,'PB','Conde'),
(2908705,'BA','Condeúba'),
(4305702,'RS','Condor'),
(3117836,'MG','Cônego Marinho'),
(3117876,'MG','Confins'),
(5103353,'MT','Confresa'),
(2504702,'PB','Congo'),
(3117900,'MG','Congonhal'),
(3118007,'MG','Congonhas'),
(3118106,'MG','Congonhas do Norte'),
(4106001,'PR','Congonhinhas'),
(3118205,'MG','Conquista'),
(5103361,'MT','Conquista D''Oeste'),
(3118304,'MG','Conselheiro Lafaiete'),
(4106100,'PR','Conselheiro Mairinck'),
(3118403,'MG','Conselheiro Pena'),
(3118502,'MG','Consolação'),
(4305801,'RS','Constantina'),
(3118601,'MG','Contagem'),
(4106209,'PR','Contenda'),
(2908804,'BA','Contendas do Sincorá'),
(3118700,'MG','Coqueiral'),
(4305835,'RS','Coqueiro Baixo'),
(2702207,'AL','Coqueiro Seco'),
(4305850,'RS','Coqueiros do Sul'),
(3118809,'MG','Coração de Jesus'),
(2908903,'BA','Coração de Maria'),
(4106308,'PR','Corbélia'),
(3301504,'RJ','Cordeiro'),
(3512407,'SP','Cordeirópolis'),
(2909000,'BA','Cordeiros'),
(4204350,'SC','Cordilheira Alta'),
(3118908,'MG','Cordisburgo'),
(3119005,'MG','Cordislândia'),
(2304004,'CE','Coreaú'),
(2504801,'PB','Coremas'),
(5003108,'MS','Corguinho'),
(2909109,'BA','Coribe'),
(3119104,'MG','Corinto'),
(4106407,'PR','Cornélio Procópio'),
(3119203,'MG','Coroaci'),
(3512506,'SP','Coroados'),
(2103604,'MA','Coroatá'),
(3119302,'MG','Coromandel'),
(4305871,'RS','Coronel Barros'),
(4305900,'RS','Coronel Bicaco'),
(4106456,'PR','Coronel Domingos Soares'),
(2402808,'RN','Coronel Ezequiel'),
(3119401,'MG','Coronel Fabriciano'),
(4204400,'SC','Coronel Freitas'),
(2402907,'RN','Coronel João Pessoa'),
(2909208,'BA','Coronel João Sá'),
(2202851,'PI','Coronel José Dias'),
(3512605,'SP','Coronel Macedo'),
(4204459,'SC','Coronel Martins'),
(3119500,'MG','Coronel Murta'),
(3119609,'MG','Coronel Pacheco'),
(4305934,'RS','Coronel Pilar'),
(5003157,'MS','Coronel Sapucaia'),
(4106506,'PR','Coronel Vivida'),
(3119708,'MG','Coronel Xavier Chaves'),
(3119807,'MG','Córrego Danta'),
(3119906,'MG','Córrego do Bom Jesus'),
(5205703,'GO','Córrego do Ouro'),
(3119955,'MG','Córrego Fundo'),
(3120003,'MG','Córrego Novo'),
(4204558,'SC','Correia Pinto'),
(2202901,'PI','Corrente'),
(2604700,'PE','Correntes'),
(2909307,'BA','Correntina'),
(2604809,'PE','Cortês'),
(5003207,'MS','Corumbá'),
(5205802,'GO','Corumbá de Goiás'),
(5205901,'GO','Corumbaíba'),
(3512704,'SP','Corumbataí'),
(4106555,'PR','Corumbataí do Sul'),
(1100072,'RO','Corumbiara'),
(4204509,'SC','Corupá'),
(2702306,'AL','Coruripe'),
(3512803,'SP','Cosmópolis'),
(3512902,'SP','Cosmorama'),
(1100080,'RO','Costa Marques'),
(5003256,'MS','Costa Rica'),
(2909406,'BA','Cotegipe'),
(3513009,'SP','Cotia'),
(4305959,'RS','Cotiporã'),
(5103379,'MT','Cotriguaçu'),
(3120102,'MG','Couto de Magalhães de Minas'),
(1706001,'TO','Couto Magalhães'),
(4305975,'RS','Coxilha'),
(5003306,'MS','Coxim'),
(2504850,'PB','Coxixola'),
(2702355,'AL','Craíbas'),
(2304103,'CE','Crateús'),
(2304202,'CE','Crato'),
(3513108,'SP','Cravinhos'),
(2909505,'BA','Cravolândia'),
(4204608,'SC','Criciúma'),
(3120151,'MG','Crisólita'),
(2909604,'BA','Crisópolis'),
(4306007,'RS','Crissiumal'),
(3120201,'MG','Cristais'),
(3513207,'SP','Cristais Paulista'),
(4306056,'RS','Cristal'),
(4306072,'RS','Cristal do Sul'),
(1706100,'TO','Cristalândia'),
(2203008,'PI','Cristalândia do Piauí'),
(3120300,'MG','Cristália'),
(5206206,'GO','Cristalina'),
(3120409,'MG','Cristiano Otoni'),
(5206305,'GO','Cristianópolis'),
(3120508,'MG','Cristina'),
(2801702,'SE','Cristinápolis'),
(2203107,'PI','Cristino Castro'),
(2909703,'BA','Cristópolis'),
(5206404,'GO','Crixás'),
(1706258,'TO','Crixás do Tocantins'),
(2304236,'CE','Croatá'),
(5206503,'GO','Cromínia'),
(3120607,'MG','Crucilândia'),
(2304251,'CE','Cruz'),
(4306106,'RS','Cruz Alta'),
(2909802,'BA','Cruz das Almas'),
(2504900,'PB','Cruz do Espírito Santo'),
(4106803,'PR','Cruz Machado'),
(3513306,'SP','Cruzália'),
(4306130,'RS','Cruzaltense'),
(3513405,'SP','Cruzeiro'),
(3120706,'MG','Cruzeiro da Fortaleza'),
(4106571,'PR','Cruzeiro do Iguaçu'),
(4106605,'PR','Cruzeiro do Oeste'),
(4106704,'PR','Cruzeiro do Sul'),
(4306205,'RS','Cruzeiro do Sul'),
(1200203,'AC','Cruzeiro do Sul'),
(2403004,'RN','Cruzeta'),
(3120805,'MG','Cruzília'),
(4106852,'PR','Cruzmaltina'),
(3513504,'SP','Cubatão'),
(2505006,'PB','Cubati'),
(5103403,'MT','Cuiabá'),
(2505105,'PB','Cuité'),
(2505238,'PB','Cuité de Mamanguape'),
(2505204,'PB','Cuitegi'),
(1100940,'RO','Cujubim'),
(5206602,'GO','Cumari'),
(2604908,'PE','Cumaru'),
(1502764,'PA','Cumaru do Norte');
INSERT IGNORE INTO cities (id,uf,name) VALUES
(2801900,'SE','Cumbe'),
(3513603,'SP','Cunha'),
(4204707,'SC','Cunha Porã'),
(4204756,'SC','Cunhataí'),
(3120839,'MG','Cuparaque'),
(2605004,'PE','Cupira'),
(2909901,'BA','Curaçá'),
(2203206,'PI','Curimatá'),
(1502772,'PA','Curionópolis'),
(4106902,'PR','Curitiba'),
(4204806,'SC','Curitibanos'),
(4107009,'PR','Curiúva'),
(2203230,'PI','Currais'),
(2403103,'RN','Currais Novos'),
(2505279,'PB','Curral de Cima'),
(3120870,'MG','Curral de Dentro'),
(2203271,'PI','Curral Novo do Piauí'),
(2505303,'PB','Curral Velho'),
(1502806,'PA','Curralinho'),
(2203255,'PI','Curralinhos'),
(1502855,'PA','Curuá'),
(1502905,'PA','Curuçá'),
(2103703,'MA','Cururupu'),
(5103437,'MT','Curvelândia'),
(3120904,'MG','Curvelo'),
(2605103,'PE','Custódia'),
(1600212,'AP','Cutias'),
(5206701,'GO','Damianópolis'),
(2505352,'PB','Damião'),
(5206800,'GO','Damolândia'),
(1706506,'TO','Darcinópolis'),
(2910008,'BA','Dário Meira'),
(3121001,'MG','Datas'),
(4306304,'RS','David Canabarro'),
(5206909,'GO','Davinópolis'),
(2103752,'MA','Davinópolis'),
(3121100,'MG','Delfim Moreira'),
(3121209,'MG','Delfinópolis'),
(2702405,'AL','Delmiro Gouveia'),
(3121258,'MG','Delta'),
(2203305,'PI','Demerval Lobão'),
(5103452,'MT','Denise'),
(5003454,'MS','Deodápolis'),
(2304269,'CE','Deputado Irapuan Pinheiro'),
(4306320,'RS','Derrubadas'),
(3513702,'SP','Descalvado'),
(4204905,'SC','Descanso'),
(3121308,'MG','Descoberto'),
(2505402,'PB','Desterro'),
(3121407,'MG','Desterro de Entre Rios'),
(3121506,'MG','Desterro do Melo'),
(4306353,'RS','Dezesseis de Novembro'),
(3513801,'SP','Diadema'),
(2505600,'PB','Diamante'),
(4107108,'PR','Diamante do Norte'),
(4107124,'PR','Diamante do Sul'),
(4107157,'PR','Diamante D''Oeste'),
(3121605,'MG','Diamantina'),
(5103502,'MT','Diamantino'),
(1707009,'TO','Dianópolis'),
(2910057,'BA','Dias d''Ávila'),
(4306379,'RS','Dilermando de Aguiar'),
(3121704,'MG','Diogo de Vasconcelos'),
(3121803,'MG','Dionísio'),
(4205001,'SC','Dionísio Cerqueira'),
(5207105,'GO','Diorama'),
(3513850,'SP','Dirce Reis'),
(2203354,'PI','Dirceu Arcoverde'),
(2802007,'SE','Divina Pastora'),
(3121902,'MG','Divinésia'),
(3122009,'MG','Divino'),
(3122108,'MG','Divino das Laranjeiras'),
(3201803,'ES','Divino de São Lourenço'),
(3513900,'SP','Divinolândia'),
(3122207,'MG','Divinolândia de Minas'),
(3122306,'MG','Divinópolis'),
(5208301,'GO','Divinópolis de Goiás'),
(1707108,'TO','Divinópolis do Tocantins'),
(3122355,'MG','Divisa Alegre'),
(3122405,'MG','Divisa Nova'),
(3122454,'MG','Divisópolis'),
(3514007,'SP','Dobrada'),
(3514106,'SP','Dois Córregos'),
(4306403,'RS','Dois Irmãos'),
(4306429,'RS','Dois Irmãos das Missões'),
(5003488,'MS','Dois Irmãos do Buriti'),
(1707207,'TO','Dois Irmãos do Tocantins'),
(4306452,'RS','Dois Lajeados'),
(2702504,'AL','Dois Riachos'),
(4107207,'PR','Dois Vizinhos'),
(3514205,'SP','Dolcinópolis'),
(5103601,'MT','Dom Aquino'),
(2910107,'BA','Dom Basílio'),
(3122470,'MG','Dom Bosco'),
(3122504,'MG','Dom Cavati'),
(1502939,'PA','Dom Eliseu'),
(2203404,'PI','Dom Expedito Lopes'),
(4306502,'RS','Dom Feliciano'),
(2203453,'PI','Dom Inocêncio'),
(3122603,'MG','Dom Joaquim'),
(2910206,'BA','Dom Macedo Costa'),
(4306601,'RS','Dom Pedrito'),
(2103802,'MA','Dom Pedro'),
(4306551,'RS','Dom Pedro de Alcântara'),
(3122702,'MG','Dom Silvério'),
(3122801,'MG','Dom Viçoso'),
(3201902,'ES','Domingos Martins'),
(2203420,'PI','Domingos Mourão'),
(4205100,'SC','Dona Emma'),
(3122900,'MG','Dona Euzébia'),
(4306700,'RS','Dona Francisca'),
(2505709,'PB','Dona Inês'),
(3123007,'MG','Dores de Campos'),
(3123106,'MG','Dores de Guanhães'),
(3123205,'MG','Dores do Indaiá'),
(3202009,'ES','Dores do Rio Preto'),
(3123304,'MG','Dores do Turvo'),
(3123403,'MG','Doresópolis'),
(2605152,'PE','Dormentes'),
(4107256,'PR','Douradina'),
(5003504,'MS','Douradina'),
(3514304,'SP','Dourado'),
(3123502,'MG','Douradoquara'),
(5003702,'MS','Dourados'),
(4107306,'PR','Doutor Camargo'),
(4306734,'RS','Doutor Maurício Cardoso'),
(4205159,'SC','Doutor Pedrinho'),
(4306759,'RS','Doutor Ricardo'),
(2403202,'RN','Doutor Severiano'),
(4128633,'PR','Doutor Ulysses'),
(5207253,'GO','Doverlândia'),
(3514403,'SP','Dracena'),
(3514502,'SP','Duartina'),
(3301603,'RJ','Duas Barras'),
(2505808,'PB','Duas Estradas'),
(1707306,'TO','Dueré'),
(3514601,'SP','Dumont'),
(2103901,'MA','Duque Bacelar'),
(3301702,'RJ','Duque de Caxias'),
(3123528,'MG','Durandé'),
(3514700,'SP','Echaporã'),
(3202108,'ES','Ecoporanga'),
(5207352,'GO','Edealina'),
(5207402,'GO','Edéia'),
(1301407,'AM','Eirunepé'),
(5003751,'MS','Eldorado'),
(3514809,'SP','Eldorado'),
(1502954,'PA','Eldorado do Carajás'),
(4306767,'RS','Eldorado do Sul'),
(2203503,'PI','Elesbão Veloso'),
(3514908,'SP','Elias Fausto'),
(2203602,'PI','Eliseu Martins'),
(3514924,'SP','Elisiário'),
(2910305,'BA','Elísio Medrado'),
(3123601,'MG','Elói Mendes'),
(2505907,'PB','Emas'),
(3514957,'SP','Embaúba'),
(3515004,'SP','Embu das Artes'),
(3515103,'SP','Embu-Guaçu'),
(3515129,'SP','Emilianópolis'),
(4306809,'RS','Encantado'),
(2403301,'RN','Encanto'),
(2910404,'BA','Encruzilhada'),
(4306908,'RS','Encruzilhada do Sul'),
(4107405,'PR','Enéas Marques'),
(4107504,'PR','Engenheiro Beltrão'),
(3123700,'MG','Engenheiro Caldas'),
(3515152,'SP','Engenheiro Coelho'),
(3123809,'MG','Engenheiro Navarro'),
(3301801,'RJ','Engenheiro Paulo de Frontin'),
(4306924,'RS','Engenho Velho'),
(3123858,'MG','Entre Folhas'),
(2910503,'BA','Entre Rios'),
(4205175,'SC','Entre Rios'),
(3123908,'MG','Entre Rios de Minas'),
(4107538,'PR','Entre Rios do Oeste'),
(4306957,'RS','Entre Rios do Sul'),
(4306932,'RS','Entre-Ijuís'),
(1301506,'AM','Envira'),
(1200252,'AC','Epitaciolândia'),
(2403400,'RN','Equador'),
(4306973,'RS','Erebango'),
(4307005,'RS','Erechim'),
(2304277,'CE','Ereré'),
(2900504,'BA','Érico Cardoso'),
(4205191,'SC','Ermo'),
(4307054,'RS','Ernestina'),
(4307203,'RS','Erval Grande'),
(4307302,'RS','Erval Seco'),
(4205209,'SC','Erval Velho'),
(3124005,'MG','Ervália'),
(2605202,'PE','Escada'),
(4307401,'RS','Esmeralda'),
(3124104,'MG','Esmeraldas'),
(3124203,'MG','Espera Feliz'),
(2506004,'PB','Esperança'),
(4307450,'RS','Esperança do Sul'),
(4107520,'PR','Esperança Nova'),
(2203701,'PI','Esperantina'),
(1707405,'TO','Esperantina'),
(2104008,'MA','Esperantinópolis'),
(4107546,'PR','Espigão Alto do Iguaçu'),
(1100098,'RO','Espigão D''Oeste'),
(3124302,'MG','Espinosa'),
(2403509,'RN','Espírito Santo'),
(3124401,'MG','Espírito Santo do Dourado'),
(3515186,'SP','Espírito Santo do Pinhal'),
(3515194,'SP','Espírito Santo do Turvo'),
(2910602,'BA','Esplanada'),
(4307500,'RS','Espumoso'),
(4307559,'RS','Estação'),
(2802106,'SE','Estância'),
(4307609,'RS','Estância Velha'),
(4307708,'RS','Esteio'),
(3124500,'MG','Estiva'),
(3557303,'SP','Estiva Gerbi'),
(2104057,'MA','Estreito'),
(4307807,'RS','Estrela'),
(3124609,'MG','Estrela Dalva'),
(2702553,'AL','Estrela de Alagoas'),
(3124708,'MG','Estrela do Indaiá'),
(5207501,'GO','Estrela do Norte'),
(3515301,'SP','Estrela do Norte'),
(3124807,'MG','Estrela do Sul'),
(3515202,'SP','Estrela d''Oeste'),
(4307815,'RS','Estrela Velha'),
(2910701,'BA','Euclides da Cunha'),
(3515350,'SP','Euclides da Cunha Paulista'),
(4307831,'RS','Eugênio de Castro'),
(3124906,'MG','Eugenópolis'),
(2910727,'BA','Eunápolis'),
(2304285,'CE','Eusébio'),
(3125002,'MG','Ewbank da Câmara'),
(3125101,'MG','Extrema'),
(2403608,'RN','Extremoz'),
(2605301,'PE','Exu'),
(2506103,'PB','Fagundes'),
(4307864,'RS','Fagundes Varela'),
(5207535,'GO','Faina'),
(3125200,'MG','Fama'),
(3125309,'MG','Faria Lemos'),
(2304301,'CE','Farias Brito'),
(1503002,'PA','Faro'),
(4107553,'PR','Farol'),
(4307906,'RS','Farroupilha'),
(3515400,'SP','Fartura'),
(2203750,'PI','Fartura do Piauí'),
(1707553,'TO','Fátima'),
(2910750,'BA','Fátima'),
(5003801,'MS','Fátima do Sul'),
(4107603,'PR','Faxinal'),
(4308003,'RS','Faxinal do Soturno'),
(4205308,'SC','Faxinal dos Guedes'),
(4308052,'RS','Faxinalzinho'),
(5207600,'GO','Fazenda Nova'),
(4107652,'PR','Fazenda Rio Grande'),
(4308078,'RS','Fazenda Vilanova'),
(1200302,'AC','Feijó'),
(2910776,'BA','Feira da Mata'),
(2910800,'BA','Feira de Santana'),
(2702603,'AL','Feira Grande'),
(2605400,'PE','Feira Nova'),
(2802205,'SE','Feira Nova'),
(2104073,'MA','Feira Nova do Maranhão'),
(3125408,'MG','Felício dos Santos'),
(2403707,'RN','Felipe Guerra'),
(3125606,'MG','Felisburgo'),
(3125705,'MG','Felixlândia'),
(4308102,'RS','Feliz'),
(2702702,'AL','Feliz Deserto'),
(5103700,'MT','Feliz Natal'),
(4107702,'PR','Fênix'),
(4107736,'PR','Fernandes Pinheiro'),
(3125804,'MG','Fernandes Tourinho'),
(2605459,'PE','Fernando de Noronha'),
(2104081,'MA','Fernando Falcão'),
(2403756,'RN','Fernando Pedroza'),
(3515608,'SP','Fernando Prestes'),
(3515509,'SP','Fernandópolis'),
(3515657,'SP','Fernão'),
(3515707,'SP','Ferraz de Vasconcelos'),
(1600238,'AP','Ferreira Gomes'),
(2605509,'PE','Ferreiros'),
(3125903,'MG','Ferros'),
(3125952,'MG','Fervedouro'),
(4107751,'PR','Figueira'),
(5003900,'MS','Figueirão'),
(1707652,'TO','Figueirópolis'),
(5103809,'MT','Figueirópolis D''Oeste'),
(1707702,'TO','Filadélfia'),
(2910859,'BA','Filadélfia'),
(2910909,'BA','Firmino Alves'),
(5207808,'GO','Firminópolis'),
(2702801,'AL','Flexeiras'),
(4107850,'PR','Flor da Serra do Sul'),
(4205357,'SC','Flor do Sertão'),
(3515806,'SP','Flora Rica'),
(4107801,'PR','Floraí'),
(2403806,'RN','Florânia'),
(3515905,'SP','Floreal'),
(2605608,'PE','Flores'),
(4308201,'RS','Flores da Cunha'),
(5207907,'GO','Flores de Goiás'),
(2203800,'PI','Flores do Piauí'),
(2605707,'PE','Floresta'),
(4107900,'PR','Floresta'),
(2911006,'BA','Floresta Azul'),
(1503044,'PA','Floresta do Araguaia'),
(2203859,'PI','Floresta do Piauí'),
(3126000,'MG','Florestal'),
(4108007,'PR','Florestópolis'),
(2203909,'PI','Floriano'),
(4308250,'RS','Floriano Peixoto'),
(4205407,'SC','Florianópolis'),
(4108106,'PR','Flórida'),
(3516002,'SP','Flórida Paulista'),
(3516101,'SP','Florínea'),
(1301605,'AM','Fonte Boa'),
(4308300,'RS','Fontoura Xavier'),
(3126109,'MG','Formiga'),
(4308409,'RS','Formigueiro'),
(5208004,'GO','Formosa'),
(2104099,'MA','Formosa da Serra Negra'),
(4108205,'PR','Formosa do Oeste'),
(2911105,'BA','Formosa do Rio Preto'),
(4205431,'SC','Formosa do Sul'),
(5208103,'GO','Formoso'),
(3126208,'MG','Formoso'),
(1708205,'TO','Formoso do Araguaia'),
(4308433,'RS','Forquetinha'),
(2304350,'CE','Forquilha'),
(4205456,'SC','Forquilhinha'),
(2304400,'CE','Fortaleza'),
(3126307,'MG','Fortaleza de Minas'),
(2104107,'MA','Fortaleza dos Nogueiras'),
(4308458,'RS','Fortaleza dos Valos'),
(2304459,'CE','Fortim'),
(2104206,'MA','Fortuna'),
(3126406,'MG','Fortuna de Minas'),
(4108304,'PR','Foz do Iguaçu'),
(4108452,'PR','Foz do Jordão'),
(4205506,'SC','Fraiburgo'),
(3516200,'SP','Franca'),
(2204006,'PI','Francinópolis'),
(4108320,'PR','Francisco Alves'),
(2204105,'PI','Francisco Ayres'),
(3126505,'MG','Francisco Badaró'),
(4108403,'PR','Francisco Beltrão'),
(2403905,'RN','Francisco Dantas'),
(3126604,'MG','Francisco Dumont'),
(2204154,'PI','Francisco Macedo'),
(3516309,'SP','Francisco Morato'),
(3126703,'MG','Francisco Sá'),
(2204204,'PI','Francisco Santos'),
(3126752,'MG','Franciscópolis'),
(3516408,'SP','Franco da Rocha'),
(2304509,'CE','Frecheirinha'),
(4308508,'RS','Frederico Westphalen'),
(3126802,'MG','Frei Gaspar'),
(3126901,'MG','Frei Inocêncio'),
(3126950,'MG','Frei Lagonegro'),
(2506202,'PB','Frei Martinho'),
(2605806,'PE','Frei Miguelinho'),
(2802304,'SE','Frei Paulo'),
(4205555,'SC','Frei Rogério'),
(3127008,'MG','Fronteira'),
(3127057,'MG','Fronteira dos Vales'),
(2204303,'PI','Fronteiras'),
(3127073,'MG','Fruta de Leite'),
(3127107,'MG','Frutal'),
(2404002,'RN','Frutuoso Gomes'),
(3202207,'ES','Fundão'),
(3127206,'MG','Funilândia'),
(3516507,'SP','Gabriel Monteiro'),
(2506251,'PB','Gado Bravo'),
(3516606,'SP','Gália'),
(3127305,'MG','Galiléia'),
(2404101,'RN','Galinhos'),
(4205605,'SC','Galvão'),
(2605905,'PE','Gameleira'),
(5208152,'GO','Gameleira de Goiás'),
(3127339,'MG','Gameleiras'),
(2911204,'BA','Gandu'),
(2606002,'PE','Garanhuns'),
(2802403,'SE','Gararu'),
(3516705,'SP','Garça'),
(4308607,'RS','Garibaldi'),
(4205704,'SC','Garopaba'),
(1503077,'PA','Garrafão do Norte'),
(4308656,'RS','Garruchos'),
(4205803,'SC','Garuva'),
(4205902,'SC','Gaspar'),
(3516804,'SP','Gastão Vidigal'),
(5103858,'MT','Gaúcha do Norte'),
(4308706,'RS','Gaurama'),
(2911253,'BA','Gavião'),
(3516853,'SP','Gavião Peixoto'),
(2204352,'PI','Geminiano'),
(4308805,'RS','General Câmara'),
(5103908,'MT','General Carneiro'),
(4108502,'PR','General Carneiro'),
(2802502,'SE','General Maynard'),
(3516903,'SP','General Salgado'),
(2304608,'CE','General Sampaio'),
(4308854,'RS','Gentil'),
(2911303,'BA','Gentio do Ouro'),
(3517000,'SP','Getulina'),
(4308904,'RS','Getúlio Vargas'),
(2204402,'PI','Gilbués'),
(2702900,'AL','Girau do Ponciano'),
(4309001,'RS','Giruá'),
(3127354,'MG','Glaucilândia'),
(3517109,'SP','Glicério'),
(2911402,'BA','Glória'),
(5004007,'MS','Glória de Dourados'),
(2606101,'PE','Glória do Goitá'),
(5103957,'MT','Glória D''Oeste'),
(4309050,'RS','Glorinha'),
(2104305,'MA','Godofredo Viana'),
(4108551,'PR','Godoy Moreira'),
(3127370,'MG','Goiabeira'),
(2606200,'PE','Goiana'),
(3127388,'MG','Goianá'),
(5208400,'GO','Goianápolis'),
(5208509,'GO','Goiandira'),
(5208608,'GO','Goianésia'),
(1503093,'PA','Goianésia do Pará'),
(5208707,'GO','Goiânia'),
(2404200,'RN','Goianinha'),
(5208806,'GO','Goianira'),
(1708304,'TO','Goianorte'),
(5208905,'GO','Goiás'),
(1709005,'TO','Goiatins'),
(5209101,'GO','Goiatuba'),
(4108601,'PR','Goioerê'),
(4108650,'PR','Goioxim'),
(3127404,'MG','Gonçalves'),
(2104404,'MA','Gonçalves Dias'),
(2911501,'BA','Gongogi'),
(3127503,'MG','Gonzaga'),
(3127602,'MG','Gouveia'),
(5209150,'GO','Gouvelândia'),
(2104503,'MA','Governador Archer'),
(4206009,'SC','Governador Celso Ramos'),
(2404309,'RN','Governador Dix-Sept Rosado'),
(2104552,'MA','Governador Edison Lobão'),
(2104602,'MA','Governador Eugênio Barros'),
(1101005,'RO','Governador Jorge Teixeira'),
(3202256,'ES','Governador Lindenberg'),
(2104628,'MA','Governador Luiz Rocha'),
(2911600,'BA','Governador Mangabeira'),
(2104651,'MA','Governador Newton Bello'),
(2104677,'MA','Governador Nunes Freire'),
(3127701,'MG','Governador Valadares'),
(2304657,'CE','Graça'),
(2104701,'MA','Graça Aranha'),
(2802601,'SE','Graccho Cardoso'),
(2104800,'MA','Grajaú'),
(4309100,'RS','Gramado'),
(4309126,'RS','Gramado dos Loureiros'),
(4309159,'RS','Gramado Xavier'),
(4108700,'PR','Grandes Rios'),
(2606309,'PE','Granito'),
(2304707,'CE','Granja'),
(2304806,'CE','Granjeiro'),
(3127800,'MG','Grão Mogol'),
(4206108,'SC','Grão-Pará'),
(2606408,'PE','Gravatá'),
(4309209,'RS','Gravataí'),
(4206207,'SC','Gravatal'),
(2304905,'CE','Groaíras'),
(2404408,'RN','Grossos'),
(3127909,'MG','Grupiara'),
(4309258,'RS','Guabiju'),
(4206306,'SC','Guabiruba'),
(3202306,'ES','Guaçuí'),
(2204501,'PI','Guadalupe'),
(4309308,'RS','Guaíba'),
(3517208,'SP','Guaiçara'),
(3517307,'SP','Guaimbê'),
(3517406,'SP','Guaíra'),
(4108809,'PR','Guaíra'),
(4108908,'PR','Guairaçá'),
(2304954,'CE','Guaiúba'),
(1301654,'AM','Guajará'),
(1100106,'RO','Guajará-Mirim'),
(2911659,'BA','Guajeru'),
(2404507,'RN','Guamaré'),
(4108957,'PR','Guamiranga'),
(2911709,'BA','Guanambi'),
(3128006,'MG','Guanhães'),
(3128105,'MG','Guapé'),
(3517505,'SP','Guapiaçu'),
(3517604,'SP','Guapiara'),
(3301850,'RJ','Guapimirim'),
(4109005,'PR','Guapirama'),
(5209200,'GO','Guapó'),
(4309407,'RS','Guaporé'),
(4109104,'PR','Guaporema'),
(3517703,'SP','Guará');
INSERT IGNORE INTO cities (id,uf,name) VALUES
(2506301,'PB','Guarabira'),
(3517802,'SP','Guaraçaí'),
(3517901,'SP','Guaraci'),
(4109203,'PR','Guaraci'),
(4206405,'SC','Guaraciaba'),
(3128204,'MG','Guaraciaba'),
(2305001,'CE','Guaraciaba do Norte'),
(3128253,'MG','Guaraciama'),
(1709302,'TO','Guaraí'),
(5209291,'GO','Guaraíta'),
(2305100,'CE','Guaramiranga'),
(4206504,'SC','Guaramirim'),
(3128303,'MG','Guaranésia'),
(3128402,'MG','Guarani'),
(4309506,'RS','Guarani das Missões'),
(5209408,'GO','Guarani de Goiás'),
(3518008,'SP','Guarani d''Oeste'),
(4109302,'PR','Guaraniaçu'),
(3518107,'SP','Guarantã'),
(5104104,'MT','Guarantã do Norte'),
(3202405,'ES','Guarapari'),
(4109401,'PR','Guarapuava'),
(4109500,'PR','Guaraqueçaba'),
(3128501,'MG','Guarará'),
(3518206,'SP','Guararapes'),
(3518305,'SP','Guararema'),
(2911808,'BA','Guaratinga'),
(3518404,'SP','Guaratinguetá'),
(4109609,'PR','Guaratuba'),
(3128600,'MG','Guarda-Mor'),
(3518503,'SP','Guareí'),
(3518602,'SP','Guariba'),
(2204550,'PI','Guaribas'),
(5209457,'GO','Guarinos'),
(3518701,'SP','Guarujá'),
(4206603,'SC','Guarujá do Sul'),
(3518800,'SP','Guarulhos'),
(4206652,'SC','Guatambú'),
(3518859,'SP','Guatapará'),
(3128709,'MG','Guaxupé'),
(5004106,'MS','Guia Lopes da Laguna'),
(3128808,'MG','Guidoval'),
(2104909,'MA','Guimarães'),
(3128907,'MG','Guimarânia'),
(5104203,'MT','Guiratinga'),
(3129004,'MG','Guiricema'),
(3129103,'MG','Gurinhatã'),
(2506400,'PB','Gurinhém'),
(2506509,'PB','Gurjão'),
(1503101,'PA','Gurupá'),
(1709500,'TO','Gurupi'),
(3518909,'SP','Guzolândia'),
(4309555,'RS','Harmonia'),
(5209606,'GO','Heitoraí'),
(3129202,'MG','Heliodora'),
(2911857,'BA','Heliópolis'),
(3519006,'SP','Herculândia'),
(4307104,'RS','Herval'),
(4206702,'SC','Herval d''Oeste'),
(4309571,'RS','Herveiras'),
(5209705,'GO','Hidrolândia'),
(2305209,'CE','Hidrolândia'),
(5209804,'GO','Hidrolina'),
(3519055,'SP','Holambra'),
(4109658,'PR','Honório Serpa'),
(2305233,'CE','Horizonte'),
(4309605,'RS','Horizontina'),
(3519071,'SP','Hortolândia'),
(2204600,'PI','Hugo Napoleão'),
(4309654,'RS','Hulha Negra'),
(4309704,'RS','Humaitá'),
(1301704,'AM','Humaitá'),
(2105005,'MA','Humberto de Campos'),
(3519105,'SP','Iacanga'),
(5209903,'GO','Iaciara'),
(3519204,'SP','Iacri'),
(2911907,'BA','Iaçu'),
(3129301,'MG','Iapu'),
(3519253,'SP','Iaras'),
(2606507,'PE','Iati'),
(4109708,'PR','Ibaiti'),
(4309753,'RS','Ibarama'),
(2305266,'CE','Ibaretama'),
(3519303,'SP','Ibaté'),
(2703007,'AL','Ibateguara'),
(3202454,'ES','Ibatiba'),
(4109757,'PR','Ibema'),
(3129400,'MG','Ibertioga'),
(3129509,'MG','Ibiá'),
(4309803,'RS','Ibiaçá'),
(3129608,'MG','Ibiaí'),
(4206751,'SC','Ibiam'),
(2305308,'CE','Ibiapina'),
(2506608,'PB','Ibiara'),
(2912004,'BA','Ibiassucê'),
(2912103,'BA','Ibicaraí'),
(4206801,'SC','Ibicaré'),
(2912202,'BA','Ibicoara'),
(2912301,'BA','Ibicuí'),
(2305332,'CE','Ibicuitinga'),
(2606606,'PE','Ibimirim'),
(2912400,'BA','Ibipeba'),
(2912509,'BA','Ibipitanga'),
(4109807,'PR','Ibiporã'),
(2912608,'BA','Ibiquera'),
(3519402,'SP','Ibirá'),
(3129657,'MG','Ibiracatu'),
(3129707,'MG','Ibiraci'),
(3202504,'ES','Ibiraçu'),
(4309902,'RS','Ibiraiaras'),
(2606705,'PE','Ibirajuba'),
(4206900,'SC','Ibirama'),
(2912707,'BA','Ibirapitanga'),
(2912806,'BA','Ibirapuã'),
(4309951,'RS','Ibirapuitã'),
(3519501,'SP','Ibirarema'),
(2912905,'BA','Ibirataia'),
(3129806,'MG','Ibirité'),
(4310009,'RS','Ibirubá'),
(2913002,'BA','Ibitiara'),
(3519600,'SP','Ibitinga'),
(3202553,'ES','Ibitirama'),
(2913101,'BA','Ibititá'),
(3129905,'MG','Ibitiúra de Minas'),
(3130002,'MG','Ibituruna'),
(3519709,'SP','Ibiúna'),
(2913200,'BA','Ibotirama'),
(2305357,'CE','Icapuí'),
(4207007,'SC','Içara'),
(3130051,'MG','Icaraí de Minas'),
(4109906,'PR','Icaraíma'),
(2105104,'MA','Icatu'),
(3519808,'SP','Icém'),
(2913309,'BA','Ichu'),
(2305407,'CE','Icó'),
(3202603,'ES','Iconha'),
(2404606,'RN','Ielmo Marinho'),
(3519907,'SP','Iepê'),
(2703106,'AL','Igaci'),
(2913408,'BA','Igaporã'),
(3520004,'SP','Igaraçu do Tietê'),
(2502607,'PB','Igaracy'),
(3520103,'SP','Igarapava'),
(3130101,'MG','Igarapé'),
(2105153,'MA','Igarapé do Meio'),
(2105203,'MA','Igarapé Grande'),
(1503200,'PA','Igarapé-Açu'),
(1503309,'PA','Igarapé-Miri'),
(2606804,'PE','Igarassu'),
(3520202,'SP','Igaratá'),
(3130200,'MG','Igaratinga'),
(2913457,'BA','Igrapiúna'),
(2703205,'AL','Igreja Nova'),
(4310108,'RS','Igrejinha'),
(3301876,'RJ','Iguaba Grande'),
(2913507,'BA','Iguaí'),
(3520301,'SP','Iguape'),
(4110003,'PR','Iguaraçu'),
(2606903,'PE','Iguaracy'),
(3130309,'MG','Iguatama'),
(5004304,'MS','Iguatemi'),
(4110052,'PR','Iguatu'),
(2305506,'CE','Iguatu'),
(3130408,'MG','Ijaci'),
(4310207,'RS','Ijuí'),
(3520426,'SP','Ilha Comprida'),
(2802700,'SE','Ilha das Flores'),
(2607604,'PE','Ilha de Itamaracá'),
(2204659,'PI','Ilha Grande'),
(3520442,'SP','Ilha Solteira'),
(3520400,'SP','Ilhabela'),
(2913606,'BA','Ilhéus'),
(4207106,'SC','Ilhota'),
(3130507,'MG','Ilicínea'),
(4310306,'RS','Ilópolis'),
(2506707,'PB','Imaculada'),
(4207205,'SC','Imaruí'),
(4110078,'PR','Imbaú'),
(4310330,'RS','Imbé'),
(3130556,'MG','Imbé de Minas'),
(4207304,'SC','Imbituba'),
(4110102,'PR','Imbituva'),
(4207403,'SC','Imbuia'),
(4310363,'RS','Imigrante'),
(2105302,'MA','Imperatriz'),
(4110201,'PR','Inácio Martins'),
(5209937,'GO','Inaciolândia'),
(4110300,'PR','Inajá'),
(2607000,'PE','Inajá'),
(3130606,'MG','Inconfidentes'),
(3130655,'MG','Indaiabira'),
(4207502,'SC','Indaial'),
(3520509,'SP','Indaiatuba'),
(4310405,'RS','Independência'),
(2305605,'CE','Independência'),
(3520608,'SP','Indiana'),
(4110409,'PR','Indianópolis'),
(3130705,'MG','Indianópolis'),
(3520707,'SP','Indiaporã'),
(5209952,'GO','Indiara'),
(2802809,'SE','Indiaroba'),
(5104500,'MT','Indiavaí'),
(2506806,'PB','Ingá'),
(3130804,'MG','Ingaí'),
(2607109,'PE','Ingazeira'),
(4310413,'RS','Inhacorá'),
(2913705,'BA','Inhambupe'),
(1503408,'PA','Inhangapi'),
(2703304,'AL','Inhapi'),
(3130903,'MG','Inhapim'),
(3131000,'MG','Inhaúma'),
(2204709,'PI','Inhuma'),
(5210000,'GO','Inhumas'),
(3131109,'MG','Inimutaba'),
(5004403,'MS','Inocência'),
(3520806,'SP','Inúbia Paulista'),
(4207577,'SC','Iomerê'),
(3131158,'MG','Ipaba'),
(5210109,'GO','Ipameri'),
(3131208,'MG','Ipanema'),
(2404705,'RN','Ipanguaçu'),
(2305654,'CE','Ipaporanga'),
(3131307,'MG','Ipatinga'),
(2305704,'CE','Ipaumirim'),
(3520905,'SP','Ipaussu'),
(4310439,'RS','Ipê'),
(2913804,'BA','Ipecaetá'),
(3521002,'SP','Iperó'),
(3521101,'SP','Ipeúna'),
(3131406,'MG','Ipiaçu'),
(2913903,'BA','Ipiaú'),
(3521150,'SP','Ipiguá'),
(4207601,'SC','Ipira'),
(2914000,'BA','Ipirá'),
(4110508,'PR','Ipiranga'),
(5210158,'GO','Ipiranga de Goiás'),
(5104526,'MT','Ipiranga do Norte'),
(2204808,'PI','Ipiranga do Piauí'),
(4310462,'RS','Ipiranga do Sul'),
(1301803,'AM','Ipixuna'),
(1503457,'PA','Ipixuna do Pará'),
(2607208,'PE','Ipojuca'),
(5210208,'GO','Iporá'),
(4110607,'PR','Iporã'),
(4207650,'SC','Iporã do Oeste'),
(3521200,'SP','Iporanga'),
(2305803,'CE','Ipu'),
(3521309,'SP','Ipuã'),
(4207684,'SC','Ipuaçu'),
(2607307,'PE','Ipubi'),
(2404804,'RN','Ipueira'),
(2305902,'CE','Ipueiras'),
(1709807,'TO','Ipueiras'),
(3131505,'MG','Ipuiúna'),
(4207700,'SC','Ipumirim'),
(2914109,'BA','Ipupiara'),
(1400282,'RR','Iracema'),
(2306009,'CE','Iracema'),
(4110656,'PR','Iracema do Oeste'),
(3521408,'SP','Iracemápolis'),
(4207759,'SC','Iraceminha'),
(4310504,'RS','Iraí'),
(3131604,'MG','Iraí de Minas'),
(2914208,'BA','Irajuba'),
(2914307,'BA','Iramaia'),
(1301852,'AM','Iranduba'),
(4207809,'SC','Irani'),
(3521507,'SP','Irapuã'),
(3521606,'SP','Irapuru'),
(2914406,'BA','Iraquara'),
(2914505,'BA','Irará'),
(4110706,'PR','Irati'),
(4207858,'SC','Irati'),
(2306108,'CE','Irauçuba'),
(2914604,'BA','Irecê'),
(4110805,'PR','Iretama'),
(4207908,'SC','Irineópolis'),
(1503507,'PA','Irituia'),
(3202652,'ES','Irupi'),
(2204907,'PI','Isaías Coelho'),
(5210307,'GO','Israelândia'),
(4208005,'SC','Itá'),
(4310538,'RS','Itaara'),
(2506905,'PB','Itabaiana'),
(2802908,'SE','Itabaiana'),
(2803005,'SE','Itabaianinha'),
(2914653,'BA','Itabela'),
(3521705,'SP','Itaberá'),
(2914703,'BA','Itaberaba'),
(5210406,'GO','Itaberaí'),
(2803104,'SE','Itabi'),
(3131703,'MG','Itabira'),
(3131802,'MG','Itabirinha'),
(3131901,'MG','Itabirito'),
(3301900,'RJ','Itaboraí'),
(2914802,'BA','Itabuna'),
(1710508,'TO','Itacajá'),
(3132008,'MG','Itacambira'),
(3132107,'MG','Itacarambi'),
(2914901,'BA','Itacaré'),
(1301902,'AM','Itacoatiara'),
(2607406,'PE','Itacuruba'),
(4310553,'RS','Itacurubi'),
(2915007,'BA','Itaeté'),
(2915106,'BA','Itagi'),
(2915205,'BA','Itagibá'),
(2915304,'BA','Itagimirim'),
(3202702,'ES','Itaguaçu'),
(2915353,'BA','Itaguaçu da Bahia'),
(3302007,'RJ','Itaguaí'),
(4110904,'PR','Itaguajé'),
(3132206,'MG','Itaguara'),
(5210562,'GO','Itaguari'),
(5210604,'GO','Itaguaru'),
(1710706,'TO','Itaguatins'),
(3521804,'SP','Itaí'),
(2607505,'PE','Itaíba'),
(2306207,'CE','Itaiçaba'),
(2205003,'PI','Itainópolis'),
(4208104,'SC','Itaiópolis'),
(2105351,'MA','Itaipava do Grajaú'),
(3132305,'MG','Itaipé'),
(4110953,'PR','Itaipulândia'),
(2306256,'CE','Itaitinga'),
(1503606,'PA','Itaituba'),
(2404853,'RN','Itajá'),
(5210802,'GO','Itajá'),
(4208203,'SC','Itajaí'),
(3521903,'SP','Itajobi'),
(3522000,'SP','Itaju'),
(2915403,'BA','Itaju do Colônia'),
(3132404,'MG','Itajubá'),
(2915502,'BA','Itajuípe'),
(3302056,'RJ','Italva'),
(2915601,'BA','Itamaraju'),
(3132503,'MG','Itamarandiba'),
(1301951,'AM','Itamarati'),
(3132602,'MG','Itamarati de Minas'),
(2915700,'BA','Itamari'),
(3132701,'MG','Itambacuri'),
(4111001,'PR','Itambaracá'),
(4111100,'PR','Itambé'),
(2915809,'BA','Itambé'),
(2607653,'PE','Itambé'),
(3132800,'MG','Itambé do Mato Dentro'),
(3132909,'MG','Itamogi'),
(3133006,'MG','Itamonte'),
(2915908,'BA','Itanagra'),
(3522109,'SP','Itanhaém'),
(3133105,'MG','Itanhandu'),
(5104542,'MT','Itanhangá'),
(2916005,'BA','Itanhém'),
(3133204,'MG','Itanhomi'),
(3133303,'MG','Itaobim'),
(3522158,'SP','Itaoca'),
(3302106,'RJ','Itaocara'),
(5210901,'GO','Itapaci'),
(3133402,'MG','Itapagipe'),
(2306306,'CE','Itapajé'),
(2916104,'BA','Itaparica'),
(2916203,'BA','Itapé'),
(2916302,'BA','Itapebi'),
(3133501,'MG','Itapecerica'),
(3522208,'SP','Itapecerica da Serra'),
(2105401,'MA','Itapecuru Mirim'),
(4111209,'PR','Itapejara d''Oeste'),
(4208302,'SC','Itapema'),
(3202801,'ES','Itapemirim'),
(4111258,'PR','Itaperuçu'),
(3302205,'RJ','Itaperuna'),
(2607703,'PE','Itapetim'),
(2916401,'BA','Itapetinga'),
(3522307,'SP','Itapetininga'),
(3522406,'SP','Itapeva'),
(3133600,'MG','Itapeva'),
(3522505,'SP','Itapevi'),
(2916500,'BA','Itapicuru'),
(2306405,'CE','Itapipoca'),
(3522604,'SP','Itapira'),
(4208401,'SC','Itapiranga'),
(1302009,'AM','Itapiranga'),
(5211008,'GO','Itapirapuã'),
(3522653,'SP','Itapirapuã Paulista'),
(1710904,'TO','Itapiratins'),
(2607752,'PE','Itapissuma'),
(2916609,'BA','Itapitanga'),
(2306504,'CE','Itapiúna'),
(4208450,'SC','Itapoá'),
(3522703,'SP','Itápolis'),
(5004502,'MS','Itaporã'),
(1711100,'TO','Itaporã do Tocantins'),
(2507002,'PB','Itaporanga'),
(3522802,'SP','Itaporanga'),
(2803203,'SE','Itaporanga d''Ajuda'),
(2507101,'PB','Itapororoca'),
(1101104,'RO','Itapuã do Oeste'),
(4310579,'RS','Itapuca'),
(3522901,'SP','Itapuí'),
(3523008,'SP','Itapura'),
(5211206,'GO','Itapuranga'),
(3523107,'SP','Itaquaquecetuba'),
(2916708,'BA','Itaquara'),
(4310603,'RS','Itaqui'),
(5004601,'MS','Itaquiraí'),
(2607802,'PE','Itaquitinga'),
(3202900,'ES','Itarana'),
(2916807,'BA','Itarantim'),
(3523206,'SP','Itararé'),
(2306553,'CE','Itarema'),
(3523305,'SP','Itariri'),
(5211305,'GO','Itarumã'),
(4310652,'RS','Itati'),
(3302254,'RJ','Itatiaia'),
(3133709,'MG','Itatiaiuçu'),
(3523404,'SP','Itatiba'),
(4310702,'RS','Itatiba do Sul'),
(2916856,'BA','Itatim'),
(3523503,'SP','Itatinga'),
(2306603,'CE','Itatira'),
(2507200,'PB','Itatuba'),
(2404903,'RN','Itaú'),
(3133758,'MG','Itaú de Minas'),
(5104559,'MT','Itaúba'),
(1600253,'AP','Itaubal'),
(5211404,'GO','Itauçu'),
(2205102,'PI','Itaueira'),
(3133808,'MG','Itaúna'),
(4111308,'PR','Itaúna do Sul'),
(3133907,'MG','Itaverava'),
(3134004,'MG','Itinga'),
(2105427,'MA','Itinga do Maranhão'),
(5104609,'MT','Itiquira'),
(3523602,'SP','Itirapina'),
(3523701,'SP','Itirapuã'),
(2916906,'BA','Itiruçu'),
(2917003,'BA','Itiúba'),
(3523800,'SP','Itobi'),
(2917102,'BA','Itororó'),
(3523909,'SP','Itu'),
(2917201,'BA','Ituaçu'),
(2917300,'BA','Ituberá'),
(3134103,'MG','Itueta'),
(3134202,'MG','Ituiutaba'),
(5211503,'GO','Itumbiara'),
(3134301,'MG','Itumirim'),
(3524006,'SP','Itupeva'),
(1503705,'PA','Itupiranga'),
(4208500,'SC','Ituporanga'),
(3134400,'MG','Iturama'),
(3134509,'MG','Itutinga'),
(3524105,'SP','Ituverava'),
(2917334,'BA','Iuiu'),
(3203007,'ES','Iúna'),
(4111407,'PR','Ivaí'),
(4111506,'PR','Ivaiporã'),
(4111555,'PR','Ivaté'),
(4111605,'PR','Ivatuba'),
(5004700,'MS','Ivinhema'),
(5211602,'GO','Ivolândia'),
(4310751,'RS','Ivorá'),
(4310801,'RS','Ivoti'),
(2607901,'PE','Jaboatão dos Guararapes'),
(4208609,'SC','Jaborá'),
(3524204,'SP','Jaborandi'),
(2917359,'BA','Jaborandi'),
(4111704,'PR','Jaboti'),
(4310850,'RS','Jaboticaba'),
(3524303,'SP','Jaboticabal'),
(3134608,'MG','Jaboticatubas'),
(2405009,'RN','Jaçanã'),
(2917409,'BA','Jacaraci'),
(2507309,'PB','Jacaraú'),
(2703403,'AL','Jacaré dos Homens'),
(1503754,'PA','Jacareacanga'),
(3524402,'SP','Jacareí'),
(4111803,'PR','Jacarezinho'),
(3524501,'SP','Jaci'),
(5104807,'MT','Jaciara'),
(3134707,'MG','Jacinto'),
(4208708,'SC','Jacinto Machado'),
(2917508,'BA','Jacobina'),
(2205151,'PI','Jacobina do Piauí'),
(3134806,'MG','Jacuí'),
(2703502,'AL','Jacuípe'),
(4310876,'RS','Jacuizinho'),
(1503804,'PA','Jacundá'),
(3524600,'SP','Jacupiranga'),
(4310900,'RS','Jacutinga'),
(3134905,'MG','Jacutinga'),
(4111902,'PR','Jaguapitã'),
(2917607,'BA','Jaguaquara'),
(3135001,'MG','Jaguaraçu'),
(4311007,'RS','Jaguarão'),
(2917706,'BA','Jaguarari'),
(3203056,'ES','Jaguaré'),
(2306702,'CE','Jaguaretama'),
(4311106,'RS','Jaguari'),
(4112009,'PR','Jaguariaíva'),
(2306801,'CE','Jaguaribara'),
(2306900,'CE','Jaguaribe');
INSERT IGNORE INTO cities (id,uf,name) VALUES
(2917805,'BA','Jaguaripe'),
(3524709,'SP','Jaguariúna'),
(2307007,'CE','Jaguaruana'),
(4208807,'SC','Jaguaruna'),
(3135050,'MG','Jaíba'),
(2205201,'PI','Jaicós'),
(3524808,'SP','Jales'),
(3524907,'SP','Jambeiro'),
(3135076,'MG','Jampruca'),
(3135100,'MG','Janaúba'),
(5211701,'GO','Jandaia'),
(4112108,'PR','Jandaia do Sul'),
(2917904,'BA','Jandaíra'),
(2405108,'RN','Jandaíra'),
(3525003,'SP','Jandira'),
(2405207,'RN','Janduís'),
(5104906,'MT','Jangada'),
(4112207,'PR','Janiópolis'),
(3135209,'MG','Januária'),
(2405306,'RN','Januário Cicco'),
(3135308,'MG','Japaraíba'),
(2703601,'AL','Japaratinga'),
(2803302,'SE','Japaratuba'),
(3302270,'RJ','Japeri'),
(2405405,'RN','Japi'),
(4112306,'PR','Japira'),
(2803401,'SE','Japoatã'),
(3135357,'MG','Japonvar'),
(5004809,'MS','Japorã'),
(4112405,'PR','Japurá'),
(1302108,'AM','Japurá'),
(2607950,'PE','Jaqueira'),
(4311122,'RS','Jaquirana'),
(5211800,'GO','Jaraguá'),
(4208906,'SC','Jaraguá do Sul'),
(5004908,'MS','Jaraguari'),
(2703700,'AL','Jaramataia'),
(2307106,'CE','Jardim'),
(5005004,'MS','Jardim'),
(4112504,'PR','Jardim Alegre'),
(2405504,'RN','Jardim de Angicos'),
(2405603,'RN','Jardim de Piranhas'),
(2205250,'PI','Jardim do Mulato'),
(2405702,'RN','Jardim do Seridó'),
(4112603,'PR','Jardim Olinda'),
(3525102,'SP','Jardinópolis'),
(4208955,'SC','Jardinópolis'),
(4311130,'RS','Jari'),
(3525201,'SP','Jarinu'),
(1100114,'RO','Jaru'),
(5211909,'GO','Jataí'),
(4112702,'PR','Jataizinho'),
(2608008,'PE','Jataúba'),
(5005103,'MS','Jateí'),
(2307205,'CE','Jati'),
(2105450,'MA','Jatobá'),
(2608057,'PE','Jatobá'),
(2205276,'PI','Jatobá do Piauí'),
(3525300,'SP','Jaú'),
(1711506,'TO','Jaú do Tocantins'),
(5212006,'GO','Jaupaci'),
(5105002,'MT','Jauru'),
(3135407,'MG','Jeceaba'),
(3135456,'MG','Jenipapo de Minas'),
(2105476,'MA','Jenipapo dos Vieiras'),
(3135506,'MG','Jequeri'),
(2703759,'AL','Jequiá da Praia'),
(2918001,'BA','Jequié'),
(3135605,'MG','Jequitaí'),
(3135704,'MG','Jequitibá'),
(3135803,'MG','Jequitinhonha'),
(2918100,'BA','Jeremoabo'),
(2507408,'PB','Jericó'),
(3525409,'SP','Jeriquara'),
(3203106,'ES','Jerônimo Monteiro'),
(2205300,'PI','Jerumenha'),
(3135902,'MG','Jesuânia'),
(4112751,'PR','Jesuítas'),
(5212055,'GO','Jesúpolis'),
(2307254,'CE','Jijoca de Jericoacoara'),
(1100122,'RO','Ji-Paraná'),
(2918209,'BA','Jiquiriçá'),
(2918308,'BA','Jitaúna'),
(4209003,'SC','Joaçaba'),
(3136009,'MG','Joaíma'),
(3136108,'MG','Joanésia'),
(3525508,'SP','Joanópolis'),
(2608107,'PE','João Alfredo'),
(2405801,'RN','João Câmara'),
(2205359,'PI','João Costa'),
(2405900,'RN','João Dias'),
(2918357,'BA','João Dourado'),
(2105500,'MA','João Lisboa'),
(3136207,'MG','João Monlevade'),
(3203130,'ES','João Neiva'),
(2507507,'PB','João Pessoa'),
(3136306,'MG','João Pinheiro'),
(3525607,'SP','João Ramalho'),
(3136405,'MG','Joaquim Felício'),
(2703809,'AL','Joaquim Gomes'),
(2608206,'PE','Joaquim Nabuco'),
(2205409,'PI','Joaquim Pires'),
(4112801,'PR','Joaquim Távora'),
(2513653,'PB','Joca Claudino'),
(2205458,'PI','Joca Marques'),
(4311155,'RS','Jóia'),
(4209102,'SC','Joinville'),
(3136504,'MG','Jordânia'),
(1200328,'AC','Jordão'),
(4209151,'SC','José Boiteux'),
(3525706,'SP','José Bonifácio'),
(2406007,'RN','José da Penha'),
(2205508,'PI','José de Freitas'),
(3136520,'MG','José Gonçalves de Minas'),
(3136553,'MG','José Raydan'),
(2105609,'MA','Joselândia'),
(3136579,'MG','Josenópolis'),
(5212105,'GO','Joviânia'),
(5105101,'MT','Juara'),
(2507606,'PB','Juarez Távora'),
(1711803,'TO','Juarina'),
(3136652,'MG','Juatuba'),
(2507705,'PB','Juazeirinho'),
(2918407,'BA','Juazeiro'),
(2307304,'CE','Juazeiro do Norte'),
(2205516,'PI','Juazeiro do Piauí'),
(2307403,'CE','Jucás'),
(2608255,'PE','Jucati'),
(2918456,'BA','Jucuruçu'),
(2406106,'RN','Jucurutu'),
(5105150,'MT','Juína'),
(3136702,'MG','Juiz de Fora'),
(2205524,'PI','Júlio Borges'),
(4311205,'RS','Júlio de Castilhos'),
(3525805,'SP','Júlio Mesquita'),
(3525854,'SP','Jumirim'),
(2105658,'MA','Junco do Maranhão'),
(2507804,'PB','Junco do Seridó'),
(2406155,'RN','Jundiá'),
(2703908,'AL','Jundiá'),
(3525904,'SP','Jundiaí'),
(4112900,'PR','Jundiaí do Sul'),
(2704005,'AL','Junqueiro'),
(3526001,'SP','Junqueirópolis'),
(2608305,'PE','Jupi'),
(4209177,'SC','Jupiá'),
(3526100,'SP','Juquiá'),
(3526209,'SP','Juquitiba'),
(3136801,'MG','Juramento'),
(4112959,'PR','Juranda'),
(2608404,'PE','Jurema'),
(2205532,'PI','Jurema'),
(2507903,'PB','Juripiranga'),
(2508000,'PB','Juru'),
(1302207,'AM','Juruá'),
(3136900,'MG','Juruaia'),
(5105176,'MT','Juruena'),
(1503903,'PA','Juruti'),
(5105200,'MT','Juscimeira'),
(5212204,'GO','Jussara'),
(4113007,'PR','Jussara'),
(2918506,'BA','Jussara'),
(2918555,'BA','Jussari'),
(2918605,'BA','Jussiape'),
(1302306,'AM','Jutaí'),
(5005152,'MS','Juti'),
(3136959,'MG','Juvenília'),
(4113106,'PR','Kaloré'),
(1302405,'AM','Lábrea'),
(4209201,'SC','Lacerdópolis'),
(3137007,'MG','Ladainha'),
(5005202,'MS','Ladário'),
(2918704,'BA','Lafaiete Coutinho'),
(3137106,'MG','Lagamar'),
(2803500,'SE','Lagarto'),
(4209300,'SC','Lages'),
(2105708,'MA','Lago da Pedra'),
(2105807,'MA','Lago do Junco'),
(2105948,'MA','Lago dos Rodrigues'),
(2105906,'MA','Lago Verde'),
(2508109,'PB','Lagoa'),
(2205557,'PI','Lagoa Alegre'),
(4311239,'RS','Lagoa Bonita do Sul'),
(2704104,'AL','Lagoa da Canoa'),
(1711902,'TO','Lagoa da Confusão'),
(3137205,'MG','Lagoa da Prata'),
(2406205,'RN','Lagoa d''Anta'),
(2508208,'PB','Lagoa de Dentro'),
(2608503,'PE','Lagoa de Itaenga'),
(2406304,'RN','Lagoa de Pedras'),
(2205573,'PI','Lagoa de São Francisco'),
(2406403,'RN','Lagoa de Velhos'),
(2205565,'PI','Lagoa do Barro do Piauí'),
(2608453,'PE','Lagoa do Carro'),
(2105922,'MA','Lagoa do Mato'),
(2608602,'PE','Lagoa do Ouro'),
(2205581,'PI','Lagoa do Piauí'),
(2205599,'PI','Lagoa do Sítio'),
(1711951,'TO','Lagoa do Tocantins'),
(2608701,'PE','Lagoa dos Gatos'),
(3137304,'MG','Lagoa dos Patos'),
(4311270,'RS','Lagoa dos Três Cantos'),
(3137403,'MG','Lagoa Dourada'),
(3137502,'MG','Lagoa Formosa'),
(3137536,'MG','Lagoa Grande'),
(2608750,'PE','Lagoa Grande'),
(2105963,'MA','Lagoa Grande do Maranhão'),
(2406502,'RN','Lagoa Nova'),
(2918753,'BA','Lagoa Real'),
(2406601,'RN','Lagoa Salgada'),
(3137601,'MG','Lagoa Santa'),
(5212253,'GO','Lagoa Santa'),
(2508307,'PB','Lagoa Seca'),
(4311304,'RS','Lagoa Vermelha'),
(4311254,'RS','Lagoão'),
(3526308,'SP','Lagoinha'),
(2205540,'PI','Lagoinha do Piauí'),
(4209409,'SC','Laguna'),
(5005251,'MS','Laguna Carapã'),
(2918803,'BA','Laje'),
(3302304,'RJ','Laje do Muriaé'),
(4311403,'RS','Lajeado'),
(1712009,'TO','Lajeado'),
(4311429,'RS','Lajeado do Bugre'),
(4209458,'SC','Lajeado Grande'),
(2105989,'MA','Lajeado Novo'),
(2918902,'BA','Lajedão'),
(2919009,'BA','Lajedinho'),
(2608800,'PE','Lajedo'),
(2919058,'BA','Lajedo do Tabocal'),
(2406700,'RN','Lajes'),
(2406809,'RN','Lajes Pintadas'),
(3137700,'MG','Lajinha'),
(2919108,'BA','Lamarão'),
(3137809,'MG','Lambari'),
(5105234,'MT','Lambari D''Oeste'),
(3137908,'MG','Lamim'),
(2205607,'PI','Landri Sales'),
(4113205,'PR','Lapa'),
(2919157,'BA','Lapão'),
(3203163,'ES','Laranja da Terra'),
(4113254,'PR','Laranjal'),
(3138005,'MG','Laranjal'),
(1600279,'AP','Laranjal do Jari'),
(3526407,'SP','Laranjal Paulista'),
(2803609,'SE','Laranjeiras'),
(4113304,'PR','Laranjeiras do Sul'),
(3138104,'MG','Lassance'),
(2508406,'PB','Lastro'),
(4209508,'SC','Laurentino'),
(2919207,'BA','Lauro de Freitas'),
(4209607,'SC','Lauro Müller'),
(1712157,'TO','Lavandeira'),
(3526506,'SP','Lavínia'),
(3138203,'MG','Lavras'),
(2307502,'CE','Lavras da Mangabeira'),
(4311502,'RS','Lavras do Sul'),
(3526605,'SP','Lavrinhas'),
(3138302,'MG','Leandro Ferreira'),
(4209706,'SC','Lebon Régis'),
(3526704,'SP','Leme'),
(3138351,'MG','Leme do Prado'),
(2919306,'BA','Lençóis'),
(3526803,'SP','Lençóis Paulista'),
(4209805,'SC','Leoberto Leal'),
(3138401,'MG','Leopoldina'),
(5212303,'GO','Leopoldo de Bulhões'),
(4113403,'PR','Leópolis'),
(4311601,'RS','Liberato Salzano'),
(3138500,'MG','Liberdade'),
(2919405,'BA','Licínio de Almeida'),
(4113429,'PR','Lidianópolis'),
(2106003,'MA','Lima Campos'),
(3138609,'MG','Lima Duarte'),
(3526902,'SP','Limeira'),
(3138625,'MG','Limeira do Oeste'),
(2608909,'PE','Limoeiro'),
(2704203,'AL','Limoeiro de Anadia'),
(1504000,'PA','Limoeiro do Ajuru'),
(2307601,'CE','Limoeiro do Norte'),
(4113452,'PR','Lindoeste'),
(3527009,'SP','Lindóia'),
(4209854,'SC','Lindóia do Sul'),
(4311627,'RS','Lindolfo Collor'),
(4311643,'RS','Linha Nova'),
(3203205,'ES','Linhares'),
(3527108,'SP','Lins'),
(2508505,'PB','Livramento'),
(2919504,'BA','Livramento de Nossa Senhora'),
(1712405,'TO','Lizarda'),
(4113502,'PR','Loanda'),
(4113601,'PR','Lobato'),
(2508554,'PB','Logradouro'),
(4113700,'PR','Londrina'),
(3138658,'MG','Lontra'),
(4209904,'SC','Lontras'),
(3527207,'SP','Lorena'),
(2106102,'MA','Loreto'),
(3527256,'SP','Lourdes'),
(3527306,'SP','Louveira'),
(5105259,'MT','Lucas do Rio Verde'),
(3527405,'SP','Lucélia'),
(2508604,'PB','Lucena'),
(3527504,'SP','Lucianópolis'),
(5105309,'MT','Luciara'),
(2406908,'RN','Lucrécia'),
(3527603,'SP','Luís Antônio'),
(2205706,'PI','Luís Correia'),
(2106201,'MA','Luís Domingues'),
(2919553,'BA','Luís Eduardo Magalhães'),
(2407005,'RN','Luís Gomes'),
(3138674,'MG','Luisburgo'),
(3138682,'MG','Luislândia'),
(4210001,'SC','Luiz Alves'),
(4113734,'PR','Luiziana'),
(3527702,'SP','Luiziânia'),
(3138708,'MG','Luminárias'),
(4113759,'PR','Lunardelli'),
(3527801,'SP','Lupércio'),
(4113809,'PR','Lupionópolis'),
(3527900,'SP','Lutécia'),
(3138807,'MG','Luz'),
(4210035,'SC','Luzerna'),
(5212501,'GO','Luziânia'),
(2205805,'PI','Luzilândia'),
(1712454,'TO','Luzinópolis'),
(3302403,'RJ','Macaé'),
(2407104,'RN','Macaíba'),
(2919603,'BA','Macajuba'),
(4311718,'RS','Maçambará'),
(2803708,'SE','Macambira'),
(1600303,'AP','Macapá'),
(2609006,'PE','Macaparana'),
(2919702,'BA','Macarani'),
(3528007,'SP','Macatuba'),
(2407203,'RN','Macau'),
(3528106,'SP','Macaubal'),
(2919801,'BA','Macaúbas'),
(3528205,'SP','Macedônia'),
(2704302,'AL','Maceió'),
(3138906,'MG','Machacalis'),
(4311700,'RS','Machadinho'),
(1100130,'RO','Machadinho D''Oeste'),
(3139003,'MG','Machado'),
(2609105,'PE','Machados'),
(4210050,'SC','Macieira'),
(3302452,'RJ','Macuco'),
(2919900,'BA','Macururé'),
(2307635,'CE','Madalena'),
(2205854,'PI','Madeiro'),
(2919926,'BA','Madre de Deus'),
(3139102,'MG','Madre de Deus de Minas'),
(2508703,'PB','Mãe d''Água'),
(1504059,'PA','Mãe do Rio'),
(2919959,'BA','Maetinga'),
(4210100,'SC','Mafra'),
(1504109,'PA','Magalhães Barata'),
(2106300,'MA','Magalhães de Almeida'),
(3528304,'SP','Magda'),
(3302502,'RJ','Magé'),
(2920007,'BA','Maiquinique'),
(2920106,'BA','Mairi'),
(3528403,'SP','Mairinque'),
(3528502,'SP','Mairiporã'),
(5212600,'GO','Mairipotaba'),
(4210209,'SC','Major Gercino'),
(2704401,'AL','Major Isidoro'),
(2407252,'RN','Major Sales'),
(4210308,'SC','Major Vieira'),
(3139201,'MG','Malacacheta'),
(2920205,'BA','Malhada'),
(2920304,'BA','Malhada de Pedras'),
(2803807,'SE','Malhada dos Bois'),
(2803906,'SE','Malhador'),
(4113908,'PR','Mallet'),
(2508802,'PB','Malta'),
(2508901,'PB','Mamanguape'),
(5212709,'GO','Mambaí'),
(4114005,'PR','Mamborê'),
(3139250,'MG','Mamonas'),
(4311734,'RS','Mampituba'),
(1302504,'AM','Manacapuru'),
(2509008,'PB','Manaíra'),
(1302553,'AM','Manaquiri'),
(2609154,'PE','Manari'),
(1302603,'AM','Manaus'),
(1200336,'AC','Mâncio Lima'),
(4114104,'PR','Mandaguaçu'),
(4114203,'PR','Mandaguari'),
(4114302,'PR','Mandirituba'),
(3528601,'SP','Manduri'),
(4114351,'PR','Manfrinópolis'),
(3139300,'MG','Manga'),
(3302601,'RJ','Mangaratiba'),
(4114401,'PR','Mangueirinha'),
(3139409,'MG','Manhuaçu'),
(3139508,'MG','Manhumirim'),
(1302702,'AM','Manicoré'),
(2205904,'PI','Manoel Emídio'),
(4114500,'PR','Manoel Ribas'),
(1200344,'AC','Manoel Urbano'),
(4311759,'RS','Manoel Viana'),
(2920403,'BA','Manoel Vitorino'),
(2920452,'BA','Mansidão'),
(3139607,'MG','Mantena'),
(3203304,'ES','Mantenópolis'),
(4311775,'RS','Maquiné'),
(3139805,'MG','Mar de Espanha'),
(2704906,'AL','Mar Vermelho'),
(5212808,'GO','Mara Rosa'),
(1302801,'AM','Maraã'),
(1504208,'PA','Marabá'),
(3528700,'SP','Marabá Paulista'),
(2106326,'MA','Maracaçumé'),
(3528809,'SP','Maracaí'),
(4210407,'SC','Maracajá'),
(5005400,'MS','Maracaju'),
(1504307,'PA','Maracanã'),
(2307650,'CE','Maracanaú'),
(2920502,'BA','Maracás'),
(2704500,'AL','Maragogi'),
(2920601,'BA','Maragogipe'),
(2609204,'PE','Maraial'),
(2106359,'MA','Marajá do Sena'),
(2307700,'CE','Maranguape'),
(2106375,'MA','Maranhãozinho'),
(1504406,'PA','Marapanim'),
(3528858,'SP','Marapoama'),
(4311791,'RS','Maratá'),
(3203320,'ES','Marataízes'),
(4311809,'RS','Marau'),
(2920700,'BA','Maraú'),
(2704609,'AL','Maravilha'),
(4210506,'SC','Maravilha'),
(3139706,'MG','Maravilhas'),
(2509057,'PB','Marcação'),
(5105580,'MT','Marcelândia'),
(4311908,'RS','Marcelino Ramos'),
(2407302,'RN','Marcelino Vieira'),
(2920809,'BA','Marcionílio Souza'),
(2307809,'CE','Marco'),
(2205953,'PI','Marcolândia'),
(2206001,'PI','Marcos Parente'),
(4114609,'PR','Marechal Cândido Rondon'),
(2704708,'AL','Marechal Deodoro'),
(3203346,'ES','Marechal Floriano'),
(1200351,'AC','Marechal Thaumaturgo'),
(4210555,'SC','Marema'),
(2509107,'PB','Mari'),
(3139904,'MG','Maria da Fé'),
(4114708,'PR','Maria Helena'),
(4114807,'PR','Marialva'),
(3140001,'MG','Mariana'),
(4311981,'RS','Mariana Pimentel'),
(4312005,'RS','Mariano Moro'),
(1712504,'TO','Marianópolis do Tocantins'),
(3528908,'SP','Mariápolis'),
(2704807,'AL','Maribondo'),
(3302700,'RJ','Maricá'),
(3140100,'MG','Marilac'),
(3203353,'ES','Marilândia'),
(4114906,'PR','Marilândia do Sul'),
(4115002,'PR','Marilena'),
(3529005,'SP','Marília'),
(4115101,'PR','Mariluz'),
(4115200,'PR','Maringá'),
(3529104,'SP','Marinópolis'),
(3140159,'MG','Mário Campos'),
(4115309,'PR','Mariópolis'),
(4115358,'PR','Maripá'),
(3140209,'MG','Maripá de Minas'),
(1504422,'PA','Marituba'),
(2509156,'PB','Marizópolis'),
(3140308,'MG','Marliéria'),
(4115408,'PR','Marmeleiro'),
(3140407,'MG','Marmelópolis'),
(4312054,'RS','Marques de Souza'),
(4115457,'PR','Marquinho'),
(3140506,'MG','Martinho Campos'),
(2307908,'CE','Martinópole'),
(3529203,'SP','Martinópolis'),
(2407401,'RN','Martins'),
(3140530,'MG','Martins Soares'),
(2804003,'SE','Maruim'),
(4115507,'PR','Marumbi'),
(5212907,'GO','Marzagão'),
(2920908,'BA','Mascote'),
(2308005,'CE','Massapê'),
(2206050,'PI','Massapê do Piauí'),
(2509206,'PB','Massaranduba'),
(4210605,'SC','Massaranduba'),
(4312104,'RS','Mata'),
(2921005,'BA','Mata de São João'),
(2705002,'AL','Mata Grande'),
(2106409,'MA','Mata Roma'),
(3140555,'MG','Mata Verde'),
(3529302,'SP','Matão'),
(2509305,'PB','Mataraca'),
(1712702,'TO','Mateiros'),
(4115606,'PR','Matelândia');
INSERT IGNORE INTO cities (id,uf,name) VALUES
(3140605,'MG','Materlândia'),
(3140704,'MG','Mateus Leme'),
(3171501,'MG','Mathias Lobato'),
(3140803,'MG','Matias Barbosa'),
(3140852,'MG','Matias Cardoso'),
(2206100,'PI','Matias Olímpio'),
(2921054,'BA','Matina'),
(2106508,'MA','Matinha'),
(2509339,'PB','Matinhas'),
(4115705,'PR','Matinhos'),
(3140902,'MG','Matipó'),
(4312138,'RS','Mato Castelhano'),
(2509370,'PB','Mato Grosso'),
(4312153,'RS','Mato Leitão'),
(4312179,'RS','Mato Queimado'),
(4115739,'PR','Mato Rico'),
(3141009,'MG','Mato Verde'),
(2106607,'MA','Matões'),
(2106631,'MA','Matões do Norte'),
(4210704,'SC','Matos Costa'),
(3141108,'MG','Matozinhos'),
(5212956,'GO','Matrinchã'),
(2705101,'AL','Matriz de Camaragibe'),
(5105606,'MT','Matupá'),
(2509396,'PB','Maturéia'),
(3141207,'MG','Matutina'),
(3529401,'SP','Mauá'),
(4115754,'PR','Mauá da Serra'),
(1302900,'AM','Maués'),
(5213004,'GO','Maurilândia'),
(1712801,'TO','Maurilândia do Tocantins'),
(2308104,'CE','Mauriti'),
(2407500,'RN','Maxaranguape'),
(4312203,'RS','Maximiliano de Almeida'),
(1600402,'AP','Mazagão'),
(3141306,'MG','Medeiros'),
(2921104,'BA','Medeiros Neto'),
(4115804,'PR','Medianeira'),
(1504455,'PA','Medicilândia'),
(3141405,'MG','Medina'),
(4210803,'SC','Meleiro'),
(1504505,'PA','Melgaço'),
(3302809,'RJ','Mendes'),
(3141504,'MG','Mendes Pimentel'),
(3529500,'SP','Mendonça'),
(4115853,'PR','Mercedes'),
(3141603,'MG','Mercês'),
(3529609,'SP','Meridiano'),
(2308203,'CE','Meruoca'),
(3529658,'SP','Mesópolis'),
(3302858,'RJ','Mesquita'),
(3141702,'MG','Mesquita'),
(2705200,'AL','Messias'),
(2407609,'RN','Messias Targino'),
(2206209,'PI','Miguel Alves'),
(2921203,'BA','Miguel Calmon'),
(2206308,'PI','Miguel Leão'),
(3302908,'RJ','Miguel Pereira'),
(3529708,'SP','Miguelópolis'),
(2308302,'CE','Milagres'),
(2921302,'BA','Milagres'),
(2106672,'MA','Milagres do Maranhão'),
(2308351,'CE','Milhã'),
(2206357,'PI','Milton Brandão'),
(5213053,'GO','Mimoso de Goiás'),
(3203403,'ES','Mimoso do Sul'),
(5213087,'GO','Minaçu'),
(2705309,'AL','Minador do Negrão'),
(4312252,'RS','Minas do Leão'),
(3141801,'MG','Minas Novas'),
(3141900,'MG','Minduri'),
(5213103,'GO','Mineiros'),
(3529807,'SP','Mineiros do Tietê'),
(1101203,'RO','Ministro Andreazza'),
(3530003,'SP','Mira Estrela'),
(3142007,'MG','Mirabela'),
(3529906,'SP','Miracatu'),
(3303005,'RJ','Miracema'),
(1713205,'TO','Miracema do Tocantins'),
(2106706,'MA','Mirador'),
(4115903,'PR','Mirador'),
(3142106,'MG','Miradouro'),
(4312302,'RS','Miraguaí'),
(3142205,'MG','Miraí'),
(2308377,'CE','Miraíma'),
(5005608,'MS','Miranda'),
(2106755,'MA','Miranda do Norte'),
(2609303,'PE','Mirandiba'),
(3530102,'SP','Mirandópolis'),
(2921401,'BA','Mirangaba'),
(1713304,'TO','Miranorte'),
(2921450,'BA','Mirante'),
(1101302,'RO','Mirante da Serra'),
(3530201,'SP','Mirante do Paranapanema'),
(4116000,'PR','Miraselva'),
(3530300,'SP','Mirassol'),
(5105622,'MT','Mirassol d''Oeste'),
(3530409,'SP','Mirassolândia'),
(3142254,'MG','Miravânia'),
(4210852,'SC','Mirim Doce'),
(2106805,'MA','Mirinzal'),
(4116059,'PR','Missal'),
(2308401,'CE','Missão Velha'),
(1504604,'PA','Mocajuba'),
(3530508,'SP','Mococa'),
(4210902,'SC','Modelo'),
(3142304,'MG','Moeda'),
(3142403,'MG','Moema'),
(2509404,'PB','Mogeiro'),
(3530607,'SP','Mogi das Cruzes'),
(3530706,'SP','Mogi Guaçu'),
(3530805,'SP','Mogi Mirim'),
(5213400,'GO','Moiporá'),
(2804102,'SE','Moita Bonita'),
(1504703,'PA','Moju'),
(1504752,'PA','Mojuí dos Campos'),
(2308500,'CE','Mombaça'),
(3530904,'SP','Mombuca'),
(2106904,'MA','Monção'),
(3531001,'SP','Monções'),
(4211009,'SC','Mondaí'),
(3531100,'SP','Mongaguá'),
(3142502,'MG','Monjolos'),
(2206407,'PI','Monsenhor Gil'),
(2206506,'PI','Monsenhor Hipólito'),
(3142601,'MG','Monsenhor Paulo'),
(2308609,'CE','Monsenhor Tabosa'),
(2509503,'PB','Montadas'),
(3142700,'MG','Montalvânia'),
(3203502,'ES','Montanha'),
(2407708,'RN','Montanhas'),
(4312351,'RS','Montauri'),
(2407807,'RN','Monte Alegre'),
(1504802,'PA','Monte Alegre'),
(5213509,'GO','Monte Alegre de Goiás'),
(3142809,'MG','Monte Alegre de Minas'),
(2804201,'SE','Monte Alegre de Sergipe'),
(2206605,'PI','Monte Alegre do Piauí'),
(3531209,'SP','Monte Alegre do Sul'),
(4312377,'RS','Monte Alegre dos Campos'),
(3531308,'SP','Monte Alto'),
(3531407,'SP','Monte Aprazível'),
(3142908,'MG','Monte Azul'),
(3531506,'SP','Monte Azul Paulista'),
(3143005,'MG','Monte Belo'),
(4312385,'RS','Monte Belo do Sul'),
(4211058,'SC','Monte Carlo'),
(3143104,'MG','Monte Carmelo'),
(4211108,'SC','Monte Castelo'),
(3531605,'SP','Monte Castelo'),
(2407906,'RN','Monte das Gameleiras'),
(1713601,'TO','Monte do Carmo'),
(3143153,'MG','Monte Formoso'),
(2509602,'PB','Monte Horebe'),
(3531803,'SP','Monte Mor'),
(1101401,'RO','Monte Negro'),
(2921500,'BA','Monte Santo'),
(3143203,'MG','Monte Santo de Minas'),
(1713700,'TO','Monte Santo do Tocantins'),
(3143401,'MG','Monte Sião'),
(2509701,'PB','Monteiro'),
(3531704,'SP','Monteiro Lobato'),
(2705408,'AL','Monteirópolis'),
(4312401,'RS','Montenegro'),
(2107001,'MA','Montes Altos'),
(3143302,'MG','Montes Claros'),
(5213707,'GO','Montes Claros de Goiás'),
(3143450,'MG','Montezuma'),
(5213756,'GO','Montividiu'),
(5213772,'GO','Montividiu do Norte'),
(2308708,'CE','Morada Nova'),
(3143500,'MG','Morada Nova de Minas'),
(2308807,'CE','Moraújo'),
(2614303,'PE','Moreilândia'),
(4116109,'PR','Moreira Sales'),
(2609402,'PE','Moreno'),
(4312427,'RS','Mormaço'),
(2921609,'BA','Morpará'),
(4116208,'PR','Morretes'),
(5213806,'GO','Morrinhos'),
(2308906,'CE','Morrinhos'),
(4312443,'RS','Morrinhos do Sul'),
(3531902,'SP','Morro Agudo'),
(5213855,'GO','Morro Agudo de Goiás'),
(2206654,'PI','Morro Cabeça no Tempo'),
(4211207,'SC','Morro da Fumaça'),
(3143609,'MG','Morro da Garça'),
(2921708,'BA','Morro do Chapéu'),
(2206670,'PI','Morro do Chapéu do Piauí'),
(3143708,'MG','Morro do Pilar'),
(4211256,'SC','Morro Grande'),
(4312450,'RS','Morro Redondo'),
(4312476,'RS','Morro Reuter'),
(2107100,'MA','Morros'),
(2921807,'BA','Mortugaba'),
(3532009,'SP','Morungaba'),
(5213905,'GO','Mossâmedes'),
(2408003,'RN','Mossoró'),
(4312500,'RS','Mostardas'),
(3532058,'SP','Motuca'),
(5214002,'GO','Mozarlândia'),
(1504901,'PA','Muaná'),
(1400308,'RR','Mucajaí'),
(2309003,'CE','Mucambo'),
(2921906,'BA','Mucugê'),
(4312609,'RS','Muçum'),
(2922003,'BA','Mucuri'),
(3203601,'ES','Mucurici'),
(4312617,'RS','Muitos Capões'),
(4312625,'RS','Muliterno'),
(2309102,'CE','Mulungu'),
(2509800,'PB','Mulungu'),
(2922052,'BA','Mulungu do Morro'),
(2922102,'BA','Mundo Novo'),
(5005681,'MS','Mundo Novo'),
(5214051,'GO','Mundo Novo'),
(3143807,'MG','Munhoz'),
(4116307,'PR','Munhoz de Melo'),
(2922201,'BA','Muniz Ferreira'),
(3203700,'ES','Muniz Freire'),
(2922250,'BA','Muquém do São Francisco'),
(3203809,'ES','Muqui'),
(3143906,'MG','Muriaé'),
(2804300,'SE','Muribeca'),
(2705507,'AL','Murici'),
(2206696,'PI','Murici dos Portelas'),
(1713957,'TO','Muricilândia'),
(2922300,'BA','Muritiba'),
(3532108,'SP','Murutinga do Sul'),
(2922409,'BA','Mutuípe'),
(3144003,'MG','Mutum'),
(5214101,'GO','Mutunópolis'),
(3144102,'MG','Muzambinho'),
(3144201,'MG','Nacip Raydan'),
(3532157,'SP','Nantes'),
(3144300,'MG','Nanuque'),
(4312658,'RS','Não-Me-Toque'),
(3144359,'MG','Naque'),
(3532207,'SP','Narandiba'),
(2408102,'RN','Natal'),
(3144375,'MG','Natalândia'),
(3144409,'MG','Natércia'),
(3303104,'RJ','Natividade'),
(1714203,'TO','Natividade'),
(3532306,'SP','Natividade da Serra'),
(2509909,'PB','Natuba'),
(4211306,'SC','Navegantes'),
(5005707,'MS','Naviraí'),
(1714302,'TO','Nazaré'),
(2922508,'BA','Nazaré'),
(2609501,'PE','Nazaré da Mata'),
(2206704,'PI','Nazaré do Piauí'),
(3532405,'SP','Nazaré Paulista'),
(3144508,'MG','Nazareno'),
(2510006,'PB','Nazarezinho'),
(2206720,'PI','Nazária'),
(5214408,'GO','Nazário'),
(2804409,'SE','Neópolis'),
(3144607,'MG','Nepomuceno'),
(5214507,'GO','Nerópolis'),
(3532504,'SP','Neves Paulista'),
(1303007,'AM','Nhamundá'),
(3532603,'SP','Nhandeara'),
(4312674,'RS','Nicolau Vergueiro'),
(2922607,'BA','Nilo Peçanha'),
(3303203,'RJ','Nilópolis'),
(2107209,'MA','Nina Rodrigues'),
(3144656,'MG','Ninheira'),
(5005806,'MS','Nioaque'),
(3532702,'SP','Nipoã'),
(5214606,'GO','Niquelândia'),
(2408201,'RN','Nísia Floresta'),
(3303302,'RJ','Niterói'),
(5105903,'MT','Nobres'),
(4312708,'RS','Nonoai'),
(2922656,'BA','Nordestina'),
(1400407,'RR','Normandia'),
(5106000,'MT','Nortelândia'),
(2804458,'SE','Nossa Senhora Aparecida'),
(2804508,'SE','Nossa Senhora da Glória'),
(2804607,'SE','Nossa Senhora das Dores'),
(4116406,'PR','Nossa Senhora das Graças'),
(2804706,'SE','Nossa Senhora de Lourdes'),
(2206753,'PI','Nossa Senhora de Nazaré'),
(5106109,'MT','Nossa Senhora do Livramento'),
(2804805,'SE','Nossa Senhora do Socorro'),
(2206803,'PI','Nossa Senhora dos Remédios'),
(3532801,'SP','Nova Aliança'),
(4116505,'PR','Nova Aliança do Ivaí'),
(4312757,'RS','Nova Alvorada'),
(5006002,'MS','Nova Alvorada do Sul'),
(5214705,'GO','Nova América'),
(4116604,'PR','Nova América da Colina'),
(5006200,'MS','Nova Andradina'),
(4312807,'RS','Nova Araçá'),
(5214804,'GO','Nova Aurora'),
(4116703,'PR','Nova Aurora'),
(5106158,'MT','Nova Bandeirantes'),
(4312906,'RS','Nova Bassano'),
(3144672,'MG','Nova Belém'),
(4312955,'RS','Nova Boa Vista'),
(5106208,'MT','Nova Brasilândia'),
(1100148,'RO','Nova Brasilândia D''Oeste'),
(4313003,'RS','Nova Bréscia'),
(3532827,'SP','Nova Campina'),
(2922706,'BA','Nova Canaã'),
(5106216,'MT','Nova Canaã do Norte'),
(3532843,'SP','Nova Canaã Paulista'),
(4313011,'RS','Nova Candelária'),
(4116802,'PR','Nova Cantu'),
(3532868,'SP','Nova Castilho'),
(2107258,'MA','Nova Colinas'),
(5214838,'GO','Nova Crixás'),
(2408300,'RN','Nova Cruz'),
(3144706,'MG','Nova Era'),
(4211405,'SC','Nova Erechim'),
(4116901,'PR','Nova Esperança'),
(1504950,'PA','Nova Esperança do Piriá'),
(4116950,'PR','Nova Esperança do Sudoeste'),
(4313037,'RS','Nova Esperança do Sul'),
(3532900,'SP','Nova Europa'),
(4117008,'PR','Nova Fátima'),
(2922730,'BA','Nova Fátima'),
(2510105,'PB','Nova Floresta'),
(3303401,'RJ','Nova Friburgo'),
(5214861,'GO','Nova Glória'),
(3533007,'SP','Nova Granada'),
(5108808,'MT','Nova Guarita'),
(3533106,'SP','Nova Guataporanga'),
(4313060,'RS','Nova Hartz'),
(2922755,'BA','Nova Ibiá'),
(3303500,'RJ','Nova Iguaçu'),
(5214879,'GO','Nova Iguaçu de Goiás'),
(3533205,'SP','Nova Independência'),
(2107308,'MA','Nova Iorque'),
(1504976,'PA','Nova Ipixuna'),
(4211454,'SC','Nova Itaberaba'),
(2922805,'BA','Nova Itarana'),
(5106182,'MT','Nova Lacerda'),
(4117057,'PR','Nova Laranjeiras'),
(3144805,'MG','Nova Lima'),
(4117107,'PR','Nova Londrina'),
(3533304,'SP','Nova Luzitânia'),
(1100338,'RO','Nova Mamoré'),
(5108857,'MT','Nova Marilândia'),
(5108907,'MT','Nova Maringá'),
(3144904,'MG','Nova Módica'),
(5108956,'MT','Nova Monte Verde'),
(5106224,'MT','Nova Mutum'),
(5106174,'MT','Nova Nazaré'),
(3533403,'SP','Nova Odessa'),
(4117206,'PR','Nova Olímpia'),
(5106232,'MT','Nova Olímpia'),
(1714880,'TO','Nova Olinda'),
(2510204,'PB','Nova Olinda'),
(2309201,'CE','Nova Olinda'),
(2107357,'MA','Nova Olinda do Maranhão'),
(1303106,'AM','Nova Olinda do Norte'),
(4313086,'RS','Nova Pádua'),
(4313102,'RS','Nova Palma'),
(2510303,'PB','Nova Palmeira'),
(4313201,'RS','Nova Petrópolis'),
(3145000,'MG','Nova Ponte'),
(3145059,'MG','Nova Porteirinha'),
(4313300,'RS','Nova Prata'),
(4117255,'PR','Nova Prata do Iguaçu'),
(4313334,'RS','Nova Ramada'),
(2922854,'BA','Nova Redenção'),
(3145109,'MG','Nova Resende'),
(5214903,'GO','Nova Roma'),
(4313359,'RS','Nova Roma do Sul'),
(1715002,'TO','Nova Rosalândia'),
(2309300,'CE','Nova Russas'),
(4117214,'PR','Nova Santa Bárbara'),
(5106190,'MT','Nova Santa Helena'),
(4313375,'RS','Nova Santa Rita'),
(2207959,'PI','Nova Santa Rita'),
(4117222,'PR','Nova Santa Rosa'),
(3145208,'MG','Nova Serrana'),
(2922904,'BA','Nova Soure'),
(4117271,'PR','Nova Tebas'),
(1505007,'PA','Nova Timboteua'),
(4211504,'SC','Nova Trento'),
(5106240,'MT','Nova Ubiratã'),
(1101435,'RO','Nova União'),
(3136603,'MG','Nova União'),
(3203908,'ES','Nova Venécia'),
(5215009,'GO','Nova Veneza'),
(4211603,'SC','Nova Veneza'),
(2923001,'BA','Nova Viçosa'),
(5106257,'MT','Nova Xavantina'),
(3533254,'SP','Novais'),
(1715101,'TO','Novo Acordo'),
(1303205,'AM','Novo Airão'),
(1715150,'TO','Novo Alegre'),
(1303304,'AM','Novo Aripuanã'),
(4313490,'RS','Novo Barreiro'),
(5215207,'GO','Novo Brasil'),
(4313391,'RS','Novo Cabrais'),
(3145307,'MG','Novo Cruzeiro'),
(5215231,'GO','Novo Gama'),
(4313409,'RS','Novo Hamburgo'),
(4211652,'SC','Novo Horizonte'),
(3533502,'SP','Novo Horizonte'),
(2923035,'BA','Novo Horizonte'),
(5106273,'MT','Novo Horizonte do Norte'),
(1100502,'RO','Novo Horizonte do Oeste'),
(5006259,'MS','Novo Horizonte do Sul'),
(4117297,'PR','Novo Itacolomi'),
(1715259,'TO','Novo Jardim'),
(2705606,'AL','Novo Lino'),
(4313425,'RS','Novo Machado'),
(5106265,'MT','Novo Mundo'),
(2309409,'CE','Novo Oriente'),
(3145356,'MG','Novo Oriente de Minas'),
(2206902,'PI','Novo Oriente do Piauí'),
(5215256,'GO','Novo Planalto'),
(1505031,'PA','Novo Progresso'),
(1505064,'PA','Novo Repartimento'),
(2206951,'PI','Novo Santo Antônio'),
(5106315,'MT','Novo Santo Antônio'),
(5106281,'MT','Novo São Joaquim'),
(4313441,'RS','Novo Tiradentes'),
(2923050,'BA','Novo Triunfo'),
(4313466,'RS','Novo Xingu'),
(3145372,'MG','Novorizonte'),
(3533601,'SP','Nuporanga'),
(1505106,'PA','Óbidos'),
(2309458,'CE','Ocara'),
(3533700,'SP','Ocauçu'),
(2207009,'PI','Oeiras'),
(1505205,'PA','Oeiras do Pará'),
(1600501,'AP','Oiapoque'),
(3145406,'MG','Olaria'),
(3533809,'SP','Óleo'),
(2510402,'PB','Olho d''Água'),
(2107407,'MA','Olho d''Água das Cunhãs'),
(2705705,'AL','Olho d''Água das Flores'),
(2408409,'RN','Olho d''Água do Borges'),
(2705804,'AL','Olho d''Água do Casado'),
(2207108,'PI','Olho D''Água do Piauí'),
(2705903,'AL','Olho d''Água Grande'),
(3145455,'MG','Olhos-d''Água'),
(3533908,'SP','Olímpia'),
(3145505,'MG','Olímpio Noronha'),
(2609600,'PE','Olinda'),
(2107456,'MA','Olinda Nova do Maranhão'),
(2923100,'BA','Olindina'),
(2510501,'PB','Olivedos'),
(3145604,'MG','Oliveira'),
(1715507,'TO','Oliveira de Fátima'),
(2923209,'BA','Oliveira dos Brejinhos'),
(3145703,'MG','Oliveira Fortes'),
(2706000,'AL','Olivença'),
(3145802,'MG','Onça de Pitangui'),
(3534005,'SP','Onda Verde'),
(3145851,'MG','Oratórios'),
(3534104,'SP','Oriente'),
(3534203,'SP','Orindiúva'),
(1505304,'PA','Oriximiná'),
(3145877,'MG','Orizânia'),
(5215306,'GO','Orizona'),
(3534302,'SP','Orlândia'),
(4211702,'SC','Orleans'),
(2609709,'PE','Orobó'),
(2609808,'PE','Orocó'),
(2309508,'CE','Orós'),
(4117305,'PR','Ortigueira'),
(3534401,'SP','Osasco'),
(3534500,'SP','Oscar Bressane'),
(4313508,'RS','Osório'),
(3534609,'SP','Osvaldo Cruz'),
(4211751,'SC','Otacílio Costa'),
(1505403,'PA','Ourém'),
(2923308,'BA','Ouriçangas'),
(2609907,'PE','Ouricuri'),
(1505437,'PA','Ourilândia do Norte'),
(3534708,'SP','Ourinhos'),
(4117404,'PR','Ourizona'),
(4211801,'SC','Ouro'),
(3145901,'MG','Ouro Branco'),
(2408508,'RN','Ouro Branco'),
(2706109,'AL','Ouro Branco'),
(3146008,'MG','Ouro Fino'),
(3146107,'MG','Ouro Preto'),
(1100155,'RO','Ouro Preto do Oeste'),
(2510600,'PB','Ouro Velho'),
(3534807,'SP','Ouro Verde'),
(4211850,'SC','Ouro Verde'),
(5215405,'GO','Ouro Verde de Goiás'),
(3146206,'MG','Ouro Verde de Minas'),
(4117453,'PR','Ouro Verde do Oeste'),
(3534757,'SP','Ouroeste'),
(2923357,'BA','Ourolândia'),
(5215504,'GO','Ouvidor'),
(3534906,'SP','Pacaembu'),
(1505486,'PA','Pacajá'),
(2309607,'CE','Pacajus'),
(1400456,'RR','Pacaraima'),
(2309706,'CE','Pacatuba');
INSERT IGNORE INTO cities (id,uf,name) VALUES
(2804904,'SE','Pacatuba'),
(2107506,'MA','Paço do Lumiar'),
(2309805,'CE','Pacoti'),
(2309904,'CE','Pacujá'),
(5215603,'GO','Padre Bernardo'),
(3146255,'MG','Padre Carvalho'),
(2207207,'PI','Padre Marcos'),
(3146305,'MG','Padre Paraíso'),
(2207306,'PI','Paes Landim'),
(3146552,'MG','Pai Pedro'),
(4211876,'SC','Paial'),
(4117503,'PR','Paiçandu'),
(4313607,'RS','Paim Filho'),
(3146404,'MG','Paineiras'),
(4211892,'SC','Painel'),
(3146503,'MG','Pains'),
(3146602,'MG','Paiva'),
(2207355,'PI','Pajeú do Piauí'),
(2706208,'AL','Palestina'),
(3535002,'SP','Palestina'),
(5215652,'GO','Palestina de Goiás'),
(1505494,'PA','Palestina do Pará'),
(2310001,'CE','Palhano'),
(4211900,'SC','Palhoça'),
(3146701,'MG','Palma'),
(4212007,'SC','Palma Sola'),
(2310100,'CE','Palmácia'),
(2610004,'PE','Palmares'),
(4313656,'RS','Palmares do Sul'),
(3535101,'SP','Palmares Paulista'),
(4117602,'PR','Palmas'),
(1721000,'TO','Palmas'),
(2923407,'BA','Palmas de Monte Alto'),
(4117701,'PR','Palmeira'),
(4212056,'SC','Palmeira'),
(4313706,'RS','Palmeira das Missões'),
(2207405,'PI','Palmeira do Piauí'),
(3535200,'SP','Palmeira d''Oeste'),
(2706307,'AL','Palmeira dos Índios'),
(2207504,'PI','Palmeirais'),
(2107605,'MA','Palmeirândia'),
(1715705,'TO','Palmeirante'),
(2923506,'BA','Palmeiras'),
(5215702,'GO','Palmeiras de Goiás'),
(1713809,'TO','Palmeiras do Tocantins'),
(2610103,'PE','Palmeirina'),
(1715754,'TO','Palmeirópolis'),
(5215801,'GO','Palmelo'),
(5215900,'GO','Palminópolis'),
(4117800,'PR','Palmital'),
(3535309,'SP','Palmital'),
(4313805,'RS','Palmitinho'),
(4212106,'SC','Palmitos'),
(3146750,'MG','Palmópolis'),
(4117909,'PR','Palotina'),
(5216007,'GO','Panamá'),
(4313904,'RS','Panambi'),
(3204005,'ES','Pancas'),
(2610202,'PE','Panelas'),
(3535408,'SP','Panorama'),
(4313953,'RS','Pantano Grande'),
(2706406,'AL','Pão de Açúcar'),
(3146909,'MG','Papagaios'),
(4212205,'SC','Papanduva'),
(2207553,'PI','Paquetá'),
(3147105,'MG','Pará de Minas'),
(3303609,'RJ','Paracambi'),
(3147006,'MG','Paracatu'),
(2310209,'CE','Paracuru'),
(1505502,'PA','Paragominas'),
(3147204,'MG','Paraguaçu'),
(3535507,'SP','Paraguaçu Paulista'),
(4314001,'RS','Paraí'),
(3303708,'RJ','Paraíba do Sul'),
(2107704,'MA','Paraibano'),
(3535606,'SP','Paraibuna'),
(2310258,'CE','Paraipaba'),
(3535705,'SP','Paraíso'),
(4212239,'SC','Paraíso'),
(5006275,'MS','Paraíso das Águas'),
(4118006,'PR','Paraíso do Norte'),
(4314027,'RS','Paraíso do Sul'),
(1716109,'TO','Paraíso do Tocantins'),
(3147303,'MG','Paraisópolis'),
(2310308,'CE','Parambu'),
(2923605,'BA','Paramirim'),
(2310407,'CE','Paramoti'),
(2408607,'RN','Paraná'),
(1716208,'TO','Paranã'),
(4118105,'PR','Paranacity'),
(4118204,'PR','Paranaguá'),
(5006309,'MS','Paranaíba'),
(5216304,'GO','Paranaiguara'),
(5106299,'MT','Paranaíta'),
(3535804,'SP','Paranapanema'),
(4118303,'PR','Paranapoema'),
(3535903,'SP','Paranapuã'),
(2610301,'PE','Paranatama'),
(5106307,'MT','Paranatinga'),
(4118402,'PR','Paranavaí'),
(5006358,'MS','Paranhos'),
(3147402,'MG','Paraopeba'),
(3536000,'SP','Parapuã'),
(2510659,'PB','Parari'),
(2923704,'BA','Paratinga'),
(3303807,'RJ','Paraty'),
(2408706,'RN','Paraú'),
(1505536,'PA','Parauapebas'),
(5216403,'GO','Paraúna'),
(2408805,'RN','Parazinho'),
(3536109,'SP','Pardinho'),
(4314035,'RS','Pareci Novo'),
(1101450,'RO','Parecis'),
(2408904,'RN','Parelhas'),
(2706422,'AL','Pariconha'),
(1303403,'AM','Parintins'),
(2923803,'BA','Paripiranga'),
(2706448,'AL','Paripueira'),
(3536208,'SP','Pariquera-Açu'),
(3536257,'SP','Parisi'),
(2207603,'PI','Parnaguá'),
(2207702,'PI','Parnaíba'),
(2403251,'RN','Parnamirim'),
(2610400,'PE','Parnamirim'),
(2107803,'MA','Parnarama'),
(4314050,'RS','Parobé'),
(2409100,'RN','Passa e Fica'),
(3147600,'MG','Passa Quatro'),
(4314068,'RS','Passa Sete'),
(3147709,'MG','Passa Tempo'),
(3147808,'MG','Passa Vinte'),
(3147501,'MG','Passabém'),
(2409209,'RN','Passagem'),
(2510709,'PB','Passagem'),
(2107902,'MA','Passagem Franca'),
(2207751,'PI','Passagem Franca do Piauí'),
(2610509,'PE','Passira'),
(2706505,'AL','Passo de Camaragibe'),
(4212254,'SC','Passo de Torres'),
(4314076,'RS','Passo do Sobrado'),
(4314100,'RS','Passo Fundo'),
(3147907,'MG','Passos'),
(4212270,'SC','Passos Maia'),
(2108009,'MA','Pastos Bons'),
(3147956,'MG','Patis'),
(4118451,'PR','Pato Bragado'),
(4118501,'PR','Pato Branco'),
(2510808,'PB','Patos'),
(3148004,'MG','Patos de Minas'),
(2207777,'PI','Patos do Piauí'),
(3148103,'MG','Patrocínio'),
(3148202,'MG','Patrocínio do Muriaé'),
(3536307,'SP','Patrocínio Paulista'),
(2409308,'RN','Patu'),
(3303856,'RJ','Paty do Alferes'),
(2923902,'BA','Pau Brasil'),
(1505551,'PA','Pau D''Arco'),
(1716307,'TO','Pau D''Arco'),
(2207793,'PI','Pau D''Arco do Piauí'),
(2409407,'RN','Pau dos Ferros'),
(2610608,'PE','Paudalho'),
(1303502,'AM','Pauini'),
(3148301,'MG','Paula Cândido'),
(4118600,'PR','Paula Freitas'),
(3536406,'SP','Paulicéia'),
(3536505,'SP','Paulínia'),
(2108058,'MA','Paulino Neves'),
(2510907,'PB','Paulista'),
(2610707,'PE','Paulista'),
(2207801,'PI','Paulistana'),
(3536570,'SP','Paulistânia'),
(3148400,'MG','Paulistas'),
(2924009,'BA','Paulo Afonso'),
(4314134,'RS','Paulo Bento'),
(3536604,'SP','Paulo de Faria'),
(4118709,'PR','Paulo Frontin'),
(2706604,'AL','Paulo Jacinto'),
(4212304,'SC','Paulo Lopes'),
(2108108,'MA','Paulo Ramos'),
(3148509,'MG','Pavão'),
(4314159,'RS','Paverama'),
(2207850,'PI','Pavussu'),
(2924058,'BA','Pé de Serra'),
(4118808,'PR','Peabiru'),
(3148608,'MG','Peçanha'),
(3536703,'SP','Pederneiras'),
(2610806,'PE','Pedra'),
(3148707,'MG','Pedra Azul'),
(3536802,'SP','Pedra Bela'),
(3148756,'MG','Pedra Bonita'),
(2310506,'CE','Pedra Branca'),
(2511004,'PB','Pedra Branca'),
(1600154,'AP','Pedra Branca do Amapari'),
(3148806,'MG','Pedra do Anta'),
(3148905,'MG','Pedra do Indaiá'),
(3149002,'MG','Pedra Dourada'),
(2409506,'RN','Pedra Grande'),
(2511103,'PB','Pedra Lavrada'),
(2805000,'SE','Pedra Mole'),
(2409605,'RN','Pedra Preta'),
(5106372,'MT','Pedra Preta'),
(3149101,'MG','Pedralva'),
(3536901,'SP','Pedranópolis'),
(2924108,'BA','Pedrão'),
(4314175,'RS','Pedras Altas'),
(2511202,'PB','Pedras de Fogo'),
(3149150,'MG','Pedras de Maria da Cruz'),
(4212403,'SC','Pedras Grandes'),
(3537008,'SP','Pedregulho'),
(3537107,'SP','Pedreira'),
(2108207,'MA','Pedreiras'),
(2805109,'SE','Pedrinhas'),
(3537156,'SP','Pedrinhas Paulista'),
(3149200,'MG','Pedrinópolis'),
(1716505,'TO','Pedro Afonso'),
(2924207,'BA','Pedro Alexandre'),
(2409704,'RN','Pedro Avelino'),
(3204054,'ES','Pedro Canário'),
(3537206,'SP','Pedro de Toledo'),
(2108256,'MA','Pedro do Rosário'),
(5006408,'MS','Pedro Gomes'),
(2207900,'PI','Pedro II'),
(2207934,'PI','Pedro Laurentino'),
(3149309,'MG','Pedro Leopoldo'),
(4314209,'RS','Pedro Osório'),
(2512721,'PB','Pedro Régis'),
(3149408,'MG','Pedro Teixeira'),
(2409803,'RN','Pedro Velho'),
(1716604,'TO','Peixe'),
(1505601,'PA','Peixe-Boi'),
(5106422,'MT','Peixoto de Azevedo'),
(4314308,'RS','Pejuçara'),
(4314407,'RS','Pelotas'),
(2310605,'CE','Penaforte'),
(2108306,'MA','Penalva'),
(3537305,'SP','Penápolis'),
(2409902,'RN','Pendências'),
(2706703,'AL','Penedo'),
(4212502,'SC','Penha'),
(2310704,'CE','Pentecoste'),
(3149507,'MG','Pequeri'),
(3149606,'MG','Pequi'),
(1716653,'TO','Pequizeiro'),
(3149705,'MG','Perdigão'),
(3149804,'MG','Perdizes'),
(3149903,'MG','Perdões'),
(3537404,'SP','Pereira Barreto'),
(3537503,'SP','Pereiras'),
(2310803,'CE','Pereiro'),
(2108405,'MA','Peri Mirim'),
(3149952,'MG','Periquito'),
(4212601,'SC','Peritiba'),
(2108454,'MA','Peritoró'),
(4118857,'PR','Perobal'),
(4118907,'PR','Pérola'),
(4119004,'PR','Pérola d''Oeste'),
(5216452,'GO','Perolândia'),
(3537602,'SP','Peruíbe'),
(3150000,'MG','Pescador'),
(4212650,'SC','Pescaria Brava'),
(2610905,'PE','Pesqueira'),
(2611002,'PE','Petrolândia'),
(4212700,'SC','Petrolândia'),
(2611101,'PE','Petrolina'),
(5216809,'GO','Petrolina de Goiás'),
(3303906,'RJ','Petrópolis'),
(2706802,'AL','Piaçabuçu'),
(3537701,'SP','Piacatu'),
(2511301,'PB','Piancó'),
(2924306,'BA','Piatã'),
(3150109,'MG','Piau'),
(4314423,'RS','Picada Café'),
(1505635,'PA','Piçarra'),
(2208007,'PI','Picos'),
(2511400,'PB','Picuí'),
(3537800,'SP','Piedade'),
(3150158,'MG','Piedade de Caratinga'),
(3150208,'MG','Piedade de Ponte Nova'),
(3150307,'MG','Piedade do Rio Grande'),
(3150406,'MG','Piedade dos Gerais'),
(4119103,'PR','Piên'),
(2924405,'BA','Pilão Arcado'),
(2706901,'AL','Pilar'),
(2511509,'PB','Pilar'),
(5216908,'GO','Pilar de Goiás'),
(3537909,'SP','Pilar do Sul'),
(2511608,'PB','Pilões'),
(2410009,'RN','Pilões'),
(2511707,'PB','Pilõezinhos'),
(3150505,'MG','Pimenta'),
(1100189,'RO','Pimenta Bueno'),
(2208106,'PI','Pimenteiras'),
(1101468,'RO','Pimenteiras do Oeste'),
(2924504,'BA','Pindaí'),
(3538006,'SP','Pindamonhangaba'),
(2108504,'MA','Pindaré-Mirim'),
(2707008,'AL','Pindoba'),
(2924603,'BA','Pindobaçu'),
(3538105,'SP','Pindorama'),
(1717008,'TO','Pindorama do Tocantins'),
(2310852,'CE','Pindoretama'),
(3150539,'MG','Pingo-d''Água'),
(4119152,'PR','Pinhais'),
(4314456,'RS','Pinhal'),
(4314464,'RS','Pinhal da Serra'),
(4119251,'PR','Pinhal de São Bento'),
(4314472,'RS','Pinhal Grande'),
(4119202,'PR','Pinhalão'),
(4212908,'SC','Pinhalzinho'),
(3538204,'SP','Pinhalzinho'),
(4119301,'PR','Pinhão'),
(2805208,'SE','Pinhão'),
(3303955,'RJ','Pinheiral'),
(4314498,'RS','Pinheirinho do Vale'),
(2108603,'MA','Pinheiro'),
(4314506,'RS','Pinheiro Machado'),
(4213005,'SC','Pinheiro Preto'),
(3204104,'ES','Pinheiros'),
(2924652,'BA','Pintadas'),
(4314548,'RS','Pinto Bandeira'),
(3150570,'MG','Pintópolis'),
(2208205,'PI','Pio IX'),
(2108702,'MA','Pio XII'),
(3538303,'SP','Piquerobi'),
(2310902,'CE','Piquet Carneiro'),
(3538501,'SP','Piquete'),
(3538600,'SP','Piracaia'),
(5217104,'GO','Piracanjuba'),
(3150604,'MG','Piracema'),
(3538709,'SP','Piracicaba'),
(2208304,'PI','Piracuruca'),
(3304003,'RJ','Piraí'),
(2924678,'BA','Piraí do Norte'),
(4119400,'PR','Piraí do Sul'),
(3538808,'SP','Piraju'),
(3150703,'MG','Pirajuba'),
(3538907,'SP','Pirajuí'),
(2805307,'SE','Pirambu'),
(3150802,'MG','Piranga'),
(3539004,'SP','Pirangi'),
(3150901,'MG','Piranguçu'),
(3151008,'MG','Piranguinho'),
(5217203,'GO','Piranhas'),
(2707107,'AL','Piranhas'),
(2108801,'MA','Pirapemas'),
(3151107,'MG','Pirapetinga'),
(4314555,'RS','Pirapó'),
(3151206,'MG','Pirapora'),
(3539103,'SP','Pirapora do Bom Jesus'),
(3539202,'SP','Pirapozinho'),
(4119509,'PR','Piraquara'),
(1717206,'TO','Piraquê'),
(3539301,'SP','Pirassununga'),
(4314605,'RS','Piratini'),
(3539400,'SP','Piratininga'),
(4213104,'SC','Piratuba'),
(3151305,'MG','Piraúba'),
(5217302,'GO','Pirenópolis'),
(5217401,'GO','Pires do Rio'),
(2310951,'CE','Pires Ferreira'),
(2924702,'BA','Piripá'),
(2208403,'PI','Piripiri'),
(2924801,'BA','Piritiba'),
(2511806,'PB','Pirpirituba'),
(4119608,'PR','Pitanga'),
(4119657,'PR','Pitangueiras'),
(3539509,'SP','Pitangueiras'),
(3151404,'MG','Pitangui'),
(2511905,'PB','Pitimbu'),
(1717503,'TO','Pium'),
(3204203,'ES','Piúma'),
(3151503,'MG','Piumhi'),
(1505650,'PA','Placas'),
(1200385,'AC','Plácido de Castro'),
(5217609,'GO','Planaltina'),
(4119707,'PR','Planaltina do Paraná'),
(2924900,'BA','Planaltino'),
(2925006,'BA','Planalto'),
(4119806,'PR','Planalto'),
(3539608,'SP','Planalto'),
(4314704,'RS','Planalto'),
(4213153,'SC','Planalto Alegre'),
(5106455,'MT','Planalto da Serra'),
(3151602,'MG','Planura'),
(3539707,'SP','Platina'),
(3539806,'SP','Poá'),
(2611200,'PE','Poção'),
(2108900,'MA','Poção de Pedras'),
(2512002,'PB','Pocinhos'),
(2410108,'RN','Poço Branco'),
(2512036,'PB','Poço Dantas'),
(4314753,'RS','Poço das Antas'),
(2707206,'AL','Poço das Trincheiras'),
(2512077,'PB','Poço de José de Moura'),
(3151701,'MG','Poço Fundo'),
(2805406,'SE','Poço Redondo'),
(2805505,'SE','Poço Verde'),
(2925105,'BA','Poções'),
(5106505,'MT','Poconé'),
(3151800,'MG','Poços de Caldas'),
(3151909,'MG','Pocrane'),
(2925204,'BA','Pojuca'),
(3539905,'SP','Poloni'),
(2512101,'PB','Pombal'),
(2611309,'PE','Pombos'),
(4213203,'SC','Pomerode'),
(3540002,'SP','Pompéia'),
(3152006,'MG','Pompéu'),
(3540101,'SP','Pongaí'),
(1505700,'PA','Ponta de Pedras'),
(4119905,'PR','Ponta Grossa'),
(5006606,'MS','Ponta Porã'),
(3540200,'SP','Pontal'),
(5106653,'MT','Pontal do Araguaia'),
(4119954,'PR','Pontal do Paraná'),
(5217708,'GO','Pontalina'),
(3540259,'SP','Pontalinda'),
(4314779,'RS','Pontão'),
(4213302,'SC','Ponte Alta'),
(1717800,'TO','Ponte Alta do Bom Jesus'),
(4213351,'SC','Ponte Alta do Norte'),
(1717909,'TO','Ponte Alta do Tocantins'),
(5106703,'MT','Ponte Branca'),
(3152105,'MG','Ponte Nova'),
(4314787,'RS','Ponte Preta'),
(4213401,'SC','Ponte Serrada'),
(5106752,'MT','Pontes e Lacerda'),
(3540309,'SP','Pontes Gestal'),
(3204252,'ES','Ponto Belo'),
(3152131,'MG','Ponto Chique'),
(3152170,'MG','Ponto dos Volantes'),
(2925253,'BA','Ponto Novo'),
(3540408,'SP','Populina'),
(2311009,'CE','Poranga'),
(3540507,'SP','Porangaba'),
(5218003,'GO','Porangatu'),
(3304102,'RJ','Porciúncula'),
(4120002,'PR','Porecatu'),
(2410207,'RN','Portalegre'),
(4314803,'RS','Portão'),
(5218052,'GO','Porteirão'),
(2311108,'CE','Porteiras'),
(3152204,'MG','Porteirinha'),
(1505809,'PA','Portel'),
(5218102,'GO','Portelândia'),
(2208502,'PI','Porto'),
(1200807,'AC','Porto Acre'),
(4314902,'RS','Porto Alegre'),
(5106778,'MT','Porto Alegre do Norte'),
(2208551,'PI','Porto Alegre do Piauí'),
(1718006,'TO','Porto Alegre do Tocantins'),
(4120101,'PR','Porto Amazonas'),
(4120150,'PR','Porto Barreiro'),
(4213500,'SC','Porto Belo'),
(2707305,'AL','Porto Calvo'),
(2805604,'SE','Porto da Folha'),
(1505908,'PA','Porto de Moz'),
(2707404,'AL','Porto de Pedras'),
(2410256,'RN','Porto do Mangue'),
(5106802,'MT','Porto dos Gaúchos'),
(5106828,'MT','Porto Esperidião'),
(5106851,'MT','Porto Estrela'),
(3540606,'SP','Porto Feliz'),
(3540705,'SP','Porto Ferreira'),
(3152303,'MG','Porto Firme'),
(2109007,'MA','Porto Franco'),
(1600535,'AP','Porto Grande'),
(4315008,'RS','Porto Lucena'),
(4315057,'RS','Porto Mauá'),
(5006903,'MS','Porto Murtinho'),
(1718204,'TO','Porto Nacional'),
(3304110,'RJ','Porto Real'),
(2707503,'AL','Porto Real do Colégio'),
(4120200,'PR','Porto Rico'),
(2109056,'MA','Porto Rico do Maranhão'),
(2925303,'BA','Porto Seguro'),
(4213609,'SC','Porto União'),
(1100205,'RO','Porto Velho'),
(4315073,'RS','Porto Vera Cruz'),
(4120309,'PR','Porto Vitória'),
(1200393,'AC','Porto Walter'),
(4315107,'RS','Porto Xavier'),
(5218300,'GO','Posse'),
(3152402,'MG','Poté'),
(2311207,'CE','Potengi'),
(3540754,'SP','Potim'),
(2925402,'BA','Potiraguá'),
(3540804,'SP','Potirendaba'),
(2311231,'CE','Potiretama'),
(3152501,'MG','Pouso Alegre'),
(3152600,'MG','Pouso Alto'),
(4315131,'RS','Pouso Novo'),
(4213708,'SC','Pouso Redondo'),
(5107008,'MT','Poxoréu'),
(3540853,'SP','Pracinha'),
(1600550,'AP','Pracuúba'),
(2925501,'BA','Prado'),
(4120333,'PR','Prado Ferreira'),
(3540903,'SP','Pradópolis'),
(3152709,'MG','Prados');
INSERT IGNORE INTO cities (id,uf,name) VALUES
(3541000,'SP','Praia Grande'),
(4213807,'SC','Praia Grande'),
(1718303,'TO','Praia Norte'),
(1506005,'PA','Prainha'),
(4120358,'PR','Pranchita'),
(3152808,'MG','Prata'),
(2512200,'PB','Prata'),
(2208601,'PI','Prata do Piauí'),
(3541059,'SP','Pratânia'),
(3152907,'MG','Pratápolis'),
(3153004,'MG','Pratinha'),
(3541109,'SP','Presidente Alves'),
(3541208,'SP','Presidente Bernardes'),
(3153103,'MG','Presidente Bernardes'),
(4213906,'SC','Presidente Castello Branco'),
(4120408,'PR','Presidente Castelo Branco'),
(2109106,'MA','Presidente Dutra'),
(2925600,'BA','Presidente Dutra'),
(3541307,'SP','Presidente Epitácio'),
(1303536,'AM','Presidente Figueiredo'),
(4214003,'SC','Presidente Getúlio'),
(2925709,'BA','Presidente Jânio Quadros'),
(2109205,'MA','Presidente Juscelino'),
(3153202,'MG','Presidente Juscelino'),
(3204302,'ES','Presidente Kennedy'),
(1718402,'TO','Presidente Kennedy'),
(3153301,'MG','Presidente Kubitschek'),
(4315149,'RS','Presidente Lucena'),
(2109239,'MA','Presidente Médici'),
(1100254,'RO','Presidente Médici'),
(4214102,'SC','Presidente Nereu'),
(3153400,'MG','Presidente Olegário'),
(3541406,'SP','Presidente Prudente'),
(2109270,'MA','Presidente Sarney'),
(2925758,'BA','Presidente Tancredo Neves'),
(2109304,'MA','Presidente Vargas'),
(3541505,'SP','Presidente Venceslau'),
(1506104,'PA','Primavera'),
(2611408,'PE','Primavera'),
(1101476,'RO','Primavera de Rondônia'),
(5107040,'MT','Primavera do Leste'),
(2109403,'MA','Primeira Cruz'),
(4120507,'PR','Primeiro de Maio'),
(4214151,'SC','Princesa'),
(2512309,'PB','Princesa Isabel'),
(5218391,'GO','Professor Jamil'),
(4315156,'RS','Progresso'),
(3541604,'SP','Promissão'),
(2805703,'SE','Propriá'),
(4315172,'RS','Protásio Alves'),
(3153608,'MG','Prudente de Morais'),
(4120606,'PR','Prudentópolis'),
(1718451,'TO','Pugmil'),
(2410405,'RN','Pureza'),
(4315206,'RS','Putinga'),
(2512408,'PB','Puxinanã'),
(3541653,'SP','Quadra'),
(4315305,'RS','Quaraí'),
(3153707,'MG','Quartel Geral'),
(4120655,'PR','Quarto Centenário'),
(3541703,'SP','Quatá'),
(4120705,'PR','Quatiguá'),
(1506112,'PA','Quatipuru'),
(3304128,'RJ','Quatis'),
(4120804,'PR','Quatro Barras'),
(4315313,'RS','Quatro Irmãos'),
(4120853,'PR','Quatro Pontes'),
(2707602,'AL','Quebrangulo'),
(4120903,'PR','Quedas do Iguaçu'),
(2208650,'PI','Queimada Nova'),
(2512507,'PB','Queimadas'),
(2925808,'BA','Queimadas'),
(3304144,'RJ','Queimados'),
(3541802,'SP','Queiroz'),
(3541901,'SP','Queluz'),
(3153806,'MG','Queluzito'),
(5107065,'MT','Querência'),
(4121000,'PR','Querência do Norte'),
(4315321,'RS','Quevedos'),
(2925907,'BA','Quijingue'),
(4214201,'SC','Quilombo'),
(4121109,'PR','Quinta do Sol'),
(3542008,'SP','Quintana'),
(4315354,'RS','Quinze de Novembro'),
(2611507,'PE','Quipapá'),
(5218508,'GO','Quirinópolis'),
(3304151,'RJ','Quissamã'),
(4121208,'PR','Quitandinha'),
(2311264,'CE','Quiterianópolis'),
(2512606,'PB','Quixaba'),
(2611533,'PE','Quixaba'),
(2925931,'BA','Quixabeira'),
(2311306,'CE','Quixadá'),
(2311355,'CE','Quixelô'),
(2311405,'CE','Quixeramobim'),
(2311504,'CE','Quixeré'),
(2410504,'RN','Rafael Fernandes'),
(2410603,'RN','Rafael Godeiro'),
(2925956,'BA','Rafael Jambeiro'),
(3542107,'SP','Rafard'),
(4121257,'PR','Ramilândia'),
(3542206,'SP','Rancharia'),
(4121307,'PR','Rancho Alegre'),
(4121356,'PR','Rancho Alegre D''Oeste'),
(4214300,'SC','Rancho Queimado'),
(2109452,'MA','Raposa'),
(3153905,'MG','Raposos'),
(3154002,'MG','Raul Soares'),
(4121406,'PR','Realeza'),
(4121505,'PR','Rebouças'),
(2611606,'PE','Recife'),
(3154101,'MG','Recreio'),
(1718501,'TO','Recursolândia'),
(1506138,'PA','Redenção'),
(2311603,'CE','Redenção'),
(3542305,'SP','Redenção da Serra'),
(2208700,'PI','Redenção do Gurguéia'),
(4315404,'RS','Redentora'),
(3154150,'MG','Reduto'),
(2208809,'PI','Regeneração'),
(3542404,'SP','Regente Feijó'),
(3542503,'SP','Reginópolis'),
(3542602,'SP','Registro'),
(4315453,'RS','Relvado'),
(2926004,'BA','Remanso'),
(2512705,'PB','Remígio'),
(4121604,'PR','Renascença'),
(2311702,'CE','Reriutaba'),
(3304201,'RJ','Resende'),
(3154200,'MG','Resende Costa'),
(4121703,'PR','Reserva'),
(5107156,'MT','Reserva do Cabaçal'),
(4121752,'PR','Reserva do Iguaçu'),
(3154309,'MG','Resplendor'),
(3154408,'MG','Ressaquinha'),
(3542701,'SP','Restinga'),
(4315503,'RS','Restinga Sêca'),
(2926103,'BA','Retirolândia'),
(2512747,'PB','Riachão'),
(2109502,'MA','Riachão'),
(2926202,'BA','Riachão das Neves'),
(2512754,'PB','Riachão do Bacamarte'),
(2805802,'SE','Riachão do Dantas'),
(2926301,'BA','Riachão do Jacuípe'),
(2512762,'PB','Riachão do Poço'),
(1718550,'TO','Riachinho'),
(3154457,'MG','Riachinho'),
(2410702,'RN','Riacho da Cruz'),
(2611705,'PE','Riacho das Almas'),
(2926400,'BA','Riacho de Santana'),
(2410801,'RN','Riacho de Santana'),
(2512788,'PB','Riacho de Santo Antônio'),
(2512804,'PB','Riacho dos Cavalos'),
(3154507,'MG','Riacho dos Machados'),
(2208858,'PI','Riacho Frio'),
(2410900,'RN','Riachuelo'),
(2805901,'SE','Riachuelo'),
(5218607,'GO','Rialma'),
(5218706,'GO','Rianápolis'),
(2109551,'MA','Ribamar Fiquene'),
(5007109,'MS','Ribas do Rio Pardo'),
(3542800,'SP','Ribeira'),
(2926509,'BA','Ribeira do Amparo'),
(2208874,'PI','Ribeira do Piauí'),
(2926608,'BA','Ribeira do Pombal'),
(2611804,'PE','Ribeirão'),
(3542909,'SP','Ribeirão Bonito'),
(3543006,'SP','Ribeirão Branco'),
(5107180,'MT','Ribeirão Cascalheira'),
(4121802,'PR','Ribeirão Claro'),
(3543105,'SP','Ribeirão Corrente'),
(3154606,'MG','Ribeirão das Neves'),
(2926657,'BA','Ribeirão do Largo'),
(4121901,'PR','Ribeirão do Pinhal'),
(3543204,'SP','Ribeirão do Sul'),
(3543238,'SP','Ribeirão dos Índios'),
(3543253,'SP','Ribeirão Grande'),
(3543303,'SP','Ribeirão Pires'),
(3543402,'SP','Ribeirão Preto'),
(3154705,'MG','Ribeirão Vermelho'),
(5107198,'MT','Ribeirãozinho'),
(2208908,'PI','Ribeiro Gonçalves'),
(2806008,'SE','Ribeirópolis'),
(3543600,'SP','Rifaina'),
(3543709,'SP','Rincão'),
(3543808,'SP','Rinópolis'),
(3154804,'MG','Rio Acima'),
(4122008,'PR','Rio Azul'),
(3204351,'ES','Rio Bananal'),
(4122107,'PR','Rio Bom'),
(3304300,'RJ','Rio Bonito'),
(4122156,'PR','Rio Bonito do Iguaçu'),
(5107206,'MT','Rio Branco'),
(1200401,'AC','Rio Branco'),
(4122172,'PR','Rio Branco do Ivaí'),
(4122206,'PR','Rio Branco do Sul'),
(5007208,'MS','Rio Brilhante'),
(3154903,'MG','Rio Casca'),
(3304409,'RJ','Rio Claro'),
(3543907,'SP','Rio Claro'),
(1100262,'RO','Rio Crespo'),
(1718659,'TO','Rio da Conceição'),
(4214409,'SC','Rio das Antas'),
(3304508,'RJ','Rio das Flores'),
(3304524,'RJ','Rio das Ostras'),
(3544004,'SP','Rio das Pedras'),
(2926707,'BA','Rio de Contas'),
(3304557,'RJ','Rio de Janeiro'),
(2926806,'BA','Rio do Antônio'),
(4214508,'SC','Rio do Campo'),
(2408953,'RN','Rio do Fogo'),
(4214607,'SC','Rio do Oeste'),
(2926905,'BA','Rio do Pires'),
(3155108,'MG','Rio do Prado'),
(4214805,'SC','Rio do Sul'),
(3155009,'MG','Rio Doce'),
(1718709,'TO','Rio dos Bois'),
(4214706,'SC','Rio dos Cedros'),
(4315552,'RS','Rio dos Índios'),
(3155207,'MG','Rio Espera'),
(2611903,'PE','Rio Formoso'),
(4214904,'SC','Rio Fortuna'),
(4315602,'RS','Rio Grande'),
(3544103,'SP','Rio Grande da Serra'),
(2209005,'PI','Rio Grande do Piauí'),
(2707701,'AL','Rio Largo'),
(3155306,'MG','Rio Manso'),
(1506161,'PA','Rio Maria'),
(4215000,'SC','Rio Negrinho'),
(5007307,'MS','Rio Negro'),
(4122305,'PR','Rio Negro'),
(3155405,'MG','Rio Novo'),
(3204401,'ES','Rio Novo do Sul'),
(3155504,'MG','Rio Paranaíba'),
(4315701,'RS','Rio Pardo'),
(3155603,'MG','Rio Pardo de Minas'),
(3155702,'MG','Rio Piracicaba'),
(3155801,'MG','Rio Pomba'),
(3155900,'MG','Rio Preto'),
(1303569,'AM','Rio Preto da Eva'),
(5218789,'GO','Rio Quente'),
(2927002,'BA','Rio Real'),
(4215059,'SC','Rio Rufino'),
(1718758,'TO','Rio Sono'),
(2512903,'PB','Rio Tinto'),
(5218805,'GO','Rio Verde'),
(5007406,'MS','Rio Verde de Mato Grosso'),
(3156007,'MG','Rio Vermelho'),
(3544202,'SP','Riolândia'),
(4315750,'RS','Riozinho'),
(4215075,'SC','Riqueza'),
(3156106,'MG','Ritápolis'),
(3543501,'SP','Riversul'),
(4315800,'RS','Roca Sales'),
(5007505,'MS','Rochedo'),
(3156205,'MG','Rochedo de Minas'),
(4215109,'SC','Rodeio'),
(4315909,'RS','Rodeio Bonito'),
(3156304,'MG','Rodeiro'),
(2927101,'BA','Rodelas'),
(2411007,'RN','Rodolfo Fernandes'),
(1200427,'AC','Rodrigues Alves'),
(4315958,'RS','Rolador'),
(4122404,'PR','Rolândia'),
(4316006,'RS','Rolante'),
(1100288,'RO','Rolim de Moura'),
(3156403,'MG','Romaria'),
(4215208,'SC','Romelândia'),
(4122503,'PR','Roncador'),
(4316105,'RS','Ronda Alta'),
(4316204,'RS','Rondinha'),
(5107578,'MT','Rondolândia'),
(4122602,'PR','Rondon'),
(1506187,'PA','Rondon do Pará'),
(5107602,'MT','Rondonópolis'),
(4316303,'RS','Roque Gonzales'),
(1400472,'RR','Rorainópolis'),
(3544251,'SP','Rosana'),
(2109601,'MA','Rosário'),
(3156452,'MG','Rosário da Limeira'),
(2806107,'SE','Rosário do Catete'),
(4122651,'PR','Rosário do Ivaí'),
(4316402,'RS','Rosário do Sul'),
(5107701,'MT','Rosário Oeste'),
(3544301,'SP','Roseira'),
(2707800,'AL','Roteiro'),
(3156502,'MG','Rubelita'),
(3544400,'SP','Rubiácea'),
(5218904,'GO','Rubiataba'),
(3156601,'MG','Rubim'),
(3544509,'SP','Rubinéia'),
(1506195,'PA','Rurópolis'),
(2311801,'CE','Russas'),
(2411106,'RN','Ruy Barbosa'),
(2927200,'BA','Ruy Barbosa'),
(3156700,'MG','Sabará'),
(4122701,'PR','Sabáudia'),
(3544608,'SP','Sabino'),
(3156809,'MG','Sabinópolis'),
(2311900,'CE','Saboeiro'),
(3156908,'MG','Sacramento'),
(4316428,'RS','Sagrada Família'),
(3544707,'SP','Sagres'),
(2612000,'PE','Sairé'),
(4316436,'RS','Saldanha Marinho'),
(3544806,'SP','Sales'),
(3544905,'SP','Sales Oliveira'),
(3545001,'SP','Salesópolis'),
(4215307,'SC','Salete'),
(2612109,'PE','Salgadinho'),
(2513000,'PB','Salgadinho'),
(2806206,'SE','Salgado'),
(2513109,'PB','Salgado de São Félix'),
(4122800,'PR','Salgado Filho'),
(2612208,'PE','Salgueiro'),
(3157005,'MG','Salinas'),
(2927309,'BA','Salinas da Margarida'),
(1506203,'PA','Salinópolis'),
(2311959,'CE','Salitre'),
(3545100,'SP','Salmourão'),
(2612307,'PE','Saloá'),
(3545159,'SP','Saltinho'),
(4215356,'SC','Saltinho'),
(3545209,'SP','Salto'),
(3157104,'MG','Salto da Divisa'),
(3545308,'SP','Salto de Pirapora'),
(5107750,'MT','Salto do Céu'),
(4122909,'PR','Salto do Itararé'),
(4316451,'RS','Salto do Jacuí'),
(4123006,'PR','Salto do Lontra'),
(3545407,'SP','Salto Grande'),
(4215406,'SC','Salto Veloso'),
(2927408,'BA','Salvador'),
(4316477,'RS','Salvador das Missões'),
(4316501,'RS','Salvador do Sul'),
(1506302,'PA','Salvaterra'),
(2109700,'MA','Sambaíba'),
(1718808,'TO','Sampaio'),
(4316600,'RS','Sananduva'),
(5219001,'GO','Sanclerlândia'),
(1718840,'TO','Sandolândia'),
(3545506,'SP','Sandovalina'),
(4215455,'SC','Sangão'),
(2612406,'PE','Sanharó'),
(3545605,'SP','Santa Adélia'),
(3545704,'SP','Santa Albertina'),
(4123105,'PR','Santa Amélia'),
(3157203,'MG','Santa Bárbara'),
(2927507,'BA','Santa Bárbara'),
(5219100,'GO','Santa Bárbara de Goiás'),
(3157252,'MG','Santa Bárbara do Leste'),
(3157278,'MG','Santa Bárbara do Monte Verde'),
(1506351,'PA','Santa Bárbara do Pará'),
(4316709,'RS','Santa Bárbara do Sul'),
(3157302,'MG','Santa Bárbara do Tugúrio'),
(3545803,'SP','Santa Bárbara d''Oeste'),
(3546009,'SP','Santa Branca'),
(2927606,'BA','Santa Brígida'),
(5107248,'MT','Santa Carmem'),
(4215505,'SC','Santa Cecília'),
(2513158,'PB','Santa Cecília'),
(4123204,'PR','Santa Cecília do Pavão'),
(4316733,'RS','Santa Cecília do Sul'),
(4316758,'RS','Santa Clara do Sul'),
(3546108,'SP','Santa Clara d''Oeste'),
(2513208,'PB','Santa Cruz'),
(2411205,'RN','Santa Cruz'),
(2612455,'PE','Santa Cruz'),
(2927705,'BA','Santa Cruz Cabrália'),
(2612471,'PE','Santa Cruz da Baixa Verde'),
(3546207,'SP','Santa Cruz da Conceição'),
(3546256,'SP','Santa Cruz da Esperança'),
(2927804,'BA','Santa Cruz da Vitória'),
(3546306,'SP','Santa Cruz das Palmeiras'),
(5219209,'GO','Santa Cruz de Goiás'),
(3157336,'MG','Santa Cruz de Minas'),
(4123303,'PR','Santa Cruz de Monte Castelo'),
(3157377,'MG','Santa Cruz de Salinas'),
(1506401,'PA','Santa Cruz do Arari'),
(2612505,'PE','Santa Cruz do Capibaribe'),
(3157401,'MG','Santa Cruz do Escalvado'),
(2209104,'PI','Santa Cruz do Piauí'),
(3546405,'SP','Santa Cruz do Rio Pardo'),
(4316808,'RS','Santa Cruz do Sul'),
(5107743,'MT','Santa Cruz do Xingu'),
(2209153,'PI','Santa Cruz dos Milagres'),
(3157500,'MG','Santa Efigênia de Minas'),
(3546504,'SP','Santa Ernestina'),
(4123402,'PR','Santa Fé'),
(5219258,'GO','Santa Fé de Goiás'),
(3157609,'MG','Santa Fé de Minas'),
(1718865,'TO','Santa Fé do Araguaia'),
(3546603,'SP','Santa Fé do Sul'),
(2209203,'PI','Santa Filomena'),
(2612554,'PE','Santa Filomena'),
(2109759,'MA','Santa Filomena do Maranhão'),
(3546702,'SP','Santa Gertrudes'),
(4123501,'PR','Santa Helena'),
(4215554,'SC','Santa Helena'),
(2109809,'MA','Santa Helena'),
(2513307,'PB','Santa Helena'),
(5219308,'GO','Santa Helena de Goiás'),
(3157658,'MG','Santa Helena de Minas'),
(4123600,'PR','Santa Inês'),
(2513356,'PB','Santa Inês'),
(2109908,'MA','Santa Inês'),
(2927903,'BA','Santa Inês'),
(3546801,'SP','Santa Isabel'),
(5219357,'GO','Santa Isabel'),
(4123709,'PR','Santa Isabel do Ivaí'),
(1303601,'AM','Santa Isabel do Rio Negro'),
(4123808,'PR','Santa Izabel do Oeste'),
(1506500,'PA','Santa Izabel do Pará'),
(3157708,'MG','Santa Juliana'),
(3204500,'ES','Santa Leopoldina'),
(4123824,'PR','Santa Lúcia'),
(3546900,'SP','Santa Lúcia'),
(2209302,'PI','Santa Luz'),
(2513406,'PB','Santa Luzia'),
(2110005,'MA','Santa Luzia'),
(2928059,'BA','Santa Luzia'),
(3157807,'MG','Santa Luzia'),
(2806305,'SE','Santa Luzia do Itanhy'),
(2707909,'AL','Santa Luzia do Norte'),
(1506559,'PA','Santa Luzia do Pará'),
(2110039,'MA','Santa Luzia do Paruá'),
(1100296,'RO','Santa Luzia D''Oeste'),
(3157906,'MG','Santa Margarida'),
(4316972,'RS','Santa Margarida do Sul'),
(4316907,'RS','Santa Maria'),
(2409332,'RN','Santa Maria'),
(2612604,'PE','Santa Maria da Boa Vista'),
(3547007,'SP','Santa Maria da Serra'),
(2928109,'BA','Santa Maria da Vitória'),
(1506583,'PA','Santa Maria das Barreiras'),
(3158003,'MG','Santa Maria de Itabira'),
(3204559,'ES','Santa Maria de Jetibá'),
(2612703,'PE','Santa Maria do Cambucá'),
(4316956,'RS','Santa Maria do Herval'),
(4123857,'PR','Santa Maria do Oeste'),
(1506609,'PA','Santa Maria do Pará'),
(3158102,'MG','Santa Maria do Salto'),
(3158201,'MG','Santa Maria do Suaçuí'),
(1718881,'TO','Santa Maria do Tocantins'),
(3304607,'RJ','Santa Maria Madalena'),
(4123907,'PR','Santa Mariana'),
(3547106,'SP','Santa Mercedes'),
(4123956,'PR','Santa Mônica'),
(2312205,'CE','Santa Quitéria'),
(2110104,'MA','Santa Quitéria do Maranhão'),
(2110203,'MA','Santa Rita'),
(2513703,'PB','Santa Rita'),
(3159209,'MG','Santa Rita de Caldas'),
(2928406,'BA','Santa Rita de Cássia'),
(3159407,'MG','Santa Rita de Ibitipoca'),
(3159308,'MG','Santa Rita de Jacutinga'),
(3159357,'MG','Santa Rita de Minas'),
(5219407,'GO','Santa Rita do Araguaia'),
(3159506,'MG','Santa Rita do Itueto'),
(5219456,'GO','Santa Rita do Novo Destino'),
(5007554,'MS','Santa Rita do Pardo'),
(3547502,'SP','Santa Rita do Passa Quatro'),
(3159605,'MG','Santa Rita do Sapucaí'),
(1718899,'TO','Santa Rita do Tocantins'),
(5107768,'MT','Santa Rita do Trivelato'),
(3547403,'SP','Santa Rita d''Oeste'),
(4317202,'RS','Santa Rosa'),
(3159704,'MG','Santa Rosa da Serra'),
(5219506,'GO','Santa Rosa de Goiás'),
(4215604,'SC','Santa Rosa de Lima'),
(2806503,'SE','Santa Rosa de Lima'),
(3547601,'SP','Santa Rosa de Viterbo'),
(2209377,'PI','Santa Rosa do Piauí'),
(1200435,'AC','Santa Rosa do Purus'),
(4215653,'SC','Santa Rosa do Sul'),
(1718907,'TO','Santa Rosa do Tocantins'),
(3547650,'SP','Santa Salete'),
(3204609,'ES','Santa Teresa'),
(2513802,'PB','Santa Teresinha'),
(4317251,'RS','Santa Tereza'),
(5219605,'GO','Santa Tereza de Goiás'),
(4124020,'PR','Santa Tereza do Oeste'),
(1719004,'TO','Santa Tereza do Tocantins'),
(2612802,'PE','Santa Terezinha'),
(4215679,'SC','Santa Terezinha'),
(5107776,'MT','Santa Terezinha'),
(2928505,'BA','Santa Terezinha'),
(5219704,'GO','Santa Terezinha de Goiás'),
(4124053,'PR','Santa Terezinha de Itaipu'),
(4215687,'SC','Santa Terezinha do Progresso'),
(1720002,'TO','Santa Terezinha do Tocantins'),
(3159803,'MG','Santa Vitória'),
(4317301,'RS','Santa Vitória do Palmar'),
(2928000,'BA','Santaluz'),
(2928208,'BA','Santana'),
(1600600,'AP','Santana'),
(4317004,'RS','Santana da Boa Vista'),
(3547205,'SP','Santana da Ponte Pensa'),
(3158300,'MG','Santana da Vargem'),
(3158409,'MG','Santana de Cataguases');
INSERT IGNORE INTO cities (id,uf,name) VALUES
(2513505,'PB','Santana de Mangueira'),
(3547304,'SP','Santana de Parnaíba'),
(3158508,'MG','Santana de Pirapama'),
(2312007,'CE','Santana do Acaraú'),
(1506708,'PA','Santana do Araguaia'),
(2312106,'CE','Santana do Cariri'),
(3158607,'MG','Santana do Deserto'),
(3158706,'MG','Santana do Garambéu'),
(2708006,'AL','Santana do Ipanema'),
(4124004,'PR','Santana do Itararé'),
(3158805,'MG','Santana do Jacaré'),
(4317103,'RS','Sant''Ana do Livramento'),
(3158904,'MG','Santana do Manhuaçu'),
(2110237,'MA','Santana do Maranhão'),
(2411403,'RN','Santana do Matos'),
(2708105,'AL','Santana do Mundaú'),
(3158953,'MG','Santana do Paraíso'),
(2209351,'PI','Santana do Piauí'),
(3159001,'MG','Santana do Riacho'),
(2806404,'SE','Santana do São Francisco'),
(2411429,'RN','Santana do Seridó'),
(2513604,'PB','Santana dos Garrotes'),
(3159100,'MG','Santana dos Montes'),
(2928307,'BA','Santanópolis'),
(1506807,'PA','Santarém'),
(1506906,'PA','Santarém Novo'),
(4317400,'RS','Santiago'),
(4215695,'SC','Santiago do Sul'),
(5107263,'MT','Santo Afonso'),
(2928604,'BA','Santo Amaro'),
(4215703,'SC','Santo Amaro da Imperatriz'),
(2806602,'SE','Santo Amaro das Brotas'),
(2110278,'MA','Santo Amaro do Maranhão'),
(3547700,'SP','Santo Anastácio'),
(3547809,'SP','Santo André'),
(2513851,'PB','Santo André'),
(4317509,'RS','Santo Ângelo'),
(2411502,'RN','Santo Antônio'),
(3547908,'SP','Santo Antônio da Alegria'),
(5219712,'GO','Santo Antônio da Barra'),
(4317608,'RS','Santo Antônio da Patrulha'),
(4124103,'PR','Santo Antônio da Platina'),
(4317707,'RS','Santo Antônio das Missões'),
(5219738,'GO','Santo Antônio de Goiás'),
(2928703,'BA','Santo Antônio de Jesus'),
(5107800,'MT','Santo Antônio de Leverger'),
(2209401,'PI','Santo Antônio de Lisboa'),
(3304706,'RJ','Santo Antônio de Pádua'),
(3548005,'SP','Santo Antônio de Posse'),
(3159902,'MG','Santo Antônio do Amparo'),
(3548054,'SP','Santo Antônio do Aracanguá'),
(3160009,'MG','Santo Antônio do Aventureiro'),
(4124202,'PR','Santo Antônio do Caiuá'),
(5219753,'GO','Santo Antônio do Descoberto'),
(3160108,'MG','Santo Antônio do Grama'),
(1303700,'AM','Santo Antônio do Içá'),
(3160207,'MG','Santo Antônio do Itambé'),
(3160306,'MG','Santo Antônio do Jacinto'),
(3548104,'SP','Santo Antônio do Jardim'),
(5107792,'MT','Santo Antônio do Leste'),
(3160405,'MG','Santo Antônio do Monte'),
(4317558,'RS','Santo Antônio do Palma'),
(4124301,'PR','Santo Antônio do Paraíso'),
(3548203,'SP','Santo Antônio do Pinhal'),
(4317756,'RS','Santo Antônio do Planalto'),
(3160454,'MG','Santo Antônio do Retiro'),
(3160504,'MG','Santo Antônio do Rio Abaixo'),
(4124400,'PR','Santo Antônio do Sudoeste'),
(1507003,'PA','Santo Antônio do Tauá'),
(2110302,'MA','Santo Antônio dos Lopes'),
(2209450,'PI','Santo Antônio dos Milagres'),
(4317806,'RS','Santo Augusto'),
(4317905,'RS','Santo Cristo'),
(2928802,'BA','Santo Estêvão'),
(3548302,'SP','Santo Expedito'),
(4317954,'RS','Santo Expedito do Sul'),
(3160603,'MG','Santo Hipólito'),
(4124509,'PR','Santo Inácio'),
(2209500,'PI','Santo Inácio do Piauí'),
(3548401,'SP','Santópolis do Aguapeí'),
(3548500,'SP','Santos'),
(3160702,'MG','Santos Dumont'),
(2312304,'CE','São Benedito'),
(2110401,'MA','São Benedito do Rio Preto'),
(2612901,'PE','São Benedito do Sul'),
(2513927,'PB','São Bentinho'),
(2513901,'PB','São Bento'),
(2110500,'MA','São Bento'),
(3160801,'MG','São Bento Abade'),
(2411601,'RN','São Bento do Norte'),
(3548609,'SP','São Bento do Sapucaí'),
(4215802,'SC','São Bento do Sul'),
(1720101,'TO','São Bento do Tocantins'),
(2411700,'RN','São Bento do Trairí'),
(2613008,'PE','São Bento do Una'),
(4215752,'SC','São Bernardino'),
(2110609,'MA','São Bernardo'),
(3548708,'SP','São Bernardo do Campo'),
(4215901,'SC','São Bonifácio'),
(4318002,'RS','São Borja'),
(2708204,'AL','São Brás'),
(3160900,'MG','São Brás do Suaçuí'),
(2209559,'PI','São Braz do Piauí'),
(1507102,'PA','São Caetano de Odivelas'),
(3548807,'SP','São Caetano do Sul'),
(2613107,'PE','São Caitano'),
(3548906,'SP','São Carlos'),
(4216008,'SC','São Carlos'),
(4124608,'PR','São Carlos do Ivaí'),
(2806701,'SE','São Cristóvão'),
(4216057,'SC','São Cristóvão do Sul'),
(2928901,'BA','São Desidério'),
(2928950,'BA','São Domingos'),
(4216107,'SC','São Domingos'),
(5219803,'GO','São Domingos'),
(2806800,'SE','São Domingos'),
(2513968,'PB','São Domingos'),
(3160959,'MG','São Domingos das Dores'),
(1507151,'PA','São Domingos do Araguaia'),
(2110658,'MA','São Domingos do Azeitão'),
(1507201,'PA','São Domingos do Capim'),
(2513943,'PB','São Domingos do Cariri'),
(2110708,'MA','São Domingos do Maranhão'),
(3204658,'ES','São Domingos do Norte'),
(3161007,'MG','São Domingos do Prata'),
(4318051,'RS','São Domingos do Sul'),
(2929107,'BA','São Felipe'),
(1101484,'RO','São Felipe D''Oeste'),
(2929008,'BA','São Félix'),
(2110807,'MA','São Félix de Balsas'),
(3161056,'MG','São Félix de Minas'),
(5107859,'MT','São Félix do Araguaia'),
(2929057,'BA','São Félix do Coribe'),
(2209609,'PI','São Félix do Piauí'),
(1720150,'TO','São Félix do Tocantins'),
(1507300,'PA','São Félix do Xingu'),
(2411809,'RN','São Fernando'),
(3304805,'RJ','São Fidélis'),
(3549003,'SP','São Francisco'),
(3161106,'MG','São Francisco'),
(2806909,'SE','São Francisco'),
(2513984,'PB','São Francisco'),
(4318101,'RS','São Francisco de Assis'),
(2209658,'PI','São Francisco de Assis do Piauí'),
(5219902,'GO','São Francisco de Goiás'),
(3304755,'RJ','São Francisco de Itabapoana'),
(3161205,'MG','São Francisco de Paula'),
(4318200,'RS','São Francisco de Paula'),
(3161304,'MG','São Francisco de Sales'),
(2110856,'MA','São Francisco do Brejão'),
(2929206,'BA','São Francisco do Conde'),
(3161403,'MG','São Francisco do Glória'),
(1101492,'RO','São Francisco do Guaporé'),
(2110906,'MA','São Francisco do Maranhão'),
(2411908,'RN','São Francisco do Oeste'),
(1507409,'PA','São Francisco do Pará'),
(2209708,'PI','São Francisco do Piauí'),
(4216206,'SC','São Francisco do Sul'),
(4318309,'RS','São Gabriel'),
(2929255,'BA','São Gabriel'),
(1303809,'AM','São Gabriel da Cachoeira'),
(3204708,'ES','São Gabriel da Palha'),
(5007695,'MS','São Gabriel do Oeste'),
(3161502,'MG','São Geraldo'),
(3161601,'MG','São Geraldo da Piedade'),
(1507458,'PA','São Geraldo do Araguaia'),
(3161650,'MG','São Geraldo do Baixio'),
(3304904,'RJ','São Gonçalo'),
(3161700,'MG','São Gonçalo do Abaeté'),
(2312403,'CE','São Gonçalo do Amarante'),
(2412005,'RN','São Gonçalo do Amarante'),
(2209757,'PI','São Gonçalo do Gurguéia'),
(3161809,'MG','São Gonçalo do Pará'),
(2209807,'PI','São Gonçalo do Piauí'),
(3161908,'MG','São Gonçalo do Rio Abaixo'),
(3125507,'MG','São Gonçalo do Rio Preto'),
(3162005,'MG','São Gonçalo do Sapucaí'),
(2929305,'BA','São Gonçalo dos Campos'),
(3162104,'MG','São Gotardo'),
(4318408,'RS','São Jerônimo'),
(4124707,'PR','São Jerônimo da Serra'),
(4124806,'PR','São João'),
(2613206,'PE','São João'),
(2111003,'MA','São João Batista'),
(4216305,'SC','São João Batista'),
(3162203,'MG','São João Batista do Glória'),
(1400506,'RR','São João da Baliza'),
(3305000,'RJ','São João da Barra'),
(3549102,'SP','São João da Boa Vista'),
(2209856,'PI','São João da Canabrava'),
(2209872,'PI','São João da Fronteira'),
(3162252,'MG','São João da Lagoa'),
(3162302,'MG','São João da Mata'),
(5220058,'GO','São João da Paraúna'),
(1507466,'PA','São João da Ponta'),
(3162401,'MG','São João da Ponte'),
(2209906,'PI','São João da Serra'),
(4318424,'RS','São João da Urtiga'),
(2209955,'PI','São João da Varjota'),
(5220009,'GO','São João d''Aliança'),
(3549201,'SP','São João das Duas Pontes'),
(3162450,'MG','São João das Missões'),
(3549250,'SP','São João de Iracema'),
(3305109,'RJ','São João de Meriti'),
(1507474,'PA','São João de Pirabas'),
(3162500,'MG','São João del Rei'),
(1507508,'PA','São João do Araguaia'),
(2209971,'PI','São João do Arraial'),
(4124905,'PR','São João do Caiuá'),
(2514008,'PB','São João do Cariri'),
(2111029,'MA','São João do Carú'),
(4216354,'SC','São João do Itaperiú'),
(4125001,'PR','São João do Ivaí'),
(2312502,'CE','São João do Jaguaribe'),
(3162559,'MG','São João do Manhuaçu'),
(3162575,'MG','São João do Manteninha'),
(4216255,'SC','São João do Oeste'),
(3162609,'MG','São João do Oriente'),
(3162658,'MG','São João do Pacuí'),
(3162708,'MG','São João do Paraíso'),
(2111052,'MA','São João do Paraíso'),
(3549300,'SP','São João do Pau d''Alho'),
(2210003,'PI','São João do Piauí'),
(4318432,'RS','São João do Polêsine'),
(2500700,'PB','São João do Rio do Peixe'),
(2412104,'RN','São João do Sabugi'),
(2111078,'MA','São João do Soter'),
(4216404,'SC','São João do Sul'),
(2514107,'PB','São João do Tigre'),
(4125100,'PR','São João do Triunfo'),
(2111102,'MA','São João dos Patos'),
(3162807,'MG','São João Evangelista'),
(3162906,'MG','São João Nepomuceno'),
(4216503,'SC','São Joaquim'),
(3549409,'SP','São Joaquim da Barra'),
(3162922,'MG','São Joaquim de Bicas'),
(2613305,'PE','São Joaquim do Monte'),
(4318440,'RS','São Jorge'),
(4125308,'PR','São Jorge do Ivaí'),
(4125357,'PR','São Jorge do Patrocínio'),
(4125209,'PR','São Jorge d''Oeste'),
(4216602,'SC','São José'),
(3162948,'MG','São José da Barra'),
(3549508,'SP','São José da Bela Vista'),
(4125407,'PR','São José da Boa Vista'),
(2613404,'PE','São José da Coroa Grande'),
(2514206,'PB','São José da Lagoa Tapada'),
(2708303,'AL','São José da Laje'),
(3162955,'MG','São José da Lapa'),
(3163003,'MG','São José da Safira'),
(2708402,'AL','São José da Tapera'),
(3163102,'MG','São José da Varginha'),
(2929354,'BA','São José da Vitória'),
(4318457,'RS','São José das Missões'),
(4125456,'PR','São José das Palmeiras'),
(2514305,'PB','São José de Caiana'),
(2514404,'PB','São José de Espinharas'),
(2412203,'RN','São José de Mipibu'),
(2514503,'PB','São José de Piranhas'),
(2514552,'PB','São José de Princesa'),
(2111201,'MA','São José de Ribamar'),
(3305133,'RJ','São José de Ubá'),
(3163201,'MG','São José do Alegre'),
(3549607,'SP','São José do Barreiro'),
(2613503,'PE','São José do Belmonte'),
(2514602,'PB','São José do Bonfim'),
(2514651,'PB','São José do Brejo do Cruz'),
(3204807,'ES','São José do Calçado'),
(2412302,'RN','São José do Campestre'),
(4216701,'SC','São José do Cedro'),
(4216800,'SC','São José do Cerrito'),
(3163300,'MG','São José do Divino'),
(2210052,'PI','São José do Divino'),
(2613602,'PE','São José do Egito'),
(3163409,'MG','São José do Goiabal'),
(4318465,'RS','São José do Herval'),
(4318481,'RS','São José do Hortêncio'),
(4318499,'RS','São José do Inhacorá'),
(2929370,'BA','São José do Jacuípe'),
(3163508,'MG','São José do Jacuri'),
(3163607,'MG','São José do Mantimento'),
(4318507,'RS','São José do Norte'),
(4318606,'RS','São José do Ouro'),
(2210102,'PI','São José do Peixe'),
(2210201,'PI','São José do Piauí'),
(5107297,'MT','São José do Povo'),
(5107305,'MT','São José do Rio Claro'),
(3549706,'SP','São José do Rio Pardo'),
(3549805,'SP','São José do Rio Preto'),
(2514701,'PB','São José do Sabugi'),
(2412401,'RN','São José do Seridó'),
(4318614,'RS','São José do Sul'),
(3305158,'RJ','São José do Vale do Rio Preto'),
(5107354,'MT','São José do Xingu'),
(4318622,'RS','São José dos Ausentes'),
(2111250,'MA','São José dos Basílios'),
(3549904,'SP','São José dos Campos'),
(2514800,'PB','São José dos Cordeiros'),
(4125506,'PR','São José dos Pinhais'),
(5107107,'MT','São José dos Quatro Marcos'),
(2514453,'PB','São José dos Ramos'),
(2210300,'PI','São Julião'),
(4318705,'RS','São Leopoldo'),
(3163706,'MG','São Lourenço'),
(2613701,'PE','São Lourenço da Mata'),
(3549953,'SP','São Lourenço da Serra'),
(4216909,'SC','São Lourenço do Oeste'),
(2210359,'PI','São Lourenço do Piauí'),
(4318804,'RS','São Lourenço do Sul'),
(4217006,'SC','São Ludgero'),
(2111300,'MA','São Luís'),
(5220108,'GO','São Luís de Montes Belos'),
(2312601,'CE','São Luís do Curu'),
(2210375,'PI','São Luis do Piauí'),
(2708501,'AL','São Luís do Quitunde'),
(2111409,'MA','São Luís Gonzaga do Maranhão'),
(1400605,'RR','São Luiz do Anauá'),
(5220157,'GO','São Luiz do Norte'),
(3550001,'SP','São Luiz do Paraitinga'),
(4318903,'RS','São Luiz Gonzaga'),
(2514909,'PB','São Mamede'),
(4125555,'PR','São Manoel do Paraná'),
(3550100,'SP','São Manuel'),
(4319000,'RS','São Marcos'),
(4319109,'RS','São Martinho'),
(4217105,'SC','São Martinho'),
(4319125,'RS','São Martinho da Serra'),
(3204906,'ES','São Mateus'),
(2111508,'MA','São Mateus do Maranhão'),
(4125605,'PR','São Mateus do Sul'),
(2412500,'RN','São Miguel'),
(3550209,'SP','São Miguel Arcanjo'),
(2210383,'PI','São Miguel da Baixa Grande'),
(4217154,'SC','São Miguel da Boa Vista'),
(2929404,'BA','São Miguel das Matas'),
(4319158,'RS','São Miguel das Missões'),
(2515005,'PB','São Miguel de Taipu'),
(2807006,'SE','São Miguel do Aleixo'),
(3163805,'MG','São Miguel do Anta'),
(5220207,'GO','São Miguel do Araguaia'),
(2210391,'PI','São Miguel do Fidalgo'),
(2412559,'RN','São Miguel do Gostoso'),
(1507607,'PA','São Miguel do Guamá'),
(1100320,'RO','São Miguel do Guaporé'),
(4125704,'PR','São Miguel do Iguaçu'),
(4217204,'SC','São Miguel do Oeste'),
(5220264,'GO','São Miguel do Passa Quatro'),
(2210409,'PI','São Miguel do Tapuio'),
(1720200,'TO','São Miguel do Tocantins'),
(2708600,'AL','São Miguel dos Campos'),
(2708709,'AL','São Miguel dos Milagres'),
(4319208,'RS','São Nicolau'),
(5220280,'GO','São Patrício'),
(3550308,'SP','São Paulo'),
(4319307,'RS','São Paulo das Missões'),
(1303908,'AM','São Paulo de Olivença'),
(2412609,'RN','São Paulo do Potengi'),
(2412708,'RN','São Pedro'),
(3550407,'SP','São Pedro'),
(2111532,'MA','São Pedro da Água Branca'),
(3305208,'RJ','São Pedro da Aldeia'),
(5107404,'MT','São Pedro da Cipa'),
(4319356,'RS','São Pedro da Serra'),
(3163904,'MG','São Pedro da União'),
(4319364,'RS','São Pedro das Missões'),
(4217253,'SC','São Pedro de Alcântara'),
(4319372,'RS','São Pedro do Butiá'),
(4125753,'PR','São Pedro do Iguaçu'),
(4125803,'PR','São Pedro do Ivaí'),
(4125902,'PR','São Pedro do Paraná'),
(2210508,'PI','São Pedro do Piauí'),
(3164100,'MG','São Pedro do Suaçuí'),
(4319406,'RS','São Pedro do Sul'),
(3550506,'SP','São Pedro do Turvo'),
(2111573,'MA','São Pedro dos Crentes'),
(3164001,'MG','São Pedro dos Ferros'),
(2412807,'RN','São Rafael'),
(2111607,'MA','São Raimundo das Mangabeiras'),
(2111631,'MA','São Raimundo do Doca Bezerra'),
(2210607,'PI','São Raimundo Nonato'),
(2111672,'MA','São Roberto'),
(3164209,'MG','São Romão'),
(3550605,'SP','São Roque'),
(3164308,'MG','São Roque de Minas'),
(3204955,'ES','São Roque do Canaã'),
(1720259,'TO','São Salvador do Tocantins'),
(2708808,'AL','São Sebastião'),
(3550704,'SP','São Sebastião'),
(4126009,'PR','São Sebastião da Amoreira'),
(3164407,'MG','São Sebastião da Bela Vista'),
(1507706,'PA','São Sebastião da Boa Vista'),
(3550803,'SP','São Sebastião da Grama'),
(3164431,'MG','São Sebastião da Vargem Alegre'),
(2515104,'PB','São Sebastião de Lagoa de Roça'),
(3305307,'RJ','São Sebastião do Alto'),
(3164472,'MG','São Sebastião do Anta'),
(4319505,'RS','São Sebastião do Caí'),
(3164506,'MG','São Sebastião do Maranhão'),
(3164605,'MG','São Sebastião do Oeste'),
(3164704,'MG','São Sebastião do Paraíso'),
(2929503,'BA','São Sebastião do Passé'),
(3164803,'MG','São Sebastião do Rio Preto'),
(3164902,'MG','São Sebastião do Rio Verde'),
(1720309,'TO','São Sebastião do Tocantins'),
(1303957,'AM','São Sebastião do Uatumã'),
(2515203,'PB','São Sebastião do Umbuzeiro'),
(4319604,'RS','São Sepé'),
(5220405,'GO','São Simão'),
(3550902,'SP','São Simão'),
(3165008,'MG','São Tiago'),
(3165107,'MG','São Tomás de Aquino'),
(4126108,'PR','São Tomé'),
(2412906,'RN','São Tomé'),
(3165206,'MG','São Tomé das Letras'),
(4319703,'RS','São Valentim'),
(4319711,'RS','São Valentim do Sul'),
(1720499,'TO','São Valério'),
(4319737,'RS','São Valério do Sul'),
(4319752,'RS','São Vendelino'),
(3551009,'SP','São Vicente'),
(2413003,'RN','São Vicente'),
(3165305,'MG','São Vicente de Minas'),
(2515401,'PB','São Vicente do Seridó'),
(4319802,'RS','São Vicente do Sul'),
(2111706,'MA','São Vicente Ferrer'),
(2613800,'PE','São Vicente Férrer'),
(2515302,'PB','Sapé'),
(2929602,'BA','Sapeaçu'),
(5107875,'MT','Sapezal'),
(4319901,'RS','Sapiranga'),
(4126207,'PR','Sapopema'),
(3305406,'RJ','Sapucaia'),
(1507755,'PA','Sapucaia'),
(4320008,'RS','Sapucaia do Sul'),
(3165404,'MG','Sapucaí-Mirim'),
(3305505,'RJ','Saquarema'),
(4320107,'RS','Sarandi'),
(4126256,'PR','Sarandi'),
(3551108,'SP','Sarapuí'),
(3165503,'MG','Sardoá'),
(3551207,'SP','Sarutaiá'),
(3165537,'MG','Sarzedo'),
(2929701,'BA','Sátiro Dias'),
(2708907,'AL','Satuba'),
(2111722,'MA','Satubinha'),
(2929750,'BA','Saubara'),
(4126272,'PR','Saudade do Iguaçu'),
(4217303,'SC','Saudades'),
(2929800,'BA','Saúde'),
(4217402,'SC','Schroeder'),
(2929909,'BA','Seabra'),
(4217501,'SC','Seara'),
(3551306,'SP','Sebastianópolis do Sul'),
(2210623,'PI','Sebastião Barros'),
(2930006,'BA','Sebastião Laranjeiras'),
(2210631,'PI','Sebastião Leal'),
(4320206,'RS','Seberi'),
(4320230,'RS','Sede Nova'),
(4320263,'RS','Segredo'),
(4320305,'RS','Selbach'),
(5007802,'MS','Selvíria'),
(3165560,'MG','Sem-Peixe'),
(1200500,'AC','Sena Madureira'),
(2111748,'MA','Senador Alexandre Costa'),
(3165578,'MG','Senador Amaral'),
(5220454,'GO','Senador Canedo'),
(3165602,'MG','Senador Cortes'),
(2413102,'RN','Senador Elói de Souza'),
(3165701,'MG','Senador Firmino'),
(2413201,'RN','Senador Georgino Avelino'),
(1200450,'AC','Senador Guiomard'),
(3165800,'MG','Senador José Bento'),
(1507805,'PA','Senador José Porfírio'),
(2111763,'MA','Senador La Rocque'),
(3165909,'MG','Senador Modestino Gonçalves'),
(2312700,'CE','Senador Pompeu'),
(2708956,'AL','Senador Rui Palmeira'),
(2312809,'CE','Senador Sá'),
(4320321,'RS','Senador Salgado Filho'),
(4126306,'PR','Sengés'),
(2930105,'BA','Senhor do Bonfim'),
(3166006,'MG','Senhora de Oliveira'),
(3166105,'MG','Senhora do Porto'),
(3166204,'MG','Senhora dos Remédios'),
(4320354,'RS','Sentinela do Sul'),
(2930204,'BA','Sento Sé'),
(4320404,'RS','Serafina Corrêa'),
(3166303,'MG','Sericita'),
(1101500,'RO','Seringueiras'),
(4320453,'RS','Sério'),
(3166402,'MG','Seritinga'),
(3305554,'RJ','Seropédica'),
(3205002,'ES','Serra'),
(4217550,'SC','Serra Alta'),
(3551405,'SP','Serra Azul'),
(3166501,'MG','Serra Azul de Minas'),
(2515500,'PB','Serra Branca'),
(2410306,'RN','Serra Caiada'),
(2515609,'PB','Serra da Raiz'),
(3166600,'MG','Serra da Saudade');
INSERT IGNORE INTO cities (id,uf,name) VALUES
(2413300,'RN','Serra de São Bento'),
(2413359,'RN','Serra do Mel'),
(1600055,'AP','Serra do Navio'),
(2930154,'BA','Serra do Ramalho'),
(3166808,'MG','Serra do Salitre'),
(3166709,'MG','Serra dos Aimorés'),
(2930303,'BA','Serra Dourada'),
(2515708,'PB','Serra Grande'),
(3551603,'SP','Serra Negra'),
(2413409,'RN','Serra Negra do Norte'),
(5107883,'MT','Serra Nova Dourada'),
(2930402,'BA','Serra Preta'),
(2515807,'PB','Serra Redonda'),
(2613909,'PE','Serra Talhada'),
(3551504,'SP','Serrana'),
(3166907,'MG','Serrania'),
(2111789,'MA','Serrano do Maranhão'),
(5220504,'GO','Serranópolis'),
(3166956,'MG','Serranópolis de Minas'),
(4126355,'PR','Serranópolis do Iguaçu'),
(3167004,'MG','Serranos'),
(2515906,'PB','Serraria'),
(2930501,'BA','Serrinha'),
(2413508,'RN','Serrinha'),
(2413557,'RN','Serrinha dos Pintos'),
(2614006,'PE','Serrita'),
(3167103,'MG','Serro'),
(2930600,'BA','Serrolândia'),
(4126405,'PR','Sertaneja'),
(2614105,'PE','Sertânia'),
(4126504,'PR','Sertanópolis'),
(4320503,'RS','Sertão'),
(4320552,'RS','Sertão Santana'),
(3551702,'SP','Sertãozinho'),
(2515930,'PB','Sertãozinho'),
(3551801,'SP','Sete Barras'),
(4320578,'RS','Sete de Setembro'),
(3167202,'MG','Sete Lagoas'),
(5007703,'MS','Sete Quedas'),
(3165552,'MG','Setubinha'),
(4320602,'RS','Severiano de Almeida'),
(2413607,'RN','Severiano Melo'),
(3551900,'SP','Severínia'),
(4217600,'SC','Siderópolis'),
(5007901,'MS','Sidrolândia'),
(2210656,'PI','Sigefredo Pacheco'),
(3305604,'RJ','Silva Jardim'),
(5220603,'GO','Silvânia'),
(1720655,'TO','Silvanópolis'),
(4320651,'RS','Silveira Martins'),
(3167301,'MG','Silveirânia'),
(3552007,'SP','Silveiras'),
(1304005,'AM','Silves'),
(3167400,'MG','Silvianópolis'),
(2807105,'SE','Simão Dias'),
(3167509,'MG','Simão Pereira'),
(2210706,'PI','Simões'),
(2930709,'BA','Simões Filho'),
(5220686,'GO','Simolândia'),
(3167608,'MG','Simonésia'),
(2210805,'PI','Simplício Mendes'),
(4320677,'RS','Sinimbu'),
(5107909,'MT','Sinop'),
(4126603,'PR','Siqueira Campos'),
(2614204,'PE','Sirinhaém'),
(2807204,'SE','Siriri'),
(5220702,'GO','Sítio d''Abadia'),
(2930758,'BA','Sítio do Mato'),
(2930766,'BA','Sítio do Quinto'),
(2413706,'RN','Sítio Novo'),
(2111805,'MA','Sítio Novo'),
(1720804,'TO','Sítio Novo do Tocantins'),
(2930774,'BA','Sobradinho'),
(4320701,'RS','Sobradinho'),
(2515971,'PB','Sobrado'),
(2312908,'CE','Sobral'),
(3167707,'MG','Sobrália'),
(3552106,'SP','Socorro'),
(2210904,'PI','Socorro do Piauí'),
(2516003,'PB','Solânea'),
(2516102,'PB','Soledade'),
(4320800,'RS','Soledade'),
(3167806,'MG','Soledade de Minas'),
(2614402,'PE','Solidão'),
(2313005,'CE','Solonópole'),
(4217709,'SC','Sombrio'),
(5007935,'MS','Sonora'),
(3205010,'ES','Sooretama'),
(3552205,'SP','Sorocaba'),
(5107925,'MT','Sorriso'),
(2516151,'PB','Sossêgo'),
(1507904,'PA','Soure'),
(2516201,'PB','Sousa'),
(2930808,'BA','Souto Soares'),
(1720853,'TO','Sucupira'),
(2111904,'MA','Sucupira do Norte'),
(2111953,'MA','Sucupira do Riachão'),
(3552304,'SP','Sud Mennucci'),
(4217758,'SC','Sul Brasil'),
(4126652,'PR','Sulina'),
(3552403,'SP','Sumaré'),
(2516300,'PB','Sumé'),
(3305703,'RJ','Sumidouro'),
(2614501,'PE','Surubim'),
(2210938,'PI','Sussuapara'),
(3552551,'SP','Suzanápolis'),
(3552502,'SP','Suzano'),
(4320859,'RS','Tabaí'),
(5107941,'MT','Tabaporã'),
(3552601,'SP','Tabapuã'),
(3552700,'SP','Tabatinga'),
(1304062,'AM','Tabatinga'),
(2614600,'PE','Tabira'),
(3552809,'SP','Taboão da Serra'),
(1708254,'TO','Tabocão'),
(2930907,'BA','Tabocas do Brejo Velho'),
(2413805,'RN','Taboleiro Grande'),
(3167905,'MG','Tabuleiro'),
(2313104,'CE','Tabuleiro do Norte'),
(2614709,'PE','Tacaimbó'),
(2614808,'PE','Tacaratu'),
(3552908,'SP','Taciba'),
(2516409,'PB','Tacima'),
(5007950,'MS','Tacuru'),
(3553005,'SP','Taguaí'),
(1720903,'TO','Taguatinga'),
(3553104,'SP','Taiaçu'),
(1507953,'PA','Tailândia'),
(4217808,'SC','Taió'),
(3168002,'MG','Taiobeiras'),
(1720937,'TO','Taipas do Tocantins'),
(2413904,'RN','Taipu'),
(3553203,'SP','Taiúva'),
(1720978,'TO','Talismã'),
(2614857,'PE','Tamandaré'),
(4126678,'PR','Tamarana'),
(3553302,'SP','Tambaú'),
(4126702,'PR','Tamboara'),
(2313203,'CE','Tamboril'),
(2210953,'PI','Tamboril do Piauí'),
(3553401,'SP','Tanabi'),
(4217907,'SC','Tangará'),
(2414001,'RN','Tangará'),
(5107958,'MT','Tangará da Serra'),
(3305752,'RJ','Tanguá'),
(2931004,'BA','Tanhaçu'),
(2709004,'AL','Tanque d''Arca'),
(2210979,'PI','Tanque do Piauí'),
(2931053,'BA','Tanque Novo'),
(2931103,'BA','Tanquinho'),
(3168051,'MG','Taparuba'),
(1304104,'AM','Tapauá'),
(4320909,'RS','Tapejara'),
(4126801,'PR','Tapejara'),
(4321006,'RS','Tapera'),
(2931202,'BA','Taperoá'),
(2516508,'PB','Taperoá'),
(4321105,'RS','Tapes'),
(4126900,'PR','Tapira'),
(3168101,'MG','Tapira'),
(3168200,'MG','Tapiraí'),
(3553500,'SP','Tapiraí'),
(2931301,'BA','Tapiramutá'),
(3553609,'SP','Tapiratiba'),
(5108006,'MT','Tapurah'),
(4321204,'RS','Taquara'),
(3168309,'MG','Taquaraçu de Minas'),
(3553658,'SP','Taquaral'),
(5221007,'GO','Taquaral de Goiás'),
(2709103,'AL','Taquarana'),
(4321303,'RS','Taquari'),
(3553708,'SP','Taquaritinga'),
(2615003,'PE','Taquaritinga do Norte'),
(3553807,'SP','Taquarituba'),
(3553856,'SP','Taquarivaí'),
(4321329,'RS','Taquaruçu do Sul'),
(5007976,'MS','Taquarussu'),
(3553906,'SP','Tarabai'),
(1200609,'AC','Tarauacá'),
(2313252,'CE','Tarrafas'),
(1600709,'AP','Tartarugalzinho'),
(3553955,'SP','Tarumã'),
(3168408,'MG','Tarumirim'),
(2112001,'MA','Tasso Fragoso'),
(3554003,'SP','Tatuí'),
(2313302,'CE','Tauá'),
(3554102,'SP','Taubaté'),
(4321352,'RS','Tavares'),
(2516607,'PB','Tavares'),
(1304203,'AM','Tefé'),
(2516706,'PB','Teixeira'),
(2931350,'BA','Teixeira de Freitas'),
(4127007,'PR','Teixeira Soares'),
(3168507,'MG','Teixeiras'),
(1101559,'RO','Teixeirópolis'),
(2313351,'CE','Tejuçuoca'),
(3554201,'SP','Tejupá'),
(4127106,'PR','Telêmaco Borba'),
(2807303,'SE','Telha'),
(2414100,'RN','Tenente Ananias'),
(2414159,'RN','Tenente Laurentino Cruz'),
(4321402,'RS','Tenente Portela'),
(2516755,'PB','Tenório'),
(2931400,'BA','Teodoro Sampaio'),
(3554300,'SP','Teodoro Sampaio'),
(2931509,'BA','Teofilândia'),
(3168606,'MG','Teófilo Otoni'),
(2931608,'BA','Teolândia'),
(2709152,'AL','Teotônio Vilela'),
(5008008,'MS','Terenos'),
(2211001,'PI','Teresina'),
(5221080,'GO','Teresina de Goiás'),
(3305802,'RJ','Teresópolis'),
(2615102,'PE','Terezinha'),
(5221197,'GO','Terezópolis de Goiás'),
(1507961,'PA','Terra Alta'),
(4127205,'PR','Terra Boa'),
(4321436,'RS','Terra de Areia'),
(2615201,'PE','Terra Nova'),
(2931707,'BA','Terra Nova'),
(5108055,'MT','Terra Nova do Norte'),
(4127304,'PR','Terra Rica'),
(4127403,'PR','Terra Roxa'),
(3554409,'SP','Terra Roxa'),
(1507979,'PA','Terra Santa'),
(5108105,'MT','Tesouro'),
(4321451,'RS','Teutônia'),
(1101609,'RO','Theobroma'),
(2313401,'CE','Tianguá'),
(4127502,'PR','Tibagi'),
(2411056,'RN','Tibau'),
(2414209,'RN','Tibau do Sul'),
(3554508,'SP','Tietê'),
(4217956,'SC','Tigrinhos'),
(4218004,'SC','Tijucas'),
(4127601,'PR','Tijucas do Sul'),
(2615300,'PE','Timbaúba'),
(2414308,'RN','Timbaúba dos Batistas'),
(4218103,'SC','Timbé do Sul'),
(2112100,'MA','Timbiras'),
(4218202,'SC','Timbó'),
(4218251,'SC','Timbó Grande'),
(3554607,'SP','Timburi'),
(2112209,'MA','Timon'),
(3168705,'MG','Timóteo'),
(4321469,'RS','Tio Hugo'),
(3168804,'MG','Tiradentes'),
(4321477,'RS','Tiradentes do Sul'),
(3168903,'MG','Tiros'),
(2807402,'SE','Tobias Barreto'),
(1721109,'TO','Tocantínia'),
(1721208,'TO','Tocantinópolis'),
(3169000,'MG','Tocantins'),
(3169059,'MG','Tocos do Moji'),
(3169109,'MG','Toledo'),
(4127700,'PR','Toledo'),
(2807501,'SE','Tomar do Geru'),
(4127809,'PR','Tomazina'),
(3169208,'MG','Tombos'),
(1508001,'PA','Tomé-Açu'),
(1304237,'AM','Tonantins'),
(2615409,'PE','Toritama'),
(5108204,'MT','Torixoréu'),
(4321493,'RS','Toropi'),
(3554656,'SP','Torre de Pedra'),
(4321501,'RS','Torres'),
(3554706,'SP','Torrinha'),
(2414407,'RN','Touros'),
(3554755,'SP','Trabiju'),
(1508035,'PA','Tracuateua'),
(2615508,'PE','Tracunhaém'),
(2709202,'AL','Traipu'),
(1508050,'PA','Trairão'),
(2313500,'CE','Trairi'),
(3305901,'RJ','Trajano de Moraes'),
(4321600,'RS','Tramandaí'),
(4321626,'RS','Travesseiro'),
(2931806,'BA','Tremedal'),
(3554805,'SP','Tremembé'),
(4321634,'RS','Três Arroios'),
(4218301,'SC','Três Barras'),
(4127858,'PR','Três Barras do Paraná'),
(4321667,'RS','Três Cachoeiras'),
(3169307,'MG','Três Corações'),
(4321709,'RS','Três Coroas'),
(4321808,'RS','Três de Maio'),
(4321832,'RS','Três Forquilhas'),
(3554904,'SP','Três Fronteiras'),
(5008305,'MS','Três Lagoas'),
(3169356,'MG','Três Marias'),
(4321857,'RS','Três Palmeiras'),
(4321907,'RS','Três Passos'),
(3169406,'MG','Três Pontas'),
(5221304,'GO','Três Ranchos'),
(3306008,'RJ','Três Rios'),
(4218350,'SC','Treviso'),
(4218400,'SC','Treze de Maio'),
(4218509,'SC','Treze Tílias'),
(5221403,'GO','Trindade'),
(2615607,'PE','Trindade'),
(4321956,'RS','Trindade do Sul'),
(4322004,'RS','Triunfo'),
(2615706,'PE','Triunfo'),
(2516805,'PB','Triunfo'),
(2414456,'RN','Triunfo Potiguar'),
(2112233,'MA','Trizidela do Vale'),
(5221452,'GO','Trombas'),
(4218608,'SC','Trombudo Central'),
(4218707,'SC','Tubarão'),
(2931905,'BA','Tucano'),
(1508084,'PA','Tucumã'),
(4322103,'RS','Tucunduva'),
(1508100,'PA','Tucuruí'),
(2112274,'MA','Tufilândia'),
(3554953,'SP','Tuiuti'),
(3169505,'MG','Tumiritinga'),
(4218756,'SC','Tunápolis'),
(4322152,'RS','Tunas'),
(4127882,'PR','Tunas do Paraná'),
(4127908,'PR','Tuneiras do Oeste'),
(2112308,'MA','Tuntum'),
(3555000,'SP','Tupã'),
(3169604,'MG','Tupaciguara'),
(2615805,'PE','Tupanatinga'),
(4322186,'RS','Tupanci do Sul'),
(4322202,'RS','Tupanciretã'),
(4322251,'RS','Tupandi'),
(4322301,'RS','Tuparendi'),
(2615904,'PE','Tuparetama'),
(4127957,'PR','Tupãssi'),
(3555109,'SP','Tupi Paulista'),
(1721257,'TO','Tupirama'),
(1721307,'TO','Tupiratins'),
(2112407,'MA','Turiaçu'),
(2112456,'MA','Turilândia'),
(3555208,'SP','Turiúba'),
(3555307,'SP','Turmalina'),
(3169703,'MG','Turmalina'),
(4322327,'RS','Turuçu'),
(2313559,'CE','Tururu'),
(5221502,'GO','Turvânia'),
(5221551,'GO','Turvelândia'),
(4127965,'PR','Turvo'),
(4218806,'SC','Turvo'),
(3169802,'MG','Turvolândia'),
(2112506,'MA','Tutóia'),
(1304260,'AM','Uarini'),
(2932002,'BA','Uauá'),
(3169901,'MG','Ubá'),
(3170008,'MG','Ubaí'),
(2932101,'BA','Ubaíra'),
(2932200,'BA','Ubaitaba'),
(2313609,'CE','Ubajara'),
(3170057,'MG','Ubaporanga'),
(3555356,'SP','Ubarana'),
(2932309,'BA','Ubatã'),
(3555406,'SP','Ubatuba'),
(3170107,'MG','Uberaba'),
(3170206,'MG','Uberlândia'),
(3555505,'SP','Ubirajara'),
(4128005,'PR','Ubiratã'),
(4322343,'RS','Ubiretama'),
(3555604,'SP','Uchoa'),
(2932408,'BA','Uibaí'),
(1400704,'RR','Uiramutã'),
(5221577,'GO','Uirapuru'),
(2516904,'PB','Uiraúna'),
(1508126,'PA','Ulianópolis'),
(2313708,'CE','Umari'),
(2414506,'RN','Umarizal'),
(2807600,'SE','Umbaúba'),
(2932457,'BA','Umburanas'),
(3170305,'MG','Umburatiba'),
(2517001,'PB','Umbuzeiro'),
(2313757,'CE','Umirim'),
(4128104,'PR','Umuarama'),
(2932507,'BA','Una'),
(3170404,'MG','Unaí'),
(2211100,'PI','União'),
(4322350,'RS','União da Serra'),
(4128203,'PR','União da Vitória'),
(3170438,'MG','União de Minas'),
(4218855,'SC','União do Oeste'),
(5108303,'MT','União do Sul'),
(2709301,'AL','União dos Palmares'),
(3555703,'SP','União Paulista'),
(4128302,'PR','Uniflor'),
(4322376,'RS','Unistalda'),
(2414605,'RN','Upanema'),
(4128401,'PR','Uraí'),
(2932606,'BA','Urandi'),
(3555802,'SP','Urânia'),
(2112605,'MA','Urbano Santos'),
(3555901,'SP','Uru'),
(5221601,'GO','Uruaçu'),
(5221700,'GO','Uruana'),
(3170479,'MG','Uruana de Minas'),
(1508159,'PA','Uruará'),
(4218905,'SC','Urubici'),
(2313807,'CE','Uruburetama'),
(3170503,'MG','Urucânia'),
(1304302,'AM','Urucará'),
(2932705,'BA','Uruçuca'),
(2211209,'PI','Uruçuí'),
(3170529,'MG','Urucuia'),
(1304401,'AM','Urucurituba'),
(4322400,'RS','Uruguaiana'),
(2313906,'CE','Uruoca'),
(1101708,'RO','Urupá'),
(4218954,'SC','Urupema'),
(3556008,'SP','Urupês'),
(4219002,'SC','Urussanga'),
(5221809,'GO','Urutaí'),
(2932804,'BA','Utinga'),
(4322509,'RS','Vacaria'),
(5108352,'MT','Vale de São Domingos'),
(1101757,'RO','Vale do Anari'),
(1101807,'RO','Vale do Paraíso'),
(4322533,'RS','Vale do Sol'),
(4322541,'RS','Vale Real'),
(4322525,'RS','Vale Verde'),
(3306107,'RJ','Valença'),
(2932903,'BA','Valença'),
(2211308,'PI','Valença do Piauí'),
(2933000,'BA','Valente'),
(3556107,'SP','Valentim Gentil'),
(3556206,'SP','Valinhos'),
(3556305,'SP','Valparaíso'),
(5221858,'GO','Valparaíso de Goiás'),
(4322558,'RS','Vanini'),
(4219101,'SC','Vargeão'),
(4219150,'SC','Vargem'),
(3556354,'SP','Vargem'),
(3170578,'MG','Vargem Alegre'),
(3205036,'ES','Vargem Alta'),
(3170602,'MG','Vargem Bonita'),
(4219176,'SC','Vargem Bonita'),
(2112704,'MA','Vargem Grande'),
(3170651,'MG','Vargem Grande do Rio Pardo'),
(3556404,'SP','Vargem Grande do Sul'),
(3556453,'SP','Vargem Grande Paulista'),
(3170701,'MG','Varginha'),
(5221908,'GO','Varjão'),
(3170750,'MG','Varjão de Minas'),
(2313955,'CE','Varjota'),
(3306156,'RJ','Varre-Sai'),
(2414704,'RN','Várzea'),
(2517100,'PB','Várzea'),
(2314003,'CE','Várzea Alegre'),
(2211357,'PI','Várzea Branca'),
(3170800,'MG','Várzea da Palma'),
(2933059,'BA','Várzea da Roça'),
(2933109,'BA','Várzea do Poço'),
(2211407,'PI','Várzea Grande'),
(5108402,'MT','Várzea Grande'),
(2933158,'BA','Várzea Nova'),
(3556503,'SP','Várzea Paulista'),
(2933174,'BA','Varzedo'),
(3170909,'MG','Varzelândia'),
(3306206,'RJ','Vassouras'),
(3171006,'MG','Vazante'),
(4322608,'RS','Venâncio Aires'),
(3205069,'ES','Venda Nova do Imigrante'),
(2414753,'RN','Venha-Ver'),
(4128534,'PR','Ventania'),
(2616001,'PE','Venturosa'),
(5108501,'MT','Vera'),
(4322707,'RS','Vera Cruz'),
(3556602,'SP','Vera Cruz'),
(2933208,'BA','Vera Cruz'),
(2414803,'RN','Vera Cruz'),
(4128559,'PR','Vera Cruz do Oeste'),
(2211506,'PI','Vera Mendes'),
(4322806,'RS','Veranópolis'),
(2616100,'PE','Verdejante'),
(3171030,'MG','Verdelândia'),
(4128609,'PR','Verê'),
(2933257,'BA','Vereda'),
(3171071,'MG','Veredinha'),
(3171105,'MG','Veríssimo'),
(3171154,'MG','Vermelho Novo'),
(2616183,'PE','Vertente do Lério'),
(2616209,'PE','Vertentes'),
(3171204,'MG','Vespasiano'),
(4322855,'RS','Vespasiano Corrêa'),
(4322905,'RS','Viadutos'),
(4323002,'RS','Viamão'),
(3205101,'ES','Viana'),
(2112803,'MA','Viana'),
(5222005,'GO','Vianópolis'),
(2616308,'PE','Vicência'),
(4323101,'RS','Vicente Dutra'),
(5008404,'MS','Vicentina'),
(5222054,'GO','Vicentinópolis'),
(3171303,'MG','Viçosa'),
(2709400,'AL','Viçosa'),
(2414902,'RN','Viçosa'),
(2314102,'CE','Viçosa do Ceará'),
(4323200,'RS','Victor Graeff'),
(4219200,'SC','Vidal Ramos');
INSERT IGNORE INTO cities (id,uf,name) VALUES
(4219309,'SC','Videira'),
(3171402,'MG','Vieiras'),
(2517209,'PB','Vieirópolis'),
(1508209,'PA','Vigia'),
(5105507,'MT','Vila Bela da Santíssima Trindade'),
(5222203,'GO','Vila Boa'),
(2415008,'RN','Vila Flor'),
(4323309,'RS','Vila Flores'),
(4323358,'RS','Vila Lângaro'),
(4323408,'RS','Vila Maria'),
(2211605,'PI','Vila Nova do Piauí'),
(4323457,'RS','Vila Nova do Sul'),
(2112852,'MA','Vila Nova dos Martírios'),
(3205150,'ES','Vila Pavão'),
(5222302,'GO','Vila Propício'),
(5108600,'MT','Vila Rica'),
(3205176,'ES','Vila Valério'),
(3205200,'ES','Vila Velha'),
(1100304,'RO','Vilhena'),
(3556701,'SP','Vinhedo'),
(3556800,'SP','Viradouro'),
(3171600,'MG','Virgem da Lapa'),
(3171709,'MG','Virgínia'),
(3171808,'MG','Virginópolis'),
(3171907,'MG','Virgolândia'),
(4128658,'PR','Virmond'),
(3172004,'MG','Visconde do Rio Branco'),
(1508308,'PA','Viseu'),
(4323507,'RS','Vista Alegre'),
(3556909,'SP','Vista Alegre do Alto'),
(4323606,'RS','Vista Alegre do Prata'),
(4323705,'RS','Vista Gaúcha'),
(2505501,'PB','Vista Serrana'),
(4219358,'SC','Vitor Meireles'),
(3205309,'ES','Vitória'),
(3556958,'SP','Vitória Brasil'),
(2933307,'BA','Vitória da Conquista'),
(4323754,'RS','Vitória das Missões'),
(2616407,'PE','Vitória de Santo Antão'),
(1600808,'AP','Vitória do Jari'),
(2112902,'MA','Vitória do Mearim'),
(1508357,'PA','Vitória do Xingu'),
(4128708,'PR','Vitorino'),
(2113009,'MA','Vitorino Freire'),
(3172103,'MG','Volta Grande'),
(3306305,'RJ','Volta Redonda'),
(3557006,'SP','Votorantim'),
(3557105,'SP','Votuporanga'),
(2933406,'BA','Wagner'),
(2211704,'PI','Wall Ferraz'),
(1722081,'TO','Wanderlândia'),
(2933455,'BA','Wanderley'),
(3172202,'MG','Wenceslau Braz'),
(4128500,'PR','Wenceslau Braz'),
(2933505,'BA','Wenceslau Guimarães'),
(4323770,'RS','Westfália'),
(4219408,'SC','Witmarsum'),
(1722107,'TO','Xambioá'),
(4128807,'PR','Xambrê'),
(4323804,'RS','Xangri-lá'),
(4219507,'SC','Xanxerê'),
(1200708,'AC','Xapuri'),
(4219606,'SC','Xavantina'),
(4219705,'SC','Xaxim'),
(2616506,'PE','Xexéu'),
(1508407,'PA','Xinguara'),
(2933604,'BA','Xique-Xique'),
(2517407,'PB','Zabelê'),
(3557154,'SP','Zacarias'),
(2114007,'MA','Zé Doca'),
(4219853,'SC','Zortéa');