surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
1 row where ledger = "sv:drone:dji" and state = "NJ" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2547 | 2547 | DJI | Elizabeth | NJ | 2024-11-26 | DJI camera (award contract) | 10217.0 | Letter dated November 14, 2024, from the Business Administrator recommending awarding a contract to SHI International Corp., 290 Davidson Avenue, Somerset, NJ for the purchase of One DJI Zenmuse H30T Five-Module Camera for use with a Paladin Drone for the Elizabeth Police Department at the total cost of $10,217.39. | https://www.elizabethnj.org/AgendaCenter/ViewFile/Minutes/_11262024-398 | https://mytown.theboringparts.com/city/elizabethnj.org/2024/#m1523001 | sv:drone:dji | recommended | 1 | 0 | 0 | NJ |
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);