openregs: legislation_subjects: 7 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

7 rows where bill_id = "96-s-3151"

descending

Link	bill_id	subject
96-s-3151,Employee benefit plans	A bill to amend the Employee Retirement Income Security Act of 1974, for the purpose of waiving preemption in the case of the Hawaii Prepaid Health Care Act. 96-s-3151	Employee benefit plans
96-s-3151,Federal preemption	A bill to amend the Employee Retirement Income Security Act of 1974, for the purpose of waiving preemption in the case of the Hawaii Prepaid Health Care Act. 96-s-3151	Federal preemption
96-s-3151,Federal-state relations	A bill to amend the Employee Retirement Income Security Act of 1974, for the purpose of waiving preemption in the case of the Hawaii Prepaid Health Care Act. 96-s-3151	Federal-state relations
96-s-3151,Hawaii	A bill to amend the Employee Retirement Income Security Act of 1974, for the purpose of waiving preemption in the case of the Hawaii Prepaid Health Care Act. 96-s-3151	Hawaii
96-s-3151,Health	A bill to amend the Employee Retirement Income Security Act of 1974, for the purpose of waiving preemption in the case of the Hawaii Prepaid Health Care Act. 96-s-3151	Health
96-s-3151,Health insurance	A bill to amend the Employee Retirement Income Security Act of 1974, for the purpose of waiving preemption in the case of the Hawaii Prepaid Health Care Act. 96-s-3151	Health insurance
96-s-3151,States	A bill to amend the Employee Retirement Income Security Act of 1974, for the purpose of waiving preemption in the case of the Hawaii Prepaid Health Care Act. 96-s-3151	States

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);