Overcrowding Rate By Degree Of Urbanisation - EU-SILC Survey

Eurostat code: tessi174 · (2013 - 2024)

@eurostat.tessi174

Table List

2 tables(26.11 KB)

Overcrowding Rate By Degree Of Urbanisation - EU-SILC Survey - Raw

Overcrowding Rate By Degree Of Urbanisation - EU-SILC Survey - Unpivoted

Overcrowding Rate By Degree Of Urbanisation - EU-SILC Survey - Raw

@eurostat.tessi174.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

17.49 KB
117 rows
16 columns

freq Freq	unit Unit	deg_urb Deg Urb	geo Geo	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022	n_2023 2023	n_2024 2024
Annual	Percentage	Cities	Albania					64.4	65.8	64	66.4	64.2
Annual	Percentage	Cities	Austria	26.5	26.4	28.2	27.7	26.6	25.3	26.4	26.9	28.4	29.9	27.3
Annual	Percentage	Cities	Belgium	4.5	4.3	3.3	8.5	10.2	13.3	12.7	13.2	14.6	14.5	14.3	15
Annual	Percentage	Cities	Bulgaria	51.9	50.5	48	49.8	49.8	50.6	49.7	48.8	46.6	44.3	42.8	41.8
Annual	Percentage	Cities	Switzerland	12.1	9.7	10.8	11.9	10.1	10.1	8.2	9.3	7.2	7.2	10.9
Annual	Percentage	Cities	Cyprus	2.2	2.2	1.2	1.9	2.7	2.4	1.6	2.5	2.4	1.9	2.5	2.6
Annual	Percentage	Cities	Czechia	25.5	23.9	23.5	22.7	20.1	20.5	19.2	19.6	19.2	20.6	21.3	22.5
Annual	Percentage	Cities	Germany	10.4	9.9	10.5	11	11.4	11.5	12.7	15	15.7	16.5	16.6	16.7
Annual	Percentage	Cities	Denmark	11.7	13.6	13.8	14.9	14.8	14.9	14.2	15.1	15.2	15.8	14.5	14.3
Annual	Percentage	Cities	Euro area - 19 countries (2015-2022)	15	15	14.6	14.6	14.2	14.5	15.2	16.3	16


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "deg_urb" VARCHAR,
  "geo" VARCHAR,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE,
  "n_2024" DOUBLE
);

Share link

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