Average Annual Population To Calculate Regional GDP Data By Other Typologies

Eurostat code: urt_10r_3pgdp · (2000 - 2022)

@eurostat.urt_10r_3pgdp

Table List

2 tables(131.44 KB)

Average Annual Population To Calculate Regional GDP Data By Other Typologies - Raw

Average Annual Population To Calculate Regional GDP Data By Other Typologies - Unpivoted

Average Annual Population To Calculate Regional GDP Data By Other Typologies - Unpivoted

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

59.83 KB
8474 rows
6 columns

freq Freq	terrtypo Terrtypo	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Border regions	Thousand	Austria	2000	4174.22
Annual	Border regions	Thousand	Belgium	2000	6593.42
Annual	Border regions	Thousand	Bulgaria	2000	4007.28
Annual	Border regions	Thousand	Czechia	2000	7454.43
Annual	Border regions	Thousand	Germany	2000	13806.54
Annual	Border regions	Thousand	Denmark	2000	1843
Annual	Border regions	Thousand	Estonia	2000	716.59
Annual	Border regions	Thousand	Greece	2000	1157.12
Annual	Border regions	Thousand	Spain	2000	5793.3
Annual	Border regions	Thousand	European Union - 27 countries (from 2020)	2000	124769.36


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

Share link

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