Baselight
Sign In

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

Eurostat code: ef_ah_pigs · (2010 - 2020)

@eurostat.ef_ah_pigs

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

  • 6.34 MB
  • 3343382 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 pigsFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive swine, domestic speciesEntire deep litter surfaceHoldingAustria201010
AnnualAbove thresholdSpecialist pigsFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive swine, domestic speciesEntire deep litter surfaceHoldingNiederösterreich201010
AnnualAbove thresholdSpecialist pigsFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive swine, domestic speciesEntire deep litter surfaceHoldingKärnten201010
AnnualAbove thresholdSpecialist pigsFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive swine, domestic speciesEntire deep litter surfaceHoldingYugozapaden2010
AnnualAbove thresholdSpecialist pigsFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive swine, domestic speciesEntire deep litter surfaceHoldingGreece201010
AnnualAbove thresholdSpecialist pigsFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive swine, domestic speciesEntire deep litter surfaceHoldingKentriki Makedonia (NUTS 2010)201010
AnnualAbove thresholdSpecialist pigsFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive swine, domestic speciesEntire deep litter surfaceHoldingSpain201020
AnnualAbove thresholdSpecialist pigsFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive swine, domestic speciesEntire deep litter surfaceHoldingCastilla y León201010
AnnualAbove thresholdSpecialist pigsFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive swine, domestic speciesEntire deep litter surfaceHoldingCastilla-La Mancha2010
AnnualAbove thresholdSpecialist pigsFrom 10 to 14.9 LSUFrom 10 to 99.9 haLive swine, domestic speciesEntire deep litter surfaceHoldingExtremadura201010

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.