surveillance_spending

A DISCOVERY INDEX of surveillance and police-technology dollar figures found in local government meeting records across 130+ named vendors — NOT a table of confirmed spending, and NOT safe to SUM. An audit on 2026-07-29 found aggregate views were adding amounts that must not be added: the same procurement recurs at committee, council, approval, amendment and renewal stages; "not to exceed" figures are authorization ceilings, not payments. Use the canned query "the CONSERVATIVE total" for any number you intend to publish, and "data-quality report" to see what is flagged. Columns added for this: `amount_type` (stated / ceiling / proposed / recommended / estimated), `dup_rank` (>1 = redundant copy), `geo_suspect` (city disagrees with the source link), `anomaly` (implausible figure), `state_norm` (normalized state). Vendors covered include ALPR (Flock, Vigilant, Genetec), body cameras/tasers (Axon, WatchGuard, Utility, Getac), gunshot detection (ShotSpotter/SoundThinking), face recognition (Clearview AI, DataWorks Plus), fingerprint biometrics (Idemia AFIS/Livescan, filed separately under `sv:biometrics`), data fusion and OSINT (Fusus, Peregrine, LexisNexis Accurint, Thomson Reuters CLEAR), phone forensics (Cellebrite, GrayKey, Magnet), drones (Skydio, BRINC, DJI), cameras/VMS (Verkada, Avigilon), cell-site simulators, CAD/RMS records systems, photo enforcement, jail-call and student monitoring. Every row carries a VERBATIM quote from the minutes and a link to the source document, and a row only publishes if that quote was found character-for-character in the source text. READ THE `ledger` COLUMN: `sv:<category>:<vendor>`. `radio_infra` (two-way radios), `rms` (records/CAD software), `biometrics` (fingerprints) and `not_surveillance` are NOT surveillance sensors — exclude them before quoting any surveillance figure.

Data license: CC BY 4.0 · Data source: MyTown

6 rows where ledger = "sv:motorola:motorola" and state = "IA" sorted by amount descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: city, product, amount, amount_type, geo_suspect, spend_date (date)

vendor 1

state 1

ledger 1

  • sv:motorola:motorola · 6 ✖
Link rowid vendor city state spend_date product amount ▲ quote source_document mytown_record ledger amount_type dup_rank geo_suspect anomaly state_norm
3287 3287 Motorola Solutions Des Moines IA 2023-11-20 in-car video systems (purchase) 1500080.0 Purchase from Motorola Solutions, Inc. (Greg Brown, CEO) of M500 In-Car Video Systems and Video Manager and five (5) year subscription for service and maintenance per Sourcewell Master Agreement for use by the Police Department, $1,500,080. https://councildocs.dsm.city/minutes/as20231120.pdf?pdf=Minutes https://mytown.theboringparts.com/city/rz-dsm.city/2023/#m576923 sv:motorola:motorola stated 1 1 0 IA
3288 3288 Motorola Solutions Des Moines IA 2024-11-04 body worn camera equipment (authorize lease agreement) 1035828.0 On the proposition to authorize a lease agreement with Motorola Solutions, Inc. (Greg Brown, CEO) in which the principal amount is not -to-exceed $1,035,828 for the purpose of purchasing upgraded body worn camera equipment and related services, (11-18-24). https://councildocs.dsm.city/minutes/as20241104.pdf https://mytown.theboringparts.com/city/rz-dsm.city/2024/#m576872 sv:motorola:motorola proposed 1 1 0 IA
3289 3289 Motorola Solutions Des Moines IA 2024-11-18 body worn camera equipment (amend loan agreement) 1035828.0 On the proposition to authorize an extension of an existing loan agreement with Motorola Solutions, Inc. (Greg Brown , CEO) in which the principal amount is not -to-exceed $1,035,828 for the purpose of purchasing upgraded body worn camera equipment and related services. https://councildocs.dsm.city/minutes/as20241118.pdf?pdf=Minutes https://mytown.theboringparts.com/city/rz-dsm.city/2024/#m576870 sv:motorola:motorola proposed 1 1 0 IA
3290 3290 Motorola Solutions Des Moines IA 2026-06-29 ALPR software licenses (purchase) 157200.0 Purchase of license plate recognition software licenses from Motorola Solutions, Inc. using the Sourcewell cooperative purchase contract for use by the Police Department for a total of $157,200 for five years. https://councildocs.dsm.city/minutes/as20260629.pdf https://mytown.theboringparts.com/city/rz-dsm.city/#m576793 sv:motorola:motorola stated 1 1 0 IA
2601 2601 Motorola Solutions Coralville IA 2025-01-14 body cameras (approve payment) 39160.0 Approve payment to Motorola Solutions, Inc. for the Coralville Police Departments M500 In-Car System with Body Worn Camera and Video Manager EL Cloud – 5years Video-As-A-Service (#1187136773): $39,160.00. https://www.coralville.org/AgendaCenter/ViewFile/Minutes/_01142025-1827 https://mytown.theboringparts.com/city/coralville.org/2025/#m1432215 sv:motorola:motorola stated 1 0 0 IA
3878 3878 Motorola Solutions Coralville IA 2026-04-14 body cameras (approve payment) 39160.0 Approve payment to Motorola Solutions, Inc. for in car and body cameras (#1187170358): $39,160.00. https://www.coralville.org/AgendaCenter/ViewFile/Minutes/_04142026-1963 https://mytown.theboringparts.com/city/coralville.org/#m18458 sv:motorola:motorola stated 1 0 0 IA

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE surveillance_spending (
  vendor TEXT, city TEXT, state TEXT, spend_date TEXT, product TEXT,
  amount REAL, quote TEXT, source_document TEXT, mytown_record TEXT, ledger TEXT, amount_type TEXT, dup_rank INTEGER, geo_suspect INTEGER, anomaly INTEGER, state_norm TEXT);
CREATE INDEX ix_surv_vendor ON surveillance_spending(vendor);
CREATE INDEX ix_surv_state ON surveillance_spending(state);
CREATE INDEX ix_surv_amount ON surveillance_spending(amount);
CREATE INDEX ix_surv_ledger ON surveillance_spending(ledger);