The question and the result
We asked whether a reader can obtain a numerical construction depth, reported rate and static-water field from specific public index queries. The table separates a missing value in a requested field from a measurement that was not part of that query. Neither implies the underlying paper or scanned file has no additional information.
| Index | Rows | Positive depth | Non-negative reported rate | Non-negative static value |
|---|---|---|---|---|
| Maine | 50 | 50/50WELL_DEPTH_FT | 32/50WELL_YIELD_GPM | 2/50WELL_STATIC_LEVEL_FT |
| Pennsylvania | 50 | 41/50Well_Depth | 32/50Well_Yield_GPM | Not in audited query |
| Colorado | 50 | 17/50well_depth | 6/50yield | 16/50static_water_level |
| New Hampshire | 50 | 50/50TOTD | 50/50YTQ | 29/50SWL; 1 source zero(s), verify meaning |
| Texas | 50 | 50/50BoreholeDepthFt | Not in audited query | Not in audited query |
| Minnesota | 50 | 50/50depth_drll | Not in audited query | 47/50swlavgmeas |
Download all 300 audit rows (CSV)
A numerical value passes only a parsing and sign check. It is not validated against a physical well. In particular, source zeros require their original meaning to be checked; a numeric zero is retained separately from blank or unparseable data.
How to reproduce the audit
- Select the first 50 rows explicitly classified domestic in each index, ordered by that service's object identifier. These are convenience samples with no randomization or geographic balancing.
- Request only the documented allowlisted fields, without geometry, owner names or street addresses. Retain the exact IDs, query URL and UTC retrieval time.
- Count finite positive numbers for the selected depth field, and finite non-negative numbers for the rate and static fields. Keep absent, blank, negative and unparseable values out of those counts.
- Do not fill a missing drilled-depth value from a different field: Minnesota's drilled and completed depths are separate. Do not replace an unrequested yield field with another measurement.
- Use the retained-ID query to recheck those entries. A later first-50 selection can differ if an agency changes its inventory or identifiers.
- Maine: Maine Geological Survey. Retrieved October 29, 2026, 08:08 PM EDT. Repeat selection ↗ · Recheck the retained IDs ↗ · Agency documentation ↗
- Pennsylvania: Pennsylvania Geological Survey. Retrieved October 29, 2026, 08:08 PM EDT. Repeat selection ↗ · Recheck the retained IDs ↗ · Agency documentation ↗
- Colorado: Colorado Division of Water Resources. Retrieved October 29, 2026, 08:08 PM EDT. Repeat selection ↗ · Recheck the retained IDs ↗ · Agency documentation ↗
- New Hampshire: New Hampshire Geological Survey / NHDES. Retrieved October 29, 2026, 08:08 PM EDT. Repeat selection ↗ · Recheck the retained IDs ↗ · Agency documentation ↗
- Texas: Texas Water Development Board / TDLR. Retrieved October 29, 2026, 08:08 PM EDT. Repeat selection ↗ · Recheck the retained IDs ↗ · Agency documentation ↗
- Minnesota: Minnesota Department of Health / Minnesota Geological Survey. Retrieved October 29, 2026, 08:08 PM EDT. Repeat selection ↗ · Recheck the retained IDs ↗ · Agency documentation ↗
What this sample cannot tell you
Low object identifiers can cluster in particular places, periods or source batches. The samples do not estimate statewide completeness, compare states' well quality, represent all households or prove that a record belongs to a parcel. We have not audited every source field, accessed every scanned log, inspected any well or tested any water. No independent professional review has been completed for this audit.
Texas's table uses BoreholeDepthFt, not a verified completed-well depth. Its filtered query does not retain yield or static level. Minnesota's table uses depth_drll and swlavgmeas, an average-measurement field, not a fresh water-level reading. Pennsylvania's selected query does not contain a static field. Numerical rates in the other indexes preserve each source's historical meaning and test context; they are not interchangeable measures of present household supply.
Use the gaps to ask a better question
If a needed field is absent, trace the identifier to the full filing or ask the agency. If a nearby point has the wrong use or uncertain location, resolve relevance before comparing measurements. The annotated log guide and property document checklist show the next steps.
Prepared and published by WellLookup. Corrections: evidence and corrections policy. Retained-state-data SHA-256: 95e97cd6fbba4817437d7e0c1bb8fbe8d50f00c186b3d858a83f372a6ff9a3c8. This checksum identifies this release's stored state data; it is not a certification of source accuracy.