surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
3 rows where ledger = "sv:motorola:motorola", state = "AL" and vendor = "Motorola Solutions" sorted by amount descending
This data as json, CSV (advanced)
Suggested facets: geo_suspect, spend_date (date)
| Link | rowid | vendor | city | state | spend_date | product | amount ▲ | quote | source_document | mytown_record | ledger | amount_type | dup_rank | geo_suspect | anomaly | state_norm |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4356 | 4356 | Motorola Solutions | Mobile | AL | 2026-04-14 | surveillance cameras (approve purchase order) | 141373.0 | Approve purchase order to Motorola Solutions, Inc. for surveillance cameras and accessories for city-wide camera system upgrades; $141,373.07 | https://mobileal.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=2580,plainText=false) | https://mytown.theboringparts.com/city/mobileal/#m70652 | sv:motorola:motorola | stated | 1 | 0 | 0 | AL |
| 2561 | 2561 | Motorola Solutions | Gadsden | AL | 2025-09-09 | in-car camera video storage (approve contract) | 75350.0 | RESOLUTION NO. R-550-25 AUTHORIZING AGREEMENT WITH MOTOROLA (Authorizing Agreement - Motorola - For storage of Gadsden Police Department in-car camera video - $75,350.00 for first year; $45,600.00 for years 2-5) | https://www.cityofgadsden.com/AgendaCenter/ViewFile/Minutes/_09092025-1261 | https://mytown.theboringparts.com/city/cityofgadsden.com/2025/#m1499108 | sv:motorola:motorola | stated | 1 | 0 | 0 | AL |
| 2911 | 2911 | Motorola Solutions | Lee County | AL | 2025-12-08 | body cam repair (purchase) | 1000.0 | Motorola Solutions, Inc. Body Cam Repair/LCSO $1,000.00 | https://leecoal.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=972,plainText=false) | https://mytown.theboringparts.com/city/leecoal/2025/#m829748 | sv:motorola:motorola | stated | 1 | 1 | 0 | AL |
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);