ResidentData/Deprecated/CovidInfection

This table comprises data on daily Covid-19 infection status and related symptoms. For each element, only a maximum of one value is reported per resident per day. In cases of multiple tests collected on the same day, tests are first priorized by positive over negative and then by earliest result received over latest. Diagnostic tests collected while residents are in community facilities may also be included in the dataset even though the resident is not residing in a prison at the time.

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
This column deprecated and now is always NULL. This column will be removed in a future release. To get all values for any given test, joining on ResidentId + Day is sufficient.

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

CovidLOC
One of three COVID-related statuses of the resident as of the end of that day, if applicable, "None" if not. A value of "Died" means the resident died due to Covid per CCHCS. A status applies to a resident from the date of the record to the date of the next record with a different value. Quarantine, Isolation, Died, None
 * Values

ViralTestStatus
Result of a positive or negative SARS-CoV-2 diagnostic test collected on the date indicated by the Day value of the record. In cases where multiple positive and/or negative tests are collected on the same day for the same resident, the first received positive test is used if there was a positive test, otherwise, the first received negative test is used. Negative, Positive
 * Values

ViralTestType
Concatenated descriptions of the assay entered into the medical record and/or by the lab for the SARS-CoV-2 diagnostic test collected on the date indicated by the Day value of the record. Note: Due to data entry errors, test types may be misdescribed. All tests in this dataset are Covid diagnostic tests, discrepant type descriptions notwithstanding. "Antigen FIA Test, COVID-19 Rapid Test POC", "BinaxNow POC, COVID-19 Rapid Test POC", "PCR"
 * Examples

ViralTestResultDate
The date the diagnostic test result was received. Note: The date the test result was received is often unreported. 2020-12-01, 2021-02-09
 * Examples

ViralTestSpecimen
Site of diagnostic test 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. Warning: Since the Covid-19 surge starting in December, 2020, SxOnset data may not be complete. 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. SpO2 may or may not be on room air. 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