Baselight
Sign In

Gross Domestic Expenditure On R&D By Sector

Eurostat code: sdg_09_10 · (2000 - 2023)

@eurostat.sdg_09_10

Gross Domestic Expenditure On R&D By Sector - Unpivoted
@eurostat.sdg_09_10.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.

  • 13.15 KB
  • 4431 rows
  • 6 columns
freq

Freq

sectperf

Sectperf

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualBusiness enterprise sectorPercentage of gross domestic product (GDP)Belgium20001.4
AnnualBusiness enterprise sectorPercentage of gross domestic product (GDP)Bulgaria20000.11
AnnualBusiness enterprise sectorPercentage of gross domestic product (GDP)Switzerland20001.67
AnnualBusiness enterprise sectorPercentage of gross domestic product (GDP)Cyprus20000.05
AnnualBusiness enterprise sectorPercentage of gross domestic product (GDP)Czechia20000.66
AnnualBusiness enterprise sectorPercentage of gross domestic product (GDP)Germany20001.67
AnnualBusiness enterprise sectorPercentage of gross domestic product (GDP)Denmark20001.46
AnnualBusiness enterprise sectorPercentage of gross domestic product (GDP)Euro area - 19 countries (2015-2022)20001.14
AnnualBusiness enterprise sectorPercentage of gross domestic product (GDP)Euro area – 20 countries (from 2023)20001.13
AnnualBusiness enterprise sectorPercentage of gross domestic product (GDP)Estonia20000.14

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