At-risk-of-poverty Rate Before Social Transfers (pensions Included In Social Transfers) By Household Type

Eurostat code: ilc_li09b · (2003 - 2024)

@eurostat.ilc_li09b

Table List

2 tables(103.55 KB)

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

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

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

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

29.3 KB
14782 rows
6 columns

freq Freq	unit Unit	hhtyp Hhtyp	geo Geo	time_period Time Period	value Value
Annual	Percentage	Single person	Austria	2003	63.2
Annual	Percentage	Single person	Belgium	2003	64.1
Annual	Percentage	Single person	Denmark	2003	62.4
Annual	Percentage	Single person	Greece	2003	66
Annual	Percentage	Single person	Ireland	2003	74.4
Annual	Percentage	Single person	Luxembourg	2003	48.6
Annual	Percentage	Single person	Norway	2003	60
Annual	Percentage	Single female	Austria	2003	76.2
Annual	Percentage	Single female	Belgium	2003	72.1
Annual	Percentage	Single female	Denmark	2003	72


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.