Name: State IT Expenditures - FY17
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

State IT Expenditures - FY17

The Office of the CIO (OCIO) oversees the state's expenditures on technology. This detailed data set provides insight into statewide IT spend.
Organization: State of Washington
Last updated: 2020-11-10T17:19:44.143203
Tags: expenditures, tbm, technology

Tables

Table 1

@usgov.state_of_washington_state_it_expenditures_fy17.table_1

212.72 MB
5,914,714 rows
44 columns

CREATE TABLE table_1 (
  "account_group" VARCHAR,
  "account_subgroup" VARCHAR,
  "account" VARCHAR,
  "department_code" VARCHAR,
  "department_description" VARCHAR,
  "owner" VARCHAR,
  "cost_center" VARCHAR,
  "cost_center_owner" VARCHAR,
  "cost_center_name" VARCHAR,
  "cost_pool" VARCHAR,
  "cost_sub_pool" VARCHAR,
  "program" DOUBLE,
  "project_id" VARCHAR,
  "project_name" VARCHAR,
  "fixed_variable" VARCHAR,
  "spend_type" VARCHAR,
  "amount" DOUBLE,
  "account_description" VARCHAR,
  "expense_type" VARCHAR,
  "purchase_order" VARCHAR,
  "biennium" BIGINT,
  "fiscal_month" BIGINT,
  "agency" BIGINT,
  "agency_title" VARCHAR,
  "fund" DOUBLE,
  "fund_title" VARCHAR,
  "appropriation_type" DOUBLE,
  "appropriation_type_title" VARCHAR,
  "subobject" VARCHAR,
  "organization_index" VARCHAR,
  "cost_objective" VARCHAR,
  "gl_account" BIGINT,
  "it_spend_type" VARCHAR,
  "tbm_program_participant" VARCHAR,
  "functional_group" VARCHAR,
  "it_acquisitions" DOUBLE,
  "it_maintenance_and_ops" DOUBLE,
  "data_processing_interagency" DOUBLE,
  "revenue" DOUBLE,
  "account_id_description" VARCHAR  -- Account ID + Description,
  "cost_center_name_aa7527" VARCHAR  -- Cost Center + Name,
  "tbm_unique_id" VARCHAR,
  "program_index" VARCHAR,
  "program_index_title" VARCHAR
);