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

OMOP Table Record Type Distinct Patients Record Count
person Patient Demographics 12,878,411 12,878,411
visit_occurrence Mobile Unit Encounter 121,825 211,292
visit_occurrence Inpatient Hospitalization from ED Visit 381,188 751,050
visit_occurrence Hospital Outpatient Visit 1,279,514 3,716,265
visit_occurrence Urgent Care Visit 7,219 7,915
visit_occurrence ED Visit 1,481,935 3,759,955
visit_occurrence Inpatient Hospitalization 729,262 1,091,046
visit_occurrence Outpatient Visit 5,116,757 110,059,870
visit_occurrence Telehealth Visit 911,524 4,578,115
visit_occurrence Chart Documentation Event 6,789,474 142,156,282
condition_occurrence Hospital Problem 1,086,109 4,848,029
condition_occurrence Encounter Diagnosis 4,892,029 159,433,196
condition_occurrence Problem List 2,749,207 16,111,833
condition_occurrence Billing Diagnosis 3,389,523 112,060,749
measurement Vital Signs 4,351,736 812,977,720
measurement Flowsheet Measurement 2,171,962 310,960,755
measurement Lab Component Result 4,745,783 1,293,485,344
drug_exposure Medication Order with Administration 1,945,043 179,766,187
drug_exposure Outpatient Medication Order with Dispense 32,697 331,787
drug_exposure Immunization Administration 1,226,092 9,750,714
drug_exposure Immunization from Procedure Order 904,794 4,237,399
drug_exposure Outpatient Medication Order 3,130,931 58,256,807
drug_exposure Medication Order with Dispense 1,170,950 18,933,292
drug_exposure Medication Order 1,235,928 15,470,082
drug_exposure Immunization from Medication Order 257,576 337,511
procedure_occurrence Procedure Inferred from Flowsheet 26,655 323,988
procedure_occurrence General Procedure 6,085,360 424,899,218
procedure_occurrence Surgical Procedure 456,724 1,795,786
observation Past Medical History 2,534,536 9,821,877
observation Patient Demographics 12,878,410 72,756,893
observation Family History 1,969,448 93,697,070
observation Surgical History Procedure 1,833,103 4,177,477
observation Allergy 4,370,852 5,342,542
observation Flowsheet Observation 2,952,499 159,665,711
observation Social History 4,183,741 198,232,248
note Lab Component Result Note 2,870,250 19,817,540
note Clinical Note 5,652,152 245,352,821
provider Provider   1,384,107
provider_attribute_xtn Physician specialty   610,677
provider_attribute_xtn Personnel specialty   179,878
location Provider Address   1,384,107
location Patient Address   12,878,410
location Care Site Address   16,497
care_site Department   6,696
care_site Place of Service   7,425
care_site Bed   84,944
care_site Room   9,015
care_site Service Area   55
care_site Care Area   886
care_site Location   2,264
concept EPIC SURGICAL PROCEDURE   45,279
concept EPIC DIAGNOSIS   1,618,390
concept EPIC ALLERGEN   41,320
concept EPIC VISIT TYPE   12,353
concept EPIC PROCEDURE   204,015
concept EPIC IMMUNIZATION   574
concept EPIC FLOWSHEET MEASURE   103,857
concept EPIC MEDICATION   147,320
concept EPIC FLOWSHEET TEMPLATE   4,255
concept EPIC LAB COMPONENT   44,868
vocabulary MSDW Vocabulary   7
vocabulary Epic Vocabulary   118
vocabulary Vocabulary   105
vocabulary PowerPath Vocabulary   8