StaffData/Deprecated/StaffCovidInfection

Table containing results for returned/reported COVID diagnostic tests on CDCR staff

StaffId
Anonymized integer uniquely identifiying each staff member. StaffId is stable across tables and timepoints. 88758923, -9450823
 * Examples

ViralTestDate
Collection date of most recent test. In cases where more than one test is collected on the same day, positive tests are picked first, then negative tests, then indeterminate tests. If a tie remains, the last test result that day will be picked. Note: In some cases, the test result is reported by the employee and test collection date is not known. In these cases, the date CDCR was informed by the employee is used as the test collection date. 2019-11-05, 2020-01-31
 * Examples

ViralTestReceivedDate
Date most recent test result received by CDCR, when known. 2020-05-07
 * Example

ViralTestResult
The test result. DETECTED, NOT DETECTED, INDETERMINATE
 * Values

OrderName
Available information regarding the type of test performed. Note: Due to issues in the source data, some values are missing or irrelevant and in other cases, the full order description is truncated. SARS-CoV-2 NAA, SARS CoV 2 RNA, COVID-19
 * Examples:

Specimen
Collection site of test Oropharyngeal; Nasal
 * Examples

Vendor
The vendor of the lab test. In cases where the employee reported the result to CDCR, the vendor is listed as "Sharepoint" MDX; MMED
 * Examples

Details
Pipe (|) delimited list of Ct, RLU, and genotype information, when available.

|Ct_RLU
The Ct or RLU values(s) assocaited with the test, if known.

Examples
 * Ct_RLU 31.9492 / 33.0119
 * Ct_RLU 27.2104 / 26.3724

|Microarray
The pango lineage identified by microarray assay

Examples
 * Microarray B.1.1.529
 * Microarray B.1.617.2

Limitations
Detail information is not available for all positive tests. Genotyping only attemped on positive staff specimens with Ct < 25.

Datasource: data.StaffCovidTests