surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
3 rows where ledger = "sv:camera:avigilon", state = "ME" and vendor = "Avigilon" sorted by amount descending
This data as json, CSV (advanced)
Suggested facets: spend_date, product, amount, quote, dup_rank, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2840 | 2840 | Avigilon | Bangor | ME | 2024-04-01 | security camera software (purchase) | 69000.0 | The Information Services Department is requesting Finance Committee approval for $69,000.00 for the purchase of Avigilon security camera software and camera licensing for City Hall, Airport, and the Cross Insurance Center. | https://www.bangormaine.gov/AgendaCenter/ViewFile/Minutes/_04012024-61 | https://mytown.theboringparts.com/city/bangormaine.gov/2024/#m1096391 | sv:camera:avigilon | stated | 1 | 0 | 0 | ME |
| 2841 | 2841 | Avigilon | Bangor | ME | 2024-04-01 | security camera software (purchase) | 69000.0 | The Information Services Department is requesting Finance Committee approval for $69,000.00 for the purchase of Avigilon security camera software and camera licensing for City Hall, Airport, and the Cross Insurance Center. | https://www.bangormaine.gov/AgendaCenter/ViewFile/Agenda/_04012024-141 | https://mytown.theboringparts.com/city/bangormaine.gov/2024/#m1096124 | sv:camera:avigilon | stated | 2 | 0 | 0 | ME |
| 4365 | 4365 | Avigilon | Bangor | ME | 2026-06-17 | camera server upgrade (budget) | 20000.0 | Upgrade/Replacement of Avigilon camera server 20,000 Y 20,000 Unassigned Fund Balance | https://www.bangormaine.gov/AgendaCenter/ViewFile/Agenda/_06172026-828 | https://mytown.theboringparts.com/city/bangormaine.gov/#m11624 | sv:camera:avigilon | stated | 1 | 0 | 0 | ME |
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);