Related Topics:
Table Name: ENFORCEMENT_ACTION
Description: Documents actions taken against a Public Water System (PWS), laboratory, or operator. Includes requirements that must be met in order to rectify a failure to perform under the Public Water Supply Supervision (PWSS) Program. Enforcement actions are informal and formal. They may be issued by the Primacy State (or its representative) or the EPA. Examples: administrative and civil/criminal legal actions, warning notices, citations, orders to follow water treatment procedures, orders to follow sampling requirements, orders to resolve violations, moratoriums on connections, temporary injunctions, restraining orders, penalties, and orders to comply with reporting requirements. Example descriptors: type of enforcement action, directed actions, and milestone date(s).
Columns:
- ENFORCEMENT_ACTION_TYPE_CODE
- ENFORCEMENT_COMMENT_TEXT
- ENFORCEMENT_DATE
- ENFORCEMENT_ID
- ORIGINATOR_CODE
- PWSID
Envirofacts Data Service API for ENFORCEMENT_ACTION: Envirofacts has developed a RESTful data service API to all of its internal data holdings. This functionality provides a user of Envirofacts with the ability to query any table through the use of a URL. The default output is in XML, which can be utilized in other applications, as well as tools such as Microsoft Excel or Access. Output options of CSV and Excel can be requested in the URL. The entire Envirofacts database metadata is available online, so that all tables and columns within Envirofacts are documented. Having the table structures available in this manner makes most of Envirofacts data easily available through the service. More information is available on the Envirofacts Services page.
Below is a sample of the first 10 rows of data for the ENFORCEMENT_ACTION table. The URL used to produce this output is:
https://data.epa.gov/efservice/ENFORCEMENT_ACTION/ROWS/0:10/EXCEL