Scientific Computing and Data / Mount Sinai Data Warehouse / Data Contents

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.

 

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 (see table below).

 

The MSDW provides researchers access to data on patients in the Mount Sinai Health System Epic EHR:

  • Over 12 million patient records
  • Over 105 million patient encounters

 

Table last updated July 5, 2026

OMOP Table Record Type Distinct Patients Record Count
person Patient Demographics 12,938,101 12,938,101
visit_occurrence Mobile Unit Encounter 123,232 213,948
visit_occurrence Inpatient Hospitalization from ED Visit 384,823 758,778
visit_occurrence Hospital Outpatient Visit 1,286,656 3,746,919
visit_occurrence Urgent Care Visit 7,219 7,915
visit_occurrence ED Visit 1,492,700 3,787,858
visit_occurrence Inpatient Hospitalization 732,717 1,096,149
visit_occurrence Outpatient Visit 5,141,779 111,104,169
visit_occurrence Telehealth Visit 918,383 4,633,259
visit_occurrence Chart Documentation Event 6,816,059 143,818,597
condition_occurrence Hospital Problem 1,092,385 4,880,574
condition_occurrence Encounter Diagnosis 4,916,975 161,152,133
condition_occurrence Problem List 2,760,730 16,212,789
condition_occurrence Billing Diagnosis 3,421,726 114,537,562
measurement Vital Signs 4,375,097 820,017,555
measurement Flowsheet Measurement 2,190,706 314,629,950
measurement Lab Component Result 4,765,695 1,302,751,974
drug_exposure Medication Order with Administration 1,986,936 237,035,187
drug_exposure Outpatient Medication Order with Dispense 32,817 332,359
drug_exposure Immunization Administration 1,227,015 9,830,671
drug_exposure Immunization from Procedure Order 907,443 4,250,288
drug_exposure Outpatient Medication Order 3,148,183 58,729,834
drug_exposure Medication Order with Dispense 1,104,551 15,948,146
drug_exposure Medication Order 1,201,404 13,416,523
drug_exposure Immunization from Medication Order 259,438 339,868
procedure_occurrence Procedure Inferred from Flowsheet 26,807 330,213
procedure_occurrence General Procedure 5,741,045 369,281,535
procedure_occurrence Surgical Procedure 461,565 1,725,736
observation Past Medical History 2,545,727 9,873,096
observation Patient Demographics 12,938,100 73,064,736
observation Family History 1,977,921 94,684,085
observation Surgical History Procedure 1,841,314 4,199,202
observation Allergy 4,394,835 5,374,563
observation Social History 4,204,204 199,792,335
observation Flowsheet Observation 2,972,242 161,540,568
note Lab Component Result Note 2,882,142 19,910,538
note Clinical Note 5,675,906 247,362,196
provider Provider   1,385,112
provider_attribute_xtn Physician specialty   610,987
provider_attribute_xtn Personnel specialty   180,971
location Provider Address   1,385,112
location Patient Address   12,938,100
location Care Site Address   16,515
care_site Service Area   55
care_site Department   6,710
care_site Care Area   886
care_site Location   2,264
care_site Place of Service   7,429
care_site Bed   85,027
care_site Room   9,416
concept EPIC SURGICAL PROCEDURE   45,432
concept EPIC DIAGNOSIS   1,618,390
concept EPIC ALLERGEN   41,359
concept EPIC VISIT TYPE   12,362
concept EPIC PROCEDURE   204,250
concept EPIC IMMUNIZATION   574
concept EPIC FLOWSHEET MEASURE   104,429
concept EPIC MEDICATION   147,502
concept EPIC LAB COMPONENT   45,033
concept EPIC FLOWSHEET TEMPLATE   4,282
vocabulary MSDW Vocabulary   7
vocabulary Epic Vocabulary   118
vocabulary Vocabulary   105
vocabulary PowerPath Vocabulary   8