Share Of Population Living In A Dwelling Not Comfortably Cool During Summer Time By Income Quintile And Degree Of Urbanisation

Eurostat code: ilc_hcmp03 · (2012 - 2014)

@eurostat.ilc_hcmp03

Table List

2 tables(17.25 KB)

Share Of Population Living In A Dwelling Not Comfortably Cool During Summer Time By Income Quintile And Degree Of Urbanisation - Raw

Share Of Population Living In A Dwelling Not Comfortably Cool During Summer Time By Income Quintile And Degree Of Urbanisation - Unpivoted

Share Of Population Living In A Dwelling Not Comfortably Cool During Summer Time By Income Quintile And Degree Of Urbanisation - Unpivoted

@eurostat.ilc_hcmp03.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.48 KB
927 rows
7 columns

freq Freq	unit Unit	deg_urb Deg Urb	quantile Quantile	geo Geo	time_period Time Period	value Value
Annual	Percentage	Cities	First quintile	Austria	2012	32.3
Annual	Percentage	Cities	First quintile	Belgium	2012	26.3
Annual	Percentage	Cities	First quintile	Bulgaria	2012	71.5
Annual	Percentage	Cities	First quintile	Switzerland	2012	24
Annual	Percentage	Cities	First quintile	Cyprus	2012	39.6
Annual	Percentage	Cities	First quintile	Czechia	2012	24.6
Annual	Percentage	Cities	First quintile	Germany	2012	23.6
Annual	Percentage	Cities	First quintile	Denmark	2012	12.4
Annual	Percentage	Cities	First quintile	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2012	32.2
Annual	Percentage	Cities	First quintile	Euro area - 18 countries (2014)	2012	32.2


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

Share link

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