Dataset: State Agency Amazon Spend Fiscal Year 23

About this Dataset

State Agency Amazon Spend Fiscal Year 23

State Agency Amazon Spend Fiscal Year 23
Organization: State of Washington
Last updated: 2023-09-02T08:05:09.409910
Tags: spend-data

Tables

Table 1

@usgov.state_of_washington_state_agency_amazon_spend_fiscal_year_23.table_1

16.28 MB
143926 rows
27 columns


CREATE TABLE table_1 (
  "order_date" VARCHAR,
  "agency_name" VARCHAR,
  "payment_date" VARCHAR,
  "payment_amount" VARCHAR,
  "shipment_date" VARCHAR,
  "product_category" VARCHAR,
  "asin" VARCHAR,
  "title" VARCHAR,
  "unspsc" BIGINT,
  "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_promotion" DOUBLE,
  "item_tax" DOUBLE,
  "item_net_total" DOUBLE,
  "discount_program" VARCHAR,
  "pricing_discount_applied_off" VARCHAR,
  "pricing_discount_applied_off_6153b4" VARCHAR,
  "seller_name" VARCHAR
);