Are all patients' admissions and ICU stays from MIMIC-II included in MIMIC-III?

1 Answer 1


The vast majority of patients who appear in MIMIC-II v2.6 also appear in MIMIC-III v1.3. These patients retain the same subject_id and can be selected across versions of the database using the following query:

mimic2 as (
    SELECT p2.subject_id subject_id_m2
    FROM mimic2v26.d_patients p2),
mimic3 as (
    SELECT p3.subject_id subject_id_m3
    FROM mimiciii.patients p3)
SELECT m2.subject_id_m2, m3.subject_id_m3
FROM mimic2 m2
LEFT JOIN mimic3 m3
ON m2.subject_id_m2 = m3.subject_id_m3
ORDER BY m2.subject_id_m2;

A small proportion of patients were not included in MIMIC-III for various reasons, mostly relating to missing data in a later data dump. These patients may be added in the future.

Note that MIMIC-II and MIMIC-III are significantly different in structure and content. We recommend treating MIMIC-III as an entirely new database, unless there are strong reasons to attempt to link across versions.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.