R&D Personnel By Sector

Eurostat code: sdg_09_30 · (2000 - 2023)

@eurostat.sdg_09_30

Table List

2 tables(47.48 KB)

R&D Personnel By Sector - Unpivoted

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

12.77 KB
3934 rows
8 columns

freq Freq	sex Sex	prof_pos Prof Pos	sectperf Sectperf	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	Total	Business enterprise sector	Percentage of population in the labour force - numerator in full-time equivalent (FTE)	Belgium	2000	0.77
Annual	Total	Total	Business enterprise sector	Percentage of population in the labour force - numerator in full-time equivalent (FTE)	Bulgaria	2000	0.06
Annual	Total	Total	Business enterprise sector	Percentage of population in the labour force - numerator in full-time equivalent (FTE)	Cyprus	2000	0.05
Annual	Total	Total	Business enterprise sector	Percentage of population in the labour force - numerator in full-time equivalent (FTE)	Czechia	2000	0.23
Annual	Total	Total	Business enterprise sector	Percentage of population in the labour force - numerator in full-time equivalent (FTE)	Germany	2000	0.8
Annual	Total	Total	Business enterprise sector	Percentage of population in the labour force - numerator in full-time equivalent (FTE)	Denmark	2000	0.84
Annual	Total	Total	Business enterprise sector	Percentage of population in the labour force - numerator in full-time equivalent (FTE)	Euro area - 19 countries (2015-2022)	2000	0.54
Annual	Total	Total	Business enterprise sector	Percentage of population in the labour force - numerator in full-time equivalent (FTE)	Estonia	2000	0.06
Annual	Total	Total	Business enterprise sector	Percentage of population in the labour force - numerator in full-time equivalent (FTE)	Greece	2000	0.22
Annual	Total	Total	Business enterprise sector	Percentage of population in the labour force - numerator in full-time equivalent (FTE)	Spain	2000	0.26


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