congress_bills
One row per congressional bill, ingested from the Congress.gov v3 REST API (/bill list endpoint) by build_congress_bills. The legislative record complementary to the regulations.gov dockets/documents view — the bills that authorize the rulemakings this dataset tracks. Scope is deliberately list-level only (no per-bill detail fetches), so every column comes from the list payload. Incremental by update_date, deduped on bill_id. All columns are stored as VARCHAR.
- Parquet file:
congress_bills.parquet - Queryable via MCP
query_sql: Yes
| Column | Type | Description |
|---|---|---|
bill_id |
VARCHAR |
Synthetic key {congress}-{type}-{number} (e.g. 118-hr-1234). Primary key / dedup key. |
congress |
VARCHAR |
Congress number the bill was introduced in (e.g. 118). |
bill_type |
VARCHAR |
Bill type, lowercased (e.g. hr, s, hjres, sjres, hconres, sconres, hres, sres). |
bill_number |
VARCHAR |
Bill number within its (congress, bill_type) (e.g. 1234). |
title |
VARCHAR |
Bill title as returned by the list endpoint. |
origin_chamber |
VARCHAR |
Chamber the bill originated in (House or Senate). |
latest_action_date |
VARCHAR |
Date of the most recent action on the bill (ISO 8601 string). Often the useful sort/recency signal. |
latest_action_text |
VARCHAR |
Text describing the most recent action on the bill. |
update_date |
VARCHAR |
Date the Congress.gov record was last updated (ISO 8601 string). Incremental window key. |
url |
VARCHAR |
Congress.gov API URL for the bill's detail resource. |