GERD By Sector Of Performance And Type Of Expenditure

Eurostat code: rd_e_gerdcost · (1980 - 2023)

@eurostat.rd_e_gerdcost

Table List

2 tables(2.61 MB)

GERD By Sector Of Performance And Type Of Expenditure - Raw

GERD By Sector Of Performance And Type Of Expenditure - Unpivoted

GERD By Sector Of Performance And Type Of Expenditure - Unpivoted

@eurostat.rd_e_gerdcost.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.25 MB
228768 rows
7 columns

freq Freq	expend Expend	sectperf Sectperf	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Capital expenditure	Business enterprise sector	Euro per inhabitant	Japan	1980	12.846
Annual	Capital expenditure	Business enterprise sector	Million euro	Japan	1980	1503.78
Annual	Capital expenditure	Business enterprise sector	Million units of national currency	Japan	1980	473751
Annual	Capital expenditure	Business enterprise sector	Million purchasing power standards (PPS) at 2005 prices	Japan	1980	3278.211
Annual	Capital expenditure	Business enterprise sector	Percentage of gross domestic product (GDP)	Japan	1980	0.19
Annual	Capital expenditure	Business enterprise sector	Purchasing power standard (PPS) per inhabitant at constant 2005 prices	Japan	1980	28.005
Annual	Capital expenditure	Government sector	Euro per inhabitant	Japan	1980	5.416
Annual	Capital expenditure	Government sector	Euro per inhabitant	United States	1980	1.534
Annual	Capital expenditure	Government sector	Million euro	Japan	1980	633.989
Annual	Capital expenditure	Government sector	Million euro	United States	1980	349.288


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