Average Annual Population To Calculate Regional GDP Data By Metropolitan Region

Eurostat code: met_10r_3pgdp · (2000 - 2022)

@eurostat.met_10r_3pgdp

Table List

2 tables(118.45 KB)

Average Annual Population To Calculate Regional GDP Data By Metropolitan Region - Raw

Average Annual Population To Calculate Regional GDP Data By Metropolitan Region - Unpivoted

Average Annual Population To Calculate Regional GDP Data By Metropolitan Region - Unpivoted

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

54.27 KB
6914 rows
5 columns

freq Freq	unit Unit	metroreg Metroreg	time_period Time Period	value Value
Annual	Thousand	Austria	2000	8011.57
Annual	Thousand	Wien	2000	2366.82
Annual	Thousand	Graz	2000	543.52
Annual	Thousand	Linz	2000	723.71
Annual	Thousand	Salzburg	2000	330.65
Annual	Thousand	Innsbruck	2000	273.26
Annual	Thousand	Non-metropolitan regions in Austria	2000	3773.63
Annual	Thousand	Belgium	2000	10251
Annual	Thousand	Bruxelles / Brussel	2000	2800.52
Annual	Thousand	Antwerpen	2000	931.77


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

Share link

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