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

15 rows where bill_id = "100-s-810"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-s-810,Authorization A bill to authorize housing assistance for homeless individuals and families. 100-s-810 Authorization
100-s-810,Department of Housing and Urban Development A bill to authorize housing assistance for homeless individuals and families. 100-s-810 Department of Housing and Urban Development
100-s-810,Economics and Public Finance A bill to authorize housing assistance for homeless individuals and families. 100-s-810 Economics and Public Finance
100-s-810,Federal aid to housing A bill to authorize housing assistance for homeless individuals and families. 100-s-810 Federal aid to housing
100-s-810,Fire prevention A bill to authorize housing assistance for homeless individuals and families. 100-s-810 Fire prevention
100-s-810,Fires and Fire Fighters A bill to authorize housing assistance for homeless individuals and families. 100-s-810 Fires and Fire Fighters
100-s-810,Homeless A bill to authorize housing assistance for homeless individuals and families. 100-s-810 Homeless
100-s-810,Housing and Housing Finance A bill to authorize housing assistance for homeless individuals and families. 100-s-810 Housing and Housing Finance
100-s-810,Housing for the aged A bill to authorize housing assistance for homeless individuals and families. 100-s-810 Housing for the aged
100-s-810,Housing subsidies A bill to authorize housing assistance for homeless individuals and families. 100-s-810 Housing subsidies
100-s-810,Public Welfare and Charities A bill to authorize housing assistance for homeless individuals and families. 100-s-810 Public Welfare and Charities
100-s-810,Public assistance programs A bill to authorize housing assistance for homeless individuals and families. 100-s-810 Public assistance programs
100-s-810,Public safety A bill to authorize housing assistance for homeless individuals and families. 100-s-810 Public safety
100-s-810,Smoke detectors A bill to authorize housing assistance for homeless individuals and families. 100-s-810 Smoke detectors
100-s-810,Social Welfare A bill to authorize housing assistance for homeless individuals and families. 100-s-810 Social Welfare

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