In-work At-risk-of-poverty Rate By Age And Sex

Eurostat code: ilc_iw01$dv_1990

@eurostat.ilc_iw01_dv_1990

Table List

2 tables(48.6 KB)

In-work At-risk-of-poverty Rate By Age And Sex - Raw

In-work At-risk-of-poverty Rate By Age And Sex - Unpivoted

In-work At-risk-of-poverty Rate By Age And Sex - Unpivoted

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

18.32 KB
7885 rows
8 columns

freq Freq	wstatus Wstatus	sex Sex	age Age	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Employed persons	Total	From 16 to 29 years	Percentage	Austria	2015	9.7
Annual	Employed persons	Total	From 16 to 29 years	Percentage	Belgium	2015	4.2
Annual	Employed persons	Total	From 16 to 29 years	Percentage	Bulgaria	2015	6.9
Annual	Employed persons	Total	From 16 to 29 years	Percentage	Switzerland	2015	8.4
Annual	Employed persons	Total	From 16 to 29 years	Percentage	Cyprus	2015	13.4
Annual	Employed persons	Total	From 16 to 29 years	Percentage	Czechia	2015	2.7
Annual	Employed persons	Total	From 16 to 29 years	Percentage	Germany	2015	12.9
Annual	Employed persons	Total	From 16 to 29 years	Percentage	Denmark	2015	11.7
Annual	Employed persons	Total	From 16 to 29 years	Percentage	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2015	10.5
Annual	Employed persons	Total	From 16 to 29 years	Percentage	Euro area - 18 countries (2014)	2015	10.5


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

Share link

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