Home

Dataset:

Name test-cdph-central-line-associated-bloodstream-infections-clabsi-in-california-hospitals
Updated 2024-08-29
Current True
Tables
clabsi_in_hospitals_2013    year - int
state - varchar(10)
hai - varchar(6)
facility_name1 - varchar(66)
facility_name2 - varchar(63)
facility_name3 - varchar(56)
facid1 - varchar(9)
facid2 - varchar(9)
facid3 - varchar(9)
county - varchar(22)
observed_infections - varchar(19)
predicted_infections - varchar(20)
central_line_days - varchar(17)
sir - varchar(4)
95pctconfidence_interval_low_limit - varchar(32)
95pctconfidence_interval_upper_limit - varchar(34)
statistical_interpretation - varchar(26)
notes - varchar(23)
clabsi_in_hospitals_2014    year - int
state - varchar(10)
hai - varchar(54)
facility_id1 - varchar(12)
facility_name1 - varchar(69)
county - varchar(15)
observed_infections - varchar(19)
predicted_infections - varchar(20)
central_line_days - varchar(17)
sir - varchar(5)
sir_ci_95_lower_limit - varchar(21)
sir_ci_95_upper_limit - varchar(21)
statistical_interpretation - varchar(26)
notes - varchar(54)
clabsi_in_hospitals_2015    year - int
state - varchar(10)
hai - varchar(54)
facility_id1 - varchar(12)
facility_name1 - varchar(66)
county - varchar(15)
observed_infections - varchar(19)
predicted_infections - varchar(20)
central_line_days - varchar(17)
sir - varchar(4)
sir_ci_95_lower_limit - varchar(21)
sir_ci_95_upper_limit - varchar(21)
statistical_interpretation - varchar(26)
notes - varchar(54)
clabsi_in_hospitals_2016    year - int
state - varchar(10)
hai - varchar(54)
facility_id - varchar(11)
facility_name1 - varchar(82)
county - varchar(15)
facility_category - varchar(82)
facility_type - varchar(82)
infections_reported - varchar(19)
infections_predicted - varchar(20)
central_line_days - varchar(17)
sir - varchar(4)
sir_ci_95_lower_limit - varchar(21)
sir_ci_95_upper_limit - varchar(21)
comparison - varchar(10)
clip_adherence_percent - varchar(22)
sir_2015 - varchar(8)
notes - varchar(77)
clabsi_in_hospitals_2017    year - int
state - varchar(10)
hai - varchar(54)
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)
central_line_days - varchar(17)
sir - varchar(5)
sir_ci_95_lower_limit - varchar(21)
sir_ci_95_upper_limit - varchar(21)
comparison - varchar(10)
on_track_toward_2020_goal_0_80_2017 - varchar(38)
clip_adherence_percent - varchar(22)
months - varchar(6)
sir_2015 - varchar(8)
notes - varchar(66)
clabsi_in_hospitals_2018    year - int
state - varchar(10)
hai - varchar(54)
facility_id - varchar(11)
facility_name - varchar(82)
county - varchar(15)
hospital_category_riskadjustment - varchar(82)
hospital_type - varchar(82)
infections_reported - varchar(19)
infections_predicted - varchar(20)
central_line_days - varchar(17)
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_7_2018 - varchar(37)
clip_adherence_percent - varchar(22)
months - varchar(6)
sir_2015 - varchar(8)
notes - varchar(66)
clabsi_in_hospitals_2019    year - int
state - varchar(10)
county - varchar(15)
hai - varchar(54)
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)
central_line_days - varchar(17)
sir - varchar(5)
sir_ci_95_lower_limit - varchar(21)
sir_ci_95_upper_limit - varchar(21)
comparison - varchar(10)
on_track - varchar(8)
clip_adherence_percent - varchar(22)
months - varchar(6)
sir_2015 - varchar(8)
notes - varchar(66)
clabsi_in_hospitals_2021    year - int
state - varchar(10)
hai - varchar(54)
facility_id - varchar(11)
facility_name - varchar(67)
county - varchar(15)
hospital_category_riskadjustment - varchar(67)
facility_type - varchar(67)
infections_reported - varchar(19)
infections_predicted - varchar(20)
central_line_days - varchar(17)
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)
months - varchar(6)
sir_2015 - varchar(8)
notes - varchar(66)
clabsi_in_hospitals_2022    year - int
state - varchar(10)
hai - varchar(54)
facility_id - varchar(11)
facility_name - varchar(85)
county - varchar(15)
hospital_category_riskadjustment - varchar(67)
facility_type - varchar(67)
infections_reported - varchar(19)
infections_predicted - varchar(20)
central_line_days - varchar(17)
sir - varchar(4)
sir_ci_95_lower_limit - varchar(21)
sir_ci_95_upper_limit - varchar(21)
comparison - varchar(10)
met_2020_goal - varchar(13)
months - varchar(6)
sir_2015 - varchar(8)
notes - varchar(66)
clabsi_in_hospitals_2023    year - int
state - varchar(10)
hai - varchar(54)
facility_id - varchar(11)
facility_name - varchar(85)
county - varchar(15)
hospital_category_riskadjustment - varchar(67)
facility_type - varchar(67)
infections_reported - varchar(19)
infections_predicted - varchar(20)
central_line_days - varchar(17)
sir - varchar(4)
sir_ci_95_lower_limit - varchar(21)
sir_ci_95_upper_limit - varchar(21)
comparison - varchar(10)
met_2020_goal - varchar(13)
months - varchar(6)
sir_2015 - varchar(8)
notes - varchar(66)
clabsi_in_hospitals_january_through_june_2020_updated_annually    year - varchar(6)
state - varchar(10)
county - varchar(15)
hai - varchar(54)
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)
central_line_days - varchar(17)
clip_adherence_percent - varchar(22)
clabsi_in_hospitals_july_through_december_2020_updated_annually    year - varchar(6)
state - varchar(10)
county - varchar(15)
hai - varchar(54)
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)
central_line_days - varchar(17)
sir - varchar(5)
sir_ci_95_lower_limit - varchar(21)
sir_ci_95_upper_limit - varchar(21)
comparison - varchar(10)
clip_adherence_percent - varchar(22)
months - varchar(6)
notes - varchar(66)
clabsi_in_long_term_acute_care_2015    year - int
state - varchar(10)
hai - varchar(54)
facility_id1 - varchar(12)
facility_name1 - varchar(54)
county - varchar(14)
observed_infections - varchar(19)
predicted_infections - varchar(20)
central_line_days - varchar(17)
sir - varchar(4)
sir_ci_95_lower_limit - varchar(21)
sir_ci_95_upper_limit - varchar(21)
statistical_interpretation - varchar(26)
notes - varchar(5)
clabsi_in_patient_care_areas_2013    year - int
state - varchar(10)
hai - varchar(6)
patient_care_area - varchar(24)
patient_care_location - varchar(50)
facility_name1 - varchar(66)
facility_name2 - varchar(63)
facility_name3 - varchar(56)
facid1 - varchar(9)
facid2 - varchar(9)
facid3 - varchar(9)
county - varchar(22)
cases - varchar(5)
central_line_days - varchar(17)
rate - varchar(5)
95pctconfidence_interval_lower_limit - varchar(34)
95pctconfidence_interval_upper_limit - varchar(34)
statistical_interpretation - varchar(26)
clip_adherence_pct - varchar(23)
notes - varchar(23)
clabsi_in_patient_care_areas_2014    year - int
state - varchar(10)
hai - varchar(54)
facility_name1 - varchar(68)
facility_id1 - varchar(12)
county - varchar(15)
patient_care_area - varchar(24)
patient_care_location - varchar(73)
cases - varchar(5)
central_line_days - varchar(17)
rate - varchar(5)
ci_95_lower_limit - varchar(17)
ci_95_upper_limit - varchar(17)
statistical_interpretation - varchar(26)
clip_adherence_percent - varchar(22)
notes - varchar(54)
clabsi_in_patient_care_areas_2015    year - int
state - varchar(10)
hai - varchar(54)
patient_care_area - varchar(24)
patient_care_location - varchar(69)
facility_id1 - varchar(12)
facility_name1 - varchar(67)
county - varchar(15)
cases - varchar(5)
central_line_days - varchar(17)
rate - varchar(5)
ci_95_lower_limit - varchar(17)
ci_95_upper_limit - varchar(17)
statistical_interpretation - varchar(26)
clip_adherence_percent - varchar(22)
notes - varchar(85)
Sources clabsi-in-hospitals-2013.csv --> clabsi_in_hospitals_2013
clabsi-in-hospitals-2014.csv --> clabsi_in_hospitals_2014
clabsi-in-hospitals-2015.csv --> clabsi_in_hospitals_2015
clabsi-in-hospitals-2016.csv --> clabsi_in_hospitals_2016
clabsi-in-hospitals-2017.csv --> clabsi_in_hospitals_2017
clabsi-in-hospitals-2018.csv --> clabsi_in_hospitals_2018
clabsi-in-hospitals-2019.csv --> clabsi_in_hospitals_2019
clabsi-in-hospitals-2021.csv --> clabsi_in_hospitals_2021
clabsi-in-hospitals-2022.csv --> clabsi_in_hospitals_2022
clabsi-in-hospitals-2023.csv --> clabsi_in_hospitals_2023
clabsi-in-hospitals-january-through-june-2020-updated-annually.csv --> clabsi_in_hospitals_january_through_june_2020_updated_annually
clabsi-in-hospitals-july-through-december-2020-updated-annually.csv --> clabsi_in_hospitals_july_through_december_2020_updated_annually
clabsi-in-long-term-acute-care-2015.csv --> clabsi_in_long_term_acute_care_2015
clabsi-in-patient-care-areas-2013.csv --> clabsi_in_patient_care_areas_2013
clabsi-in-patient-care-areas-2014.csv --> clabsi_in_patient_care_areas_2014
clabsi-in-patient-care-areas-2015.csv --> clabsi_in_patient_care_areas_2015
Updates
2025-02-02 19:03:18      0
2024-12-27 19:04:12      0
2024-12-14 18:36:15      0
2024-12-04 16:52:54      None
2024-09-18 13:22:39      None