R&D Personnel And Researchers By Sector Of Performance, Educational Attainment Level (ISCED1997) And Sex (1980-2015)

Eurostat code: rd_p_persqual · (1980 - 2015)

@eurostat.rd_p_persqual

Table List

2 tables(689.12 KB)

R&D Personnel And Researchers By Sector Of Performance, Educational Attainment Level (ISCED1997) And Sex (1980-2015) - Raw

R&D Personnel And Researchers By Sector Of Performance, Educational Attainment Level (ISCED1997) And Sex (1980-2015) - Unpivoted

R&D Personnel And Researchers By Sector Of Performance, Educational Attainment Level (ISCED1997) And Sex (1980-2015) - Unpivoted

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

296.36 KB
73287 rows
9 columns

freq Freq	prof_pos Prof Pos	sectperf Sectperf	isced97 Isced97	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Researchers	Business enterprise sector	All ISCED 1997 levels	Total	Full-time equivalent (FTE)	Hungary	1980	14993
Annual	Researchers	Business enterprise sector	All ISCED 1997 levels	Total	Full-time equivalent (FTE)	Poland	1980	65500
Annual	Researchers	Business enterprise sector	All ISCED 1997 levels	Total	Head count	Bulgaria	1980	19579
Annual	Researchers	Business enterprise sector	All ISCED 1997 levels	Total	Head count	Hungary	1980	18254
Annual	Researchers	Government sector	All ISCED 1997 levels	Total	Full-time equivalent (FTE)	Hungary	1980	5641
Annual	Researchers	Government sector	All ISCED 1997 levels	Total	Full-time equivalent (FTE)	Poland	1980	10700
Annual	Researchers	Government sector	All ISCED 1997 levels	Total	Head count	Bulgaria	1980	8245
Annual	Researchers	Government sector	All ISCED 1997 levels	Total	Head count	Estonia	1980	3304
Annual	Researchers	Government sector	All ISCED 1997 levels	Total	Head count	Hungary	1980	6346
Annual	Researchers	Higher education sector	All ISCED 1997 levels	Total	Full-time equivalent (FTE)	Hungary	1980	4955


CREATE TABLE tidy (
  "freq" VARCHAR,
  "prof_pos" VARCHAR,
  "sectperf" VARCHAR,
  "isced97" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.