At-risk-of-poverty Rate After Deducting Housing Costs By Degree Of Urbanisation

Eurostat code: ilc_li48 · (2003 - 2024)

@eurostat.ilc_li48

Table List

2 tables(40.25 KB)

At-risk-of-poverty Rate After Deducting Housing Costs By Degree Of Urbanisation - Raw

At-risk-of-poverty Rate After Deducting Housing Costs By Degree Of Urbanisation - Unpivoted

At-risk-of-poverty Rate After Deducting Housing Costs By Degree Of Urbanisation - Unpivoted

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

10.66 KB
2910 rows
6 columns

freq Freq	deg_urb Deg Urb	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Cities	Percentage	Ireland	2003	24.8
Annual	Cities	Percentage	Luxembourg	2003	28.6
Annual	Towns and suburbs	Percentage	Ireland	2003	29
Annual	Towns and suburbs	Percentage	Luxembourg	2003	16.4
Annual	Rural areas	Percentage	Ireland	2003	29.8
Annual	Rural areas	Percentage	Luxembourg	2003	15.5
Annual	Total	Percentage	Ireland	2003	27.8
Annual	Total	Percentage	Luxembourg	2003	22.1
Annual	Cities	Percentage	Austria	2004	33.6
Annual	Cities	Percentage	Belgium	2004	32.9


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

Share link

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