Name: Between the Bills open legislative record
Creator: Between the Bills
License: https://creativecommons.org/publicdomain/mark/1.0/

Between the Bills Open Data

Bill and resolution records from Congress since 1999 and roll-call votes since 1789, in one public archive. Search it here, query all 33.98 million rows with SQL in your browser, call the free API, or take the files with you.

Rows in the archive: 33,978,824
Roll-call vote positions: 26,401,508
Bills and resolutions: 173,568
Congresses: 1st–119th

Release 4ce2964, refreshed November 2, 2026.

Harris & Ewing, a new tabulating machine for the 1940 census, December 2, 1939. Library of Congress. Public domain.

Search every bill

93,893 bills and joint resolutions from the 113th Congress (2013) to today. Open any row for its full timeline of recorded actions.

Loading…

Matching bills
Bill	Title	Sponsor	Day one	Got to	Introduced

Query 33.98 million rows in your browser

The console runs DuckDB inside this page and reads the Parquet archive straight from Hugging Face. Nothing loads until you run a query; each table then downloads the first time a query uses it, and later queries run on your own machine. Nothing you type is sent to our servers.

Starts when you run your first query

Tab indents inside the editor. Press Escape, then Tab, to move on.

Tables and columns

A free, read-only JSON API

No key, no sign-up. Responses are cached at the edge and safe to call from a browser. Please keep it under a few requests per second, and cache what you can.

Endpointhttps://nusmmbtxvphisicjoxlm.supabase.co/functions/v1/btb-open

Pick a route, then send the request.

Parameters for bills

q: Full-text search over titles, sponsors and policy areas, or a bill number such as 118-hr815.
congress: 113 to 119.
chamber: House or Senate.
coalition: bipartisan, not_bipartisan; for the 116th onward also same_party, solo.
furthest: introduced, cleared_committee, passed_one, passed_both, law.
party: Sponsor party: D, R, I.
policy: Exact policy area name, from route=policy_areas.
limit, cursor: Up to 50 rows per page. Pass the next_cursor from one response to get the next page.

Code to copy

JavaScript Python curl R

Eighteen tables, one record

Fourteen tables built from the Library of Congress Bill Status files, the records behind Congress.gov, cover bills from the 108th Congress (2003) on. Four more from Voteview cover roll calls since the First Congress. Apache Parquet, one public dataset on Hugging Face (release 4ce2964), readable by DuckDB, pandas, polars, R and Spark.

Filter tables

bills One row per bill or resolution: title, sponsor, policy area, cosponsor counts (total, original, cross-party) and whether it became law. 173,568 108th–119th (2003–today)

Download the files: 8.0 MB in 12 files Also in the live API: 93,893 rows, 113th–119th. Source: Library of Congress Bill Status (GovInfo bulk data)

Columns in bills
Column	Type
`bill_id`	varchar
`congress`	bigint
`bill_type`	varchar
`bill_number`	bigint
`title`	varchar
`introduced_date`	date
`origin_chamber`	varchar
`policy_area`	varchar
`sponsor_bioguide`	varchar
`sponsor_name`	varchar
`sponsor_party`	varchar
`sponsor_state`	varchar
`sponsor_district`	varchar
`by_request`	boolean
`n_cosponsors`	bigint
`n_original_cosponsors`	bigint
`n_cross_party_cosponsors`	bigint
`n_original_cross_party`	bigint
`n_withdrawn_cosponsors`	bigint
`n_actions`	bigint
`n_committees`	bigint
`n_subjects`	bigint
`n_amendments`	bigint
`n_text_versions`	bigint
`became_law`	boolean
`law_type`	varchar
`law_number`	varchar
`latest_action_date`	date
`latest_action_text`	varchar
`update_date`	date
`congress_url`	varchar

actions Every recorded action on every bill: date, Library of Congress code, text, and the roll call when there was one. 933,053 108th–119th (2003–today)

Download the files: 7.3 MB in 12 files Also in the live API: 465,291 rows, 113th–119th. Source: Library of Congress Bill Status (GovInfo bulk data)

Columns in actions
Column	Type
`bill_id`	varchar
`congress`	bigint
`seq`	bigint
`action_date`	date
`action_time`	varchar
`text`	varchar
`type`	varchar
`action_code`	varchar
`source_code`	varchar
`source_name`	varchar
`committee_codes`	varchar
`vote_chamber`	varchar
`vote_roll`	bigint
`vote_session`	bigint
`vote_url`	varchar

cosponsors Every cosponsorship: member, party, state, join and withdrawal dates, original flag, and whether it crossed the aisle. 2,106,325 108th–119th (2003–today)

Download the files: 10.1 MB in 12 files Source: Library of Congress Bill Status (GovInfo bulk data)

Columns in cosponsors
Column	Type
`bill_id`	varchar
`congress`	bigint
`bioguide_id`	varchar
`full_name`	varchar
`party`	varchar
`state`	varchar
`district`	varchar
`sponsorship_date`	date
`withdrawn_date`	date
`is_original`	boolean
`cross_party`	boolean

committees Committee and subcommittee activity per bill: referrals, hearings, markups, reports, with dates. 341,317 108th–119th (2003–today)

Download the files: 3.7 MB in 12 files Source: Library of Congress Bill Status (GovInfo bulk data)

Columns in committees
Column	Type
`bill_id`	varchar
`congress`	bigint
`system_code`	varchar
`name`	varchar
`chamber`	varchar
`committee_type`	varchar
`parent_code`	varchar
`activity`	varchar
`activity_date`	date

subjects Library of Congress legislative subject terms, one row per bill and term. 1,527,403 108th–119th (2003–today)

Download the files: 3.1 MB in 12 files Source: Library of Congress Bill Status (GovInfo bulk data)

Columns in subjects
Column	Type
`bill_id`	varchar
`congress`	bigint
`subject`	varchar

summaries Congressional Research Service summaries as plain text, one row per bill version. 190,080 108th–119th (2003–today)

Download the files: 41.7 MB in 12 files Source: Library of Congress Bill Status (GovInfo bulk data)

Columns in summaries
Column	Type
`bill_id`	varchar
`congress`	bigint
`version_code`	varchar
`action_date`	date
`action_desc`	varchar
`update_date`	date
`text`	varchar

titles Every official, short and popular title a bill carried. 525,070 108th–119th (2003–today)

Download the files: 10.3 MB in 12 files Source: Library of Congress Bill Status (GovInfo bulk data)

Columns in titles
Column	Type
`bill_id`	varchar
`congress`	bigint
`title_type`	varchar
`title`	varchar
`chamber`	varchar
`version`	varchar

related_bills Links between bills: identical, related, procedurally related. 152,521 108th–119th (2003–today)

Download the files: 955 KB in 12 files Source: Library of Congress Bill Status (GovInfo bulk data)

Columns in related_bills
Column	Type
`bill_id`	varchar
`congress`	bigint
`related_bill_id`	varchar
`relationship`	varchar
`identified_by`	varchar

amendments Amendments offered to bills, with sponsor, purpose and latest action. 68,014 108th–119th (2003–today)

Download the files: 1.6 MB in 12 files Source: Library of Congress Bill Status (GovInfo bulk data)

Columns in amendments
Column	Type
`bill_id`	varchar
`congress`	bigint
`amendment_id`	varchar
`chamber`	varchar
`purpose`	varchar
`sponsor_bioguide`	varchar
`sponsor_party`	varchar
`proposed_date`	date
`submitted_date`	date
`latest_action_date`	date
`latest_action_text`	varchar

text_versions Published text versions with links to the text. 226,628 108th–119th (2003–today)

Download the files: 2.4 MB in 12 files Source: Library of Congress Bill Status (GovInfo bulk data)

Columns in text_versions
Column	Type
`bill_id`	varchar
`congress`	bigint
`version`	varchar
`date`	date
`url`	varchar

cbo_estimates Congressional Budget Office cost estimates. 17,731 108th–119th (2003–today)

Download the files: 499 KB in 10 files Source: Library of Congress Bill Status (GovInfo bulk data)

Columns in cbo_estimates
Column	Type
`bill_id`	varchar
`congress`	bigint
`pub_date`	date
`title`	varchar
`url`	varchar

committee_reports Committee report citations per bill. 13,793 108th–119th (2003–today)

Download the files: 114 KB in 12 files Source: Library of Congress Bill Status (GovInfo bulk data)

Columns in committee_reports
Column	Type
`bill_id`	varchar
`congress`	bigint
`citation`	varchar

laws Public and private laws enacted, with law numbers. 4,309 108th–119th (2003–today)

Download the files: 46 KB in 12 files Source: Library of Congress Bill Status (GovInfo bulk data)

Columns in laws
Column	Type
`bill_id`	varchar
`congress`	bigint
`law_type`	varchar
`law_number`	varchar

recorded_votes Roll-call votes tied to bill actions. 19,766 108th–119th (2003–today)

Download the files: 535 KB in 12 files Source: Library of Congress Bill Status (GovInfo bulk data)

Columns in recorded_votes
Column	Type
`bill_id`	varchar
`congress`	bigint
`chamber`	varchar
`session`	bigint
`roll_number`	bigint
`date`	date
`url`	varchar
`action_text`	varchar

votes Source actor positions on roll calls, including presidential positions and preserved source repeats. cast_code 1–3 yea, 4–6 nay, 7–8 present, 9 not voting. Join to members on congress, chamber and icpsr. 26,401,508 1st–119th (1789–today)

Download the files: 44.6 MB in 8 files Source: Voteview (Lewis, Poole, Rosenthal, Boche, Rudkin and Sonnet), UCLA

Columns in votes
Column	Type
`congress`	bigint
`chamber`	varchar
`rollnumber`	bigint
`icpsr`	bigint
`cast_code`	bigint
`prob`	varchar

rollcalls Every roll call since 1789: date, question, result, yea and nay tallies. 113,568 1st–119th (1789–today)

Download the files: 6.1 MB Source: Voteview (Lewis, Poole, Rosenthal, Boche, Rudkin and Sonnet), UCLA

Columns in rollcalls
Column	Type
`congress`	bigint
`chamber`	varchar
`rollnumber`	bigint
`date`	date
`session`	integer
`clerk_rollnumber`	integer
`majority_requirement`	varchar
`yea_count`	bigint
`nay_count`	bigint
`nominate_mid_1`	double
`nominate_mid_2`	double
`nominate_spread_1`	double
`nominate_spread_2`	double
`nominate_log_likelihood`	double
`bill_number`	varchar
`vote_result`	varchar
`vote_desc`	varchar
`vote_question`	varchar
`dtl_desc`	varchar

members Actor roster entries by Congress and chamber, including President entries, with names, party and available ideology scores. 51,064 1st–119th (1789–today)

Download the files: 1.3 MB Source: Voteview (Lewis, Poole, Rosenthal, Boche, Rudkin and Sonnet), UCLA

Columns in members
Column	Type
`congress`	bigint
`chamber`	varchar
`icpsr`	bigint
`state_icpsr`	bigint
`district_code`	integer
`state_abbrev`	varchar
`party_code`	integer
`occupancy`	bigint
`last_means`	bigint
`bioname`	varchar
`bioguide_id`	varchar
`born`	integer
`died`	integer
`nominate_dim1`	double
`nominate_dim2`	double
`nominate_log_likelihood`	double
`nominate_geo_mean_probability`	double
`nominate_number_of_votes`	bigint
`nominate_number_of_errors`	bigint
`conditional`	varchar
`nokken_poole_dim1`	double
`nokken_poole_dim2`	double

parties Party codes and names per Congress and chamber, with median ideology. 848 1st–119th (1789–today)

Download the files: 20 KB Source: Voteview (Lewis, Poole, Rosenthal, Boche, Rudkin and Sonnet), UCLA

Columns in parties
Column	Type
`congress`	bigint
`chamber`	varchar
`party_code`	integer
`party_name`	varchar
`n_members`	bigint
`nominate_dim1_median`	double
`nominate_dim2_median`	double
`nominate_dim1_mean`	double
`nominate_dim2_mean`	double

member networks Each member’s top cross-party partners, shared bills and laws, from investigation 002. API only: route=member. 806 Investigation 002

The dataset on Hugging FaceAll 18 tables, a data viewer and the dataset card with sources and methods.
Validation reportRow counts, duplicate and orphan checks, and law totals matched against the official record.
The research repositoryThe pipeline and SQL behind the investigations, with per-row source checksums, on GitHub.

Things to know

Coverage, codes and known gaps in the source records.

Coverage
Bill and resolution tables begin with the 108th Congress (2003). Voteview records span the 1st–119th Congresses. The Browse tab and the API serve the 113th–119th.
Votes
cast_code 1–3 is yea, 4–6 nay, 7–8 present, 9 not voting. Party codes 100 and 200 are Democrats and Republicans; parties names the rest. Votes join to members on congress, chamber and icpsr.
The 119th Congress is in session
Its bills are still moving, so counts change until the record is final.
Flags, not fixes
Rows with quality problems are kept and flagged. Some bills have no sponsor in the source, and a handful of text versions carry impossible dates. Newer bills carry fewer subject terms because the Library of Congress adds them over time.
Grain
Every bill table has bill_id (for example 118-hr-815) and congress. Cosponsorships are one row per bill, member and join date; votes one row per member and roll call.

Use it, and credit it

The bill records are works of the U.S. government and in the public domain; the vote records come from Voteview at UCLA. If you publish with this compilation, please credit Between the Bills, the Library of Congress and Voteview.

Between the Bills. Congressional archive: bills 1999–present and roll-call votes 1789–present, version 09d33ee. Compiled from Library of Congress Bill Status records (GovInfo) and Voteview (Lewis et al., UCLA). https://betweenthebills.com/data/

Search every bill

Query 33.98 million rows in your browser

A free, read-only JSON API

Eighteen tables, one record

Things to know

Coverage

Votes

The 119th Congress is in session

Flags, not fixes

Grain

Use it, and credit it

Get new reviews by email