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

42 rows where bill_id = "100-hr-4158" 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 32
  • 1 10
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
100-hr-4158,R000141 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 R000141 Rep. Regula, Ralph [R-OH-16] R OH 1988-05-24 0
100-hr-4158,T000350 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 T000350 Rep. Traficant, James A., Jr. [D-OH-17] D OH 1988-05-24 0
100-hr-4158,C000174 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 C000174 Rep. Carper, Thomas R. [D-DE-At Large] D DE 1988-05-17 0
100-hr-4158,B000153 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 B000153 Rep. Barnard, Doug, Jr. [D-GA-10] D GA 1988-05-17 0
100-hr-4158,C000462 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 C000462 Rep. Clarke, James McC. [D-NC-11] D NC 1988-05-17 0
100-hr-4158,K000009 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1988-05-17 0
100-hr-4158,S000477 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 S000477 Rep. Slattery, Jim [D-KS-2] D KS 1988-05-03 0
100-hr-4158,B000620 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 B000620 Rep. Bonker, Don [D-WA-3] D WA 1988-05-03 0
100-hr-4158,K000259 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 K000259 Rep. Kleczka, Gerald D. [D-WI-4] D WI 1988-05-03 0
100-hr-4158,S001040 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 S001040 Rep. Studds, Gerry E. [D-MA-10] D MA 1988-04-21 0
100-hr-4158,P000574 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 P000574 Rep. Pursell, Carl D. [R-MI-2] R MI 1988-04-21 0
100-hr-4158,K000172 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 K000172 Rep. Kildee, Dale E. [D-MI-7] D MI 1988-04-21 0
100-hr-4158,B000236 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 B000236 Rep. Bates, Jim [D-CA-44] D CA 1988-04-21 0
100-hr-4158,D000051 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 D000051 Rep. Darden, George (Buddy) [D-GA-7] D GA 1988-04-21 0
100-hr-4158,H000930 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 H000930 Rep. Hughes, William J. [D-NJ-2] D NJ 1988-04-21 0
100-hr-4158,N000106 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 N000106 Rep. Nielson, Howard C. [R-UT-3] R UT 1988-04-13 0
100-hr-4158,S000462 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 S000462 Rep. Skaggs, David E. [D-CO-2] D CO 1988-04-13 0
100-hr-4158,F000235 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 F000235 Rep. Foglietta, Thomas M. [D-PA-1] D PA 1988-04-13 0
100-hr-4158,W000752 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 W000752 Rep. Wortley, George C. [R-NY-27] R NY 1988-04-13 0
100-hr-4158,H000514 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 H000514 Rep. Henry, Paul B. [R-MI-5] R MI 1988-04-13 0
100-hr-4158,N000016 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 N000016 Rep. Neal, Stephen L. [D-NC-5] D NC 1988-04-13 0
100-hr-4158,B000711 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 B000711 Rep. Boxer, Barbara [D-CA-6] D CA 1988-04-13 0
100-hr-4158,F000041 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 F000041 Rep. Fascell, Dante B. [D-FL-19] D FL 1988-04-13 0
100-hr-4158,S001139 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 S001139 Rep. Synar, Mike [D-OK-2] D OK 1988-03-30 0
100-hr-4158,S000136 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 S000136 Rep. Schneider, Claudine [R-RI-2] R RI 1988-03-30 0
100-hr-4158,B000918 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 B000918 Rep. Brown, George E., Jr. [D-CA-36] D CA 1988-03-30 0
100-hr-4158,H000067 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 H000067 Rep. Hall, Ralph M. [D-TX-4] D TX 1988-03-30 0
100-hr-4158,J000265 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 J000265 Rep. Jontz, Jim [D-IN-5] D IN 1988-03-30 0
100-hr-4158,S001115 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 S001115 Rep. Swift, Al [D-WA-2] D WA 1988-03-30 0
100-hr-4158,D000586 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 D000586 Rep. Dwyer, Bernard J. [D-NJ-6] D NJ 1988-03-30 0
100-hr-4158,H000670 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 H000670 Rep. Hochbrueckner, George J. [D-NY-1] D NY 1988-03-30 0
100-hr-4158,B000971 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 B000971 Rep. Bruce, Terry L. [D-IL-19] D IL 1988-03-30 0
100-hr-4158,M000926 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 M000926 Rep. Moorhead, Carlos J. [R-CA-22] R CA 1988-03-15 1
100-hr-4158,B000997 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 B000997 Rep. Bryant, John W. [D-TX-5] D TX 1988-03-15 1
100-hr-4158,D000044 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 D000044 Rep. Dannemeyer, William E. [R-CA-39] R CA 1988-03-15 1
100-hr-4158,G000120 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 G000120 Rep. Gejdenson, Sam [D-CT-2] D CT 1988-03-15 1
100-hr-4158,L000237 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 L000237 Rep. Leland, Mickey [D-TX-18] D TX 1988-03-15 1
100-hr-4158,M000133 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 M000133 Rep. Markey, Edward J. [D-MA-7] D MA 1988-03-15 1
100-hr-4158,O000163 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 O000163 Rep. Oxley, Michael G. [R-OH-4] R OH 1988-03-15 1
100-hr-4158,R000229 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 R000229 Rep. Richardson, Bill [D-NM-3] D NM 1988-03-15 1
100-hr-4158,W000044 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 W000044 Rep. Walgren, Doug [D-PA-18] D PA 1988-03-15 1
100-hr-4158,W000779 National Appliance Energy Conservation Amendments of 1988 100-hr-4158 W000779 Rep. Wyden, Ron [D-OR-3] D OR 1988-03-15 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);