Related Topics:
Table Name: VIOLATION
Description: Documents a breach of a requirement. Violations are detected by assessment of sample results or reviews (including on site visits). Violations may lead to legal actions or compliance orders. Violations are publicized, when required, by public notification. Violations may be remedied by compliance/enforcement remedies, such as improved filtration techniques or changes in procedures. Examples: Maximum Contaminant Level (MCL) violations, failure to replace lead service lines, monitoring and reporting violations, treatment technique violations, and procedural violations. Example descriptors: type, date, description, severity, and recommended corrective action(s) to include milestones.
Description: Documents a breach of a requirement. Violations are detected by assessment of sample results or reviews (including on site visits). Violations may lead to legal actions or compliance orders. Violations are publicized, when required, by public notification. Violations may be remedied by compliance/enforcement remedies, such as improved filtration techniques or changes in procedures. Examples: Maximum Contaminant Level (MCL) violations, failure to replace lead service lines, monitoring and reporting violations, treatment technique violations, and procedural violations. Example descriptors: type, date, description, severity, and recommended corrective action(s) to include milestones.
Columns:
- COMPLIANCE_STATUS_CODE
- COMPL_PER_BEGIN_DATE
- COMPL_PER_END_DATE
- CONTAMINANT_CODE
- CORRECTIVE_ACTION_ID
- EPA_REGION
- FACILITY_ID
- IS_HEALTH_BASED_IND
- IS_MAJOR_VIOL_IND
- LATEST_ENFORCEMENT_ID
- ORIGINATOR_CODE
- POPULATION_SERVED_COUNT
- POP_CAT_5_CODE
- PRIMACY_AGENCY_CODE
- PRIMARY_SOURCE_CODE
- PUBLIC_NOTIFICATION_TIER
- PWSID
- PWSID
- PWS_ACTIVITY_CODE
- PWS_DEACTIVATION_DATE
- PWS_TYPE_CODE
- RTC_DATE
- RTC_ENFORCEMENT_ID
- RULE_CODE
- RULE_FAMILY_CODE
- RULE_GROUP_CODE
- SAMPLE_RESULT_ID
- SEVERITY_IND_CNT
- STATE_MCL
- UNIT_OF_MEASURE
- VIOLATION_CATEGORY_CODE
- VIOLATION_CODE
- VIOLATION_ID
- VIOL_MEASURE
Envirofacts Data Service API for VIOLATION: 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 VIOLATION table. The URL used to produce this output is:
https://data.epa.gov/efservice/VIOLATION/ROWS/0:10/EXCEL