openregs: legislation_subjects: 4 rows where bill

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 = "118-hconres-78"

descending

Link	bill_id	subject
118-hconres-78,Commemorative events and holidays	Expressing the sense of Congress that public health professionals should be commended for their dedication and service to the United States on Public Health Thank You Day, November 20, 2023. 118-hconres-78	Commemorative events and holidays
118-hconres-78,Congressional tributes	Expressing the sense of Congress that public health professionals should be commended for their dedication and service to the United States on Public Health Thank You Day, November 20, 2023. 118-hconres-78	Congressional tributes
118-hconres-78,Health personnel	Expressing the sense of Congress that public health professionals should be commended for their dedication and service to the United States on Public Health Thank You Day, November 20, 2023. 118-hconres-78	Health personnel
118-hconres-78,World health	Expressing the sense of Congress that public health professionals should be commended for their dedication and service to the United States on Public Health Thank You Day, November 20, 2023. 118-hconres-78	World health

Advanced export

JSON shape: default, array, newline-delimited, object

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