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

29 rows where bill_id = "99-hr-4972" 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 22
  • 1 7
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hr-4972,S000393 Health Protection Act of 1986 99-hr-4972 S000393 Rep. Shumway, Norman D. [R-CA-14] R CA 1986-10-09 0
99-hr-4972,N000163 Health Protection Act of 1986 99-hr-4972 N000163 Rep. Nowak, Henry [D-NY-33] D NY 1986-09-23 0
99-hr-4972,B000160 Health Protection Act of 1986 99-hr-4972 B000160 Rep. Barnes, Michael D. [D-MD-8] D MD 1986-09-23 0
99-hr-4972,Y000031 Health Protection Act of 1986 99-hr-4972 Y000031 Rep. Young, C. W. Bill [R-FL-8] R FL 1986-09-23 0
99-hr-4972,T000326 Health Protection Act of 1986 99-hr-4972 T000326 Rep. Towns, Edolphus [D-NY-11] D NY 1986-08-12 0
99-hr-4972,L000226 Health Protection Act of 1986 99-hr-4972 L000226 Rep. Lehman, William [D-FL-17] D FL 1986-08-12 0
99-hr-4972,C000919 Health Protection Act of 1986 99-hr-4972 C000919 Rep. Crockett, George W., Jr. [D-MI-13] D MI 1986-07-29 0
99-hr-4972,K000307 Health Protection Act of 1986 99-hr-4972 K000307 Rep. Kolter, Joseph P. [D-PA-4] D PA 1986-07-29 0
99-hr-4972,D000222 Health Protection Act of 1986 99-hr-4972 D000222 Rep. Dellums, Ronald V. [D-CA-8] D CA 1986-07-24 0
99-hr-4972,F000046 Health Protection Act of 1986 99-hr-4972 F000046 Del. Fauntroy, Walter E. [D-DC-At Large] D DC 1986-07-24 0
99-hr-4972,P000005 Health Protection Act of 1986 99-hr-4972 P000005 Rep. Packard, Ron [R-CA-43] R CA 1986-07-24 0
99-hr-4972,B001158 Health Protection Act of 1986 99-hr-4972 B001158 Rep. Burton, Sala [D-CA-5] D CA 1986-07-24 0
99-hr-4972,H001018 Health Protection Act of 1986 99-hr-4972 H001018 Rep. Hutto, Earl [D-FL-1] D FL 1986-07-16 0
99-hr-4972,B000711 Health Protection Act of 1986 99-hr-4972 B000711 Rep. Boxer, Barbara [D-CA-6] D CA 1986-07-16 0
99-hr-4972,S000124 Health Protection Act of 1986 99-hr-4972 S000124 Rep. Scheuer, James H. [D-NY-8] D NY 1986-07-16 0
99-hr-4972,G000047 Health Protection Act of 1986 99-hr-4972 G000047 Rep. Garcia, Robert [D-NY-18] D NY 1986-07-16 0
99-hr-4972,L000342 Health Protection Act of 1986 99-hr-4972 L000342 Rep. Lipinski, William O. [D-IL-5] D IL 1986-07-16 0
99-hr-4972,L000263 Health Protection Act of 1986 99-hr-4972 L000263 Rep. Levin, Sander M. [D-MI-17] D MI 1986-07-16 0
99-hr-4972,H000367 Health Protection Act of 1986 99-hr-4972 H000367 Rep. Hawkins, Augustus F. [D-CA-29] D CA 1986-06-25 0
99-hr-4972,W000570 Health Protection Act of 1986 99-hr-4972 W000570 Rep. Wilson, Charles [D-TX-2] D TX 1986-06-25 0
99-hr-4972,S001077 Health Protection Act of 1986 99-hr-4972 S001077 Del. Sunia, Foto I. F. [D-AS-At Large] D AS 1986-06-25 0
99-hr-4972,M000860 Health Protection Act of 1986 99-hr-4972 M000860 Rep. Monson, David S. [R-UT-2] R UT 1986-06-25 0
99-hr-4972,L000486 Health Protection Act of 1986 99-hr-4972 L000486 Rep. Lowry, Mike [D-WA-7] D WA 1986-06-10 1
99-hr-4972,S001115 Health Protection Act of 1986 99-hr-4972 S001115 Rep. Swift, Al [D-WA-2] D WA 1986-06-10 1
99-hr-4972,N000106 Health Protection Act of 1986 99-hr-4972 N000106 Rep. Nielson, Howard C. [R-UT-3] R UT 1986-06-10 1
99-hr-4972,H000172 Health Protection Act of 1986 99-hr-4972 H000172 Rep. Hansen, James V. [R-UT-1] R UT 1986-06-10 1
99-hr-4972,S000997 Health Protection Act of 1986 99-hr-4972 S000997 Rep. Stratton, Samuel S. [D-NY-23] D NY 1986-06-10 1
99-hr-4972,S001040 Health Protection Act of 1986 99-hr-4972 S001040 Rep. Studds, Gerry E. [D-MA-10] D MA 1986-06-10 1
99-hr-4972,A000226 Health Protection Act of 1986 99-hr-4972 A000226 Rep. Atkins, Chester G. [D-MA-5] D MA 1986-06-10 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);