ResidentData/Demographics

This table comprises data on resident demographics, 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

Sex
Resident's morphological sex M, F
 * Values

Race
Resident's race (Asian, Black, Hispanic, White, Other). Missing values are left blank. A, B, H, W, O, Null
 * Values

Ethnicity
Resident's ethnicity; orthogonal to race Samoan, Mexican, American Indian
 * Examples

AgeInYears
The resident's age in years on that day, randomly jittered by between -33 and +33 days. Each resident's age is jittered by a stable value. 21, 42, 65
 * Examples

EstimatedReleaseMonthYear
Last day of month and Year of estimated release date. Only current estimated release date is shown. Dates with year=1000 indicate unkown values; dates with year=9999 indicate life sentence with no parole date set 1/1/2032, 1/31/9999
 * Examples

HomeCounty
County of Last Legal Residence Stanislaus, unkown, null
 * Examples

CustodyLevel
Custody Level as of the end of that day I, II, III, IV
 * Examples

CustodyPoints
Custody Points as of the end of that day 1, 23, 239
 * Examples

PrimaryLanguage
Resident's primary language English, Spanish, ASL, Unknown
 * Examples

Interpreter
Whether the resident requires a language interpreter 1, 0
 * Values

ReadingLevel
The resident's most recent reading score on the Test of Achievement in Basic Education (TABE). Scores are intended to reflect reading grade level, from 0 to 12.9 0, 3.8, 12.8
 * Examples

Potential columns
The following columns may be added to this table in the future.

MathLevel
The resident's most recent math score on the Test of Achievement in Basic Education (TABE). Scores are intended to reflect reading grade level, from 0 to 12.9 0, 3.8, 12.8
 * Examples

LanguageLevel
The resident's most recent language score on the Test of Achievement in Basic Education (TABE). Scores are intended to reflect reading grade level, from 0 to 12.9 0, 3.8, 12.8
 * Examples