Home

Dataset:

Name	clostridioides-difficile-infections-cdi-in-california-hospitals
Updated	2024-08-28
CA Dataset	link
Current	True
Tables	cdis_in_hospitals_2013     year - int state - varchar(10) hai - varchar(37) facility_name1 - varchar(66) facility_name2 - varchar(63) facility_name3 - varchar(56) facid1 - varchar(9) facid2 - varchar(9) facid3 - varchar(9) county - varchar(22) hospital_onset_cases - varchar(20) patient_days - varchar(12) sir - varchar(4) sir_95pct_ci_lower_limit - varchar(22) sir_95pct_ci_upper_limit - varchar(22) comparison - varchar(12) notes - varchar(42) cdis_in_hospitals_2014     year - int state - varchar(10) hai - varchar(37) facility_id1 - varchar(12) facility_name1 - varchar(69) county - varchar(15) hospital_onset_cases - varchar(20) predicted_cases - varchar(15) patient_days - varchar(12) sir - varchar(4) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) comparison - varchar(12) notes - varchar(53) cdis_in_hospitals_2015     year - int state - varchar(10) hai - varchar(37) facility_id1 - varchar(12) facility_name1 - varchar(66) county - varchar(15) hospital_onset_cases - varchar(20) predicted_cases - varchar(15) patient_days - varchar(12) sir - varchar(4) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) comparison - varchar(13) notes - varchar(78) cdis_in_hospitals_2016     year - int state - varchar(10) hai - varchar(37) facility_id - varchar(11) facility_name - varchar(82) county - varchar(15) facility_category - varchar(82) facility_type - varchar(82) infections_reported - varchar(19) infections_predicted - varchar(20) patient_days - varchar(12) sir - varchar(4) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) comparison - varchar(10) sir_2015 - varchar(8) notes - varchar(55) cdis_in_hospitals_2017     year - int state - varchar(10) hai - varchar(37) facility_id - varchar(11) facility_name - varchar(85) county - varchar(15) hospital_category_riskadjustment - varchar(82) hospital_type - varchar(82) infections_reported - varchar(19) infections_predicted - varchar(20) patient_days - varchar(12) sir - varchar(4) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) comparison - varchar(10) on_track_toward_2020_goal_0_88_2017 - varchar(38) months - varchar(6) sir_2015 - varchar(8) notes - varchar(78) cdis_in_hospitals_2018     year - int state - varchar(10) hai - varchar(40) facility_id - varchar(11) facility_name - varchar(79) county - varchar(15) hospital_category_riskadjustment - varchar(70) hospital_type - varchar(70) infections_reported - varchar(19) infections_predicted - varchar(20) patient_days - varchar(12) sir - varchar(4) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) comparison - varchar(10) on_track_toward_2020_goal_0_82_2018 - varchar(38) months - varchar(6) sir_2015 - varchar(8) notes - varchar(78) cdis_in_hospitals_2019     year - int state - varchar(10) county - varchar(15) hai - varchar(40) facility_id - varchar(11) facility_name - varchar(79) hospital_category_riskadjustment - varchar(67) facility_type - varchar(67) infections_reported - varchar(19) infections_predicted - varchar(20) patient_days - varchar(12) sir - varchar(5) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) comparison - varchar(10) on_track - varchar(8) months - varchar(6) sir_2015 - varchar(8) notes - varchar(66) cdis_in_hospitals_2021     year - int state - varchar(10) county - varchar(15) hai - varchar(40) facility_id - varchar(11) facility_name - varchar(67) hospital_category_riskadjustment - varchar(67) facility_type - varchar(67) infections_reported - varchar(19) infections_predicted - varchar(20) patient_days - varchar(12) sir - varchar(5) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) comparison - varchar(10) met_2020_goal - varchar(13) sir_2015 - varchar(8) months - varchar(6) notes - varchar(66) cdis_in_hospitals_2022     year - int state - varchar(10) county - varchar(15) hai - varchar(40) facility_id - varchar(11) facility_name - varchar(85) hospital_category_riskadjustment - varchar(67) facility_type - varchar(67) infections_reported - varchar(19) infections_predicted - varchar(20) patient_days - varchar(12) sir - varchar(5) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) comparison - varchar(10) met_2020_goal - varchar(13) sir_2015 - varchar(8) months - varchar(6) notes - varchar(66) cdis_in_hospitals_2023     year - int state - varchar(10) county - varchar(15) hai - varchar(40) facility_id - varchar(11) facility_name - varchar(85) hospital_category_riskadjustment - varchar(67) facility_type - varchar(67) infections_reported - varchar(19) infections_predicted - varchar(20) patient_days - varchar(12) sir - varchar(5) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) comparison - varchar(10) met_2020_goal - varchar(13) sir_2015 - varchar(8) months - varchar(6) notes - varchar(66) cdis_in_hospitals_2024     cdis_in_january_through_june_2020_updated_annually     year - varchar(6) state - varchar(10) county - varchar(15) hai - varchar(40) facility_id - varchar(11) facility_name - varchar(67) hospital_category_riskadjustment - varchar(67) facility_type - varchar(67) infections_reported - varchar(19) infections_predicted - varchar(20) patient_days - varchar(12) cdis_in_july_through_december_2020_updated_annually     year - varchar(6) state - varchar(10) county - varchar(15) hai - varchar(40) facility_id - varchar(11) facility_name - varchar(67) hospital_category_riskadjustment - varchar(67) facility_type - varchar(67) infections_reported - varchar(19) infections_predicted - varchar(20) patient_days - varchar(12) sir - varchar(5) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) comparison - varchar(10) months - varchar(6) notes - varchar(66) cdis_in_ltacs_2013     year - int state - varchar(10) hai - varchar(37) facility_name - varchar(56) facid - varchar(9) county - varchar(14) hospital_onset_cases - varchar(20) patient_days - varchar(12) hospital_onset_rate - varchar(19) 95pct_confidence_interval_lower_limit - varchar(35) 95pct_confidence_interval_upper_limit - varchar(35) pcr - varchar(8) notes - varchar(5) cdis_in_ltacs_2014     year - int state - varchar(10) hai - varchar(37) facility_id1 - varchar(12) facility_name1 - varchar(52) county - varchar(14) hospital_onset_cases - varchar(20) patient_days - varchar(12) hospital_onset_rate - varchar(19) ci_95_lower_limit - varchar(17) ci_95_upper_limit - varchar(17) pcr - varchar(8) notes - varchar(5) cdis_in_ltacs_2015     year - int state - varchar(10) hai - varchar(37) facility_id1 - varchar(12) facility_name1 - varchar(54) county - varchar(14) hospital_onset_cases - varchar(20) patient_days - varchar(12) hospital_onset_rate - varchar(19) ci_95_lower_limit - varchar(17) ci_95_upper_limit - varchar(17) pcr - varchar(3) notes - varchar(5) cdis_in_rehabs_2013     year - int state - varchar(10) hai - varchar(37) facility_name - varchar(56) facid - varchar(9) county - varchar(14) hospital_onset_cases - varchar(20) patient_days - varchar(12) hospital_onset_rate - varchar(19) 95pct_confidence_interval_lower_limit - varchar(35) 95pct_confidence_interval_upper_limit - varchar(35) pcr - varchar(8) notes - varchar(42) cdis_in_rehabs_2014     year - int state - varchar(10) hai - varchar(37) facility_id1 - varchar(12) facility_name1 - varchar(48) county - varchar(14) hospital_onset_cases - varchar(20) patient_days - varchar(12) hospital_onset_rate - varchar(19) ci_95_lower_limit - varchar(17) ci_95_upper_limit - varchar(17) pcr - varchar(8) notes - varchar(5) cdis_in_rehabs_2015     year - int state - varchar(10) hai - varchar(37) facility_id1 - varchar(12) facility_name1 - varchar(58) county - varchar(15) hospital_onset_cases - varchar(20) patient_days - varchar(12) hospital_onset_rate - varchar(19) ci_95_lower_limit - varchar(17) ci_95_upper_limit - varchar(17) pcr - varchar(3) notes - varchar(37)
Sources	cdis-in-ltacs-data-dictionary-2013-2015.xls  -    datapackage.json  -    cdis-in-hospitals-2013.csv  -  Table: cdis_in_hospitals_2013   Fails: 3 cdis-in-hospitals-2014.csv  -  Table: cdis_in_hospitals_2014   Updated: 2025-10-11 cdis-in-hospitals-2015.csv  -  Table: cdis_in_hospitals_2015   Updated: 2025-10-11 cdis-in-hospitals-2016.csv  -  Table: cdis_in_hospitals_2016   Updated: 2025-10-11 cdis-in-hospitals-2017.csv  -  Table: cdis_in_hospitals_2017   Fails: 3 cdis-in-hospitals-2018.csv  -  Table: cdis_in_hospitals_2018   Fails: 3 cdis-in-hospitals-2019.csv  -  Table: cdis_in_hospitals_2019   Updated: 2025-10-11 cdis-in-hospitals-2021.csv  -  Table: cdis_in_hospitals_2021   Updated: 2025-10-11 cdis-in-hospitals-2022.csv  -  Table: cdis_in_hospitals_2022   Updated: 2025-10-11 cdis-in-hospitals-2023.csv  -  Table: cdis_in_hospitals_2023   Updated: 2025-10-11 cdis-in-hospitals-2024.csv  -  Table: cdis_in_hospitals_2024   Updated: 2025-10-11 cdis-in-january-through-june-2020-updated-annually.csv  -  Table: cdis_in_january_through_june_2020_updated_annually   Updated: 2025-10-11 cdis-in-july-through-december-2020-updated-annually.csv  -  Table: cdis_in_july_through_december_2020_updated_annually   Updated: 2025-10-11 cdis-in-ltacs-2013.csv  -  Table: cdis_in_ltacs_2013   Fails: 3 cdis-in-ltacs-2014.csv  -  Table: cdis_in_ltacs_2014   Updated: 2025-10-11 cdis-in-ltacs-2015.csv  -  Table: cdis_in_ltacs_2015   Updated: 2025-10-11 cdis-in-rehabs-2013.csv  -  Table: cdis_in_rehabs_2013   Fails: 3 cdis-in-rehabs-2014.csv  -  Table: cdis_in_rehabs_2014   Updated: 2025-10-11 cdis-in-rehabs-2015.csv  -  Table: cdis_in_rehabs_2015   Updated: 2025-10-11
Updated