Defining Data Quality in the CO APCD

Claims data is very different than other types of data typically encountered by actuaries, accountants, analysts, and researchers. If not prepared for the unique challenges it presents, it is easy to conclude that something is wrong with a data set. The phrase “data quality” is frequently used as a catch-all Read more

By Stephanie Spriggs, ago

CIVHC Launches Updated Insights Dashboard with New Accessibility, Equity, and Usability Features

The Center for Improving Value in Health Care (CIVHC) unveiled a newly enhanced version of its Colorado All Payer Claims Database (CO APCD) Insights Dashboard, featuring major usability and design upgrades focused on accessibility and expanded functionality. The new dashboard is available now at civhc.org. This interactive dashboard allows users Read more

By Sarah Ford, ago

In-Warehouse Quality Checks and Data Processing

Once payer-submitted data has successfully passed the extensive initial validation and quality tests performed by CIVHC and data manager Human Services Research Institute (HSRI) and NORC at the University of Chicago, the data are ready to be ingested into the warehouse. Previous queries have detailed the process for the monthly submission and intake Read more

By Sarah Ford, ago
A person uses a calculator on a desk with a laptop, glasses, and a stethoscope nearby, hinting at healthcare finances or medical billing, possibly leveraging APCD data.

Colorado’s Leadership in Health Care Cost Transparency

In recent years, health care price transparency tools have become increasingly popular as more states begin to prioritize cost transparency initiatives. Legislation mandating health care price transparency has passed at the state and federal levels in an effort to empower consumers with understandable, actionable information on health care costs. However, while Read more

By Sarah Ford, ago
Link to infographic describing phasegate steps

Phasegate

In fiscal year 2023-2024, CIVHC’s Data Operations team implemented a new project management process, PhaseGate, to ensure projects moving through CIVHC’s teams are successful. The process divides development into distinct stages, or phases, separated by decision points, known as gates. The PhaseGate process is effective because it helps teams break Read more

By Sarah Ford, ago
Line chart illustrating the number of Medicare Advantage payers included in the Colorado All Payer Claims Database (CO APCD) from 2013 to 2023. The chart shows a starting count of 10 payers in 2013, a dip to 9 in 2014, followed by an increase to 12 payers in 2020 and 2022, before declining to 10 payers again in 2023. This visual highlights changes in Medicare Advantage payer participation over the years.

Medicare Data in the CO APCD

As of June 2023, the Colorado All Payer Claims Database (CO APCD) contained over one billion claims spanning 2013 through 2022. These claims were submitted by commercial health insurance plans, including Medicare Advantage, voluntarily submitted Employee Retirement Income Security Act (ERISA) and mandated non-ERISA self-insured employer plans, Medicaid, and Medicare Fee-for-Service (FFS). The CO Read more

By CIVHC, ago