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

10 rows where bill_id = "112-s-2018"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
112-s-2018,Congressional oversight Long Island Sound Restoration and Stewardship Act 112-s-2018 Congressional oversight
112-s-2018,Connecticut Long Island Sound Restoration and Stewardship Act 112-s-2018 Connecticut
112-s-2018,Ecology Long Island Sound Restoration and Stewardship Act 112-s-2018 Ecology
112-s-2018,Environmental assessment, monitoring, research Long Island Sound Restoration and Stewardship Act 112-s-2018 Environmental assessment, monitoring, research
112-s-2018,Long Island Sound Long Island Sound Restoration and Stewardship Act 112-s-2018 Long Island Sound
112-s-2018,Marine and coastal resources, fisheries Long Island Sound Restoration and Stewardship Act 112-s-2018 Marine and coastal resources, fisheries
112-s-2018,New York State Long Island Sound Restoration and Stewardship Act 112-s-2018 New York State
112-s-2018,Water quality Long Island Sound Restoration and Stewardship Act 112-s-2018 Water quality
112-s-2018,Watersheds Long Island Sound Restoration and Stewardship Act 112-s-2018 Watersheds
112-s-2018,Wildlife conservation and habitat protection Long Island Sound Restoration and Stewardship Act 112-s-2018 Wildlife conservation and habitat protection

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