Skip to content

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.