The procedures_icd table
Table source: Hospital database.
Table purpose: Contains ICD procedures for patients, most notably ICD-9 procedures.
Number of rows: 240,095
- PATIENTS on
- ADMISSIONS on
- D_ICD_PROCEDURES on
- The ICD codes are generated for billing purposes at the end of the hospital stay.
- ICD codes are recorded for all patient hospitalizations in MIMIC-III.
|Name||PostgreSQL data type||Modifiers|
Identifiers which specify the patient:
SUBJECT_ID is unique to a patient and
HADM_ID is unique to a patient hospital stay.
SEQ_NUM provides the order in which the procedures were performed.
ICD9_CODE provides the ICD-9 code for the given procedure. This code can be joined to the D_ICD_PROCEDURES table to determine what procedure is recorded for the patient.