home / openregs

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 = "110-s-2986"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
110-s-2986,Bridges A bill to amend the Safe, Accountable, Flexible, Efficient Transportation Equity Act: A Legacy for Users to modify the project description for a project for the city of Lake Charles, Louisiana. 110-s-2986 Bridges
110-s-2986,Economics and Public Finance A bill to amend the Safe, Accountable, Flexible, Efficient Transportation Equity Act: A Legacy for Users to modify the project description for a project for the city of Lake Charles, Louisiana. 110-s-2986 Economics and Public Finance
110-s-2986,Federal aid to transportation A bill to amend the Safe, Accountable, Flexible, Efficient Transportation Equity Act: A Legacy for Users to modify the project description for a project for the city of Lake Charles, Louisiana. 110-s-2986 Federal aid to transportation
110-s-2986,Highway finance A bill to amend the Safe, Accountable, Flexible, Efficient Transportation Equity Act: A Legacy for Users to modify the project description for a project for the city of Lake Charles, Louisiana. 110-s-2986 Highway finance
110-s-2986,Infrastructure A bill to amend the Safe, Accountable, Flexible, Efficient Transportation Equity Act: A Legacy for Users to modify the project description for a project for the city of Lake Charles, Louisiana. 110-s-2986 Infrastructure
110-s-2986,Interstate highway system A bill to amend the Safe, Accountable, Flexible, Efficient Transportation Equity Act: A Legacy for Users to modify the project description for a project for the city of Lake Charles, Louisiana. 110-s-2986 Interstate highway system
110-s-2986,Louisiana A bill to amend the Safe, Accountable, Flexible, Efficient Transportation Equity Act: A Legacy for Users to modify the project description for a project for the city of Lake Charles, Louisiana. 110-s-2986 Louisiana
110-s-2986,Road construction A bill to amend the Safe, Accountable, Flexible, Efficient Transportation Equity Act: A Legacy for Users to modify the project description for a project for the city of Lake Charles, Louisiana. 110-s-2986 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);
Powered by Datasette · Queries took 3.481ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API