R&D Personnel And Researchers In Business Enterprise Sector By NACE Rev. 1.1 Activity And Sex (1980-2010)

Eurostat code: rd_p_bempocc · (1980 - 2010)

@eurostat.rd_p_bempocc

Table List

2 tables(585.16 KB)

R&D Personnel And Researchers In Business Enterprise Sector By NACE Rev. 1.1 Activity And Sex (1980-2010) - Raw

R&D Personnel And Researchers In Business Enterprise Sector By NACE Rev. 1.1 Activity And Sex (1980-2010) - Unpivoted

R&D Personnel And Researchers In Business Enterprise Sector By NACE Rev. 1.1 Activity And Sex (1980-2010) - Unpivoted

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

272.5 KB
92570 rows
8 columns

freq Freq	sex Sex	nace_r1 Nace R1	prof_pos Prof Pos	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	Total - all NACE activities	Researchers	Full-time equivalent (FTE)	Hungary	1980	14993
Annual	Total	Total - all NACE activities	Researchers	Full-time equivalent (FTE)	Poland	1980	65500
Annual	Total	Total - all NACE activities	Researchers	Head count	Bulgaria	1980	19579
Annual	Total	Total - all NACE activities	Researchers	Head count	Hungary	1980	18254
Annual	Total	Total - all NACE activities	Total	Full-time equivalent (FTE)	Spain	1980	12303
Annual	Total	Total - all NACE activities	Total	Full-time equivalent (FTE)	Hungary	1980	14993
Annual	Total	Total - all NACE activities	Total	Full-time equivalent (FTE)	Poland	1980	65500
Annual	Total	Total - all NACE activities	Total	Head count	Bulgaria	1980	48337
Annual	Total	Total - all NACE activities	Total	Head count	Hungary	1980	50044
Annual	Total	Total - all NACE activities	Researchers	Full-time equivalent (FTE)	Austria	1981	2886


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

Share link

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