Baselight

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

Eurostat code: rd_e_gerdsobj07 ยท (2003 - 2023)

@eurostat.rd_e_gerdsobj07

GERD By Sector Of Performance And Socioeconomic Objectives (NABS 2007) - Unpivoted
@eurostat.rd_e_gerdsobj07.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.

  • 520.06 KB
  • 112748 rows
  • 7 columns
freq

Freq

nabs07

Nabs07

sectperf

Sectperf

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualExploration and exploitation of the earthBusiness enterprise sectorEuro per inhabitantCzechia20030.077
AnnualExploration and exploitation of the earthBusiness enterprise sectorEuro per inhabitantEstonia2003
AnnualExploration and exploitation of the earthBusiness enterprise sectorEuro per inhabitantSpain20030.947
AnnualExploration and exploitation of the earthBusiness enterprise sectorEuro per inhabitantCroatia20030.184
AnnualExploration and exploitation of the earthBusiness enterprise sectorEuro per inhabitantHungary20030.057
AnnualExploration and exploitation of the earthBusiness enterprise sectorEuro per inhabitantIceland20033.365
AnnualExploration and exploitation of the earthBusiness enterprise sectorEuro per inhabitantSouth Korea20030.111
AnnualExploration and exploitation of the earthBusiness enterprise sectorEuro per inhabitantNorway20031.051
AnnualExploration and exploitation of the earthBusiness enterprise sectorEuro per inhabitantPortugal20030.105
AnnualExploration and exploitation of the earthBusiness enterprise sectorEuro per inhabitantRomania20030.08

CREATE TABLE tidy (
  "freq" VARCHAR,
  "nabs07" 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.