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

31 rows where bill_id = "100-hr-5337" 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 31
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
100-hr-5337,H000114 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 H000114 Rep. Hamilton, Lee H. [D-IN-9] D IN 1988-09-22 1
100-hr-5337,B000890 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 B000890 Rep. Broomfield, William S. [R-MI-18] R MI 1988-09-22 1
100-hr-5337,L000090 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 L000090 Rep. Lantos, Tom [D-CA-11] D CA 1988-09-22 1
100-hr-5337,B000410 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 B000410 Rep. Berman, Howard L. [D-CA-26] D CA 1988-09-22 1
100-hr-5337,G000212 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 G000212 Rep. Gilman, Benjamin A. [R-NY-22] R NY 1988-09-22 1
100-hr-5337,Y000014 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 Y000014 Rep. Yatron, Gus [D-PA-6] D PA 1988-09-22 1
100-hr-5337,S000673 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 S000673 Rep. Solarz, Stephen J. [D-NY-13] D NY 1988-09-22 1
100-hr-5337,S001040 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 S001040 Rep. Studds, Gerry E. [D-MA-10] D MA 1988-09-22 1
100-hr-5337,M000688 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 M000688 Rep. Mica, Daniel Andrew [D-FL-14] D FL 1988-09-22 1
100-hr-5337,W000682 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 W000682 Rep. Wolpe, Howard E. [D-MI-3] D MI 1988-09-22 1
100-hr-5337,K000319 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 K000319 Rep. Kostmayer, Peter H. [D-PA-8] D PA 1988-09-22 1
100-hr-5337,T000317 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 T000317 Rep. Torricelli, Robert G. [D-NJ-9] D NJ 1988-09-22 1
100-hr-5337,S000586 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 S000586 Rep. Smith, Lawrence [D-FL-16] D FL 1988-09-22 1
100-hr-5337,L000264 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 L000264 Rep. Levine, Mel [D-CA-27] D CA 1988-09-22 1
100-hr-5337,F000059 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 F000059 Rep. Feighan, Edward F. [D-OH-19] D OH 1988-09-22 1
100-hr-5337,W000258 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 W000258 Rep. Weiss, Ted [D-NY-17] D NY 1988-09-22 1
100-hr-5337,A000022 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 A000022 Rep. Ackerman, Gary L. [D-NY-7] D NY 1988-09-22 1
100-hr-5337,A000226 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 A000226 Rep. Atkins, Chester G. [D-MA-5] D MA 1988-09-22 1
100-hr-5337,C000462 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 C000462 Rep. Clarke, James McC. [D-NC-11] D NC 1988-09-22 1
100-hr-5337,F000435 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 F000435 Resident Commissioner Fuster, Jamie B. [D-PR-At Large] D PR 1988-09-22 1
100-hr-5337,B000462 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 B000462 Rep. Bilbray, James H. [D-NV-1] D NV 1988-09-22 1
100-hr-5337,L000020 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 L000020 Rep. Lagomarsino, Robert J. [R-CA-19] R CA 1988-09-22 1
100-hr-5337,L000169 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 L000169 Rep. Leach, James A. [R-IA-1] R IA 1988-09-22 1
100-hr-5337,S000663 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 S000663 Rep. Snowe, Olympia J. [R-ME-2] R ME 1988-09-22 1
100-hr-5337,H001022 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 H001022 Rep. Hyde, Henry J. [R-IL-6] R IL 1988-09-22 1
100-hr-5337,S000675 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 S000675 Rep. Solomon, Gerald B. H. [R-NY-24] R NY 1988-09-22 1
100-hr-5337,D000435 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 D000435 Rep. Dornan, Robert K. [R-CA-38] R CA 1988-09-22 1
100-hr-5337,S000522 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 1988-09-22 1
100-hr-5337,M000019 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 M000019 Rep. Mack, Connie, III [R-FL-13] R FL 1988-09-22 1
100-hr-5337,M000736 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 M000736 Rep. Miller, John R. [R-WA-1] R WA 1988-09-22 1
100-hr-5337,B000551 Sanctions Against Iraqi Chemical Weapons Use Act 100-hr-5337 B000551 Del. Blaz, Ben G. [R-GU-At Large] R GU 1988-09-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);
Powered by Datasette · Queries took 8.916ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API