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

12 rows where bill_id = "96-hr-6601" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

is_original_cosponsor 1

  • 0 12
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
96-hr-6601,R000165 Credit Union Savers Relief Act of 1980 96-hr-6601 R000165 Rep. Reuss, Henry S. [D-WI-5] D     0
96-hr-6601,B001080 Credit Union Savers Relief Act of 1980 96-hr-6601 B001080 Rep. Burgener, Clair W. [R-CA-43] R     0
96-hr-6601,G000417 Credit Union Savers Relief Act of 1980 96-hr-6601 G000417 Rep. Green, S. William [R-NY-18] R     0
96-hr-6601,M000794 Credit Union Savers Relief Act of 1980 96-hr-6601 M000794 Rep. Mineta, Norman Y. [D-CA-13] D     0
96-hr-6601,O000001 Credit Union Savers Relief Act of 1980 96-hr-6601 O000001 Rep. Oakar, Mary Rose [D-OH-20] D     0
96-hr-6601,B000160 Credit Union Savers Relief Act of 1980 96-hr-6601 B000160 Rep. Barnes, Michael D. [D-MD-8] D     0
96-hr-6601,C000714 Credit Union Savers Relief Act of 1980 96-hr-6601 C000714 Rep. Conyers, John, Jr. [D-MI-1] D MI   0
96-hr-6601,B000839 Credit Union Savers Relief Act of 1980 96-hr-6601 B000839 Rep. Brinkley, Jack [D-GA-3] D     0
96-hr-6601,D000017 Credit Union Savers Relief Act of 1980 96-hr-6601 D000017 Rep. D'Amours, Norman E. [D-NH-1] D     0
96-hr-6601,M000260 Credit Union Savers Relief Act of 1980 96-hr-6601 M000260 Rep. Mattox, James A. [D-TX-5] D     0
96-hr-6601,W000528 Credit Union Savers Relief Act of 1980 96-hr-6601 W000528 Rep. Williams, Lyle [R-OH-17] R     0
96-hr-6601,W000227 Credit Union Savers Relief Act of 1980 96-hr-6601 W000227 Rep. Weaver, James H. [D-OR-4] D     0

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);