Skip to main content

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
ColumnData TypeNullableIndexedDescription
icd_diagnosis_idbigintNoYes-
diagnosis_codetextNoYes-
descriptiontextNoNo-
icd_versiontextNoNo-
release_datedateNoYes-