Baselight

Persistent-at-risk-of-poverty Rate

Eurostat code: tespm150 ยท (2013 - 2024)

@eurostat.tespm150

Persistent-at-risk-of-poverty Rate - Unpivoted
@eurostat.tespm150.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

  • 10.69 KB
  • 2011 rows
  • 8 columns
freq

Freq

indic_il

Indic Il

sex

Sex

unit

Unit

age

Age

geo

Geo

time_period

Time Period

value

Value

AnnualAt persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)TotalPercentageFrom 18 to 24 yearsAustria20136
AnnualAt persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)TotalPercentageFrom 18 to 24 yearsBelgium20136.4
AnnualAt persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)TotalPercentageFrom 18 to 24 yearsBulgaria201311.2
AnnualAt persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)TotalPercentageFrom 18 to 24 yearsSwitzerland20134.4
AnnualAt persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)TotalPercentageFrom 18 to 24 yearsCyprus20136.5
AnnualAt persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)TotalPercentageFrom 18 to 24 yearsCzechia20137.1
AnnualAt persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)TotalPercentageFrom 18 to 24 yearsGermany20137.5
AnnualAt persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)TotalPercentageFrom 18 to 24 yearsDenmark20136.3
AnnualAt persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)TotalPercentageFrom 18 to 24 yearsEuro area - 19 countries (2015-2022)201312.8
AnnualAt persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)TotalPercentageFrom 18 to 24 yearsEstonia201313

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

Share link

Anyone who has the link will be able to view this.