ResidentData/Immunization

This table comprises data realted to measuring and mitigating the COVID pandemic in CDCR, with one record per CDCR resident per day from 1 Jan 2020 onward and for selected days prior to 1 Jan 2020. Days when residents are temporarily out to court or a medical facility are also included, but days after a resident has paroled or discharged are not. If a paroled or discharged resident returns to CDCR, then their daily records will resume on the day they first returned.

Day
The beginning of the day for which the record applies 11/6/2019, 1/5/2020
 * Examples

Month
The integer value of the month in which the day of the record falls, used to segment files 1, 2, 11, 12
 * Examples

Seq
Equals 1 for the most recent daily record for a given resident; otherwise is null. 1, null
 * Values

ResidentId
Stable anonymized signed integer ID value for the resident 578998371, -456578293
 * Examples

VaccinationHistory
Comma-separated string of all vaccinations, results (received or refused) and dates offered by CDCR to the resident within the last five years. COVID-19 vaccinations are included in this list. pneumococcal 23-polyvalent,Received,2017-03-24,tetanus/diphtheria/pertussis acel(Tdap),Received,2017-03-24,influenza virus inactivated,Received,2018-10-23,hepatitis B,Received,2017-06-06,hepatitis A-hepatitis B,Received,2016-05-16,hepatitis B,Received,2016-07-06
 * Example

CovidVaccinationDate
Date last COVID-19 vaccine received 4/2/20, 5/18/20
 * Examples

CovidVaccinationRefusedDate
Most recent date COVID-19 vaccine was refused. Note that it is possible that a resident both refuses and receives a vaccination on the same day. 4/2/20, 5/18/20
 * Examples

CovidVaccinationBrand
Brand of COVID vaccine last received. In the event that a resident both refuses and receives a vaccination on the same day, this column is equal to the brand that was received. Moderna, Pfizer
 * Examples