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

5 rows where bill_id = "96-s-3012"

descending

Link	bill_id	subject
96-s-3012,Income tax	A bill to amend the Internal Revenue Code of 1954 to eliminate the requirement that the States reduce the amount of unemployment compensation payable for any week by the amount of certain retirement benefits, and for other purposes. 96-s-3012	Income tax
96-s-3012,Intergovernmental tax relations	A bill to amend the Internal Revenue Code of 1954 to eliminate the requirement that the States reduce the amount of unemployment compensation payable for any week by the amount of certain retirement benefits, and for other purposes. 96-s-3012	Intergovernmental tax relations
96-s-3012,Retirement income	A bill to amend the Internal Revenue Code of 1954 to eliminate the requirement that the States reduce the amount of unemployment compensation payable for any week by the amount of certain retirement benefits, and for other purposes. 96-s-3012	Retirement income
96-s-3012,States	A bill to amend the Internal Revenue Code of 1954 to eliminate the requirement that the States reduce the amount of unemployment compensation payable for any week by the amount of certain retirement benefits, and for other purposes. 96-s-3012	States
96-s-3012,Unemployment insurance	A bill to amend the Internal Revenue Code of 1954 to eliminate the requirement that the States reduce the amount of unemployment compensation payable for any week by the amount of certain retirement benefits, and for other purposes. 96-s-3012	Unemployment insurance

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