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

4 rows where bill_id = "100-hr-4215"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-hr-4215,Asbestos A bill to amend the provisions of the Toxic Substances Control Act relating to asbestos in the Nation's schools by extending the deadlines for local educational agencies to submit asbestos management plans to State Governors and to begin implementation of those plans. 100-hr-4215 Asbestos
100-hr-4215,Education A bill to amend the provisions of the Toxic Substances Control Act relating to asbestos in the Nation's schools by extending the deadlines for local educational agencies to submit asbestos management plans to State Governors and to begin implementation of those plans. 100-hr-4215 Education
100-hr-4215,Educational facilities A bill to amend the provisions of the Toxic Substances Control Act relating to asbestos in the Nation's schools by extending the deadlines for local educational agencies to submit asbestos management plans to State Governors and to begin implementation of those plans. 100-hr-4215 Educational facilities
100-hr-4215,Schools A bill to amend the provisions of the Toxic Substances Control Act relating to asbestos in the Nation's schools by extending the deadlines for local educational agencies to submit asbestos management plans to State Governors and to begin implementation of those plans. 100-hr-4215 Schools

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