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

5 rows where bill_id = "97-s-28"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
97-s-28,Dams A bill to terminate the authorizations for Lafayette Dam and Reservoir, Big Pine Dam and Reservoir, Clify Creek Dam and Reservoir and the Big Blue Dam and Reservoir in the State of Indiana. 97-s-28 Dams
97-s-28,Flood control A bill to terminate the authorizations for Lafayette Dam and Reservoir, Big Pine Dam and Reservoir, Clify Creek Dam and Reservoir and the Big Blue Dam and Reservoir in the State of Indiana. 97-s-28 Flood control
97-s-28,Indiana A bill to terminate the authorizations for Lafayette Dam and Reservoir, Big Pine Dam and Reservoir, Clify Creek Dam and Reservoir and the Big Blue Dam and Reservoir in the State of Indiana. 97-s-28 Indiana
97-s-28,Reservoirs A bill to terminate the authorizations for Lafayette Dam and Reservoir, Big Pine Dam and Reservoir, Clify Creek Dam and Reservoir and the Big Blue Dam and Reservoir in the State of Indiana. 97-s-28 Reservoirs
97-s-28,Water and Water Resources Development A bill to terminate the authorizations for Lafayette Dam and Reservoir, Big Pine Dam and Reservoir, Clify Creek Dam and Reservoir and the Big Blue Dam and Reservoir in the State of Indiana. 97-s-28 Water and Water Resources Development

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