Baselight

Support For Rural Development: Number Of Farms, Agricultural Area, Standard Output (SO) And Livestock (LSU) By Legal Status And Type Of Farming (1-digit)

Eurostat code: ef_ogardlegft ยท (2010 - 2013)

@eurostat.ef_ogardlegft

Support For Rural Development: Number Of Farms, Agricultural Area, Standard Output (SO) And Livestock (LSU) By Legal Status And Type Of Farming (1-digit) - Unpivoted
@eurostat.ef_ogardlegft.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.

  • 250.46 KB
  • 104638 rows
  • 7 columns
freq

Freq

farmtype

Farmtype

legtype

Legtype

indic_ef

Indic Ef

geo

Geo

time_period

Time Period

value

Value

AnnualSpecialist field crops (calculated with Standard Output)Group holdingsha: Utilised agricultural areaAustria201055040
AnnualSpecialist field crops (calculated with Standard Output)Group holdingsha: Utilised agricultural areaGermany2010964360
AnnualSpecialist field crops (calculated with Standard Output)Group holdingsha: Utilised agricultural areaFinland2010103980
AnnualSpecialist field crops (calculated with Standard Output)Group holdingsha: Utilised agricultural areaFrance2010959280
AnnualSpecialist field crops (calculated with Standard Output)Group holdingsha: Utilised agricultural areaLithuania2010
AnnualSpecialist field crops (calculated with Standard Output)Group holdingsha: Utilised agricultural areaLuxembourg2010
AnnualSpecialist field crops (calculated with Standard Output)Group holdingsha: Utilised agricultural areaLatvia2010119240
AnnualSpecialist field crops (calculated with Standard Output)Group holdingsha: Utilised agricultural areaMalta201080
AnnualSpecialist field crops (calculated with Standard Output)Group holdingsLSU of the holdings with livestockAustria2010390
AnnualSpecialist field crops (calculated with Standard Output)Group holdingsLSU of the holdings with livestockGermany201043740

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

Share link

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