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.

 

The MSDW provides researchers access to data on patients in the Mount Sinai Health System Epic EHR:

  • Over 11 million patient records
  • Over 87 million patient encounters

 

 

Understanding Electronic Health Record (EHR) Data

Principal Data Architect Timothy Quinn, PhD, has developed informative presentations on OMOP Vocabulary Tables and Electronic Health Record (EHR) Data in MSDW:

Mount Sinai’s Epic electronic health record (EHR) system constitutes the primary data source for the Mount Sinai Data Warehouse. Data are also loaded from other ancillary systems.

 

 

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.

The MSDW is situated on the Minerva High Performance Computing (HPC) cluster alongside other research data sets.

MSDW Record Counts

Last updated November 7, 2022

 

OMOP Table Record Type Distinct Patients Record Count
person Patient Demographics 11,086,465 11,086,465
death Patient Date of Death 43,297 43,297
visit_occurrence ED Visit 1,071,158 2,557,491
visit_occurrence Hospital Outpatient Visit 857,350 2,348,832
visit_occurrence Inpatient Hospitalization 587,615 887,743
visit_occurrence Inpatient Hospitalization from ED Visit 260,733 488,722
visit_occurrence Mobile Unit Encounter 60,937 96,888
visit_occurrence No matching concept 1,827,563 17,148,617
visit_occurrence Outpatient Visit 3,910,651 70,142,953
visit_occurrence Telehealth Visit 525,044 1,494,772
condition_occurrence Billing Diagnosis 2,027,659 38,678,373
condition_occurrence Encounter Diagnosis 3,682,910 96,062,194
condition_occurrence Hospital Problem 808,998 2,943,383
condition_occurrence Problem List 2,176,791 11,320,889
measurement Flowsheet Measurement 1,294,457 134,711,920
measurement Lab Component Result 3,746,932 908,064,086
measurement Vital Signs 3,270,951 557,575,109
drug_exposure Immunization Administration 1,065,473 6,263,319
drug_exposure Immunization from Medication Order 183,333 234,902
drug_exposure Immunization from Procedure Order 703,428 3,074,673
drug_exposure Medication Order 890,369 10,651,439
drug_exposure Medication Order with Administration 1,322,117 105,479,981
drug_exposure Medication Order with Dispense 866,841 14,501,174
drug_exposure Outpatient Medication Order 2,323,591 38,336,783
drug_exposure Outpatient Medication Order with Dispense 28,292 309,162
procedure_occurrence General Procedure 4,735,605 224,303,499
procedure_occurrence Procedure Inferred from Flowsheet 17,873 211,258
procedure_occurrence Surgical Procedure 249,552 602,436
observation Allergy 3,261,806 3,914,357
observation Family History 1,516,267 54,386,271
observation Flowsheet Observation 2,159,152 84,924,539
observation Past Medical History 2,001,016 7,578,157
observation Patient Cohort Membership 749,135 951,906
observation Patient Demographics 11,407,045 77,567,781
observation Social History 3,190,355 124,812,004
observation Surgical History Procedure 1,383,358 3,061,608
note Clinical Note 4,384,281 161,294,724
note Lab Component Result Note 2,289,865 45,205,368
provider Provider   1,256,199
provider_attribute_xtn Personnel specialty   164,549
provider_attribute_xtn Physician specialty   603,190
location Care Site Address   15,376
location Patient Address   14,144,904
location Provider Address   1,258,673
care_site Bed   88,949
care_site Care Area   976
care_site Department   6,241
care_site Location   2,180
care_site Place of Service   6,777
care_site Room   11,812
care_site Service Area   50
concept EPIC ALLERGEN   39,232
concept EPIC DIAGNOSIS   1,574,667
concept EPIC FLOWSHEET MEASURE   76,054
concept EPIC FLOWSHEET TEMPLATE   3,177
concept EPIC IMMUNIZATION   414
concept EPIC LAB COMPONENT   34,762
concept EPIC MEDICATION   135,456
concept EPIC PROCEDURE   154,727
concept EPIC SURGICAL PROCEDURE   31,726
concept EPIC VISIT TYPE   9,071