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-2139"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
106-s-2139,Agricultural pollution Timber and Agriculture Environmental Fairness Act 106-s-2139 Agricultural pollution
106-s-2139,Agricultural runoff Timber and Agriculture Environmental Fairness Act 106-s-2139 Agricultural runoff
106-s-2139,Agriculture and Food Timber and Agriculture Environmental Fairness Act 106-s-2139 Agriculture and Food
106-s-2139,Aquaculture Timber and Agriculture Environmental Fairness Act 106-s-2139 Aquaculture
106-s-2139,Drainage Timber and Agriculture Environmental Fairness Act 106-s-2139 Drainage
106-s-2139,Emergency Management Timber and Agriculture Environmental Fairness Act 106-s-2139 Emergency Management
106-s-2139,Fire prevention Timber and Agriculture Environmental Fairness Act 106-s-2139 Fire prevention
106-s-2139,Forest fires Timber and Agriculture Environmental Fairness Act 106-s-2139 Forest fires
106-s-2139,Forest management Timber and Agriculture Environmental Fairness Act 106-s-2139 Forest management
106-s-2139,Forest roads Timber and Agriculture Environmental Fairness Act 106-s-2139 Forest roads
106-s-2139,Highway maintenance Timber and Agriculture Environmental Fairness Act 106-s-2139 Highway maintenance
106-s-2139,Infrastructure Timber and Agriculture Environmental Fairness Act 106-s-2139 Infrastructure
106-s-2139,Law Timber and Agriculture Environmental Fairness Act 106-s-2139 Law
106-s-2139,Licenses Timber and Agriculture Environmental Fairness Act 106-s-2139 Licenses
106-s-2139,Nurseries (Horticulture) Timber and Agriculture Environmental Fairness Act 106-s-2139 Nurseries (Horticulture)
106-s-2139,Pest control Timber and Agriculture Environmental Fairness Act 106-s-2139 Pest control
106-s-2139,Public Lands and Natural Resources Timber and Agriculture Environmental Fairness Act 106-s-2139 Public Lands and Natural Resources
106-s-2139,Range management Timber and Agriculture Environmental Fairness Act 106-s-2139 Range management
106-s-2139,Reforestation Timber and Agriculture Environmental Fairness Act 106-s-2139 Reforestation

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