Mount Sinai Data Warehouse (MSDW)
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.
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.
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.
TriNetX is an intuitive self-service tool that can be used to perform de-identified queries in the MSDW.
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.
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.