Average Population (mid-year)

Eurostat code: med_ps115 · (2005 - 2018)

@eurostat.med_ps115

Table List

2 tables(34.54 KB)

Average Population (mid-year) - Unpivoted

Average Population (mid-year) - Unpivoted

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

13.54 KB
1119 rows
7 columns

freq Freq	age Age	sex Sex	indic_de Indic De	geo Geo	time_period Time Period	value Value
Annual	Total	Females	Average population - total	Algeria	2005	16286002
Annual	Total	Females	Average population - total	Egypt	2005	34658748
Annual	Total	Females	Average population - total	Israel	2005	3506995
Annual	Total	Females	Average population - total	Jordan	2005	2750000
Annual	Total	Females	Average population - total	Morocco	2005	15307354
Annual	Total	Females	Average population - total	Tunisia	2005	5010074
Annual	Total	Males	Average population - total	Algeria	2005	16628256
Annual	Total	Males	Average population - total	Egypt	2005	36278347
Annual	Total	Males	Average population - total	Israel	2005	3423130
Annual	Total	Males	Average population - total	Jordan	2005	2927500


CREATE TABLE tidy (
  "freq" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "indic_de" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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