Baselight
Sign In

Fruit And Berry Plantations: Number Of Farms And Areas By Size Of Farm (UAA) And Size Of Fruit And Berry Plantation Area

Eurostat code: ef_lu_pcfruit ยท (1990 - 2007)

@eurostat.ef_lu_pcfruit

Fruit And Berry Plantations: Number Of Farms And Areas By Size Of Farm (UAA) And Size Of Fruit And Berry Plantation Area - Unpivoted
@eurostat.ef_lu_pcfruit.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.

  • 231.46 KB
  • 135380 rows
  • 8 columns
freq

Freq

agrarea

Agrarea

croparea

Croparea

variable

Variable

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualZero haZero haUtilised agricultural areaHectareBelgium1990
AnnualZero haZero haUtilised agricultural areaHectareDenmark1990
AnnualZero haZero haUtilised agricultural areaHectareGreece1990
AnnualZero haZero haUtilised agricultural areaHectareSpain1990
AnnualZero haZero haUtilised agricultural areaHectareMetropolitan France1990
AnnualZero haZero haUtilised agricultural areaHectareIreland1990
AnnualZero haZero haUtilised agricultural areaHectareItaly1990
AnnualZero haZero haUtilised agricultural areaHectareLuxembourg1990
AnnualZero haZero haUtilised agricultural areaHectareNetherlands1990
AnnualZero haZero haUtilised agricultural areaHectarePortugal1990

CREATE TABLE tidy (
  "freq" VARCHAR,
  "agrarea" VARCHAR,
  "croparea" VARCHAR,
  "variable" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);