Iowa Liquor Sales
12 million alcoholic beverage sales in the Midwest
@kaggle.residentmario_iowa_liquor_sales
Iowa Liquor Sales
@kaggle.residentmario_iowa_liquor_sales.iowa_liquor_sales
- 370.96 MB
- 12591077 rows
- 24 columns
invoice_item_numberInvoice/Item Number | dateDate | store_numberStore Number | store_nameStore Name | addressAddress | cityCity | zip_codeZip Code | store_locationStore Location | county_numberCounty Number | countyCounty | categoryCategory | category_nameCategory Name | vendor_numberVendor Number | vendor_nameVendor Name | item_numberItem Number | item_descriptionItem Description | packPack | bottle_volume_mlBottle Volume (ml) | state_bottle_costState Bottle Cost | state_bottle_retailState Bottle Retail | bottles_soldBottles Sold | sale_dollarsSale (Dollars) | volume_sold_litersVolume Sold (Liters) | volume_sold_gallonsVolume Sold (Gallons) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| S29198800001 | Fri Nov 20 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 2191 | Keokuk Spirits | 1013 MAIN | KEOKUK | 52632 | 1013 MAIN KEOKUK 52632 (40.39978, -91.387531) | 56 | Lee | nan | 255 | Wilson Daniels Ltd. | 297 | Templeton Rye w/Flask | 6 | 750 | $18.09 | $27.14 | 6 | $162.84 | 4.5 | 1.19 | |
| S29195400002 | Sat Nov 21 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 2205 | Ding's Honk And Holler | 900 E WASHINGTON | CLARINDA | 51632 | 900 E WASHINGTON CLARINDA 51632 (40.739238, -95.02756) | 73 | Page | nan | 255 | Wilson Daniels Ltd. | 297 | Templeton Rye w/Flask | 6 | 750 | $18.09 | $27.14 | 12 | $325.68 | 9 | 2.38 | |
| S29050300001 | Mon Nov 16 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 3549 | Quicker Liquor Store | 1414 48TH ST | FORT MADISON | 52627 | 1414 48TH ST FORT MADISON 52627 (40.624226, -91.373211) | 56 | Lee | nan | 130 | Disaronno International LLC | 249 | Disaronno Amaretto Cavalli Mignon 3-50ml Pack | 20 | 150 | $6.40 | $9.60 | 2 | $19.20 | 0.3 | 0.08 | |
| S28867700001 | Wed Nov 04 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 2513 | Hy-Vee Food Store #2 / Iowa City | 812 S 1ST AVE | IOWA CITY | 52240 | 812 S 1ST AVE IOWA CITY 52240 | 52 | Johnson | nan | 65 | Jim Beam Brands | 237 | Knob Creek w/ Crystal Decanter | 3 | 1750 | $35.55 | $53.34 | 3 | $160.02 | 5.25 | 1.39 | |
| S29050800001 | Tue Nov 17 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 3942 | Twin Town Liquor | 104 HIGHWAY 30 WEST | TOLEDO | 52342 | 104 HIGHWAY 30 WEST TOLEDO 52342 (41.985887, -92.579244) | 86 | Tama | nan | 130 | Disaronno International LLC | 249 | Disaronno Amaretto Cavalli Mignon 3-50ml Pack | 20 | 150 | $6.40 | $9.60 | 2 | $19.20 | 0.3 | 0.08 | |
| S28869200001 | Wed Nov 11 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 3650 | Spirits, Stogies and Stuff | 118 South Main St. | HOLSTEIN | 51025 | 118 South Main St. HOLSTEIN 51025 (42.490073, -95.544793) | 47 | Ida | nan | 65 | Jim Beam Brands | 237 | Knob Creek w/ Crystal Decanter | 3 | 1750 | $35.55 | $53.34 | 1 | $53.34 | 1.75 | 0.46 | |
| S28865700001 | Mon Nov 09 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 2538 | Hy-Vee Food Store #3 / Waterloo | 1422 FLAMMANG DR | WATERLOO | 50702 | 1422 FLAMMANG DR WATERLOO 50702 (42.459938, -92.327917) | 7 | Black Hawk | 1701100 | DECANTERS & SPECIALTY PACKAGES | 962 | Duggan's Distillers Products Corp | 238 | Forbidden Secret Coffee Pack | 6 | 1500 | $11.62 | $17.43 | 6 | $104.58 | 9 | 2.38 |
| S28869500001 | Tue Nov 10 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 3942 | Twin Town Liquor | 104 HIGHWAY 30 WEST | TOLEDO | 52342 | 104 HIGHWAY 30 WEST TOLEDO 52342 (41.985887, -92.579244) | 86 | Tama | nan | 65 | Jim Beam Brands | 237 | Knob Creek w/ Crystal Decanter | 3 | 1750 | $35.55 | $53.34 | 2 | $106.68 | 3.5 | 0.92 | |
| S29339300091 | Mon Nov 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 2662 | Hy-Vee Wine & Spirits / Muscatine | 522 MULBERRY, SUITE A | MUSCATINE | 52761 | 522 MULBERRY, SUITE A MUSCATINE 52761 | 70 | Muscatine | 1701100 | DECANTERS & SPECIALTY PACKAGES | 65 | Jim Beam Brands | 173 | Laphroaig w/ Whiskey Stones | 12 | 750 | $19.58 | $29.37 | 4 | $117.48 | 3 | 0.79 |
| S29050900001 | Mon Nov 16 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 4307 | Crossroads Wine and Liquor | 117 IOWA AVE | DUNLAP | 712-2 | 117 IOWA AVE DUNLAP 712-2 (41.854728, -95.602969) | 43 | Harrison | nan | 130 | Disaronno International LLC | 249 | Disaronno Amaretto Cavalli Mignon 3-50ml Pack | 20 | 150 | $6.40 | $9.60 | 2 | $19.20 | 0.3 | 0.08 |
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,
"state_bottle_cost" VARCHAR,
"state_bottle_retail" VARCHAR,
"bottles_sold" BIGINT,
"sale_dollars" VARCHAR,
"volume_sold_liters" DOUBLE,
"volume_sold_gallons" DOUBLE
);