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

16 rows where bill_id = "105-s-1145"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
105-s-1145,Earnings Social Security Information Act of 1997 105-s-1145 Earnings
105-s-1145,Economics and Public Finance Social Security Information Act of 1997 105-s-1145 Economics and Public Finance
105-s-1145,Finance and Financial Sector Social Security Information Act of 1997 105-s-1145 Finance and Financial Sector
105-s-1145,Financial statements Social Security Information Act of 1997 105-s-1145 Financial statements
105-s-1145,Government Operations and Politics Social Security Information Act of 1997 105-s-1145 Government Operations and Politics
105-s-1145,Government paperwork Social Security Information Act of 1997 105-s-1145 Government paperwork
105-s-1145,Government publicity Social Security Information Act of 1997 105-s-1145 Government publicity
105-s-1145,Government trust funds Social Security Information Act of 1997 105-s-1145 Government trust funds
105-s-1145,Inflation Social Security Information Act of 1997 105-s-1145 Inflation
105-s-1145,Interest Social Security Information Act of 1997 105-s-1145 Interest
105-s-1145,Labor and Employment Social Security Information Act of 1997 105-s-1145 Labor and Employment
105-s-1145,Old age, survivors and disability insurance Social Security Information Act of 1997 105-s-1145 Old age, survivors and disability insurance
105-s-1145,Savings bonds Social Security Information Act of 1997 105-s-1145 Savings bonds
105-s-1145,Social security beneficiaries Social Security Information Act of 1997 105-s-1145 Social security beneficiaries
105-s-1145,Social security finance Social Security Information Act of 1997 105-s-1145 Social security finance
105-s-1145,Stocks Social Security Information Act of 1997 105-s-1145 Stocks

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