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-6482" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 1 20
  • 0 2
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
97-hr-6482,R000011 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 R000011 Rep. Rahall, Nick J., II [D-WV-4] D WV 1982-09-20 0
97-hr-6482,G000511 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 G000511 Rep. Guarini, Frank J. [D-NJ-14] D NJ 1982-09-20 0
97-hr-6482,W000763 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 W000763 Rep. Wright, James C., Jr. [D-TX-12] D TX 1982-05-25 1
97-hr-6482,G000153 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 G000153 Rep. Gibbons, Sam [D-FL-7] D FL 1982-05-25 1
97-hr-6482,P000218 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 P000218 Rep. Pepper, Claude [D-FL-14] D FL 1982-05-25 1
97-hr-6482,B000600 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 B000600 Rep. Boland, Edward P. [D-MA-2] D MA 1982-05-25 1
97-hr-6482,M000834 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 M000834 Rep. Moakley, John Joseph [D-MA-9] D MA 1982-05-25 1
97-hr-6482,B000918 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 B000918 Rep. Brown, George E., Jr. [D-CA-36] D CA 1982-05-25 1
97-hr-6482,F000270 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 F000270 Rep. Ford, William D. [D-MI-15] D MI 1982-05-25 1
97-hr-6482,J000083 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 J000083 Rep. Jenkins, Edgar L. [D-GA-9] D GA 1982-05-25 1
97-hr-6482,D000471 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 D000471 Rep. Downey, Thomas J. [D-NY-2] D NY 1982-05-25 1
97-hr-6482,C000714 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 C000714 Rep. Conyers, John, Jr. [D-MI-1] D MI 1982-05-25 1
97-hr-6482,S000423 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 S000423 Rep. Simon, Paul [D-IL-24] D IL 1982-05-25 1
97-hr-6482,B000037 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 B000037 Rep. Bailey, Donald A. [D-PA-21] D PA 1982-05-25 1
97-hr-6482,B000862 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 B000862 Rep. Brodhead, William [D-MI-17] D MI 1982-05-25 1
97-hr-6482,F000161 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 F000161 Rep. Fithian, Floyd J. [D-IN-2] D IN 1982-05-25 1
97-hr-6482,M000249 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 M000249 Rep. Matsui, Robert T. [D-CA-3] D CA 1982-05-25 1
97-hr-6482,E000208 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 E000208 Rep. Ertel, Allen E. [D-PA-17] D PA 1982-05-25 1
97-hr-6482,S000230 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 S000230 Rep. Seiberling, John F. [D-OH-14] D OH 1982-05-25 1
97-hr-6482,A000103 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 A000103 Rep. Alexander, Bill [D-AR-1] D AR 1982-05-25 1
97-hr-6482,H000719 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 H000719 Rep. Holland, Kenneth L. [D-SC-5] D SC 1982-05-25 1
97-hr-6482,T000356 A bill to improve worker training under the Trade Act of 1974, and for other purposes. 97-hr-6482 T000356 Rep. Traxler, Bob [D-MI-8] D MI 1982-05-25 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);