indicadores_dicionario
Indicator dictionary (indicadores_serie)
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 is
- one row per (fonte, indicador_id)
- Key columns
- fonte, indicador_id
- Source
- Derived from indicadores_serie; SIDRA/IBGE metadata labels, CNES auxiliary tables, SINISA spreadsheets and pipeline documentation
- License
- Government open data (see fonte_url on each row)
- Domain
- Social
- Snapshot
- 2026-09-25
Columns
| Column | Type | Description |
|---|---|---|
| fonteKEY | VARCHAR | Originating source (same value as indicadores_serie.fonte). |
| indicador_idKEY | VARCHAR | Identifier used in indicadores_serie.indicador_id. |
| descricao | VARCHAR | Human-readable indicator label in Portuguese (null when the source does not publish a label). |
| unidade | VARCHAR | Predominant unit of measure of the indicator. |
| periodicidade | VARCHAR | annual, monthly or quarterly (inferred from the periodo format). |
| periodo_min | VARCHAR | First available period. |
| periodo_max | VARCHAR | Last available period. |
| n_periodos | BIGINT | Number of distinct periods. |
| n_municipios | BIGINT | Number of municipalities with at least one value. |
| n_linhas | BIGINT | Number of rows in indicadores_serie. |
| fonte_nome | VARCHAR | Name of the originating source/survey. |
| fonte_url | VARCHAR | Official page of the source. |
Queries that read this table
Search municipal indicators. Searches the dictionary of municipal-level indicators (~700 from ~20 sources: IBGE/PAM/PPM, SINISA/SNIS, CNES, INEP, RAIS, SINESP, National Treasury, Bolsa Família/BPC, INPE…). Returns indicador_id, unit, frequency and coverage — use the indicador_id in indicador_serie, ranking and comparar.
- transferencias_municipio2 credits
Constitutional transfers to the municipality. Federal transfers to the municipality (National Treasury): FPM, Fundeb, ITR, CIDE-Combustíveis, IOF-Ouro, LC 176/2020, Lei Kandir and FEX, by year or month, with the period total and each transfer's share. Default: last 5 years. Gap: SUS fund-to-fund transfers (FNS), ICMS/IPVA revenue shares and voluntary transfers are NOT in the lake.
- municipio_vs_pares5 credits
Municipality vs. peers of the same size. Compares a municipality with an automatic group of up to 30 peers: same state (UF) (or same region, if the state has fewer than 10) with population between -30% and +30% (if there are not 10, the 30 closest in population in the region). For each indicator (up to 5) it returns the municipality's value, median, p25, p75, the municipality's percentile among its peers and only the top 5/bottom 5 peers — never the full list.
- agro_municipio2 credits
Municipality agriculture and livestock (crops and herds). Agricultural production (IBGE PAM: temporary and permanent crops — harvested area, quantity, production value, yield and share of total value) and livestock (IBGE PPM: herd sizes, milked cows and production of milk, eggs, honey, wool) of a municipality in a year (default: the most recent). Gap: the value of animal production (R$) and forestry/plant extraction are not in the lake.
- educacao_municipio2 credits
Municipality education (basic and higher). Education in a municipality: INEP School Census (schools by network and location, enrollments by stage, teachers, student/teacher ratio, % of schools with internet, library, labs etc.), Higher Education Census (HEIs, programs, enrollments, new entrants, graduates) and IDEB 2023 (early/final years). Default year: the most recent of each source; includes the previous year's value for comparison. Gap: the lake only has the 2023 IDEB (no series, no SAEB, no pass/dropout rates).
- saude_municipio2 credits
Municipality health (facilities and health plans). A municipality's health network: CNES facilities (total and by type — UBS, hospitals, emergency care, CAPS, clinics…) per 10,000 inhabitants, and health plan beneficiaries (ANS) with coverage relative to the population. Default period: the most recent of each source (uses the last <= periodo). Gap: beds (CNES-LT), professionals, SUS production and the public/private split of facilities are NOT in the lake.
Query via MCP
The lake is served through curated queries. Connect your agent to the MCP server and ask — it finds the right query on its own. All you need is an API key — new keys come with 50 free credits (pricing).
indicadores_buscar
Which municipal indicators about schools are available?