The MIMIC II Explorer is a collection of web-based tools for searching and browsing the data contained within the MIMIC II Database.

The applications on this site communicate with your browser through an encrypted channel. For convenience, all applications are signed using the same certificate, which can be installed in your browser by clicking on the following download link

http://mimic.mit.edu/certs/lcpca.crt

If you do not install our certificate, a warning will be displayed before you access each application. Please check the certificate carefully, and proceed only once you have verified the information.

The MIMIC-II Explorer consists of the following applications.

Query Builder

Screenshot of query builder application

Application Link

For an introduction to the database, please see our tutorial

The query builder provides a direct SQL interface to the database. While the rich search application provides an interface for introductory searches, the query builder provides an interface for advanced users to perform low-level database queries and extract much more complicated information. This interface also provides the ability for users to export the results of their queries for processing in their own statistical tools.

Upon accessing the query builder application, the user is presented with a display similar to that shown on the right. The screen contains three main areas: 1. The SQL entry panel. 2. The result dataset panel. 3. A tree showing the various database objects available.

The user enters their query in the entry panel, and clicks the "Execute query" button. After the server has executed the query, the resulting dataset is returned to the user and displayed in the lower part of the page. 50 records are displayed and the user can scroll down to view records which do not fit on the screen. The other records can be obtained by paging the result set, by clicking on the paging toolbar at the very bottom of the screen or entering the desired page number in the field.

Screenshot of chartevents meta-dataOnce a query has been run, it can be exported -- 50 records at a time -- to a CSV ("comma-separated values") file for use in a standard spreadsheet program.

The tree on the left hand side displays a list of available database objects such as tables and views. Clicking on one of these entries will display meta-data pertaining to the selected object. The object's metadata is invaluable for learning the structure of the database since it shows the columns contained within each object and the specific details of each column. The name of each column, along with their datatype and a comment are displayed.

This metadata is used extensively when developing queries since it informs the user how to combine the various database objects to extract the information from the database. For example, the d_patient table contains the subject_ids - other database tables also contain a subject_id which indicates to which patient a particular record applies.