Baselight

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 - Raw
@eurostat.ilc_li03.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

  • 233.34 KB
  • 6231 rows
  • 35 columns
freq

Freq

indic_il

Indic Il

hhtyp

Hhtyp

unit

Unit

geo

Geo

n_1995

1995

n_1996

1996

n_1997

1997

n_1998

1998

n_1999

1999

n_2000

2000

n_2001

2001

n_2002

2002

n_2003

2003

n_2004

2004

n_2005

2005

n_2006

2006

n_2007

2007

n_2008

2008

n_2009

2009

n_2010

2010

n_2011

2011

n_2012

2012

n_2013

2013

n_2014

2014

n_2015

2015

n_2016

2016

n_2017

2017

n_2018

2018

n_2019

2019

n_2020

2020

n_2021

2021

n_2022

2022

n_2023

2023

n_2024

2024

AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageAlbania6129.69.38.8
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageAustria10108697610.29.97.78.27.11010.311.911.710.49.411.28.59.510.89.610.38.58.99.910.3
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageBelgium9106710878.77.76.27.16.97.44.84.55.45.67.24.855.54.65.75.47.35.35.94.44.2
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageBulgaria14.921.934.33633.434.2262616.627.219.130.427.334.734.631.635.913.517.2
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageSwitzerland11.313.313.811.211.513.212.511.810.411.7121111.811.412.71312.6
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageCyprus32.329.329.823.219.42117.117.512.716.213.913.810.58.18.810.77.77.19.19.9
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageCzechia6.454.454.94.55.14.23.74.15.55.65.45.45.54.95.25.44.73.6
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageGermany141210121099.1914.416.516.815.61817.417.217.618.518.817.417.917.915.41513.514.115
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageDenmark10.49.29.49.38.49.710.810.811.710.913.313.911.912.311.811.61211.210.8121112.3
AnnualAt risk of poverty rate (cut-off point: 40% of mean equivalised income)Single personPercentageEuro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)12.412.512.113.412.812.612.61313.713.413.113.313.213.3

CREATE TABLE raw (
  "freq" VARCHAR,
  "indic_il" VARCHAR,
  "hhtyp" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1995" DOUBLE,
  "n_1996" DOUBLE,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "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,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE,
  "n_2024" DOUBLE
);

Share link

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