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 = "97-hr-7320" 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

  • 0 21
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
97-hr-7320,H000172 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 H000172 Rep. Hansen, James V. [R-UT-1] R UT 1982-12-20 0
97-hr-7320,M000432 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 M000432 Rep. McEwen, Bob [R-OH-6] R OH 1982-12-09 0
97-hr-7320,B000919 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 B000919 Rep. Brown, Hank [R-CO-4] R CO 1982-12-09 0
97-hr-7320,L000020 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 L000020 Rep. Lagomarsino, Robert J. [R-CA-19] R CA 1982-12-09 0
97-hr-7320,C000858 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 C000858 Rep. Craig, Larry E. [R-ID-1] R ID 1982-12-09 0
97-hr-7320,M000195 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 M000195 Rep. Martin, Lynn M. [R-IL-16] R IL 1982-12-09 0
97-hr-7320,F000111 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 F000111 Rep. Fields, Jack [R-TX-8] R TX 1982-12-09 0
97-hr-7320,L000381 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 L000381 Rep. Lloyd, Marilyn [D-TN-3] D TN 1982-12-09 0
97-hr-7320,P000583 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 P000583 Rep. Paul, Ron [R-TX-22] R TX 1982-12-09 0
97-hr-7320,F000339 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 F000339 Rep. Frank, Barney [D-MA-4] D MA 1982-12-09 0
97-hr-7320,R000465 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 R000465 Rep. Roukema, Marge [R-NJ-7] R NJ 1982-12-09 0
97-hr-7320,H000981 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 H000981 Rep. Hunter, Duncan [R-CA-42] R CA 1982-12-09 0
97-hr-7320,H000490 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 H000490 Rep. Hendon, Bill [R-NC-11] R NC 1982-12-09 0
97-hr-7320,R000459 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 R000459 Rep. Roth, Toby [R-WI-8] R WI 1982-12-09 0
97-hr-7320,C000523 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 C000523 Rep. Clinger, William F., Jr. [R-PA-23] R PA 1982-12-09 0
97-hr-7320,M000350 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 M000350 Rep. McCollum, Bill [R-FL-5] R FL 1982-12-09 0
97-hr-7320,M000264 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 M000264 Rep. Mavroules, Nicholas [D-MA-6] D MA 1982-12-09 0
97-hr-7320,R000262 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 R000262 Rep. Rinaldo, Matthew J. [R-NJ-12] R NJ 1982-12-09 0
97-hr-7320,F000078 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 F000078 Rep. Fenwick, Millicent H. [R-NJ-5] R NJ 1982-12-09 0
97-hr-7320,G000225 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 G000225 Rep. Gingrich, Newt [R-GA-6] R GA 1982-12-09 0
97-hr-7320,D000044 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 D000044 Rep. Dannemeyer, William E. [R-CA-39] R CA 1982-12-09 0
97-hr-7320,A000214 A bill to freeze for fiscal year 1983 the rate of salary payable to Members of Congress. 97-hr-7320 A000214 Rep. Applegate, Douglas [D-OH-18] D OH 1982-11-29 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);