R&D Personnel And Researchers By Sector Of Performance, Fields Of R&D And Sex

Eurostat code: rd_p_perssci · (1980 - 2023)

@eurostat.rd_p_perssci

Table List

2 tables(1.56 MB)

R&D Personnel And Researchers By Sector Of Performance, Fields Of R&D And Sex - Raw

R&D Personnel And Researchers By Sector Of Performance, Fields Of R&D And Sex - Unpivoted

R&D Personnel And Researchers By Sector Of Performance, Fields Of R&D And Sex - Unpivoted

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

716.25 KB
180842 rows
9 columns

freq Freq	sectperf Sectperf	prof_pos Prof Pos	sex Sex	ford Ford	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Business enterprise sector	Researchers	Total	Total	Full-time equivalent (FTE)	Hungary	1980	14993
Annual	Business enterprise sector	Researchers	Total	Total	Full-time equivalent (FTE)	Japan	1980	184889
Annual	Business enterprise sector	Researchers	Total	Total	Full-time equivalent (FTE)	Poland	1980	65500
Annual	Business enterprise sector	Researchers	Total	Total	Head count	Bulgaria	1980	19579
Annual	Business enterprise sector	Researchers	Total	Total	Head count	Hungary	1980	18254
Annual	Business enterprise sector	Total	Total	Natural sciences, engineering and technology, medical and health sciences, agricultural sciences	Full-time equivalent (FTE)	Japan	1980	349480
Annual	Business enterprise sector	Total	Total	Social sciences and humanities	Full-time equivalent (FTE)	Japan	1980
Annual	Business enterprise sector	Total	Total	Total	Full-time equivalent (FTE)	Spain	1980	12303
Annual	Business enterprise sector	Total	Total	Total	Full-time equivalent (FTE)	Hungary	1980	14993
Annual	Business enterprise sector	Total	Total	Total	Full-time equivalent (FTE)	Japan	1980	349480


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

Share link

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