Land Use: Number Of Farms And Areas By Size Of Farm (UAA) And LFA Status

Eurostat code: ef_ov_lusum · (1990 - 2007)

@eurostat.ef_ov_lusum

Table List

2 tables(1.28 MB)

Land Use: Number Of Farms And Areas By Size Of Farm (UAA) And LFA Status - Raw

Land Use: Number Of Farms And Areas By Size Of Farm (UAA) And LFA Status - Unpivoted

Land Use: Number Of Farms And Areas By Size Of Farm (UAA) And LFA Status - Unpivoted

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

616.03 KB
242540 rows
8 columns

freq Freq	terrtypo Terrtypo	variable Variable	unit Unit	agrarea Agrarea	geo Geo	time_period Time Period	value Value
Annual	Less favoured areas - mountainous	Utilised agricultural area	Hectare	Zero ha	Germany	1990
Annual	Less favoured areas - mountainous	Utilised agricultural area	Hectare	Zero ha	Greece	1990
Annual	Less favoured areas - mountainous	Utilised agricultural area	Hectare	Zero ha	Spain	1990
Annual	Less favoured areas - mountainous	Utilised agricultural area	Hectare	Zero ha	Metropolitan France	1990
Annual	Less favoured areas - mountainous	Utilised agricultural area	Hectare	Zero ha	Italy	1990
Annual	Less favoured areas - mountainous	Utilised agricultural area	Hectare	Zero ha	Portugal	1990
Annual	Less favoured areas - mountainous	Utilised agricultural area	Hectare	From 10 to 19.9 ha	Germany	1990	90510
Annual	Less favoured areas - mountainous	Utilised agricultural area	Hectare	From 10 to 19.9 ha	Greece	1990	235800
Annual	Less favoured areas - mountainous	Utilised agricultural area	Hectare	From 10 to 19.9 ha	Spain	1990	690680
Annual	Less favoured areas - mountainous	Utilised agricultural area	Hectare	From 10 to 19.9 ha	Metropolitan France	1990	366160


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

Share link

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