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

25 rows where bill_id = "98-hr-6301" 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 20
  • 0 5
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
98-hr-6301,M000826 Steel Import Stabilization Act 98-hr-6301 M000826 Rep. Mitchell, Parren J. [D-MD-7] D MD 1984-09-26 0
98-hr-6301,L000342 Steel Import Stabilization Act 98-hr-6301 L000342 Rep. Lipinski, William O. [D-IL-5] D IL 1984-09-26 0
98-hr-6301,W000654 Steel Import Stabilization Act 98-hr-6301 W000654 Rep. Wise, Robert E., Jr. [D-WV-3] D WV 1984-09-26 0
98-hr-6301,K000172 Steel Import Stabilization Act 98-hr-6301 K000172 Rep. Kildee, Dale E. [D-MI-7] D MI 1984-09-26 0
98-hr-6301,N000163 Steel Import Stabilization Act 98-hr-6301 N000163 Rep. Nowak, Henry [D-NY-33] D NY 1984-09-26 0
98-hr-6301,M001120 Steel Import Stabilization Act 98-hr-6301 M001120 Rep. Murtha, John P. [D-PA-12] D PA 1984-09-25 1
98-hr-6301,R000141 Steel Import Stabilization Act 98-hr-6301 R000141 Rep. Regula, Ralph [R-OH-16] R OH 1984-09-25 1
98-hr-6301,R000053 Steel Import Stabilization Act 98-hr-6301 R000053 Rep. Rangel, Charles B. [D-NY-16] D NY 1984-09-25 1
98-hr-6301,S000810 Steel Import Stabilization Act 98-hr-6301 S000810 Rep. Stark, Fortney Pete [D-CA-9] D CA 1984-09-25 1
98-hr-6301,F000261 Steel Import Stabilization Act 98-hr-6301 F000261 Rep. Ford, Harold E. [D-TN-9] D TN 1984-09-25 1
98-hr-6301,H000449 Steel Import Stabilization Act 98-hr-6301 H000449 Rep. Heftel, Cecil [D-HI-1] D HI 1984-09-25 1
98-hr-6301,G000511 Steel Import Stabilization Act 98-hr-6301 G000511 Rep. Guarini, Frank J. [D-NJ-14] D NJ 1984-09-25 1
98-hr-6301,S000286 Steel Import Stabilization Act 98-hr-6301 S000286 Rep. Shannon, James M. [D-MA-5] D MA 1984-09-25 1
98-hr-6301,R000543 Steel Import Stabilization Act 98-hr-6301 R000543 Rep. Russo, Martin A. [D-IL-3] D IL 1984-09-25 1
98-hr-6301,P000170 Steel Import Stabilization Act 98-hr-6301 P000170 Rep. Pease, Donald J. [D-OH-13] D OH 1984-09-25 1
98-hr-6301,H000144 Steel Import Stabilization Act 98-hr-6301 H000144 Rep. Hance, Kent R. [D-TX-19] D TX 1984-09-25 1
98-hr-6301,K000118 Steel Import Stabilization Act 98-hr-6301 K000118 Rep. Kennelly, Barbara B. [D-CT-1] D CT 1984-09-25 1
98-hr-6301,D000355 Steel Import Stabilization Act 98-hr-6301 D000355 Rep. Dingell, John D. [D-MI-16] D MI 1984-09-25 1
98-hr-6301,F000046 Steel Import Stabilization Act 98-hr-6301 F000046 Del. Fauntroy, Walter E. [D-DC-At Large] D DC 1984-09-25 1
98-hr-6301,T000356 Steel Import Stabilization Act 98-hr-6301 T000356 Rep. Traxler, Bob [D-MI-8] D MI 1984-09-25 1
98-hr-6301,S000230 Steel Import Stabilization Act 98-hr-6301 S000230 Rep. Seiberling, John F. [D-OH-14] D OH 1984-09-25 1
98-hr-6301,W000528 Steel Import Stabilization Act 98-hr-6301 W000528 Rep. Williams, Lyle [R-OH-17] R OH 1984-09-25 1
98-hr-6301,S000522 Steel Import Stabilization Act 98-hr-6301 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 1984-09-25 1
98-hr-6301,K000307 Steel Import Stabilization Act 98-hr-6301 K000307 Rep. Kolter, Joseph P. [D-PA-4] D PA 1984-09-25 1
98-hr-6301,M000725 Steel Import Stabilization Act 98-hr-6301 M000725 Rep. Miller, George [D-CA-7] D CA 1984-09-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);