Baselight

Employment Rate Of EU/EFTA Citizens Who Usually Reside In Another EU/EFTA Country By Citizenship, Age And Educational Attainment Level

Eurostat code: lfst_lmbercited ยท (1995 - 2024)

@eurostat.lfst_lmbercited

Employment Rate Of EU/EFTA Citizens Who Usually Reside In Another EU/EFTA Country By Citizenship, Age And Educational Attainment Level - Unpivoted
@eurostat.lfst_lmbercited.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.

  • 49.99 KB
  • 26457 rows
  • 8 columns
freq

Freq

unit

Unit

age

Age

c_resid

C Resid

isced11

Isced11

citizen

Citizen

time_period

Time Period

value

Value

AnnualPercentageFrom 15 to 64 yearsEuropean Union - 27 countries (from 2020)Less than primary, primary and lower secondary education (levels 0-2)Austria199554.1
AnnualPercentageFrom 15 to 64 yearsEuropean Union - 27 countries (from 2020)Less than primary, primary and lower secondary education (levels 0-2)Greece199563.3
AnnualPercentageFrom 15 to 64 yearsEuropean Union - 27 countries (from 2020)Less than primary, primary and lower secondary education (levels 0-2)Spain199548.7
AnnualPercentageFrom 15 to 64 yearsEuropean Union - 27 countries (from 2020)Less than primary, primary and lower secondary education (levels 0-2)EU27 countries (from 2020) or EFTA countries except reporting country199557.8
AnnualPercentageFrom 15 to 64 yearsEuropean Union - 27 countries (from 2020)Less than primary, primary and lower secondary education (levels 0-2)EU27 countries (from 2020) except reporting country199557.9
AnnualPercentageFrom 15 to 64 yearsEuropean Union - 27 countries (from 2020)Less than primary, primary and lower secondary education (levels 0-2)France199545.8
AnnualPercentageFrom 15 to 64 yearsEuropean Union - 27 countries (from 2020)Less than primary, primary and lower secondary education (levels 0-2)Italy199555.3
AnnualPercentageFrom 15 to 64 yearsEuropean Union - 27 countries (from 2020)Less than primary, primary and lower secondary education (levels 0-2)Reporting country199545
AnnualPercentageFrom 15 to 64 yearsEuropean Union - 27 countries (from 2020)Less than primary, primary and lower secondary education (levels 0-2)Non-EU27 countries (from 2020) nor EFTA countries199544.1
AnnualPercentageFrom 15 to 64 yearsEuropean Union - 27 countries (from 2020)Less than primary, primary and lower secondary education (levels 0-2)Netherlands199542.1

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "age" VARCHAR,
  "c_resid" VARCHAR,
  "isced11" VARCHAR,
  "citizen" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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