camara_proposicoes
Chamber of Deputies bills and proposals
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.
Query via MCP ↓525,056 rows · 11 columns
- One row is
- one row per bill / proposal
- Key columns
- id
- License
- Government open data (Law 12,527/2011 — LAI)
- Domain
- Politics
- Snapshot
- 2026-09-25
Columns
| Column | Type | Description |
|---|---|---|
| idKEY | BIGINT | Identifier of the bill/proposal in the Chamber API. |
| ano | BIGINT | Year of the bill/proposal. |
| sigla_tipo | VARCHAR | Type abbreviation (PL, PEC, MPV, REQ, RIC, PAR...). |
| numero | BIGINT | Number of the bill/proposal within the type/year. |
| ementa | VARCHAR | Summary (ementa, official abstract). |
| ementa_detalhada | VARCHAR | Detailed summary (often empty). |
| keywords | VARCHAR | Indexing keywords, comma-separated. |
| data_apresentacao | TIMESTAMP WITH TIME ZONE | Filing date and time (America/Sao_Paulo time zone). |
| sigla_orgao | VARCHAR | Abbreviation of the body where it was filed (PLEN, MESA, committees). |
| uri_orgao | VARCHAR | URI of the body in the Chamber API. |
| uri_proposicao | VARCHAR | URI of the bill/proposal in the Chamber API. |
Queries that read this table
- camara_proposicoes_resumo2 credits
Chamber of Deputies bills — summary. How many bills and propositions were introduced in the Chamber of Deputies per year and type (PL, PEC, MPV…), optionally filtered by words in the summary. Aggregated summary, without listing propositions.
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_proposicoes_resumo
How many bills did the Chamber of Deputies receive per year since 2023?