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

6 rows where bill_id = "105-s-2003"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
105-s-2003,Budget surpluses Notch Fairness Act of 1998 105-s-2003 Budget surpluses
105-s-2003,Deficit reduction Notch Fairness Act of 1998 105-s-2003 Deficit reduction
105-s-2003,Economics and Public Finance Notch Fairness Act of 1998 105-s-2003 Economics and Public Finance
105-s-2003,Federal budgets Notch Fairness Act of 1998 105-s-2003 Federal budgets
105-s-2003,Old age, survivors and disability insurance Notch Fairness Act of 1998 105-s-2003 Old age, survivors and disability insurance
105-s-2003,Social security beneficiaries Notch Fairness Act of 1998 105-s-2003 Social security beneficiaries

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