IDEALIST
Datasets Introduction
Retrospective temporal dataset for adult patients who underwent inpatient surgical procedure at UFH between 1/1/2012 and 10/15/2020.
Status
IDEALIST dataset is ready to be used.
Table dictionary
Download Complete Data Dictionary
Administrative Data
Table Name
Description
Action
cohort_def
Definition of data cohorts used for various research
database_update
Database updates informtion
encounters
Encounter related data including demographic, comorbidities, admission-discharge, and death related information for each...
Show More↓
or_case_key_look_up_table
Look up table for all surgery encounters
or_case_schedule_encounters
Surgery related data merged with essential encounters data
Demographic Info
Table Name
Description
Action
education
Patients' education level related data
height_weight
Patients’ height and weight data with date and time stamp for each encounter
nine_digit_zip
9-digit zip, state, and city informaton by patient ID and date
patient_status_table
Patient death status related data
Health Economics Data
Table Name
Description
Action
charges
Total cost and charges in US dollars
Health System Data
Table Name
Description
Action
internal_stations
Information regarding patient's location including enter and exit times to each location
Medical History
Table Name
Description
Action
admission_encounters
Demographic, comorbidities, admission-discharge, and death related information for each admission encounter
anesthesia
Bispectral index information for patients
asa_scores
Results of American Society of Anesthesiologists (ASA) assessment for patient’s physical status
blood_pressure
Blood pressure related data including source, value, and date and timestamp
braden
Data related to Braden scale which is a special scoring system to evaluate a patient’s risk of developing a pressure ulc...
Show More↓
cam
Results of Confusion Assessment Method (CAM)
diagnoses
Diagnoses codes related data
dialysis
Dialysis related data
ecg_cardiology_detail
Electrocardiogram (ECG) related data
glasgow
Glasgow coma score including its components: eye, verbal, motor and sum
heart_rate
Heart rate related data including source, value, and date and timestamp
hemodynamic_monitoring
Hemodynamic monitoring related data
intake_outtake
Intake and output measurements related data
lab_notes
Laboratory notes with details including date and time
labs
Laboratory results with details including lab names, specimen taken date and time, unit, and LOINC codes.
mac_components
Minimum Alveolar Concentration (MAC) related data
meds
Medication data with details including medication name, dose, and date and time stamps.
mews
Modified Early Warning Score (MEWS) related data
mobility
Mobility situation of patients
morse
Morse falls scale data to identify risk factors for falls in hospitalized patients
nephrology_consult
Nephrology consult note details
ob_history_mom_child_birthdate
Delivery dates of the patient
or_case_schedule
Surgery related data including operating room, time, procedure code, and doctor for each surgery
pain
Pain assessment related data
prescribing
Prescribed medication data with details including medication name, dose, and date and time stamps
procedures
Patient procedure records: ICD9, ICD10, and CPT including the “procedure_hierarchy”
rass
Richmond Agitation-Sedation Scale (RASS) sores of patients measured at different time points
realm
Results from Literacy Assessment Tool called Rapid Estimate of Adult Literacy in Medicine (REALM)
respiratory
Respiration related data
sofa
Sequential Organ Failure Assessment (SOFA) score and its components.
ssdi2
Death date based on Social Security Death Index database
temperature
Temperature related data
transfusions
Information about blood product transfusions of patients.
Outcomes Data
Table Name
Description
Action
merged_enc_id_outcome_final
Outcomes for each encounter and surgery
riskassessments
Risk assessments for postoperative complications made by the physicians