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 = "98-s-977"

descending

Link	bill_id	subject
98-s-977,Bank holding companies	A bill to provide special rules for the application of section 4943 of the Internal Revenue Code of 1954 to any private foundation the principal asset of which is a bank holding company. 98-s-977	Bank holding companies
98-s-977,Excise tax	A bill to provide special rules for the application of section 4943 of the Internal Revenue Code of 1954 to any private foundation the principal asset of which is a bank holding company. 98-s-977	Excise tax
98-s-977,Finance and Financial Sector	A bill to provide special rules for the application of section 4943 of the Internal Revenue Code of 1954 to any private foundation the principal asset of which is a bank holding company. 98-s-977	Finance and Financial Sector
98-s-977,Foundations	A bill to provide special rules for the application of section 4943 of the Internal Revenue Code of 1954 to any private foundation the principal asset of which is a bank holding company. 98-s-977	Foundations
98-s-977,Income tax	A bill to provide special rules for the application of section 4943 of the Internal Revenue Code of 1954 to any private foundation the principal asset of which is a bank holding company. 98-s-977	Income tax
98-s-977,Tax-exempt organizations	A bill to provide special rules for the application of section 4943 of the Internal Revenue Code of 1954 to any private foundation the principal asset of which is a bank holding company. 98-s-977	Tax-exempt organizations
98-s-977,Taxation	A bill to provide special rules for the application of section 4943 of the Internal Revenue Code of 1954 to any private foundation the principal asset of which is a bank holding company. 98-s-977	Taxation

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