Baselight
Sign In

Number Of Pigs

Eurostat code: tag00018 ยท (2013 - 2024)

@eurostat.tag00018

Number Of Pigs - Unpivoted
@eurostat.tag00018.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.66 KB
  • 432 rows
  • 7 columns
freq

Freq

month

Month

animals

Animals

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualDecemberLive swine, domestic speciesThousand heads (animals)Austria20132895.84
AnnualDecemberLive swine, domestic speciesThousand heads (animals)Bosnia and Herzegovina2013530
AnnualDecemberLive swine, domestic speciesThousand heads (animals)Belgium20136351.28
AnnualDecemberLive swine, domestic speciesThousand heads (animals)Bulgaria2013586.42
AnnualDecemberLive swine, domestic speciesThousand heads (animals)Switzerland20131484.73
AnnualDecemberLive swine, domestic speciesThousand heads (animals)Cyprus2013357.9
AnnualDecemberLive swine, domestic speciesThousand heads (animals)Czechia20131547.69
AnnualDecemberLive swine, domestic speciesThousand heads (animals)Germany201328133.26
AnnualDecemberLive swine, domestic speciesThousand heads (animals)Denmark201312402
AnnualDecemberLive swine, domestic speciesThousand heads (animals)Estonia2013358.7

CREATE TABLE tidy (
  "freq" VARCHAR,
  "month" VARCHAR,
  "animals" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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