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.