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 = "98-s-243"

descending

Link	bill_id	subject
98-s-243,Flood control	A bill to authorize the implementation of a project for the prevention of flood damage on the West Branch of the Susquehanna River at Lock Haven, Pennsylvania, and for other purposes. 98-s-243	Flood control
98-s-243,Pennsylvania	A bill to authorize the implementation of a project for the prevention of flood damage on the West Branch of the Susquehanna River at Lock Haven, Pennsylvania, and for other purposes. 98-s-243	Pennsylvania
98-s-243,Rivers	A bill to authorize the implementation of a project for the prevention of flood damage on the West Branch of the Susquehanna River at Lock Haven, Pennsylvania, and for other purposes. 98-s-243	Rivers
98-s-243,Water and Water Resources Development	A bill to authorize the implementation of a project for the prevention of flood damage on the West Branch of the Susquehanna River at Lock Haven, Pennsylvania, and for other purposes. 98-s-243	Water and Water Resources Development

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