Total Area By Species (area In Ha)

Eurostat code: orch_total · (2002 - 2017)

@eurostat.orch_total

Table List

2 tables(20.77 KB)

Total Area By Species (area In Ha) - Raw

Total Area By Species (area In Ha) - Unpivoted

Total Area By Species (area In Ha) - Unpivoted

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

9.75 KB
637 rows
8 columns

freq Freq	density Density	unit Unit	age Age	fruitvar Fruitvar	geo Geo	time_period Time Period	value Value
Annual	Total	Hectare	Total	Apricot trees	Austria	2002	469.78
Annual	Total	Hectare	Total	Apricot trees	Greece	2002	4994.2
Annual	Total	Hectare	Total	Apricot trees	Spain	2002	22615.4
Annual	Total	Hectare	Total	Apricot trees	France	2002	14924.2
Annual	Total	Hectare	Total	Apricot trees	Italy	2002	15574.5
Annual	Total	Hectare	Total	Apricot trees	Portugal	2002	490.91
Annual	Total	Hectare	Total	Dessert apple trees	Austria	2002	6952.41
Annual	Total	Hectare	Total	Dessert apple trees	Belgium	2002	8248.89
Annual	Total	Hectare	Total	Dessert apple trees	Germany	2002	28050.1
Annual	Total	Hectare	Total	Dessert apple trees	Denmark	2002	1397.58


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.