Home

Dataset:

Name	surgical-site-infections-ssis-for-28-operative-procedures-in-california-hospitals
Updated	2024-08-29
CA Dataset	link
Current	True
Tables	hosp_who_did_not_rpt_surg_procs_jan_1_jun_30_2020_upd_ann     year - int state - varchar(10) county - varchar(14) hai - varchar(30) facility_id - varchar(11) facility_name - varchar(55) facility_type - varchar(28) notes - varchar(90) hosp_who_did_not_rpt_surg_procs_jul_1_dec_31_2020_upd_ann     year - varchar(6) state - varchar(10) county - varchar(14) hai - varchar(30) facility_id - varchar(11) facility_name - varchar(55) facility_type - varchar(28) notes - varchar(91) hospitals_who_did_not_report_surg_proc_jan_1_dec_31_2021     year - int state - varchar(10) county - varchar(14) hai - varchar(30) facility_id - varchar(11) facility_name - varchar(55) facility_type - varchar(28) number_months_expected - varchar(22) notes - varchar(76) hospitals_who_did_not_report_surg_procs_jan_1_dec_31_2023     year - int state - varchar(10) county - varchar(14) hai - varchar(30) facility_id - varchar(11) facility_name - varchar(55) facility_type - varchar(28) number_months_expected - varchar(22) notes - varchar(76) hospitals_who_did_not_report_surgical_procedures_2016     year - int state - varchar(10) hai - varchar(63) county - varchar(14) facility_id - varchar(11) facility_name - varchar(48) notes - varchar(77) hospitals_who_did_not_report_surgical_procedures_2017     year - int state - varchar(10) hai - varchar(63) county - varchar(14) facility_id - varchar(11) facility_name - varchar(53) notes - varchar(76) hospitals_who_did_not_report_surgical_procedures_2018     year - int state - varchar(10) hai - varchar(63) county - varchar(14) facility_id - varchar(11) facility_name - varchar(53) notes - varchar(76) hospitals_who_did_not_report_surgical_procedures_2019     year - int state - varchar(10) county - varchar(14) hai - varchar(29) facility_id - varchar(11) facility_name - varchar(55) facility_type - varchar(28) number_months_expected - varchar(22) notes - varchar(76) hospitals_who_did_not_report_surgical_procedures_2022     year - int state - varchar(10) county - varchar(14) hai - varchar(30) facility_id - varchar(11) facility_name - varchar(55) facility_type - varchar(28) number_months_expected - varchar(22) notes - varchar(76) ssi_in_adult_patients_2016     year - int state - varchar(10) hai - varchar(63) county - varchar(15) facility_id - varchar(11) facility_name - varchar(67) operative_procedure - varchar(74) procedure_count - varchar(15) predicted_infection_count - varchar(25) infection_count - varchar(15) sir - varchar(6) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) comparison - varchar(10) sir_2015 - varchar(8) notes - varchar(53) ssi_in_adult_patients_2017     year - int state - varchar(10) hai - varchar(63) operative_procedure - varchar(74) facility_id - varchar(11) facility_name - varchar(85) hospital_category_riskadjustment - varchar(32) hospital_type - varchar(24) county - varchar(15) procedure_count - varchar(15) infection_count - varchar(15) predicted_infection_count - varchar(25) sir - varchar(5) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) comparison - varchar(10) sir_2015 - varchar(8) on_track_toward_2020_goal_0_88_2017 - varchar(38) notes - varchar(53) ssi_in_adult_patients_2018     year - int state - varchar(10) hai - varchar(63) facility_id - varchar(11) facility_name - varchar(66) county - varchar(15) hospital_category_riskadjustment - varchar(32) hospital_type - varchar(24) operative_procedure - varchar(76) procedure_count - varchar(15) infections_reported - varchar(19) infections_predicted - varchar(20) 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_82_2018 - varchar(38) sir_2015 - varchar(8) notes - varchar(53) ssi_in_adult_patients_2019     year - int state - varchar(10) county - varchar(15) hai - varchar(30) operative_procedure - varchar(76) facility_id - varchar(11) facility_name - varchar(66) hospital_category_riskadjustment - varchar(32) facility_type - varchar(23) procedure_count - varchar(15) infections_reported - varchar(19) infections_predicted - varchar(20) sir - varchar(5) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) comparison - varchar(10) on_track - varchar(8) sir_2015 - varchar(8) notes - varchar(21) ssi_in_adult_patients_2021     year - int state - varchar(10) county - varchar(15) hai - varchar(30) operative_procedure - varchar(76) facility_id - varchar(11) facility_name - varchar(63) hospital_category_riskadjustment - varchar(32) facility_type - varchar(23) procedure_count - varchar(15) infections_reported - varchar(19) infections_predicted - varchar(20) 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) notes - varchar(21) ssi_in_adult_patients_2022     year - int state - varchar(10) county - varchar(15) hai - varchar(30) operative_procedure - varchar(76) facility_id - varchar(11) facility_name - varchar(85) hospital_category_riskadjustment - varchar(32) facility_type - varchar(23) procedure_count - varchar(15) infections_reported - varchar(19) infections_predicted - varchar(20) 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) notes - varchar(21) ssi_in_adult_patients_january_1_december_31_2023     year - int state - varchar(10) county - varchar(15) hai - varchar(30) operative_procedure - varchar(76) facility_id - varchar(11) facility_name - varchar(85) hospital_category_riskadjustment - varchar(32) facility_type - varchar(23) procedure_count - varchar(15) infections_reported - varchar(19) infections_predicted - varchar(20) 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) notes - varchar(21) ssi_in_adult_patients_january_1_june_30_2020_updated_annually     year - varchar(6) state - varchar(10) county - varchar(15) hai - varchar(30) operative_procedure - varchar(76) facility_id - varchar(11) facility_name - varchar(60) hospital_category_riskadjustment - varchar(32) facility_type - varchar(23) procedure_count - varchar(15) infections_reported - varchar(19) infections_predicted - varchar(20) ssi_in_adult_patients_july_1_december_31_2020_updated_annually     year - int state - varchar(10) county - varchar(15) hai - varchar(30) operative_procedure - varchar(76) facility_id - varchar(11) facility_name - varchar(60) hospital_category_riskadjustment - varchar(32) facility_type - varchar(23) procedure_count - varchar(15) infections_reported - varchar(19) infections_predicted - varchar(20) sir - varchar(5) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) comparison - varchar(10) notes - varchar(21) ssi_in_ped_pats_jan_1_jun_30_2020_upd_ann     year - varchar(6) state - varchar(10) county - varchar(15) hai - varchar(30) operative_procedure - varchar(76) facility_id - varchar(11) facility_name - varchar(60) hospital_category_riskadjustment - varchar(32) facility_type - varchar(23) procedure_count - varchar(15) infections_reported - varchar(19) infections_predicted - varchar(20) ssi_in_ped_pats_jul_1_dec_31_2020_upd_ann     year - varchar(6) state - varchar(10) county - varchar(15) hai - varchar(30) operative_procedure - varchar(76) facility_id - varchar(11) facility_name - varchar(60) hospital_category_riskadjustment - varchar(32) facility_type - varchar(23) procedure_count - varchar(15) infections_reported - varchar(19) infections_predicted - varchar(20) sir - varchar(4) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) comparison - varchar(10) notes - varchar(21) ssi_in_pediatric_patients_2016     year - varchar(4) state - varchar(10) hai - varchar(63) county - varchar(15) facility_id - varchar(11) facility_name - varchar(67) operative_procedure - varchar(41) procedure_count - varchar(15) predicted_infection_count - varchar(25) infection_count - varchar(15) added0 - varchar(6) notes - varchar(5) ssi_in_pediatric_patients_2017     year - int state - varchar(10) hai - varchar(63) operative_procedure - varchar(74) facility_id - varchar(11) facility_name - varchar(85) hospital_category_riskadjustment - varchar(32) hospital_type - varchar(24) county - varchar(15) procedure_count - varchar(15) infection_count - varchar(15) predicted_infection_count - varchar(25) 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) notes - varchar(53) ssi_in_pediatric_patients_2018     year - int state - varchar(10) hai - varchar(63) operative_procedure - varchar(74) facility_id - varchar(11) facility_name - varchar(66) hospital_category_riskadjustment - varchar(32) hospital_type - varchar(24) county - varchar(15) procedure_count - varchar(15) infections_reported - varchar(19) infections_predicted - varchar(20) sir - varchar(4) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) comparison - varchar(10) on_track_to_achieve_2020_goal_0_82_in_2018 - varchar(44) notes - varchar(53) ssi_in_pediatric_patients_2019     year - int state - varchar(10) county - varchar(15) hai - varchar(30) operative_procedure - varchar(76) facility_id - varchar(11) facility_name - varchar(66) hospital_category_riskadjustment - varchar(32) facility_type - varchar(23) procedure_count - varchar(15) infections_reported - varchar(19) infections_predicted - varchar(20) sir - varchar(4) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) comparison - varchar(10) on_track - varchar(8) notes - varchar(21) ssi_in_pediatric_patients_2022     year - int state - varchar(10) county - varchar(15) hai - varchar(30) operative_procedure - varchar(76) facility_id - varchar(11) facility_name - varchar(85) hospital_category_riskadjustment - varchar(32) facility_type - varchar(23) procedure_count - varchar(15) infections_reported - varchar(19) infections_predicted - varchar(20) 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) notes - varchar(21) ssi_in_pediatric_patients_january_1_december_31_2021     year - int state - varchar(10) county - varchar(15) hai - varchar(30) operative_procedure - varchar(76) facility_id - varchar(11) facility_name - varchar(63) hospital_category_riskadjustment - varchar(32) facility_type - varchar(23) procedure_count - varchar(15) infections_reported - varchar(19) infections_predicted - varchar(20) 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) notes - varchar(21) ssi_in_pediatric_patients_january_1_december_31_2023     year - int state - varchar(10) county - varchar(15) hai - varchar(30) operative_procedure - varchar(76) facility_id - varchar(11) facility_name - varchar(85) hospital_category_riskadjustment - varchar(32) facility_type - varchar(23) procedure_count - varchar(15) infections_reported - varchar(19) infections_predicted - varchar(20) 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) notes - varchar(21) ssis_for_24_operative_procedures_2013     year - int state - varchar(10) hai - varchar(3) operative_procedure - varchar(69) facid1 - varchar(9) facility_name1 - varchar(66) facid2 - varchar(9) facility_name2 - varchar(63) facid3 - varchar(9) facility_name3 - varchar(56) county - varchar(22) procedure_count - varchar(15) infection_count - varchar(15) sir - varchar(5) comparison - varchar(13) sir_95pct_ci_ll - varchar(13) sir_95pct_ci_ul - varchar(13) notes - varchar(23) ssis_for_24_operative_procedures_2014     year - int state - varchar(10) hai - varchar(63) operative_procedure - varchar(69) facility_id1 - varchar(12) facility_name1 - varchar(68) county - varchar(15) procedure_count - varchar(15) infection_count - varchar(15) predicted_infection_count - varchar(25) sir - varchar(5) comparison - varchar(14) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) notes - varchar(53) ssis_for_24_operative_procedures_2015     year - int state - varchar(10) hai - varchar(63) operative_procedure - varchar(69) facility_id1 - varchar(12) facility_name1 - varchar(67) county - varchar(15) procedure_count - varchar(15) infection_count - varchar(15) predicted_infection_count - varchar(25) sir - varchar(5) comparison - varchar(14) sir_ci_95_lower_limit - varchar(21) sir_ci_95_upper_limit - varchar(21) notes - varchar(53) ssis_for_5_operative_procedures_2013     year - int state - varchar(10) hai - varchar(3) operative_procedure - varchar(19) facid1 - varchar(9) facility_name1 - varchar(66) facid2 - varchar(9) facility_name2 - varchar(63) facid3 - varchar(9) facility_name3 - varchar(56) county - varchar(22) procedure_count - varchar(15) infection_count - varchar(15) notes - varchar(21) ssis_for_5_operative_procedures_2014     year - int state - varchar(10) hai - varchar(63) operative_procedure - varchar(19) facility_id1 - varchar(12) facility_name1 - varchar(68) county - varchar(15) procedure_count - varchar(15) infection_count - varchar(15) predicted_infection_count - varchar(25) notes - varchar(58) ssis_for_5_operative_procedures_2015     year - int state - varchar(10) hai - varchar(63) operative_procedure - varchar(19) facility_id1 - varchar(12) facility_name_1 - varchar(67) county - varchar(15) procedure_count - varchar(15) infection_count - varchar(15) predicted_infection_count - varchar(25) notes - varchar(58)
Sources	datapackage.json  -    hospitals-who-did-not-report-surgical-procedures-january-1-june-30-2020-updated-annually.csv  -  Table: hosp_who_did_not_rpt_surg_procs_jan_1_jun_30_2020_upd_ann   Fails: 12 hospitals-who-did-not-report-surgical-procedures-july-1-december-31-2020-updated-annually.csv  -  Table: hosp_who_did_not_rpt_surg_procs_jul_1_dec_31_2020_upd_ann   Updated: 2025-10-11 hospitals-who-did-not-report-surgical-procedures-january-1-december-31-2021.csv  -  Table: hospitals_who_did_not_report_surg_proc_jan_1_dec_31_2021   Updated: 2025-10-11 hospitals-who-did-not-report-surgical-procedures-january-1-december-31-2023.csv  -  Table: hospitals_who_did_not_report_surg_procs_jan_1_dec_31_2023   Fails: 8 hospitals-who-did-not-report-surgical-procedures-2016.csv  -  Table: hospitals_who_did_not_report_surgical_procedures_2016   Updated: 2025-10-11 hospitals-who-did-not-report-surgical-procedures-2017.csv  -  Table: hospitals_who_did_not_report_surgical_procedures_2017   Updated: 2025-10-11 hospitals-who-did-not-report-surgical-procedures-2018.csv  -  Table: hospitals_who_did_not_report_surgical_procedures_2018   Updated: 2025-10-11 hospitals-who-did-not-report-surgical-procedures-2019.csv  -  Table: hospitals_who_did_not_report_surgical_procedures_2019   Updated: 2025-10-11 hospitals-who-did-not-report-surgical-procedures-2022.csv  -  Table: hospitals_who_did_not_report_surgical_procedures_2022   Updated: 2025-10-11 ssi-in-adult-patients-2016.csv  -  Table: ssi_in_adult_patients_2016   Updated: 2025-10-11 ssi-in-adult-patients-2017.csv  -  Table: ssi_in_adult_patients_2017   Fails: 3 ssi-in-adult-patients-2018.csv  -  Table: ssi_in_adult_patients_2018   Fails: 3 ssi-in-adult-patients-2019.csv  -  Table: ssi_in_adult_patients_2019   Updated: 2025-10-11 ssi-in-adult-patients-2021.csv  -  Table: ssi_in_adult_patients_2021   Updated: 2025-10-11 ssi-in-adult-patients-2022.csv  -  Table: ssi_in_adult_patients_2022   Updated: 2025-10-11 ssi-in-adult-patients-january-1-december-31-2023.csv  -  Table: ssi_in_adult_patients_january_1_december_31_2023   Fails: 8 ssi-in-adult-patients-january-1-june-30-2020-updated-annually.csv  -  Table: ssi_in_adult_patients_january_1_june_30_2020_updated_annually   Updated: 2025-10-11 ssi-in-adult-patients-july-1-december-31-2020-updated-annually.csv  -  Table: ssi_in_adult_patients_july_1_december_31_2020_updated_annually   Fails: 12 ssi-in-pediatric-patients-january-1-june-30-2020-updated-annually.csv  -  Table: ssi_in_ped_pats_jan_1_jun_30_2020_upd_ann   Updated: 2025-10-11 ssi-in-pediatric-patients-july-1-december-31-2020-updated-annually.csv  -  Table: ssi_in_ped_pats_jul_1_dec_31_2020_upd_ann   Updated: 2025-10-11 ssi-in-pediatric-patients-2016.csv  -  Table: ssi_in_pediatric_patients_2016   Fails: 3 ssi-in-pediatric-patients-2017.csv  -  Table: ssi_in_pediatric_patients_2017   Fails: 3 ssi-in-pediatric-patients-2018.csv  -  Table: ssi_in_pediatric_patients_2018   Fails: 3 ssi-in-pediatric-patients-2019.csv  -  Table: ssi_in_pediatric_patients_2019   Updated: 2025-10-11 ssi-in-pediatric-patients-2022.csv  -  Table: ssi_in_pediatric_patients_2022   Updated: 2025-10-11 ssi-in-pediatric-patients-january-1-december-31-2021.csv  -  Table: ssi_in_pediatric_patients_january_1_december_31_2021   Updated: 2025-10-11 ssi-in-pediatric-patients-january-1-december-31-2023.csv  -  Table: ssi_in_pediatric_patients_january_1_december_31_2023   Fails: 8 ssis-for-24-operative-procedures-2013.csv  -  Table: ssis_for_24_operative_procedures_2013   Fails: 3 ssis-for-24-operative-procedures-2014.csv  -  Table: ssis_for_24_operative_procedures_2014   Updated: 2025-10-11 ssis-for-24-operative-procedures-2015.csv  -  Table: ssis_for_24_operative_procedures_2015   Updated: 2025-10-11 ssis-for-5-operative-procedures-2013.csv  -  Table: ssis_for_5_operative_procedures_2013   Updated: 2025-10-11 ssis-for-5-operative-procedures-2014.csv  -  Table: ssis_for_5_operative_procedures_2014   Updated: 2025-10-11 ssis-for-5-operative-procedures-2015.csv  -  Table: ssis_for_5_operative_procedures_2015   Updated: 2025-10-11
Updated