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

14 rows where bill_id = "105-s-2309"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
105-s-2309,Commemorations Gateway Visitor Center Authorization Act of 1998 105-s-2309 Commemorations
105-s-2309,Commerce Gateway Visitor Center Authorization Act of 1998 105-s-2309 Commerce
105-s-2309,Concessions Gateway Visitor Center Authorization Act of 1998 105-s-2309 Concessions
105-s-2309,Economics and Public Finance Gateway Visitor Center Authorization Act of 1998 105-s-2309 Economics and Public Finance
105-s-2309,Government Operations and Politics Gateway Visitor Center Authorization Act of 1998 105-s-2309 Government Operations and Politics
105-s-2309,Historic sites Gateway Visitor Center Authorization Act of 1998 105-s-2309 Historic sites
105-s-2309,History Gateway Visitor Center Authorization Act of 1998 105-s-2309 History
105-s-2309,Law Gateway Visitor Center Authorization Act of 1998 105-s-2309 Law
105-s-2309,National parks Gateway Visitor Center Authorization Act of 1998 105-s-2309 National parks
105-s-2309,Nonprofit organizations Gateway Visitor Center Authorization Act of 1998 105-s-2309 Nonprofit organizations
105-s-2309,Pennsylvania Gateway Visitor Center Authorization Act of 1998 105-s-2309 Pennsylvania
105-s-2309,Social Welfare Gateway Visitor Center Authorization Act of 1998 105-s-2309 Social Welfare
105-s-2309,Tourism Gateway Visitor Center Authorization Act of 1998 105-s-2309 Tourism
105-s-2309,User charges Gateway Visitor Center Authorization Act of 1998 105-s-2309 User charges

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