Home

Dataset:

Name methicillin-resistant-staphylococcus-aureus-mrsa-bloodstream-infections-bsi-in-california-hospitals
Updated 2024-08-29
CA Dataset link
Current True
Tables
mrsa_bsi_in_hospitals_2021     year - int
state - varchar(10)
hai - varchar(77)
facility_id - varchar(11)
facility_name - varchar(63)
county - varchar(15)
hospital_category_riskadjustment - varchar(67)
hospital_type - varchar(67)
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)
met_2020_goal - varchar(13)
months - varchar(6)
sir_2015 - varchar(8)
notes - varchar(67)
mrsa_bsi_in_hospitals_2022     year - int
state - varchar(10)
hai - varchar(77)
facility_id - varchar(11)
facility_name - varchar(85)
county - varchar(15)
hospital_category_riskadjustment - varchar(67)
hospital_type - varchar(67)
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)
met_2020_goal - varchar(13)
months - varchar(6)
sir_2015 - varchar(8)
notes - varchar(66)
mrsa_bsi_in_hospitals_2023     year - int
state - varchar(10)
hai - varchar(77)
facility_id - varchar(11)
facility_name - varchar(85)
county - varchar(15)
hospital_category_riskadjustment - varchar(67)
hospital_type - varchar(67)
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)
met_2020_goal - varchar(13)
months - varchar(6)
sir_2015 - varchar(8)
notes - varchar(66)
mrsa_bsi_in_january_through_june_2020_updated_annually     year - varchar(6)
state - varchar(10)
county - varchar(15)
hai - varchar(77)
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)
mrsa_bsi_in_july_through_december_2020_updated_annually     year - varchar(6)
state - varchar(10)
county - varchar(15)
hai - varchar(77)
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(4)
sir_ci_95_lower_limit - varchar(21)
sir_ci_95_upper_limit - varchar(21)
comparison - varchar(10)
months - varchar(6)
notes - varchar(43)
mrsa_in_hospitals_2013     year - int
state - varchar(10)
hai - varchar(76)
facility_name1 - varchar(66)
facility_name2 - varchar(63)
facility_name3 - varchar(56)
facid1 - varchar(9)
facid2 - varchar(9)
facid3 - varchar(9)
county - varchar(22)
infection_count - varchar(15)
patient_days - varchar(12)
sir - varchar(5)
sir_95pct_ci_lower_limit - varchar(22)
sir_95pct_ci_upper_limit - varchar(22)
comparison - varchar(12)
notes - varchar(42)
mrsa_in_hospitals_2014     year - int
state - varchar(10)
hai - varchar(76)
facility_id1 - varchar(12)
facility_name1 - varchar(69)
county - varchar(15)
cases - varchar(5)
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)
mrsa_in_hospitals_2015     year - int
state - varchar(10)
hai - varchar(76)
facility_id1 - varchar(12)
facility_name1 - varchar(67)
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(79)
mrsa_in_hospitals_2016     year - int
state - varchar(10)
hai - varchar(77)
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(5)
sir_ci_95_lower_limit - varchar(21)
sir_ci_95_upper_limit - varchar(21)
comparison - varchar(10)
sir_2015 - varchar(8)
notes - varchar(78)
mrsa_in_hospitals_2017     year - int
state - varchar(10)
hai - varchar(77)
facility_id - varchar(11)
facility_name - varchar(85)
county - varchar(15)
hospital_category_riskadjustment - varchar(32)
hospital_type - varchar(54)
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)
sir_2015 - varchar(8)
on_track - varchar(8)
months - varchar(6)
notes - varchar(66)
mrsa_in_hospitals_2018     year - int
state - varchar(10)
hai - varchar(77)
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)
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_70_2018 - varchar(38)
sir_2015 - varchar(8)
months - varchar(6)
notes - varchar(43)
mrsa_in_hospitals_2019     year - int
state - varchar(10)
county - varchar(15)
hai - varchar(77)
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(4)
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)
mrsa_in_long_term_acute_care_2013     year - int
state - varchar(10)
hai - varchar(76)
facility_name - varchar(56)
facid - varchar(9)
county - varchar(14)
cases - varchar(5)
patient_days - varchar(12)
incidence_rate - varchar(14)
95pct_confidence_interval_lower_limit - varchar(35)
95pct_confidence_interval_upper_limit - varchar(35)
compared_to_pooled_mean_rate - varchar(29)
notes - varchar(5)
mrsa_in_long_term_acute_care_2014     year - int
state - varchar(10)
hai - varchar(76)
facility_id1 - varchar(12)
facility_name1 - varchar(52)
county - varchar(14)
cases - varchar(5)
patient_days - varchar(12)
incidence_rate - varchar(14)
ci_95_lower_limit - varchar(17)
ci_95_upper_limit - varchar(17)
compared_to_pooled_mean_rate - varchar(28)
notes - varchar(40)
mrsa_in_long_term_acute_care_2015     year - int
state - varchar(10)
hai - varchar(76)
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)
comparison - varchar(13)
notes - varchar(48)
mrsa_in_rehabilitation_acute_care_2013     year - int
state - varchar(10)
hai - varchar(76)
facility_name - varchar(56)
facid - varchar(9)
county - varchar(14)
cases - varchar(5)
patient_days - varchar(12)
incidence_rate - varchar(14)
95pct_confidence_interval_lower_limit - varchar(35)
95pct_confidence_interval_upper_limit - varchar(35)
compared_to_pooled_mean_rate - varchar(29)
notes - varchar(42)
mrsa_in_rehabilitation_acute_care_2014     year - int
state - varchar(10)
hai - varchar(76)
facility_id1 - varchar(12)
facility_name1 - varchar(48)
county - varchar(14)
cases - varchar(5)
patient_days - varchar(12)
incidence_rate - varchar(14)
ci_95_lower_limit - varchar(17)
ci_95_upper_limit - varchar(17)
compared_to_pooled_mean_rate - varchar(28)
notes - varchar(5)
mrsa_in_rehabilitation_acute_care_2015     year - int
state - varchar(10)
hai - varchar(76)
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)
comparison - varchar(13)
notes - varchar(37)
Sources
mrsa-data-dictionary-2016.xlsx - None
mrsa-data-dictionary-2017.xlsx - None
mrsa-data-dictionary-2018.xlsx - None
mrsa-in-hospitals-data-dictionary-2013-2015.xlsx - None
mrsa-in-long-term-acute-care-data-dictionary-2013-2015.xls - None
mrsa-in-rehabilitation-acute-care-data-dictionary-2013-2015.xls - None
datapackage.json - None
mrsa-bsi-in-hospitals-2021.csv - mrsa_bsi_in_hospitals_2021
mrsa-bsi-in-hospitals-2022.csv - mrsa_bsi_in_hospitals_2022
mrsa-bsi-in-hospitals-2023.csv - mrsa_bsi_in_hospitals_2023
mrsa-bsi-in-january-through-june-2020-updated-annually.csv - mrsa_bsi_in_january_through_june_2020_updated_annually
mrsa-bsi-in-july-through-december-2020-updated-annually.csv - mrsa_bsi_in_july_through_december_2020_updated_annually
mrsa-in-hospitals-2013.csv - mrsa_in_hospitals_2013
mrsa-in-hospitals-2014.csv - mrsa_in_hospitals_2014
mrsa-in-hospitals-2015.csv - mrsa_in_hospitals_2015
mrsa-in-hospitals-2016.csv - mrsa_in_hospitals_2016
mrsa-in-hospitals-2017.csv - mrsa_in_hospitals_2017
mrsa-in-hospitals-2018.csv - mrsa_in_hospitals_2018
mrsa-in-hospitals-2019.csv - mrsa_in_hospitals_2019
mrsa-in-long-term-acute-care-2013.csv - mrsa_in_long_term_acute_care_2013
mrsa-in-long-term-acute-care-2014.csv - mrsa_in_long_term_acute_care_2014
mrsa-in-long-term-acute-care-2015.csv - mrsa_in_long_term_acute_care_2015
mrsa-in-rehabilitation-acute-care-2013.csv - mrsa_in_rehabilitation_acute_care_2013
mrsa-in-rehabilitation-acute-care-2014.csv - mrsa_in_rehabilitation_acute_care_2014
mrsa-in-rehabilitation-acute-care-2015.csv - mrsa_in_rehabilitation_acute_care_2015
Updates
2025-07-11 17:52:43      None
2025-02-02 18:44:33      0
2024-12-27 18:56:33      0
2024-12-14 17:12:07      0
2024-12-04 16:45:39      None
2024-09-18 13:13:49      None