Baselight

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

Eurostat code: ef_ogardlegecs ยท (2010 - 2013)

@eurostat.ef_ogardlegecs

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

  • 295.96 KB
  • 126156 rows
  • 7 columns
freq

Freq

legtype

Legtype

so_eur

So Eur

indic_ef

Indic Ef

geo

Geo

time_period

Time Period

value

Value

AnnualGroup holdingsZero eurosha: Utilised agricultural areaAustria201030
AnnualGroup holdingsZero eurosha: Utilised agricultural areaGermany2010200
AnnualGroup holdingsZero eurosha: Utilised agricultural areaFinland20101110
AnnualGroup holdingsZero eurosha: Utilised agricultural areaFrance2010150
AnnualGroup holdingsZero eurosha: Utilised agricultural areaLatvia20104950
AnnualGroup holdingsZero eurosha: Utilised agricultural areaMalta201010
AnnualGroup holdingsZero eurosLSU of the holdings with livestockAustria2010
AnnualGroup holdingsZero eurosLSU of the holdings with livestockGermany2010
AnnualGroup holdingsZero eurosLSU of the holdings with livestockFinland2010
AnnualGroup holdingsZero eurosLSU of the holdings with livestockFrance2010

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

Share link

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