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

Eurostat code: ilc_iw16$dv_1991

@eurostat.ilc_iw16_dv_1991

Table List

2 tables(72.57 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_dv_1991.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.

29.73 KB
15193 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 (from 2020) except reporting country	Females	From 16 to 29 years	Austria	2015	16.8
Annual	Percentage	EU27 countries (from 2020) except reporting country	Females	From 16 to 29 years	Switzerland	2015	15.2
Annual	Percentage	EU27 countries (from 2020) except reporting country	Females	From 16 to 29 years	Cyprus	2015	24.4
Annual	Percentage	EU27 countries (from 2020) except reporting country	Females	From 16 to 29 years	Spain	2015	6.1
Annual	Percentage	EU27 countries (from 2020) except reporting country	Females	From 16 to 29 years	Ireland	2015	3.2
Annual	Percentage	EU27 countries (from 2020) except reporting country	Females	From 16 to 29 years	Iceland	2015	11.4
Annual	Percentage	EU27 countries (from 2020) except reporting country	Females	From 16 to 29 years	Italy	2015	29.5
Annual	Percentage	EU27 countries (from 2020) except reporting country	Females	From 16 to 29 years	Luxembourg	2015	10.3
Annual	Percentage	EU27 countries (from 2020) except reporting country	Females	From 16 to 29 years	United Kingdom	2015	13.5
Annual	Percentage	EU27 countries (from 2020) except reporting country	Females	From 18 to 54 years	Austria	2015	16.9


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.