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

4 rows where bill_id = "117-hres-337"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
117-hres-337,Commemorative events and holidays Congratulating the Department of Veterans Affairs on 75 years of psychology training and expansion of access to mental health care for veterans by expressing support for the designation of April 19 through April 23, 2021, as "VA Psychology Recognition Week". 117-hres-337 Commemorative events and holidays
117-hres-337,Health personnel Congratulating the Department of Veterans Affairs on 75 years of psychology training and expansion of access to mental health care for veterans by expressing support for the designation of April 19 through April 23, 2021, as "VA Psychology Recognition Week". 117-hres-337 Health personnel
117-hres-337,Mental health Congratulating the Department of Veterans Affairs on 75 years of psychology training and expansion of access to mental health care for veterans by expressing support for the designation of April 19 through April 23, 2021, as "VA Psychology Recognition Week". 117-hres-337 Mental health
117-hres-337,Veterans' medical care Congratulating the Department of Veterans Affairs on 75 years of psychology training and expansion of access to mental health care for veterans by expressing support for the designation of April 19 through April 23, 2021, as "VA Psychology Recognition Week". 117-hres-337 Veterans' medical care

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