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

20 rows where bill_id = "112-hr-4154" 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 16
  • 1 4
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hr-4154,K000369 SAVE Native Women Act 112-hr-4154 K000369 Rep. Kissell, Larry [D-NC-8] D NC 2012-07-18 0
112-hr-4154,M000933 SAVE Native Women Act 112-hr-4154 M000933 Rep. Moran, James P. [D-VA-8] D VA 2012-06-29 0
112-hr-4154,F000116 SAVE Native Women Act 112-hr-4154 F000116 Rep. Filner, Bob [D-CA-51] D CA 2012-06-29 0
112-hr-4154,W000738 SAVE Native Women Act 112-hr-4154 W000738 Rep. Woolsey, Lynn C. [D-CA-6] D CA 2012-06-26 0
112-hr-4154,K000375 SAVE Native Women Act 112-hr-4154 K000375 Rep. Keating, William R. [D-MA-10] D MA 2012-06-26 0
112-hr-4154,C001085 SAVE Native Women Act 112-hr-4154 C001085 Rep. Clarke, Hansen [D-MI-13] D MI 2012-06-26 0
112-hr-4154,M001156 SAVE Native Women Act 112-hr-4154 M001156 Rep. McHenry, Patrick T. [R-NC-10] R NC 2012-05-18 0
112-hr-4154,D000482 SAVE Native Women Act 112-hr-4154 D000482 Rep. Doyle, Michael F. [D-PA-14] D PA 2012-05-17 0
112-hr-4154,L000560 SAVE Native Women Act 112-hr-4154 L000560 Rep. Larsen, Rick [D-WA-2] D WA 2012-05-17 0
112-hr-4154,R000585 SAVE Native Women Act 112-hr-4154 R000585 Rep. Reed, Tom [R-NY-29] R NY 2012-05-17 0
112-hr-4154,N000147 SAVE Native Women Act 112-hr-4154 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2012-05-07 0
112-hr-4154,W000800 SAVE Native Women Act 112-hr-4154 W000800 Rep. Welch, Peter [D-VT-At Large] D VT 2012-04-25 0
112-hr-4154,S001148 SAVE Native Women Act 112-hr-4154 S001148 Rep. Simpson, Michael K. [R-ID-2] R ID 2012-04-19 0
112-hr-4154,G000551 SAVE Native Women Act 112-hr-4154 G000551 Rep. Grijalva, Raúl M. [D-AZ-7] D AZ 2012-03-27 0
112-hr-4154,M001160 SAVE Native Women Act 112-hr-4154 M001160 Rep. Moore, Gwen [D-WI-4] D WI 2012-03-19 0
112-hr-4154,T000460 SAVE Native Women Act 112-hr-4154 T000460 Rep. Thompson, Mike [D-CA-1] D CA 2012-03-13 0
112-hr-4154,C001053 SAVE Native Women Act 112-hr-4154 C001053 Rep. Cole, Tom [R-OK-4] R OK 2012-03-07 1
112-hr-4154,M001143 SAVE Native Women Act 112-hr-4154 M001143 Rep. McCollum, Betty [D-MN-4] D MN 2012-03-07 1
112-hr-4154,I000026 SAVE Native Women Act 112-hr-4154 I000026 Rep. Inslee, Jay [D-WA-1] D WA 2012-03-07 1
112-hr-4154,K000172 SAVE Native Women Act 112-hr-4154 K000172 Rep. Kildee, Dale E. [D-MI-5] D MI 2012-03-07 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);