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

3 rows where state = "IA" and vendor = "Flock Safety" sorted by amount descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: city, spend_date, amount, amount_type, dup_rank, spend_date (date)

vendor 1

  • Flock Safety · 3 ✖

state 1

ledger 1

Link rowid vendor city state spend_date product amount ▲ quote source_document mytown_record ledger amount_type dup_rank geo_suspect anomaly state_norm
2207 2207 Flock Safety Coralville IA 2026-01-20 budget 18000.0 Police Chief Kyle Nicholson reported some budget lines show significant increases while others show no funding because they reflect an effort to consolidate budget lines. The budget proposes hiring one additional police officer, $5,000 in funding for a sergeant assessment center in anticipation of the retirement of Sgt. Sutton in January 2027, putting $100,000 into reserves to replace the TAC10 system which has reached capacity, funding to meet new CJIS security requirements, $18,000 allocated for the second year of the Flock Safety contract, funding a second full-time mental health liaison shared with the Johnson County Sheriff’s Office and North Liberty Police Department, and funding for three new police vehicles and associated equipment as part of the regular fleet replacement cycle. https://www.coralville.org/AgendaCenter/ViewFile/Minutes/_01202026-1937 https://mytown.theboringparts.com/city/coralville.org/#m1431863 flock proposed 1 0 0 IA
2208 2208 Flock Safety Coralville IA 2026-01-20 budgeted 18000.0 $18,000 allocated for the second year of the Flock Safety contract https://www.coralville.org/AgendaCenter/ViewFile/Agenda/_01202026-1944 https://mytown.theboringparts.com/city/coralville.org/#m1431869 flock stated 2 0 0 IA
1899 1899 Flock Safety Polk County IA 2022-09-14 approve minor bond projects 8550.0 Flock Safety Cameras Easter Lake and Fort Des Moines Park entrances $8,550 Parks https://polkcountyia.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=5942,plainText=false) https://mytown.theboringparts.com/city/polkcountyia/2022/#m756976 flock 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);