surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
4 rows where state = "GA" and vendor = "ShotSpotter" sorted by amount descending
This data as json, CSV (advanced)
Suggested facets: spend_date, product, amount, quote, amount_type, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3507 | 3507 | ShotSpotter | Macon-Bibb County | GA | 2021-09-14 | gunshot detection subscription (appropriate budget) | 1970000.0 | An Ordinance to appropriate up to $1,970,000 to be paid from American Rescue Plan Act Funds for the purpose of funding an agreement with ShotSpotter, Inc for gunshot location and response services (Sponsored by Mayor Lester M. Miller) | https://maconbibbcoga.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=658,plainText=false) | https://mytown.theboringparts.com/city/maconbibbcoga/2021/#m449498 | sv:gunshot:shotspotter | ceiling | 1 | 0 | 0 | GA |
| 3508 | 3508 | ShotSpotter | Macon-Bibb County | GA | 2021-09-14 | gunshot detection subscription (approve contract) | 1970000.0 | A Resolution authorizing the Mayor to execute an agreement with ShotSpotter, Inc for the provision of gunshot detection, location and forensic analysis services, in a total amount of $1,970,000 for four years of service to be paid from American Rescue Plan Act Funds (Sponsored by Mayor Lester M. Miller) | https://maconbibbcoga.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=657,plainText=false) | https://mytown.theboringparts.com/city/maconbibbcoga/2021/#m449497 | sv:gunshot:shotspotter | stated | 2 | 0 | 0 | GA |
| 3810 | 3810 | ShotSpotter | Macon-Bibb County | GA | 2026-06-02 | gunshot detection subscription (approve contract) | 524000.0 | A Resolution Of The Macon-Bibb County Commission Authorizing The Mayor To Execute An Agreement With Shotspotter, Inc. For The Provision Of Gunshot Detection, Location, And Forensic Analysis Services, In The Amount Of $524,000.00 Per Year For A Term Of Three Years, To Be Paid From Public Safety Fund | https://maconbibbcoga.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=3550,plainText=false) | https://mytown.theboringparts.com/city/maconbibbcoga/#m168238 | sv:gunshot:shotspotter | stated | 1 | 0 | 0 | GA |
| 3811 | 3811 | ShotSpotter | Macon-Bibb County | GA | 2026-06-02 | gunshot detection subscription (authorize agreement) | 524000.0 | A Resolution Of The Macon-Bibb County Commission Authorizing The Mayor To Execute An Agreement With Shotspotter, Inc. For The Provision Of Gunshot Detection, Location, And Forensic Analysis Services, In The Amount Of $524,000.00 Per Year For A Term Of Three Years, To Be Paid From Public Safety Fund | https://maconbibbcoga.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=3536,plainText=false) | https://mytown.theboringparts.com/city/maconbibbcoga/#m168236 | sv:gunshot:shotspotter | stated | 2 | 0 | 0 | GA |
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);