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

24 rows where bill_id = "97-hr-5278" 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 16
  • 0 8
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
97-hr-5278,H000012 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 H000012 Rep. Hagedorn, Thomas M. [R-MN-2] R MN 1982-07-19 0
97-hr-5278,B000615 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 B000615 Rep. Boner, William H. [D-TN-5] D TN 1982-07-19 0
97-hr-5278,V000087 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 V000087 Rep. Vento, Bruce F. [D-MN-4] D MN 1982-04-01 0
97-hr-5278,F000235 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 F000235 Rep. Foglietta, Thomas M. [D-PA-1] D PA 1982-04-01 0
97-hr-5278,F000286 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 F000286 Rep. Forsythe, Edwin B. [R-NJ-6] R NJ 1982-04-01 0
97-hr-5278,H000930 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 H000930 Rep. Hughes, William J. [D-NJ-2] D NJ 1982-04-01 0
97-hr-5278,E000043 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 E000043 Rep. Edgar, Robert W. [D-PA-7] D PA 1982-04-01 0
97-hr-5278,C000845 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 C000845 Rep. Coyne, James K. [R-PA-8] R PA 1982-04-01 0
97-hr-5278,B000403 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 B000403 Rep. Bereuter, Doug [R-NE-1] R NE 1981-12-16 1
97-hr-5278,H000206 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 H000206 Rep. Harkin, Tom [D-IA-5] D IA 1981-12-16 1
97-hr-5278,S000596 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 S000596 Rep. Smith, Neal Edward [D-IA-4] D IA 1981-12-16 1
97-hr-5278,L000169 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 L000169 Rep. Leach, James A. [R-IA-1] R IA 1981-12-16 1
97-hr-5278,T000053 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 T000053 Rep. Tauke, Thomas Joseph [R-IA-2] R IA 1981-12-16 1
97-hr-5278,E000259 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 E000259 Rep. Evans, Cooper [R-IA-3] R IA 1981-12-16 1
97-hr-5278,D000065 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 D000065 Rep. Daub, Hal [R-NE-2] R NE 1981-12-16 1
97-hr-5278,G000132 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 G000132 Rep. Gephardt, Richard A. [D-MO-3] D MO 1981-12-16 1
97-hr-5278,S000465 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 S000465 Rep. Skelton, Ike [D-MO-4] D MO 1981-12-16 1
97-hr-5278,V000112 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 V000112 Rep. Volkmer, Harold L. [D-MO-9] D MO 1981-12-16 1
97-hr-5278,C000618 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 C000618 Rep. Coleman, E. Thomas [R-MO-6] R MO 1981-12-16 1
97-hr-5278,B000047 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 B000047 Rep. Bailey, Wendell [R-MO-8] R MO 1981-12-16 1
97-hr-5278,W000426 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 W000426 Rep. Whittaker, Bob [R-KS-5] R KS 1981-12-16 1
97-hr-5278,T000075 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 T000075 Rep. Taylor, G. [R-MO-7] R MO 1981-12-16 1
97-hr-5278,E000174 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 E000174 Rep. Emerson, Bill [R-MO-10] R MO 1981-12-16 1
97-hr-5278,M000139 A bill to prohibit any State from selling or otherwise transferring interstate waters located in such State for use outside such State unless all other States in the drainage basin of such waters consent to such sale or transfer. 97-hr-5278 M000139 Rep. Marlenee, Ron [R-MT-2] R MT 1981-12-16 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);