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

9 rows where bill_id = "112-s-2011"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
112-s-2011,Air quality Clean Ports Act of 2011 112-s-2011 Air quality
112-s-2011,Federal preemption Clean Ports Act of 2011 112-s-2011 Federal preemption
112-s-2011,Intergovernmental relations Clean Ports Act of 2011 112-s-2011 Intergovernmental relations
112-s-2011,Motor carriers Clean Ports Act of 2011 112-s-2011 Motor carriers
112-s-2011,Navigation, waterways, harbors Clean Ports Act of 2011 112-s-2011 Navigation, waterways, harbors
112-s-2011,Roads and highways Clean Ports Act of 2011 112-s-2011 Roads and highways
112-s-2011,State and local government operations Clean Ports Act of 2011 112-s-2011 State and local government operations
112-s-2011,Transportation costs Clean Ports Act of 2011 112-s-2011 Transportation costs
112-s-2011,Transportation safety and security Clean Ports Act of 2011 112-s-2011 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);