Baselight

Arable Crops: Number Of Farms And Areas Of Different Arable Crops By Economic Size Of Farm (SO In Euro) And Size Of Arable Area

Eurostat code: ef_alarableecs ยท (2005 - 2013)

@eurostat.ef_alarableecs

Arable Crops: Number Of Farms And Areas Of Different Arable Crops By Economic Size Of Farm (SO In Euro) And Size Of Arable Area - Unpivoted
@eurostat.ef_alarableecs.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.

  • 501.75 KB
  • 301809 rows
  • 7 columns
freq

Freq

arable

Arable

so_eur

So Eur

indic_ef

Indic Ef

geo

Geo

time_period

Time Period

value

Value

AnnualZero haZero eurosha: Utilised agricultural areaAustria2005340
AnnualZero haZero eurosha: Utilised agricultural areaBelgium2005
AnnualZero haZero eurosha: Utilised agricultural areaBulgaria2005
AnnualZero haZero eurosha: Utilised agricultural areaCyprus2005
AnnualZero haZero eurosha: Utilised agricultural areaCzechia200530
AnnualZero haZero eurosha: Utilised agricultural areaGreece200510
AnnualZero haZero eurosha: Utilised agricultural areaFinland2005
AnnualZero haZero eurosha: Utilised agricultural areaFrance200530
AnnualZero haZero eurosha: Utilised agricultural areaHungary20051370
AnnualZero haZero eurosha: Utilised agricultural areaIreland2005

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