mytown-research: surveillance_spending: 83 rows where ledger = "sv:forensics:grayshift" sorted by amount descending

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

83 rows where ledger = "sv:forensics:grayshift" sorted by amount descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	vendor	city	state	spend_date	product	amount ▲	quote	source_document	mytown_record	ledger	amount_type	dup_rank	geo_suspect	state_norm
3869	3869	Grayshift / GrayKey	Murfreesboro	TN	2026-07-02	GrayKey software license (renew)	134340.0	Approve the twelve-month renewal of the GrayKey software license with Magnet Forensics, LLC in the amount of $134,340.	https://www.murfreesborotn.gov/AgendaCenter/ViewFile/Minutes/_07022026-2476	https://mytown.theboringparts.com/city/murfreesborotn.gov/#m22625	sv:forensics:grayshift	stated	1	0	TN
3221	3221	Grayshift / GrayKey	Oklahoma City	OK	2024-05-21	GrayKey units (purchase)	133085.0	Resolution authorizing the sole source purchase of two annual licenses for GrayKey units, Magnet Forensics (COKC00027), $133,085, retroactive to May 1, 2024 through April 30, 2025; and approving End User License Agreement.	https://okc.primegov.com/Public/CompiledDocument/64837	https://mytown.theboringparts.com/city/okc/2024/#m640657	sv:forensics:grayshift	stated	1	1	OK
3795	3795	Grayshift / GrayKey	Bakersfield	CA	2025-10-22	GrayKey software (amend)	111500.0	(revised not to exceed $111,500, and extend term 1 year) for GrayKey Software, a data extraction forensic tool.	https://pub-bakersfield.escribemeetings.com/Meeting.aspx?Id=b136cfd2-a0d8-4592-9c2f-cf16fe1c21ad&Agenda=Agenda&lang=English	https://mytown.theboringparts.com/city/pub-bakersfield/2025/#m207660	sv:forensics:grayshift	ceiling	1	0	CA
2932	2932	Grayshift / GrayKey	Ocala	FL	2026-07-21	forensic software (renew)	74740.0	Annual renewal of GrayKey forensic software for $74,740	https://ocala.legistar1.com/ocala/meetings/2026/7/3706_M_City_Council_26-07-21_Synopsis.pdf	https://mytown.theboringparts.com/city/ocala/#m808486	sv:forensics:grayshift	stated	1	0	FL
3619	3619	Grayshift / GrayKey	Ocala	FL	2025-08-05	forensic software (renew)	69520.0	Approve Fiscal Year 2024-2025 renewal of GrayKey forensic software in the amount of $69,520	https://ocala.legistar1.com/ocala/meetings/2025/8/3498_M_City_Council_25-08-05_Minutes.pdf	https://mytown.theboringparts.com/city/ocala/2025/#m328732	sv:forensics:grayshift	stated	1	0	FL
2861	2861	Grayshift / GrayKey	East Point	GA	2026-02-16	GrayKey forensic tool (renew)	68620.0	Council Approval on Vendor Magnet Forensic USA Inc., Sole Source Procurement, for the Renewal of GrayKey Cell Phone Forensic Tool. NOT TO EXCEED: $68,620.00 FUNDING SOURCE: General	https://eastpointcityga.iqm2.com/Citizens/FileOpen.aspx?Type=15&ID=2315&Inline=True	https://mytown.theboringparts.com/city/iq-eastpointcityga/#m879792	sv:forensics:grayshift	ceiling	1	0	GA
2862	2862	Grayshift / GrayKey	East Point	GA	2026-02-09	GrayKey forensic tool (renew)	68620.0	Council Discussion and Possible Action on Vendor, Magnet Forensic USA Inc., Sole Source Procurement, for the Renewal of GrayKey Cell Phone Forensic Tool. NOT TO EXCEED: $68,620.00 FUNDING SOURCE: General	https://eastpointcityga.iqm2.com/Citizens/FileOpen.aspx?Type=1&ID=3079&Inline=True	https://mytown.theboringparts.com/city/iq-eastpointcityga/#m879791	sv:forensics:grayshift	ceiling	1	0	GA
2981	2981	Grayshift / GrayKey	York County	SC	2021-05-17	forensic software licensing (renew)	64065.0	Council to approve an annual renewal for forensic software licensing agreement with Grayshift LLC, of Atlanta GA, for a total cost of 64,065.00.	https://yorkcosc.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=2011,plainText=false)	https://mytown.theboringparts.com/city/yorkcosc/2021/#m783874	sv:forensics:grayshift	stated	1	1	SC
2982	2982	Grayshift / GrayKey	York County	SC	2021-02-08	forensic software licensing (renew)	64065.0	Council to approve an annual renewal for forensic software licensing agreement with Grayshift LLC, of Atlanta GA, for a total cost of 64,065.00.	https://yorkcosc.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=4141,plainText=false)	https://mytown.theboringparts.com/city/yorkcosc/2021/#m783846	sv:forensics:grayshift	stated	2	1	SC
2980	2980	Grayshift / GrayKey	York County	SC	2022-01-13	forensic software licensing (renew)	63990.0	Council to approve an annual renewal for forensic software licensing agreement with Grayshift LLC, of Atlanta GA, for a total cost of 63,990.00	https://yorkcosc.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=442,plainText=false)	https://mytown.theboringparts.com/city/yorkcosc/2022/#m783934	sv:forensics:grayshift	stated	1	1	SC
3094	3094	Grayshift / GrayKey	Delaware County	PA	2026-02-18	GrayKey License - Premier Bundle (renew)	61395.0	Approval to purchase GrayKey License - Premier Bundle renewal for a 12 month term from May 10, 2026- May 9, 2027 using ICAC grant funds in the amount of $61,395.00.	https://delawarecopa.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=5468,plainText=false)	https://mytown.theboringparts.com/city/delawarecopa/#m705445	sv:forensics:grayshift	stated	1	0	PA
3095	3095	Grayshift / GrayKey	Delaware County	PA	2026-02-17	iPhone/Android extraction license (renew)	61395.0	Approval to purchase GrayKey License - Premier Bundle renewal for a 12 month term from May 10, 2026- May 9, 2027 using ICAC grant funds in the amount of $61,395.00.	https://delawarecopa.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=2453,plainText=false)	https://mytown.theboringparts.com/city/delawarecopa/#m705442	sv:forensics:grayshift	stated	2	0	PA
3140	3140	Grayshift / GrayKey	Morris County	NJ	2023-11-08	GrayKey licenses (purchase)	59027.0	Resolution Authorizing a State Contract purchase from Grayshift LLC to acquire proprietary software licensing for the GrayKey licenses for the amount of $59,027.50 (R23-184) (Prosecutor) (ID #11041)	https://morriscountynj.primegov.com/Public/CompiledDocument/264	https://mytown.theboringparts.com/city/morriscountynj/2023/#m685071	sv:forensics:grayshift	stated	1	0	NJ
3030	3030	Grayshift / GrayKey	New Castle County	DE	2023-11-28	forensic equipment (authorize contract to purchase)	57160.0	R23-218: AUTHORIZING THE EXECUTION OF ONE CONTRACT WITH GRAYSHIFT, LLC TO PURCHASE TWO UNITS OF FORENSIC EQUIPMENT, AND THE ASSOCIATED LICENSES, FOR POLICE INVESTIGATIONS FOR THE DEPARTMENT OF PUBLIC SAFETY, DIVISION OF POLICE IN THE AMOUNT OF $57,160.64	https://newcastlecode.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=4057,plainText=false)	https://mytown.theboringparts.com/city/newcastlecode/2023/#m745656	sv:forensics:grayshift	stated	1	0	DE
3031	3031	Grayshift / GrayKey	New Castle County	DE	2023-11-28	forensic extraction devices (purchase)	57160.0	AUTHORIZING THE EXECUTION OF ONE CONTRACT WITH GRAYSHIFT, LLC TO PURCHASE TWO UNITS OF FORENSIC EQUIPMENT, AND THE ASSOCIATED LICENSES, FOR POLICE INVESTIGATIONS FOR THE DEPARTMENT OF PUBLIC SAFETY, DIVISION OF POLICE IN THE AMOUNT OF $57,160.64	https://newcastlecode.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=4033,plainText=false)	https://mytown.theboringparts.com/city/newcastlecode/2023/#m745655	sv:forensics:grayshift	stated	2	0	DE
3106	3106	Grayshift / GrayKey	Delaware County	PA	2025-04-02	GrayKey license (renew)	57110.0	Approval to request ICAC grant funds to renew the Magnet Forensics GrayKey license in the amount of $57,110.00, for a term from May 10, 2025, to May 9, 2026.	https://delawarecopa.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=832,plainText=false)	https://mytown.theboringparts.com/city/delawarecopa/2025/#m705328	sv:forensics:grayshift	stated	1	0	PA
3107	3107	Grayshift / GrayKey	Delaware County	PA	2025-04-01	GrayKey license (renew)	57110.0	Approval to request ICAC grant funds to renew the Magnet Forensics GrayKey license in the amount of $57,110.00, for a term from May 10, 2025, to May 9, 2026.	https://delawarecopa.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=615,plainText=false)	https://mytown.theboringparts.com/city/delawarecopa/2025/#m705326	sv:forensics:grayshift	stated	2	0	PA
3626	3626	Grayshift / GrayKey	Ocala	FL	2024-08-20	forensic software (renew)	55055.0	Approve the Fiscal Year 2023-24 annual renewal of Graykey forensic software in the amount of $55,055	https://ocala.legistar1.com/ocala/meetings/2024/8/1567_M_City_Council_24-08-20_Minutes.pdf	https://mytown.theboringparts.com/city/ocala/2024/#m328592	sv:forensics:grayshift	stated	1	0	FL
3116	3116	Grayshift / GrayKey	Delaware County	PA	2024-05-01	license renewal (purchase renewal)	54390.0	Approval to purchase the renewal of GrayKey License using ICAC grant funds in the amount of $54,390.00.	https://delawarecopa.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=852,plainText=false)	https://mytown.theboringparts.com/city/delawarecopa/2024/#m705266	sv:forensics:grayshift	stated	1	0	PA
3117	3117	Grayshift / GrayKey	Delaware County	PA	2024-04-30	GrayKey License renewal (purchase renewal)	54390.0	Approval to purchase the renewal of GrayKey License using ICAC grant funds in the amount of $54,390.00.	https://delawarecopa.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=631,plainText=false)	https://mytown.theboringparts.com/city/delawarecopa/2024/#m705265	sv:forensics:grayshift	stated	2	0	PA
3152	3152	Grayshift / GrayKey	Cumberland County	NJ	2024-02-27	Graykey license (award contract)	54390.0	Resolution Authorizing the Award of a Non-Fair And Open Contract For Graykey License Premier Unlimited IOS And Android Extractions For Proprietary Software/Hardware (Magnet Forensics, LLC) ($54,390.00)	https://cumberlandcountynj.primegov.com/Public/CompiledDocument/114	https://mytown.theboringparts.com/city/cumberlandcountynj/2024/#m684870	sv:forensics:grayshift	stated	1	0	NJ
2852	2852	Grayshift / GrayKey	Cornwall	ON	2026-03-05	cell phone extraction tech (approve contract)	54385.0	That the CPSB approve GrayKey/Magnet Forensics proposal to provide the technology to lawfully access and extract data from mobile devices at the quoted price of $54,385 USD plus tax and is supported by a $25,000 grant from the Criminal Investigation Service of Ontario.	https://pub-cornwall.escribemeetings.com/Meeting.aspx?Id=c9795d65-a6ea-4c45-a94b-b08dbbe5e4fe&Agenda=Agenda&lang=English	https://canada.theboringparts.com/city/pub-cornwall/#m935589	sv:forensics:grayshift	proposed	1	0	ON
3640	3640	Grayshift / GrayKey	Mesquite	TX	2023-10-16	GrayKey license renewal (renew)	50595.0	Bid No. 2024-012 - GrayKey License Renewal FY 2024. (Staff recommends purchase from sole source provider Grayshift, LLC, in an amount not to exceed $50,595.00.)	https://legistar1.granicus.com/Mesquite/meetings/2023/10/1467_M_City_Council_23-10-16_Minutes_-_Final.pdf	https://mytown.theboringparts.com/city/mesquite/2023/#m316687	sv:forensics:grayshift	ceiling	1	0	TX
3144	3144	Grayshift / GrayKey	Morris County	NJ	2021-11-10	iPhone/Android extraction (award contract)	46070.0	Resolution for the Award of contract C22-18 for proprietary software & hardware licensing & maintenance to Grayshift, LLC for $46,070.00 for a 12 month period	https://morriscountynj.primegov.com/Public/CompiledDocument/727	https://mytown.theboringparts.com/city/morriscountynj/2021/#m684973	sv:forensics:grayshift	stated	1	0	NJ
3142	3142	Grayshift / GrayKey	Morris County	NJ	2022-10-26	iPhone extraction devices (award contract)	45995.0	Resolution authorizing the award of a non-fair & open contract for proprietary software to Grayshift LLC for $45,995.00 (Prosecutor) (ID #9815)	https://morriscountynj.primegov.com/Public/CompiledDocument/868	https://mytown.theboringparts.com/city/morriscountynj/2022/#m685020	sv:forensics:grayshift	stated	1	0	NJ
3499	3499	Grayshift / GrayKey	Mobile	AL	2022-02-22	forensic science software license (approve purchase order)	45995.0	Approve purchase order to Grayshift for annual renewal of forensic science software license; $45,995.00 (sponsored by Mayor Stimpson) (submitted by John Paine, Purchasing Dept.).	https://mobileal.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=663,plainText=false)	https://mytown.theboringparts.com/city/mobileal/2022/#m454719	sv:forensics:grayshift	stated	1	0	AL
3500	3500	Grayshift / GrayKey	Mobile	AL	2022-02-15	forensic science software license (approve purchase order)	45995.0	Approve purchase order to Grayshift for annual renewal of forensic science software license; $45,995.00	https://mobileal.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=673,plainText=false)	https://mytown.theboringparts.com/city/mobileal/2022/#m454718	sv:forensics:grayshift	stated	1	0	AL
2780	2780	Grayshift / GrayKey	Sterling Heights	MI	2025-11-05	GrayKey software subscription (purchase)	38660.0	RESOLVED , to: 1. Purchase the GrayKey software technology subscription from Magnet Forensics, LLC, 931 Monroe Drive NE, Suite A102 -340, Atlanta, GA 30308, from November 21, 2025, through November 20, 2028, at a total cost of $38,660;	https://www.sterlingheights.gov/AgendaCenter/ViewFile/Minutes/_11052025-2755	https://mytown.theboringparts.com/city/sterlingheights.gov/2025/#m1237883	sv:forensics:grayshift	stated	1	0	MI
3504	3504	Grayshift / GrayKey	Mobile	AL	2021-05-04	mobile device forensic software licenses (approve purchase order)	38602.0	Approve purchase order to Grayshift for mobile device forensic software annual licenses renewal, $38,602.79	https://mobileal.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=530,plainText=false)	https://mytown.theboringparts.com/city/mobileal/2021/#m454676	sv:forensics:grayshift	stated	1	0	AL
3505	3505	Grayshift / GrayKey	Mobile	AL	2021-04-27	mobile device forensic software (approve purchase order)	38602.0	Approve purchase order to Grayshift for mobile device forensic software annual licenses renewal, $38,602.79	https://mobileal.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=545,plainText=false)	https://mytown.theboringparts.com/city/mobileal/2021/#m454675	sv:forensics:grayshift	stated	2	0	AL
2849	2849	Grayshift / GrayKey	Ardmore	OK	2026-07-20	GrayKey license (renew)	36996.0	Consideration and Possible Action on the Renewal of a GrayKey Mobile Extraction Device License Agreement by and between the City of Ardmore and Carahsoft Technology Corporation, for the Ardmore Police Department Crime Scene Investigation Forensic Lab, through Oklahoma State Contract SW1041, in the Total Amount of $36,996.30	https://www.ardmorecity.org/AgendaCenter/ViewFile/Agenda/_07202026-1943	https://mytown.theboringparts.com/city/ardmorecity.org/#m1005448	sv:forensics:grayshift	stated	1	0	OK
3101	3101	Grayshift / GrayKey	Delaware County	PA	2025-06-18	GrayKey extraction devices (renew agreement)	34760.0	Approval to renew agreement with Magnet Forensics (GrayKey) for Narcotics/Intelligence in the amount of $34,760.00.	https://delawarecopa.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=891,plainText=false)	https://mytown.theboringparts.com/city/delawarecopa/2025/#m705360	sv:forensics:grayshift	stated	1	0	PA
3103	3103	Grayshift / GrayKey	Delaware County	PA	2025-06-17	GrayKey extraction devices (renew)	34760.0	Approval to renew agreement with Magnet Forensics (GrayKey) for Narcotics/Intelligence in the amount of $34,760.00. Subject to Solicitor's approval.	https://delawarecopa.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=663,plainText=false)	https://mytown.theboringparts.com/city/delawarecopa/2025/#m705357	sv:forensics:grayshift	stated	1	0	PA
3146	3146	Grayshift / GrayKey	Cumberland County	NJ	2025-03-25	Graykey license (award contract)	34760.0	(PROSECUTOR) Resolution Authorizing the Award of a Non-Fair And Open Contract For Graykey License Premier Unlimited IOS And Android Extractions For Proprietary Software/Hardware (Magnet Forensics, LLC - $34,760)	https://cumberlandcountynj.primegov.com/Public/CompiledDocument/624	https://mytown.theboringparts.com/city/cumberlandcountynj/#m684923	sv:forensics:grayshift	stated	1	0	NJ
3467	3467	Grayshift / GrayKey	Waterloo	IA	2025-07-21	software renewal (renew)	34760.0	Police (GrayKey Software Renewal) Amount: $34,760.00 Expenditure: Annual GrayKey software renewal for FY26.	https://waterlooia.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=1893,plainText=false)	https://mytown.theboringparts.com/city/waterlooia/2025/#m461530	sv:forensics:grayshift	stated	1	0	IA
2717	2717	Grayshift / GrayKey	Ardmore	OK	2025-09-15	iPhone/Android extraction device (renew)	33891.0	Consideration and Possible Action for the Renewal of the Advanced License for the GrayKey Mobil Extraction Device for the Ardmore Police Department Forensic Lab utilizing NASPO Contract SW1022C from Carahsoft Technology Corporation to be valid from September 27, 2025 to September 26, 2026 in the Total Amount of $33,891.00	https://www.ardmorecity.org/AgendaCenter/ViewFile/Agenda/_09152025-1826	https://mytown.theboringparts.com/city/ardmorecity.org/2025/#m1327261	sv:forensics:grayshift	stated	1	0	OK
2968	2968	Grayshift / GrayKey	Bucks County	PA	2024-05-15	forensic software licenses (approve contract)	33105.0	With: Magnet Forensics LLC f/k/a Grayshift, LLC Atlanta, GA Amount: $33,105** (County 100%) Purpose: Approve contract to provide forensic software licenses.	https://buckscopa.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=1762,plainText=false)	https://mytown.theboringparts.com/city/buckscopa/2024/#m795145	sv:forensics:grayshift	stated	1	0	PA
3078	3078	Grayshift / GrayKey	Davenport	IA	2025-01-08	Graykey license (approve contract)	33105.0	Magnet Forensics, LLC \| Graykey license \| Amount: $33,105	https://davenportia.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=5771,plainText=false)	https://mytown.theboringparts.com/city/davenportia/2025/#m708254	sv:forensics:grayshift	stated	1	0	IA
3573	3573	Grayshift / GrayKey	Salinas	CA	2024-02-06	GrayKey software license (approve payment)	33105.0	Resolution authorizing payment of $33,105 to Magnet Forensics for the annual license fee for GrayKey software was approved.	https://legistar2.granicus.com/salinas/meetings/2024/2/2555_M_City_Council_24-02-06_Meeting_Minutes.pdf	https://mytown.theboringparts.com/city/salinas/2024/#m345208	sv:forensics:grayshift	stated	1	0	CA
3372	3372	Grayshift / GrayKey	Jackson County	MO	2023-06-05	mobile forensic equipment (awarding a contract)	32454.0	Appropriating $32,454.00 from the undesignated fund balance of the 2023 Anti-Crime Sales Tax Fund in acceptance of grant funds and awarding a contract for the furnishing of mobile forensic equipment and software to Grayshift, LLC, of Atlanta, GA, as a sole source purchase.	https://jacksonco.legistar1.com/jacksoncounty/meetings/2023/6/9129_M_County_Legislature_23-06-05_JOURNAL.pdf	https://mytown.theboringparts.com/city/jacksonco/2023/#m551347	sv:forensics:grayshift	stated	1	0	MO
3373	3373	Grayshift / GrayKey	Jackson County	MO	2023-06-12	mobile forensic equipment and software (award contract)	32454.0	AN ORDINANCE appropriating $32,454.00 from the undesignated fund balance of the 2023 Anti-Crime Sales Tax Fund in acceptance of grant funds and awarding a contract for the furnishing of mobile forensic equipment and software to Grayshift, LLC, of Atlanta, GA, as a sole source purchase.	https://jacksonco.legistar1.com/jacksoncounty/meetings/2023/6/9131_M_Finance_and_Audit_Committee_23-06-12_Meeting_Minutes.pdf	https://mytown.theboringparts.com/city/jacksonco/2023/#m551345	sv:forensics:grayshift	stated	1	0	MO
3374	3374	Grayshift / GrayKey	Jackson County	MO	2023-06-12	mobile forensic equipment (awarding a contract)	32454.0	AN ORDINANCE appropriating $32,454.00 from the undesignated fund balance of the 2023 Anti-Crime Sales Tax Fund in acceptance of grant funds and awarding a contract for the furnishing of mobile forensic equipment and software to Grayshift, LLC, of Atlanta, GA, as a sole source purchase.	https://jacksonco.legistar1.com/jacksoncounty/meetings/2023/6/9132_M_County_Legislature_23-06-12_JOURNAL.pdf	https://mytown.theboringparts.com/city/jacksonco/2023/#m551344	sv:forensics:grayshift	stated	2	0	MO
3114	3114	Grayshift / GrayKey	Delaware County	PA	2024-07-03	forensic extraction devices (renew)	31450.0	Approval to renew Agreement with Magnet Forensics (GrayKey) for Narcotics/Intelligence in the amount of $31,450.	https://delawarecopa.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=896,plainText=false)	https://mytown.theboringparts.com/city/delawarecopa/2024/#m705274	sv:forensics:grayshift	stated	1	0	PA
3115	3115	Grayshift / GrayKey	Delaware County	PA	2024-07-02	phone extraction system (renew)	31450.0	Approval to renew Agreement with Magnet Forensics (GrayKey) for Narcotics/Intelligence in the amount of $31,450.	https://delawarecopa.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=667,plainText=false)	https://mytown.theboringparts.com/city/delawarecopa/2024/#m705273	sv:forensics:grayshift	stated	2	0	PA
3156	3156	Grayshift / GrayKey	Cumberland County	NJ	2022-12-20	GrayKey license (award contract)	31420.0	Resolution Authorizing the Award of a Non-Fair And Open Contract For Graykey License Advanced Unlimited Consent and BFU Extractions As Per N.J.S.A. 40A:11-5(1)(dd) For The Prosecutor's Office (Grayshift LLC) ($31,420.00)	https://cumberlandcountynj.primegov.com/Public/CompiledDocument/804	https://mytown.theboringparts.com/city/cumberlandcountynj/2022/#m684821	sv:forensics:grayshift	stated	1	0	NJ
2783	2783	Grayshift / GrayKey	Sterling Heights	MI	2023-11-07	Graykey software subscription (purchase)	31115.0	Purchase a two-year software subscription to Graykey technology at the Essentials level, including a twenty (20) Advanced Actions expansion pack, from Magnet Forensics, Inc., 2220 University Ave East, Suite 200. Waterloo, Ontario N2K 0A8, at a cumulative cost of $31,115;	https://www.sterlingheights.gov/AgendaCenter/ViewFile/Minutes/_11072023-2575	https://mytown.theboringparts.com/city/sterlingheights.gov/#m1237823	sv:forensics:grayshift	stated	1	0	MI
2503	2503	Grayshift / GrayKey	Starkville	MS	2023-10-17	forensic mobile data software (accept grant and enter into agreement)	30795.0	$30,795.00 FOR THE LICENSE RENEWAL OF GRAYKEY DIGITAL FORENSIC MOBILE DATA SOFTWARE AND EQUIPMENT.	https://www.cityofstarkville.org/AgendaCenter/ViewFile/Minutes/_10172023-877	https://mytown.theboringparts.com/city/cityofstarkville.org/#m1574629	sv:forensics:grayshift	stated	1	0	MS
2533	2533	Grayshift / GrayKey	Gloucester County	NJ	2023-05-24	iPhone passcode-bypass (approve contract)	30795.0	RESOLUTION AUTHORIZING A CONTRACT WITH GRAYSHIFT, LLC FROM JUNE 30, 2023 TO JUNE 29, 2024 FOR A TOTAL AMOUNT OF $30,795.00.	https://www.gloucestercountynj.gov/AgendaCenter/ViewFile/Minutes/_05242023-290	https://mytown.theboringparts.com/city/gloucestercountynj.gov/2023/#m1541748	sv:forensics:grayshift	stated	1	0	NJ
3083	3083	Grayshift / GrayKey	Davenport	IA	2023-11-01	GrayKey license (purchase)	30795.0	Grayshift LLC \| GrayKey annual license \| Amount: $30,795	https://davenportia.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=2936,plainText=false)	https://mytown.theboringparts.com/city/davenportia/2023/#m707987	sv:forensics:grayshift	stated	1	0	IA
3123	3123	Grayshift / GrayKey	Delaware County	PA	2023-06-07	forensic license (purchase)	30795.0	Approval to purchase Grayshift forensic license in the amount of $30,795.00 using PCCD ICAC grant funds.	https://delawarecopa.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=880,plainText=false)	https://mytown.theboringparts.com/city/delawarecopa/2023/#m705222	sv:forensics:grayshift	stated	1	0	PA

Advanced export

JSON shape: default, array, newline-delimited

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