Other Gainful Activities Directly Related To The Holding: Number Of Farms, Agricultural Area, Standard Output (SO) And Livestock (LSU) By Age And Sex Of Holder

Eurostat code: ef_ogadsexage · (2005 - 2013)

@eurostat.ef_ogadsexage

Table List

2 tables(946.98 KB)

Other Gainful Activities Directly Related To The Holding: Number Of Farms, Agricultural Area, Standard Output (SO) And Livestock (LSU) By Age And Sex Of Holder - Raw

Other Gainful Activities Directly Related To The Holding: Number Of Farms, Agricultural Area, Standard Output (SO) And Livestock (LSU) By Age And Sex Of Holder - Unpivoted

Other Gainful Activities Directly Related To The Holding: Number Of Farms, Agricultural Area, Standard Output (SO) And Livestock (LSU) By Age And Sex Of Holder - Unpivoted

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

465.96 KB
128195 rows
7 columns

freq Freq	age Age	sex Sex	indic_ef Indic Ef	geo Geo	time_period Time Period	value Value
Annual	Not applicable	Not applicable	ha: Utilised agricultural area	Austria	2005	495590
Annual	Not applicable	Not applicable	ha: Utilised agricultural area	Belgium	2005	117690
Annual	Not applicable	Not applicable	ha: Utilised agricultural area	Bulgaria	2005	1455520
Annual	Not applicable	Not applicable	ha: Utilised agricultural area	Cyprus	2005	10510
Annual	Not applicable	Not applicable	ha: Utilised agricultural area	Czechia	2005	2516340
Annual	Not applicable	Not applicable	ha: Utilised agricultural area	Germany	2005	2993290
Annual	Not applicable	Not applicable	ha: Utilised agricultural area	Denmark	2005	42300
Annual	Not applicable	Not applicable	ha: Utilised agricultural area	Estonia	2005	367390
Annual	Not applicable	Not applicable	ha: Utilised agricultural area	Greece	2005	16040
Annual	Not applicable	Not applicable	ha: Utilised agricultural area	Spain	2005	7740880


CREATE TABLE tidy (
  "freq" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "indic_ef" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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