Researchers By Sector Of Performance, Age Class And Sex

Eurostat code: rd_p_persage · (1980 - 2023)

@eurostat.rd_p_persage

Table List

2 tables(241.5 KB)

Researchers By Sector Of Performance, Age Class And Sex - Raw

Researchers By Sector Of Performance, Age Class And Sex - Unpivoted

Researchers By Sector Of Performance, Age Class And Sex - Unpivoted

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

95.18 KB
21291 rows
8 columns

freq Freq	age Age	sectperf Sectperf	unit Unit	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Total	Business enterprise sector	Head count	Total	Bulgaria	1980	19579
Annual	Total	Business enterprise sector	Head count	Total	Hungary	1980	18254
Annual	Total	Government sector	Head count	Total	Bulgaria	1980	8245
Annual	Total	Government sector	Head count	Total	Estonia	1980	3304
Annual	Total	Government sector	Head count	Total	Hungary	1980	6346
Annual	Total	Higher education sector	Head count	Total	Bulgaria	1980	10882
Annual	Total	Higher education sector	Head count	Total	Estonia	1980	2941
Annual	Total	Higher education sector	Head count	Total	Hungary	1980	14105
Annual	Total	All sectors	Head count	Total	Bulgaria	1980	38706
Annual	Total	All sectors	Head count	Total	Hungary	1980	38705


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

Share link

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