Permanent Crops: Number Of Farms And Areas By Agricultural Size Of Farm (UAA) And Size Of Permanent Crop Area

Eurostat code: ef_popermaa · (2005 - 2013)

@eurostat.ef_popermaa

Table List

2 tables(759.55 KB)

Permanent Crops: Number Of Farms And Areas By Agricultural Size Of Farm (UAA) And Size Of Permanent Crop Area - Raw

Permanent Crops: Number Of Farms And Areas By Agricultural Size Of Farm (UAA) And Size Of Permanent Crop Area - Unpivoted

Permanent Crops: Number Of Farms And Areas By Agricultural Size Of Farm (UAA) And Size Of Permanent Crop Area - Unpivoted

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

384.09 KB
308803 rows
7 columns

freq Freq	indic_ef Indic Ef	agrarea Agrarea	croparea Croparea	geo Geo	time_period Time Period
Annual	ha: Utilised agricultural area	Zero ha	Zero ha	Austria	2005
Annual	ha: Utilised agricultural area	Zero ha	Zero ha	Belgium	2005
Annual	ha: Utilised agricultural area	Zero ha	Zero ha	Bulgaria	2005
Annual	ha: Utilised agricultural area	Zero ha	Zero ha	Switzerland	2005
Annual	ha: Utilised agricultural area	Zero ha	Zero ha	Cyprus	2005
Annual	ha: Utilised agricultural area	Zero ha	Zero ha	Czechia	2005
Annual	ha: Utilised agricultural area	Zero ha	Zero ha	Germany	2005
Annual	ha: Utilised agricultural area	Zero ha	Zero ha	Denmark	2005
Annual	ha: Utilised agricultural area	Zero ha	Zero ha	Estonia	2005
Annual	ha: Utilised agricultural area	Zero ha	Zero ha	Greece	2005


CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_ef" VARCHAR,
  "agrarea" VARCHAR,
  "croparea" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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