Colorado Population Data Dashboard

 

The Colorado School of Public Health and the COVID-19 Modeling Group developed the Colorado Population Data Dashboard website to disseminate key information and population-level data related to the ongoing SARS-CoV-2 (COVID-19) pandemic. It was developed for decision-makers in Colorado, from the state to the local levels, and for private citizens who may find the information and models useful. It is designed to complement existing information available on the COVID-19 pandemic and provide a comprehensive picture of community-level characteristics to assist local decision-makers in both the short- and long-term recovery post-pandemic.

The mission of the Colorado School of Public Health is to promote the physical, mental, social, and environmental health of people and communities in the Rocky Mountain Region, across our nation, and globally. This mission will be accomplished through collaborations in education, population-based research, and community service that bring together institutions, agencies, and diverse populations.

The development of this website has been supported by the Gates Family Foundation, the Colorado Health Foundation and an anonymous donor. Throughout its development, input was obtained from a diverse group of stakeholders who will continue to help us improve the website resources into the future.

 

Why did we create this resource?

This website was developed for decision-makers in Colorado, from the state to the local levels, and for private citizens who may find the information and models useful.

The first version of the county data dashboards includes the following categories of indicators:

  • COVID-19 surveillance indicators (e.g., past 14-day case rates and positivity rates)
  • Demograhics (e.g., age and race)
  • Social and economic factors (e.g., education and insurance)
  • Health risks (e.g., diabetes, asthma and heart disease)
  • Mental health (e.g., suicide and alcohol consumption)
  • Economic activity (e.g., weekly filings for unemployment insurance benefits, Supplemental Nutrition Assistance Program monthly enrollment and monthly Medicaid enrollment)
  • Mobility patterns (e.g., mobility patterns within and across counties)
  • Other factors that may increase a person’s and a population’s risk for contracting SARS-CoV-2 infection and the disease it causes—COVID-19 (e.g., working in essential jobs)

In developing this website, we have had input from many sectors, including state and local public health agencies, county commissioners, Colorado Human Services Directors Association and other local stakeholders.

We need your continued feedback. How can we make the website better fit your needs? What else would you like see? You may provide your comments via our Feedback page.

There are other resources on the COVID-19 pandemic in Colorado, the United States, and globally. Specifically, we call your attention to the website developed by the Colorado Department of Public Health and Environment which provides basic epidemiological data on COVID-19 in the state

 

Data used on our website and disease models

We use data from the following sources:

  • COVID-19 surveillance (test, cases, hospitalizations and deaths):
    • Colorado Department of Public Health and Environment (CDPHE)
  • Demographic and socio-economic factors:
    • Colorado State Demography Office
    • United States Census Bureau: American Community Survey 5-Year Estimates
    • Centers for Disease Control & Prevention (CDC): Social Vulnerability Index
  • Health risks (co-morbidity):
    • CDPHE: Colorado Behavioral Risk Factor Surveillance System
    • CDC: County-Level Comorbidity Prevalence Estimates; Wide-ranging Online Data for Epidemiologic Research (CDC WONDER) Underlying Cause of Death
    • Centers for Medicare & Medicaid Services (CMS): Chronic Condition Warehouse for Medicare BeneficiariesAgency for Healthcare Research and Quality (AHRQ): Hospital Cost Utilization Project State Inpatient Database
  • Mobility patterns: SafeGraph
  • Economic activity: Homebase
  • Unemployment insurance weekly claims: Colorado Department of Labor and Employment
  • Medicaid monthly enrollment: Colorado Department of Health Care Policy and Financing
  • Supplemental Nutrition Assistance Program (SNAP) monthly enrollment: Colorado Department of Human Services, Office of Economic Security

Download the Colorado Population Dashboard dataset.

Download the Colorado Population Dashboard data dictionary.

 

Mobility Data Privacy Information

We are aware of concerns related to the use of mobile device (mobility) data and assuring that privacy is maintained. First, we emphasize that all data presented on this website is anonymized and aggregated to the county level. We have no information about specific individuals.

We use mobile device data from SafeGraph, which aggregates anonymized mobile device data and provides two products. We use the Social Distancing Metrics dataset (SDM) to document broad trends in where people are spending time. The SDMs are aggregated to the Census block group level. To enhance privacy, SafeGraph excludes census block group information if fewer than five devices visited an establishment in a month from a given census block group. We aggregate these block group measures up to the county by calculating the mean of the values of all census block groups within a county.

For more information and steps to opt-out of sharing your mobile device data and location, visit SafeGraph's privacy policy page.

 

Coming Soon

 

Clearinghouse for Up-to-Date Rigorous Scientific Evidence on COVID-19 and Related Topics

The scientific literature on SARS-CoV-2 and COVID-19 has grown at a breath-taking pace. We will use the website to identify and make available some of the most significant reports, providing some commentary to guide readers. The website will also curate a library of the latest evidence on the COVID-19 pandemic. It will place the references in sub-categories which can be readily accessed by our various stakeholders (for example, mode of transmission, effectiveness of social distancing and mask-wearing and factors associated with disease severity)

 

County COVID-19 Stories

The quantitative data represented in this website helps improve our understanding of various factors that may influence a county’s ability to effectively mitigate and suppress COVID-19 while addressing its many consequences (for example, decrease in small business revenue, long-term unemployment and loss of health insurance). While it is helpful, it doesn’t fully capture the nuanced dynamics that may be specific to counties.

We will work with our local partners spanning various sectors to capture their insights into how the pandemic has affected their communities. Initially, we will select three to five counties with representation from rural, frontier and urban regions. We will conduct interviews with a diverse group of stakeholders with the goal of providing a more nuanced understanding of the impact of COVID-19 on their economies, population health and other relevant areas.