Baselight

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

Eurostat code: ef_ls_gzgoat ยท (1990 - 2007)

@eurostat.ef_ls_gzgoat

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

  • 188.87 KB
  • 85340 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 headsHoldingLivestockBelgium19901470
AnnualZero haNo headsHoldingLivestockDenmark1990150
AnnualZero haNo headsHoldingLivestockGreece19904140
AnnualZero haNo headsHoldingLivestockSpain199013920
AnnualZero haNo headsHoldingLivestockMetropolitan France19903090
AnnualZero haNo headsHoldingLivestockIreland1990240
AnnualZero haNo headsHoldingLivestockItaly19904340
AnnualZero haNo headsHoldingLivestockLuxembourg199010
AnnualZero haNo headsHoldingLivestockNetherlands19902140
AnnualZero haNo headsHoldingLivestockPortugal19903200

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