openregs: legislation_subjects: 8 rows where bill

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

descending

Link	bill_id	subject
110-s-2174,Congress	A bill to designate the facility of the United States Postal Service located at 175 South Monroe Street in Tiffin, Ohio, as the "Paul E. Gillmor Post Office Building". 110-s-2174	Congress
110-s-2174,Congressional tributes	A bill to designate the facility of the United States Postal Service located at 175 South Monroe Street in Tiffin, Ohio, as the "Paul E. Gillmor Post Office Building". 110-s-2174	Congressional tributes
110-s-2174,Ex-Members of Congress	A bill to designate the facility of the United States Postal Service located at 175 South Monroe Street in Tiffin, Ohio, as the "Paul E. Gillmor Post Office Building". 110-s-2174	Ex-Members of Congress
110-s-2174,Government Operations and Politics	A bill to designate the facility of the United States Postal Service located at 175 South Monroe Street in Tiffin, Ohio, as the "Paul E. Gillmor Post Office Building". 110-s-2174	Government Operations and Politics
110-s-2174,House of Representatives	A bill to designate the facility of the United States Postal Service located at 175 South Monroe Street in Tiffin, Ohio, as the "Paul E. Gillmor Post Office Building". 110-s-2174	House of Representatives
110-s-2174,Names	A bill to designate the facility of the United States Postal Service located at 175 South Monroe Street in Tiffin, Ohio, as the "Paul E. Gillmor Post Office Building". 110-s-2174	Names
110-s-2174,Ohio	A bill to designate the facility of the United States Postal Service located at 175 South Monroe Street in Tiffin, Ohio, as the "Paul E. Gillmor Post Office Building". 110-s-2174	Ohio
110-s-2174,Postal facilities	A bill to designate the facility of the United States Postal Service located at 175 South Monroe Street in Tiffin, Ohio, as the "Paul E. Gillmor Post Office Building". 110-s-2174	Postal facilities

Advanced export

JSON shape: default, array, newline-delimited, object

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