18-20 year olds in Massachusetts County Houses of Correction (Plymouth County Sheriff's Department)

Joshua Dankoff filed this request with the Plymouth County Sheriff's Department of Plymouth County, MA.
Multi Request 18-20 year olds in Massachusetts County Houses of Correction
Status
Completed

Communications

From: Joshua Dankoff

Dear County Sheriff's Office,

This is a request under the Massachusetts Public Records Law (M. G. L. Chapter 66, Section 10), for documents in your Department’s possession regarding 18-, 19-, and 20-year-olds in your custody. I am writing on behalf of Citizens for Juvenile Justice (CfJJ), a nonprofit organization advocating for equitable youth justice in Massachusetts.

With respect to the form of production, we note that relevant regulations require the production of records in an accessible, commonly used electronic form, to the extent feasible. See 950 CMR 32.04(5)(d). Record custodians are also required to implement new record keeping systems and databases in such a way as to allow for “retrieval of public portions of records to provide maximum public access.” See 950 CMR 32.07(1)(e). Extraction of such data from a database or electronic record system does not constitute creating a new record. See 950 CMR 32.07(1)(f). Printing these records from a database or electronic system, redacting them with a marker, and then re-scanning them, is generally not consistent with these regulations; this process provides the digital records neither in the preferred form nor in a “searchable machine-readable form.” 950 CMR 32.04(5)(d). If necessary, we welcome reasonable suggested modifications pursuant to 950 CMR 32.06(2)(g). Per Attorney Gen. v. Dist. Attorney for Plymouth Dist., 484 Mass. 260, 141 N.E.3d 429 (2020), compiling information from a database is not tantamount to creating a new record that would otherwise be precluded under public records law. Specifically: “Where public records are in electronic form, a public records request that requires a government entity to search its electronic database to extract requested data does not mean that the extracted data constitute the creation of a new record, which would not be required, under the public records law. " Id. at 442 to 443. Thus, we request that your department query its database and provide a response to the records request below.

1. A list of every field or type of data tracked in your electronic database (e.g. “Race”, “Date of Birth”, “date of admission”, etc.)

2. We request an extracted record in excel or other computer readable format of your data management system/case management system with line level data for the following fields for all people in your physical custody at some point in fiscal years 2018, 2019, 2020, and 2021 and who entered your custody between the ages of 18 years old and 20 years old and 364 days (ie prior to their 21st birthday) either pre-trial or sentenced:
- Date of admission
- Reason of admission (pre-trial, serving sentence, etc)
- Lead charge/most serious offense or its equivalent
- Date of Birth (or, if this is deemed to be information subject to an exemption, then please include month and year of birth (though not day))
- Date of release
- Length of stay
- Length of sentence (if applicable)
- Race
- Ethnicity
- Gender/sex
- Zipcode of home/last residence
- Sexual Orientation / Gender Identity
- Date(s) of disciplinary action taken, if any
- Type of disciplinary action taken, if any
- Days spent (or dates of admission to and release from) in Restrictive Housing, segregated housing unit or any other unit where an incarcerated individual stays in their room for a minimum of 21 hours.
- Whether the individual is/was housed in a specialized unit (such as the PEACE unit in Suffolk or PACT in Middlesex) as applicable.

3. Average annual cost of HOC incarceration for an 18-, 19-, and 20-year-old, separated by the costs of pre-trial detention and sentenced. If there are special units associated with this age group, please break down costs for general population and the special units.

4. Cost of one day in restrictive housing or when individuals are held for 21 hours or more.

Thank you for considering our request. We look forward to hearing back from you and working with you. We are available to answer any questions regarding this data request or our work. We can be reached by email through the address provided, or by phone at 617.338.1050.

Sincerely,

Joshua Dankoff
Director of Strategic Initiatives
Citizens for Juvenile Justice

Sana Fadel
Deputy Director
Citizens for Juvenile Justice

From: Plymouth County Sheriff's Department

Dear Mr. Dankoff and Ms. Fadel:

In response to your request, the Department estimates that an information technology professional would have to spend approximately 24 hours to gather the documents. As the Offender Management System (OMS) does not have a prebuilt report which joins all the requested data, our team would have to create custom code to generate the queries within Microsoft SQL (Standard Query Language) Server to return the dataset of offenders meeting the parameters as requested. Part of the work for creating the query code is researching the affected tables which contain the other datapoints requested (charges, sentencing, address for last residence, disciplinary history, etc.) as these datapoints are spread throughout the database schema. As this is a unique request, we do not have pre-existing code which we could reference in order to locate these datapoints. This research and testing the code as datapoints are included and tested is the bulk of the work. Once the various datapoints are located, the query codes would have to be combined in order to return the complete dataset as per the parameters of the request and continuous testing of the code would have to be performed in order to ensure data integrity and accuracy. Certain datapoints (disciplinary history, restrictive housing, and case/charge information) may have to be separated from the bulk of the dataset which means separate query code would have to be created for the affected result sets. With regards to the “Lead charge/most serious offense or its equivalent” portion of the request, a member of the team will have to manually sift through the resulting dataset and remove any extraneous records from the dataset. If you would like us to proceed with gathering the data, please send a check payable to the Plymouth County Sheriff’s Department in the amount of $1000 (20hrs x $50). The Department has not assessed a fee for the first four hours of work, and the actual hourly rate of the employer is higher than $50. This is a good faith estimate of the amount of work necessary to comply with your request. Once the Department commences the work of gathering the data, it will assess additional cost if the work takes longer or issue a partial refund if the work takes less time.

The Department does not have records within its possession, custody, or control which calculate annual costs for inmates in certain age categories or daily cost for inmates in special management units. The Facility does not have restrictive housing units.

You have the right to appeal this determination to the supervisor of public records, pursuant to 950 C.M.R. 32.00 and M.G.L. c. 66 §10A(a) and to seek judicial review pursuant to M.G.L. c. 66 §10A(c).

Patrick C. Lee
General Counsel
Plymouth County Sheriff’s Department
24 Long Pond Road
Plymouth, MA 02360
508-830-6287
508-830-6234(f)
plee@pcsdma.org

From: Joshua Dankoff

Dear Mr. Lee,

Thank you for speaking with me earlier and for agreeing to follow up with your IT department. As discussed, the estimated time to extract data from 16 fields seems quite high. Indeed, I have attached an excel document containing the column headings for responses we have received so far from other counties' HOCs, all of which were produced under 4 hours of staff time. While each one is differently worded/ordered, all of these replies provided sufficient records in response to the request. I am hopeful that this helps guide your data team in extracting data in a time efficient manner.

Thank you again and I look forward to hearing back from you.

Best,
Josh

From: Plymouth County Sheriff's Department

I got something in the mail from you, but there were no spreadsheets attached.

From: Plymouth County Sheriff's Department

In response to your request, the Department provides the attached records.

You have the right to appeal this determination to the supervisor of public records, pursuant to 950 C.M.R. 32.00 and M.G.L. c. 66 §10A(a) and to seek judicial review pursuant to M.G.L. c. 66 §10A(c). You have the right to appeal this determination to the supervisor of public records, pursuant to 950 C.M.R. 32.00 and M.G.L. c. 66 §10A(a) and to seek judicial review pursuant to M.G.L. c. 66 §10A(c).

Patrick C. Lee
General Counsel
Plymouth County Sheriff’s Department
24 Long Pond Road
Plymouth, MA 02360
508-830-6287
508-830-6234(f)
plee@pcsdma.org

Files