Dataset: Previous Occupations Of The Unemployed, By Sex (1–000)

About this Dataset

Previous Occupations Of The Unemployed, By Sex (1–000)

This Eurostat dataset contains data on previous occupations of the unemployed, by sex (1 000), as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-04-14T23:00:00+0200

Tables

Previous Occupations Of The Unemployed, By Sex (1–000) - Raw

@eurostat.lfsa_ugpis.raw

146.15 KB
1466 rows
38 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "sex" VARCHAR,
  "isco08" VARCHAR,
  "geo" VARCHAR,
  "n_1992" DOUBLE,
  "n_1993" DOUBLE,
  "n_1994" DOUBLE,
  "n_1995" DOUBLE,
  "n_1996" DOUBLE,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE,
  "n_2024" DOUBLE
);

Previous Occupations Of The Unemployed, By Sex (1–000) - Unpivoted

@eurostat.lfsa_ugpis.tidy

84.67 KB
27592 rows
7 columns


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