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

51 rows where bill_id = "100-hr-5409" 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 46
  • 0 5
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
100-hr-5409,H001018 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 H001018 Rep. Hutto, Earl [D-FL-1] D FL 1988-10-13 0
100-hr-5409,K000172 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 K000172 Rep. Kildee, Dale E. [D-MI-7] D MI 1988-10-13 0
100-hr-5409,G000240 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 G000240 Rep. Glickman, Dan [D-KS-4] D KS 1988-10-13 0
100-hr-5409,S000124 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 S000124 Rep. Scheuer, James H. [D-NY-8] D NY 1988-10-13 0
100-hr-5409,B000711 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 B000711 Rep. Boxer, Barbara [D-CA-6] D CA 1988-10-13 0
100-hr-5409,S001115 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 S001115 Rep. Swift, Al [D-WA-2] D WA 1988-09-28 1
100-hr-5409,J000033 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 J000033 Rep. Jacobs, Andrew, Jr. [D-IN-10] D IN 1988-09-28 1
100-hr-5409,C000809 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 C000809 Rep. Courter, Jim [R-NJ-12] R NJ 1988-09-28 1
100-hr-5409,D000209 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 D000209 Del. de Lugo, Ron [D-VI-At Large] D VI 1988-09-28 1
100-hr-5409,N000106 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 N000106 Rep. Nielson, Howard C. [R-UT-3] R UT 1988-09-28 1
100-hr-5409,Y000031 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 Y000031 Rep. Young, C. W. Bill [R-FL-8] R FL 1988-09-28 1
100-hr-5409,G000212 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 G000212 Rep. Gilman, Benjamin A. [R-NY-22] R NY 1988-09-28 1
100-hr-5409,D000267 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 D000267 Rep. Derrick, Butler C. [D-SC-3] D SC 1988-09-28 1
100-hr-5409,C000321 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 C000321 Rep. Chappell, Bill, Jr. [D-FL-4] D FL 1988-09-28 1
100-hr-5409,O000156 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 O000156 Rep. Owens, Wayne [D-UT-2] D UT 1988-09-28 1
100-hr-5409,S000673 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 S000673 Rep. Solarz, Stephen J. [D-NY-13] D NY 1988-09-28 1
100-hr-5409,B000918 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 B000918 Rep. Brown, George E., Jr. [D-CA-36] D CA 1988-09-28 1
100-hr-5409,G000047 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 G000047 Rep. Garcia, Robert [D-NY-18] D NY 1988-09-28 1
100-hr-5409,H000367 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 H000367 Rep. Hawkins, Augustus F. [D-CA-29] D CA 1988-09-28 1
100-hr-5409,S001144 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 S001144 Rep. Shays, Christopher [R-CT-4] R CT 1988-09-28 1
100-hr-5409,V000006 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 V000006 Rep. Valentine, Tim [D-NC-2] D NC 1988-09-28 1
100-hr-5409,S000749 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 S000749 Rep. Spratt, John M., Jr. [D-SC-5] D SC 1988-09-28 1
100-hr-5409,D000222 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 D000222 Rep. Dellums, Ronald V. [D-CA-8] D CA 1988-09-28 1
100-hr-5409,U000001 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 U000001 Rep. Udall, Morris K. [D-AZ-2] D AZ 1988-09-28 1
100-hr-5409,K000110 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 K000110 Rep. Kennedy, Joseph P., II [D-MA-8] D MA 1988-09-28 1
100-hr-5409,K000009 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1988-09-28 1
100-hr-5409,L000226 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 L000226 Rep. Lehman, William [D-FL-17] D FL 1988-09-28 1
100-hr-5409,O000006 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 O000006 Rep. Oberstar, James L. [D-MN-8] D MN 1988-09-28 1
100-hr-5409,S000522 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 1988-09-28 1
100-hr-5409,G000291 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 G000291 Rep. Goodling, William F. [R-PA-19] R PA 1988-09-28 1
100-hr-5409,O000159 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 O000159 Rep. Owens, Major R. [D-NY-12] D NY 1988-09-28 1
100-hr-5409,H000172 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 H000172 Rep. Hansen, James V. [R-UT-1] R UT 1988-09-28 1
100-hr-5409,A000069 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 A000069 Rep. Akaka, Daniel K. [D-HI-2] D HI 1988-09-28 1
100-hr-5409,E000250 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 E000250 Rep. Evans, Lane [D-IL-17] D IL 1988-09-28 1
100-hr-5409,B000236 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 B000236 Rep. Bates, Jim [D-CA-44] D CA 1988-09-28 1
100-hr-5409,F000046 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 F000046 Del. Fauntroy, Walter E. [D-DC-At Large] D DC 1988-09-28 1
100-hr-5409,H000388 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 H000388 Rep. Hayes, Charles A. [D-IL-1] D IL 1988-09-28 1
100-hr-5409,T000350 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 T000350 Rep. Traficant, James A., Jr. [D-OH-17] D OH 1988-09-28 1
100-hr-5409,R000465 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 R000465 Rep. Roukema, Marge [R-NJ-5] R NJ 1988-09-28 1
100-hr-5409,L000263 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 L000263 Rep. Levin, Sander M. [D-MI-17] D MI 1988-09-28 1
100-hr-5409,M000941 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 M000941 Rep. Morella, Constance A. [R-MD-8] R MD 1988-09-28 1
100-hr-5409,F000235 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 F000235 Rep. Foglietta, Thomas M. [D-PA-1] D PA 1988-09-28 1
100-hr-5409,P000005 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 P000005 Rep. Packard, Ron [R-CA-43] R CA 1988-09-28 1
100-hr-5409,P000112 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 P000112 Rep. Patterson, Elizabeth [D-SC-4] D SC 1988-09-28 1
100-hr-5409,A000226 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 A000226 Rep. Atkins, Chester G. [D-MA-5] D MA 1988-09-28 1
100-hr-5409,C000634 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 C000634 Rep. Collins, Cardiss [D-IL-7] D IL 1988-09-28 1
100-hr-5409,F000184 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 F000184 Rep. Flake, Floyd H. [D-NY-6] D NY 1988-09-28 1
100-hr-5409,W000682 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 W000682 Rep. Wolpe, Howard E. [D-MI-3] D MI 1988-09-28 1
100-hr-5409,H000514 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 H000514 Rep. Henry, Paul B. [R-MI-5] R MI 1988-09-28 1
100-hr-5409,B000798 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 B000798 Rep. Brennan, Joseph E. [D-ME-1] D ME 1988-09-28 1
100-hr-5409,W000258 Alcoholic Beverage Labeling Act of 1988 100-hr-5409 W000258 Rep. Weiss, Ted [D-NY-17] D NY 1988-09-28 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);