At-risk-of-poverty Rate By Degree Of Urbanisation

Eurostat code: ilc_li43 · (2003 - 2024)

@eurostat.ilc_li43

Table List

2 tables(57.88 KB)

At-risk-of-poverty Rate By Degree Of Urbanisation - Raw

At-risk-of-poverty Rate By Degree Of Urbanisation - Unpivoted

At-risk-of-poverty Rate By Degree Of Urbanisation - Unpivoted

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

18.75 KB
4358 rows
6 columns

freq Freq	unit Unit	deg_urb Deg Urb	geo Geo	time_period Time Period	value Value
Annual	Percentage	Cities	Austria	2003	12.9
Annual	Percentage	Cities	Belgium	2003	17
Annual	Percentage	Cities	Denmark	2003	12.2
Annual	Percentage	Cities	Greece	2003	12.7
Annual	Percentage	Cities	Ireland	2003	17.1
Annual	Percentage	Cities	Luxembourg	2003	14.8
Annual	Percentage	Towns and suburbs	Austria	2003	12
Annual	Percentage	Towns and suburbs	Belgium	2003	13
Annual	Percentage	Towns and suburbs	Denmark	2003	9.2
Annual	Percentage	Towns and suburbs	Greece	2003	14.8


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

Share link

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