home / openregs

legislation_cosponsors

Cosponsors for tracked legislation. Distinguishes original cosponsors (signed on at introduction) from later additions. Linked to congress_members via bioguide_id.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

17 rows where bill_id = "104-hr-3776" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 1 15
  • 0 2
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
104-hr-3776,C000560 Prison Work and Victim Restitution Act of 1996 104-hr-3776 C000560 Rep. Coburn, Tom [R-OK-2] R OK 1996-07-18 0
104-hr-3776,H000413 Prison Work and Victim Restitution Act of 1996 104-hr-3776 H000413 Rep. Hayworth, J. D. [R-AZ-6] R AZ 1996-07-18 0
104-hr-3776,E000187 Prison Work and Victim Restitution Act of 1996 104-hr-3776 E000187 Rep. English, Phil [R-PA-21] R PA 1996-07-10 1
104-hr-3776,G000134 Prison Work and Victim Restitution Act of 1996 104-hr-3776 G000134 Rep. Geren, Pete [D-TX-12] D TX 1996-07-10 1
104-hr-3776,R000033 Prison Work and Victim Restitution Act of 1996 104-hr-3776 R000033 Rep. Ramstad, Jim [R-MN-3] R MN 1996-07-10 1
104-hr-3776,Z000008 Prison Work and Victim Restitution Act of 1996 104-hr-3776 Z000008 Rep. Zimmer, Dick [R-NJ-12] R NJ 1996-07-10 1
104-hr-3776,J000033 Prison Work and Victim Restitution Act of 1996 104-hr-3776 J000033 Rep. Jacobs, Andrew, Jr. [D-IN-10] D IN 1996-07-10 1
104-hr-3776,C000377 Prison Work and Victim Restitution Act of 1996 104-hr-3776 C000377 Rep. Christensen, Jon [R-NE-2] R NE 1996-07-10 1
104-hr-3776,L000119 Prison Work and Victim Restitution Act of 1996 104-hr-3776 L000119 Rep. Laughlin, Greg [R-TX-14] R TX 1996-07-10 1
104-hr-3776,H000390 Prison Work and Victim Restitution Act of 1996 104-hr-3776 H000390 Rep. Hayes, James A. [R-LA-7] R LA 1996-07-10 1
104-hr-3776,S000822 Prison Work and Victim Restitution Act of 1996 104-hr-3776 S000822 Rep. Stearns, Cliff [R-FL-6] R FL 1996-07-10 1
104-hr-3776,W000437 Prison Work and Victim Restitution Act of 1996 104-hr-3776 W000437 Rep. Wicker, Roger F. [R-MS-1] R MS 1996-07-10 1
104-hr-3776,L000342 Prison Work and Victim Restitution Act of 1996 104-hr-3776 L000342 Rep. Lipinski, William O. [D-IL-3] D IL 1996-07-10 1
104-hr-3776,B000213 Prison Work and Victim Restitution Act of 1996 104-hr-3776 B000213 Rep. Barton, Joe [R-TX-6] R TX 1996-07-10 1
104-hr-3776,B000072 Prison Work and Victim Restitution Act of 1996 104-hr-3776 B000072 Rep. Baker, Richard H. [R-LA-6] R LA 1996-07-10 1
104-hr-3776,B000996 Prison Work and Victim Restitution Act of 1996 104-hr-3776 B000996 Rep. Bryant, Ed [R-TN-7] R TN 1996-07-10 1
104-hr-3776,L000096 Prison Work and Victim Restitution Act of 1996 104-hr-3776 L000096 Rep. Largent, Steve [R-OK-1] R OK 1996-07-10 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE legislation_cosponsors (
    bill_id TEXT NOT NULL REFERENCES legislation(bill_id),
    bioguide_id TEXT NOT NULL,
    full_name TEXT,
    party TEXT,
    state TEXT,
    sponsorship_date TEXT,
    is_original_cosponsor INTEGER,
    PRIMARY KEY (bill_id, bioguide_id)
);
CREATE INDEX idx_lc_bioguide ON legislation_cosponsors(bioguide_id);
CREATE INDEX idx_lc_bill ON legislation_cosponsors(bill_id);
CREATE INDEX idx_lc_original ON legislation_cosponsors(is_original_cosponsor);
Powered by Datasette · Queries took 7.426ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API