Name: Persons By Risk Of Poverty, Material Deprivation, Work Intensity Of The Household, Age And Sex Of The Person - 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, Age And Sex Of The Person - 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, age and sex of the person - 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, Age And Sex Of The Person - Intersections Of EU 2020 Strategy Poverty Target Indicators - Raw

@eurostat.ilc_pees01.raw

574.84 KB
23664 rows
21 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "yn_rskpov" VARCHAR,
  "lev_depr" VARCHAR,
  "workint" VARCHAR,
  "age" VARCHAR,
  "sex" 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, Age And Sex Of The Person - Intersections Of EU 2020 Strategy Poverty Target Indicators - Unpivoted

@eurostat.ilc_pees01.tidy

507.07 KB
259200 rows
10 columns


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