Baselight
Sign In

Cattle: Number Of Farms And Heads By Size Of Farm (UAA) And Size Of Cattle Herd

Eurostat code: ef_ls_gzcatl ยท (1990 - 2007)

@eurostat.ef_ls_gzcatl

Cattle: Number Of Farms And Heads By Size Of Farm (UAA) And Size Of Cattle Herd - Unpivoted
@eurostat.ef_ls_gzcatl.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.

  • 563.52 KB
  • 269211 rows
  • 8 columns
freq

Freq

agrarea

Agrarea

n_head

N Head

unit

Unit

variable

Variable

geo

Geo

time_period

Time Period

value

Value

AnnualZero haNo headsHoldingFodder crops and grassBelgium1990
AnnualZero haNo headsHoldingFodder crops and grassDenmark1990
AnnualZero haNo headsHoldingFodder crops and grassGreece1990
AnnualZero haNo headsHoldingFodder crops and grassSpain1990
AnnualZero haNo headsHoldingFodder crops and grassMetropolitan France1990
AnnualZero haNo headsHoldingFodder crops and grassIreland1990
AnnualZero haNo headsHoldingFodder crops and grassItaly1990
AnnualZero haNo headsHoldingFodder crops and grassLuxembourg1990
AnnualZero haNo headsHoldingFodder crops and grassNetherlands1990
AnnualZero haNo headsHoldingFodder crops and grassPortugal1990

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