Name: Persons By Risk Of Poverty, Material Deprivation, Work Intensity Of The Household And Educational Attainment Level (population Aged 18 And Over) - Intersections Of EU 2020 Strategy Poverty Target Indicators
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

Persons By Risk Of Poverty, Material Deprivation, Work Intensity Of The Household And Educational Attainment Level (population Aged 18 And Over) - Intersections Of EU 2020 Strategy Poverty Target Indicators

This Eurostat dataset contains data on persons by risk of poverty, material deprivation, work intensity of the household and educational attainment level (population aged 18 and over) - intersections of eu 2020 strategy poverty target indicators, 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-07-18T11:00:00+0200

Tables

Persons By Risk Of Poverty, Material Deprivation, Work Intensity Of The Household And Educational Attainment Level (population Aged 18 And Over) - Intersections Of EU 2020 Strategy Poverty Target Indicators - Raw

@eurostat.ilc_pees05.raw

40.86 KB
1080 rows
20 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "yn_rskpov" VARCHAR,
  "lev_depr" VARCHAR,
  "workint" VARCHAR,
  "isced11" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "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
);

Persons By Risk Of Poverty, Material Deprivation, Work Intensity Of The Household And Educational Attainment Level (population Aged 18 And Over) - Intersections Of EU 2020 Strategy Poverty Target Indicators - Unpivoted

@eurostat.ilc_pees05.tidy

26.65 KB
12048 rows
9 columns


CREATE TABLE tidy (
  "freq" VARCHAR,
  "yn_rskpov" VARCHAR,
  "lev_depr" VARCHAR,
  "workint" VARCHAR,
  "isced11" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);