The d_icd_diagnoses table

Table source: Online sources.

Table purpose: Definition table for ICD diagnoses.

Number of rows: 14,567

Links to:

  • DIAGNOSES_ICD ON ICD9_CODE

Brief summary

This table defines International Classification of Diseases Version 9 (ICD-9) codes for diagnoses. These codes are assigned at the end of the patient’s stay and are used by the hospital to bill for care provided.

Table columns

Name Postgres data type
ROW_ID INT
ICD9_CODE VARCHAR(10)
SHORT_TITLE VARCHAR(50)
LONG_TITLE VARCHAR(300)

Detailed Description

ICD9_CODE

ICD9_CODE is the International Coding Definitions Version 9 (ICD-9) code. Each code corresponds to a single diagnostic concept.

SHORT_TITLE, LONG_TITLE

The title fields provide a brief definition for the given diagnosis code in ICD9_CODE.

MIMIC-III v1.4 documentation