Baselight

Livestock: Number Of Farms, Heads And LSU By Type Of Farming (2-digit) And Economic Size Of Farm (ESU)

Eurostat code: ef_ov_lsft ยท (2000 - 2007)

@eurostat.ef_ov_lsft

Livestock: Number Of Farms, Heads And LSU By Type Of Farming (2-digit) And Economic Size Of Farm (ESU) - Unpivoted
@eurostat.ef_ov_lsft.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.

  • 1.66 MB
  • 1004141 rows
  • 8 columns
freq

Freq

esu

Esu

farmtype

Farmtype

variable

Variable

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)LivestockHoldingAustria20001780
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)LivestockHoldingBelgium200040
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)LivestockHoldingGermany20001570
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)LivestockHoldingDenmark200010
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)LivestockHoldingGreece20005850
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)LivestockHoldingSpain20002120
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)LivestockHoldingFinland200060
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)LivestockHoldingMetropolitan France20002040
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)LivestockHoldingHungary20007390
AnnualFrom 1 to 1.9 ESUSpecialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)LivestockHoldingIreland200010

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

Share link

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