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

15 rows where bill_id = "95-s-3418"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
95-s-3418,Business and commerce Pacific Northwest Electric Power Planning and Conservation Act 95-s-3418 Business and commerce
95-s-3418,Costs Pacific Northwest Electric Power Planning and Conservation Act 95-s-3418 Costs
95-s-3418,Electric power Pacific Northwest Electric Power Planning and Conservation Act 95-s-3418 Electric power
95-s-3418,Electric power conservation Pacific Northwest Electric Power Planning and Conservation Act 95-s-3418 Electric power conservation
95-s-3418,Electric power distribution Pacific Northwest Electric Power Planning and Conservation Act 95-s-3418 Electric power distribution
95-s-3418,Electric power production Pacific Northwest Electric Power Planning and Conservation Act 95-s-3418 Electric power production
95-s-3418,Electric utility rates Pacific Northwest Electric Power Planning and Conservation Act 95-s-3418 Electric utility rates
95-s-3418,Energy conservation Pacific Northwest Electric Power Planning and Conservation Act 95-s-3418 Energy conservation
95-s-3418,Energy policy Pacific Northwest Electric Power Planning and Conservation Act 95-s-3418 Energy policy
95-s-3418,Federal advisory bodies Pacific Northwest Electric Power Planning and Conservation Act 95-s-3418 Federal advisory bodies
95-s-3418,Industrial development bonds Pacific Northwest Electric Power Planning and Conservation Act 95-s-3418 Industrial development bonds
95-s-3418,Northwestern States Pacific Northwest Electric Power Planning and Conservation Act 95-s-3418 Northwestern States
95-s-3418,Regional planning Pacific Northwest Electric Power Planning and Conservation Act 95-s-3418 Regional planning
95-s-3418,Renewable natural resources Pacific Northwest Electric Power Planning and Conservation Act 95-s-3418 Renewable natural resources
95-s-3418,States Pacific Northwest Electric Power Planning and Conservation Act 95-s-3418 States

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