surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
4 rows where ledger = "sv:rms:centralsquare" and state = "AL" sorted by amount descending
This data as json, CSV (advanced)
Suggested facets: city, product, amount, quote, dup_rank, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3177 | 3177 | CentralSquare | Vernon | AL | 2023-09-19 | dispatch software (approve contract) | 582117.0 | Approve and authorize the City Administrator to execute a Professional Services Agreement with CentralSquare, in substantially the same form as submitted, for a Public Safety Software System for a total amount not-to-exceed $582,117, for a three-year term. | https://cityofvernon.primegov.com/Public/CompiledDocument/5290 | https://mytown.theboringparts.com/city/cityofvernon/2023/#m681668 | sv:rms:centralsquare | stated | 1 | 0 | 0 | AL |
| 3877 | 3877 | CentralSquare | Dothan | AL | 2026-05-05 | Fusion Open Market subscription (approve contract) | 12000.0 | Approving a quote for CentralSquare ’s Fusion Open Market Annual Subscription in the amount of $12,000.00 annually from date of contract execution. | https://www.dothan.org/AgendaCenter/ViewFile/Minutes/_05052026-564 | https://mytown.theboringparts.com/city/dothan.org/#m19002 | sv:rms:centralsquare | stated | 1 | 0 | 0 | AL |
| 3175 | 3175 | CentralSquare | Vernon | AL | 2025-12-02 | warrant services & data conversion (approve contract) | 7656.0 | A. Approve and authorize the City Administrator to execute CentralSquare Technologies Quote No. Q-231025 for upgraded warrant services and data conversion for a total amount not -to-exceed $7,656.71, for the term December 1, 2025 - September 18, 2026; | https://cityofvernon.primegov.com/Public/CompiledDocument/9234 | https://mytown.theboringparts.com/city/cityofvernon/#m681776 | sv:rms:centralsquare | stated | 1 | 0 | 0 | AL |
| 3176 | 3176 | CentralSquare | Vernon | AL | 2025-11-18 | warrant services & data conversion (approve contract) | 7656.0 | A. Approve and authorize the City Administrator to execute CentralSquare Technologies Quote No. Q-231025 for upgraded warrant services and data conversion for a total amount not -to-exceed $7,656.71, for the term December 1, 2025 - September 18, 2026; | https://cityofvernon.primegov.com/Public/CompiledDocument/9176 | https://mytown.theboringparts.com/city/cityofvernon/#m681774 | sv:rms:centralsquare | stated | 2 | 0 | 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);