Type Of Tenure: Number Of Farms And Areas By Size Of Farm (UAA) And NUTS 2 Region

Eurostat code: ef_so_mptenure · (1990 - 2007)

@eurostat.ef_so_mptenure

Table List

2 tables(678.89 KB)

Type Of Tenure: Number Of Farms And Areas By Size Of Farm (UAA) And NUTS 2 Region - Raw

Type Of Tenure: Number Of Farms And Areas By Size Of Farm (UAA) And NUTS 2 Region - Unpivoted

Type Of Tenure: Number Of Farms And Areas By Size Of Farm (UAA) And NUTS 2 Region - Unpivoted

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

311.65 KB
111860 rows
7 columns

freq Freq	agrarea Agrarea	unit Unit	variable Variable	geo Geo	time_period Time Period
Annual	Zero ha	Hectare	Utilised agricultural area	Belgium	1990
Annual	Zero ha	Hectare	Utilised agricultural area	Région de Bruxelles-Capitale/Brussels Hoofdstedelijk Gewest and Vlaams Gewest	1990
Annual	Zero ha	Hectare	Utilised agricultural area	Région wallonne	1990
Annual	Zero ha	Hectare	Utilised agricultural area	Denmark	1990
Annual	Zero ha	Hectare	Utilised agricultural area	Greece	1990
Annual	Zero ha	Hectare	Utilised agricultural area	Anatoliki Makedonia, Thraki (NUTS 2010)	1990
Annual	Zero ha	Hectare	Utilised agricultural area	Kentriki Makedonia (NUTS 2010)	1990
Annual	Zero ha	Hectare	Utilised agricultural area	Dytiki Makedonia (NUTS 2010)	1990
Annual	Zero ha	Hectare	Utilised agricultural area	Thessalia (NUTS 2010)	1990
Annual	Zero ha	Hectare	Utilised agricultural area	Ipeiros (NUTS 2010)	1990


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

Share link

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