Baselight

Labour Force: Number Of Persons And Farm Work (AWU) By Type Of Farming (2-digit) And Economic Size Of Farm (ESU)

Eurostat code: ef_ov_lfft ยท (2000 - 2007)

@eurostat.ef_ov_lfft

Labour Force: Number Of Persons And Farm Work (AWU) By Type Of Farming (2-digit) And Economic Size Of Farm (ESU) - Unpivoted
@eurostat.ef_ov_lfft.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.

  • 867.42 KB
  • 445276 rows
  • 8 columns
freq

Freq

esu

Esu

farmtype

Farmtype

variable

Variable

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)Labour force - directly employed by the holdingAnnual working unit (AWU)Austria20001940
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)Labour force - directly employed by the holdingAnnual working unit (AWU)Belgium200080
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)Labour force - directly employed by the holdingAnnual working unit (AWU)Germany20001280
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)Labour force - directly employed by the holdingAnnual working unit (AWU)Denmark200020
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)Labour force - directly employed by the holdingAnnual working unit (AWU)Greece20002020
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)Labour force - directly employed by the holdingAnnual working unit (AWU)Spain20003090
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)Labour force - directly employed by the holdingAnnual working unit (AWU)Finland2000870
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)Labour force - directly employed by the holdingAnnual working unit (AWU)Metropolitan France2000970
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)Labour force - directly employed by the holdingAnnual working unit (AWU)Ireland200060
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)Labour force - directly employed by the holdingAnnual working unit (AWU)Italy200016330

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

Share link

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