Honolulu police roster 2023-11-2

Sam Stecklow filed this request with the Honolulu Police Department of Honolulu, HI.
Status
Completed

From: Sam Stecklow

To Whom It May Concern:

This is a public records request made via MuckRock under the Hawaii Uniform Information Practices Act, seeking records related to law enforcement officer employment rosters in this state.

This request is brought by Big Local News along with a collaboration of news organizations, including ABC News, KQED, MuckRock, the Invisible Institute and other news organizations. Big Local News is a program of Stanford University’s Journalism and Democracy Initiative and helps journalists collect, process and analyze public data.

We are seeking any datasets, databases, and/or spreadsheets sufficient to show the following information regarding every *former* sworn employee of the Honolulu Police Department, year-by-year, dating back however far as the data exist for:

First name
Middle name or initial
Last name
Unique employee identification number
Star or badge number
Race
Gender
Year of birth
Rank
Troop assignment
Unit assignment
Division assignment (Patrol, Investigations, Support, etc.)
Hire date
Separation date
Reason for separation

If your certification/roster system contains data elements not listed above, please include them in the response, provided they are releasable under the law. On the other hand, we recognize some of the information we are asking for may not be tracked by your system. If that is the case, we are willing to accept as many of the data elements as your agency maintains. If some records are more readily available, we are happy to receive partial information as soon as possible while the remaining request is processed.

In addition to the data elements listed, we request documentation necessary to understand and interpret the data, including but not limited to record layouts, data dictionaries, code sheets, lookup tables, etc.

Our preference is to receive structured data provided in a machine-readable text file, such as delimited or fixed-width formats. We can also handle a variety of other data formats including SQL databases, Excel workbooks and MS Access. If there are additional formats your agency would prefer to provide, please let us know.

We are seeking this information as a news media organization on a matter of public interest concerning the conduct of government. As such, we ask for a waiver of all fees, if allowed under state law. If fees are necessary to reimburse the agency for actual costs, we agree to pay up to $100. If costs exceed that amount, please let us know before fulfilling the request.

Please send clarifications and questions via electronic communication at any time. Thank you very much for your time and attention to this request.

Sam Stecklow
Journalist
Invisible Institute

From: Honolulu Police Department

Hi Sam,

The HPD does not maintain a database or spreadsheet containing information on every former sworn employee of the Honolulu Police Department.

Take care,
Sarah

From: Sam Stecklow

Hello Sarah

I understand that not *every* former employee of the HPD would be present in its data, but my request seeks whatever data exists about the former employees who *are* present. Are you asserting any kind of exemption over this data?

Sam

From: Honolulu Police Department

Hi Sam,

The HPD does not maintain a database or spreadsheet with information for all former employees. The information for an estimated 10,000 employees are or were kept on individual cards. Each card would need to be manually reviewed and the data retrieved. If you would like an estimated fee to retrieve the information requested, we can provide that.

Take care,
Sarah

From: Sam Stecklow

Hello Sarah

I simply do not believe that the only information about ANY former employees is only kept on paper cards. I am asking for the electronic data that exist about former employees. Not all former employees - the ones who are present in the electronic data that do exist and are subject to the UIPA.

Please let me know if I can clarify any further.

Sam Stecklow

From: Honolulu Police Department

Hi Sam,

We are able to provide some information on approximately half of the estimated 10,000 former employees. The information would be similar to the data that was provided to you in July. Please let us know if you would like the same data for our former employees.

Please note that the data will not include the separation date and reason for separation as that information is not readily exportable and must be manually retrieved. If you would like an estimated fee to retrieve the additional information, please let us know.

Sarah

From: Sam Stecklow

Hi Sarah, thanks

Just to clarify, we would receive a list of former officers and when they were hired, but no information about when they would have left HPD?

From: Honolulu Police Department

Yes. The database will not include the separation date and the reason for separation because this information is not readily exportable and must be manually retrieved.

From: Sam Stecklow

Understood. I will accept this file without additional information at this time.

Thank you

From: Honolulu Police Department

Hi Sam,

Please see the attached PDF.

Take care,
Sarah