home / openregs

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

18 rows where bill_id = "97-s-2801"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
97-s-2801,Alaska Wilderness Protection Act of 1982 97-s-2801 Alaska
97-s-2801,Colorado Wilderness Protection Act of 1982 97-s-2801 Colorado
97-s-2801,Congress and Congressmen Wilderness Protection Act of 1982 97-s-2801 Congress and Congressmen
97-s-2801,Congressional oversight Wilderness Protection Act of 1982 97-s-2801 Congressional oversight
97-s-2801,Energy Wilderness Protection Act of 1982 97-s-2801 Energy
97-s-2801,Forests and forest products Wilderness Protection Act of 1982 97-s-2801 Forests and forest products
97-s-2801,Geothermal resources Wilderness Protection Act of 1982 97-s-2801 Geothermal resources
97-s-2801,Idaho Wilderness Protection Act of 1982 97-s-2801 Idaho
97-s-2801,Mines and mineral resources Wilderness Protection Act of 1982 97-s-2801 Mines and mineral resources
97-s-2801,Mining leases Wilderness Protection Act of 1982 97-s-2801 Mining leases
97-s-2801,National forests Wilderness Protection Act of 1982 97-s-2801 National forests
97-s-2801,Natural gas Wilderness Protection Act of 1982 97-s-2801 Natural gas
97-s-2801,New Mexico Wilderness Protection Act of 1982 97-s-2801 New Mexico
97-s-2801,Oil and gas leases Wilderness Protection Act of 1982 97-s-2801 Oil and gas leases
97-s-2801,Parks and Natural Areas Wilderness Protection Act of 1982 97-s-2801 Parks and Natural Areas
97-s-2801,Petroleum Wilderness Protection Act of 1982 97-s-2801 Petroleum
97-s-2801,Petroleum and petroleum products Wilderness Protection Act of 1982 97-s-2801 Petroleum and petroleum products
97-s-2801,Wilderness areas Wilderness Protection Act of 1982 97-s-2801 Wilderness areas

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);
Powered by Datasette · Queries took 3.122ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API