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

15 rows where bill_id = "105-hr-4686" 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

  • 1 14
  • 0 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
105-hr-4686,F000262 Long-Term Care Patient Protection Act of 1998 105-hr-4686 F000262 Rep. Ford, Harold E., Jr. [D-TN-9] D TN 1998-10-09 0
105-hr-4686,B000177 Long-Term Care Patient Protection Act of 1998 105-hr-4686 B000177 Rep. Barrett, Thomas M. [D-WI-5] D WI 1998-10-02 1
105-hr-4686,H000324 Long-Term Care Patient Protection Act of 1998 105-hr-4686 H000324 Rep. Hastings, Alcee L. [D-FL-23] D FL 1998-10-02 1
105-hr-4686,C000794 Long-Term Care Patient Protection Act of 1998 105-hr-4686 C000794 Rep. Costello, Jerry F. [D-IL-12] D IL 1998-10-02 1
105-hr-4686,F000116 Long-Term Care Patient Protection Act of 1998 105-hr-4686 F000116 Rep. Filner, Bob [D-CA-50] D CA 1998-10-02 1
105-hr-4686,W000215 Long-Term Care Patient Protection Act of 1998 105-hr-4686 W000215 Rep. Waxman, Henry A. [D-CA-29] D CA 1998-10-02 1
105-hr-4686,K000180 Long-Term Care Patient Protection Act of 1998 105-hr-4686 K000180 Rep. Kilpatrick, Carolyn C. [D-MI-15] D MI 1998-10-02 1
105-hr-4686,S000810 Long-Term Care Patient Protection Act of 1998 105-hr-4686 S000810 Rep. Stark, Fortney Pete [D-CA-13] D CA 1998-10-02 1
105-hr-4686,K000113 Long-Term Care Patient Protection Act of 1998 105-hr-4686 K000113 Rep. Kennedy, Patrick J. [D-RI-1] D RI 1998-10-02 1
105-hr-4686,N000015 Long-Term Care Patient Protection Act of 1998 105-hr-4686 N000015 Rep. Neal, Richard E. [D-MA-2] D MA 1998-10-02 1
105-hr-4686,S000480 Long-Term Care Patient Protection Act of 1998 105-hr-4686 S000480 Rep. Slaughter, Louise McIntosh [D-NY-28] D NY 1998-10-02 1
105-hr-4686,S000044 Long-Term Care Patient Protection Act of 1998 105-hr-4686 S000044 Rep. Sandlin, Max [D-TX-1] D TX 1998-10-02 1
105-hr-4686,U000014 Long-Term Care Patient Protection Act of 1998 105-hr-4686 U000014 Del. Underwood, Robert A. [D-GU-At Large] D GU 1998-10-02 1
105-hr-4686,M000627 Long-Term Care Patient Protection Act of 1998 105-hr-4686 M000627 Rep. Meehan, Martin T. [D-MA-5] D MA 1998-10-02 1
105-hr-4686,R000486 Long-Term Care Patient Protection Act of 1998 105-hr-4686 R000486 Rep. Roybal-Allard, Lucille [D-CA-33] D CA 1998-10-02 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);