Baselight

In-work At-risk-of-poverty Rate By Household Type

Eurostat code: ilc_iw02 ยท (2003 - 2024)

@eurostat.ilc_iw02

In-work At-risk-of-poverty Rate By Household Type - Raw
@eurostat.ilc_iw02.raw

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

  • 33.75 KB
  • 270 rows
  • 26 columns
freq

Freq

hhtyp

Hhtyp

unit

Unit

geo

Geo

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

AnnualSingle personPercentageAlbania4.32.63.12.75.7
AnnualSingle personPercentageAustria11.1139.29.98.211.41412.111.511.21111.810.41011.910.811.81110.410.913.1
AnnualSingle personPercentageBelgium10.34.85.25.15.25.86.44.16.44.96.65.46.66.96.17.27.26.76.84.68.36.7
AnnualSingle personPercentageBulgaria3.76.19.410.812.21210.38.37.67.515.61011.612.612.51312.114.514.9
AnnualSingle personPercentageSwitzerland8.99.288.38.610.59.310.512.48.610.89.19.79.310.210.311.6
AnnualSingle personPercentageCyprus13.412.511.897.711.811.114.110.81012.4128.49.29.9910.1911.312.6
AnnualSingle personPercentageCzechia5.26.65.85.66.55.35.85.96.866.98.276.45.87.475.74.44.9
AnnualSingle personPercentageGermany9.610.111.111.69.211.412.514.615.317.416.41715.113.413.515.814.712.112.112.8
AnnualSingle personPercentageDenmark1011.511.39.28.210.912.812.113.610.613.48.29.910.711.515.614.413.811.813.813.614.8
AnnualSingle personPercentageEuro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)10.410.210.21212.412.713.913.313.613.512.712.713.713.6

CREATE TABLE raw (
  "freq" VARCHAR,
  "hhtyp" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "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.