Baselight
Sign In

Support For Rural Development: Number Of Farms, Agricultural Area, Standard Output (SO) And Livestock (LSU) By Legal Status Of Holding And Agricultural Size Of Farm (UAA)

Eurostat code: ef_ogardaa ยท (2010 - 2013)

@eurostat.ef_ogardaa

Support For Rural Development: Number Of Farms, Agricultural Area, Standard Output (SO) And Livestock (LSU) By Legal Status Of Holding And Agricultural Size Of Farm (UAA) - Unpivoted
@eurostat.ef_ogardaa.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.

  • 256.21 KB
  • 105618 rows
  • 7 columns
freq

Freq

agrarea

Agrarea

legtype

Legtype

indic_ef

Indic Ef

geo

Geo

time_period

Time Period

value

Value

AnnualZero haGroup holdingsha: Utilised agricultural areaAustria2010
AnnualZero haGroup holdingsha: Utilised agricultural areaGermany2010
AnnualZero haGroup holdingsha: Utilised agricultural areaFinland2010
AnnualZero haGroup holdingsha: Utilised agricultural areaFrance2010
AnnualZero haGroup holdingsha: Utilised agricultural areaLatvia2010
AnnualZero haGroup holdingsha: Utilised agricultural areaMalta2010
AnnualZero haGroup holdingsLSU of the holdings with livestockAustria201015110
AnnualZero haGroup holdingsLSU of the holdings with livestockGermany2010404250
AnnualZero haGroup holdingsLSU of the holdings with livestockFinland20101310
AnnualZero haGroup holdingsLSU of the holdings with livestockFrance201018350

CREATE TABLE tidy (
  "freq" VARCHAR,
  "agrarea" VARCHAR,
  "legtype" VARCHAR,
  "indic_ef" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);