GERD By Source Of Funds

Eurostat code: rd_e_fundgerd · (1980 - 2023)

@eurostat.rd_e_fundgerd

Table List

2 tables(99.29 KB)

GERD By Source Of Funds - Unpivoted

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

31.03 KB
7162 rows
6 columns

freq Freq	sectfund Sectfund	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Business enterprise sector	Percentage of total	Japan	1980	60.89
Annual	Business enterprise sector	Percentage of total	United States	1980	48.51
Annual	Government sector	Percentage of total	Japan	1980	27.92
Annual	Government sector	Percentage of total	United States	1980	48.68
Annual	Higher education sector	Percentage of total	Japan	1980	10.49
Annual	Higher education sector	Percentage of total	United States	1980	1.44
Annual	Private non-profit sector	Percentage of total	Japan	1980	0.61
Annual	Private non-profit sector	Percentage of total	United States	1980	1.37
Annual	Rest of the world	Percentage of total	Japan	1980	0.09
Annual	All sectors	Percentage of total	Japan	1980	100


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

Share link

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