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

18 rows where bill_id = "108-s-2865"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
108-s-2865,Administrative procedure Freedom From Foreign Oil Act of 2004 108-s-2865 Administrative procedure
108-s-2865,Alcohol as fuel Freedom From Foreign Oil Act of 2004 108-s-2865 Alcohol as fuel
108-s-2865,Automobile industry Freedom From Foreign Oil Act of 2004 108-s-2865 Automobile industry
108-s-2865,Automobiles Freedom From Foreign Oil Act of 2004 108-s-2865 Automobiles
108-s-2865,Commerce Freedom From Foreign Oil Act of 2004 108-s-2865 Commerce
108-s-2865,Consumer education Freedom From Foreign Oil Act of 2004 108-s-2865 Consumer education
108-s-2865,Department of Transportation Freedom From Foreign Oil Act of 2004 108-s-2865 Department of Transportation
108-s-2865,Energy Freedom From Foreign Oil Act of 2004 108-s-2865 Energy
108-s-2865,Energy efficiency Freedom From Foreign Oil Act of 2004 108-s-2865 Energy efficiency
108-s-2865,Environmental Protection Freedom From Foreign Oil Act of 2004 108-s-2865 Environmental Protection
108-s-2865,Fines (Penalties) Freedom From Foreign Oil Act of 2004 108-s-2865 Fines (Penalties)
108-s-2865,Fuel consumption Freedom From Foreign Oil Act of 2004 108-s-2865 Fuel consumption
108-s-2865,Government Operations and Politics Freedom From Foreign Oil Act of 2004 108-s-2865 Government Operations and Politics
108-s-2865,Labeling Freedom From Foreign Oil Act of 2004 108-s-2865 Labeling
108-s-2865,Law Freedom From Foreign Oil Act of 2004 108-s-2865 Law
108-s-2865,Motor vehicle pollution control Freedom From Foreign Oil Act of 2004 108-s-2865 Motor vehicle pollution control
108-s-2865,Signs and symbols Freedom From Foreign Oil Act of 2004 108-s-2865 Signs and symbols
108-s-2865,Trucks Freedom From Foreign Oil Act of 2004 108-s-2865 Trucks

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