Community Designs (CD) By Metropolitan Region (1996-2016)

Eurostat code: met_ipr_dfa · (2003 - 2016)

@eurostat.met_ipr_dfa

Table List

2 tables(43.81 KB)

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

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

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

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

16.6 KB
3287 rows
5 columns

freq Freq	unit Unit	metroreg Metroreg	time_period Time Period	value Value
Annual	Number	Graz	2003	24
Annual	Number	Linz	2003	103
Annual	Number	Salzburg	2003	42
Annual	Number	Innsbruck	2003	76
Annual	Number	Bruxelles / Brussel	2003	101
Annual	Number	Antwerpen	2003	133
Annual	Number	Charleroi	2003	2
Annual	Number	Zürich	2003	120
Annual	Number	Genève	2003	46
Annual	Number	Basel	2003	166


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.