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

47 rows where bill_id = "99-hr-4723" 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 46
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hr-4723,H000067 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 H000067 Rep. Hall, Ralph M. [D-TX-4] D TX 1986-10-15 0
99-hr-4723,W000258 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 W000258 Rep. Weiss, Ted [D-NY-17] D NY 1986-10-14 0
99-hr-4723,K000322 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 K000322 Rep. Kramer, Ken [R-CO-5] R CO 1986-10-14 0
99-hr-4723,L000516 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 L000516 Rep. Lundine, Stanley N. [D-NY-34] D NY 1986-09-16 0
99-hr-4723,K000172 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 K000172 Rep. Kildee, Dale E. [D-MI-7] D MI 1986-09-16 0
99-hr-4723,L000274 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 L000274 Rep. Lewis, Jerry [R-CA-35] R CA 1986-09-16 0
99-hr-4723,T000326 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 T000326 Rep. Towns, Edolphus [D-NY-11] D NY 1986-09-16 0
99-hr-4723,F000046 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 F000046 Del. Fauntroy, Walter E. [D-DC-At Large] D DC 1986-09-16 0
99-hr-4723,B000918 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 B000918 Rep. Brown, George E., Jr. [D-CA-36] D CA 1986-09-16 0
99-hr-4723,W000426 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 W000426 Rep. Whittaker, Bob [R-KS-5] R KS 1986-08-15 0
99-hr-4723,A000189 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 A000189 Rep. Anderson, Glenn M. [D-CA-32] D CA 1986-08-15 0
99-hr-4723,U000001 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 U000001 Rep. Udall, Morris K. [D-AZ-2] D AZ 1986-08-15 0
99-hr-4723,P000047 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 P000047 Rep. Panetta, Leon [D-CA-16] D CA 1986-08-15 0
99-hr-4723,L000447 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 L000447 Rep. Lott, Trent [R-MS-5] R MS 1986-08-15 0
99-hr-4723,B000644 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 B000644 Rep. Borski, Robert A. [D-PA-3] D PA 1986-07-29 0
99-hr-4723,H000514 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 H000514 Rep. Henry, Paul B. [R-MI-5] R MI 1986-07-29 0
99-hr-4723,C000919 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 C000919 Rep. Crockett, George W., Jr. [D-MI-13] D MI 1986-07-29 0
99-hr-4723,K000016 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 K000016 Rep. Kasich, John R. [R-OH-12] R OH 1986-07-29 0
99-hr-4723,M000206 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 M000206 Rep. Martinez, Matthew G. [D-CA-30] D CA 1986-07-29 0
99-hr-4723,M000860 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 M000860 Rep. Monson, David S. [R-UT-2] R UT 1986-07-29 0
99-hr-4723,S000136 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 S000136 Rep. Schneider, Claudine [R-RI-2] R RI 1986-07-29 0
99-hr-4723,B000586 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 B000586 Rep. Boehlert, Sherwood [R-NY-25] R NY 1986-07-29 0
99-hr-4723,M000702 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 M000702 Rep. Mikulski, Barbara A. [D-MD-3] D MD 1986-07-17 0
99-hr-4723,F000053 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 F000053 Rep. Fazio, Vic [D-CA-4] D CA 1986-07-17 0
99-hr-4723,M000117 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 M000117 Rep. Manton, Thomas J. [D-NY-9] D NY 1986-07-17 0
99-hr-4723,B000392 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 B000392 Rep. Bentley, Helen Delich [R-MD-2] R MD 1986-07-17 0
99-hr-4723,S000142 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 S000142 Rep. Schroeder, Patricia [D-CO-1] D CO 1986-07-17 0
99-hr-4723,B000160 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 B000160 Rep. Barnes, Michael D. [D-MD-8] D MD 1986-07-17 0
99-hr-4723,M000826 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 M000826 Rep. Mitchell, Parren J. [D-MD-7] D MD 1986-07-17 0
99-hr-4723,L000237 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 L000237 Rep. Leland, Mickey [D-TX-18] D TX 1986-07-17 0
99-hr-4723,G000025 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 G000025 Rep. Gallo, Dean A. [R-NJ-11] R NJ 1986-07-17 0
99-hr-4723,L000508 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 L000508 Rep. Luken, Thomas A. [D-OH-1] D OH 1986-07-17 0
99-hr-4723,R000383 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 R000383 Rep. Roe, Robert A. [D-NJ-8] D NJ 1986-06-26 0
99-hr-4723,S001139 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 S001139 Rep. Synar, Mike [D-OK-2] D OK 1986-06-25 0
99-hr-4723,K000319 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 K000319 Rep. Kostmayer, Peter H. [D-PA-8] D PA 1986-06-25 0
99-hr-4723,W000752 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 W000752 Rep. Wortley, George C. [R-NY-27] R NY 1986-06-25 0
99-hr-4723,M001130 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 M001130 Rep. Myers, John T. [R-IN-7] R IN 1986-06-25 0
99-hr-4723,W000570 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 W000570 Rep. Wilson, Charles [D-TX-2] D TX 1986-06-25 0
99-hr-4723,R000229 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 R000229 Rep. Richardson, Bill [D-NM-3] D NM 1986-06-04 0
99-hr-4723,H000797 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 H000797 Rep. Horton, Frank J. [R-NY-29] R NY 1986-06-04 0
99-hr-4723,M001088 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 M001088 Rep. Murphy, Austin J. [D-PA-22] D PA 1986-06-04 0
99-hr-4723,F000141 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 F000141 Rep. Fish, Hamilton, Jr. [R-NY-21] R NY 1986-06-04 0
99-hr-4723,H000114 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 H000114 Rep. Hamilton, Lee H. [D-IN-9] D IN 1986-06-04 0
99-hr-4723,M001057 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 M001057 Rep. Mrazek, Robert J. [D-NY-3] D NY 1986-06-04 0
99-hr-4723,C000634 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 C000634 Rep. Collins, Cardiss [D-IL-7] D IL 1986-06-04 0
99-hr-4723,F000215 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 F000215 Rep. Florio, James J. [D-NJ-1] D NJ 1986-06-04 0
99-hr-4723,W000779 President's Council on Health Promotion and Disease Prevention Act of 1986 99-hr-4723 W000779 Rep. Wyden, Ron [D-OR-3] D OR 1986-04-30 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);