surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
3 rows where ledger = "sv:photo_enforce:ats" and state = "CO" sorted by amount descending
This data as json, CSV (advanced)
Suggested facets: product, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4282 | 4282 | American Traffic Solutions | Denver | CO | 2022-03-21 | photo radar and red light (approve contract) | 5660000.0 | Approves a contract with American Traffic Solutions, Inc. d/b/a/ Verra Mobility for $5,660,000 and for 5 years to provide photo radar and photo red light services citywide (POLIC-202261957). | https://denver.legistar1.com/denver/meetings/2022/3/7684_M_City_Council_22-03-21_Council_Minutes.pdf | https://mytown.theboringparts.com/city/denver/2022/#m276897 | sv:photo_enforce:ats | stated | 1 | 0 | 0 | CO |
| 4285 | 4285 | American Traffic Solutions | Denver | CO | 2022-02-15 | photo radar and red light (approve contract) | 5660000.0 | Approves a contract with American Traffic Solutions, Inc. d/b/a/ Verra Mobility for $5,660,000 and for 5 years to provide photo radar and photo red light services citywide (POLIC-202261957). | https://denver.legistar1.com/denver/meetings/2022/2/7641_A_Mayor-Council_22-02-15_Mayor-Council_Agenda.pdf | https://mytown.theboringparts.com/city/denver/2022/#m276861 | sv:photo_enforce:ats | stated | 2 | 0 | 0 | CO |
| 4286 | 4286 | American Traffic Solutions | Denver | CO | 2022-02-09 | photo radar and red-light cameras (approve contract) | 5660000.0 | Approves a contract with American Traffic Solutions, Inc. d/b/a/ Verra Mobility for $5,660,000 and for 5 years to provide photo radar and photo red light services citywide (POLIC-202261957). | https://denver.legistar1.com/denver/meetings/2022/2/7617_M_Safety%2C_Housing%2C_Education___Homelessness_Committee_22-02-09_Committee_Minutes.pdf | https://mytown.theboringparts.com/city/denver/2022/#m276854 | sv:photo_enforce:ats | stated | 3 | 0 | 0 | CO |
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);