IT Contracts Report 2022

CREATE TABLE table_1 (
  "agency_number_agency_name" VARCHAR  -- Agency Number - Agency Name,
  "contract_no" VARCHAR  -- Contract No.,
  "contractor_name" VARCHAR,
  "contractor_name_d_b_a_optional" VARCHAR  -- Contractor Name D/B/A (Optional),
  "cooperative_purchase_yes_no" VARCHAR  -- Cooperative Purchase (Yes/No),
  "cooperative_name_if_applicable" VARCHAR  -- Cooperative Name (if Applicable),
  "was_this_purchased_through_a_des_statewide_contract_y_n" BOOLEAN  -- Was This Purchased Through A DES Statewide Contract? Y/N,
  "contract_start_date" VARCHAR,
  "contract_end_date" VARCHAR,
  "contract_date_explanation" 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_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
);