surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
1 row where state = "CA" and vendor = "Securus Technologies" sorted by amount descending
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3402 | 3402 | Securus Technologies | Fresno County | CA | 2023-04-25 | inmate phone call management (approve contract) | 264000.0 | Approve and authorize the Chairman to execute an Agreement with Securus Technologies, LLC to provide telephone call management and monitoring services to the Juvenile Justice Campus, effective upon execution, not to exceed five consecutive years, which includes a three-year base contract with two optional one-year extensions, total not to exceed $264,000 | https://fresnocounty.legistar1.com/fresnocounty/meetings/2023/4/9924_M_Board_of_Supervisors_23-04-25_Action_Summary.pdf | https://mytown.theboringparts.com/city/fresnocounty/2023/#m543386 | sv:jail:securus | ceiling | 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);