Population By Sex, Age, Migration Status, Citizenship And Educational Attainment Level

Eurostat code: lfsa_pganedm$dv_1806

@eurostat.lfsa_pganedm_dv_1806

Table List

2 tables(134.83 KB)

Population By Sex, Age, Migration Status, Citizenship And Educational Attainment Level - Raw

Population By Sex, Age, Migration Status, Citizenship And Educational Attainment Level - Unpivoted

Population By Sex, Age, Migration Status, Citizenship And Educational Attainment Level - Unpivoted

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

63.57 KB
11569 rows
10 columns

freq Freq	isced11 Isced11	citizen Citizen	mgstatus Mgstatus	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	All ISCED 2011 levels	EU27 countries (from 2020) except reporting country	Total	From 15 to 24 years	Females	Thousand persons	Austria	2021	38.5
Annual	All ISCED 2011 levels	EU27 countries (from 2020) except reporting country	Total	From 15 to 24 years	Females	Thousand persons	Belgium	2021	33.6
Annual	All ISCED 2011 levels	EU27 countries (from 2020) except reporting country	Total	From 15 to 24 years	Females	Thousand persons	Switzerland	2021	49.7
Annual	All ISCED 2011 levels	EU27 countries (from 2020) except reporting country	Total	From 15 to 24 years	Females	Thousand persons	Cyprus	2021	4.1
Annual	All ISCED 2011 levels	EU27 countries (from 2020) except reporting country	Total	From 15 to 24 years	Females	Thousand persons	Czechia	2021	3.3
Annual	All ISCED 2011 levels	EU27 countries (from 2020) except reporting country	Total	From 15 to 24 years	Females	Thousand persons	Germany	2021	173.2
Annual	All ISCED 2011 levels	EU27 countries (from 2020) except reporting country	Total	From 15 to 24 years	Females	Thousand persons	Denmark	2021	5.3
Annual	All ISCED 2011 levels	EU27 countries (from 2020) except reporting country	Total	From 15 to 24 years	Females	Thousand persons	Euro area – 20 countries (from 2023)	2021	498.3
Annual	All ISCED 2011 levels	EU27 countries (from 2020) except reporting country	Total	From 15 to 24 years	Females	Thousand persons	Greece	2021	3.1
Annual	All ISCED 2011 levels	EU27 countries (from 2020) except reporting country	Total	From 15 to 24 years	Females	Thousand persons	Spain	2021	76.6


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

Share link

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