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

10 rows where bill_id = "98-hr-5293"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
98-hr-5293,Administrative procedure A bill to terminate certain authorities of the executive branch of the Government which are subject to congressional review unless those authorities are approved by an enactment of the Congress. 98-hr-5293 Administrative procedure
98-hr-5293,Congress and Members of Congress A bill to terminate certain authorities of the executive branch of the Government which are subject to congressional review unless those authorities are approved by an enactment of the Congress. 98-hr-5293 Congress and Members of Congress
98-hr-5293,Congressional oversight A bill to terminate certain authorities of the executive branch of the Government which are subject to congressional review unless those authorities are approved by an enactment of the Congress. 98-hr-5293 Congressional oversight
98-hr-5293,Congressional veto A bill to terminate certain authorities of the executive branch of the Government which are subject to congressional review unless those authorities are approved by an enactment of the Congress. 98-hr-5293 Congressional veto
98-hr-5293,Department of Education A bill to terminate certain authorities of the executive branch of the Government which are subject to congressional review unless those authorities are approved by an enactment of the Congress. 98-hr-5293 Department of Education
98-hr-5293,Families A bill to terminate certain authorities of the executive branch of the Government which are subject to congressional review unless those authorities are approved by an enactment of the Congress. 98-hr-5293 Families
98-hr-5293,Federal aid to higher education A bill to terminate certain authorities of the executive branch of the Government which are subject to congressional review unless those authorities are approved by an enactment of the Congress. 98-hr-5293 Federal aid to higher education
98-hr-5293,Government Operations and Politics A bill to terminate certain authorities of the executive branch of the Government which are subject to congressional review unless those authorities are approved by an enactment of the Congress. 98-hr-5293 Government Operations and Politics
98-hr-5293,Government regulation A bill to terminate certain authorities of the executive branch of the Government which are subject to congressional review unless those authorities are approved by an enactment of the Congress. 98-hr-5293 Government regulation
98-hr-5293,Student aid A bill to terminate certain authorities of the executive branch of the Government which are subject to congressional review unless those authorities are approved by an enactment of the Congress. 98-hr-5293 Student aid

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