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

8 rows where bill_id = "93-s-4151"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
93-s-4151,Department of the Treasury A bill to establish a Strategic Energy Reserve Office in the Federal Energy Administration, to create a strategic energy reserve system to minimize the impact of interruptions or reductions of energy imports. 93-s-4151 Department of the Treasury
93-s-4151,Fuel A bill to establish a Strategic Energy Reserve Office in the Federal Energy Administration, to create a strategic energy reserve system to minimize the impact of interruptions or reductions of energy imports. 93-s-4151 Fuel
93-s-4151,Government Operations and Politics A bill to establish a Strategic Energy Reserve Office in the Federal Energy Administration, to create a strategic energy reserve system to minimize the impact of interruptions or reductions of energy imports. 93-s-4151 Government Operations and Politics
93-s-4151,Imports A bill to establish a Strategic Energy Reserve Office in the Federal Energy Administration, to create a strategic energy reserve system to minimize the impact of interruptions or reductions of energy imports. 93-s-4151 Imports
93-s-4151,National defense A bill to establish a Strategic Energy Reserve Office in the Federal Energy Administration, to create a strategic energy reserve system to minimize the impact of interruptions or reductions of energy imports. 93-s-4151 National defense
93-s-4151,Petroleum A bill to establish a Strategic Energy Reserve Office in the Federal Energy Administration, to create a strategic energy reserve system to minimize the impact of interruptions or reductions of energy imports. 93-s-4151 Petroleum
93-s-4151,Petroleum and petroleum products A bill to establish a Strategic Energy Reserve Office in the Federal Energy Administration, to create a strategic energy reserve system to minimize the impact of interruptions or reductions of energy imports. 93-s-4151 Petroleum and petroleum products
93-s-4151,Strategic materials A bill to establish a Strategic Energy Reserve Office in the Federal Energy Administration, to create a strategic energy reserve system to minimize the impact of interruptions or reductions of energy imports. 93-s-4151 Strategic materials

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