Aterio Datasets

US Drinking Water System Ratings

Discover drinking water safety insights using Aterio's Water System Irregularities dataset.

Available on

CSV FileAmazon S3Google Cloud Platform

You might also like

US Climate Risk Index by Zip Code


Free sample available for instant download

Identify neighborhood vulnerability to disasters and climate change with Aterio's Climate Risk Index.

US Flood Risk & Cost of Insurance


Free sample available for instant download

Explore Insurance Costs in Climate-Vulnerable Zones


Gain entry to information regarding safe drinking water through Aterio's Drinking Water System Irregularities dataset. Uncover essential details concerning the safety of drinking water systems with Aterio's Water Quality sample dataset, presently accessible on Snowflake Marketplace. This dataset provides thorough insights into irregularities that may impact water quality, sourced directly from the US EPA via the contemporary Safe Drinking Water Information System, as mandated by the US government through the Safe Drinking Water Act.

Dataset Component

  • Access data from water facilities to ensure transparency regarding any violations, with a clear distinction between health-based and major violations.
  • Understand the potential health effects of irregularities by categorizing violations to indicate whether they pose a threat to public health.
  • Includes metadata mapping that links attribute names to zip codes, cities, counties, and Core Based Statistical Areas (CBSAs).

Primary Fields Included:

  • Zip Codes
  • Aterio Unique ID
  • County
  • City
  • CBSAs
  • State
  • Latitude/Longitude

Business Needs

Market Analysis

  • Gain valuable insights into areas and neighborhoods through water quality-related data.
  • With Aterio's robust analytics, investors and retailers can identify regions with potential water quality concerns and assess water system scores for future investment prospects.

Location Planning

  • Access a dataset focusing on water system violations and water quality scores by zip code.
  • Fulfilling a critical business need for precise, location-specific data, enabling informed decision-making, resource optimization, and adaptation to changing market conditions.

Risk Analysis

  • The dataset equips investors with essential information to evaluate health risks and proactively address potential issues.
  • By analyzing historical and current data, investors can understand risks associated with specific areas, enabling informed investment decisions and portfolio adjustments to mitigate potential drawbacks.

Why Choose Aterio ?

  • Continuous Updates: Stay informed with quarterly dataset updates, providing the most current information for your analysis.
  • Zip Code Specific: Data is organized by zip code, enabling a localized perspective on water system health.
  • Data Neutrality: Aterio provides the data without making judgments about water quality, empowering users to assess and understand water system irregularities.


Column NameDescription
CITY_NAMECity name
COUNTY_NAMECounty name
COUNTY_FIPS_CODEFederal Information Processing Standards (FIPS) code for counties
STATE_CODEState code
TOT_NUM_COUNTY_DW_VIOLATIONTotal number of drinking water violations in the county
AVG_TOT_NUM_US_DW_VIOLATIONAverage number of drinking water violations in the US
TOT_NUM_COUNTY_HEALTH_DW_VIOLATIONTotal number of health-related drinking water violations in the county
AVG_TOT_NUM_US_HEALTH_DW_VIOLATIONAverage number of health-related drinking water violations in the US
TOT_NUM_COUNTY_MAJOR_DW_VIOLATIONTotal number of major drinking water violations in the county
AVG_TOT_NUM_US_MAJOR_DW_VIOLATIONAverage number of major drinking water violations in the US
TOT_NUM_COUNTY_DW_CONTAMINATIONTotal number of water contaminations in the county
AVG_TOT_NUM_US_DW_CONTAMINATIONAverage number of water contaminations in the US
WATER_QUALITY_COUNTY_SCORECounty's water quality score