Agency Contracts Fiscal Year 2023

CREATE TABLE table_1 (
  "agency_number_agency_name" VARCHAR  -- Agency Number - Agency Name,
  "agency_contract_no" VARCHAR  -- Agency Contract No.,
  "agency_contract_amendment_no" VARCHAR  -- Agency Contract Amendment No.,
  "contractor_name_search_for_vendor" VARCHAR  -- Contractor Name (Search For Vendor),
  "contractor_name_d_b_a_optional" VARCHAR  -- Contractor Name D/B/A (Optional),
  "statewide_vendor_number_optional" VARCHAR  -- Statewide Vendor Number (Optional),
  "purpose_of_the_contract" VARCHAR,
  "purpose_of_the_contract_description_optional" VARCHAR  -- Purpose Of The Contract Description (Optional),
  "contract_effective_start_date" VARCHAR,
  "contract_effective_end_date" VARCHAR,
  "period_of_performance_start_date" VARCHAR,
  "period_of_performance_end_date" VARCHAR,
  "federal_amount" VARCHAR,
  "state_amount" VARCHAR,
  "other_amount" VARCHAR,
  "cost_of_contract" VARCHAR,
  "explanation_of_costs_optional" VARCHAR  -- Explanation Of Costs (Optional),
  "contract_modifications" VARCHAR,
  "procurement_type" VARCHAR,
  "non_financial_contract_yes_no_optional" VARCHAR  -- Non-Financial Contract Yes/No (Optional),
  "minority_woman_owned" VARCHAR,
  "small_business" VARCHAR,
  "veteran" VARCHAR,
  "diversity_status_explanation" VARCHAR
);