surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
2 rows where state = "DE" and vendor = "Grayshift / GrayKey" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3030 | 3030 | Grayshift / GrayKey | New Castle County | DE | 2023-11-28 | forensic equipment (authorize contract to purchase) | 57160.0 | R23-218: AUTHORIZING THE EXECUTION OF ONE CONTRACT WITH GRAYSHIFT, LLC TO PURCHASE TWO UNITS OF FORENSIC EQUIPMENT, AND THE ASSOCIATED LICENSES, FOR POLICE INVESTIGATIONS FOR THE DEPARTMENT OF PUBLIC SAFETY, DIVISION OF POLICE IN THE AMOUNT OF $57,160.64 | https://newcastlecode.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=4057,plainText=false) | https://mytown.theboringparts.com/city/newcastlecode/2023/#m745656 | sv:forensics:grayshift | stated | 1 | 0 | 0 | DE |
| 3031 | 3031 | Grayshift / GrayKey | New Castle County | DE | 2023-11-28 | forensic extraction devices (purchase) | 57160.0 | AUTHORIZING THE EXECUTION OF ONE CONTRACT WITH GRAYSHIFT, LLC TO PURCHASE TWO UNITS OF FORENSIC EQUIPMENT, AND THE ASSOCIATED LICENSES, FOR POLICE INVESTIGATIONS FOR THE DEPARTMENT OF PUBLIC SAFETY, DIVISION OF POLICE IN THE AMOUNT OF $57,160.64 | https://newcastlecode.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=4033,plainText=false) | https://mytown.theboringparts.com/city/newcastlecode/2023/#m745655 | sv:forensics:grayshift | stated | 2 | 0 | 0 | DE |
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);