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

11 rows where bill_id = "100-hr-5243"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-hr-5243,Dams A bill relating to the treatment of a certain project for purposes of the energy tax credit. 100-hr-5243 Dams
100-hr-5243,Energy A bill relating to the treatment of a certain project for purposes of the energy tax credit. 100-hr-5243 Energy
100-hr-5243,Energy facilities A bill relating to the treatment of a certain project for purposes of the energy tax credit. 100-hr-5243 Energy facilities
100-hr-5243,Energy policy A bill relating to the treatment of a certain project for purposes of the energy tax credit. 100-hr-5243 Energy policy
100-hr-5243,Energy tax credits A bill relating to the treatment of a certain project for purposes of the energy tax credit. 100-hr-5243 Energy tax credits
100-hr-5243,Hydroelectric power A bill relating to the treatment of a certain project for purposes of the energy tax credit. 100-hr-5243 Hydroelectric power
100-hr-5243,Idaho A bill relating to the treatment of a certain project for purposes of the energy tax credit. 100-hr-5243 Idaho
100-hr-5243,Income tax A bill relating to the treatment of a certain project for purposes of the energy tax credit. 100-hr-5243 Income tax
100-hr-5243,Investment tax credit A bill relating to the treatment of a certain project for purposes of the energy tax credit. 100-hr-5243 Investment tax credit
100-hr-5243,Tax credits A bill relating to the treatment of a certain project for purposes of the energy tax credit. 100-hr-5243 Tax credits
100-hr-5243,Water and Water Resources Development A bill relating to the treatment of a certain project for purposes of the energy tax credit. 100-hr-5243 Water and Water Resources Development

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