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

18 rows where bill_id = "97-hr-5792" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state, sponsorship_date (date)

is_original_cosponsor 1

  • 1 18
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
97-hr-5792,O000001 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 O000001 Rep. Oakar, Mary Rose [D-OH-20] D OH 1982-04-22 1
97-hr-5792,H000797 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 H000797 Rep. Horton, Frank J. [R-NY-34] R NY 1982-04-22 1
97-hr-5792,M000796 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 M000796 Rep. Minish, Joseph G. [D-NJ-11] D NJ 1982-04-22 1
97-hr-5792,F000286 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 F000286 Rep. Forsythe, Edwin B. [R-NJ-6] R NJ 1982-04-22 1
97-hr-5792,D000435 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 D000435 Rep. Dornan, Robert K. [R-CA-27] R CA 1982-04-22 1
97-hr-5792,L000226 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 L000226 Rep. Lehman, William [D-FL-13] D FL 1982-04-22 1
97-hr-5792,M000826 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 M000826 Rep. Mitchell, Parren J. [D-MD-7] D MD 1982-04-22 1
97-hr-5792,W000180 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 W000180 Rep. Washington, Harold [D-IL-1] D IL 1982-04-22 1
97-hr-5792,D000231 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 D000231 Rep. DeNardis, Lawrence J. [R-CT-3] R CT 1982-04-22 1
97-hr-5792,W000227 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 W000227 Rep. Weaver, James H. [D-OR-4] D OR 1982-04-22 1
97-hr-5792,S000579 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 S000579 Rep. Smith, Joseph F. [D-PA-3] D PA 1982-04-22 1
97-hr-5792,M000041 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 M000041 Rep. Madigan, Edward R. [R-IL-21] R IL 1982-04-22 1
97-hr-5792,D000446 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 D000446 Rep. Dougherty, Charles F. [R-PA-4] R PA 1982-04-22 1
97-hr-5792,M000458 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 M000458 Rep. McGrath, Raymond J. [R-NY-5] R NY 1982-04-22 1
97-hr-5792,S000124 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 S000124 Rep. Scheuer, James H. [D-NY-11] D NY 1982-04-22 1
97-hr-5792,B000432 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 B000432 Rep. Biaggi, Mario [D-NY-10] D NY 1982-04-22 1
97-hr-5792,L000381 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 L000381 Rep. Lloyd, Marilyn [D-TN-3] D TN 1982-04-22 1
97-hr-5792,E000043 A bill to amend the Higher Education Act of 1965 to authorize grants to offset reductions in other forms of student financial assistance, and for other purposes. 97-hr-5792 E000043 Rep. Edgar, Robert W. [D-PA-7] D PA 1982-04-22 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);