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

11 rows where bill_id = "119-s-1470"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
119-s-1470,Colorado Continental Divide National Scenic Trail Completion Act 119-s-1470 Colorado
119-s-1470,Congressional oversight Continental Divide National Scenic Trail Completion Act 119-s-1470 Congressional oversight
119-s-1470,Geography and mapping Continental Divide National Scenic Trail Completion Act 119-s-1470 Geography and mapping
119-s-1470,Idaho Continental Divide National Scenic Trail Completion Act 119-s-1470 Idaho
119-s-1470,Land transfers Continental Divide National Scenic Trail Completion Act 119-s-1470 Land transfers
119-s-1470,Land use and conservation Continental Divide National Scenic Trail Completion Act 119-s-1470 Land use and conservation
119-s-1470,Montana Continental Divide National Scenic Trail Completion Act 119-s-1470 Montana
119-s-1470,New Mexico Continental Divide National Scenic Trail Completion Act 119-s-1470 New Mexico
119-s-1470,Outdoor recreation Continental Divide National Scenic Trail Completion Act 119-s-1470 Outdoor recreation
119-s-1470,Parks, recreation areas, trails Continental Divide National Scenic Trail Completion Act 119-s-1470 Parks, recreation areas, trails
119-s-1470,Wyoming Continental Divide National Scenic Trail Completion Act 119-s-1470 Wyoming

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