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

6 rows where bill_id = "101-s-3192"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
101-s-3192,Executive reorganization A bill to amend the Water Resource Development Act of 1974 to transfer jurisdiction of the Big South Fork National River and Recreation Area from the Secretary of the Army to the Secretary of the Interior, and for other purposes. 101-s-3192 Executive reorganization
101-s-3192,Historic sites A bill to amend the Water Resource Development Act of 1974 to transfer jurisdiction of the Big South Fork National River and Recreation Area from the Secretary of the Army to the Secretary of the Interior, and for other purposes. 101-s-3192 Historic sites
101-s-3192,Kentucky A bill to amend the Water Resource Development Act of 1974 to transfer jurisdiction of the Big South Fork National River and Recreation Area from the Secretary of the Army to the Secretary of the Interior, and for other purposes. 101-s-3192 Kentucky
101-s-3192,National recreation areas A bill to amend the Water Resource Development Act of 1974 to transfer jurisdiction of the Big South Fork National River and Recreation Area from the Secretary of the Army to the Secretary of the Interior, and for other purposes. 101-s-3192 National recreation areas
101-s-3192,Rivers A bill to amend the Water Resource Development Act of 1974 to transfer jurisdiction of the Big South Fork National River and Recreation Area from the Secretary of the Army to the Secretary of the Interior, and for other purposes. 101-s-3192 Rivers
101-s-3192,Tennessee A bill to amend the Water Resource Development Act of 1974 to transfer jurisdiction of the Big South Fork National River and Recreation Area from the Secretary of the Army to the Secretary of the Interior, and for other purposes. 101-s-3192 Tennessee

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