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
On June 16, 2022, Principal Data Architect Timothy Quinn, PhD, delivered an informative presentation on 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 Ecosystem
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 July 5, 2022
| OMOP Table | Record Type | Distinct Patients | Record Count |
| person | Patient Demographics | 10,938,207 | 10,938,207 |
| death | Patient Date of Death | 41,387 | 41,387 |
| visit_occurrence | Mobile Unit Encounter | 55,709 | 87,443 |
| visit_occurrence | Inpatient Hospitalization from ED Visit | 248,641 | 463,146 |
| visit_occurrence | Hospital Outpatient Visit | 831,580 | 2,266,261 |
| visit_occurrence | ED Visit | 1,026,635 | 2,432,065 |
| visit_occurrence | Inpatient Hospitalization | 573,212 | 866,615 |
| visit_occurrence | Outpatient Visit | 3,805,810 | 67,981,749 |
| visit_occurrence | Telehealth Visit | 1,799,958 | 16,807,322 |
| condition_occurrence | Problem List | 2,125,883 | 10,964,963 |
| condition_occurrence | Billing Diagnosis | 1,909,239 | 34,963,624 |
| condition_occurrence | Hospital Problem | 784,663 | 2,823,563 |
| condition_occurrence | Encounter Diagnosis | 3,571,459 | 91,663,171 |
| measurement | Vital Signs | 3,153,122 | 534,829,176 |
| measurement | Lab Component Result | 3,658,730 | 876,170,299 |
| drug_exposure | Medication Order with Administration | 1,190,910 | 90,769,012 |
| drug_exposure | Outpatient Medication Order with Dispense | 22,789 | 271,304 |
| drug_exposure | Immunization Administration | 969,756 | 5,743,071 |
| drug_exposure | Immunization from Procedure Order | 681,583 | 2,944,246 |
| drug_exposure | Outpatient Medication Order | 2,238,687 | 36,556,947 |
| drug_exposure | Medication Order with Dispense | 827,140 | 14,015,400 |
| drug_exposure | Immunization from Medication Order | 174,389 | 223,175 |
| drug_exposure | Medication Order | 859,017 | 10,426,014 |
| procedure_occurrence | Procedure Inferred from Flowsheet | 16,631 | 5,847,800 |
| procedure_occurrence | General Procedure | 4,610,700 | 210,757,371 |
| procedure_occurrence | Surgical Procedure | 228,723 | 542,016 |
| observation | Past Medical History | 1,942,699 | 7,334,424 |
| observation | Surgical History Procedure | 1,381,428 | 3,057,772 |
| observation | Allergy | 3,185,081 | 3,806,027 |
| observation | Patient Cohort Membership | 571,526 | 607,674 |
| observation | Family History | 1,472,741 | 51,555,381 |
| observation | Patient Demographics | 10,909,364 | 65,567,907 |
| observation | Social History | 3,085,083 | 119,013,099 |
| note | Lab Component Result Note | 2,289,835 | 45,205,378 |
| note | Clinical Note | 2,656,944 | 47,010,046 |
| provider | Provider | 1,251,780 | |
| provider_attribute_xtn | Physician specialty | 602,851 | |
| provider_attribute_xtn | Personnel specialty | 162,461 | |
| location | Care Site Address | 188,136 | |
| location | Patient Address | 24,985,269 | |
| location | Provider Address | 2,484,627 | |
| care_site | Service Area | 101 | |
| care_site | Department | 5,107 | |
| care_site | Care Area | 761 | |
| care_site | Location | 1,902 | |
| care_site | Place of Service | 6,765 | |
| care_site | Bed | 75,261 | |
| care_site | Room | 6,967 | |
| concept | EPIC VISIT TYPE | 9,071 | |
| concept | EPIC ALLERGEN | 38,955 | |
| concept | EPIC PROCEDURE | 154,459 | |
| concept | EPIC IMMUNIZATION | 402 | |
| concept | EPIC FLOWSHEET MEASURE | 74,604 | |
| concept | EPIC LAB COMPONENT | 34,219 | |
| concept | EPIC FLOWSHEET TEMPLATE | 2,885 | |
| concept | EPIC MEDICATION | 134,281 | |
| concept | EPIC SURGICAL PROCEDURE | 31,684 | |
| concept | EPIC DIAGNOSIS | 1,566,543 |