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

20 rows where bill_id = "110-s-3571"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
110-s-3571,Access to health care HIA Act of 2008 110-s-3571 Access to health care
110-s-3571,Citizen participation HIA Act of 2008 110-s-3571 Citizen participation
110-s-3571,Community development HIA Act of 2008 110-s-3571 Community development
110-s-3571,Community health services HIA Act of 2008 110-s-3571 Community health services
110-s-3571,Congress HIA Act of 2008 110-s-3571 Congress
110-s-3571,Congressional investigations HIA Act of 2008 110-s-3571 Congressional investigations
110-s-3571,Congressional reporting requirements HIA Act of 2008 110-s-3571 Congressional reporting requirements
110-s-3571,Economics and Public Finance HIA Act of 2008 110-s-3571 Economics and Public Finance
110-s-3571,Education HIA Act of 2008 110-s-3571 Education
110-s-3571,Environmental Protection HIA Act of 2008 110-s-3571 Environmental Protection
110-s-3571,Environmental health HIA Act of 2008 110-s-3571 Environmental health
110-s-3571,Federal aid to education HIA Act of 2008 110-s-3571 Federal aid to education
110-s-3571,Health surveys HIA Act of 2008 110-s-3571 Health surveys
110-s-3571,Higher education HIA Act of 2008 110-s-3571 Higher education
110-s-3571,Infrastructure HIA Act of 2008 110-s-3571 Infrastructure
110-s-3571,Land use HIA Act of 2008 110-s-3571 Land use
110-s-3571,Public Lands and Natural Resources HIA Act of 2008 110-s-3571 Public Lands and Natural Resources
110-s-3571,Risk HIA Act of 2008 110-s-3571 Risk
110-s-3571,Urban affairs HIA Act of 2008 110-s-3571 Urban affairs
110-s-3571,Urban planning HIA Act of 2008 110-s-3571 Urban planning

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 3.184ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API