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

34 rows where bill_id = "109-s-2043"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
109-s-2043,Animals Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Animals
109-s-2043,Congregate housing Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Congregate housing
109-s-2043,Congress Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Congress
109-s-2043,Congressional reporting requirements Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Congressional reporting requirements
109-s-2043,Curricula Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Curricula
109-s-2043,Disabled Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Disabled
109-s-2043,Disaster relief Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Disaster relief
109-s-2043,Economics and Public Finance Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Economics and Public Finance
109-s-2043,Emergency housing Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Emergency housing
109-s-2043,Employee training Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Employee training
109-s-2043,Evacuation of civilians Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Evacuation of civilians
109-s-2043,Federal-local relations Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Federal-local relations
109-s-2043,Federal-state relations Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Federal-state relations
109-s-2043,Government Operations and Politics Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Government Operations and Politics
109-s-2043,Government publicity Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Government publicity
109-s-2043,Grants-in-aid Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Grants-in-aid
109-s-2043,Group homes Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Group homes
109-s-2043,Health Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Health
109-s-2043,Hospitals Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Hospitals
109-s-2043,Housing and Community Development Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Housing and Community Development
109-s-2043,Hurricane aftermath legislation Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Hurricane aftermath legislation
109-s-2043,Labor and Employment Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Labor and Employment
109-s-2043,Nonprofit organizations Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Nonprofit organizations
109-s-2043,Nursing homes Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Nursing homes
109-s-2043,Pets Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Pets
109-s-2043,Planning Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Planning
109-s-2043,Protection of animals Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Protection of animals
109-s-2043,Self-help devices for the disabled Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Self-help devices for the disabled
109-s-2043,Social Welfare Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Social Welfare
109-s-2043,Suburbs Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Suburbs
109-s-2043,Transportation and the aged Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Transportation and the aged
109-s-2043,Transportation and the disabled Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Transportation and the disabled
109-s-2043,Urban affairs Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Urban affairs
109-s-2043,Urban areas Mass Evacuation Exercise Assistance Act of 2005 109-s-2043 Urban areas

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