Population On 1 January By Sex And Age Group

Eurostat code: enps_demo_pjangr · (2005 - 2023)

@eurostat.enps_demo_pjangr

Table List

2 tables(70.04 KB)

Population On 1 January By Sex And Age Group - Raw

Population On 1 January By Sex And Age Group - Unpivoted

Population On 1 January By Sex And Age Group - Unpivoted

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

29.87 KB
3470 rows
7 columns

freq Freq	sex Sex	age Age	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Females	Total	Number	Algeria	2005	16148003
Annual	Females	Total	Number	Egypt	2005	34180000
Annual	Females	Total	Number	Israel	2005	3476970
Annual	Females	Total	Number	Jordan	2005	2790000
Annual	Females	Total	Number	Morocco	2005	15209020
Annual	Females	Total	Number	Tunisia	2005	4982679
Annual	Females	From 15 to 19 years	Number	Algeria	2005	1862770
Annual	Females	From 15 to 19 years	Number	Egypt	2005	3612847
Annual	Females	From 15 to 19 years	Number	Israel	2005	278820
Annual	Females	From 15 to 19 years	Number	Jordan	2005	279395


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

Share link

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