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

18 rows where bill_id = "116-hr-4347" 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

Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
116-hr-4347,N000191 PREPARE Act of 2019 116-hr-4347 N000191 Rep. Neguse, Joe [D-CO-2] D CO 2020-03-13 0
116-hr-4347,S001209 PREPARE Act of 2019 116-hr-4347 S001209 Rep. Spanberger, Abigail Davis [D-VA-7] D VA 2020-01-29 0
116-hr-4347,A000378 PREPARE Act of 2019 116-hr-4347 A000378 Rep. Axne, Cynthia [D-IA-3] D IA 2020-01-15 0
116-hr-4347,C001053 PREPARE Act of 2019 116-hr-4347 C001053 Rep. Cole, Tom [R-OK-4] R OK 2019-12-12 0
116-hr-4347,K000188 PREPARE Act of 2019 116-hr-4347 K000188 Rep. Kind, Ron [D-WI-3] D WI 2019-10-31 0
116-hr-4347,F000466 PREPARE Act of 2019 116-hr-4347 F000466 Rep. Fitzpatrick, Brian K. [R-PA-1] R PA 2019-10-16 0
116-hr-4347,P000608 PREPARE Act of 2019 116-hr-4347 P000608 Rep. Peters, Scott H. [D-CA-52] D CA 2019-09-26 0
116-hr-4347,J000032 PREPARE Act of 2019 116-hr-4347 J000032 Rep. Jackson Lee, Sheila [D-TX-18] D TX 2019-09-20 0
116-hr-4347,H001071 PREPARE Act of 2019 116-hr-4347 H001071 Rep. Hice, Jody B. [R-GA-10] R GA 2019-09-18 0
116-hr-4347,W000806 PREPARE Act of 2019 116-hr-4347 W000806 Rep. Webster, Daniel [R-FL-11] R FL 2019-09-17 1
116-hr-4347,L000579 PREPARE Act of 2019 116-hr-4347 L000579 Rep. Lowenthal, Alan S. [D-CA-47] D CA 2019-09-17 1
116-hr-4347,G000582 PREPARE Act of 2019 116-hr-4347 G000582 Resident Commissioner González-Colón, Jenniffer [R-PR-At Large] R PR 2019-09-17 1
116-hr-4347,G000565 PREPARE Act of 2019 116-hr-4347 G000565 Rep. Gosar, Paul A. [R-AZ-4] R AZ 2019-09-17 1
116-hr-4347,R000616 PREPARE Act of 2019 116-hr-4347 R000616 Rep. Rouda, Harley [D-CA-48] D CA 2019-09-17 1
116-hr-4347,C001078 PREPARE Act of 2019 116-hr-4347 C001078 Rep. Connolly, Gerald E. [D-VA-11] D VA 2019-09-17 1
116-hr-4347,L000578 PREPARE Act of 2019 116-hr-4347 L000578 Rep. LaMalfa, Doug [R-CA-1] R CA 2019-09-17 1
116-hr-4347,N000147 PREPARE Act of 2019 116-hr-4347 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2019-09-17 1
116-hr-4347,R000603 PREPARE Act of 2019 116-hr-4347 R000603 Rep. Rouzer, David [R-NC-7] R NC 2019-09-17 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);