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

9 rows where bill_id = "102-s-751"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
102-s-751,Dams Tongue River Dam Authorization Act of 1990 102-s-751 Dams
102-s-751,Federal aid to water resources development Tongue River Dam Authorization Act of 1990 102-s-751 Federal aid to water resources development
102-s-751,Fishery management Tongue River Dam Authorization Act of 1990 102-s-751 Fishery management
102-s-751,Indian water rights Tongue River Dam Authorization Act of 1990 102-s-751 Indian water rights
102-s-751,Irrigation Tongue River Dam Authorization Act of 1990 102-s-751 Irrigation
102-s-751,Missouri River development Tongue River Dam Authorization Act of 1990 102-s-751 Missouri River development
102-s-751,Montana Tongue River Dam Authorization Act of 1990 102-s-751 Montana
102-s-751,Watersheds Tongue River Dam Authorization Act of 1990 102-s-751 Watersheds
102-s-751,Wildlife conservation Tongue River Dam Authorization Act of 1990 102-s-751 Wildlife conservation

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