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

21 rows where bill_id = "111-hr-4603" 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 21
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hr-4603,T000238 HOPE Act 111-hr-4603 T000238 Rep. Thornberry, Mac [R-TX-13] R TX 2010-05-06 0
111-hr-4603,C001077 HOPE Act 111-hr-4603 C001077 Rep. Coffman, Mike [R-CO-6] R CO 2010-04-29 0
111-hr-4603,C001051 HOPE Act 111-hr-4603 C001051 Rep. Carter, John R. [R-TX-31] R TX 2010-04-20 0
111-hr-4603,L000111 HOPE Act 111-hr-4603 L000111 Rep. Latham, Tom [R-IA-4] R IA 2010-04-20 0
111-hr-4603,S001169 HOPE Act 111-hr-4603 S001169 Rep. Sestak, Joe [D-PA-7] D PA 2010-03-25 0
111-hr-4603,B001256 HOPE Act 111-hr-4603 B001256 Rep. Bachmann, Michele [R-MN-6] R MN 2010-03-22 0
111-hr-4603,C001076 HOPE Act 111-hr-4603 C001076 Rep. Chaffetz, Jason [R-UT-3] R UT 2010-03-17 0
111-hr-4603,E000092 HOPE Act 111-hr-4603 E000092 Rep. Ehlers, Vernon J. [R-MI-3] R MI 2010-03-17 0
111-hr-4603,F000448 HOPE Act 111-hr-4603 F000448 Rep. Franks, Trent [R-AZ-2] R AZ 2010-03-16 0
111-hr-4603,S001143 HOPE Act 111-hr-4603 S001143 Rep. Souder, Mark E. [R-IN-3] R IN 2010-03-16 0
111-hr-4603,P000373 HOPE Act 111-hr-4603 P000373 Rep. Pitts, Joseph R. [R-PA-16] R PA 2010-03-16 0
111-hr-4603,B000755 HOPE Act 111-hr-4603 B000755 Rep. Brady, Kevin [R-TX-8] R TX 2010-03-16 0
111-hr-4603,G000377 HOPE Act 111-hr-4603 G000377 Rep. Granger, Kay [R-TX-12] R TX 2010-03-16 0
111-hr-4603,L000564 HOPE Act 111-hr-4603 L000564 Rep. Lamborn, Doug [R-CO-5] R CO 2010-03-16 0
111-hr-4603,E000289 HOPE Act 111-hr-4603 E000289 Rep. Ellsworth, Brad [D-IN-8] D IN 2010-03-16 0
111-hr-4603,B001260 HOPE Act 111-hr-4603 B001260 Rep. Buchanan, Vern [R-FL-13] R FL 2010-02-26 0
111-hr-4603,M001138 HOPE Act 111-hr-4603 M001138 Rep. Manzullo, Donald A. [R-IL-16] R IL 2010-02-26 0
111-hr-4603,C001075 HOPE Act 111-hr-4603 C001075 Rep. Cassidy, Bill [R-LA-6] R LA 2010-02-26 0
111-hr-4603,H001047 HOPE Act 111-hr-4603 H001047 Rep. Himes, James A. [D-CT-4] D CT 2010-02-26 0
111-hr-4603,A000358 HOPE Act 111-hr-4603 A000358 Rep. Akin, W. Todd [R-MO-2] R MO 2010-02-26 0
111-hr-4603,S000364 HOPE Act 111-hr-4603 S000364 Rep. Shimkus, John [R-IL-19] R IL 2010-02-26 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);