HCAI

Home

Dataset:

Name

vancomycin-resistant-enterococci-vre-bloodstream-infections-in-california-hospitals

Updated

2024-08-29

CA Dataset

link

Current

True

Tables

vre_bsi_in_hospitals_2021

year - int
state - varchar(10)
county - varchar(15)
hai - varchar(65)
facility_id - varchar(11)
facility_name - varchar(79)
facility_type - varchar(69)
infections_reported - varchar(19)
patient_days - varchar(12)
rate - varchar(4)
rate_ci_95_lower_limit - varchar(22)
rate_ci_95_upper_limit - varchar(22)
comparison - varchar(10)
months - varchar(6)
rate_2015 - varchar(9)
notes - varchar(43)

vre_bsi_in_hospitals_2022

year - int
state - varchar(10)
county - varchar(15)
hai - varchar(65)
facility_id - varchar(11)
facility_name - varchar(85)
facility_type - varchar(69)
infections_reported - varchar(19)
patient_days - varchar(12)
rate - varchar(4)
rate_ci_95_lower_limit - varchar(22)
rate_ci_95_upper_limit - varchar(22)
comparison - varchar(10)
months - varchar(6)
rate_2015 - varchar(9)
notes - varchar(43)

vre_bsi_in_hospitals_2023

vre_in_california_hospitals_2013

year - int
state - varchar(10)
hai - varchar(64)
hospital_type - varchar(13)
facility_name1 - varchar(66)
facility_name2 - varchar(63)
facility_name3 - varchar(56)
facid1 - varchar(9)
facid2 - varchar(9)
facid3 - varchar(9)
county - varchar(22)
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(28)
case_mix_index - varchar(14)
notes - varchar(42)

vre_in_california_hospitals_2014

year - int
state - varchar(10)
hai - varchar(64)
hospital_type - varchar(25)
facility_id1 - varchar(12)
facility_name1 - varchar(68)
county - varchar(15)
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)
case_mix_index - varchar(14)
notes - varchar(53)

vre_in_california_hospitals_2015

year - int
state - varchar(10)
hai - varchar(64)
hospital_type - varchar(13)
facility_id1 - varchar(12)
facility_name1 - varchar(67)
county - varchar(15)
case_mix_index - 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(55)

vre_in_california_hospitals_2016

year - int
state - varchar(10)
hai - varchar(66)
facility_id - varchar(11)
facility_name - varchar(80)
county - varchar(15)
facility_category - varchar(31)
facility_type - varchar(37)
case_mix_index - varchar(14)
infections_reported - varchar(19)
patient_days - varchar(12)
rate - varchar(4)
rate_ci_95_lower_limit - varchar(22)
rate_ci_95_upper_limit - varchar(22)
comparison - varchar(10)
rate_2015 - varchar(9)
notes - varchar(55)

vre_in_california_hospitals_2017

year - int
state - varchar(10)
hai - varchar(66)
facility_id - varchar(11)
facility_name - varchar(85)
county - varchar(15)
hospital_category - varchar(82)
hospital_type - varchar(82)
infections_reported - varchar(19)
patient_days - varchar(12)
rate - varchar(4)
rate_ci_95_lower_limit - varchar(22)
rate_ci_95_upper_limit - varchar(22)
comparison - varchar(10)
months - varchar(6)
rate_2016 - varchar(9)
notes - varchar(55)

vre_in_california_hospitals_2018

year - int
state - varchar(10)
hai - varchar(66)
facility_id - varchar(11)
facility_name - varchar(79)
county - varchar(15)
hospital_type - varchar(69)
infections_reported - varchar(19)
patient_days - varchar(12)
rate - varchar(4)
rate_ci_95_lower_limit - varchar(22)
rate_ci_95_upper_limit - varchar(22)
comparison - varchar(10)
months - varchar(6)
rate_2015 - varchar(9)
notes - varchar(21)

vre_in_california_hospitals_2019

year - int
state - varchar(10)
county - varchar(15)
hai - varchar(65)
facility_id - varchar(11)
facility_name - varchar(79)
facility_type - varchar(82)
infections_reported - varchar(19)
patient_days - varchar(12)
rate - varchar(4)
rate_ci_95_lower_limit - varchar(22)
rate_ci_95_upper_limit - varchar(22)
comparison - varchar(10)
months - varchar(6)
notes - varchar(43)

vre_in_hospitals_january_to_june_2020_updated_annually

vre_in_hospitals_july_through_december_2020_updated_annually

year - varchar(6)
state - varchar(10)
county - varchar(15)
hai - varchar(65)
facility_id - varchar(11)
facility_name - varchar(79)
facility_type - varchar(82)
infections_reported - varchar(19)
patient_days - varchar(12)
rate - varchar(4)
rate_ci_95_lower_limit - varchar(22)
rate_ci_95_upper_limit - varchar(22)
comparison - varchar(10)
months - varchar(6)
notes - varchar(43)

Sources

datapackage.json	-
vre-bsi-in-hospitals-2021.csv	-	Table: vre_bsi_in_hospitals_2021	Updated: 2025-10-11
vre-bsi-in-hospitals-2022.csv	-	Table: vre_bsi_in_hospitals_2022	Updated: 2025-10-11
vre-bsi-in-hospitals-2023.csv	-	Table: vre_bsi_in_hospitals_2023	Updated: 2025-10-11
vre-in-california-hospitals-2013.csv	-	Table: vre_in_california_hospitals_2013	Fails: 3
vre-in-california-hospitals-2014.csv	-	Table: vre_in_california_hospitals_2014	Updated: 2025-10-11
vre-in-california-hospitals-2015.csv	-	Table: vre_in_california_hospitals_2015	Updated: 2025-10-11
vre-in-california-hospitals-2016.csv	-	Table: vre_in_california_hospitals_2016	Updated: 2025-10-11
vre-in-california-hospitals-2017.csv	-	Table: vre_in_california_hospitals_2017	Updated: 2025-10-11
vre-in-california-hospitals-2018.csv	-	Table: vre_in_california_hospitals_2018	Updated: 2025-10-11
vre-in-california-hospitals-2019.csv	-	Table: vre_in_california_hospitals_2019	Updated: 2025-10-11
vre-in-hospitals-january-to-june-2020-updated-annually.csv	-	Table: vre_in_hospitals_january_to_june_2020_updated_annually	Updated: 2025-10-11
vre-in-hospitals-july-through-december-2020-updated-annually.csv	-	Table: vre_in_hospitals_july_through_december_2020_updated_annually	Updated: 2025-10-11

Updated