In-work At-risk-of-poverty Rate By Full-/part-time Work

Eurostat code: ilc_iw07 · (2003 - 2024)

@eurostat.ilc_iw07

Table List

2 tables(32.99 KB)

In-work At-risk-of-poverty Rate By Full-/part-time Work - Raw

In-work At-risk-of-poverty Rate By Full-/part-time Work - Unpivoted

In-work At-risk-of-poverty Rate By Full-/part-time Work - Unpivoted

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

8.67 KB
1554 rows
6 columns

freq Freq	worktime Worktime	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Full-time	Percentage	Austria	2003	7.5
Annual	Full-time	Percentage	Belgium	2003	6.2
Annual	Full-time	Percentage	Denmark	2003	3.9
Annual	Full-time	Percentage	Greece	2003	12.5
Annual	Full-time	Percentage	Ireland	2003	6
Annual	Full-time	Percentage	Luxembourg	2003	6.8
Annual	Full-time	Percentage	Norway	2003	3.8
Annual	Part-time	Percentage	Austria	2003	15.4
Annual	Part-time	Percentage	Belgium	2003	7
Annual	Part-time	Percentage	Greece	2003	26.1


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

Share link

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