Researchers By Sector Of Performance, Country Of Citizenship And Sex

Eurostat code: rd_p_perscitz · (1980 - 2023)

@eurostat.rd_p_perscitz

Table List

2 tables(210.32 KB)

Researchers By Sector Of Performance, Country Of Citizenship And Sex - Raw

Researchers By Sector Of Performance, Country Of Citizenship And Sex - Unpivoted

Researchers By Sector Of Performance, Country Of Citizenship And Sex - Unpivoted

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

88.08 KB
20765 rows
8 columns

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


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