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_hospitals_2024     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  -    mrsa-data-dictionary-2017.xlsx  -    mrsa-data-dictionary-2018.xlsx  -    mrsa-in-hospitals-data-dictionary-2013-2015.xlsx  -    mrsa-in-long-term-acute-care-data-dictionary-2013-2015.xls  -    mrsa-in-rehabilitation-acute-care-data-dictionary-2013-2015.xls  -    datapackage.json  -    mrsa-bsi-in-hospitals-2021.csv  -  Table: mrsa_bsi_in_hospitals_2021   Updated: 2025-10-11 mrsa-bsi-in-hospitals-2022.csv  -  Table: mrsa_bsi_in_hospitals_2022   Updated: 2025-10-11 mrsa-bsi-in-hospitals-2023.csv  -  Table: mrsa_bsi_in_hospitals_2023   Updated: 2025-10-11 mrsa-bsi-in-hospitals-2024.csv  -  Table: mrsa_bsi_in_hospitals_2024   Updated: 2025-10-11 mrsa-bsi-in-january-through-june-2020-updated-annually.csv  -  Table: mrsa_bsi_in_january_through_june_2020_updated_annually   Updated: 2025-10-11 mrsa-bsi-in-july-through-december-2020-updated-annually.csv  -  Table: mrsa_bsi_in_july_through_december_2020_updated_annually   Updated: 2025-10-11 mrsa-in-hospitals-2013.csv  -  Table: mrsa_in_hospitals_2013   Fails: 3 mrsa-in-hospitals-2014.csv  -  Table: mrsa_in_hospitals_2014   Updated: 2025-10-11 mrsa-in-hospitals-2015.csv  -  Table: mrsa_in_hospitals_2015   Updated: 2025-10-11 mrsa-in-hospitals-2016.csv  -  Table: mrsa_in_hospitals_2016   Updated: 2025-10-11 mrsa-in-hospitals-2017.csv  -  Table: mrsa_in_hospitals_2017   Updated: 2025-10-11 mrsa-in-hospitals-2018.csv  -  Table: mrsa_in_hospitals_2018   Fails: 3 mrsa-in-hospitals-2019.csv  -  Table: mrsa_in_hospitals_2019   Updated: 2025-10-11 mrsa-in-long-term-acute-care-2013.csv  -  Table: mrsa_in_long_term_acute_care_2013   Fails: 3 mrsa-in-long-term-acute-care-2014.csv  -  Table: mrsa_in_long_term_acute_care_2014   Updated: 2025-10-11 mrsa-in-long-term-acute-care-2015.csv  -  Table: mrsa_in_long_term_acute_care_2015   Updated: 2025-10-11 mrsa-in-rehabilitation-acute-care-2013.csv  -  Table: mrsa_in_rehabilitation_acute_care_2013   Fails: 3 mrsa-in-rehabilitation-acute-care-2014.csv  -  Table: mrsa_in_rehabilitation_acute_care_2014   Updated: 2025-10-11 mrsa-in-rehabilitation-acute-care-2015.csv  -  Table: mrsa_in_rehabilitation_acute_care_2015   Updated: 2025-10-11
Updated