Go to an accessible version of this page

data.iowa.gov
Close
Author
Alcoholic Beverages Division (Commerce)
Description
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.
Category
Sales & Distribution
Tags
liquor sales, spirit sales, store sales, liquor licensees
Rating
Current value: 0 out of 5
Data Provided By
Iowa Department of Revenue, Alcoholic Beverages
License
1.0 Universal (Public Domain Dedication)
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size

  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Invoice/Item Number
invoice_line_no
Date
date
Store Number
store
Store Name
name
Address
address
City
city
Zip Code
zipcode
Store Location
store_location
County Number
county_number
County
county
Category
category
Category Name
category_name
Vendor Number
vendor_no
Vendor Name
vendor_name
Item Number
itemno
Item Description
im_desc
Pack
pack
Bottle Volume (ml)
bottle_volume_ml
State Bottle Cost
state_bottle_cost
State Bottle Retail
state_bottle_retail
Bottles Sold
sale_bottles
Sale (Dollars)
sale_dollars
Volume Sold (Liters)
sale_liters
Volume Sold (Gallons)
sale_gallons
Iowa ZIP Code Tabulation Areas
:@computed_region_3r5t_5243
Iowa Watershed Sub-Basins (HUC 08)
:@computed_region_wnea_7qqw
Iowa Watersheds (HUC 10)
:@computed_region_i9mz_6gmt
County Boundaries of Iowa
:@computed_region_uhgg_e8y2
US Counties
:@computed_region_e7ym_nrbf

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.