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

OMOP Table Record Type Distinct Patients Record Count
person Patient Demographics 12,999,446 12,999,446
visit_occurrence Chart Documentation Event 6,900,581 147,152,853
visit_occurrence ED Visit 1,513,632 3,843,284
visit_occurrence Hospital Outpatient Visit 1,300,791 3,807,517
visit_occurrence Inpatient Hospitalization 739,453 1,106,143
visit_occurrence Inpatient Hospitalization from ED Visit 391,684 773,610
visit_occurrence Mobile Unit Encounter 125,977 218,948
visit_occurrence Outpatient Visit 5,192,823 113,082,731
visit_occurrence Telehealth Visit 932,479 4,737,974
visit_occurrence Urgent Care Visit 7,219 7,915
condition_occurrence Billing Diagnosis 3,485,583 119,272,725
condition_occurrence Encounter Diagnosis 4,968,177 164,562,454
condition_occurrence Hospital Problem 1,104,901 4,943,167
condition_occurrence Problem List 2,784,255 16,416,275
measurement Flowsheet Measurement 2,228,235 322,278,933
measurement Lab Component Result 4,806,632 1,321,603,196
measurement Vital Signs 4,424,723 834,577,133
drug_exposure Immunization Administration 1,229,224 9,991,692
drug_exposure Immunization from Medication Order 263,050 344,492
drug_exposure Immunization from Procedure Order 912,789 4,276,076
drug_exposure Medication Order 1,218,994 13,677,972
drug_exposure Medication Order with Administration 2,021,502 240,936,324
drug_exposure Medication Order with Dispense 1,121,222 16,175,011
drug_exposure Outpatient Medication Order 3,182,373 59,573,039
drug_exposure Outpatient Medication Order with Dispense 33,091 333,565
procedure_occurrence General Procedure 6,151,213 398,457,058
procedure_occurrence Procedure Inferred from Flowsheet 27,136 342,645
procedure_occurrence Surgical Procedure 470,272 1,297,673
observation Allergy 4,425,380 5,412,320
observation Family History 1,994,084 96,561,689
observation Flowsheet Observation 3,013,806 165,557,589
observation Past Medical History 2,569,904 9,984,982
observation Patient Demographics 12,999,445 73,581,629
observation Social History 4,248,803 203,097,878
observation Surgical History Procedure 1,859,032 4,245,550
note Clinical Note 5,724,967 251,341,022
note Lab Component Result Note 2,906,773 20,103,729
provider Provider   1,386,945
provider_attribute_xtn Personnel specialty   180,984
provider_attribute_xtn Physician specialty   614,159
location Care Site Address   16,672
location Patient Address   12,897,379
location Provider Address   1,386,602
care_site Bed   85,104
care_site Care Area   888
care_site Department   6,731
care_site Location   2,269
care_site Place of Service   7,544
care_site Room   9,808
care_site Service Area   55
concept EPIC ALLERGEN   41,444
concept EPIC DIAGNOSIS   1,618,390
concept EPIC FLOWSHEET MEASURE   109,034
concept EPIC FLOWSHEET TEMPLATE   4,308
concept EPIC IMMUNIZATION   574
concept EPIC LAB COMPONENT   45,910
concept EPIC MEDICATION   148,081
concept EPIC PROCEDURE   204,540
concept EPIC SURGICAL PROCEDURE   45,761
concept EPIC VISIT TYPE   12,393
vocabulary Epic Vocabulary   118
vocabulary MSDW Vocabulary   13
vocabulary PowerPath Vocabulary   8
vocabulary Vocabulary   105