Monthly summary of the different Class E liquor sales in State of Iowa

liquor_sales

Format

a data frame with 10 variables.

year

The year in which the sale occurred.

year_month

This is an aggregated value indicating the month and year in YYYY-MM-DD format.

county

The county in which the sale occurred.

population

The population of the county of the year of sale as recorded by the US Census Bureau. NA values indicate no census data were found on the Iowa Data Portal.

type

A high level grouping of the liquor. This was derived separately.

category

A grouping variable used by the State of Iowa.

state_cost

The cost (in US$) to the state to purchase the liquor from a vendor. Not adjusted for inflation.

state_revenue

The revenue (in US$) the state earned from the sale of the liquor to retailers. Not adjusted for inflation.

bottles_sold

The number of bottles sold by the state to a retailer.

volume

The volume sold (in liters) by the state to a retailer.

Source

State of Iowa Data API website

Details

This dataset contains an aggregated view (aggregated by multiple attributes) of the sales data for Class E liquor. The dataset has been pre-processed to remove NULL values from the county and county number variables. See vignette for more details