StaffData/Deprecated/StaffCovidInfection

Information on COVID diagnostic tests on CDCR staff administered by or reported to CDCR from the beginning of the pandemic to the present.

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

ViralTestDate
Collection date of diagnostic 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

OrderName
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
Anatomical collection site of test Oropharyngeal; Nasal
 * Examples

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

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

ViralTestReceivedDate
Date test result received by CDCR. Often unknown. 2020-05-07
 * Example

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

|Ct_RLU
The Ct or RLU values associated with the test. Often unknown.

Examples
 * Ct_RLU 31.9492 / 33.0119
 * Ct_RLU 27.2104 / 26.3724

|Microarray
The pango lineage identified. Identified by microarray assay

Examples
 * Microarray B.1.1.529
 * Microarray B.1.617.2

|SNP
This detail is currently unavailable.

The SARS-CoV-2 variant based on variations of single nucleotide polymorphisms

Examples
 * SNP Delta
 * SNP Omicron

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

GisaidId
This detail is not currently available. The GISAID ID of the test result.

Datasource: data.StaffCovidTests