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 = "94-s-3889"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
94-s-3889,Armed Forces and National Security Department of the Environment and Oceans Act 94-s-3889 Armed Forces and National Security
94-s-3889,Army Corps of Engineers Department of the Environment and Oceans Act 94-s-3889 Army Corps of Engineers
94-s-3889,Department of Commerce Department of the Environment and Oceans Act 94-s-3889 Department of Commerce
94-s-3889,Department of Transportation Department of the Environment and Oceans Act 94-s-3889 Department of Transportation
94-s-3889,Department of the Interior Department of the Environment and Oceans Act 94-s-3889 Department of the Interior
94-s-3889,Environmental Protection Department of the Environment and Oceans Act 94-s-3889 Environmental Protection
94-s-3889,Environmental Protection Agency Department of the Environment and Oceans Act 94-s-3889 Environmental Protection Agency
94-s-3889,Government Operations and Politics Department of the Environment and Oceans Act 94-s-3889 Government Operations and Politics
94-s-3889,Independent regulatory commissions Department of the Environment and Oceans Act 94-s-3889 Independent regulatory commissions
94-s-3889,Ocean Department of the Environment and Oceans Act 94-s-3889 Ocean

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