Dataset: Iowa Liquor Sales

About this Dataset

Iowa Liquor Sales

Context

The Iowa Department of Commerce requires that every store that sells alcohol in bottled form for off-the-premises consumption must hold a class "E" liquor license (an arrangement typical of most of the state alcohol regulatory bodies). All alcoholic sales made by stores registered thusly with the Iowa Department of Commerce are logged in the Commerce department system, which is in turn published as open data by the State of Iowa.

Content

This dataset contains information on the name, kind, price, quantity, and location of sale of sales of individual containers or packages of containers of alcoholic beverages.

This dataset is relatively straightforward, but one source of further information on the contents of the data is this Gist.

Acknowledgements

This data was originally published by the State of Iowa here and has been republished as-is on Kaggle.

Inspiration

This data is probably a representative sample of sale activity for alcohol in the United States, and can be used to answer many questions thereof, like: how much alcohol is sold and consumed in the United States? What kind? What are the most popular brands and labels? What are the most popular mixers? What is the distribution of prices paid in-store? Etcetera.

Tables

Iowa Liquor Sales

@kaggle.residentmario_iowa_liquor_sales.iowa_liquor_sales

370.96 MB
12591077 rows
24 columns


CREATE TABLE iowa_liquor_sales (
  "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" BIGINT,
  "item_description" VARCHAR,
  "pack" BIGINT,
  "bottle_volume_ml" BIGINT,
  "state_bottle_cost" VARCHAR,
  "state_bottle_retail" VARCHAR,
  "bottles_sold" BIGINT,
  "sale_dollars" VARCHAR,
  "volume_sold_liters" DOUBLE,
  "volume_sold_gallons" DOUBLE
);