surveillance_spending
Data license: CC BY 4.0 · Data source: MyTown
6 rows where state = "CO" and vendor = "L3Harris" sorted by amount descending
This data as json, CSV (advanced)
Suggested facets: product, amount, quote, dup_rank, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3716 | 3716 | L3Harris | Denver | CO | 2022-01-18 | two-way radios (approve master purchase order) | 7000000.0 | Approves a master purchase order with L3 Harris Technologies, Inc. for $7,000,000 and for two years, with three one-year options to extend, for communication radios, supplies, and repairs at Denver International Airport (SC-00006355). | https://denver.legistar1.com/denver/meetings/2022/1/7599_A_Mayor-Council_22-01-18_Mayor-Council_Agenda.pdf | https://mytown.theboringparts.com/city/denver/#m276827 | sv:radio_infra:l3harris | stated | 1 | 0 | 0 | CO |
| 3717 | 3717 | L3Harris | Denver | CO | 2022-01-12 | two-way radios (approve master purchase order) | 7000000.0 | Approves a master purchase order with L3 Harris Technologies, Inc. for $7,000,000 and for two years, with three one-year options to extend, for communication radios, supplies, and repairs at Denver International Airport (SC-00006355). | https://denver.legistar1.com/denver/meetings/2022/1/7589_M_Business%2C_Arts%2C_Workforce%2C___Aviation_Services_Committee_22-01-12_Committee_Minutes.pdf | https://mytown.theboringparts.com/city/denver/2022/#m276822 | sv:radio_infra:l3harris | stated | 2 | 0 | 0 | CO |
| 3703 | 3703 | L3Harris | Denver | CO | 2023-08-22 | radio system upgrade (approve contract) | 3808387.0 | Approves a contract with L3Harris Technologies, Inc. for $3,808,387.04 and 5 years plus one 2-year extension, to upgrade the proprietary Public Safety Radio System (PSRS) and provide ongoing maintenance and support, in Council District 11 (PLANE-202264092). | https://denver.legistar1.com/denver/meetings/2023/8/8466_A_Mayor-Council_23-08-22_Mayor-Council_Agenda.pdf | https://mytown.theboringparts.com/city/denver/2023/#m277482 | sv:radio_infra:l3harris | stated | 1 | 0 | 0 | CO |
| 3704 | 3704 | L3Harris | Denver | CO | 2023-08-16 | two-way radios (approve contract) | 3808387.0 | Approves a contract with L3Harris Technologies, Inc. for $3,808,387.04 and 5 years plus one 2-year extension, to upgrade the proprietary Public Safety Radio System (PSRS) and provide ongoing maintenance and support, in Council District 11 (PLANE-202264092). | https://denver.legistar1.com/denver/meetings/2023/8/8441_M_Business%2C_Arts%2C_Workforce%2C___Aviation_Services_Committee_23-08-16_Committee_Minutes.pdf | https://mytown.theboringparts.com/city/denver/2023/#m277475 | sv:radio_infra:l3harris | stated | 2 | 0 | 0 | CO |
| 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);