Area Under Wine-grape Vine Varieties Broken Down By Vine Variety, Age Of The Vines And Region - Spain
Eurostat code: vit_bs4_es ยท (1999 - 2009)
@eurostat.vit_bs4_es
Eurostat code: vit_bs4_es ยท (1999 - 2009)
@eurostat.vit_bs4_es
This Eurostat dataset contains data on area under wine-grape vine varieties broken down by vine variety, age of the vines and region - spain, as collected and published by the Statistical Office of the European Union.
raw
: Original table as downloaded from Eurostat.tidy
: A cleaned and transformed version of the raw
table, where time period values appear as rows instead of columns (unpivoted format).Last updated: 2012-03-16T23:00:00+0100
CREATE TABLE raw (
"freq" VARCHAR,
"indic_vi" VARCHAR,
"wine_var" VARCHAR,
"age" VARCHAR,
"geo" VARCHAR,
"n_1999" DOUBLE -- 1999,
"n_2009" DOUBLE -- 2009
);
CREATE TABLE tidy (
"freq" VARCHAR,
"indic_vi" VARCHAR,
"wine_var" VARCHAR,
"age" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);
Anyone who has the link will be able to view this.