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

10 rows where bill_id = "116-hr-9057"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
116-hr-9057,Aging Improving Care for Vulnerable Older Citizens and People with Disabilities through Workforce Advancement Act of 2020 116-hr-9057 Aging
116-hr-9057,Disability and paralysis Improving Care for Vulnerable Older Citizens and People with Disabilities through Workforce Advancement Act of 2020 116-hr-9057 Disability and paralysis
116-hr-9057,Health care costs and insurance Improving Care for Vulnerable Older Citizens and People with Disabilities through Workforce Advancement Act of 2020 116-hr-9057 Health care costs and insurance
116-hr-9057,Health care quality Improving Care for Vulnerable Older Citizens and People with Disabilities through Workforce Advancement Act of 2020 116-hr-9057 Health care quality
116-hr-9057,Health facilities and institutions Improving Care for Vulnerable Older Citizens and People with Disabilities through Workforce Advancement Act of 2020 116-hr-9057 Health facilities and institutions
116-hr-9057,Health personnel Improving Care for Vulnerable Older Citizens and People with Disabilities through Workforce Advancement Act of 2020 116-hr-9057 Health personnel
116-hr-9057,Health programs administration and funding Improving Care for Vulnerable Older Citizens and People with Disabilities through Workforce Advancement Act of 2020 116-hr-9057 Health programs administration and funding
116-hr-9057,Home and outpatient care Improving Care for Vulnerable Older Citizens and People with Disabilities through Workforce Advancement Act of 2020 116-hr-9057 Home and outpatient care
116-hr-9057,Long-term, rehabilitative, and terminal care Improving Care for Vulnerable Older Citizens and People with Disabilities through Workforce Advancement Act of 2020 116-hr-9057 Long-term, rehabilitative, and terminal care
116-hr-9057,Medicaid Improving Care for Vulnerable Older Citizens and People with Disabilities through Workforce Advancement Act of 2020 116-hr-9057 Medicaid

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