Original data research from the PlainWater editorial team. Every page is rendered server-side from a live SELECT against the portal database; no numbers are hardcoded.
EPA Safe Drinking Water Information System (SDWIS) data ranking all US states by total drinking water act violations. Rendered server-side from a live SELECT against the PlainWater states table — every number on the page derives from the current ETL snapshot of EPA SDWIS.
EPA UCMR5 (Unregulated Contaminant Monitoring Rule, fifth cycle) data ranks per- and polyfluoroalkyl substances (PFAS) by the share of public-water-system samples in which each compound was detected at or above the minimum reporting level. Rendered live from the PlainWater pfas_contaminants table.
EPA UCMR5 PFAS occurrence data aggregated to the state level — rates reflect the share of tested public water systems in each state with at least one PFAS analyte detected at or above the minimum reporting level. Live SSR query against the PlainWater states table.