About this Dataset

Iowa Liquor Sales

This dataset contains the spirits purchase information of Iowa Class “E” liquor licensees by product and date of purchase from January 1, 2012 to current. The dataset can be used to analyze total spirits sales in Iowa of individual products at the store level. Class E liquor license, for grocery stores, liquor stores, convenience stores, etc., allows commercial establishments to sell liquor for off-premises consumption in original unopened containers.
Organization: State of Iowa
Last updated: 2023-01-20T00:04:18.109616
Tags: liquor-licensees, liquor-sales, spirit-sales, store-sales

Tables

Table 1

@usgov.state_of_iowa_iowa_liquor_sales.table_1

901.62 MB
31,339,341 rows
24 columns

CREATE TABLE table_1 (
  "invoice_item_number" VARCHAR,
  "date" TIMESTAMP,
  "store_number" BIGINT,
  "store_name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "zip_code" VARCHAR,
  "store_location" VARCHAR,
  "county_number" DOUBLE,
  "county" VARCHAR,
  "category" DOUBLE,
  "category_name" VARCHAR,
  "vendor_number" DOUBLE,
  "vendor_name" VARCHAR,
  "item_number" VARCHAR,
  "item_description" VARCHAR,
  "pack" BIGINT,
  "bottle_volume_ml" BIGINT  -- Bottle Volume (ml),
  "state_bottle_cost" DOUBLE,
  "state_bottle_retail" DOUBLE,
  "bottles_sold" BIGINT,
  "sale_dollars" DOUBLE  -- Sale (Dollars),
  "volume_sold_liters" DOUBLE  -- Volume Sold (Liters),
  "volume_sold_gallons" DOUBLE  -- Volume Sold (Gallons)
);