MSDW Data Contents

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 MSDW provides researchers access to data on patients in the Mount Sinai Health System Epic EHR:

  • Over 11 million patient records
  • Over 87 million patient encounters

 

 

Understanding Electronic Health Record (EHR) Data

On June 16, 2022, Principal Data Architect Timothy Quinn, PhD, delivered an informative presentation on Electronic Health Record (EHR) Data in MSDW:

Mount Sinai’s Epic electronic health record (EHR) system constitutes the primary data source for the Mount Sinai Data Warehouse. Data are also loaded from other ancillary systems.

 

 

MSDW Ecosystem

MSDW ecosystem uses the OHDSI collaborative’s OMOP Common Data Model to facilitate optimal data sharing and interoperability both internally (at Mount Sinai) and externally with research partners. The clinical data are extracted from Mount Sinai’s Epic Caboodle database and other ancillary systems, transformed to the OMOP Common Data Model (CDM) format, and loaded to the MSDW database. These data are updated daily.

The MSDW is situated on the Minerva High Performance Computing (HPC) cluster alongside other research data sets.

MSDW Record Counts

Last updated July 5, 2022

OMOP Table Record Type Distinct Patients Record Count
person Patient Demographics 10,938,207 10,938,207
death Patient Date of Death 41,387 41,387
visit_occurrence Mobile Unit Encounter 55,709 87,443
visit_occurrence Inpatient Hospitalization from ED Visit 248,641 463,146
visit_occurrence Hospital Outpatient Visit 831,580 2,266,261
visit_occurrence ED Visit 1,026,635 2,432,065
visit_occurrence Inpatient Hospitalization 573,212 866,615
visit_occurrence Outpatient Visit 3,805,810 67,981,749
visit_occurrence Telehealth Visit 1,799,958 16,807,322
condition_occurrence Problem List 2,125,883 10,964,963
condition_occurrence Billing Diagnosis 1,909,239 34,963,624
condition_occurrence Hospital Problem 784,663 2,823,563
condition_occurrence Encounter Diagnosis 3,571,459 91,663,171
measurement Vital Signs 3,153,122 534,829,176
measurement Lab Component Result 3,658,730 876,170,299
drug_exposure Medication Order with Administration 1,190,910 90,769,012
drug_exposure Outpatient Medication Order with Dispense 22,789 271,304
drug_exposure Immunization Administration 969,756 5,743,071
drug_exposure Immunization from Procedure Order 681,583 2,944,246
drug_exposure Outpatient Medication Order 2,238,687 36,556,947
drug_exposure Medication Order with Dispense 827,140 14,015,400
drug_exposure Immunization from Medication Order 174,389 223,175
drug_exposure Medication Order 859,017 10,426,014
procedure_occurrence Procedure Inferred from Flowsheet 16,631 5,847,800
procedure_occurrence General Procedure 4,610,700 210,757,371
procedure_occurrence Surgical Procedure 228,723 542,016
observation Past Medical History 1,942,699 7,334,424
observation Surgical History Procedure 1,381,428 3,057,772
observation Allergy 3,185,081 3,806,027
observation Patient Cohort Membership 571,526 607,674
observation Family History 1,472,741 51,555,381
observation Patient Demographics 10,909,364 65,567,907
observation Social History 3,085,083 119,013,099
note Lab Component Result Note 2,289,835 45,205,378
note Clinical Note 2,656,944 47,010,046
provider Provider   1,251,780
provider_attribute_xtn Physician specialty   602,851
provider_attribute_xtn Personnel specialty   162,461
location Care Site Address   188,136
location Patient Address   24,985,269
location Provider Address   2,484,627
care_site Service Area   101
care_site Department   5,107
care_site Care Area   761
care_site Location   1,902
care_site Place of Service   6,765
care_site Bed   75,261
care_site Room   6,967
concept EPIC VISIT TYPE   9,071
concept EPIC ALLERGEN   38,955
concept EPIC PROCEDURE   154,459
concept EPIC IMMUNIZATION   402
concept EPIC FLOWSHEET MEASURE   74,604
concept EPIC LAB COMPONENT   34,219
concept EPIC FLOWSHEET TEMPLATE   2,885
concept EPIC MEDICATION   134,281
concept EPIC SURGICAL PROCEDURE   31,684
concept EPIC DIAGNOSIS   1,566,543