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

4 rows where bill_id = "115-hr-7331"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
115-hr-7331,Congressional tributes To designate the facility of the United States Postal Service located at 11158 Highway 146 North in Hardin, Texas, as the "Lucas Lowe Post Office". 115-hr-7331 Congressional tributes
115-hr-7331,Government buildings, facilities, and property To designate the facility of the United States Postal Service located at 11158 Highway 146 North in Hardin, Texas, as the "Lucas Lowe Post Office". 115-hr-7331 Government buildings, facilities, and property
115-hr-7331,Postal service To designate the facility of the United States Postal Service located at 11158 Highway 146 North in Hardin, Texas, as the "Lucas Lowe Post Office". 115-hr-7331 Postal service
115-hr-7331,Texas To designate the facility of the United States Postal Service located at 11158 Highway 146 North in Hardin, Texas, as the "Lucas Lowe Post Office". 115-hr-7331 Texas

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