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

39 rows where bill_id = "112-hr-1684" 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 30
  • 0 9
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hr-1684,C001084 Keep American Jobs from Going Down the Drain Act 112-hr-1684 C001084 Rep. Cicilline, David N. [D-RI-1] D RI 2012-09-11 0
112-hr-1684,H001038 Keep American Jobs from Going Down the Drain Act 112-hr-1684 H001038 Rep. Higgins, Brian [D-NY-27] D NY 2012-04-26 0
112-hr-1684,B001227 Keep American Jobs from Going Down the Drain Act 112-hr-1684 B001227 Rep. Brady, Robert A. [D-PA-1] D PA 2012-02-16 0
112-hr-1684,T000193 Keep American Jobs from Going Down the Drain Act 112-hr-1684 T000193 Rep. Thompson, Bennie G. [D-MS-2] D MS 2012-01-23 0
112-hr-1684,L000551 Keep American Jobs from Going Down the Drain Act 112-hr-1684 L000551 Rep. Lee, Barbara [D-CA-9] D CA 2011-11-14 0
112-hr-1684,N000179 Keep American Jobs from Going Down the Drain Act 112-hr-1684 N000179 Rep. Napolitano, Grace F. [D-CA-38] D CA 2011-09-08 0
112-hr-1684,V000108 Keep American Jobs from Going Down the Drain Act 112-hr-1684 V000108 Rep. Visclosky, Peter J. [D-IN-1] D IN 2011-07-21 0
112-hr-1684,R000011 Keep American Jobs from Going Down the Drain Act 112-hr-1684 R000011 Rep. Rahall, Nick J., II [D-WV-3] D WV 2011-07-21 0
112-hr-1684,C001085 Keep American Jobs from Going Down the Drain Act 112-hr-1684 C001085 Rep. Clarke, Hansen [D-MI-13] D MI 2011-05-11 0
112-hr-1684,M001180 Keep American Jobs from Going Down the Drain Act 112-hr-1684 M001180 Rep. McKinley, David B. [R-WV-1] R WV 2011-05-03 1
112-hr-1684,L000563 Keep American Jobs from Going Down the Drain Act 112-hr-1684 L000563 Rep. Lipinski, Daniel [D-IL-3] D IL 2011-05-03 1
112-hr-1684,B001242 Keep American Jobs from Going Down the Drain Act 112-hr-1684 B001242 Rep. Bishop, Timothy H. [D-NY-1] D NY 2011-05-03 1
112-hr-1684,J000255 Keep American Jobs from Going Down the Drain Act 112-hr-1684 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2011-05-03 1
112-hr-1684,B001259 Keep American Jobs from Going Down the Drain Act 112-hr-1684 B001259 Rep. Braley, Bruce L. [D-IA-1] D IA 2011-05-03 1
112-hr-1684,D000191 Keep American Jobs from Going Down the Drain Act 112-hr-1684 D000191 Rep. DeFazio, Peter A. [D-OR-4] D OR 2011-05-03 1
112-hr-1684,M001149 Keep American Jobs from Going Down the Drain Act 112-hr-1684 M001149 Rep. Michaud, Michael H. [D-ME-2] D ME 2011-05-03 1
112-hr-1684,D000216 Keep American Jobs from Going Down the Drain Act 112-hr-1684 D000216 Rep. DeLauro, Rosa L. [D-CT-3] D CT 2011-05-03 1
112-hr-1684,S001168 Keep American Jobs from Going Down the Drain Act 112-hr-1684 S001168 Rep. Sarbanes, John P. [D-MD-3] D MD 2011-05-03 1
112-hr-1684,C001068 Keep American Jobs from Going Down the Drain Act 112-hr-1684 C001068 Rep. Cohen, Steve [D-TN-9] D TN 2011-05-03 1
112-hr-1684,Y000062 Keep American Jobs from Going Down the Drain Act 112-hr-1684 Y000062 Rep. Yarmuth, John A. [D-KY-3] D KY 2011-05-03 1
112-hr-1684,M000725 Keep American Jobs from Going Down the Drain Act 112-hr-1684 M000725 Rep. Miller, George [D-CA-7] D CA 2011-05-03 1
112-hr-1684,L000562 Keep American Jobs from Going Down the Drain Act 112-hr-1684 L000562 Rep. Lynch, Stephen F. [D-MA-9] D MA 2011-05-03 1
112-hr-1684,K000009 Keep American Jobs from Going Down the Drain Act 112-hr-1684 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 2011-05-03 1
112-hr-1684,G000410 Keep American Jobs from Going Down the Drain Act 112-hr-1684 G000410 Rep. Green, Gene [D-TX-29] D TX 2011-05-03 1
112-hr-1684,S001156 Keep American Jobs from Going Down the Drain Act 112-hr-1684 S001156 Rep. Sánchez, Linda T. [D-CA-39] D CA 2011-05-03 1
112-hr-1684,H001042 Keep American Jobs from Going Down the Drain Act 112-hr-1684 H001042 Rep. Hirono, Mazie K. [D-HI-2] D HI 2011-05-03 1
112-hr-1684,M001169 Keep American Jobs from Going Down the Drain Act 112-hr-1684 M001169 Rep. Murphy, Christopher [D-CT-5] D CT 2011-05-03 1
112-hr-1684,O000085 Keep American Jobs from Going Down the Drain Act 112-hr-1684 O000085 Rep. Olver, John W. [D-MA-1] D MA 2011-05-03 1
112-hr-1684,A000210 Keep American Jobs from Going Down the Drain Act 112-hr-1684 A000210 Rep. Andrews, Robert E. [D-NJ-1] D NJ 2011-05-03 1
112-hr-1684,E000290 Keep American Jobs from Going Down the Drain Act 112-hr-1684 E000290 Rep. Edwards, Donna F. [D-MD-4] D MD 2011-05-03 1
112-hr-1684,L000287 Keep American Jobs from Going Down the Drain Act 112-hr-1684 L000287 Rep. Lewis, John [D-GA-5] D GA 2011-05-03 1
112-hr-1684,T000469 Keep American Jobs from Going Down the Drain Act 112-hr-1684 T000469 Rep. Tonko, Paul [D-NY-21] D NY 2011-05-03 1
112-hr-1684,C001069 Keep American Jobs from Going Down the Drain Act 112-hr-1684 C001069 Rep. Courtney, Joe [D-CT-2] D CT 2011-05-03 1
112-hr-1684,D000355 Keep American Jobs from Going Down the Drain Act 112-hr-1684 D000355 Rep. Dingell, John D. [D-MI-15] D MI 2011-05-03 1
112-hr-1684,F000116 Keep American Jobs from Going Down the Drain Act 112-hr-1684 F000116 Rep. Filner, Bob [D-CA-51] D CA 2011-05-03 1
112-hr-1684,G000559 Keep American Jobs from Going Down the Drain Act 112-hr-1684 G000559 Rep. Garamendi, John [D-CA-10] D CA 2011-05-03 1
112-hr-1684,D000482 Keep American Jobs from Going Down the Drain Act 112-hr-1684 D000482 Rep. Doyle, Michael F. [D-PA-14] D PA 2011-05-03 1
112-hr-1684,S001145 Keep American Jobs from Going Down the Drain Act 112-hr-1684 S001145 Rep. Schakowsky, Janice D. [D-IL-9] D IL 2011-05-03 1
112-hr-1684,P000597 Keep American Jobs from Going Down the Drain Act 112-hr-1684 P000597 Rep. Pingree, Chellie [D-ME-1] D ME 2011-05-03 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);