Community Designs (CD) Per Billion GDP By Metropolitan Region (1996-2016)

Eurostat code: met_ipr_dfagdp · (2003 - 2016)

@eurostat.met_ipr_dfagdp

Table List

2 tables(87.38 KB)

Community Designs (CD) Per Billion GDP By Metropolitan Region (1996-2016) - Raw

Community Designs (CD) Per Billion GDP By Metropolitan Region (1996-2016) - Unpivoted

Community Designs (CD) Per Billion GDP By Metropolitan Region (1996-2016) - Unpivoted

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

36.45 KB
6018 rows
5 columns

freq Freq	unit Unit	metroreg Metroreg	time_period Time Period	value Value
Annual	Euro per billion GDP	Graz	2003	1.44
Annual	Euro per billion GDP	Linz	2003	4.48
Annual	Euro per billion GDP	Salzburg	2003	3.55
Annual	Euro per billion GDP	Innsbruck	2003	8.79
Annual	Euro per billion GDP	Bruxelles / Brussel	2003	1.17
Annual	Euro per billion GDP	Antwerpen	2003	4.15
Annual	Euro per billion GDP	Charleroi	2003	0.23
Annual	Euro per billion GDP	Lefkosia	2003	1.71
Annual	Euro per billion GDP	Praha	2003	0.13
Annual	Euro per billion GDP	Ostrava	2003	0.12


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.