Aterio Datasets
US Drinking Water System Ratings
Discover drinking water safety insights using Aterio's Water System Irregularities dataset.
About
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.
Fields
Column Name | Description |
---|---|
ZIP_CODE | US Zip Code |
CITY_NAME | City name |
COUNTY_NAME | County name |
COUNTY_FIPS_CODE | Federal Information Processing Standards (FIPS) code for counties |
STATE_CODE | State code |
TOT_NUM_COUNTY_DW_VIOLATION | Total number of drinking water violations in the county |
AVG_TOT_NUM_US_DW_VIOLATION | Average number of drinking water violations in the US |
TOT_NUM_COUNTY_HEALTH_DW_VIOLATION | Total number of health-related drinking water violations in the county |
AVG_TOT_NUM_US_HEALTH_DW_VIOLATION | Average number of health-related drinking water violations in the US |
TOT_NUM_COUNTY_MAJOR_DW_VIOLATION | Total number of major drinking water violations in the county |
AVG_TOT_NUM_US_MAJOR_DW_VIOLATION | Average number of major drinking water violations in the US |
TOT_NUM_COUNTY_DW_CONTAMINATION | Total number of water contaminations in the county |
AVG_TOT_NUM_US_DW_CONTAMINATION | Average number of water contaminations in the US |
WATER_QUALITY_COUNTY_SCORE | County's water quality score |