In-work At-risk-of-poverty Rate By Type Of Contract

Eurostat code: ilc_iw05 · (2003 - 2024)

@eurostat.ilc_iw05

Table List

2 tables(47.59 KB)

In-work At-risk-of-poverty Rate By Type Of Contract - Raw

In-work At-risk-of-poverty Rate By Type Of Contract - Unpivoted

In-work At-risk-of-poverty Rate By Type Of Contract - Unpivoted

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

13.52 KB
4629 rows
7 columns

freq Freq	sex Sex	wstatus Wstatus	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Females	Employees with a permanent job	Percentage	Austria	2003	5.5
Annual	Females	Employees with a permanent job	Percentage	Belgium	2003	3.4
Annual	Females	Employees with a permanent job	Percentage	Denmark	2003	2.6
Annual	Females	Employees with a permanent job	Percentage	Greece	2003	2.1
Annual	Females	Employees with a permanent job	Percentage	Ireland	2003	3.2
Annual	Females	Employees with a permanent job	Percentage	Luxembourg	2003	6.4
Annual	Females	Employees with a permanent job	Percentage	Norway	2003	2.5
Annual	Females	Employees with a temporary job	Percentage	Austria	2003	7.6
Annual	Females	Employees with a temporary job	Percentage	Belgium	2003	7.4
Annual	Females	Employees with a temporary job	Percentage	Greece	2003	10.9


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

Share link

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