Number Of Local Units, Persons Employed And Wages And Salaries By NUTS 2 Region (1997-2007)

Eurostat code: sbs_cre_rreg · (1997 - 2007)

@eurostat.sbs_cre_rreg

Table List

2 tables(50.24 KB)

Number Of Local Units, Persons Employed And Wages And Salaries By NUTS 2 Region (1997-2007) - Raw

Number Of Local Units, Persons Employed And Wages And Salaries By NUTS 2 Region (1997-2007) - Unpivoted

Number Of Local Units, Persons Employed And Wages And Salaries By NUTS 2 Region (1997-2007) - Unpivoted

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

22.14 KB
3796 rows
6 columns

freq Freq	indic_sb Indic Sb	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	Wages and Salaries - million euro	Other monetary intermediation	Germany	1997	26216.654
Annual	Wages and Salaries - million euro	Other monetary intermediation	Baden-Württemberg	1997	2598.61
Annual	Wages and Salaries - million euro	Other monetary intermediation	Bayern	1997	4304.947
Annual	Wages and Salaries - million euro	Other monetary intermediation	Berlin	1997	779.532
Annual	Wages and Salaries - million euro	Other monetary intermediation	Brandenburg	1997	217.355
Annual	Wages and Salaries - million euro	Other monetary intermediation	Bremen	1997	220.402
Annual	Wages and Salaries - million euro	Other monetary intermediation	Hamburg	1997	661.714
Annual	Wages and Salaries - million euro	Other monetary intermediation	Hessen	1997	8090.375
Annual	Wages and Salaries - million euro	Other monetary intermediation	Mecklenburg-Vorpommern	1997	170.126
Annual	Wages and Salaries - million euro	Other monetary intermediation	Niedersachsen	1997	1632.701


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

Share link

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