Perform biomedical informatics without a database using MIMIC-III data and Amazon Athena

[manavsehgal]

MIMIC-III (Medical Information Mart for Intensive Care III) is a large, freely-available database comprising deidentified health-related data associated with over forty thousand patients who stayed in critical care units of the Beth Israel Deaconess Medical Center between 2001 and 2012.

The database includes information such as demographics, vital sign measurements made at the bedside (~1 data point per hour), laboratory test results, procedures, medications, caregiver notes, imaging reports, and mortality (both in and out of hospital).

MIMIC supports a diverse range of analytic studies spanning epidemiology, clinical decision-rule improvement, and electronic tool development. It is notable for three factors:

it is freely available to researchers worldwide it encompasses a diverse and very large population of ICU patients it contains high temporal resolution data including lab results, electronic documentation, and bedside monitor trends and waveforms.

The admissions table The callout table The caregivers table The chartevents table The cptevents table The d_cpt table The d_icd_diagnoses table D_ICD_PROCEDURES The d_items table The d_labitems table The datetimeevents table The diagnoses_icd table The drgcodes table The icustays table The inputevents_cv table The inputevents_mv table The labevents table The microbiologyevents table The noteevents table The outputevents table The patients table The prescriptions table The procedureevents_mv table The procedures_icd table The services table The transfers table

Recently, the MIT Laboratory of Computational Physiology (LCP) started hosting the MIMIC-III dataset on the AWS cloud through the AWS Public Dataset program.

https://mimic.physionet.org/iv/access/cloud/aws/

https://aws.amazon.com/blogs/big-data/perform-biomedical-informatics-without-a-database-using-mimic-iii-data-and-amazon-athena/