Iowa Liquor Sales
12 million alcoholic beverage sales in the Midwest
@kaggle.residentmario_iowa_liquor_sales
12 million alcoholic beverage sales in the Midwest
@kaggle.residentmario_iowa_liquor_sales
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.
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.
This data was originally published by the State of Iowa here and has been republished as-is on Kaggle.
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.
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 -- Bottle Volume (ml),
"state_bottle_cost" VARCHAR,
"state_bottle_retail" VARCHAR,
"bottles_sold" BIGINT,
"sale_dollars" VARCHAR -- Sale (Dollars),
"volume_sold_liters" DOUBLE -- Volume Sold (Liters),
"volume_sold_gallons" DOUBLE -- Volume Sold (Gallons)
);Anyone who has the link will be able to view this.