GERD By Sector Of Performance And Fields Of R&D

Eurostat code: rd_e_gerdsc · (1980 - 2023)

@eurostat.rd_e_gerdsc

Table List

2 tables(2.56 MB)

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

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

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

@eurostat.rd_e_gerdsc.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.19 MB
258590 rows
7 columns

freq Freq	ford Ford	sectperf Sectperf	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Natural sciences	Higher education sector	Euro per inhabitant	United States	1980	8.368
Annual	Natural sciences	Higher education sector	Million euro	United States	1980	1905.566
Annual	Natural sciences	Higher education sector	Million units of national currency	United States	1980	2653.119
Annual	Natural sciences	Higher education sector	Million purchasing power standards (PPS) at 2005 prices	United States	1980	4503.303
Annual	Natural sciences	Higher education sector	Percentage of gross domestic product (GDP)	United States	1980	0.09
Annual	Natural sciences	Higher education sector	Purchasing power standard (PPS) per inhabitant at constant 2005 prices	United States	1980	19.775
Annual	Natural sciences, engineering and technology, medical and health sciences, agricultural sciences	Business enterprise sector	Euro per inhabitant	Japan	1980	85.205
Annual	Natural sciences, engineering and technology, medical and health sciences, agricultural sciences	Business enterprise sector	Euro per inhabitant	United States	1980	140.366
Annual	Natural sciences, engineering and technology, medical and health sciences, agricultural sciences	Business enterprise sector	Million euro	Japan	1980	9974.149
Annual	Natural sciences, engineering and technology, medical and health sciences, agricultural sciences	Business enterprise sector	Million euro	United States	1980	31965.094


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