| Name |
methicillin-resistant-staphylococcus-aureus-mrsa-bloodstream-infections-bsi-in-california-hospitals |
|---|
| Updated |
2024-08-29 |
|---|
| 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
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-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 |
|
|---|