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

19 rows where bill_id = "116-hr-3655" 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

  • 1 12
  • 0 7
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
116-hr-3655,F000465 Livestock Protection Act of 2019 116-hr-3655 F000465 Rep. Ferguson, A. Drew, IV [R-GA-3] R GA 2019-09-25 0
116-hr-3655,D000619 Livestock Protection Act of 2019 116-hr-3655 D000619 Rep. Davis, Rodney [R-IL-13] R IL 2019-09-09 0
116-hr-3655,B001306 Livestock Protection Act of 2019 116-hr-3655 B001306 Rep. Balderson, Troy [R-OH-12] R OH 2019-07-18 0
116-hr-3655,G000563 Livestock Protection Act of 2019 116-hr-3655 G000563 Rep. Gibbs, Bob [R-OH-7] R OH 2019-07-17 0
116-hr-3655,S001214 Livestock Protection Act of 2019 116-hr-3655 S001214 Rep. Steube, W. Gregory [R-FL-17] R FL 2019-07-17 0
116-hr-3655,P000615 Livestock Protection Act of 2019 116-hr-3655 P000615 Rep. Pence, Greg [R-IN-6] R IN 2019-07-12 0
116-hr-3655,P000601 Livestock Protection Act of 2019 116-hr-3655 P000601 Rep. Palazzo, Steven M. [R-MS-4] R MS 2019-07-10 0
116-hr-3655,B001307 Livestock Protection Act of 2019 116-hr-3655 B001307 Rep. Baird, James R. [R-IN-4] R IN 2019-07-09 1
116-hr-3655,D000616 Livestock Protection Act of 2019 116-hr-3655 D000616 Rep. DesJarlais, Scott [R-TN-4] R TN 2019-07-09 1
116-hr-3655,C001087 Livestock Protection Act of 2019 116-hr-3655 C001087 Rep. Crawford, Eric A. "Rick" [R-AR-1] R AR 2019-07-09 1
116-hr-3655,C001108 Livestock Protection Act of 2019 116-hr-3655 C001108 Rep. Comer, James [R-KY-1] R KY 2019-07-09 1
116-hr-3655,L000569 Livestock Protection Act of 2019 116-hr-3655 L000569 Rep. Luetkemeyer, Blaine [R-MO-3] R MO 2019-07-09 1
116-hr-3655,G000591 Livestock Protection Act of 2019 116-hr-3655 G000591 Rep. Guest, Michael [R-MS-3] R MS 2019-07-09 1
116-hr-3655,K000388 Livestock Protection Act of 2019 116-hr-3655 K000388 Rep. Kelly, Trent [R-MS-1] R MS 2019-07-09 1
116-hr-3655,R000575 Livestock Protection Act of 2019 116-hr-3655 R000575 Rep. Rogers, Mike D. [R-AL-3] R AL 2019-07-09 1
116-hr-3655,W000821 Livestock Protection Act of 2019 116-hr-3655 W000821 Rep. Westerman, Bruce [R-AR-4] R AR 2019-07-09 1
116-hr-3655,A000374 Livestock Protection Act of 2019 116-hr-3655 A000374 Rep. Abraham, Ralph Lee [R-LA-5] R LA 2019-07-09 1
116-hr-3655,M001184 Livestock Protection Act of 2019 116-hr-3655 M001184 Rep. Massie, Thomas [R-KY-4] R KY 2019-07-09 1
116-hr-3655,B001295 Livestock Protection Act of 2019 116-hr-3655 B001295 Rep. Bost, Mike [R-IL-12] R IL 2019-07-09 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);