Labour Force: Number Of Persons And Farm Work (AWU) By Size Of Farm (UAA) And Objective Zone 1999

Eurostat code: ef_ov_lfob99 · (2000 - 2003)

@eurostat.ef_ov_lfob99

Table List

2 tables(53.81 KB)

Labour Force: Number Of Persons And Farm Work (AWU) By Size Of Farm (UAA) And Objective Zone 1999 - Raw

Labour Force: Number Of Persons And Farm Work (AWU) By Size Of Farm (UAA) And Objective Zone 1999 - Unpivoted

Labour Force: Number Of Persons And Farm Work (AWU) By Size Of Farm (UAA) And Objective Zone 1999 - Unpivoted

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

25.71 KB
7060 rows
8 columns

freq Freq	agrarea Agrarea	obzone Obzone	unit Unit	variable Variable	geo Geo	time_period Time Period	value Value
Annual	Zero ha	Not in any objective zone (as defined up to 1999)	Annual working unit (AWU)	Labour force - directly employed by the holding	Austria	2000	350
Annual	Zero ha	Not in any objective zone (as defined up to 1999)	Annual working unit (AWU)	Labour force - directly employed by the holding	Germany	2000	2840
Annual	Zero ha	Not in any objective zone (as defined up to 1999)	Annual working unit (AWU)	Labour force - directly employed by the holding	Spain	2000	990
Annual	Zero ha	Not in any objective zone (as defined up to 1999)	Annual working unit (AWU)	Labour force - directly employed by the holding	Finland	2000	30
Annual	Zero ha	Not in any objective zone (as defined up to 1999)	Annual working unit (AWU)	Labour force - directly employed by the holding	Metropolitan France	2000	6120
Annual	Zero ha	Not in any objective zone (as defined up to 1999)	Annual working unit (AWU)	Labour force - directly employed by the holding	Luxembourg	2000
Annual	Zero ha	Not in any objective zone (as defined up to 1999)	Annual working unit (AWU)	Labour force - directly employed by the holding	Netherlands	2000	2460
Annual	Zero ha	Not in any objective zone (as defined up to 1999)	Annual working unit (AWU)	Labour force - directly employed by the holding	Sweden	2000	750
Annual	Zero ha	Not in any objective zone (as defined up to 1999)	Annual working unit (AWU)	Labour force - directly employed by the holding	United Kingdom	2000	5940
Annual	Zero ha	Not in any objective zone (as defined up to 1999)	Annual working unit (AWU)	Group-holdings: Holders	Austria	2000


CREATE TABLE tidy (
  "freq" VARCHAR,
  "agrarea" VARCHAR,
  "obzone" VARCHAR,
  "unit" VARCHAR,
  "variable" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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