At-risk-of-poverty Rate By Poverty Threshold And Most Frequent Activity In The Previous Year

Eurostat code: ilc_li04 · (1995 - 2024)

@eurostat.ilc_li04

Table List

2 tables(1.81 MB)

At-risk-of-poverty Rate By Poverty Threshold And Most Frequent Activity In The Previous Year - Raw

At-risk-of-poverty Rate By Poverty Threshold And Most Frequent Activity In The Previous Year - Unpivoted

At-risk-of-poverty Rate By Poverty Threshold And Most Frequent Activity In The Previous Year - Raw

@eurostat.ilc_li04.raw

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

976.51 KB
38345 rows
37 columns

freq Freq	wstatus Wstatus	indic_il Indic Il	sex Sex	age Age	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_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
Annual	Employed persons	At risk of poverty rate (cut-off point: 40% of mean equivalised income)	Females	From 16 to 64 years	Percentage	Albania																						11.6	9.8	6.9	5.7	5.2
Annual	Employed persons	At risk of poverty rate (cut-off point: 40% of mean equivalised income)	Females	From 16 to 64 years	Percentage	Austria	4	3	2	3	3	2	3	3.2	3.2	2.5	2.3	1.9	3.1	3	3.2	2.4	3.4	3.4	2.7	3	2.4	3.4	2.6	3.5	3.1	3.4	3.1	2.8
Annual	Employed persons	At risk of poverty rate (cut-off point: 40% of mean equivalised income)	Females	From 16 to 64 years	Percentage	Belgium	3	2	2	2	2	2	1	2.3	1.2	1.1	1.5	1.4	1.7	1.4	1.3	1	1.4	1.3	1.3	1.4	0.8	1.2	1	1.1	1.2	0.8	0.6	0.6	0.7
Annual	Employed persons	At risk of poverty rate (cut-off point: 40% of mean equivalised income)	Females	From 16 to 64 years	Percentage	Bulgaria											2.5	2.9	3.8	3.4	3.1	3.7	2.4	3.2	5.5	4	6.4	5.7	6	6.3	5.6	5.6	4.9	5.9	6.1
Annual	Employed persons	At risk of poverty rate (cut-off point: 40% of mean equivalised income)	Females	From 16 to 64 years	Percentage	Switzerland												4	4.1	4	3.6	3.2	3.1	2.6	2.7	3.7	3.1	3.6	2.8	3	3	3.5	3.6	4.2
Annual	Employed persons	At risk of poverty rate (cut-off point: 40% of mean equivalised income)	Females	From 16 to 64 years	Percentage	Cyprus										2.7	3.1	2.6	2.7	3.5	4.9	4	4.3	4.6	4.1	4	3.7	2.4	1.8	2.2	2.3	2.5	2.4	2	3.3
Annual	Employed persons	At risk of poverty rate (cut-off point: 40% of mean equivalised income)	Females	From 16 to 64 years	Percentage	Czechia										0.5	0.8	0.9	0.9	1.1	1.2	1.2	1.5	1.1	1.1	0.9	1.1	0.9	0.9	0.7	1	1.2	0.9	0.9	0.8
Annual	Employed persons	At risk of poverty rate (cut-off point: 40% of mean equivalised income)	Females	From 16 to 64 years	Percentage	Germany	3	3	2	2	1	2				1.9	2.9	3.3	3.5	3	2.6	3.5	3.4	3.7	4.8	4.6	4	3.8	4	3.3	4.1	4	3	2.5	2.4
Annual	Employed persons	At risk of poverty rate (cut-off point: 40% of mean equivalised income)	Females	From 16 to 64 years	Percentage	Denmark								1.6	1.4	2.2	1.2	1.5	1.7	1.8	3.2	2.6	1.7	2.8	2	1.7	2.9	2.1	3.1	3.3	2.4	2.8	2.1	3.2	2.7
Annual	Employed persons	At risk of poverty rate (cut-off point: 40% of mean equivalised income)	Females	From 16 to 64 years	Percentage	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)													3.5	3.4	3.2	3.7	3.7	3.8	4.2	4.1	4.1	4.1	3.9	3.7	3.7	3.6


CREATE TABLE raw (
  "freq" VARCHAR,
  "wstatus" VARCHAR,
  "indic_il" VARCHAR,
  "sex" VARCHAR,
  "age" 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
);