Name: Persons By Risk Of Poverty, Material Deprivation, Work Intensity Of The Household And Country Of Birth (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 Country Of Birth (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 country of birth (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 Country Of Birth (population Aged 18 And Over) - Intersections Of EU 2020 Strategy Poverty Target Indicators - Raw

@eurostat.ilc_pees07.raw

63.43 KB
2736 rows
20 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "yn_rskpov" VARCHAR,
  "lev_depr" VARCHAR,
  "workint" VARCHAR,
  "c_birth" 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 Country Of Birth (population Aged 18 And Over) - Intersections Of EU 2020 Strategy Poverty Target Indicators - Unpivoted

@eurostat.ilc_pees07.tidy

42.79 KB
24088 rows
9 columns


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