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

Eurostat code: met_ipr_da · (2003 - 2016)

@eurostat.met_ipr_da

Table List

2 tables(37.45 KB)

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

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

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

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

14.57 KB
3287 rows
5 columns

freq Freq	unit Unit	metroreg Metroreg	time_period Time Period	value Value
Annual	Number	Graz	2003	8
Annual	Number	Linz	2003	27
Annual	Number	Salzburg	2003	12
Annual	Number	Innsbruck	2003	12
Annual	Number	Bruxelles / Brussel	2003	48
Annual	Number	Antwerpen	2003	28
Annual	Number	Charleroi	2003	2
Annual	Number	Zürich	2003	18
Annual	Number	Genève	2003	15
Annual	Number	Basel	2003	15


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.