Settlement Area Per Capita

Eurostat code: sdg_11_31 · (2009 - 2018)

@eurostat.sdg_11_31

Table List

2 tables(11.47 KB)

Settlement Area Per Capita - Unpivoted

@eurostat.sdg_11_31.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.11 KB
117 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Square metres per capita	Austria	2009	654.3
Annual	Square metres per capita	Belgium	2009	572.5
Annual	Square metres per capita	Czechia	2009	623.6
Annual	Square metres per capita	Germany	2009	526.6
Annual	Square metres per capita	Denmark	2009	969.6
Annual	Square metres per capita	Estonia	2009	1164.4
Annual	Square metres per capita	Greece	2009	562
Annual	Square metres per capita	Spain	2009	561.6
Annual	Square metres per capita	European Union (aggregate changing according to the context)	2009	616.1
Annual	Square metres per capita	Finland	2009	2136.6


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

Share link

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