Population On 1 January By Sex And By Age Group

Eurostat code: med_ps112 · (2005 - 2019)

@eurostat.med_ps112

Table List

2 tables(48.76 KB)

Population On 1 January By Sex And By Age Group - Raw

Population On 1 January By Sex And By Age Group - Unpivoted

Population On 1 January By Sex And By Age Group - Unpivoted

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

20.4 KB
2122 rows
7 columns

freq Freq	age Age	sex Sex	indic_de Indic De	geo Geo	time_period Time Period	value Value
Annual	Total	Females	Population on 1 January - total	Algeria	2005	16148003
Annual	Total	Females	Population on 1 January - total	Egypt	2005	34180000
Annual	Total	Females	Population on 1 January - total	Israel	2005	3476970
Annual	Total	Females	Population on 1 January - total	Jordan	2005	2710000
Annual	Total	Females	Population on 1 January - total	Morocco	2005	15209020
Annual	Total	Females	Population on 1 January - total	Tunisia	2005	4982679
Annual	Total	Males	Population on 1 January - total	Algeria	2005	16487005
Annual	Total	Males	Population on 1 January - total	Egypt	2005	35817000
Annual	Total	Males	Population on 1 January - total	Israel	2005	3392560
Annual	Total	Males	Population on 1 January - total	Jordan	2005	2887000


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.