home / openregs

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-5864" 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 22
  • 1 9
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hr-5864,T000460 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 T000460 Rep. Thompson, Mike [D-CA-1] D CA 2012-10-05 0
112-hr-5864,P000597 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 P000597 Rep. Pingree, Chellie [D-ME-1] D ME 2012-09-12 0
112-hr-5864,S000810 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 S000810 Rep. Stark, Fortney Pete [D-CA-13] D CA 2012-09-12 0
112-hr-5864,M001166 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 M001166 Rep. McNerney, Jerry [D-CA-11] D CA 2012-08-02 0
112-hr-5864,H001062 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 H001062 Rep. Hochul, Kathleen C. [D-NY-26] D NY 2012-08-02 0
112-hr-5864,B000574 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 B000574 Rep. Blumenauer, Earl [D-OR-3] D OR 2012-08-01 0
112-hr-5864,L000551 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 L000551 Rep. Lee, Barbara [D-CA-9] D CA 2012-07-31 0
112-hr-5864,H001042 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 H001042 Rep. Hirono, Mazie K. [D-HI-2] D HI 2012-07-26 0
112-hr-5864,K000009 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 2012-07-24 0
112-hr-5864,C001085 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 C001085 Rep. Clarke, Hansen [D-MI-13] D MI 2012-07-24 0
112-hr-5864,S001174 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 S001174 Rep. Sutton, Betty [D-OH-13] D OH 2012-07-17 0
112-hr-5864,P000595 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 P000595 Rep. Peters, Gary C. [D-MI-9] D MI 2012-07-10 0
112-hr-5864,F000116 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 F000116 Rep. Filner, Bob [D-CA-51] D CA 2012-06-27 0
112-hr-5864,L000263 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 L000263 Rep. Levin, Sander M. [D-MI-12] D MI 2012-06-21 0
112-hr-5864,O000169 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 O000169 Rep. Owens, William L. [D-NY-23] D NY 2012-06-19 0
112-hr-5864,R000577 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 R000577 Rep. Ryan, Tim [D-OH-17] D OH 2012-06-19 0
112-hr-5864,H001038 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 H001038 Rep. Higgins, Brian [D-NY-27] D NY 2012-06-19 0
112-hr-5864,L000553 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 L000553 Rep. LaTourette, Steven C. [R-OH-14] R OH 2012-06-07 0
112-hr-5864,H000324 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 H000324 Rep. Hastings, Alcee L. [D-FL-23] D FL 2012-06-07 0
112-hr-5864,C001036 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 C001036 Rep. Capps, Lois [D-CA-23] D CA 2012-06-07 0
112-hr-5864,D000355 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 D000355 Rep. Dingell, John D. [D-MI-15] D MI 2012-06-01 0
112-hr-5864,E000288 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 E000288 Rep. Ellison, Keith [D-MN-5] D MN 2012-05-31 0
112-hr-5864,R000053 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 R000053 Rep. Rangel, Charles B. [D-NY-15] D NY 2012-05-30 1
112-hr-5864,R000572 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 R000572 Rep. Rogers, Mike J. [R-MI-8] R MI 2012-05-30 1
112-hr-5864,K000336 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 K000336 Rep. Kucinich, Dennis J. [D-OH-10] D OH 2012-05-30 1
112-hr-5864,B001245 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 B001245 Del. Bordallo, Madeleine Z. [D-GU-At Large] D GU 2012-05-30 1
112-hr-5864,H000627 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 H000627 Rep. Hinchey, Maurice D. [D-NY-22] D NY 2012-05-30 1
112-hr-5864,F000030 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 F000030 Rep. Farr, Sam [D-CA-17] D CA 2012-05-30 1
112-hr-5864,M000087 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 M000087 Rep. Maloney, Carolyn B. [D-NY-14] D NY 2012-05-30 1
112-hr-5864,K000172 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 K000172 Rep. Kildee, Dale E. [D-MI-5] D MI 2012-05-30 1
112-hr-5864,G000551 Invasive Fish and Wildlife Prevention Act of 2012 112-hr-5864 G000551 Rep. Grijalva, Raúl M. [D-AZ-7] D AZ 2012-05-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);
Powered by Datasette · Queries took 18.375ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API