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

8 rows where bill_id = "105-hr-2855"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
105-hr-2855,Administrative procedure To amend title 49, United States Code, to require the installation of the collision avoidance system known as TCAS-II on large cargo aircraft. 105-hr-2855 Administrative procedure
105-hr-2855,Aviation safety To amend title 49, United States Code, to require the installation of the collision avoidance system known as TCAS-II on large cargo aircraft. 105-hr-2855 Aviation safety
105-hr-2855,Avionics To amend title 49, United States Code, to require the installation of the collision avoidance system known as TCAS-II on large cargo aircraft. 105-hr-2855 Avionics
105-hr-2855,Department of Transportation To amend title 49, United States Code, to require the installation of the collision avoidance system known as TCAS-II on large cargo aircraft. 105-hr-2855 Department of Transportation
105-hr-2855,Government Operations and Politics To amend title 49, United States Code, to require the installation of the collision avoidance system known as TCAS-II on large cargo aircraft. 105-hr-2855 Government Operations and Politics
105-hr-2855,Law To amend title 49, United States Code, to require the installation of the collision avoidance system known as TCAS-II on large cargo aircraft. 105-hr-2855 Law
105-hr-2855,Navigational aids (Aeronautics) To amend title 49, United States Code, to require the installation of the collision avoidance system known as TCAS-II on large cargo aircraft. 105-hr-2855 Navigational aids (Aeronautics)
105-hr-2855,Transport aircraft To amend title 49, United States Code, to require the installation of the collision avoidance system known as TCAS-II on large cargo aircraft. 105-hr-2855 Transport aircraft

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