About this Dataset

State Agency Amazon Spend Fiscal Year 18

DES is publishing the Amazon spend for state agencies collected through the Washington State Amazon Business account. The data set only includes closed orders. Any orders that are still in process or have been cancelled are not included. This data is for Fiscal Year 18 (July 1, 2017 to June 30, 2018).
Organization: State of Washington
Last updated: 2021-10-08T21:49:53.634156
Tags: agency, contracts, procurement, report, spend

Tables

Table 1

@usgov.state_of_washington_state_agency_amazon_spend_fiscal_year_18.table_1

3.78 MB
38,762 rows
27 columns

CREATE TABLE table_1 (
  "order_date" VARCHAR,
  "agency_name" VARCHAR,
  "payment_date" VARCHAR,
  "payment_amount" DOUBLE,
  "shipment_date" VARCHAR,
  "product_category" VARCHAR,
  "asin" VARCHAR,
  "title" VARCHAR,
  "unspsc" DOUBLE,
  "brand_code" VARCHAR,
  "brand" VARCHAR,
  "manufacturer" VARCHAR,
  "item_model_number" VARCHAR,
  "part_number" VARCHAR,
  "product_condition" VARCHAR,
  "listed_ppu" DOUBLE,
  "purchase_ppu" DOUBLE,
  "item_quantity" BIGINT,
  "item_subtotal" DOUBLE,
  "item_shipping_handling" DOUBLE  -- Item Shipping & Handling,
  "item_promotion" DOUBLE,
  "item_tax" DOUBLE,
  "item_net_total" DOUBLE,
  "discount_program" VARCHAR,
  "pricing_discount_applied_off" DOUBLE  -- Pricing Discount Applied ($ Off),
  "pricing_discount_applied_off_6153b4" DOUBLE  -- Pricing Discount Applied (% Off),
  "seller_name" VARCHAR
);