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

16 rows where bill_id = "111-s-3752"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
111-s-3752,Administrative law and regulatory procedures Indian Energy Parity Act of 2010 111-s-3752 Administrative law and regulatory procedures
111-s-3752,Alternative and renewable resources Indian Energy Parity Act of 2010 111-s-3752 Alternative and renewable resources
111-s-3752,Department of Energy Indian Energy Parity Act of 2010 111-s-3752 Department of Energy
111-s-3752,Electric power generation and transmission Indian Energy Parity Act of 2010 111-s-3752 Electric power generation and transmission
111-s-3752,Employment and training programs Indian Energy Parity Act of 2010 111-s-3752 Employment and training programs
111-s-3752,Energy efficiency and conservation Indian Energy Parity Act of 2010 111-s-3752 Energy efficiency and conservation
111-s-3752,Energy storage, supplies, demand Indian Energy Parity Act of 2010 111-s-3752 Energy storage, supplies, demand
111-s-3752,Federal-Indian relations Indian Energy Parity Act of 2010 111-s-3752 Federal-Indian relations
111-s-3752,Forests, forestry, trees Indian Energy Parity Act of 2010 111-s-3752 Forests, forestry, trees
111-s-3752,Government lending and loan guarantees Indian Energy Parity Act of 2010 111-s-3752 Government lending and loan guarantees
111-s-3752,Indian lands and resources rights Indian Energy Parity Act of 2010 111-s-3752 Indian lands and resources rights
111-s-3752,Licensing and registrations Indian Energy Parity Act of 2010 111-s-3752 Licensing and registrations
111-s-3752,Mining Indian Energy Parity Act of 2010 111-s-3752 Mining
111-s-3752,Oil and gas Indian Energy Parity Act of 2010 111-s-3752 Oil and gas
111-s-3752,Residential rehabilitation and home repair Indian Energy Parity Act of 2010 111-s-3752 Residential rehabilitation and home repair
111-s-3752,User charges and fees Indian Energy Parity Act of 2010 111-s-3752 User charges and fees

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