indicadores_serie

Columns

Queries that read this table

• indicador_serie2 credits

  Indicator time series. Values of an indicator (indicador_id from indicadores_buscar) for 1 to 10 municipalities over time, with unit and source.

• ranking3 credits

  Municipality ranking by indicator. Top N (<= 100) municipalities by an indicator in a period (default: the most recent), nationwide, in a state (UF) or region.

• comparar3 credits

  Compare municipalities across several indicators. Up to 10 municipalities × up to 10 indicators; by default the most recent value of each pair (or of a fixed period).

• 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.

• filtrar_municipios5 credits

  Filter municipalities by criteria (screener). Finds municipalities that meet up to 5 criteria {indicador_id, operador, valor} at once (e.g. population >= 100000 and bf.beneficiarios < 5000), optionally in a state (UF) or region, sorted by an indicator. "populacao" = 2025 estimate (2022 Census if missing). Default period: the most recent of each indicator; a municipality without data for an indicator fails that criterion. At most 50 rows and 1 page (total_encontrados says how many match); each row counts double toward the daily row limit.

• variacao_indicador3 credits

  Ranking of an indicator's change between two periods. Municipalities with the largest increase or largest decrease in an indicator between periodo_inicio and periodo_fim, with absolute and percentage change; sorts by the chosen measure (percentage ignores zero/negative bases). Top N <= 50, nationwide, in a state (UF) or region; populacao_min excludes very small municipalities.

• 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.

• programas_sociais_municipio2 credits

  Social programs in the municipality (Bolsa Família, BPC, Pé-de-Meia). Bolsa Família, BPC/LOAS and Pé-de-Meia in a municipality: beneficiaries (last month and monthly average), total amount paid, monthly average, per capita amount and beneficiaries per 1,000 inhabitants, plus a total row. Default: the last 12 available months of each program. Pé-de-Meia counts payments (a student may receive more than one in a month).

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).

How has the number of Bolsa Família beneficiaries in Santos and São
Paulo changed since January 2025?