if not exists(select * from Core_Country where id = 'BR')

begin

insert into Core_Country (Id,Name,Code3,IsBillingEnabled,IsShippingEnabled,IsCityEnabled,IsZipCodeEnabled,IsDistrictEnabled)

select 'BR','Brasil','BRA', 1, 1, 0, 1, 1

end

select *

into #tmpEstados

from (

select 'Acre' as Estado, 'AC' as sigla union all

select 'Alagoas' as Estado, 'AL' as sigla union all

select 'Amapá' as Estado, 'AP' as sigla union all

select 'Amazonas' as Estado, 'AM' as sigla union all

select 'Bahia' as Estado, 'BA' as sigla union all

select 'Ceará' as Estado, 'CE' as sigla union all

select 'Distrito Federal' as Estado, 'DF' as sigla union all

select 'Espírito Santo' as Estado, 'ES' as sigla union all

select 'Goiás' as Estado, 'GO' as sigla union all

select 'Maranhão' as Estado, 'MA' as sigla union all

select 'Mato Grosso' as Estado, 'MT' as sigla union all

select 'Mato Grosso do Sul' as Estado, 'MS' as sigla union all

select 'Minas Gerais' as Estado, 'MG' as sigla union all

select 'Pará' as Estado, 'PA' as sigla union all

select 'Paraíba' as Estado, 'PB' as sigla union all

select 'Paraná' as Estado, 'PR' as sigla union all

select 'Pernambuco' as Estado, 'PE' as sigla union all

select 'Piauí' as Estado, 'PI' as sigla union all

select 'Rio de Janeiro' as Estado, 'RJ' as sigla union all

select 'Rio Grande do Norte' as Estado, 'RN' as sigla union all

select 'Rio Grande do Sul' as Estado, 'RS' as sigla union all

select 'Rondônia' as Estado, 'RO' as sigla union all

select 'Roraima' as Estado, 'RR' as sigla union all

select 'Santa Catarina' as Estado, 'SC' as sigla union all

select 'São Paulo' as Estado, 'SP' as sigla union all

select 'Sergipe' as Estado, 'SE' as sigla union all

select 'Tocantins' as Estado, 'TO' as sigla

) as t

insert into Core_StateOrProvince (CountryId,Code,Name,Type)

select 'BR',Sigla,Estado,'Estado'

from #tmpEstados as tmp

left join Core_StateOrProvince as s

on s.Code = tmp.sigla

and s.Name = tmp.Estado

and s.CountryId = 'BR'

where s.id is null

order by estado

select *

into #tmpCidades

from (

select 'RO' as Estado, 'Alta Floresta D''Oeste' as Municipio union all

select 'RO' as Estado, 'Alto Alegre dos Parecis' as Municipio union all

select 'RO' as Estado, 'Alto Paraíso' as Municipio union all

select 'RO' as Estado, 'Alvorada D''Oeste' as Municipio union all

select 'RO' as Estado, 'Ariquemes' as Municipio union all

select 'RO' as Estado, 'Buritis' as Municipio union all

select 'RO' as Estado, 'Cabixi' as Municipio union all

select 'RO' as Estado, 'Cacaulândia' as Municipio union all

select 'RO' as Estado, 'Cacoal' as Municipio union all

select 'RO' as Estado, 'Campo Novo de Rondônia' as Municipio union all

select 'RO' as Estado, 'Candeias do Jamari' as Municipio union all

select 'RO' as Estado, 'Castanheiras' as Municipio union all

select 'RO' as Estado, 'Cerejeiras' as Municipio union all

select 'RO' as Estado, 'Chupinguaia' as Municipio union all

select 'RO' as Estado, 'Colorado do Oeste' as Municipio union all

select 'RO' as Estado, 'Corumbiara' as Municipio union all

select 'RO' as Estado, 'Costa Marques' as Municipio union all

select 'RO' as Estado, 'Cujubim' as Municipio union all

select 'RO' as Estado, 'Espigão D''Oeste' as Municipio union all

select 'RO' as Estado, 'Governador Jorge Teixeira' as Municipio union all

select 'RO' as Estado, 'Guajará-Mirim' as Municipio union all

select 'RO' as Estado, 'Itapuã do Oeste' as Municipio union all

select 'RO' as Estado, 'Jaru' as Municipio union all

select 'RO' as Estado, 'Ji-Paraná' as Municipio union all

select 'RO' as Estado, 'Machadinho D''Oeste' as Municipio union all

select 'RO' as Estado, 'Ministro Andreazza' as Municipio union all

select 'RO' as Estado, 'Mirante da Serra' as Municipio union all

select 'RO' as Estado, 'Monte Negro' as Municipio union all

select 'RO' as Estado, 'Nova Brasilândia D''Oeste' as Municipio union all

select 'RO' as Estado, 'Nova Mamoré' as Municipio union all

select 'RO' as Estado, 'Nova União' as Municipio union all

select 'RO' as Estado, 'Novo Horizonte do Oeste' as Municipio union all

select 'RO' as Estado, 'Ouro Preto do Oeste' as Municipio union all

select 'RO' as Estado, 'Parecis' as Municipio union all

select 'RO' as Estado, 'Pimenta Bueno' as Municipio union all

select 'RO' as Estado, 'Pimenteiras do Oeste' as Municipio union all

select 'RO' as Estado, 'Porto Velho' as Municipio union all

select 'RO' as Estado, 'Presidente Médici' as Municipio union all

select 'RO' as Estado, 'Primavera de Rondônia' as Municipio union all

select 'RO' as Estado, 'Rio Crespo' as Municipio union all

select 'RO' as Estado, 'Rolim de Moura' as Municipio union all

select 'RO' as Estado, 'Santa Luzia D''Oeste' as Municipio union all

select 'RO' as Estado, 'São Felipe D''Oeste' as Municipio union all

select 'RO' as Estado, 'São Francisco do Guaporé' as Municipio union all

select 'RO' as Estado, 'São Miguel do Guaporé' as Municipio union all

select 'RO' as Estado, 'Seringueiras' as Municipio union all

select 'RO' as Estado, 'Teixeirópolis' as Municipio union all

select 'RO' as Estado, 'Theobroma' as Municipio union all

select 'RO' as Estado, 'Urupá' as Municipio union all

select 'RO' as Estado, 'Vale do Anari' as Municipio union all

select 'RO' as Estado, 'Vale do Paraíso' as Municipio union all

select 'RO' as Estado, 'Vilhena' as Municipio union all

select 'AC' as Estado, 'Acrelândia' as Municipio union all

select 'AC' as Estado, 'Assis Brasil' as Municipio union all

select 'AC' as Estado, 'Brasiléia' as Municipio union all

select 'AC' as Estado, 'Bujari' as Municipio union all

select 'AC' as Estado, 'Capixaba' as Municipio union all

select 'AC' as Estado, 'Cruzeiro do Sul' as Municipio union all

select 'AC' as Estado, 'Epitaciolândia' as Municipio union all

select 'AC' as Estado, 'Feijó' as Municipio union all

select 'AC' as Estado, 'Jordão' as Municipio union all

select 'AC' as Estado, 'Mâncio Lima' as Municipio union all

select 'AC' as Estado, 'Manoel Urbano' as Municipio union all

select 'AC' as Estado, 'Marechal Thaumaturgo' as Municipio union all

select 'AC' as Estado, 'Plácido de Castro' as Municipio union all

select 'AC' as Estado, 'Porto Acre' as Municipio union all

select 'AC' as Estado, 'Porto Walter' as Municipio union all

select 'AC' as Estado, 'Rio Branco' as Municipio union all

select 'AC' as Estado, 'Rodrigues Alves' as Municipio union all

select 'AC' as Estado, 'Santa Rosa do Purus' as Municipio union all

select 'AC' as Estado, 'Sena Madureira' as Municipio union all

select 'AC' as Estado, 'Senador Guiomard' as Municipio union all

select 'AC' as Estado, 'Tarauacá' as Municipio union all

select 'AC' as Estado, 'Xapuri' as Municipio union all

select 'AM' as Estado, 'Alvarães' as Municipio union all

select 'AM' as Estado, 'Amaturá' as Municipio union all

select 'AM' as Estado, 'Anamã' as Municipio union all

select 'AM' as Estado, 'Anori' as Municipio union all

select 'AM' as Estado, 'Apuí' as Municipio union all

select 'AM' as Estado, 'Atalaia do Norte' as Municipio union all

select 'AM' as Estado, 'Autazes' as Municipio union all

select 'AM' as Estado, 'Barcelos' as Municipio union all

select 'AM' as Estado, 'Barreirinha' as Municipio union all

select 'AM' as Estado, 'Benjamin Constant' as Municipio union all

select 'AM' as Estado, 'Beruri' as Municipio union all

select 'AM' as Estado, 'Boa Vista do Ramos' as Municipio union all

select 'AM' as Estado, 'Boca do Acre' as Municipio union all

select 'AM' as Estado, 'Borba' as Municipio union all

select 'AM' as Estado, 'Caapiranga' as Municipio union all

select 'AM' as Estado, 'Canutama' as Municipio union all

select 'AM' as Estado, 'Carauari' as Municipio union all

select 'AM' as Estado, 'Careiro' as Municipio union all

select 'AM' as Estado, 'Careiro da Várzea' as Municipio union all

select 'AM' as Estado, 'Coari' as Municipio union all

select 'AM' as Estado, 'Codajás' as Municipio union all

select 'AM' as Estado, 'Eirunepé' as Municipio union all

select 'AM' as Estado, 'Envira' as Municipio union all

select 'AM' as Estado, 'Fonte Boa' as Municipio union all

select 'AM' as Estado, 'Guajará' as Municipio union all

select 'AM' as Estado, 'Humaitá' as Municipio union all

select 'AM' as Estado, 'Ipixuna' as Municipio union all

select 'AM' as Estado, 'Iranduba' as Municipio union all

select 'AM' as Estado, 'Itacoatiara' as Municipio union all

select 'AM' as Estado, 'Itamarati' as Municipio union all

select 'AM' as Estado, 'Itapiranga' as Municipio union all

select 'AM' as Estado, 'Japurá' as Municipio union all

select 'AM' as Estado, 'Juruá' as Municipio union all

select 'AM' as Estado, 'Jutaí' as Municipio union all

select 'AM' as Estado, 'Lábrea' as Municipio union all

select 'AM' as Estado, 'Manacapuru' as Municipio union all

select 'AM' as Estado, 'Manaquiri' as Municipio union all

select 'AM' as Estado, 'Manaus' as Municipio union all

select 'AM' as Estado, 'Manicoré' as Municipio union all

select 'AM' as Estado, 'Maraã' as Municipio union all

select 'AM' as Estado, 'Maués' as Municipio union all

select 'AM' as Estado, 'Nhamundá' as Municipio union all

select 'AM' as Estado, 'Nova Olinda do Norte' as Municipio union all

select 'AM' as Estado, 'Novo Airão' as Municipio union all

select 'AM' as Estado, 'Novo Aripuanã' as Municipio union all

select 'AM' as Estado, 'Parintins' as Municipio union all

select 'AM' as Estado, 'Pauini' as Municipio union all

select 'AM' as Estado, 'Presidente Figueiredo' as Municipio union all

select 'AM' as Estado, 'Rio Preto da Eva' as Municipio union all

select 'AM' as Estado, 'Santa Isabel do Rio Negro' as Municipio union all

select 'AM' as Estado, 'Santo Antônio do Içá' as Municipio union all

select 'AM' as Estado, 'São Gabriel da Cachoeira' as Municipio union all

select 'AM' as Estado, 'São Paulo de Olivença' as Municipio union all

select 'AM' as Estado, 'São Sebastião do Uatumã' as Municipio union all

select 'AM' as Estado, 'Silves' as Municipio union all

select 'AM' as Estado, 'Tabatinga' as Municipio union all

select 'AM' as Estado, 'Tapauá' as Municipio union all

select 'AM' as Estado, 'Tefé' as Municipio union all

select 'AM' as Estado, 'Tonantins' as Municipio union all

select 'AM' as Estado, 'Uarini' as Municipio union all

select 'AM' as Estado, 'Urucará' as Municipio union all

select 'AM' as Estado, 'Urucurituba' as Municipio union all

select 'RR' as Estado, 'Alto Alegre' as Municipio union all

select 'RR' as Estado, 'Amajari' as Municipio union all

select 'RR' as Estado, 'Boa Vista' as Municipio union all

select 'RR' as Estado, 'Bonfim' as Municipio union all

select 'RR' as Estado, 'Cantá' as Municipio union all

select 'RR' as Estado, 'Caracaraí' as Municipio union all

select 'RR' as Estado, 'Caroebe' as Municipio union all

select 'RR' as Estado, 'Iracema' as Municipio union all

select 'RR' as Estado, 'Mucajaí' as Municipio union all

select 'RR' as Estado, 'Normandia' as Municipio union all

select 'RR' as Estado, 'Pacaraima' as Municipio union all

select 'RR' as Estado, 'Rorainópolis' as Municipio union all

select 'RR' as Estado, 'São João da Baliza' as Municipio union all

select 'RR' as Estado, 'São Luiz' as Municipio union all

select 'RR' as Estado, 'Uiramutã' as Municipio union all

select 'PA' as Estado, 'Abaetetuba' as Municipio union all

select 'PA' as Estado, 'Abel Figueiredo' as Municipio union all

select 'PA' as Estado, 'Acará' as Municipio union all

select 'PA' as Estado, 'Afuá' as Municipio union all

select 'PA' as Estado, 'Água Azul do Norte' as Municipio union all

select 'PA' as Estado, 'Alenquer' as Municipio union all

select 'PA' as Estado, 'Almeirim' as Municipio union all

select 'PA' as Estado, 'Altamira' as Municipio union all

select 'PA' as Estado, 'Anajás' as Municipio union all

select 'PA' as Estado, 'Ananindeua' as Municipio union all

select 'PA' as Estado, 'Anapu' as Municipio union all

select 'PA' as Estado, 'Augusto Corrêa' as Municipio union all

select 'PA' as Estado, 'Aurora do Pará' as Municipio union all

select 'PA' as Estado, 'Aveiro' as Municipio union all

select 'PA' as Estado, 'Bagre' as Municipio union all

select 'PA' as Estado, 'Baião' as Municipio union all

select 'PA' as Estado, 'Bannach' as Municipio union all

select 'PA' as Estado, 'Barcarena' as Municipio union all

select 'PA' as Estado, 'Belém' as Municipio union all

select 'PA' as Estado, 'Belterra' as Municipio union all

select 'PA' as Estado, 'Benevides' as Municipio union all

select 'PA' as Estado, 'Bom Jesus do Tocantins' as Municipio union all

select 'PA' as Estado, 'Bonito' as Municipio union all

select 'PA' as Estado, 'Bragança' as Municipio union all

select 'PA' as Estado, 'Brasil Novo' as Municipio union all

select 'PA' as Estado, 'Brejo Grande do Araguaia' as Municipio union all

select 'PA' as Estado, 'Breu Branco' as Municipio union all

select 'PA' as Estado, 'Breves' as Municipio union all

select 'PA' as Estado, 'Bujaru' as Municipio union all

select 'PA' as Estado, 'Cachoeira do Arari' as Municipio union all

select 'PA' as Estado, 'Cachoeira do Piriá' as Municipio union all

select 'PA' as Estado, 'Cametá' as Municipio union all

select 'PA' as Estado, 'Canaã dos Carajás' as Municipio union all

select 'PA' as Estado, 'Capanema' as Municipio union all

select 'PA' as Estado, 'Capitão Poço' as Municipio union all

select 'PA' as Estado, 'Castanhal' as Municipio union all

select 'PA' as Estado, 'Chaves' as Municipio union all

select 'PA' as Estado, 'Colares' as Municipio union all

select 'PA' as Estado, 'Conceição do Araguaia' as Municipio union all

select 'PA' as Estado, 'Concórdia do Pará' as Municipio union all

select 'PA' as Estado, 'Cumaru do Norte' as Municipio union all

select 'PA' as Estado, 'Curionópolis' as Municipio union all

select 'PA' as Estado, 'Curralinho' as Municipio union all

select 'PA' as Estado, 'Curuá' as Municipio union all

select 'PA' as Estado, 'Curuçá' as Municipio union all

select 'PA' as Estado, 'Dom Eliseu' as Municipio union all

select 'PA' as Estado, 'Eldorado dos Carajás' as Municipio union all

select 'PA' as Estado, 'Faro' as Municipio union all

select 'PA' as Estado, 'Floresta do Araguaia' as Municipio union all

select 'PA' as Estado, 'Garrafão do Norte' as Municipio union all

select 'PA' as Estado, 'Goianésia do Pará' as Municipio union all

select 'PA' as Estado, 'Gurupá' as Municipio union all

select 'PA' as Estado, 'Igarapé-Açu' as Municipio union all

select 'PA' as Estado, 'Igarapé-Miri' as Municipio union all

select 'PA' as Estado, 'Inhangapi' as Municipio union all

select 'PA' as Estado, 'Ipixuna do Pará' as Municipio union all

select 'PA' as Estado, 'Irituia' as Municipio union all

select 'PA' as Estado, 'Itaituba' as Municipio union all

select 'PA' as Estado, 'Itupiranga' as Municipio union all

select 'PA' as Estado, 'Jacareacanga' as Municipio union all

select 'PA' as Estado, 'Jacundá' as Municipio union all

select 'PA' as Estado, 'Juruti' as Municipio union all

select 'PA' as Estado, 'Limoeiro do Ajuru' as Municipio union all

select 'PA' as Estado, 'Mãe do Rio' as Municipio union all

select 'PA' as Estado, 'Magalhães Barata' as Municipio union all

select 'PA' as Estado, 'Marabá' as Municipio union all

select 'PA' as Estado, 'Maracanã' as Municipio union all

select 'PA' as Estado, 'Marapanim' as Municipio union all

select 'PA' as Estado, 'Marituba' as Municipio union all

select 'PA' as Estado, 'Medicilândia' as Municipio union all

select 'PA' as Estado, 'Melgaço' as Municipio union all

select 'PA' as Estado, 'Mocajuba' as Municipio union all

select 'PA' as Estado, 'Moju' as Municipio union all

select 'PA' as Estado, 'Monte Alegre' as Municipio union all

select 'PA' as Estado, 'Muaná' as Municipio union all

select 'PA' as Estado, 'Nova Esperança do Piriá' as Municipio union all

select 'PA' as Estado, 'Nova Ipixuna' as Municipio union all

select 'PA' as Estado, 'Nova Timboteua' as Municipio union all

select 'PA' as Estado, 'Novo Progresso' as Municipio union all

select 'PA' as Estado, 'Novo Repartimento' as Municipio union all

select 'PA' as Estado, 'Óbidos' as Municipio union all

select 'PA' as Estado, 'Oeiras do Pará' as Municipio union all

select 'PA' as Estado, 'Oriximiná' as Municipio union all

select 'PA' as Estado, 'Ourém' as Municipio union all

select 'PA' as Estado, 'Ourilândia do Norte' as Municipio union all

select 'PA' as Estado, 'Pacajá' as Municipio union all

select 'PA' as Estado, 'Palestina do Pará' as Municipio union all

select 'PA' as Estado, 'Paragominas' as Municipio union all

select 'PA' as Estado, 'Parauapebas' as Municipio union all

select 'PA' as Estado, 'Pau D''Arco' as Municipio union all

select 'PA' as Estado, 'Peixe-Boi' as Municipio union all

select 'PA' as Estado, 'Piçarra' as Municipio union all

select 'PA' as Estado, 'Placas' as Municipio union all

select 'PA' as Estado, 'Ponta de Pedras' as Municipio union all

select 'PA' as Estado, 'Portel' as Municipio union all

select 'PA' as Estado, 'Porto de Moz' as Municipio union all

select 'PA' as Estado, 'Prainha' as Municipio union all

select 'PA' as Estado, 'Primavera' as Municipio union all

select 'PA' as Estado, 'Quatipuru' as Municipio union all

select 'PA' as Estado, 'Redenção' as Municipio union all

select 'PA' as Estado, 'Rio Maria' as Municipio union all

select 'PA' as Estado, 'Rondon do Pará' as Municipio union all

select 'PA' as Estado, 'Rurópolis' as Municipio union all

select 'PA' as Estado, 'Salinópolis' as Municipio union all

select 'PA' as Estado, 'Salvaterra' as Municipio union all

select 'PA' as Estado, 'Santa Bárbara do Pará' as Municipio union all

select 'PA' as Estado, 'Santa Cruz do Arari' as Municipio union all

select 'PA' as Estado, 'Santa Isabel do Pará' as Municipio union all

select 'PA' as Estado, 'Santa Luzia do Pará' as Municipio union all

select 'PA' as Estado, 'Santa Maria das Barreiras' as Municipio union all

select 'PA' as Estado, 'Santa Maria do Pará' as Municipio union all

select 'PA' as Estado, 'Santana do Araguaia' as Municipio union all

select 'PA' as Estado, 'Santarém' as Municipio union all

select 'PA' as Estado, 'Santarém Novo' as Municipio union all

select 'PA' as Estado, 'Santo Antônio do Tauá' as Municipio union all

select 'PA' as Estado, 'São Caetano de Odivelas' as Municipio union all

select 'PA' as Estado, 'São Domingos do Araguaia' as Municipio union all

select 'PA' as Estado, 'São Domingos do Capim' as Municipio union all

select 'PA' as Estado, 'São Félix do Xingu' as Municipio union all

select 'PA' as Estado, 'São Francisco do Pará' as Municipio union all

select 'PA' as Estado, 'São Geraldo do Araguaia' as Municipio union all

select 'PA' as Estado, 'São João da Ponta' as Municipio union all

select 'PA' as Estado, 'São João de Pirabas' as Municipio union all

select 'PA' as Estado, 'São João do Araguaia' as Municipio union all

select 'PA' as Estado, 'São Miguel do Guamá' as Municipio union all

select 'PA' as Estado, 'São Sebastião da Boa Vista' as Municipio union all

select 'PA' as Estado, 'Sapucaia' as Municipio union all

select 'PA' as Estado, 'Senador José Porfírio' as Municipio union all

select 'PA' as Estado, 'Soure' as Municipio union all

select 'PA' as Estado, 'Tailândia' as Municipio union all

select 'PA' as Estado, 'Terra Alta' as Municipio union all

select 'PA' as Estado, 'Terra Santa' as Municipio union all

select 'PA' as Estado, 'Tomé-Açu' as Municipio union all

select 'PA' as Estado, 'Tracuateua' as Municipio union all

select 'PA' as Estado, 'Trairão' as Municipio union all

select 'PA' as Estado, 'Tucumã' as Municipio union all

select 'PA' as Estado, 'Tucuruí' as Municipio union all

select 'PA' as Estado, 'Ulianópolis' as Municipio union all

select 'PA' as Estado, 'Uruará (por decisão judicial)' as Municipio union all

select 'PA' as Estado, 'Vigia' as Municipio union all

select 'PA' as Estado, 'Viseu' as Municipio union all

select 'PA' as Estado, 'Vitória do Xingu' as Municipio union all

select 'PA' as Estado, 'Xinguara' as Municipio union all

select 'AP' as Estado, 'Amapá' as Municipio union all

select 'AP' as Estado, 'Calçoene' as Municipio union all

select 'AP' as Estado, 'Cutias' as Municipio union all

select 'AP' as Estado, 'Ferreira Gomes' as Municipio union all

select 'AP' as Estado, 'Itaubal' as Municipio union all

select 'AP' as Estado, 'Laranjal do Jari' as Municipio union all

select 'AP' as Estado, 'Macapá' as Municipio union all

select 'AP' as Estado, 'Mazagão' as Municipio union all

select 'AP' as Estado, 'Oiapoque' as Municipio union all

select 'AP' as Estado, 'Pedra Branca do Amapari' as Municipio union all

select 'AP' as Estado, 'Porto Grande' as Municipio union all

select 'AP' as Estado, 'Pracuúba' as Municipio union all

select 'AP' as Estado, 'Santana' as Municipio union all

select 'AP' as Estado, 'Serra do Navio' as Municipio union all

select 'AP' as Estado, 'Tartarugalzinho' as Municipio union all

select 'AP' as Estado, 'Vitória do Jari' as Municipio union all

select 'TO' as Estado, 'Abreulândia' as Municipio union all

select 'TO' as Estado, 'Aguiarnópolis' as Municipio union all

select 'TO' as Estado, 'Aliança do Tocantins' as Municipio union all

select 'TO' as Estado, 'Almas' as Municipio union all

select 'TO' as Estado, 'Alvorada' as Municipio union all

select 'TO' as Estado, 'Ananás' as Municipio union all

select 'TO' as Estado, 'Angico' as Municipio union all

select 'TO' as Estado, 'Aparecida do Rio Negro' as Municipio union all

select 'TO' as Estado, 'Aragominas' as Municipio union all

select 'TO' as Estado, 'Araguacema' as Municipio union all

select 'TO' as Estado, 'Araguaçu' as Municipio union all

select 'TO' as Estado, 'Araguaína' as Municipio union all

select 'TO' as Estado, 'Araguanã' as Municipio union all

select 'TO' as Estado, 'Araguatins' as Municipio union all

select 'TO' as Estado, 'Arapoema' as Municipio union all

select 'TO' as Estado, 'Arraias' as Municipio union all

select 'TO' as Estado, 'Augustinópolis' as Municipio union all

select 'TO' as Estado, 'Aurora do Tocantins' as Municipio union all

select 'TO' as Estado, 'Axixá do Tocantins' as Municipio union all

select 'TO' as Estado, 'Babaçulândia' as Municipio union all

select 'TO' as Estado, 'Bandeirantes do Tocantins' as Municipio union all

select 'TO' as Estado, 'Barra do Ouro' as Municipio union all

select 'TO' as Estado, 'Barrolândia' as Municipio union all

select 'TO' as Estado, 'Bernardo Sayão' as Municipio union all

select 'TO' as Estado, 'Bom Jesus do Tocantins' as Municipio union all

select 'TO' as Estado, 'Brasilândia do Tocantins' as Municipio union all

select 'TO' as Estado, 'Brejinho de Nazaré' as Municipio union all

select 'TO' as Estado, 'Buriti do Tocantins' as Municipio union all

select 'TO' as Estado, 'Cachoeirinha' as Municipio union all

select 'TO' as Estado, 'Campos Lindos' as Municipio union all

select 'TO' as Estado, 'Cariri do Tocantins' as Municipio union all

select 'TO' as Estado, 'Carmolândia' as Municipio union all

select 'TO' as Estado, 'Carrasco Bonito' as Municipio union all

select 'TO' as Estado, 'Caseara' as Municipio union all

select 'TO' as Estado, 'Centenário' as Municipio union all

select 'TO' as Estado, 'Chapada da Natividade' as Municipio union all

select 'TO' as Estado, 'Chapada de Areia' as Municipio union all

select 'TO' as Estado, 'Colinas do Tocantins' as Municipio union all

select 'TO' as Estado, 'Colméia' as Municipio union all

select 'TO' as Estado, 'Combinado' as Municipio union all

select 'TO' as Estado, 'Conceição do Tocantins' as Municipio union all

select 'TO' as Estado, 'Couto de Magalhães' as Municipio union all

select 'TO' as Estado, 'Cristalândia' as Municipio union all

select 'TO' as Estado, 'Crixás do Tocantins' as Municipio union all

select 'TO' as Estado, 'Darcinópolis' as Municipio union all

select 'TO' as Estado, 'Dianópolis' as Municipio union all

select 'TO' as Estado, 'Divinópolis do Tocantins' as Municipio union all

select 'TO' as Estado, 'Dois Irmãos do Tocantins' as Municipio union all

select 'TO' as Estado, 'Dueré' as Municipio union all

select 'TO' as Estado, 'Esperantina' as Municipio union all

select 'TO' as Estado, 'Fátima' as Municipio union all

select 'TO' as Estado, 'Figueirópolis' as Municipio union all

select 'TO' as Estado, 'Filadélfia' as Municipio union all

select 'TO' as Estado, 'Formoso do Araguaia' as Municipio union all

select 'TO' as Estado, 'Fortaleza do Tabocão' as Municipio union all

select 'TO' as Estado, 'Goianorte' as Municipio union all

select 'TO' as Estado, 'Goiatins' as Municipio union all

select 'TO' as Estado, 'Guaraí' as Municipio union all

select 'TO' as Estado, 'Gurupi' as Municipio union all

select 'TO' as Estado, 'Ipueiras' as Municipio union all

select 'TO' as Estado, 'Itacajá' as Municipio union all

select 'TO' as Estado, 'Itaguatins' as Municipio union all

select 'TO' as Estado, 'Itapiratins' as Municipio union all

select 'TO' as Estado, 'Itaporã do Tocantins' as Municipio union all

select 'TO' as Estado, 'Jaú do Tocantins' as Municipio union all

select 'TO' as Estado, 'Juarina' as Municipio union all

select 'TO' as Estado, 'Lagoa da Confusão' as Municipio union all

select 'TO' as Estado, 'Lagoa do Tocantins' as Municipio union all

select 'TO' as Estado, 'Lajeado' as Municipio union all

select 'TO' as Estado, 'Lavandeira' as Municipio union all

select 'TO' as Estado, 'Lizarda' as Municipio union all

select 'TO' as Estado, 'Luzinópolis' as Municipio union all

select 'TO' as Estado, 'Marianópolis do Tocantins' as Municipio union all

select 'TO' as Estado, 'Mateiros' as Municipio union all

select 'TO' as Estado, 'Maurilândia do Tocantins' as Municipio union all

select 'TO' as Estado, 'Miracema do Tocantins' as Municipio union all

select 'TO' as Estado, 'Miranorte' as Municipio union all

select 'TO' as Estado, 'Monte do Carmo' as Municipio union all

select 'TO' as Estado, 'Monte Santo do Tocantins' as Municipio union all

select 'TO' as Estado, 'Muricilândia' as Municipio union all

select 'TO' as Estado, 'Natividade' as Municipio union all

select 'TO' as Estado, 'Nazaré' as Municipio union all

select 'TO' as Estado, 'Nova Olinda' as Municipio union all

select 'TO' as Estado, 'Nova Rosalândia' as Municipio union all

select 'TO' as Estado, 'Novo Acordo' as Municipio union all

select 'TO' as Estado, 'Novo Alegre' as Municipio union all

select 'TO' as Estado, 'Novo Jardim' as Municipio union all

select 'TO' as Estado, 'Oliveira de Fátima' as Municipio union all

select 'TO' as Estado, 'Palmas' as Municipio union all

select 'TO' as Estado, 'Palmeirante' as Municipio union all

select 'TO' as Estado, 'Palmeiras do Tocantins' as Municipio union all

select 'TO' as Estado, 'Palmeirópolis' as Municipio union all

select 'TO' as Estado, 'Paraíso do Tocantins' as Municipio union all

select 'TO' as Estado, 'Paranã' as Municipio union all

select 'TO' as Estado, 'Pau D''Arco' as Municipio union all

select 'TO' as Estado, 'Pedro Afonso' as Municipio union all

select 'TO' as Estado, 'Peixe' as Municipio union all

select 'TO' as Estado, 'Pequizeiro' as Municipio union all

select 'TO' as Estado, 'Pindorama do Tocantins' as Municipio union all

select 'TO' as Estado, 'Piraquê' as Municipio union all

select 'TO' as Estado, 'Pium' as Municipio union all

select 'TO' as Estado, 'Ponte Alta do Bom Jesus' as Municipio union all

select 'TO' as Estado, 'Ponte Alta do Tocantins' as Municipio union all

select 'TO' as Estado, 'Porto Alegre do Tocantins' as Municipio union all

select 'TO' as Estado, 'Porto Nacional' as Municipio union all

select 'TO' as Estado, 'Praia Norte' as Municipio union all

select 'TO' as Estado, 'Presidente Kennedy' as Municipio union all

select 'TO' as Estado, 'Pugmil' as Municipio union all

select 'TO' as Estado, 'Recursolândia' as Municipio union all

select 'TO' as Estado, 'Riachinho' as Municipio union all

select 'TO' as Estado, 'Rio da Conceição' as Municipio union all

select 'TO' as Estado, 'Rio dos Bois' as Municipio union all

select 'TO' as Estado, 'Rio Sono' as Municipio union all

select 'TO' as Estado, 'Sampaio' as Municipio union all

select 'TO' as Estado, 'Sandolândia' as Municipio union all

select 'TO' as Estado, 'Santa Fé do Araguaia' as Municipio union all

select 'TO' as Estado, 'Santa Maria do Tocantins' as Municipio union all

select 'TO' as Estado, 'Santa Rita do Tocantins' as Municipio union all

select 'TO' as Estado, 'Santa Rosa do Tocantins' as Municipio union all

select 'TO' as Estado, 'Santa Tereza do Tocantins' as Municipio union all

select 'TO' as Estado, 'Santa Terezinha do Tocantins' as Municipio union all

select 'TO' as Estado, 'São Bento do Tocantins' as Municipio union all

select 'TO' as Estado, 'São Félix do Tocantins' as Municipio union all

select 'TO' as Estado, 'São Miguel do Tocantins' as Municipio union all

select 'TO' as Estado, 'São Salvador do Tocantins' as Municipio union all

select 'TO' as Estado, 'São Sebastião do Tocantins' as Municipio union all

select 'TO' as Estado, 'São Valério da Natividade' as Municipio union all

select 'TO' as Estado, 'Silvanópolis' as Municipio union all

select 'TO' as Estado, 'Sítio Novo do Tocantins' as Municipio union all

select 'TO' as Estado, 'Sucupira' as Municipio union all

select 'TO' as Estado, 'Taguatinga' as Municipio union all

select 'TO' as Estado, 'Taipas do Tocantins' as Municipio union all

select 'TO' as Estado, 'Talismã' as Municipio union all

select 'TO' as Estado, 'Tocantínia' as Municipio union all

select 'TO' as Estado, 'Tocantinópolis' as Municipio union all

select 'TO' as Estado, 'Tupirama' as Municipio union all

select 'TO' as Estado, 'Tupiratins' as Municipio union all

select 'TO' as Estado, 'Wanderlândia' as Municipio union all

select 'TO' as Estado, 'Xambioá' as Municipio union all

select 'MA' as Estado, 'Açailândia' as Municipio union all

select 'MA' as Estado, 'Afonso Cunha' as Municipio union all

select 'MA' as Estado, 'Água Doce do Maranhão' as Municipio union all

select 'MA' as Estado, 'Alcântara' as Municipio union all

select 'MA' as Estado, 'Aldeias Altas' as Municipio union all

select 'MA' as Estado, 'Altamira do Maranhão' as Municipio union all

select 'MA' as Estado, 'Alto Alegre do Maranhão' as Municipio union all

select 'MA' as Estado, 'Alto Alegre do Pindaré' as Municipio union all

select 'MA' as Estado, 'Alto Parnaíba' as Municipio union all

select 'MA' as Estado, 'Amapá do Maranhão' as Municipio union all

select 'MA' as Estado, 'Amarante do Maranhão' as Municipio union all

select 'MA' as Estado, 'Anajatuba' as Municipio union all

select 'MA' as Estado, 'Anapurus' as Municipio union all

select 'MA' as Estado, 'Apicum-Açu' as Municipio union all

select 'MA' as Estado, 'Araguanã' as Municipio union all

select 'MA' as Estado, 'Araioses' as Municipio union all

select 'MA' as Estado, 'Arame' as Municipio union all

select 'MA' as Estado, 'Arari' as Municipio union all

select 'MA' as Estado, 'Axixá' as Municipio union all

select 'MA' as Estado, 'Bacabal' as Municipio union all

select 'MA' as Estado, 'Bacabeira' as Municipio union all

select 'MA' as Estado, 'Bacuri' as Municipio union all

select 'MA' as Estado, 'Bacurituba' as Municipio union all

select 'MA' as Estado, 'Balsas' as Municipio union all

select 'MA' as Estado, 'Barão de Grajaú' as Municipio union all

select 'MA' as Estado, 'Barra do Corda' as Municipio union all

select 'MA' as Estado, 'Barreirinhas' as Municipio union all

select 'MA' as Estado, 'Bela Vista do Maranhão' as Municipio union all

select 'MA' as Estado, 'Belágua' as Municipio union all

select 'MA' as Estado, 'Benedito Leite' as Municipio union all

select 'MA' as Estado, 'Bequimão' as Municipio union all

select 'MA' as Estado, 'Bernardo do Mearim' as Municipio union all

select 'MA' as Estado, 'Boa Vista do Gurupi' as Municipio union all

select 'MA' as Estado, 'Bom Jardim' as Municipio union all

select 'MA' as Estado, 'Bom Jesus das Selvas' as Municipio union all

select 'MA' as Estado, 'Bom Lugar' as Municipio union all

select 'MA' as Estado, 'Brejo' as Municipio union all

select 'MA' as Estado, 'Brejo de Areia' as Municipio union all

select 'MA' as Estado, 'Buriti' as Municipio union all

select 'MA' as Estado, 'Buriti Bravo' as Municipio union all

select 'MA' as Estado, 'Buriticupu' as Municipio union all

select 'MA' as Estado, 'Buritirana' as Municipio union all

select 'MA' as Estado, 'Cachoeira Grande' as Municipio union all

select 'MA' as Estado, 'Cajapió' as Municipio union all

select 'MA' as Estado, 'Cajari' as Municipio union all

select 'MA' as Estado, 'Campestre do Maranhão' as Municipio union all

select 'MA' as Estado, 'Cândido Mendes' as Municipio union all

select 'MA' as Estado, 'Cantanhede' as Municipio union all

select 'MA' as Estado, 'Capinzal do Norte' as Municipio union all

select 'MA' as Estado, 'Carolina' as Municipio union all

select 'MA' as Estado, 'Carutapera' as Municipio union all

select 'MA' as Estado, 'Caxias' as Municipio union all

select 'MA' as Estado, 'Cedral' as Municipio union all

select 'MA' as Estado, 'Central do Maranhão' as Municipio union all

select 'MA' as Estado, 'Centro do Guilherme' as Municipio union all

select 'MA' as Estado, 'Centro Novo do Maranhão' as Municipio union all

select 'MA' as Estado, 'Chapadinha' as Municipio union all

select 'MA' as Estado, 'Cidelândia' as Municipio union all

select 'MA' as Estado, 'Codó' as Municipio union all

select 'MA' as Estado, 'Coelho Neto' as Municipio union all

select 'MA' as Estado, 'Colinas' as Municipio union all

select 'MA' as Estado, 'Conceição do Lago-Açu' as Municipio union all

select 'MA' as Estado, 'Coroatá' as Municipio union all

select 'MA' as Estado, 'Cururupu' as Municipio union all

select 'MA' as Estado, 'Davinópolis' as Municipio union all

select 'MA' as Estado, 'Dom Pedro' as Municipio union all

select 'MA' as Estado, 'Duque Bacelar' as Municipio union all

select 'MA' as Estado, 'Esperantinópolis' as Municipio union all

select 'MA' as Estado, 'Estreito' as Municipio union all

select 'MA' as Estado, 'Feira Nova do Maranhão' as Municipio union all

select 'MA' as Estado, 'Fernando Falcão' as Municipio union all

select 'MA' as Estado, 'Formosa da Serra Negra' as Municipio union all

select 'MA' as Estado, 'Fortaleza dos Nogueiras' as Municipio union all

select 'MA' as Estado, 'Fortuna' as Municipio union all

select 'MA' as Estado, 'Godofredo Viana' as Municipio union all

select 'MA' as Estado, 'Gonçalves Dias' as Municipio union all

select 'MA' as Estado, 'Governador Archer' as Municipio union all

select 'MA' as Estado, 'Governador Edison Lobão' as Municipio union all

select 'MA' as Estado, 'Governador Eugênio Barros' as Municipio union all

select 'MA' as Estado, 'Governador Luiz Rocha' as Municipio union all

select 'MA' as Estado, 'Governador Newton Bello' as Municipio union all

select 'MA' as Estado, 'Governador Nunes Freire' as Municipio union all

select 'MA' as Estado, 'Graça Aranha' as Municipio union all

select 'MA' as Estado, 'Grajaú' as Municipio union all

select 'MA' as Estado, 'Guimarães' as Municipio union all

select 'MA' as Estado, 'Humberto de Campos' as Municipio union all

select 'MA' as Estado, 'Icatu' as Municipio union all

select 'MA' as Estado, 'Igarapé do Meio' as Municipio union all

select 'MA' as Estado, 'Igarapé Grande' as Municipio union all

select 'MA' as Estado, 'Imperatriz' as Municipio union all

select 'MA' as Estado, 'Itaipava do Grajaú' as Municipio union all

select 'MA' as Estado, 'Itapecuru Mirim' as Municipio union all

select 'MA' as Estado, 'Itinga do Maranhão' as Municipio union all

select 'MA' as Estado, 'Jatobá' as Municipio union all

select 'MA' as Estado, 'Jenipapo dos Vieiras' as Municipio union all

select 'MA' as Estado, 'João Lisboa' as Municipio union all

select 'MA' as Estado, 'Joselândia' as Municipio union all

select 'MA' as Estado, 'Junco do Maranhão' as Municipio union all

select 'MA' as Estado, 'Lago da Pedra' as Municipio union all

select 'MA' as Estado, 'Lago do Junco' as Municipio union all

select 'MA' as Estado, 'Lago dos Rodrigues' as Municipio union all

select 'MA' as Estado, 'Lago Verde' as Municipio union all

select 'MA' as Estado, 'Lagoa do Mato' as Municipio union all

select 'MA' as Estado, 'Lagoa Grande do Maranhão' as Municipio union all

select 'MA' as Estado, 'Lajeado Novo' as Municipio union all

select 'MA' as Estado, 'Lima Campos' as Municipio union all

select 'MA' as Estado, 'Loreto' as Municipio union all

select 'MA' as Estado, 'Luís Domingues' as Municipio union all

select 'MA' as Estado, 'Magalhães de Almeida' as Municipio union all

select 'MA' as Estado, 'Maracaçumé' as Municipio union all

select 'MA' as Estado, 'Marajá do Sena' as Municipio union all

select 'MA' as Estado, 'Maranhãozinho' as Municipio union all

select 'MA' as Estado, 'Mata Roma' as Municipio union all

select 'MA' as Estado, 'Matinha' as Municipio union all

select 'MA' as Estado, 'Matões' as Municipio union all

select 'MA' as Estado, 'Matões do Norte' as Municipio union all

select 'MA' as Estado, 'Milagres do Maranhão' as Municipio union all

select 'MA' as Estado, 'Mirador' as Municipio union all

select 'MA' as Estado, 'Miranda do Norte' as Municipio union all

select 'MA' as Estado, 'Mirinzal' as Municipio union all

select 'MA' as Estado, 'Monção' as Municipio union all

select 'MA' as Estado, 'Montes Altos' as Municipio union all

select 'MA' as Estado, 'Morros' as Municipio union all

select 'MA' as Estado, 'Nina Rodrigues' as Municipio union all

select 'MA' as Estado, 'Nova Colinas' as Municipio union all

select 'MA' as Estado, 'Nova Iorque' as Municipio union all

select 'MA' as Estado, 'Nova Olinda do Maranhão' as Municipio union all

select 'MA' as Estado, 'Olho d''Água das Cunhãs' as Municipio union all

select 'MA' as Estado, 'Olinda Nova do Maranhão' as Municipio union all

select 'MA' as Estado, 'Paço do Lumiar' as Municipio union all

select 'MA' as Estado, 'Palmeirândia' as Municipio union all

select 'MA' as Estado, 'Paraibano' as Municipio union all

select 'MA' as Estado, 'Parnarama' as Municipio union all

select 'MA' as Estado, 'Passagem Franca' as Municipio union all

select 'MA' as Estado, 'Pastos Bons' as Municipio union all

select 'MA' as Estado, 'Paulino Neves' as Municipio union all

select 'MA' as Estado, 'Paulo Ramos' as Municipio union all

select 'MA' as Estado, 'Pedreiras' as Municipio union all

select 'MA' as Estado, 'Pedro do Rosário' as Municipio union all

select 'MA' as Estado, 'Penalva' as Municipio union all

select 'MA' as Estado, 'Peri Mirim' as Municipio union all

select 'MA' as Estado, 'Peritoró' as Municipio union all

select 'MA' as Estado, 'Pindaré-Mirim' as Municipio union all

select 'MA' as Estado, 'Pinheiro' as Municipio union all

select 'MA' as Estado, 'Pio XII' as Municipio union all

select 'MA' as Estado, 'Pirapemas' as Municipio union all

select 'MA' as Estado, 'Poção de Pedras' as Municipio union all

select 'MA' as Estado, 'Porto Franco' as Municipio union all

select 'MA' as Estado, 'Porto Rico do Maranhão' as Municipio union all

select 'MA' as Estado, 'Presidente Dutra' as Municipio union all

select 'MA' as Estado, 'Presidente Juscelino' as Municipio union all

select 'MA' as Estado, 'Presidente Médici' as Municipio union all

select 'MA' as Estado, 'Presidente Sarney' as Municipio union all

select 'MA' as Estado, 'Presidente Vargas' as Municipio union all

select 'MA' as Estado, 'Primeira Cruz' as Municipio union all

select 'MA' as Estado, 'Raposa' as Municipio union all

select 'MA' as Estado, 'Riachão' as Municipio union all

select 'MA' as Estado, 'Ribamar Fiquene' as Municipio union all

select 'MA' as Estado, 'Rosário' as Municipio union all

select 'MA' as Estado, 'Sambaíba' as Municipio union all

select 'MA' as Estado, 'Santa Filomena do Maranhão' as Municipio union all

select 'MA' as Estado, 'Santa Helena' as Municipio union all

select 'MA' as Estado, 'Santa Inês' as Municipio union all

select 'MA' as Estado, 'Santa Luzia' as Municipio union all

select 'MA' as Estado, 'Santa Luzia do Paruá' as Municipio union all

select 'MA' as Estado, 'Santa Quitéria do Maranhão' as Municipio union all

select 'MA' as Estado, 'Santa Rita' as Municipio union all

select 'MA' as Estado, 'Santana do Maranhão' as Municipio union all

select 'MA' as Estado, 'Santo Amaro do Maranhão' as Municipio union all

select 'MA' as Estado, 'Santo Antônio dos Lopes' as Municipio union all

select 'MA' as Estado, 'São Benedito do Rio Preto' as Municipio union all

select 'MA' as Estado, 'São Bento' as Municipio union all

select 'MA' as Estado, 'São Bernardo' as Municipio union all

select 'MA' as Estado, 'São Domingos do Azeitão' as Municipio union all

select 'MA' as Estado, 'São Domingos do Maranhão' as Municipio union all

select 'MA' as Estado, 'São Félix de Balsas' as Municipio union all

select 'MA' as Estado, 'São Francisco do Brejão' as Municipio union all

select 'MA' as Estado, 'São Francisco do Maranhão' as Municipio union all

select 'MA' as Estado, 'São João Batista' as Municipio union all

select 'MA' as Estado, 'São João do Carú' as Municipio union all

select 'MA' as Estado, 'São João do Paraíso' as Municipio union all

select 'MA' as Estado, 'São João do Soter' as Municipio union all

select 'MA' as Estado, 'São João dos Patos' as Municipio union all

select 'MA' as Estado, 'São José de Ribamar' as Municipio union all

select 'MA' as Estado, 'São José dos Basílios' as Municipio union all

select 'MA' as Estado, 'São Luís' as Municipio union all

select 'MA' as Estado, 'São Luís Gonzaga do Maranhão' as Municipio union all

select 'MA' as Estado, 'São Mateus do Maranhão' as Municipio union all

select 'MA' as Estado, 'São Pedro da Água Branca' as Municipio union all

select 'MA' as Estado, 'São Pedro dos Crentes' as Municipio union all

select 'MA' as Estado, 'São Raimundo das Mangabeiras' as Municipio union all

select 'MA' as Estado, 'São Raimundo do Doca Bezerra' as Municipio union all

select 'MA' as Estado, 'São Roberto' as Municipio union all

select 'MA' as Estado, 'São Vicente Ferrer' as Municipio union all

select 'MA' as Estado, 'Satubinha' as Municipio union all

select 'MA' as Estado, 'Senador Alexandre Costa' as Municipio union all

select 'MA' as Estado, 'Senador La Rocque' as Municipio union all

select 'MA' as Estado, 'Serrano do Maranhão' as Municipio union all

select 'MA' as Estado, 'Sítio Novo' as Municipio union all

select 'MA' as Estado, 'Sucupira do Norte' as Municipio union all

select 'MA' as Estado, 'Sucupira do Riachão' as Municipio union all

select 'MA' as Estado, 'Tasso Fragoso' as Municipio union all

select 'MA' as Estado, 'Timbiras' as Municipio union all

select 'MA' as Estado, 'Timon' as Municipio union all

select 'MA' as Estado, 'Trizidela do Vale' as Municipio union all

select 'MA' as Estado, 'Tufilândia' as Municipio union all

select 'MA' as Estado, 'Tuntum' as Municipio union all

select 'MA' as Estado, 'Turiaçu' as Municipio union all

select 'MA' as Estado, 'Turilândia' as Municipio union all

select 'MA' as Estado, 'Tutóia' as Municipio union all

select 'MA' as Estado, 'Urbano Santos' as Municipio union all

select 'MA' as Estado, 'Vargem Grande' as Municipio union all

select 'MA' as Estado, 'Viana' as Municipio union all

select 'MA' as Estado, 'Vila Nova dos Martírios' as Municipio union all

select 'MA' as Estado, 'Vitória do Mearim' as Municipio union all

select 'MA' as Estado, 'Vitorino Freire' as Municipio union all

select 'MA' as Estado, 'Zé Doca' as Municipio union all

select 'PI' as Estado, 'Acauã' as Municipio union all

select 'PI' as Estado, 'Agricolândia' as Municipio union all

select 'PI' as Estado, 'Água Branca' as Municipio union all

select 'PI' as Estado, 'Alagoinha do Piauí' as Municipio union all

select 'PI' as Estado, 'Alegrete do Piauí' as Municipio union all

select 'PI' as Estado, 'Alto Longá' as Municipio union all

select 'PI' as Estado, 'Altos' as Municipio union all

select 'PI' as Estado, 'Alvorada do Gurguéia' as Municipio union all

select 'PI' as Estado, 'Amarante' as Municipio union all

select 'PI' as Estado, 'Angical do Piauí' as Municipio union all

select 'PI' as Estado, 'Anísio de Abreu' as Municipio union all

select 'PI' as Estado, 'Antônio Almeida' as Municipio union all

select 'PI' as Estado, 'Aroazes' as Municipio union all

select 'PI' as Estado, 'Aroeiras do Itaim' as Municipio union all

select 'PI' as Estado, 'Arraial' as Municipio union all

select 'PI' as Estado, 'Assunção do Piauí' as Municipio union all

select 'PI' as Estado, 'Avelino Lopes' as Municipio union all

select 'PI' as Estado, 'Baixa Grande do Ribeiro' as Municipio union all

select 'PI' as Estado, 'Barra D''Alcântara' as Municipio union all

select 'PI' as Estado, 'Barras' as Municipio union all

select 'PI' as Estado, 'Barreiras do Piauí' as Municipio union all

select 'PI' as Estado, 'Barro Duro' as Municipio union all

select 'PI' as Estado, 'Batalha' as Municipio union all

select 'PI' as Estado, 'Bela Vista do Piauí' as Municipio union all

select 'PI' as Estado, 'Belém do Piauí' as Municipio union all

select 'PI' as Estado, 'Beneditinos' as Municipio union all

select 'PI' as Estado, 'Bertolínia' as Municipio union all

select 'PI' as Estado, 'Betânia do Piauí' as Municipio union all

select 'PI' as Estado, 'Boa Hora' as Municipio union all

select 'PI' as Estado, 'Bocaina' as Municipio union all

select 'PI' as Estado, 'Bom Jesus' as Municipio union all

select 'PI' as Estado, 'Bom Princípio do Piauí' as Municipio union all

select 'PI' as Estado, 'Bonfim do Piauí' as Municipio union all

select 'PI' as Estado, 'Boqueirão do Piauí' as Municipio union all

select 'PI' as Estado, 'Brasileira' as Municipio union all

select 'PI' as Estado, 'Brejo do Piauí' as Municipio union all

select 'PI' as Estado, 'Buriti dos Lopes' as Municipio union all

select 'PI' as Estado, 'Buriti dos Montes' as Municipio union all

select 'PI' as Estado, 'Cabeceiras do Piauí' as Municipio union all

select 'PI' as Estado, 'Cajazeiras do Piauí' as Municipio union all

select 'PI' as Estado, 'Cajueiro da Praia' as Municipio union all

select 'PI' as Estado, 'Caldeirão Grande do Piauí' as Municipio union all

select 'PI' as Estado, 'Campinas do Piauí' as Municipio union all

select 'PI' as Estado, 'Campo Alegre do Fidalgo' as Municipio union all

select 'PI' as Estado, 'Campo Grande do Piauí' as Municipio union all

select 'PI' as Estado, 'Campo Largo do Piauí' as Municipio union all

select 'PI' as Estado, 'Campo Maior' as Municipio union all

select 'PI' as Estado, 'Canavieira' as Municipio union all

select 'PI' as Estado, 'Canto do Buriti' as Municipio union all

select 'PI' as Estado, 'Capitão de Campos' as Municipio union all

select 'PI' as Estado, 'Capitão Gervásio Oliveira' as Municipio union all

select 'PI' as Estado, 'Caracol' as Municipio union all

select 'PI' as Estado, 'Caraúbas do Piauí' as Municipio union all

select 'PI' as Estado, 'Caridade do Piauí' as Municipio union all

select 'PI' as Estado, 'Castelo do Piauí' as Municipio union all

select 'PI' as Estado, 'Caxingó' as Municipio union all

select 'PI' as Estado, 'Cocal' as Municipio union all

select 'PI' as Estado, 'Cocal de Telha' as Municipio union all

select 'PI' as Estado, 'Cocal dos Alves' as Municipio union all

select 'PI' as Estado, 'Coivaras' as Municipio union all

select 'PI' as Estado, 'Colônia do Gurguéia' as Municipio union all

select 'PI' as Estado, 'Colônia do Piauí' as Municipio union all

select 'PI' as Estado, 'Conceição do Canindé' as Municipio union all

select 'PI' as Estado, 'Coronel José Dias' as Municipio union all

select 'PI' as Estado, 'Corrente' as Municipio union all

select 'PI' as Estado, 'Cristalândia do Piauí' as Municipio union all

select 'PI' as Estado, 'Cristino Castro' as Municipio union all

select 'PI' as Estado, 'Curimatá' as Municipio union all

select 'PI' as Estado, 'Currais' as Municipio union all

select 'PI' as Estado, 'Curral Novo do Piauí' as Municipio union all

select 'PI' as Estado, 'Curralinhos' as Municipio union all

select 'PI' as Estado, 'Demerval Lobão' as Municipio union all

select 'PI' as Estado, 'Dirceu Arcoverde' as Municipio union all

select 'PI' as Estado, 'Dom Expedito Lopes' as Municipio union all

select 'PI' as Estado, 'Dom Inocêncio' as Municipio union all

select 'PI' as Estado, 'Domingos Mourão' as Municipio union all

select 'PI' as Estado, 'Elesbão Veloso' as Municipio union all

select 'PI' as Estado, 'Eliseu Martins' as Municipio union all

select 'PI' as Estado, 'Esperantina' as Municipio union all

select 'PI' as Estado, 'Fartura do Piauí' as Municipio union all

select 'PI' as Estado, 'Flores do Piauí' as Municipio union all

select 'PI' as Estado, 'Floresta do Piauí' as Municipio union all

select 'PI' as Estado, 'Floriano' as Municipio union all

select 'PI' as Estado, 'Francinópolis' as Municipio union all

select 'PI' as Estado, 'Francisco Ayres' as Municipio union all

select 'PI' as Estado, 'Francisco Macedo' as Municipio union all

select 'PI' as Estado, 'Francisco Santos' as Municipio union all

select 'PI' as Estado, 'Fronteiras' as Municipio union all

select 'PI' as Estado, 'Geminiano' as Municipio union all

select 'PI' as Estado, 'Gilbués' as Municipio union all

select 'PI' as Estado, 'Guadalupe' as Municipio union all

select 'PI' as Estado, 'Guaribas' as Municipio union all

select 'PI' as Estado, 'Hugo Napoleão' as Municipio union all

select 'PI' as Estado, 'Ilha Grande' as Municipio union all

select 'PI' as Estado, 'Inhuma' as Municipio union all

select 'PI' as Estado, 'Ipiranga do Piauí' as Municipio union all

select 'PI' as Estado, 'Isaías Coelho' as Municipio union all

select 'PI' as Estado, 'Itainópolis' as Municipio union all

select 'PI' as Estado, 'Itaueira' as Municipio union all

select 'PI' as Estado, 'Jacobina do Piauí' as Municipio union all

select 'PI' as Estado, 'Jaicós' as Municipio union all

select 'PI' as Estado, 'Jardim do Mulato' as Municipio union all

select 'PI' as Estado, 'Jatobá do Piauí' as Municipio union all

select 'PI' as Estado, 'Jerumenha' as Municipio union all

select 'PI' as Estado, 'João Costa' as Municipio union all

select 'PI' as Estado, 'Joaquim Pires' as Municipio union all

select 'PI' as Estado, 'Joca Marques' as Municipio union all

select 'PI' as Estado, 'José de Freitas' as Municipio union all

select 'PI' as Estado, 'Juazeiro do Piauí' as Municipio union all

select 'PI' as Estado, 'Júlio Borges' as Municipio union all

select 'PI' as Estado, 'Jurema' as Municipio union all

select 'PI' as Estado, 'Lagoa Alegre' as Municipio union all

select 'PI' as Estado, 'Lagoa de São Francisco' as Municipio union all

select 'PI' as Estado, 'Lagoa do Barro do Piauí' as Municipio union all

select 'PI' as Estado, 'Lagoa do Piauí' as Municipio union all

select 'PI' as Estado, 'Lagoa do Sítio' as Municipio union all

select 'PI' as Estado, 'Lagoinha do Piauí' as Municipio union all

select 'PI' as Estado, 'Landri Sales' as Municipio union all

select 'PI' as Estado, 'Luís Correia' as Municipio union all

select 'PI' as Estado, 'Luzilândia' as Municipio union all

select 'PI' as Estado, 'Madeiro' as Municipio union all

select 'PI' as Estado, 'Manoel Emídio' as Municipio union all

select 'PI' as Estado, 'Marcolândia' as Municipio union all

select 'PI' as Estado, 'Marcos Parente' as Municipio union all

select 'PI' as Estado, 'Massapê do Piauí' as Municipio union all

select 'PI' as Estado, 'Matias Olímpio' as Municipio union all

select 'PI' as Estado, 'Miguel Alves' as Municipio union all

select 'PI' as Estado, 'Miguel Leão' as Municipio union all

select 'PI' as Estado, 'Milton Brandão' as Municipio union all

select 'PI' as Estado, 'Monsenhor Gil' as Municipio union all

select 'PI' as Estado, 'Monsenhor Hipólito' as Municipio union all

select 'PI' as Estado, 'Monte Alegre do Piauí' as Municipio union all

select 'PI' as Estado, 'Morro Cabeça no Tempo' as Municipio union all

select 'PI' as Estado, 'Morro do Chapéu do Piauí' as Municipio union all

select 'PI' as Estado, 'Murici dos Portelas' as Municipio union all

select 'PI' as Estado, 'Nazaré do Piauí' as Municipio union all

select 'PI' as Estado, 'Nossa Senhora de Nazaré' as Municipio union all

select 'PI' as Estado, 'Nossa Senhora dos Remédios' as Municipio union all

select 'PI' as Estado, 'Nova Santa Rita' as Municipio union all

select 'PI' as Estado, 'Novo Oriente do Piauí' as Municipio union all

select 'PI' as Estado, 'Novo Santo Antônio' as Municipio union all

select 'PI' as Estado, 'Oeiras' as Municipio union all

select 'PI' as Estado, 'Olho D''Água do Piauí' as Municipio union all

select 'PI' as Estado, 'Padre Marcos' as Municipio union all

select 'PI' as Estado, 'Paes Landim' as Municipio union all

select 'PI' as Estado, 'Pajeú do Piauí' as Municipio union all

select 'PI' as Estado, 'Palmeira do Piauí' as Municipio union all

select 'PI' as Estado, 'Palmeirais' as Municipio union all

select 'PI' as Estado, 'Paquetá' as Municipio union all

select 'PI' as Estado, 'Parnaguá' as Municipio union all

select 'PI' as Estado, 'Parnaíba' as Municipio union all

select 'PI' as Estado, 'Passagem Franca do Piauí' as Municipio union all

select 'PI' as Estado, 'Patos do Piauí' as Municipio union all

select 'PI' as Estado, 'Pau D''Arco do Piauí' as Municipio union all

select 'PI' as Estado, 'Paulistana' as Municipio union all

select 'PI' as Estado, 'Pavussu' as Municipio union all

select 'PI' as Estado, 'Pedro II' as Municipio union all

select 'PI' as Estado, 'Pedro Laurentino' as Municipio union all

select 'PI' as Estado, 'Picos' as Municipio union all

select 'PI' as Estado, 'Pimenteiras' as Municipio union all

select 'PI' as Estado, 'Pio IX' as Municipio union all

select 'PI' as Estado, 'Piracuruca' as Municipio union all

select 'PI' as Estado, 'Piripiri' as Municipio union all

select 'PI' as Estado, 'Porto' as Municipio union all

select 'PI' as Estado, 'Porto Alegre do Piauí' as Municipio union all

select 'PI' as Estado, 'Prata do Piauí' as Municipio union all

select 'PI' as Estado, 'Queimada Nova' as Municipio union all

select 'PI' as Estado, 'Redenção do Gurguéia' as Municipio union all

select 'PI' as Estado, 'Regeneração' as Municipio union all

select 'PI' as Estado, 'Riacho Frio' as Municipio union all

select 'PI' as Estado, 'Ribeira do Piauí' as Municipio union all

select 'PI' as Estado, 'Ribeiro Gonçalves' as Municipio union all

select 'PI' as Estado, 'Rio Grande do Piauí' as Municipio union all

select 'PI' as Estado, 'Santa Cruz do Piauí' as Municipio union all

select 'PI' as Estado, 'Santa Cruz dos Milagres' as Municipio union all

select 'PI' as Estado, 'Santa Filomena' as Municipio union all

select 'PI' as Estado, 'Santa Luz' as Municipio union all

select 'PI' as Estado, 'Santa Rosa do Piauí' as Municipio union all

select 'PI' as Estado, 'Santana do Piauí' as Municipio union all

select 'PI' as Estado, 'Santo Antônio de Lisboa' as Municipio union all

select 'PI' as Estado, 'Santo Antônio dos Milagres' as Municipio union all

select 'PI' as Estado, 'Santo Inácio do Piauí' as Municipio union all

select 'PI' as Estado, 'São Braz do Piauí' as Municipio union all

select 'PI' as Estado, 'São Félix do Piauí' as Municipio union all

select 'PI' as Estado, 'São Francisco de Assis do Piauí' as Municipio union all

select 'PI' as Estado, 'São Francisco do Piauí' as Municipio union all

select 'PI' as Estado, 'São Gonçalo do Gurguéia' as Municipio union all

select 'PI' as Estado, 'São Gonçalo do Piauí' as Municipio union all

select 'PI' as Estado, 'São João da Canabrava' as Municipio union all

select 'PI' as Estado, 'São João da Fronteira' as Municipio union all

select 'PI' as Estado, 'São João da Serra' as Municipio union all

select 'PI' as Estado, 'São João da Varjota' as Municipio union all

select 'PI' as Estado, 'São João do Arraial' as Municipio union all

select 'PI' as Estado, 'São João do Piauí' as Municipio union all

select 'PI' as Estado, 'São José do Divino' as Municipio union all

select 'PI' as Estado, 'São José do Peixe' as Municipio union all

select 'PI' as Estado, 'São José do Piauí' as Municipio union all

select 'PI' as Estado, 'São Julião' as Municipio union all

select 'PI' as Estado, 'São Lourenço do Piauí' as Municipio union all

select 'PI' as Estado, 'São Luis do Piauí' as Municipio union all

select 'PI' as Estado, 'São Miguel da Baixa Grande' as Municipio union all

select 'PI' as Estado, 'São Miguel do Fidalgo' as Municipio union all

select 'PI' as Estado, 'São Miguel do Tapuio' as Municipio union all

select 'PI' as Estado, 'São Pedro do Piauí' as Municipio union all

select 'PI' as Estado, 'São Raimundo Nonato' as Municipio union all

select 'PI' as Estado, 'Sebastião Barros' as Municipio union all

select 'PI' as Estado, 'Sebastião Leal' as Municipio union all

select 'PI' as Estado, 'Sigefredo Pacheco' as Municipio union all

select 'PI' as Estado, 'Simões' as Municipio union all

select 'PI' as Estado, 'Simplício Mendes' as Municipio union all

select 'PI' as Estado, 'Socorro do Piauí' as Municipio union all

select 'PI' as Estado, 'Sussuapara' as Municipio union all

select 'PI' as Estado, 'Tamboril do Piauí' as Municipio union all

select 'PI' as Estado, 'Tanque do Piauí' as Municipio union all

select 'PI' as Estado, 'Teresina' as Municipio union all

select 'PI' as Estado, 'União' as Municipio union all

select 'PI' as Estado, 'Uruçuí' as Municipio union all

select 'PI' as Estado, 'Valença do Piauí' as Municipio union all

select 'PI' as Estado, 'Várzea Branca' as Municipio union all

select 'PI' as Estado, 'Várzea Grande' as Municipio union all

select 'PI' as Estado, 'Vera Mendes' as Municipio union all

select 'PI' as Estado, 'Vila Nova do Piauí' as Municipio union all

select 'PI' as Estado, 'Wall Ferraz' as Municipio union all

select 'CE' as Estado, 'Abaiara' as Municipio union all

select 'CE' as Estado, 'Acarape' as Municipio union all

select 'CE' as Estado, 'Acaraú' as Municipio union all

select 'CE' as Estado, 'Acopiara' as Municipio union all

select 'CE' as Estado, 'Aiuaba' as Municipio union all

select 'CE' as Estado, 'Alcântaras' as Municipio union all

select 'CE' as Estado, 'Altaneira' as Municipio union all

select 'CE' as Estado, 'Alto Santo' as Municipio union all

select 'CE' as Estado, 'Amontada' as Municipio union all

select 'CE' as Estado, 'Antonina do Norte' as Municipio union all

select 'CE' as Estado, 'Apuiarés' as Municipio union all

select 'CE' as Estado, 'Aquiraz' as Municipio union all

select 'CE' as Estado, 'Aracati' as Municipio union all

select 'CE' as Estado, 'Aracoiaba' as Municipio union all

select 'CE' as Estado, 'Ararendá' as Municipio union all

select 'CE' as Estado, 'Araripe' as Municipio union all

select 'CE' as Estado, 'Aratuba' as Municipio union all

select 'CE' as Estado, 'Arneiroz' as Municipio union all

select 'CE' as Estado, 'Assaré' as Municipio union all

select 'CE' as Estado, 'Aurora' as Municipio union all

select 'CE' as Estado, 'Baixio' as Municipio union all

select 'CE' as Estado, 'Banabuiú' as Municipio union all

select 'CE' as Estado, 'Barbalha' as Municipio union all

select 'CE' as Estado, 'Barreira' as Municipio union all

select 'CE' as Estado, 'Barro' as Municipio union all

select 'CE' as Estado, 'Barroquinha' as Municipio union all

select 'CE' as Estado, 'Baturité' as Municipio union all

select 'CE' as Estado, 'Beberibe' as Municipio union all

select 'CE' as Estado, 'Bela Cruz' as Municipio union all

select 'CE' as Estado, 'Boa Viagem' as Municipio union all

select 'CE' as Estado, 'Brejo Santo' as Municipio union all

select 'CE' as Estado, 'Camocim' as Municipio union all

select 'CE' as Estado, 'Campos Sales' as Municipio union all

select 'CE' as Estado, 'Canindé' as Municipio union all

select 'CE' as Estado, 'Capistrano' as Municipio union all

select 'CE' as Estado, 'Caridade' as Municipio union all

select 'CE' as Estado, 'Cariré' as Municipio union all

select 'CE' as Estado, 'Caririaçu' as Municipio union all

select 'CE' as Estado, 'Cariús' as Municipio union all

select 'CE' as Estado, 'Carnaubal' as Municipio union all

select 'CE' as Estado, 'Cascavel' as Municipio union all

select 'CE' as Estado, 'Catarina' as Municipio union all

select 'CE' as Estado, 'Catunda' as Municipio union all

select 'CE' as Estado, 'Caucaia' as Municipio union all

select 'CE' as Estado, 'Cedro' as Municipio union all

select 'CE' as Estado, 'Chaval' as Municipio union all

select 'CE' as Estado, 'Choró' as Municipio union all

select 'CE' as Estado, 'Chorozinho' as Municipio union all

select 'CE' as Estado, 'Coreaú' as Municipio union all

select 'CE' as Estado, 'Crateús' as Municipio union all

select 'CE' as Estado, 'Crato' as Municipio union all

select 'CE' as Estado, 'Croatá' as Municipio union all

select 'CE' as Estado, 'Cruz' as Municipio union all

select 'CE' as Estado, 'Deputado Irapuan Pinheiro' as Municipio union all

select 'CE' as Estado, 'Ererê' as Municipio union all

select 'CE' as Estado, 'Eusébio' as Municipio union all

select 'CE' as Estado, 'Farias Brito' as Municipio union all