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

9 rows where bill_id = "118-hr-1237" 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
118-hr-1237,H001081 Sarah Keys Evans Congressional Gold Medal Act 118-hr-1237 H001081 Rep. Hayes, Jahana [D-CT-5] D CT 2023-12-22 0
118-hr-1237,R000305 Sarah Keys Evans Congressional Gold Medal Act 118-hr-1237 R000305 Rep. Ross, Deborah K. [D-NC-2] D NC 2023-02-28 1
118-hr-1237,N000194 Sarah Keys Evans Congressional Gold Medal Act 118-hr-1237 N000194 Rep. Nickel, Wiley [D-NC-13] D NC 2023-02-28 1
118-hr-1237,J000288 Sarah Keys Evans Congressional Gold Medal Act 118-hr-1237 J000288 Rep. Johnson, Henry C. "Hank," Jr. [D-GA-4] D GA 2023-02-28 1
118-hr-1237,P000604 Sarah Keys Evans Congressional Gold Medal Act 118-hr-1237 P000604 Rep. Payne, Donald M., Jr. [D-NJ-10] D NJ 2023-02-28 1
118-hr-1237,L000562 Sarah Keys Evans Congressional Gold Medal Act 118-hr-1237 L000562 Rep. Lynch, Stephen F. [D-MA-8] D MA 2023-02-28 1
118-hr-1237,C001072 Sarah Keys Evans Congressional Gold Medal Act 118-hr-1237 C001072 Rep. Carson, Andre [D-IN-7] D IN 2023-02-28 1
118-hr-1237,N000147 Sarah Keys Evans Congressional Gold Medal Act 118-hr-1237 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2023-02-28 1
118-hr-1237,T000481 Sarah Keys Evans Congressional Gold Medal Act 118-hr-1237 T000481 Rep. Tlaib, Rashida [D-MI-12] D MI 2023-02-28 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);