Dark Mode
Iowa Spirits Purchase Data
Retail & Consumer Behavior
Tags and Keywords
Trusted By
"No reviews yet"
Free
About
Spirits purchase information from Iowa Class "E" liquor licensees, covering individual products and purchase dates from January 2021 to January 2022. It offers an in-depth view of total spirits sales across Iowa at the store level, providing a foundation for analysing market trends and consumption patterns.
Columns
- invoice_and_item_number: A unique identifier created by concatenating the invoice and line number for each individual liquor product in a store's order.
- date: The specific date when the liquor order was placed.
- store_number: A unique numerical identifier assigned to each store that placed a liquor order.
- store_name: The trading name of the store that ordered the liquor.
- address: The street address of the store that placed the liquor order.
- city: The city where the ordering store is situated.
- zip_code: The postal code for the ordering store's location.
- store_location: Geocoded coordinates derived from the store's address, city, state, and zip code, indicating its geographical position.
- county_number: The Iowa county number corresponding to the county where the ordering store is located.
- county: The name of the county where the ordering store is located.
- category: A code representing the category of the liquor ordered.
- category_name: The descriptive name of the liquor category.
- vendor_number: The identifier for the vendor company supplying the brand of liquor ordered.
- vendor_name: The name of the vendor company supplying the brand of liquor ordered.
- item_number: The specific item number for the individual liquor product ordered.
- item_description: A description of the individual liquor product ordered.
- pack: The quantity of bottles contained within a single case of the ordered liquor.
- bottle_volume_ml: The volume of each liquor bottle, measured in milliliters.
- state_bottle_cost: The cost paid by the Alcoholic Beverages Division for each bottle of liquor ordered.
- state_bottle_retail: The retail price paid by the store for each bottle of liquor ordered.
- bottles_sold: The total number of liquor bottles ordered by the store.
- sale_dollars: The total monetary value of the liquor order, calculated by multiplying the number of bottles sold by the state bottle retail price.
- volume_sold_liters: The total volume of liquor ordered, expressed in liters.
- volume_sold_gallons: The total volume of liquor ordered, expressed in gallons.
Distribution
The dataset is provided in a tabular format, typically a CSV file. It contains approximately 3 million rows and 24 columns, with a file size of around 680.46 MB. Specific numbers for rows across various columns consistently show 2.81 million valid records.
Usage
This dataset is ideal for analysing total spirits sales in Iowa at the store level. Potential applications include:
- Tracking trends in bottle sales from January 2021 to January 2022.
- Calculating Iowa's monthly revenue from liquor sales.
- Identifying top-selling products.
- Determining the number of active stores and top-ordering establishments.
- Investigating regional variations in popular products.
- Examining seasonal differences in product consumption.
- Forecasting future bottle sales.
- Insights into liquor consumption behaviour within the USA as a sample.
Coverage
The dataset focuses on liquor sales within Iowa, specifically from Iowa Class "E" liquor licensees. The temporal scope spans from January 2021 to January 2022. It provides geographical details down to the county, city, and zip code level within Iowa.
License
Attribution 4.0 International (CC BY 4.0)
Who Can Use It
This dataset is valuable for data analysts, business intelligence professionals, market researchers, government agencies, and anyone interested in retail sales, consumer behaviour, or regional economic analysis. It can support studies on market dynamics, inventory management, and policy impact within the alcoholic beverage sector.
Dataset Name Suggestions
- Iowa Liquor Sales 2021-2022
- Iowa Spirits Purchase Data
- Iowa Liquor Retail Analytics
- Iowa Alcoholic Beverage Sales
- Iowa State Liquor Sales
Attributes
Original Data Source: Iowa Spirits Purchase Data
QUALITY