About this Dataset

Healthcare Payments Data (HPD) Healthcare Measures

This dataset contains data for the Healthcare Payments Data (HPD) Healthcare Measures report. The data cover three measurement categories: Health conditions, Utilization, and Demographics. The health condition measurements quantify the prevalence of long-term illnesses and major medical events prominent in California’s communities like diabetes and heart failure. Utilization measures convey rates of healthcare system use through visits to the emergency department and different categories of inpatient stays, such as maternity or surgical stays. The demographic measures describe the health coverage and other characteristics (e.g., age) of the Californians included in the data and represented in the other measures. The data include both a count or sum of each measure and a count of the base population so that data users can calculate the percentages, rates, and averages in the visualization.
Measures are grouped by year, age band, sex (assigned sex at birth), payer type, Covered California Region, and county.
Organization: State of California
Last updated: 2025-07-23T14:38:43.781446
Tags: all-payer-claims-database, apcd, chronic-conditions, department-of-health-care-access-and-information, ed-utilization, enrollment, hcai, health-conditions, healthcare-payments-data, hpd, inpatient-utilization, utilization

Tables

HPD Measures Data (2018-2021)

@usgov.ca_gov_healthcare_payments_data_hpd_healthcare_measures_9f673.hpd_measures_data_2018_2021

1.03 MB
344428 rows
12 columns


CREATE TABLE hpd_measures_data_2018_2021 (
  "reporting_year" BIGINT,
  "age_band" VARCHAR,
  "assigned_sex_at_birth" VARCHAR,
  "county_name" VARCHAR,
  "county_name_plus_spa" VARCHAR,
  "covered_california_region" VARCHAR,
  "payer_type" VARCHAR,
  "measure_id" BIGINT,
  "measure_numerator" DOUBLE,
  "measure_denominator" DOUBLE,
  "measure_scaling_factor" BIGINT,
  "suppression_ind" VARCHAR
);

HPD Measures Data (2018-2023)

@usgov.ca_gov_healthcare_payments_data_hpd_healthcare_measures_9f673.hpd_measures_data_2018_2023

1.44 MB
523584 rows
12 columns


CREATE TABLE hpd_measures_data_2018_2023 (
  "reporting_year" BIGINT,
  "age_band" VARCHAR,
  "assigned_sex_at_birth" VARCHAR,
  "covered_california_region" VARCHAR,
  "geo_type" VARCHAR,
  "geo_value" VARCHAR,
  "payer_type" VARCHAR,
  "measure_id" BIGINT,
  "measure_numerator" DOUBLE,
  "measure_denominator" DOUBLE,
  "measure_scaling_factor" BIGINT,
  "suppression_ind" VARCHAR
);

HPD Measures - Data Dictionary

@usgov.ca_gov_healthcare_payments_data_hpd_healthcare_measures_9f673.hpd_measures_data_dictionary

5.62 KB
12 rows
4 columns


CREATE TABLE hpd_measures_data_dictionary (
  "field_name" VARCHAR,
  "field_title" VARCHAR,
  "data_type" VARCHAR,
  "description" VARCHAR
);

HPD Measures - Measure Descriptions

@usgov.ca_gov_healthcare_payments_data_hpd_healthcare_measures_9f673.hpd_measures_measure_descriptions

10.1 KB
37 rows
6 columns


CREATE TABLE hpd_measures_measure_descriptions (
  "measure_id" BIGINT,
  "measure_name" VARCHAR,
  "measure_category" VARCHAR,
  "measure_description" VARCHAR,
  "numerator_definition" VARCHAR,
  "denominator_definition" VARCHAR
);