legislation_subjects

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-4366"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
97-hr-4366,Corporations and Stocks National Water Utilities Bank Act 97-hr-4366 Corporations and Stocks
97-hr-4366,Finance and Financial Sector National Water Utilities Bank Act 97-hr-4366 Finance and Financial Sector
97-hr-4366,Government corporations National Water Utilities Bank Act 97-hr-4366 Government corporations
97-hr-4366,Income tax National Water Utilities Bank Act 97-hr-4366 Income tax
97-hr-4366,Public utilities National Water Utilities Bank Act 97-hr-4366 Public utilities
97-hr-4366,Tax-exempt organizations National Water Utilities Bank Act 97-hr-4366 Tax-exempt organizations
97-hr-4366,Water and Water Resources Development National Water Utilities Bank Act 97-hr-4366 Water and Water Resources Development
97-hr-4366,Water supply National Water Utilities Bank Act 97-hr-4366 Water supply

Advanced export

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

CSV options: 

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