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

20 rows where bill_id = "119-s-1787"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
119-s-1787,Advisory bodies Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Advisory bodies
119-s-1787,Colorado Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Colorado
119-s-1787,Congressional oversight Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Congressional oversight
119-s-1787,Dams and canals Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Dams and canals
119-s-1787,Forests, forestry, trees Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Forests, forestry, trees
119-s-1787,Government information and archives Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Government information and archives
119-s-1787,Hunting and fishing Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Hunting and fishing
119-s-1787,Indian lands and resources rights Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Indian lands and resources rights
119-s-1787,Lakes and rivers Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Lakes and rivers
119-s-1787,Land transfers Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Land transfers
119-s-1787,Land use and conservation Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Land use and conservation
119-s-1787,Livestock Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Livestock
119-s-1787,Motor vehicles Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Motor vehicles
119-s-1787,Outdoor recreation Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Outdoor recreation
119-s-1787,Roads and highways Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Roads and highways
119-s-1787,Water storage Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Water storage
119-s-1787,Water use and supply Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Water use and supply
119-s-1787,Watersheds Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Watersheds
119-s-1787,Wilderness and natural areas, wildlife refuges, wild rivers, habitats Dolores River National Conservation Area and Special Management Area Act 119-s-1787 Wilderness and natural areas, wildlife refuges, wild rivers, habitats
119-s-1787,Wildlife conservation and habitat protection Dolores River National Conservation Area and Special Management Area Act 119-s-1787 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);