Baselight

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

Eurostat code: ef_mp_voctraining · (2010 - 2020)

@eurostat.ef_mp_voctraining

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

  • 7.41 MB
  • 3518704 rows
  • 10 columns
freq

Freq

so_eur

So Eur

uaarea

Uaarea

age

Age

sex

Sex

frequenc

Frequenc

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualZero eurosZero haTotalFemalesIn the last 12 monthsHectareBelgium2010
AnnualZero eurosZero haTotalFemalesIn the last 12 monthsHectareProv. West-Vlaanderen2010
AnnualZero eurosZero haTotalFemalesIn the last 12 monthsHectareEuropean Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)2010
AnnualZero eurosZero haTotalFemalesIn the last 12 monthsHectareEuropean Union - 27 countries (2007-2013)2010
AnnualZero eurosZero haTotalFemalesIn the last 12 monthsHectareEuropean Union - 27 countries (from 2020)2010
AnnualZero eurosZero haTotalFemalesIn the last 12 monthsHectareEuropean Union - 28 countries (2013-2020)2010
AnnualZero eurosZero haTotalFemalesIn the last 12 monthsHectareFinland2010
AnnualZero eurosZero haTotalFemalesIn the last 12 monthsHectareLänsi-Suomi2010
AnnualZero eurosZero haTotalFemalesIn the last 12 monthsHectareFrance2010
AnnualZero eurosZero haTotalFemalesIn the last 12 monthsHectareHaute-Normandie (NUTS 2013)2010

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

Share link

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