ResidentData/CovidTests

This table comprises all SARS-CoV-2 diagnostic tests on CDCR residents with valid results. Pending tests are not included unless and until a result is received.

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

CollectionDate
Collection date of the test.

TestType
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. "CoV-2 RNA QUAL RT-PCR+(COVID19)-39433 PAN-SARS RNA", "Misc Test Other+COVID19"
 * Examples

Specimen
Site of diagnostic test specimen collection. Free text. Nasopharyngeal, NP+OP, Nasal
 * Examples

ResultReceivedDate
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

Result
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

ViralLoad
Viral-load related value, such as CT or RLU, when available