Baselight

Farm Indicators By Age And Sex Of The Manager, Economic Size Of The Farm, Utilised Agricultural Area And NUTS 2 Region

Eurostat code: ef_m_farmang ยท (2010 - 2020)

@eurostat.ef_m_farmang

Farm Indicators By Age And Sex Of The Manager, Economic Size Of The Farm, Utilised Agricultural Area And NUTS 2 Region - Unpivoted
@eurostat.ef_m_farmang.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.

  • 21.27 MB
  • 6161962 rows
  • 10 columns
freq

Freq

sex

Sex

age

Age

so_eur

So Eur

uaarea

Uaarea

crops

Crops

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFemalesTotalZero eurosZero haUtilised agricultural areaAnnual working unit (AWU)Belgium201020
AnnualFemalesTotalZero eurosZero haUtilised agricultural areaAnnual working unit (AWU)Prov. Antwerpen2010
AnnualFemalesTotalZero eurosZero haUtilised agricultural areaAnnual working unit (AWU)Prov. West-Vlaanderen201010
AnnualFemalesTotalZero eurosZero haUtilised agricultural areaAnnual working unit (AWU)European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)2010390
AnnualFemalesTotalZero eurosZero haUtilised agricultural areaAnnual working unit (AWU)European Union - 27 countries (2007-2013)2010390
AnnualFemalesTotalZero eurosZero haUtilised agricultural areaAnnual working unit (AWU)European Union - 27 countries (from 2020)2010390
AnnualFemalesTotalZero eurosZero haUtilised agricultural areaAnnual working unit (AWU)European Union - 28 countries (2013-2020)2010390
AnnualFemalesTotalZero eurosZero haUtilised agricultural areaAnnual working unit (AWU)France2010200
AnnualFemalesTotalZero eurosZero haUtilised agricultural areaAnnual working unit (AWU)Nord-Pas-de-Calais (NUTS 2013)201060
AnnualFemalesTotalZero eurosZero haUtilised agricultural areaAnnual working unit (AWU)Pays de la Loire (NUTS 2013)201010

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

Share link

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