The diagnoses_icd table

Table source: Hospital database.

Table purpose: Contains ICD diagnoses for patients, most notably ICD-9 diagnoses.

Number of rows: 651,047

Links to:

  • PATIENTS on SUBJECT_ID
  • ADMISSIONS on HADM_ID
  • D_ICD_DIAGNOSES on ICD9_CODE

Important considerations

  • The ICD codes are generated for billing purposes at the end of the hospital stay.
  • All ICD codes in MIMIC-III are ICD-9 based. The Beth Israel Deaconess Medical Center will begin using ICD-10 codes in 2015.
  • The code field for the ICD-9-CM Principal and Other Diagnosis Codes is six characters in length, with the decimal point implied between the third and fourth digit for all diagnosis codes other than the V codes. The decimal is implied for V codes between the second and third digit.

Table columns

Name PostgreSQL data type Modifiers
ROW_ID INT not null
SUBJECT_ID INT not null
HADM_ID INT not null
SEQ_NUM INT
ICD9_CODE VARCHAR(10)

Detailed Description

SUBJECT_ID, HADM_ID

Identifiers which specify the patient: SUBJECT_ID is unique to a patient and HADM_ID is unique to a patient hospital stay.

SEQ_NUM

SEQ_NUM provides the order in which the ICD diagnoses relate to the patient. ICD diagnoses are ordered by priority - and the order does have an impact on the reimbursement for treatment.

ICD9_CODE

ICD9_CODE contains the actual code corresponding to the diagnosis assigned to the patient for the given row. Note that all codes, as of MIMIC-III v1.0, are ICD-9 codes.

MIMIC-III v1.4 documentation