About this Dataset

IT Contracts Report 2019

The IT Contracts Report is an annual report required by a proviso in section 150(10)(a) of the 2019-2021 operating budget. The report provides a snap shot of all state agency and higher education active IT contracts as of June 30 of each year.
Organization: State of Washington
Last updated: 2020-11-10T17:20:12.893395
Tags: agency, contracts, it-spend, procurement, report, spend

Tables

Table 1

@usgov.state_of_washington_it_contracts_report_2019.table_1

402.96 kB
8,521 rows
63 columns

CREATE TABLE table_1 (
  "agency_name" VARCHAR,
  "agency_contract_no" VARCHAR  -- Agency Contract No.,
  "contractor_name" VARCHAR,
  "contractor_name_d_b_a_optional" VARCHAR  -- Contractor Name D/B/A (Optional),
  "was_this_purchased_through_a_des_master_contract_y_n" VARCHAR  -- Was This Purchased Through A DES Master Contract? Y/N,
  "contract_start_date" VARCHAR,
  "contract_end_date" VARCHAR,
  "it_tower_application" DOUBLE  -- IT Tower: Application,
  "it_tower_compute" DOUBLE  -- IT Tower: Compute,
  "it_tower_data_center" DOUBLE  -- IT Tower: Data Center,
  "it_tower_delivery" DOUBLE  -- IT Tower: Delivery,
  "it_tower_end_user" DOUBLE  -- IT Tower: End User,
  "it_tower_it_management" DOUBLE  -- IT Tower: IT Management,
  "it_tower_network" DOUBLE  -- IT Tower: Network,
  "it_tower_output" DOUBLE  -- IT Tower: Output,
  "it_tower_platform" DOUBLE  -- IT Tower: Platform,
  "it_tower_security" DOUBLE  -- IT Tower: Security,
  "it_tower_storage" DOUBLE  -- IT Tower: Storage,
  "other_non_it" DOUBLE,
  "total_percentage_auto_calculated" BIGINT  -- Total Percentage (Auto Calculated),
  "contract_amount_fy00" DOUBLE,
  "contract_amount_fy01" DOUBLE,
  "contract_amount_fy02" DOUBLE,
  "contract_amount_fy03" DOUBLE,
  "contract_amount_fy04" DOUBLE,
  "contract_amount_fy05" DOUBLE,
  "contract_amount_fy06" DOUBLE,
  "contract_amount_fy07" DOUBLE,
  "contract_amount_fy08" DOUBLE,
  "contract_amount_fy09" DOUBLE,
  "contract_amount_fy10" DOUBLE,
  "contract_amount_fy11" DOUBLE,
  "contract_amount_fy12" DOUBLE,
  "contract_amount_fy13" DOUBLE,
  "contract_amount_fy14" DOUBLE,
  "contract_amount_fy15" DOUBLE,
  "contract_amount_pre_fy16" DOUBLE,
  "contract_amount_fy16" DOUBLE,
  "contract_amount_fy17" DOUBLE,
  "contract_amount_fy18" DOUBLE,
  "contract_amount_fy19" DOUBLE,
  "contract_amount_fy20" DOUBLE,
  "contract_amount_fy21" DOUBLE,
  "contract_amount_fy22" DOUBLE,
  "contract_amount_fy23" DOUBLE,
  "contract_amount_fy24" DOUBLE,
  "contract_amount_post_fy24" DOUBLE,
  "contract_amount_fy25" DOUBLE,
  "contract_amount_fy26" DOUBLE,
  "contract_amount_fy27" DOUBLE,
  "contract_amount_fy28" DOUBLE,
  "contract_amount_fy29" DOUBLE,
  "contract_amount_fy30" DOUBLE,
  "contract_amount_fy31" DOUBLE,
  "contract_amount_fy32" DOUBLE,
  "contract_amount_fy33" DOUBLE,
  "contract_amount_fy34" DOUBLE,
  "contract_amount_fy35" DOUBLE,
  "contract_amount_fy36" DOUBLE,
  "contract_amount_fy37" DOUBLE,
  "contract_amount_fy38" DOUBLE,
  "contract_amount_fy39" DOUBLE,
  "total_contract_amount" DOUBLE
);