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

19 rows where bill_id = "103-s-2002"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
103-s-2002,Air quality Rail Investment Act of 1994 103-s-2002 Air quality
103-s-2002,Authorization Rail Investment Act of 1994 103-s-2002 Authorization
103-s-2002,Capital investments Rail Investment Act of 1994 103-s-2002 Capital investments
103-s-2002,Congress Rail Investment Act of 1994 103-s-2002 Congress
103-s-2002,Congressional reporting requirements Rail Investment Act of 1994 103-s-2002 Congressional reporting requirements
103-s-2002,Connecticut Rail Investment Act of 1994 103-s-2002 Connecticut
103-s-2002,Cost accounting Rail Investment Act of 1994 103-s-2002 Cost accounting
103-s-2002,Disabled Rail Investment Act of 1994 103-s-2002 Disabled
103-s-2002,Disaster relief Rail Investment Act of 1994 103-s-2002 Disaster relief
103-s-2002,District of Columbia Rail Investment Act of 1994 103-s-2002 District of Columbia
103-s-2002,Economics and Public Finance Rail Investment Act of 1994 103-s-2002 Economics and Public Finance
103-s-2002,Emergency Management Rail Investment Act of 1994 103-s-2002 Emergency Management
103-s-2002,Employee training Rail Investment Act of 1994 103-s-2002 Employee training
103-s-2002,Environmental Protection Rail Investment Act of 1994 103-s-2002 Environmental Protection
103-s-2002,Federal aid to transportation Rail Investment Act of 1994 103-s-2002 Federal aid to transportation
103-s-2002,Finance and Financial Sector Rail Investment Act of 1994 103-s-2002 Finance and Financial Sector
103-s-2002,Government Operations and Politics Rail Investment Act of 1994 103-s-2002 Government Operations and Politics
103-s-2002,Government corporations Rail Investment Act of 1994 103-s-2002 Government corporations
103-s-2002,Government paperwork Rail Investment Act of 1994 103-s-2002 Government paperwork

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