United States Comprehensive Drinking Water Database

This project aims to create a database that is structured to function as a Comprehensive Drinking Water Database (CDWD). The CDWD will integrate the Safe Drinking Water Information System (SDWIS) reports, Census data, and community water system estimated service area boundaries datasets. The CDWD will facilitate research studies that assess the relationship between drinking water quality, race/ethnicity, and socioeconomics at the national, state, county, or community water system (CWS) level. The DWJL research team must currently manually construct a variable for a CWS without violations; this process will be automated, reducing the potential for human error and saving valuable time. This database tool will feature an easy-to-use interface and RStudio scripts for as-needed custom programming.

Research Assistants: Meena Muthusubramanian (Lead) & Ritvik Singh

Faculty Advisor: Dr. Doug Fisher, Dr. Ke Jack Ding, & Dr. Yolanda J. McDonald