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 = "98-hr-5447" 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

  • 1 17
  • 0 3
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
98-hr-5447,L000020 National Fishing Enhancement Act of 1984 98-hr-5447 L000020 Rep. Lagomarsino, Robert J. [R-CA-19] R CA 1984-05-01 0
98-hr-5447,B000431 National Fishing Enhancement Act of 1984 98-hr-5447 B000431 Rep. Bevill, Tom [D-AL-4] D AL 1984-05-01 0
98-hr-5447,S000303 National Fishing Enhancement Act of 1984 98-hr-5447 S000303 Rep. Shaw, E. Clay, Jr. [R-FL-15] R FL 1984-05-01 0
98-hr-5447,P000546 National Fishing Enhancement Act of 1984 98-hr-5447 P000546 Rep. Pritchard, Joel [R-WA-1] R WA 1984-04-12 1
98-hr-5447,H000930 National Fishing Enhancement Act of 1984 98-hr-5447 H000930 Rep. Hughes, William J. [D-NJ-2] D NJ 1984-04-12 1
98-hr-5447,F000041 National Fishing Enhancement Act of 1984 98-hr-5447 F000041 Rep. Fascell, Dante B. [D-FL-19] D FL 1984-04-12 1
98-hr-5447,M000923 National Fishing Enhancement Act of 1984 98-hr-5447 M000923 Rep. Moore, W. Henson [R-LA-6] R LA 1984-04-12 1
98-hr-5447,H001018 National Fishing Enhancement Act of 1984 98-hr-5447 H001018 Rep. Hutto, Earl [D-FL-1] D FL 1984-04-12 1
98-hr-5447,D000017 National Fishing Enhancement Act of 1984 98-hr-5447 D000017 Rep. D'Amours, Norman E. [D-NH-1] D NH 1984-04-12 1
98-hr-5447,B000463 National Fishing Enhancement Act of 1984 98-hr-5447 B000463 Rep. Bilirakis, Michael [R-FL-9] R FL 1984-04-12 1
98-hr-5447,T000034 National Fishing Enhancement Act of 1984 98-hr-5447 T000034 Rep. Tallon, Robert M. (Robin) [D-SC-6] D SC 1984-04-12 1
98-hr-5447,F000430 National Fishing Enhancement Act of 1984 98-hr-5447 F000430 Rep. Fuqua, Don [D-FL-2] D FL 1984-04-12 1
98-hr-5447,B000432 National Fishing Enhancement Act of 1984 98-hr-5447 B000432 Rep. Biaggi, Mario [D-NY-19] D NY 1984-04-12 1
98-hr-5447,W000686 National Fishing Enhancement Act of 1984 98-hr-5447 W000686 Del. Won Pat, Antonio B. [D-GU-At Large] D GU 1984-04-12 1
98-hr-5447,S000586 National Fishing Enhancement Act of 1984 98-hr-5447 S000586 Rep. Smith, Lawrence [D-FL-16] D FL 1984-04-12 1
98-hr-5447,N000163 National Fishing Enhancement Act of 1984 98-hr-5447 N000163 Rep. Nowak, Henry [D-NY-33] D NY 1984-04-12 1
98-hr-5447,L000371 National Fishing Enhancement Act of 1984 98-hr-5447 L000371 Rep. Livingston, Bob [R-LA-1] R LA 1984-04-12 1
98-hr-5447,S000136 National Fishing Enhancement Act of 1984 98-hr-5447 S000136 Rep. Schneider, Claudine [R-RI-2] R RI 1984-04-12 1
98-hr-5447,F000053 National Fishing Enhancement Act of 1984 98-hr-5447 F000053 Rep. Fazio, Vic [D-CA-4] D CA 1984-04-12 1
98-hr-5447,R000383 National Fishing Enhancement Act of 1984 98-hr-5447 R000383 Rep. Roe, Robert A. [D-NJ-8] D NJ 1984-04-12 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);