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

Eurostat code: ef_ov_lfob00 · (2000 - 2003)

@eurostat.ef_ov_lfob00

Table List

2 tables(53.32 KB)

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

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

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

@eurostat.ef_ov_lfob00.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.78 KB
6320 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 from 2000)	Annual working unit (AWU)	Labour force - directly employed by the holding	Austria	2000	270
Annual	Zero ha	Not in any objective zone (as defined from 2000)	Annual working unit (AWU)	Labour force - directly employed by the holding	Germany	2000	3360
Annual	Zero ha	Not in any objective zone (as defined from 2000)	Annual working unit (AWU)	Labour force - directly employed by the holding	Spain	2000	980
Annual	Zero ha	Not in any objective zone (as defined from 2000)	Annual working unit (AWU)	Labour force - directly employed by the holding	Finland	2000	20
Annual	Zero ha	Not in any objective zone (as defined from 2000)	Annual working unit (AWU)	Labour force - directly employed by the holding	Metropolitan France	2000	8620
Annual	Zero ha	Not in any objective zone (as defined from 2000)	Annual working unit (AWU)	Labour force - directly employed by the holding	Luxembourg	2000
Annual	Zero ha	Not in any objective zone (as defined from 2000)	Annual working unit (AWU)	Labour force - directly employed by the holding	Netherlands	2000	2210
Annual	Zero ha	Not in any objective zone (as defined from 2000)	Annual working unit (AWU)	Labour force - directly employed by the holding	Sweden	2000	830
Annual	Zero ha	Not in any objective zone (as defined from 2000)	Annual working unit (AWU)	Labour force - directly employed by the holding	United Kingdom	2000	6660
Annual	Zero ha	Not in any objective zone (as defined from 2000)	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.