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

9 rows where bill_id = "114-hr-5756"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
114-hr-5756,Academic performance and assessments Degrees Not Debt Act 114-hr-5756 Academic performance and assessments
114-hr-5756,Education of the disadvantaged Degrees Not Debt Act 114-hr-5756 Education of the disadvantaged
114-hr-5756,Education programs funding Degrees Not Debt Act 114-hr-5756 Education programs funding
114-hr-5756,Government information and archives Degrees Not Debt Act 114-hr-5756 Government information and archives
114-hr-5756,Higher education Degrees Not Debt Act 114-hr-5756 Higher education
114-hr-5756,Inflation and prices Degrees Not Debt Act 114-hr-5756 Inflation and prices
114-hr-5756,Intergovernmental relations Degrees Not Debt Act 114-hr-5756 Intergovernmental relations
114-hr-5756,State and local finance Degrees Not Debt Act 114-hr-5756 State and local finance
114-hr-5756,Student aid and college costs Degrees Not Debt Act 114-hr-5756 Student aid and college costs

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