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

Principal Data Architect Timothy Quinn, PhD, has developed informative presentations on OMOP Vocabulary Tables and 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 Data Model

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 May 12, 2023

OMOP Table Record Type Distinct Patients Record Count
person Patient Demographics 11,359,705 11,359,705
death Patient Date of Death 45,954 45,957
visit_occurrence Mobile Unit Encounter 68,743 111,327
visit_occurrence Inpatient Hospitalization from ED Visit 277,736 525,105
visit_occurrence Hospital Outpatient Visit 894,661 2,472,103
visit_occurrence Urgent Care Visit 190 296
visit_occurrence ED Visit 1,131,817 2,732,247
visit_occurrence Inpatient Hospitalization 609,075 919,758
visit_occurrence Outpatient Visit 4,061,760 73,545,946
visit_occurrence Telehealth Visit 660,939 2,706,066
visit_occurrence Chart Documentation Event 5,434,697 87,301,399
condition_occurrence Hospital Problem 847,633 3,136,818
condition_occurrence Encounter Diagnosis 3,856,726 103,437,716
condition_occurrence Billing Diagnosis 2,204,779 44,863,750
condition_occurrence Problem List 2,258,485 11,899,865
measurement Vital Signs 3,424,374 566,300,804
measurement Flowsheet Measurement 1,631,208 181,917,868
measurement Lab Component Result 3,848,811 954,973,027
drug_exposure Medication Order with Administration 1,402,010 113,132,577
drug_exposure Outpatient Medication Order with Dispense 28,819 312,286
drug_exposure Immunization Administration 1,191,626 7,040,845
drug_exposure Immunization from Procedure Order 730,975 3,242,607
drug_exposure Outpatient Medication Order 2,438,809 40,933,585
drug_exposure Medication Order with Dispense 914,408 15,155,885
drug_exposure Medication Order 943,232 11,340,759
drug_exposure Immunization from Medication Order 193,928 248,744
procedure_occurrence Procedure Inferred from Flowsheet 19,530 227,434
procedure_occurrence General Procedure 4,914,936 245,337,669
procedure_occurrence Surgical Procedure 279,583 692,085
observation Past Medical History 2,074,240 7,818,061
observation Patient Cohort Membership 748,031 1,209,821
observation Patient Demographics 11,659,195 102,946,477
observation Family History 1,579,969 59,561,698
observation Surgical History Procedure 1,483,828 3,287,367
observation Allergy 3,440,910 4,121,860
observation Social History 3,343,596 135,683,865
observation Flowsheet Observation 2,269,628 94,567,642
note Clinical Note 4,550,473 174,579,797
note Lab Component Result Note 2,371,636 16,017,684
provider Provider 1,299,450
provider_attribute_xtn Physician specialty 603,551
provider_attribute_xtn Personnel specialty 165,709
location Provider Address 1,299,542
location Patient Address 11,359,705
location Care Site Address 14,263
care_site Service Area 50
care_site Department 5,361
care_site Room 7,086
care_site Care Area 781
care_site Location 2,016
care_site Place of Service 6,784
care_site Bed 77,519
concept EPIC SURGICAL PROCEDURE 33,056
concept EPIC DIAGNOSIS 1,577,077
concept EPIC VISIT TYPE 9,061
concept EPIC ALLERGEN 39,464
concept EPIC PROCEDURE 175,233
concept EPIC IMMUNIZATION 430
concept EPIC MEDICATION 136,625
concept EPIC FLOWSHEET MEASURE 78,590
concept EPIC LAB COMPONENT 36,044
concept EPIC FLOWSHEET TEMPLATE 3,260