GERD By Sector Of Performance And Socioeconomic Objectives (NABS 1992) (1980-2007)

Eurostat code: rd_e_gerdsobj92 · (1981 - 2006)

@eurostat.rd_e_gerdsobj92

Table List

2 tables(834.94 KB)

GERD By Sector Of Performance And Socioeconomic Objectives (NABS 1992) (1980-2007) - Raw

GERD By Sector Of Performance And Socioeconomic Objectives (NABS 1992) (1980-2007) - Unpivoted

GERD By Sector Of Performance And Socioeconomic Objectives (NABS 1992) (1980-2007) - Unpivoted

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

381.92 KB
94006 rows
7 columns

freq Freq	nabs92 Nabs92	sectperf Sectperf	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Exploration and exploitation of the earth	Business enterprise sector	Euro per inhabitant	Austria	1981
Annual	Exploration and exploitation of the earth	Business enterprise sector	Euro per inhabitant	Spain	1981	0.1
Annual	Exploration and exploitation of the earth	Business enterprise sector	Euro per inhabitant	Ireland	1981	0.2
Annual	Exploration and exploitation of the earth	Business enterprise sector	Euro per inhabitant	Netherlands	1981
Annual	Exploration and exploitation of the earth	Business enterprise sector	Euro per inhabitant	Norway	1981	1.5
Annual	Exploration and exploitation of the earth	Business enterprise sector	Million euro	Austria	1981	0.125
Annual	Exploration and exploitation of the earth	Business enterprise sector	Million euro	Spain	1981	4.991
Annual	Exploration and exploitation of the earth	Business enterprise sector	Million euro	Ireland	1981	0.777
Annual	Exploration and exploitation of the earth	Business enterprise sector	Million euro	Netherlands	1981
Annual	Exploration and exploitation of the earth	Business enterprise sector	Million euro	Norway	1981	6.075


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

Share link

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