Baselight

Animal Housing By Type Of Bovine, Utilised Agricultural Area, Size Classes Of Livestock Units And NUTS 2 Region

Eurostat code: ef_ah_bovine · (2010 - 2020)

@eurostat.ef_ah_bovine

Animal Housing By Type Of Bovine, Utilised Agricultural Area, Size Classes Of Livestock Units And NUTS 2 Region - Unpivoted
@eurostat.ef_ah_bovine.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.

  • 8.19 MB
  • 4106256 rows
  • 11 columns
freq

Freq

statinfo

Statinfo

farmtype

Farmtype

lsu

Lsu

uaarea

Uaarea

animals

Animals

hous_ani

Hous Ani

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAbove thresholdSpecialist dairyingFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive bovine animalsLoose/cubicle housingHoldingAustria2010410
AnnualAbove thresholdSpecialist dairyingFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive bovine animalsLoose/cubicle housingHoldingNiederösterreich201090
AnnualAbove thresholdSpecialist dairyingFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive bovine animalsLoose/cubicle housingHoldingKärnten201030
AnnualAbove thresholdSpecialist dairyingFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive bovine animalsLoose/cubicle housingHoldingSteiermark2010100
AnnualAbove thresholdSpecialist dairyingFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive bovine animalsLoose/cubicle housingHoldingOberösterreich201080
AnnualAbove thresholdSpecialist dairyingFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive bovine animalsLoose/cubicle housingHoldingSalzburg201050
AnnualAbove thresholdSpecialist dairyingFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive bovine animalsLoose/cubicle housingHoldingTirol201030
AnnualAbove thresholdSpecialist dairyingFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive bovine animalsLoose/cubicle housingHoldingVorarlberg201020
AnnualAbove thresholdSpecialist dairyingFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive bovine animalsLoose/cubicle housingHoldingBulgaria201020
AnnualAbove thresholdSpecialist dairyingFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive bovine animalsLoose/cubicle housingHoldingSeveroiztochen2010

CREATE TABLE tidy (
  "freq" VARCHAR,
  "statinfo" VARCHAR,
  "farmtype" VARCHAR,
  "lsu" VARCHAR,
  "uaarea" VARCHAR,
  "animals" VARCHAR,
  "hous_ani" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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