Hospital Care Quality Measures

Timely & Effective Care Across the U.S

@kaggle.thedevastator_hospital_care_quality_measures

Table List

1 table(4.98 MB)

Rows

@kaggle.thedevastator_hospital_care_quality_measures.rows

4.98 MB
180763 rows
18 columns

index Index	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	condition Condition	measure_id Measure ID	measure_name Measure Name	score Score	sample Sample	footnote Footnote	measure_start_date Measure Start Date	measure_end_date Measure End Date	location Location
	010005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	Heart Attack or Chest Pain	AMI_7a	Fibrinolytic Therapy Received Within 30 Minutes Of Hospital Arrival	Not Available	Not Available	7 - No cases met the criteria for this measure.	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
1	010005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	Heart Attack or Chest Pain	AMI_8a	Primary PCI Received Within 90 Minutes of Hospital Arrival	82	11	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
2	010005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	Emergency Department	ED_1b	ED1	248	1238	2 - Data submitted were based on a sample of cases/patients.	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
3	010005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	Emergency Department	ED_2b	ED2	69	1115	2 - Data submitted were based on a sample of cases/patients.	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
4	010005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	Emergency Department	EDV	Emergency department volume	Very High (60,000+ patients annually)	nan	nan	Tue Jan 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	2505 U S HIGHWAY 431 NORTH BOAZ, AL 35957
5	010005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	Heart Failure	HF_2	Evaluation of LVS Function	98	187	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
6	010005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	Preventive Care	IMM_2	Immunization for influenza	99	914	2 - Data submitted were based on a sample of cases/patients.	Wed Oct 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2505 U S HIGHWAY 431 NORTH BOAZ, AL 35957
7	010005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	Preventive Care	IMM_3_OP_27_FAC_ADHPCT	Healthcare workers given influenza vaccination	86	1773	nan	Wed Oct 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2505 U S HIGHWAY 431 NORTH BOAZ, AL 35957
8	010005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	Heart Attack or Chest Pain	OP_1	Median Time to Fibrinolysis	Not Available	Not Available	1 - The number of cases/patients is too few to report.	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
9	010005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	MARSHALL	2565938310	Emergency Department	OP_18b	OP 18	120	1437	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 rows (
  "index" BIGINT,
  "provider_id" VARCHAR,
  "hospital_name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "county_name" VARCHAR,
  "phone_number" BIGINT,
  "condition" VARCHAR,
  "measure_id" VARCHAR,
  "measure_name" VARCHAR,
  "score" VARCHAR,
  "sample" VARCHAR,
  "footnote" VARCHAR,
  "measure_start_date" TIMESTAMP,
  "measure_end_date" TIMESTAMP,
  "location" VARCHAR
);