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

19 rows where bill_id = "100-s-1243"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-s-1243,Authorization Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 Authorization
100-s-1243,Central Intelligence Agency Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 Central Intelligence Agency
100-s-1243,Civil service retirement Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 Civil service retirement
100-s-1243,Department of Defense Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 Department of Defense
100-s-1243,Diplomats Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 Diplomats
100-s-1243,Disability retirement Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 Disability retirement
100-s-1243,Economics and Public Finance Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 Economics and Public Finance
100-s-1243,Federal employees Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 Federal employees
100-s-1243,Federal employees and officials Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 Federal employees and officials
100-s-1243,Government Operations and Politics Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 Government Operations and Politics
100-s-1243,Government trust funds Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 Government trust funds
100-s-1243,Income tax Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 Income tax
100-s-1243,Intelligence community staff Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 Intelligence community staff
100-s-1243,Intelligence officers Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 Intelligence officers
100-s-1243,International Affairs Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 International Affairs
100-s-1243,Military personnel Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 Military personnel
100-s-1243,National Security and Intelligence Operations Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 National Security and Intelligence Operations
100-s-1243,Personnel management Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 Personnel management
100-s-1243,Tax exclusion Intelligence Authorization Act, Fiscal Years 1988 and 1989 100-s-1243 Tax exclusion

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