surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
2 rows where ledger = "sv:rms:tyler_ps", state = "MS" and vendor = "Tyler Technologies (public safety)" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3611 | 3611 | Tyler Technologies (public safety) | Pearl | MS | 2024-01-02 | Brazos maintenance (approve invoice) | 12219.0 | Request for Approval to pay Tyler Technologies Brazos Annual Maintenance in the amount of $12,219.52 | https://pearlms.legistar1.com/pearlms/meetings/2024/1/1007_M_Mayor_and_Board_of_Aldermen_24-01-02_Meeting_Minutes.pdf | https://mytown.theboringparts.com/city/pearlms/2024/#m331798 | sv:rms:tyler_ps | stated | 1 | 0 | 0 | MS |
| 3607 | 3607 | Tyler Technologies (public safety) | Pearl | MS | 2026-01-20 | police training (approve purchase) | 6300.0 | Order to approve the purchase of PACE-05 (Planned Annual Continuing Education) for Police & IT Department annual employee training, in the amount of $6,300.00 payable to Tyler Technologies. | https://pearlms.legistar1.com/pearlms/meetings/2026/1/1070_M_Mayor_and_Board_of_Aldermen_26-01-20_Meeting_Minutes.pdf | https://mytown.theboringparts.com/city/pearlms/#m331852 | sv:rms:tyler_ps | stated | 1 | 0 | 0 | MS |
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);