About this Dataset

Healthcare Payments Data Snapshot

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.
Organization: State of California
Last updated: 2025-08-23T13:02:35.566921
Tags: all-payer-claims, apcd, department-of-health-care-access-and-information, enrollment, hcai, healthcare-payments-data, hpd, medical-claims, pharmacy-claims

Tables

Data Dictionary: HPD Snapshot - Enrollment

@usgov.ca_gov_healthcare_payments_data_snapshot_f977f.data_dictionary_hpd_snapshot_enrollment

4.63 kB
8 rows
4 columns

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

Data Dictionary: HPD Snapshot - Medical

@usgov.ca_gov_healthcare_payments_data_snapshot_f977f.data_dictionary_hpd_snapshot_medical

4.97 kB
5 rows
4 columns

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

Data Dictionary: HPD Snapshot - Pharmacy

@usgov.ca_gov_healthcare_payments_data_snapshot_f977f.data_dictionary_hpd_snapshot_pharmacy

4.5 kB
6 rows
4 columns

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

HPD Snapshot Data - Enrollment (2018-2023)

@usgov.ca_gov_healthcare_payments_data_snapshot_f977f.hpd_snapshot_data_enrollment_2018_2023

13.91 kB
1,503 rows
8 columns

CREATE TABLE hpd_snapshot_data_enrollment_2018_2023 (
  "product_type" VARCHAR,
  "reporting_year" BIGINT,
  "claim_type" VARCHAR,
  "payer_type" VARCHAR,
  "record_type" VARCHAR,
  "metric_id" BIGINT,
  "metric_name" VARCHAR,
  "count" BIGINT
);

HPD Snapshot Data - Medical (2018-2023)

@usgov.ca_gov_healthcare_payments_data_snapshot_f977f.hpd_snapshot_data_medical_2018_2023

104.54 kB
12,881 rows
5 columns

CREATE TABLE hpd_snapshot_data_medical_2018_2023 (
  "procedure_category" VARCHAR,
  "reporting_year" BIGINT,
  "type_of_service" VARCHAR,
  "payer_type" VARCHAR,
  "record_count" BIGINT
);

HPD Snapshot Data - Pharmacy (2018-2023)

@usgov.ca_gov_healthcare_payments_data_snapshot_f977f.hpd_snapshot_data_pharmacy_2018_2023

359.96 kB
59,951 rows
6 columns

CREATE TABLE hpd_snapshot_data_pharmacy_2018_2023 (
  "drug_name" VARCHAR,
  "reporting_year" BIGINT,
  "drug_class" VARCHAR,
  "brand_generic" VARCHAR,
  "payer_type" VARCHAR,
  "prescription_count" BIGINT
);