openregs: legislation_subjects: 3 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

3 rows where bill_id = "98-s-3012"

descending

Link	bill_id	subject
98-s-3012,Civil engineering	A bill to authorize the Secretary of the Army, acting through the Chief of Engineers, to undertake further engineering and design of water resources development projects following the submission of a report to Congress recommending implementation. 98-s-3012	Civil engineering
98-s-3012,Public works	A bill to authorize the Secretary of the Army, acting through the Chief of Engineers, to undertake further engineering and design of water resources development projects following the submission of a report to Congress recommending implementation. 98-s-3012	Public works
98-s-3012,Water and Water Resources Development	A bill to authorize the Secretary of the Army, acting through the Chief of Engineers, to undertake further engineering and design of water resources development projects following the submission of a report to Congress recommending implementation. 98-s-3012	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);