forked from Workearly/Final-Assignment
-
Notifications
You must be signed in to change notification settings - Fork 0
/
finance_liquor_sales.sql
74 lines (67 loc) · 55.6 KB
/
finance_liquor_sales.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
CREATE DATABASE IF NOT EXISTS `liquorSales` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `liquorSales`;
-- MySQL dump 10.13 Distrib 8.0.29, for Win64 (x86_64)
--
-- Host: 34.65.221.160 Database: liquorSales
-- ------------------------------------------------------
-- Server version 8.0.26-google
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `finance_liquor_sales`
--
DROP TABLE IF EXISTS `finance_liquor_sales`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `finance_liquor_sales` (
`invoice_and_item_number` text,
`date` datetime DEFAULT NULL,
`store_number` int DEFAULT NULL,
`store_name` text,
`address` text,
`city` text,
`zip_code` text,
`store_location` text,
`county_number` int DEFAULT NULL,
`county` text,
`category` double DEFAULT NULL,
`category_name` text,
`vendor_number` int DEFAULT NULL,
`vendor_name` text,
`item_number` int DEFAULT NULL,
`item_description` text,
`pack` int DEFAULT NULL,
`bottle_volume_ml` int DEFAULT NULL,
`state_bottle_cost` double DEFAULT NULL,
`state_bottle_retail` double DEFAULT NULL,
`bottles_sold` int DEFAULT NULL,
`sale_dollars` double DEFAULT NULL,
`volume_sold_liters` double DEFAULT NULL,
`volume_sold_gallons` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `finance_liquor_sales`
--
LOCK TABLES `finance_liquor_sales` WRITE;
/*!40000 ALTER TABLE `finance_liquor_sales` DISABLE KEYS */;
INSERT INTO `finance_liquor_sales` VALUES ('INV-31797900035','2020-11-10 00:00:00',4967,'Jeff\'s Market / Blue Grass','102, W Mayne St','Blue Grass','52726.0','POINT (-90.766126 41.509119)',82,'SCOTT',1011600,'Straight Rye Whiskies',255,'Infinium Spirits',26858,'Templeton 4YR Rye',12,375,9.99,14.99,1,14.99,0.37,0.09),('INV-23548800092','2019-11-27 00:00:00',2601,'Hy-Vee Food Store / Fairfield','1300 West Burlington Ave','Fairfield','52556.0','POINT (-91.978702 41.006456)',51,'JEFFERSON',1081500,'Triple Sec',434,'LUXCO INC',86251,'Juarez Triple Sec',12,1000,2.42,3.63,6,21.78,6,1.58),('INV-23609300026','2019-12-02 00:00:00',4962,'Hilltop Grocery','1312 Harrison St','Davenport','52803.0','',82,'SCOTT',1091200,'Neutral Grain Spirits',434,'LUXCO INC',41844,'Everclear Alcohol',24,375,4.2,6.3,3,18.9,1.12,0.29),('INV-39482900037','2021-08-24 00:00:00',3719,'Wal-Mart 0581 / Marshalltown','2802 S Center St','Marshalltown','50158.0','POINT (-92.91231 42.012918)',64,'MARSHALL',1082100,'Imported Cordials & Liqueur',192,'Mast-Jagermeister US, Inc',65259,'Jagermeister Liqueur Mini Meisters',12,20,4.93,7.4,12,88.8,0.24,0.06),('INV-39520400088','2021-08-25 00:00:00',5423,'Stammer Liquor Corp','615 2nd Ave','Sheldon','51201.0','POINT (-95.854899 43.184242)',71,'OBRIEN',1092100,'Imported Distilled Spirit Specialty',421,'SAZERAC COMPANY INC',77487,'Tortilla Gold DSS',12,1000,4.85,7.28,4,29.12,4,1.05),('INV-29941700050','2020-09-02 00:00:00',3842,'Bancroft Liquor Store','107 N Portland St Po Bx 222','Bancroft','50517.0','POINT (-94.218 43.29355)',55,'KOSSUTH',1091100,'American Distilled Spirit Specialty',578,'S&B Farms Distillery',77055,'Sir Winston Peach',6,750,13.01,19.52,18,351.36,13.5,3.56),('S30390600011','2016-01-26 00:00:00',2641,'Hy-Vee Drugstore / Council Bluffs','757 W BROADWAY','COUNCIL BLUFFS','51501','POINT (-95.855054 41.261673)',78,'Pottawattamie',1081380,'MISCELLANEOUS SCHNAPPS',55,'Sazerac North America',81124,'99 Peppermint Mini',10,600,5.94,8.91,2,17.82,1.2,0.32),('S30348700047','2016-01-25 00:00:00',3162,'Nash Finch / Wholesale Food','807 GRANDVIEW','MUSCATINE','52761','POINT (-91.06411300000002 41.408437)',70,'Muscatine',1081330,'PEACH SCHNAPPS',65,'Jim Beam Brands',82847,'Dekuyper Peachtree',12,1000,7.62,11.43,4,45.72,4,1.06),('S30466200002','2016-02-01 00:00:00',2633,'Hy-Vee #3 / BDI / Des Moines','3221 SE 14TH ST','DES MOINES','50320','POINT (-93.596754 41.554101)',77,'Polk',1081700,'DISTILLED SPIRITS SPECIALTY',55,'Sazerac North America',973627,'Di Amore Quattro Orange',12,1000,9.75,14.63,120,1755.6,120,31.7),('INV-16481100198','2018-12-20 00:00:00',2544,'Hy-Vee Food Store / Marshalltown','802 South Center','Marshalltown','50158','POINT (-92.912817 42.039205)',64,'MARSHALL',1081100,'Coffee Liqueurs',65,'Jim Beam Brands',67557,'Kamora Coffee Liqueur',12,1000,8.39,12.59,6,75.54,6,1.58),('S27335100016','2015-08-19 00:00:00',3723,'J D Spirits Liquor','1023 9TH ST','ONAWA','51040','POINT (-96.095845 42.025841)',67,'Monona',1051110,'BLACKBERRY BRANDIES',434,'Luxco-St Louis',55087,'Paramount Blackberry Brandy',12,1000,6.53,9.8,4,39.2,4,1.06),('S20965700021','2014-09-02 00:00:00',2597,'Hy-Vee Food Store / Cherokee','1300 N. SECOND','CHEROKEE','51012','POINT (-95.552585 42.765259)',18,'Cherokee',1081700,'DISTILLED SPIRITS SPECIALTY',434,'Luxco-St Louis',75087,'Juarez Gold Dss',12,1000,4.92,7.38,72,531.36,72,19.02),('S33151100001','2016-06-30 00:00:00',2571,'Hy-Vee Food Store #2 / Waterloo','2181 Logan Ave','Waterloo','50703','POINT (-92.337583 42.530476)',7,'Black Hawk',1701100,'DECANTERS & SPECIALTY PACKAGES',65,'Jim Beam Brands',168,'Pinnacle Peach w/ Punch Dispenser',6,750,7.35,11.03,180,1985.4,135,35.66),('S11775900048','2013-04-22 00:00:00',3932,'Main Street Spirits / Mapleton','311 MAIN ST','MAPLETON','51034','POINT (-95.79375 42.165915)',67,'Monona',1081315,'CINNAMON SCHNAPPS',65,'Jim Beam Brands',82610,'Dekuyper Hot Damn!',12,1000,7.62,11.43,4,45.72,4,1.06),('S12784400003','2013-06-13 00:00:00',4612,'ATC Liquor','214, MYRTLE ST','DAVENPORT','52802','POINT (-90.589149 41.521586)',82,'Scott',1031100,'100 PROOF VODKA',300,'Mccormick Distilling Company',36886,'Mccormick Vodka',12,750,3.3,4.96,72,357.12,54,14.27),('S15967600028','2013-11-26 00:00:00',2190,'Central City Liquor, Inc.','1460 2ND AVE','DES MOINES','50314','POINT (-93.619787 41.60566)',77,'Polk',1081335,'RASPBERRY SCHNAPPS',434,'Luxco-St Louis',82147,'Arrow Raspberry Schnapps',12,1000,4.75,7.13,4,28.52,4,1.06),('S15747600010','2013-11-20 00:00:00',3447,'Sam\'s Club 6432 / Sioux City','4201 S. YORK ST.','SIOUX CITY','51106','POINT (-96.37082 42.43407)',97,'Woodbury',1701100,'DECANTERS & SPECIALTY PACKAGES',305,'MHW Ltd',3963,'Rumchata w/Thermal Cup',6,750,12.5,18.75,270,5062.5,202.5,53.49),('S21868800005','2014-10-20 00:00:00',3690,'Target Store T-1792 / Waterloo','1501 E SAN MARNAN','WATERLOO','50702','POINT (-92.325387 42.464521)',7,'Black Hawk',1701100,'DECANTERS & SPECIALTY PACKAGES',305,'MHW Ltd',40614,'Rumchata w/Thermal Cup',6,750,12.5,18.75,60,1125,45,11.89),('INV-26349800022','2020-04-07 00:00:00',3763,'Main Street Liquors / Hawarden','911 Central Ave','Hawarden','51023.0','POINT (-96.48518900000002 42.996100000000006)',84,'SIOUX',1062100,'Gold Rum',35,'BACARDI USA INC',43038,'Bacardi Gold',6,1750,15,22.5,3,67.5,5.25,1.38),('INV-23807400003','2019-12-10 00:00:00',5446,'Pump N Pak','1004 Main St.','Rock Valley','51247.0','POINT (-96.294824 43.200164)',84,'SIOUX',1081500,'Triple Sec',65,'Jim Beam Brands',86112,'Dekuyper Triple Sec',12,1000,2.33,3.5,6,21,6,1.58),('INV-30507900064','2020-09-24 00:00:00',5102,'Wilkie Liquors','724 1st St SE','Mount Vernon','52314.0','POINT (-91.410401 41.918328)',57,'LINN',1081500,'Triple Sec',55,'SAZERAC NORTH AMERICA',86390,'Montezuma Triple Sec',12,1000,2.13,3.2,180,576,180,47.55),('INV-48377000104','2022-06-15 00:00:00',2675,'Hy-Vee #2 / Coralville','3285 Crosspark Rd','Coralville','52241.0','POINT (-91.605881 41.722419)',52,'JOHNSON',1082100,'Imported Cordials & Liqueur',342,'DV Spirits LLC',66023,'Naranja Orange Liqueur',12,750,11,16.5,10,165,7.5,1.98),('S12075200027','2013-05-07 00:00:00',2465,'Sid\'s Beverage Shop','2727 DODGE ST','DUBUQUE','52003','POINT (-90.705328 42.491862)',31,'Dubuque',1081700,'DISTILLED SPIRITS SPECIALTY',55,'Sazerac North America',76227,'Montezuma Blue',12,1000,4.5,6.75,120,810,120,31.7),('S14672100067','2013-09-19 00:00:00',3692,'Wilkie Liquors','724 1ST ST E','MT VERNON','52314','POINT (-91.960918 41.994458)',57,'Linn',1081700,'DISTILLED SPIRITS SPECIALTY',434,'Luxco-St Louis',75087,'Juarez Gold Dss',12,1000,4.75,7.13,420,2994.6,420,110.95),('S30506300012','2016-02-02 00:00:00',2562,'Hy-Vee Food Store / Fort Dodge','115 SOUTH 29TH ST','FORT DODGE','50501','POINT (-94.15824700000002 42.504742)',94,'Webster',1031100,'100 PROOF VODKA',301,'Fifth Generation Inc.',38176,'Titos Vodka',12,750,9.65,14.48,108,1563.84,81,21.4),('S30600400007','2016-02-09 00:00:00',4559,'Osage Payless Foods','633, CHASE ST','OSAGE','50461','POINT (-92.811539 43.285134)',66,'Mitchell',1031100,'100 PROOF VODKA',297,'Laird And Company',35918,'Five O\'clock Vodka',6,1750,7.2,10.8,30,324,52.5,13.87),('INV-34046300069','2021-02-04 00:00:00',2532,'Hy-Vee Food Store #2 / Des Moines','2540 E Euclid','Des Moines','50317.0','POINT (-93.569452 41.627838)',77,'POLK',1062100,'Gold Rum',434,'LUXCO INC',45247,'Paramount Gold Rum',12,1000,4.42,6.63,2,13.26,2,0.52),('S17361200007','2014-02-12 00:00:00',2585,'Hy-Vee Wine and Spirits / Algona','1516 HIGHWAY 169 NORTH','ALGONA','50511','POINT (-94.236003 43.081288)',55,'Kossuth',1012300,'IRISH WHISKIES',370,'Pernod Ricard USA/Austin Nichols',15626,'Jameson',12,750,13.74,20.99,36,755.64,27,7.13),('S23337300013','2015-01-06 00:00:00',4319,'Fareway Stores #703 / Humbolt','710 FIRST AVE N','HUMBOLDT','50548','POINT (-94.218699 42.722165)',46,'Humboldt',1051110,'BLACKBERRY BRANDIES',434,'Luxco-St Louis',55088,'Paramount Blackberry Brandy',6,1750,11.29,16.94,3,50.82,5.25,1.39),('S19673500062','2014-06-23 00:00:00',3952,'Lot-A-Spirits','3780 STATE ST','BETTENDORF','52722','POINT (-90.48065 41.529655)',82,'Scott',1081400,'TRIPLE SEC',434,'Luxco-St Louis',86251,'Juarez Triple Sec',12,1000,2.21,3.31,48,158.88,48,12.68),('S33457600258','2016-07-19 00:00:00',2576,'Hy-Vee Wine and Spirits / Storm Lake','1250 N Lake St','Storm Lake','50588','POINT (-95.200758 42.65318400000001)',11,'Buena Vista',1081340,'ROOT BEER SCHNAPPS',380,'Phillips Beverage Company',84617,'Phillips Root Beer Schnapps',12,1000,5.5,8.25,4,33,4,1.06),('INV-18262300112','2019-03-20 00:00:00',3869,'Bootleggin\' Barzini\'s Fin','412 1st Ave','Coralville','52241','POINT (-91.565517 41.672672)',52,'JOHNSON',1062100,'Gold Rum',35,'BACARDI USA INC',43034,'Bacardi Gold',24,375,4.5,6.75,1,6.75,0.37,0.09),('INV-24014800058','2019-12-18 00:00:00',4312,'I-80 Liquor / Council Bluffs','2411 S 24TH ST #1','Council Bluffs','51501.0','POINT (-95.8792 41.238092)',78,'POTTAWATTA',1081500,'Triple Sec',434,'LUXCO INC',86251,'Juarez Triple Sec',12,1000,2.42,3.63,48,174.24,48,12.68),('INV-30599200070','2020-09-28 00:00:00',2662,'Hy-Vee Wine & Spirits / Muscatine','522 Mulberry, Suite A','Muscatine','52761.0','POINT (-91.04437 41.426615)',70,'MUSCATINE',1011600,'Straight Rye Whiskies',255,'Infinium Spirits',27175,'Templeton 4YR Rye',6,1000,21,31.5,6,189,6,1.58),('INV-30856600013','2020-10-08 00:00:00',2675,'Hy-Vee #2 / Coralville','3285 Crosspark Rd','Coralville','52241.0','POINT (-91.60627100000002 41.721438)',52,'JOHNSON',1011600,'Straight Rye Whiskies',85,'Brown Forman Corp.',27130,'Woodford Reserve Rye',6,750,22.49,33.74,30,1012.2,22.5,5.94),('S16496900079','2013-12-26 00:00:00',2622,'Hy-Vee Food Store / Iowa City','1125 N DODGE ST','IOWA CITY','52240','POINT (-91.518868 41.676095)',52,'Johnson',1031100,'100 PROOF VODKA',300,'Mccormick Distilling Company',36908,'Mccormick Vodka Pet',6,1750,7.47,11.21,3,33.63,5.25,1.39),('S30700500137','2016-02-11 00:00:00',4829,'Central City 2','1501 MICHIGAN AVE','DES MOINES','50314','POINT (-93.613739 41.60572)',77,'Polk',1052100,'',420,'Moet Hennessy USA, Inc.',48106,'Hennessy Vs Cognac',12,750,18.99,28.49,60,1709.4,45,11.89),('S30849100007','2016-02-22 00:00:00',4898,'Burlington Shell','130, S ROOSEVELT AVE','BURLINGTON','52601','POINT (-91.140986 40.808239)',29,'Des Moines',1052100,'',420,'Moet Hennessy USA, Inc.',48099,'Hennessy VS',24,200,5.74,8.61,24,206.64,4.8,1.27),('S30778800020','2016-02-17 00:00:00',3772,'Shop N Save #1 / Mlk Pkwy','2127 M L KING JR PKWY','DES MOINES','50314','',77,'Polk',1052100,'',389,'REMY COINTREAU USA .',49182,'Remy Martin VSOP',24,100,3.24,4.86,24,116.64,2.4,0.63),('S30972000014','2016-02-29 00:00:00',4153,'Fareway Stores #067 / Evansdale','215 S EVANS RD','EVANSDALE','50707','POINT (-92.287834 42.475631)',7,'Black Hawk',1012300,'IRISH WHISKIES',370,'Pernod Ricard USA/Austin Nichols',15626,'Jameson',12,750,14.99,22.49,60,1349.4,45,11.89),('INV-08576400023','2017-11-09 00:00:00',4158,'Fareway Stores #409 / Carroll','709 Monterey Dr','Carroll','51401','POINT (-94.850616 42.065252)',14,'CARROLL',1041300,'American Sloe Gins',434,'LUXCO INC',33717,'Paramount Sloe Gin',12,1000,5.42,8.13,4,32.52,4,1.06),('INV-48109600001','2022-06-07 00:00:00',6245,'Neighborhood Liquor House / Ankeny','833 East 1st Street, Suite 102','Ankeny','50021.0','POINT (-93.4545 41.651405)',77,'POLK',1092100,'Imported Distilled Spirit Specialty',293,'JINRO AMERICA INC',965344,'SOOH Jinro Strawberry Soju',20,375,3,4.5,20,90,7.5,1.98),('INV-39702900141','2021-08-31 00:00:00',2593,'Hy-Vee Food Store / Carroll','905 US Highway 30 West','Carroll','51401.0','POINT (-94.853591 42.064155)',14,'CARROLL',1011600,'Straight Rye Whiskies',255,'Infinium Spirits',27102,'Templeton Rye 4YR',6,750,18.09,27.14,30,814.2,22.5,5.94),('INV-16617300052','2018-12-28 00:00:00',5416,'Depot Liquor & Grocery','114 N Center St.','Marshalltown','50158','POINT (-92.912975 42.051619)',64,'MARSHALL',1081100,'Coffee Liqueurs',370,'PERNOD RICARD USA',67528,'Kahlua Coffee',6,1750,24.99,37.49,3,112.47,5.25,1.38),('S08987900005','2012-11-15 00:00:00',2190,'Central City Liquor, Inc.','1460 2ND AVE','DES MOINES','50314','POINT (-93.619787 41.60566)',77,'Polk',1012300,'IRISH WHISKIES',370,'Pernod Ricard USA/Austin Nichols',15627,'Jameson',12,1000,17.4,26.1,84,2192.4,84,22.19),('INV-36308700079','2021-05-04 00:00:00',2576,'Hy-Vee Wine and Spirits / Storm Lake','1250 N Lake St','Storm Lake','50588.0','POINT (-95.200758 42.65318400000001)',11,'BUENA VIST',1062100,'Gold Rum',35,'BACARDI USA INC',43037,'Bacardi Gold',12,1000,9.5,14.25,2,28.5,2,0.52),('S22169400007','2014-11-05 00:00:00',3928,'Smokin\' Joe\'s #12 Tobacco and Liquor','465 HWY 965 UNIT G','NORTH LIBERTY','52317','POINT (-91.60759 41.739524)',52,'Johnson',1031100,'100 PROOF VODKA',300,'Mccormick Distilling Company',36908,'Mccormick Vodka Pet',6,1750,7.47,11.21,3,33.63,5.25,1.39),('S04156200024','2012-02-20 00:00:00',2285,'John\'s Grocery','401 EAST MARKET ST','IOWA CITY','52240','POINT (-91.529854 41.663541)',52,'Johnson',1701100,'DECANTERS & SPECIALTY PACKAGES',370,'Pernod Ricard USA/Austin Nichols',2878,'Absolut Zing Zang Bloody Mary Mix',3,1750,19.87,29.81,3,89.43,5.25,1.39),('S33157700058','2016-06-30 00:00:00',5102,'Wilkie Liquors','724 1st St SE','Mount Vernon','52314','POINT (-91.410401 41.918328)',57,'Linn',1081700,'DISTILLED SPIRITS SPECIALTY',434,'Luxco-St Louis',75087,'Juarez Gold Dss',12,1000,4.92,7.38,660,4870.8,660,174.35),('S18025600096','2014-03-24 00:00:00',2191,'Keokuk Spirits','1013 MAIN','KEOKUK','52632','POINT (-91.387797 40.400038)',56,'Lee',1081370,'WATERMELON SCHNAPPS',65,'Jim Beam Brands',82867,'Dekuyper Watermelon Pucker',12,1000,7.62,11.43,4,45.72,4,1.06),('INV-32122800013','2020-11-20 00:00:00',4896,'Barrys Mini Mart','403, Chestnut St','Harpers Ferry','52146.0','POINT (-91.38553 43.050183)',3,'ALLAMAKEE',1700000,'Temporary & Specialty Packages',260,'DIAGEO AMERICAS',101181,'Crown Royal Multibrand Advent Calendar',6,50,22.49,33.74,6,202.44,0.3,0.07),('INV-23689100001','2019-12-05 00:00:00',2633,'Hy-Vee #3 / BDI / Des Moines','3221 SE 14th St','Des Moines','50320.0','POINT (-93.596754 41.554101)',77,'POLK',1011800,'Iowa Distillery Whiskies',566,'Foundry Distilling Company, LLC',926577,'Glen Oaks Whiskey Buy the Barrel',6,750,19,28.5,66,1881,49.5,13.07),('INV-48328000010','2022-06-14 00:00:00',6268,'Super Mart / Oelwein','701 South Frederick Avenue','Oelwein','50662.0','POINT (-91.913481 42.669128)',33,'FAYETTE',1091300,'Neutral Grain Spirits Flavored',346,'OLE SMOKY DISTILLERY LLC',76412,'Ole Smoky Butter Pecan Moonshine Mini',8,50,8.75,13.13,4,52.52,0.2,0.05),('INV-48418000001','2022-06-16 00:00:00',4988,'Happy\'s Wine & Spirits','5925 University Ave','Cedar Falls','50613.0','POINT (-92.429644 42.512762)',7,'BLACK HAWK',1901200,'Special Order Items',368,'Park Street Imports',964525,'Branca Menta',6,750,19.47,29.21,18,525.78,13.5,3.56),('INV-48570500097','2022-06-22 00:00:00',2502,'Hy-Vee Wine and Spirits / Ankeny','410 North Ankeny Blvd','Ankeny','50021.0','',77,'POLK',1091100,'American Distilled Spirit Specialty',154,'DUNKEL CORPORATION / Iowa Distilling',78115,'Saints N Sinners Mini',8,50,8.38,12.57,3,37.71,0.15,0.03),('S09252300073','2012-12-03 00:00:00',2643,'Hy-Vee Wine and Spirits / Waterloo','2126 KIMBALL AVE','WATERLOO','50701','',7,'Black Hawk',1012300,'IRISH WHISKIES',370,'Pernod Ricard USA/Austin Nichols',15644,'Jameson',24,375,6.5,9.74,5,48.7,1.88,0.5),('S05197900001','2012-04-26 00:00:00',2190,'Central City Liquor, Inc.','1460 2ND AVE','DES MOINES','50314','POINT (-93.619787 41.60566)',77,'Polk',1011400,'BOTTLED IN BOND BOURBON',85,'Brown-Forman Corporation',26906,'Jack Daniels Single Barrel Why.',6,750,24.38,36.57,198,7240.86,148.5,39.23),('S03601100009','2012-01-17 00:00:00',2506,'Hy-Vee #1044 / Burlington','3140 AGENCY','BURLINGTON','52601','POINT (-91.136655 40.814666)',29,'Des Moines',1081700,'DISTILLED SPIRITS SPECIALTY',434,'Luxco-St Louis',75087,'Juarez Gold Dss',12,1000,4.75,7.13,96,684.48,96,25.36),('S22094200035','2014-10-29 00:00:00',3417,'Big G Food Store','PO BOX 261 310 W DILLON','MARENGO','52301','',48,'Iowa',1081340,'ROOT BEER SCHNAPPS',380,'Phillips Beverage Company',84617,'Phillips Root Beer Schnapps',12,1000,5.5,8.25,4,33,4,1.06),('S05878500009','2012-06-05 00:00:00',3477,'Sam\'s Club 6472 / Council Bluffs','3221 MANAWA CENTRE DR','COUNCIL BLUFFS','51501','POINT (-95.847163 41.225208)',78,'Pottawattamie',1081330,'PEACH SCHNAPPS',65,'Jim Beam Brands',82847,'Dekuyper Peachtree',12,1000,7.35,11.02,48,528.96,48,12.68),('S30624700060','2016-02-09 00:00:00',5166,'East Side Liquor and Groceries','1116 E NEVADA ST','MARSHALLTOWN','50158','POINT (-92.893113 42.044345)',64,'Marshall',1052100,'',420,'Moet Hennessy USA, Inc.',48099,'Hennessy VS',24,200,5.74,8.61,24,206.64,4.8,1.27),('S06563400058','2012-07-12 00:00:00',2569,'Hy-Vee Food Store #2 / Cedar Rapids','279 COLLINS ROAD NE','CEDAR RAPIDS','52402','POINT (-91.630677 42.027805)',57,'Linn',1042100,'IMPORTED DRY GINS',35,'Bacardi U.S.A., Inc.',28238,'Bombay Sapphire Gin',6,1750,26.22,39.33,3,117.99,5.25,1.39),('INV-36879200087','2021-05-24 00:00:00',2552,'Hy-Vee Food Store #3 / Cedar Rapids','20 Wilson Avenue West','Cedar Rapids','52404.0','POINT (-91.658577 41.955859)',57,'LINN',1041300,'American Sloe Gins',434,'LUXCO INC',33717,'Paramount Sloe Gin',12,1000,5.42,8.13,4,32.52,4,1.05),('S23143000059','2014-12-23 00:00:00',4604,'Pit Stop Liquors / Newton','1324, 1st AVE E','NEWTON','50208','POINT (-93.035654 41.699173)',50,'Jasper',1701100,'DECANTERS & SPECIALTY PACKAGES',420,'Moet Hennessy USA, Inc.',1258,'Glenmorangie Taster Pack',6,400,14.84,22.26,1,22.26,0.4,0.11),('S19819500030','2014-07-01 00:00:00',3447,'Sam\'s Club 6432 / Sioux City','4201 S. YORK ST.','SIOUX CITY','51106','POINT (-96.37082 42.43407)',97,'Woodbury',1081400,'TRIPLE SEC',434,'Luxco-St Louis',86251,'Juarez Triple Sec',12,1000,2.21,3.31,84,278.04,84,22.19),('INV-18341600009','2019-03-25 00:00:00',4867,'Speedy Gas N Shop','430 S 35th St','Council Bluffs','51501','POINT (-95.902023 41.257663)',78,'POTTAWATTA',1081100,'Coffee Liqueurs',370,'PERNOD RICARD USA',67524,'Kahlua Coffee',24,375,6.49,9.74,7,68.18,2.62,0.69),('INV-18280700077','2019-03-21 00:00:00',5102,'Wilkie Liquors','724 1st St SE','Mount Vernon','52314','POINT (-91.410401 41.918328)',57,'LINN',1092100,'Imported Distilled Spirit Specialty',434,'LUXCO INC',75087,'Juarez Gold Dss',12,1000,5,7.5,900,6750,900,237.75),('INV-19122600110','2019-05-02 00:00:00',2647,'Hy-Vee #7 / Cedar Rapids','5050 Edgewood Rd','Cedar Rapids','52411','POINT (-91.701581 42.030129)',57,'LINN',1091200,'Neutral Grain Spirits',434,'LUXCO INC',41846,'Everclear Alcohol',12,750,9,13.5,36,486,27,7.13),('INV-12116400006','2018-05-16 00:00:00',5003,'Famous Liquors','2604 W Locust St','Davenport','52804','POINT (-90.615542 41.538186)',82,'SCOTT',1092100,'Imported Distilled Spirit Specialty',370,'PERNOD RICARD USA',48690,'Martell VSSD',24,200,5.99,8.99,2,17.98,0.4,0.11),('INV-48744200012','2022-06-28 00:00:00',5514,'Johncy\'s Liquor Store','585 Hwy 965 Ste D & E','North Liberty','52317.0','POINT (-91.60761 41.738129)',52,'JOHNSON',1700000,'Temporary & Specialty Packages',260,'DIAGEO AMERICAS',101216,'Captain Morgan OSR w/50ml CM Sliced Apple',6,1750,18,27,78,2106,136.5,36.05),('S30824400027','2016-02-24 00:00:00',3447,'Sam\'s Club 6432 / Sioux City','4201 S. YORK ST.','SIOUX CITY','51106','POINT (-96.37082 42.43407)',97,'Woodbury',1081400,'TRIPLE SEC',434,'Luxco-St Louis',86251,'Juarez Triple Sec',12,1000,2.42,3.63,144,522.72,144,38.04),('S30984900084','2016-02-29 00:00:00',2512,'Hy-Vee Wine and Spirits / Iowa City','1720 WATERFRONT DR','IOWA CITY','52240','POINT (-91.53046300000001 41.642764)',52,'Johnson',1011500,'STRAIGHT RYE WHISKIES',255,'Wilson Daniels Ltd.',27102,'Templeton Rye',6,750,18.09,27.14,18,488.52,13.5,3.57),('INV-31762500009','2020-11-09 00:00:00',2630,'Hy-Vee Drugstore #2 / WDM','1010 60th St','West Des Moines','50266.0','POINT (-93.790534 41.584979)',77,'POLK',1700000,'Temporary & Specialty Packages',65,'Jim Beam Brands',434,'Jim Beam w/2 Glasses',6,750,10.5,15.75,90,1417.5,67.5,17.83),('INV-48056800026','2022-06-04 00:00:00',5936,'CJ\'s Convenience Store / Elkader','107 1st St SW','Elkader','52043.0','POINT (-91.405293 42.85389)',22,'CLAYTON',1091300,'Neutral Grain Spirits Flavored',346,'OLE SMOKY DISTILLERY LLC',80398,'Ole Smoky White Chocolate Strawberry Moonshine Mini',8,50,8.75,13.13,6,78.78,0.3,0.07),('INV-48112600094','2022-06-07 00:00:00',2623,'Hy-Vee Food Store #4 / Sioux City','2827 Hamilton Blvd','Sioux City','51104.0','POINT (-96.417795 42.519966)',97,'WOODBURY',1081100,'Coffee Liqueurs',370,'PERNOD RICARD USA',67522,'Kahlua Coffee Mini',12,50,6.6,9.9,3,29.7,0.15,0.03),('INV-23393500001','2019-11-21 00:00:00',2515,'Hy-Vee Food Store #1 / Mason City','2400 4th St SW','Mason City','50401.0','POINT (-93.235588 43.148451)',17,'CERRO GORD',1091300,'Neutral Grain Spirits Flavored',346,'OLE SMOKY DISTILLERY LLC',986845,'Ole Smoky Blackberry Moonshine Mini',8,50,8.75,13.13,48,630.24,2.4,0.63),('INV-39587600047','2021-08-26 00:00:00',5995,'Super Stop Liquor and Wine / Altoona','2635 Adventureland Dr','Altoona','50009.0','POINT (-93.494642 41.65854)',77,'POLK',1091300,'Neutral Grain Spirits Flavored',384,'PIEDMONT DISTILLERS INC',76067,'Midnight Moon Watermelon Mini',4,50,17.16,25.74,4,102.96,0.2,0.05),('S30192200003','2016-01-13 00:00:00',3772,'Shop N Save #1 / Mlk Pkwy','2127 M L KING JR PKWY','DES MOINES','50314','',77,'Polk',1051140,'PEACH BRANDIES',115,'Constellation Wine Company, Inc.',56193,'Paul Masson Peach Grande Amber Brandy',24,200,1.96,2.94,24,70.56,4.8,1.27),('S22091200129','2014-10-29 00:00:00',2512,'Hy-Vee Wine and Spirits / Iowa City','1720 WATERFRONT DR','IOWA CITY','52240','POINT (-91.53046300000001 41.642764)',52,'Johnson',1701100,'DECANTERS & SPECIALTY PACKAGES',370,'Pernod Ricard USA/Austin Nichols',734,'Absolut w/50ml Citron & Mandrin',12,850,11.49,17.24,120,2068.8,102,26.95),('S06135100018','2012-06-19 00:00:00',3629,'Wal-Mart 1965 / Council Bluffs','3200 MANAWA DR','COUNCIL BLUFFS','51503','',78,'Pottawattamie',1031100,'100 PROOF VODKA',300,'Mccormick Distilling Company',36908,'Mccormick Vodka Pet',6,1750,7.46,11.19,24,268.56,42,11.1),('S13053000058','2013-06-27 00:00:00',3942,'Twin Town Liquor','104 HIGHWAY 30 WEST','TOLEDO','52342','POINT (-92.579446 41.985985)',86,'Tama',1081335,'RASPBERRY SCHNAPPS',434,'Luxco-St Louis',82147,'Arrow Raspberry Schnapps',12,1000,4.75,7.13,4,28.52,4,1.06),('S27691400006','2015-10-14 00:00:00',3524,'Sam\'s Club 6568 / Ames','305 AIRPORT RD','AMES','50010','POINT (-93.613648 42.001123)',85,'Story',1701100,'DECANTERS & SPECIALTY PACKAGES',85,'Brown-Forman Corporation',472,'Jack Daniels Tennessee Honey w/Glass',6,750,15.07,22.61,30,678.3,22.5,5.94),('S08077400022','2012-10-03 00:00:00',3447,'Sam\'s Club 6432 / Sioux City','4201 S. YORK ST.','SIOUX CITY','51106','POINT (-96.37082 42.43407)',97,'Woodbury',1011500,'STRAIGHT RYE WHISKIES',255,'Wilson Daniels Ltd.',27102,'Templeton Rye',6,750,18.08,27.13,30,813.9,22.5,5.94),('S25033600015','2015-04-13 00:00:00',4829,'Central City 2','1501 MICHIGAN AVE','DES MOINES','50314','POINT (-93.613739 41.60572)',77,'Polk',1011500,'STRAIGHT RYE WHISKIES',255,'Wilson Daniels Ltd.',27102,'Templeton Rye',6,750,18.09,27.14,30,814.2,22.5,5.94),('INV-11703600001','2018-04-25 00:00:00',3524,'Sam\'s Club 6568 / Ames','305 Airport Rd','Ames','50010','POINT (-93.613648 42.001123)',85,'STORY',1901200,'Special Order Items',421,'SAZERAC COMPANY INC',946574,'Member\'s Mark Spiced Rum',6,1750,9.06,13.59,288,3913.92,504,133.14),('S27033900005','2015-07-29 00:00:00',4268,'Fareway Stores #531 / Algona','1905 HIGHWAY 18 E','ALGONA','50511','POINT (-94.214064 43.082782)',55,'Kossuth',1081380,'MISCELLANEOUS SCHNAPPS',55,'Sazerac North America',84171,'99 Bananas',48,100,0.89,1.34,48,64.32,4.8,1.27),('INV-40087100012','2021-09-14 00:00:00',5592,'Hubers Store','101 Main St','Fort Atkinson','52144.0','POINT (-91.932448 43.14339)',96,'WINNESHIEK',1081100,'Coffee Liqueurs',65,'Jim Beam Brands',67557,'Kamora Coffee Liqueur',12,1000,8.39,12.59,2,25.18,2,0.52),('S27848300001','2015-10-12 00:00:00',3790,'Wal-Mart 0784 / Mt Pleasan','1045 N GRAND AVE','MT PLEASANT','52641','POINT (-91.539034 40.978416)',44,'Henry',1701100,'DECANTERS & SPECIALTY PACKAGES',260,'Diageo Americas',1400,'Crown Royal w/2 Glasses',6,750,15,22.5,66,1485,49.5,13.08),('S30590700029','2016-02-08 00:00:00',5204,'Quik Stop / Burlington','1812 OSBORN ST','BURLINGTON','52601','POINT (-91.112658 40.826163)',29,'Des Moines',1031100,'100 PROOF VODKA',297,'Laird And Company',35913,'Five O\'clock Vodka',48,200,1.13,1.7,48,81.6,9.6,2.54),('S05878500024','2012-06-05 00:00:00',3477,'Sam\'s Club 6472 / Council Bluffs','3221 MANAWA CENTRE DR','COUNCIL BLUFFS','51501','POINT (-95.847163 41.225208)',78,'Pottawattamie',1081400,'TRIPLE SEC',434,'Luxco-St Louis',86251,'Juarez Triple Sec',12,1000,2.21,3.31,144,476.64,144,38.04),('INV-05780600013','2017-06-28 00:00:00',3447,'Sam\'s Club 6432 / Sioux City','4201 S. York St.','Sioux City','51106','POINT (-96.37082 42.43407)',97,'WOODBURY',1081100,'Coffee Liqueurs',421,'SAZERAC COMPANY INC',67586,'Kapali Coffee Liqueur',12,750,5.05,7.58,84,720.72,63,16.64),('INV-05775700006','2017-06-28 00:00:00',2522,'Hy-Vee Wine and Spirits / Spirit Lake','Hwy 9 & 71','Spirit Lake','51360','',30,'DICKINSON',1092100,'Imported Distilled Spirit Specialty',421,'SAZERAC COMPANY INC',77487,'Tortilla Gold Dss',12,1000,4.51,6.77,48,324.96,48,12.68),('INV-36845700009','2021-05-21 00:00:00',3910,'Riverside Casino And Resort','3184 Highway 22','Riverside','52327.0','POINT (-91.531499 41.496387000000006)',92,'WASHINGTON',1011600,'Straight Rye Whiskies',255,'Infinium Spirits',27175,'Templeton Rye 4YR',6,1000,21,31.5,6,189,6,1.58),('S13664600061','2013-07-31 00:00:00',3952,'Lot-A-Spirits','3780 STATE ST','BETTENDORF','52722','POINT (-90.48065 41.529655)',82,'Scott',1081330,'PEACH SCHNAPPS',65,'Jim Beam Brands',82847,'Dekuyper Peachtree',12,1000,7.62,11.43,60,685.8,60,15.85),('S23864600106','2015-02-04 00:00:00',2572,'Hy-Vee Food Store / Cedar Falls','6301 UNIVERSITY','CEDAR FALLS','50613','POINT (-92.435236 42.512789)',7,'Black Hawk',1081340,'ROOT BEER SCHNAPPS',380,'Phillips Beverage Company',84617,'Phillips Root Beer Schnapps',12,1000,5.5,8.25,4,33,4,1.06),('S19719700065','2014-06-24 00:00:00',2619,'Hy-Vee Wine and Spirits / WDM','1725 74TH ST','WEST DES MOINES','50266','POINT (-93.808855 41.598515)',77,'Polk',1011500,'STRAIGHT RYE WHISKIES',255,'Wilson Daniels Ltd.',27102,'Templeton Rye',6,750,18.09,27.14,18,488.52,13.5,3.57),('S33324700013','2016-07-12 00:00:00',2665,'Hy-Vee / Waukee','1005 E Hickman Rd','Waukee','50263','POINT (-93.854477 41.615059)',25,'Dallas',1701100,'DECANTERS & SPECIALTY PACKAGES',192,'Sidney Frank Importing Co.',3135,'Jagermeister w/2 Shot Glasses',12,750,12.05,18.08,84,1518.72,63,16.64),('S33584700201','2016-07-26 00:00:00',2619,'Hy-Vee Wine and Spirits / WDM','1725 74th St','West Des Moines','50266','POINT (-93.808855 41.598515)',77,'Polk',1701100,'DECANTERS & SPECIALTY PACKAGES',370,'Pernod Ricard USA/Austin Nichols',250,'Avion Silver w/Powell & Mahoney Margarita Mix',6,750,24.98,37.47,90,3372.3,67.5,17.83),('INV-18204200080','2019-03-18 00:00:00',4829,'Central City 2','1501 Michigan Ave','Des Moines','50314','POINT (-93.613739 41.60572)',77,'POLK',1081500,'Triple Sec',434,'LUXCO INC',86251,'Juarez Triple Sec',12,1000,2.42,3.63,180,653.4,180,47.55),('INV-24268000020','2019-12-31 00:00:00',3993,'New Star Liquor / W 4th S / Waterloo','1625 West 4th St','Waterloo','50701.0','',7,'BLACK HAWK',1062100,'Gold Rum',35,'BACARDI USA INC',43031,'Bacardi Gold Mini',12,50,5.54,8.31,4,33.24,0.2,0.05),('INV-02880700047','2017-01-24 00:00:00',2465,'Sid\'s Beverage Shop','2727 Dodge St','Dubuque','52003','POINT (-90.705328 42.491862)',31,'DUBUQUE',1062100,'Gold Rum',35,'BACARDI USA INC',43031,'Bacardi Gold Rum Mini',12,500,5.54,8.31,5,41.55,2.5,0.66),('INV-30633000143','2020-09-29 00:00:00',2572,'Hy-Vee Food Store / Cedar Falls','6301 University','Cedar Falls','50613.0','POINT (-92.435236 42.512789)',7,'BLACK HAWK',1062300,'Aged Dark Rum',421,'SAZERAC COMPANY INC',42167,'Myers\'s Original Dark Rum',12,1000,13,19.5,2,39,2,0.52),('S21419200004','2014-09-24 00:00:00',3869,'Bootleggin\' Barzini\'s Fin','412 1ST AVE','CORALVILLE','52241','POINT (-91.565517 41.672672)',52,'Johnson',1701100,'DECANTERS & SPECIALTY PACKAGES',370,'Pernod Ricard USA/Austin Nichols',837,'The Glenlivet Tasting Kit w/12YR 200ml, 15YR 200ml & 18YR 200ml',6,600,34.99,52.49,6,314.94,3.6,0.95),('S30696800117','2016-02-11 00:00:00',2587,'Hy-Vee Food Store / Johnston','5750 MERLE HAY ROAD','JOHNSTON','50131','POINT (-93.697731 41.665172)',77,'Polk',1031100,'100 PROOF VODKA',421,'Sazerac Co., Inc.',38089,'Platinum 7x Vodka',48,100,0.89,1.34,48,64.32,4.8,1.27),('INV-31899300015','2020-11-13 00:00:00',5309,'Royal Food','1443 2nd Ave','Des Moines','50314.0','POINT (-93.619783 41.605229)',77,'POLK',1700000,'Temporary & Specialty Packages',65,'Jim Beam Brands',430,'Jim Beam 50ml Holiday 4pk',12,50,2,3,36,108,1.8,0.47),('INV-31981600004','2020-11-16 00:00:00',3618,'Wal-Mart 2716 / Cedar Rapids','3601 29th Ave SW','Cedar Rapids','52404.0','POINT (-91.718042 41.949215)',57,'LINN',1700000,'Temporary & Specialty Packages',260,'DIAGEO AMERICAS',101217,'Captain Morgan OSR PET 6/1.75l w/ 50ml CM Sliced Apple',6,1750,18,27,36,972,63,16.64),('INV-39673900119','2021-08-31 00:00:00',2573,'Hy-Vee Food Store / Muscatine','2400 2nd Ave','Muscatine','52761.0','POINT (-91.035138 41.451349)',70,'MUSCATINE',1091200,'Neutral Grain Spirits',434,'LUXCO INC',41846,'Everclear 151',12,750,9,13.5,60,810,45,11.88),('INV-39702900142','2021-08-31 00:00:00',2593,'Hy-Vee Food Store / Carroll','905 US Highway 30 West','Carroll','51401.0','POINT (-94.853591 42.064155)',14,'CARROLL',1011600,'Straight Rye Whiskies',255,'Infinium Spirits',27125,'Templeton Rye 6YR',6,750,22.75,34.13,30,1023.9,22.5,5.94),('INV-29974100066','2020-09-03 00:00:00',2582,'Hy-Vee #2 Food Store / Mason City','551 S Illinois Ave','Mason City','50401.0','POINT (-93.17114 43.14623)',17,'CERRO GORD',1011600,'Straight Rye Whiskies',255,'Infinium Spirits',27175,'Templeton 4YR Rye',6,1000,21,31.5,6,189,6,1.58),('INV-36577200001','2021-05-12 00:00:00',2565,'Hy-Vee Food Store #1636 / Spencer','819 N Grand Ave','Spencer','51301.0','POINT (-95.14506 43.145897)',21,'CLAY',1011300,'Single Barrel Bourbon Whiskies',184,'FOUR ROSES DISTILLERY',18350,'Four Roses Single Barrel',6,750,22.5,33.75,36,1215,27,7.13),('S16673000012','2014-01-06 00:00:00',3591,'Ackley Super Foods','526 MAIN ST','ACKLEY','50601','POINT (-93.055216 42.554159)',94,'Webster',1051110,'BLACKBERRY BRANDIES',434,'Luxco-St Louis',55088,'Paramount Blackberry Brandy',6,1750,11.29,16.94,3,50.82,5.25,1.39),('INV-32061000087','2020-11-18 00:00:00',2555,'Hy-Vee Food Store / Keokuk','3111 Main','Keokuk','52632.0','POINT (-91.403752 40.41538)',56,'LEE',1700000,'Temporary & Specialty Packages',260,'DIAGEO AMERICAS',101216,'Captain Morgan OSR 6/1.75l w/ 50ml CM Sliced Apple',6,1750,18,27,90,2430,157.5,41.6),('INV-23828600019','2019-12-11 00:00:00',5146,'Fareway Stores #153 / W Des Moines','329 Grand Ave','West Des Moines','50265.0','POINT (-93.70689 41.58269000000001)',77,'POLK',1081100,'Coffee Liqueurs',370,'PERNOD RICARD USA',67526,'Kahlua Coffee',12,750,12.49,18.74,72,1349.28,54,14.26),('INV-23879500055','2019-12-12 00:00:00',2515,'Hy-Vee Food Store #1 / Mason City','2400 4th St SW','Mason City','50401.0','POINT (-93.235588 43.148451)',17,'CERRO GORD',1091300,'Neutral Grain Spirits Flavored',346,'OLE SMOKY DISTILLERY LLC',86843,'Ole Smoky Salty Caramel Whiskey',6,750,10,15,18,270,13.5,3.56),('INV-40037600033','2021-09-13 00:00:00',5949,'Uptown Liquor & Tobacco / Cedar Rapids','2000 Wiley Blvd SW STE 106','Cedar Rapids','52404.0','POINT (-91.725777 41.959614)',57,'LINN',1062100,'Gold Rum',35,'BACARDI USA INC',43038,'Bacardi Gold',6,1750,15,22.5,3,67.5,5.25,1.38),('S30519600038','2016-02-02 00:00:00',3705,'Liquor Locker','507 1ST AVE #100','ROCK RAPIDS','51246','',60,'Lyon',1081350,'SPEARMINT SCHNAPPS',434,'Luxco-St Louis',82187,'Arrow Spearmint Schnapps',12,1000,5,7.5,5,37.5,5,1.32),('INV-16756400027','2019-01-04 00:00:00',4156,'Fareway Stores #412 / Oelwein','102 2nd Ave SE','Oelwein','50662','POINT (-91.910502 42.677024)',33,'FAYETTE',1091300,'Neutral Grain Spirits Flavored',346,'OLE SMOKY DISTILLERY LLC',86739,'Ole Smoky Apple Pie Moonshine 70prf Mini',8,300,8.75,13.13,8,105.04,2.4,0.63),('INV-16882100032','2019-01-11 00:00:00',2178,'Double D Liquor Store','618 Rossville Road','Waukon','52172','POINT (-91.473634 43.262114)',3,'ALLAMAKEE',1081100,'Coffee Liqueurs',370,'PERNOD RICARD USA',67524,'Kahlua Coffee',24,375,6.49,9.74,1,9.74,0.37,0.09),('S24001600032','2015-02-11 00:00:00',4478,'U S Gas','3000, SW 9th ST','DES MOINES','50315','POINT (-93.625682 41.557862)',77,'Polk',1051100,'APRICOT BRANDIES',259,'Heaven Hill Brands',52314,'Christian Bros Brandy',24,375,3.23,4.85,5,24.25,1.88,0.5),('S17871000030','2014-03-19 00:00:00',3524,'Sam\'s Club 6568 / Ames','305 AIRPORT RD','AMES','50010','POINT (-93.613648 42.001123)',85,'Story',1011500,'STRAIGHT RYE WHISKIES',255,'Wilson Daniels Ltd.',27102,'Templeton Rye',6,750,18.09,27.14,120,3256.8,90,23.78),('S10365800032','2013-01-31 00:00:00',4180,'Smokin\' Joe\'s #10 Tobacco and Liquor','480 7TH AVE','MARION','52302','POINT (-91.605094 42.033366)',57,'Linn',1081305,'APPLE SCHNAPPS',65,'Jim Beam Brands',82604,'Dekuyper Sour Apple Pucker',24,375,3.06,4.59,7,32.13,2.62,0.69),('INV-05679500136','2017-06-22 00:00:00',2633,'Hy-Vee #3 / BDI / Des Moines','3221 SE 14th St','Des Moines','50320','POINT (-93.596754 41.554101)',77,'POLK',1092100,'Imported Distilled Spirit Specialty',421,'SAZERAC COMPANY INC',77487,'Tortilla Gold Dss',12,1000,4.51,6.77,72,487.44,72,19.02),('INV-05901900145','2017-07-05 00:00:00',2616,'Hy-Vee Food and Drug / Clinton','901 South 4th St','Clinton','52732','POINT (-90.193204 41.836268000000004)',23,'CLINTON',1062100,'Gold Rum',434,'LUXCO INC',45248,'Paramount Gold Rum',6,1750,7.84,11.76,24,282.24,42,11.1),('S16776600081','2014-01-13 00:00:00',3385,'Sam\'s Club 8162 / Cedar Rapids','2605 BLAIRS FERRY RD NE','CEDAR RAPIDS','52402','POINT (-91.67969 42.031819)',57,'Linn',1081700,'DISTILLED SPIRITS SPECIALTY',421,'Sazerac Co., Inc.',77487,'Tortilla Gold Dss',12,1000,4.51,6.76,144,973.44,144,38.04),('INV-18229400004','2019-03-19 00:00:00',3993,'New Star Liquor / W 4th S / Waterloo','1625 West 4th St','Waterloo','50701','',7,'BLACK HAWK',1062100,'Gold Rum',35,'BACARDI USA INC',43034,'Bacardi Gold',24,375,4.5,6.75,7,47.25,2.62,0.69),('INV-18227900139','2019-03-19 00:00:00',2571,'Hy-Vee Food Store #2 / Waterloo','2181 Logan Ave','Waterloo','50703','POINT (-92.337583 42.530476)',7,'BLACK HAWK',1062100,'Gold Rum',35,'BACARDI USA INC',43034,'Bacardi Gold',24,375,4.5,6.75,1,6.75,0.37,0.09),('INV-12108900028','2018-05-16 00:00:00',4971,'Fareway Stores #138 / Pleasant Hill','5500, E University Ave','Pleasant Hill','50327','POINT (-93.505732 41.599274)',77,'Polk',1062100,'Gold Rum',35,'BACARDI USA INC',43040,'Bacardi Gold Rum PET',6,1750,15,22.5,102,2295,178.5,47.15),('INV-24096400014','2019-12-23 00:00:00',2593,'Hy-Vee Food Store / Carroll','905 US Highway 30 West','Carroll','51401.0','POINT (-94.853591 42.064155)',14,'CARROLL',1011600,'Straight Rye Whiskies',65,'Jim Beam Brands',27189,'Basil Hayden Dark Rye',6,750,23.62,35.43,18,637.74,13.5,3.56),('INV-40375800006','2021-09-23 00:00:00',2515,'Hy-Vee Food Store #1 / Mason City','2400 4th St SW','Mason City','50401.0','POINT (-93.235588 43.148451)',17,'CERRO GORD',1062300,'Aged Dark Rum',65,'Jim Beam Brands',44442,'Cruzan Blackstrap',6,750,8.2,12.3,18,221.4,13.5,3.56),('INV-30697000054','2020-10-01 00:00:00',5251,'Northside Liquor','1303 North Federal','Mason City','50401.0','POINT (-93.201061 43.163663)',17,'CERRO GORD',1091100,'American Distilled Spirit Specialty',578,'S&B Farms Distillery',77055,'Sir Winston Peach',6,750,13.01,19.52,18,351.36,13.5,3.56),('S29181200007','2015-11-19 00:00:00',2626,'Hy-Vee Drugstore / University / DSM','4100 UNIVERSITY AVE','DES MOINES','50311','POINT (-93.673222 41.600361)',77,'Polk',1011500,'STRAIGHT RYE WHISKIES',260,'Diageo Americas',27025,'Bulleit 95 Rye',12,750,16.75,25.13,72,1809.36,54,14.27),('S11345900081','2013-03-28 00:00:00',2545,'Hy-Vee Drugstore / Iowa City','310 N 1ST ST','IOWA CITY','52245','POINT (-91.528105 42.207428)',52,'Johnson',1081400,'TRIPLE SEC',65,'Jim Beam Brands',86112,'Dekuyper Triple Sec',12,1000,2.21,3.32,4,13.28,4,1.06),('S30983900023','2016-02-29 00:00:00',2636,'Hy-Vee Wine and Spirits / Hubbell','2310 HUBBELL AVE','DES MOINES','50317','POINT (-93.573845 41.604312)',77,'Polk',1051140,'PEACH BRANDIES',115,'Constellation Wine Company, Inc.',56193,'Paul Masson Peach Grande Amber Brandy',24,200,1.96,2.94,24,70.56,4.8,1.27),('INV-48179800010','2022-06-08 00:00:00',5293,'The Boonedocks','228, N Hwy 71','Arnolds Park','51331.0','POINT (-95.125928 43.370941)',30,'DICKINSON',1081100,'Coffee Liqueurs',370,'PERNOD RICARD USA',67527,'Kahlua Coffee',12,1000,15.99,23.99,2,47.98,2,0.52),('S06415700066','2012-07-05 00:00:00',2200,'Sac Liquor Store','619 E MAIN ST','SAC CITY','50583','POINT (-94.974011 42.421341)',81,'Sac',1042100,'IMPORTED DRY GINS',260,'Diageo Americas',28867,'Tanqueray Gin',12,1000,14.99,22.48,4,89.92,4,1.06),('S05489800001','2012-05-10 00:00:00',3692,'Wilkie Liquors','724 1ST ST E','MT VERNON','52314','POINT (-91.960918 41.994458)',57,'Linn',1081400,'TRIPLE SEC',434,'Luxco-St Louis',86507,'Paramount Triple Sec',12,1000,3.75,5.62,48,269.76,48,12.68),('S28565600082','2015-10-20 00:00:00',3942,'Twin Town Liquor','104 HIGHWAY 30 WEST','TOLEDO','52342','POINT (-92.579446 41.985985)',86,'Tama',1042100,'IMPORTED DRY GINS',260,'Diageo Americas',28867,'Tanqueray Gin',12,1000,15.25,22.88,4,91.52,4,1.06),('S33174400010','2016-07-01 00:00:00',9001,'Cedar Ridge Vineyards','1441 Marak Rd NW','Swisher','52338','POINT (-91.67737 41.8321)',52,'Johnson',1012210,'SINGLE MALT SCOTCH',125,'Cedar Ridge Vineyards,LLC',27357,'Cedar Ridge Single Malt Single Barrel Select',6,750,27.5,41.25,90,3712.5,67.5,17.83),('INV-11928300062','2018-05-07 00:00:00',2512,'Hy-Vee Wine and Spirits / Iowa City','1720 Waterfront Dr','Iowa City','52240','POINT (-91.53046300000001 41.642764)',52,'JOHNSON',1081500,'Triple Sec',434,'LUXCO INC',86251,'Juarez Triple Sec',12,1000,2.42,3.63,60,217.8,60,15.85),('INV-11935900110','2018-05-07 00:00:00',2591,'Hy-Vee Wine and Spirits / Atlantic','1602 E 7th St','Atlantic','50022','POINT (-94.990031 41.403856)',15,'CASS',1081500,'Triple Sec',434,'LUXCO INC',86507,'Paramount Triple Sec',12,1000,3.84,5.76,4,23.04,4,1.06),('INV-05445500002','2017-06-12 00:00:00',2538,'Hy-Vee Food Store #3 / Waterloo','1422 Flammang Dr','Waterloo','50702','POINT (-92.327917 42.459938)',7,'BLACK HAWK',1901200,'Special Order Items',259,'Heaven Hill Brands',917914,'HA Elijah Craig Cask Barrel Proof',3,750,29.92,44.88,18,807.84,13.5,3.57),('S29733400113','2015-12-18 00:00:00',2512,'Hy-Vee Wine and Spirits / Iowa City','1720 WATERFRONT DR','IOWA CITY','52240','POINT (-91.53046300000001 41.642764)',52,'Johnson',1012300,'IRISH WHISKIES',370,'Pernod Ricard USA/Austin Nichols',15621,'Jameson Mini',10,600,11.88,17.82,4,71.28,2.4,0.63),('S21774000049','2014-10-14 00:00:00',2544,'Hy-Vee Food Store / Marshalltown','802 SOUTH CENTER','MARSHALLTOWN','50158','POINT (-92.912817 42.039205)',64,'Marshall',1042100,'IMPORTED DRY GINS',260,'Diageo Americas',28868,'Tanqueray Gin',6,1750,24.99,37.49,3,112.47,5.25,1.39),('INV-32115900001','2020-11-20 00:00:00',3868,'Wal-Mart 3630 / Marion','5491 Business Hwy 151','Marion','52302.0','',57,'LINN',1700000,'Temporary & Specialty Packages',260,'DIAGEO AMERICAS',101181,'Crown Royal Multibrand Advent Calendar',6,50,22.49,33.74,18,607.32,0.9,0.23),('INV-40011600078','2021-09-13 00:00:00',2561,'Hy-Vee Food Store / Fleur / DSM','4605 Fleur Drive','Des Moines','50321.0','POINT (-93.64494300000001 41.542748)',77,'POLK',1091100,'American Distilled Spirit Specialty',662,'IA-Native Spirits',75372,'Lemoncello 50010',6,750,12.49,18.74,60,1124.4,45,11.88),('INV-02320700006','2016-12-22 00:00:00',3447,'Sam\'s Club 6432 / Sioux City','4201 S. York St.','Sioux City','51106','POINT (-96.37082 42.43407)',97,'WOODBURY',1081100,'Coffee Liqueurs',370,'PERNOD RICARD USA',67527,'Kahlua Coffee Liqueur',12,1000,14.99,22.49,240,5397.6,240,63.4),('S07379700036','2012-10-05 00:00:00',2644,'Hy-Vee Fort Dodge Wine and Spirits','1511 2ND AVE NORTH','FORT DODGE','50501','POINT (-94.177165 42.508344)',94,'Webster',1701100,'DECANTERS & SPECIALTY PACKAGES',260,'Diageo Americas',2870,'Bailey\'s Original Irish Cream w/2 Glasses',6,750,13,19.5,72,1404,54,14.27),('S07338200008','2012-10-26 00:00:00',2620,'Hy-Vee / Windsor Heights','7101 UNIVERSITY AVE','WINDSOR HEIGHTS','50311','',77,'Polk',1701100,'DECANTERS & SPECIALTY PACKAGES',421,'Sazerac Co., Inc.',76436,'Old St. Nick\'\'s Egg Nog',12,750,3.63,5.45,60,327,45,11.89),('S25180400119','2015-04-21 00:00:00',4167,'Iowa Street Market, Inc.','1256 IOWA ST','DUBUQUE','52001','POINT (-90.668138 42.504959)',31,'Dubuque',1081400,'TRIPLE SEC',434,'Luxco-St Louis',86507,'Paramount Triple Sec',12,1000,3.84,5.76,4,23.04,4,1.06),('S30557300014','2016-02-04 00:00:00',5113,'Ray\'s Supermarket, Inc.','1975 FRANKLIN ST','WATERLOO','50703','POINT (-92.315215 42.495394)',7,'Black Hawk',1052100,'',420,'Moet Hennessy USA, Inc.',48099,'Hennessy VS',24,200,5.74,8.61,24,206.64,4.8,1.27),('S09484800001','2012-12-13 00:00:00',4141,'Fareway Stores #975 / SE 22nd / DSM','3000 SE 22ND ST','DES MOINES','50320','POINT (-93.57748 41.556274)',77,'Polk',1011500,'STRAIGHT RYE WHISKIES',255,'Wilson Daniels Ltd.',27102,'Templeton Rye',6,750,18.08,27.13,120,3255.6,90,23.78),('S24517200030','2015-03-16 00:00:00',3385,'Sam\'s Club 8162 / Cedar Rapids','2605 BLAIRS FERRY RD NE','CEDAR RAPIDS','52402','POINT (-91.67969 42.031819)',57,'Linn',1081030,'COFFEE LIQUEURS',65,'Jim Beam Brands',67557,'Kamora Coffee Liqueur',12,1000,8.39,12.59,72,906.48,72,19.02),('INV-05690500027','2017-06-23 00:00:00',4291,'Fareway Stores #597 / Creston','105 E Adams St','Creston','50801','POINT (-94.237509 40.715722)',88,'UNION',1062100,'Gold Rum',35,'BACARDI USA INC',43037,'Bacardi Gold Rum',12,1000,9.5,14.25,5,71.25,5,1.32),('INV-17897100064','2019-03-04 00:00:00',4152,'Food Land Super Markets','407 W Huron','Missouri Valley','51555','POINT (-95.899346 41.557404)',43,'HARRISON',1062100,'Gold Rum',434,'LUXCO INC',45247,'Paramount Gold Rum',12,1000,4.42,6.63,2,13.26,2,0.52),('INV-19169000013','2019-05-06 00:00:00',2593,'Hy-Vee Food Store / Carroll','905 US Highway 30 West','Carroll','51401','POINT (-94.853591 42.064155)',14,'CARROLL',1062100,'Gold Rum',35,'BACARDI USA INC',43031,'Bacardi Gold Mini',12,500,5.54,8.31,12,99.72,6,1.58),('INV-26474100003','2020-04-13 00:00:00',2633,'Hy-Vee #3 / BDI / Des Moines','3221 SE 14th St','Des Moines','50320.0','POINT (-93.596754 41.554101)',77,'POLK',1901200,'Special Order Items',65,'Jim Beam Brands',936097,'Gilbeys Vodka',12,1000,5.25,7.88,72,567.36,72,19.02),('INV-40313100005','2021-09-22 00:00:00',9001,'Cedar Ridge Vineyards','1441 Marak Rd NW','Swisher','52338.0','POINT (-91.67737 41.8321)',52,'JOHNSON',1700000,'Temporary & Specialty Packages',125,'CEDAR RIDGE VINEYARDS LL',86990,'Cedar Ridge Sir Maple',6,750,23,34.5,78,2691,58.5,15.45),('INV-30758700021','2020-10-05 00:00:00',2512,'Hy-Vee Wine and Spirits / Iowa City','1720 Waterfront Dr','Iowa City','52240.0','POINT (-91.53046300000001 41.642764)',52,'JOHNSON',1081500,'Triple Sec',65,'Jim Beam Brands',86112,'Dekuyper Triple Sec',12,1000,2.33,3.5,48,168,48,12.68),('S30812800004','2016-02-18 00:00:00',5063,'Logan Convenience Store','735, LOGAN AVE','WATERLOO','50703','POINT (-92.337744 42.510453)',7,'Black Hawk',1031100,'100 PROOF VODKA',255,'Wilson Daniels Ltd.',37880,'Seagrams Extra Smooth',24,200,1.76,2.64,24,63.36,4.8,1.27),('INV-23543600014','2019-11-27 00:00:00',3549,'Quicker Liquor Store','1414 48th St','Fort Madison','52627.0','POINT (-91.373211 40.62422600000001)',56,'LEE',1081100,'Coffee Liqueurs',421,'SAZERAC COMPANY INC',67586,'Kapali Coffee Liqueur',12,750,5.72,8.58,36,237.24,27,7.13),('INV-29949800007','2020-09-02 00:00:00',2605,'Hy-Vee Drugstore #5 / Cedar Rapids','2001 Blairs Ferry Road NE','Cedar Rapids','52402.0','POINT (-91.668919 42.034799)',57,'LINN',1011600,'Straight Rye Whiskies',434,'LUXCO INC',27171,'Minor Case Straight Rye',6,750,20,30,30,900,22.5,5.94),('INV-30087000085','2020-09-09 00:00:00',5514,'Johncy\'s Liquor Store','585 Hwy 965 Ste D & E','North Liberty','52317.0','POINT (-91.60761 41.738129)',52,'JOHNSON',1011600,'Straight Rye Whiskies',255,'Infinium Spirits',27175,'Templeton 4YR Rye',6,1000,21,31.5,6,189,6,1.58),('INV-33889200035','2021-01-29 00:00:00',2607,'Hy-Vee Wine and Spirits / Shenandoah','520 So Fremont','Shenandoah','51601.0','POINT (-95.385111 40.761736)',73,'PAGE',1081100,'Coffee Liqueurs',65,'Jim Beam Brands',67557,'Kamora Coffee Liqueur',12,1000,8.39,12.59,5,62.95,5,1.32),('S28238500181','2015-10-01 00:00:00',2663,'Hy-Vee / Urbandale','8701 DOUGLAS','URBANDALE','50322','POINT (-93.739105 41.629364)',77,'Polk',1701100,'DECANTERS & SPECIALTY PACKAGES',305,'MHW Ltd',4114,'Rumchata Iced Coffee Pack',6,750,12.5,18.75,36,675,27,7.13),('S13019100037','2013-06-26 00:00:00',3625,'Wal-Mart 0892 / Ankeny','1002 SE NATIONAL DR','ANKENY','50021','POINT (-93.582348 41.70486400000001)',77,'Polk',1011500,'STRAIGHT RYE WHISKIES',255,'Wilson Daniels Ltd.',27102,'Templeton Rye',6,750,18.08,27.13,18,488.34,13.5,3.57),('S18502100014','2014-04-21 00:00:00',3899,'Wal-Mart 3762 / WDM','6365 STAGECOACH DR','WEST DES MOINES','50266','POINT (-93.795512 41.558107)',77,'Polk',1701100,'DECANTERS & SPECIALTY PACKAGES',65,'Jim Beam Brands',19081,'Jim Beam Operation Homefront',6,1750,19.94,29.91,24,717.84,42,11.1),('S23024900039','2014-12-18 00:00:00',4807,'Williamsburg Foods','103, W WALNUT ST','WILLIAMSBURG','52361','POINT (-92.007391 41.662819)',48,'Iowa',1081330,'PEACH SCHNAPPS',65,'Jim Beam Brands',82849,'Dekuyper Peachtree Schnapps Pet',6,1750,11.54,17.31,4,69.24,7,1.85),('S27304200029','2015-08-12 00:00:00',2625,'Hy-Vee Wine and Spirits #2','3301 W KIMBERLY RD','DAVENPORT','52804','',82,'Scott',1042100,'IMPORTED DRY GINS',260,'Diageo Americas',28868,'Tanqueray Gin',6,1750,24.99,37.49,3,112.47,5.25,1.39),('S20038300091','2014-07-10 00:00:00',3692,'Wilkie Liquors','724 1ST ST E','MT VERNON','52314','POINT (-91.960918 41.994458)',57,'Linn',1081400,'TRIPLE SEC',434,'Luxco-St Louis',86507,'Paramount Triple Sec',12,1000,3.75,5.62,120,674.4,120,31.7),('INV-18020600032','2019-03-08 00:00:00',3963,'Tobacco Hut #14 / Council Bluffs','1925 W Broadway','Council Bluffs','51501','POINT (-95.873073 41.261866)',78,'POTTAWATTA',1062100,'Gold Rum',35,'BACARDI USA INC',43031,'Bacardi Gold Mini',12,500,5.54,8.31,4,33.24,2,0.52),('INV-23938500001','2019-12-16 00:00:00',4136,'Fareway Stores #983 / Grimes','351 Gateway Dr','Grimes','50111.0','',77,'POLK',1091100,'American Distilled Spirit Specialty',154,'DUNKEL CORPORATION',77805,'Saints N Sinners Apple Pie',12,750,8,12,108,1296,81,21.39),('INV-30244200003','2020-09-15 00:00:00',5352,'Casey\'s General Store # 3565/ Tripoli','600 7th Ave','Tripoli','50676.0','',9,'BREMER',1081100,'Coffee Liqueurs',370,'PERNOD RICARD USA',67524,'Kahlua Coffee',24,375,6.49,9.74,3,29.22,1.12,0.29),('INV-30208800030','2020-09-14 00:00:00',5339,'Prime Star','395 Western Avenue','Marengo','52301.0','POINT (-92.074374 41.792953)',48,'IOWA',1081100,'Coffee Liqueurs',370,'PERNOD RICARD USA',67524,'Kahlua Coffee',24,375,6.49,9.74,3,29.22,1.12,0.29),('INV-30280200091','2020-09-16 00:00:00',2555,'Hy-Vee Food Store / Keokuk','3111 Main','Keokuk','52632.0','POINT (-91.403752 40.41538)',56,'LEE',1062100,'Gold Rum',35,'BACARDI USA INC',43037,'Bacardi Gold',12,1000,9.5,14.25,2,28.5,2,0.52),('INV-30470200046','2020-09-23 00:00:00',5315,'Brother\'s Market Wine and Spirits','110 South Main Street','Sigourney','52591.0','POINT (-92.20510500000002 41.333293)',54,'KEOKUK',1081500,'Triple Sec',434,'LUXCO INC',86251,'Juarez Triple Sec',12,1000,2.42,3.63,2,7.26,2,0.52),('INV-39999600001','2021-09-11 00:00:00',5292,'John\'s Qwik Stop','814, C Ave','Vinton','52349.0','POINT (-92.027865 42.163119)',6,'BENTON',1700000,'Temporary & Specialty Packages',205,'E & J Gallo Winery',73065,'RumChata Peppermint Bark',12,750,13.5,20.25,144,2916,108,28.53),('INV-48272100239','2022-06-13 00:00:00',2573,'Hy-Vee Food Store / Muscatine','2400 2nd Ave','Muscatine','52761.0','POINT (-91.035301 41.450849)',70,'MUSCATINE',1091300,'Neutral Grain Spirits Flavored',346,'OLE SMOKY DISTILLERY LLC',86739,'Ole Smoky Apple Pie Moonshine 70prf Mini',8,50,8.75,13.13,3,39.39,0.15,0.03),('S30560800002','2016-02-03 00:00:00',4057,'Tequila\'s Liquor Store','1434 DES MOINES ST STE 5','DES MOINES','50316','POINT (-93.59704 41.594713)',77,'Polk',1052100,'',420,'Moet Hennessy USA, Inc.',48099,'Hennessy VS',24,200,5.74,8.61,48,413.28,9.6,2.54),('S30703100053','2016-02-15 00:00:00',3494,'Sam\'s Club 6514 / Waterloo','210 EAST TOWER PARK DR','WATERLOO','50702','POINT (-92.353103 42.456374)',7,'Black Hawk',1081700,'DISTILLED SPIRITS SPECIALTY',421,'Sazerac Co., Inc.',77487,'Tortilla Gold Dss',12,1000,4.51,6.77,768,5199.36,768,202.88),('INV-16653400110','2018-12-31 00:00:00',2643,'Hy-Vee Wine and Spirits / Waterloo','2126 Kimball Ave','Waterloo','50701','',7,'BLACK HAWK',1081500,'Triple Sec',65,'Jim Beam Brands',86112,'Dekuyper Triple Sec',12,1000,2.33,3.5,2,7,2,0.52),('INV-17055600010','2019-01-22 00:00:00',2843,'CVS Pharmacy #8526 / Cedar Rapids','4116 Center Pointe Rd','Cedar Rapids','52402','POINT (-91.665139 42.020729)',57,'LINN',1062100,'Gold Rum',434,'LUXCO INC',45246,'Paramount Gold Rum',12,750,4,6,7,42,5.25,1.38),('INV-00002300008','2016-08-29 00:00:00',5244,'The Ox & Wren Spirits and Gifts','708 2nd AVE SE','Cresco','52136','POINT (-92.106529 43.371131)',45,'HOWARD',1031000,'American Vodka',297,'Laird & Company',35917,'Five O\'clock Vodka',12,1000,4.17,6.26,2,75.12,2,0.52),('INV-26642700001','2020-04-17 00:00:00',5236,'Giggle Juice Liquor Station, LLC','600 W Main St','Anamosa','52205.0','POINT (-91.29083400000002 42.108203)',53,'JONES',1092100,'Imported Distilled Spirit Specialty',421,'SAZERAC COMPANY INC',77487,'Tortilla Gold DSS',12,1000,4.85,7.28,60,436.8,60,15.85),('INV-24116900112','2019-12-23 00:00:00',2670,'Hy-Vee Food Store / Coralville','2004 8th St','Coralville','52241.0','POINT (-91.591868 41.682337000000004)',52,'JOHNSON',1092100,'Imported Distilled Spirit Specialty',353,'John Ernest Distillery, Inc.',65750,'Maestro Agavero Gold',12,1000,7,10.5,48,504,48,12.68),('INV-44363100014','2022-02-02 00:00:00',5298,'DeWitt Travel Mart','630, 6th Ave','DeWitt','52742.0','POINT (-90.538952 41.821779)',23,'CLINTON',1091300,'Neutral Grain Spirits Flavored',384,'PIEDMONT DISTILLERS INC',76069,'Midnight Moon Apple Pie Mini',4,50,17.16,25.74,4,102.96,0.2,0.05),('S14178600031','2013-10-14 00:00:00',4098,'Wal-Mart 1475 / Washington','2485 HWY 92','WASHINGTON','52353','POINT (-91.660194 41.296202)',92,'Washington',1701100,'DECANTERS & SPECIALTY PACKAGES',421,'Sazerac Co., Inc.',76436,'Old St. Nick\'\'s Egg Nog',12,750,3.64,5.46,120,655.2,90,23.78),('S29111400017','2015-11-17 00:00:00',2565,'Hy-Vee Food Store / Spencer','819 N GRAND AVE','SPENCER','51301','POINT (-95.14506 43.145897)',21,'Clay',1081330,'PEACH SCHNAPPS',65,'Jim Beam Brands',82847,'Dekuyper Peachtree',12,1000,7.62,11.43,5,57.15,5,1.32),('S07550700025','2012-09-05 00:00:00',3385,'Sam\'s Club 8162 / Cedar Rapids','2605 BLAIRS FERRY RD NE','CEDAR RAPIDS','52402','POINT (-91.67969 42.031819)',57,'Linn',1081400,'TRIPLE SEC',434,'Luxco-St Louis',86507,'Paramount Triple Sec',12,1000,3.75,5.62,96,539.52,96,25.36),('INV-31954700002','2020-11-16 00:00:00',2633,'Hy-Vee #3 / BDI / Des Moines','3221 SE 14th St','Des Moines','50320.0','POINT (-93.596754 41.554101)',77,'POLK',1901200,'Special Order Items',370,'PERNOD RICARD USA',902150,'Hiram Walker Blue Curacao',12,750,4,6,36,216,27,7.13),('INV-08495400086','2017-11-07 00:00:00',4167,'Iowa Street Market, Inc.','1256 Iowa St','Dubuque','52001','POINT (-90.668138 42.504959)',31,'DUBUQUE',1081100,'Coffee Liqueurs',65,'Jim Beam Brands',67557,'Kamora Coffee Liqueur',12,1000,8.39,12.59,4,50.36,4,1.06),('INV-08632500071','2017-11-14 00:00:00',3385,'Sam\'s Club 8162 / Cedar Rapids','2605 Blairs Ferry Rd NE','Cedar Rapids','52402','POINT (-91.67969 42.031819)',57,'LINN',1081500,'Triple Sec',55,'SAZERAC NORTH AMERICA',86390,'Montezuma Triple Sec',12,1000,2.13,3.2,216,691.2,216,57.06),('INV-28352300005','2020-06-29 00:00:00',5292,'John\'s Qwik Stop','814, C Ave','Vinton','52349.0','POINT (-92.027865 42.163119)',6,'BENTON',1062100,'Gold Rum',35,'BACARDI USA INC',43038,'Bacardi Gold',6,1750,15,22.5,3,67.5,5.25,1.38),('INV-33910800023','2021-01-29 00:00:00',2644,'Hy-Vee Fort Dodge Wine and Spirits','1511 2nd Ave North','Fort Dodge','50501.0','POINT (-94.177165 42.508344)',94,'WEBSTER',1700000,'Temporary & Specialty Packages',260,'DIAGEO AMERICAS',101217,'Captain Morgan OSR PET 6/1.75l w/ 50ml CM Sliced Apple',6,1750,18,27,156,4212,273,72.11),('S30234800064','2016-01-15 00:00:00',4829,'Central City 2','1501 MICHIGAN AVE','DES MOINES','50314','POINT (-93.613739 41.60572)',77,'Polk',1081400,'TRIPLE SEC',434,'Luxco-St Louis',86251,'Juarez Triple Sec',12,1000,2.42,3.63,60,217.8,60,15.85),('S13771300075','2013-08-07 00:00:00',3354,'Sam\'s Club 8238 / Davenport','3845 ELMORE AVE.','DAVENPORT','52807','POINT (-90.527081 41.559731)',82,'Scott',1031100,'100 PROOF VODKA',300,'Mccormick Distilling Company',36887,'McCormick Vodka',12,1000,4.13,6.2,204,1264.8,204,53.89),('S21330500108','2014-09-22 00:00:00',2560,'Hy-Vee Food Store / Marion','3600 BUSINESS HWY 151 EAST','MARION','52302','',57,'Linn',1041200,'AMERICAN SLOE GINS',434,'Luxco-St Louis',33717,'Paramount Sloe Gin',12,1000,5.17,7.76,4,31.04,4,1.06);
/*!40000 ALTER TABLE `finance_liquor_sales` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2022-08-11 14:40:57