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

26 rows where bill_id = "105-hr-3152" 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 1

  • 0 26
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
105-hr-3152,J000174 Amy Somers Volunteers at Food Banks Act 105-hr-3152 J000174 Rep. Johnson, Sam [R-TX-3] R TX 1998-06-24 0
105-hr-3152,P000265 Amy Somers Volunteers at Food Banks Act 105-hr-3152 P000265 Rep. Petri, Thomas E. [R-WI-6] R WI 1998-06-16 0
105-hr-3152,P000583 Amy Somers Volunteers at Food Banks Act 105-hr-3152 P000583 Rep. Paul, Ron [R-TX-14] R TX 1998-06-16 0
105-hr-3152,T000326 Amy Somers Volunteers at Food Banks Act 105-hr-3152 T000326 Rep. Towns, Edolphus [D-NY-10] D NY 1998-05-12 0
105-hr-3152,D000492 Amy Somers Volunteers at Food Banks Act 105-hr-3152 D000492 Rep. Dreier, David [R-CA-28] R CA 1998-04-28 0
105-hr-3152,W000099 Amy Somers Volunteers at Food Banks Act 105-hr-3152 W000099 Rep. Walsh, James T. [R-NY-25] R NY 1998-04-28 0
105-hr-3152,L000397 Amy Somers Volunteers at Food Banks Act 105-hr-3152 L000397 Rep. Lofgren, Zoe [D-CA-16] D CA 1998-03-17 0
105-hr-3152,R000004 Amy Somers Volunteers at Food Banks Act 105-hr-3152 R000004 Rep. Radanovich, George [R-CA-19] R CA 1998-03-17 0
105-hr-3152,W000738 Amy Somers Volunteers at Food Banks Act 105-hr-3152 W000738 Rep. Woolsey, Lynn C. [D-CA-6] D CA 1998-03-05 0
105-hr-3152,T000350 Amy Somers Volunteers at Food Banks Act 105-hr-3152 T000350 Rep. Traficant, James A., Jr. [D-OH-17] D OH 1998-03-05 0
105-hr-3152,J000283 Amy Somers Volunteers at Food Banks Act 105-hr-3152 J000283 Rep. Jackson, Jesse L., Jr. [D-IL-2] D IL 1998-03-05 0
105-hr-3152,M000714 Amy Somers Volunteers at Food Banks Act 105-hr-3152 M000714 Rep. Millender-McDonald, Juanita [D-CA-37] D CA 1998-03-05 0
105-hr-3152,L000090 Amy Somers Volunteers at Food Banks Act 105-hr-3152 L000090 Rep. Lantos, Tom [D-CA-12] D CA 1998-03-05 0
105-hr-3152,B000013 Amy Somers Volunteers at Food Banks Act 105-hr-3152 B000013 Rep. Bachus, Spencer [R-AL-6] R AL 1998-03-03 0
105-hr-3152,M001134 Amy Somers Volunteers at Food Banks Act 105-hr-3152 M001134 Rep. Myrick, Sue Wilkins [R-NC-9] R NC 1998-03-03 0
105-hr-3152,W000672 Amy Somers Volunteers at Food Banks Act 105-hr-3152 W000672 Rep. Wolf, Frank R. [R-VA-10] R VA 1998-02-24 0
105-hr-3152,G000210 Amy Somers Volunteers at Food Banks Act 105-hr-3152 G000210 Rep. Gillmor, Paul E. [R-OH-5] R OH 1998-02-24 0
105-hr-3152,B000177 Amy Somers Volunteers at Food Banks Act 105-hr-3152 B000177 Rep. Barrett, Thomas M. [D-WI-5] D WI 1998-02-24 0
105-hr-3152,G000280 Amy Somers Volunteers at Food Banks Act 105-hr-3152 G000280 Rep. Goode, Virgil H., Jr. [D-VA-5] D VA 1998-02-24 0
105-hr-3152,W000215 Amy Somers Volunteers at Food Banks Act 105-hr-3152 W000215 Rep. Waxman, Henry A. [D-CA-29] D CA 1998-02-24 0
105-hr-3152,W000267 Amy Somers Volunteers at Food Banks Act 105-hr-3152 W000267 Rep. Weldon, Dave [R-FL-15] R FL 1998-02-24 0
105-hr-3152,F000010 Amy Somers Volunteers at Food Banks Act 105-hr-3152 F000010 Del. Faleomavaega, Eni F. H. [D-AS-At Large] D AS 1998-02-24 0
105-hr-3152,G000439 Amy Somers Volunteers at Food Banks Act 105-hr-3152 G000439 Rep. Greenwood, James C. [R-PA-8] R PA 1998-02-11 0
105-hr-3152,H000074 Amy Somers Volunteers at Food Banks Act 105-hr-3152 H000074 Rep. Hall, Tony P. [D-OH-3] D OH 1998-02-11 0
105-hr-3152,G000021 Amy Somers Volunteers at Food Banks Act 105-hr-3152 G000021 Rep. Gallegly, Elton [R-CA-23] R CA 1998-02-11 0
105-hr-3152,F000030 Amy Somers Volunteers at Food Banks Act 105-hr-3152 F000030 Rep. Farr, Sam [D-CA-17] D CA 1998-02-11 0

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 7.094ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API