DIAG_TABLE

This table provides helpful context and categories around ICD-10 diagnosis codes.

Queries that source from DIAG_TABLE table

• diagDetail

What is in the DIAG_TABLE table?

Results are returned as a json, pySpark DataFrame, or pandas DataFrame (default).

feature	description	example
diag_code	ICD-10 diagnosis code	E512
short_diag_code	First three characters of the ICD-10 diagnosis code, corresponding to the diagnosis subcategory	E51
diag_subcategory	Name of the ICD-10 diagnosis sub-category	thiamine deficiency
diag_category	Name of the ICD-10 diagnosis category	endocrine, nutri, and metabolic diseases/immunity disorders
diag_desc	Description of the ICD-10 diagnosis code	Wernicke's encephalopathy
icd9_code	ICD-9 mapping to the ICD-10 diagnosis code	2651
diag_severity	CMS-designated severity score from 0 to 100	70

Helper Function within the CareQuery API to help understand the underlying DIAG_TABLE dataset.

Python

# import package
from care_query.care_query import CareQuery

# instantiate and connect
cq = CareQuery(email = "your-email", 
               token = "your-api-token")

# return details 
print(cq.glossary.table_detail('DIAG_TABLE'))