Holdings, Cultivated Area Under Vines (CAV) And Utilised Agricultural Area (AA) By AV/AA Ratio, Size Class And Region

Eurostat code: vit_bs2 · (1999 - 2009)

@eurostat.vit_bs2

Table List

2 tables(3.02 MB)

Holdings, Cultivated Area Under Vines (CAV) And Utilised Agricultural Area (AA) By AV/AA Ratio, Size Class And Region - Raw

Holdings, Cultivated Area Under Vines (CAV) And Utilised Agricultural Area (AA) By AV/AA Ratio, Size Class And Region - Unpivoted

Holdings, Cultivated Area Under Vines (CAV) And Utilised Agricultural Area (AA) By AV/AA Ratio, Size Class And Region - Unpivoted

@eurostat.vit_bs2.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

1.48 MB
573412 rows
8 columns

freq Freq	prodtyp Prodtyp	vit_vtv Vit Vtv	indic_vi Indic Vi	vtarcls Vtarcls	geo Geo	time_period Time Period	value Value
Annual	Others (other types of production, mixed production, etc.)	Holdings with > 0 <= 10 % of agricultural area in use under vines	Agricultural area in use of vineyard holdings (ha)	0.10 to < 0.20 ha of area under vines	Greece	1999	17403.85
Annual	Others (other types of production, mixed production, etc.)	Holdings with > 0 <= 10 % of agricultural area in use under vines	Agricultural area in use of vineyard holdings (ha)	0.10 to < 0.20 ha of area under vines	Anatoliki Makedonia, Thraki (NUTS 2010)	1999	6131.97
Annual	Others (other types of production, mixed production, etc.)	Holdings with > 0 <= 10 % of agricultural area in use under vines	Agricultural area in use of vineyard holdings (ha)	0.10 to < 0.20 ha of area under vines	Dytiki Makedonia (NUTS 2010)	1999	2696.49
Annual	Others (other types of production, mixed production, etc.)	Holdings with > 0 <= 10 % of agricultural area in use under vines	Agricultural area in use of vineyard holdings (ha)	0.10 to < 0.20 ha of area under vines	Thessalia (NUTS 2010)	1999	3326.06
Annual	Others (other types of production, mixed production, etc.)	Holdings with > 0 <= 10 % of agricultural area in use under vines	Agricultural area in use of vineyard holdings (ha)	0.10 to < 0.20 ha of area under vines	Ipeiros (NUTS 2010)	1999
Annual	Others (other types of production, mixed production, etc.)	Holdings with > 0 <= 10 % of agricultural area in use under vines	Agricultural area in use of vineyard holdings (ha)	0.10 to < 0.20 ha of area under vines	Voreio Aigaio	1999	1054.35
Annual	Others (other types of production, mixed production, etc.)	Holdings with > 0 <= 10 % of agricultural area in use under vines	Agricultural area in use of vineyard holdings (ha)	0.10 to < 0.20 ha of area under vines	Kriti	1999	4194.98
Annual	Others (other types of production, mixed production, etc.)	Holdings with > 0 <= 10 % of agricultural area in use under vines	Agricultural area in use of vineyard holdings (ha)	0.10 to < 0.20 ha of area under vines	Spain	1999	477.91
Annual	Others (other types of production, mixed production, etc.)	Holdings with > 0 <= 10 % of agricultural area in use under vines	Agricultural area in use of vineyard holdings (ha)	0.10 to < 0.20 ha of area under vines	France	1999	213.29
Annual	Others (other types of production, mixed production, etc.)	Holdings with > 0 <= 10 % of agricultural area in use under vines	Agricultural area in use of vineyard holdings (ha)	0.10 to < 0.20 ha of area under vines	Centre (FR) (NUTS 2013)	1999	71.37


CREATE TABLE tidy (
  "freq" VARCHAR,
  "prodtyp" VARCHAR,
  "vit_vtv" VARCHAR,
  "indic_vi" VARCHAR,
  "vtarcls" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.