GERD By Sector Of Performance And Type Of R&D

Eurostat code: rd_e_gerdact · (1980 - 2023)

@eurostat.rd_e_gerdact

Table List

2 tables(1.41 MB)

GERD By Sector Of Performance And Type Of R&D - Raw

GERD By Sector Of Performance And Type Of R&D - Unpivoted

GERD By Sector Of Performance And Type Of R&D - Unpivoted

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

685.11 KB
118262 rows
7 columns

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


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