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 = "110-hr-6830"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
110-hr-6830,Administrative law and regulatory procedures Healthy Forests, Healthy Planet Act of 2008 110-hr-6830 Administrative law and regulatory procedures
110-hr-6830,Alternative and renewable resources Healthy Forests, Healthy Planet Act of 2008 110-hr-6830 Alternative and renewable resources
110-hr-6830,Climate change and greenhouse gases Healthy Forests, Healthy Planet Act of 2008 110-hr-6830 Climate change and greenhouse gases
110-hr-6830,Ecology Healthy Forests, Healthy Planet Act of 2008 110-hr-6830 Ecology
110-hr-6830,Electric power generation and transmission Healthy Forests, Healthy Planet Act of 2008 110-hr-6830 Electric power generation and transmission
110-hr-6830,Executive agency funding and structure Healthy Forests, Healthy Planet Act of 2008 110-hr-6830 Executive agency funding and structure
110-hr-6830,Forests, forestry, trees Healthy Forests, Healthy Planet Act of 2008 110-hr-6830 Forests, forestry, trees
110-hr-6830,Income tax credits Healthy Forests, Healthy Planet Act of 2008 110-hr-6830 Income tax credits
110-hr-6830,Land use and conservation Healthy Forests, Healthy Planet Act of 2008 110-hr-6830 Land use and conservation
110-hr-6830,Performance measurement Healthy Forests, Healthy Planet Act of 2008 110-hr-6830 Performance measurement
110-hr-6830,Public-private cooperation Healthy Forests, Healthy Planet Act of 2008 110-hr-6830 Public-private cooperation

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