This dataset contains the spirits purchase information of Iowa Class “E” liquor licensees by product and date of purchase from January 1, 2014 to current. The dataset can be used to analyze total spirits sales in Iowa of individual products at the store level.

"description": "This dataset contains the spirits purchase information of Iowa Class “E” liquor licensees by product and date of purchase from January 1, 2014 to current. The dataset can be used to analyze total spirits sales in Iowa of individual products at the store level.",

"domain": "data.iowa.gov",

"id": "m3tr-qhgy",

"columns": {

"btl_price": {

"fred": "money",

"name": "BTL PRICE",

"description": "The amount the store paid for the bottle",

"physicalDatatype": "money",

"position": 20,

"hideInTable": false

},

"city": {

"fred": "text",

"name": "CITY",

"description": "City of store",

"physicalDatatype": "text",

"position": 6,

"hideInTable": false

},

"zipcode": {

"fred": "text",

"name": "ZIPCODE",

"description": "Zipcode of store",

"physicalDatatype": "text",

"position": 7,

"hideInTable": false

},

"name": {

"fred": "text",

"name": "NAME",

"description": "Name of store",

"physicalDatatype": "text",

"position": 4,

"hideInTable": false

},

"state_btl_cost": {

"fred": "money",

"name": "STATE BTL COST",

"description": "The amount that Alcoholic Beverages Division paid for the bottle",

"physicalDatatype": "money",

"position": 19,

"hideInTable": false

},

"store_location": {

"fred": "location",

"name": "STORE LOCATION",

"description": "Location of store",

"physicalDatatype": "location",

"position": 8,

"hideInTable": false

},

"convenience_store": {

"fred": "text",

"name": "CONVENIENCE STORE",

"description": "Contains a \"Y\" if convenience store",

"physicalDatatype": "text",

"position": 2,

"hideInTable": false

},

"description": {

"fred": "text",

"name": "DESCRIPTION",

"description": "Item Description",

"physicalDatatype": "text",

"position": 16,

"hideInTable": false

},

"category_name": {

"fred": "text",

"name": "CATEGORY NAME",

"description": "Category for the liquor type",

"physicalDatatype": "text",

"position": 12,

"hideInTable": false

},

"pack": {

"fred": "number",

"name": "PACK",

"description": "The number of bottles in a case",

"physicalDatatype": "number",

"position": 17,

"hideInTable": false

},

"county_number": {

"fred": "text",

"name": "COUNTY NUMBER",

"description": "Iowa county number where store is located\n",

"physicalDatatype": "text",

"position": 9,

"hideInTable": false

},

"store": {

"fred": "text",

"name": "STORE",

"description": "Store Number",

"physicalDatatype": "text",

"position": 3,

"hideInTable": false

},

"total": {

"fred": "money",

"name": "TOTAL",

"description": "The total amount of the sale (number of bottles multiplied by the bottle price)",

"physicalDatatype": "money",

"position": 22,

"hideInTable": false

},

"county": {

"fred": "text",

"name": "COUNTY",

"description": "County where store is located\n",

"physicalDatatype": "text",

"position": 10,

"hideInTable": false

},

"vendor_no": {

"fred": "text",

"name": "VENDOR NO",

"description": "The vendor number of the company for this brand of liquor",

"physicalDatatype": "text",

"position": 13,

"hideInTable": false

},

"date": {

"fred": "calendar_date",

"name": "DATE",

"description": "Date of order",

"physicalDatatype": "calendar_date",

"position": 1,

"hideInTable": false

},

"address": {

"fred": "text",

"name": "ADDRESS",

"description": "Address of store",

"physicalDatatype": "text",

"position": 5,

"hideInTable": false

},

"category": {

"fred": "text",

"name": "CATEGORY",

"description": "Category code for liquor type",

"physicalDatatype": "text",

"position": 11,

"hideInTable": false

},

"vendor": {

"fred": "text",

"name": "VENDOR",

"description": "The vendor name of the company for this brand of liquor",