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

OMOP Table Record Type Distinct Patients Record Count
person Patient Demographics 13,053,669 13,053,669
visit_occurrence Chart Documentation Event 6,958,425 151,019,697
visit_occurrence ED Visit 1,537,566 3,907,771
visit_occurrence Hospital Outpatient Visit 1,316,439 3,876,902
visit_occurrence Inpatient Hospitalization 746,897 1,117,393
visit_occurrence Inpatient Hospitalization from ED Visit 399,566 790,836
visit_occurrence Mobile Unit Encounter 129,026 224,757
visit_occurrence Outpatient Visit 5,252,168 115,923,566
visit_occurrence Telehealth Visit 948,879 4,866,995
visit_occurrence Urgent Care Visit 7,221 7,917
condition_occurrence Billing Diagnosis 3,551,384 124,379,086
condition_occurrence Encounter Diagnosis 5,022,096 168,219,386
condition_occurrence Hospital Problem 1,117,660 5,009,501
condition_occurrence Problem List 2,808,201 16,632,159
measurement Flowsheet Measurement 2,251,526 326,829,291
measurement Lab Component Result 4,850,414 1,340,955,583
measurement Vital Signs 4,456,443 843,188,241
drug_exposure Immunization Administration 1,233,617 10,194,344
drug_exposure Immunization from Medication Order 267,354 351,017
drug_exposure Immunization from Procedure Order 924,916 4,350,895
drug_exposure Medication Order 1,237,871 13,977,654
drug_exposure Medication Order with Administration 2,057,879 245,298,061
drug_exposure Medication Order with Dispense 1,139,502 16,521,560
drug_exposure Outpatient Medication Order 3,220,825 60,651,713
drug_exposure Outpatient Medication Order with Dispense 54,440 404,341
procedure_occurrence General Procedure 6,207,988 408,845,667
procedure_occurrence Procedure Inferred from Flowsheet 27,383 350,365
procedure_occurrence Surgical Procedure 480,639 1,326,291
observation Allergy 4,496,821 5,511,890
observation Family History 2,012,368 98,842,176
observation Flowsheet Observation 3,039,434 167,914,721
observation Past Medical History 2,592,307 10,099,316
observation Patient Demographics 13,053,668 74,110,176
observation Social History 4,292,018 206,337,359
observation Surgical History Procedure 1,875,980 4,291,122
note Clinical Note 5,779,588 256,361,563
note Lab Component Result Note 2,940,133 20,438,199
provider Provider   1,389,449
provider_attribute_xtn Personnel specialty   182,241
provider_attribute_xtn Physician specialty   616,261
location Care Site Address   16,728
location Patient Address   13,039,506
location Provider Address   1,389,147
care_site Bed   85,364
care_site Care Area   892
care_site Department   6,761
care_site Location   2,288
care_site Place of Service   7,567
care_site Room   10,991
care_site Service Area   55
concept EPIC ALLERGEN   41,565
concept EPIC DIAGNOSIS   1,628,763
concept EPIC FLOWSHEET MEASURE   122,598
concept EPIC FLOWSHEET TEMPLATE   4,382
concept EPIC IMMUNIZATION   574
concept EPIC LAB COMPONENT   46,520
concept EPIC MEDICATION   148,594
concept EPIC PROCEDURE   205,086
concept EPIC SURGICAL PROCEDURE   46,154
concept EPIC VISIT TYPE   12,495
vocabulary Epic Vocabulary   118
vocabulary MSDW Vocabulary   13
vocabulary PowerPath Vocabulary   8
vocabulary Vocabulary   105