Land Covered By Artificial Surfaces - Index

Eurostat code: lan_lcv_arti · (2009 - 2018)

@eurostat.lan_lcv_arti

Table List

2 tables(11.66 KB)

Land Covered By Artificial Surfaces - Index - Raw

Land Covered By Artificial Surfaces - Index - Unpivoted

Land Covered By Artificial Surfaces - Index - Unpivoted

@eurostat.lan_lcv_arti.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.18 KB
247 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Index, 2009=100	Austria	2009	100
Annual	Index, 2009=100	Belgium	2009	100
Annual	Index, 2009=100	Czechia	2009	100
Annual	Index, 2009=100	Germany	2009	100
Annual	Index, 2009=100	Denmark	2009	100
Annual	Index, 2009=100	Estonia	2009	100
Annual	Index, 2009=100	Greece	2009	100
Annual	Index, 2009=100	Spain	2009	100
Annual	Index, 2009=100	European Union (aggregate changing according to the context)	2009	100
Annual	Index, 2009=100	Finland	2009	100


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.