Researchers By Sector Of Performance, Country Of Citizenship And Sex

Eurostat code: rd_p_perscitz$dv_1863

@eurostat.rd_p_perscitz_dv_1863

Table List

2 tables(86.08 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_dv_1863.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.

39.1 KB
6821 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	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	Head count	Females	Bulgaria	2013	14
Annual	Business enterprise sector	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	Head count	Females	Greece	2013	19
Annual	Business enterprise sector	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	Head count	Females	France	2013	1253
Annual	Business enterprise sector	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	Head count	Females	Croatia	2013	1
Annual	Business enterprise sector	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	Head count	Females	Hungary	2013	20
Annual	Business enterprise sector	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	Head count	Females	North Macedonia	2013
Annual	Business enterprise sector	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	Head count	Females	Malta	2013	21
Annual	Business enterprise sector	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	Head count	Females	Poland	2013	12
Annual	Business enterprise sector	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	Head count	Females	Portugal	2013	36
Annual	Business enterprise sector	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	Head count	Females	Serbia	2013


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.