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

33 rows where bill_id = "99-hr-4818" 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 33
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hr-4818,B000392 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 B000392 Rep. Bentley, Helen Delich [R-MD-2] R MD 1986-06-24 1
99-hr-4818,B000431 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 B000431 Rep. Bevill, Tom [D-AL-4] D AL 1986-06-24 1
99-hr-4818,B000600 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 B000600 Rep. Boland, Edward P. [D-MA-2] D MA 1986-06-24 1
99-hr-4818,B000619 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 B000619 Rep. Bonior, David E. [D-MI-12] D MI 1986-06-24 1
99-hr-4818,C000178 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 C000178 Rep. Carr, Bob [D-MI-6] D MI 1986-06-24 1
99-hr-4818,C000322 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 C000322 Rep. Chappie, Eugene A. [R-CA-2] R CA 1986-06-24 1
99-hr-4818,D000038 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 D000038 Rep. Daniel, W. C. (Dan) [D-VA-5] D VA 1986-06-24 1
99-hr-4818,D000203 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 D000203 Rep. de la Garza, E. [D-TX-15] D TX 1986-06-24 1
99-hr-4818,D000209 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 D000209 Del. de Lugo, Ron [D-VI-At Large] D VI 1986-06-24 1
99-hr-4818,D000586 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 D000586 Rep. Dwyer, Bernard J. [D-NJ-6] D NJ 1986-06-24 1
99-hr-4818,E000031 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 E000031 Rep. Eckart, Dennis E. [D-OH-11] D OH 1986-06-24 1
99-hr-4818,F000215 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 F000215 Rep. Florio, James J. [D-NJ-1] D NJ 1986-06-24 1
99-hr-4818,F000235 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 F000235 Rep. Foglietta, Thomas M. [D-PA-1] D PA 1986-06-24 1
99-hr-4818,H000367 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 H000367 Rep. Hawkins, Augustus F. [D-CA-29] D CA 1986-06-24 1
99-hr-4818,H000388 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 H000388 Rep. Hayes, Charles A. [D-IL-1] D IL 1986-06-24 1
99-hr-4818,J000033 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 J000033 Rep. Jacobs, Andrew, Jr. [D-IN-10] D IN 1986-06-24 1
99-hr-4818,J000216 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 J000216 Rep. Jones, Ed [D-TN-8] D TN 1986-06-24 1
99-hr-4818,K000009 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1986-06-24 1
99-hr-4818,L000508 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 L000508 Rep. Luken, Thomas A. [D-OH-1] D OH 1986-06-24 1
99-hr-4818,M000206 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 M000206 Rep. Martinez, Matthew G. [D-CA-30] D CA 1986-06-24 1
99-hr-4818,M000702 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 M000702 Rep. Mikulski, Barbara A. [D-MD-3] D MD 1986-06-24 1
99-hr-4818,M000826 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 M000826 Rep. Mitchell, Parren J. [D-MD-7] D MD 1986-06-24 1
99-hr-4818,M000834 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 M000834 Rep. Moakley, John Joseph [D-MA-9] D MA 1986-06-24 1
99-hr-4818,N000009 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 N000009 Rep. Natcher, William H. [D-KY-2] D KY 1986-06-24 1
99-hr-4818,R000011 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 R000011 Rep. Rahall, Nick J., II [D-WV-4] D WV 1986-06-24 1
99-hr-4818,R000146 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 R000146 Rep. Reid, Harry [D-NV-1] D NV 1986-06-24 1
99-hr-4818,R000383 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 R000383 Rep. Roe, Robert A. [D-NJ-8] D NJ 1986-06-24 1
99-hr-4818,R000436 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 R000436 Rep. Rose, Charlie [D-NC-7] D NC 1986-06-24 1
99-hr-4818,S000586 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 S000586 Rep. Smith, Lawrence [D-FL-16] D FL 1986-06-24 1
99-hr-4818,T000326 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 T000326 Rep. Towns, Edolphus [D-NY-11] D NY 1986-06-24 1
99-hr-4818,T000350 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 T000350 Rep. Traficant, James A., Jr. [D-OH-17] D OH 1986-06-24 1
99-hr-4818,W000406 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 W000406 Rep. Whitehurst, G. William [R-VA-2] R VA 1986-06-24 1
99-hr-4818,Y000014 Public Safety Officers Death Benefits Amendments of 1986 99-hr-4818 Y000014 Rep. Yatron, Gus [D-PA-6] D PA 1986-06-24 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);