Hospital Infections Dataset

Detailed Information on Hospital Infections and Performance Measures

@kaggle.muhammadfaizan65_hospital_infections_dataset

Table List

1 table(4.38 MB)

Healthcare Associated Infections Hospital

Healthcare Associated Infections Hospital

@kaggle.muhammadfaizan65_hospital_infections_dataset.healthcare_associated_infections_hospital

4.38 MB
222864 rows
16 columns

provider_id Provider ID	hospital_name Hospital Name	address Address	city City	state State	zip_code ZIP Code	county_name County Name	phone_number Phone Number	measure_name Measure Name	measure_id Measure ID	compared_to_national Compared To National	score Score	footnote Footnote	measure_start_date Measure Start Date	measure_end_date Measure End Date	location Location
10005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	CLABSI: Lower Confidence Limit	HAI_1_CI_LOWER	No Different than National Benchmark	0.165	nan	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2505 U S HIGHWAY 431 NORTH BOAZ, AL 35957
10005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	CLABSI: Upper Confidence Limit	HAI_1_CI_UPPER	No Different than National Benchmark	3.249	nan	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2505 U S HIGHWAY 431 NORTH BOAZ, AL 35957
10005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	CLABSI: Number of Procedures	HAI_1_DOPC_DAYS	No Different than National Benchmark	1485	nan	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2505 U S HIGHWAY 431 NORTH BOAZ, AL 35957
10005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	CLABSI: Predicted Cases	HAI_1_ELIGCASES	No Different than National Benchmark	2.034	nan	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2505 U S HIGHWAY 431 NORTH BOAZ, AL 35957
10005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	CLABSI: Observed Cases	HAI_1_NUMERATOR	No Different than National Benchmark	2	nan	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2505 U S HIGHWAY 431 NORTH BOAZ, AL 35957
10005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	Central line-associated bloodstream infections (CLABSI) in ICUs and select wards	HAI_1_SIR	No Different than National Benchmark	0.983	nan	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2505 U S HIGHWAY 431 NORTH BOAZ, AL 35957
10005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	CLABSI Lower Confidence Limit	HAI_1a_CI_LOWER	Worse than the National Benchmark	1.168	nan	Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2505 U S HIGHWAY 431 NORTH BOAZ, AL 35957
10005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	CLABSI Upper Confidence Limit	HAI_1a_CI_UPPER	Worse than the National Benchmark	7.068	nan	Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2505 U S HIGHWAY 431 NORTH BOAZ, AL 35957
10005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	CLABSI Central Line Days	HAI_1a_DOPC_DAYS	Worse than the National Benchmark	1045	nan	Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2505 U S HIGHWAY 431 NORTH BOAZ, AL 35957
10005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	CLABSI Predicted Cases	HAI_1a_ELIGCASES	Worse than the National Benchmark	1.568	nan	Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2505 U S HIGHWAY 431 NORTH BOAZ, AL 35957


CREATE TABLE healthcare_associated_infections_hospital (
  "provider_id" BIGINT,
  "hospital_name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "county_name" VARCHAR,
  "phone_number" BIGINT,
  "measure_name" VARCHAR,
  "measure_id" VARCHAR,
  "compared_to_national" VARCHAR,
  "score" VARCHAR,
  "footnote" VARCHAR,
  "measure_start_date" TIMESTAMP,
  "measure_end_date" TIMESTAMP,
  "location" VARCHAR
);