Desert Hot Springs is a city in the Coachella Valley in Riverside County, California. About 32,500 people lived there at the 2020 census. We loaded two sets of Flock audit records from the Desert Hot Springs Police Department. The network audit lists searches by any agency that reached Desert Hot Springs cameras, from August 1, 2021 through September 23, 2026. The org audit lists searches run by Desert Hot Springs Flock users, from March 1 through September 23, 2026. All times below are Pacific time. Thanks to DHS Concerned Citizen for obtaining and sharing these records.
#Network audit metrics
- Type: Network audit
- Timespan: Aug 1, 2021 – Sep 23, 2026 (1,880 days; Jul 31 and Aug 31, 2026 not covered)
- Records: 13,593,476
- Organizations (network): 389
- Search types: lookup (5,604,270), search (4,795,148), lookup - Mobile (2,477,089), search - Mobile (657,017), convoy (56,004), and eight other types with 3,948 records combined
- Operator name: redacted on 13,593,476 records
- License plate: redacted on 11,566,958 records; blank on 2,026,518
- Case #: redacted on 4,731,777 records; blank on 8,861,699
- Filters: redacted on 3,363,524 records; blank on 10,229,952
- Reason: blank on 25,408 records
The agency marked redactions with ***. It redacted the operator name on all records, including the 68,921 searches its own Flock users ran. The median network search covered 599 networks. 18.8% covered 1,000 networks or more.
The first record is from 11:15 a.m. on August 4, 2021. No records fall on August 5–17, 2021. The record count includes one record from 12:00 a.m. on July 31, 2026 and 11 records from the first minute of September 24, 2026.
#Org audit metrics
- Type: Organization audit
- Timespan: Mar 1 – Sep 23, 2026 (207 days; Apr 30, May 31, Jun 30, Jul 31, and Aug 31 not covered; Mar 31 covered until 3:30 a.m.)
- Records: 12,227
- Search types: lookup (7,392), lookup - Mobile (2,717), search (1,768), search - Mobile (349), searchSummary - Mobile (1)
- License plate: not included
- Filters: not included
- Case # present: 2,277 (18.6%)
- Reason: blank on 23 records
The org audit files keep the License Plate and Filters headers, but every cell under them is empty. The org name on all records is Desert Hot Springs CA PD. 12,121 of the 12,227 org audit IDs also appear in the network audit.
Case numbers start on July 29, 2026. Before that date, two records carry one. From July 29 on, 2,275 of 2,277 records carry one. The reasons change on the same date. Through July 27, 6,277 reasons take the form “Category - detail”, and the detail is often a report number. No reason after that date contains " - ".
The median org search covered 428 networks. 2,129 searches covered one network. None covered 1,000 or more.
The bars show network audit searches per week. The line shows org audit searches per week. Weeks start on Monday. The chart runs from the week of August 2, 2021 to the week of September 14, 2026. It leaves a week blank when the files do not cover every day of that week. It counts each record ID once.
#Agencies using Desert Hot Springs’s network
7 organizations searched the network in 2021 and 14 in 2022. 202 did in 2023, 306 in 2024, and 353 in 2025. Before October 2023, 19 organizations had searched it. 15 of them are in Riverside or San Bernardino County. On October 26, 2023, 49 organizations searched it for the first time. Monthly searches rose from 35,993 in September 2023 to between 399,512 and 568,839 in each month from January 2025 through June 2026.
Houston TX PD is the only police agency outside California in the network audit. It ran 954,531 searches between January 10, 2024 and September 30, 2025. That is 7.0% of all records. It ran between 29,646 and 74,974 searches each month in that span. No Houston search appears after September 30, 2025.
The “[Federal] US Postal Inspection Service” account ran 203 searches between May 31 and June 6, 2023. An account named “Decommissioned Org” ran 1,069 searches between November 8, 2023 and April 2, 2024. Two Flock accounts, “Flock RTCC” and “Flock Safety - Admins”, ran four.
Desert Hot Springs CA PD ranks 45th with 68,921 searches.
| Agency | Count | % |
|---|---|---|
| Riverside County CA SO | 1,570,752 | 11.6% |
| Houston TX PD | 954,531 | 7.0% |
| California Highway Patrol | 855,585 | 6.3% |
| San Francisco CA PD | 742,087 | 5.5% |
| Orange County SO CA | 548,335 | 4.0% |
| Los Angeles CA PD | 447,833 | 3.3% |
| NCRIC | 306,744 | 2.3% |
| Los Angeles County CA SD | 300,389 | 2.2% |
| San Bernardino County CA SO | 268,416 | 2.0% |
| Alameda County CA SO | 199,075 | 1.5% |
| City of Riverside CA PD | 187,360 | 1.4% |
| Oakland CA PD | 174,050 | 1.3% |
| San Diego County CA SD | 163,285 | 1.2% |
| San Diego CA PD | 144,049 | 1.1% |
| Ontario CA PD | 142,929 | 1.1% |
| Other (374 agencies) | 6,588,056 | 48.5% |
#Search types
#Network audit
| Type | Count | % |
|---|---|---|
| lookup | 5,604,270 | 41.2% |
| search | 4,795,148 | 35.3% |
| lookup - Mobile | 2,477,089 | 18.2% |
| search - Mobile | 657,017 | 4.8% |
| convoy | 56,004 | 0.4% |
| visual | 2,497 | <0.1% |
| searchSummary - Mobile | 703 | <0.1% |
| freeform | 369 | <0.1% |
| multiGeo | 328 | <0.1% |
| freeform - Mobile | 14 | <0.1% |
| mostSeenOcrValues | 14 | <0.1% |
| visual - Mobile | 13 | <0.1% |
| apiV1 | 10 | <0.1% |
#Org audit
| Type | Count | % |
|---|---|---|
| lookup | 7,392 | 60.5% |
| lookup - Mobile | 2,717 | 22.2% |
| search | 1,768 | 14.5% |
| search - Mobile | 349 | 2.9% |
| searchSummary - Mobile | 1 | <0.1% |
#Top operators
39 Flock users ran searches in the org audit. Three ran 51.4% of them: Dawne Byers (2,428), Leslie Abelon (2,249), and Cregg Corona (1,603).
| Name | Count | % |
|---|---|---|
| Dawne Byers | 2,428 | 19.9% |
| Leslie Abelon | 2,249 | 18.4% |
| Cregg Corona | 1,603 | 13.1% |
| Tania Toscano | 790 | 6.5% |
| June Casey | 707 | 5.8% |
| George Bailey | 641 | 5.2% |
| Joshua Olsen | 498 | 4.1% |
| Amy Burningham | 421 | 3.4% |
| Monica Sifuentes | 353 | 2.9% |
| Shawn Longueira | 279 | 2.3% |
| Matthew Henry | 264 | 2.2% |
| Anabel Terrazas | 233 | 1.9% |
| Greg Elias | 194 | 1.6% |
| Chris James | 191 | 1.6% |
| Megan Miller | 173 | 1.4% |
| Other (24 operators) | 1,203 | 9.8% |
#Reasons
#Org audit
This table groups org reasons by the text before the first " - ". The org audit holds 708 distinct reasons in 49 groups, ignoring capitalization.
| Reason group | Count | % |
|---|---|---|
| Assault/Battery Offenses | 1,806 | 14.8% |
| Motor Vehicle Theft/Stolen | 1,522 | 12.4% |
| Drugs/Narcotics | 886 | 7.2% |
| Stolen Property Offenses | 833 | 6.8% |
| Traffic Infraction | 819 | 6.7% |
| Wanted Person (Arrest Warrant/Fugitive) | 771 | 6.3% |
| Weapons Offense (Guns/Shots Fired) | 724 | 5.9% |
| Burglary/Breaking & Entering | 684 | 5.6% |
| Hit and Run/Car Accident | 587 | 4.8% |
| Assault/Battery Offenses (Domestic) | 570 | 4.7% |
| Larceny/Theft Offenses | 495 | 4.0% |
| Welfare Check | 472 | 3.9% |
| Alcohol Offenses (Non-DUI) | 406 | 3.3% |
| Criminal Motor Vehicle Offense (incl. Road Rage/Reckless) | 219 | 1.8% |
| Child Abuse/Neglect | 194 | 1.6% |
| Other (34 groups and 23 blank) | 1,239 | 10.1% |
#Network audit
The network audit holds 592,325 distinct reasons, ignoring capitalization. Several of the top reasons are bare California code sections: Vehicle Code 10851 (vehicle theft) and Penal Code 459 (burglary), 211 (robbery), and 503 (embezzlement). Others are a category with an empty detail, such as “drugs/narcotics -”.
| Reason | Count | % |
|---|---|---|
| inv | 598,382 | 4.4% |
| investigation | 408,803 | 3.0% |
| 10851 | 301,939 | 2.2% |
| stolen | 169,470 | 1.2% |
| motor vehicle theft/stolen - | 164,663 | 1.2% |
| invest | 120,122 | 0.9% |
| 459 | 114,978 | 0.8% |
| drugs/narcotics - | 109,502 | 0.8% |
| motor vehicle theft/stolen | 106,554 | 0.8% |
| larceny/theft offenses - | 100,203 | 0.7% |
| 211 | 84,620 | 0.6% |
| wanted person (arrest warrant/fugitive) - | 83,799 | 0.6% |
| warrant | 81,486 | 0.6% |
| suspect | 75,145 | 0.6% |
| 503 | 72,844 | 0.5% |
| Other (including 25,408 blank) | 11,000,966 | 80.9% |
#Report highlights
#Immigration
1,841 network records from 46 agencies match the immigration report’s terms. Many of them do not refer to immigration. “DHS” is a common short form of Desert Hot Springs, as in “DHS PD” (110 records) and “DHS 187”. Other false matches include “Tracker removal”, “southbound”, and “Wanted sexual predator from San Diego”. The org audit has no matches.
Houston TX PD gave “immigration” as the reason 121 times between January 23 and March 4, 2025. The forms include “Immigration”, “IMMIGRATION”, and “immigration enforcement”.
California Highway Patrol entered 425 reasons that name Stonegarden between December 23, 2024 and July 25, 2025. Most are numbered “interdiction log” entries. Five other agencies entered 70 more. Operation Stonegarden is a Department of Homeland Security grant program that funds state and local police work on border security.
Seven agencies named CBP in 152 records. San Diego County CA SD entered 99 of them between January 7 and May 7, 2025.
The report’s terms do not include “HSI”, the short name of Homeland Security Investigations. HSI appears in 3,479 network reasons from 50 agencies. Menifee CA PD entered 1,953 of them between November 2, 2021 and August 16, 2025. Most read “HSI inv” or cite HSI narcotics cases.
Anaheim CA PD gave the bare reason “ICE” 14 times on June 12, 2025. “Ice” is also slang for methamphetamine, and a one-word reason does not show which meaning the operator intended.
#First Amendment
1,628 network records from 76 agencies match the report’s terms. Many cite churches, video, or the city of Temple City. 165 records from 14 agencies contain the word “protest”. The org audit has no matches.
- On June 14, 2025, the day of the nationwide “No Kings” protests, Riverside County CA SO ran 46 searches with reasons such as “pprotest”, “city protests”, and “cat city protests”. The same day, Anaheim CA PD gave “gene autry protest” 9 times, Daly City CA PD gave “SF PROTEST” 5 times, and San Bernardino County CA SO gave “no king” once.
- San Bernardino County CA SO gave “ICE PROTEST” twice on June 9, 2025.
- Escondido CA PD ran 28 searches citing a protest on February 2, 2025. 22 gave “2/2/25 Protest ATI Vehicle” and 3 gave “Immigration Protest”.
- Irvine CA PD gave “veh seen at protest” 19 times on February 7, 2026.
- California Highway Patrol gave “DXE Operation 25-454” 43 times on May 27, 2025. Merced County CA SO gave “DXE activity” twice on May 6, 2025. DxE is the short name of the animal rights group Direct Action Everywhere. The reasons do not say whether they refer to it.
- Orange County (CA) DA Office cited election or voter fraud 98 times between January 14 and September 8, 2026.
#Develop your own probable cause
1,850 network records from 57 agencies match the report’s terms. Houston TX PD entered 549, Santa Clara CA PD 387, and San Mateo CA PD 241. San Mateo CA PD gave one reason 234 times between February 21 and February 23, 2024: “Develop PC to conduct ID stop, use Officer Safety as firearm is outstanding.” Some matches cite a Penal Code section, as in “wanted felon for PC 422”, and do not ask operators to develop probable cause. The org audit has no matches.
#Low-level offenses
200 org records match the report’s terms. 119 cite disorderly conduct, 71 trespass, 9 illegal dumping or littering, and 1 curfew, loitering, or vagrancy. In the network audit, 40,405 records from 293 agencies match.
#Profiling
10,547 network records from 117 agencies match the report’s terms. Most cite gangs. Los Angeles CA PD entered 2,715 and Houston TX PD 1,863. The org audit has no matches.
#How we processed the files
We changed no file. Each staged CSV is a byte-for-byte copy of a released file under its released name. We left one released network file out because a later file holds every one of its records.
#Extraction
The files arrived in zip archives. We extracted every member with Python 3.12.15’s zipfile module, reading and writing raw bytes. The archives hold no folders, so no file was renamed or flattened. To check the result, we ran the same extraction into a separate folder and compared SHA-256 hashes for all 93 files. They matched.
#Files left out
“7_1_2026-7_6_2026-Desert Hot Springs CA PD-Network-Audit.csv.” This file holds 83,790 rows from July 1 through 12:42 p.m. on July 6, 2026. All 83,790 IDs also appear in “July 2026 NETWORK - 7_1_2026-7_31_2026-Desert Hot Springs CA PD-Network-Audit.csv”. The July file holds no other rows in that time span. 47,605 of the shared rows match in every field. The other 36,185 differ in Reason, Org Name, or both:
- In 33,626 rows, the reason in the July 1–6 file ends with " - " and the July file’s does not, as in "Robbery - " and “Robbery”.
- In 5,092 rows, the org name differs. In 3,163, it differs only by a leading or trailing space, as in "City of Riverside CA PD " (1,952). In the rest, the name itself differs: “San Diego County CA SD” and “San Diego County CA SO” (1,504), “Sacramento CA PD” and “Sacramento CA PD [Inactive]” (319), “Town of Los Gatos CA” and “Los Gatos CA” (95), and two smaller pairs.
The import step hashes every field except the ID, so importing both files would load most of the 36,185 rows twice. We kept the July file whole and did not import the July 1–6 file. This keeps the July file’s version of all 83,790 rows, so July, August, and September 2026 come from one export. The network files through June 2026 keep the trailing " - " form. The June 2026 file has it on 226,758 rows. The July, August, and September files have it on none.
#Staged CSVs
Row counts exclude the header. The 68 network files hold 13,609,025 rows.
| File | Rows | Bytes | SHA-256 |
|---|---|---|---|
| 8_1_2021-8_31_2021-Desert Hot Springs CA PD-Network-Audit.csv | 710 | 125,813 | a3e7633516017fd49f11a7c7752eacffc93e5e0a0a3d57beb50eb8958ba4d318 |
| 9_1_2021-9_30_2021-Desert Hot Springs CA PD-Network-Audit.csv | 3,900 | 659,616 | 40ca4b61274859bc4d205169567e64176ce8341e1dc0a5be6ed2c9c9c87f057b |
| 10_1_2021-10_31_2021-Desert Hot Springs CA PD-Network-Audit.csv | 5,809 | 1,017,165 | 5284070b4fda9c80fc4090a52739f6715d32b029d0ba4fdd1423c97da2c3819d |
| 11_1_2021-11_30_2021-Desert Hot Springs CA PD-Network-Audit.csv | 8,758 | 1,538,192 | 3689e58fc02426089d770d98179c6f1ab4ec6d9f323aedeef57b56eff569c280 |
| 12_1_2021-12_31_2021-Desert Hot Springs CA PD-Network-Audit.csv | 12,482 | 2,183,924 | 128d2ef61437c908209225867db232a1a2c47e7de72c48e88da9d7f4a44ed7d0 |
| 1_1_2022-1_31_2022-Desert Hot Springs CA PD-Network-Audit.csv | 11,657 | 2,048,409 | 87d020e554188552eceac2912ac728a3efd570dc24fd66dc79b6e588ab136069 |
| 2_1_2022-2_28_2022-Desert Hot Springs CA PD-Network-Audit.csv | 12,378 | 2,177,764 | 3da7ea56caa35c0f2e17828b2519191e8816f4d0ff97b121f7302d521115c234 |
| 3_1_2022-3_31_2022-Desert Hot Springs CA PD-Network-Audit.csv | 18,414 | 3,243,526 | 1842b426e5f8902877bc86c4ee12245ac0f3d78a6bc496706e4442ec1e0d1555 |
| 4_1_2022-4_30_2022-Desert Hot Springs CA PD-Network-Audit.csv | 20,208 | 3,557,522 | af9200f830b8d17e5d6fce83374daccd7294340cd84d10d4db75c44d2aa40391 |
| 5_1_2022-5_31_2022-Desert Hot Springs CA PD-Network-Audit.csv | 22,903 | 4,028,110 | 1e2ec230e8eead35a559576c4d20bb1be89d6b189c570d978be904a81dda1da4 |
| 6_1_2022-6_30_2022-Desert Hot Springs CA PD-Network-Audit.csv | 21,518 | 3,767,335 | 0a58f9bf70ed7fc599fb32009f687ffee67551430b605a7233123f4f1a7f9a7a |
| 7_1_2022-7_31_2022-Desert Hot Springs CA PD-Network-Audit.csv | 20,474 | 3,580,744 | 52131615b4ad24cb105a7dbeff75f04ff2d7592c9584badca65a178423509af2 |
| 8_1_2022-8_31_2022-Desert Hot Springs CA PD-Network-Audit.csv | 29,922 | 5,233,330 | 15ed9d1002b3a84ec6385d4628cfedff1bf878ebae4350f23afc9b3363c554f5 |
| 9_1_2022-9_30_2022-Desert Hot Springs CA PD-Network-Audit.csv | 33,014 | 5,811,481 | bf36b40ad97a3d73df83fb2a8251cd93f846680ce2bc928bf2188a86a1cada25 |
| 10_1_2022-10_31_2022-Desert Hot Springs CA PD-Network-Audit.csv | 27,965 | 4,911,627 | 78f956cfabe917675f40e32121d3eef21bbeaf99a3a5fa645c8943a6c20a9da8 |
| 11_1_2022-11_30_2022-Desert Hot Springs CA PD-Network-Audit.csv | 25,549 | 4,472,739 | 891b5e2ccfd996bb2f66db26e62bc2f4adba696d6b61691a4ea70a9c54e37fc9 |
| 12_1_2022-12_31_2022-Desert Hot Springs CA PD-Network-Audit.csv | 32,132 | 5,632,757 | 0bde1147a29840b5513a46de6699874ce7dbd3acde62d802cc5067480f2c262a |
| 1_1_2023-1_31_2023-Desert Hot Springs CA PD-Network-Audit.csv | 29,455 | 5,218,319 | f7f2fe165724e958a57f6016c293aea790c8fa07b09540f7faa566680adf1b9a |
| 2_1_2023-2_28_2023-Desert Hot Springs CA PD-Network-Audit.csv | 31,448 | 5,580,684 | 46c9c81477ffaba22062c0e2aba5810566ad035fa5daafe126e9188da3c8f539 |
| 3_1_2023-3_31_2023-Desert Hot Springs CA PD-Network-Audit.csv | 41,953 | 7,424,654 | 1d6580a571ff2bef959afb0e38eaf7c1b2ddab29232a18cc538c04c90415cd9e |
| 4_1_2023-4_30_2023-Desert Hot Springs CA PD-Network-Audit.csv | 31,707 | 5,643,323 | 4e7e42b2103392e4cdef00e82b2c131b717b22d85c0ad3be14c213b709a88a9d |
| 5_1_2023-5_31_2023-Desert Hot Springs CA PD-Network-Audit.csv | 34,681 | 6,150,345 | e8ee65d83c1112d1a9a6a86205c5210cf6d6f828b55b33a0dd4325a78fcc5175 |
| 6_1_2023-6_30_2023-Desert Hot Springs CA PD-Network-Audit.csv | 32,703 | 5,801,365 | 6350eee0350b7b4b6bde566dfeb8f687baf1ddf9bb5eaf4f6d6ac4db3e1ef97a |
| 7_1_2023-7_31_2023-Desert Hot Springs CA PD-Network-Audit.csv | 33,243 | 5,893,264 | b9ab6c347d096462452c3adf9933138a2868fd4744c5b4b5700e217a50e6abb4 |
| 8_1_2023-8_31_2023-Desert Hot Springs CA PD-Network-Audit.csv | 40,743 | 7,235,851 | 0780a0a95a34e2467dedd3d7e0686fc4233f8a2a7326848434fa58921ad16eb2 |
| 9_1_2023-9_30_2023-Desert Hot Springs CA PD-Network-Audit.csv | 35,993 | 6,386,452 | f5d9ae6e02c5650197616f56ac5a196e0edcbbe9e255a51937cfbfa0dbc249bc |
| 10_1_2023-10_31_2023-Desert Hot Springs CA PD-Network-Audit (1).csv | 38,236 | 6,812,185 | eaf57bebb59c619723b9fbc2538314fc1181a229a3085388252256efdde7181a |
| 11_1_2023-11_30_2023-Desert Hot Springs CA PD-Network-Audit.csv | 50,992 | 9,068,611 | 8b8b2fd5b2005802e1fac8dee534b3fa42aa5102b8205efc0095361a33194876 |
| 12_1_2023-12_31_2023-Desert Hot Springs CA PD-Network-Audit.csv | 57,250 | 10,253,766 | 3a5ebe816889640ba410efc6799cebbd17fb888e96619a96053a61122f562483 |
| 1_1_2024-1_15_2024-Desert Hot Springs CA PD-Network-Audit.csv | 38,853 | 6,922,100 | 402c4b52ee5c8ca922cfea7900db7a03fef98dcdff4646e7e6f8929ab31b50b1 |
| 1_16_2024-1_31_2024-Desert Hot Springs CA PD-Network-Audit.csv | 80,736 | 14,286,897 | 76920c682f47fb91a076e219b55f8f9130a726e1f7383c2885d5f1900776a044 |
| 2_1_2024-2_29_2024-Desert Hot Springs CA PD-Network-Audit.csv | 152,826 | 27,112,187 | 811da854785ff1ebee2e49e9b9a52eb236e1a8e2690da3b52d178c377f341689 |
| 3_1_2024-3_31_2024-Desert Hot Springs CA PD-Network-Audit.csv | 185,351 | 32,817,094 | e77721ec8fe5c3254d205214ce32403233f4626706e9bb85fd959971000012b1 |
| 4_1_2024-4_30_2024-Desert Hot Springs CA PD-Network-Audit.csv | 210,944 | 37,387,783 | 95a1a3b7b6a74d58d79132a16a0471e36863e5fad3e256f72ae6d1d40cbe1784 |
| 5_1_2024-5_31_2024-Desert Hot Springs CA PD-Network-Audit.csv | 229,638 | 40,728,457 | 9f9ff16a1d1ed82f2eae5715d1e807dca039e51f996c25a0f83c48c24500c317 |
| 6_1_2024-6_15_2024-Desert Hot Springs CA PD-Network-Audit.csv | 115,396 | 20,458,846 | e1bc8f3b5bb14a28a8da5e609673ac15b11dac323babd17ef268d54e442f46ad |
| 6_16_2024-6_30_2024-Desert Hot Springs CA PD-Network-Audit.csv | 104,430 | 18,592,604 | c6f6f2ea63f23f53e4bf270b9570da4167729c83b580337c5f2b75f5e9b8fa08 |
| 7_1_2024-7_15_2024-Desert Hot Springs CA PD-Network-Audit.csv | 99,351 | 17,736,548 | 97a5643821108323fe166e369525048a9c6f7b5579d68644402a0831af6f0e6f |
| 7_16_2024-7_31_2024-Desert Hot Springs CA PD-Network-Audit.csv | 130,996 | 23,355,551 | 07f770293cc9d5d2fb79f6ff5964250d5ed2ac5f8a9f3021044d52064be5cfea |
| 8_1_2024-8_31_2024-Desert Hot Springs CA PD-Network-Audit.csv | 281,823 | 50,426,260 | d81312f83774c38b2c43f9908c64d6150bb35ea7487a89803f75df9f2d21e42d |
| 9_1_2024-9_30_2024-Desert Hot Springs CA PD-Network-Audit (1).csv | 282,612 | 50,512,540 | d612f3409a21ca359124d01645c20d8e7c0cf428ac82434430ecb72112d1893d |
| 10_1_2024-10_15_2024-Desert Hot Springs CA PD-Network-Audit.csv | 154,854 | 27,686,954 | 16f43e1cdf7f14722e6bd1fb243acb8bad0b20a278fefe7526e80f2660cb2aeb |
| 10_16_2024-10_31_2024-Desert Hot Springs CA PD-Network-Audit (1).csv | 168,334 | 30,100,971 | 88131406b3ea2ed202c4d34d1a933e1c40fca4d7f8fa8d74498471243d793694 |
| 11_1_2024-11_30_2024-Desert Hot Springs CA PD-Network-Audit.csv | 315,933 | 56,515,395 | a83276612aa2d8a46986aa939f44ec3d6350c3666d10422b354cbbb986d9c418 |
| 12_1_2024-12_7_2024-Desert Hot Springs CA PD-Network-Audit (1).csv | 90,224 | 16,134,223 | cb6f778d7cacd0ee156466c81d0e68e03c8fc3f86cf730489e40f5324a45bce7 |
| 12_8_2024-12_15_2024-Desert Hot Springs CA PD-Network-Audit.csv | 95,446 | 17,076,263 | e6528eef5bce7bdbb6c85c0a4c22c153c94f56857f7ff1c67057bf308ce35da9 |
| 12_16_2024-12_31_2024-Desert Hot Springs CA PD-Network-Audit.csv | 191,276 | 34,279,029 | 9ace526c573cd5a25fedb5939e86136e411dcdb94036dc5189dc5cae6d0691bc |
| 1_1_2025-1_31_2025-Desert Hot Springs CA PD-Network-Audit.csv | 450,002 | 80,614,290 | e5b8d1a391b6cf1f6c65e32cbd2035a96bb0bd8853ea21f637de9d275bbc6a4f |
| 2_1_2025-2_28_2025-Desert Hot Springs CA PD-Network-Audit.csv | 408,492 | 73,374,507 | 974df04c54a16308113fe8010f9e11464cae89aca23286d57a01e5fb9a576ec9 |
| 3_1_2025-3_31_2025-Desert Hot Springs CA PD-Network-Audit.csv | 430,683 | 77,693,902 | fee70dca7ffa021cb7be358c85cf783ab87a8dc5644bfc41c3005ccd53b11f57 |
| 4_1_2025-4_30_2025-Desert Hot Springs CA PD-Network-Audit.csv | 464,042 | 83,810,817 | 052708b13124a0cfc17e11a28bad50c107fb997ddc14bde7e939d41fa9f2d8fb |
| 5_1_2025-5_31_2025-Desert Hot Springs CA PD-Network-Audit.csv | 504,631 | 91,126,342 | a1209b5447125164ca77699507bf6a6ab4c0a91195cf447a500734829f94e0c1 |
| 6_1_2025-6_30_2025-Desert Hot Springs CA PD-Network-Audit.csv | 481,748 | 87,277,556 | 5aaea14f18899d7fbef0f3464257bcb792f909aa8b5271c7eb1ff5d13d3f7648 |
| 7_1_2025-7_31_2025-Desert Hot Springs CA PD-Network-Audit.csv | 563,593 | 103,071,346 | 551364b2c25e805038006ea242b4689b860090719a278c79f24fc399414eb4bc |
| 8_1_2025-8_31_2025-Desert Hot Springs CA PD-Network-Audit.csv | 510,424 | 94,804,902 | 094b7d1105218b637cf7b692b5bcb967be0dbc6b9c3cd7ff8bf4393d054aa8ab |
| 9_1_2025-9_30_2025-Desert Hot Springs CA PD-Network-Audit.csv | 456,580 | 85,068,370 | 8883e8ce594544fc594ab8ff6ea3de7518c57cc0741f77b4e8133db323d7d1d1 |
| 10_1_2025-10_31_2025-Desert Hot Springs CA PD-Network-Audit.csv | 423,209 | 77,815,259 | 9ed819cf7e31713c771142de6e2d6c4660b75a3862853366024f7c67cc7c8d3e |
| 11_1_2025-11_30_2025-Desert Hot Springs CA PD-Network-Audit.csv | 399,512 | 73,606,108 | 495a759a38ae3a9cff862307b8ad36b0587708c9287d3f15edd3ca077e837be5 |
| 12_1_2025-12_31_2025-Desert Hot Springs CA PD-Network-Audit.csv | 426,760 | 84,151,652 | 54b4798b8ab4cdc0f859457f061a651252c9c3a64d6696a22bbdd93f127b1041 |
| 1_1_2026-1_31_2026-Desert Hot Springs CA PD-Network-Audit.csv | 476,082 | 100,570,597 | 036322d0cb948c86967cf32b88feb7d44d46d533fd969acf51c9443407c46f4d |
| 2_1_2026-2_28_2026-Desert Hot Springs CA PD-Network-Audit.csv | 451,419 | 95,563,575 | 25969905f655e18b20f07c40b5197ed4e9035780d681e625b1d9f448b2866333 |
| 3_1_2026-3_31_2026-Desert Hot Springs CA PD-Network-Audit.csv | 498,503 | 105,745,017 | 5cc8aa8d8ab6b8b219a39e9b50e04b16ae99ef846e46295586934d145a5c19c4 |
| 4_1_2026-4_30_2026-Desert Hot Springs CA PD-Network-Audit.csv | 498,284 | 105,103,046 | 33763fbfd7f71d808522c25859ef74f674ec434b74c7cf4d1dccb04edde54974 |
| 5_1_2026-5_31_2026-Desert Hot Springs CA PD-Network-Audit.csv | 531,515 | 111,737,507 | cf58f22a648fbe852280b1a9863af3885e43ee5c6c53d3b250e89b953e7f2b21 |
| 6_1_2026-6_30_2026-Desert Hot Springs CA PD-Network-Audit.csv | 568,839 | 119,985,458 | 752b509b6d294f289f1cf2e9d72aa03cec9f0db3551012195279c794847ed763 |
| July 2026 NETWORK - 7_1_2026-7_31_2026-Desert Hot Springs CA PD-Network-Audit.csv | 550,601 | 115,762,435 | b673f9dae935063aa45e7619483bc33d8122bcf334fbe629c787af38a75a5baa |
| August 2026 NETWORK - 8_1_2026-8_31_2026-Desert Hot Springs CA PD-Network-Audit.csv | 489,107 | 103,058,729 | aa9ee3a5826736314d3afb217947219095afb82cf36f8ac0b5e40c085a935e76 |
| September 2026 NETWORK - 9_1_2026-9_24_2026-Desert Hot Springs CA PD-Network-Audit.csv | 329,779 | 69,857,363 | c200b1a380431e7ac21379f26695bdaf2b0a36d03053f0781900dae3651b9ee6 |
The seven org audit files hold 12,227 rows.
| File | Rows | Bytes | SHA-256 |
|---|---|---|---|
| March 2026 DHSPD Organization - 3_1_2026-3_31_2026-Desert Hot Springs CA PD-Audit (1).csv | 3,331 | 719,877 | 70cdd82f0bb04c8b241df44120f067fd02b310173792046090e4b56c63d29865 |
| April 2026 DHSPD Organization - 4_1_2026-4_30_2026-Desert Hot Springs CA PD-Audit.csv | 2,254 | 486,888 | fa3014275c280587fabbfa5fb947d11876293dda2ce66aae98a081fb26f30957 |
| May 2026 Desert Hot Springs Organization - 5_1_2026-5_31_2026-Desert Hot Springs CA PD-Audit.csv | 1,531 | 325,987 | 8983300d7983e12b7bce9bcd78cb08b25d5d2842be6a87c6da61ac24e32c8811 |
| June 2026 Desert Hot Springs Organization - 6_1_2026-6_30_2026-Desert Hot Springs CA PD-Audit.csv | 1,454 | 310,703 | dc22bb3d04da1f0051a9edf960757487cb788e69408baa6425372ed3a4aa0479 |
| July 2026 Desert Hot Springs Organization - 7_1_2026-7_31_2026-Desert Hot Springs CA PD-Audit.csv | 1,449 | 308,150 | ec93132f72f91956a438d0ff02450dacd18937c08beac4700a8bc6b6034acab6 |
| August 2026 Desert Hot Springs Organization - 8_1_2026-8_31_2026-Desert Hot Springs CA PD-Audit.csv | 1,180 | 260,580 | 3512c5d40f8595f6c4777e32fb443e96ef786fac0f7a9573b268a90a841c43cb |
| September 2026 Desert Hot Springs Organization - 9_1_2026-9_24_2026-Desert Hot Springs CA PD-Audit.csv | 1,028 | 222,733 | b9d9d711f5a6a643a35fbb9a065632d76990f785aa4afc200d11fed7ec2302a1 |
#What we checked and left unchanged
- Headers. All 75 staged files share one 13-column header: ID, Name, Org Name, Total Networks Searched, Time Frame, License Plate, Reason, Case #, Filters, Search Time, Search Type, Text Prompt, Moderation. Every name after ID starts with a space, such as " Org Name".
- Format. The files are UTF-8 with no byte-order mark. Rows end in
\r\n. Fields that hold a comma or a line break are quoted, and so are some fields that hold a tab. Time Frame holds two timestamps separated by\ninside quotes. Some reasons in 12 network files also contain line breaks. - Missing values in the org audit. The License Plate and Filters columns are present, but every cell is empty. The import step reads each column by name and stores an empty value for an empty cell, so the files import as released.
- Repeated IDs within a file. 15,549 rows in 16 network files repeat the ID of an earlier row in the same file. The February 2025 file has 7,824 of them, with some IDs appearing up to five times. 15,544 of the repeats match the earlier row in every field. The import step drops exact repeats within a file. Five rows in “12_8_2024-12_15_2024-Desert Hot Springs CA PD-Network-Audit.csv” differ from the earlier row only in Total Networks Searched, such as 4965 and 4966. The import step will keep both versions of those five. This post counts each ID once.
- IDs across files. No ID appears in two network files. 12,121 org audit IDs also appear in the network audit, as Desert Hot Springs’s own searches. The network version redacts the name and other fields, so the import step stores both.
- Times. Search Time values are in UTC. We left them as released.
- Org names. The network files spell some agencies more than one way, as described above. We left them as released.
#Anomalies
#Missing days
Neither audit covers July 31 or August 31, 2026. The July network file ends at 12:00 a.m. on July 31, and the August file ends at 11:59 p.m. on August 30. The org audit also misses April 30, May 31, June 30, and March 31 after 3:30 a.m. The network audit shows 219 Desert Hot Springs searches in those gaps: 18 on March 31, 53 on April 30, 18 on May 31, and 130 on June 30.
#Test records
Six org records have “test” in the reason: “Trespass - test” five times on March 6, 2026 and “Assault/Battery Offenses - test” once on April 5, 2026.
In the network audit, 12,994 records from 232 agencies have a reason containing a word that starts with “test”. Desert Hot Springs CA PD entered 1,654 of them between August 19, 2021 and April 5, 2026. 1,638 of those read “test” alone, in some capitalization.
How we processed the files lists every step.