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 February 5, 2026

OMOP Table	Record Type	Distinct Patients	Record Count
person	Patient Demographics	12,789,482	12,789,482
visit_occurrence	Mobile Unit Encounter	116,229	200,452
visit_occurrence	Inpatient Hospitalization from ED Visit	366,294	719,999
visit_occurrence	Hospital Outpatient Visit	1,251,491	3,594,079
visit_occurrence	Urgent Care Visit	7,218	7,914
visit_occurrence	ED Visit	1,442,031	3,653,554
visit_occurrence	Inpatient Hospitalization	714,905	1,069,900
visit_occurrence	Outpatient Visit	5,018,804	105,730,805
visit_occurrence	Telehealth Visit	883,233	4,352,464
visit_occurrence	Chart Documentation Event	6,676,333	135,468,281
condition_occurrence	Hospital Problem	1,059,420	4,755,521
condition_occurrence	Encounter Diagnosis	4,798,384	152,875,469
condition_occurrence	Problem List	2,702,206	15,915,252
condition_occurrence	Billing Diagnosis	3,268,418	102,690,087
measurement	Vital Signs	4,259,708	784,607,163
measurement	Flowsheet Measurement	2,104,887	296,226,710
measurement	Lab Component Result	4,668,993	1,256,888,462
drug_exposure	Medication Order with Administration	1,870,155	155,214,452
drug_exposure	Outpatient Medication Order with Dispense	29,955	301,853
drug_exposure	Immunization from Procedure Order	893,381	4,179,526
drug_exposure	Outpatient Medication Order	3,057,799	56,087,822
drug_exposure	Medication Order with Dispense	1,126,251	18,084,665
drug_exposure	Medication Order	1,210,936	15,529,463
drug_exposure	Immunization from Medication Order	251,047	328,415
drug_exposure	Immunization Administration	1,222,332	9,423,124
procedure_occurrence	Procedure Inferred from Flowsheet	25,950	310,035
procedure_occurrence	General Procedure	5,959,894	399,542,432
procedure_occurrence	Surgical Procedure	437,468	1,736,221
observation	Past Medical History	2,488,286	9,605,340
observation	Patient Demographics	12,789,481	71,784,284
observation	Family History	1,933,028	89,679,899
observation	Surgical History Procedure	1,799,486	4,087,020
observation	Social History	4,101,333	191,854,083
observation	Flowsheet Observation	2,875,264	152,041,168
observation	Allergy	4,278,446	5,217,744
note	Lab Component Result Note	2,821,984	19,391,170
note	Clinical Note	5,561,705	237,231,006
provider	Provider		1,380,482
provider_attribute_xtn	Physician specialty		608,931
provider_attribute_xtn	Personnel specialty		181,936
location	Patient Address		12,789,481
location	Provider Address		1,380,482
location	Care Site Address		16,340
care_site	Service Area		55
care_site	Department		6,643
care_site	Care Area		881
care_site	Location		2,242
care_site	Place of Service		7,343
care_site	Bed		84,678
care_site	Room		8,044
concept	EPIC SURGICAL PROCEDURE		43,170
concept	EPIC DIAGNOSIS		1,613,375
concept	EPIC ALLERGEN		41,187
concept	EPIC VISIT TYPE		12,259
concept	EPIC PROCEDURE		202,833
concept	EPIC MEDICATION		146,419
concept	EPIC FLOWSHEET MEASURE		101,512
concept	EPIC FLOWSHEET TEMPLATE		4,163
concept	EPIC LAB COMPONENT		43,596
concept	EPIC IMMUNIZATION		570
vocabulary	MSDW Vocabulary		7
vocabulary	Epic Vocabulary		118
vocabulary	Vocabulary		103
vocabulary	PowerPath Vocabulary		8