Baselight

Livestock

Eurostat code: enps_apro_mt_ls ยท (2005 - 2022)

@eurostat.enps_apro_mt_ls

Livestock - Unpivoted
@eurostat.enps_apro_mt_ls.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.

  • 9.91 KB
  • 756 rows
  • 6 columns
freq

Freq

unit

Unit

animals

Animals

geo

Geo

time_period

Time Period

value

Value

AnnualThousand heads (animals)Live bovine animalsAlgeria20051586.1
AnnualThousand heads (animals)Live bovine animalsEgypt20054484.7
AnnualThousand heads (animals)Live bovine animalsIsrael2005373
AnnualThousand heads (animals)Live bovine animalsJordan200567.5
AnnualThousand heads (animals)Live bovine animalsMorocco20052664.4
AnnualThousand heads (animals)Live bovine animalsPalestine*200533.7
AnnualThousand heads (animals)Live bovine animalsTunisia2005685
AnnualThousand heads (animals)Dairy cowsAlgeria2005828.8
AnnualThousand heads (animals)Dairy cowsIsrael2005120
AnnualThousand heads (animals)Dairy cowsJordan200540

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

Share link

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