Share Of Population Having Moved To Other Dwelling Within The Last Five Year Period By Tenure Status And Degree Of Urbanisation

Eurostat code: ilc_hcmp05 · (2012 - 2014)

@eurostat.ilc_hcmp05

Table List

2 tables(17.42 KB)

Share Of Population Having Moved To Other Dwelling Within The Last Five Year Period By Tenure Status And Degree Of Urbanisation - Raw

Share Of Population Having Moved To Other Dwelling Within The Last Five Year Period By Tenure Status And Degree Of Urbanisation - Unpivoted

Share Of Population Having Moved To Other Dwelling Within The Last Five Year Period By Tenure Status And Degree Of Urbanisation - Unpivoted

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

8.59 KB
771 rows
7 columns

freq Freq	unit Unit	deg_urb Deg Urb	tenure Tenure	geo Geo	time_period Time Period	value Value
Annual	Percentage	Cities	Owner, with mortgage or loan	Austria	2012	23
Annual	Percentage	Cities	Owner, with mortgage or loan	Belgium	2012	26.6
Annual	Percentage	Cities	Owner, with mortgage or loan	Bulgaria	2012	20.2
Annual	Percentage	Cities	Owner, with mortgage or loan	Switzerland	2012	24.3
Annual	Percentage	Cities	Owner, with mortgage or loan	Cyprus	2012	41.7
Annual	Percentage	Cities	Owner, with mortgage or loan	Czechia	2012	24.6
Annual	Percentage	Cities	Owner, with mortgage or loan	Germany	2012	21.4
Annual	Percentage	Cities	Owner, with mortgage or loan	Denmark	2012	29.1
Annual	Percentage	Cities	Owner, with mortgage or loan	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2012	21.6
Annual	Percentage	Cities	Owner, with mortgage or loan	Euro area - 18 countries (2014)	2012	21.6


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

Share link

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