In-work At-risk-of-poverty Rate By Group Of Country Of Birth (population Aged 18 And Over)

Eurostat code: ilc_iw16 · (2003 - 2024)

@eurostat.ilc_iw16

Table List

2 tables(360.72 KB)

In-work At-risk-of-poverty Rate By Group Of Country Of Birth (population Aged 18 And Over) - Raw

In-work At-risk-of-poverty Rate By Group Of Country Of Birth (population Aged 18 And Over) - Unpivoted

In-work At-risk-of-poverty Rate By Group Of Country Of Birth (population Aged 18 And Over) - Unpivoted

@eurostat.ilc_iw16.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.6 KB
111848 rows
8 columns

freq Freq	unit Unit	c_birth C Birth	sex Sex	age Age	geo Geo	time_period Time Period	value Value
Annual	Percentage	EU27 countries (2007-2013) except reporting country	Females	From 16 to 29 years	Belgium	2003
Annual	Percentage	EU27 countries (2007-2013) except reporting country	Females	From 16 to 29 years	Luxembourg	2003	4.1
Annual	Percentage	EU27 countries (2007-2013) except reporting country	Females	From 18 to 54 years	Austria	2003	4.8
Annual	Percentage	EU27 countries (2007-2013) except reporting country	Females	From 18 to 54 years	Belgium	2003	6.9
Annual	Percentage	EU27 countries (2007-2013) except reporting country	Females	From 18 to 54 years	Denmark	2003	4.5
Annual	Percentage	EU27 countries (2007-2013) except reporting country	Females	From 18 to 54 years	Greece	2003	7.7
Annual	Percentage	EU27 countries (2007-2013) except reporting country	Females	From 18 to 54 years	Ireland	2003	7.1
Annual	Percentage	EU27 countries (2007-2013) except reporting country	Females	From 18 to 54 years	Luxembourg	2003	6
Annual	Percentage	EU27 countries (2007-2013) except reporting country	Females	From 18 to 54 years	Norway	2003	5.7
Annual	Percentage	EU27 countries (2007-2013) except reporting country	Females	From 18 to 59 years	Austria	2003	4.7


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

Share link

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