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

42 rows where bill_id = "112-hr-3173" 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 37
  • 1 5
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hr-3173,R000589 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 R000589 Rep. Rigell, E. Scott [R-VA-2] R VA 2012-06-06 0
112-hr-3173,P000601 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 P000601 Rep. Palazzo, Steven M. [R-MS-4] R MS 2012-06-06 0
112-hr-3173,M000404 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 M000404 Rep. McDermott, Jim [D-WA-7] D WA 2012-06-01 0
112-hr-3173,S001180 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 S001180 Rep. Schrader, Kurt [D-OR-5] D OR 2012-05-18 0
112-hr-3173,S001165 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 S001165 Rep. Sires, Albio [D-NJ-13] D NJ 2012-05-17 0
112-hr-3173,L000554 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 L000554 Rep. LoBiondo, Frank A. [R-NJ-2] R NJ 2012-05-17 0
112-hr-3173,G000570 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 G000570 Rep. Guinta, Frank C. [R-NH-1] R NH 2012-05-17 0
112-hr-3173,H001038 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 H001038 Rep. Higgins, Brian [D-NY-27] D NY 2012-05-16 0
112-hr-3173,S000030 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 S000030 Rep. Sanchez, Loretta [D-CA-47] D CA 2012-05-16 0
112-hr-3173,H001045 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 H001045 Rep. Harper, Gregg [R-MS-3] R MS 2012-05-15 0
112-hr-3173,H001050 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 H001050 Rep. Hanabusa, Colleen W. [D-HI-1] D HI 2012-05-15 0
112-hr-3173,C001060 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 C001060 Rep. Carnahan, Russ [D-MO-3] D MO 2012-05-15 0
112-hr-3173,H001042 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 H001042 Rep. Hirono, Mazie K. [D-HI-2] D HI 2012-05-09 0
112-hr-3173,J000255 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2012-05-07 0
112-hr-3173,L000553 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 L000553 Rep. LaTourette, Steven C. [R-OH-14] R OH 2012-05-07 0
112-hr-3173,M001149 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 M001149 Rep. Michaud, Michael H. [D-ME-2] D ME 2012-05-07 0
112-hr-3173,M001157 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 M001157 Rep. McCaul, Michael T. [R-TX-10] R TX 2012-05-07 0
112-hr-3173,N000186 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 N000186 Rep. Nunnelee, Alan [R-MS-1] R MS 2012-05-07 0
112-hr-3173,W000804 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 W000804 Rep. Wittman, Robert J. [R-VA-1] R VA 2012-04-26 0
112-hr-3173,D000191 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 D000191 Rep. DeFazio, Peter A. [D-OR-4] D OR 2012-04-26 0
112-hr-3173,K000378 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 K000378 Rep. Kinzinger, Adam [R-IL-11] R IL 2012-04-25 0
112-hr-3173,J000292 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 J000292 Rep. Johnson, Bill [R-OH-6] R OH 2012-04-25 0
112-hr-3173,M001143 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 M001143 Rep. McCollum, Betty [D-MN-4] D MN 2012-04-24 0
112-hr-3173,R000011 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 R000011 Rep. Rahall, Nick J., II [D-WV-3] D WV 2012-04-24 0
112-hr-3173,H001051 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 H001051 Rep. Hanna, Richard L. [R-NY-24] R NY 2012-04-24 0
112-hr-3173,R000581 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 R000581 Rep. Richardson, Laura [D-CA-37] D CA 2012-04-24 0
112-hr-3173,H001052 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 H001052 Rep. Harris, Andy [R-MD-1] R MD 2012-04-24 0
112-hr-3173,G000546 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 G000546 Rep. Graves, Sam [R-MO-6] R MO 2012-04-24 0
112-hr-3173,L000560 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 L000560 Rep. Larsen, Rick [D-WA-2] D WA 2012-04-24 0
112-hr-3173,C001068 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 C001068 Rep. Cohen, Steve [D-TN-9] D TN 2012-04-17 0
112-hr-3173,R000576 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 R000576 Rep. Ruppersberger, C. A. Dutch [D-MD-2] D MD 2012-03-28 0
112-hr-3173,B001232 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 B001232 Rep. Biggert, Judy [R-IL-13] R IL 2012-02-28 0
112-hr-3173,G000569 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 G000569 Rep. Grimm, Michael G. [R-NY-13] R NY 2012-02-28 0
112-hr-3173,G000410 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 G000410 Rep. Green, Gene [D-TX-29] D TX 2012-02-28 0
112-hr-3173,H001063 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 H001063 Rep. Hahn, Janice [D-CA-36] D CA 2012-02-07 0
112-hr-3173,Y000064 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 Y000064 Rep. Young, Todd [R-IN-9] R IN 2012-02-07 0
112-hr-3173,L000569 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 L000569 Rep. Luetkemeyer, Blaine [R-MO-9] R MO 2011-12-07 0
112-hr-3173,Y000033 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 Y000033 Rep. Young, Don [R-AK-At Large] R AK 2011-10-12 1
112-hr-3173,K000210 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 K000210 Rep. King, Peter T. [R-NY-3] R NY 2011-10-12 1
112-hr-3173,T000193 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 T000193 Rep. Thompson, Bennie G. [D-MS-2] D MS 2011-10-12 1
112-hr-3173,C000984 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 C000984 Rep. Cummings, Elijah E. [D-MD-7] D MD 2011-10-12 1
112-hr-3173,R000588 To direct the Secretary of Homeland Security to reform the process for the enrollment, activation, issuance, and renewal of a Transportation Worker Identification Credential (TWIC) to require, in total, not more than one in-person visit to a designated enrollment center. 112-hr-3173 R000588 Rep. Richmond, Cedric L. [D-LA-2] D LA 2011-10-12 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);