Permanent Crops: Number Of Farms And Areas By Economic Size Of Farm (SO In Euro) And Size Of Permanent Crop Area

Eurostat code: ef_popermecs · (2005 - 2013)

@eurostat.ef_popermecs

Table List

2 tables(920.58 KB)

Permanent Crops: Number Of Farms And Areas By Economic Size Of Farm (SO In Euro) And Size Of Permanent Crop Area - Raw

Permanent Crops: Number Of Farms And Areas By Economic Size Of Farm (SO In Euro) And Size Of Permanent Crop Area - Unpivoted

Permanent Crops: Number Of Farms And Areas By Economic Size Of Farm (SO In Euro) And Size Of Permanent Crop Area - Unpivoted

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

454.99 KB
363940 rows
7 columns

freq Freq	croparea Croparea	so_eur So Eur	indic_ef Indic Ef	geo Geo	time_period Time Period	value Value
Annual	Zero ha	Zero euros	ha: Utilised agricultural area	Austria	2005	1300
Annual	Zero ha	Zero euros	ha: Utilised agricultural area	Belgium	2005	120
Annual	Zero ha	Zero euros	ha: Utilised agricultural area	Bulgaria	2005	3490
Annual	Zero ha	Zero euros	ha: Utilised agricultural area	Cyprus	2005	450
Annual	Zero ha	Zero euros	ha: Utilised agricultural area	Czechia	2005	650
Annual	Zero ha	Zero euros	ha: Utilised agricultural area	Germany	2005	6230
Annual	Zero ha	Zero euros	ha: Utilised agricultural area	Denmark	2005	2610
Annual	Zero ha	Zero euros	ha: Utilised agricultural area	Estonia	2005	680
Annual	Zero ha	Zero euros	ha: Utilised agricultural area	Greece	2005	100
Annual	Zero ha	Zero euros	ha: Utilised agricultural area	Spain	2005	29000


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

Share link

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