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

27 rows where bill_id = "115-s-2971" 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 26
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
115-s-2971,B000944 PACE Act 115-s-2971 B000944 Sen. Brown, Sherrod [D-OH] D OH 2018-12-13 0
115-s-2971,D000563 PACE Act 115-s-2971 D000563 Sen. Durbin, Richard J. [D-IL] D IL 2018-12-04 0
115-s-2971,B001230 PACE Act 115-s-2971 B001230 Sen. Baldwin, Tammy [D-WI] D WI 2018-10-11 0
115-s-2971,M001111 PACE Act 115-s-2971 M001111 Sen. Murray, Patty [D-WA] D WA 2018-10-10 0
115-s-2971,S000033 PACE Act 115-s-2971 S000033 Sen. Sanders, Bernard [I-VT] I VT 2018-10-05 0
115-s-2971,W000817 PACE Act 115-s-2971 W000817 Sen. Warren, Elizabeth [D-MA] D MA 2018-10-04 0
115-s-2971,G000555 PACE Act 115-s-2971 G000555 Sen. Gillibrand, Kirsten E. [D-NY] D NY 2018-10-04 0
115-s-2971,F000062 PACE Act 115-s-2971 F000062 Sen. Feinstein, Dianne [D-CA] D CA 2018-10-02 0
115-s-2971,M001176 PACE Act 115-s-2971 M001176 Sen. Merkley, Jeff [D-OR] D OR 2018-10-02 0
115-s-2971,C001088 PACE Act 115-s-2971 C001088 Sen. Coons, Christopher A. [D-DE] D DE 2018-10-02 0
115-s-2971,M000133 PACE Act 115-s-2971 M000133 Sen. Markey, Edward J. [D-MA] D MA 2018-10-02 0
115-s-2971,U000039 PACE Act 115-s-2971 U000039 Sen. Udall, Tom [D-NM] D NM 2018-10-01 0
115-s-2971,S001181 PACE Act 115-s-2971 S001181 Sen. Shaheen, Jeanne [D-NH] D NH 2018-09-28 0
115-s-2971,C000127 PACE Act 115-s-2971 C000127 Sen. Cantwell, Maria [D-WA] D WA 2018-09-26 0
115-s-2971,R000122 PACE Act 115-s-2971 R000122 Sen. Reed, Jack [D-RI] D RI 2018-09-26 0
115-s-2971,D000622 PACE Act 115-s-2971 D000622 Sen. Duckworth, Tammy [D-IL] D IL 2018-09-25 0
115-s-2971,H001076 PACE Act 115-s-2971 H001076 Sen. Hassan, Margaret Wood [D-NH] D NH 2018-09-24 0
115-s-2971,H001075 PACE Act 115-s-2971 H001075 Sen. Harris, Kamala D. [D-CA] D CA 2018-09-24 0
115-s-2971,M001169 PACE Act 115-s-2971 M001169 Sen. Murphy, Christopher [D-CT] D CT 2018-09-18 0
115-s-2971,C001035 PACE Act 115-s-2971 C001035 Sen. Collins, Susan M. [R-ME] R ME 2018-09-17 0
115-s-2971,C000174 PACE Act 115-s-2971 C000174 Sen. Carper, Thomas R. [D-DE] D DE 2018-09-17 0
115-s-2971,V000128 PACE Act 115-s-2971 V000128 Sen. Van Hollen, Chris [D-MD] D MD 2018-09-17 0
115-s-2971,J000300 PACE Act 115-s-2971 J000300 Sen. Jones, Doug [D-AL] D AL 2018-09-12 0
115-s-2971,C001113 PACE Act 115-s-2971 C001113 Sen. Cortez Masto, Catherine [D-NV] D NV 2018-06-27 0
115-s-2971,P000595 PACE Act 115-s-2971 P000595 Sen. Peters, Gary C. [D-MI] D MI 2018-06-19 0
115-s-2971,W000779 PACE Act 115-s-2971 W000779 Sen. Wyden, Ron [D-OR] D OR 2018-06-19 0
115-s-2971,B001277 PACE Act 115-s-2971 B001277 Sen. Blumenthal, Richard [D-CT] D CT 2018-05-24 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);