surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
3 rows where ledger = "sv:radio_infra:motorola", state = "SC" and vendor = "Motorola Solutions" sorted by amount descending
This data as json, CSV (advanced)
Suggested facets: city, amount, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4028 | 4028 | Motorola Solutions | Summerville | SC | 2025-08-11 | two-way radios (issue purchase order) | 478304.0 | Authorization to issue a purchase order to Motorola Solutions Request in the amount of $478,304.93 for fire and police radios (on state contract). | https://www.summervillesc.gov/AgendaCenter/ViewFile/Minutes/_08112025-1139 | https://mytown.theboringparts.com/city/summervillesc.gov/2025/#m1332772 | sv:radio_infra:motorola | stated | 1 | 0 | 0 | SC |
| 4156 | 4156 | Motorola Solutions | Lancaster County | SC | 2024-06-18 | two-way radios (approve budget line) | 28549.0 | 25 Motorola Radios Fire/Public Corns 28,549 7 | https://lancastercosc.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=363,plainText=false) | https://mytown.theboringparts.com/city/lancastercosc/2024/#m754434 | sv:radio_infra:motorola | stated | 1 | 0 | 0 | SC |
| 4158 | 4158 | Motorola Solutions | Lancaster County | SC | 2024-05-02 | two-way radios (approve) | 28549.0 | 25 Motorola Radios Fire/Public Corns 28,549 | https://lancastercosc.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=459,plainText=false) | https://mytown.theboringparts.com/city/lancastercosc/2024/#m754424 | sv:radio_infra:motorola | stated | 1 | 0 | 0 | SC |
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);