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

19 rows where bill_id = "100-s-809"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-s-809,Authorization Urgent Relief for the Homeless Act 100-s-809 Authorization
100-s-809,Block grants Urgent Relief for the Homeless Act 100-s-809 Block grants
100-s-809,Department of Agriculture Urgent Relief for the Homeless Act 100-s-809 Department of Agriculture
100-s-809,Department of Health and Human Services Urgent Relief for the Homeless Act 100-s-809 Department of Health and Human Services
100-s-809,Department of Housing and Urban Development Urgent Relief for the Homeless Act 100-s-809 Department of Housing and Urban Development
100-s-809,Economics and Public Finance Urgent Relief for the Homeless Act 100-s-809 Economics and Public Finance
100-s-809,Education Urgent Relief for the Homeless Act 100-s-809 Education
100-s-809,Elementary and secondary education Urgent Relief for the Homeless Act 100-s-809 Elementary and secondary education
100-s-809,Employment and training programs Urgent Relief for the Homeless Act 100-s-809 Employment and training programs
100-s-809,Executive reorganization Urgent Relief for the Homeless Act 100-s-809 Executive reorganization
100-s-809,Families Urgent Relief for the Homeless Act 100-s-809 Families
100-s-809,Federal aid to education Urgent Relief for the Homeless Act 100-s-809 Federal aid to education
100-s-809,Federal aid to housing Urgent Relief for the Homeless Act 100-s-809 Federal aid to housing
100-s-809,Federal installations Urgent Relief for the Homeless Act 100-s-809 Federal installations
100-s-809,Fire prevention Urgent Relief for the Homeless Act 100-s-809 Fire prevention
100-s-809,Fires and Fire Fighters Urgent Relief for the Homeless Act 100-s-809 Fires and Fire Fighters
100-s-809,Food and Food Industry Urgent Relief for the Homeless Act 100-s-809 Food and Food Industry
100-s-809,Food relief Urgent Relief for the Homeless Act 100-s-809 Food relief
100-s-809,Food stamps Urgent Relief for the Homeless Act 100-s-809 Food stamps

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