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

26 rows where bill_id = "102-hr-5960" 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 25
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
102-hr-5960,C000873 Sexual Assault Prevention Act of 1992 102-hr-5960 C000873 Rep. Crane, Philip M. [R-IL-12] R IL 1992-10-05 0
102-hr-5960,M000350 Sexual Assault Prevention Act of 1992 102-hr-5960 M000350 Rep. McCollum, Bill [R-FL-5] R FL 1992-10-05 0
102-hr-5960,R000252 Sexual Assault Prevention Act of 1992 102-hr-5960 R000252 Rep. Riggs, Frank [R-CA-1] R CA 1992-10-05 0
102-hr-5960,H000124 Sexual Assault Prevention Act of 1992 102-hr-5960 H000124 Rep. Hammerschmidt, John P. [R-AR-3] R AR 1992-10-05 0
102-hr-5960,I000029 Sexual Assault Prevention Act of 1992 102-hr-5960 I000029 Rep. Ireland, Andrew P. [R-FL-10] R FL 1992-10-05 0
102-hr-5960,M000684 Sexual Assault Prevention Act of 1992 102-hr-5960 M000684 Rep. Meyers, Jan [R-KS-3] R KS 1992-10-05 0
102-hr-5960,E000174 Sexual Assault Prevention Act of 1992 102-hr-5960 E000174 Rep. Emerson, Bill [R-MO-8] R MO 1992-10-05 0
102-hr-5960,Y000033 Sexual Assault Prevention Act of 1992 102-hr-5960 Y000033 Rep. Young, Don [R-AK-At Large] R AK 1992-10-05 0
102-hr-5960,J000163 Sexual Assault Prevention Act of 1992 102-hr-5960 J000163 Rep. Johnson, Nancy L. [R-CT-6] R CT 1992-10-05 0
102-hr-5960,W000068 Sexual Assault Prevention Act of 1992 102-hr-5960 W000068 Rep. Walker, Robert S. [R-PA-16] R PA 1992-10-05 0
102-hr-5960,G000225 Sexual Assault Prevention Act of 1992 102-hr-5960 G000225 Rep. Gingrich, Newt [R-GA-6] R GA 1992-10-05 0
102-hr-5960,M000692 Sexual Assault Prevention Act of 1992 102-hr-5960 M000692 Rep. Michel, Robert H. [R-IL-18] R IL 1992-10-05 0
102-hr-5960,H000814 Sexual Assault Prevention Act of 1992 102-hr-5960 H000814 Rep. Houghton, Amo [R-NY-34] R NY 1992-10-05 0
102-hr-5960,S000303 Sexual Assault Prevention Act of 1992 102-hr-5960 S000303 Rep. Shaw, E. Clay, Jr. [R-FL-15] R FL 1992-10-05 0
102-hr-5960,N000094 Sexual Assault Prevention Act of 1992 102-hr-5960 N000094 Rep. Nichols, Dick [R-KS-5] R KS 1992-10-02 0
102-hr-5960,G000021 Sexual Assault Prevention Act of 1992 102-hr-5960 G000021 Rep. Gallegly, Elton [R-CA-21] R CA 1992-10-02 0
102-hr-5960,C000618 Sexual Assault Prevention Act of 1992 102-hr-5960 C000618 Rep. Coleman, E. Thomas [R-MO-6] R MO 1992-10-02 0
102-hr-5960,K000016 Sexual Assault Prevention Act of 1992 102-hr-5960 K000016 Rep. Kasich, John R. [R-OH-12] R OH 1992-10-02 0
102-hr-5960,O000163 Sexual Assault Prevention Act of 1992 102-hr-5960 O000163 Rep. Oxley, Michael G. [R-OH-4] R OH 1992-09-25 0
102-hr-5960,S000522 Sexual Assault Prevention Act of 1992 102-hr-5960 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 1992-09-25 0
102-hr-5960,G000511 Sexual Assault Prevention Act of 1992 102-hr-5960 G000511 Rep. Guarini, Frank J. [D-NJ-14] D NJ 1992-09-25 0
102-hr-5960,H000797 Sexual Assault Prevention Act of 1992 102-hr-5960 H000797 Rep. Horton, Frank J. [R-NY-29] R NY 1992-09-25 0
102-hr-5960,L000342 Sexual Assault Prevention Act of 1992 102-hr-5960 L000342 Rep. Lipinski, William O. [D-IL-5] D IL 1992-09-25 0
102-hr-5960,P000148 Sexual Assault Prevention Act of 1992 102-hr-5960 P000148 Rep. Paxon, Bill [R-NY-31] R NY 1992-09-25 0
102-hr-5960,F000348 Sexual Assault Prevention Act of 1992 102-hr-5960 F000348 Rep. Franks, Gary A. [R-CT-5] R CT 1992-09-25 0
102-hr-5960,K000352 Sexual Assault Prevention Act of 1992 102-hr-5960 K000352 Rep. Kyl, Jon [R-AZ-4] R AZ 1992-09-16 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);