surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
2 rows where ledger = "sv:camera:avigilon" and state = "TN" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3243 | 3243 | Avigilon | Blount County | TN | 2019-11-21 | camera license upgrade (budget increase) | 42647.0 | Resolution No. 19-11-003, Budget Increase - Circuit Court Clerk - $42,647.00 (New computers, monitors, and upgrade for Avigilon camera license) | http://blounttn.legistar1.com/blounttn/meetings/2019/11/1233_M_Board_of_Commissioners_19-11-21_Meeting_Minutes.pdf | https://mytown.theboringparts.com/city/blounttn/#m608828 | sv:camera:avigilon | stated | 1 | 1 | 0 | TN |
| 3244 | 3244 | Avigilon | Blount County | TN | 2019-11-12 | camera license upgrade (budget increase) | 42647.0 | Resolution No. 19-11-003, Budget Increase - Circuit Court Clerk - $42,647.00 (New computers, monitors, and upgrade for Avigilon camera license) | http://blounttn.legistar1.com/blounttn/meetings/2019/11/1255_M_Budget_Committee_19-11-12_Meeting_Minutes.pdf | https://mytown.theboringparts.com/city/blounttn/#m608806 | sv:camera:avigilon | stated | 2 | 1 | 0 | TN |
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);