ResidentData/Deprecated/Comorbidity

This table comprises data on comorbidities that may impact illness outcomes, with one record per CDCR resident per day from 1 Jan 2020 onward and for selected days prior to 1 Jan 2020. Days when residents are temporarily out to court or a medical facility are also included, but days after a resident has paroled or discharged are not. If a paroled or discharged resident returns to CDCR, then their daily records will resume on the day they first returned.

Day
The beginning of the day for which the record applies 11/6/2019, 1/5/2020
 * Examples

Month
The integer value of the month in which the day of the record falls, used to segment files 1, 2, 11, 12
 * Examples

Seq
Equals 1 for the most recent daily record for a given resident; otherwise is null. 1, null
 * Values

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

ClinicalRisk
General clinical risk level as of the end of that day. Ordinal. LOW, MED, HIGH1, HIGH2
 * Examples

CovidRiskCdcr
CDCR's weighted COVID risk score based on comorbidities and age. Integer. Higher values indicate greater risk. 0, 1, 4, 16
 * Examples

Comorbidities
A weighted score of selected COVID-related comorbidities + 1. Scoring is as follows where all comorbidity variables are 0/1: 1 + 1*asthma+ 2*[cancer-high]+ 1*CKD+ 1*[CKD-High]+ 1*LungDisease + 2*COPD+1*Diabetes+ 1*[Diabetes-High]+ 1*CVD+ 1*[CVD-High]+ 1*Hemoglobinopathy + 1*HIV+ 1*[Hiv-High]+ 1*HTN+ 2*Immunocompromised + + 1*Pregnancy + 2*AdvancedLiverDisease + 1 if ([dementiaorparkinsons]+[MultipleSclerosis]+[MyastheniaGravis]+[NeurologicDisorder]) >0 + 1 if bmi>=30 + 1 if ([Coccidioidomycosis-high]+ [ConnectiveTissueDisorder-high]+[EndocrineDisorder-high]+[Vasculitis-high])>0 1, 7, 15 ==Immunocompromised == Any of the following: 'Aplastic Anemia', 'Histiocytosis', 'Immunosuppressed', 'Organ Transplant', 'Other Transplant'. 1,0
 * Examples
 * Examples

LungDisease
Any of the following: 'Cystic Fibrosis','Pulmonary Fibrosis','Pneumoconiosis'. 1, 0
 * Examples

HTN/HTN-High
Hypertension 1,0
 * Examples

CVD/CVD-High
Any cardiovascular disease other than hypertension 1,0
 * Examples

Asthma
Persistent asthma 1,0
 * Examples

Cancer/Cancer-High
Any cancer 1,0
 * Examples

Diabetes/Diabetes-High
Diabetes 1,0
 * Examples

COPD/COPD-High
Chronic obstructive pulmonary disease 1,0
 * Examples

HIV/HIV-High
Human immunodeficiency virus 1,0
 * Examples

Pregnancy
Pregnant 1,0
 * Examples

MyastheniaGravis
0,1
 * Examples

Hemoglobinopathy
0,1
 * Examples

MultipleSclerosis/-High
0,1
 * Examples

Vasculilitis/-High
0,1
 * Examples

EndocrineDisorder/-High
0,1
 * Examples

NeurologicDisorder/-High
0,1
 * Examples

CKD/-High
Chronic Kidney Disease 0,1
 * Examples

DementiaOrParkinsons/-High
0,1
 * Examples

Coccidioidomycosis/-High
0,1
 * Examples

ConnectiveTissueDisorder/-High
0,1
 * Examples

Advanced Liver Disease
Cirrhosis or End stage liver disease 1,0
 * Examples

AdvancedAge
Resident is 65 years in age or older 1,0
 * Examples

Dialysis
Resident is currently on dialysis. Null values indicated this information is not known 1,0, null
 * Examples

Weight
Most recent recorded weight, in kg, rounded to the nearest kg 75, 101
 * Examples

Bmi
kg/m², rounded to the nearest whole number. In cases where BMI is not available for a given date range and resident, but is available for that same resident later in time, the later value is used. In cases where BMI is not available at all for a given resident, BMI is imputed based on coefficients of a linear regression by sex, age band (18-29,30-39,40-49,50-59,60-69,70-79,80 to 120), race (white, black, hispanic, other), and age band * race. 18,30,42
 * Examples

RegressedBmi
Equals 1 if BMI was imputed using linear regression, otherwise equals 0. 1,0
 * Examples

Potential columns
The following columns may be added to this table in the future.

Ili30DayHistory
Comma-separated string of all dates in the last 30 days (current day inclusive) during which any of the following symptoms was recorded: cough, shortness of breath, fever, temp>=37.8C, or SpO2<94. 2019-Oct-1, 2019-Oct-2, 2019-Oct-5, 2019-Oct-10
 * Examples