surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
3 rows where ledger = "sv:fusion:fusus" and state = "NC" sorted by amount descending
This data as json, CSV (advanced)
Suggested facets: amount_type, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3535 | 3535 | Fusus (Axon) | Winston-Salem | NC | 2022-03-28 | FususONE software (award purchase order) | 49900.0 | Resolution Awarding a Purchase Order for FususONE Software to Fusus, LLC - $49,900. (Recommended by Finance Committee) | https://winston-salem.legistar1.com/winston-salem/meetings/2022/3/2411_A_City_Council_22-03-28_City_Council_Agenda.pdf | https://mytown.theboringparts.com/city/winston-salem/2022/#m365206 | sv:fusion:fusus | recommended | 1 | 0 | 0 | NC |
| 3536 | 3536 | Fusus (Axon) | Winston-Salem | NC | 2022-01-03 | Security Camera Management System (approve contract) | 49900.0 | Resolution Approving a Contract with Fusus, LLC for Security Camera Management System - $49,900. (Recommended by Finance Committee) | https://winston-salem.legistar1.com/winston-salem/meetings/2022/1/2406_A_City_Council_22-01-03_City_Council_Agenda.pdf | https://mytown.theboringparts.com/city/winston-salem/2022/#m365188 | sv:fusion:fusus | recommended | 1 | 0 | 0 | NC |
| 3537 | 3537 | Fusus (Axon) | Winston-Salem | NC | 2021-12-13 | security camera management system (approving a contract) | 49900.0 | Resolution Approving a Contract with Fusus, LLC for Security Camera Management System - $49,900. | https://winston-salem.legistar1.com/winston-salem/meetings/2021/12/2392_A_Finance_Committee_21-12-13_Committee_Agenda.pdf | https://mytown.theboringparts.com/city/winston-salem/2021/#m365184 | sv:fusion:fusus | stated | 1 | 0 | 0 | NC |
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);