Average Population Mid-year By Sex And Age Group

Eurostat code: enps_demo_pjangry · (2005 - 2022)

@eurostat.enps_demo_pjangry

Table List

2 tables(42.51 KB)

Average Population Mid-year By Sex And Age Group - Raw

Average Population Mid-year By Sex And Age Group - Unpivoted

Average Population Mid-year By Sex And Age Group - Unpivoted

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

16.25 KB
1532 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	16286002
Annual	Females	Total	Number	Egypt	2005	34839005
Annual	Females	Total	Number	Israel	2005	3506995
Annual	Females	Total	Number	Jordan	2005	2830000
Annual	Females	Total	Number	Morocco	2005	15307354
Annual	Females	Total	Number	Tunisia	2005	5010074
Annual	Females	From 15 to 64 years	Number	Algeria	2005	10722631
Annual	Females	From 15 to 64 years	Number	Egypt	2005	22224493
Annual	Females	From 15 to 64 years	Number	Israel	2005	2155985
Annual	Females	From 15 to 64 years	Number	Jordan	2005	1716028


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.