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

130 rows where state = "IL" and vendor = "Axon" sorted by amount descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: product, amount_type, geo_suspect, anomaly, spend_date (date)

vendor 1

  • Axon · 130 ✖

state 1

  • IL · 130 ✖

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
15 15 Axon Bloomington IL 2025-09-08 bundle/OSP 13559883.81 Approving a New Twelve-Year (Beginning October 1, 2025) Agreement with Axon Enterprises, Inc., in the Amount of $13,559,883.81 https://bloomingtonil.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=6918,plainText=false) https://mytown.theboringparts.com/city/bloomingtonil/2025/#m725835 axon stated 1 0 1 IL
49 49 Axon Aurora IL 2023-09-12 body cameras 6246715.0 Approved $6,246,715 contract with Axon Enterprises for police cameras and equipment (11-1) https://legistar1.granicus.com/aurora-il/meetings/2023/9/4003_M_City_Council_23-09-12_Meeting_Minutes.pdf https://mytown.theboringparts.com/city/aurora-il/2023/#m74571 axon stated 1 0 0 IL
90 90 Axon Peoria IL 2022-10-25 body cameras and Tasers 3398734.0 $3,398,734.00 contract with Axon Enterprises for body cameras and Tasers https://legistar.granicus.com/peoriail/meetings/2022/10/4943_A_City_Council_22-10-25_Agenda_and_Notice.pdf https://mytown.theboringparts.com/city/peoriail/#m332467 axon stated 1 0 0 IL
121 121 Axon Kane County IL 2025-10-09 bundle/OSP 2300000.0 ubmitted budget amount for software, licensing, and services is $2,300,000. https://countyofkane.legistar1.com/countyofkane/meetings/2025/10/2117_M_Judicial_and_Public_Safety_Strategic_Planning_and_Technology_Commission_25-10-09_Meeting_Minutes.pdf https://mytown.theboringparts.com/city/countyofkane/2025/#m561275 axon stated 1 1 0 IL
124 124 Axon Naperville IL 2022-02-01 body cameras 2257634.97 Approve the award of Cooperative Procurement 21-281, Police Department Body Worn Cameras and In-Car Video System to Axon Enterprise, Inc for an amount not to exceed $2,257,634.97 and for a five-year term https://naperville.legistar1.com/naperville/meetings/2022/2/2597_M_City_Council_22-02-01_Meeting_Minutes.pdf https://mytown.theboringparts.com/city/naperville/2022/#m325064 axon ceiling 1 0 0 IL
147 147 Axon Rolling Meadows IL 2023-09-12 body cameras and Tasers 1843708.39 Approve a Ten (10) Year Contract with Axon Enterprises, Inc. of Scottsdale, Arizona for a Body Worn Camera System and Less Lethal Electronic Control Devices (Tasers) for a Purchase Price not to exceed $1,843,708.39 https://www.cityrm.org/AgendaCenter/ViewFile/Minutes/_09122023-1067 https://mytown.theboringparts.com/city/cityrm.org/2023/#m1402493 axon ceiling 1 1 0 IL
158 158 Axon Round Lake Beach IL 2026-05-18 bundle/OSP 1727648.43 Award of contract to Axon for police equipment https://www.roundlakebeachil.gov/05.18.2026%20Council%20Meeting%20Agenda%20Packet.pdf https://mytown.theboringparts.com/city/rz-roundlakebeachil.gov/#m848219 axon stated 1 0 0 IL
163 163 Axon Rock Island County IL 2026-03-23 body cameras 1604502.9 a $1,604,502.90 equipment and vehicle purchase, and contracts for tree services, mowing, masonry restoration, and a five‑year Axon body‑camera agreement. https://rockislandil.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=1839,plainText=false) https://mytown.theboringparts.com/city/rockislandil/#m734674 axon stated 1 0 0 IL
170 170 Axon Hoffman Estates IL 2024-11-25 bundle/OSP 1486990.47 Authorization to waive formal bidding and award a five (5) year service agreement to Axon Enterprise, Inc, Scottsdale, AZ, in an amount not to exceed $1,486,990.47. https://hoffmanestatesil.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=517,plainText=false) https://mytown.theboringparts.com/city/hoffmanestatesil/2024/#m408365 axon ceiling 1 0 0 IL
186 186 Axon Schiller Park IL 2023-12-21 body cameras 1322370.91 Axon Enterprise, Inc. — Axon Body Camera and Data Storage Including Evidence.com https://www.villageofschillerpark.com/AgendaCenter/ViewFile/Minutes/_12212023-1763 https://mytown.theboringparts.com/city/villageofschillerpark.com/#m1397903 axon stated 1 0 0 IL
190 190 Axon Geneva IL 2026-05-18 Tasers, body cameras, vehicle cameras, and software 1254027.63 Approved purchase of Axon Taser 7 program, body cameras, vehicle cameras, and software for $1,254,027.63 over 10 years (8-1) https://www.geneva.il.us/AgendaCenter/ViewFile/Minutes/_05182026-2706 https://mytown.theboringparts.com/city/geneva.il.us/#m20168 axon stated 1 0 0 IL
197 197 Axon Naperville IL 2024-09-17 Tasers 1178820.0 Approve the award for the Cooperative Procurement 24-239, Axon Taser and Virtual Reality Equipment, to Axon Enterprise for an amount not to exceed $1,178,820 and for a five-year term https://naperville.legistar1.com/naperville/meetings/2024/9/3128_M_City_Council_24-09-17_Meeting_Minutes.pdf https://mytown.theboringparts.com/city/naperville/2024/#m325475 axon ceiling 1 0 0 IL
240 240 Axon Park Ridge IL 2023-10-16 bundle/OSP 921241.0 Five-year contract with Axon Enterprise for body cameras, in-car cameras, and Tasers in the amount of $921,241 https://parkridge.granicus.com/AgendaViewer.php?view_id=5&clip_id=2697 https://mytown.theboringparts.com/city/gr-parkridge/2023/#m166511 axon stated 1 0 0 IL
241 241 Axon Marion IL 2023-03-13 body cameras 917510.4 purchase Axon body-worn cameras and in-car cameras for a total cost of $917,510.40 https://marionil.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=355,plainText=false) https://mytown.theboringparts.com/city/marionil/2023/#m526899 axon stated 1 0 0 IL
255 255 Axon Glenview IL 2024-09-03 body cameras 825708.0 Police Body Worn Camera system agreement with Axon Enterprises up to $825,708 https://glenview.granicus.com/AgendaViewer.php?view_id=6&clip_id=2906 https://mytown.theboringparts.com/city/gr-glenview/2024/#m145262 axon ceiling 1 0 0 IL
279 279 Axon Carpentersville IL 2026-06-22 bundle/OSP 743113.08 The total value of the proposed consolidated Axon agreement is $743,113.08 over 60 months. https://www.cville.org/AgendaCenter/ViewFile/Minutes/_06222026-1031 https://mytown.theboringparts.com/city/cville.org/#m581339 axon proposed 1 1 0 IL
302 302 Axon DuPage County IL 2025-08-12 body cameras 625198.3 Approved $625,198.30 Axon Body 4 Camera Bundle contract for Sheriff’s Office (unanimous) https://dupage.legistar1.com/dupage/meetings/2025/8/10898_M_Finance_Committee_25-08-12_Summary.pdf https://mytown.theboringparts.com/city/dupage/2025/#m560370 axon stated 1 1 0 IL
312 312 Axon Westmont IL 2021-10-21 bundle/OSP 595379.3 The Village Board is reviewing an ordinance for a $595,379.30 police equipment agreement with Axon Enterprise, Inc. https://westmontil.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=8319,plainText=false) https://mytown.theboringparts.com/city/westmontil/2021/#m457311 axon stated 1 0 0 IL
320 320 Axon Peoria IL 2021-10-12 bundle/OSP 576730.89 $576,730.89 agreement with Axon Enterprises, Inc. for police interview room technology https://legistar.granicus.com/peoriail/meetings/2021/10/4868_A_City_Council_21-10-12_Agenda_and_Notice.pdf https://mytown.theboringparts.com/city/peoriail/2021/#m332428 axon stated 1 0 0 IL
372 372 Axon Carpentersville IL 2026-06-22 bundle/OSP 447879.94 Including this capability at no additional cost adds value to the agreement and is included in Axon's total stated savings figure of $447,879.94. https://www.cville.org/AgendaCenter/ViewFile/Minutes/_06222026-1031 https://mytown.theboringparts.com/city/cville.org/#m581339 axon stated 1 1 0 IL
395 395 Axon Geneva IL 2023-11-20 body cameras 404703.34 Consider Resolution No. 2023-118 Authorizing the Purchase of Axon Body Worn Cameras, Vehicle Cameras, and Supporting Software at a Cost Not- to-Exceed $404,703.34 Over a Five-Year Term Utilizing the Sourcewell Contract. https://www.geneva.il.us/AgendaCenter/ViewFile/Minutes/_11202023-2258 https://mytown.theboringparts.com/city/geneva.il.us/#m1245842 axon stated 1 0 0 IL
401 401 Axon Pingree Grove IL 2026-06-15 other 399801.92 Consideration and Approval – Authorization of the Purchase of Body Cameras and Tasers from Axon Enterprises, INC. in the amount of $399,801.92 https://www.villageofpingreegrove.org/AgendaCenter/ViewFile/Agenda/_06152026-681 https://mytown.theboringparts.com/city/villageofpingreegrove.org/#m166693 axon stated 1 0 0 IL
417 417 Axon Deerfield IL 2023-12-18 body cameras 370661.72 Deputy Chief Budny noted the Department is seeking authorization to purchase 43 AXON Body 3 cameras at a cost of $370,661.72. https://www.deerfield.il.us/AgendaCenter/ViewFile/Minutes/_12182023-1051 https://mytown.theboringparts.com/city/deerfield.il.us/2023/#m1352950 axon stated 1 0 0 IL
427 427 Axon McLean County IL 2026-06-03 Justice/Records 345224.06 73681 AXON RECORDS - PATROL 74 101 $52.60 $46.19 $345,224.06 $0.00 $345,224.06 https://www.mcleancountyil.gov/AgendaCenter/ViewFile/Minutes/_06032026-1208 https://mytown.theboringparts.com/city/mcleancountyil.gov/#m562205 axon stated 1 0 0 IL
459 459 Axon Oak Brook IL 2026-02-24 Report Management System 299268.29 Axon Enterprise Inc. - Report Management System - $299,268.29 https://oakbrookil.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=1794,plainText=false) https://mytown.theboringparts.com/city/oakbrookil/#m462620 axon stated 1 0 0 IL
463 463 Axon Collinsville IL 2023-08-22 body cameras 293494.3 Body Worn Cameras Hardware, Software and Service - $293,494.30 (5 installmen https://collinsville.legistar1.com/collinsville/meetings/2023/8/1692_M_City_Council_23-08-22_Minutes.pdf https://mytown.theboringparts.com/city/collinsville/2023/#m262779 axon stated 1 0 0 IL
464 464 Axon East Moline IL 2025-11-17 bundle/OSP 293268.19 Axon is also throwing in a free Outpost LPR Camera as part of a promotion. https://www.eastmoline.com/AgendaCenter/ViewFile/Minutes/_11172025-1140 https://mytown.theboringparts.com/city/eastmoline.com/2025/#m1372845 axon stated 1 0 0 IL
465 465 Axon Palos Heights IL 2023-06-27   291824.0 Proposed purchase of 31 Axon body cameras with a 5-year cost of $291,824.00 https://www.palosheights.org/AgendaCenter/ViewFile/Minutes/_06272023-856 https://mytown.theboringparts.com/city/palosheights.org/2023/#m1262083 axon proposed 1 0 0 IL
466 466 Axon Schiller Park IL 2023-12-21 body cameras 285164.6 Motion to ratify approval of a revised proposal from Axon Enterprise, Inc. in an amount not to exceed $285,164.60 for the purchase of body cameras and data storage and authorize the Village Manager to execute the necessary documents and undertake https://www.villageofschillerpark.com/AgendaCenter/ViewFile/Minutes/_12212023-1763 https://mytown.theboringparts.com/city/villageofschillerpark.com/#m1397903 axon ceiling 1 0 0 IL
469 469 Axon Oak Brook IL 2025-01-28 Report Management System 278241.49 Axon Enterprise Inc. - Report Management System - $278,241.49 https://oakbrookil.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=424,plainText=false) https://mytown.theboringparts.com/city/oakbrookil/2025/#m462543 axon stated 1 0 0 IL
477 477 Axon Olympia Fields IL 2025-12-17 bundle/OSP 268888.38 Approval Of The Five-Year Contract Extension/Early Renewal With Axon Enterprise In The Amount Of $268,888.38. https://www.olympia-fields.com/AgendaCenter/ViewFile/Minutes/_12172025-533 https://mytown.theboringparts.com/city/olympia-fields.com/#m1576285 axon stated 1 0 0 IL
493 493 Axon Joliet IL 2022-03-14 body cameras 250075.0 Change Order No.1 for Axon Body Worn Camera Program https://joliet.legistar1.com/joliet/meetings/2022/3/1469_M_Pre-Council_Meeting_22-03-14_Meeting_Minutes.pdf https://mytown.theboringparts.com/city/joliet/2022/#m296435 axon stated 1 0 0 IL
504 504 Axon River Grove IL 2024-02-05 body cameras 241661.8 orizing the Purchase of Thirty-Five (35) Body Worn Cameras and related Equipment; Software; Data Storage and related Items from Axon Enterprise, Inc of Scottsdale, AZ for a Not-to-Exceed Cost of $ 241,661.80, Payable Over Five (5) Years. https://www.rivergroveil.gov/AgendaCenter/ViewFile/Minutes/_02052024-502 https://mytown.theboringparts.com/city/rivergroveil.gov/#m1567675 axon stated 1 0 0 IL
530 530 Axon Edwardsville IL 2024-11-25 Tasers 212307.6 We are requesting to purchase (47) Taser 10s and to enter a five-year contract with Axon for Taser licensing and equipment in the amount of $212,307.60. https://www.cityofedwardsville.com/AgendaCenter/ViewFile/Agenda/_11252024-3563 https://mytown.theboringparts.com/city/cityofedwardsville.com/2024/#m1144676 axon stated 1 0 0 IL
532 532 Axon Vernon Hills IL 2023-12-12 Tasers 208930.0 NTH EXPENDITURE NOT TO EXCEED $208,930 FOR THE PURCHASE AND CONTRACTING OF THE “TASER 10 CONDUCTED ELECTRICAL WEAPON SYSTEM” FROM AXON ENTERPRISE, INC. https://www.vernonhills.org/AgendaCenter/ViewFile/Minutes/_12122023-1105 https://mytown.theboringparts.com/city/vernonhills.org/2023/#m1298949 axon ceiling 1 0 0 IL
545 545 Axon McLean County IL 2026-06-03 Axon Records 195000.0 AXON RECORDS - PROFESSIONAL SERVICES MILESTONE PAYMENT 1 $250.00 $195,000.00 $195,00 https://www.mcleancountyil.gov/AgendaCenter/ViewFile/Minutes/_06032026-1208 https://mytown.theboringparts.com/city/mcleancountyil.gov/#m562205 axon stated 1 0 0 IL
569 569 Axon Naperville IL 2022-06-21 Taser 177256.96 Approve the award of Change Order #1 to Contract 20-375, Axon Taser Equipment, to Axon Enterprise for an amount not to exceed $177,256.96 over three years and a total award of $453,256.96 https://naperville.legistar1.com/naperville/meetings/2022/6/2755_M_City_Council_22-06-21_Meeting_Minutes.pdf https://mytown.theboringparts.com/city/naperville/2022/#m325137 axon ceiling 1 0 0 IL
577 577 Axon DuPage County IL 2025-01-21 other 172633.19 Contract to Axon Enterprise for interview recording system, $172,633.19 https://dupage.legistar1.com/dupage/meetings/2025/1/10997_M_Technology_Committee_25-01-21_Summary.pdf https://mytown.theboringparts.com/city/dupage/2025/#m560293 axon stated 1 1 0 IL
587 587 Axon Vernon Hills IL 2025-04-15 Justice/Records 164183.0 AN ORDINANCE AUTHORIZING APPROVAL TO WAIVE THE COMPETITIVE BIDDING PROCESS FOR THE PURCHASE OF AXON DRAFT ONE REPORT WRITING SOFTWARE AND THE TOTAL 32-MONTH EXPENDITURE NOT TO EXCEED $164,183 FROM AXON ENTERPRISE, INC. https://www.vernonhills.org/AgendaCenter/ViewFile/Minutes/_04152025-1281 https://mytown.theboringparts.com/city/vernonhills.org/2025/#m1298670 axon ceiling 1 0 0 IL
589 589 Axon DuPage County IL 2026-02-10 bundle/OSP 162602.1 Second amendment to Purchase Order 6662-0001 SERV, issued to Axon Enterprise, Inc., to increase the contract encumbrance in the amount of $ 162,602.10, for a new contract total not to exceed $1,684,987.90. https://dupage.legistar1.com/dupage/meetings/2026/2/11355_M_DuPage_County_Board_26-02-10_Summary.pdf https://mytown.theboringparts.com/city/dupage/#m560011 axon ceiling 1 0 0 IL
590 590 Axon Rolling Meadows IL 2025-12-16 Fleet ALPR 160912.2 Approve and Authorize a Five -Year Purchase Agreement with Axon Enterprise, Inc., for the Purchase of Eleven Axon Fleet In- Car Video Cameras and Supporting Information, Services and Warranties in a Total Amount of $160,912.20 https://www.cityrm.org/AgendaCenter/ViewFile/Minutes/_12162025-1340 https://mytown.theboringparts.com/city/cityrm.org/2025/#m1402153 axon stated 1 1 0 IL
598 598 Axon River Grove IL 2022-07-21 Fleet ALPR 158140.0 on Enterprise, Inc. as the Sole Source Provider of In-Car Camera and License Plate Recognition Equipment, Technical Support, and Axon Software Updates/Upgrades for Axon Products In Use By and Necessary for the River Grove Police Department (Total Contract $158,140.00 Payable In Five Installments of https://www.rivergroveil.gov/AgendaCenter/ViewFile/Minutes/_07212022-380 https://mytown.theboringparts.com/city/rivergroveil.gov/2022/#m1567510 axon stated 1 0 0 IL
603 603 Axon Deerfield IL 2024-06-17 Fleet ALPR 155742.0 Trustee Goldstone moved to approve the Resolution waiving the competitive bidding and approving an agreement with Axon Enterprises, Inc., for the purchase of ten (10) digital in-car video system in the amount of $155,742. https://www.deerfield.il.us/AgendaCenter/ViewFile/Minutes/_06172024-1108 https://mytown.theboringparts.com/city/deerfield.il.us/2024/#m1352758 axon stated 1 0 0 IL
610 610 Axon Mundelein IL 2026-05-11 bundle/OSP 151500.0 AXON Body Worn, Fleet and ALPR Camera Storage Motion to approve purchase order number 27-01005 and payment in the amount of $151,500 to AXON Enterprises for year five of the five-year agreeme https://mundeleinil.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=3100,plainText=false) https://mytown.theboringparts.com/city/mundeleinil/#m6350762 axon stated 1 0 0 IL
621 621 Axon Naperville IL 2022-08-16 bundle/OSP 148957.85 Approve the award of Cooperative Procurement 22-230, Audio/Video Interview Room System, to Axon Enterprise, Inc. for an amount not to exceed $148,957.85 and for a five-year term https://naperville.legistar1.com/naperville/meetings/2022/8/2764_M_City_Council_22-08-16_Meeting_Minutes.pdf https://mytown.theboringparts.com/city/naperville/2022/#m325157 axon ceiling 1 0 0 IL
626 626 Axon Ottawa IL 2024-03-05 Tasers 147469.46 Moved by Commissioner Ganiere that the 5 year Quote received from Axon Enterprises Inc. in the amount of $147,469.46 for the Ottawa Police Department’s taser lease program, be accepted and paid for from the Drug Fund. https://www.cityofottawa.org/AgendaCenter/ViewFile/Minutes/_03052024-212 https://mytown.theboringparts.com/city/cityofottawa.org/2024/#m1269900 axon stated 1 0 0 IL
627 627 Axon Blue Island IL 2025-10-28 body cameras 147000.0 Adopted Resolution 2025‑051 for Axon camera system ($147,000 over 5 years) (7‑0) https://www.blueisland.org/AgendaCenter/ViewFile/Minutes/_10282025-181 https://mytown.theboringparts.com/city/blueisland.org/2025/#m1498373 axon stated 1 0 0 IL
630 630 Axon Moline IL 2026-07-08 body cameras 145889.1 Axon Enterprise, Inc. AI Assistant software contract for $145,889.10 https://molineil.granicus.com/AgendaViewer.php?view_id=1&clip_id=348 https://mytown.theboringparts.com/city/gr-molineil/#m221095 axon stated 1 0 0 IL
631 631 Axon Highwood IL 2023-06-06 body cameras 145000.0 Approved $145,000 purchase of body and vehicle cameras from Axon Enterprises in installments through 2028 (All present voting aye) https://www.cityofhighwood.com/AgendaCenter/ViewFile/Minutes/_06062023-989 https://mytown.theboringparts.com/city/cityofhighwood.com/2023/#m1507437 axon stated 1 0 0 IL
635 635 Axon DuPage County IL 2024-10-22 bundle/OSP 144049.8 Amendment to Purchase Order 6662-0001 SERV, issued to Axon Enterprise, Inc., to increase the contract encumbrance in the amount of $ 144,049.80, for a new contract total not to exceed $1,522,385.80, an increase of 10.45%. https://dupage.legistar1.com/dupage/meetings/2024/10/10692_M_DuPage_County_Board_24-10-22_Summary.pdf https://mytown.theboringparts.com/city/dupage/2024/#m560556 axon ceiling 1 0 0 IL

Next page

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