King County / Seattle Police

2011 Doug Larm network stretches to the Office of Nazi Drug Control Policy

2013 era Olympia Intel guy withheld / Active emails and who they involved show it was Seattle Police among others in King County who were primaries in the Communications

Those who WAGES data indicate left August – December 2022 (July Roster data shown)

This Calculation Probably Missed Some Surnames Because of how Suffixes are added in various sources

CRISIS Data indicates 2022 patrol but NONE in 2023 so far. Left? Went to a desk? Disabled? Unavailable? Retired? Discipline? Potentials are varied. https://publicrecordsourcerer.org/wp-content/uploads/2023/03/2022-seattle-patrol-officers-known-to-be-missing-from-2023-crisis-contacts-so-far-mar-2023-note.zip

Total PRA Failure / Fraud with public money (Wages / Salary) https://twitter.com/drimcalban/status/1627790680872439808

SEATTLE POLICE 2015 list WHERE ARE THEY 2022 (Zero? Gone) Also Updates Name, if known in 2022, and Unit in 2022, where that is still SPD.

The PseudoID numbers above are randomly chosen from each DATE on which an OIS occurred.

https://openoversight.tech-bloc-sea.dev/department/1 OFFSITE

Jan – September 2021 COBAN History for those that drive cars as a CSV file. Zipped.

A Directory: Dec 2021 Roster by Feb 26 2022 Terry Stops – Open Data (most Recent Terry Stop by DATE order of stop
BRADY LIST NOV 2021

The Brady List for King County as of Nov 2021 via Public Records

Multi Table 2021 and 2022 Seattle Police (WAGES – CRISIS – ROSTER) Extract
Lt of What – Feb 2021, Dec 2021 stacked for Reference
Dec 2021 Roster Who’s Intelligence (remaining)
Knowing What To Ask For is half the point of this site
Last Light: PRA Open Data flow stopped early Dec 7th 2021 through at least January 2022

Last Light: COBAN data flows came to an end in Early December 2021 as well.

Correlating databases without explicit keys (name variations) leads to incomplete lists in the aggregate

https://data.seattle.gov/City-Business/City-of-Seattle-Wage-Data/2khk-5ukd

Who Left Since July 31 2021 Roster (from Nov WAGES Date crosstab)

Coup Cops Clan OPA Report July 8 2021

January 2017 FITLIST data (found in a PRA in Summer 2021)

SERIALS (Work ID Numbers) Basics: Four digits, higher is more recently hired. Don’t call them Badge Numbers or stuff gets stupid really quickly. Ask for SERIALS.

Seattle Police Legal Department has a BAD LIST – if you get on it, they serialize your requests and then shout at you online on each request in once voice: We will now delay everything behind the slowest dribble we have for you as an individual.

If you think that you are offered a chance to re-prioritize those requests – as they wrote in their email, well – NOPE.

They set the pace, they set the order. Once they figure out that you’re splitting brooms on them. After all, they have to help everyone like the Leg said they have to. This is HELPING.

This is a MENDACITY BAT, a blow to the head delivered by a liar with a keyboard.
“If you would like to re-prioritize your requests please let me know…”

DROP Roster July 1 2021

Roster July 31 2021

AS WORKED: Derived from Open Data in June 2021

As revealed in ROSTERS (Public Records Act request) June 2021

Left in June 2021
New Hires in June 2021

That file is sparse but it tells you which Serials worked which BEATS in 2021 to date, so far.

When you compare that to the Pseudo ID numbers on the Use of Force open data that list will limit whose hours to study and whose to ignore for that “Open Data” (obscured partial view).

FIT LIST Tables 2014 – 2015 era (still known going on, just harder to get intact attachments)

Historical indexes and GETEM March 2021 list – Regional not just SPD

June 7 2020 Incident Action Plans – Redacted phones (The day they abandon the East Precinct Building for a month)

Community Response Group emails – one lonely installment before they Sequenced all the requests into one chain.

The COBAN User field and FileName are not the same as might first appear when browsing the raw data.

If you split File Name into its four digits before the @ and the sequence after (keep both as TEXT data types) you can pivot the tables to show you who’s supervising whom in the Department. Sergeants will have a few Serials they review. Some OPA members and IT people will “supervise” dozens or hundreds depending on the length of time observed.

COBAN June 2021 Who Supervised Whom So Far this year.

The Political Nature of the Police of the Capitol of Capital for a Region. It’s not just nominal power but financial imperatives which assign decision roles in Washington State.

CRG Emails Kraus Installment One Oct 2020 era founding records

Knowing HOW to ask for aggregate figures directly is important
Fingerprint Scanning for CRG to use on protest arrests
Asks for Shifts are the best include lists to have for TEAMS at a moment in time
Vehicle Deconfliction
Briar Patch Location
Status of Bikes Email Noun for later PRA RQ

2021 to date CRISIS CALLS by Day of Month and BEAT through June
CRG in the City on an organized field trip known as a SHIFT
The SPOG President maintains dignity online for his Members

https://dsl.richmond.edu/panorama/redlining/#loc=13/47.571/-122.381&city=seattle-wa
COBAN data hole illustrated in the Data Lens version of the database
EXAMPLE RECORD – NOT ASSOCIATED WITH ANY ADJACENT PICTURES

Another Federalized Responsibility Attaches to the Country famous for prohibiting quartering of troops
January 6th 2021 Fallout – Proud Boys FBI JTTF Seattle attentions
Case Number Threads
Coup Cops Clan Attorneys
Don’t get too excited – this is a professional relationship and she’s a renter
The kind of Open Records that actually work day in and day out without nonsense or charges

.

https://publicrecordsourcerer.org/wp-content/uploads/2023/05/wages-q1-2023-seattle-csv-zip.zip

Published by publicrecordsourcerer

TTP WA PRA INCL SNARK (July 2020 - Irondale) Hobbyfarm Curmudgeon Infests PT Bedroom Community, Terrorizing dozens. Well, a few ppl we heard of. Or maybe three teens from Philly, and a vocoder and a good script. Who cares, it's CONTENT! PUBLISH!