Baselight
Sign In

Hospital Infections Dataset

Detailed Information on Hospital Infections and Performance Measures

@kaggle.muhammadfaizan65_hospital_infections_dataset

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

10005MARSHALL MEDICAL CENTER SOUTH2505 U S HIGHWAY 431 NORTHBOAZAL35957MARSHALL2565938310CLABSI: Lower Confidence LimitHAI_1_CI_LOWERNo Different than National Benchmark0.165nanThu 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
10005MARSHALL MEDICAL CENTER SOUTH2505 U S HIGHWAY 431 NORTHBOAZAL35957MARSHALL2565938310CLABSI: Upper Confidence LimitHAI_1_CI_UPPERNo Different than National Benchmark3.249nanThu 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
10005MARSHALL MEDICAL CENTER SOUTH2505 U S HIGHWAY 431 NORTHBOAZAL35957MARSHALL2565938310CLABSI: Number of ProceduresHAI_1_DOPC_DAYSNo Different than National Benchmark1485nanThu 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
10005MARSHALL MEDICAL CENTER SOUTH2505 U S HIGHWAY 431 NORTHBOAZAL35957MARSHALL2565938310CLABSI: Predicted CasesHAI_1_ELIGCASESNo Different than National Benchmark2.034nanThu 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
10005MARSHALL MEDICAL CENTER SOUTH2505 U S HIGHWAY 431 NORTHBOAZAL35957MARSHALL2565938310CLABSI: Observed CasesHAI_1_NUMERATORNo Different than National Benchmark2nanThu 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
10005MARSHALL MEDICAL CENTER SOUTH2505 U S HIGHWAY 431 NORTHBOAZAL35957MARSHALL2565938310Central line-associated bloodstream infections (CLABSI) in ICUs and select wardsHAI_1_SIRNo Different than National Benchmark0.983nanThu 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
10005MARSHALL MEDICAL CENTER SOUTH2505 U S HIGHWAY 431 NORTHBOAZAL35957MARSHALL2565938310CLABSI Lower Confidence LimitHAI_1a_CI_LOWERWorse than the National Benchmark1.168nanTue 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
10005MARSHALL MEDICAL CENTER SOUTH2505 U S HIGHWAY 431 NORTHBOAZAL35957MARSHALL2565938310CLABSI Upper Confidence LimitHAI_1a_CI_UPPERWorse than the National Benchmark7.068nanTue 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
10005MARSHALL MEDICAL CENTER SOUTH2505 U S HIGHWAY 431 NORTHBOAZAL35957MARSHALL2565938310CLABSI Central Line DaysHAI_1a_DOPC_DAYSWorse than the National Benchmark1045nanTue 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
10005MARSHALL MEDICAL CENTER SOUTH2505 U S HIGHWAY 431 NORTHBOAZAL35957MARSHALL2565938310CLABSI Predicted CasesHAI_1a_ELIGCASESWorse than the National Benchmark1.568nanTue 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
);