Abstract

The Colorado All Payer Claims Database (CO APCD) is a state-legislated, secure health care claims database compliant with all federal privacy laws. It contains nearly 920 million claims for approximately 65 percent of insured lives in Colorado, with information from 42 commercial health insurance plans. Health insurance payers submit data monthly and the entire database is refreshed every other month, so the CO ACPD is continually evolving and being enhanced.

Usage

The dataset was extracted by the Center for Improving Value in Health Care (CIVHC) to support Stanford University COVID Long Haul Analysis. It includes medical, pharmacy, and dental claims files with coverage dates from 01/01/2012 to 08/31/2021.

For more information of CO APCD please refer to https://www.civhc.org/get-data/whats-in-the-co-apcd/

Before Manuscript Submission

All manuscripts (and other items you'd like to publish) must be submitted to

phsdatacore@stanford.edu for approval prior to journal submission.

We will check your cell sizes and citations.

For more information about how to cite PHS and PHS datasets, please visit:

https:/phsdocs.developerhub.io/need-help/citing-phs-data-core

Data Documentation

Metadata access is required to view this section.

These data are quality measures for each Utah small area calculated by the Utah Department of Health, Office of Healthcare Statistics (OHCS) using Utah’s All Payer Claims Database (APCD).

WA-APCD - Washington All-Payer Claims Database

The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018.

Download the attachment for the data dictionary and more information about WA-APCD and the data.

This dataset is designed to analyze prescription drug use and spending among New York State residents at the drug product level (pharmacy claims data that have been aggregated by labeler code and product code segments of the National Drug Code). The dataset includes the number of prescriptions filled by unique members by payer type, nonproprietary name, labeler name, dosage characteristics, amount insurer paid, and more.

This data set includes comparative cost and quality information for clinics with five or more physicians for medical claims in 2016. Only clinics with eligible Total Cost of Care indices and three quality measures, Breast Cancer Screening, A1c testing, and Medical Attention for Nephropathy are included.

This data set was calculated by the Utah Department of Health, Office of Healthcare Statistics (OHCS) and HealthInsight Utah using Utah’s All Payer Claims Database (APCD).

This dataset contains data for the Healthcare Payments Data (HPD) Snapshot visualization. The Enrollment data file contains counts of claims and encounter data collected for California's statewide HPD Program. It includes counts of enrollment records, service records from medical and pharmacy claims, and the number of individuals represented across these records. Aggregate counts are grouped by payer type (Commercial, Medi-Cal, or Medicare), product type, and year. The Medical data file contains counts of medical procedures from medical claims and encounter data in HPD. Procedures are categorized using claim line procedure codes and grouped by year, type of setting (e.g., outpatient, laboratory, ambulance), and payer type. The Pharmacy data file contains counts of drug prescriptions from pharmacy claims and encounter data in HPD. Prescriptions are categorized by name and drug class using the reported National Drug Code (NDC) and grouped by year, payer type, and whether the drug dispensed is branded or a generic.

Analysis of ‘WA-APCD Quality and Cost Summary Report: Practice Quality’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/10d4ddee-0987-4f16-a780-430181a47bf2 on 28 January 2022.

--- Dataset description provided by original source is as follows ---

WA-APCD - Washington All-Payer Claims Database

The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018.

Download the attachment for the data dictionary and more information about WA-APCD and the data.

--- Original source retains full ownership of the source dataset ---

Analysis of ‘WA-APCD Quality and Cost Summary Report: County Cost’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/d69107cb-99d1-40ec-93f3-b94800f5e61e on 26 January 2022.

--- Dataset description provided by original source is as follows ---

WA-APCD - Washington All-Payer Claims Database

The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018.

Download the attachment for the data dictionary and more information about WA-APCD and the data.

--- Original source retains full ownership of the source dataset ---

Analysis of ‘WA-APCD Quality and Cost Summary Report: Hospital Quality’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/13e6499e-0f20-42f7-b51c-0dc0174855a9 on 12 November 2021.

--- Dataset description provided by original source is as follows ---

WA-APCD - Washington All-Payer Claims Database

The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018.

Download the attachment for the data dictionary and more information about WA-APCD and the data.

--- Original source retains full ownership of the source dataset ---

This dataset is designed to analyze prescription drug use and spending among New York State residents at the active ingredient level. The dataset includes the number of prescriptions filled by unique members by payer type, rankings by volume, nonproprietary name, amount insurer paid, and more.

This dataset is designed to analyze prescription drug use and spending among New York State residents at the drug product level (pharmacy claims data that have been aggregated by labeler code and product code segments of the National Drug Code). The dataset includes the number of prescriptions filled by unique members by payer type, nonproprietary name, labeler name, dosage characteristics, amount insurer paid, and more.

The All-Payer TCOC is calculated for most Vermont residents with claims available in VHCURES, the state’s All Payer Claims Database. Since some people have more than one type of coverage (e.g. both Medicare and Medicaid), each person is assigned a primary payer type for the month. Any claims incurred for the month (based on first service date) are included for the month’s spending, whether that care was in Vermont or outside of Vermont. The TCOC is based on allowed amounts, which includes both what the insurer paid and the member’s responsibility (i.e. copayments, coinsurance, and deductibles). It is also limited to claims paid as primary.

Analysis of ‘WA-APCD Quality and Cost Summary Report: Facility Cost’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/8b31c8cf-0fbe-4d8e-abcd-1b2540a62470 on 12 November 2021.

--- Dataset description provided by original source is as follows ---

WA-APCD - Washington All Payers Claims Database

The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018.

Download the attachment for the data dictionary and more information about WA-APCD and the data.

--- Original source retains full ownership of the source dataset ---

This dataset is designed to analyze prescription drug use and spending among New York State residents at the drug product level (pharmacy claims data that have been aggregated by labeler code and product code segments of the National Drug Code). The dataset includes the number of prescriptions filled by unique members by payer type, nonproprietary name, labeler name, dosage characteristics, amount insurer paid, and more.

Variables and data resources in the study.

Ever wonder how many claims or people are in the Colorado All Payer Claims Database (CO APCD), and how it differs by type of claim (medical, dental, pharmacy), by year and by payer type? Use this interactive dashboard to understand what the CO APCD includes and what percentage of the population is represented in each county. Additional information is also available on race and ethnicity data, behavioral health services, dental code volume, and vision claims that are in the data warehouse under the Resources link.

This dataset is designed to analyze prescription drug use and spending among New York State residents at the active ingredient level. The dataset includes the number of prescriptions filled by unique members by payer type, rankings by volume, nonproprietary name, amount insurer paid, and more.

WA-APCD - Washington All-Payer Claims Database

The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018.

Download the attachment for the data dictionary and more information about WA-APCD and the data.

This data set includes comparative information for clinics in Utah for medical claims for the years 2017 and 2018.

This data set was calculated by the Utah Department of Health, Office of Healthcare Statistics (OHCS) using Utah’s All Payer Claims Database (APCD).

Prior years (2015-2016) may be viewed at: https://opendata.utah.gov/Health/2016-2015-Clinic-Quality-Comparisons-for-Clinics-w/35s3-nmpm

These data are quality measures for each Utah small area calculated by the Utah Department of Health, Office of Healthcare Statistics (OHCS) using Utah’s All Payer Claims Database (APCD).