Category Archives: Uncategorized

Parsing APO and FPO Zips

https://www.sos.wa.gov/elections/data-research/reports-data-and-statistics/washington-state-voter-registration-database-vrdb Zip Column Data Type TEXT Split on 5th Character Delete the ‘change data type’ and keep it Text (don’t convert BACK to text from numerical) Make sure to trim the dashes with a replace values, in the Zip4 field. Who’s Deployed in July 2025 according to the Open Source known as WA VRDB RememberContinue reading “Parsing APO and FPO Zips”

King County Jail

Open Data Sets can reveal who’s died in custody and who’s being written about in news stories – even when the custodial person is not named. https://komonews.com/news/local/man-dies-days-after-medical-emergency-at-downtown-seattle-jail-death-investigation-king-county-correctional-facility-warrants-arrest-harborview-medical-center-department-of-adult-and-juvenile-detention 2024-000189 Devon Arthur Hartman 1/5/2024 7:11 2024-000617 Josue David Rivas-Valdez 1/16/2024 20:17

State Patrol – The Washington State Fusion Center

The Washington State Fusion Center Originally called WAJAC – The Washington Joint Analytical Center – the WSFC was formed during the Global War on Terror between the middle 2000’s and 2010.  Washington State Patrol and its Organized Crime Intelligence Unit were the primary architects, and the Joint Terror Task Force of the FBI was eventuallyContinue reading “State Patrol – The Washington State Fusion Center”

Pierce County / Port of Tacoma

Public Records Document Dump: https://portoftacoma.nextrequest.com/documents Palestine Actions Nov 5, 6 2023 https://publicrecordsourcerer.org/wp-content/uploads/2023/12/tacoma_nov_8_2023_march_names_added_back.zip BEFORE THERE WAS AN ACTION – THE MILITARY REACHES OUT TO COORDINATE INTELLIGENCE (Email) FIRST BODY CAMERA METADATA OCTOBER – Nov 8 2023 (Names added back from March 2023 data table may not represent rank achieved by Nov 2023) Data from Vendor faulty saysContinue reading “Pierce County / Port of Tacoma”

Washington State Patrol / Public Records Unit

Gaslighting and bullying via doppel disclosures. When slowboating would not work well enough, one way to obscure the fact that disclosure is being simulated rather than practiced, is to send the same material as before, mixed in with new material. It LOOKS like you sent nine files but REALLY you sent four, plus five thatContinue reading “Washington State Patrol / Public Records Unit”