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

7 rows where bill_id = "116-hr-8564"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
116-hr-8564,Land use and conservation To amend the John D. Dingell, Jr. Conservation, Management, and Recreation Act to establish the Cerro de la Olla Wilderness in the Río Grande del Norte National Monument, New Mexico. 116-hr-8564 Land use and conservation
116-hr-8564,Monuments and memorials To amend the John D. Dingell, Jr. Conservation, Management, and Recreation Act to establish the Cerro de la Olla Wilderness in the Río Grande del Norte National Monument, New Mexico. 116-hr-8564 Monuments and memorials
116-hr-8564,New Mexico To amend the John D. Dingell, Jr. Conservation, Management, and Recreation Act to establish the Cerro de la Olla Wilderness in the Río Grande del Norte National Monument, New Mexico. 116-hr-8564 New Mexico
116-hr-8564,Parks, recreation areas, trails To amend the John D. Dingell, Jr. Conservation, Management, and Recreation Act to establish the Cerro de la Olla Wilderness in the Río Grande del Norte National Monument, New Mexico. 116-hr-8564 Parks, recreation areas, trails
116-hr-8564,Water use and supply To amend the John D. Dingell, Jr. Conservation, Management, and Recreation Act to establish the Cerro de la Olla Wilderness in the Río Grande del Norte National Monument, New Mexico. 116-hr-8564 Water use and supply
116-hr-8564,Wilderness and natural areas, wildlife refuges, wild rivers, habitats To amend the John D. Dingell, Jr. Conservation, Management, and Recreation Act to establish the Cerro de la Olla Wilderness in the Río Grande del Norte National Monument, New Mexico. 116-hr-8564 Wilderness and natural areas, wildlife refuges, wild rivers, habitats
116-hr-8564,Wildlife conservation and habitat protection To amend the John D. Dingell, Jr. Conservation, Management, and Recreation Act to establish the Cerro de la Olla Wilderness in the Río Grande del Norte National Monument, New Mexico. 116-hr-8564 Wildlife conservation and habitat protection

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