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

14 rows where bill_id = "103-hr-3136" 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 1

  • 0 14
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hr-3136,C000488 Rent-To-Own Reform Act of 1993 103-hr-3136 C000488 Rep. Clay, William (Bill) [D-MO-1] D MO 1994-04-19 0
103-hr-3136,E000250 Rent-To-Own Reform Act of 1993 103-hr-3136 E000250 Rep. Evans, Lane [D-IL-17] D IL 1994-03-08 0
103-hr-3136,R000243 Rent-To-Own Reform Act of 1993 103-hr-3136 R000243 Rep. Ridge, Thomas J. [R-PA-21] R PA 1994-02-01 0
103-hr-3136,S000148 Rent-To-Own Reform Act of 1993 103-hr-3136 S000148 Rep. Schumer, Charles E. [D-NY-9] D NY 1993-11-17 0
103-hr-3136,W000207 Rent-To-Own Reform Act of 1993 103-hr-3136 W000207 Rep. Watt, Melvin L. [D-NC-12] D NC 1993-11-17 0
103-hr-3136,G000535 Rent-To-Own Reform Act of 1993 103-hr-3136 G000535 Rep. Gutierrez, Luis V. [D-IL-4] D IL 1993-11-01 0
103-hr-3136,B000177 Rent-To-Own Reform Act of 1993 103-hr-3136 B000177 Rep. Barrett, Thomas M. [D-WI-5] D WI 1993-11-01 0
103-hr-3136,H000627 Rent-To-Own Reform Act of 1993 103-hr-3136 H000627 Rep. Hinchey, Maurice D. [D-NY-26] D NY 1993-11-01 0
103-hr-3136,R000515 Rent-To-Own Reform Act of 1993 103-hr-3136 R000515 Rep. Rush, Bobby L. [D-IL-1] D IL 1993-11-01 0
103-hr-3136,R000486 Rent-To-Own Reform Act of 1993 103-hr-3136 R000486 Rep. Roybal-Allard, Lucille [D-CA-33] D CA 1993-11-01 0
103-hr-3136,W000187 Rent-To-Own Reform Act of 1993 103-hr-3136 W000187 Rep. Waters, Maxine [D-CA-35] D CA 1993-11-01 0
103-hr-3136,T000316 Rent-To-Own Reform Act of 1993 103-hr-3136 T000316 Rep. Torres, Esteban Edward [D-CA-34] D CA 1993-11-01 0
103-hr-3136,K000110 Rent-To-Own Reform Act of 1993 103-hr-3136 K000110 Rep. Kennedy, Joseph P., II [D-MA-8] D MA 1993-10-14 0
103-hr-3136,G000309 Rent-To-Own Reform Act of 1993 103-hr-3136 G000309 Rep. Gordon, Bart [D-TN-6] D TN 1993-10-07 0

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);