Employees By Sex, Age, Migration Status And Type Of Employment Contract

Eurostat code: lfsa_eegatm · (2021 - 2024)

@eurostat.lfsa_eegatm

Table List

2 tables(633.7 KB)

Employees By Sex, Age, Migration Status And Type Of Employment Contract - Raw

Employees By Sex, Age, Migration Status And Type Of Employment Contract - Unpivoted

Employees By Sex, Age, Migration Status And Type Of Employment Contract - Unpivoted

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

295.49 KB
88332 rows
9 columns

freq Freq	emp_cont Emp Cont	mgstatus Mgstatus	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Limited duration	Foreign-born (first generation)	From 15 to 24 years	Females	Thousand persons	Austria	2021	7.3
Annual	Limited duration	Foreign-born (first generation)	From 15 to 24 years	Females	Thousand persons	Belgium	2021	8.2
Annual	Limited duration	Foreign-born (first generation)	From 15 to 24 years	Females	Thousand persons	Switzerland	2021	19.6
Annual	Limited duration	Foreign-born (first generation)	From 15 to 24 years	Females	Thousand persons	Cyprus	2021	2.3
Annual	Limited duration	Foreign-born (first generation)	From 15 to 24 years	Females	Thousand persons	Czechia	2021	1.4
Annual	Limited duration	Foreign-born (first generation)	From 15 to 24 years	Females	Thousand persons	Germany	2021	77.6
Annual	Limited duration	Foreign-born (first generation)	From 15 to 24 years	Females	Thousand persons	Denmark	2021	4.2
Annual	Limited duration	Foreign-born (first generation)	From 15 to 24 years	Females	Thousand persons	Euro area – 20 countries (from 2023)	2021	256.1
Annual	Limited duration	Foreign-born (first generation)	From 15 to 24 years	Females	Thousand persons	Spain	2021	60.2
Annual	Limited duration	Foreign-born (first generation)	From 15 to 24 years	Females	Thousand persons	European Union - 27 countries (from 2020)	2021	286


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