In-work At-risk-of-poverty Rate By Educational Attainment Level

Eurostat code: ilc_iw04 · (2003 - 2024)

@eurostat.ilc_iw04

Table List

2 tables(37.97 KB)

In-work At-risk-of-poverty Rate By Educational Attainment Level - Raw

In-work At-risk-of-poverty Rate By Educational Attainment Level - Unpivoted

In-work At-risk-of-poverty Rate By Educational Attainment Level - Unpivoted

@eurostat.ilc_iw04.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.

10.2 KB
2331 rows
6 columns

freq Freq	isced11 Isced11	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Percentage	Austria	2003	11.3
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Percentage	Belgium	2003	9.3
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Percentage	Denmark	2003	5.3
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Percentage	Greece	2003	24.4
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Percentage	Ireland	2003	14.6
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Percentage	Luxembourg	2003	12.3
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Percentage	Norway	2003	7
Annual	Upper secondary and post-secondary non-tertiary education (levels 3 and 4)	Percentage	Austria	2003	7.4
Annual	Upper secondary and post-secondary non-tertiary education (levels 3 and 4)	Percentage	Belgium	2003	7.1
Annual	Upper secondary and post-secondary non-tertiary education (levels 3 and 4)	Percentage	Denmark	2003	5


CREATE TABLE tidy (
  "freq" VARCHAR,
  "isced11" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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