Community Designs (CD) By NUTS 3 Region (2003-2016)

Eurostat code: ipr_dfa_reg · (2003 - 2016)

@eurostat.ipr_dfa_reg

Table List

2 tables(169.87 KB)

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

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

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

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

88.54 KB
21665 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Number	Austria	2003	808
Annual	Number	Ostösterreich	2003	293
Annual	Number	Burgenland	2003	6
Annual	Number	Mittelburgenland	2003	1
Annual	Number	Nordburgenland	2003	3
Annual	Number	Südburgenland	2003	2
Annual	Number	Niederösterreich	2003	129
Annual	Number	Mostviertel-Eisenwurzen	2003	45
Annual	Number	Niederösterreich-Süd	2003	2
Annual	Number	Sankt Pölten	2003	46


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.