At-risk-of-poverty Rate Before Social Transfers (pensions Excluded From Social Transfers) By Household Type

Eurostat code: ilc_li10b · (2003 - 2024)

@eurostat.ilc_li10b

Table List

2 tables(93.63 KB)

At-risk-of-poverty Rate Before Social Transfers (pensions Excluded From Social Transfers) By Household Type - Raw

At-risk-of-poverty Rate Before Social Transfers (pensions Excluded From Social Transfers) By Household Type - Unpivoted

At-risk-of-poverty Rate Before Social Transfers (pensions Excluded From Social Transfers) By Household Type - Unpivoted

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

28.47 KB
14778 rows
6 columns

freq Freq	unit Unit	hhtyp Hhtyp	geo Geo	time_period Time Period	value Value
Annual	Percentage	Single person	Austria	2003	27
Annual	Percentage	Single person	Belgium	2003	33.7
Annual	Percentage	Single person	Denmark	2003	48.5
Annual	Percentage	Single person	Greece	2003	30.3
Annual	Percentage	Single person	Ireland	2003	61.1
Annual	Percentage	Single person	Luxembourg	2003	16.2
Annual	Percentage	Single person	Norway	2003	42.7
Annual	Percentage	Single female	Austria	2003	29
Annual	Percentage	Single female	Belgium	2003	32.9
Annual	Percentage	Single female	Denmark	2003	53.4


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

Share link

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