surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
2 rows where ledger = "flock", state = "CA" and vendor = "Flock Systems" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1554 | 1554 | Flock Systems | Ontario | CA | 2024-01-16 | authorize purchase and implementation | 1487500.0 | That City Council authorize the City Manager or his designee to execute all documents necessary for the purchase and implementation of twenty Automated License Plate Recognition (ALPR) cameras from Flock Systems of Atlanta, GA in the amount of $1,487,500. | https://ontarioca.granicus.com/AgendaViewer.php?view_id=1&clip_id=310 | https://mytown.theboringparts.com/city/gr-ontarioca/2024/#m153937 | flock | stated | 1 | 0 | 0 | CA |
| 2157 | 2157 | Flock Systems | Saratoga | CA | 2025-11-05 | approve amendment | 187000.0 | Approve Amendment No. 2 to the Agreement with Flock Systems for Automated License Plate Reader Systems (ALPRS) for a new annual amount not to exceed $187,000. | https://www.saratoga.ca.us/AgendaCenter/ViewFile/Minutes/_11052025-1380 | https://mytown.theboringparts.com/city/saratoga.ca.us/2025/#m1376814 | flock | ceiling | 1 | 0 | 0 | CA |
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);