home / openregs

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 = "107-hr-2331"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
107-hr-2331,Auctions Energy Market Monitoring Act 107-hr-2331 Auctions
107-hr-2331,Business records Energy Market Monitoring Act 107-hr-2331 Business records
107-hr-2331,Commerce Energy Market Monitoring Act 107-hr-2331 Commerce
107-hr-2331,Congress Energy Market Monitoring Act 107-hr-2331 Congress
107-hr-2331,Congressional investigations Energy Market Monitoring Act 107-hr-2331 Congressional investigations
107-hr-2331,Congressional oversight Energy Market Monitoring Act 107-hr-2331 Congressional oversight
107-hr-2331,Congressional-executive relations Energy Market Monitoring Act 107-hr-2331 Congressional-executive relations
107-hr-2331,Department of Energy Energy Market Monitoring Act 107-hr-2331 Department of Energy
107-hr-2331,Energy demand Energy Market Monitoring Act 107-hr-2331 Energy demand
107-hr-2331,Energy industries Energy Market Monitoring Act 107-hr-2331 Energy industries
107-hr-2331,Energy prices Energy Market Monitoring Act 107-hr-2331 Energy prices
107-hr-2331,Energy supplies Energy Market Monitoring Act 107-hr-2331 Energy supplies
107-hr-2331,Environmental Protection Energy Market Monitoring Act 107-hr-2331 Environmental Protection
107-hr-2331,Environmental assessment Energy Market Monitoring Act 107-hr-2331 Environmental assessment
107-hr-2331,Federal Energy Regulatory Commission Energy Market Monitoring Act 107-hr-2331 Federal Energy Regulatory Commission
107-hr-2331,Government Operations and Politics Energy Market Monitoring Act 107-hr-2331 Government Operations and Politics
107-hr-2331,Independent regulatory commissions Energy Market Monitoring Act 107-hr-2331 Independent regulatory commissions
107-hr-2331,Law Energy Market Monitoring Act 107-hr-2331 Law
107-hr-2331,Subpoena Energy Market Monitoring Act 107-hr-2331 Subpoena

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);
Powered by Datasette · Queries took 1.367ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy