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

Eurostat code: met_ipr_dapop · (2003 - 2016)

@eurostat.met_ipr_dapop

Table List

2 tables(60.61 KB)

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

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

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

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

26.16 KB
3227 rows
5 columns

freq Freq	unit Unit	metroreg Metroreg	time_period Time Period	value Value
Annual	Per million inhabitants	Graz	2003	14.33
Annual	Per million inhabitants	Linz	2003	36.93
Annual	Per million inhabitants	Salzburg	2003	35.93
Annual	Per million inhabitants	Innsbruck	2003	44.54
Annual	Per million inhabitants	Bruxelles / Brussel	2003	22.03
Annual	Per million inhabitants	Antwerpen	2003	29.77
Annual	Per million inhabitants	Charleroi	2003	4.75
Annual	Per million inhabitants	Zürich	2003	14.5
Annual	Per million inhabitants	Genève	2003	35.82
Annual	Per million inhabitants	Basel	2003	22.38


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.