Average Size Of Dwelling By Household Type And Degree Of Urbanisation

Eurostat code: ilc_hcmh02 · (2012 - 2012)

@eurostat.ilc_hcmh02

Table List

2 tables(16.85 KB)

Average Size Of Dwelling By Household Type And Degree Of Urbanisation - Raw

Average Size Of Dwelling By Household Type And Degree Of Urbanisation - Unpivoted

Average Size Of Dwelling By Household Type And Degree Of Urbanisation - Unpivoted

@eurostat.ilc_hcmh02.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.67 KB
700 rows
7 columns

freq Freq	unit Unit	deg_urb Deg Urb	hhtyp Hhtyp	geo Geo	time_period Time Period	value Value
Annual	Average	Cities	Single person	Austria	2012	62.4
Annual	Average	Cities	Single person	Belgium	2012	88.9
Annual	Average	Cities	Single person	Bulgaria	2012	61.8
Annual	Average	Cities	Single person	Switzerland	2012	76.7
Annual	Average	Cities	Single person	Cyprus	2012	100.6
Annual	Average	Cities	Single person	Czechia	2012	56.2
Annual	Average	Cities	Single person	Germany	2012	60.4
Annual	Average	Cities	Single person	Denmark	2012	75.3
Annual	Average	Cities	Single person	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2012	68
Annual	Average	Cities	Single person	Euro area - 18 countries (2014)	2012	67.9


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

Share link

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