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 = "110-hr-7204"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
110-hr-7204,Administrative law and regulatory procedures To amend title 49, United States Code, to direct the Secretary of Transportation to establish sanctions and penalties applicable to an employer whenever an employee of the employer is convicted of driving an over-the-road bus under the influence of alcohol or a controlled substance while acting within the scope of the employee's employment. 110-hr-7204 Administrative law and regulatory procedures
110-hr-7204,Criminal procedure and sentencing To amend title 49, United States Code, to direct the Secretary of Transportation to establish sanctions and penalties applicable to an employer whenever an employee of the employer is convicted of driving an over-the-road bus under the influence of alcohol or a controlled substance while acting within the scope of the employee's employment. 110-hr-7204 Criminal procedure and sentencing
110-hr-7204,Department of Transportation To amend title 49, United States Code, to direct the Secretary of Transportation to establish sanctions and penalties applicable to an employer whenever an employee of the employer is convicted of driving an over-the-road bus under the influence of alcohol or a controlled substance while acting within the scope of the employee's employment. 110-hr-7204 Department of Transportation
110-hr-7204,Drug, alcohol, tobacco use To amend title 49, United States Code, to direct the Secretary of Transportation to establish sanctions and penalties applicable to an employer whenever an employee of the employer is convicted of driving an over-the-road bus under the influence of alcohol or a controlled substance while acting within the scope of the employee's employment. 110-hr-7204 Drug, alcohol, tobacco use
110-hr-7204,Motor carriers To amend title 49, United States Code, to direct the Secretary of Transportation to establish sanctions and penalties applicable to an employer whenever an employee of the employer is convicted of driving an over-the-road bus under the influence of alcohol or a controlled substance while acting within the scope of the employee's employment. 110-hr-7204 Motor carriers
110-hr-7204,Transportation safety and security To amend title 49, United States Code, to direct the Secretary of Transportation to establish sanctions and penalties applicable to an employer whenever an employee of the employer is convicted of driving an over-the-road bus under the influence of alcohol or a controlled substance while acting within the scope of the employee's employment. 110-hr-7204 Transportation safety and security

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