Baselight
Sign In

At-risk-of-poverty Rate By Poverty Threshold And Household Type

Eurostat code: ilc_li03 ยท (1995 - 2024)

@eurostat.ilc_li03

At-risk-of-poverty Rate By Poverty Threshold And Household Type - Unpivoted
@eurostat.ilc_li03.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.

  • 163.71 KB
  • 114223 rows
  • 7 columns
freq

Freq

indic_il

Indic Il

hhtyp

Hhtyp

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageAustria199510
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageBelgium19959
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageGermany199514
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageGreece199526
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageSpain19959
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageEuropean Union - 15 countries (1995-2004)199513
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageFrance199514
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageIreland19957
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageItaly19958
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageLuxembourg19954

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

Share link

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