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

24 rows where bill_id = "99-hr-5157" 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 12
  • 1 12
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hr-5157,C000293 Federal Hospital System Sharing Act of 1986 99-hr-5157 C000293 Rep. Chandler, Rod D. [R-WA-8] R WA 1986-09-25 0
99-hr-5157,P000005 Federal Hospital System Sharing Act of 1986 99-hr-5157 P000005 Rep. Packard, Ron [R-CA-43] R CA 1986-09-25 0
99-hr-5157,C000555 Federal Hospital System Sharing Act of 1986 99-hr-5157 C000555 Rep. Cobey, William W. [R-NC-4] R NC 1986-09-08 0
99-hr-5157,S000393 Federal Hospital System Sharing Act of 1986 99-hr-5157 S000393 Rep. Shumway, Norman D. [R-CA-14] R CA 1986-08-12 0
99-hr-5157,S000527 Federal Hospital System Sharing Act of 1986 99-hr-5157 S000527 Rep. Smith, Denny [R-OR-5] R OR 1986-08-12 0
99-hr-5157,G000047 Federal Hospital System Sharing Act of 1986 99-hr-5157 G000047 Rep. Garcia, Robert [D-NY-18] D NY 1986-08-05 0
99-hr-5157,D000044 Federal Hospital System Sharing Act of 1986 99-hr-5157 D000044 Rep. Dannemeyer, William E. [R-CA-39] R CA 1986-08-04 0
99-hr-5157,K000306 Federal Hospital System Sharing Act of 1986 99-hr-5157 K000306 Rep. Kolbe, Jim [R-AZ-5] R AZ 1986-08-04 0
99-hr-5157,H001022 Federal Hospital System Sharing Act of 1986 99-hr-5157 H001022 Rep. Hyde, Henry J. [R-IL-6] R IL 1986-08-04 0
99-hr-5157,F000059 Federal Hospital System Sharing Act of 1986 99-hr-5157 F000059 Rep. Feighan, Edward F. [D-OH-19] D OH 1986-07-28 0
99-hr-5157,L000020 Federal Hospital System Sharing Act of 1986 99-hr-5157 L000020 Rep. Lagomarsino, Robert J. [R-CA-19] R CA 1986-07-22 0
99-hr-5157,O000163 Federal Hospital System Sharing Act of 1986 99-hr-5157 O000163 Rep. Oxley, Michael G. [R-OH-4] R OH 1986-07-22 0
99-hr-5157,B000153 Federal Hospital System Sharing Act of 1986 99-hr-5157 B000153 Rep. Barnard, Doug, Jr. [D-GA-10] D GA 1986-07-14 1
99-hr-5157,B000204 Federal Hospital System Sharing Act of 1986 99-hr-5157 B000204 Rep. Bartlett, Steve [R-TX-3] R TX 1986-07-14 1
99-hr-5157,B000666 Federal Hospital System Sharing Act of 1986 99-hr-5157 B000666 Rep. Boulter, Beau [R-TX-13] R TX 1986-07-14 1
99-hr-5157,D000359 Federal Hospital System Sharing Act of 1986 99-hr-5157 D000359 Rep. DioGuardi, Joseph J. [R-NY-20] R NY 1986-07-14 1
99-hr-5157,G000524 Federal Hospital System Sharing Act of 1986 99-hr-5157 G000524 Rep. Gunderson, Steve [R-WI-3] R WI 1986-07-14 1
99-hr-5157,D000435 Federal Hospital System Sharing Act of 1986 99-hr-5157 D000435 Rep. Dornan, Robert K. [R-CA-38] R CA 1986-07-14 1
99-hr-5157,C000873 Federal Hospital System Sharing Act of 1986 99-hr-5157 C000873 Rep. Crane, Philip M. [R-IL-12] R IL 1986-07-14 1
99-hr-5157,J000072 Federal Hospital System Sharing Act of 1986 99-hr-5157 J000072 Rep. Jeffords, James M. [R-VT-At Large] R VT 1986-07-14 1
99-hr-5157,S000991 Federal Hospital System Sharing Act of 1986 99-hr-5157 S000991 Rep. Strang, Michael L. [R-CO-3] R CO 1986-07-14 1
99-hr-5157,F000141 Federal Hospital System Sharing Act of 1986 99-hr-5157 F000141 Rep. Fish, Hamilton, Jr. [R-NY-21] R NY 1986-07-14 1
99-hr-5157,N000016 Federal Hospital System Sharing Act of 1986 99-hr-5157 N000016 Rep. Neal, Stephen L. [D-NC-5] D NC 1986-07-14 1
99-hr-5157,S001122 Federal Hospital System Sharing Act of 1986 99-hr-5157 S001122 Rep. Swindall, Patrick L. [R-GA-4] R GA 1986-07-14 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);