home / openregs

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

28 rows where bill_id = "103-hr-4206" 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 27
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hr-4206,M001120 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 M001120 Rep. Murtha, John P. [D-PA-12] D PA 1994-06-10 0
103-hr-4206,B000392 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 B000392 Rep. Bentley, Helen Delich [R-MD-2] R MD 1994-06-10 0
103-hr-4206,V000108 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 V000108 Rep. Visclosky, Peter J. [D-IN-1] D IN 1994-06-10 0
103-hr-4206,O000006 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 O000006 Rep. Oberstar, James L. [D-MN-8] D MN 1994-06-10 0
103-hr-4206,P000452 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 P000452 Rep. Poshard, Glenn [D-IL-19] D IL 1994-06-10 0
103-hr-4206,Q000016 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 Q000016 Rep. Quinn, Jack [R-NY-30] R NY 1994-06-10 0
103-hr-4206,K000009 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1994-06-10 0
103-hr-4206,M000844 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 M000844 Rep. Mollohan, Alan B. [D-WV-1] D WV 1994-06-10 0
103-hr-4206,M001088 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 M001088 Rep. Murphy, Austin J. [D-PA-20] D PA 1994-06-10 0
103-hr-4206,A000214 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 A000214 Rep. Applegate, Douglas [D-OH-18] D OH 1994-06-10 0
103-hr-4206,B000944 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 B000944 Rep. Brown, Sherrod [D-OH-13] D OH 1994-06-10 0
103-hr-4206,G000410 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 G000410 Rep. Green, Gene [D-TX-29] D TX 1994-06-10 0
103-hr-4206,L000098 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 L000098 Rep. LaRocco, Larry [D-ID-1] D ID 1994-06-10 0
103-hr-4206,M000117 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 M000117 Rep. Manton, Thomas J. [D-NY-7] D NY 1994-06-10 0
103-hr-4206,L000556 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 L000556 Rep. LaFalce, John J. [D-NY-29] D NY 1994-06-10 0
103-hr-4206,F000128 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 F000128 Rep. Fingerhut, Eric D. [D-OH-19] D OH 1994-06-10 0
103-hr-4206,C000880 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 C000880 Rep. Crapo, Mike [R-ID-2] R ID 1994-06-10 0
103-hr-4206,B000644 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 B000644 Rep. Borski, Robert A. [D-PA-3] D PA 1994-06-10 0
103-hr-4206,T000350 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 T000350 Rep. Traficant, James A., Jr. [D-OH-17] D OH 1994-06-10 0
103-hr-4206,R000243 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 R000243 Rep. Ridge, Thomas J. [R-PA-21] R PA 1994-06-10 0
103-hr-4206,C000633 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 C000633 Rep. Collins, Barbara-Rose [D-MI-15] D MI 1994-06-10 0
103-hr-4206,C000634 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 C000634 Rep. Collins, Cardiss [D-IL-7] D IL 1994-06-10 0
103-hr-4206,S000056 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 S000056 Rep. Sangmeister, George E. [D-IL-11] D IL 1994-06-10 0
103-hr-4206,S000948 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 S000948 Rep. Stokes, Louis [D-OH-11] D OH 1994-06-10 0
103-hr-4206,S001004 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 S001004 Rep. Strickland, Ted [D-OH-6] D OH 1994-06-10 0
103-hr-4206,K000270 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 K000270 Rep. Klink, Ron [D-PA-4] D PA 1994-06-10 0
103-hr-4206,M000399 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 M000399 Rep. McDade, Joseph M. [R-PA-10] R PA 1994-06-10 0
103-hr-4206,M000794 GATT Fair Trade Enforcement Act of 1994 103-hr-4206 M000794 Rep. Mineta, Norman Y. [D-CA-15] D CA 1994-04-13 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);
Powered by Datasette · Queries took 4.922ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API