Baselight

Type Of Other Gainful Activities Directly Related To The Agricultural Holdings By Age Of The Manager, Utilised Agricultural Area, Farm Type And Economic Size By NUTS 2 Region

Eurostat code: ef_oga_type · (2010 - 2020)

@eurostat.ef_oga_type

Type Of Other Gainful Activities Directly Related To The Agricultural Holdings By Age Of The Manager, Utilised Agricultural Area, Farm Type And Economic Size By NUTS 2 Region - Unpivoted
@eurostat.ef_oga_type.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.

  • 18.43 MB
  • 9555480 rows
  • 11 columns
freq

Freq

statinfo

Statinfo

farmtype

Farmtype

so_eur

So Eur

uaarea

Uaarea

age

Age

oga_type

Oga Type

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAbove thresholdSpecialist cropsFrom 2 000 to 49 999 eurosFrom 2 to 19.9 haTotalHoldings having no other gainful activityAnnual working unit (AWU)Austria20107100
AnnualAbove thresholdSpecialist cropsFrom 2 000 to 49 999 eurosFrom 2 to 19.9 haTotalHoldings having no other gainful activityAnnual working unit (AWU)Burgenland2010850
AnnualAbove thresholdSpecialist cropsFrom 2 000 to 49 999 eurosFrom 2 to 19.9 haTotalHoldings having no other gainful activityAnnual working unit (AWU)Niederösterreich20103030
AnnualAbove thresholdSpecialist cropsFrom 2 000 to 49 999 eurosFrom 2 to 19.9 haTotalHoldings having no other gainful activityAnnual working unit (AWU)Wien201070
AnnualAbove thresholdSpecialist cropsFrom 2 000 to 49 999 eurosFrom 2 to 19.9 haTotalHoldings having no other gainful activityAnnual working unit (AWU)Kärnten2010140
AnnualAbove thresholdSpecialist cropsFrom 2 000 to 49 999 eurosFrom 2 to 19.9 haTotalHoldings having no other gainful activityAnnual working unit (AWU)Steiermark20101720
AnnualAbove thresholdSpecialist cropsFrom 2 000 to 49 999 eurosFrom 2 to 19.9 haTotalHoldings having no other gainful activityAnnual working unit (AWU)Oberösterreich20101060
AnnualAbove thresholdSpecialist cropsFrom 2 000 to 49 999 eurosFrom 2 to 19.9 haTotalHoldings having no other gainful activityAnnual working unit (AWU)Salzburg2010110
AnnualAbove thresholdSpecialist cropsFrom 2 000 to 49 999 eurosFrom 2 to 19.9 haTotalHoldings having no other gainful activityAnnual working unit (AWU)Tirol2010100
AnnualAbove thresholdSpecialist cropsFrom 2 000 to 49 999 eurosFrom 2 to 19.9 haTotalHoldings having no other gainful activityAnnual working unit (AWU)Vorarlberg201020

CREATE TABLE tidy (
  "freq" VARCHAR,
  "statinfo" VARCHAR,
  "farmtype" VARCHAR,
  "so_eur" VARCHAR,
  "uaarea" VARCHAR,
  "age" VARCHAR,
  "oga_type" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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