home / openregs

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

3 rows where bill_id = "118-hconres-67"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
118-hconres-67,Aging Supporting the designation of the week of September 17 through September 23, 2023, as "National Fall Prevention Awareness Week" to raise awareness about, and encourage the prevention of, falls among older adults. 118-hconres-67 Aging
118-hconres-67,Commemorative events and holidays Supporting the designation of the week of September 17 through September 23, 2023, as "National Fall Prevention Awareness Week" to raise awareness about, and encourage the prevention of, falls among older adults. 118-hconres-67 Commemorative events and holidays
118-hconres-67,Health promotion and preventive care Supporting the designation of the week of September 17 through September 23, 2023, as "National Fall Prevention Awareness Week" to raise awareness about, and encourage the prevention of, falls among older adults. 118-hconres-67 Health promotion and preventive 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);
Powered by Datasette · Queries took 2.863ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API