In-work At-risk-of-poverty Rate By Household Type

Eurostat code: ilc_iw02 · (2003 - 2024)

@eurostat.ilc_iw02

Table List

2 tables(46.52 KB)

In-work At-risk-of-poverty Rate By Household Type - Raw

In-work At-risk-of-poverty Rate By Household Type - Unpivoted

In-work At-risk-of-poverty Rate By Household Type - Unpivoted

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

12.77 KB
4663 rows
6 columns

freq Freq	hhtyp Hhtyp	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Single person	Percentage	Austria	2003	11.1
Annual	Single person	Percentage	Belgium	2003	10.3
Annual	Single person	Percentage	Denmark	2003	10
Annual	Single person	Percentage	Greece	2003	7.2
Annual	Single person	Percentage	Ireland	2003	17.9
Annual	Single person	Percentage	Luxembourg	2003	6.8
Annual	Single person	Percentage	Norway	2003	10.9
Annual	Single person with dependent children	Percentage	Austria	2003	24.1
Annual	Single person with dependent children	Percentage	Belgium	2003	14
Annual	Single person with dependent children	Percentage	Denmark	2003	7.3


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

Share link

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