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

22 rows where bill_id = "101-hr-5589" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 0 21
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
101-hr-5589,A000103 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 A000103 Rep. Alexander, Bill [D-AR-1] D AR 1990-10-24 0
101-hr-5589,J000265 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 J000265 Rep. Jontz, Jim [D-IN-5] D IN 1990-10-23 0
101-hr-5589,C000794 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 C000794 Rep. Costello, Jerry F. [D-IL-21] D IL 1990-10-17 0
101-hr-5589,V000087 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 V000087 Rep. Vento, Bruce F. [D-MN-4] D MN 1990-10-17 0
101-hr-5589,R000053 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 R000053 Rep. Rangel, Charles B. [D-NY-16] D NY 1990-09-24 0
101-hr-5589,M000992 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 M000992 Rep. Morrison, Bruce A. [D-CT-3] D CT 1990-09-24 0
101-hr-5589,M000133 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 M000133 Rep. Markey, Edward J. [D-MA-7] D MA 1990-09-24 0
101-hr-5589,E000250 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 E000250 Rep. Evans, Lane [D-IL-17] D IL 1990-09-24 0
101-hr-5589,K000009 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1990-09-21 0
101-hr-5589,M001057 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 M001057 Rep. Mrazek, Robert J. [D-NY-3] D NY 1990-09-21 0
101-hr-5589,B000997 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 B000997 Rep. Bryant, John W. [D-TX-5] D TX 1990-09-21 0
101-hr-5589,H000547 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 H000547 Rep. Hertel, Dennis M. [D-MI-14] D MI 1990-09-21 0
101-hr-5589,H000930 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 H000930 Rep. Hughes, William J. [D-NJ-2] D NJ 1990-09-21 0
101-hr-5589,L000342 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 L000342 Rep. Lipinski, William O. [D-IL-5] D IL 1990-09-21 0
101-hr-5589,P000197 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 P000197 Rep. Pelosi, Nancy [D-CA-5] D CA 1990-09-21 0
101-hr-5589,S000477 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 S000477 Rep. Slattery, Jim [D-KS-2] D KS 1990-09-18 0
101-hr-5589,K000259 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 K000259 Rep. Kleczka, Gerald D. [D-WI-4] D WI 1990-09-18 0
101-hr-5589,R000011 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 R000011 Rep. Rahall, Nick J., II [D-WV-4] D WV 1990-09-18 0
101-hr-5589,S000810 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 S000810 Rep. Stark, Fortney Pete [D-CA-9] D CA 1990-09-18 0
101-hr-5589,C000634 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 C000634 Rep. Collins, Cardiss [D-IL-7] D IL 1990-09-18 0
101-hr-5589,G000309 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 G000309 Rep. Gordon, Bart [D-TN-6] D TN 1990-09-18 0
101-hr-5589,C000754 Medicaid Prescription Drug Fair Access and Pricing Act of 1990 101-hr-5589 C000754 Rep. Cooper, Jim [D-TN-4] D TN 1990-09-12 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 5.965ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API