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 = "102-s-2829"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
102-s-2829,Air bases A bill to require the Secretary of the Air Force to indemnify and hold harmless the recipients of the real property at Loring Air Force Base, Maine, for releases and threatened releases of hazardous substances or pollutants of contaminants resulting from Department of Defense activities at that base before the closure of that base. 102-s-2829 Air bases
102-s-2829,Environmental Protection A bill to require the Secretary of the Air Force to indemnify and hold harmless the recipients of the real property at Loring Air Force Base, Maine, for releases and threatened releases of hazardous substances or pollutants of contaminants resulting from Department of Defense activities at that base before the closure of that base. 102-s-2829 Environmental Protection
102-s-2829,Government liability A bill to require the Secretary of the Air Force to indemnify and hold harmless the recipients of the real property at Loring Air Force Base, Maine, for releases and threatened releases of hazardous substances or pollutants of contaminants resulting from Department of Defense activities at that base before the closure of that base. 102-s-2829 Government liability
102-s-2829,Indemnity A bill to require the Secretary of the Air Force to indemnify and hold harmless the recipients of the real property at Loring Air Force Base, Maine, for releases and threatened releases of hazardous substances or pollutants of contaminants resulting from Department of Defense activities at that base before the closure of that base. 102-s-2829 Indemnity
102-s-2829,Liability for toxic substances pollution damages A bill to require the Secretary of the Air Force to indemnify and hold harmless the recipients of the real property at Loring Air Force Base, Maine, for releases and threatened releases of hazardous substances or pollutants of contaminants resulting from Department of Defense activities at that base before the closure of that base. 102-s-2829 Liability for toxic substances pollution damages
102-s-2829,Maine A bill to require the Secretary of the Air Force to indemnify and hold harmless the recipients of the real property at Loring Air Force Base, Maine, for releases and threatened releases of hazardous substances or pollutants of contaminants resulting from Department of Defense activities at that base before the closure of that base. 102-s-2829 Maine

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