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

28 rows where bill_id = "112-hr-4128" 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

  • 1 17
  • 0 11
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hr-4128,M001149 Real Unemployment Calculation Act 112-hr-4128 M001149 Rep. Michaud, Michael H. [D-ME-2] D ME 2012-09-12 0
112-hr-4128,H001060 Real Unemployment Calculation Act 112-hr-4128 H001060 Rep. Hurt, Robert [R-VA-5] R VA 2012-05-08 0
112-hr-4128,P000592 Real Unemployment Calculation Act 112-hr-4128 P000592 Rep. Poe, Ted [R-TX-2] R TX 2012-04-27 0
112-hr-4128,R000592 Real Unemployment Calculation Act 112-hr-4128 R000592 Rep. Rokita, Todd [R-IN-4] R IN 2012-04-17 0
112-hr-4128,M001147 Real Unemployment Calculation Act 112-hr-4128 M001147 Rep. McCotter, Thaddeus G. [R-MI-11] R MI 2012-04-17 0
112-hr-4128,S001184 Real Unemployment Calculation Act 112-hr-4128 S001184 Rep. Scott, Tim [R-SC-1] R SC 2012-04-17 0
112-hr-4128,M001138 Real Unemployment Calculation Act 112-hr-4128 M001138 Rep. Manzullo, Donald A. [R-IL-16] R IL 2012-03-20 0
112-hr-4128,C001086 Real Unemployment Calculation Act 112-hr-4128 C001086 Rep. Cravaack, Chip [R-MN-8] R MN 2012-03-20 0
112-hr-4128,N000186 Real Unemployment Calculation Act 112-hr-4128 N000186 Rep. Nunnelee, Alan [R-MS-1] R MS 2012-03-07 0
112-hr-4128,H001059 Real Unemployment Calculation Act 112-hr-4128 H001059 Rep. Hultgren, Randy [R-IL-14] R IL 2012-03-05 0
112-hr-4128,E000291 Real Unemployment Calculation Act 112-hr-4128 E000291 Rep. Ellmers, Renee L. [R-NC-2] R NC 2012-03-05 0
112-hr-4128,S001188 Real Unemployment Calculation Act 112-hr-4128 S001188 Rep. Stutzman, Marlin A. [R-IN-3] R IN 2012-03-01 1
112-hr-4128,K000378 Real Unemployment Calculation Act 112-hr-4128 K000378 Rep. Kinzinger, Adam [R-IL-11] R IL 2012-03-01 1
112-hr-4128,D000612 Real Unemployment Calculation Act 112-hr-4128 D000612 Rep. Denham, Jeff [R-CA-19] R CA 2012-03-01 1
112-hr-4128,P000601 Real Unemployment Calculation Act 112-hr-4128 P000601 Rep. Palazzo, Steven M. [R-MS-4] R MS 2012-03-01 1
112-hr-4128,R000583 Real Unemployment Calculation Act 112-hr-4128 R000583 Rep. Rooney, Thomas J. [R-FL-16] R FL 2012-03-01 1
112-hr-4128,Q000024 Real Unemployment Calculation Act 112-hr-4128 Q000024 Rep. Quayle, Benjamin [R-AZ-3] R AZ 2012-03-01 1
112-hr-4128,G000558 Real Unemployment Calculation Act 112-hr-4128 G000558 Rep. Guthrie, Brett [R-KY-2] R KY 2012-03-01 1
112-hr-4128,F000448 Real Unemployment Calculation Act 112-hr-4128 F000448 Rep. Franks, Trent [R-AZ-2] R AZ 2012-03-01 1
112-hr-4128,G000569 Real Unemployment Calculation Act 112-hr-4128 G000569 Rep. Grimm, Michael G. [R-NY-13] R NY 2012-03-01 1
112-hr-4128,I000056 Real Unemployment Calculation Act 112-hr-4128 I000056 Rep. Issa, Darrell E. [R-CA-49] R CA 2012-03-01 1
112-hr-4128,P000373 Real Unemployment Calculation Act 112-hr-4128 P000373 Rep. Pitts, Joseph R. [R-PA-16] R PA 2012-03-01 1
112-hr-4128,B001256 Real Unemployment Calculation Act 112-hr-4128 B001256 Rep. Bachmann, Michele [R-MN-6] R MN 2012-03-01 1
112-hr-4128,B001243 Real Unemployment Calculation Act 112-hr-4128 B001243 Rep. Blackburn, Marsha [R-TN-7] R TN 2012-03-01 1
112-hr-4128,B001262 Real Unemployment Calculation Act 112-hr-4128 B001262 Rep. Broun, Paul C. [R-GA-10] R GA 2012-03-01 1
112-hr-4128,M001182 Real Unemployment Calculation Act 112-hr-4128 M001182 Rep. Mulvaney, Mick [R-SC-5] R SC 2012-03-01 1
112-hr-4128,W000811 Real Unemployment Calculation Act 112-hr-4128 W000811 Rep. Walsh, Joe [R-IL-8] R IL 2012-03-01 1
112-hr-4128,B000461 Real Unemployment Calculation Act 112-hr-4128 B000461 Rep. Bilbray, Brian P. [R-CA-50] R CA 2012-03-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);