Baselight

Holder-manager Relationship: Selected Variables By Size Of Farm (UAA)

Eurostat code: ef_so_mplegper ยท (1990 - 2007)

@eurostat.ef_so_mplegper

Holder-manager Relationship: Selected Variables By Size Of Farm (UAA) - Unpivoted
@eurostat.ef_so_mplegper.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.

  • 385.57 KB
  • 124186 rows
  • 7 columns
freq

Freq

agrarea

Agrarea

hold_man

Hold Man

variable

Variable

geo

Geo

time_period

Time Period

value

Value

AnnualZero haManager not holder but member of holder 's familyUtilised agricultural area (ha)Belgium1990
AnnualZero haManager not holder but member of holder 's familyUtilised agricultural area (ha)Greece1990
AnnualZero haManager not holder but member of holder 's familyUtilised agricultural area (ha)Spain1990
AnnualZero haManager not holder but member of holder 's familyUtilised agricultural area (ha)Ireland1990
AnnualZero haManager not holder but member of holder 's familyUtilised agricultural area (ha)Italy1990
AnnualZero haManager not holder but member of holder 's familyUtilised agricultural area (ha)Luxembourg1990
AnnualZero haManager not holder but member of holder 's familyUtilised agricultural area (ha)Netherlands1990
AnnualZero haManager not holder but member of holder 's familyUtilised agricultural area (ha)Portugal1990
AnnualZero haManager not holder but member of holder 's familyUtilised agricultural area (ha)United Kingdom1990
AnnualZero haManager not holder but member of holder 's familyhold: Farm accounts are keptBelgium199010

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

Share link

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