In Work At-risk-of-poverty Rate

Eurostat code: sdg_01_41 · (2003 - 2024)

@eurostat.sdg_01_41

Table List

2 tables(29.88 KB)

In Work At-risk-of-poverty Rate - Unpivoted

In Work At-risk-of-poverty Rate - Unpivoted

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

7.92 KB
749 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	18 years or over	Percentage	Austria	2003	7.7
Annual	Employed persons	Total	18 years or over	Percentage	Belgium	2003	6.5
Annual	Employed persons	Total	18 years or over	Percentage	Denmark	2003	4.5
Annual	Employed persons	Total	18 years or over	Percentage	Greece	2003	13.5
Annual	Employed persons	Total	18 years or over	Percentage	Ireland	2003	7.5
Annual	Employed persons	Total	18 years or over	Percentage	Luxembourg	2003	7.1
Annual	Employed persons	Total	18 years or over	Percentage	Norway	2003	4.4
Annual	Employed persons	Total	18 years or over	Percentage	Austria	2004	7.3
Annual	Employed persons	Total	18 years or over	Percentage	Belgium	2004	4
Annual	Employed persons	Total	18 years or over	Percentage	Denmark	2004	4.8


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.