camara_votacoes
Chamber of Deputies votes (roll calls)
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.
Query via MCP ↓94,733 rows · 9 columns
- One row is
- one row per vote (roll call)
- Key columns
- id
- License
- Government open data (Law 12,527/2011 — LAI)
- Domain
- Politics
- Snapshot
- 2026-09-25
Columns
| Column | Type | Description |
|---|---|---|
| idKEY | VARCHAR | Vote identifier (id of the bill/object + sequence number). |
| ano | BIGINT | Year of the vote. |
| data | VARCHAR | Date of the vote (AAAA-MM-DD, text). |
| data_hora_registro | TIMESTAMP WITH TIME ZONE | Date and time the vote was recorded. |
| sigla_orgao | VARCHAR | Body where it took place (PLEN or committee abbreviation). |
| descricao | VARCHAR | Description of the outcome. |
| aprovacao | BIGINT | 1 if approved, 0 if rejected; null when not applicable. |
| ultima_apresentacao_proposicao | VARCHAR | Description of the latest filing of the bill voted on. |
| uri | VARCHAR | URI of the vote in the Chamber API. |
Queries that read this table
- camara_votacoes_resumo2 credits
Chamber of Deputies votes — summary. Chamber of Deputies votes by year and body (Plenary, committees), with how many were approved. Aggregated summary.
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_votacoes_resumo
Summarize the Chamber of Deputies' floor votes since 2024.