#Wine Magazine
Find the number of wines each taster tasted within the variation.
Output the tester's name, variety, and the number of tastings.
Order records by taster name and the variety in ascending order and by the number of tasting in descending order.
table name: winemag_p2
Solution:
select taster_name,variety,
count(*) as noOfTasting
from winemag_p2
where taster_name is not null
group by variety,taster_name
order by
taster_name,variety ,
noOfTasting desc
Output(Few Records):
SQL Script:
USE [StrataScratch]
GO
CREATE TABLE [dbo].[winemag_p2](
[id] [int] NULL,
[country] [varchar](50) NULL,
[description] [varchar](max) NULL,
[designation] [varchar](150) NULL,
[points] [int] NULL,
[price] [float] NULL,
[province] [varchar](500) NULL,
[region_1] [varchar](50) NULL,
[region_2] [varchar](50) NULL,
[taster_name] [varchar](50) NULL,
[taster_twitter_handle] [varchar](50) NULL,
[title] [varchar](500) NULL,
[variety] [varchar](50) NULL,
[winery] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (118040, N'US', N'A bit too soft and thus lacks structure. Shows a good array of wild berry and briary, brambly flavors. Dry and spicy, and ready now.', N'The Convict Rocky Ridge Vineyard', 86, 38, N'California', N'Rockpile', N'Sonoma', N'', N'', N'Paradise Ridge 2006 The Convict Rocky Ridge Vineyard Zinfandel (Rockpile)', N'Zinfandel', N'Paradise Ridge')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (59743, N'Italy', N'Aromas of toasted oak, vanilla and a confectionary note lead the nose while the palate offers mature Golden Delicious apple, butterscotch and walnut skin alongside bracing acidity.', N'Mongris Riserva', 88, 30, N'Northeastern Italy', N'Collio', N'', N'Kerin O''Keefe', N'@kerinokeefe', N'Marco Felluga 2012 Mongris Riserva Pinot Grigio (Collio)', N'Pinot Grigio', N'Marco Felluga')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (117951, N'US', N'Heavy in alcohol and overripe, but entirely dry, and the black currant, chocolate and pepper flavors will play well against richly sauced barbecue.', N'The Caboose', 84, 30, N'California', N'Alexander Valley', N'Sonoma', N'', N'', N'Starry Night 2007 The Caboose Zinfandel (Alexander Valley)', N'Zinfandel', N'Starry Night')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (10202, N'France', N'Fragrant; dusty plum and rose aromas are followed on the palate by very fruity flavors of cherries and apple skins. The fine bead and rich mousse result in a creamy mouthfeel. It''s all a bit obvious and simple, but undeniably good.', N'Brut Rosa', 87, 83, N'Champagne', N'Champagne', N'', N'Joe Czerwinski', N'@JoeCz', N'Ruinart NV Brut Rosa (Champagne)', N'Champagne Blend', N'Ruinart')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (69268, N'Germany', N'Layers of plush yellow peach and apricot flavors highlight this easy, crowd-pleasing kabinett. Sunny lemon acidity lends refreshment to the midpalate, cutting through all the ripeness and leading to a brisk finish. Drink now through 2019.', N'Kabinett', 88, 15, N'Rheinhessen', N'', N'', N'Anna Lee C. Iijima', N'', N'Weinreich 2012 Kabinett Riesling (Rheinhessen)', N'Riesling', N'Weinreich')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (8052, N'US', N'A boisterous, easy-drinking red wine that gushes ripe fruit and sweet oak aromas. It tastes almost sweet, like blackberry jam, and seems soft-textured in spite of its full body.', N'Dante''s Inferno', 86, 31, N'California', N'California', N'California Other', N'Jim Gordon', N'@gordone_cellars', N'Dante Robere 2012 Dante''s Inferno Red (California)', N'Rhane-style Red Blend', N'Dante Robere')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (18672, N'US', N'Superripe and oaky in pineapple, white peach purae, pear tart, buttered toast and vanilla-infused crame bralae, this Chardonnay is saved from mere richness by crisp coastal acidity and a fine spine of minerals. Exotic and delicious, it''s at its best now.', N'Split Rock Vineyard', 92, 30, N'California', N'Sonoma Coast', N'Sonoma', N'', N'', N'Bartz-Allen 2008 Split Rock Vineyard Chardonnay (Sonoma Coast)', N'Chardonnay', N'Bartz-Allen')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (106260, N'France', N'This is a fresh wine that has been aged in tanks, retaining its bright red fruits and lively acidity. It is still young although it will develop quickly to give a soft fruit-driven wine.', N'', 86, 11, N'Bordeaux', N'Bordeaux', N'', N'Roger Voss', N'@vossroger', N'Chateau Roc de Sagur 2015 Bordeaux', N'Bordeaux-style Red Blend', N'Chateau Roc de Sagur')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (75703, N'US', N'This white is a study in unexpected complexity and pleasure. Quince, sulfur and grapefruit notes define it best, as supple minerality and gravelly texture provide dimensionality.', N'Olema', 90, 15, N'California', N'Sonoma County', N'Sonoma', N'Virginie Boone', N'@vboone', N'Amici 2014 Olema Chardonnay (Sonoma County)', N'Chardonnay', N'Amici')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (2756, N'Chile', N'There are a lot of uncommon, unusual elements to this Pinot. For starters, the nose is volatile, with notes of horseradish and grapefruit. The palate has a solid, juicy feel to it, while mulchy cherry and plum flavors finish aimlessly.', N'Unfiltered', 84, 25, N'Casablanca Valley', N'', N'', N'Michael Schachner', N'@wineschach', N'Loma Larga 2013 Unfiltered Pinot Noir (Casablanca Valley)', N'Pinot Noir', N'Loma Larga')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (56290, N'Italy', N'Mediterra opens with intense aromas of bell pepper, red currants, sage and black pepper. The round palate offers lush plum and blackberry layered with nutmeg, clove and pepper. Pair it with a variety of foods including cured meats and medium aged cheeses.', N'Mediterra', 89, 25, N'Tuscany', N'Toscana', N'', N'Kerin O''Keefe', N'@kerinokeefe', N'Poggio al Tesoro 2011 Mediterra Red (Toscana)', N'Red Blend', N'Poggio al Tesoro')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (40766, N'Spain', N'A green, struggling wine from front to back. The nose kicks up underripe aromas to go with distant red fruit, while the palate is edgy and prickly, with high acidity creating snappy cherry and green flavors.', N'Esenzia', 82, 9, N'Northern Spain', N'Vino de la Tierra del Bajo Aragun', N'', N'Michael Schachner', N'@wineschach', N'Bodegas y Vinos de Lacera NV Esenzia Garnacha (Vino de la Tierra del Bajo Aragun)', N'Garnacha', N'Bodegas y Vinos de Lacera')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (109977, N'US', N'All stainless, no malolactic and widely available distribution make this a pure-blooded warm weather go-to white wine. It''s young and still a bit yeasty, aromatic with scents of seeds and grains. Tightly wound fruit flavors of apple and green melon come with good depth and texture.', N'Estate Grown', 89, 20, N'Oregon', N'Willamette Valley', N'Willamette Valley', N'Paul Gregutt', N'@paulgwine', N'WillaKenzie Estate 2016 Estate Grown Pinot Gris (Willamette Valley)', N'Pinot Gris', N'WillaKenzie Estate')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (2553, N'US', N'Sharp aromas of peach blossoms, honeyed nuts and lemon balm make for a fruity yet biting nose on this blend of 58% Grenache Blanc from Happy Canyon and 42% Viognier from San Luis Obispo County. Ripened stonefruit flavors are cut with a sizzle of acidity and warmth of sea salt and candied Meyer lemon on the palate.', N'The River', 89, 24, N'California', N'Central Coast', N'Central Coast', N'Matt Kettmann', N'@mattkettmann', N'Barton 2014 The River White (Central Coast)', N'Rhane-style White Blend', N'Barton')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (2917, N'US', N'This is a fairly light, bright Pinot Noir with the marks of a ripe year and time spent in oak. It is crafted under the guidelines of a certified sustainable grape growing program. Medium-bodied and juicy, it''s fairly priced and ready to enjoy now.', N'Appellation Series', 86, 29, N'California', N'Sonoma Coast', N'Sonoma', N'Virginie Boone', N'@vboone', N'Benziger 2012 Appellation Series Pinot Noir (Sonoma Coast)', N'Pinot Noir', N'Benziger')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (74394, N'France', N'Not many Grand Cru wines are made into a Sec style of Champagne. This wine is more soft than sweet, with plenty of acidity as well as a touch of honey. Soft and round at the end, the wine is balanced and ready to drink.', N'Tendresse Grand Cru Sec', 88, 55, N'Champagne', N'Champagne', N'', N'Roger Voss', N'@vossroger', N'Jean Milan NV Tendresse Grand Cru Sec (Champagne)', N'Champagne Blend', N'Jean Milan')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (20381, N'France', N'The sand and granite soil of the Brand vineyard gives an intensely structured wine that''s tight and steely. It''s rich with apricot and pear flavors made crisp with refreshing acidity. Drink from 2015.', N'Brand Grand Cru', 93, 27, N'Alsace', N'Alsace', N'', N'Roger Voss', N'@vossroger', N'Domaine Charles Baur 2010 Brand Grand Cru Riesling (Alsace)', N'Riesling', N'Domaine Charles Baur')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (11149, N'France', N'This is a young, fruity wine with bright acidity and red berry fruit that comes across as lean. Its structure and tannic core suggests it needs to age. Drink from 2019.', N'Grande Cuvae', 89, 20, N'Burgundy', N'Bourgogne Hautes Cates de Nuits', N'', N'Roger Voss', N'@vossroger', N'Nuiton-Beaunoy 2015 Grande Cuvae (Bourgogne Hautes Cates de Nuits)', N'Pinot Noir', N'Nuiton-Beaunoy')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (19125, N'US', N'Firmly tannic and rather mouth-numbing even at five years of age. Enters with a hard edge and finishes tough and gritty. Will it age? There are some black cherry flavors inside, but it''s a gamble.', N'La Joie', 85, 100, N'California', N'Sonoma County', N'Sonoma', N'', N'', N'Verita 1998 La Joie Red (Sonoma County)', N'Red Blend', N'Verita')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (104907, N'US', N'With 8.1% residual sugar, this is a sweet wine. Honey flavors dominate, with underlying notes of apricots, tangerines and golden mangoes. It could be more concentrated and intense, but the sweetness is attractive. Drink now.', N'Late Harvest Sweet', 87, 35, N'California', N'Anderson Valley', N'', N'', N'', N'Navarro 2009 Late Harvest Sweet Gewurztraminer (Anderson Valley)', N'Gewurztraminer', N'Navarro')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (18434, N'Austria', N'This is an intense expression of steely Riesling, with a complex structure and excellent aging potential. It is full of citrus, pear and crisp pineapple flavors that are laced with concentrated acidity. Age for at least five years. Screwcap.', N'Moosburgerin Reserve', 91, 41, N'Kremstal', N'', N'', N'Roger Voss', N'@vossroger', N'Buchegger 2010 Moosburgerin Reserve Riesling (Kremstal)', N'Riesling', N'Buchegger')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (30988, N'Italy', N'It''s hard not to be a big fan of Giacomo Vico''s beautiful Chardonnay. The wine marries the cool-climate characteristics of the Langhe (Piedmont) with a round, opulent and rich winemaking style. You''ll recognize loads of yellow fruit and rose with a playful touch of sweet vanilla.', N'', 88, 22, N'Piedmont', N'Langhe', N'', N'', N'', N'Giacomo Vico 2010 Chardonnay (Langhe)', N'Chardonnay', N'Giacomo Vico')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (10401, N'Spain', N'Roasted and rubbery, this features potent leather and compost aromas that settle with airing. Angular, aggressive and full of power and lemony oak, it also has raw wood and heavily toasted black-fruit flavors. Long, peppery and choppy, it''s powerful and stomping. Best to hold this for 3-5 years before drinking, when it should emerge as a better, more approachable wine.', N'Expresiun', 91, 70, N'Northern Spain', N'Ribera del Duero', N'', N'Michael Schachner', N'@wineschach', N'Alidis 2009 Expresiun (Ribera del Duero)', N'Tempranillo', N'Alidis')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (86405, N'Germany', N'Whiffs of bamboo leaf, lime zest and green herb invite and invigorate on this light-bodied, off-dry Riesling. The palate is juicy and concentrated, an easy going yet tangy mix of tangerine, lemon and salty minerality that lingers long through the finish. Proceeds benefit Nashville''s homeless people and pets.', N'Rockin Riesling The FOH Nashville Project', 90, 16, N'Mosel', N'', N'', N'Anna Lee C. Iijima', N'', N'Von Schleinitz 2015 Rockin Riesling The FOH Nashville Project Riesling (Mosel)', N'Riesling', N'Von Schleinitz')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (34545, N'Italy', N'Castello Banfi''s delicious Cum Laude is a super Tuscan blend of Cabernet Sauvignon, Merlot, Sangiovese and Syrah that opens with rich aromas of black fruit and chocolate fudge. The 30% Cabernet Sauvignon component adds background notes of exotic spice, moist tobacco and firm tannins.', N'Cum Laude', 92, 37, N'Tuscany', N'Toscana', N'', N'', N'', N'Castello Banfi 2006 Cum Laude Red (Toscana)', N'Red Blend', N'Castello Banfi')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (60026, N'US', N'Austin Hope''s latest releases are all about power and ripeness, and this blend of 35% Grenache, 35% Mourvadre and 30% Syrah achieves balance and elegance amidst that strength. Cuban coffee, fig jam, dried blueberry and chocolate aromas lead into a pillowy-soft palate that''s layered with espresso, cocoa, roasted fig and plum jam flavors. Steady acidity and finely chiseled tannins frame it all.', N'Avery #3 The Magic Sun', 95, 75, N'California', N'Templeton Gap District', N'Central Coast', N'Matt Kettmann', N'@mattkettmann', N'Austin Hope 2014 Avery #3 The Magic Sun G-S-M (Templeton Gap District)', N'G-S-M', N'Austin Hope')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (1557, N'US', N'A stupendous Pinot Noir, showing how beautifully this vineyard performs in the remote Sonoma Coast above Fort Ross. Williams Selyem''s last few vintages of Precious Mountain have been extraordinary, but this 2009 tops them all. The wine is as light as a feather in the mouth, modest in alcohol and delicately feminine, like pure satin. However, few Pinot Noirs in the world achieve this level of concentration. Wild raspberries and cherries, cola, sleek minerals, dusty baking spices and smoky oak combine for flavors that are utterly delicious. After all that, it possesses an indefinable attribute of fascination. Will age well for a long time, if you can keep your hands off it. Now-2021.', N'Precious Mountain Vineyard', 99, 94, N'California', N'Sonoma Coast', N'Sonoma', N'', N'', N'Williams Selyem 2009 Precious Mountain Vineyard Pinot Noir (Sonoma Coast)', N'Pinot Noir', N'Williams Selyem')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (69447, N'France', N'The wine is initially soft and then begins to show a more steely, mineral character. That gives structure as well as citrus and crisp apple skin flavors. Very tight at this stage, it needs to develop, so give it until 2015.', N'Lieu-dit Les Epinats', 87, NULL, N'Loire Valley', N'Saumur', N'', N'Roger Voss', N'@vossroger', N'Cave de Saumur 2013 Lieu-dit Les Epinats (Saumur)', N'Chenin Blanc', N'Cave de Saumur')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (62795, N'Austria', N'Ripe pear and yellow plum vie for prominence on the nose, while the palate is full of savory, peppery kitchen herbs like chervil, lovage and dried sage. The midpalate phenolic texture destines this for the table where it will shine with subtly spiced dishes. Wonderfully complex and long.', N'', 93, 22, N'Vienna', N'', N'', N'Anne KrebiehlMW', N'@AnneInVino', N'Wieninger 2013 Gruner Veltliner (Vienna)', N'Gruner Veltliner', N'Wieninger')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (110765, N'US', N'There''s a seemingly sweet edge to the lemon, lime and vanilla flavors, which are fortunately balanced with crisp acidity. Fans of richly styled white wines will like this bottling.', N'Vintner''s Reserve', 84, 13, N'California', N'California', N'California Other', N'', N'', N'Kendall-Jackson 2011 Vintner''s Reserve Sauvignon Blanc (California)', N'Sauvignon Blanc', N'Kendall-Jackson')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (120771, N'France', N'The master of Savigny-las-Beaune, Bize has produced a powerful, expressive wine from this small single vineyard. It has serious structure, although the sumptuous black-fruit flavors are already showing. Concentrated, rich and fruity, this will age for at least five years.', N'Aux Grands Liards', 92, 46, N'Burgundy', N'Savigny-las-Beaune', N'', N'Roger Voss', N'@vossroger', N'Simon Bize 2010 Aux Grands Liards (Savigny-las-Beaune)', N'Pinot Noir', N'Simon Bize')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (64471, N'US', N'A strong hazelnut aroma meets poached pear and cotton candy on the nose of this bottling, giving a rich yet tightly woven impression. The palate is oily in texture, with walnut, dried apricot and browned apple flavors.', N'', 88, 30, N'California', N'Santa Cruz Mountains', N'Central Coast', N'Matt Kettmann', N'@mattkettmann', N'Portola Vineyards 2014 Chardonnay (Santa Cruz Mountains)', N'Chardonnay', N'Portola Vineyards')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (93506, N'US', N'Palazzio is Testarossa''s blend of various vineyards. It showcases a regional Central Coast personality, and a fine one at that. The ''06 has elements of ripe cherries, raspberries and root beer, enriched with smoky oak, and appeals for its silky, crisp mouthfeel. Best now and for a year or two.', N'Palazzio', 88, 37, N'California', N'Central Coast', N'Central Coast', N'', N'', N'Testarossa 2006 Palazzio Pinot Noir (Central Coast)', N'Pinot Noir', N'Testarossa')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (67751, N'Spain', N'Minerally lime and peach-pit aromas set up a crisp, stony, elegant palate with lees-based flavors of vanilla that are softly matched by melon and papaya. Fresh and not too demanding, it''s made from 70% Garnatxa Blanca and 30% Macabeo (Viura).', N'Blanc', 88, 20, N'Catalonia', N'Terra Alta', N'', N'Michael Schachner', N'@wineschach', N'Jaspi 2012 Blanc White (Terra Alta)', N'White Blend', N'Jaspi')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (58990, N'Portugal', N'The wine has the correct texture and attractive perfumes for a delicate Riesling. The crisp apple and tight mineral flavors are light and floating. It''s a surprising wine for the Lisbon region, but it works so well.', N'', 88, 17, N'Lisboa', N'', N'', N'Roger Voss', N'@vossroger', N'Quinta de Sant''Ana 2013 Riesling (Lisboa)', N'Riesling', N'Quinta de Sant''Ana')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (69042, N'Italy', N'A spicy, creamy wine that manages to give freshness and intense varietal character at the same time. The overall effect is of lightness and elegance as well as spiciness and richness.', N'Kolbenhof', 89, 26, N'Northeastern Italy', N'Alto Adige', N'', N'Roger Voss', N'@vossroger', N'J. Hofstatter 2002 Kolbenhof Gewurztraminer (Alto Adige)', N'Gewurztraminer', N'J. Hofstatter')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (76789, N'France', N'This is a plump, medium-bodied rosa at a reasonable price. Pomelo or grapefruit notes combine with stone fruit, then finish stony-dry and tart.', N'Prestige', 87, 13, N'Rhane Valley', N'Cates du Rhane', N'', N'Joe Czerwinski', N'@JoeCz', N'La Chasse 2016 Prestige Rosa (Cates du Rhane)', N'Rosa', N'La Chasse')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (14744, N'Portugal', N'This is a southern and warmer take on Alvarinho than is found in northern Portugal. It brings out the ripe perfumed character of the grape. Apricot and golden plums show both the fruit and the generous texture. Drink this wine starting from late 2017.', N'Grand''Arte', 90, 13, N'Lisboa', N'', N'', N'Roger Voss', N'@vossroger', N'DFJ Vinhos 2016 Grand''Arte Alvarinho (Lisboa)', N'Alvarinho', N'DFJ Vinhos')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (129610, N'Italy', N'La Fagiana is a bright, ruby-colored wine with aromas of forest fruit and bramble, with white almond and spice at the back. It''s an easy, no-fuss expression with a clean, tart close.', N'La Fagiana', 84, NULL, N'Tuscany', N'Toscana', N'', N'', N'', N'Fattoria di San Quintino 2008 La Fagiana Red (Toscana)', N'Red Blend', N'Fattoria di San Quintino')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (96808, N'Spain', N'Right away you know this Syrah-Petit Verdot is a powerful wine. The bouquet is pointed and blasts away with cherry, berry, spice and oak aromas. It''s thick, pushy and full-bodied, with minty, toasty oak flavors running side by side with blackberry. On the finish, it''s more charred and toasty, with peppery spice and some heat. Drink now-2015.', N'', 90, 35, N'Central Spain', N'Vino de la Tierra de Castilla', N'', N'Michael Schachner', N'@wineschach', N'Finca Constancia 2010 Syrah-Petit Verdot (Vino de la Tierra de Castilla)', N'Syrah-Petit Verdot', N'Finca Constancia')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (120382, N'France', N'A fruity wine, full of grapefruit, lime and melon flavors, cut with passion fruit acidity. The wine has a light texture with a zesty edge, clean and totally ready to drink. Screwcap.', N'', 86, 12, N'Loire Valley', N'Touraine', N'', N'Roger Voss', N'@vossroger', N'Villebois 2010 Sauvignon Blanc (Touraine)', N'Sauvignon Blanc', N'Villebois')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (60731, N'Argentina', N'Cherry and plum aromas are aggressive. This energetic Malbec is beyond snappy and juicy, while salty plum and currant flavors are racy and edgy. A briny aftertaste and peppery spice flavors dominate a tough finish.', N'Leo', 84, 17, N'Mendoza Province', N'Mendoza', N'', N'Michael Schachner', N'@wineschach', N'Valentin Bianchi 2013 Leo Malbec (Mendoza)', N'Malbec', N'Valentin Bianchi')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (40392, N'US', N'Aromas like white pepper and dried herbs lead to ripe, direct fruit flavors and a feeling of power from the very full body.', N'Old Vine', 87, 15, N'California', N'Lodi', N'Central Valley', N'Jim Gordon', N'@gordone_cellars', N'Rail2Rail 2014 Old Vine Zinfandel (Lodi)', N'Zinfandel', N'Rail2Rail')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (93338, N'US', N'A light yet concentrated Pinot Noir, this has a cherry flavor and a spicy texture. Give it some air to allow the better side of its earthy aromas time to unravel.', N'Unfiltered', 87, 34, N'California', N'Anderson Valley', N'', N'Virginie Boone', N'@vboone', N'Philo Ridge 2009 Unfiltered Pinot Noir (Anderson Valley)', N'Pinot Noir', N'Philo Ridge')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (83505, N'Australia', N'A pretty, relatively lightweight Pinot Noir, this offering from Western Australia starts off with hints of coffee and sour cherries, then develops more herbal notes and brown sugar with air. Flavors of cola, tart cherries and root vegetables finish a bit short.', N'', 86, 36, N'Western Australia', N'Pemberton', N'', N'Joe Czerwinski', N'@JoeCz', N'Salitage 2005 Pinot Noir (Pemberton)', N'Pinot Noir', N'Salitage')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (95710, N'France', N'Full of mango and starfruit flavors to go with the nuts, spice and ripe texture. The wine, made from organic grapes, has richness as much as sweetness, the acidity an important element. For long-term aging.', N'L''Etoile Moelleux', 89, 22, N'Loire Valley', N'Vouvray', N'', N'Roger Voss', N'@vossroger', N'Domaine du Petit Coteau 2008 L''Etoile Moelleux (Vouvray)', N'Chenin Blanc', N'Domaine du Petit Coteau')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (33240, N'Germany', N'Dancing on the nose and palate, this Pinot Noir rosa fills the glass with whiffs of cherry blossoms and sugar cookies. Tart red-cherry and berry flavors are delicate and spry on the palate, lingering nervously in a luscious mousse of soft, rolling bubbles. Finishes elegantly with a bristle of stony minerals.', N'Sputburgunder Rosa Sekt Brut', 92, 35, N'Rheingau', N'', N'', N'Anna Lee C. Iijima', N'', N'Peter Jakob Kuhn 2012 Sputburgunder Rosa Sekt Brut Pinot Noir (Rheingau)', N'Pinot Noir', N'Peter Jakob Kuhn')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (48471, N'US', N'This wine from the recently approved El Pomar District is tropically perfumed with lychee candy and a hint of passionfruit. Bouncy acidity on the front of the palate leads into red apple fruit and citrus skin bitterness, and wipes up with a zing on the palate.', N'Estate', 88, 25, N'California', N'Paso Robles', N'Central Coast', N'Matt Kettmann', N'@mattkettmann', N'Pomar Junction 2013 Estate Viognier (Paso Robles)', N'Viognier', N'Pomar Junction')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (127051, N'France', N'Bright red fruit highlights this soft wine. Acidity and hint of stalky tannins give its red berry flavors a boost. It''s easygoing and ready to drink.', N'', 85, 10, N'France Other', N'Vin de France', N'', N'Roger Voss', N'@vossroger', N'Fat Bastard 2016 Malbec (Vin de France)', N'Malbec', N'Fat Bastard')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (90489, N'US', N'This blend of 58% Petite Sirah and 42% Zinfandel provides a good example of a winery going over the top and succeeding. Aromas recall blackberry-laced tea, dried rose petals and Luxardo cherries. Cassis provides the centerpoint of the flavor profile, with a backbone of ample tannins and touch of tar.', N'The Maneater Derby Vineyard', 93, 30, N'California', N'Paso Robles', N'Central Coast', N'Matt Kettmann', N'@mattkettmann', N'Derby 2011 The Maneater Derby Vineyard Red (Paso Robles)', N'Red Blend', N'Derby')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (55320, N'US', N'A little one-dimensional, but offers enough cherry, red currant and smoky oak flavors to get by for everyday eating. A good example of the art of blending, with 115,000 cases produced.', N'Coastal Estates', 84, 11, N'California', N'California', N'California Other', N'', N'', N'Beaulieu Vineyard 2011 Coastal Estates Merlot (California)', N'Merlot', N'Beaulieu Vineyard')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (90041, N'Portugal', N'This blend of Touriga Nacional and Castelao has produced an impressive wine that is packed with rich tannins and a dark brooding structure. Intense acidity cuts through the rich, powerful texture to give a fresh aftertaste. It is still young, so drink from 2018.', N'Terras do Anjo Tinto', 93, 30, N'Lisboa', N'', N'', N'Roger Voss', N'@vossroger', N'Quinta do Pinto 2012 Terras do Anjo Tinto Red (Lisboa)', N'Portuguese Red', N'Quinta do Pinto')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (53575, N'Argentina', N'Citrus blossom and leesy vanilla notes open this balanced aromatic white from Argentina''s north. Leesy tropcial-fruit flavors focus on lychee and lime. The wine is moderately long on a simple but solid finish.', N'Estate', 89, 15, N'Other', N'Salta', N'', N'Michael Schachner', N'@wineschach', N'Coloma 2016 Estate Torrontas (Salta)', N'Torrontas', N'Coloma')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (91714, N'US', N'This inviting Pinot is broadly ripe and fully lush in earthy, spicy layers, dark cherry and plum that plays across the palate. With a long, substantial finish, iot suits pork roasts and bacon-wrapped scallops.', N'', 89, 65, N'California', N'Sonoma Coast', N'Sonoma', N'Virginie Boone', N'@vboone', N'Guarachi Family 2012 Pinot Noir (Sonoma Coast)', N'Pinot Noir', N'Guarachi Family')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (96584, N'Spain', N'It''s mouthfeel smacks hard with acidity, leaving a crisp expression of strawberry, raspberry and herb flavors. It turns warm, lactic and chocolaty on the finish.', N'Veraz', 84, 8, N'Northern Spain', N'Campo de Borja', N'', N'Michael Schachner', N'@wineschach', N'Bodegas Aletta 2010 Veraz Garnacha (Campo de Borja)', N'Garnacha', N'Bodegas Aletta')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (55586, N'France', N'While there is a somewhat meaty edge to this wine, it also has good rich texture. It probably needs time to bring out the full potential of its ripe yellow fruits.', N'En Carementrant', 88, 48, N'Burgundy', N'Pouilly-Fuissa', N'', N'Roger Voss', N'@vossroger', N'Bret Brothers 2008 En Carementrant (Pouilly-Fuissa)', N'Chardonnay', N'Bret Brothers')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (92938, N'Greece', N'Lemon zest, lime and melon aromas lead this elegant white blend. Zesty citrus and lush melon on the palate offers a refined character that is nonetheless fine for everyday enjoyment. The finish is expressive and slightly floral.', N'Ovilos', 87, 38, N'Pangeon', N'', N'', N'Susan Kostrzewa', N'@suskostrzewa', N'Estate Biblia Chora 2011 Ovilos White (Pangeon)', N'White Blend', N'Estate Biblia Chora')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (114997, N'France', N'In hommage to the man who pioneered the use of oak to ferment Sauvignon Blanc, this wood-fermented and matured wine is only produced in the best years. It is rich and just toasty, but equally about the structured mineral texture and ripe citrus. It is a wine to age, so drink from 2018.', N'Etienne Henri', 94, 65, N'Loire Valley', N'Sancerre', N'', N'Roger Voss', N'@vossroger', N'Henri Bourgeois 2013 Etienne Henri (Sancerre)', N'Sauvignon Blanc', N'Henri Bourgeois')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (61149, N'Australia', N'A terrific value if you can find it (alas, only 150 cases were imported), this is full bodied and richly textured, marrying hints of peppery spice with grilled lavender and rosemary that perfectly season the beach cherry and mocha flavors. It''s stout, tannic and mouth coating on the finish, ideal for matching with roasts or steaks. Drink 2018-2025.', N'Terra Barossa', 91, 15, N'South Australia', N'Barossa', N'', N'Joe Czerwinski', N'@JoeCz', N'Thorn Clarke 2013 Terra Barossa Cabernet Sauvignon (Barossa)', N'Cabernet Sauvignon', N'Thorn Clarke')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (116359, N'US', N'Earthy tones of smoke and hazelnuts give way to bright white peach and grapefruit notes on the nose and palate of this fruitful Pinot Gris. Off dry in style, it''s a tad sugary on the midpalate, but finishes fairly dry with a refreshing shower of lemony acidity. Drink now.', N'', 85, 16, N'New York', N'Finger Lakes', N'Finger Lakes', N'Anna Lee C. Iijima', N'', N'Billsboro 2010 Pinot Gris (Finger Lakes)', N'Pinot Gris', N'Billsboro')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (19302, N'Portugal', N'One of the strengths of cool Beira Interior is that it produces powerful wines without the attendant alcohol of warmer climates. That''s apparent with this intense, dark wine. Blending Touriga Nacional and Tinta Roriz, the dense and brooding wine with its rich blackberry fruitiness alongside dry, mineral tannins is a study in concentration and needs to age. Drink from 2018.', N'Quinta do Cardo Grande Escolha', 94, 55, N'Beira Interior', N'', N'', N'Roger Voss', N'@vossroger', N'Companhia das Quintas 2011 Quinta do Cardo Grande Escolha Red (Beira Interior)', N'Portuguese Red', N'Companhia das Quintas')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (13218, N'Brazil', N'This leesy, bready, heavily toasted Brazilian sparkler offers heady vanilla and caramel notes on the nose. A round, plump, soda-like palate is home to toasty, leesy, lightly oxidized apple flavors that finish briny, bready and marginally fresh. Drink now.', N'Brut 130', 86, 20, N'Vale dos Vinhedos', N'', N'', N'Michael Schachner', N'@wineschach', N'Casa Valduga NV Brut 130 (Vale dos Vinhedos)', N'Champagne Blend', N'Casa Valduga')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (127787, N'US', N'Very tart, with a deep, tannic, earthy mineral streak. There''s an iron/earth streak running through all Abacela wines; here it comes across as iron and slightly bitter licorice. This is still very young and green; the score might well improve with more time in the bottle.', N'', 86, 18, N'Oregon', N'Umpqua Valley', N'Southern Oregon', N'Paul Gregutt', N'@paulgwine', N'Abacela 1999 Merlot (Umpqua Valley)', N'Merlot', N'Abacela')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (105296, N'Argentina', N'Creamy and rooty at first, and then smokier and darker as it settles. For young Malbec it displays both a jammy fruit side and an acidic center. So there''s both ripeness and heft but also a piercing sizzle. Perfectly good for parties and less-serious imbibing.', N'', 85, 11, N'Mendoza Province', N'Mendoza', N'', N'Michael Schachner', N'@wineschach', N'Budini 2007 Malbec (Mendoza)', N'Malbec', N'Budini')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (71912, N'France', N'A pure, fresh line runs through this delicate rosa. It shows more white fruits than red, just hinting at red currants, but more of fresh white berries. There is just some hint of sweetness, more from the fruit of 2003 than from any extra dosage.', N'Brut Rosa', 92, 70, N'Champagne', N'Champagne', N'', N'Roger Voss', N'@vossroger', N'Louis Roederer 2003 Brut Rosa (Champagne)', N'Champagne Blend', N'Louis Roederer')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (75608, N'US', N'First bottle corked. Second bottle sound, but rather one dimensional. The fruit is simple green apple and green berry; but there is a distinct earthy undertone that carries into the finish. If new oak barrels were used, they are not evident.', N'Estate', 85, 20, N'Washington', N'Wahluke Slope', N'Columbia Valley', N'Paul Gregutt', N'@paulgwine', N'Gilbert Cellars 2007 Estate Chardonnay (Wahluke Slope)', N'Chardonnay', N'Gilbert Cellars')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (8560, N'US', N'Deep aromas of hibiscus, rose buds, dark red berries and sugar plums are spiced up by cola, crushed pencils and lots of garrigue on this bottling. The palate is clean and crisp, with snappy raspberry, light cranberry and lots more chaparral-like herbs, including wild thyme, bay laurel, lavender and fennel pollen.', N'Stone Corral Vineyard', 93, 48, N'California', N'Edna Valley', N'Central Coast', N'Matt Kettmann', N'@mattkettmann', N'Kynsi 2013 Stone Corral Vineyard Pinot Noir (Edna Valley)', N'Pinot Noir', N'Kynsi')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (46248, N'US', N'Off-dry with a candied orange character, this is indeed a malange, including portions of seven different white wine grapes. It''s an interesting wine, though might prove a bit challenging to match to food. Perhaps a curry?', N'Malange Blanc', 86, 15, N'Washington', N'Columbia Valley (WA)', N'Columbia Valley', N'Paul Gregutt', N'@paulgwine', N'Waterbrook 2008 Malange Blanc White (Columbia Valley (WA))', N'White Blend', N'Waterbrook')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (70406, N'US', N'Bold and ripe in cherry jam flavors. Oak brings buttered toast to the mix. Delicious and savory, this Pinot is solidly in the ripe California style of forward fruit and immediate flash. Drink now and through 2014.', N'Six Sixty Seven', 90, 52, N'California', N'Santa Cruz Mountains', N'Central Coast', N'', N'', N'Heart O'' The Mountain 2008 Six Sixty Seven Pinot Noir (Santa Cruz Mountains)', N'Pinot Noir', N'Heart O'' The Mountain')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (36522, N'Spain', N'Bland, sweet aromas are not persuasive. This feels cloying and sticky due to a lot of sugar and not much acidity. Soapy, sweet flavors finish with bitter notes.', N'', 81, 9, N'Central Spain', N'Vino de la Tierra de Castilla', N'', N'Michael Schachner', N'@wineschach', N'Love 2015 Moscato (Vino de la Tierra de Castilla)', N'Moscato', N'Love')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (52865, N'US', N'La Casita is made entirely from Dijon clone 114. It''s a total -wow- wine, from the very first sip. Rich black cherry, chocolate and caramel flavors wrap tightly together. That firm and full-bodied richness continues through the midpalate. Enjoy this outstanding bottle over the next three or four years.', N'La Casita', 92, 60, N'Oregon', N'Dundee Hills', N'Willamette Valley', N'Paul Gregutt', N'@paulgwine', N'Durant 2014 La Casita Pinot Noir (Dundee Hills)', N'Pinot Noir', N'Durant')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (78138, N'US', N'A mind-bending array of aromas come to play in this bottling by Winemaker Billy Wathen, with savory tones of crushed pepper, teriyaki, fresh but underripe berry fruit, piquant forest underbrush, wet chaparral and raw lamb gaminess. It''s surprisingly light and lithe on the lovely palate, with black peppercorn, thyme, lavender and complex beef-stew notes.', N'Williamson-Dora Vineyard', 94, 46, N'California', N'Santa Ynez Valley', N'Central Coast', N'Matt Kettmann', N'@mattkettmann', N'Foxen 2013 Williamson-Dora Vineyard Syrah (Santa Ynez Valley)', N'Syrah', N'Foxen')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (114873, N'New Zealand', N'Most barrel-fermented Marlborough Sauvignons will set you back close to twice as much, making this a bargain. Awesomely pungent and smoky aromas leap from the glass, followed by complex flavors that range from saline to pink grapefruit and stone fruit. Drink this full-bodied, silky-textured wine over the next year or two.', N'Barrel Fermented', 92, 20, N'Marlborough', N'', N'', N'Joe Czerwinski', N'@JoeCz', N'Jules Taylor 2011 Barrel Fermented Sauvignon Blanc (Marlborough)', N'Sauvignon Blanc', N'Jules Taylor')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (26464, N'US', N'Very, sweet, with molasses, oatmeal cookie, blackberry jam, chocolate, vanilla and spice flavors. Could be more concentrated for the sweetness. The blend is mainly Petite Sirah, with the balance comprised of traditional Port varieties.', N'Noble Companion 10 Year Old Tawny', 88, 55, N'California', N'Napa Valley', N'Napa', N'', N'', N'Prager NV Noble Companion 10 Year Old Tawny Port (Napa Valley)', N'Port', N'Prager')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (127241, N'Chile', N'The punchy nose brings spice notes that are sharp on the inhale. This is tight on the palate, with tartaric acid rising up through a medium-weight body. Black plum, cherry, oak and spice flavors finish dry but hollow.', N'', 87, 20, N'Colchagua Valley', N'', N'', N'Michael Schachner', N'@wineschach', N'Primus 2013 Carmenare (Colchagua Valley)', N'Carmenare', N'Primus')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (98475, N'Italy', N'Ripe, black-skinned fruit, dark spice and chopped herbs abound on this structured red. The big, bold palate offers ripe black cherry, blackberry extract, mocha and licorice while round tannins envelop the palate.', N'', 91, 72, N'Veneto', N'Amarone della Valpolicella Classico', N'', N'Kerin O''Keefe', N'@kerinokeefe', N'Le Salette 2012 Amarone della Valpolicella Classico', N'Red Blend', N'Le Salette')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (93779, N'Austria', N'Pepper and power mark this impressively rich wine. Tropical fruits, mangos and lychees are layered with minerality and acidity. A wine that needs some aging in order to release the full potential of its structure and fruit weight.', N'Ried Schutt Smaragd', 94, 50, N'Wachau', N'', N'', N'Roger Voss', N'@vossroger', N'Emmerich Knoll 2006 Ried Schutt Smaragd Gruner Veltliner (Wachau)', N'Gruner Veltliner', N'Emmerich Knoll')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (126040, N'US', N'Pinot Noir specialist Bryan Babcock explores this aromatic white grape, delivering a lush and creamy expression. Poached pear and orange blossom notes combine with a nutty quality on the nose, while the wine''s creamy consistency meets buoyant acidity on the palate. Lush apple, pear and cashews flavors complete the picture.', N'Simpatico', 92, 40, N'California', N'Sta. Rita Hills', N'Central Coast', N'Matt Kettmann', N'@mattkettmann', N'Babcock 2015 Simpatico Sauvignon Blanc (Sta. Rita Hills)', N'Sauvignon Blanc', N'Babcock')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (35859, N'France', N'91-93 A very complete wine, packed with just the right level of tannins and with the sweet plum fruit pushing through to give richness to the acidity.', N'Barrel sample', 92, NULL, N'Bordeaux', N'Margaux', N'', N'Roger Voss', N'@vossroger', N'Chateau d''Angludet 2010 Barrel sample (Margaux)', N'Bordeaux-style Red Blend', N'Chateau d''Angludet')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (50183, N'France', N'There is a barnyard feel to this wine, from its rustic aromas through the edgy berry fruit to the final flavors of acidity and beetroot. The character gives licorice and spice as well as blackberry fruits.', N'Cuvae BLF', 84, 11, N'Southwest France', N'Fronton', N'', N'Roger Voss', N'@vossroger', N'Chateau Bellevue la Forat 2007 Cuvae BLF Red (Fronton)', N'Red Blend', N'Chateau Bellevue la Forat')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (73907, N'Australia', N'After recently tasting a knockout bottle of the 2005, this was disappointing. Ample cinnamon and mocha notes accent slightly pruny flavors; the tannins are soft, while the acids provide a lemony edge to the finish.', N'The Pict', 88, 135, N'South Australia', N'Barossa Valley', N'', N'Joe Czerwinski', N'@JoeCz', N'Torbreck 2007 The Pict Mataro (Barossa Valley)', N'Mataro', N'Torbreck')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (102345, N'France', N'This isn''t the biggest or ripest Cates du Rhane, but it balances hints of greenness with fresh cherry fruit. The floral notes on the nose are attractive, while the wine finishes firm and crisp.', N'', 88, 13, N'Rhane Valley', N'Cates du Rhane', N'', N'Joe Czerwinski', N'@JoeCz', N'Louis Bernard 2014 Red (Cates du Rhane)', N'Rhane-style Red Blend', N'Louis Bernard')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (71903, N'Argentina', N'Roasted fruit, road tar and barrel notes play a big role on the nose, which is otherwise regular and not particularly individual. The palate offers red-fruit jam, butter and pepper flavors, while the finish has some bite and definitive snap. Plenty good enough to drink but lacking completeness and texture.', N'Perpetuum', 85, 16, N'Mendoza Province', N'Mendoza', N'', N'Michael Schachner', N'@wineschach', N'Gimenez Riili 2006 Perpetuum Malbec (Mendoza)', N'Malbec', N'Gimenez Riili')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (96274, N'Italy', N'Violet, dark-skinned berry and balsamic notes come together in this ripe, round wine. The palate delivers black cherry, tobacco and thyme flavors, bolstered by assertive tannins. Enjoy 2018-2023.', N'', 89, NULL, N'Tuscany', N'Brunello di Montalcino', N'', N'Kerin O''Keefe', N'@kerinokeefe', N'Villa Le Prata 2012 Brunello di Montalcino', N'Sangiovese', N'Villa Le Prata')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (35921, N'US', N'Sourced from two vineyards, including Sangiacomo Amaral Ranch, a cool site near the bay, this is a tremendous offering for the price. The wine is light, bright and brambly in raspberry and cherry kirsch, with a mischievous streak of cola. Pretty and fresh, it finishes in a tease of black tea.', N'', 91, 24, N'California', N'Sonoma Coast', N'Sonoma', N'Virginie Boone', N'@vboone', N'Bench 2013 Pinot Noir (Sonoma Coast)', N'Pinot Noir', N'Bench')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (126543, N'US', N'This wine is a blend of Cabernet Sauvignon (60%) and Merlot. Cocoa, baking chocolate and dark-fruit aromas lead to ripe generous black-fruit flavors, backed by well-integrated tannins. The finish lingers.', N'Longevity', 91, 45, N'Washington', N'Columbia Valley (WA)', N'Columbia Valley', N'Sean P. Sullivan', N'@wawinereport', N'JM Cellars 2013 Longevity Red (Columbia Valley (WA))', N'Bordeaux-style Red Blend', N'JM Cellars')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (39226, N'Italy', N'Alluring aromas of menthol, red berry, rose and herb lift out of the glass. The rounded solid palate offers raspberry, morello cherry, a touch of clove and a hint of cinnamon framed in firm tannins. It''s straightforward by Barolo standards but it''s appealing and already almost accessible. Drink after 2021.', N'Riserva', 89, 30, N'Piedmont', N'Barolo', N'', N'Kerin O''Keefe', N'@kerinokeefe', N'Cantina Terre del Barolo 2011 Riserva (Barolo)', N'Nebbiolo', N'Cantina Terre del Barolo')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (15996, N'France', N'Still very firm, this wine shows the tannic structure of the vintage. Because it''s beginning to mature, it also shows it''s not likely to open up much more. Big and hard to like.', N'', 86, 30, N'Bordeaux', N'Saint-umilion', N'', N'Roger Voss', N'@vossroger', N'Chateau Tour Grand Faurie 2011 Saint-umilion', N'Bordeaux-style Red Blend', N'Chateau Tour Grand Faurie')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (11598, N'US', N'With an orange-pink color, this is really a rosa wine. It''s sweet and sugary, with raspberry and watermelon flavors that are balanced by cleansing acids.', N'Willow Springs White', 83, 6, N'California', N'California', N'California Other', N'', N'', N'CK Mondavi 2012 Willow Springs White Zinfandel (California)', N'Zinfandel', N'CK Mondavi')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (43420, N'France', N'Scented impressions of ripe pear and aloe vera pervade this wine. The palate shows texture and more fruit than you might expect from slender Sylvaner. The finish is brisk, clean and taut.', N'Vieilles Vignes', 89, 13, N'Alsace', N'Alsace', N'', N'Anne KrebiehlMW', N'@AnneInVino', N'Boeckel 2015 Vieilles Vignes Sylvaner (Alsace)', N'Sylvaner', N'Boeckel')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (65831, N'France', N'Sourced from grapes grown in the Cate Chalonnaise, this is a soft, red-fruit-flavored wine, with a ripe, jammy character that makes it almost sweet. It is ready to drink.', N'Vieilles Vignes', 86, 25, N'Burgundy', N'Bourgogne', N'', N'Roger Voss', N'@vossroger', N'Chateau de Santenay 2014 Vieilles Vignes (Bourgogne)', N'Pinot Noir', N'Chateau de Santenay')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (95728, N'Portugal', N'This is a herbal, earthy wine with as many tannins as fruit at this stage. That gives it a dense, dusty texture that seeps into the ripe, sweet plum flavors. With the wood giving an extra push of richness as well as spice, it needs to age. Drink from 2017.', N'D. Fuas Reserva', 89, 7, N'Terras do Dao', N'', N'', N'Roger Voss', N'@vossroger', N'Caves Velhas 2013 D. Fuas Reserva Red (Terras do Dao)', N'Portuguese Red', N'Caves Velhas')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (129701, N'US', N'Coming from the warm 2012 vintage, the notes vary from stone fruit, such as apricot, into tropical with dried pineapple. Aged in a mixture of stainless steel and older French oak barrels, it''s fresh and appealing while also displaying some weight and density, drinking quite dry with a tart finish.', N'Horse Heaven Vineyard', 87, 18, N'Washington', N'Horse Heaven Hills', N'Columbia Valley', N'Sean P. Sullivan', N'@wawinereport', N'Chateau Ste. Michelle 2012 Horse Heaven Vineyard Sauvignon Blanc (Horse Heaven Hills)', N'Sauvignon Blanc', N'Chateau Ste. Michelle')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (40444, N'Italy', N'No doubt, this is a simple and sharp wine from northern Italy but it would make a perfect pairing partner to easy grilled lamb or pork chops. It offers clean aromas of wild berry and almond and the mouthfeel is thin and compact.', N'', 85, NULL, N'Veneto', N'Valpolicella Classico Superiore Ripasso', N'', N'', N'', N'Giuseppe Lonardi 2007 Valpolicella Classico Superiore Ripasso', N'Corvina, Rondinella, Molinara', N'Giuseppe Lonardi')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (110345, N'France', N'The top wine from this estate is a blend of Syrah and Braucol. It is still firm and tannic, rich with perfumed black fruits. Made from the property''s oldest vines and wood aged, it has hints of licorice as well as a toasty edge. The wine needs to be aged, so drink from 2020.', N'Mamoire', 90, 30, N'Southwest France', N'Gaillac', N'', N'Roger Voss', N'@vossroger', N'Chateau Clament Termes 2014 Mamoire Red (Gaillac)', N'Red Blend', N'Chateau Clament Termes')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (110752, N'Macedonia', N'Lavender and ripe black-cherry aromas are enticing on this Pinot Noir. Dry and full bodied, it doesn''t have a lot of concentration, but it''s softly fruity, with hints of soil and autumn leaf.', N'', 84, 15, N'Tikves', N'', N'', N'Anna Lee C. Iijima', N'', N'Macedon 2010 Pinot Noir (Tikves)', N'Pinot Noir', N'Macedon')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (73787, N'Macedonia', N'This garnet-colored Pinot Noir is named after Alexander the Great III The Macedon. It has aromas of cherry and vanilla and bright top notes of fresh red raspberry. Medium bodied, it delivers fresh flavors of cranberry and cherry in the finish.', N'Macedon', 87, 15, N'Tikves', N'', N'', N'Jeff Jenssen', N'@worldwineguys', N'Stobi 2011 Macedon Pinot Noir (Tikves)', N'Pinot Noir', N'Stobi')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (38503, N'Macedonia', N'This 100% Vranec presents the nose with black plum, blackberry, tobacco leaf and saddle leather and the palate with blueberry, dried herbs, tobacco and red plums. The finish is soft and elegant.', N'Veritas', 89, 20, N'Tikves', N'', N'', N'Jeff Jenssen', N'@worldwineguys', N'Stobi 2011 Veritas Vranec (Tikves)', N'Vranec', N'Stobi')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (58531, N'Macedonia', N'This Chardonnay has an appealing nose that''s both fruity and toasty, with complex, lush flavors of Chardonnay fruit, vanilla and toasted wood. A spirited but elegant wine that will pair well with poultry, cheeses or richer fish.', N'', 87, 15, N'Tikves', N'', N'', N'Susan Kostrzewa', N'@suskostrzewa', N'Bovin 2008 Chardonnay (Tikves)', N'Chardonnay', N'Bovin')
GO
INSERT [dbo].[winemag_p2] ([id], [country], [description], [designation], [points], [price], [province], [region_1], [region_2], [taster_name], [taster_twitter_handle], [title], [variety], [winery]) VALUES (51421, N'Macedonia', N'This Macedonian wine made from 100% uilavka has aromas of honeysuckle and peach. Balanced in the mouth, it has flavors of green papaya and tart pineapple.', N'', 88, 15, N'Tikves', N'', N'', N'Jeff Jenssen', N'@worldwineguys', N'Stobi 2014 uilavka (Tikves)', N'uilavka', N'Stobi')
GO