Labour Force: Number Of Persons And Farm Work (AWU) By Sex Of Worker, Category Of Worker, Legal Status Of Holding, Economic Size Of Farm (ESU) And NUTS 2 Region

Eurostat code: ef_so_lfesu · (1990 - 2007)

@eurostat.ef_so_lfesu

Table List

2 tables(5.08 MB)

Labour Force: Number Of Persons And Farm Work (AWU) By Sex Of Worker, Category Of Worker, Legal Status Of Holding, Economic Size Of Farm (ESU) And NUTS 2 Region - Raw

Labour Force: Number Of Persons And Farm Work (AWU) By Sex Of Worker, Category Of Worker, Legal Status Of Holding, Economic Size Of Farm (ESU) And NUTS 2 Region - Unpivoted

Labour Force: Number Of Persons And Farm Work (AWU) By Sex Of Worker, Category Of Worker, Legal Status Of Holding, Economic Size Of Farm (ESU) And NUTS 2 Region - Unpivoted

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

2.38 MB
1676077 rows
9 columns

freq Freq	esu Esu	legtype Legtype	wstatus Wstatus	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Zero ESU	Holding is legal entity	Farm labour force, directly employed by the farm on a regular or non-regular basis	Total	Annual working unit (AWU)	Nord-Pas-de-Calais (NUTS 2013)	1990
Annual	Zero ESU	Holding is legal entity	Farm labour force, directly employed by the farm on a regular or non-regular basis	Total	Annual working unit (AWU)	Franche-Comté (NUTS 2013)	1990
Annual	Zero ESU	Holding is legal entity	Farm labour force, directly employed by the farm on a regular or non-regular basis	Total	Annual working unit (AWU)	Poitou-Charentes (NUTS 2013)	1990
Annual	Zero ESU	Holding is legal entity	Farm labour force, directly employed by the farm on a regular or non-regular basis	Total	Annual working unit (AWU)	Midi-Pyrénées (NUTS 2013)	1990	20
Annual	Zero ESU	Holding is legal entity	Farm labour force, directly employed by the farm on a regular or non-regular basis	Total	Annual working unit (AWU)	Rhône-Alpes (NUTS 2013)	1990
Annual	Zero ESU	Holding is legal entity	Farm labour force, directly employed by the farm on a regular or non-regular basis	Total	Annual working unit (AWU)	Metropolitan France	1990	120
Annual	Zero ESU	Holding is legal entity	Farm labour force, directly employed by the farm on a regular or non-regular basis	Total	Annual working unit (AWU)	Ireland	1990
Annual	Zero ESU	Holding is legal entity	Farm labour force, directly employed by the farm on a regular or non-regular basis	Total	Annual working unit (AWU)	Italy	1990	580
Annual	Zero ESU	Holding is legal entity	Farm labour force, directly employed by the farm on a regular or non-regular basis	Total	Annual working unit (AWU)	Piemonte	1990	50
Annual	Zero ESU	Holding is legal entity	Farm labour force, directly employed by the farm on a regular or non-regular basis	Total	Annual working unit (AWU)	Liguria	1990


CREATE TABLE tidy (
  "freq" VARCHAR,
  "esu" VARCHAR,
  "legtype" VARCHAR,
  "wstatus" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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