surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
2 rows where state = "TX" and vendor = "Genetec" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3751 | 3751 | Genetec | Deer Park | TX | 2024-03-05 | Surveillance and Access Control System (purchase) | 66454.0 | Authorize purchasing a Genetec Surveillance and Access Control System for the Court Theatre Building, Wastewater Treatment Plant, & Surface Water Treatment Plant under DIR contract DIR-CPO-4766 for the amount of $ 66,454.92. | https://legistar1.granicus.com/cityofdeerpark/meetings/2024/3/3009_A_City_Council__24-03-05_Council_Workshop.pdf | https://mytown.theboringparts.com/city/cityofdeerpark/2024/#m249213 | sv:alpr:genetec | stated | 1 | 0 | 0 | TX |
| 3641 | 3641 | Genetec | Mesquite | TX | 2022-05-16 | Security Center upgrade (award contract) | 65738.0 | Bid No. 2022-085 - Genetec-City Upgrade. (Authorize the City Manager to finalize and execute the required documents with Convergint Technologies LLC, dba Convergint CTC Texas LLC, through OMNIA Partners Contract No. R170502, in an amount not to exceed $65,738.17.) | https://legistar1.granicus.com/Mesquite/meetings/2022/5/1388_M_City_Council_22-05-16_Minutes_-_Final.pdf | https://mytown.theboringparts.com/city/mesquite/2022/#m316653 | sv:alpr:genetec | ceiling | 1 | 0 | 0 | TX |
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);