surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
1 row where ledger = "flock", state = "CA" and vendor = "Flock Group, Inc. DBA Flock Safety" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1789 | 1789 | Flock Group, Inc. DBA Flock Safety | Redondo Beach | CA | 2024-01-09 | approve an agreement | 34300.0 | APPROVE AN AGREEMENT WITH FLOCK GROUP, INC. DBA FLOCK SAFETY FOR AUTOMATIC LICENSE PLATE READERS IN AN AMOUNT NOT TO EXCEED $34,300, FOR AN INITIAL TERM OF JANUARY 9, 2024 THROUGH JANUARY 8, 2025, WITH AN OPTION TO RENEW FOR 24 MONTHS. | https://redondo.legistar1.com/redondo/meetings/2024/1/1712_A_City_Council_24-01-09_Agenda.pdf | https://mytown.theboringparts.com/city/redondo/2024/#m571785 | 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);