R&D Personnel And Researchers By Sector Of Performance, Sex And NUTS 2 Region

Eurostat code: rd_p_persreg · (1980 - 2023)

@eurostat.rd_p_persreg

Table List

2 tables(3.58 MB)

R&D Personnel And Researchers By Sector Of Performance, Sex And NUTS 2 Region - Raw

R&D Personnel And Researchers By Sector Of Performance, Sex And NUTS 2 Region - Unpivoted

R&D Personnel And Researchers By Sector Of Performance, Sex And NUTS 2 Region - Unpivoted

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

1.78 MB
608729 rows
8 columns

freq Freq	prof_pos Prof Pos	sex Sex	sectperf Sectperf	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Researchers	Total	Business enterprise sector	Full-time equivalent (FTE)	Hungary	1980	14993
Annual	Researchers	Total	Business enterprise sector	Full-time equivalent (FTE)	Japan	1980	184889
Annual	Researchers	Total	Business enterprise sector	Full-time equivalent (FTE)	Poland	1980	65500
Annual	Researchers	Total	Business enterprise sector	Head count	Bulgaria	1980	19579
Annual	Researchers	Total	Business enterprise sector	Head count	Hungary	1980	18254
Annual	Researchers	Total	Business enterprise sector	Head count	Slovenija	1980	633
Annual	Researchers	Total	Government sector	Full-time equivalent (FTE)	Hungary	1980	5641
Annual	Researchers	Total	Government sector	Full-time equivalent (FTE)	Japan	1980	28792
Annual	Researchers	Total	Government sector	Full-time equivalent (FTE)	Poland	1980	10700
Annual	Researchers	Total	Government sector	Full-time equivalent (FTE)	United States	1980	58600


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