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 October 5, 2026

OMOP Table Record Type Distinct Patients Record Count
person Patient Demographics 13,025,854 13,025,854
visit_occurrence Chart Documentation Event 6,930,381 149,150,937
visit_occurrence ED Visit 1,525,731 3,876,250
visit_occurrence Hospital Outpatient Visit 1,308,735 3,842,043
visit_occurrence Inpatient Hospitalization 743,269 1,111,988
visit_occurrence Inpatient Hospitalization from ED Visit 395,752 782,505
visit_occurrence Mobile Unit Encounter 127,458 221,851
visit_occurrence Outpatient Visit 5,222,937 114,463,166
visit_occurrence Telehealth Visit 940,976 4,805,478
visit_occurrence Urgent Care Visit 7,220 7,916
condition_occurrence Billing Diagnosis 3,517,218 121,690,294
condition_occurrence Encounter Diagnosis 4,993,714 166,278,627
condition_occurrence Hospital Problem 1,111,092 4,975,286
condition_occurrence Problem List 2,795,676 16,518,531
measurement Flowsheet Measurement 2,231,983 323,055,522
measurement Lab Component Result 4,827,460 1,330,850,616
measurement Vital Signs 4,429,232 836,047,797
drug_exposure Immunization Administration 1,231,437 10,088,137
drug_exposure Immunization from Medication Order 265,151 347,535
drug_exposure Immunization from Procedure Order 917,594 4,304,163
drug_exposure Medication Order 1,228,285 13,826,665
drug_exposure Medication Order with Administration 2,039,529 243,117,085
drug_exposure Medication Order with Dispense 1,130,421 16,338,561
drug_exposure Outpatient Medication Order 3,202,217 60,166,062
drug_exposure Outpatient Medication Order with Dispense 38,057 344,847
procedure_occurrence General Procedure 6,177,707 403,037,638
procedure_occurrence Procedure Inferred from Flowsheet 27,179 344,104
procedure_occurrence Surgical Procedure 474,862 1,310,341
observation Allergy 4,470,203 5,476,219
observation Family History 2,003,784 97,749,613
observation Flowsheet Observation 3,017,724 165,943,485
observation Past Medical History 2,580,529 10,037,630
observation Patient Demographics 13,025,853 73,839,215
observation Social History 4,269,572 204,620,308
observation Surgical History Procedure 1,866,910 4,266,420
note Clinical Note 5,750,197 253,595,407
note Lab Component Result Note 2,922,288 20,256,014
provider Provider   1,388,649
provider_attribute_xtn Personnel specialty   182,100
provider_attribute_xtn Physician specialty   615,561
location Care Site Address   16,703
location Patient Address   13,003,337
location Provider Address   1,388,333
care_site Bed   85,129
care_site Care Area   888
care_site Department   6,736
care_site Location   2,285
care_site Place of Service   7,555
care_site Room   10,241
care_site Service Area   55
concept EPIC ALLERGEN   41,524
concept EPIC DIAGNOSIS   1,628,763
concept EPIC FLOWSHEET MEASURE   113,537
concept EPIC FLOWSHEET TEMPLATE   4,343
concept EPIC IMMUNIZATION   574
concept EPIC LAB COMPONENT   46,350
concept EPIC MEDICATION   148,356
concept EPIC PROCEDURE   204,958
concept EPIC SURGICAL PROCEDURE   45,910
concept EPIC VISIT TYPE   12,406
vocabulary Epic Vocabulary   118
vocabulary MSDW Vocabulary   13
vocabulary PowerPath Vocabulary   8
vocabulary Vocabulary   105