surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
2 rows where ledger = "sv:camera:axis" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4369 | 4369 | Axis Communications | Fort Walton Beach | FL | 2021-09-14 | dome camera (purchase) | 2312.0 | 682-002-007 AXIS COMMUNICATIONS CAMERA - DOME Q6055-E 1 Ea. $2,312.00 Control Technologies, Inc. | https://fortwaltonbeachcityfl.iqm2.com/Citizens/FileOpen.aspx?Type=15&ID=1639&Inline=True | https://mytown.theboringparts.com/city/iq-fortwaltonbeachcityfl/#m880808 | sv:camera:axis | stated | 1 | 0 | 0 | FL |
| 4370 | 4370 | Axis Communications | Fort Walton Beach | FL | 2021-09-09 | dome camera (purchase) | 2312.0 | 682-002-007 AXIS COMMUNICATIONS CAMERA - DOME Q6055-E 1 Ea. $2,312.00 Control Technologies, Inc. | https://fortwaltonbeachcityfl.iqm2.com/Citizens/FileOpen.aspx?Type=15&ID=1639&Inline=True | https://mytown.theboringparts.com/city/iq-fortwaltonbeachcityfl/#m880807 | sv:camera:axis | stated | 2 | 0 | 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);