Scientific Computing and Data / Mount Sinai Data Warehouse / Data Contents

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 April 5, 2024

OMOP Table                                                  Record Type                                                                    Distinct Patients                       Record Count
person Patient Demographics 11,830,543 11,830,543
death Patient Date of Death 50,660 50,660
visit_occurrence Mobile Unit Encounter 84,359 140,215
visit_occurrence Inpatient Hospitalization from ED Visit 307,039 589,505
visit_occurrence Hospital Outpatient Visit 964,643 2,731,489
visit_occurrence Urgent Care Visit 7,111 7,637
visit_occurrence ED Visit 1,245,482 3,065,033
visit_occurrence Inpatient Hospitalization 639,166 956,755
visit_occurrence Outpatient Visit 4,413,541 83,232,628
visit_occurrence Telehealth Visit 696,368 3,061,875
visit_occurrence Chart Documentation Event 5,848,249 99,293,771
condition_occurrence Hospital Problem 909,305 3,425,413
condition_occurrence Encounter Diagnosis 4,178,472 116,764,326
condition_occurrence Billing Diagnosis 2,546,986 57,410,863
condition_occurrence Problem List 2,416,221 12,974,884
measurement Vital Signs 3,715,829 636,601,950
measurement Flowsheet Measurement 1,792,455 219,383,113
measurement Lab Component Result 4,095,070 1,048,799,506
drug_exposure Outpatient Medication Order with Dispense 29,563 316,037
drug_exposure Medication Order with Administration 1,548,956 127,256,449
drug_exposure Immunization Administration 1,400,531 8,512,254
drug_exposure Immunization from Procedure Order 785,862 3,556,699
drug_exposure Outpatient Medication Order 2,663,274 45,901,244
drug_exposure Medication Order with Dispense 984,788 16,211,644
drug_exposure Medication Order 1,040,298 12,956,705
drug_exposure Immunization from Medication Order 213,994 276,240
procedure_occurrence Procedure Inferred from Flowsheet 22,704 257,536
procedure_occurrence General Procedure 5,252,782 305,647,242
procedure_occurrence Surgical Procedure 333,624 862,499
observation Allergy 3,734,774 4,504,929
observation Social History 3,620,368 154,075,432
observation Flowsheet Observation 2,475,057 112,873,743
observation Past Medical History 2,225,717 8,442,920
observation Patient Cohort Membership 1,938,939 2,860,042
observation Patient Demographics 11,830,563 57,350,342
observation Family History 1,709,447 69,187,508
observation Surgical History Procedure 1,600,273 3,579,861
note Lab Component Result Note 2,508,252 17,092,578
note Clinical Note 4,877,850 193,754,283
provider Provider   1,349,327
provider_attribute_xtn Physician specialty   604,442
provider_attribute_xtn Personnel specialty   172,802
location Patient Address   11,830,543
location Care Site Address   14,669
location Provider Address   1,349,393
care_site Care Area   802
care_site Location   2,074
care_site Place of Service   6,814
care_site Service Area   50
care_site Department   5,679
care_site Bed   79,268
care_site Room   7,294
concept EPIC PROCEDURE   184,884
concept EPIC SURGICAL PROCEDURE   34,793
concept EPIC DIAGNOSIS   1,584,457
concept EPIC ALLERGEN   39,997
concept EPIC VISIT TYPE   10,065
concept EPIC IMMUNIZATION   494
concept EPIC FLOWSHEET MEASURE   83,902
concept EPIC MEDICATION   139,897
concept EPIC FLOWSHEET TEMPLATE   3,490
concept EPIC LAB COMPONENT   40,117