surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
1 row where ledger = "sv:photo_enforce:verra" and state = "PA" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4262 | 4262 | Verra Mobility | Pittsburgh | PA | 2025-08-26 | red-light cameras (authorize agreement) | 13977973.0 | Resolution authorizing the Mayor and the Director of the Department of Mobility and Infrastructure to enter into an Agreement or Agreements with Verra Mobility for costs associated with the design, construction, and maintenance of the Automated Red Light Enforcement Program; providing for the payment of the costs thereof, not to exceed Thirteen Million Nine Hundred Seventy-Seven Thousand Nine Hundred Seventy-Three Dollars ($13,977,973.00), with costs assessed on a fixed per-system basis and payable only upon usage, reimbursable at 100% under a five-year contract term. | https://pittsburgh.legistar1.com/pittsburgh/meetings/2025/8/11661_M_City_Council_25-08-26_Meeting_Minutes.pdf | https://mytown.theboringparts.com/city/pittsburgh/2025/#m335705 | sv:photo_enforce:verra | ceiling | 1 | 0 | 0 | PA |
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);