Community Design (CD) Applications Per Million Population By Other Typologies (2003-2016)

Eurostat code: urt_ipr_dapop · (2003 - 2016)

@eurostat.urt_ipr_dapop

Table List

2 tables(30.89 KB)

Community Design (CD) Applications Per Million Population By Other Typologies (2003-2016) - Raw

Community Design (CD) Applications Per Million Population By Other Typologies (2003-2016) - Unpivoted

Community Design (CD) Applications Per Million Population By Other Typologies (2003-2016) - Unpivoted

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

11.58 KB
1114 rows
6 columns

freq Freq	unit Unit	terrtypo Terrtypo	geo Geo	time_period Time Period	value Value
Annual	Per million inhabitants	Border regions	Ireland	2003	9.48
Annual	Per million inhabitants	Border regions	Liechtenstein	2003	442.96
Annual	Per million inhabitants	Border regions	Luxembourg	2003	44.61
Annual	Per million inhabitants	Coastal regions	Cyprus	2003	5.6
Annual	Per million inhabitants	Coastal regions	Sweden	2003	40.14
Annual	Per million inhabitants	Intermediate regions	Austria	2003	24.81
Annual	Per million inhabitants	Intermediate regions	Cyprus	2003	5.6
Annual	Per million inhabitants	Intermediate regions	Ireland	2003	14.18
Annual	Per million inhabitants	Intermediate regions	Luxembourg	2003	44.61
Annual	Per million inhabitants	Intermediate regions	Sweden	2003	39.33


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "terrtypo" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.