openregs: legislation_subjects: 8 rows where bill

CRS legislative subject terms assigned to bills, useful for filtering by topic.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

8 rows where bill_id = "117-hconres-42"

descending

Link	bill_id	subject
117-hconres-42,Civil actions and liability	Expressing the sense of Congress that governmental entities should use a portion of the proceeds from litigation against opioid manufacturers and distributors to increase participation in drug take back programs and for the safe disposal of collected, unused medicines. 117-hconres-42	Civil actions and liability
117-hconres-42,Consumer affairs	Expressing the sense of Congress that governmental entities should use a portion of the proceeds from litigation against opioid manufacturers and distributors to increase participation in drug take back programs and for the safe disposal of collected, unused medicines. 117-hconres-42	Consumer affairs
117-hconres-42,Drug trafficking and controlled substances	Expressing the sense of Congress that governmental entities should use a portion of the proceeds from litigation against opioid manufacturers and distributors to increase participation in drug take back programs and for the safe disposal of collected, unused medicines. 117-hconres-42	Drug trafficking and controlled substances
117-hconres-42,Prescription drugs	Expressing the sense of Congress that governmental entities should use a portion of the proceeds from litigation against opioid manufacturers and distributors to increase participation in drug take back programs and for the safe disposal of collected, unused medicines. 117-hconres-42	Prescription drugs
117-hconres-42,Solid waste and recycling	Expressing the sense of Congress that governmental entities should use a portion of the proceeds from litigation against opioid manufacturers and distributors to increase participation in drug take back programs and for the safe disposal of collected, unused medicines. 117-hconres-42	Solid waste and recycling
117-hconres-42,State and local finance	Expressing the sense of Congress that governmental entities should use a portion of the proceeds from litigation against opioid manufacturers and distributors to increase participation in drug take back programs and for the safe disposal of collected, unused medicines. 117-hconres-42	State and local finance
117-hconres-42,State and local government operations	Expressing the sense of Congress that governmental entities should use a portion of the proceeds from litigation against opioid manufacturers and distributors to increase participation in drug take back programs and for the safe disposal of collected, unused medicines. 117-hconres-42	State and local government operations
117-hconres-42,Transportation costs	Expressing the sense of Congress that governmental entities should use a portion of the proceeds from litigation against opioid manufacturers and distributors to increase participation in drug take back programs and for the safe disposal of collected, unused medicines. 117-hconres-42	Transportation costs

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE legislation_subjects (
    bill_id TEXT REFERENCES legislation(bill_id),
    subject TEXT,
    PRIMARY KEY (bill_id, subject)
);
CREATE INDEX idx_legsub_subject ON legislation_subjects(subject);