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

16 rows where bill_id = "99-hr-5692" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date (date)

is_original_cosponsor 1

  • 1 16
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hr-5692,M000725 Child Victim Witness Protection Act of 1986 99-hr-5692 M000725 Rep. Miller, George [D-CA-7] D CA 1986-10-10 1
99-hr-5692,D000471 Child Victim Witness Protection Act of 1986 99-hr-5692 D000471 Rep. Downey, Thomas J. [D-NY-2] D NY 1986-10-10 1
99-hr-5692,A000069 Child Victim Witness Protection Act of 1986 99-hr-5692 A000069 Rep. Akaka, Daniel K. [D-HI-2] D HI 1986-10-10 1
99-hr-5692,H000840 Child Victim Witness Protection Act of 1986 99-hr-5692 H000840 Rep. Howard, James J. [D-NJ-3] D NJ 1986-10-10 1
99-hr-5692,Y000013 Child Victim Witness Protection Act of 1986 99-hr-5692 Y000013 Rep. Yates, Sidney R. [D-IL-9] D IL 1986-10-10 1
99-hr-5692,M000702 Child Victim Witness Protection Act of 1986 99-hr-5692 M000702 Rep. Mikulski, Barbara A. [D-MD-3] D MD 1986-10-10 1
99-hr-5692,Y000051 Child Victim Witness Protection Act of 1986 99-hr-5692 Y000051 Rep. Young, Robert A. [D-MO-2] D MO 1986-10-10 1
99-hr-5692,L000226 Child Victim Witness Protection Act of 1986 99-hr-5692 L000226 Rep. Lehman, William [D-FL-17] D FL 1986-10-10 1
99-hr-5692,W000038 Child Victim Witness Protection Act of 1986 99-hr-5692 W000038 Rep. Waldon, Alton R., Jr. [D-NY-6] D NY 1986-10-10 1
99-hr-5692,M000206 Child Victim Witness Protection Act of 1986 99-hr-5692 M000206 Rep. Martinez, Matthew G. [D-CA-30] D CA 1986-10-10 1
99-hr-5692,M000342 Child Victim Witness Protection Act of 1986 99-hr-5692 M000342 Rep. McCloskey, Frank [D-IN-8] D IN 1986-10-10 1
99-hr-5692,W000682 Child Victim Witness Protection Act of 1986 99-hr-5692 W000682 Rep. Wolpe, Howard E. [D-MI-3] D MI 1986-10-10 1
99-hr-5692,T000326 Child Victim Witness Protection Act of 1986 99-hr-5692 T000326 Rep. Towns, Edolphus [D-NY-11] D NY 1986-10-10 1
99-hr-5692,F000046 Child Victim Witness Protection Act of 1986 99-hr-5692 F000046 Del. Fauntroy, Walter E. [D-DC-At Large] D DC 1986-10-10 1
99-hr-5692,B001172 Child Victim Witness Protection Act of 1986 99-hr-5692 B001172 Rep. Bustamante, Albert G. [D-TX-23] D TX 1986-10-10 1
99-hr-5692,E000250 Child Victim Witness Protection Act of 1986 99-hr-5692 E000250 Rep. Evans, Lane [D-IL-17] D IL 1986-10-10 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);