Community Design (CD) Applications Per Billion GDP (2003-2015)

Eurostat code: ipr_da_gdp · (2003 - 2015)

@eurostat.ipr_da_gdp

Table List

2 tables(24.43 KB)

Community Design (CD) Applications Per Billion GDP (2003-2015) - Raw

Community Design (CD) Applications Per Billion GDP (2003-2015) - Unpivoted

Community Design (CD) Applications Per Billion GDP (2003-2015) - Unpivoted

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

7.22 KB
1235 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Euro per billion GDP	Austria	2003	0.83
Annual	Euro per billion GDP	Australia	2003	0.17
Annual	Euro per billion GDP	Belgium	2003	0.56
Annual	Euro per billion GDP	Brazil	2003	0.04
Annual	Euro per billion GDP	Canada	2003	0.05
Annual	Euro per billion GDP	Switzerland	2003	0.62
Annual	Euro per billion GDP	China except Hong Kong	2003	0.02
Annual	Euro per billion GDP	Cyprus	2003	0.31
Annual	Euro per billion GDP	Czechia	2003	0.11
Annual	Euro per billion GDP	Germany	2003	0.86


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.