Ask a question

Methodology

Data sources

  • USGS: Estimated county level domestic well population with arsenic > 10 µg/L (Ayotte, Medalie & Qi, 2017), 3,138 records. Source
  • Minnesota County Well Index (MGS/MDH), non-public-supply wells (USE_C = 'DO' (domestic)), 576,453 records. Source
  • Michigan EGLE Wellogic water wells (WELL_TYPE = 'HOSHLD' (household)), 1,084,120 records. Source
  • California DWR Well Completion Reports (OSWCR) (Planned use 'Water Supply Domestic', record type 'New'), 377,705 records. Source
  • Well Construction Reports (Well Log Database), Washington Department of Ecology (WellProjectType='Water' and WellSubType in ('Water (Cased)','Water (Dug)') (water-supply wells; no domestic-only field exists)), 165,233 records. Source
    Caveats: Ecology Well Construction Reports has no use field separating domestic from irrigation/municipal/commercial water wells; all new water-supply wells (WellProjectType Water) are included, the large majority are single-household exempt wells; CompletedDepth and StaticWaterLvl are stored as text and converted to numbers (feet); zero depths ignored; Water Sampling, Resource Protection, Geotechnical, Dewatering, Ground Source, Decommissioning records excluded
  • Maine Well Database (Maine Geological Survey, Dept. of Agriculture, Conservation & Forestry) (WELL_USE in ('DOMESTIC','FARM, DOMESTIC'), geothermal and observation excluded), 92,816 records. Source
    Caveats: Maine Well Database holds domestic wells reported by drillers; ~40% have coordinates but all records carry a town, so all are used; County derived from WELL_LOCATION_TOWN via Census 2020 county subdivisions; unmapped towns go to (unknown); Depth = WELL_DEPTH_FT; yield = WELL_YIELD_GPM; static = WELL_STATIC_LEVEL_FT (sparse); Mostly bedrock wells (WELL_TYPE BEDROCK ~96%); includes some gravel/overburden/dug
  • Private Well Tracking System (Private Well Facilities layer), Iowa Department of Natural Resources (No use field: layer is the Iowa DNR Private Well Tracking System (private wells = household supply wells); all opStatus values included), 41,504 records. Source
    Caveats: Private Well Tracking System has no use field; it tracks private (non-public) water supply wells, mostly household, some may be livestock/ag; No static water level or yield fields in this layer; Includes all opStatus values (Active, Expired, Retired, Plugged ...); n_records is deduped on progid; PWTS records mainly from ~1990s onward (state well-program permits), so pre-1990 stats are thin
  • Arkansas Water Well Construction Database (public layer), Arkansas Department of Agriculture - Natural Resources Division (use_cd_x='DO' (Domestic use code in Arkansas Water Well Construction Database)), 31,436 records. Source
    Caveats: county_cd_x is the 3-digit county FIPS code, mapped to Census names; Layer is the public Waterwell Construction Database (Arkansas Dept. of Agriculture Natural Resources Division, formerly ANRC/AAD); ~96k records total, skewed to eastern-Arkansas irrigation; Includes all well_status_x values (new wells, repairs etc.)
  • Well completion report sites (delegated counties + District issued permits), St. Johns River Water Management District (SJRWMD), Florida (WELL_USE='Domestic' (SJRWMD well completion report sites; delegated-county + district-issued permit layers merged, deduped on STN_ID)), 132,426 records. Source
    Caveats: Coverage is only the SJRWMD-area and delegated-county well completion reports (about 20 counties heavy in NE/central/east FL); SWFWMD, SFWMD, SRWMD, NWFWMD not included unless noted in the report; No yield field in layer; Depth = WELL_CUR_DPTH (current well depth), not casing depth; Static level of 0 treated as missing; Use 'Domestic' only; Irrigation, Monitoring, Public Supply, HVAC excluded
  • MassDEP Well Driller Program well completion reports (Well Location Viewer data, snapshot 26 Apr 2023) (Well_Type='Domestic', Work_Performed<>'Decommission', no Error_Flag), 78,066 records. Source
    Caveats: Layer is MassDEP's published 'Well Location Viewer' extract (127,011 of ~206,000 reports; only reports with parcel-level verified location); Snapshot dated 2023-04-26, so recent wells are missing; hosted on ArcGIS Online by MassDEP (DEP_DWP); Fields are strings in source, parsed numerically; zero treated as missing; County derived from Town via Census 2020 county subdivisions
  • Virginia Water Wells (VA_Water_Wells), Virginia Department of Energy, Division of Geology and Mineral Resources (compiled from DEQ GW-2, VDH, USGS, WWCR records) (Function_='Domestic' (exact; excludes 'Industrial and Domestic', Farm, Public, Municipal etc.; Use_ free-text ignored)), 7,530 records. Source
    Caveats: Static level 0, yield 0 and depth 0 are treated as missing (source uses 0 for unknown); Many records have no completion date (era splits sparse); Independent cities appear as 'Name (City)' which normalises to the Census 'Name city'; 'Fairfax', 'Roanoke', 'Richmond', 'Franklin', 'Bedford' county vs city cannot be separated; Spotsylvania median depth 28 ft looks suspicious (likely shallow/old dug or unit-mixed records) - flag; Compiled historic data; not complete for all VA wells; Virginia only requires well reports since 1992 (DEQ GWMA/WWCR)
  • IN DNR Water Well Records (Water Well Record Database), Indiana Department of Natural Resources, Division of Water (NO use field in the Indiana DNR record layer; heuristic residential proxy: owner name has no business/utility/government/institution keyword, casing diameter <= 6 in (or missing), pump rate <= 100 gpm (or missing)), 347,191 records. Source
    Caveats: Indiana DNR Division of Water Well Record Database (IN DNR Water Well Records) has no well-use field; domestic wells are inferred, not labelled. Medians describe 'small-diameter wells owned by what look like individuals', including some small irrigation, agricultural, and geothermal wells; Owner fields used only server-side for filtering; not stored in output; Zero in depth/static/yield means missing and is ignored; many old records have completion-date year placeholders
  • Oklahoma Water Resources Board groundwater well records (use_class='Domestic'), 93,587 records. Source
  • Water Resource Sites database (ground-water site inventory, domestic wells), North Dakota Department of Water Resources (formerly State Water Commission) (Purpose='Domestic Well' (Water Resource Sites inventory, site download sites.txt; MN-/MT- out-of-state sites dropped)), 5,021 records. Source
    Caveats: Not the full drillers-log file: DWR's public site inventory holds only ~5.5k domestic wells statewide (ND has far more drilled), so coverage is partial and skewed to cooperative USGS/DWR county ground-water studies; Depth = Total_Depth, falling back to Bottom_Screen when Total_Depth is 0/blank (about 30% fallbacks); No static level or yield columns in the site download; ground-water level measurements are in a separate table not used here; Date_Drilled is often a placeholder like 19xx-01-01 for historic wells
  • Pennsylvania DCNR PaGWIS water wells (Water_Use='DOMESTIC' (layer holds 9 duplicated OID blocks; only first block OID<26713000 read, then deduped on PAWellID)), 351,531 records. Source
  • Water Wells (Wellhead Information Management System, certified water wells), Missouri Department of Natural Resources - Missouri Geological Survey (WELL_TYPE='Domestic' (WIMS well types: Domestic, High Yield, Public, Multi-Family)), 172,835 records. Source
    Caveats: Layer has no county field: county assigned by point-in-polygon of the well point against US Census TIGERweb 2020s county polygons (simplified 0.0005 deg); 51 domestic wells not located in a county were dropped; gis.dnr.mo.gov REST endpoint is behind a bot-blocking firewall for scripted queries, so data pulled via the official ArcGIS Hub CSV export (gis-modnr.opendata.arcgis.com, item 7ec0b65d9c184f8b9af996b4fe554203); Many well points are placed at PLSS section centers (location accuracy varies) so county can be wrong for wells near a county line; Depth = TOTAL_DPTH; static = SWL (feet); yield = WELL_YIELD (driller-reported GPM); WIMS holds drillers' certified wells (required since 1985 Water Well Drillers law); all rows are WELL_STAT Active; Independent city of St. Louis is kept as its own unit ('St. Louis city')
  • NR68 Water Well Completion Reports (well logs, public layer), South Dakota Department of Agriculture and Natural Resources - Water Rights Program (WELL_TYPE='DOM' (Domestic)), 38,031 records. Source
    Caveats: Oglala Lakota County (FIPS 46102) renamed Shannon to match the Census file in data/raw/census (FIPS 46113 era name); Static level kept only where staticType='depth' (pressure/flowing readings dropped); only ~10% of logs carry a static value; No yield field in the public layer; Well logs required since 1975; some older reports included; Includes domestic wells of all statuses in the public layer (plugged wells use separate type PLG and are excluded)
  • Ground Water Information Center (GWIC) database, Montana Bureau of Mines and Geology (Montana Tech) (GWIC Well Use layer well_use='DOMESTIC' AND priority=1 (primary use), joined on gwicid to Boreholes site_type='WELL'), 182,113 records. Source
    Caveats: GWIC is split into relational layers; Boreholes joined to Well Use and Performance on gwicid; County names are upper-case in source and title-cased here; Includes all domestic wells with a GWIC record, including older and abandoned/dry-hole records (site_type WELL); Depths and levels are feet below ground surface
  • Wells (well driller's reports), Idaho Department of Water Resources (WellUse in Domestic, Domestic-Single Residence, Domestic-Multiple Residence, Domestic-Multiple Individual Users, Domestic-Livestock (excludes Domestic-Public Water Supply; 54% of records have blank WellUse and are excluded)), 81,193 records. Source
    Caveats: 54% of IDWR well records (mostly older reports) have a blank WellUse and are excluded, so counts understate domestic wells and skew toward newer wells; Records are from the database that holds most reports since July 1987; older ones are less complete; Depth/static values of 9999 and static level 0 treated as missing; units feet; ProductionRate taken as yield gpm; Out-of-state county labels (Cache UT, Mineral MT etc.) kept as tiny rows
  • Registered Groundwater Wells (Groundwater Wells DWEE), Nebraska Department of Water, Energy and Environment (formerly DNR) (WellUseDescription='Domestic'), 48,098 records. Source
    Caveats: gis.ne.gov unreachable from the build host; data pulled via the official ArcGIS Hub CSV download of the same layer (export dated 2026-11-17); Registration required only since 1993-09-09; pre-1993 domestic wells are under-represented (and only registered if later reported); Includes all Status values (active, inactive, decommissioned); Depth = TotalDepth; static = StaticWaterLevel; yield = PumpRate (registered pump rate GPM, not a tested yield)
  • Water Wells (RBDMS-ENV water well database), Geological Survey of Alabama (FacilityType='Domestic' (case-insensitive) in GSA RBDMS-ENV Water Wells layer; depth from Construct table (WELL_DEPTH ft), static level / pumping rate / year from each well's earliest WaterLevel record), 30,657 records. Source
    Caveats: GSA says the public RBDMS-ENV data are incomplete vs ~100k hardcopy records on file; No construction-date field: era splits use year of each well's earliest water-level measurement, usually the driller's log (source DL), so it approximates completion year; Only wells with a Construct row have depth; static level is earliest recorded level, not an average
  • Private Wells / Well Completion Reports (Vermont DEC Drinking Water & Groundwater Protection Division, ANR; via VCGI open data) (WellUseCode='Domestic', excluding WellReasonCode Geothermal and Test/Exploration/Monitoring), 112,699 records. Source
    Caveats: Source = Vermont Open Geodata Portal CSV export (data/raw/vt_src/vt_wells.csv); ANR ArcGIS REST host anrmaps.vermont.gov timed out; County derived from Town via Census 2020 county subdivisions; Zero values in depth, yield and static level treated as missing (source uses 0 for unknown); Reports filed since 1966; many wells never reported
  • Well Reports (Water Well Log database), Oregon Water Resources Department (primary_use='Domestic' and type_of_log='Water Well'), 286,595 records. Source
    Caveats: County field is a 4-letter OWRD code mapped to county names; One location per report (many are PLSS section/quarter-quarter centroids); Reports include new wells, deepenings, alterations and abandonments; wl_id deduped so versioned reports count once; Static level = post_static_water_level (feet below land surface); depth in feet
  • MS Water Permit Wells / Water Well Records (Nov 2024), Mississippi DEQ Office of Land and Water Resources, published by MARIS (Mississippi Automated Resource Information System) (Beneficial='DO' (DOMESTIC (HOME) WELL)), 104,789 records. Source
    Caveats: Mississippi MDEQ Office of Land and Water Resources water-well permit/driller-log database as published by MARIS (Mississippi Automated Resource Information System, Nov 2024); layer carries total depth, casing diameter, aquifer and use only: no static level, yield or completion date, so those columns and the era splits are blank; Layer does not support resultOffset paging; read in FID windows of 2000; County names are upper case in source
  • Well Log Tracking System (WELTS), Alaska Department of Natural Resources, Division of Mining, Land and Water (WellUse='Domestic' (about 70% of WELTS logs have no WellUse recorded and are excluded)), 8,868 records. Source
    Caveats: Region field = borough or Regional Educational Attendance Area (REAA); only boroughs/municipalities match Census counties, REAA rows will not join; Only ~22% of WELTS logs state a well use, so Domestic-only is a small, self-selected subset; WellDepth, StaticWaterDepth, PumpGPM stored as text, converted to feet/gpm; Static level taken as StaticWaterDepth (feet below ground)
  • Nevada Division of Water Resources (NDWR) Well Driller Reports (ProposedUse='Domestic' AND WorkType IN ('New','Replacement Well')), 59,003 records. Source
    Caveats: Layer has no county field: county assigned by point-in-polygon of latitude/longitude against Census TIGERweb county polygons (136 records fell outside any county polygon, listed as (unknown)); Depth = DepthDrilled falling back to DepthCased; static level = StaticWaterLevel (ft below land surface); yield = 'yield' (gpm); Only WorkType New and Replacement Well kept (excludes Deepen, Plug or Abandonment, Recondition, Geothermal); deduped on WellLog number; Date = WellFinishDate
  • Kentucky Water Wells and Springs (Kentucky Groundwater Data Repository), Kentucky Geological Survey, University of Kentucky (primary_use LIKE 'Domestic%' (Domestic - Single Household; Domestic - Multiple Domestic Households) and GWSourceType = W (wells, springs excluded)), 31,530 records. Source
    Caveats: Kentucky Geological Survey Kentucky Groundwater Data Repository (Water Wells and Springs); no yield field in the public layer so yield columns blank; Many records carry a placeholder construction date of 1900-01-01, which counts toward pre-1990 medians but not decade medians; true age of those wells unknown; Static water level 0 may be flowing/at-surface or missing value; owner/PII fields not read
  • ILWATER Water and Related Wells (Illinois water well records), Illinois State Geological Survey (Prairie Research Institute, University of Illinois) (WELL_TYPE='PRIV' (Private Water Well; excludes Semi-Private, Household-Livestock, municipal, irrigation, monitoring, geothermal, test holes)), 205,553 records. Source
    Caveats: Illinois State Geological Survey ILWATER Water and Related Wells layer (water well records from Illinois State Water Survey/IDPH well construction reports); no static water level field in public layer so static columns blank; Private-well count may include a few legacy records with approximate dates; TOTAL_DEPTH used as depth
  • New Mexico Office of the State Engineer (OSE) Points of Diversion (well records from driller logs) (use_ IN ('DOM','DOL','PDM','PDL') = 72-12-1 domestic one household, domestic+livestock, and non-72-12-1 domestic / domestic+livestock; excludes pod_status CLW (changed location of well)), 140,658 records. Source
    Caveats: Static level = static_level falling back to depth_water; feet; Includes plugged/inactive wells (only pod_status CLW excluded); no hard dedupe key (a well with several POD suffixes may repeat); Domestic = standardised use_ code DOM/DOL/PDM/PDL, not the free-text use_of_well; One 'Xx' county code (285 records) is not a real county
  • Water Wells (NYSDEC Water Well Contractor Program completion reports, since April 2000) via NY GIS Clearinghouse (WELLTYPE in ('Domestic','domestic supply') exact (mixed-use strings like Domestic/Irrigation excluded; geothermal excluded)), 129,786 records. Source
    Caveats: Layer has no static level or completion date, so those columns and era splits are blank; PUMPCAP (pump capacity, gpm) used as yield - may be pump rating/test rate rather than a measured yield; Statewide upstate-focused; Suffolk dominates (shallow Long Island wells), county mix skews depth low; Reports are submitted by drillers and not verified
  • Coastal Plain Well Inventory (SCDNR_Coastal_Plain_Well_Inventory), South Carolina Department of Natural Resources / SC Dept of Environmental Services Hydrology (WELL_USE='DOM' (domestic)), 4,422 records. Source
    Caveats: Coastal Plain province ONLY (about 25 counties); no Piedmont/Blue Ridge counties - SC has no statewide driller-log database online; Inventory is not a complete list of Coastal Plain wells (SCDNR disclaimer); only 4,422 DOM records; Static level from WL_FT text, not all rows parseable
  • Texas Water Development Board Submitted Driller Reports (ProposedUse='Domestic' and WellType not 'Reconditioning' (TWDB Submitted Driller Reports; depth = BoreholeDepthFt; no static level or yield fields)), 292,575 records. Source
    Caveats: DateOfWellCompletion makes the server return HTTP 400 on query, so era splits (pre1990, 2010on) are blank
  • NHDES / NH Geological Survey Water Well Inventory (well completion reports) (USE_ in ('DOMESTIC','DOMESTIC DRINKING WATER') (excludes geothermal, test, ag, community supply, municipal etc.)), 48,709 records. Source
    Caveats: Layer holds georeferenced wells only (~56k of >135k reports on NHDES OneStop); Fields are strings in source; parsed numerically; County derived from TOWN via Census 2020 county subdivisions; unmapped towns go to (unknown); Static level = SWL (feet below land surface); yield = YTQ (gpm); depth = TOTD (total depth)
  • Wisconsin Well Inventory (Well Construction Reports, private wells), Wisconsin Department of Natural Resources (WELL_USE='PRIVATE POTABLE' from SOURCE_DATABASE='WELL CONSTRUCTION' (private well construction reports; excludes private non-potable, monitoring, loop/heat exchange, public/municipal, high-capacity)), 494,210 records. Source
    Caveats: Wisconsin DNR Well Inventory (Well Construction Reports from private-well system, 1936-present); layer includes all well-construction types New/Replacement/Reconstruction so a property can have several records; Static level read as depth below surface; STATIC_WATER_LEV_ABOVE_BELOW not used, so a few flowing/above-ground levels may be counted as positive depth; Pumping rate is drillers' test rate in gpm
  • Non-Public Wells permit database (DNREC Division of Water, Residential Services; Delaware Environmental Navigator) via FirstMap (WellType='Domestic - Standard' and WellStatus in (Active, Completed)), 77,962 records. Source
    Caveats: Permit records, not driller logs: depth = TotalDepthActual, falling back to TotalDepthProp (proposed) when actual is 0; Static level = StaticWaterLevel, yield = PumpTestRate (gpm); zeros treated as missing; County assigned by point-in-polygon of Latitude/longitude against Census TIGERweb county polygons (layer has no county field); Date = ActualConstructionDate, else CompletionReportDate; many wells in Coastal Plain are shallow (<150 ft); Some well locations may be redacted/approximate per Delaware law
  • Arizona Department of Water Resources well registry (WATER_USE='DOMESTIC' (exact, excludes combined-use strings) and not WELL_CANCELLED='Y'), 99,754 records. Source
  • Ohio DNR water well log records (WELL_USE='DOMESTIC'), 417,876 records. Source
  • Colorado Division of Water Resources (DWR) well permits (CDSS REST API) (associatedUses contains Domestic or Household use only, with no Commercial/Industrial/Municipal/Augmentation/Geothermal/Dewatering/Monitoring/Irrigation-free-of-domestic etc. (Domestic+Stock/Irrigation allowed); excludes application/permit-stage records never built; deduped on permit number), 148,007 records. Source
    Caveats: PARTIAL: CDSS REST anonymous daily data limit ('Exceeded Daily Data Limit', HTTP 403) hit after 38 of 64 counties; missing counties: EL PASO, MESA, MINERAL, MOFFAT, MONTEZUMA, MONTROSE, MORGAN, OTERO, OURAY, PARK, PHILLIPS, PITKIN, PROWERS, PUEBLO, RIO BLANCO, RIO GRANDE, ROUTT, SAGUACHE, SAN JUAN, SAN MIGUEL, SEDGWICK, SUMMIT, TELLER, WASHINGTON, WELD, YUMA. Re-run tools/extra/fetch_co.py (skips existing) then run_co.py after the quota resets; Source is the Division of Water Resources (DWR) well permit database via the CDSS REST API v2 wellpermits; one request per county; Domestic = associatedUses includes Domestic or Household use only and none of Commercial/Industrial/Municipal/Augmentation/Geothermal/Dewatering/Monitoring/Power/Fishery/Recharge/Recreation/Replacement/Snow Making/Fire/Wildlife; Domestic+Stock and Domestic+Irrigation kept; Records at application/permit-issued/expired/cancelled stage (never built) excluded; abandoned, replaced and final-permit records kept; depthTotal, staticWaterLevel (feet) and pumpTestYield (gpm) come from well construction reports; many older permits have no depth (n_with_depth < n_records), static level and yield especially sparse; Date = dateWellCompleted; dedupe on permit number
  • Wyoming State Engineer's Office (SEO) groundwater well permits, via Wyoming State Geological Survey (Uses contains DOM_GW and no IRR_GW/IND_GW/MUN_GW/CBM/MON/TST (DOM_GW with STK/MIS allowed); deduped on permit number+prefix+suffix), 76,626 records. Source
    Caveats: Source is the WSGS compilation of Wyoming State Engineer's Office (SEO) ePermit groundwater well permits as of 2023-09-01 (not a live feed); no ArcGIS REST service found; Domestic permits often have no depth/static level (only wells with a driller log or completion report carry Total_dept/StaticWate), so n_with_depth is much smaller than n_records and may skew to newer/bigger wells; County not in source: assigned by point-in-polygon of Longitude/Latitude against Census TIGERweb county polygons (4 permits unplaced -> (unknown)); Date used for era splits = permit priority date (not well completion date); Yield left blank: Total_Flow is the permitted/claimed rate, not a tested yield; Permits include inactive/cancelled ones (IsActive not filtered)
  • Kansas Geological Survey WWC5 water well records (WELL_TYPE_CATEGORY='Domestic' (USE_DESC Domestic; Domestic+Lawn/Garden; Domestic+Livestock; Domestic changed from ...)), 150,792 records. Source

Cleaning

We keep household or domestic wells only (using each state's own use code), drop depths of 0 or more than 5,000 ft, yields of 0 or more than 5,000 gallons per minute, and negative or implausible water levels. We report medians, not averages, because a few very deep wells would distort an average.

Thresholds

County statistics are shown only where a county has at least 30 records. Decade and before/after comparisons also need 30 records per group.

County pages

A county gets its own page when state records list at least 200 household wells. Depth bands (under 100 ft, 100 to 300, 300 to 500, 500 or more) are shares of wells with a recorded depth. The water standing in a typical well is the median depth minus the median static water level, converted to gallons for a 6-inch casing (1.47 gallons per foot).

Drilling cost estimates

County drilling estimates multiply the county median depth by a published per-foot range for drilling alone ($25 to $65 per foot, Angi 2026 cost guide). They exclude casing, pump, tank, wiring and permits and are not quotes.

Measured water quality

Where available, county pages show groundwater results from the Water Quality Portal (USGS, EPA and state agencies). We use the most recent result per well since 1990, compare it with the federal limit named in the table, and show a county only when at least 10 wells were tested. Sampled wells include monitoring and public-supply wells, so the share over a limit is not the share of private wells over it.

Neighbouring counties

From the US Census Bureau county adjacency file (2024).

Who compiles this

The datasets and county pages are compiled by Rohit S, Editor and data lead.

Arsenic estimates

USGS estimated the probability that a household well exceeds 10 µg/L of arsenic and multiplied it by the number of people using household wells (2010). We sum those county estimates by state. They are model estimates and do not describe any single well.

Limits

Well records describe wells when they were drilled. Not every state publishes digital records, and records are not a count of active wells. Driller-reported depths and yields are not independently verified.

Updates

Last built 2026-11-19. We rebuild when sources update.