surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
2 rows where ledger = "sv:forensics:graykey" and state = "FL" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3598 | 3598 | GrayKey | Pembroke Pines | FL | 2023-03-15 | forensic software license (renew) | 30795.0 | MOTION TO APPROVE THE POLICE DEPARTMENT ’S ONE YEAR RENEWAL OF ITS GRAYKEY FORENSIC SOFTWARE LICENSE IN THE AMOUNT NOT TO EXCEED $ 30,795 FROM THE GRAYSHIFT, LLC. CORPORATION, PURSUANT TO SECTIONS 35.18(C)(7)(H) AND 35.18(C)(7)(I). | https://ppines.legistar1.com/ppines/meetings/2023/3/1534_M_City_Commission_23-03-15_Meeting_Minutes.pdf | https://mytown.theboringparts.com/city/ppines/2023/#m336926 | sv:forensics:graykey | ceiling | 1 | 1 | 0 | FL |
| 3599 | 3599 | GrayKey | Pembroke Pines | FL | 2022-06-01 | forensic software license (renew) | 27995.0 | MOTION TO APPROVE THE POLICE DEPARTMENT ’S ONE YEAR RENEWAL OF ITS GRAYKEY FORENSIC SOFTWARE LICENSE IN THE AMOUNT OF $ 27,995 FROM GRAYSHIFT, LLC. | https://ppines.legistar1.com/ppines/meetings/2022/6/1454_M_City_Commission_22-06-01_Meeting_Minutes.pdf | https://mytown.theboringparts.com/city/ppines/2022/#m336880 | sv:forensics:graykey | stated | 1 | 1 | 0 | FL |
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);