Community Design (CD) Applications By NUTS 3 Region (2003-2016)

Eurostat code: ipr_da_reg · (2003 - 2016)

@eurostat.ipr_da_reg

Table List

2 tables(151.43 KB)

Community Design (CD) Applications By NUTS 3 Region (2003-2016) - Raw

Community Design (CD) Applications By NUTS 3 Region (2003-2016) - Unpivoted

Community Design (CD) Applications By NUTS 3 Region (2003-2016) - Unpivoted

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

82.14 KB
21665 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Number	Austria	2003	191
Annual	Number	Ostösterreich	2003	65
Annual	Number	Burgenland	2003	4
Annual	Number	Mittelburgenland	2003	1
Annual	Number	Nordburgenland	2003	1
Annual	Number	Südburgenland	2003	2
Annual	Number	Niederösterreich	2003	21
Annual	Number	Mostviertel-Eisenwurzen	2003	8
Annual	Number	Niederösterreich-Süd	2003	2
Annual	Number	Sankt Pölten	2003	3


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.