DOI: 10.7910/dvn/9kwmtj
title: California Jail Profile Survey 1995-2020

description: This data is the Jail Profile Survey from California. These data include highly detailed information about the inmates in jails in the state at the jail-month level and the county-month and county-quarter level of analysis.
&lt;br&gt;&lt;br&gt;
The data was scraped from the California Board of State and Community Corrections' website here https://app.bscc.ca.gov/joq//jps/queryselection.asp
&lt;br&gt;&lt;br&gt;
There are three data sets available: facility/jail-level data monthly, county-level data monthly, and county-level data quarterly. Each of these data sets offers different variables. All the data sets have the variables indicating the years, month (or quarter), and jurisdiction (in most cases the county sheriff). I added variables with the FIPS county and state codes and county names from the US census.
&lt;br&gt;&lt;br&gt;
The PDF available for download is the instruction manual from the California Board of State and Community Corrections to employees who submit the jail survey data. This manual indicates how variables are created and can help with understanding the data. I recommend reading it before using this data.
&lt;br&gt;&lt;br&gt;
I did not make any changes to the except for the following: Changed column names to make it more informative and shorten names to fit the 32 character limit for Stata. Some cells had the values D and U to represent Does Not Apply and Unavailable. In both of these cases I changed those cells to NA. I did this to allow the column to be numeric for analysis.
&lt;br&gt;&lt;br&gt;
Variables in Facility/Jail-Level Data Monthly&lt;br&gt;

 Name of facility/jail&lt;br&gt;
 Population capacity for the facility (if any)&lt;br&gt;
 Average daily population for unsentenced males&lt;br&gt;
 Average daily population for unsentenced females&lt;br&gt;
 Average daily population for sentenced males&lt;br&gt;
 Average daily population for sentenced females&lt;br&gt;
 Average daily population total&lt;br&gt;&lt;br&gt;

Variables in County-Level Data Monthly&lt;br&gt;

 Average daily population for unsentenced males&lt;br&gt;
 Average daily population for unsentenced females&lt;br&gt;
 Average daily population for sentenced males&lt;br&gt;
 Average daily population for sentenced females&lt;br&gt;
 Average daily population total&lt;br&gt;
 Average number of felony inmates unsentenced&lt;br&gt;
 Average number of felony inmates sentenced&lt;br&gt;
 Average number of felony inmates total&lt;br&gt;
 Average number of misdemeanor inmates unsentenced&lt;br&gt;
 Average number of misdemeanor inmates sentenced&lt;br&gt;
 Average number of misdemeanor inmates total&lt;br&gt;
 Day of month where county had most number of inmates&lt;br&gt;
 The number of inmates on that day&lt;br&gt;
 Average daily population of maximum security inmates&lt;br&gt;
 Average daily population of medium security inmates&lt;br&gt;
 Average daily population of minimum security inmates&lt;br&gt;
 Number of mental health cases opened last day of month&lt;br&gt;
 Number of new mental health cases open during month&lt;br&gt;
 Inmates receiving psych medication on last day of month&lt;br&gt;
 Inmates assigned to mental health beds on last day of month&lt;br&gt;
 Inmates seen at sick call during month&lt;br&gt;
 Doctor occurrences during month&lt;br&gt;
 Off-site medical appointments during month&lt;br&gt;
 Dental encounters during month&lt;br&gt;
 Inmates assigned to medical beds on last day of month&lt;br&gt;
 Average number of inmates not assigned to housing&lt;br&gt;
 Average number of inmates in contract beds in other jurisdictions&lt;br&gt;
 Average number of federal inmates in facilities (by contract)&lt;br&gt;
 Average number of state inmates in facilities (by contract)&lt;br&gt;
 Average number of other county inmates in facilities (by contract)&lt;br&gt;
 Average number of inmates sent or awaiting contract to prison&lt;br&gt;
 Average number of inmates in hospitals outside jail&lt;br&gt;
 Total number of inmates booked during month&lt;br&gt;
 Total number of pretrial released due to lack of housing&lt;br&gt;
 Total number of sentenced inmates released due to lack of housing&lt;br&gt;
 Total number of juveniles in custody&lt;br&gt;&lt;br&gt;

Variables in County-Level Data Quarterly&lt;br&gt;

 Number of inmates classified as "3rd Strike"&lt;br&gt;
 Number of inmates classified as "2nd Strike"&lt;br&gt;
 Number of unserved felony warrants in county&lt;br&gt;
 Number of unserved misdemeanor warrants in county&lt;br&gt;
 Percent of inmates believed to be illegal aliens&lt;br&gt;
 Number of inmates assaults on staff&lt;br&gt;
 Money spent on medication in previous quarter&lt;br&gt;
 Money spent on psych medication during previous quarter&lt;br&gt;
 Average length of stay (in days) for all released inmates&lt;br&gt;
 Average length of stay (in days) for pretrial releases&lt;br&gt;
 Average length of stay (in days) for sentenced inmate releases