The Mount Sinai Data Warehouse (MSDW) collects clinical, operational, and financial data for use in clinical and translational research, as well as quality and improvement initiatives. MSDW data goes back to 2003, covering a variety of EMR and ancillary systems at Mount Sinai Hospital (MSH) and expanding to Mount Sinai Queens Hospital (MSQ), and in recent years, St. Luke’s (MSSL), Mount Sinai West (MSW), and Brooklyn hospitals.

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. Cohort Query Tool (CQT)

The Cohort Query Tool (CQT) is a web-based self-service tool that can be used to query de-identified or identified data in the MSDW.

Learn More

C. i2b2

I2b2 is a software application supported by ConduITS, the ISMMS CTSA and the NIH. i2b2 allows investigators to quickly perform self-service queries of de-identified data in the MSDW.

Learn More 

D. TriNetX

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

Learn More

E. 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

F. De-identified Data Service

The MSDW team offers de-identified data through CQT, i2b2 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