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 March 6, 2023

OMOP Table Record Type Distinct Patients Record Count
person Patient Demographics 11,177,093 11,177,093
death Patient Date of Death 45,049 45,052
visit_occurrence Mobile Unit Encounter 66,073 106,414
visit_occurrence Inpatient Hospitalization from ED Visit 271,983 512,697
visit_occurrence Telehealth Visit 645,565 2,598,146
visit_occurrence Outpatient Visit 3,994,766 71,755,352
visit_occurrence Hospital Outpatient Visit 880,326 2,426,812
visit_occurrence ED Visit 1,111,377 2,673,626
visit_occurrence Inpatient Hospitalization 601,644 908,834
visit_occurrence Chart Documentation Event 5,368,850 85,255,112
condition_occurrence Hospital Problem 834,367 3,070,112
condition_occurrence Encounter Diagnosis 3,796,577 100,840,907
condition_occurrence Problem List 2,229,862 11,697,388
condition_occurrence Billing Diagnosis 2,144,166 42,702,583
measurement Vital Signs 3,369,386 553,966,048
measurement Flowsheet Measurement 1,602,833 175,213,455
measurement Lab Component Result 3,803,066 938,162,898
drug_exposure Medication Order with Administration 1,374,014 110,487,414
drug_exposure Outpatient Medication Order with Dispense 28,637 311,196
drug_exposure Immunization Administration 1,152,689 6,829,310
drug_exposure Immunization from Procedure Order 723,316 3,197,257
drug_exposure Outpatient Medication Order 2,397,719 40,007,968
drug_exposure Medication Order with Dispense 899,838 15,022,336
drug_exposure Medication Order 926,275 11,250,980
drug_exposure Immunization from Medication Order 190,352 244,164
procedure_occurrence Procedure Inferred from Flowsheet 18,924 221,697
procedure_occurrence General Procedure 4,850,027 238,737,871
procedure_occurrence Surgical Procedure 268,370 658,410
observation Past Medical History 2,052,458 15,163,629
observation Patient Cohort Membership 748,914 951,906
observation Patient Demographics 11,514,057 94,772,659
observation Family History 1,556,013 57,840,752
observation Surgical History Procedure 1,381,745 3,061,608
observation Allergy 3,385,605 4,050,914
observation Flowsheet Observation 2,230,078 91,023,643
observation Social History 3,291,025 132,301,155
note Lab Component Result Note 2,286,466 45,205,368
note Clinical Note 4,490,490 170,973,460
provider Provider   1,296,897
provider_attribute_xtn Physician specialty   603,385
provider_attribute_xtn Personnel specialty   165,210
location Provider Address   1,296,998
location Patient Address   11,197,396
location Care Site Address   14,147
care_site Location   1,970
care_site Place of Service   6,783
care_site Room   7,037
care_site Department   5,292
care_site Care Area   768
care_site Service Area   50
care_site Bed   77,027
concept EPIC SURGICAL PROCEDURE   32,773
concept EPIC DIAGNOSIS   1,574,667
concept EPIC ALLERGEN   39,413
concept EPIC VISIT TYPE   9,071
concept EPIC PROCEDURE   155,651
concept EPIC IMMUNIZATION   423
concept EPIC FLOWSHEET TEMPLATE   3,217
concept EPIC FLOWSHEET MEASURE   77,281
concept EPIC MEDICATION   136,347
concept EPIC LAB COMPONENT   35,270