Peach And Apricot Trees - Area By Density Classes And Group Of Varieties (area In Ha)

Eurostat code: orch_peach2 · (2012 - 2017)

@eurostat.orch_peach2

Table List

2 tables(107.6 KB)

Peach And Apricot Trees - Area By Density Classes And Group Of Varieties (area In Ha) - Raw

Peach And Apricot Trees - Area By Density Classes And Group Of Varieties (area In Ha) - Unpivoted

Peach And Apricot Trees - Area By Density Classes And Group Of Varieties (area In Ha) - Unpivoted

@eurostat.orch_peach2.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.

53.34 KB
8681 rows
8 columns

freq Freq	density Density	unit Unit	age Age	fruitvar Fruitvar	geo Geo	time_period Time Period	value Value
Annual	From 600 to 1 199 trees per hectare	Hectare	Total	Apricot trees	Austria	2012	283.77
Annual	From 600 to 1 199 trees per hectare	Hectare	Total	Apricot trees	Ostösterreich	2012	197.13
Annual	From 600 to 1 199 trees per hectare	Hectare	Total	Apricot trees	Südösterreich	2012	49.64
Annual	From 600 to 1 199 trees per hectare	Hectare	Total	Apricot trees	Westösterreich	2012	37
Annual	From 600 to 1 199 trees per hectare	Hectare	Total	Apricot trees	Bulgaria	2012	145.21
Annual	From 600 to 1 199 trees per hectare	Hectare	Total	Apricot trees	Yugozapadna i Yuzhna tsentralna Bulgaria	2012	71.02
Annual	From 600 to 1 199 trees per hectare	Hectare	Total	Apricot trees	Cyprus	2012	5.02
Annual	From 600 to 1 199 trees per hectare	Hectare	Total	Apricot trees	Czechia	2012	238.62
Annual	From 600 to 1 199 trees per hectare	Hectare	Total	Apricot trees	Spain	2012	3867.77
Annual	From 600 to 1 199 trees per hectare	Hectare	Total	Apricot trees	Noreste	2012	2519.2


CREATE TABLE tidy (
  "freq" VARCHAR,
  "density" VARCHAR,
  "unit" VARCHAR,
  "age" VARCHAR,
  "fruitvar" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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