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

3 rows where bill_id = "116-hr-8917"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
116-hr-8917,Historic sites and heritage areas To amend the Omnibus Parks and Public Lands Management Act of 1996 to extend the authorization of the South Carolina National Heritage Corridor, and for other purposes. 116-hr-8917 Historic sites and heritage areas
116-hr-8917,Parks, recreation areas, trails To amend the Omnibus Parks and Public Lands Management Act of 1996 to extend the authorization of the South Carolina National Heritage Corridor, and for other purposes. 116-hr-8917 Parks, recreation areas, trails
116-hr-8917,South Carolina To amend the Omnibus Parks and Public Lands Management Act of 1996 to extend the authorization of the South Carolina National Heritage Corridor, and for other purposes. 116-hr-8917 South Carolina

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