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.