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-4050"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
108-hr-4050,Bridges Rural Bridge Safety and Repair Demonstration Act of 2004 108-hr-4050 Bridges
108-hr-4050,Congress Rural Bridge Safety and Repair Demonstration Act of 2004 108-hr-4050 Congress
108-hr-4050,Congressional reporting requirements Rural Bridge Safety and Repair Demonstration Act of 2004 108-hr-4050 Congressional reporting requirements
108-hr-4050,Economics and Public Finance Rural Bridge Safety and Repair Demonstration Act of 2004 108-hr-4050 Economics and Public Finance
108-hr-4050,Federal aid to transportation Rural Bridge Safety and Repair Demonstration Act of 2004 108-hr-4050 Federal aid to transportation
108-hr-4050,Highway finance Rural Bridge Safety and Repair Demonstration Act of 2004 108-hr-4050 Highway finance
108-hr-4050,Highway maintenance Rural Bridge Safety and Repair Demonstration Act of 2004 108-hr-4050 Highway maintenance
108-hr-4050,Infrastructure Rural Bridge Safety and Repair Demonstration Act of 2004 108-hr-4050 Infrastructure
108-hr-4050,Louisiana Rural Bridge Safety and Repair Demonstration Act of 2004 108-hr-4050 Louisiana
108-hr-4050,Road construction Rural Bridge Safety and Repair Demonstration Act of 2004 108-hr-4050 Road construction

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