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

21 rows where bill_id = "109-s-1848"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
109-s-1848,Citizen participation Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Citizen participation
109-s-1848,Congress Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Congress
109-s-1848,Congressional reporting requirements Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Congressional reporting requirements
109-s-1848,Environmental assessment Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Environmental assessment
109-s-1848,Fines (Penalties) Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Fines (Penalties)
109-s-1848,Good samaritan laws Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Good samaritan laws
109-s-1848,Government Operations and Politics Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Government Operations and Politics
109-s-1848,Groundwater Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Groundwater
109-s-1848,Hazardous wastes Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Hazardous wastes
109-s-1848,Indian lands Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Indian lands
109-s-1848,Injunctions Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Injunctions
109-s-1848,Law Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Law
109-s-1848,Liability for environmental damages Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Liability for environmental damages
109-s-1848,Licenses Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Licenses
109-s-1848,Mine wastes Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Mine wastes
109-s-1848,Mine water Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Mine water
109-s-1848,Minorities Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Minorities
109-s-1848,Nonpoint source pollution Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Nonpoint source pollution
109-s-1848,Waste water treatment Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Waste water treatment
109-s-1848,Water Resources Development Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Water Resources Development
109-s-1848,Water pollution control Cleanup of Inactive and Abandoned Mines Act 109-s-1848 Water pollution control

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