artakulov/us-spanish-required-water-utilities

U.S. Water Systems Serving Spanish-LEP Communities

Version: 2026-07 (built 2026-09-13) Records: 1,449 U.S. public water systems whose service area meets California's published threshold for non-English-language CCR provisions, applied to Spanish-LEP as a national benchmark Granularity: Per utility (PWSID-keyed) License: CC-BY-4.0 Canonical URL: https://zipcheckup.com/data/open/ccr-rich-spanish/us-spanish-required-water-utilities-2026-05.json Version DOI: not minted; external publication is owner-gated Concept DOI: 10.5281/zenodo.20217878 (external archive; may lag this local version until publication) Parent dataset: 10.5281/zenodo.20216597 (full CCR-rich corpus)

Immutable predecessor lifecycle

• —Version 2026-05; DOI 10.5281/zenodo.20217879; Zenodo record https://zenodo.org/records/20217879; records 1454; status retired.
• —Version 2026-06; DOI 10.5281/zenodo.20592313; Zenodo record https://zenodo.org/records/20592313; records 1432; status published.

⚠ Correction notice (v2026-07)

The first version (v2026-05, DOI 10.5281/zenodo.20217879) framed this as utilities "federally required to publish Spanish-language CCRs." That framing was incorrect and has been retired. There is no federal list or numeric threshold requiring Spanish-language CCRs: under 40 CFR §141.153(h)(3), multilingual information is required only "in communities with a large proportion of LEP consumers as determined by the Primacy Agency," and a contact for a translated copy or assistance satisfies the rule — full translation is not federally mandated. The v1 inclusion field (bilingual_required) was derived from the near-universal EPA Spanish courtesy line ("Este informe contiene información muy importante…"), present in ~57.6% of all CCRs regardless of any mandate, so it tracked boilerplate, not obligation. See CHANGELOG.md and methodology.md.

What this is (v2026-07)

One accepted signal and one deliberately withheld signal:

1. 1.Service-area Spanish-LEP - Census ACS C16001 values are aggregated over direct service ZIPs. Percentage qualification is allowed only when every service ZIP has valid Census coverage. With partial coverage, the percentage and complete-area totals are null; a record can qualify only when its known Spanish-LEP count already exceeds 1,000, which is a safe lower bound.

1. 1.CCR language evidence - currently withheld. ccr_pdf_spanish, ccr_spanish_term_count, languages_listed, and multilingual_program are null until source text, period, extractor, and locator evidence are accepted. Null means unknown.

Headline coverage

State distribution (top 10)

Files

• —us-spanish-required-water-utilities-2026-05.json — canonical PWSID-keyed JSON (stable file slug retained for citation/mirror continuity)
• —us-spanish-required-water-utilities-2026-05.csv — flattened tabular
• —schema.json — JSON Schema 2020-12
• —methodology.md - regulatory basis, LEP derivation, and evidence caveats
• —CHANGELOG.md — version history incl. v1→v2 correction
• —CITATION.cff — citation metadata
• —zenodo.json — metadata template for owner-gated external publication
• —README.md — this exact eight-file package manifest

Citation

Akulov, A. (2026). U.S. Water Systems Serving Spanish-LEP Communities
(Version 2026-07). ZipCheckup. https://zipcheckup.com/data/open/ccr-rich-spanish/us-spanish-required-water-utilities-2026-05.json

License

CC BY 4.0. Source data: EPA SDWIS (public domain), Census ACS (public domain), utility-published CCR PDFs (public-record disclosures under SDWA §1414(c)).