The Mount Sinai Data Warehouse (MSDW) collects clinical and operational data for use in clinical and translational research, as well as quality improvement initiatives. The majority of the data provided by the MSDW comes from the Epic (Verona, WI) electronic health record (EHR), which is the primary EHR for the Mount Sinai Health System (MSHS). Epic was implemented as the inpatient EHR at Mount Sinai Hospital (MSH) in late 2011. Subsequently, Epic has been implemented in additional inpatient facilities across the MSHS, including Mount Sinai Queens (2013), Mount Sinai West (2018), Mount Sinai St. Lukes (2018), Mount Sinai Brooklyn (2019) and Mount Sinai Beth Israel (2020).


The MSDW provides researchers access to data on the over 12 million unique patients in the Mount Sinai Health System Epic EHR, of which nearly 5.5 million of these patients have had an encounter. In total there are over 115 million patient encounters recorded in Epic.


The Mount Sinai Data Warehouse (MSDW) ecosystem is Epic and OMOP-centric. The majority of the data collected by the MSDW comes from the Epic Clarity and Caboodle databases, as Epic is the primary electronic health record (EHR) across the Mount Sinai Health System (MSHS). The clinical data is extracted from the Epic Caboodle and Clarity databases, transformed to the OMOP Common Data Model (CDM) and is stored in the MSDW2 database, which is now located on the Minerva High Performance Computing cluster. This data is refreshed daily.

Data Sources

OMOP Table EHR Record Type
person Patient Demographics
death Patient Date of Death
provider Provider
provider_specialty_xtn* Provider Specialty
care_site Care Site/Place of Service
location Patient Address
Provider Address
Care Site Address
visit_occurrence Inpatient Hospitalization
Hospital Outpatient Visit
Inpatient Hospitalization from ED Visit
ED Visit
Outpatient Visit
Telehealth Visit
Mobile Unit Encounter
measurement Lab Component Result
Vital Signs
procedure_occurrence General Procedure
Surgical Procedure
condition_occurrence Encounter Diagnosis
Problem List
Hospital Problem
Billing Diagnosis
drug_exposure Medication Order
Medication Order with Dispense
Outpatient Medication Order with Dispense
Medication Order with Administration
Immunization Administration
Immunization from Medication Order
Immunization from Procedure Order
observation Patient Demographics
Past Medical History
Surgical History Procedure
Social History
Family History
note Clinical Note
Lab Component Result Note