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_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 - None
datapackage.json - None
cdis-in-hospitals-2013.csv - cdis_in_hospitals_2013
cdis-in-hospitals-2014.csv - cdis_in_hospitals_2014
cdis-in-hospitals-2015.csv - cdis_in_hospitals_2015
cdis-in-hospitals-2016.csv - cdis_in_hospitals_2016
cdis-in-hospitals-2017.csv - cdis_in_hospitals_2017
cdis-in-hospitals-2018.csv - cdis_in_hospitals_2018
cdis-in-hospitals-2019.csv - cdis_in_hospitals_2019
cdis-in-hospitals-2021.csv - cdis_in_hospitals_2021
cdis-in-hospitals-2022.csv - cdis_in_hospitals_2022
cdis-in-hospitals-2023.csv - cdis_in_hospitals_2023
cdis-in-january-through-june-2020-updated-annually.csv - cdis_in_january_through_june_2020_updated_annually
cdis-in-july-through-december-2020-updated-annually.csv - cdis_in_july_through_december_2020_updated_annually
cdis-in-ltacs-2013.csv - cdis_in_ltacs_2013
cdis-in-ltacs-2014.csv - cdis_in_ltacs_2014
cdis-in-ltacs-2015.csv - cdis_in_ltacs_2015
cdis-in-rehabs-2013.csv - cdis_in_rehabs_2013
cdis-in-rehabs-2014.csv - cdis_in_rehabs_2014
cdis-in-rehabs-2015.csv - cdis_in_rehabs_2015
Updates
2025-07-11 17:54:49      None
2025-02-02 17:31:58      0
2025-01-31 15:44:23      0
2024-12-28 15:54:04      0
2024-12-28 15:52:26      1
2024-12-10 15:03:22      None
2024-12-10 15:02:15      None
2024-12-04 16:18:54      None
2024-09-18 10:59:16      None
2024-09-18 08:58:34      None
2024-09-17 20:10:08      None