Community Design (CD) Applications Per Million Population (2003-2015)

Eurostat code: ipr_da_pop · (2003 - 2015)

@eurostat.ipr_da_pop

Table List

2 tables(23.82 KB)

Community Design (CD) Applications Per Million Population (2003-2015) - Raw

Community Design (CD) Applications Per Million Population (2003-2015) - Unpivoted

Community Design (CD) Applications Per Million Population (2003-2015) - Unpivoted

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

8.17 KB
641 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Per million inhabitants	Austria	2003	23.58
Annual	Per million inhabitants	Australia	2003	4.26
Annual	Per million inhabitants	Belgium	2003	15.35
Annual	Per million inhabitants	Brazil	2003	0.1
Annual	Per million inhabitants	Canada	2003	1.3
Annual	Per million inhabitants	Switzerland	2003	26.25
Annual	Per million inhabitants	China except Hong Kong	2003	0.03
Annual	Per million inhabitants	Cyprus	2003	5.6
Annual	Per million inhabitants	Czechia	2003	0.98
Annual	Per million inhabitants	Germany	2003	23.19


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

Share link

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