Total Researchers By Sectors Of Performance - Full Time Equivalent

Eurostat code: tsc00004 · (2012 - 2023)

@eurostat.tsc00004

Table List

2 tables(50.21 KB)

Total Researchers By Sectors Of Performance - Full Time Equivalent - Raw

Total Researchers By Sectors Of Performance - Full Time Equivalent - Unpivoted

Total Researchers By Sectors Of Performance - Full Time Equivalent - Unpivoted

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

22.18 KB
2281 rows
8 columns

freq Freq	sex Sex	prof_pos Prof Pos	unit Unit	sectperf Sectperf	geo Geo	time_period Time Period	value Value
Annual	Total	Researchers	Full-time equivalent (FTE)	Business enterprise sector	Austria	2012	25180
Annual	Total	Researchers	Full-time equivalent (FTE)	Business enterprise sector	Bosnia and Herzegovina	2012	108.7
Annual	Total	Researchers	Full-time equivalent (FTE)	Business enterprise sector	Belgium	2012	23464
Annual	Total	Researchers	Full-time equivalent (FTE)	Business enterprise sector	Bulgaria	2012	2095
Annual	Total	Researchers	Full-time equivalent (FTE)	Business enterprise sector	Switzerland	2012	16595
Annual	Total	Researchers	Full-time equivalent (FTE)	Business enterprise sector	China except Hong Kong	2012	872384
Annual	Total	Researchers	Full-time equivalent (FTE)	Business enterprise sector	Cyprus	2012	174.3
Annual	Total	Researchers	Full-time equivalent (FTE)	Business enterprise sector	Czechia	2012	15057.5
Annual	Total	Researchers	Full-time equivalent (FTE)	Business enterprise sector	Germany	2012	199623
Annual	Total	Researchers	Full-time equivalent (FTE)	Business enterprise sector	Denmark	2012	24369.3


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

Share link

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