Baselight
Sign In

Livestock: Number Of Farms And Heads By Size Of Farm (UAA) And Objective Zone 2000

Eurostat code: ef_ov_lsob00 ยท (2000 - 2003)

@eurostat.ef_ov_lsob00

Livestock: Number Of Farms And Heads By Size Of Farm (UAA) And Objective Zone 2000 - Unpivoted
@eurostat.ef_ov_lsob00.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.

  • 35.51 KB
  • 8556 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)HoldingNo. of holdingsAustria2000730
AnnualZero haNot in any objective zone (as defined from 2000)HoldingNo. of holdingsGermany20001560
AnnualZero haNot in any objective zone (as defined from 2000)HoldingNo. of holdingsFinland200040
AnnualZero haNot in any objective zone (as defined from 2000)HoldingNo. of holdingsMetropolitan France20005790
AnnualZero haNot in any objective zone (as defined from 2000)HoldingNo. of holdingsLuxembourg2000
AnnualZero haNot in any objective zone (as defined from 2000)HoldingNo. of holdingsNetherlands2000880
AnnualZero haNot in any objective zone (as defined from 2000)HoldingNo. of holdingsSweden20001180
AnnualZero haNot in any objective zone (as defined from 2000)HoldingNo. of holdingsUnited Kingdom20007060
AnnualZero haNot in any objective zone (as defined from 2000)HoldingLivestockAustria2000730
AnnualZero haNot in any objective zone (as defined from 2000)HoldingLivestockGermany20001560

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.