Request #19-5033
  Closed

This letter is to request access to records in the possession of the Los Angeles Police Department and the City Manager’s Office for the purpose of inspection and copying pursuant to the California Public Records Act (Government Code Section 6250 et seq.).

 

Please provide me an electronic copy of the Los Angeles Police Department data contained in your agency’s payroll records database collected from January 1 to December 31 from the years of 2010 to 2019. I have already accessed the payroll data from this link that was sent to me by the City Administrative Office http://lacity.payroll.finance.socrata.com/#!/year/2018

But I am requesting additional fields. I would like to receive the corresponding names and gender to the officers's ID numbers.  

I ask that this data be provided in a machine-readable format such as a Microsoft Excel file, a text file or a Microsoft Access file.

I would also request a copy of the record layout of the database and a data dictionary to help interpret the information in the database.

Section 6253.9 of the Act requires “a public agency to make the record available in any electronic format in which it holds the information and authorizes the agency to charge the public for the direct cost of duplicating the record.” As these data were generated by a machine reading process, it is evident that such a record exists.

If you determine that an express provision of law exists to exempt from disclosure all or a portion of the material I have requested, Government Code Section 6256 requires notification to me of the reasons for the determination not later than 10 days from your receipt of this request.

Government Code Section 6256.2 prohibits the use of the 10-day period, or any provisions of the Public Records Act “to delay access for purposes of inspecting public records.”

Thank you for your timely attention to my request.

 

Sincerely,

 

 

BULBUL RAJAGOPAL

URBAN AFFAIRS REPORTER

ANNENBERG MEDIA

(425) 598-4648

bulbulra@usc.edu


Received

September 9, 2019 via web


Departments

Controller

Documents

Public

(loading...)

Staff

Point of Contact

Kevin Mcneely (Controller)

Request Closed Public

Revised spreadsheets containing the requested additional fields have been sent to the requester.

 
October 30, 2019, 10:50am
Document(s) Released Public
LAPD Payroll Data for CY2018 V2_Rajagopal CPRA19-5033.csv
October 30, 2019, 10:47am
Document(s) Released Public
LAPD Payroll Data for CY2017 V2_Rajagopal CPRA19-5033.csv
October 30, 2019, 10:47am
Document(s) Released Public
LAPD Payroll Data for CY2016 V2_Rajagopal CPRA19-5033.csv
October 30, 2019, 10:47am
External Message   Hide Public

Dear Mr. Rajagopal:

 

This letter is in response to your letter dated October 10, 2019, regarding:

 

  • I am requesting to revise the data set. I am requesting for the fields of 'race', 'hire date' and 'serial/badge number' to be added. Please let me know if this can be arranged.

 

Responsive to your request, please find the attached three spreadsheets. 

 

Please be advised that under Government Code sections 6254(c) and 6255, a small subset of the hire date field is listed as 1/1/1900 to ensure the privacy of undercover officers.

 

Thank you.

 

Kevin McNeely

Senior Management Analyst II

Office of the Controller

October 30, 2019, 10:47am by Kevin Mcneely (Controller), Sr. Management Analyst II (Staff)
External Message   Hide Public

Dear Mr. Rajagopal:

 

This letter is in response to your letter dated October 10, 2019, regarding:

 

  • I am requesting to revise the data set. I am requesting for the fields of 'race', 'hire date' and 'serial/badge number' to be added. Please let me know if this can be arranged.

 

Please be advised that a revised dataset with the requested additional fields will be ready on or before October 30, 2019.

 

Thank you.

 

Kevin McNeely

Senior Management Analyst II

Office of the Controller

October 11, 2019, 9:13am by Kevin Mcneely (Controller), Sr. Management Analyst II (Staff)
Due Date Changed Public
10/30/2019 (was 09/27/2019). Additional time necessary to add three requested fields to the spreadsheet.
October 11, 2019, 9:12am
Request Reopened Public
October 11, 2019, 9:12am
Request Closed Public
LAPD payroll data was produced. 
September 25, 2019, 8:39am
Request Published Public
September 24, 2019, 4:15pm
Document(s) Released to Requester Public
LAPD Payroll Data for CY2018_Rajagopal CPRA19-5033.csv
September 24, 2019, 4:15pm
Document(s) Released to Requester Public
LAPD Payroll Data for CY2017_Rajagopal CPRA19-5033.csv
September 24, 2019, 4:14pm
Document(s) Released to Requester Public
LAPD Payroll Data for CY2016_Rajagopal CPRA19-5033.csv
September 24, 2019, 4:14pm
Due Date Changed Public
09/27/2019 (was 09/19/2019). Extra time is required to extract and save a voluminous amount of data.
September 11, 2019, 9:39am
Department Assignment Public
Controller
September 9, 2019, 9:33am
Request Opened Public
Request received via web
September 9, 2019, 9:33am