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

25 rows where bill_id = "109-s-2161"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
109-s-2161,Administrative procedure Small System Safe Drinking Water Act of 2005 109-s-2161 Administrative procedure
109-s-2161,Arsenic Small System Safe Drinking Water Act of 2005 109-s-2161 Arsenic
109-s-2161,Congress Small System Safe Drinking Water Act of 2005 109-s-2161 Congress
109-s-2161,Congressional reporting requirements Small System Safe Drinking Water Act of 2005 109-s-2161 Congressional reporting requirements
109-s-2161,Economics and Public Finance Small System Safe Drinking Water Act of 2005 109-s-2161 Economics and Public Finance
109-s-2161,Environmental Protection Agency Small System Safe Drinking Water Act of 2005 109-s-2161 Environmental Protection Agency
109-s-2161,Environmental health Small System Safe Drinking Water Act of 2005 109-s-2161 Environmental health
109-s-2161,Environmental research Small System Safe Drinking Water Act of 2005 109-s-2161 Environmental research
109-s-2161,Environmental technology Small System Safe Drinking Water Act of 2005 109-s-2161 Environmental technology
109-s-2161,Federal aid to water pollution control Small System Safe Drinking Water Act of 2005 109-s-2161 Federal aid to water pollution control
109-s-2161,Government Operations and Politics Small System Safe Drinking Water Act of 2005 109-s-2161 Government Operations and Politics
109-s-2161,Governmental investigations Small System Safe Drinking Water Act of 2005 109-s-2161 Governmental investigations
109-s-2161,Health Small System Safe Drinking Water Act of 2005 109-s-2161 Health
109-s-2161,Infrastructure Small System Safe Drinking Water Act of 2005 109-s-2161 Infrastructure
109-s-2161,Law Small System Safe Drinking Water Act of 2005 109-s-2161 Law
109-s-2161,Potable water Small System Safe Drinking Water Act of 2005 109-s-2161 Potable water
109-s-2161,Research and development Small System Safe Drinking Water Act of 2005 109-s-2161 Research and development
109-s-2161,Revolving funds Small System Safe Drinking Water Act of 2005 109-s-2161 Revolving funds
109-s-2161,Science, Technology, Communications Small System Safe Drinking Water Act of 2005 109-s-2161 Science, Technology, Communications
109-s-2161,Technology transfer Small System Safe Drinking Water Act of 2005 109-s-2161 Technology transfer
109-s-2161,Waste water treatment Small System Safe Drinking Water Act of 2005 109-s-2161 Waste water treatment
109-s-2161,Water Resources Development Small System Safe Drinking Water Act of 2005 109-s-2161 Water Resources Development
109-s-2161,Water pollution control Small System Safe Drinking Water Act of 2005 109-s-2161 Water pollution control
109-s-2161,Water purification Small System Safe Drinking Water Act of 2005 109-s-2161 Water purification
109-s-2161,Water treatment plants Small System Safe Drinking Water Act of 2005 109-s-2161 Water treatment plants

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