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.


 * The columns listed below constitude all current and potential columns in the dataset. Depending upon its specific agreement with CDCR, a given organization may not have access to all columns listed.

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