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

9 rows where state = "OH" and vendor = "ShotSpotter" sorted by amount descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

vendor 1

  • ShotSpotter · 9 ✖

state 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
3552 3552 ShotSpotter Toledo OH 2022-03-15 gunshot detection subscription (award contract) 840000.0 Authorizing the Mayor to enter into a three-year subscription agreement with SST, Inc. for expansion of the Shot Spotter gunshot detection system; authorizing the expenditure of an amount not to exceed $840,000 from the Local Fiscal Recovery Fund; waiving the competitive bidding requirements of TMC Chapter 187; and declaring an emergency. https://legistar2.granicus.com/toledo/meetings/2022/3/3191_A_City_Council_22-03-15_Formal_Agenda.pdf https://mytown.theboringparts.com/city/toledo/2022/#m360030 sv:gunshot:shotspotter ceiling 1 0 0 OH
3829 3829 ShotSpotter Columbus OH 2021-11-15 gunshot detection pilot (amend) 630000.0 To authorize the Public Safety Director to modify the contract with ShotSpotter, Inc. to establish a gunfire detection, alert, and analysis pilot program; to authorize the expenditure of $630,000.00 from the General Fund. ($630,000.00) https://legistar3.granicus.com/Columbus/meetings/2021/11/5834_M_Columbus_City_Council_21-11-15_Minutes_-_Final.pdf https://mytown.theboringparts.com/city/columbus/2021/#m144320 sv:gunshot:shotspotter stated 1 0 0 OH
3831 3831 ShotSpotter Columbus OH 2021-11-22 gunshot detection pilot (amend contract) 630000.0 To authorize the Public Safety Director to modify the contract with ShotSpotter, Inc. to establish a gunfire detection, alert, and analysis pilot program; to authorize the expenditure of $630,000.00 from the General Fund. ($630,000.00) https://legistar3.granicus.com/Columbus/meetings/2021/11/5835_M_Columbus_City_Council_21-11-22_Minutes_-_Final.pdf https://mytown.theboringparts.com/city/columbus/2021/#m144319 sv:gunshot:shotspotter stated 2 0 0 OH
3548 3548 ShotSpotter Toledo OH 2023-03-21 gunshot detection (authorize expenditure) 280000.0 Authorizing the expenditure in an amount not to exceed $280,000 from the Capital Improvement Fund for the cost of Shot Spotter gunshot detection; and declaring an emergency. https://legistar2.granicus.com/toledo/meetings/2023/3/3417_M_City_Council_23-03-21_Meeting_Minutes.pdf https://mytown.theboringparts.com/city/toledo/2023/#m360190 sv:gunshot:shotspotter ceiling 1 0 0 OH
3551 3551 ShotSpotter Toledo OH 2022-05-10 gunshot detection (authorize expenditure) 280000.0 Authorizing the expenditure in an amount not to exceed $280,000 from the 2022 Capital Improvement Fund for the cost of Shot Spotter gunshot detection; and declaring an emergency. https://legistar2.granicus.com/toledo/meetings/2022/5/3212_M_City_Council_22-05-10_Meeting_Minutes.pdf https://mytown.theboringparts.com/city/toledo/2022/#m360053 sv:gunshot:shotspotter ceiling 1 0 0 OH
3554 3554 ShotSpotter Toledo OH 2021-03-30 gunshot detection (authorize expenditure) 280000.0 Authorizing the expenditure in an amount not to exceed $280,000 from the Capital Improvement Fund for the cost of Shot Spotter gunshot detection; and declaring an emergency. https://legistar2.granicus.com/toledo/meetings/2021/3/1961_A_City_Council_21-03-30_Formal_Agenda.pdf https://mytown.theboringparts.com/city/toledo/2021/#m359888 sv:gunshot:shotspotter ceiling 2 0 0 OH
3546 3546 ShotSpotter Toledo OH 2025-05-20 gunshot detection subscription (renew) 213855.0 Authorizing the Mayor to renew an agreement with SoundThinking, Inc. for Shotspotter; authorizing the appropriation and expenditure of $213,855 in the General Fund for the renewal; https://legistar2.granicus.com/toledo/meetings/2025/5/3840_A_City_Council_25-05-20_Formal_Agenda.pdf https://mytown.theboringparts.com/city/toledo/2025/#m360504 sv:gunshot:shotspotter stated 1 0 0 OH
3547 3547 ShotSpotter Toledo OH 2025-05-13 gunshot detection subscription (renew) 213855.0 Authorizing the Mayor to renew an agreement with SoundThinking, Inc. for Shotspotter; authorizing the appropriation and expenditure of $213,855 in the General Fund for the renewal; waiving the competitive bidding requirements of TMC Chapter 187; and declaring an emergency. https://legistar2.granicus.com/toledo/meetings/2025/5/3762_A_City_Council_25-05-13_Agenda_Review.pdf https://mytown.theboringparts.com/city/toledo/2025/#m360501 sv:gunshot:shotspotter stated 1 0 0 OH
2495 2495 ShotSpotter Warrensville Heights OH 2024-11-06 gunshot detection subscription (amend) 128700.0 AUTHORIZING THE MAYOR TO ENTER INTO AMENDMENT ONE TO THE RESPOND SERVICES AGREEMENT WITH SOUNDTHINKING, INC., FORMERLY SHOTSPOTTER, INC., FOR AN AMOUNT NOT TO EXCEED $128,700.00 TO UPDATE THE NAME OF THE VENDOR AND SERVICES, AND EXTEND THE AGREEMENT TO SEPTEMBER 27, 2026 PURSANT TO ARTICLE VI, SECTION 5 OF THE WARRENSVILLE HEIGHTS CHARTER, AND DECLARING AN EMERGENCY https://www.cityofwarrensville.com/AgendaCenter/ViewFile/Minutes/_11062024-38 https://mytown.theboringparts.com/city/cityofwarrensville.com/2024/#m1584610 sv:gunshot:shotspotter ceiling 1 0 0 OH

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);