Baselight

Researchers By Sector Of Performance, Country Of Citizenship And Sex

Eurostat code: rd_p_perscitz$dv_1863

@eurostat.rd_p_perscitz_dv_1863

Researchers By Sector Of Performance, Country Of Citizenship And Sex - Raw
@eurostat.rd_p_perscitz_dv_1863.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

  • 46.98 KB
  • 870 rows
  • 16 columns
freq

Freq

sectperf

Sectperf

citizen

Citizen

unit

Unit

sex

Sex

geo

Geo

n_2013

2013

n_2014

2014

n_2015

2015

n_2016

2016

n_2017

2017

n_2018

2018

n_2019

2019

n_2020

2020

n_2021

2021

n_2022

2022

AnnualBusiness enterprise sectorEuropean Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Head countFemalesBosnia and Herzegovina
AnnualBusiness enterprise sectorEuropean Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Head countFemalesBulgaria141316151610
AnnualBusiness enterprise sectorEuropean Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Head countFemalesCzechia133
AnnualBusiness enterprise sectorEuropean Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Head countFemalesGreece1961651468
AnnualBusiness enterprise sectorEuropean Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Head countFemalesSpain552503626692
AnnualBusiness enterprise sectorEuropean Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Head countFemalesFrance1253
AnnualBusiness enterprise sectorEuropean Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Head countFemalesCroatia1111374
AnnualBusiness enterprise sectorEuropean Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Head countFemalesHungary20311413151624315262
AnnualBusiness enterprise sectorEuropean Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Head countFemalesNorth Macedonia22
AnnualBusiness enterprise sectorEuropean Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Head countFemalesMalta216718231536332436

CREATE TABLE raw (
  "freq" VARCHAR,
  "sectperf" VARCHAR,
  "citizen" VARCHAR,
  "unit" VARCHAR,
  "sex" VARCHAR,
  "geo" VARCHAR,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE
);

Share link

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