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

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

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
97-s-3012,Business and commerce A bill to amend the Small Business Act to reduce the interest rate payable on the Federal share of certain disaster loans made under such Act. 97-s-3012 Business and commerce
97-s-3012,Disaster relief A bill to amend the Small Business Act to reduce the interest rate payable on the Federal share of certain disaster loans made under such Act. 97-s-3012 Disaster relief
97-s-3012,Disasters and Disaster Relief A bill to amend the Small Business Act to reduce the interest rate payable on the Federal share of certain disaster loans made under such Act. 97-s-3012 Disasters and Disaster Relief
97-s-3012,Government lending A bill to amend the Small Business Act to reduce the interest rate payable on the Federal share of certain disaster loans made under such Act. 97-s-3012 Government lending
97-s-3012,Small business A bill to amend the Small Business Act to reduce the interest rate payable on the Federal share of certain disaster loans made under such Act. 97-s-3012 Small business

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