ResidentData/Deprecated/CovidInfection

This table comprises data realted to measuring and mitigating the COVID pandemic in CDCR, 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 2019-11-06, 2020-01-31
 * Examples

Month
The year and month for which the record applies, used to segment files 2019-11, 2020-01
 * 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

EstimatedInfectionDate
Collection date of first positive COVID test or symptom onset date if onset occurred within 7 days prior to first test date, whichever came first 2020-12-01, 2021-02-09
 * Examples

CovidLOC
The COVID-related status of the resident as of the end of that day. Warning: ER, Telemetry, Med/Surg, Med/Surg ICU, ICU, ICU/Vent, and Resolved may be underreported in this data element. Naive, Confirmed Active, Quarantine, Isolation, Resolved, ER, Telemetry, Med/Surg, Med/Surg ICU, ICU, ICU/Vent, Died
 * Values

ViralTestStatus
Latest COVID viral test (pcr OR antigen) result  as of the end of that day Negative, Positive
 * Examples

ViralTestType
Concatenated descriptions of assay entered into EHRS and/or by the lab for the most recent viral test as of the end of that day "CoV-2 RNA QUAL RT-PCR+(COVID19)-39433 PAN-SARS RNA", "Misc Test Other+COVID19"
 * Examples

ViralTestDate
Collection date of last completed viral test. Note that in cases where multiple tests with the same result have been collected, ViralTestDate should change to reflect the latest collection date of each test. 2020-12-01, 2021-02-09
 * Examples

ViralTestResultDate
Date last completed viral test result was recorded in the medical record. 2020-12-01, 2021-02-09 Note the possibility of cases where two or more tests collected on different days are received back on the same day. In this case, ViralTestResultDate will be the same across records for the same resident but with different ViralTestDates.
 * Examples
 * Comments

ViralTestSpecimen
Site of COVID specimen collection. Free text. Nasopharyngeal, NP+OP, Nasal
 * Examples

SxOnset
Equals 1 as of the day of COVID symptom onset per public health data. Stays as 1 until public health declares that symptoms have remitted, that the resident has been released from isolation, or that the case is resolved (whichever occurs first), at which point it switches to 0 for all subsequent days. null indicates no history of ever being symptomatic for COVID. Note that symptom onset often preceeds date of positive test collection. null,1,0
 * Values

Ili
Equals 1 if cough, shortness of breath, fever, temp>=37.8C, or SpO2<94 were recorded in the medical record on that day. Note that this is independent of COVID status. 0,1
 * Examples

HospitalizationDxs
This column under construction and currently not populated Comma-separated list of ICD 10 codes of the admitting diagnoses of any hospital admission that occurred on that day for that resident. Note that the hospitalization may or may not be related to COVID-19. 724.2, 789.0, 836.54, 995.3
 * Examples