MIMIC II: Clinical Database Flat Files version 2.5

The new PhysioNet website is available at https://physionet.org.

MIMIC II: Clinical Database Flat Files version 2.5 (Coming Soon!)

MIMIC II Clinical Database version 2.5 flat files contain data for 26,655 subjects, who have been divided (arbitrarily) into five groups of about 5000 subjects each, and a sixth group of about 1700 subjects.

Downloads (requires decryption key to use):

DELIMITER: Within each table, fields (columns) are separated by comma and text data is wrapped in double quotes (CSV file format).

Definition tables and maps

The definition tables consist of nine tables containing definitions needed to interpret elements of the subject-specific tables. These tables can be extracted from the Definitions.tar.gz file above. These are:

  1. D_CAREGIVERS
  2. D_CAREUNITS
  3. D_CHARTITEMS
  4. D_CARTITEMS_DETAIL
  5. D_IOITEMS
  6. D_LABITEMS
  7. D_MEDITEMS
  8. D_PARAMMAP_ITEMS
  9. PARAMETER_MAPPING
Definitions.tar.gz contains the directory POSTGRES. This directory contains the database schema file in PostgreSQL format and sql scripts to generate some views. These files can be used to import the data into a local postgresql server. This process, however, is still under development and has not been fully tested. These files may change in the future.

BATCH Subject data tables

The six BATCH*.tar.gz.pgp files above contain subject-specific tables. An empty file indicates that data of the corresponding type are not available for the given subject. The tarballs unpack into directories for each subject. Each subject's directory contains 20 tables. These tables are:

  1. A_CHARTDURATIONS
  2. ADDITIVES
  3. ADMISSIONS
  4. A_IODURATIONS
  5. A_MEDDURATIONS
  6. CENSUSEVENTS
  7. CHARTEVENTS
  8. DELIVERIES
  9. D_PATIENTS
  10. ICD9
  11. ICUSTAY_DAYS
  12. ICUSTAY_DETAIL
  13. ICUSTAYEVENTS
  14. IOEVENTS
  15. LABEVENTS
  16. MEDEVENTS
  17. NOTEEVENTS
  18. POE_MED
  19. POE_ORDER
  20. TOTALBALEVENTS

Related Links: