Baselight
Sign In

GERD By Sector Of Performance And Source Of Funds

Eurostat code: rd_e_gerdfund ยท (1980 - 2023)

@eurostat.rd_e_gerdfund

GERD By Sector Of Performance And Source Of Funds - Unpivoted
@eurostat.rd_e_gerdfund.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.42 MB
  • 307001 rows
  • 7 columns
freq

Freq

sectperf

Sectperf

sectfund

Sectfund

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualBusiness enterprise sectorBusiness enterprise sectorEuro per inhabitantJapan198083.481
AnnualBusiness enterprise sectorBusiness enterprise sectorEuro per inhabitantUnited States198096.12
AnnualBusiness enterprise sectorBusiness enterprise sectorMillion euroJapan19809772.242
AnnualBusiness enterprise sectorBusiness enterprise sectorMillion euroUnited States198021888.961
AnnualBusiness enterprise sectorBusiness enterprise sectorMillion units of national currencyJapan19803078647
AnnualBusiness enterprise sectorBusiness enterprise sectorMillion units of national currencyUnited States198030476
AnnualBusiness enterprise sectorBusiness enterprise sectorMillion purchasing power standards (PPS) at 2005 pricesJapan198021303.288
AnnualBusiness enterprise sectorBusiness enterprise sectorMillion purchasing power standards (PPS) at 2005 pricesUnited States198051728.806
AnnualBusiness enterprise sectorBusiness enterprise sectorPercentage of gross domestic product (GDP)Japan19801.2
AnnualBusiness enterprise sectorBusiness enterprise sectorPercentage of gross domestic product (GDP)United States19801.07

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