Baselight

Involuntary Temporary Employment

Eurostat code: tesem190 · (2005 - 2024)

@eurostat.tesem190

Involuntary Temporary Employment - Unpivoted
@eurostat.tesem190.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.

  • 8.26 KB
  • 832 rows
  • 8 columns
freq

Freq

unit

Unit

sex

Sex

age

Age

reason

Reason

geo

Geo

time_period

Time Period

value

Value

AnnualPercentage of employeesTotalFrom 15 to 64 yearsNo permanent job foundBelgium20055.9
AnnualPercentage of employeesTotalFrom 15 to 64 yearsNo permanent job foundBulgaria20053.7
AnnualPercentage of employeesTotalFrom 15 to 64 yearsNo permanent job foundCyprus200512.7
AnnualPercentage of employeesTotalFrom 15 to 64 yearsNo permanent job foundCzechia20055.5
AnnualPercentage of employeesTotalFrom 15 to 64 yearsNo permanent job foundGermany20052.3
AnnualPercentage of employeesTotalFrom 15 to 64 yearsNo permanent job foundDenmark20054.8
AnnualPercentage of employeesTotalFrom 15 to 64 yearsNo permanent job foundEuro area – 20 countries (from 2023)20054.8
AnnualPercentage of employeesTotalFrom 15 to 64 yearsNo permanent job foundEstonia20051.3
AnnualPercentage of employeesTotalFrom 15 to 64 yearsNo permanent job foundGreece20058.6
AnnualPercentage of employeesTotalFrom 15 to 64 yearsNo permanent job foundEuropean Union - 27 countries (from 2020)20055.3

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "reason" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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