Climate Change Risk Index for 1,455 US Municipal Drinking Water Utilities (CMU KiltHub)

Provider
Zia Lyle, Constantine Samaras, Jeanne VanBriesen (Carnegie Mellon University)
License
CC-BY-4.0 (source)
Size
4 files
Format
Parquet (in sampled files)
Stored at
Hugging Face (https://huggingface.co/datasets/CMU-OSPO/Climate_Change_Risk_Index_Values_for_Medium-_and_Large-_Municipal_Drinking_Water_Utilities)
Access
Free and public. No account with the data provider is needed.
DOI
10.1184/R1/28169504.v2
Category
Climate & Weather
Source
https://huggingface.co/datasets/CMU-OSPO/Climate_Change_Risk_Index_Values_for_Medium-_and_Large-_Municipal_Drinking_Water_Utilities

About this dataset

Climate hazard projections, exposure and vulnerability indicators, and a comparative climate risk index for 1,455 medium and large municipal drinking water systems in the contiguous United States, compiled at Carnegie Mellon University from public sources. Each row is one public water system, keyed by its EPA Public Water System ID (pwsid), with population served, service connections, primary source water type and NOAA climate region. The 49 variables include historical and mid-century RCP4.5 projections of 5-day maximum precipitation, 5-day maximum temperature, average temperature and precipitation, freeze-thaw cycles, wildfire risk, a sea level rise indicator, energy demand and water stress, plus financial and social vulnerability measures such as average bond rating, operating ratio, water quality noncompliance score, median housing age, poverty rate and annual service cost. These feed hazard, exposure, vulnerability and overall risk indices. The Hugging Face copy, made by CMU's Open Source Programs Office, is one Parquet table that loads with the datasets library or pandas; the authors' README with variable definitions is on KiltHub. License CC BY 4.0. Cite Lyle, Samaras and VanBriesen (2025), Carnegie Mellon University, DOI 10.1184/R1/28169504.v2.

How to load this dataset in Python

from datasets import load_dataset
ds = load_dataset("CMU-OSPO/Climate_Change_Risk_Index_Values_for_Medium-_and_Large-_Municipal_Drinking_Water_Utilities")
print(ds)

Data structure

File types in sampled files: Parquet

Files

Example file: dwutils_climateriskindex_dataset/train-00000-of-00001.parquet

Analyze this dataset without downloading it

On Scigantic, Climate Change Risk Index for 1,455 US Municipal Drinking Water Utilities (CMU KiltHub) opens in a hosted JupyterLab notebook with the data already mounted, so you can read files where they are stored instead of copying them first. Each notebook includes an AI assistant that can see the mounted files and write and run analysis code. Open the dataset page to launch a notebook, or browse the full catalog.

This page is also available as Markdown and as JSON.

Related Climate & Weather datasets