surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
6 rows where state = "CA" and vendor = "SoundThinking" sorted by amount descending
This data as json, CSV (advanced)
Suggested facets: city, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3823 | 3823 | SoundThinking | Oakland | CA | 2024-09-10 | gunshot detection subscription (renew) | 2525010.0 | Adopt A Resolution Authorizing The City Administrator To (1) Renew The Agreement Which Expired June 30, 2024 With Soundthinking Inc. For Gunshot Location Detection Subscription Service Coverage For Three Years In An Amount Not To Exceed Eight Hundred Forty-One Thousand Six Hundred Seventy Dollars ($841,670) For Each Year For A Total Not To Exceed Two Million Five Hundred Twenty Five Thousand Ten Dollars ($2,525,010) For The Period Beginning July 1, 2024 And Ending June 30, 2027; | https://oakland.legistar1.com/oakland/meetings/2024/9/9177_A__Public_Safety_Committee_-_CANCELLED_24-09-10__Agenda.pdf | https://mytown.theboringparts.com/city/oakland/2024/#m146856 | sv:gunshot:soundthinking | ceiling | 1 | 0 | 0 | CA |
| 3824 | 3824 | SoundThinking | Oakland | CA | 2024-10-08 | gunshot detection subscription (renew) | 2525010.0 | Adopt A Resolution Authorizing The City Administrator To (1) Renew The Agreement Which Expired June 30, 2024 With Soundthinking Inc. For Gunshot Location Detection Subscription Service Coverage For Three Years In An Amount Not To Exceed Eight Hundred Forty-One Thousand Six Hundred Seventy Dollars ($841,670) For Each Year For A Total Not To Exceed Two Million Five Hundred Twenty Five Thousand Ten Dollars ($2,525,010) For The Period Beginning July 1, 2024 And Ending June 30, 2027; | https://oakland.legistar1.com/oakland/meetings/2024/10/9193_M__Public_Safety_Committee_24-10-08_Meeting_Minutes.pdf | https://mytown.theboringparts.com/city/oakland/2024/#m146841 | sv:gunshot:soundthinking | ceiling | 2 | 0 | 0 | CA |
| 3821 | 3821 | SoundThinking | Oakland | CA | 2024-07-11 | gunshot detection subscription (renew) | 841670.0 | Renew The Agreement Which Expired June 30, 2024 With Soundthinking Inc. For Gunshot Location Detection Subscription Service Coverage For Three Years In An Amount Not To Exceed Eight Hundred Forty-One Thousand Six Hundred Seventy Dollars ($841,670) For Each Year | https://oakland.legistar1.com/oakland/meetings/2024/7/9150_M__Rules___Legislation_Committee_24-07-11_Meeting_Minutes.pdf | https://mytown.theboringparts.com/city/oakland/2024/#m146879 | sv:gunshot:soundthinking | ceiling | 1 | 0 | 0 | CA |
| 3562 | 3562 | SoundThinking | San Pablo | CA | 2024-07-01 | gunshot detection service (authorize three-year service agreement) | 406527.0 | AUTHORIZING THE CITY MANAGER TO ENTER INTO A THREE-YEAR SERVICE AGREEMENT WITH SOUNDTHINKING, INC., FORMERLY SHOTSPOTTER, INC., AT A TOTAL COST NOT TO EXCEED $406,527, SUBJECT TO FUNDING AVAILABILITY | http://sanpablo.legistar1.com/sanpablo/meetings/2024/7/1469_M_City_Council_24-07-01_Meeting_Minutes.pdf | https://mytown.theboringparts.com/city/sanpablo/2024/#m350577 | sv:gunshot:soundthinking | ceiling | 1 | 0 | 0 | CA |
| 3563 | 3563 | SoundThinking | San Pablo | CA | 2024-06-26 | gunshot detection contract (authorize contract) | 406000.0 | recommend approval to the City Council to authorize a 3-year contract with Soundthinking, Inc. at an estimated cost of $406,000 which is budgeted within the Police Department FY 2024-25 & FY 2025-26 departmental budget. | http://sanpablo.legistar1.com/sanpablo/meetings/2024/6/1506_M_Public_Safety_Standing_Committee_24-06-26_Meeting_Minutes.pdf | https://mytown.theboringparts.com/city/sanpablo/2024/#m350576 | sv:gunshot:soundthinking | recommended | 1 | 0 | 0 | CA |
| 2984 | 2984 | SoundThinking | Montebello | CA | 2024-03-27 | ResourceRouter software (award contract) | 88500.0 | Authorize the City Manager to execute a professional service agreement with SoundThinking for Subscription Based "ResourceRouter" Resource Management System (Crime Analytics/Mapping Software) for three (3) years for an amount of $88,500; | https://montebelloca.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=5793,plainText=false) | https://mytown.theboringparts.com/city/montebelloca/2024/#m782967 | sv:gunshot:soundthinking | stated | 1 | 0 | 0 | CA |
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);