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

12 rows where bill_id = "117-s-4423"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
117-s-4423,Advisory bodies Tribal Cultural Areas Protection Act 117-s-4423 Advisory bodies
117-s-4423,Federal-Indian relations Tribal Cultural Areas Protection Act 117-s-4423 Federal-Indian relations
117-s-4423,Historic sites and heritage areas Tribal Cultural Areas Protection Act 117-s-4423 Historic sites and heritage areas
117-s-4423,Historical and cultural resources Tribal Cultural Areas Protection Act 117-s-4423 Historical and cultural resources
117-s-4423,Indian lands and resources rights Tribal Cultural Areas Protection Act 117-s-4423 Indian lands and resources rights
117-s-4423,Indian social and development programs Tribal Cultural Areas Protection Act 117-s-4423 Indian social and development programs
117-s-4423,Land transfers Tribal Cultural Areas Protection Act 117-s-4423 Land transfers
117-s-4423,Land use and conservation Tribal Cultural Areas Protection Act 117-s-4423 Land use and conservation
117-s-4423,Livestock Tribal Cultural Areas Protection Act 117-s-4423 Livestock
117-s-4423,Motor vehicles Tribal Cultural Areas Protection Act 117-s-4423 Motor vehicles
117-s-4423,Parks, recreation areas, trails Tribal Cultural Areas Protection Act 117-s-4423 Parks, recreation areas, trails
117-s-4423,Wilderness and natural areas, wildlife refuges, wild rivers, habitats Tribal Cultural Areas Protection Act 117-s-4423 Wilderness and natural areas, wildlife refuges, wild rivers, habitats

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