camara_votos
Deputies' roll-call votes
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.
Query via MCP ↓1,579,536 rows · 7 columns
- One row is
- one row per (id_votacao, id_deputado)
- Key columns
- id_votacao, id_deputado
- License
- Government open data (Law 12,527/2011 — LAI)
- Domain
- Politics
- Snapshot
- 2026-09-25
Columns
| Column | Type | Description |
|---|---|---|
| id_votacaoKEY | VARCHAR | Vote identifier (= camara_votacoes.id). |
| id_deputadoKEY | BIGINT | Deputy identifier in the Chamber API. |
| ano | BIGINT | Year of the vote. |
| voto | VARCHAR | Sim, Não, Obstrução, Abstenção or Artigo 17 (presiding officer). |
| data_hora | TIMESTAMP WITH TIME ZONE | Date and time the vote was recorded. |
| sigla_partido | VARCHAR | Deputy's party at the time of the vote. |
| sigla_uf | VARCHAR | Deputy's state (UF). |
Queries that read this table
No curated query reads this table directly yet — it feeds the lake's derived tables. Browse all queries.
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).
camara_votos
Deputies' roll-call votes.
Use the lakebrasil MCP — start with consultas_buscar — and cite the
source of each number.