surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
2 rows where state = "GA" and vendor = "FLOCK" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1752 | 1752 | FLOCK | McDonough | GA | 2023-06-20 | approve the proposal to purchase | 363000.0 | Councilmember Reeves motioned to approve the proposal from FLOCK to purchase a total of 28 cameras, at a total cost of $363,000, to be paid over a five -year period, to be funded with ARPA Funds; | https://mcdonoughga.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=1795,plainText=false) | https://mytown.theboringparts.com/city/mcdonoughga/2023/#m530925 | flock | proposed | 1 | 0 | 0 | GA |
| 1755 | 1755 | FLOCK | McDonough | GA | 2024-05-20 | approve contract | 40650.0 | Chief Noble brought forth the request for the approval of a 24-month contract for an additional 11 FLOCK cameras, including a one-time implementation fee of $7,150.00 ($650.00 per camera). He also requested authorization to pay the balance for the subsequent year at cost of $33,500.00, for a total cost of 40,650.00. | https://mcdonoughga.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=1931,plainText=false) | https://mytown.theboringparts.com/city/mcdonoughga/2024/#m530953 | flock | stated | 1 | 0 | 0 | GA |
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);