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

6 rows where bill_id = "97-s-2986"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
97-s-2986,Armed Forces and National Security A bill to provide for the reimbursement of certain Indian tribes for expenses incurred by such tribes for community impact planning activities related to planning for the then potential deployment of the MX missile system. 97-s-2986 Armed Forces and National Security
97-s-2986,Government liability A bill to provide for the reimbursement of certain Indian tribes for expenses incurred by such tribes for community impact planning activities related to planning for the then potential deployment of the MX missile system. 97-s-2986 Government liability
97-s-2986,Indian claims A bill to provide for the reimbursement of certain Indian tribes for expenses incurred by such tribes for community impact planning activities related to planning for the then potential deployment of the MX missile system. 97-s-2986 Indian claims
97-s-2986,M-X missile A bill to provide for the reimbursement of certain Indian tribes for expenses incurred by such tribes for community impact planning activities related to planning for the then potential deployment of the MX missile system. 97-s-2986 M-X missile
97-s-2986,Missile bases A bill to provide for the reimbursement of certain Indian tribes for expenses incurred by such tribes for community impact planning activities related to planning for the then potential deployment of the MX missile system. 97-s-2986 Missile bases
97-s-2986,National Security and Intelligence Operations A bill to provide for the reimbursement of certain Indian tribes for expenses incurred by such tribes for community impact planning activities related to planning for the then potential deployment of the MX missile system. 97-s-2986 National Security and Intelligence 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);
Powered by Datasette · Queries took 61.92ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API