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

38 rows where bill_id = "112-hr-15" 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 26
  • 0 12
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hr-15,G000553 Middle Class Tax Cut Act 112-hr-15 G000553 Rep. Green, Al [D-TX-9] D TX 2012-12-12 0
112-hr-15,D000355 Middle Class Tax Cut Act 112-hr-15 D000355 Rep. Dingell, John D. [D-MI-15] D MI 2012-07-31 0
112-hr-15,M000312 Middle Class Tax Cut Act 112-hr-15 M000312 Rep. McGovern, James P. [D-MA-3] D MA 2012-07-31 0
112-hr-15,M000133 Middle Class Tax Cut Act 112-hr-15 M000133 Rep. Markey, Edward J. [D-MA-7] D MA 2012-07-31 0
112-hr-15,W000215 Middle Class Tax Cut Act 112-hr-15 W000215 Rep. Waxman, Henry A. [D-CA-30] D CA 2012-07-31 0
112-hr-15,R000486 Middle Class Tax Cut Act 112-hr-15 R000486 Rep. Roybal-Allard, Lucille [D-CA-34] D CA 2012-07-31 0
112-hr-15,H001032 Middle Class Tax Cut Act 112-hr-15 H001032 Rep. Holt, Rush [D-NJ-12] D NJ 2012-07-31 0
112-hr-15,L000560 Middle Class Tax Cut Act 112-hr-15 L000560 Rep. Larsen, Rick [D-WA-2] D WA 2012-07-31 0
112-hr-15,C001066 Middle Class Tax Cut Act 112-hr-15 C001066 Rep. Castor, Kathy [D-FL-11] D FL 2012-07-31 0
112-hr-15,G000551 Middle Class Tax Cut Act 112-hr-15 G000551 Rep. Grijalva, Raúl M. [D-AZ-7] D AZ 2012-07-31 0
112-hr-15,M001143 Middle Class Tax Cut Act 112-hr-15 M001143 Rep. McCollum, Betty [D-MN-4] D MN 2012-07-31 0
112-hr-15,D000216 Middle Class Tax Cut Act 112-hr-15 D000216 Rep. DeLauro, Rosa L. [D-CT-3] D CT 2012-07-31 0
112-hr-15,P000197 Middle Class Tax Cut Act 112-hr-15 P000197 Rep. Pelosi, Nancy [D-CA-8] D CA 2012-07-30 1
112-hr-15,H000874 Middle Class Tax Cut Act 112-hr-15 H000874 Rep. Hoyer, Steny H. [D-MD-5] D MD 2012-07-30 1
112-hr-15,C000537 Middle Class Tax Cut Act 112-hr-15 C000537 Rep. Clyburn, James E. [D-SC-6] D SC 2012-07-30 1
112-hr-15,R000053 Middle Class Tax Cut Act 112-hr-15 R000053 Rep. Rangel, Charles B. [D-NY-15] D NY 2012-07-30 1
112-hr-15,M000404 Middle Class Tax Cut Act 112-hr-15 M000404 Rep. McDermott, Jim [D-WA-7] D WA 2012-07-30 1
112-hr-15,L000287 Middle Class Tax Cut Act 112-hr-15 L000287 Rep. Lewis, John [D-GA-5] D GA 2012-07-30 1
112-hr-15,N000015 Middle Class Tax Cut Act 112-hr-15 N000015 Rep. Neal, Richard E. [D-MA-2] D MA 2012-07-30 1
112-hr-15,L000557 Middle Class Tax Cut Act 112-hr-15 L000557 Rep. Larson, John B. [D-CT-1] D CT 2012-07-30 1
112-hr-15,B000574 Middle Class Tax Cut Act 112-hr-15 B000574 Rep. Blumenauer, Earl [D-OR-3] D OR 2012-07-30 1
112-hr-15,P000096 Middle Class Tax Cut Act 112-hr-15 P000096 Rep. Pascrell, Bill, Jr. [D-NJ-8] D NJ 2012-07-30 1
112-hr-15,C001038 Middle Class Tax Cut Act 112-hr-15 C001038 Rep. Crowley, Joseph [D-NY-7] D NY 2012-07-30 1
112-hr-15,V000128 Middle Class Tax Cut Act 112-hr-15 V000128 Rep. Van Hollen, Chris [D-MD-8] D MD 2012-07-30 1
112-hr-15,D000327 Middle Class Tax Cut Act 112-hr-15 D000327 Rep. Dicks, Norman D. [D-WA-6] D WA 2012-07-30 1
112-hr-15,C001080 Middle Class Tax Cut Act 112-hr-15 C001080 Rep. Chu, Judy [D-CA-32] D CA 2012-07-30 1
112-hr-15,H001034 Middle Class Tax Cut Act 112-hr-15 H001034 Rep. Honda, Michael M. [D-CA-15] D CA 2012-07-30 1
112-hr-15,T000469 Middle Class Tax Cut Act 112-hr-15 T000469 Rep. Tonko, Paul [D-NY-21] D NY 2012-07-30 1
112-hr-15,H001063 Middle Class Tax Cut Act 112-hr-15 H001063 Rep. Hahn, Janice [D-CA-36] D CA 2012-07-30 1
112-hr-15,M000725 Middle Class Tax Cut Act 112-hr-15 M000725 Rep. Miller, George [D-CA-7] D CA 2012-07-30 1
112-hr-15,W000800 Middle Class Tax Cut Act 112-hr-15 W000800 Rep. Welch, Peter [D-VT-At Large] D VT 2012-07-30 1
112-hr-15,R000588 Middle Class Tax Cut Act 112-hr-15 R000588 Rep. Richmond, Cedric L. [D-LA-2] D LA 2012-07-30 1
112-hr-15,C001084 Middle Class Tax Cut Act 112-hr-15 C001084 Rep. Cicilline, David N. [D-RI-1] D RI 2012-07-30 1
112-hr-15,S001145 Middle Class Tax Cut Act 112-hr-15 S001145 Rep. Schakowsky, Janice D. [D-IL-9] D IL 2012-07-30 1
112-hr-15,J000126 Middle Class Tax Cut Act 112-hr-15 J000126 Rep. Johnson, Eddie Bernice [D-TX-30] D TX 2012-07-30 1
112-hr-15,S000248 Middle Class Tax Cut Act 112-hr-15 S000248 Rep. Serrano, Jose E. [D-NY-16] D NY 2012-07-30 1
112-hr-15,C001036 Middle Class Tax Cut Act 112-hr-15 C001036 Rep. Capps, Lois [D-CA-23] D CA 2012-07-30 1
112-hr-15,P000597 Middle Class Tax Cut Act 112-hr-15 P000597 Rep. Pingree, Chellie [D-ME-1] D ME 2012-07-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);