GERD By Sector Of Performance And NUTS 2 Region

Eurostat code: rd_e_gerdreg · (1980 - 2023)

@eurostat.rd_e_gerdreg

Table List

2 tables(3.06 MB)

GERD By Sector Of Performance And NUTS 2 Region - Raw

GERD By Sector Of Performance And NUTS 2 Region - Unpivoted

GERD By Sector Of Performance And NUTS 2 Region - Unpivoted

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

1.5 MB
284272 rows
6 columns

freq Freq	sectperf Sectperf	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Business enterprise sector	Euro per inhabitant	Japan	1980	85.205
Annual	Business enterprise sector	Euro per inhabitant	United States	1980	140.366
Annual	Business enterprise sector	Million euro	Japan	1980	9974.149
Annual	Business enterprise sector	Million euro	United States	1980	31965.094
Annual	Business enterprise sector	Million units of national currency	Japan	1980	3142256
Annual	Business enterprise sector	Million units of national currency	United States	1980	44505
Annual	Business enterprise sector	Million purchasing power standards (PPS) at 2005 prices	Japan	1980	21743.442
Annual	Business enterprise sector	Million purchasing power standards (PPS) at 2005 prices	United States	1980	75541.098
Annual	Business enterprise sector	Percentage of gross domestic product (GDP)	Japan	1980	1.23
Annual	Business enterprise sector	Percentage of gross domestic product (GDP)	United States	1980	1.56


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