Hawaii DOCARE police roster 2023-3-3

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 current or former sworn employee of the Hawaii DOCARE, 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, if applicable
Reason for separation, if applicable

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

Hello

The timeframe we're seeking is as far back as electronic data are maintained. We are not asking the agency to go through paper records.

The MuckRock platform doesn't allow me to see what is highlighted. Could you send the list of data points you can and can't receive with some other notation than highlighting?

Thank you

Hello

Thanks for this file. Can you clarify which officers it contains information for? Is this only current officers, or former officers too?

Thanks

Sam

Hello

I'd like to follow up on this question.

If it is only current officers, is there a legal reason why previous officers were not provided?

Thanks

Sam

Hi Dan

Thanks for this response. Just to clarify, there is no data held by DOCARE HR, or the finance/payroll department that might show some information about former employees?

Sam