ResidentData/Deprecated/CovidInfection

This table comprises data related to measuring and mitigating the COVID pandemic in CDCR.

Day
The day for which the record applies 2019-11-06, 2020-01-31
 * Examples

Month
Integer representing the year and month for which the record applies 201911, 202001
 * Examples

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

Sequence
An integer that uniquely identifies the specific record when there are multiple records of the same type for a given resident within the same file (full or incremental), ordered by most recent first. For example, the records below show three ViralTestType-ViralTestStatus pairs for resident #55555555: Detected PCR on February 1; Not detected Antigen on February 3; and Inconclusive PCR on February 3. For the two pairs on February 3, Inconclusive PCR happened most recently, as it has a lower sequence number (2) than Not detected Antigent (3). Note: Sequence values reset within each file (full and incremental) and do not correspond across files. Therefore, make sure to only match sequences between records from the same file.

Element
The data element for that record. Elements can be any of the following:

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
Result of a COVID viral test. Negative, Positive
 * Examples

ViralTestType
Concatenated descriptions of assay entered into EHRS and/or by the lab for the viral test. The Day associated with this element is the day the test was collected. "CoV-2 RNA QUAL RT-PCR+(COVID19)-39433 PAN-SARS RNA", "Misc Test Other+COVID19"
 * 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. Equals 0 on the day that public health declares that symptoms have remitted, that the resident has been released from isolation, or that the case is resolved (whichever occurs first). Note that symptom onset often preceeds date of positive test collection. 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. 1
 * Values

Hospitalization
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