Mapping the MIMIC-III database to the OMOP schema
Switch branches/tags
Nothing to show
Clone or download


This repository contains an Extract-Transform-Load (ETL) process for mapping the MIMIC-III database to the OMOP Common Data Model. This process involves both transforming the structure of the database (i.e. the relational schema), but also standardizing the many concepts in the MIMIC-III database to a standard vocabulary (primarily the Athena Vocabulary, which you can explore here).

"WHERE IS ..."

Below in the README, we provide two sections. The first section, OMOP TABLES LOADED, lists the OMOP tables which have been populated from MIMIC-III. You can use this section to figure out what data generated each OMOP TABLE. For example, we can see that the OMOP CDM table person was populated using data from the patients and admissions table in MIMIC-III.

The second section, MIMIC TABLES EQUIVALENCE, lists all the tables in MIMIC-III, and shows where the data now exists in the OMOP CDM. For example, we can see that the MIMIC-III table patients was used to populate the OMOP CDM tables person and death.





  • both MIMIC & OMOP schema do have table & columns descriptions directly into postgres
  • take a look at the schemaspy website describing both
    1. mimic
    2. omop