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-6789" 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 15
  • 1 3
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
97-hr-6789,B000403 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 B000403 Rep. Bereuter, Doug [R-NE-1] R NE 1982-12-08 0
97-hr-6789,S000663 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 S000663 Rep. Snowe, Olympia J. [R-ME-2] R ME 1982-08-19 0
97-hr-6789,W000419 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 W000419 Rep. Whitley, Charles O., Sr. [D-NC-3] D NC 1982-08-19 0
97-hr-6789,T000053 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 T000053 Rep. Tauke, Thomas Joseph [R-IA-2] R IA 1982-08-13 0
97-hr-6789,M001088 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 M001088 Rep. Murphy, Austin J. [D-PA-22] D PA 1982-08-05 0
97-hr-6789,B000431 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 B000431 Rep. Bevill, Tom [D-AL-4] D AL 1982-08-05 0
97-hr-6789,D000131 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 D000131 Rep. Davis, Robert W. [R-MI-11] R MI 1982-08-05 0
97-hr-6789,R000012 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 R000012 Rep. Railsback, Thomas F. [R-IL-19] R IL 1982-08-05 0
97-hr-6789,R000384 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 R000384 Rep. Roemer, Buddy [D-LA-4] D LA 1982-08-05 0
97-hr-6789,W000570 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 W000570 Rep. Wilson, Charles [D-TX-2] D TX 1982-08-03 0
97-hr-6789,D000203 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 D000203 Rep. de la Garza, E. [D-TX-15] D TX 1982-08-03 0
97-hr-6789,B000298 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 B000298 Rep. Bedell, Berkley W. [D-IA-6] D IA 1982-08-03 0
97-hr-6789,F000088 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 F000088 Rep. Ferraro, Geraldine A. [D-NY-9] D NY 1982-08-03 0
97-hr-6789,B000615 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 B000615 Rep. Boner, William H. [D-TN-5] D TN 1982-08-02 0
97-hr-6789,A000213 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 A000213 Rep. Anthony, Beryl, Jr. [D-AR-4] D AR 1982-08-02 0
97-hr-6789,D000064 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 D000064 Rep. Daschle, Thomas A. [D-SD-1] D SD 1982-07-29 1
97-hr-6789,M000139 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 M000139 Rep. Marlenee, Ron [R-MT-2] R MT 1982-07-29 1
97-hr-6789,R000383 A bill to exempt rural electrical cooperatives from fees under the Federal Land Policy and Management Act of 1976. 97-hr-6789 R000383 Rep. Roe, Robert A. [D-NJ-8] D NJ 1982-07-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);