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 - None
hospitals-who-did-not-report-surgical-procedures-january-1-june-30-2020-updated-annually.csv - hosp_who_did_not_rpt_surg_procs_jan_1_jun_30_2020_upd_ann
hospitals-who-did-not-report-surgical-procedures-july-1-december-31-2020-updated-annually.csv - hosp_who_did_not_rpt_surg_procs_jul_1_dec_31_2020_upd_ann
hospitals-who-did-not-report-surgical-procedures-january-1-december-31-2021.csv - hospitals_who_did_not_report_surg_proc_jan_1_dec_31_2021
hospitals-who-did-not-report-surgical-procedures-january-1-december-31-2023.csv - hospitals_who_did_not_report_surg_procs_jan_1_dec_31_2023
hospitals-who-did-not-report-surgical-procedures-2016.csv - hospitals_who_did_not_report_surgical_procedures_2016
hospitals-who-did-not-report-surgical-procedures-2017.csv - hospitals_who_did_not_report_surgical_procedures_2017
hospitals-who-did-not-report-surgical-procedures-2018.csv - hospitals_who_did_not_report_surgical_procedures_2018
hospitals-who-did-not-report-surgical-procedures-2019.csv - hospitals_who_did_not_report_surgical_procedures_2019
hospitals-who-did-not-report-surgical-procedures-2022.csv - hospitals_who_did_not_report_surgical_procedures_2022
ssi-in-adult-patients-2016.csv - ssi_in_adult_patients_2016
ssi-in-adult-patients-2017.csv - ssi_in_adult_patients_2017
ssi-in-adult-patients-2018.csv - ssi_in_adult_patients_2018
ssi-in-adult-patients-2019.csv - ssi_in_adult_patients_2019
ssi-in-adult-patients-2021.csv - ssi_in_adult_patients_2021
ssi-in-adult-patients-2022.csv - ssi_in_adult_patients_2022
ssi-in-adult-patients-january-1-december-31-2023.csv - ssi_in_adult_patients_january_1_december_31_2023
ssi-in-adult-patients-january-1-june-30-2020-updated-annually.csv - ssi_in_adult_patients_january_1_june_30_2020_updated_annually
ssi-in-adult-patients-july-1-december-31-2020-updated-annually.csv - ssi_in_adult_patients_july_1_december_31_2020_updated_annually
ssi-in-pediatric-patients-january-1-june-30-2020-updated-annually.csv - ssi_in_ped_pats_jan_1_jun_30_2020_upd_ann
ssi-in-pediatric-patients-july-1-december-31-2020-updated-annually.csv - ssi_in_ped_pats_jul_1_dec_31_2020_upd_ann
ssi-in-pediatric-patients-2016.csv - ssi_in_pediatric_patients_2016
ssi-in-pediatric-patients-2017.csv - ssi_in_pediatric_patients_2017
ssi-in-pediatric-patients-2018.csv - ssi_in_pediatric_patients_2018
ssi-in-pediatric-patients-2019.csv - ssi_in_pediatric_patients_2019
ssi-in-pediatric-patients-2022.csv - ssi_in_pediatric_patients_2022
ssi-in-pediatric-patients-january-1-december-31-2021.csv - ssi_in_pediatric_patients_january_1_december_31_2021
ssi-in-pediatric-patients-january-1-december-31-2023.csv - ssi_in_pediatric_patients_january_1_december_31_2023
ssis-for-24-operative-procedures-2013.csv - ssis_for_24_operative_procedures_2013
ssis-for-24-operative-procedures-2014.csv - ssis_for_24_operative_procedures_2014
ssis-for-24-operative-procedures-2015.csv - ssis_for_24_operative_procedures_2015
ssis-for-5-operative-procedures-2013.csv - ssis_for_5_operative_procedures_2013
ssis-for-5-operative-procedures-2014.csv - ssis_for_5_operative_procedures_2014
ssis-for-5-operative-procedures-2015.csv - ssis_for_5_operative_procedures_2015
Updates
2025-07-11 17:51:30      None
2025-02-02 19:02:52      2
2024-12-31 18:15:24      0
2024-12-31 18:15:08      0
2024-12-31 18:13:16      0
2024-12-31 18:13:01      0
2024-12-29 22:52:03      0
2024-12-29 22:51:47      0
2024-12-29 22:46:09      1
2024-12-29 22:45:28      0
2024-12-29 22:45:12      1
2024-12-29 22:42:17      0
2024-12-29 22:42:01      0
2024-12-29 22:40:54      1
2024-12-29 22:39:14      0
2024-12-29 22:38:58      1
2024-12-29 22:38:23      1
2024-12-29 22:36:55      1
2024-12-29 22:36:55      1
2024-12-29 22:35:25      0
2024-12-29 22:34:44      0
2024-12-29 22:34:28      1
2024-12-29 22:32:39      1
2024-12-29 22:32:38      1
2024-12-29 22:29:51      0
2024-12-29 22:29:35      1
2024-12-29 22:27:12      0
2024-12-29 22:26:56      1
2024-12-29 22:15:05      0
2024-12-29 22:12:08      1
2024-12-29 00:19:00      1
2024-12-28 21:46:38      1
2024-11-16 16:44:50      None
2024-09-18 13:22:36      None
2024-09-09 16:03:43      None
2024-09-09 13:50:56      None
2024-08-06 17:30:40      None
2024-08-06 16:11:03      None
2024-08-06 12:40:50      None
2024-08-05 19:30:42      None