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

39 rows where bill_id = "100-hconres-142" 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 28
  • 0 11
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
100-hconres-142,L000508 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 L000508 Rep. Luken, Thomas A. [D-OH-1] D OH 1988-09-28 0
100-hconres-142,C000077 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 C000077 Rep. Campbell, Ben Nighthorse [D-CO-3] D CO 1987-06-25 0
100-hconres-142,C000312 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 C000312 Rep. Chapman, Jim [D-TX-1] D TX 1987-06-25 0
100-hconres-142,C000709 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 C000709 Rep. Conte, Silvio O. [R-MA-1] R MA 1987-06-25 0
100-hconres-142,E000250 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 E000250 Rep. Evans, Lane [D-IL-17] D IL 1987-06-25 0
100-hconres-142,H000074 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 H000074 Rep. Hall, Tony P. [D-OH-3] D OH 1987-06-25 0
100-hconres-142,M000206 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 M000206 Rep. Martinez, Matthew G. [D-CA-30] D CA 1987-06-25 0
100-hconres-142,M000249 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 M000249 Rep. Matsui, Robert T. [D-CA-3] D CA 1987-06-25 0
100-hconres-142,R000277 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 R000277 Rep. Ritter, Don [R-PA-15] R PA 1987-06-25 0
100-hconres-142,T000316 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 T000316 Rep. Torres, Esteban Edward [D-CA-34] D CA 1987-06-25 0
100-hconres-142,T000350 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 T000350 Rep. Traficant, James A., Jr. [D-OH-17] D OH 1987-06-25 0
100-hconres-142,A000069 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 A000069 Rep. Akaka, Daniel K. [D-HI-2] D HI 1987-06-17 1
100-hconres-142,A000214 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 A000214 Rep. Applegate, Douglas [D-OH-18] D OH 1987-06-17 1
100-hconres-142,B000644 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 B000644 Rep. Borski, Robert A. [D-PA-3] D PA 1987-06-17 1
100-hconres-142,B000919 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 B000919 Rep. Brown, Hank [R-CO-4] R CO 1987-06-17 1
100-hconres-142,B001172 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 B001172 Rep. Bustamante, Albert G. [D-TX-23] D TX 1987-06-17 1
100-hconres-142,D000294 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 D000294 Rep. DeWine, Mike [R-OH-7] R OH 1987-06-17 1
100-hconres-142,D000416 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 D000416 Rep. Donnelly, Brian J. [D-MA-11] D MA 1987-06-17 1
100-hconres-142,D000592 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 D000592 Rep. Dymally, Mervyn M. [D-CA-31] D CA 1987-06-17 1
100-hconres-142,D000492 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 D000492 Rep. Dreier, David [R-CA-33] R CA 1987-06-17 1
100-hconres-142,F000059 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 F000059 Rep. Feighan, Edward F. [D-OH-19] D OH 1987-06-17 1
100-hconres-142,F000339 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 F000339 Rep. Frank, Barney [D-MA-4] D MA 1987-06-17 1
100-hconres-142,G000349 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 G000349 Rep. Gradison, Willis D., Jr. [R-OH-2] R OH 1987-06-17 1
100-hconres-142,H000390 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 H000390 Rep. Hayes, James A. [D-LA-7] D LA 1987-06-17 1
100-hconres-142,H000840 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 H000840 Rep. Howard, James J. [D-NJ-3] D NJ 1987-06-17 1
100-hconres-142,K000009 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1987-06-17 1
100-hconres-142,L000020 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 L000020 Rep. Lagomarsino, Robert J. [R-CA-19] R CA 1987-06-17 1
100-hconres-142,L000116 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 L000116 Rep. Latta, Delbert L. [R-OH-5] R OH 1987-06-17 1
100-hconres-142,L000509 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 L000509 Rep. Lukens, Donald E. [R-OH-8] R OH 1987-06-17 1
100-hconres-142,M000834 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 M000834 Rep. Moakley, John Joseph [D-MA-9] D MA 1987-06-17 1
100-hconres-142,M000926 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 M000926 Rep. Moorhead, Carlos J. [R-CA-22] R CA 1987-06-17 1
100-hconres-142,O000163 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 O000163 Rep. Oxley, Michael G. [R-OH-4] R OH 1987-06-17 1
100-hconres-142,P000170 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 P000170 Rep. Pease, Donald J. [D-OH-13] D OH 1987-06-17 1
100-hconres-142,R000543 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 R000543 Rep. Russo, Martin A. [D-IL-3] D IL 1987-06-17 1
100-hconres-142,S000094 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 S000094 Rep. Sawyer, Tom [D-OH-14] D OH 1987-06-17 1
100-hconres-142,S000109 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 S000109 Rep. Schaefer, Dan [R-CO-6] R CO 1987-06-17 1
100-hconres-142,S000124 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 S000124 Rep. Scheuer, James H. [D-NY-8] D NY 1987-06-17 1
100-hconres-142,S000663 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 S000663 Rep. Snowe, Olympia J. [R-ME-2] R ME 1987-06-17 1
100-hconres-142,Y000033 A concurrent resolution expressing the opposition of Congress to mandatory coverage of all State and local government employees under the medicare program. 100-hconres-142 Y000033 Rep. Young, Don [R-AK-At Large] R AK 1987-06-17 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);