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: 2023-08-25T21:31:10.243742
Tags: 1115-waiver, california-department-of-health-care-services, dhcs, hospitals, prime, quality-health-care

Tables

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

@usgov.ca_gov_public_hospital_redesign_and_incentives_in_medi_2be0ab8a.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_2be0ab8a.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_2be0ab8a.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_2be0ab8a.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_2be0ab8a.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
);