Data catalog

Reference table of the 5,571 municipalities: names, IBGE territorial hierarchy, population, coordinates and a snapshot of indicators (GDP, MHDI, public finances, education, mayor elected in 2024). Use it to add names and context to any table via ibge_code.

one row per municipality · IBGE, TSE, INEP, STN and others, consolidated in the npm package municipios-br 3.2.1

Long table combining ~730 indicators from 20 sources (health, education, social assistance, agriculture and livestock, sanitation, public safety, transfers, energy, fuel prices). Each row is the value of one indicator for one municipality in one period; see indicadores_dicionario to find the available indicador_id values.

one row per (ibge_code, indicador_id, periodo) · IBGE (SIDRA/PAM/PPM/PNADc/CEMPRE), INEP, MEC, DataSUS/CNES, ANS, Transparency Portal (BPC, Bolsa Família, Pé-de-Meia), FNDE, STN, SINESP, SNIS/SINISA, ANEEL, ANP, INPE

Lists each distinct indicator in indicadores_serie with its Portuguese label, unit, coverage (municipalities, periods) and source. It is the starting point for finding which indicador_id to query. Generated from indicadores_serie on each export.

one row per (fonte, indicador_id) · Derived from indicadores_serie; SIDRA/IBGE metadata labels, CNES auxiliary tables, SINISA spreadsheets and pipeline documentation

Daily and monthly series from the BCB Time Series Management System (SGS): monthly IPCA (433), daily Selic (11) and the US dollar exchange rate (1). Useful for deflating or contextualizing municipal series.

one row per (serie_id, data) · Central Bank of Brazil — SGS

Monthly exports and imports by municipality of the company's tax domicile, product (SH4) and partner country, since 2020. Municipal database of Comex Stat (MDIC/Secex).

one row per (ano, mes, ibge_code, fluxo, sh4, pais) · MDIC/Secex — Comex Stat (municipal database)

Count of establishments in the National Register of Legal Entities (CNPJ, Federal Revenue Service) aggregated by municipality, primary CNAE and registration status, from the monthly dump. Used to measure the active, closed or unfit business base of each municipality and sector.

one row per (snapshot, ibge_code, cnae_principal, situacao_cadastral) · Federal Revenue Service (Receita Federal) — CNPJ Open Data

Count of CNPJ establishments by municipality, primary CNAE and company size (ME, EPP, other), joining the Empresas and Estabelecimentos files from the Receita dump. Complements cnpj_estabelecimentos_municipio with the company-size dimension.

one row per (snapshot, ibge_code, cnae, porte) · Federal Revenue Service (Receita Federal) — CNPJ Open Data (Empresas × Estabelecimentos)

Spending executed by the FEDERAL GOVERNMENT (federal agencies), not the city government's budget: each row sums the Transparency Portal entries (despesas/execução) for one month, location, function, subfunction and program, with committed, accrued and paid amounts. The location is where the federal spending was recorded (which is why functions like National defense appear in capitals); ibge_code is null when the entry has no municipality (≈74% of rows).

one row per (mes_competencia, uf, municipio, codigo_funcao, codigo_subfuncao, codigo_programa) · CGU — Transparency Portal, Spending: execution

Amendments to the federal budget (individual, state caucus, committee and rapporteur) with author, location of application, functional-programmatic classification and committed, accrued and paid amounts. ibge_code exists only when the location is a municipality (≈29% of rows).

one row per amendment × location × budget classification, as in the Portal file · CGU — Transparency Portal, Parliamentary Amendments

All bills and proposals filed in the Chamber since 2015 (PL, PEC, MPV, requests, committee reports, etc.) with type, number, summary (ementa), keywords and filing body.

one row per bill / proposal · Chamber of Deputies (Câmara dos Deputados) — Open Data

Voting events in the Chamber's plenary and committees since 2015, with a description of the outcome and an approval flag. Joins to camara_votos on id = id_votacao.

one row per vote (roll call) · Chamber of Deputies (Câmara dos Deputados) — Open Data

Individual vote of each deputy in each roll-call vote in the Chamber since 2015, with party and UF at the time of the vote. Joins to camara_votacoes on id_votacao = id.

one row per (id_votacao, id_deputado) · Chamber of Deputies (Câmara dos Deputados) — Open Data

Register of retail automotive fuel resellers authorized by the ANP, with CNPJ, address, brand and municipality. Contains two snapshots of the same register; filter by snapshot to avoid double-counting stations.

one row per (cnpj, snapshot) · ANP — Registration data of retail fuel resellers

Number of registered vehicles by municipality and vehicle type (car, motorcycle, truck...) according to Senatran, as of December 2024.

one row per (ibge_code, periodo, tipo_veiculo) · Ministry of Transport — Senatran, Fleet by municipality and type

About 1.28 million CEPs with street, neighborhood, locality, UF, DDD and IBGE municipality code. Useful for geocoding addresses down to the municipality level.

one row per CEP · npm package municipios-br 3.2.1 (compilation of public CEP databases, incl. OpenCEP)