About this Dataset

Quality Incentive Pool (QIP) Program Data (Years 1 - 6)

Beginning with the July 1, 2017, rating period, the Department implemented a managed care Designated Public Hospital (DPH) Quality Incentive Pool (QIP). The Department directed Managed Care Plans (MCPs) to make QIP payments tied to performance on designated performance metrics in four strategic categories: primary care, specialty care, inpatient care, and resource utilization. The datasets includes available data from DPHs’ annual reports, which include self-reported data on performance of QIP required metrics. Data can be viewed via the download button.
Organization: State of California
Last updated: 2025-07-23T19:59:45.098189
Tags: california-department-of-health-care-services, dhcs, hospitals, qip, quality-health-care

Tables

Data Dictionary - Quality Incentive Pool (QIP) Program Data Diabetes Measure (Year 3)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.n__dictionary_quality_incentive_pool_qip_program_diabe_d0ed526f

5.64 kB
16 rows
4 columns


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

Data Dictionary - Quality Incentive Pool (QIP) Program Data Immunization Subpool Measures (Year 3.5)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.n__dictionary_quality_incentive_pool_qip_program_immun_2145c4d1

5.67 kB
16 rows
4 columns


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

Data Dictionary - Quality Incentive Pool (QIP) Program Data (New PY4 Data Reported In PY5)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.n__dictionary_quality_incentive_pool_qip_program_new_p_ac8977e3

4.93 kB
18 rows
4 columns


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

Data Dictionary - Quality Incentive Pool (QIP) Program Data PRIME Transition Measures (Year 3.5)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.n__dictionary_quality_incentive_pool_qip_program_prime_ea7c156a

5.44 kB
16 rows
4 columns


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

Data Dictionary - Quality Incentive Pool (QIP) Program Data (Year 1)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.n__dictionary_quality_incentive_pool_qip_program_year_1

5.48 kB
16 rows
4 columns


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

Data Dictionary - Quality Incentive Pool (QIP) Program Data (Year 2)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.n__dictionary_quality_incentive_pool_qip_program_year_2

5.51 kB
16 rows
4 columns


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

Data Dictionary - Quality Incentive Pool (QIP) Program Data (Year 3)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.n__dictionary_quality_incentive_pool_qip_program_year_3

5.64 kB
16 rows
4 columns


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

Data Dictionary - Quality Incentive Pool (QIP) Program Data (Year 4)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.n__dictionary_quality_incentive_pool_qip_program_year_4

5.1 kB
19 rows
4 columns


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

Data Dictionary - Quality Incentive Pool (QIP) Program Data (Year 5)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.n__dictionary_quality_incentive_pool_qip_program_year_5

5.22 kB
20 rows
4 columns


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

Data Dictionary - Quality Incentive Pool (QIP) Program Data (Year 6)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.n__dictionary_quality_incentive_pool_qip_program_year_6

5.07 kB
18 rows
4 columns


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

Quality Incentive Pool (QIP) Program Data (Year 1)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.quality_incentive_pool_qip_program_data_year_1

21.36 kB
522 rows
16 columns


CREATE TABLE quality_incentive_pool_qip_program_data_year_1 (
  "py" VARCHAR,
  "type" VARCHAR,
  "hospital" VARCHAR,
  "number" VARCHAR,
  "title" VARCHAR,
  "report_status" VARCHAR,
  "baseline_rate" VARCHAR,
  "baseline_rate_annotation_code" DOUBLE,
  "target_rate" VARCHAR,
  "numerator" VARCHAR,
  "numerator_annotation_code" DOUBLE,
  "denominator" VARCHAR,
  "denominator_annotation_code" DOUBLE,
  "achievement_rate" VARCHAR,
  "achievement_rate_annotation_code" DOUBLE,
  "achievement_value" DOUBLE
);

Quality Incentive Pool (QIP) Program Data (Year 2)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.quality_incentive_pool_qip_program_data_year_2

23.82 kB
508 rows
16 columns


CREATE TABLE quality_incentive_pool_qip_program_data_year_2 (
  "py" VARCHAR,
  "type" VARCHAR,
  "hospital" VARCHAR,
  "number" VARCHAR,
  "title" VARCHAR,
  "report_status" VARCHAR,
  "baseline_rate" VARCHAR,
  "baseline_rate_annotation_code" DOUBLE,
  "target_rate" VARCHAR,
  "numerator" VARCHAR,
  "numerator_annotation_code" DOUBLE,
  "denominator" VARCHAR,
  "denominator_annotation_code" DOUBLE,
  "achievement_rate" VARCHAR,
  "achievement_rate_annotation_code" DOUBLE,
  "achievement_value" VARCHAR
);

Quality Incentive Pool (QIP) Program Data (Year 3)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.quality_incentive_pool_qip_program_data_year_3

24.73 kB
532 rows
16 columns


CREATE TABLE quality_incentive_pool_qip_program_data_year_3 (
  "py" VARCHAR,
  "hospital" VARCHAR,
  "type" VARCHAR,
  "number" VARCHAR,
  "title" VARCHAR,
  "report_status" VARCHAR,
  "baseline_rate" DOUBLE,
  "baseline_rate_annotation_code" DOUBLE,
  "target_rate" VARCHAR,
  "numerator" DOUBLE,
  "numerator_annotation_code" DOUBLE,
  "denominator" DOUBLE,
  "denominator_annotation_code" DOUBLE,
  "achievement_rate" DOUBLE,
  "achievement_rate_annotation_code" DOUBLE,
  "achievement_value" DOUBLE
);

Quality Incentive Pool (QIP) Program Data (Year 4)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.quality_incentive_pool_qip_program_data_year_4

45.79 kB
3,066 rows
19 columns


CREATE TABLE quality_incentive_pool_qip_program_data_year_4 (
  "py" VARCHAR,
  "type" VARCHAR,
  "hospital" VARCHAR,
  "number" VARCHAR,
  "abbreviation" VARCHAR,
  "title" VARCHAR,
  "report_status" VARCHAR,
  "baseline_rate" VARCHAR,
  "baseline_rate_annotation" DOUBLE,
  "target_rate" VARCHAR,
  "target_rate_annotation" DOUBLE,
  "numerator" VARCHAR,
  "numerator_annotation" DOUBLE,
  "denominator" VARCHAR,
  "denominator_annotation" DOUBLE,
  "achievement_rate" VARCHAR,
  "achievement_rate_annotation" DOUBLE,
  "achievement_value" VARCHAR,
  "p4p" VARCHAR
);

Quality Incentive Pool (QIP) Program Data (Year 5)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.quality_incentive_pool_qip_program_data_year_5

76.53 kB
5,362 rows
20 columns


CREATE TABLE quality_incentive_pool_qip_program_data_year_5 (
  "py" VARCHAR,
  "hospital" VARCHAR,
  "type" VARCHAR,
  "number" VARCHAR,
  "abbreviation" VARCHAR,
  "title" VARCHAR,
  "report_status" VARCHAR,
  "baseline_rate" VARCHAR,
  "baseline_rate_annotation_code" DOUBLE,
  "target_rate" VARCHAR,
  "target_rate_annotation_code" VARCHAR,
  "numerator" VARCHAR,
  "numerator_annotation_code" DOUBLE,
  "denominator" VARCHAR,
  "denominator_annotation_code" DOUBLE,
  "achievement_rate" VARCHAR,
  "achievement_rate_annotation_code" DOUBLE,
  "achievement_value" VARCHAR,
  "overperformance_value" VARCHAR,
  "p4p" VARCHAR
);

Quality Incentive Pool (QIP) Program Data (Year 6)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.quality_incentive_pool_qip_program_data_year_6

90.08 kB
6,777 rows
18 columns


CREATE TABLE quality_incentive_pool_qip_program_data_year_6 (
  "py" VARCHAR,
  "hospital" VARCHAR,
  "type" VARCHAR,
  "number" VARCHAR,
  "abbreviation" VARCHAR,
  "title" VARCHAR,
  "report_status" VARCHAR,
  "baseline_rate" DOUBLE,
  "baseline_rate_annotation_code" DOUBLE,
  "target_rate" VARCHAR,
  "numerator" DOUBLE,
  "numerator_annotation_code" DOUBLE,
  "denominator" DOUBLE,
  "denominator_annotation_code" DOUBLE,
  "achievement_rate" DOUBLE,
  "achievement_rate_annotation_code" DOUBLE,
  "achievement_value" VARCHAR,
  "overperformance_value" VARCHAR
);

Quality Incentive Pool (QIP) Program Data Diabetes Measure (Year 3)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.quality_incentive_pool_qip_program_diabetes_measure_year_3

24.63 kB
1,431 rows
16 columns


CREATE TABLE quality_incentive_pool_qip_program_diabetes_measure_year_3 (
  "py" VARCHAR,
  "hospital" VARCHAR,
  "type" VARCHAR,
  "number" VARCHAR,
  "title" VARCHAR,
  "report_status" VARCHAR,
  "baseline_rate" DOUBLE,
  "baseline_rate_annotation_code" DOUBLE,
  "target_rate" VARCHAR,
  "numerator" DOUBLE,
  "numerator_annotation_code" DOUBLE,
  "denominator" DOUBLE,
  "denominator_annotation_code" DOUBLE,
  "achievement_rate" DOUBLE,
  "achievement_rate_annoation_code" DOUBLE,
  "achievement_value" VARCHAR
);

Quality Incentive Pool (QIP) Program Data Immunization Subpool Measures (Year 3.5)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.quality_incentive_pool_qip_program_immunization_subpoo_a3f0d01a

14.95 kB
153 rows
16 columns


CREATE TABLE quality_incentive_pool_qip_program_immunization_subpoo_a3f0d01a (
  "py" VARCHAR,
  "type" VARCHAR,
  "hospital" VARCHAR,
  "number" VARCHAR,
  "title" VARCHAR,
  "report_status" VARCHAR,
  "baseline_rate" DOUBLE,
  "baseline_annotation_code" VARCHAR,
  "target_rate" DOUBLE,
  "numerator" DOUBLE,
  "numerator_annotation_code" DOUBLE,
  "denominator" DOUBLE,
  "denominator_annotation_code" DOUBLE,
  "achievement_rate" VARCHAR,
  "achievement_rate_annotation_code" DOUBLE,
  "achievement_value" DOUBLE
);

Quality Incentive Pool (QIP) Program Data (New PY4 Data Reported In PY5)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.quality_incentive_pool_qip_program_new_py4_reported_in_py5

27 kB
471 rows
18 columns


CREATE TABLE quality_incentive_pool_qip_program_new_py4_reported_in_py5 (
  "py" VARCHAR,
  "dph_dmph" VARCHAR,
  "hospital" VARCHAR,
  "number" VARCHAR,
  "abbreviation" VARCHAR,
  "title" VARCHAR,
  "report_status" VARCHAR,
  "baseline_rate" VARCHAR,
  "baseline_rate_annotation_code" VARCHAR,
  "target_rate" VARCHAR,
  "target_rate_annotation_code" DOUBLE,
  "numerator" DOUBLE,
  "numerator_annotation_code" DOUBLE,
  "denominator" DOUBLE,
  "denominator_annotation_code" DOUBLE,
  "achievement_rate" VARCHAR,
  "achievement_rate_annotation_code" DOUBLE,
  "achievement_value" VARCHAR
);

Quality Incentive Pool (QIP) Program Data (New PY5 Data Reported In PY6)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.quality_incentive_pool_qip_program_new_py5_reported_in_py6

26.87 kB
541 rows
16 columns


CREATE TABLE quality_incentive_pool_qip_program_new_py5_reported_in_py6 (
  "py" VARCHAR,
  "type" VARCHAR,
  "hospital" VARCHAR,
  "number" VARCHAR,
  "abbreviation" VARCHAR,
  "title" VARCHAR,
  "numerator" DOUBLE,
  "numerator_annotation_code" DOUBLE,
  "denominator" DOUBLE,
  "denominator_annotation_code" DOUBLE,
  "achievement_rate" DOUBLE,
  "achievement_rate_annotation_code" DOUBLE,
  "achievement_value" VARCHAR,
  "target_rate" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR
);

Quality Incentive Pool (QIP) Program Data PRIME Transition Measures (Year 3.5)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.quality_incentive_pool_qip_program_prime_transition_me_cd8bfce9

51.91 kB
1,533 rows
16 columns


CREATE TABLE quality_incentive_pool_qip_program_prime_transition_me_cd8bfce9 (
  "py" VARCHAR,
  "type" VARCHAR,
  "hospital" VARCHAR,
  "number" VARCHAR,
  "title" VARCHAR,
  "report_status" VARCHAR,
  "baseline_rate" DOUBLE,
  "baseline_annotation_code" BIGINT,
  "target_rate" DOUBLE,
  "numerator" VARCHAR,
  "numerator_annotation_code" BIGINT,
  "denominator" VARCHAR,
  "denominator_annotation_code" BIGINT,
  "achievement_rate" DOUBLE,
  "achievement_rate_annotation_code" DOUBLE,
  "achievement_value" VARCHAR
);

Quality Incentive Pool (QIP) Race-Ethnicity Program Data (Year 4)

@usgov.ca_gov_quality_incentive_pool_qip_program_data_years_1_6.quality_incentive_pool_qip_race_ethnicity_program_year_4

105.64 kB
3,876 rows
31 columns


CREATE TABLE quality_incentive_pool_qip_race_ethnicity_program_year_4 (
  "py" VARCHAR,
  "hospital" VARCHAR,
  "type" VARCHAR,
  "abbreviation" VARCHAR,
  "title" VARCHAR,
  "report_status" VARCHAR,
  "race" VARCHAR,
  "hisp_numerator" DOUBLE,
  "hisp_numerator_annotation_code" DOUBLE,
  "hisp_denominator" DOUBLE,
  "hisp_denominator_annotation_code" DOUBLE,
  "hisp_achievement_rate" DOUBLE,
  "hisp_achievement_rate_annotation_code" DOUBLE,
  "non_hisp_numerator" DOUBLE,
  "non_hisp_numerator_annotation_code" DOUBLE,
  "non_hisp_denominator" DOUBLE,
  "non_hisp_denominator_annotation_code" DOUBLE,
  "non_hisp_achievement_rate" DOUBLE,
  "non_hisp_achievement_rate_annotation_code" DOUBLE,
  "unknown_ethnicity_numerator" DOUBLE,
  "unknown_ethnicity_numerator_annotation_code" DOUBLE,
  "unknown_ethnicity_denominator" DOUBLE,
  "unknown_ethnicity_denominator_annotation_code" DOUBLE,
  "unknown_ethnicity_achievement_rate" DOUBLE,
  "unknown_ethnicity_achievement_rate_annotation_code" DOUBLE,
  "total_numerator" DOUBLE,
  "total_numerator_annotation_code" DOUBLE,
  "total_denominator" DOUBLE,
  "total_denominator_annotation_code" DOUBLE,
  "total_achievement_rate" DOUBLE,
  "total_achievement_rate_annotation_code" DOUBLE
);