Area Of The Region By Metropolitan Region

Eurostat code: met_d3area · (1990 - 2023)

@eurostat.met_d3area

Table List

2 tables(159.84 KB)

Area Of The Region By Metropolitan Region - Raw

Area Of The Region By Metropolitan Region - Unpivoted

Area Of The Region By Metropolitan Region - Unpivoted

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

35.41 KB
16421 rows
6 columns

freq Freq	unit Unit	landuse Landuse	metroreg Metroreg	time_period Time Period	value Value
Annual	Square kilometre	Land area - total	Bruxelles / Brussel	1990	2661
Annual	Square kilometre	Land area - total	Antwerpen	1990	954
Annual	Square kilometre	Land area - total	Gent	1990	1266
Annual	Square kilometre	Land area - total	Charleroi	1990	555
Annual	Square kilometre	Land area - total	Liège	1990	1178
Annual	Square kilometre	Land area - total	Zürich	1990	1660.9
Annual	Square kilometre	Land area - total	Genève	1990	245.7
Annual	Square kilometre	Land area - total	Bern	1990	5932.5
Annual	Square kilometre	Land area - total	Lausanne	1990	2822.4
Annual	Square kilometre	Land area - total	Non-metropolitan regions in Switzerland	1990	28868.3


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

Share link

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