About this Dataset

Public Hospital Redesign And Incentives In Medi-Cal (PRIME) Program Demonstration Year 11 – Demonstration Year 15 Data

This data is from the Public Hospital Redesign and Incentives in Medi-Cal (PRIME) program, part of California’s Medi-Cal 2020 1115 waiver approved by the Centers for Medicare and Medicaid Services (CMS). This dataset includes self-reported data from designated public hospitals (DPHs) and municipal public hospitals (DMPHs) and municipal public hospitals (DMPHs) annual reports, which include self-reported data on performance of PRIME required metrics.
Organization: State of California
Last updated: 2025-07-23T21:37:44.448474
Tags: 1115-waiver, california-department-of-health-care-services, dhcs, hospitals, prime, quality-health-care

Tables

Data Dictionary - Public Hospital Redesign And Incentives In Medi-Cal (PRIME) Program Demonstration Year 12 Data

@usgov.ca_gov_public_hospital_redesign_and_incentives_in_medi_2a94eca6.n__dictionary_public_hospital_redesign_and_incentives__0e85bca9

11.64 kB
16 rows
4 columns

CREATE TABLE n__dictionary_public_hospital_redesign_and_incentives__0e85bca9 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Public Hospital Redesign And Incentives In Medi-Cal (PRIME) Program Demonstration Year 13 Data

@usgov.ca_gov_public_hospital_redesign_and_incentives_in_medi_2a94eca6.n__dictionary_public_hospital_redesign_and_incentives__8ac566ae

11.6 kB
16 rows
4 columns

CREATE TABLE n__dictionary_public_hospital_redesign_and_incentives__8ac566ae (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Public Hospital Redesign And Incentives In Medi-Cal (PRIME) Program Demonstration Year 11 Data

@usgov.ca_gov_public_hospital_redesign_and_incentives_in_medi_2a94eca6.n__dictionary_public_hospital_redesign_and_incentives__dfafb7fa

11.6 kB
16 rows
4 columns

CREATE TABLE n__dictionary_public_hospital_redesign_and_incentives__dfafb7fa (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Public Hospital Redesign And Incentives In Medi-Cal (PRIME) Program Demonstration Year 15 Data

@usgov.ca_gov_public_hospital_redesign_and_incentives_in_medi_2a94eca6.public_hospital_redesign_and_incentives_in_medi_cal_pr_3ca876ab

56.88 kB
1,553 rows
15 columns

CREATE TABLE public_hospital_redesign_and_incentives_in_medi_cal_pr_3ca876ab (
  "dph_dmph" VARCHAR  -- DPH/ DMPH,
  "hospital" VARCHAR,
  "metric_number" VARCHAR,
  "metric_name" VARCHAR,
  "numerator" VARCHAR,
  "numerator_annotation_code" BIGINT,
  "denominator" VARCHAR,
  "denominator_annotation_code" BIGINT,
  "achievement_value" VARCHAR,
  "achievement_rate" DOUBLE,
  "achievement_rate_annotation_code" BIGINT,
  "baseline_rate" DOUBLE,
  "baseline_rate_annotaion_code" BIGINT,
  "target_rate" DOUBLE,
  "allocation" DOUBLE
);

Public Hospital Redesign And Incentives In Medi-Cal (PRIME) Program Demonstration Year 12 Data

@usgov.ca_gov_public_hospital_redesign_and_incentives_in_medi_2a94eca6.public_hospital_redesign_and_incentives_in_medi_cal_pr_4ee191be

84.08 kB
2,365 rows
16 columns

CREATE TABLE public_hospital_redesign_and_incentives_in_medi_cal_pr_4ee191be (
  "year" VARCHAR,
  "dph_dmph" VARCHAR  -- DPH/ DMPH,
  "hospital" VARCHAR,
  "number" VARCHAR,
  "metric" VARCHAR,
  "numerator" VARCHAR,
  "numerator_annotation_code" DOUBLE,
  "denominator" VARCHAR,
  "denominator_annotation_code" DOUBLE,
  "achievement_value" DOUBLE,
  "achievement_rate" DOUBLE,
  "achievement_rate_annotation_code" DOUBLE,
  "baseline_rate" VARCHAR,
  "baseline_rate_annotation_code" DOUBLE,
  "target_rate" VARCHAR,
  "n__allocation" VARCHAR  -- Allocation
);

Public Hospital Redesign And Incentives In Medi-Cal (PRIME) Program Demonstration Year 11 Data

@usgov.ca_gov_public_hospital_redesign_and_incentives_in_medi_2a94eca6.public_hospital_redesign_and_incentives_in_medi_cal_pr_9d40f80a

47.38 kB
1,855 rows
16 columns

CREATE TABLE public_hospital_redesign_and_incentives_in_medi_cal_pr_9d40f80a (
  "dy" VARCHAR,
  "type" VARCHAR,
  "hospital" VARCHAR,
  "number" VARCHAR,
  "metric" VARCHAR,
  "numerator" VARCHAR,
  "numerator_annotation_code" DOUBLE,
  "denominator" VARCHAR,
  "denominator_annotation_code" DOUBLE,
  "achievement_value" DOUBLE,
  "achievement_rate" VARCHAR,
  "achievement_rate_annotation_code" DOUBLE,
  "baseline_rate" VARCHAR,
  "baseline_rate_annotation_code" DOUBLE,
  "target_rate" VARCHAR,
  "allocation" VARCHAR
);

Public Hospital Redesign And Incentives In Medi-Cal (PRIME) Program Demonstration Year 14 Data

@usgov.ca_gov_public_hospital_redesign_and_incentives_in_medi_2a94eca6.public_hospital_redesign_and_incentives_in_medi_cal_pr_c4ad4f67

56.27 kB
1,575 rows
16 columns

CREATE TABLE public_hospital_redesign_and_incentives_in_medi_cal_pr_c4ad4f67 (
  "year" VARCHAR,
  "type" VARCHAR,
  "hospital" VARCHAR,
  "metric_number" VARCHAR,
  "metric_name" VARCHAR,
  "numerator" VARCHAR,
  "numerator_annotation_code" BIGINT,
  "denominator" VARCHAR,
  "denominator_annotation_code" BIGINT,
  "achievement_value" VARCHAR,
  "achievement_rate" DOUBLE,
  "achievement_rate_annotation_code" BIGINT,
  "baseline_rate" DOUBLE,
  "baseline_rate_annotation_code" BIGINT,
  "target_rate" DOUBLE,
  "allocation" DOUBLE
);

Public Hospital Redesign And Incentives In Medi-Cal (PRIME) Program Demonstration Year 13 Data

@usgov.ca_gov_public_hospital_redesign_and_incentives_in_medi_2a94eca6.public_hospital_redesign_and_incentives_in_medi_cal_pr_daec0ed0

58.67 kB
1,647 rows
16 columns

CREATE TABLE public_hospital_redesign_and_incentives_in_medi_cal_pr_daec0ed0 (
  "year" VARCHAR,
  "dph_dmph" VARCHAR,
  "hospital" VARCHAR,
  "number" VARCHAR,
  "metric" VARCHAR,
  "numerator" VARCHAR,
  "numerator_annotation_code" BIGINT,
  "denominator" VARCHAR,
  "denominator_annotation_code" BIGINT,
  "achievement_value" VARCHAR,
  "achievement_rate" VARCHAR,
  "achievement_rate_annotation_code" BIGINT,
  "baseline_rate" VARCHAR,
  "baseline_rate_annotation_code" DOUBLE,
  "target_rate" DOUBLE,
  "allocation" DOUBLE
);