icd_diagnosis_lookup
List of ICD Diagnosis codes from CMS
Primary Key:Indexes:diagnosis_code_prefix_idx
-"left"(diagnosis_code, 4)
icd_diagnosis_lookup_diagnosis_code_release_date_idx
(Unique) -diagnosis_code
,release_date
Column | Data Type | Nullable | Indexed | Description |
---|---|---|---|---|
icd_diagnosis_id | bigint | No | Yes | - |
diagnosis_code | text | No | Yes | - |
description | text | No | No | - |
icd_version | text | No | No | - |
release_date | date | No | Yes | - |