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

18 rows where bill_id = "113-hr-4716" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 0 11
  • 1 7
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
113-hr-4716,C001077 Sage Grouse Protection and Conservation Act 113-hr-4716 C001077 Rep. Coffman, Mike [R-CO-6] R CO 2014-09-10 0
113-hr-4716,L000573 Sage Grouse Protection and Conservation Act 113-hr-4716 L000573 Rep. Labrador, Raul R. [R-ID-1] R ID 2014-07-24 0
113-hr-4716,W000791 Sage Grouse Protection and Conservation Act 113-hr-4716 W000791 Rep. Walden, Greg [R-OR-2] R OR 2014-07-16 0
113-hr-4716,M001177 Sage Grouse Protection and Conservation Act 113-hr-4716 M001177 Rep. McClintock, Tom [R-CA-4] R CA 2014-07-16 0
113-hr-4716,B001243 Sage Grouse Protection and Conservation Act 113-hr-4716 B001243 Rep. Blackburn, Marsha [R-TN-7] R TN 2014-07-16 0
113-hr-4716,R000582 Sage Grouse Protection and Conservation Act 113-hr-4716 R000582 Rep. Roe, David P. [R-TN-1] R TN 2014-07-16 0
113-hr-4716,L000564 Sage Grouse Protection and Conservation Act 113-hr-4716 L000564 Rep. Lamborn, Doug [R-CO-5] R CO 2014-06-25 0
113-hr-4716,N000184 Sage Grouse Protection and Conservation Act 113-hr-4716 N000184 Rep. Noem, Kristi L. [R-SD-At Large] R SD 2014-06-10 0
113-hr-4716,M001159 Sage Grouse Protection and Conservation Act 113-hr-4716 M001159 Rep. McMorris Rodgers, Cathy [R-WA-5] R WA 2014-05-30 0
113-hr-4716,G000565 Sage Grouse Protection and Conservation Act 113-hr-4716 G000565 Rep. Gosar, Paul A. [R-AZ-4] R AZ 2014-05-28 0
113-hr-4716,C001096 Sage Grouse Protection and Conservation Act 113-hr-4716 C001096 Rep. Cramer, Kevin [R-ND-At Large] R ND 2014-05-28 0
113-hr-4716,B001250 Sage Grouse Protection and Conservation Act 113-hr-4716 B001250 Rep. Bishop, Rob [R-UT-1] R UT 2014-05-22 1
113-hr-4716,L000571 Sage Grouse Protection and Conservation Act 113-hr-4716 L000571 Rep. Lummis, Cynthia M. [R-WY-At Large] R WY 2014-05-22 1
113-hr-4716,S001192 Sage Grouse Protection and Conservation Act 113-hr-4716 S001192 Rep. Stewart, Chris [R-UT-2] R UT 2014-05-22 1
113-hr-4716,C001076 Sage Grouse Protection and Conservation Act 113-hr-4716 C001076 Rep. Chaffetz, Jason [R-UT-3] R UT 2014-05-22 1
113-hr-4716,T000470 Sage Grouse Protection and Conservation Act 113-hr-4716 T000470 Rep. Tipton, Scott R. [R-CO-3] R CO 2014-05-22 1
113-hr-4716,A000369 Sage Grouse Protection and Conservation Act 113-hr-4716 A000369 Rep. Amodei, Mark E. [R-NV-2] R NV 2014-05-22 1
113-hr-4716,D000618 Sage Grouse Protection and Conservation Act 113-hr-4716 D000618 Rep. Daines, Steve [R-MT-At Large] R MT 2014-05-22 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);