Demographic Indicators

Eurostat code: med_ps12 · (2005 - 2019)

@eurostat.med_ps12

Table List

2 tables(28.25 KB)

Demographic Indicators - Unpivoted

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

8.96 KB
1083 rows
7 columns

freq Freq	age Age	sex Sex	indic_de Indic De	geo Geo	time_period Time Period	value Value
Annual	Total	Females	Mean age at first marriage	Egypt	2005	23.2
Annual	Total	Females	Mean age at first marriage	Israel	2005	28.8
Annual	Total	Females	Mean age at first marriage	Jordan	2005	26.7
Annual	Total	Females	Mean age at first marriage	Palestine*	2005	20.4
Annual	Total	Females	Mean age at first marriage	Tunisia	2005	26.8
Annual	Total	Females	Under 5 mortality rate (per 1000 live birth)	Algeria	2005	33
Annual	Total	Females	Under 5 mortality rate (per 1000 live birth)	Egypt	2005	24.3
Annual	Total	Females	Under 5 mortality rate (per 1000 live birth)	Israel	2005	5
Annual	Total	Females	Infant mortality rate	Algeria	2005	28.2
Annual	Total	Females	Infant mortality rate	Egypt	2005	18.7


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.