Diabetes 130-US Hospitals for Years 1999-2008

About

The dataset represents ten years (1999-2008) of clinical care at 130 US hospitals and integrated delivery networks. Each row concerns hospital records of patients diagnosed with diabetes, who underwent laboratory, medications, and stayed up to 14 days. The goal is to determine the early readmission of the patient within 30 days of discharge. The problem is important for the following reasons. Despite high-quality evidence showing improved clinical outcomes for diabetic patients who receive various preventive and therapeutic interventions, many patients do not receive them. This can be partially attributed to arbitrary diabetes management in hospital environments, which fail to attend to glycemic control. Failure to provide proper diabetes care not only increases the managing costs for the hospitals (as the patients are readmitted) but also impacts the morbidity and mortality of the patients, who may face complications associated with diabetes. The dataset represents ten years (1999-2008) of clinical care at 130 US hospitals and integrated delivery networks. It includes over 50 features representing patient and hospital outcomes. Information was extracted from the database for encounters that satisfied the following criteria. (1) It is an inpatient encounter (a hospital admission). (2) It is a diabetic encounter, that is, one during which any kind of diabetes was entered into the system as a diagnosis. (3) The length of stay was at least 1 day and at most 14 days. (4) Laboratory tests were performed during the encounter. (5) Medications were administered during the encounter. The data contains such attributes as patient number, race, gender, age, admission type, time in hospital, medical specialty of admitting physician, number of lab tests performed, HbA1c test result, diagnosis, number of medications, diabetic medications, number of outpatient, inpatient, and emergency visits in the year before the hospitalization, etc. Does this dataset contain sensitive information?: The dataset contains information about the age, gender, and race of the patients.

Subject Area

Health and Medicine

Instances

101,766

Features

Data Types

Multivariate

Tasks

Classification, Clustering

Feature Types

Categorical, Integer

Features

Name	Role	Type	Units	Missing Values
encounter_id	Id	Other	-	No
└ Unique identifier of an encounter
patient_nbr	Id	Other	-	No
└ Unique identifier of a patient
race	Feature	Categorical	-	Yes
└ Values: Caucasian, Asian, African American, Hispanic, and other
gender	Feature	Categorical	-	No
└ Values: male, female, and unknown/invalid
age	Feature	Categorical	-	No
└ Grouped in 10-year intervals: [0, 10), [10, 20),..., [90, 100)
weight	Feature	Categorical	-	Yes
└ Weight in pounds.
admission_type_id	Feature	Categorical	-	No
└ Integer identifier corresponding to 9 distinct values, for example, emergency, urgent, elective, newborn, and not available
discharge_disposition_id	Feature	Categorical	-	No
└ Integer identifier corresponding to 29 distinct values, for example, discharged to home, expired, and not available
admission_source_id	Feature	Categorical	-	No
└ Integer identifier corresponding to 21 distinct values, for example, physician referral, emergency room, and transfer from a hospital
time_in_hospital	Feature	Integer	-	No
└ Integer number of days between admission and discharge
payer_code	Feature	Categorical	-	Yes
└ Integer identifier corresponding to 23 distinct values, for example, Blue Cross/Blue Shield, Medicare, and self-pay
medical_specialty	Feature	Categorical	-	Yes
└ Integer identifier of a specialty of the admitting physician, corresponding to 84 distinct values, for example, cardiology, internal medicine, family/general practice, and surgeon
num_lab_procedures	Feature	Integer	-	No
└ Number of lab tests performed during the encounter
num_procedures	Feature	Integer	-	No
└ Number of procedures (other than lab tests) performed during the encounter
num_medications	Feature	Integer	-	No
└ Number of distinct generic names administered during the encounter
number_outpatient	Feature	Integer	-	No
└ Number of outpatient visits of the patient in the year preceding the encounter
number_emergency	Feature	Integer	-	No
└ Number of emergency visits of the patient in the year preceding the encounter
number_inpatient	Feature	Integer	-	No
└ Number of inpatient visits of the patient in the year preceding the encounter
diag_1	Feature	Categorical	-	Yes
└ The primary diagnosis (coded as first three digits of ICD9); 848 distinct values
diag_2	Feature	Categorical	-	Yes
└ Secondary diagnosis (coded as first three digits of ICD9); 923 distinct values
diag_3	Feature	Categorical	-	Yes
└ Additional secondary diagnosis (coded as first three digits of ICD9); 954 distinct values
number_diagnoses	Feature	Integer	-	No
└ Number of diagnoses entered to the system
max_glu_serum	Feature	Categorical	-	No
└ Indicates the range of the result or if the test was not taken. Values: >200, >300, normal, and none if not measured
A1Cresult	Feature	Categorical	-	No
└ Indicates the range of the result or if the test was not taken. Values: >8 if the result was greater than 8%, >7 if the result was greater than 7% but less than 8%, normal if the result was less than 7%, and none if not measured.
metformin	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
repaglinide	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
nateglinide	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
chlorpropamide	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
glimepiride	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
acetohexamide	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
glipizide	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
glyburide	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
tolbutamide	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
pioglitazone	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
rosiglitazone	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
acarbose	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
miglitol	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
troglitazone	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
tolazamide	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
examide	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
citoglipton	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
insulin	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
glyburide-metformin	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
glipizide-metformin	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
glimepiride-pioglitazone	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
metformin-rosiglitazone	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
metformin-pioglitazone	Feature	Categorical	-	No
└ The feature indicates whether the drug was prescribed or there was a change in the dosage. Values: up if the dosage was increased during the encounter, down if the dosage was decreased, steady if the dosage did not change, and no if the drug was not prescribed
change	Feature	Categorical	-	No
└ Indicates if there was a change in diabetic medications (either dosage or generic name). Values: change and no change
diabetesMed	Feature	Categorical	-	No
└ Indicates if there was any diabetic medication prescribed. Values: yes and no
readmitted	Target	Categorical	-	No
└ Days to inpatient readmission. Values: <30 if the patient was readmitted in less than 30 days, >30 if the patient was readmitted in more than 30 days, and No for no record of readmission.

Introductory Paper

Impact of HbA1c Measurement on Hospital Readmission Rates: Analysis of 70,000 Clinical Database Patient Record

Beata Strack, Jonathan DeShazo, Chris Gennings, Juan Olmo, Sebastian Ventura, Krzysztof Cios, John Clore. 2014.

BioMed Research International, vol. 2014

Additional Metadata

Keywords

–

Authors

John Clore

Krzysztof Cios

Jon DeShazo

Beata Strack

Year Created

2014

DOI

10.24432/C5230J

License

CC BY 4.0

Diabetes 130-US Hospitals for Years 1999-2008

About

Features

Introductory Paper

Additional Metadata

Authors

Donation Information