Key Variables By Size Of Farm (UAA), Economic Size Of Farm (ESU) And LFA Status

Eurostat code: ef_ov_kvaaesu · (1990 - 2007)

@eurostat.ef_ov_kvaaesu

Table List

2 tables(1.68 MB)

Key Variables By Size Of Farm (UAA), Economic Size Of Farm (ESU) And LFA Status - Raw

Key Variables By Size Of Farm (UAA), Economic Size Of Farm (ESU) And LFA Status - Unpivoted

Key Variables By Size Of Farm (UAA), Economic Size Of Farm (ESU) And LFA Status - Unpivoted

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

821.07 KB
265399 rows
8 columns

freq Freq	esu Esu	terrtypo Terrtypo	agrarea Agrarea	variable Variable	geo Geo	time_period Time Period	value Value
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Zero ha	Utilised agricultural area (ha)	Greece	1990
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Zero ha	Utilised agricultural area (ha)	Spain	1990
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Zero ha	Utilised agricultural area (ha)	Metropolitan France	1990
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Zero ha	Utilised agricultural area (ha)	Italy	1990
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Zero ha	Utilised agricultural area (ha)	Portugal	1990
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Zero ha	hold: No. of holdings	Greece	1990	440
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Zero ha	hold: No. of holdings	Spain	1990	1420
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Zero ha	hold: No. of holdings	Metropolitan France	1990	160
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Zero ha	hold: No. of holdings	Italy	1990	310
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Zero ha	hold: No. of holdings	Portugal	1990	150


CREATE TABLE tidy (
  "freq" VARCHAR,
  "esu" VARCHAR,
  "terrtypo" VARCHAR,
  "agrarea" VARCHAR,
  "variable" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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