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 state = "IL" and vendor = "Verkada" 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

  • Verkada · 6 ✖

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
3330 3330 Verkada DuPage County IL 2025-11-18 video surveillance solution (approve contract) 1457141.0 Recommendation for the approval of a contract to Heartland Business Systems LLC, to replace and expand existing video surveillance solution with Verkada Command for the Circuit Court at the Judicial Office Facility, for Facilities Management, for the period of November 25, 2025 through November 24, 2026, for a total contract amount not to exceed $1,457,141.52; per quote #391347 v2. https://dupage.legistar1.com/dupage/meetings/2025/11/10797_M_Public_Works_Committee_25-11-18_Summary.pdf https://mytown.theboringparts.com/city/dupage/2025/#m560466 sv:camera:verkada ceiling 1 1 0 IL
2646 2646 Verkada Danville IL 2025-08-26 security camera system (authorize purchase) 200000.0 Resolution Authorizing the Purchase of a Security Camera System for City of Danville Parks with the purchase of Verkada Cameras and Video Management Software Technology from Heartland Business Systems for the estimated cost of $200,000.00 to be paid from line item 001-051-00-55016 Parks & Public Property and 302-302-00-55016 Capital Improvement https://www.cityofdanville.org/AgendaCenter/ViewFile/Minutes/_08262025-255 https://mytown.theboringparts.com/city/cityofdanville.org/2025/#m1392416 sv:camera:verkada estimated 1 0 0 IL
2648 2648 Verkada Danville IL 2025-08-05 security camera system (authorize purchase) 200000.0 RESOLUTION 2025-92 Authorizing the Purchase of a Security Camera System for City of Danville Parks with the purchase of Verkada Cameras and Video Management Software Technology from Heartland Business Systems for the estimated cost of $200,000.00 https://www.cityofdanville.org/AgendaCenter/ViewFile/Minutes/_08052025-252 https://mytown.theboringparts.com/city/cityofdanville.org/2025/#m1392252 sv:camera:verkada estimated 1 0 0 IL
2649 2649 Verkada Danville IL 2025-08-19 security camera system (authorize purchase) 200000.0 Authorizing the Purchase of a Security Camera System for City of Danville Parks with the purchase of Verkada Cameras and Video Management Software Technology from Heartland Business Systems for the estimated cost of $200,000.00 https://www.cityofdanville.org/AgendaCenter/ViewFile/Minutes/_08192025-254 https://mytown.theboringparts.com/city/cityofdanville.org/2025/#m1392251 sv:camera:verkada estimated 1 0 0 IL
4012 4012 Verkada Niles IL 2023-07-11 Door access controllers (ratify purchase orders) 52033.0 The Committee seeks ratification of multiple Purchase Orders to ITsavvy totaling 52,033.09 for the Door Access Control System (Verkada Door Controllers) Project Village-wide. https://www.vniles.com/AgendaCenter/ViewFile/Minutes/_07112023-2409 https://mytown.theboringparts.com/city/vniles.com/2023/#m1396957 sv:camera:verkada stated 1 0 0 IL
2747 2747 Verkada DeKalb IL 2024-11-12 security system (approve contract) 52000.0 Resolution 2024- 110 Authorizing 22VETS Technologies to Install the Verkada Security System at the Public Works Facility in an Amount Not to Exceed $52,000. https://www.cityofdekalb.com/AgendaCenter/ViewFile/Minutes/_11122024-2614 https://mytown.theboringparts.com/city/cityofdekalb.com/2024/#m1277610 sv:camera:verkada ceiling 1 0 0 IL

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