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

12 rows where bill_id = "110-hr-5312" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
110-hr-5312,B001259 Automobile Arbitration Fairness Act of 2008 110-hr-5312 B001259 Rep. Braley, Bruce L. [D-IA-1] D IA 2008-05-06 0
110-hr-5312,S000344 Automobile Arbitration Fairness Act of 2008 110-hr-5312 S000344 Rep. Sherman, Brad [D-CA-27] D CA 2008-04-23 0
110-hr-5312,F000043 Automobile Arbitration Fairness Act of 2008 110-hr-5312 F000043 Rep. Fattah, Chaka [D-PA-2] D PA 2008-03-12 0
110-hr-5312,C000714 Automobile Arbitration Fairness Act of 2008 110-hr-5312 C000714 Rep. Conyers, John, Jr. [D-MI-14] D MI 2008-02-07 1
110-hr-5312,C001068 Automobile Arbitration Fairness Act of 2008 110-hr-5312 C001068 Rep. Cohen, Steve [D-TN-9] D TN 2008-02-07 1
110-hr-5312,W000207 Automobile Arbitration Fairness Act of 2008 110-hr-5312 W000207 Rep. Watt, Melvin L. [D-NC-12] D NC 2008-02-07 1
110-hr-5312,L000397 Automobile Arbitration Fairness Act of 2008 110-hr-5312 L000397 Rep. Lofgren, Zoe [D-CA-16] D CA 2008-02-07 1
110-hr-5312,J000288 Automobile Arbitration Fairness Act of 2008 110-hr-5312 J000288 Rep. Johnson, Henry C. "Hank," Jr. [D-GA-4] D GA 2008-02-07 1
110-hr-5312,K000336 Automobile Arbitration Fairness Act of 2008 110-hr-5312 K000336 Rep. Kucinich, Dennis J. [D-OH-10] D OH 2008-02-07 1
110-hr-5312,W000797 Automobile Arbitration Fairness Act of 2008 110-hr-5312 W000797 Rep. Wasserman Schultz, Debbie [D-FL-20] D FL 2008-02-07 1
110-hr-5312,W000314 Automobile Arbitration Fairness Act of 2008 110-hr-5312 W000314 Rep. Wexler, Robert [D-FL-19] D FL 2008-02-07 1
110-hr-5312,D000210 Automobile Arbitration Fairness Act of 2008 110-hr-5312 D000210 Rep. Delahunt, William D. [D-MA-10] D MA 2008-02-07 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);