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 = "97-hr-7331"

descending

Link	bill_id	subject
97-hr-7331,Income tax	A bill to amend the Internal Revenue Code of 1954 to provide financial relief to state and local governments by eliminating a requirement that would result in a duplicative mailing each year. 97-hr-7331	Income tax
97-hr-7331,Intergovernmental relations	A bill to amend the Internal Revenue Code of 1954 to provide financial relief to state and local governments by eliminating a requirement that would result in a duplicative mailing each year. 97-hr-7331	Intergovernmental relations
97-hr-7331,Intergovernmental tax relations	A bill to amend the Internal Revenue Code of 1954 to provide financial relief to state and local governments by eliminating a requirement that would result in a duplicative mailing each year. 97-hr-7331	Intergovernmental tax relations
97-hr-7331,Local and Municipal Government	A bill to amend the Internal Revenue Code of 1954 to provide financial relief to state and local governments by eliminating a requirement that would result in a duplicative mailing each year. 97-hr-7331	Local and Municipal Government
97-hr-7331,Local taxation	A bill to amend the Internal Revenue Code of 1954 to provide financial relief to state and local governments by eliminating a requirement that would result in a duplicative mailing each year. 97-hr-7331	Local taxation
97-hr-7331,State taxation	A bill to amend the Internal Revenue Code of 1954 to provide financial relief to state and local governments by eliminating a requirement that would result in a duplicative mailing each year. 97-hr-7331	State taxation
97-hr-7331,States	A bill to amend the Internal Revenue Code of 1954 to provide financial relief to state and local governments by eliminating a requirement that would result in a duplicative mailing each year. 97-hr-7331	States
97-hr-7331,Tax administration	A bill to amend the Internal Revenue Code of 1954 to provide financial relief to state and local governments by eliminating a requirement that would result in a duplicative mailing each year. 97-hr-7331	Tax administration

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