Baselight
Sign In

Labour Force: Number Of Persons And Farm Work (AWU) By Size Of Farm (UAA) And LFA Status

Eurostat code: ef_ov_lfsum ยท (1990 - 2007)

@eurostat.ef_ov_lfsum

Labour Force: Number Of Persons And Farm Work (AWU) By Size Of Farm (UAA) And LFA Status - Unpivoted
@eurostat.ef_ov_lfsum.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.

  • 129.06 KB
  • 49790 rows
  • 8 columns
freq

Freq

terrtypo

Terrtypo

agrarea

Agrarea

unit

Unit

variable

Variable

geo

Geo

time_period

Time Period

value

Value

AnnualLess favoured areas - mountainousZero haAnnual working unit (AWU)Labour force - directly employed by the holdingGreece19903760
AnnualLess favoured areas - mountainousZero haAnnual working unit (AWU)Labour force - directly employed by the holdingSpain19905840
AnnualLess favoured areas - mountainousZero haAnnual working unit (AWU)Labour force - directly employed by the holdingMetropolitan France1990580
AnnualLess favoured areas - mountainousZero haAnnual working unit (AWU)Labour force - directly employed by the holdingItaly19903260
AnnualLess favoured areas - mountainousZero haAnnual working unit (AWU)Labour force - directly employed by the holdingPortugal1990950
AnnualLess favoured areas - mountainousZero haAnnual working unit (AWU)Sole holdersGreece19902550
AnnualLess favoured areas - mountainousZero haAnnual working unit (AWU)Sole holdersSpain19903930
AnnualLess favoured areas - mountainousZero haAnnual working unit (AWU)Sole holdersMetropolitan France1990380
AnnualLess favoured areas - mountainousZero haAnnual working unit (AWU)Sole holdersItaly19901540
AnnualLess favoured areas - mountainousZero haAnnual working unit (AWU)Sole holdersPortugal1990410

CREATE TABLE tidy (
  "freq" VARCHAR,
  "terrtypo" VARCHAR,
  "agrarea" 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.