Contaminant Data — All Analytes
29 well testing events on record, covering
23 analytes.
Data spans 1957 to 2022.
| Contaminant |
Samples |
Years |
Detection Rate |
Distribution LowModHigh |
vs. Limit |
vs. NY Avg |
|
Manganese
|
23 |
1971–2018
|
78% |
|
106% of limit
|
~ typical
|
|
Iron
|
23 |
1971–2018
|
87% |
|
25% of limit
|
↓ 84% below
|
|
Radon
|
17 |
1994–2018
|
100% |
|
22% of limit
|
↓ 83% below
|
|
Arsenic
|
17 |
1971–2018
|
76% |
|
5% of limit
|
↓ 88% below
|
|
Chloride
|
23 |
1971–2018
|
100% |
|
5% of limit
|
↓ 90% below
|
|
Fluoride
|
23 |
1971–2018
|
74% |
|
2% of limit
|
↓ 55% below
|
|
HFPO-DA (GenX)
municipal
|
6 |
2023–2025
|
0% |
|
— |
— |
|
Lead
|
17 |
1971–2018
|
47% |
|
1% of limit
|
↓ 98% below
|
|
Nitrate
|
23 |
1971–2018
|
61% |
|
2% of limit
|
↓ 72% below
|
|
Nitrite
|
18 |
1973–2018
|
17% |
|
0% of limit
|
↓ 92% below
|
|
PFHxS
municipal
|
6 |
2023–2025
|
0% |
|
— |
— |
|
PFNA
municipal
|
6 |
2023–2025
|
0% |
|
— |
— |
|
PFOA
municipal
|
6 |
2023–2025
|
0% |
|
— |
— |
|
PFOS
municipal
|
6 |
2023–2025
|
0% |
|
— |
— |
|
Sulfate
|
23 |
1971–2018
|
100% |
|
8% of limit
|
↓ 49% below
|
|
Uranium
|
11 |
2008–2018
|
91% |
|
0% of limit
|
↓ 74% below
|
|
Total Coliform
|
4 |
2008–2018
|
11% |
|
— |
— |
|
Sodium
|
23 |
1971–2018
|
100% |
|
— |
↓ 81% below
|
|
pH
|
23 |
1971–2018
|
100% |
|
— |
~ typical
|
|
PFBS
municipal
|
6 |
2023–2025
|
0% |
|
— |
— |
|
Hardness
|
23 |
1971–2018
|
100% |
|
— |
~ typical
|
|
Fecal Coliform
|
4 |
2008–2018
|
0% |
|
— |
— |
|
E. coli
|
4 |
2008–2018
|
0% |
|
— |
— |
Distribution shows the share of samples in each concentration band relative to the EPA Maximum Contaminant Level (MCL): Low = below half the MCL, Moderate = between half and the MCL, High = above the MCL. Analytes without an MCL (e.g. sodium, pH) show — in the limit columns. State average is based on county median values across NY.
Data Sources
This report aggregates data from the following public databases:
- Water Quality Portal (WQP) — groundwater sample results for Columbia County from EPA, USGS, and state agencies. Browse WQP data →
- EPA Safe Drinking Water Information System (SDWIS) — public water system inventory used to estimate the share of residents on private wells. Browse SDWIS →
- Census ACS 5-Year Estimates — well and cistern household counts (variable DP04_0074E) used to calculate the private-well percentage for Columbia County. Census data explorer →
- USGS Aquifer Atlas — principal aquifer type underlying Columbia County, which informs which contaminants are geologically likely. USGS Aquifer Atlas →
- EPA UCMR 5 (2023–2025) — PFAS occurrence data from public water systems, used as a proxy indicator for aquifer PFAS exposure. Rows marked "municipal" in the table above come from this source. About UCMR 5 →
- EPA Toxics Release Inventory (TRI) — industrial facility chemical releases near Columbia County, used in contamination risk scoring. TRI Explorer →
- EPA Superfund NPL — National Priorities List sites in or near Columbia County, used in contamination risk scoring. Superfund site search →
- CDC PLACES — county-level health outcome prevalence (kidney disease, cancer, heart disease) correlated with detected contaminants. About CDC PLACES →
Methodology
Raw records are downloaded from the Water Quality Portal and normalized to µg/L (ppb). Records are deduplicated by sample ID and date, and certified outliers are excluded. Analyte names are mapped to EPA canonical forms. Detection rates, distribution bands, and MCL comparisons are computed from the normalized dataset.
Distribution bands use the EPA Maximum Contaminant Level as the threshold: concentrations below 50% of the MCL are classed as Low, between 50% and 100% as Moderate, and above 100% as High. For analytes without an MCL (sodium, hardness, pH), distribution is not computed.
State comparison uses the median of county median values across all counties in NY with at least one sample for that analyte.
Last updated: 2026-07-15
Full methodology →