Baselight
Sign In

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

Eurostat code: lfsa_pfganwsm · (2021 - 2023)

@eurostat.lfsa_pfganwsm

Foreign-born Population By Sex, Age, Main Reason For Migrating, Citizenship And Labour Status - Unpivoted
@eurostat.lfsa_pfganwsm.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.

  • 331.3 KB
  • 118643 rows
  • 10 columns
freq

Freq

wstatus

Wstatus

citizen

Citizen

reason

Reason

age

Age

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualPersons in the labour forceEU27 countries (from 2020) except reporting countryEducation or trainingFrom 15 to 64 yearsFemalesThousand personsAustria202120
AnnualPersons in the labour forceEU27 countries (from 2020) except reporting countryEducation or trainingFrom 15 to 64 yearsFemalesThousand personsBelgium202114.1
AnnualPersons in the labour forceEU27 countries (from 2020) except reporting countryEducation or trainingFrom 15 to 64 yearsFemalesThousand personsSwitzerland202116.8
AnnualPersons in the labour forceEU27 countries (from 2020) except reporting countryEducation or trainingFrom 15 to 64 yearsFemalesThousand personsCzechia20213.3
AnnualPersons in the labour forceEU27 countries (from 2020) except reporting countryEducation or trainingFrom 15 to 64 yearsFemalesThousand personsGermany202134.9
AnnualPersons in the labour forceEU27 countries (from 2020) except reporting countryEducation or trainingFrom 15 to 64 yearsFemalesThousand personsDenmark20214.8
AnnualPersons in the labour forceEU27 countries (from 2020) except reporting countryEducation or trainingFrom 15 to 64 yearsFemalesThousand personsEuro area – 20 countries (from 2023)2021157.9
AnnualPersons in the labour forceEU27 countries (from 2020) except reporting countryEducation or trainingFrom 15 to 64 yearsFemalesThousand personsSpain202118.4
AnnualPersons in the labour forceEU27 countries (from 2020) except reporting countryEducation or trainingFrom 15 to 64 yearsFemalesThousand personsEuropean Union - 27 countries (from 2020)2021179.7
AnnualPersons in the labour forceEU27 countries (from 2020) except reporting countryEducation or trainingFrom 15 to 64 yearsFemalesThousand personsFinland20212.2

CREATE TABLE tidy (
  "freq" VARCHAR,
  "wstatus" VARCHAR,
  "citizen" VARCHAR,
  "reason" 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.