Baselight

Other Activities On The Holding: Number Of Farms, Agricultural Area And Economic Size (ESU) By Legal Status Of Holding, Type Of Farming (1-digit) And Economic Size Of Farm (ESU)

Eurostat code: ef_so_rdft ยท (2000 - 2007)

@eurostat.ef_so_rdft

Other Activities On The Holding: Number Of Farms, Agricultural Area And Economic Size (ESU) By Legal Status Of Holding, Type Of Farming (1-digit) And Economic Size Of Farm (ESU) - Unpivoted
@eurostat.ef_so_rdft.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.

  • 911.8 KB
  • 728460 rows
  • 9 columns
freq

Freq

esu

Esu

farmtype

Farmtype

legtype

Legtype

variable

Variable

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFrom 1 to 1.9 ESUSpecialist field crops (calculated with Standard Gross Margin)Group holdingsHoldings with another gainful activityHectareFinland2000170
AnnualFrom 1 to 1.9 ESUSpecialist field crops (calculated with Standard Gross Margin)Group holdingsHoldings with another gainful activityHectareMetropolitan France2000
AnnualFrom 1 to 1.9 ESUSpecialist field crops (calculated with Standard Gross Margin)Group holdingsHoldings with another gainful activityHectareLatvia2000
AnnualFrom 1 to 1.9 ESUSpecialist field crops (calculated with Standard Gross Margin)Group holdingsHoldings with another gainful activityHectareUnited Kingdom2000
AnnualFrom 1 to 1.9 ESUSpecialist field crops (calculated with Standard Gross Margin)Group holdingsHoldings with another gainful activityHoldingFinland200020
AnnualFrom 1 to 1.9 ESUSpecialist field crops (calculated with Standard Gross Margin)Group holdingsHoldings with another gainful activityHoldingMetropolitan France2000
AnnualFrom 1 to 1.9 ESUSpecialist field crops (calculated with Standard Gross Margin)Group holdingsHoldings with another gainful activityHoldingLatvia2000
AnnualFrom 1 to 1.9 ESUSpecialist field crops (calculated with Standard Gross Margin)Group holdingsHoldings with another gainful activityHoldingUnited Kingdom2000
AnnualFrom 1 to 1.9 ESUSpecialist field crops (calculated with Standard Gross Margin)Group holdingsHoldings with another gainful activityStandard gross margin (SGM) in economic size unit (ESU)Finland200030
AnnualFrom 1 to 1.9 ESUSpecialist field crops (calculated with Standard Gross Margin)Group holdingsHoldings with another gainful activityStandard gross margin (SGM) in economic size unit (ESU)Metropolitan France2000

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