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

19 rows where bill_id = "106-s-1925"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
106-s-1925,Air quality Lake Tahoe Restoration Act 106-s-1925 Air quality
106-s-1925,Animals Lake Tahoe Restoration Act 106-s-1925 Animals
106-s-1925,California Lake Tahoe Restoration Act 106-s-1925 California
106-s-1925,Congress Lake Tahoe Restoration Act 106-s-1925 Congress
106-s-1925,Congressional reporting requirements Lake Tahoe Restoration Act 106-s-1925 Congressional reporting requirements
106-s-1925,Economics and Public Finance Lake Tahoe Restoration Act 106-s-1925 Economics and Public Finance
106-s-1925,Emergency Management Lake Tahoe Restoration Act 106-s-1925 Emergency Management
106-s-1925,Energy Lake Tahoe Restoration Act 106-s-1925 Energy
106-s-1925,Environmental Protection Lake Tahoe Restoration Act 106-s-1925 Environmental Protection
106-s-1925,Environmental assessment Lake Tahoe Restoration Act 106-s-1925 Environmental assessment
106-s-1925,Environmental monitoring Lake Tahoe Restoration Act 106-s-1925 Environmental monitoring
106-s-1925,Federal aid to water pollution control Lake Tahoe Restoration Act 106-s-1925 Federal aid to water pollution control
106-s-1925,Fire departments Lake Tahoe Restoration Act 106-s-1925 Fire departments
106-s-1925,Fire prevention Lake Tahoe Restoration Act 106-s-1925 Fire prevention
106-s-1925,Fishery management Lake Tahoe Restoration Act 106-s-1925 Fishery management
106-s-1925,Forest fires Lake Tahoe Restoration Act 106-s-1925 Forest fires
106-s-1925,Forest health Lake Tahoe Restoration Act 106-s-1925 Forest health
106-s-1925,Government Operations and Politics Lake Tahoe Restoration Act 106-s-1925 Government Operations and Politics
106-s-1925,Groundwater pollution Lake Tahoe Restoration Act 106-s-1925 Groundwater pollution

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