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 = "118-hr-7204" 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

  • 0 10
  • 1 4
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
118-hr-7204,N000147 Ensure Funding for Our Environment Act 118-hr-7204 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2024-06-25 0
118-hr-7204,K000394 Ensure Funding for Our Environment Act 118-hr-7204 K000394 Rep. Kim, Andy [D-NJ-3] D NJ 2024-05-31 0
118-hr-7204,N000188 Ensure Funding for Our Environment Act 118-hr-7204 N000188 Rep. Norcross, Donald [D-NJ-1] D NJ 2024-04-17 0
118-hr-7204,T000483 Ensure Funding for Our Environment Act 118-hr-7204 T000483 Rep. Trone, David J. [D-MD-6] D MD 2024-03-21 0
118-hr-7204,K000398 Ensure Funding for Our Environment Act 118-hr-7204 K000398 Rep. Kean, Thomas H. [R-NJ-7] R NJ 2024-03-13 0
118-hr-7204,S001207 Ensure Funding for Our Environment Act 118-hr-7204 S001207 Rep. Sherrill, Mikie [D-NJ-11] D NJ 2024-03-06 0
118-hr-7204,W000822 Ensure Funding for Our Environment Act 118-hr-7204 W000822 Rep. Watson Coleman, Bonnie [D-NJ-12] D NJ 2024-03-06 0
118-hr-7204,W000828 Ensure Funding for Our Environment Act 118-hr-7204 W000828 Rep. Williams, Brandon [R-NY-22] R NY 2024-02-28 0
118-hr-7204,C001090 Ensure Funding for Our Environment Act 118-hr-7204 C001090 Rep. Cartwright, Matt [D-PA-8] D PA 2024-02-09 0
118-hr-7204,G000583 Ensure Funding for Our Environment Act 118-hr-7204 G000583 Rep. Gottheimer, Josh [D-NJ-5] D NJ 2024-02-05 0
118-hr-7204,H001085 Ensure Funding for Our Environment Act 118-hr-7204 H001085 Rep. Houlahan, Chrissy [D-PA-6] D PA 2024-02-01 1
118-hr-7204,F000466 Ensure Funding for Our Environment Act 118-hr-7204 F000466 Rep. Fitzpatrick, Brian K. [R-PA-1] R PA 2024-02-01 1
118-hr-7204,E000296 Ensure Funding for Our Environment Act 118-hr-7204 E000296 Rep. Evans, Dwight [D-PA-3] D PA 2024-02-01 1
118-hr-7204,S001205 Ensure Funding for Our Environment Act 118-hr-7204 S001205 Rep. Scanlon, Mary Gay [D-PA-5] D PA 2024-02-01 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);