Dataset: Foreign-born Population By Sex, Age, Main Reason For Migrating, Country Of Birth And Educational Attainment Level

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.

freq Freq	c_birth C Birth	isced11 Isced11	reason Reason	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	EU27 countries (from 2020) except reporting country	Less than primary, primary and lower secondary education (levels 0-2)	Education or training	From 15 to 24 years	Males	Thousand persons	Switzerland	2021	1.3
Annual	EU27 countries (from 2020) except reporting country	Less than primary, primary and lower secondary education (levels 0-2)	Education or training	From 15 to 24 years	Males	Thousand persons	Luxembourg	2021	1
Annual	EU27 countries (from 2020) except reporting country	Less than primary, primary and lower secondary education (levels 0-2)	Education or training	From 15 to 24 years	Males	Thousand persons	Netherlands	2021	1.8
Annual	EU27 countries (from 2020) except reporting country	Less than primary, primary and lower secondary education (levels 0-2)	Education or training	From 15 to 24 years	Total	Thousand persons	Switzerland	2021	1.8
Annual	EU27 countries (from 2020) except reporting country	Less than primary, primary and lower secondary education (levels 0-2)	Education or training	From 15 to 24 years	Total	Thousand persons	Luxembourg	2021	1.2
Annual	EU27 countries (from 2020) except reporting country	Less than primary, primary and lower secondary education (levels 0-2)	Education or training	From 15 to 24 years	Total	Thousand persons	Netherlands	2021	2.3
Annual	EU27 countries (from 2020) except reporting country	Less than primary, primary and lower secondary education (levels 0-2)	Education or training	From 15 to 29 years	Males	Thousand persons	Switzerland	2021	1.5
Annual	EU27 countries (from 2020) except reporting country	Less than primary, primary and lower secondary education (levels 0-2)	Education or training	From 15 to 29 years	Males	Thousand persons	Luxembourg	2021	1.2
Annual	EU27 countries (from 2020) except reporting country	Less than primary, primary and lower secondary education (levels 0-2)	Education or training	From 15 to 29 years	Males	Thousand persons	Netherlands	2021	1.8
Annual	EU27 countries (from 2020) except reporting country	Less than primary, primary and lower secondary education (levels 0-2)	Education or training	From 15 to 29 years	Total	Thousand persons	Switzerland	2021	1.9

freq

Freq

c_birth

C Birth

isced11

Isced11

reason

Reason

age

Age

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

Annual

EU27 countries (from 2020) except reporting country

Less than primary, primary and lower secondary education (levels 0-2)

Education or training

From 15 to 24 years

Males

Thousand persons

Switzerland

2021

1.3

Annual

EU27 countries (from 2020) except reporting country

Less than primary, primary and lower secondary education (levels 0-2)

Education or training

From 15 to 24 years

Males

Thousand persons

Luxembourg

2021

Annual

EU27 countries (from 2020) except reporting country

Less than primary, primary and lower secondary education (levels 0-2)

Education or training

From 15 to 24 years

Males

Thousand persons

Netherlands

2021

1.8

Annual

EU27 countries (from 2020) except reporting country

Less than primary, primary and lower secondary education (levels 0-2)

Education or training

From 15 to 24 years

Total

Thousand persons

Switzerland

2021

1.8

Annual

EU27 countries (from 2020) except reporting country

Less than primary, primary and lower secondary education (levels 0-2)

Education or training

From 15 to 24 years

Total

Thousand persons

Luxembourg

2021

1.2

Annual

EU27 countries (from 2020) except reporting country

Less than primary, primary and lower secondary education (levels 0-2)

Education or training

From 15 to 24 years

Total

Thousand persons

Netherlands

2021

2.3

Annual

EU27 countries (from 2020) except reporting country

Less than primary, primary and lower secondary education (levels 0-2)

Education or training

From 15 to 29 years

Males

Thousand persons

Switzerland

2021

1.5

Annual

EU27 countries (from 2020) except reporting country

Less than primary, primary and lower secondary education (levels 0-2)

Education or training

From 15 to 29 years

Males

Thousand persons

Luxembourg

2021

1.2

Annual

EU27 countries (from 2020) except reporting country

Less than primary, primary and lower secondary education (levels 0-2)

Education or training

From 15 to 29 years

Males

Thousand persons

Netherlands

2021

1.8

Annual

EU27 countries (from 2020) except reporting country

Less than primary, primary and lower secondary education (levels 0-2)

Education or training

From 15 to 29 years

Total

Thousand persons

Switzerland

2021

1.9

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

Foreign-born Population By Sex, Age, Main Reason For Migrating, Country Of Birth And Educational Attainment Level

Table List

Foreign-born Population By Sex, Age, Main Reason For Migrating, Country Of Birth And Educational Attainment Level - Unpivoted

@eurostat.lfsa_pfgacedm.tidy

freq

c_birth

isced11

reason

age

sex

unit

geo

time_period

value

Share link