General Indicators

Eurostat code: med_ps111 · (2005 - 2019)

@eurostat.med_ps111

Table List

2 tables(18.31 KB)

General Indicators - Raw

General Indicators - Unpivoted

General Indicators - Raw

@eurostat.med_ps111.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

13.37 KB
15 rows
18 columns

freq Freq	indic_md Indic Md	geo Geo	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019
Annual	Total area (km²)	Algeria	2381741	2381741	2381741	2381741	2381741	2381741	2381741	2381741	2381741	2381741	2381741	2381741	2381741	2381741
Annual	Total area (km²)	Egypt	1009450	1009450	1009450			1001450
Annual	Total area (km²)	Israel	22072	22072	22072	22072	22072	22072	22072	22072	22072	22072	22072	22072	22072	22072	22072
Annual	Total area (km²)	Jordan	89318	89318	89318	89318	89318	89318	89318	89318	89318	89318	89318	89318	89318	89318
Annual	Total area (km²)	Lebanon	10452	10452	10452	10452	10452	10452
Annual	Total area (km²)	Morocco	710850	710850	710850	710850	710850	710850	710850	710850
Annual	Total area (km²)	Tunisia	164150	164150	164150	164150	164150	164150	164150	164150
Annual	Population density (Inhab / Km²)	Algeria	13.8	14.1	14.3	14.5	14.8	15.1	15.4	15.7	16.1	16.4	16.8	17	17.3
Annual	Population density (Inhab / Km²)	Egypt	70.3	71.5	73	74.6	76.2	78	79.8	81.8	83.8	85	87	90.4	92.4	96.6	98.1
Annual	Population density (Inhab / Km²)	Israel	299.2	305.2	310.5	315.6	320.9	328.7	334.5	347.1	353.1	359	366	373	380.2	387.4	394.6


CREATE TABLE raw (
  "freq" VARCHAR,
  "indic_md" VARCHAR,
  "geo" VARCHAR,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE
);

Share link

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