Share Of R&D Personnel And Researchers In Total Active Population And Employment By Sector Of Performance And Sex

Eurostat code: rd_p_perslf · (1981 - 2023)

@eurostat.rd_p_perslf

Table List

2 tables(220.1 KB)

Share Of R&D Personnel And Researchers In Total Active Population And Employment By Sector Of Performance And Sex - Raw

Share Of R&D Personnel And Researchers In Total Active Population And Employment By Sector Of Performance And Sex - Unpivoted

Share Of R&D Personnel And Researchers In Total Active Population And Employment By Sector Of Performance And Sex - Unpivoted

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

89.48 KB
57934 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	Researchers	Business enterprise sector	Percentage of population in the labour force - numerator in full-time equivalent (FTE)	Japan	1981	0.34
Annual	Total	Researchers	Business enterprise sector	Percentage of total employment - numerator in full-time equivalent (FTE)	Japan	1981	0.35
Annual	Total	Researchers	Government sector	Percentage of population in the labour force - numerator in full-time equivalent (FTE)	Japan	1981	0.05
Annual	Total	Researchers	Government sector	Percentage of population in the labour force - numerator in full-time equivalent (FTE)	United States	1981	0.05
Annual	Total	Researchers	Government sector	Percentage of total employment - numerator in full-time equivalent (FTE)	Japan	1981	0.05
Annual	Total	Researchers	Government sector	Percentage of total employment - numerator in full-time equivalent (FTE)	United States	1981	0.06
Annual	Total	Researchers	Higher education sector	Percentage of population in the labour force - numerator in full-time equivalent (FTE)	Japan	1981	0.29
Annual	Total	Researchers	Higher education sector	Percentage of population in the labour force - numerator in full-time equivalent (FTE)	United States	1981	0.09
Annual	Total	Researchers	Higher education sector	Percentage of total employment - numerator in full-time equivalent (FTE)	Japan	1981	0.29
Annual	Total	Researchers	Higher education sector	Percentage of total employment - numerator in full-time equivalent (FTE)	United States	1981	0.1


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.