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

28 rows where bill_id = "109-s-2011"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
109-s-2011,Administrative procedure Tire-Derived Fuel Safety Act of 2005 109-s-2011 Administrative procedure
109-s-2011,Air pollution control Tire-Derived Fuel Safety Act of 2005 109-s-2011 Air pollution control
109-s-2011,Autoimmune diseases Tire-Derived Fuel Safety Act of 2005 109-s-2011 Autoimmune diseases
109-s-2011,Automobile tires Tire-Derived Fuel Safety Act of 2005 109-s-2011 Automobile tires
109-s-2011,Birth defects Tire-Derived Fuel Safety Act of 2005 109-s-2011 Birth defects
109-s-2011,Child health Tire-Derived Fuel Safety Act of 2005 109-s-2011 Child health
109-s-2011,Congress Tire-Derived Fuel Safety Act of 2005 109-s-2011 Congress
109-s-2011,Congressional reporting requirements Tire-Derived Fuel Safety Act of 2005 109-s-2011 Congressional reporting requirements
109-s-2011,Energy Tire-Derived Fuel Safety Act of 2005 109-s-2011 Energy
109-s-2011,Environmental Protection Agency Tire-Derived Fuel Safety Act of 2005 109-s-2011 Environmental Protection Agency
109-s-2011,Environmental health Tire-Derived Fuel Safety Act of 2005 109-s-2011 Environmental health
109-s-2011,Environmental technology Tire-Derived Fuel Safety Act of 2005 109-s-2011 Environmental technology
109-s-2011,Environmentally induced diseases Tire-Derived Fuel Safety Act of 2005 109-s-2011 Environmentally induced diseases
109-s-2011,Epidemiology Tire-Derived Fuel Safety Act of 2005 109-s-2011 Epidemiology
109-s-2011,Families Tire-Derived Fuel Safety Act of 2005 109-s-2011 Families
109-s-2011,Government Operations and Politics Tire-Derived Fuel Safety Act of 2005 109-s-2011 Government Operations and Politics
109-s-2011,Health Tire-Derived Fuel Safety Act of 2005 109-s-2011 Health
109-s-2011,Law Tire-Derived Fuel Safety Act of 2005 109-s-2011 Law
109-s-2011,Licenses Tire-Derived Fuel Safety Act of 2005 109-s-2011 Licenses
109-s-2011,Medical research Tire-Derived Fuel Safety Act of 2005 109-s-2011 Medical research
109-s-2011,Paper and paper products Tire-Derived Fuel Safety Act of 2005 109-s-2011 Paper and paper products
109-s-2011,Pollution measurement Tire-Derived Fuel Safety Act of 2005 109-s-2011 Pollution measurement
109-s-2011,Public Lands and Natural Resources Tire-Derived Fuel Safety Act of 2005 109-s-2011 Public Lands and Natural Resources
109-s-2011,Refuse as fuel Tire-Derived Fuel Safety Act of 2005 109-s-2011 Refuse as fuel
109-s-2011,Respiratory diseases Tire-Derived Fuel Safety Act of 2005 109-s-2011 Respiratory diseases
109-s-2011,Science, Technology, Communications Tire-Derived Fuel Safety Act of 2005 109-s-2011 Science, Technology, Communications
109-s-2011,Standards Tire-Derived Fuel Safety Act of 2005 109-s-2011 Standards
109-s-2011,Transportation and Public Works Tire-Derived Fuel Safety Act of 2005 109-s-2011 Transportation and Public Works

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