Aterio Datasets
US Water Quality
| STATE_CODE | CITY_NAME | ZIP_CODE | TOT_NUM_COUNTY_DW_VIOLATION | TOT_NUM_COUNTY_DW_CONTAMINATION |
|---|---|---|---|---|
| WA | Spokane | 99260 | 983 | 78 |
| WA | Seattle | 98155 | 233 | 28 |
| OR | Otter Rock | 97369 | 834 | 64 |
| WA | Cashmere | 98815 | 368 | 58 |
| WA | Spangle | 99031 | 983 | 78 |
| WA | Tacoma | 98443 | 438 | 54 |
| OR | Cloverdale | 97112 | 495 | 41 |
Get access to data on safe drinking water with Aterio's Drinking Water System Irregularities dataset. Explore critical insights into the safety of drinking water systems with Aterio's Water Quality sample dataset, now available on Snowflake Marketplace. This dataset offers a deep dive into irregularities that can affect water quality, sourced directly from the US EPA under the modern Safe Drinking Water Information System, mandated by the US government through the Safe Drinking Water Act.
Key Features:
-
Transparent Data on Water Systems: Access data from water facilities, ensuring transparency regarding any violations, with a clear distinction between health-based and major violations.
-
Health Impact Assessment: Understand the potential health effects of irregularities, as violations are categorized to indicate whether they pose a threat to public health.
-
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 |
| UPDATED_AT | Date of the last data update |