home / openregs

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

17 rows where bill_id = "103-hres-372" 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 16
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hres-372,K000009 Expressing the sense of the House of Representatives concerning providing as part of health care reform financial incentives to promote worksite health promotion programs. 103-hres-372 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1994-10-04 0
103-hres-372,H000676 Expressing the sense of the House of Representatives concerning providing as part of health care reform financial incentives to promote worksite health promotion programs. 103-hres-372 H000676 Rep. Hoekstra, Peter [R-MI-2] R MI 1994-09-13 0
103-hres-372,A000210 Expressing the sense of the House of Representatives concerning providing as part of health care reform financial incentives to promote worksite health promotion programs. 103-hres-372 A000210 Rep. Andrews, Robert E. [D-NJ-1] D NJ 1994-06-21 0
103-hres-372,F000141 Expressing the sense of the House of Representatives concerning providing as part of health care reform financial incentives to promote worksite health promotion programs. 103-hres-372 F000141 Rep. Fish, Hamilton, Jr. [R-NY-19] R NY 1994-06-21 0
103-hres-372,S001045 Expressing the sense of the House of Representatives concerning providing as part of health care reform financial incentives to promote worksite health promotion programs. 103-hres-372 S001045 Rep. Stupak, Bart [D-MI-1] D MI 1994-06-21 0
103-hres-372,E000215 Expressing the sense of the House of Representatives concerning providing as part of health care reform financial incentives to promote worksite health promotion programs. 103-hres-372 E000215 Rep. Eshoo, Anna G. [D-CA-14] D CA 1994-06-09 0
103-hres-372,S000948 Expressing the sense of the House of Representatives concerning providing as part of health care reform financial incentives to promote worksite health promotion programs. 103-hres-372 S000948 Rep. Stokes, Louis [D-OH-11] D OH 1994-06-09 0
103-hres-372,C000846 Expressing the sense of the House of Representatives concerning providing as part of health care reform financial incentives to promote worksite health promotion programs. 103-hres-372 C000846 Rep. Coyne, William J. [D-PA-14] D PA 1994-04-19 0
103-hres-372,J000070 Expressing the sense of the House of Representatives concerning providing as part of health care reform financial incentives to promote worksite health promotion programs. 103-hres-372 J000070 Rep. Jefferson, William J. [D-LA-2] D LA 1994-04-19 0
103-hres-372,W000099 Expressing the sense of the House of Representatives concerning providing as part of health care reform financial incentives to promote worksite health promotion programs. 103-hres-372 W000099 Rep. Walsh, James T. [R-NY-25] R NY 1994-03-24 0
103-hres-372,S000185 Expressing the sense of the House of Representatives concerning providing as part of health care reform financial incentives to promote worksite health promotion programs. 103-hres-372 S000185 Rep. Scott, Robert C. "Bobby" [D-VA-3] D VA 1994-03-24 0
103-hres-372,K000328 Expressing the sense of the House of Representatives concerning providing as part of health care reform financial incentives to promote worksite health promotion programs. 103-hres-372 K000328 Rep. Kreidler, Mike [D-WA-9] D WA 1994-03-11 0
103-hres-372,S000477 Expressing the sense of the House of Representatives concerning providing as part of health care reform financial incentives to promote worksite health promotion programs. 103-hres-372 S000477 Rep. Slattery, Jim [D-KS-2] D KS 1994-03-11 0
103-hres-372,T000326 Expressing the sense of the House of Representatives concerning providing as part of health care reform financial incentives to promote worksite health promotion programs. 103-hres-372 T000326 Rep. Towns, Edolphus [D-NY-10] D NY 1994-03-11 0
103-hres-372,F000235 Expressing the sense of the House of Representatives concerning providing as part of health care reform financial incentives to promote worksite health promotion programs. 103-hres-372 F000235 Rep. Foglietta, Thomas M. [D-PA-1] D PA 1994-03-11 0
103-hres-372,C000243 Expressing the sense of the House of Representatives concerning providing as part of health care reform financial incentives to promote worksite health promotion programs. 103-hres-372 C000243 Rep. Castle, Michael N. [R-DE-At Large] R DE 1994-03-11 0
103-hres-372,U000031 Expressing the sense of the House of Representatives concerning providing as part of health care reform financial incentives to promote worksite health promotion programs. 103-hres-372 U000031 Rep. Upton, Fred [R-MI-6] R MI 1994-03-01 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);
Powered by Datasette · Queries took 543.102ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API