Los Angeles Police Department
https://lacity.nextrequest.com/requests/23-2867
March 2022 Open Data PAYROLL LIST
SERIAL can be roughly tied to Hire Date in the table above, more specifically in the actual data – often to a specific date of Hire, even when it’s absent (retired) itself.
If the RANGES of serials are pivoted by segment, we see some reserved ranges fall out of the data sets that are published to other Agencies for their work.
Those reserved ranges – if they were issued to anyone with U/C Training, would keep them out of the published rosters by using math on the reports rather than a separate hotlist of who’s on / off the team at some moment or another in their career. Saving paperwork.
When Police Realize The List Needed Editing (Above)
It opens opportunities for MATH to become a friend of Transparency. The Headshots, Below: Note some editing needs done, to make it DATA that matches well enough to sort and compare.
https://publicrecordsourcerer.org/wp-content/uploads/2023/04/headshots.zip
The Problem is mostly picking the right ROSTER to compare.
AUGUST 2022 Roster (from open sources) gives a MUCH SHORTER LIST of potential names missing from the Published List vs the Photos Released. 200 Shorter!
Of 104 Rows, 96 contain unique SERIALS in the PIVOT view of Frequency.
Changes in Rank
Left LAPD Gangs and Narcotics and Dept entirely
Came in from OTHER UNITS in the 2019-2022 period. Not as many as went out.
Gang and Narcotics units in Seattle are used as backup protest patrol teams and often have high turnover after uprisings. This could be what’s happening in LAPD as well.
SAN FRANCISCO Area (MOTCO)
Public Record Sourcerer 
You must be logged in to post a comment.