Baselight

Agricultural Holdings And Utilised Agricultural Area By Training, Age And Sex Of Farm Managers

Eurostat code: ef_mp_training ยท (2010 - 2020)

@eurostat.ef_mp_training

Agricultural Holdings And Utilised Agricultural Area By Training, Age And Sex Of Farm Managers - Unpivoted
@eurostat.ef_mp_training.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.

  • 17.14 MB
  • 7876565 rows
  • 10 columns
freq

Freq

uaarea

Uaarea

so_eur

So Eur

sex

Sex

age

Age

training

Training

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualZero haZero eurosFemalesTotalBasic trainingHectareBelgium2010
AnnualZero haZero eurosFemalesTotalBasic trainingHectareProv. Limburg (BE)2010
AnnualZero haZero eurosFemalesTotalBasic trainingHectareProv. Hainaut2010
AnnualZero haZero eurosFemalesTotalBasic trainingHectareEuropean Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)2010
AnnualZero haZero eurosFemalesTotalBasic trainingHectareEuropean Union - 27 countries (2007-2013)2010
AnnualZero haZero eurosFemalesTotalBasic trainingHectareEuropean Union - 27 countries (from 2020)2010
AnnualZero haZero eurosFemalesTotalBasic trainingHectareEuropean Union - 28 countries (2013-2020)2010
AnnualZero haZero eurosFemalesTotalBasic trainingHectareFrance2010
AnnualZero haZero eurosFemalesTotalBasic trainingHectarePays de la Loire (NUTS 2013)2010
AnnualZero haZero eurosFemalesTotalBasic trainingHectareBretagne (NUTS 2013)2010

CREATE TABLE tidy (
  "freq" VARCHAR,
  "uaarea" VARCHAR,
  "so_eur" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "training" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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