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

10 rows where bill_id = "100-hr-4158"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-hr-4158,Consumer protection National Appliance Energy Conservation Amendments of 1988 100-hr-4158 Consumer protection
100-hr-4158,Energy conservation National Appliance Energy Conservation Amendments of 1988 100-hr-4158 Energy conservation
100-hr-4158,Energy efficiency National Appliance Energy Conservation Amendments of 1988 100-hr-4158 Energy efficiency
100-hr-4158,Energy policy National Appliance Energy Conservation Amendments of 1988 100-hr-4158 Energy policy
100-hr-4158,Federal preemption National Appliance Energy Conservation Amendments of 1988 100-hr-4158 Federal preemption
100-hr-4158,Labeling National Appliance Energy Conservation Amendments of 1988 100-hr-4158 Labeling
100-hr-4158,Lighting National Appliance Energy Conservation Amendments of 1988 100-hr-4158 Lighting
100-hr-4158,Standards National Appliance Energy Conservation Amendments of 1988 100-hr-4158 Standards
100-hr-4158,State laws National Appliance Energy Conservation Amendments of 1988 100-hr-4158 State laws
100-hr-4158,States National Appliance Energy Conservation Amendments of 1988 100-hr-4158 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);