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.
Was this page helpful?
Glad to hear it! Please raise an issue here to tell us how we can improve.
Sorry to hear that. Please raise an issue here to tell us how we can improve.