Settlement Area

Eurostat code: lan_settl · (2009 - 2018)

@eurostat.lan_settl

Table List

2 tables(16.85 KB)

Settlement Area - Unpivoted

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

7.66 KB
715 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Coefficient of variation for absolute value	Austria	2009	4
Annual	Coefficient of variation for absolute value	Belgium	2009	3.9
Annual	Coefficient of variation for absolute value	Czechia	2009	3.9
Annual	Coefficient of variation for absolute value	Germany	2009	1.5
Annual	Coefficient of variation for absolute value	Denmark	2009	4.5
Annual	Coefficient of variation for absolute value	Estonia	2009	9.3
Annual	Coefficient of variation for absolute value	Greece	2009	4
Annual	Coefficient of variation for absolute value	Spain	2009	1.8
Annual	Coefficient of variation for absolute value	European Union (aggregate changing according to the context)	2009	0.6
Annual	Coefficient of variation for absolute value	Finland	2009	3.5


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.