surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
2 rows where ledger = "sv:intercept:l3harris" and state = "CO" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3711 | 3711 | L3Harris | Denver | CO | 2022-09-20 | aircraft noise monitoring software (amend) | 399504.0 | Amends a contract with L3Harris Technologies, Inc. by adding $399,504 for a new total of $1,477,684 and two years for a new end date of 12-31-2024 for continued aircraft noise monitoring software and NextGen radar data at Denver International Airport in Council District 11 (201629366/ 202263851). | https://denver.legistar1.com/denver/meetings/2022/9/7957_A_Mayor-Council_22-09-20_Mayor-Council_Agenda.pdf | https://mytown.theboringparts.com/city/denver/2022/#m277096 | sv:intercept:l3harris | stated | 1 | 0 | 0 | CO |
| 3712 | 3712 | L3Harris | Denver | CO | 2022-09-14 | aircraft noise monitoring software (amend) | 399504.0 | Amends a contract with L3Harris Technologies, Inc. by adding $399,504 for a new total of $1,477,684 and two years for a new end date of 12-31-2024 for continued aircraft noise monitoring software and NextGen radar data at Denver International Airport in Council District 11 (201629366/ 202263851). | https://denver.legistar1.com/denver/meetings/2022/9/7928_M_Business%2C_Arts%2C_Workforce%2C___Aviation_Services_Committee_22-09-14_Committee_Minutes.pdf | https://mytown.theboringparts.com/city/denver/2022/#m277089 | sv:intercept:l3harris | stated | 2 | 0 | 0 | CO |
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);