Wine Data

With more than 6,000 wineries in the USA alone (each producing several different wines each year) and more than 14,000 wine grape varietals worldwide, "wine geek" has become an endearing term for wine data aficionados.  People are asking questions about the wine they drink and the wine they want to buy.  There is a plethora of facts to navigate from vineyards and vines to vintages and wineries to bottles and what's on the label to wine styles and food pairings. 

The Secret Wine Shop wants to make it easy for consumers to learn more about a certain wine, figure out what to pair with what, or plan a fun wine tasting trip anywhere in the world.


APPLICATIONS

RAW WINE DATA

Region:  World

 #1 Wine Grape Varieties
http://www.factual.com/t/r3njZN
  Source:  http://ngr.ucdavis.edu/http://bioweb.ensam.inra.fr/collections_vigne/Variete.php?page=1&recherche=&recherche=&recherche=, http://www.eu-vitis.de/index.php
Rows: 14,004
Data Notes:  A list of all known wine grape varieties, vitis vinifera, according to 3 governmental agricultural sites USDA, INRA (French version of USDA), and The European Vitis Database Genetic Resources of Grapes (last updated March 2010).  

 #2 Wine Competition Winners
http://www.factual.com/t/ay7E4d
  Source:  
Rows: 14,652
Data Notes: 
 Winning wines from a growing list of annual wine competitions (San Francisco Chronicle, San Francisco International, Sonoma Harvest Fair, (2011 best values), mash-up SFChron+SonomaHarvest,  Los Angeles International, Finger Lakes International, Lone Star International).  2008-2011 Competition results.

#3E-Bacchus Wine Regions (EU wine designations of origin as protected by the EC)
http://www.factual.com/t/odNBhn
 Source:  http://ec.europa.eu/agriculture/markets/wine/e-bacchus/
Rows: 1,911
Data Notes: 
 E-Bacchus" is a database which lists non-EU countries' geographical indications and names of origin protected in accordance with the bilateral agreements on trade in wine concluded between the EU and the non-EU countries concerned, and consists of the Register of designations of origin and geographical indications protected in accordance with Council Regulation 1234/2007.  Date of the last modification – Member States: Tuesday, 15 June 2010 11:10:59.  Date of the last modification - Third Countries: Tuesday, 26 January 2010 13:25:14.  Date of the last synchronisation of the database: Saturday, 19 June 2010 22:01:12

#4E-Bacchus Glossary (Traditional Terms used by the EC)
http://www.factual.com/t/CyUlwb/E_Bacchus_Glossary
 Source:  http://ec.europa.eu/agriculture/markets/wine/e-bacchus/
Rows: 359
Data Notes: 
 E-Bacchus" is a database which lists non-EU countries' geographical indications and names of origin protected in accordance with the bilateral agreements on trade in wine concluded between the EU and the non-EU countries concerned, and consists of the Register of designations of origin and geographical indications protected in accordance with Council Regulation 1234/2007.  Date of the last modification – Member States: Tuesday, 15 June 2010 11:10:59.  Date of the last modification - Third Countries: Tuesday, 26 January 2010 13:25:14.  Date of the last synchronisation of the database: Saturday, 19 June 2010 22:01:12

 #5 Wikipedia Worldwide Vineyards & Wineries
http://www.factual.com/t/eNTjYI
  Source:  http://en.wikipedia.org/wiki/List_of_vineyards_and_wineries
Rows: 1,582
Data Notes:  Wikipedia, mostly Australia. "The following is a non-exhaustive list of vineyards and wineries from around the world."  Last updated October 2009.

Region:  USA, Canada & the Americas

 #1 USA Grape Crush Prices
http://www.factual.com/t/S0Tsfw/Latest_USA_Grapes_Crush_Price_Changes#vis_314
  Source:  http://www.nass.usda.gov/Statistics_by_State/California
Rows: 244
Data Notes:  USA Crush statistics for top 6 grape-producing states (CA, WA, OR, PA, VA, NY).  Final report only.  Final crush report is updated for CA around January following the preceding harvest.  Other states follow.  Still waiting for 2009 harvest results from PA, VA, NY, TX.  If possible to get TX results, will add them to the list of states in this table.

 #2 CA Wineries with Addresses
http://www.factual.com/ts/zQvt6K
  Source:  http://www.abc.ca.gov/datport/DataExport.html
Rows: 4,377
Data Notes:
 Used Type 2 license which includes all wineries & growers.  Active listings only as of June 2010.

 #3OR Wineries with Addresses
http://www.factual.com/t/p7y21H
 Source:  google.com
Rows: 643
Data Notes: 
 Google directories Travel > Oregon > Type Wineries.  Updated June 2010.

 #4 USA Wineries with Addresses
http://www.factual.com/t/YeXhi9
  Source:  ttb.gov
Rows: 6,302
Data Notes:  All wineries in the USA including wineries without their own vineyards or crushpads.  Active listings only as of June 2010.

 #5 Vitacultural areas in the US
http://www.factual.com/t/5j61kT
  Source:  http://www.ttb.gov/appellation/us_by_ava.pdf
Rows: 289
Data Notes:  The latest AVA to be added was Calistoga.  Pending division of Paso Robles into multiple AVAs.  Last updated January 2010. A good source for early announcements, even before the government website is updated, is winebusiness.com

Region:  Europe & the Middle East

 #1 Vitacultural areas in France
http://www.factual.com/t/Ho0MJi
  Source:  www.inau.gouv.fr
Rows: 619
Data Notes:  La loi de 1905 Opinion des Viticulteurs. - Exposé d'un Programme qui a, pendant 30 ans, attendu sa réalisation. Updates very rarely, although there is current discussion of adjusting the Champagne AOC.  winebusiness.com will probably announce this earlier than the government website.

 #2 Vitacultural areas in Italy
http://www.factual.com/t/6pwlb6
  Source:  EU law, http://eur-lex.europa.eu/en/index.htm
Rows: 746
Data Notes: 
 Outer join of the above EU Italian wine region definitions and US import labels (ttb.gov).  Some entries may only appear in one or the other source.

 #3 Vitacultural areas in Spain
http://www.factual.com/t/wyEkwV
  Source:  http://www.ttb.gov/itd/pdf/ITD%20-%20Listing%20from%20Agreement-SPAIN.pdf
Rows: 142
Data Notes:  Viticultural areas in Spain as accepted on US wine import labels, according to US-EC agreement on Trade in Wine.

Region:  Asia & Oceana

 #1 Viticultural areas in Japan
http://www.factual.com/t/IAQryz
  Source:  http://www.ttb.gov/appellation/japan.pdf
Rows: 10
Data Notes:  Vitacultural areas in Japan as accepted on US wine import labels

 #2 Vitacultural areas in China
http://www.factual.com/t/kS9FLC
  Source:  http://www.ttb.gov/appellation/china.pdf
Rows: 9
Data Notes: 
 Vitacultural areas in China as accepted on US wine import labels

 #3 Vitacultural areas in Lebanon
http://www.factual.com/t/fI9v96
  Source:  http://www.ttb.gov/appellation/lebanon.pdf
Rows: 7
Data Notes:  Viticultural areas in Lebanon as accepted on US wine import labels.
Comments