Baselight

Other Activities On The Holding: Number Of Farms, Agricultural Area And Economic Size (ESU) By Legal Status Of Holding And Other Gainful Activity Of Sole-holder

Eurostat code: ef_so_rdoga ยท (2000 - 2007)

@eurostat.ef_so_rdoga

Other Activities On The Holding: Number Of Farms, Agricultural Area And Economic Size (ESU) By Legal Status Of Holding And Other Gainful Activity Of Sole-holder - Unpivoted
@eurostat.ef_so_rdoga.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.

  • 99.88 KB
  • 37521 rows
  • 8 columns
freq

Freq

oga_hld

Oga Hld

legtype

Legtype

variable

Variable

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualHolding is a legal person or group holdingGroup holdingsHoldings with another gainful activityHectareFinland200041840
AnnualHolding is a legal person or group holdingGroup holdingsHoldings with another gainful activityHectareMetropolitan France20001234970
AnnualHolding is a legal person or group holdingGroup holdingsHoldings with another gainful activityHectareLatvia200018970
AnnualHolding is a legal person or group holdingGroup holdingsHoldings with another gainful activityHectareNetherlands20003200
AnnualHolding is a legal person or group holdingGroup holdingsHoldings with another gainful activityHectareUnited Kingdom2000122380
AnnualHolding is a legal person or group holdingGroup holdingsHoldings with another gainful activityHoldingFinland2000900
AnnualHolding is a legal person or group holdingGroup holdingsHoldings with another gainful activityHoldingMetropolitan France200011880
AnnualHolding is a legal person or group holdingGroup holdingsHoldings with another gainful activityHoldingLatvia2000120
AnnualHolding is a legal person or group holdingGroup holdingsHoldings with another gainful activityHoldingNetherlands200070
AnnualHolding is a legal person or group holdingGroup holdingsHoldings with another gainful activityHoldingUnited Kingdom2000950

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