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

13 rows where bill_id = "114-hr-5259"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
114-hr-5259,Administrative law and regulatory procedures Certainty for States and Tribes Act 114-hr-5259 Administrative law and regulatory procedures
114-hr-5259,Advisory bodies Certainty for States and Tribes Act 114-hr-5259 Advisory bodies
114-hr-5259,Coal Certainty for States and Tribes Act 114-hr-5259 Coal
114-hr-5259,Department of the Interior Certainty for States and Tribes Act 114-hr-5259 Department of the Interior
114-hr-5259,Economic performance and conditions Certainty for States and Tribes Act 114-hr-5259 Economic performance and conditions
114-hr-5259,Energy revenues and royalties Certainty for States and Tribes Act 114-hr-5259 Energy revenues and royalties
114-hr-5259,Environmental assessment, monitoring, research Certainty for States and Tribes Act 114-hr-5259 Environmental assessment, monitoring, research
114-hr-5259,Federal-Indian relations Certainty for States and Tribes Act 114-hr-5259 Federal-Indian relations
114-hr-5259,Indian lands and resources rights Certainty for States and Tribes Act 114-hr-5259 Indian lands and resources rights
114-hr-5259,Intergovernmental relations Certainty for States and Tribes Act 114-hr-5259 Intergovernmental relations
114-hr-5259,Mining Certainty for States and Tribes Act 114-hr-5259 Mining
114-hr-5259,Oil and gas Certainty for States and Tribes Act 114-hr-5259 Oil and gas
114-hr-5259,State and local government operations Certainty for States and Tribes Act 114-hr-5259 State and local government operations

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