SET NAMES utf8mb4;

CREATE TABLE IF NOT EXISTS crefaz_coverage_cities (
  state VARCHAR(2) NOT NULL,
  city VARCHAR(120) NOT NULL,
  PRIMARY KEY (state, city)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT IGNORE INTO crefaz_coverage_cities (state, city) VALUES
('BA','ABAIRA'),
('BA','ABARE'),
('BA','ACAJUTIBA'),
('BA','ADUSTINA'),
('BA','AGUA FRIA'),
('BA','AIQUARA'),
('BA','ALAGOINHAS'),
('BA','ALCOBACA'),
('BA','ALMADINA'),
('BA','AMARGOSA'),
('BA','AMELIA RODRIGUES'),
('BA','AMERICA DOURADA'),
('BA','ANAGE'),
('BA','ANDARAI'),
('BA','ANDORINHA'),
('BA','ANGICAL'),
('BA','ANGUERA'),
('BA','ANTAS'),
('BA','ANTONIO CARDOSO'),
('BA','ANTONIO GONCALVES'),
('BA','APORA'),
('BA','APUAREMA'),
('BA','ARACAS'),
('BA','ARACATU'),
('BA','ARACI'),
('BA','ARAMARI'),
('BA','ARATACA'),
('BA','ARATUIPE'),
('BA','AURELINO LEAL'),
('BA','BAIANOPOLIS'),
('BA','BAIXA GRANDE'),
('BA','BANZAE'),
('BA','BARRA'),
('BA','BARRA DA ESTIVA'),
('BA','BARRA DO CHOCA'),
('BA','BARRA DO MENDES'),
('BA','BARRA DO ROCHA'),
('BA','BARREIRAS'),
('BA','BARRO ALTO'),
('BA','BARROCAS'),
('BA','BELMONTE'),
('BA','BELO CAMPO'),
('BA','BIRITINGA'),
('BA','BOA NOVA'),
('BA','BOA VISTA DO TUPIM'),
('BA','BOM JESUS DA LAPA'),
('BA','BOM JESUS DA SERRA'),
('BA','BONINAL'),
('BA','BONITO'),
('BA','BOQUIRA'),
('BA','BOTUPORA'),
('BA','BREJOES'),
('BA','BREJOLANDIA'),
('BA','BROTAS DE MACAUBAS'),
('BA','BRUMADO'),
('BA','BUERAREMA'),
('BA','BURITIRAMA'),
('BA','CAATIBA'),
('BA','CABACEIRAS DO PARAGUACU'),
('BA','CACHOEIRA'),
('BA','CACULE'),
('BA','CAEM'),
('BA','CAETANOS'),
('BA','CAETITE'),
('BA','CAFARNAUM'),
('BA','CAIRU'),
('BA','CALDEIRAO GRANDE'),
('BA','CAMACAN'),
('BA','CAMACARI'),
('BA','CAMAMU'),
('BA','CAMPO ALEGRE DE LOURDES'),
('BA','CAMPO FORMOSO'),
('BA','CANAPOLIS'),
('BA','CANARANA'),
('BA','CANAVIEIRAS'),
('BA','CANDEAL'),
('BA','CANDEIAS'),
('BA','CANDIBA'),
('BA','CANDIDO SALES'),
('BA','CANSANCAO'),
('BA','CANUDOS'),
('BA','CAPELA DO ALTO ALEGRE'),
('BA','CAPIM GROSSO'),
('BA','CARAIBAS'),
('BA','CARAVELAS'),
('BA','CARDEAL DA SILVA'),
('BA','CARINHANHA'),
('BA','CASA NOVA'),
('BA','CASTRO ALVES'),
('BA','CATOLANDIA'),
('BA','CATU'),
('BA','CATURAMA'),
('BA','CENTRAL'),
('BA','CHORROCHO'),
('BA','CICERO DANTAS'),
('BA','CIPO'),
('BA','COARACI'),
('BA','COCOS'),
('BA','CONCEICAO DA FEIRA'),
('BA','CONCEICAO DO ALMEIDA'),
('BA','CONCEICAO DO COITE'),
('BA','CONCEICAO DO JACUIPE'),
('BA','CONDE'),
('BA','CONDEUBA'),
('BA','CONTENDAS DO SINCORA'),
('BA','CORACAO DE MARIA'),
('BA','CORDEIROS'),
('BA','CORIBE'),
('BA','CORONEL JOAO SA'),
('BA','CORRENTINA'),
('BA','COTEGIPE'),
('BA','CRAVOLANDIA'),
('BA','CRISOPOLIS'),
('BA','CRISTOPOLIS'),
('BA','CRUZ DAS ALMAS'),
('BA','CURACA'),
('BA','DARIO MEIRA'),
('BA','DIAS D AVILA'),
('BA','DOM BASILIO'),
('BA','DOM MACEDO COSTA'),
('BA','ELISIO MEDRADO'),
('BA','ENCRUZILHADA'),
('BA','ENTRE RIOS'),
('BA','ERICO CARDOSO'),
('BA','ESPLANADA'),
('BA','EUCLIDES DA CUNHA'),
('BA','EUNAPOLIS'),
('BA','FATIMA'),
('BA','FEIRA DA MATA'),
('BA','FEIRA DE SANTANA'),
('BA','FILADELFIA'),
('BA','FIRMINO ALVES'),
('BA','FLORESTA AZUL'),
('BA','FORMOSA DO RIO PRETO'),
('BA','GANDU'),
('BA','GAVIAO'),
('BA','GENTIO DO OURO'),
('BA','GLORIA'),
('BA','GONGOGI'),
('BA','GOVERNADOR MANGABEIRA'),
('BA','GUAJERU'),
('BA','GUANAMBI'),
('BA','GUARATINGA'),
('BA','HELIOPOLIS'),
('BA','IACU'),
('BA','IBIASSUCE'),
('BA','IBICARAI'),
('BA','IBICOARA'),
('BA','IBICUI'),
('BA','IBIPEBA'),
('BA','IBIPITANGA'),
('BA','IBIQUERA'),
('BA','IBIRAPITANGA'),
('BA','IBIRAPUA'),
('BA','IBIRATAIA'),
('BA','IBITIARA'),
('BA','IBITITA'),
('BA','IBOTIRAMA'),
('BA','ICHU'),
('BA','IGAPORA'),
('BA','IGRAPIUNA'),
('BA','IGUAI'),
('BA','ILHEUS'),
('BA','INHAMBUPE'),
('BA','IPECAETA'),
('BA','IPIAU'),
('BA','IPIRA'),
('BA','IPUPIARA'),
('BA','IRAJUBA'),
('BA','IRAMAIA'),
('BA','IRAQUARA'),
('BA','IRARA'),
('BA','IRECE'),
('BA','ITABELA'),
('BA','ITABERABA'),
('BA','ITABUNA'),
('BA','ITACARE'),
('BA','ITAETE'),
('BA','ITAGI'),
('BA','ITAGIBA'),
('BA','ITAGIMIRIM'),
('BA','ITAGUACU DA BAHIA'),
('BA','ITAJU DO COLONIA'),
('BA','ITAJUIPE'),
('BA','ITAMARAJU'),
('BA','ITAMARI'),
('BA','ITAMBE'),
('BA','ITANAGRA'),
('BA','ITANHEM'),
('BA','ITAPARICA'),
('BA','ITAPE'),
('BA','ITAPEBI'),
('BA','ITAPETINGA'),
('BA','ITAPICURU'),
('BA','ITAPITANGA'),
('BA','ITAQUARA'),
('BA','ITARANTIM'),
('BA','ITATIM'),
('BA','ITIRUCU'),
('BA','ITIUBA'),
('BA','ITORORO'),
('BA','ITUACU'),
('BA','ITUBERA'),
('BA','IUIU'),
('BA','JABORANDI'),
('BA','JACARACI'),
('BA','JACOBINA'),
('BA','JAGUAQUARA'),
('BA','JAGUARARI'),
('BA','JAGUARIPE'),
('BA','JEQUIE'),
('BA','JEREMOABO'),
('BA','JIQUIRICA'),
('BA','JITAUNA'),
('BA','JOAO DOURADO'),
('BA','JUAZEIRO'),
('BA','JUCURUCU'),
('BA','JUSSARA'),
('BA','JUSSARI'),
('BA','JUSSIAPE'),
('BA','LAFAIETE COUTINHO'),
('BA','LAGOA REAL'),
('BA','LAJE'),
('BA','LAJEDAO'),
('BA','LAJEDINHO'),
('BA','LAJEDO DO TABOCAL'),
('BA','LAMARAO'),
('BA','LAPAO'),
('BA','LAURO DE FREITAS'),
('BA','LENCOIS'),
('BA','LICINIO DE ALMEIDA'),
('BA','LIVRAMENTO DE NOSSA SENHORA'),
('BA','LUIS EDUARDO MAGALHAES'),
('BA','MACAJUBA'),
('BA','MACARANI'),
('BA','MACAUBAS'),
('BA','MACURURE'),
('BA','MADRE DE DEUS'),
('BA','MAETINGA'),
('BA','MAIQUINIQUE'),
('BA','MAIRI'),
('BA','MALHADA'),
('BA','MALHADA DE PEDRAS'),
('BA','MANOEL VITORINO'),
('BA','MANSIDAO'),
('BA','MARACAS'),
('BA','MARAGOGIPE'),
('BA','MARAU'),
('BA','MARCIONILIO SOUZA'),
('BA','MASCOTE'),
('BA','MATA DE SAO JOAO'),
('BA','MATINA'),
('BA','MEDEIROS NETO'),
('BA','MIGUEL CALMON'),
('BA','MILAGRES'),
('BA','MIRANGABA'),
('BA','MIRANTE'),
('BA','MONTE SANTO'),
('BA','MORPARA'),
('BA','MORRO DO CHAPEU'),
('BA','MORTUGABA'),
('BA','MUCUGE'),
('BA','MUCURI'),
('BA','MULUNGU DO MORRO'),
('BA','MUNDO NOVO'),
('BA','MUNIZ FERREIRA'),
('BA','MURITIBA'),
('BA','MUTUIPE'),
('BA','NAZARE'),
('BA','NILO PECANHA'),
('BA','NORDESTINA'),
('BA','NOVA CANAA'),
('BA','NOVA FATIMA'),
('BA','NOVA IBIA'),
('BA','NOVA ITARANA'),
('BA','NOVA REDENCAO'),
('BA','NOVA SOURE'),
('BA','NOVA VICOSA'),
('BA','NOVO HORIZONTE'),
('BA','NOVO TRIUNFO'),
('BA','OLINDINA'),
('BA','OLIVEIRA DOS BREJINHOS'),
('BA','OURICANGAS'),
('BA','OUROLANDIA'),
('BA','PALMAS DE MONTE ALTO'),
('BA','PALMEIRAS'),
('BA','PARAMIRIM'),
('BA','PARATINGA'),
('BA','PARIPIRANGA'),
('BA','PAU BRASIL'),
('BA','PAULO AFONSO'),
('BA','PE DE SERRA'),
('BA','PEDRAO'),
('BA','PEDRO ALEXANDRE'),
('BA','PIATA'),
('BA','PILAO ARCADO'),
('BA','PINDAI'),
('BA','PINDOBACU'),
('BA','PINTADAS'),
('BA','PIRAI DO NORTE'),
('BA','PIRIPA'),
('BA','PIRITIBA'),
('BA','PLANALTINO'),
('BA','PLANALTO'),
('BA','POCOES'),
('BA','POJUCA'),
('BA','PONTO NOVO'),
('BA','PORTO SEGURO'),
('BA','POTIRAGUA'),
('BA','PRADO'),
('BA','PRESIDENTE DUTRA'),
('BA','PRESIDENTE JANIO QUADROS'),
('BA','PRESIDENTE TANCREDO NEVES'),
('BA','QUEIMADAS'),
('BA','QUIJINGUE'),
('BA','QUIXABEIRA'),
('BA','RAFAEL JAMBEIRO'),
('BA','REMANSO'),
('BA','RETIROLANDIA'),
('BA','RIACHAO DAS NEVES'),
('BA','RIACHAO DO JACUIPE'),
('BA','RIACHO DE SANTANA'),
('BA','RIBEIRA DO AMPARO'),
('BA','RIBEIRA DO POMBAL'),
('BA','RIBEIRAO DO LARGO'),
('BA','RIO DE CONTAS'),
('BA','RIO DO ANTONIO'),
('BA','RIO DO PIRES'),
('BA','RODELAS'),
('BA','RUY BARBOSA'),
('BA','SALINAS DA MARGARIDA'),
('BA','SALVADOR'),
('BA','SANTA BARBARA'),
('BA','SANTA BRIGIDA'),
('BA','SANTA CRUZ CABRALIA'),
('BA','SANTA CRUZ DA VITORIA'),
('BA','SANTA INES'),
('BA','SANTA LUZIA'),
('BA','SANTA MARIA DA VITORIA'),
('BA','SANTA RITA DE CASSIA'),
('BA','SANTALUZ'),
('BA','SANTANA'),
('BA','SANTANOPOLIS'),
('BA','SANTO AMARO'),
('BA','SANTO ANTONIO DE JESUS'),
('BA','SANTO ESTEVAO'),
('BA','SAO DESIDERIO'),
('BA','SAO DOMINGOS'),
('BA','SAO FELIPE'),
('BA','SAO FELIX'),
('BA','SAO FELIX DO CORIBE'),
('BA','SAO FRANCISCO DO CONDE'),
('BA','SAO GABRIEL'),
('BA','SAO GONCALO DOS CAMPOS'),
('BA','SAO JOSE DA VITORIA'),
('BA','SAO JOSE DO JACUIPE'),
('BA','SAO MIGUEL DAS MATAS'),
('BA','SAO SEBASTIAO DO PASSE'),
('BA','SAPEACU'),
('BA','SATIRO DIAS'),
('BA','SAUBARA'),
('BA','SAUDE'),
('BA','SEABRA'),
('BA','SEBASTIAO LARANJEIRAS'),
('BA','SENHOR DO BONFIM'),
('BA','SENTO SE'),
('BA','SERRA DO RAMALHO'),
('BA','SERRA DOURADA'),
('BA','SERRA PRETA'),
('BA','SERRINHA'),
('BA','SERROLANDIA'),
('BA','SIMOES FILHO'),
('BA','SITIO DO MATO'),
('BA','SITIO DO QUINTO'),
('BA','SOBRADINHO'),
('BA','SOUTO SOARES'),
('BA','TABOCAS DO BREJO VELHO'),
('BA','TANHACU'),
('BA','TANQUE NOVO'),
('BA','TANQUINHO'),
('BA','TAPEROA'),
('BA','TAPIRAMUTA'),
('BA','TEIXEIRA DE FREITAS'),
('BA','TEODORO SAMPAIO'),
('BA','TEOFILANDIA'),
('BA','TEOLANDIA'),
('BA','TERRA NOVA'),
('BA','TREMEDAL'),
('BA','TUCANO'),
('BA','UAUA'),
('BA','UBAIRA'),
('BA','UBAITABA'),
('BA','UBATA'),
('BA','UIBAI'),
('BA','UMBURANAS'),
('BA','UNA'),
('BA','URANDI'),
('BA','URUCUCA'),
('BA','UTINGA'),
('BA','VALENCA'),
('BA','VALENTE'),
('BA','VARZEA DA ROCA'),
('BA','VARZEA DO POCO'),
('BA','VARZEA NOVA'),
('BA','VARZEDO'),
('BA','VERA CRUZ'),
('BA','VEREDA'),
('BA','VITORIA DA CONQUISTA'),
('BA','WAGNER'),
('BA','WANDERLEY'),
('BA','WENCESLAU GUIMARAES'),
('BA','XIQUE-XIQUE'),
('CE','ABAIARA'),
('CE','ACARAPE'),
('CE','ACARAU'),
('CE','ACOPIARA'),
('CE','AIUABA'),
('CE','ALCANTARAS'),
('CE','ALTANEIRA'),
('CE','ALTO SANTO'),
('CE','AMONTADA'),
('CE','ANTONINA DO NORTE'),
('CE','APUIARES'),
('CE','AQUIRAZ'),
('CE','ARACATI'),
('CE','ARACOIABA'),
('CE','ARARENDA'),
('CE','ARARIPE'),
('CE','ARATUBA'),
('CE','ARNEIROZ'),
('CE','ASSARE'),
('CE','AURORA'),
('CE','BAIXIO'),
('CE','BANABUIU'),
('CE','BARBALHA'),
('CE','BARREIRA'),
('CE','BARRO'),
('CE','BARROQUINHA'),
('CE','BATURITE'),
('CE','BEBERIBE'),
('CE','BELA CRUZ'),
('CE','BOA VIAGEM'),
('CE','BREJO SANTO'),
('CE','CAMOCIM'),
('CE','CAMPOS SALES'),
('CE','CANINDE'),
('CE','CAPISTRANO'),
('CE','CARIDADE'),
('CE','CARIRE'),
('CE','CARIRIACU'),
('CE','CARIUS'),
('CE','CARNAUBAL'),
('CE','CASCAVEL'),
('CE','CATARINA'),
('CE','CATUNDA'),
('CE','CAUCAIA'),
('CE','CEDRO'),
('CE','CHAVAL'),
('CE','CHORO'),
('CE','CHOROZINHO'),
('CE','COREAU'),
('CE','CRATEUS'),
('CE','CRATO'),
('CE','CROATA'),
('CE','CRUZ'),
('CE','DEPUTADO IRAPUAN PINHEIRO'),
('CE','ERERE'),
('CE','EUSEBIO'),
('CE','FARIAS BRITO'),
('CE','FORQUILHA'),
('CE','FORTALEZA'),
('CE','FORTIM'),
('CE','FRECHEIRINHA'),
('CE','GENERAL SAMPAIO'),
('CE','GRACA'),
('CE','GRANJA'),
('CE','GRANJEIRO'),
('CE','GROAIRAS'),
('CE','GUAIUBA'),
('CE','GUARACIABA DO NORTE'),
('CE','GUARAMIRANGA'),
('CE','HIDROLANDIA'),
('CE','HORIZONTE'),
('CE','IBARETAMA'),
('CE','IBIAPINA'),
('CE','IBICUITINGA'),
('CE','ICAPUI'),
('CE','ICO'),
('CE','IGUATU'),
('CE','INDEPENDENCIA'),
('CE','IPAPORANGA'),
('CE','IPAUMIRIM'),
('CE','IPU'),
('CE','IPUEIRAS'),
('CE','IRACEMA'),
('CE','IRAUCUBA'),
('CE','ITAICABA'),
('CE','ITAITINGA'),
('CE','ITAPAJE'),
('CE','ITAPIPOCA');

INSERT IGNORE INTO crefaz_coverage_cities (state, city) VALUES
('CE','ITAPIUNA'),
('CE','ITAREMA'),
('CE','ITATIRA'),
('CE','JAGUARETAMA'),
('CE','JAGUARIBARA'),
('CE','JAGUARIBE'),
('CE','JAGUARUANA'),
('CE','JARDIM'),
('CE','JATI'),
('CE','JIJOCA DE JERICOACOARA'),
('CE','JUAZEIRO DO NORTE'),
('CE','JUCAS'),
('CE','LAVRAS DA MANGABEIRA'),
('CE','LIMOEIRO DO NORTE'),
('CE','MADALENA'),
('CE','MARACANAU'),
('CE','MARANGUAPE'),
('CE','MARCO'),
('CE','MARTINOPOLE'),
('CE','MASSAPE'),
('CE','MAURITI'),
('CE','MERUOCA'),
('CE','MILAGRES'),
('CE','MILHA'),
('CE','MIRAIMA'),
('CE','MISSAO VELHA'),
('CE','MOMBACA'),
('CE','MONSENHOR TABOSA'),
('CE','MORADA NOVA'),
('CE','MORAUJO'),
('CE','MORRINHOS'),
('CE','MUCAMBO'),
('CE','MULUNGU'),
('CE','NOVA OLINDA'),
('CE','NOVA RUSSAS'),
('CE','NOVO ORIENTE'),
('CE','OCARA'),
('CE','OROS'),
('CE','PACAJUS'),
('CE','PACATUBA'),
('CE','PACOTI'),
('CE','PACUJA'),
('CE','PALHANO'),
('CE','PALMACIA'),
('CE','PARACURU'),
('CE','PARAIPABA'),
('CE','PARAMBU'),
('CE','PARAMOTI'),
('CE','PEDRA BRANCA'),
('CE','PENAFORTE'),
('CE','PENTECOSTE'),
('CE','PEREIRO'),
('CE','PINDORETAMA'),
('CE','PIQUET CARNEIRO'),
('CE','PIRES FERREIRA'),
('CE','PORANGA'),
('CE','PORTEIRAS'),
('CE','POTENGI'),
('CE','POTIRETAMA'),
('CE','QUITERIANOPOLIS'),
('CE','QUIXADA'),
('CE','QUIXELO'),
('CE','QUIXERAMOBIM'),
('CE','QUIXERE'),
('CE','REDENCAO'),
('CE','RERIUTABA'),
('CE','RUSSAS'),
('CE','SABOEIRO'),
('CE','SALITRE'),
('CE','SANTA QUITERIA'),
('CE','SANTANA DO ACARAU'),
('CE','SANTANA DO CARIRI'),
('CE','SAO BENEDITO'),
('CE','SAO GONCALO DO AMARANTE'),
('CE','SAO JOAO DO JAGUARIBE'),
('CE','SAO LUIS DO CURU'),
('CE','SENADOR POMPEU'),
('CE','SENADOR SA'),
('CE','SOBRAL'),
('CE','SOLONOPOLE'),
('CE','TABULEIRO DO NORTE'),
('CE','TAMBORIL'),
('CE','TARRAFAS'),
('CE','TAUA'),
('CE','TEJUCUOCA'),
('CE','TIANGUA'),
('CE','TRAIRI'),
('CE','TURURU'),
('CE','UBAJARA'),
('CE','UMARI'),
('CE','UMIRIM'),
('CE','URUBURETAMA'),
('CE','URUOCA'),
('CE','VARJOTA'),
('CE','VARZEA ALEGRE'),
('CE','VICOSA DO CEARA'),
('MG','ARCEBURGO'),
('MG','ITAMOGI'),
('MG','MONTE SANTO DE MINAS'),
('PE','ABREU E LIMA'),
('PE','AFOGADOS DA INGAZEIRA'),
('PE','AFRANIO'),
('PE','AGRESTINA'),
('PE','AGUA PRETA'),
('PE','AGUAS BELAS'),
('PE','ALAGOINHA'),
('PE','ALIANCA'),
('PE','ALTINHO'),
('PE','AMARAJI'),
('PE','ANGELIM'),
('PE','ARACOIABA'),
('PE','ARARIPINA'),
('PE','ARCOVERDE'),
('PE','BARRA DE GUABIRABA'),
('PE','BARREIROS'),
('PE','BELEM DE MARIA'),
('PE','BELEM DO SAO FRANCISCO'),
('PE','BELO JARDIM'),
('PE','BETANIA'),
('PE','BEZERROS'),
('PE','BODOCO'),
('PE','BOM CONSELHO'),
('PE','BOM JARDIM'),
('PE','BONITO'),
('PE','BREJAO'),
('PE','BREJINHO'),
('PE','BREJO DA MADRE DE DEUS'),
('PE','BUENOS AIRES'),
('PE','BUIQUE'),
('PE','CABO DE SANTO AGOSTINHO'),
('PE','CABROBO'),
('PE','CACHOEIRINHA'),
('PE','CAETES'),
('PE','CALCADO'),
('PE','CALUMBI'),
('PE','CAMARAGIBE'),
('PE','CAMOCIM DE SAO FELIX'),
('PE','CAMUTANGA'),
('PE','CANHOTINHO'),
('PE','CAPOEIRAS'),
('PE','CARNAIBA'),
('PE','CARNAUBEIRA DA PENHA'),
('PE','CARPINA'),
('PE','CARUARU'),
('PE','CASINHAS'),
('PE','CATENDE'),
('PE','CEDRO'),
('PE','CHA DE ALEGRIA'),
('PE','CHA GRANDE'),
('PE','CONDADO'),
('PE','CORRENTES'),
('PE','CORTES'),
('PE','CUMARU'),
('PE','CUPIRA'),
('PE','CUSTODIA'),
('PE','DORMENTES'),
('PE','ESCADA'),
('PE','EXU'),
('PE','FEIRA NOVA'),
('PE','FERNANDO DE NORONHA'),
('PE','FERREIROS'),
('PE','FLORES'),
('PE','FLORESTA'),
('PE','FREI MIGUELINHO'),
('PE','GAMELEIRA'),
('PE','GARANHUNS'),
('PE','GLORIA DO GOITA'),
('PE','GOIANA'),
('PE','GRANITO'),
('PE','GRAVATA'),
('PE','IATI'),
('PE','IBIMIRIM'),
('PE','IBIRAJUBA'),
('PE','IGARASSU'),
('PE','IGUARACY'),
('PE','ILHA DE ITAMARACA'),
('PE','INAJA'),
('PE','INGAZEIRA'),
('PE','IPOJUCA'),
('PE','IPUBI'),
('PE','ITACURUBA'),
('PE','ITAIBA'),
('PE','ITAMBE'),
('PE','ITAPETIM'),
('PE','ITAPISSUMA'),
('PE','ITAQUITINGA'),
('PE','JABOATAO DOS GUARARAPES'),
('PE','JAQUEIRA'),
('PE','JATAUBA'),
('PE','JATOBA'),
('PE','JOAO ALFREDO'),
('PE','JOAQUIM NABUCO'),
('PE','JUCATI'),
('PE','JUPI'),
('PE','JUREMA'),
('PE','LAGOA DO CARRO'),
('PE','LAGOA DO OURO'),
('PE','LAGOA DOS GATOS'),
('PE','LAGOA GRANDE'),
('PE','LAJEDO'),
('PE','LIMOEIRO'),
('PE','MACAPARANA'),
('PE','MACHADOS'),
('PE','MANARI'),
('PE','MARAIAL'),
('PE','MIRANDIBA'),
('PE','MOREILANDIA'),
('PE','MORENO'),
('PE','NAZARE DA MATA'),
('PE','OLINDA'),
('PE','OROBO'),
('PE','OROCO'),
('PE','OURICURI'),
('PE','PALMARES'),
('PE','PALMEIRINA'),
('PE','PANELAS'),
('PE','PARANATAMA'),
('PE','PARNAMIRIM'),
('PE','PASSIRA'),
('PE','PAUDALHO'),
('PE','PAULISTA'),
('PE','PEDRA'),
('PE','PESQUEIRA'),
('PE','PETROLANDIA'),
('PE','PETROLINA'),
('PE','POCAO'),
('PE','POMBOS'),
('PE','PRIMAVERA'),
('PE','QUIPAPA'),
('PE','QUIXABA'),
('PE','RECIFE'),
('PE','RIACHO DAS ALMAS'),
('PE','RIBEIRAO'),
('PE','RIO FORMOSO'),
('PE','SAIRE'),
('PE','SALGADINHO'),
('PE','SALGUEIRO'),
('PE','SALOA'),
('PE','SANHARO'),
('PE','SANTA CRUZ'),
('PE','SANTA CRUZ DA BAIXA VERDE'),
('PE','SANTA CRUZ DO CAPIBARIBE'),
('PE','SANTA FILOMENA'),
('PE','SANTA MARIA DA BOA VISTA'),
('PE','SANTA MARIA DO CAMBUCA'),
('PE','SANTA TEREZINHA'),
('PE','SAO BENEDITO DO SUL'),
('PE','SAO BENTO DO UNA'),
('PE','SAO CAITANO'),
('PE','SAO JOAO'),
('PE','SAO JOAQUIM DO MONTE'),
('PE','SAO JOSE DA COROA GRANDE'),
('PE','SAO JOSE DO BELMONTE'),
('PE','SAO JOSE DO EGITO'),
('PE','SAO LOURENCO DA MATA'),
('PE','SAO VICENTE FERRER'),
('PE','SERRA TALHADA'),
('PE','SERRITA'),
('PE','SERTANIA'),
('PE','SIRINHAEM'),
('PE','SOLIDAO'),
('PE','SURUBIM'),
('PE','TABIRA'),
('PE','TACAIMBO'),
('PE','TACARATU'),
('PE','TAMANDARE'),
('PE','TAQUARITINGA DO NORTE'),
('PE','TEREZINHA'),
('PE','TERRA NOVA'),
('PE','TIMBAUBA'),
('PE','TORITAMA'),
('PE','TRACUNHAEM'),
('PE','TRINDADE'),
('PE','TRIUNFO'),
('PE','TUPANATINGA'),
('PE','TUPARETAMA'),
('PE','VENTUROSA'),
('PE','VERDEJANTE'),
('PE','VERTENTE DO LERIO'),
('PE','VERTENTES'),
('PE','VICENCIA'),
('PE','VITORIA DE SANTO ANTAO'),
('PE','XEXEU'),
('PR','JACAREZINHO'),
('PR','RIBEIRAO CLARO'),
('RJ','ANGRA DOS REIS'),
('RJ','APERIBE'),
('RJ','AREAL'),
('RJ','ARMACAO DOS BUZIOS'),
('RJ','ARRAIAL DO CABO'),
('RJ','BOM JARDIM'),
('RJ','BOM JESUS DO ITABAPOANA'),
('RJ','CABO FRIO'),
('RJ','CAMBUCI'),
('RJ','CAMPOS DOS GOYTACAZES'),
('RJ','CANTAGALO'),
('RJ','CARAPEBUS'),
('RJ','CARDOSO MOREIRA'),
('RJ','CASIMIRO DE ABREU'),
('RJ','CONCEICAO DE MACABU'),
('RJ','CORDEIRO'),
('RJ','DUAS BARRAS'),
('RJ','GUAPIMIRIM'),
('RJ','IGUABA GRANDE'),
('RJ','ITABORAI'),
('RJ','ITALVA'),
('RJ','ITAOCARA'),
('RJ','ITAPERUNA'),
('RJ','ITATIAIA'),
('RJ','LAJE DO MURIAE'),
('RJ','MACAE'),
('RJ','MACUCO'),
('RJ','MAGE'),
('RJ','MANGARATIBA'),
('RJ','MARICA'),
('RJ','MIRACEMA'),
('RJ','NATIVIDADE'),
('RJ','NITEROI'),
('RJ','PARATY'),
('RJ','PETROPOLIS'),
('RJ','PORCIUNCULA'),
('RJ','PORTO REAL'),
('RJ','QUISSAMA'),
('RJ','RIO BONITO'),
('RJ','RIO DAS OSTRAS'),
('RJ','SANTA MARIA MADALENA'),
('RJ','SANTO ANTONIO DE PADUA'),
('RJ','SAO FIDELIS'),
('RJ','SAO FRANCISCO DE ITABAPOANA'),
('RJ','SAO GONCALO'),
('RJ','SAO JOAO DA BARRA'),
('RJ','SAO JOSE DE UBA'),
('RJ','SAO JOSE DO VALE DO RIO PRETO'),
('RJ','SAO PEDRO DA ALDEIA'),
('RJ','SAO SEBASTIAO DO ALTO'),
('RJ','SAQUAREMA'),
('RJ','SILVA JARDIM'),
('RJ','TANGUA'),
('RJ','TERESOPOLIS'),
('RJ','TRAJANO DE MORAES'),
('RJ','VARRE-SAI'),
('RN','ACARI'),
('RN','ACU'),
('RN','AFONSO BEZERRA'),
('RN','AGUA NOVA'),
('RN','ALEXANDRIA'),
('RN','ALMINO AFONSO'),
('RN','ALTO DO RODRIGUES'),
('RN','ANGICOS'),
('RN','ANTONIO MARTINS'),
('RN','APODI'),
('RN','AREIA BRANCA'),
('RN','ARES'),
('RN','AUGUSTO SEVERO'),
('RN','BAIA FORMOSA'),
('RN','BARAUNA'),
('RN','BARCELONA'),
('RN','BENTO FERNANDES'),
('RN','BODO'),
('RN','BOM JESUS'),
('RN','BREJINHO'),
('RN','CAICARA DO NORTE'),
('RN','CAICARA DO RIO DO VENTO'),
('RN','CAICO'),
('RN','CAMPO REDONDO'),
('RN','CANGUARETAMA'),
('RN','CARAUBAS'),
('RN','CARNAUBA DOS DANTAS'),
('RN','CARNAUBAIS'),
('RN','CEARA-MIRIM'),
('RN','CERRO CORA'),
('RN','CORONEL EZEQUIEL'),
('RN','CORONEL JOAO PESSOA'),
('RN','CRUZETA'),
('RN','CURRAIS NOVOS'),
('RN','DOUTOR SEVERIANO'),
('RN','ENCANTO'),
('RN','EQUADOR'),
('RN','ESPIRITO SANTO'),
('RN','EXTREMOZ'),
('RN','FELIPE GUERRA'),
('RN','FERNANDO PEDROZA'),
('RN','FLORANIA'),
('RN','FRANCISCO DANTAS'),
('RN','FRUTUOSO GOMES'),
('RN','GALINHOS'),
('RN','GOIANINHA'),
('RN','GOVERNADOR DIX-SEPT ROSADO'),
('RN','GROSSOS'),
('RN','GUAMARE'),
('RN','IELMO MARINHO'),
('RN','IPANGUACU'),
('RN','IPUEIRA'),
('RN','ITAJA'),
('RN','ITAU'),
('RN','JACANA'),
('RN','JANDAIRA'),
('RN','JANDUIS'),
('RN','JANUARIO CICCO'),
('RN','JAPI'),
('RN','JARDIM DE ANGICOS'),
('RN','JARDIM DE PIRANHAS'),
('RN','JARDIM DO SERIDO'),
('RN','JOAO CAMARA'),
('RN','JOAO DIAS'),
('RN','JOSE DA PENHA'),
('RN','JUCURUTU'),
('RN','JUNDIA'),
('RN','LAGOA DE PEDRAS'),
('RN','LAGOA DE VELHOS'),
('RN','LAGOA NOVA'),
('RN','LAGOA SALGADA'),
('RN','LAJES'),
('RN','LAJES PINTADAS'),
('RN','LUCRECIA'),
('RN','LUIS GOMES'),
('RN','MACAIBA'),
('RN','MACAU'),
('RN','MAJOR SALES'),
('RN','MARCELINO VIEIRA'),
('RN','MARTINS'),
('RN','MAXARANGUAPE'),
('RN','MESSIAS TARGINO'),
('RN','MONTANHAS'),
('RN','MONTE ALEGRE'),
('RN','MONTE DAS GAMELEIRAS'),
('RN','MOSSORO'),
('RN','NATAL'),
('RN','NISIA FLORESTA'),
('RN','NOVA CRUZ'),
('RN','OLHO D AGUA DO BORGES'),
('RN','OURO BRANCO'),
('RN','PARANA'),
('RN','PARAU'),
('RN','PARAZINHO'),
('RN','PARELHAS'),
('RN','PARNAMIRIM'),
('RN','PASSA E FICA'),
('RN','PASSAGEM'),
('RN','PATU'),
('RN','PAU DOS FERROS'),
('RN','PEDRA GRANDE'),
('RN','PEDRA PRETA'),
('RN','PEDRO AVELINO'),
('RN','PEDRO VELHO'),
('RN','PENDENCIAS'),
('RN','PILOES'),
('RN','POCO BRANCO'),
('RN','PORTALEGRE'),
('RN','PORTO DO MANGUE'),
('RN','PUREZA'),
('RN','RAFAEL FERNANDES'),
('RN','RAFAEL GODEIRO'),
('RN','RIACHO DA CRUZ'),
('RN','RIACHO DE SANTANA'),
('RN','RIACHUELO'),
('RN','RIO DO FOGO'),
('RN','RODOLFO FERNANDES'),
('RN','RUY BARBOSA'),
('RN','SANTA CRUZ'),
('RN','SANTA MARIA'),
('RN','SANTANA DO MATOS'),
('RN','SANTANA DO SERIDO'),
('RN','SANTO ANTONIO'),
('RN','SAO BENTO DO NORTE'),
('RN','SAO BENTO DO TRAIRI'),
('RN','SAO FERNANDO'),
('RN','SAO FRANCISCO DO OESTE'),
('RN','SAO GONCALO DO AMARANTE'),
('RN','SAO JOAO DO SABUGI'),
('RN','SAO JOSE DE MIPIBU'),
('RN','SAO JOSE DO CAMPESTRE'),
('RN','SAO JOSE DO SERIDO'),
('RN','SAO MIGUEL'),
('RN','SAO MIGUEL DO GOSTOSO'),
('RN','SAO PAULO DO POTENGI'),
('RN','SAO PEDRO'),
('RN','SAO RAFAEL'),
('RN','SAO TOME'),
('RN','SAO VICENTE'),
('RN','SENADOR ELOI DE SOUZA'),
('RN','SENADOR GEORGINO AVELINO'),
('RN','SERRA CAIADA'),
('RN','SERRA DE SAO BENTO'),
('RN','SERRA DO MEL'),
('RN','SERRA NEGRA DO NORTE'),
('RN','SERRINHA'),
('RN','SERRINHA DOS PINTOS'),
('RN','SEVERIANO MELO'),
('RN','SITIO NOVO'),
('RN','TABOLEIRO GRANDE'),
('RN','TAIPU'),
('RN','TANGARA'),
('RN','TENENTE ANANIAS'),
('RN','TENENTE LAURENTINO CRUZ'),
('RN','TIBAU'),
('RN','TIBAU DO SUL'),
('RN','TIMBAUBA DOS BATISTAS'),
('RN','TOUROS'),
('RN','TRIUNFO POTIGUAR');

INSERT IGNORE INTO crefaz_coverage_cities (state, city) VALUES
('RN','UMARIZAL'),
('RN','UPANEMA'),
('RN','VARZEA'),
('RN','VENHA-VER'),
('RN','VERA CRUZ'),
('RN','VICOSA'),
('RN','VILA FLOR'),
('RS','AGUDO'),
('RS','ALEGRETE'),
('RS','ALEGRIA'),
('RS','ALTO FELIZ'),
('RS','ANDRE DA ROCHA'),
('RS','ANTA GORDA'),
('RS','ANTONIO PRADO'),
('RS','ARARICA'),
('RS','ARATIBA'),
('RS','ARROIO DO MEIO'),
('RS','ARROIO DO TIGRE'),
('RS','ARVOREZINHA'),
('RS','AUREA'),
('RS','BARAO DE COTEGIPE'),
('RS','BARRA DO QUARAI'),
('RS','BARRA FUNDA'),
('RS','BARRACAO'),
('RS','BARROS CASSAL'),
('RS','BENTO GONCALVES'),
('RS','BOA VISTA DO BURICA'),
('RS','BOM JESUS'),
('RS','BOM PRINCIPIO'),
('RS','BOM PROGRESSO'),
('RS','BRAGA'),
('RS','BROCHIER'),
('RS','CACAPAVA DO SUL'),
('RS','CACEQUI'),
('RS','CACHOEIRINHA'),
('RS','CACIQUE DOBLE'),
('RS','CAICARA'),
('RS','CAMARGO'),
('RS','CAMBARA DO SUL'),
('RS','CAMPESTRE DA SERRA'),
('RS','CAMPO BOM'),
('RS','CAMPO NOVO'),
('RS','CANDELARIA'),
('RS','CANELA'),
('RS','CANOAS'),
('RS','CAPAO BONITO DO SUL'),
('RS','CAPAO DO CIPO'),
('RS','CAPELA DE SANTANA'),
('RS','CARLOS BARBOSA'),
('RS','CASCA'),
('RS','CASEIROS'),
('RS','CAXIAS DO SUL'),
('RS','CERRO BRANCO'),
('RS','CERRO LARGO'),
('RS','COLINAS'),
('RS','CONSTANTINA'),
('RS','CORONEL BICACO'),
('RS','CORONEL PILAR'),
('RS','COTIPORA'),
('RS','CRISSIUMAL'),
('RS','CRUZEIRO DO SUL'),
('RS','DEZESSEIS DE NOVEMBRO'),
('RS','DOIS IRMAOS'),
('RS','DOIS IRMAOS DAS MISSOES'),
('RS','DOIS LAJEADOS'),
('RS','DOUTOR MAURICIO CARDOSO'),
('RS','ENCANTADO'),
('RS','ENGENHO VELHO'),
('RS','ENTRE RIOS DO SUL'),
('RS','ERECHIM'),
('RS','ERVAL GRANDE'),
('RS','ERVAL SECO'),
('RS','ESMERALDA'),
('RS','ESTANCIA VELHA'),
('RS','ESTEIO'),
('RS','ESTRELA'),
('RS','EUGENIO DE CASTRO'),
('RS','FAGUNDES VARELA'),
('RS','FARROUPILHA'),
('RS','FAXINALZINHO'),
('RS','FELIZ'),
('RS','FLORES DA CUNHA'),
('RS','FORMIGUEIRO'),
('RS','FREDERICO WESTPHALEN'),
('RS','GARIBALDI'),
('RS','GAURAMA'),
('RS','GLORINHA'),
('RS','GRAMADO'),
('RS','GRAVATAI'),
('RS','GUABIJU'),
('RS','GUAPORE'),
('RS','GUARANI DAS MISSOES'),
('RS','HARMONIA'),
('RS','HORIZONTINA'),
('RS','HUMAITA'),
('RS','IBARAMA'),
('RS','IBIRAIARAS'),
('RS','IGREJINHA'),
('RS','ILOPOLIS'),
('RS','IMIGRANTE'),
('RS','IPE'),
('RS','IRAI'),
('RS','ITAARA'),
('RS','ITACURUBI'),
('RS','ITAQUI'),
('RS','ITATIBA DO SUL'),
('RS','IVOTI'),
('RS','JACUTINGA'),
('RS','JAGUARI'),
('RS','JAQUIRANA'),
('RS','JULIO DE CASTILHOS'),
('RS','LAGOA VERMELHA'),
('RS','LAGOAO'),
('RS','LIBERATO SALZANO'),
('RS','LINDOLFO COLLOR'),
('RS','LINHA NOVA'),
('RS','MACAMBARA'),
('RS','MACHADINHO'),
('RS','MANOEL VIANA'),
('RS','MARCELINO RAMOS'),
('RS','MARIANO MORO'),
('RS','MATA'),
('RS','MATO LEITAO'),
('RS','MAXIMILIANO DE ALMEIDA'),
('RS','MIRAGUAI'),
('RS','MONTAURI'),
('RS','MONTE ALEGRE DOS CAMPOS'),
('RS','MONTE BELO DO SUL'),
('RS','MORRO REUTER'),
('RS','MUCUM'),
('RS','NONOAI'),
('RS','NOVA ALVORADA'),
('RS','NOVA ARACA'),
('RS','NOVA BASSANO'),
('RS','NOVA BOA VISTA'),
('RS','NOVA BRESCIA'),
('RS','NOVA ESPERANCA DO SUL'),
('RS','NOVA HARTZ'),
('RS','NOVA PADUA'),
('RS','NOVA PETROPOLIS'),
('RS','NOVA PRATA'),
('RS','NOVA ROMA DO SUL'),
('RS','NOVA SANTA RITA'),
('RS','NOVO BARREIRO'),
('RS','NOVO HAMBURGO'),
('RS','NOVO MACHADO'),
('RS','PAIM FILHO'),
('RS','PALMEIRA DAS MISSOES'),
('RS','PALMITINHO'),
('RS','PARAI'),
('RS','PARAISO DO SUL'),
('RS','PARECI NOVO'),
('RS','PAROBE'),
('RS','PASSO FUNDO'),
('RS','PAULO BENTO'),
('RS','PICADA CAFE'),
('RS','PINHAL DA SERRA'),
('RS','PINHAL GRANDE'),
('RS','PINHEIRINHO DO VALE'),
('RS','PIRAPO'),
('RS','PLANALTO'),
('RS','PONTE PRETA'),
('RS','PORTAO'),
('RS','PORTO MAUA'),
('RS','PORTO XAVIER'),
('RS','PRESIDENTE LUCENA'),
('RS','PROTASIO ALVES'),
('RS','PUTINGA'),
('RS','QUARAI'),
('RS','QUATRO IRMAOS'),
('RS','QUEVEDOS'),
('RS','REDENTORA'),
('RS','RELVADO'),
('RS','RIO PARDO'),
('RS','RIOZINHO'),
('RS','ROCA SALES'),
('RS','ROLANTE'),
('RS','RONDINHA'),
('RS','ROQUE GONZALES'),
('RS','ROSARIO DO SUL'),
('RS','SALTO DO JACUI'),
('RS','SANANDUVA'),
('RS','SANT ANA DO LIVRAMENTO'),
('RS','SANTA CRUZ DO SUL'),
('RS','SANTA MARGARIDA DO SUL'),
('RS','SANTA MARIA'),
('RS','SANTA MARIA DO HERVAL'),
('RS','SANTA ROSA'),
('RS','SANTA TEREZA'),
('RS','SANTANA DA BOA VISTA'),
('RS','SANTIAGO'),
('RS','SANTO ANGELO'),
('RS','SANTO ANTONIO DO PALMA'),
('RS','SANTO AUGUSTO'),
('RS','SANTO CRISTO'),
('RS','SAO BORJA'),
('RS','SAO DOMINGOS DO SUL'),
('RS','SAO FRANCISCO DE ASSIS'),
('RS','SAO FRANCISCO DE PAULA'),
('RS','SAO GABRIEL'),
('RS','SAO JOAO DA URTIGA'),
('RS','SAO JORGE'),
('RS','SAO JOSE DAS MISSOES'),
('RS','SAO JOSE DO HERVAL'),
('RS','SAO JOSE DO HORTENCIO'),
('RS','SAO JOSE DO INHACORA'),
('RS','SAO JOSE DO OURO'),
('RS','SAO JOSE DOS AUSENTES'),
('RS','SAO LEOPOLDO'),
('RS','SAO MARCOS'),
('RS','SAO MARTINHO'),
('RS','SAO MARTINHO DA SERRA'),
('RS','SAO NICOLAU'),
('RS','SAO PEDRO DAS MISSOES'),
('RS','SAO PEDRO DO BUTIA'),
('RS','SAO PEDRO DO SUL'),
('RS','SAO SEBASTIAO DO CAI'),
('RS','SAO SEPE'),
('RS','SAO VALENTIM'),
('RS','SAO VALENTIM DO SUL'),
('RS','SAO VENDELINO'),
('RS','SAO VICENTE DO SUL'),
('RS','SAPIRANGA'),
('RS','SAPUCAIA DO SUL'),
('RS','SARANDI'),
('RS','SEBERI'),
('RS','SEDE NOVA'),
('RS','SEGREDO'),
('RS','SERAFINA CORREA'),
('RS','SEVERIANO DE ALMEIDA'),
('RS','SINIMBU'),
('RS','SOBRADINHO'),
('RS','SOLEDADE'),
('RS','TAQUARA'),
('RS','TAQUARUCU DO SUL'),
('RS','TENENTE PORTELA'),
('RS','TOROPI'),
('RS','TRES ARROIOS'),
('RS','TRES COROAS'),
('RS','TRES PALMEIRAS'),
('RS','TRES PASSOS'),
('RS','TRINDADE DO SUL'),
('RS','TUCUNDUVA'),
('RS','TUPANDI'),
('RS','TUPARENDI'),
('RS','UNIAO DA SERRA'),
('RS','URUGUAIANA'),
('RS','VACARIA'),
('RS','VALE DO SOL'),
('RS','VALE REAL'),
('RS','VANINI'),
('RS','VENANCIO AIRES'),
('RS','VERA CRUZ'),
('RS','VERANOPOLIS'),
('RS','VESPASIANO CORREA'),
('RS','VIADUTOS'),
('RS','VICENTE DUTRA'),
('RS','VILA FLORES'),
('RS','VILA NOVA DO SUL'),
('RS','VISTA ALEGRE'),
('RS','VISTA ALEGRE DO PRATA'),
('RS','VISTA GAUCHA'),
('SP','AGUAS DE LINDOIA'),
('SP','AGUAS DE SANTA BARBARA'),
('SP','AGUAS DE SAO PEDRO'),
('SP','AGUDOS'),
('SP','ALAMBARI'),
('SP','ALTAIR'),
('SP','ALTINOPOLIS'),
('SP','ALTO ALEGRE'),
('SP','ALUMINIO'),
('SP','ALVARO DE CARVALHO'),
('SP','ALVINLANDIA'),
('SP','AMERICANA'),
('SP','AMERICO BRASILIENSE'),
('SP','AMPARO'),
('SP','ANALANDIA'),
('SP','ARACARIGUAMA'),
('SP','ARACATUBA'),
('SP','ARACOIABA DA SERRA'),
('SP','ARAMINA'),
('SP','ARANDU'),
('SP','ARARAQUARA'),
('SP','AREALVA'),
('SP','AREIOPOLIS'),
('SP','ARIRANHA'),
('SP','AVAI'),
('SP','AVANHANDAVA'),
('SP','AVARE'),
('SP','BADY BASSITT'),
('SP','BALBINOS'),
('SP','BALSAMO'),
('SP','BARBOSA'),
('SP','BARIRI'),
('SP','BARRA BONITA'),
('SP','BARRETOS'),
('SP','BARRINHA'),
('SP','BATATAIS'),
('SP','BAURU'),
('SP','BEBEDOURO'),
('SP','BENTO DE ABREU'),
('SP','BERNARDINO DE CAMPOS'),
('SP','BILAC'),
('SP','BIRIGUI'),
('SP','BOA ESPERANCA DO SUL'),
('SP','BOCAINA'),
('SP','BOFETE'),
('SP','BOITUVA'),
('SP','BORACEIA'),
('SP','BOREBI'),
('SP','BOTUCATU'),
('SP','BRAUNA'),
('SP','BREJO ALEGRE'),
('SP','BRODOWSKI'),
('SP','BROTAS'),
('SP','BURITIZAL'),
('SP','CABRALIA PAULISTA'),
('SP','CACONDE'),
('SP','CAFELANDIA'),
('SP','CAJOBI'),
('SP','CAJURU'),
('SP','CAMPINAS'),
('SP','CAMPO LIMPO PAULISTA'),
('SP','CAMPOS NOVOS PAULISTA'),
('SP','CANDIDO RODRIGUES'),
('SP','CANITAR'),
('SP','CAPELA DO ALTO'),
('SP','CAPIVARI'),
('SP','CASA BRANCA'),
('SP','CASSIA DOS COQUEIROS'),
('SP','CEDRAL'),
('SP','CERQUEIRA CESAR'),
('SP','CHARQUEADA'),
('SP','CHAVANTES'),
('SP','CLEMENTINA'),
('SP','COLINA'),
('SP','COLOMBIA'),
('SP','COROADOS'),
('SP','COSMOPOLIS'),
('SP','CRAVINHOS'),
('SP','CRISTAIS PAULISTA'),
('SP','CUBATAO'),
('SP','DESCALVADO'),
('SP','DIVINOLANDIA'),
('SP','DOBRADA'),
('SP','DOIS CORREGOS'),
('SP','DOURADO'),
('SP','DUARTINA'),
('SP','DUMONT'),
('SP','ELIAS FAUSTO'),
('SP','EMBAUBA'),
('SP','ESPIRITO SANTO DO PINHAL'),
('SP','ESPIRITO SANTO DO TURVO'),
('SP','FERNANDO PRESTES'),
('SP','FERNAO'),
('SP','FRANCA'),
('SP','GABRIEL MONTEIRO'),
('SP','GALIA'),
('SP','GARCA'),
('SP','GAVIAO PEIXOTO'),
('SP','GETULINA'),
('SP','GLICERIO'),
('SP','GUAICARA'),
('SP','GUAIMBE'),
('SP','GUAIRA'),
('SP','GUAPIACU'),
('SP','GUARA'),
('SP','GUARACI'),
('SP','GUARANTA'),
('SP','GUARARAPES'),
('SP','GUAREI'),
('SP','GUARIBA'),
('SP','GUATAPARA'),
('SP','HERCULANDIA'),
('SP','HORTOLANDIA'),
('SP','IACANGA'),
('SP','IARAS'),
('SP','IBATE'),
('SP','IBIRA'),
('SP','IBITINGA'),
('SP','ICEM'),
('SP','IGARACU DO TIETE'),
('SP','IGARAPAVA'),
('SP','INDAIATUBA'),
('SP','IPAUSSU'),
('SP','IPERO'),
('SP','IPUA'),
('SP','ITAJU'),
('SP','ITAPETININGA'),
('SP','ITAPIRA'),
('SP','ITAPOLIS'),
('SP','ITAPUI'),
('SP','ITATIBA'),
('SP','ITATINGA'),
('SP','ITIRAPUA'),
('SP','ITOBI'),
('SP','ITU'),
('SP','ITUPEVA'),
('SP','ITUVERAVA'),
('SP','JABORANDI'),
('SP','JABOTICABAL'),
('SP','JACI'),
('SP','JAGUARIUNA'),
('SP','JARDINOPOLIS'),
('SP','JAU'),
('SP','JERIQUARA'),
('SP','JOSE BONIFACIO'),
('SP','JULIO MESQUITA'),
('SP','JUNDIAI'),
('SP','LENCOIS PAULISTA'),
('SP','LINDOIA'),
('SP','LINS'),
('SP','LOUVEIRA'),
('SP','LUCIANOPOLIS'),
('SP','LUIS ANTONIO'),
('SP','LUIZIANIA'),
('SP','LUPERCIO'),
('SP','MACATUBA'),
('SP','MANDURI'),
('SP','MARILIA'),
('SP','MATAO'),
('SP','MIGUELOPOLIS'),
('SP','MINEIROS DO TIETE'),
('SP','MIRASSOL'),
('SP','MIRASSOLANDIA'),
('SP','MOCOCA'),
('SP','MOMBUCA'),
('SP','MONTE ALEGRE DO SUL'),
('SP','MONTE ALTO'),
('SP','MONTE APRAZIVEL'),
('SP','MONTE AZUL PAULISTA'),
('SP','MONTE MOR'),
('SP','MORRO AGUDO'),
('SP','MORUNGABA'),
('SP','MOTUCA'),
('SP','NEVES PAULISTA'),
('SP','NOVA EUROPA'),
('SP','NOVA GRANADA'),
('SP','NOVA ODESSA'),
('SP','NUPORANGA'),
('SP','OCAUCU'),
('SP','OLEO'),
('SP','OLIMPIA'),
('SP','ORIENTE'),
('SP','ORLANDIA'),
('SP','OURINHOS'),
('SP','PALESTINA'),
('SP','PALMARES PAULISTA'),
('SP','PARAISO'),
('SP','PARDINHO'),
('SP','PATROCINIO PAULISTA'),
('SP','PAULINIA'),
('SP','PAULISTANIA'),
('SP','PEDERNEIRAS'),
('SP','PEDREGULHO'),
('SP','PEDREIRA'),
('SP','PENAPOLIS'),
('SP','PIACATU'),
('SP','PINDORAMA'),
('SP','PIRACICABA'),
('SP','PIRAJU'),
('SP','PIRAJUI'),
('SP','PIRANGI'),
('SP','PIRATININGA'),
('SP','PITANGUEIRAS'),
('SP','POLONI'),
('SP','POMPEIA'),
('SP','PONGAI'),
('SP','PONTAL'),
('SP','PORTO FELIZ'),
('SP','POTIRENDABA'),
('SP','PRADOPOLIS'),
('SP','PRAIA GRANDE'),
('SP','PRATANIA'),
('SP','PRESIDENTE ALVES'),
('SP','QUEIROZ'),
('SP','QUINTANA'),
('SP','RAFARD'),
('SP','REGINOPOLIS'),
('SP','RESTINGA'),
('SP','RIBEIRAO BONITO'),
('SP','RIBEIRAO CORRENTE'),
('SP','RIBEIRAO PRETO'),
('SP','RIFAINA'),
('SP','RINCAO'),
('SP','RIO DAS PEDRAS'),
('SP','RUBIACEA'),
('SP','SABINO'),
('SP','SALES OLIVEIRA'),
('SP','SALTINHO'),
('SP','SALTO'),
('SP','SALTO DE PIRAPORA'),
('SP','SANTA ADELIA'),
('SP','SANTA BARBARA D OESTE'),
('SP','SANTA CRUZ DA ESPERANCA'),
('SP','SANTA CRUZ DO RIO PARDO'),
('SP','SANTA ERNESTINA'),
('SP','SANTA LUCIA'),
('SP','SANTA MARIA DA SERRA'),
('SP','SANTA ROSA DE VITERBO');

INSERT IGNORE INTO crefaz_coverage_cities (state, city) VALUES
('SP','SANTO ANTONIO DA ALEGRIA'),
('SP','SANTO ANTONIO DO ARACANGUA'),
('SP','SANTO ANTONIO DO JARDIM'),
('SP','SANTOPOLIS DO AGUAPEI'),
('SP','SANTOS'),
('SP','SAO CARLOS'),
('SP','SAO JOAQUIM DA BARRA'),
('SP','SAO JOSE DA BELA VISTA'),
('SP','SAO JOSE DO RIO PARDO'),
('SP','SAO JOSE DO RIO PRETO'),
('SP','SAO MANUEL'),
('SP','SAO MIGUEL ARCANJO'),
('SP','SAO PEDRO'),
('SP','SAO PEDRO DO TURVO'),
('SP','SAO ROQUE'),
('SP','SAO SEBASTIAO DA GRAMA'),
('SP','SAO SIMAO'),
('SP','SAO VICENTE'),
('SP','SARAPUI'),
('SP','SARUTAIA'),
('SP','SERRA AZUL'),
('SP','SERRA NEGRA'),
('SP','SERRANA'),
('SP','SERTAOZINHO'),
('SP','SEVERINIA'),
('SP','SOCORRO'),
('SP','SOROCABA'),
('SP','SUMARE'),
('SP','TABATINGA'),
('SP','TAGUAI'),
('SP','TAIACU'),
('SP','TAIUVA'),
('SP','TANABI'),
('SP','TAPIRATIBA'),
('SP','TAQUARAL'),
('SP','TAQUARITINGA'),
('SP','TAQUARITUBA'),
('SP','TEJUPA'),
('SP','TERRA ROXA'),
('SP','TIMBURI'),
('SP','TORRINHA'),
('SP','TRABIJU'),
('SP','UBARANA'),
('SP','UBIRAJARA'),
('SP','UCHOA'),
('SP','URU'),
('SP','VALINHOS'),
('SP','VALPARAISO'),
('SP','VARZEA PAULISTA'),
('SP','VERA CRUZ'),
('SP','VINHEDO'),
('SP','VIRADOURO'),
('SP','VISTA ALEGRE DO ALTO'),
('SP','VOTORANTIM');