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

7 rows where bill_id = "118-sjres-38"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
118-sjres-38,Administrative law and regulatory procedures A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Federal Highway Administration relating to "Waiver of Buy America Requirements for Electric Vehicle Chargers". 118-sjres-38 Administrative law and regulatory procedures
118-sjres-38,Buy American requirements A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Federal Highway Administration relating to "Waiver of Buy America Requirements for Electric Vehicle Chargers". 118-sjres-38 Buy American requirements
118-sjres-38,Congressional oversight A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Federal Highway Administration relating to "Waiver of Buy America Requirements for Electric Vehicle Chargers". 118-sjres-38 Congressional oversight
118-sjres-38,Department of Transportation A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Federal Highway Administration relating to "Waiver of Buy America Requirements for Electric Vehicle Chargers". 118-sjres-38 Department of Transportation
118-sjres-38,Hybrid, electric, and advanced technology vehicles A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Federal Highway Administration relating to "Waiver of Buy America Requirements for Electric Vehicle Chargers". 118-sjres-38 Hybrid, electric, and advanced technology vehicles
118-sjres-38,Manufacturing A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Federal Highway Administration relating to "Waiver of Buy America Requirements for Electric Vehicle Chargers". 118-sjres-38 Manufacturing
118-sjres-38,Motor vehicles A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Federal Highway Administration relating to "Waiver of Buy America Requirements for Electric Vehicle Chargers". 118-sjres-38 Motor vehicles

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