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

26 rows where bill_id = "112-hr-4345" 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 23
  • 1 3
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hr-4345,A000055 Domestic Fuels Protection Act of 2012 112-hr-4345 A000055 Rep. Aderholt, Robert B. [R-AL-4] R AL 2012-09-10 0
112-hr-4345,N000186 Domestic Fuels Protection Act of 2012 112-hr-4345 N000186 Rep. Nunnelee, Alan [R-MS-1] R MS 2012-07-24 0
112-hr-4345,P000373 Domestic Fuels Protection Act of 2012 112-hr-4345 P000373 Rep. Pitts, Joseph R. [R-PA-16] R PA 2012-07-19 0
112-hr-4345,B000013 Domestic Fuels Protection Act of 2012 112-hr-4345 B000013 Rep. Bachus, Spencer [R-AL-6] R AL 2012-07-19 0
112-hr-4345,S001154 Domestic Fuels Protection Act of 2012 112-hr-4345 S001154 Rep. Shuster, Bill [R-PA-9] R PA 2012-07-18 0
112-hr-4345,H000712 Domestic Fuels Protection Act of 2012 112-hr-4345 H000712 Rep. Holden, Tim [D-PA-17] D PA 2012-07-18 0
112-hr-4345,H001045 Domestic Fuels Protection Act of 2012 112-hr-4345 H001045 Rep. Harper, Gregg [R-MS-3] R MS 2012-07-17 0
112-hr-4345,G000567 Domestic Fuels Protection Act of 2012 112-hr-4345 G000567 Rep. Griffin, Tim [R-AR-2] R AR 2012-06-27 0
112-hr-4345,P000601 Domestic Fuels Protection Act of 2012 112-hr-4345 P000601 Rep. Palazzo, Steven M. [R-MS-4] R MS 2012-06-06 0
112-hr-4345,P000602 Domestic Fuels Protection Act of 2012 112-hr-4345 P000602 Rep. Pompeo, Mike [R-KS-4] R KS 2012-05-31 0
112-hr-4345,P000592 Domestic Fuels Protection Act of 2012 112-hr-4345 P000592 Rep. Poe, Ted [R-TX-2] R TX 2012-05-30 0
112-hr-4345,M001142 Domestic Fuels Protection Act of 2012 112-hr-4345 M001142 Rep. Matheson, Jim [D-UT-2] D UT 2012-05-30 0
112-hr-4345,C001077 Domestic Fuels Protection Act of 2012 112-hr-4345 C001077 Rep. Coffman, Mike [R-CO-6] R CO 2012-05-30 0
112-hr-4345,W000795 Domestic Fuels Protection Act of 2012 112-hr-4345 W000795 Rep. Wilson, Joe [R-SC-2] R SC 2012-05-18 0
112-hr-4345,J000255 Domestic Fuels Protection Act of 2012 112-hr-4345 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2012-05-18 0
112-hr-4345,C001053 Domestic Fuels Protection Act of 2012 112-hr-4345 C001053 Rep. Cole, Tom [R-OK-4] R OK 2012-05-18 0
112-hr-4345,K000362 Domestic Fuels Protection Act of 2012 112-hr-4345 K000362 Rep. King, Steve [R-IA-5] R IA 2012-05-17 0
112-hr-4345,S001172 Domestic Fuels Protection Act of 2012 112-hr-4345 S001172 Rep. Smith, Adrian [R-NE-3] R NE 2012-05-17 0
112-hr-4345,B001256 Domestic Fuels Protection Act of 2012 112-hr-4345 B001256 Rep. Bachmann, Michele [R-MN-6] R MN 2012-05-17 0
112-hr-4345,B000652 Domestic Fuels Protection Act of 2012 112-hr-4345 B000652 Rep. Boswell, Leonard L. [D-IA-3] D IA 2012-05-07 0
112-hr-4345,L000569 Domestic Fuels Protection Act of 2012 112-hr-4345 L000569 Rep. Luetkemeyer, Blaine [R-MO-9] R MO 2012-05-07 0
112-hr-4345,L000111 Domestic Fuels Protection Act of 2012 112-hr-4345 L000111 Rep. Latham, Tom [R-IA-4] R IA 2012-04-24 0
112-hr-4345,M001159 Domestic Fuels Protection Act of 2012 112-hr-4345 M001159 Rep. McMorris Rodgers, Cathy [R-WA-5] R WA 2012-04-17 0
112-hr-4345,R000573 Domestic Fuels Protection Act of 2012 112-hr-4345 R000573 Rep. Ross, Mike [D-AR-4] D AR 2012-03-30 1
112-hr-4345,S001155 Domestic Fuels Protection Act of 2012 112-hr-4345 S001155 Rep. Sullivan, John [R-OK-1] R OK 2012-03-30 1
112-hr-4345,P000258 Domestic Fuels Protection Act of 2012 112-hr-4345 P000258 Rep. Peterson, Collin C. [D-MN-7] D MN 2012-03-30 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);