Baselight
Sign In

Land Use: Number Of Farms And Areas By Size Of Farm (UAA) And Objective Zone 2000

Eurostat code: ef_ov_luob00 ยท (2000 - 2005)

@eurostat.ef_ov_luob00

Land Use: Number Of Farms And Areas By Size Of Farm (UAA) And Objective Zone 2000 - Unpivoted
@eurostat.ef_ov_luob00.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.

  • 181.91 KB
  • 72624 rows
  • 8 columns
freq

Freq

agrarea

Agrarea

obzone

Obzone

unit

Unit

variable

Variable

geo

Geo

time_period

Time Period

value

Value

AnnualZero haNot in any objective zone (as defined from 2000)HectareUtilised agricultural areaBelgium2000
AnnualZero haNot in any objective zone (as defined from 2000)HectareUtilised agricultural areaDenmark2000
AnnualZero haNot in any objective zone (as defined from 2000)HectareUtilised agricultural areaMetropolitan France2000
AnnualZero haNot in any objective zone (as defined from 2000)HectareUtilised agricultural areaItaly2000
AnnualZero haNot in any objective zone (as defined from 2000)HectareUtilised agricultural areaUnited Kingdom2000
AnnualZero haNot in any objective zone (as defined from 2000)HectareArable landBelgium2000
AnnualZero haNot in any objective zone (as defined from 2000)HectareArable landDenmark2000
AnnualZero haNot in any objective zone (as defined from 2000)HectareArable landMetropolitan France2000
AnnualZero haNot in any objective zone (as defined from 2000)HectareArable landItaly2000
AnnualZero haNot in any objective zone (as defined from 2000)HectareArable landUnited Kingdom2000

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

Share link

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