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 March 5, 2025

OMOP Table	Record Type	Distinct Patients	Record Count
person	Patient Demographics	12,183,142	12,183,142
death	Patient Date of Death	55,626	55,626
visit_occurrence	Chart Documentation Event	6,239,525	115,434,061
visit_occurrence	Mobile Unit Encounter	99,818	169,340
visit_occurrence	Inpatient Hospitalization from ED Visit	335,127	652,658
visit_occurrence	Hospital Outpatient Visit	1,035,604	3,017,867
visit_occurrence	Urgent Care Visit	7,142	7,826
visit_occurrence	ED Visit	1,342,653	3,359,116
visit_occurrence	Inpatient Hospitalization	676,614	1,012,456
visit_occurrence	Telehealth Visit	794,235	3,683,284
visit_occurrence	Outpatient Visit	4,727,970	93,872,652
condition_occurrence	Billing Diagnosis	2,829,062	74,065,186
condition_occurrence	Encounter Diagnosis	4,353,043	125,919,573
condition_occurrence	Problem List	2,462,239	13,779,826
condition_occurrence	Hospital Problem	952,609	3,969,045
measurement	Vital Signs	3,983,408	709,682,208
measurement	Flowsheet Measurement	1,945,060	258,022,030
measurement	Lab Component Result	4,308,922	1,136,014,375
drug_exposure	Medication Order with Administration	1,698,995	141,076,077
drug_exposure	Outpatient Medication Order with Dispense	28,980	294,784
drug_exposure	Immunization Administration	1,184,493	8,074,855
drug_exposure	Outpatient Medication Order	2,857,440	50,668,017
drug_exposure	Medication Order with Dispense	1,029,879	16,685,664
drug_exposure	Medication Order	1,112,002	13,901,740
drug_exposure	Immunization from Medication Order	226,605	294,143
drug_exposure	Immunization from Procedure Order	792,275	3,649,981
procedure_occurrence	Procedure Inferred from Flowsheet	24,442	285,164
procedure_occurrence	General Procedure	5,462,144	344,497,784
procedure_occurrence	Surgical Procedure	379,773	1,517,522
observation	Surgical History Procedure	1,687,247	3,767,626
observation	Flowsheet Observation	2,321,710	115,799,634
observation	Social History	3,463,871	152,506,583
observation	Past Medical History	2,348,250	8,891,021
observation	Patient Demographics	12,183,141	65,348,008
observation	Family History	1,606,052	70,397,471
observation	Allergy	3,557,322	4,317,311
note	Clinical Note	5,165,100	213,043,520
note	Lab Component Result Note	2,629,844	18,126,783
provider	Provider		1,362,193
provider_attribute_xtn	Physician specialty		604,988
provider_attribute_xtn	Personnel specialty		176,943
location	Provider Address		1,362,193
location	Patient Address		12,183,141
location	Care Site Address		15,874
care_site	Service Area		50
care_site	Place of Service		7,252
care_site	Bed		82,027
care_site	Department		6,346
care_site	Care Area		813
care_site	Location		2,174
care_site	Room		7,460
concept	EPIC SURGICAL PROCEDURE		36,166
concept	EPIC DIAGNOSIS		1,590,107
concept	EPIC ALLERGEN		40,505
concept	EPIC VISIT TYPE		11,959
concept	EPIC PROCEDURE		189,076
concept	EPIC FLOWSHEET MEASURE		96,078
concept	EPIC FLOWSHEET TEMPLATE		3,985
concept	EPIC MEDICATION		142,623
concept	EPIC LAB COMPONENT		41,500
concept	EPIC IMMUNIZATION		520
vocabulary	MSDW Vocabulary		7
vocabulary	Epic Vocabulary		89
vocabulary	Vocabulary		104
vocabulary	PowerPath Vocabulary		8