Foreign-born Population By Sex, Age, Main Reason For Migrating, Citizenship And Labour Status

Eurostat code: lfsa_pfganwsm · (2021 - 2023)

@eurostat.lfsa_pfganwsm

Table List

2 tables(682.69 KB)

Foreign-born Population By Sex, Age, Main Reason For Migrating, Citizenship And Labour Status - Raw

Foreign-born Population By Sex, Age, Main Reason For Migrating, Citizenship And Labour Status - Unpivoted

Foreign-born Population By Sex, Age, Main Reason For Migrating, Citizenship And Labour Status - Raw

@eurostat.lfsa_pfganwsm.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

351.39 KB
102602 rows
10 columns

freq Freq	wstatus Wstatus	citizen Citizen	reason Reason	age Age	sex Sex	unit Unit	geo Geo	n_2021 2021	n_2023 2023
Annual	Persons in the labour force	EU27 countries (from 2020) except reporting country	Education or training	From 15 to 64 years	Females	Thousand persons	Austria	20	29.7
Annual	Persons in the labour force	EU27 countries (from 2020) except reporting country	Education or training	From 15 to 64 years	Females	Thousand persons	Bosnia and Herzegovina
Annual	Persons in the labour force	EU27 countries (from 2020) except reporting country	Education or training	From 15 to 64 years	Females	Thousand persons	Belgium	14.1	22.2
Annual	Persons in the labour force	EU27 countries (from 2020) except reporting country	Education or training	From 15 to 64 years	Females	Thousand persons	Switzerland	16.8	18.5
Annual	Persons in the labour force	EU27 countries (from 2020) except reporting country	Education or training	From 15 to 64 years	Females	Thousand persons	Cyprus
Annual	Persons in the labour force	EU27 countries (from 2020) except reporting country	Education or training	From 15 to 64 years	Females	Thousand persons	Czechia	3.3	5.4
Annual	Persons in the labour force	EU27 countries (from 2020) except reporting country	Education or training	From 15 to 64 years	Females	Thousand persons	Germany	34.9	62.4
Annual	Persons in the labour force	EU27 countries (from 2020) except reporting country	Education or training	From 15 to 64 years	Females	Thousand persons	Denmark	4.8	7.6
Annual	Persons in the labour force	EU27 countries (from 2020) except reporting country	Education or training	From 15 to 64 years	Females	Thousand persons	Euro area – 20 countries (from 2023)	157.9	216.2
Annual	Persons in the labour force	EU27 countries (from 2020) except reporting country	Education or training	From 15 to 64 years	Females	Thousand persons	Greece


CREATE TABLE raw (
  "freq" VARCHAR,
  "wstatus" VARCHAR,
  "citizen" VARCHAR,
  "reason" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2021" DOUBLE,
  "n_2023" DOUBLE
);

Share link

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