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

31 rows where bill_id = "112-hr-5741" 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 29
  • 1 2
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hr-5741,W000808 JOLT Act of 2012 112-hr-5741 W000808 Rep. Wilson, Frederica S. [D-FL-17] D FL 2012-12-31 0
112-hr-5741,W000800 JOLT Act of 2012 112-hr-5741 W000800 Rep. Welch, Peter [D-VT-At Large] D VT 2012-12-11 0
112-hr-5741,N000015 JOLT Act of 2012 112-hr-5741 N000015 Rep. Neal, Richard E. [D-MA-2] D MA 2012-11-29 0
112-hr-5741,S000510 JOLT Act of 2012 112-hr-5741 S000510 Rep. Smith, Adam [D-WA-9] D WA 2012-11-14 0
112-hr-5741,C001058 JOLT Act of 2012 112-hr-5741 C001058 Rep. Chandler, Ben [D-KY-6] D KY 2012-09-21 0
112-hr-5741,K000009 JOLT Act of 2012 112-hr-5741 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 2012-09-13 0
112-hr-5741,G000567 JOLT Act of 2012 112-hr-5741 G000567 Rep. Griffin, Tim [R-AR-2] R AR 2012-09-13 0
112-hr-5741,F000030 JOLT Act of 2012 112-hr-5741 F000030 Rep. Farr, Sam [D-CA-17] D CA 2012-08-01 0
112-hr-5741,R000589 JOLT Act of 2012 112-hr-5741 R000589 Rep. Rigell, E. Scott [R-VA-2] R VA 2012-07-25 0
112-hr-5741,B001228 JOLT Act of 2012 112-hr-5741 B001228 Rep. Bono Mack, Mary [R-CA-45] R CA 2012-07-25 0
112-hr-5741,L000569 JOLT Act of 2012 112-hr-5741 L000569 Rep. Luetkemeyer, Blaine [R-MO-9] R MO 2012-07-24 0
112-hr-5741,S000364 JOLT Act of 2012 112-hr-5741 S000364 Rep. Shimkus, John [R-IL-19] R IL 2012-07-19 0
112-hr-5741,K000378 JOLT Act of 2012 112-hr-5741 K000378 Rep. Kinzinger, Adam [R-IL-11] R IL 2012-07-19 0
112-hr-5741,C001084 JOLT Act of 2012 112-hr-5741 C001084 Rep. Cicilline, David N. [D-RI-1] D RI 2012-07-17 0
112-hr-5741,S001179 JOLT Act of 2012 112-hr-5741 S001179 Rep. Schock, Aaron [R-IL-18] R IL 2012-07-17 0
112-hr-5741,S001150 JOLT Act of 2012 112-hr-5741 S001150 Rep. Schiff, Adam B. [D-CA-29] D CA 2012-07-12 0
112-hr-5741,M001169 JOLT Act of 2012 112-hr-5741 M001169 Rep. Murphy, Christopher [D-CT-5] D CT 2012-07-12 0
112-hr-5741,C001053 JOLT Act of 2012 112-hr-5741 C001053 Rep. Cole, Tom [R-OK-4] R OK 2012-07-10 0
112-hr-5741,R000590 JOLT Act of 2012 112-hr-5741 R000590 Rep. Rivera, David [R-FL-25] R FL 2012-07-10 0
112-hr-5741,H001051 JOLT Act of 2012 112-hr-5741 H001051 Rep. Hanna, Richard L. [R-NY-24] R NY 2012-06-27 0
112-hr-5741,M001137 JOLT Act of 2012 112-hr-5741 M001137 Rep. Meeks, Gregory W. [D-NY-6] D NY 2012-06-19 0
112-hr-5741,A000369 JOLT Act of 2012 112-hr-5741 A000369 Rep. Amodei, Mark E. [R-NV-2] R NV 2012-06-06 0
112-hr-5741,P000595 JOLT Act of 2012 112-hr-5741 P000595 Rep. Peters, Gary C. [D-MI-9] D MI 2012-06-05 0
112-hr-5741,H001050 JOLT Act of 2012 112-hr-5741 H001050 Rep. Hanabusa, Colleen W. [D-HI-1] D HI 2012-05-30 0
112-hr-5741,H001042 JOLT Act of 2012 112-hr-5741 H001042 Rep. Hirono, Mazie K. [D-HI-2] D HI 2012-05-30 0
112-hr-5741,N000147 JOLT Act of 2012 112-hr-5741 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2012-05-30 0
112-hr-5741,G000569 JOLT Act of 2012 112-hr-5741 G000569 Rep. Grimm, Michael G. [R-NY-13] R NY 2012-05-18 0
112-hr-5741,B001231 JOLT Act of 2012 112-hr-5741 B001231 Rep. Berkley, Shelley [D-NV-1] D NV 2012-05-16 0
112-hr-5741,V000128 JOLT Act of 2012 112-hr-5741 V000128 Rep. Van Hollen, Chris [D-MD-8] D MD 2012-05-16 0
112-hr-5741,Q000023 JOLT Act of 2012 112-hr-5741 Q000023 Rep. Quigley, Mike [D-IL-5] D IL 2012-05-15 1
112-hr-5741,C000266 JOLT Act of 2012 112-hr-5741 C000266 Rep. Chabot, Steve [R-OH-1] R OH 2012-05-15 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);