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

19 rows where bill_id = "98-hr-5849" 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

  • 1 18
  • 0 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
98-hr-5849,M000794 Cancer Patients Employment Rights Act 98-hr-5849 M000794 Rep. Mineta, Norman Y. [D-CA-13] D CA 1984-09-18 0
98-hr-5849,L000237 Cancer Patients Employment Rights Act 98-hr-5849 L000237 Rep. Leland, Mickey [D-TX-18] D TX 1984-09-06 1
98-hr-5849,C000714 Cancer Patients Employment Rights Act 98-hr-5849 C000714 Rep. Conyers, John, Jr. [D-MI-1] D MI 1984-09-06 1
98-hr-5849,F000339 Cancer Patients Employment Rights Act 98-hr-5849 F000339 Rep. Frank, Barney [D-MA-4] D MA 1984-09-06 1
98-hr-5849,H000547 Cancer Patients Employment Rights Act 98-hr-5849 H000547 Rep. Hertel, Dennis M. [D-MI-14] D MI 1984-09-06 1
98-hr-5849,R000383 Cancer Patients Employment Rights Act 98-hr-5849 R000383 Rep. Roe, Robert A. [D-NJ-8] D NJ 1984-09-06 1
98-hr-5849,W000426 Cancer Patients Employment Rights Act 98-hr-5849 W000426 Rep. Whittaker, Bob [R-KS-5] R KS 1984-09-06 1
98-hr-5849,W000258 Cancer Patients Employment Rights Act 98-hr-5849 W000258 Rep. Weiss, Ted [D-NY-17] D NY 1984-09-06 1
98-hr-5849,T000317 Cancer Patients Employment Rights Act 98-hr-5849 T000317 Rep. Torricelli, Robert G. [D-NJ-9] D NJ 1984-09-06 1
98-hr-5849,R000011 Cancer Patients Employment Rights Act 98-hr-5849 R000011 Rep. Rahall, Nick J., II [D-WV-4] D WV 1984-09-06 1
98-hr-5849,L000226 Cancer Patients Employment Rights Act 98-hr-5849 L000226 Rep. Lehman, William [D-FL-17] D FL 1984-09-06 1
98-hr-5849,B000711 Cancer Patients Employment Rights Act 98-hr-5849 B000711 Rep. Boxer, Barbara [D-CA-6] D CA 1984-09-06 1
98-hr-5849,V000087 Cancer Patients Employment Rights Act 98-hr-5849 V000087 Rep. Vento, Bruce F. [D-MN-4] D MN 1984-09-06 1
98-hr-5849,R000229 Cancer Patients Employment Rights Act 98-hr-5849 R000229 Rep. Richardson, Bill [D-NM-3] D NM 1984-09-06 1
98-hr-5849,M000206 Cancer Patients Employment Rights Act 98-hr-5849 M000206 Rep. Martinez, Matthew G. [D-CA-30] D CA 1984-09-06 1
98-hr-5849,D000586 Cancer Patients Employment Rights Act 98-hr-5849 D000586 Rep. Dwyer, Bernard J. [D-NJ-6] D NJ 1984-09-06 1
98-hr-5849,T000326 Cancer Patients Employment Rights Act 98-hr-5849 T000326 Rep. Towns, Edolphus [D-NY-11] D NY 1984-09-06 1
98-hr-5849,K000118 Cancer Patients Employment Rights Act 98-hr-5849 K000118 Rep. Kennelly, Barbara B. [D-CT-1] D CT 1984-09-06 1
98-hr-5849,Y000051 Cancer Patients Employment Rights Act 98-hr-5849 Y000051 Rep. Young, Robert A. [D-MO-2] D MO 1984-09-06 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);