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 = "108-hr-5029"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
108-hr-5029,Administrative remedies To allow a waiver or exemption of certain requirements for restricted airspace if security is not reduced. 108-hr-5029 Administrative remedies
108-hr-5029,Air routes To allow a waiver or exemption of certain requirements for restricted airspace if security is not reduced. 108-hr-5029 Air routes
108-hr-5029,Aircraft To allow a waiver or exemption of certain requirements for restricted airspace if security is not reduced. 108-hr-5029 Aircraft
108-hr-5029,Airspace (Law) To allow a waiver or exemption of certain requirements for restricted airspace if security is not reduced. 108-hr-5029 Airspace (Law)
108-hr-5029,Arts, Culture, Religion To allow a waiver or exemption of certain requirements for restricted airspace if security is not reduced. 108-hr-5029 Arts, Culture, Religion
108-hr-5029,Aviation safety To allow a waiver or exemption of certain requirements for restricted airspace if security is not reduced. 108-hr-5029 Aviation safety
108-hr-5029,Department of Transportation To allow a waiver or exemption of certain requirements for restricted airspace if security is not reduced. 108-hr-5029 Department of Transportation
108-hr-5029,Exhibitions To allow a waiver or exemption of certain requirements for restricted airspace if security is not reduced. 108-hr-5029 Exhibitions
108-hr-5029,Government Operations and Politics To allow a waiver or exemption of certain requirements for restricted airspace if security is not reduced. 108-hr-5029 Government Operations and Politics
108-hr-5029,Law To allow a waiver or exemption of certain requirements for restricted airspace if security is not reduced. 108-hr-5029 Law

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