Permanent Crops: Number Of Farms And Areas By Size Of Farm (UAA), Size Of Permanent Crop Area And NUTS 2 Region

Eurostat code: ef_lu_pcreg · (1990 - 2007)

@eurostat.ef_lu_pcreg

Table List

2 tables(1.28 MB)

Permanent Crops: Number Of Farms And Areas By Size Of Farm (UAA), Size Of Permanent Crop Area And NUTS 2 Region - Raw

Permanent Crops: Number Of Farms And Areas By Size Of Farm (UAA), Size Of Permanent Crop Area And NUTS 2 Region - Unpivoted

Permanent Crops: Number Of Farms And Areas By Size Of Farm (UAA), Size Of Permanent Crop Area And NUTS 2 Region - Unpivoted

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

612.06 KB
492194 rows
7 columns

freq Freq	croparea Croparea	variable Variable	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Zero ha	Utilised agricultural area	Hectare	Belgium	1990	1311230
Annual	Zero ha	Utilised agricultural area	Hectare	Région de Bruxelles-Capitale/Brussels Hoofdstedelijk Gewest and Vlaams Gewest	1990	571050
Annual	Zero ha	Utilised agricultural area	Hectare	Région wallonne	1990	740190
Annual	Zero ha	Utilised agricultural area	Hectare	Denmark	1990	2737820
Annual	Zero ha	Utilised agricultural area	Hectare	Greece	1990	1383450
Annual	Zero ha	Utilised agricultural area	Hectare	Anatoliki Makedonia, Thraki (NUTS 2010)	1990	290420
Annual	Zero ha	Utilised agricultural area	Hectare	Kentriki Makedonia (NUTS 2010)	1990	380800
Annual	Zero ha	Utilised agricultural area	Hectare	Dytiki Makedonia (NUTS 2010)	1990	146930
Annual	Zero ha	Utilised agricultural area	Hectare	Thessalia (NUTS 2010)	1990	280910
Annual	Zero ha	Utilised agricultural area	Hectare	Ipeiros (NUTS 2010)	1990	51040


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

Share link

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