Mount Sinai Data Warehouse (MSDW)

The Mount Sinai Data Warehouse (MSDW) collects clinical and operational data for use in clinical and translational research, as well as quality and improvement initiatives. MSDW data is largely comprised of Epic EHR data, which is the primary EHR system in the Mount Sinai Health System.  Epic was first implemented in 2011 and now contains data on over 12 million patients in the Mount Sinai Health System.

To learn more about the data sources, refer to the MSDW website.

Researchers can access the MSDW using the following avenues:

A. Custom Queries

Work with MSDW analysts to compose custom SQL queries for research. This is a comprehensive and sophisticated way to search the MSDW.

  • Cost: $180/hr
  • Turnaround Time: Typically a few weeks
  • Typical Query
    • Tabulate demographics, comorbidities, PMD and SW/Care Management involvement in geriatric patients discharged from the ED who were re-admitted within 3, 6 or 12 months.
  • IRB Approval: Required
  • Access: To request a custom query, submit support requests through the MSDW ticketing system using your Mount Sinai credentials.

B. Leaf

A lightweight, drag-and-drop web-based query tool that enables you to easily create patient cohorts from de-identified data using multiple clinical and demographic criteria.

Learn More

C. TriNetX

TriNetX is an intuitive self-service tool that can be used to perform de-identified queries in the MSDW.

Learn More

D. OMOP Common Data Model (CDM) and OHDSI ATLAS – A web-based integrated platform for database exploration, standardized vocabulary browsing, cohort definition, and population-level analysis.

Learn More

E. De-identified Data Service

The MSDW team offers de-identified data through Leaf, ATLAS and TriNetX, and follow Mount Sinai’s policy on the de-identification of protected health information. Please note that the MSDW team currently does not offer de-identified health information in free text fields, e.g., Progress Notes. As techniques evolve, the possibility of this data source will be revisited.

Learn More