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, 2025
| OMOP Table | Record Type | Distinct Patients | Record Count |
| person | Patient Demographics | 12,640,282 | 12,640,282 |
| death | Patient Date of Death | 58,634 | 58,634 |
| visit_occurrence | Mobile Unit Encounter | 110,091 | 188,788 |
| visit_occurrence | Inpatient Hospitalization from ED Visit | 352,525 | 692,401 |
| visit_occurrence | Hospital Outpatient Visit | 1,093,633 | 3,230,625 |
| visit_occurrence | Urgent Care Visit | 7,215 | 7,911 |
| visit_occurrence | ED Visit | 1,399,808 | 3,542,474 |
| visit_occurrence | Inpatient Hospitalization | 701,317 | 1,050,130 |
| visit_occurrence | Outpatient Visit | 4,913,452 | 101,369,445 |
| visit_occurrence | Telehealth Visit | 852,645 | 4,110,436 |
| visit_occurrence | Chart Documentation Event | 6,448,145 | 128,125,810 |
| condition_occurrence | Encounter Diagnosis | 4,552,704 | 137,639,882 |
| condition_occurrence | Problem List | 2,560,182 | 14,653,919 |
| condition_occurrence | Billing Diagnosis | 3,058,393 | 88,988,451 |
| condition_occurrence | Hospital Problem | 1,002,637 | 4,367,780 |
| measurement | Vital Signs | 4,144,409 | 756,480,711 |
| measurement | Flowsheet Measurement | 2,037,296 | 281,674,483 |
| measurement | Lab Component Result | 4,495,393 | 1,200,366,603 |
| drug_exposure | Outpatient Medication Order with Dispense | 29,772 | 300,168 |
| drug_exposure | Medication Order with Administration | 1,795,906 | 149,607,185 |
| drug_exposure | Immunization Administration | 1,222,523 | 9,067,106 |
| drug_exposure | Immunization from Procedure Order | 872,044 | 4,051,125 |
| drug_exposure | Medication Order with Dispense | 1,086,747 | 17,539,012 |
| drug_exposure | Outpatient Medication Order | 2,980,097 | 54,030,699 |
| drug_exposure | Medication Order | 1,171,988 | 14,933,369 |
| drug_exposure | Immunization from Medication Order | 243,632 | 317,571 |
| procedure_occurrence | Procedure Inferred from Flowsheet | 25,373 | 300,675 |
| procedure_occurrence | General Procedure | 5,663,906 | 372,599,812 |
| procedure_occurrence | Surgical Procedure | 412,732 | 1,629,715 |
| observation | Past Medical History | 2,429,400 | 9,265,877 |
| observation | Flowsheet Observation | 2,480,295 | 128,888,897 |
| observation | Social History | 3,657,444 | 164,679,547 |
| observation | Patient Demographics | 12,640,281 | 67,648,837 |
| observation | Family History | 1,706,978 | 77,257,175 |
| observation | Surgical History Procedure | 1,752,337 | 3,948,490 |
| observation | Allergy | 3,771,954 | 4,602,175 |
| note | Lab Component Result Note | 2,708,904 | 18,777,693 |
| note | Clinical Note | 5,337,071 | 226,015,773 |
| provider | Provider | 1,373,119 | |
| provider_attribute_xtn | Physician specialty | 606,288 | |
| provider_attribute_xtn | Personnel specialty | 180,721 | |
| location | Patient Address | 12,640,281 | |
| location | Provider Address | 1,373,119 | |
| location | Care Site Address | 16,154 | |
| care_site | Service Area | 51 | |
| care_site | Care Area | 844 | |
| care_site | Bed | 84,195 | |
| care_site | Department | 6,548 | |
| care_site | Location | 2,228 | |
| care_site | Place of Service | 7,274 | |
| care_site | Room | 7,999 | |
| concept | EPIC ALLERGEN | 41,032 | |
| concept | EPIC VISIT TYPE | 12,176 | |
| concept | EPIC SURGICAL PROCEDURE | 42,274 | |
| concept | EPIC DIAGNOSIS | 1,613,375 | |
| concept | EPIC IMMUNIZATION | 547 | |
| concept | EPIC PROCEDURE | 200,276 | |
| concept | EPIC MEDICATION | 145,540 | |
| concept | EPIC FLOWSHEET MEASURE | 99,949 | |
| concept | EPIC FLOWSHEET TEMPLATE | 4,125 | |
| concept | EPIC LAB COMPONENT | 43,289 | |
| vocabulary | MSDW Vocabulary | 7 | |
| vocabulary | Epic Vocabulary | 118 | |
| vocabulary | Vocabulary | 104 | |
| vocabulary | PowerPath Vocabulary | 8 |