Typical Dwelling Sizes By Type Of Dwelling In Each Surveyed City

Eurostat code: prc_colc_surf · (2013 - 2023)

@eurostat.prc_colc_surf

Table List

2 tables(18.09 KB)

Typical Dwelling Sizes By Type Of Dwelling In Each Surveyed City - Raw

Typical Dwelling Sizes By Type Of Dwelling In Each Surveyed City - Unpivoted

Typical Dwelling Sizes By Type Of Dwelling In Each Surveyed City - Unpivoted

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

5.82 KB
2306 rows
6 columns

freq Freq	building Building	unit Unit	geo Geo	time_period Time Period	value Value
Annual	1-bedroom flats	Square metre	Tiranë (Tirana)	2013	70
Annual	1-bedroom flats	Square metre	Wien	2013	70
Annual	1-bedroom flats	Square metre	Bruxelles/Brussel	2013	70
Annual	1-bedroom flats	Square metre	Sofia	2013	70
Annual	1-bedroom flats	Square metre	Bern (Berne)	2013	70
Annual	1-bedroom flats	Square metre	Genève	2013	70
Annual	1-bedroom flats	Square metre	Lefkosia	2013	70
Annual	1-bedroom flats	Square metre	Praha	2013	70
Annual	1-bedroom flats	Square metre	Berlin	2013	70
Annual	1-bedroom flats	Square metre	Karlsruhe	2013	70


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

Share link

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