Claims data system for public water systems

Client only

An online intake tool, data pipeline, and dashboards that collected data from large numbers of water providers and screened lab reports and production data for eligibility in the AFFF settlements.

Illustration of data moving from an intake form through validation to a dashboard

The national PFAS settlements with water providers required each claimant to document its water sources, sampling results, and production volumes. For a consulting team filing on behalf of many providers at once, the hard part is collecting that information consistently and checking it before the deadline.

What it does

  • An online intake tool where water providers submit their information and documents directly.
  • Methods to screen lab reports and production records for eligibility under the settlement terms.
  • A data pipeline that tracks every water system and source from first contact to filed claim.
  • Dashboards that show the status of the whole effort, and the gaps, at a glance.

Together these supported claims for more than 1,800 water systems across the country.

Access is limited to the client team and participating water providers.

Built with Python, SQL, R, Dashboards.