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

Gender
Self-reported gender of staff member. Note, to safeguard against potential identification of individuals, cases where gender is not male or female are set to NULL. Male, Female, NULL
 * Values

Ethnicity
Ethnicity of staff member African American, White, Other, Unspecified
 * Examples

Zipcode
Residential zipcode of staff member

AgeInDecades
Age decade of staff member at the time of test collection, jittered by +/- 33 days. For example, 3 means the staff member is in their 30's. 2, 5, 7
 * Examples

Classification
Job class. Some classes may be aggregated to ensure privacy. Correctional, Other
 * Values

WorkArea
Name of institution or office where staff primarly works. Note: This column is slated for removal. Use the StaffRoster dataset to determine staff work location for any given month. (COR) Corcoran State Prison; Headquarters; Parole
 * 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

Month
The year and month of the viral test collection, used to segment files 2019-11, 2020-01
 * 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

UpdateDate
The date the table was last updated. 2021-02-12
 * Example