General Indicators

Eurostat code: med_ps111 · (2005 - 2019)

@eurostat.med_ps111

Table List

2 tables(18.31 KB)

General Indicators - Unpivoted

@eurostat.med_ps111.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.94 KB
171 rows
5 columns

freq Freq	indic_md Indic Md	geo Geo	time_period Time Period	value Value
Annual	Total area (km²)	Algeria	2005	2381741
Annual	Total area (km²)	Egypt	2005	1009450
Annual	Total area (km²)	Israel	2005	22072
Annual	Total area (km²)	Jordan	2005	89318
Annual	Total area (km²)	Lebanon	2005	10452
Annual	Total area (km²)	Morocco	2005	710850
Annual	Total area (km²)	Tunisia	2005	164150
Annual	Population density (Inhab / Km²)	Algeria	2005	13.8
Annual	Population density (Inhab / Km²)	Egypt	2005	70.3
Annual	Population density (Inhab / Km²)	Israel	2005	299.2


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.