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 = "113-hr-4285" 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 18
  • 1 10
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
113-hr-4285,M001160 PACE Assessment Protection Act of 2014 113-hr-4285 M001160 Rep. Moore, Gwen [D-WI-4] D WI 2014-06-09 0
113-hr-4285,L000570 PACE Assessment Protection Act of 2014 113-hr-4285 L000570 Rep. Lujan, Ben Ray [D-NM-3] D NM 2014-05-20 0
113-hr-4285,T000472 PACE Assessment Protection Act of 2014 113-hr-4285 T000472 Rep. Takano, Mark [D-CA-41] D CA 2014-05-07 0
113-hr-4285,D000197 PACE Assessment Protection Act of 2014 113-hr-4285 D000197 Rep. DeGette, Diana [D-CO-1] D CO 2014-05-01 0
113-hr-4285,H001034 PACE Assessment Protection Act of 2014 113-hr-4285 H001034 Rep. Honda, Michael M. [D-CA-17] D CA 2014-04-29 0
113-hr-4285,D000598 PACE Assessment Protection Act of 2014 113-hr-4285 D000598 Rep. Davis, Susan A. [D-CA-53] D CA 2014-04-28 0
113-hr-4285,W000215 PACE Assessment Protection Act of 2014 113-hr-4285 W000215 Rep. Waxman, Henry A. [D-CA-33] D CA 2014-04-10 0
113-hr-4285,S000030 PACE Assessment Protection Act of 2014 113-hr-4285 S000030 Rep. Sanchez, Loretta [D-CA-46] D CA 2014-04-10 0
113-hr-4285,L000579 PACE Assessment Protection Act of 2014 113-hr-4285 L000579 Rep. Lowenthal, Alan S. [D-CA-47] D CA 2014-04-10 0
113-hr-4285,H001063 PACE Assessment Protection Act of 2014 113-hr-4285 H001063 Rep. Hahn, Janice [D-CA-44] D CA 2014-04-10 0
113-hr-4285,S001175 PACE Assessment Protection Act of 2014 113-hr-4285 S001175 Rep. Speier, Jackie [D-CA-14] D CA 2014-04-10 0
113-hr-4285,L000397 PACE Assessment Protection Act of 2014 113-hr-4285 L000397 Rep. Lofgren, Zoe [D-CA-19] D CA 2014-04-10 0
113-hr-4285,C001097 PACE Assessment Protection Act of 2014 113-hr-4285 C001097 Rep. Cárdenas, Tony [D-CA-29] D CA 2014-04-03 0
113-hr-4285,N000147 PACE Assessment Protection Act of 2014 113-hr-4285 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2014-04-01 0
113-hr-4285,C001059 PACE Assessment Protection Act of 2014 113-hr-4285 C001059 Rep. Costa, Jim [D-CA-16] D CA 2014-04-01 0
113-hr-4285,E000293 PACE Assessment Protection Act of 2014 113-hr-4285 E000293 Rep. Esty, Elizabeth H. [D-CT-5] D CT 2014-04-01 0
113-hr-4285,H001068 PACE Assessment Protection Act of 2014 113-hr-4285 H001068 Rep. Huffman, Jared [D-CA-2] D CA 2014-03-27 0
113-hr-4285,P000598 PACE Assessment Protection Act of 2014 113-hr-4285 P000598 Rep. Polis, Jared [D-CO-2] D CO 2014-03-26 0
113-hr-4285,K000210 PACE Assessment Protection Act of 2014 113-hr-4285 K000210 Rep. King, Peter T. [R-NY-2] R NY 2014-03-24 1
113-hr-4285,M001185 PACE Assessment Protection Act of 2014 113-hr-4285 M001185 Rep. Maloney, Sean Patrick [D-NY-18] D NY 2014-03-24 1
113-hr-4285,C000059 PACE Assessment Protection Act of 2014 113-hr-4285 C000059 Rep. Calvert, Ken [R-CA-42] R CA 2014-03-24 1
113-hr-4285,M001163 PACE Assessment Protection Act of 2014 113-hr-4285 M001163 Rep. Matsui, Doris O. [D-CA-6] D CA 2014-03-24 1
113-hr-4285,E000215 PACE Assessment Protection Act of 2014 113-hr-4285 E000215 Rep. Eshoo, Anna G. [D-CA-18] D CA 2014-03-24 1
113-hr-4285,M000725 PACE Assessment Protection Act of 2014 113-hr-4285 M000725 Rep. Miller, George [D-CA-11] D CA 2014-03-24 1
113-hr-4285,S001150 PACE Assessment Protection Act of 2014 113-hr-4285 S001150 Rep. Schiff, Adam B. [D-CA-28] D CA 2014-03-24 1
113-hr-4285,M001166 PACE Assessment Protection Act of 2014 113-hr-4285 M001166 Rep. McNerney, Jerry [D-CA-9] D CA 2014-03-24 1
113-hr-4285,F000451 PACE Assessment Protection Act of 2014 113-hr-4285 F000451 Rep. Fitzpatrick, Michael G. [R-PA-8] R PA 2014-03-24 1
113-hr-4285,G000559 PACE Assessment Protection Act of 2014 113-hr-4285 G000559 Rep. Garamendi, John [D-CA-3] D CA 2014-03-24 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);