Name: Unemployed By Sex, Age And Type Of Employment Sought (1–000)
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

Unemployed By Sex, Age And Type Of Employment Sought (1–000)

This Eurostat dataset contains data on unemployed by sex, age and type of employment sought (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: 2024-12-12T23:00:00+0100

Tables

Unemployed By Sex, Age And Type Of Employment Sought (1–000) - Raw

@eurostat.lfsq_ugates.raw

2.04 MB
11,642 rows
98 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "empsough" VARCHAR,
  "geo" VARCHAR,
  "n_1998_q1" DOUBLE  -- 1998-Q1,
  "n_1998_q2" DOUBLE  -- 1998-Q2,
  "n_1998_q3" DOUBLE  -- 1998-Q3,
  "n_1998_q4" DOUBLE  -- 1998-Q4,
  "n_1999_q1" DOUBLE  -- 1999-Q1,
  "n_1999_q2" DOUBLE  -- 1999-Q2,
  "n_1999_q3" DOUBLE  -- 1999-Q3,
  "n_1999_q4" DOUBLE  -- 1999-Q4,
  "n_2000_q1" DOUBLE  -- 2000-Q1,
  "n_2000_q2" DOUBLE  -- 2000-Q2,
  "n_2000_q3" DOUBLE  -- 2000-Q3,
  "n_2000_q4" DOUBLE  -- 2000-Q4,
  "n_2001_q1" DOUBLE  -- 2001-Q1,
  "n_2001_q2" DOUBLE  -- 2001-Q2,
  "n_2001_q3" DOUBLE  -- 2001-Q3,
  "n_2001_q4" DOUBLE  -- 2001-Q4,
  "n_2002_q1" DOUBLE  -- 2002-Q1,
  "n_2002_q2" DOUBLE  -- 2002-Q2,
  "n_2002_q3" DOUBLE  -- 2002-Q3,
  "n_2002_q4" DOUBLE  -- 2002-Q4,
  "n_2003_q1" DOUBLE  -- 2003-Q1,
  "n_2003_q2" DOUBLE  -- 2003-Q2,
  "n_2003_q3" DOUBLE  -- 2003-Q3,
  "n_2003_q4" DOUBLE  -- 2003-Q4,
  "n_2004_q1" DOUBLE  -- 2004-Q1,
  "n_2004_q2" DOUBLE  -- 2004-Q2,
  "n_2004_q3" DOUBLE  -- 2004-Q3,
  "n_2004_q4" DOUBLE  -- 2004-Q4,
  "n_2005_q1" DOUBLE  -- 2005-Q1,
  "n_2005_q2" DOUBLE  -- 2005-Q2,
  "n_2005_q3" DOUBLE  -- 2005-Q3,
  "n_2005_q4" DOUBLE  -- 2005-Q4,
  "n_2006_q1" DOUBLE  -- 2006-Q1,
  "n_2006_q2" DOUBLE  -- 2006-Q2,
  "n_2006_q3" DOUBLE  -- 2006-Q3,
  "n_2006_q4" DOUBLE  -- 2006-Q4,
  "n_2007_q1" DOUBLE  -- 2007-Q1,
  "n_2007_q2" DOUBLE  -- 2007-Q2,
  "n_2007_q3" DOUBLE  -- 2007-Q3,
  "n_2007_q4" DOUBLE  -- 2007-Q4,
  "n_2008_q1" DOUBLE  -- 2008-Q1,
  "n_2008_q2" DOUBLE  -- 2008-Q2,
  "n_2008_q3" DOUBLE  -- 2008-Q3,
  "n_2008_q4" DOUBLE  -- 2008-Q4,
  "n_2009_q1" DOUBLE  -- 2009-Q1,
  "n_2009_q2" DOUBLE  -- 2009-Q2,
  "n_2009_q3" DOUBLE  -- 2009-Q3,
  "n_2009_q4" DOUBLE  -- 2009-Q4,
  "n_2010_q1" DOUBLE  -- 2010-Q1,
  "n_2010_q2" DOUBLE  -- 2010-Q2,
  "n_2010_q3" DOUBLE  -- 2010-Q3,
  "n_2010_q4" DOUBLE  -- 2010-Q4,
  "n_2011_q1" DOUBLE  -- 2011-Q1,
  "n_2011_q2" DOUBLE  -- 2011-Q2,
  "n_2011_q3" DOUBLE  -- 2011-Q3,
  "n_2011_q4" DOUBLE  -- 2011-Q4,
  "n_2012_q1" DOUBLE  -- 2012-Q1,
  "n_2012_q2" DOUBLE  -- 2012-Q2,
  "n_2012_q3" DOUBLE  -- 2012-Q3,
  "n_2012_q4" DOUBLE  -- 2012-Q4,
  "n_2013_q1" DOUBLE  -- 2013-Q1,
  "n_2013_q2" DOUBLE  -- 2013-Q2,
  "n_2013_q3" DOUBLE  -- 2013-Q3,
  "n_2013_q4" DOUBLE  -- 2013-Q4,
  "n_2014_q1" DOUBLE  -- 2014-Q1,
  "n_2014_q2" DOUBLE  -- 2014-Q2,
  "n_2014_q3" DOUBLE  -- 2014-Q3,
  "n_2014_q4" DOUBLE  -- 2014-Q4,
  "n_2015_q1" DOUBLE  -- 2015-Q1,
  "n_2015_q2" DOUBLE  -- 2015-Q2,
  "n_2015_q3" DOUBLE  -- 2015-Q3,
  "n_2015_q4" DOUBLE  -- 2015-Q4,
  "n_2016_q1" DOUBLE  -- 2016-Q1,
  "n_2016_q2" DOUBLE  -- 2016-Q2,
  "n_2016_q3" DOUBLE  -- 2016-Q3,
  "n_2016_q4" DOUBLE  -- 2016-Q4,
  "n_2017_q1" DOUBLE  -- 2017-Q1,
  "n_2017_q2" DOUBLE  -- 2017-Q2,
  "n_2017_q3" DOUBLE  -- 2017-Q3,
  "n_2017_q4" DOUBLE  -- 2017-Q4,
  "n_2018_q1" DOUBLE  -- 2018-Q1,
  "n_2018_q2" DOUBLE  -- 2018-Q2,
  "n_2018_q3" DOUBLE  -- 2018-Q3,
  "n_2018_q4" DOUBLE  -- 2018-Q4,
  "n_2019_q1" DOUBLE  -- 2019-Q1,
  "n_2019_q2" DOUBLE  -- 2019-Q2,
  "n_2019_q3" DOUBLE  -- 2019-Q3,
  "n_2019_q4" DOUBLE  -- 2019-Q4,
  "n_2020_q1" DOUBLE  -- 2020-Q1,
  "n_2020_q2" DOUBLE  -- 2020-Q2,
  "n_2020_q3" DOUBLE  -- 2020-Q3,
  "n_2020_q4" DOUBLE  -- 2020-Q4
);

Unemployed By Sex, Age And Type Of Employment Sought (1–000) - Unpivoted

@eurostat.lfsq_ugates.tidy

1.53 MB
562,931 rows
8 columns

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