Lead Service Lines and Tap Water Risk Across Chicago Neighborhoods

The heaviest lead/galvanized/unknown service-line replacement burden concentrates in lower-income, majority-Black and majority-Latino South and West S

The real public data behind Lead Service Lines and Tap Water Risk Across Chicago Neighborhoods. Chicago lead water service line inventory aggregated to community areas and census tracts (with 2023 ACS demographics). Files are hosted here directly so the analysis is reproducible; analysis.py reads only these files and prints the figures the paper reports.

• analysis.py

  Reproducible pandas script. Verifies the developments file is a subset of the portfolio, isolates OCII Western Addition-Area 2 (21 developments / 914 units / 821 income-restricted), tabulates tenure a

  Source: Inside Climate News / Grist / WBEZ (compiled from the City of Chicago Department of Water Management 2025 service line inventory submitted to the Illinois EPA, plus U.S. Census ACS 2023 5-year)

  18.2 kBDownload PYView at source

  This file is not a tabular CSV. Use the download button above to save it locally.

• chicago-community-areas-lead.csv

  Lead service-line inventory aggregated to Chicago's 77 community areas with ACS 2023 demographics. Real file copied unchanged from the Inside Climate News repo (processed_data/chicago_community_areas.

  Source: Inside Climate News / Grist / WBEZ (compiled from the City of Chicago Department of Water Management 2025 service line inventory submitted to the Illinois EPA, plus U.S. Census ACS 2023 5-year)

Documented Schema

What the cleaned archive will contain when complete. Column names and types may evolve until the archive ships.