StaffData/Deprecated/StaffCovidInfection

This dataset has been replaced by StaffData/StaffCovidTests

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 signed integer ID value for the staff member, consistent across all data in the same upload.

Examples

88758923, -9450823

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.

Examples

2019-11-05, 2020-01-31

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.

Examples

SARS-CoV-2 NAA, SARS CoV 2 RNA, COVID-19

Specimen

Anatomical collection site of test

Examples

Oropharyngeal; Nasal

Vendor

The laboratory that conducted the test. In cases where the employee reported the result to CDCR, the vendor is listed as "Sharepoint"

Examples

MDX; MMED

ViralTestResult

The test result.

Values

DETECTED, NOT DETECTED, INDETERMINATE

ViralTestReceivedDate

Date test result received by CDCR. Often unknown.

Example

2020-05-07

Details

Viral load and variant from test. Pipe (|) delimited list, provided 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 associated with the test.

ViralSequence

This detail is not currently available. The viral genomic sequence of the test specimen.

Datasource: data.StaffCovidTests