Employment By Sex, Age, Migration Status, Professional Status And Full/part Time

Eurostat code: lfsa_egaftsm · (2021 - 2024)

@eurostat.lfsa_egaftsm

Table List

2 tables(1.7 MB)

Employment By Sex, Age, Migration Status, Professional Status And Full/part Time - Raw

Employment By Sex, Age, Migration Status, Professional Status And Full/part Time - Unpivoted

Employment By Sex, Age, Migration Status, Professional Status And Full/part Time - Unpivoted

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

861.48 KB
270785 rows
10 columns

freq Freq	worktime Worktime	wstatus Wstatus	mgstatus Mgstatus	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Full-time	Contributing family workers	Foreign-born (first generation)	From 15 to 24 years	Males	Thousand persons	Spain	2021	1.8
Annual	Full-time	Contributing family workers	Foreign-born (first generation)	From 15 to 24 years	Males	Thousand persons	Türkiye	2021	2.1
Annual	Full-time	Contributing family workers	Foreign-born (first generation)	From 15 to 24 years	Total	Thousand persons	Spain	2021	2.5
Annual	Full-time	Contributing family workers	Foreign-born (first generation)	From 15 to 24 years	Total	Thousand persons	Türkiye	2021	2.6
Annual	Full-time	Contributing family workers	Foreign-born (first generation)	From 15 to 29 years	Females	Thousand persons	Spain	2021	1.7
Annual	Full-time	Contributing family workers	Foreign-born (first generation)	From 15 to 29 years	Females	Thousand persons	Türkiye	2021	0.5
Annual	Full-time	Contributing family workers	Foreign-born (first generation)	From 15 to 29 years	Males	Thousand persons	Switzerland	2021	1.1
Annual	Full-time	Contributing family workers	Foreign-born (first generation)	From 15 to 29 years	Males	Thousand persons	Spain	2021	2.4
Annual	Full-time	Contributing family workers	Foreign-born (first generation)	From 15 to 29 years	Males	Thousand persons	Türkiye	2021	2.7
Annual	Full-time	Contributing family workers	Foreign-born (first generation)	From 15 to 29 years	Total	Thousand persons	Switzerland	2021	1.6


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