Number Of Known Species

Eurostat code: med_en52 · (2000 - 2013)

@eurostat.med_en52

Table List

2 tables(17.2 KB)

Number Of Known Species - Unpivoted

@eurostat.med_en52.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.

4.98 KB
215 rows
5 columns

freq Freq	indic_md Indic Md	geo Geo	time_period Time Period	value Value
Annual	Mammals (number)	Algeria	2000	107
Annual	Mammals (number)	Jordan	2000	72
Annual	Mammals (number)	Lebanon	2000	65
Annual	Mammals (number)	Palestine*	2000	95
Annual	Mammals (number)	Tunisia	2000	78
Annual	Birds (number)	Algeria	2000	336
Annual	Birds (number)	Jordan	2000	422
Annual	Birds (number)	Lebanon	2000	338
Annual	Birds (number)	Palestine*	2000	470
Annual	Birds (number)	Tunisia	2000	362


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

Share link

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