Severe Material And Social Deprivation By Degree Of Urbanization

Eurostat code: ilc_mdsd19 · (2015 - 2024)

@eurostat.ilc_mdsd19

Table List

2 tables(22.54 KB)

Severe Material And Social Deprivation By Degree Of Urbanization - Raw

Severe Material And Social Deprivation By Degree Of Urbanization - Unpivoted

Severe Material And Social Deprivation By Degree Of Urbanization - Unpivoted

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

7.65 KB
1296 rows
6 columns

freq Freq	deg_urb Deg Urb	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Cities	Percentage	Austria	2015	4.4
Annual	Cities	Percentage	Belgium	2015	11
Annual	Cities	Percentage	Bulgaria	2015	29.1
Annual	Cities	Percentage	Switzerland	2015	2.8
Annual	Cities	Percentage	Cyprus	2015	7.3
Annual	Cities	Percentage	Czechia	2015	5.2
Annual	Cities	Percentage	Germany	2015	6.7
Annual	Cities	Percentage	Denmark	2015	2.8
Annual	Cities	Percentage	Euro area – 20 countries (from 2023)	2015	8.5
Annual	Cities	Percentage	Estonia	2015	4.4


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.