ResidentData/Deprecated/Comorbidity

This table comprises data on comorbidities that may impact illness outcomes.

ResidentId
Stable anonymized signed integer ID value for the resident 578998371, -456578293
 * Examples

Comorbidity
The name of the specific comorbidity or vital sign. Values with a "High" suffix indicates a comorbidity that exceeds an established threshold of severity. Values are determined via automated abstraction of diagnostic codes, procedure codes, medications, vital signs, and laboratory results from CDCR's electronic health record and outside medical provider claims. AdvancedLiverDisease , Asthma , Bmi , Cancer , CancerHigh, CKD CKDHigh, CovidWeighedRisk , GeneralClinicalRisk , Coccidioidomycosis, CoccidioidomycosisHigh, ConnectiveTissueDisorder, ConnectiveTissueDisorderHigh, COPD , COPDHigh, CVD , CVDHigh, DementiaOrParkinsons, DementiaOrParkinsonsHigh, Diabetes, DiabetesHigh, Dialysis , EndocrineDisorder, EndocrineDisorderHigh, Hemoglobinopathy, HemoglobinopathyHigh, HIV , HIVHigh , HTN , HTNHigh, Immunocompromised , LungDisease , MinPulse, MaxPulse, MinRR , MaxRR , MinSBP , MaxSBP , MinSpO2 , MaxSpO2 , MinTemp , MaxTemp , MultipleSclerosis, MultipleSclerosisHigh, MyastheniaGravis, MyastheniaGravisHigh, NeurologicDisorder, NeurologicDisorderHigh, Pregnancy, TB , Vasculitis, VasculitisHigh, Weight
 * Values

Starting
The date the comorbidity value took effect or that the vital sign was taken. 2019-11-06, 2020-05-15
 * Examples

Month
The year and month in the comorbidity value took effect for the resident. Used to segment files. 2019-11, 2020-01
 * Examples

Ending
The date the comorbidity value ended for the resident or that the next vital sign was taken. NULL if value currently applies or if the vital sign has not been retaken since. Note: For any given record, the effective period is [Starting, Ending), meaning that the period includes the starting date but does not include the ending date.	2019-11-07, 2020-05-16, NULL
 * Examples

Value
The value associated with the comorbidity. For BMI, it is kg/m², rounded to the nearest whole number. For weight, it is kg, rounded to the nearest kg. For ClinicalRisk, it is based on this scoring algorithm. For dialysis, it is 1 on the date the resident started dialysis and 0 when they stopped. For all other comorbidities, it is 1 if the comorbidity is present and 0 if it is no longer present.