Name: Persons By Risk Of Poverty, Material Deprivation, Work Intensity Of The Household, Age And Sex Of The Person - Intersections Of EU 2030 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 2030 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 2030 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-24T23: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 2030 Poverty Target Indicators - Raw

@eurostat.ilc_pees01n.raw

441.15 KB
23232 rows
18 columns


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

Persons By Risk Of Poverty, Material Deprivation, Work Intensity Of The Household, Age And Sex Of The Person - Intersections Of EU 2030 Poverty Target Indicators - Unpivoted

@eurostat.ilc_pees01n.tidy

379.39 KB
199056 rows
10 columns


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