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. 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.

Institution
The facility where test was collected. This is often a CDCR prison but may also be a community facility, a jail (county name is used in this case), or other location. In some cases, the facility is unkonwn and the resident's presumed location at the time of test collection is used (e.g., CDCR, PAROLE, DISHCARGED, ESCAPE). ASP, CCWF, Butte County, El Dorado County, CDCR, PAROLE
 * Examples

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

CollectionDate
Collection date of the test. In cases of clear data entry error for this date, CollectionDate is adjusted to equal ReceivedDate. In these cases the term "CollectionDate adjusted" will appear in the Details column string.

Details
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. In cases where CollectionDate is adjusted, "CollectionDate adjusted" also appears in this column. Note: Due to labeling differences across laboratories and across time and data entry errors and omissions, test types may be misdescribed or incomplete. 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

ReceivedDate
The date the diagnostic test result was received. Note: The date the test result was received is often unreported. In cases where the received date exists but precedes CollectionDate, it is automatically set equal to CollectionDate. 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