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

12 rows where bill_id = "99-s-2188"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
99-s-2188,Advisory bodies Electric Generation and Industrial Energy Development Act of 1986 99-s-2188 Advisory bodies
99-s-2188,Coal Electric Generation and Industrial Energy Development Act of 1986 99-s-2188 Coal
99-s-2188,Coal-fired power plants Electric Generation and Industrial Energy Development Act of 1986 99-s-2188 Coal-fired power plants
99-s-2188,Department of Energy Electric Generation and Industrial Energy Development Act of 1986 99-s-2188 Department of Energy
99-s-2188,Electric power production Electric Generation and Industrial Energy Development Act of 1986 99-s-2188 Electric power production
99-s-2188,Energy facilities Electric Generation and Industrial Energy Development Act of 1986 99-s-2188 Energy facilities
99-s-2188,Executive reorganization Electric Generation and Industrial Energy Development Act of 1986 99-s-2188 Executive reorganization
99-s-2188,Federal advisory bodies Electric Generation and Industrial Energy Development Act of 1986 99-s-2188 Federal advisory bodies
99-s-2188,Fuel Electric Generation and Industrial Energy Development Act of 1986 99-s-2188 Fuel
99-s-2188,Mines and mineral resources Electric Generation and Industrial Energy Development Act of 1986 99-s-2188 Mines and mineral resources
99-s-2188,Research and development Electric Generation and Industrial Energy Development Act of 1986 99-s-2188 Research and development
99-s-2188,Technological innovations Electric Generation and Industrial Energy Development Act of 1986 99-s-2188 Technological innovations

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