IT Contracts Report 2022

CREATE TABLE table_1 (
  "agency_number_agency_name" VARCHAR,
  "contract_no" VARCHAR,
  "contractor_name" VARCHAR,
  "contractor_name_d_b_a_optional" VARCHAR,
  "cooperative_purchase_yes_no" VARCHAR,
  "cooperative_name_if_applicable" VARCHAR,
  "was_this_purchased_through_a_des_statewide_contract_y_n" BOOLEAN,
  "contract_start_date" VARCHAR,
  "contract_end_date" VARCHAR,
  "contract_date_explanation" VARCHAR,
  "it_tower_application" DOUBLE,
  "it_tower_compute" DOUBLE,
  "it_tower_data_center" DOUBLE,
  "it_tower_delivery" DOUBLE,
  "it_tower_end_user" DOUBLE,
  "it_tower_it_management" DOUBLE,
  "it_tower_network" DOUBLE,
  "it_tower_output" DOUBLE,
  "it_tower_platform" DOUBLE,
  "it_tower_security" DOUBLE,
  "it_tower_storage" DOUBLE,
  "other_non_it" DOUBLE,
  "total_percentage_auto_calculated" BIGINT,
  "contract_amount_fy97" VARCHAR,
  "contract_amount_fy98" VARCHAR,
  "contract_amount_fy99" VARCHAR,
  "contract_amount_fy00" VARCHAR,
  "contract_amount_fy01" VARCHAR,
  "contract_amount_fy02" VARCHAR,
  "contract_amount_fy03" VARCHAR,
  "contract_amount_fy04" VARCHAR,
  "contract_amount_fy05" VARCHAR,
  "contract_amount_fy06" VARCHAR,
  "contract_amount_fy07" VARCHAR,
  "contract_amount_fy08" VARCHAR,
  "contract_amount_fy09" VARCHAR,
  "contract_amount_fy10" VARCHAR,
  "contract_amount_fy11" VARCHAR,
  "contract_amount_fy12" VARCHAR,
  "contract_amount_fy13" VARCHAR,
  "contract_amount_fy14" VARCHAR,
  "contract_amount_fy15" VARCHAR,
  "contract_amount_fy16" VARCHAR,
  "contract_amount_fy17" VARCHAR,
  "contract_amount_fy18" VARCHAR,
  "contract_amount_fy19" VARCHAR,
  "contract_amount_fy20" VARCHAR,
  "contract_amount_fy21" VARCHAR,
  "contract_amount_fy22" VARCHAR,
  "contract_amount_fy23" VARCHAR,
  "contract_amount_fy24" VARCHAR,
  "contract_amount_fy25" VARCHAR,
  "contract_amount_fy26" VARCHAR,
  "contract_amount_fy27" VARCHAR,
  "contract_amount_fy28" VARCHAR,
  "contract_amount_fy29" VARCHAR,
  "contract_amount_fy30" VARCHAR,
  "contract_amount_fy31" VARCHAR,
  "contract_amount_fy32" VARCHAR,
  "contract_amount_fy33" VARCHAR,
  "contract_amount_fy34" VARCHAR,
  "contract_amount_fy35" VARCHAR,
  "contract_amount_fy36" VARCHAR,
  "contract_amount_fy37" VARCHAR,
  "contract_amount_fy38" VARCHAR,
  "contract_amount_fy39" VARCHAR,
  "contract_amount_fy40" VARCHAR,
  "contract_amount_fy41" VARCHAR,
  "contract_amount_fy42" VARCHAR,
  "contract_amount_fy43" VARCHAR,
  "contract_amount_fy44" VARCHAR,
  "contract_amount_fy45" VARCHAR,
  "contract_amount_fy46" VARCHAR,
  "contract_amount_fy47" VARCHAR,
  "contract_amount_fy48" VARCHAR,
  "contract_amount_fy49" VARCHAR,
  "contract_amount_fy50" VARCHAR,
  "total_contract_amount" VARCHAR,
  "explanation_of_contract_amount" VARCHAR
);