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

20 rows where bill_id = "96-hr-8085" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

is_original_cosponsor 1

  • 0 20
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
96-hr-8085,W000781 Credit Control Sunset Act of 1980 96-hr-8085 W000781 Rep. Wylie, Chalmers P. [R-OH-15] R     0
96-hr-8085,H000171 Credit Control Sunset Act of 1980 96-hr-8085 H000171 Rep. Hansen, George V. [R-ID-2] R ID   0
96-hr-8085,H001022 Credit Control Sunset Act of 1980 96-hr-8085 H001022 Rep. Hyde, Henry J. [R-IL-6] R     0
96-hr-8085,K000077 Credit Control Sunset Act of 1980 96-hr-8085 K000077 Rep. Kelly, Richard [R-FL-5] R     0
96-hr-8085,L000169 Credit Control Sunset Act of 1980 96-hr-8085 L000169 Rep. Leach, James A. [R-IA-1] R     0
96-hr-8085,E000258 Credit Control Sunset Act of 1980 96-hr-8085 E000258 Rep. Evans, Thomas B., Jr. [R-DE-At Large] R     0
96-hr-8085,G000417 Credit Control Sunset Act of 1980 96-hr-8085 G000417 Rep. Green, S. William [R-NY-18] R     0
96-hr-8085,P000583 Credit Control Sunset Act of 1980 96-hr-8085 P000583 Rep. Paul, Ron [R-TX-14] R     0
96-hr-8085,B000422 Credit Control Sunset Act of 1980 96-hr-8085 B000422 Rep. Bethune, Ed [R-AR-2] R     0
96-hr-8085,S000393 Credit Control Sunset Act of 1980 96-hr-8085 S000393 Rep. Shumway, Norman D. [R-CA-14] R     0
96-hr-8085,C000079 Credit Control Sunset Act of 1980 96-hr-8085 C000079 Rep. Campbell, Carroll A., Jr. [R-SC-4] R     0
96-hr-8085,R000277 Credit Control Sunset Act of 1980 96-hr-8085 R000277 Rep. Ritter, Don [R-PA-15] R     0
96-hr-8085,H000641 Credit Control Sunset Act of 1980 96-hr-8085 H000641 Rep. Hinson, Jon C. [R-MS-4] R     0
96-hr-8085,P000444 Credit Control Sunset Act of 1980 96-hr-8085 P000444 Rep. Porter, John Edward [R-IL-10] R     0
96-hr-8085,M000826 Credit Control Sunset Act of 1980 96-hr-8085 M000826 Rep. Mitchell, Parren J. [D-MD-7] D     0
96-hr-8085,N000016 Credit Control Sunset Act of 1980 96-hr-8085 N000016 Rep. Neal, Stephen L. [D-NC-5] D     0
96-hr-8085,H000878 Credit Control Sunset Act of 1980 96-hr-8085 H000878 Rep. Hubbard, Carroll, Jr. [D-KY-1] D     0
96-hr-8085,E000239 Credit Control Sunset Act of 1980 96-hr-8085 E000239 Rep. Evans, David W. [D-IN-6] D     0
96-hr-8085,B000153 Credit Control Sunset Act of 1980 96-hr-8085 B000153 Rep. Barnard, Doug, Jr. [D-GA-10] D     0
96-hr-8085,W000194 Credit Control Sunset Act of 1980 96-hr-8085 W000194 Rep. Watkins, Wes [D-OK-3] R     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);