Colorado Covid Wastewater Dashboard 

Important Note: As of August 2023, some utilities have dropped out of the CDPHE Wastewater program, including two included in this model.  Per communication from CDPHE staff, the Wellington Water and Sewer & Fort-Collins Boxelder are no longer reporting COVID Viral Copies to CDPHE. Due to their absence, a new regression model was developed, including only the utilities that are still reporting through the program.  This new model actually has a slightly better correlation (.9677 vs .9662)  with the 7 day average Cases, and a slightly higher r-squared (.9365 vs .9335), meaning this model is slightly more accurate than the original model, depite relying on two less utilities.  All figures in the graph above now reflect the revised model. 

The above dashboard uses the COVID copies measured in Colorado Wastewater to estimate the actual number of cases of COVID occurring in the state at the time of the most recent wastewater data report.  It uses data from 20 Wastewater Utilities in the state of Colorado,  who have reported wastewater viral copies since their start date, mostly August 2020, with one being added in Occtober 2020. The included wastewater utilities are  Aurora, Berthoud, Boulder, Broomfield, CO Springs - JD Phillips, CO Springs - Las Vegas, Fort Collins - Boxelder, Fort Collins - Drake, Fort Collins - Mulberry, Greeley, Longmont, Louisville, Loveland, Metro WW - Clear Creek, Metro WW - Platte/Central, Pueblo, South Adams County, South Fort Collins, South Platte, Wellington Water and Sewer. 

Data is updated weekly (usually on Saturday afternoon after 5pm).  

This is an independent project that relies on data using data produced by CDPHE and the CDC, but not affiliated with CDPHE or the CDC in any way.  The developer affirms that there are no conflicts associated with this work that affect the integrity of the work. 

Read all about this tool, its validity and development here: https://docs.google.com/document/d/e/2PACX-1vQWXO5zGeMa7uSq3wy-OKIQbybLgPI4lbtvK9UBwL0BDCTTeDHQ5n-JHuU7tG9IJyjQ_CRdk1ExCKiP/pub 

To see CDPHE's own summary wastewater data, please CLICK HERE

This tool was built using data from the CDPHE COVID Wastewater tool, available here; https://cdphe.maps.arcgis.com/apps/dashboards/d79cf93c3938470ca4bcc4823328946b. 

It compares the wastewater trends to case data from the CDPHE site, available here: https://drive.google.com/drive/folders/17MWRnHYUhlv19CnoFxbRj3OTGBqlPaar

And uses population data posted on the CDC NWSS available here: https://www.cdc.gov/nwss/reporting/index.html?CDC_AA_refVal=https%3A%2F%2Fwww.cdc.gov%2Fhealthywater%2Fsurveillance%2Fwastewater-surveillance%2Fdata-reporting-analytics.html

Thank you to the many people who have made this data available, especially hardworking public health staff, wastewater workers, and scientists.