About this Dataset

Clostridioides Difficile Infections (CDI) In California Hospitals

California Health and Safety Code section 1288.55(a)(1) requires general acute care hospitals to report all cases of Clostridioides difficile infections (CDI) identified in their facilities to the California Department of Public Health (CDPH). CDI data are submitted by hospitals to the Centers for Disease Control and Prevention (CDC) National Healthcare Safety Network (NHSN).

CDPH downloads California hospital CDI data from NHSN and analyzes the data to describe prevention progress in an annual public report of healthcare-associated infections CDPH publishes annual CDI data reported by each California hospital in the datasets below.

The following datasets include the number of CDI reported by each California hospital in the specified reporting year. Beginning in 2016 for each California hospital, the annual CDI dataset includes the number of CDI that were predicted to occur in each hospital based on its specific facility-level characteristics. The observed (reported) number of CDI are then compared to the predicted number of CDI in a ratio called the Standardized Infection Ratio or SIR. The SIR is a metric that summarizes an individual hospital’s CDI prevention progress compared with the national baseline and California state-specific prevention goals.

Detailed information about the variables included in each dataset are described in the accompanying data dictionaries for the year of interest.

For more information about the SIR and NHSN’s statistical models that are used to calculate the predicted number of CDI for each hospital, please review “NHSN’s Guide to the SIR”: https://www.cdc.gov/nhsn/ps-analysis-resources/index.html

For general information about NHSN, surveillance definitions, and reporting requirements for CDI, please visit: https://www.cdc.gov/nhsn/index.html

To link the CDPH facility IDs with those from other Departments, including OSHPD, please reference the "Licensed Facility Cross-Walk" Open Data table at: https://data.chhs.ca.gov/dataset/licensed-facility-crosswalk.

For information about healthcare-associated infection prevention progress in California hospitals and statewide prevention goals, please visit: https://www.cdph.ca.gov/Programs/CHCQ/HAI/Pages/HAIreport.aspx
Organization: State of California
Last updated: 2025-09-23T12:40:17.426059
Tags: bacterial, california-department-of-public-health, cdi, clostridium-difficile, cross-infection, epidemiology, hai, healthcare, healthcare-acquired-infections, hospital, nosocomial-infections, surveillance

Tables

CDIs In Hospitals, 2013

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_hospitals_2013

30.96 kB
356 rows
17 columns

CREATE TABLE cdis_in_hospitals_2013 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "facility_name1" VARCHAR,
  "facility_name2" VARCHAR,
  "facility_name3" VARCHAR,
  "facid1" BIGINT,
  "facid2" VARCHAR,
  "facid3" VARCHAR,
  "county" VARCHAR,
  "hospital_onset_cases" DOUBLE,
  "patient_days" DOUBLE,
  "sir" DOUBLE,
  "sir_95_ci_lower_limit" DOUBLE  -- SIR 95% CI Lower Limit,
  "sir_95_ci_upper_limit" DOUBLE  -- SIR 95% CI Upper Limit,
  "comparison" VARCHAR,
  "notes" VARCHAR
);

CDIs In Hospitals, 2014

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_hospitals_2014

28.12 kB
362 rows
14 columns

CREATE TABLE cdis_in_hospitals_2014 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "facility_id1" BIGINT,
  "facility_name1" VARCHAR,
  "county" VARCHAR,
  "hospital_onset_cases" DOUBLE,
  "predicted_cases" DOUBLE,
  "patient_days" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "notes" VARCHAR
);

CDIs In Hospitals, 2015

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_hospitals_2015

28.21 kB
362 rows
14 columns

CREATE TABLE cdis_in_hospitals_2015 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "facility_id1" BIGINT,
  "facility_name1" VARCHAR,
  "county" VARCHAR,
  "hospital_onset_cases" DOUBLE,
  "predicted_cases" DOUBLE,
  "patient_days" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "notes" VARCHAR
);

CDIs In Hospitals, 2016

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_hospitals_2016

36.47 kB
463 rows
17 columns

CREATE TABLE cdis_in_hospitals_2016 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "county" VARCHAR,
  "facility_category" VARCHAR,
  "facility_type" VARCHAR,
  "infections_reported" VARCHAR,
  "infections_predicted" VARCHAR,
  "patient_days" VARCHAR,
  "sir" VARCHAR,
  "sir_ci_95_lower_limit" VARCHAR,
  "sir_ci_95_upper_limit" VARCHAR,
  "comparison" VARCHAR,
  "sir_2015" VARCHAR,
  "notes" VARCHAR
);

CDIs In Hospitals, 2017

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_hospitals_2017

38.43 kB
470 rows
19 columns

CREATE TABLE cdis_in_hospitals_2017 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "county" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "hospital_type" VARCHAR,
  "infections_reported" VARCHAR,
  "infections_predicted" VARCHAR,
  "patient_days" VARCHAR,
  "sir" VARCHAR,
  "sir_ci_95_lower_limit" VARCHAR,
  "sir_ci_95_upper_limit" VARCHAR,
  "comparison" VARCHAR,
  "on_track_toward_2020_goal_0_88_2017" VARCHAR  -- On Track Toward 2020 Goal (0.88, 2017),
  "months" VARCHAR,
  "sir_2015" DOUBLE,
  "notes" VARCHAR
);

CDIs In Hospitals, 2018

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_hospitals_2018

38.12 kB
471 rows
19 columns

CREATE TABLE cdis_in_hospitals_2018 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "county" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "hospital_type" VARCHAR,
  "infections_reported" DOUBLE,
  "infections_predicted" DOUBLE,
  "patient_days" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "on_track_toward_2020_goal_0_82_2018" VARCHAR  -- On Track Toward 2020 Goal (0.82, 2018),
  "months" DOUBLE,
  "sir_2015" DOUBLE,
  "notes" VARCHAR
);

CDIs In Hospitals, 2019

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_hospitals_2019

37.81 kB
469 rows
19 columns

CREATE TABLE cdis_in_hospitals_2019 (
  "year" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "facility_type" VARCHAR,
  "infections_reported" DOUBLE,
  "infections_predicted" DOUBLE,
  "patient_days" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "on_track" VARCHAR,
  "months" DOUBLE,
  "sir_2015" DOUBLE,
  "notes" VARCHAR
);

CDIs In Hospitals, 2021

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_hospitals_2021

36.74 kB
463 rows
19 columns

CREATE TABLE cdis_in_hospitals_2021 (
  "year" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "facility_type" VARCHAR,
  "infections_reported" DOUBLE,
  "infections_predicted" DOUBLE,
  "patient_days" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "met_2020_goal" VARCHAR,
  "sir_2015" DOUBLE,
  "months" DOUBLE,
  "notes" VARCHAR
);

CDIs In Hospitals, 2022

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_hospitals_2022

36.7 kB
463 rows
19 columns

CREATE TABLE cdis_in_hospitals_2022 (
  "year" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "facility_type" VARCHAR,
  "infections_reported" DOUBLE,
  "infections_predicted" DOUBLE,
  "patient_days" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "met_2020_goal" VARCHAR,
  "sir_2015" DOUBLE,
  "months" DOUBLE,
  "notes" VARCHAR
);

CDIs In Hospitals, 2023

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_hospitals_2023

37.01 kB
468 rows
19 columns

CREATE TABLE cdis_in_hospitals_2023 (
  "year" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "facility_type" VARCHAR,
  "infections_reported" DOUBLE,
  "infections_predicted" DOUBLE,
  "patient_days" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "met_2020_goal" VARCHAR,
  "sir_2015" DOUBLE,
  "months" DOUBLE,
  "notes" VARCHAR
);

CDIs In Hospitals, 2024

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_hospitals_2024

35.49 kB
465 rows
18 columns

CREATE TABLE cdis_in_hospitals_2024 (
  "year" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "facility_type" VARCHAR,
  "infections_reported" DOUBLE,
  "infections_predicted" DOUBLE,
  "patient_days" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "on_track" VARCHAR,
  "months" DOUBLE,
  "notes" VARCHAR
);

CDIs In January Through June 2020 (updated Annually)

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_january_through_june_2020_updated_annually

25.08 kB
459 rows
11 columns

CREATE TABLE cdis_in_january_through_june_2020_updated_annually (
  "year" VARCHAR,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "facility_type" VARCHAR,
  "infections_reported" DOUBLE,
  "infections_predicted" DOUBLE,
  "patient_days" DOUBLE
);

CDIs In July Through December 2020 (updated Annually)

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_july_through_december_2020_updated_annually

33.66 kB
458 rows
17 columns

CREATE TABLE cdis_in_july_through_december_2020_updated_annually (
  "year" VARCHAR,
  "state" VARCHAR,
  "county" VARCHAR,
  "hai" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "hospital_category_riskadjustment" VARCHAR,
  "facility_type" VARCHAR,
  "infections_reported" DOUBLE,
  "infections_predicted" DOUBLE,
  "patient_days" DOUBLE,
  "sir" DOUBLE,
  "sir_ci_95_lower_limit" DOUBLE,
  "sir_ci_95_upper_limit" DOUBLE,
  "comparison" VARCHAR,
  "months" DOUBLE,
  "notes" VARCHAR
);

CDIs In LTACs, 2013

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_ltacs_2013

11.55 kB
23 rows
13 columns

CREATE TABLE cdis_in_ltacs_2013 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "facility_name" VARCHAR,
  "facid" BIGINT,
  "county" VARCHAR,
  "hospital_onset_cases" BIGINT,
  "patient_days" BIGINT,
  "hospital_onset_rate" DOUBLE,
  "n_95_confidence_interval_lower_limit" DOUBLE  -- 95% Confidence Interval Lower Limit,
  "n_95_confidence_interval_upper_limit" DOUBLE  -- 95% Confidence Interval Upper Limit,
  "pcr" VARCHAR,
  "notes" VARCHAR
);

CDIs In LTACs, 2014

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_ltacs_2014

11.25 kB
24 rows
13 columns

CREATE TABLE cdis_in_ltacs_2014 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "facility_id1" BIGINT,
  "facility_name1" VARCHAR,
  "county" VARCHAR,
  "hospital_onset_cases" BIGINT,
  "patient_days" BIGINT,
  "hospital_onset_rate" DOUBLE,
  "ci_95_lower_limit" DOUBLE,
  "ci_95_upper_limit" DOUBLE,
  "pcr" VARCHAR,
  "notes" VARCHAR
);

CDIs In LTACs, 2015

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_ltacs_2015

11.23 kB
24 rows
13 columns

CREATE TABLE cdis_in_ltacs_2015 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "facility_id1" DOUBLE,
  "facility_name1" VARCHAR,
  "county" VARCHAR,
  "hospital_onset_cases" BIGINT,
  "patient_days" BIGINT,
  "hospital_onset_rate" DOUBLE,
  "ci_95_lower_limit" DOUBLE,
  "ci_95_upper_limit" DOUBLE,
  "pcr" VARCHAR,
  "notes" VARCHAR
);

CDIs In REHABs, 2013

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_rehabs_2013

10.76 kB
6 rows
13 columns

CREATE TABLE cdis_in_rehabs_2013 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "facility_name" VARCHAR,
  "facid" BIGINT,
  "county" VARCHAR,
  "hospital_onset_cases" DOUBLE,
  "patient_days" DOUBLE,
  "hospital_onset_rate" DOUBLE,
  "n_95_confidence_interval_lower_limit" DOUBLE  -- 95% Confidence Interval Lower Limit,
  "n_95_confidence_interval_upper_limit" DOUBLE  -- 95% Confidence Interval Upper Limit,
  "pcr" VARCHAR,
  "notes" VARCHAR
);

CDIs In REHABs, 2014

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_rehabs_2014

10.2 kB
6 rows
13 columns

CREATE TABLE cdis_in_rehabs_2014 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "facility_id1" BIGINT,
  "facility_name1" VARCHAR,
  "county" VARCHAR,
  "hospital_onset_cases" BIGINT,
  "patient_days" BIGINT,
  "hospital_onset_rate" DOUBLE,
  "ci_95_lower_limit" DOUBLE,
  "ci_95_upper_limit" DOUBLE,
  "pcr" VARCHAR,
  "notes" VARCHAR
);

CDIs In REHABs, 2015

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.cdis_in_rehabs_2015

13.36 kB
63 rows
13 columns

CREATE TABLE cdis_in_rehabs_2015 (
  "year" BIGINT,
  "state" VARCHAR,
  "hai" VARCHAR,
  "facility_id1" BIGINT,
  "facility_name1" VARCHAR,
  "county" VARCHAR,
  "hospital_onset_cases" BIGINT,
  "patient_days" BIGINT,
  "hospital_onset_rate" DOUBLE,
  "ci_95_lower_limit" DOUBLE,
  "ci_95_upper_limit" DOUBLE,
  "pcr" VARCHAR,
  "notes" VARCHAR
);

Data Dictionary - CDIs In Hospitals, 2013

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.data_dictionary_cdis_in_hospitals_2013

7.25 kB
17 rows
4 columns

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

Data Dictionary - CDIs In Hospitals, 2014

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.data_dictionary_cdis_in_hospitals_2014

8.53 kB
14 rows
4 columns

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

Data Dictionary - CDIs In Hospitals, 2015

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.data_dictionary_cdis_in_hospitals_2015

8.53 kB
14 rows
4 columns

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

Data Dictionary - CDIs In Hospitals, 2018

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.data_dictionary_cdis_in_hospitals_2018

10.72 kB
19 rows
4 columns

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

Data Dictionary - CDIs In Hospitals, 2019

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.data_dictionary_cdis_in_hospitals_2019

10.61 kB
19 rows
4 columns

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

Data Dictionary - CDIs In Hospitals, 2021

@usgov.ca_gov_clostridioides_difficile_infections_cdi_in_cali_8f103103.data_dictionary_cdis_in_hospitals_2021

7.62 kB
19 rows
4 columns

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