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

12 rows where bill_id = "106-s-3272"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
106-s-3272,Archaeology Great Basin National Heritage Area Act of 2000 106-s-3272 Archaeology
106-s-3272,Arts, Culture, Religion Great Basin National Heritage Area Act of 2000 106-s-3272 Arts, Culture, Religion
106-s-3272,Commemorations Great Basin National Heritage Area Act of 2000 106-s-3272 Commemorations
106-s-3272,Cultural property Great Basin National Heritage Area Act of 2000 106-s-3272 Cultural property
106-s-3272,Environmental Protection Great Basin National Heritage Area Act of 2000 106-s-3272 Environmental Protection
106-s-3272,Historic sites Great Basin National Heritage Area Act of 2000 106-s-3272 Historic sites
106-s-3272,History Great Basin National Heritage Area Act of 2000 106-s-3272 History
106-s-3272,Nature conservation Great Basin National Heritage Area Act of 2000 106-s-3272 Nature conservation
106-s-3272,Nevada Great Basin National Heritage Area Act of 2000 106-s-3272 Nevada
106-s-3272,Outdoor recreation Great Basin National Heritage Area Act of 2000 106-s-3272 Outdoor recreation
106-s-3272,Sports and Recreation Great Basin National Heritage Area Act of 2000 106-s-3272 Sports and Recreation
106-s-3272,Utah Great Basin National Heritage Area Act of 2000 106-s-3272 Utah

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 1.538ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy