ResidentData/CovidTests

This table comprises one record per CDCR resident per day for each positive, negative, and inconclusive SARS-CoV-2 diagnostic tests. If, for example, a resident had a negative and a positive diagnostic test on the same day, there would be two records for that resident for that day in this dataset. If a resident had two negative tests on the same day, there would be one record for that resident on that day, based on the first of the two tests received. 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
List of available descriptions of each 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 of multiple tests on the same day, descriptions are separated by a | (pipe). 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 descriptions notwithstanding.
 * Examples
 * PCR
 * Antigen FIA Test
 * Antigen FIA Test | Antigen FIA Test
 * Antigen FIA Test (CollectionDate adjusted)
 * COVID-19 POC Result
 * CoV-2 RNA (COVID19), QUAL NAAT-39448
 * SARS CoV 2 RNA(COVID 19), QUALITATIVE NA
 * BinaxNow POC
 * COVID19 Result

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, negative, or inconclusive SARS-CoV-2 diagnostic test collected on the date indicated by the Day value of the record. In cases where multiple positive tests, multiple negative tests, or multiple inconclusive tests are collected on the same day for the same resident, the first received test with that result is used. Negative, Positive, Inconclusive
 * Values