home / openregs

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

12 rows where bill_id = "97-s-2502"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
97-s-2502,Authorization Federal Public Transportation Act of 1982 97-s-2502 Authorization
97-s-2502,Economics and Public Finance Federal Public Transportation Act of 1982 97-s-2502 Economics and Public Finance
97-s-2502,Federal aid programs Federal Public Transportation Act of 1982 97-s-2502 Federal aid programs
97-s-2502,Intergovernmental fiscal relations Federal Public Transportation Act of 1982 97-s-2502 Intergovernmental fiscal relations
97-s-2502,Local and Municipal Government Federal Public Transportation Act of 1982 97-s-2502 Local and Municipal Government
97-s-2502,Local finance Federal Public Transportation Act of 1982 97-s-2502 Local finance
97-s-2502,Mass rapid transit Federal Public Transportation Act of 1982 97-s-2502 Mass rapid transit
97-s-2502,State finance Federal Public Transportation Act of 1982 97-s-2502 State finance
97-s-2502,States Federal Public Transportation Act of 1982 97-s-2502 States
97-s-2502,Transportation and Travel Federal Public Transportation Act of 1982 97-s-2502 Transportation and Travel
97-s-2502,Urban affairs Federal Public Transportation Act of 1982 97-s-2502 Urban affairs
97-s-2502,Urban transportation Federal Public Transportation Act of 1982 97-s-2502 Urban transportation

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);
Powered by Datasette · Queries took 1154.552ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API