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
- Ensemble Meteorological Dataset for Planet Earth, EM-Earth
- NOAA Real-Time Mesoscale Analysis (RTMA) / Unrestricted Mesoscale Analysis (URMA)
- GEOS-Chem Input Data
- GPM IMERG Late Precipitation L3 1 day 0.1 degree x 0.1 degree V07 (GPM_3IMERGDL) at GES DISC
- NOAA RRFS Ensemble Forecast System (REFS) Ensemble Means, Spreads and Probabilities, dynamical.org Icechunk Zarr
- Met Office UK Marine Observations
- NCEP/CPC L3 Half Hourly 4km Global (60S - 60N) Merged IR V1 (GPM_MERGIR) at GES DISC
- Climate Ready Boston sea level rise inundation and social vulnerability