Average Size Of Dwelling By Income Quintile And Tenure Status

Eurostat code: ilc_hcmh01 · (2012 - 2012)

@eurostat.ilc_hcmh01

Table List

2 tables(19.88 KB)

Average Size Of Dwelling By Income Quintile And Tenure Status - Raw

Average Size Of Dwelling By Income Quintile And Tenure Status - Unpivoted

Average Size Of Dwelling By Income Quintile And Tenure Status - Unpivoted

@eurostat.ilc_hcmh01.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.12 KB
1110 rows
7 columns

freq Freq	unit Unit	tenure Tenure	quantile Quantile	geo Geo	time_period Time Period	value Value
Annual	Average	Owner, with mortgage or loan	First quintile	Austria	2012	121.7
Annual	Average	Owner, with mortgage or loan	First quintile	Belgium	2012	127.6
Annual	Average	Owner, with mortgage or loan	First quintile	Bulgaria	2012	56.5
Annual	Average	Owner, with mortgage or loan	First quintile	Switzerland	2012	137.2
Annual	Average	Owner, with mortgage or loan	First quintile	Cyprus	2012	152.3
Annual	Average	Owner, with mortgage or loan	First quintile	Czechia	2012	89.9
Annual	Average	Owner, with mortgage or loan	First quintile	Germany	2012	114.2
Annual	Average	Owner, with mortgage or loan	First quintile	Denmark	2012	134.7
Annual	Average	Owner, with mortgage or loan	First quintile	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2012	109.2
Annual	Average	Owner, with mortgage or loan	First quintile	Euro area - 18 countries (2014)	2012	109.1


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

Share link

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