Community Designs (CD) Per Million Population By Metropolitan Region (1996-2016)

Eurostat code: met_ipr_dfapop · (2003 - 2016)

@eurostat.met_ipr_dfapop

Table List

2 tables(63.8 KB)

Community Designs (CD) Per Million Population By Metropolitan Region (1996-2016) - Raw

Community Designs (CD) Per Million Population By Metropolitan Region (1996-2016) - Unpivoted

Community Designs (CD) Per Million Population By Metropolitan Region (1996-2016) - Unpivoted

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

28.73 KB
3227 rows
5 columns

freq Freq	unit Unit	metroreg Metroreg	time_period Time Period	value Value
Annual	Per million inhabitants	Graz	2003	42.98
Annual	Per million inhabitants	Linz	2003	140.88
Annual	Per million inhabitants	Salzburg	2003	125.76
Annual	Per million inhabitants	Innsbruck	2003	282.1
Annual	Per million inhabitants	Bruxelles / Brussel	2003	46.37
Annual	Per million inhabitants	Antwerpen	2003	141.39
Annual	Per million inhabitants	Charleroi	2003	4.75
Annual	Per million inhabitants	Zürich	2003	96.67
Annual	Per million inhabitants	Genève	2003	109.85
Annual	Per million inhabitants	Basel	2003	247.69


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.