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

22 rows where bill_id = "96-hr-3538" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

is_original_cosponsor 1

  • 0 22
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
96-hr-3538,R000262 Flood Control Procedure Reform Act of 1979 96-hr-3538 R000262 Rep. Rinaldo, Matthew J. [R-NJ-12] R     0
96-hr-3538,A000069 Flood Control Procedure Reform Act of 1979 96-hr-3538 A000069 Rep. Akaka, Daniel K. [D-HI-2] D     0
96-hr-3538,L000381 Flood Control Procedure Reform Act of 1979 96-hr-3538 L000381 Rep. Lloyd, Marilyn [D-TN-3] D     0
96-hr-3538,B000682 Flood Control Procedure Reform Act of 1979 96-hr-3538 B000682 Rep. Bowen, David R. [D-MS-2] D     0
96-hr-3538,B000780 Flood Control Procedure Reform Act of 1979 96-hr-3538 B000780 Rep. Breaux, John B. [D-LA-7] D     0
96-hr-3538,B000910 Flood Control Procedure Reform Act of 1979 96-hr-3538 B000910 Rep. Brown, Clarence, Jr. [R-OH-7] R     0
96-hr-3538,D000534 Flood Control Procedure Reform Act of 1979 96-hr-3538 D000534 Rep. Duncan, John J. [R-TN-2] R     0
96-hr-3538,H000641 Flood Control Procedure Reform Act of 1979 96-hr-3538 H000641 Rep. Hinson, Jon C. [R-MS-4] R     0
96-hr-3538,H000878 Flood Control Procedure Reform Act of 1979 96-hr-3538 H000878 Rep. Hubbard, Carroll, Jr. [D-KY-1] D     0
96-hr-3538,H000901 Flood Control Procedure Reform Act of 1979 96-hr-3538 H000901 Rep. Huckaby, Thomas J. (Jerry) [D-LA-5] D     0
96-hr-3538,M000365 Flood Control Procedure Reform Act of 1979 96-hr-3538 M000365 Rep. McCormack, Mike [D-WA-4] D     0
96-hr-3538,M001088 Flood Control Procedure Reform Act of 1979 96-hr-3538 M001088 Rep. Murphy, Austin J. [D-PA-22] D     0
96-hr-3538,P000230 Flood Control Procedure Reform Act of 1979 96-hr-3538 P000230 Rep. Perkins, Carl Dewey [D-KY-7] D     0
96-hr-3538,P000522 Flood Control Procedure Reform Act of 1979 96-hr-3538 P000522 Rep. Price, Melvin [D-IL-23] D IL   0
96-hr-3538,R000011 Flood Control Procedure Reform Act of 1979 96-hr-3538 R000011 Rep. Rahall, Nick J., II [D-WV-4] D WV   0
96-hr-3538,S000423 Flood Control Procedure Reform Act of 1979 96-hr-3538 S000423 Rep. Simon, Paul [D-IL-24] D     0
96-hr-3538,T000053 Flood Control Procedure Reform Act of 1979 96-hr-3538 T000053 Rep. Tauke, Thomas Joseph [R-IA-2] R     0
96-hr-3538,W000570 Flood Control Procedure Reform Act of 1979 96-hr-3538 W000570 Rep. Wilson, Charles [D-TX-2] D     0
96-hr-3538,W000636 Flood Control Procedure Reform Act of 1979 96-hr-3538 W000636 Rep. Winn, Larry, Jr. [R-KS-3] R     0
96-hr-3538,W000686 Flood Control Procedure Reform Act of 1979 96-hr-3538 W000686 Del. Won Pat, Antonio B. [D-GU-At Large] D     0
96-hr-3538,Y000051 Flood Control Procedure Reform Act of 1979 96-hr-3538 Y000051 Rep. Young, Robert A. [D-MO-2] D     0
96-hr-3538,L000417 Flood Control Procedure Reform Act of 1979 96-hr-3538 L000417 Rep. Long, Gillis W. [D-LA-8] D LA   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);