The d_icd_procedures table

Table source: Online sources.

Table purpose: Definition table for ICD procedures.

Number of rows: 3,882

Links to:

  • PROCEDURES_ICD on ICD9_CODE

Brief summary

This table defines International Classification of Diseases Version 9 (ICD-9) codes for procedures. These codes are assigned at the end of the patient’s stay and are used by the hospital to bill for care provided. They can further be used to identify if certain procedures have been performed (e.g. surgery).

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 procedural concept.

SHORT_TITLE, LONG_TITLE

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

MIMIC-III v1.4 documentation