Baselight

Industry By Employment Size Class (NACE Rev. 2, B-E) (2005-2020)

Eurostat code: sbs_sc_ind_r2 ยท (2005 - 2020)

@eurostat.sbs_sc_ind_r2

Industry By Employment Size Class (NACE Rev. 2, B-E) (2005-2020) - Raw
@eurostat.sbs_sc_ind_r2.raw

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

  • 18.88 MB
  • 937696 rows
  • 21 columns
freq

Freq

nace_r2

Nace R2

indic_sb

Indic Sb

size_emp

Size Emp

geo

Geo

n_2005

2005

n_2006

2006

n_2007

2007

n_2008

2008

n_2009

2009

n_2010

2010

n_2011

2011

n_2012

2012

n_2013

2013

n_2014

2014

n_2015

2015

n_2016

2016

n_2017

2017

n_2018

2018

n_2019

2019

n_2020

2020

AnnualMining and quarryingEnterprises - numberFrom 0 to 9 persons employedAlbania502510
AnnualMining and quarryingEnterprises - numberFrom 0 to 9 persons employedAustria244243233237244245242238238227230226215192183197
AnnualMining and quarryingEnterprises - numberFrom 0 to 9 persons employedBosnia and Herzegovina15012111812113212912110210198
AnnualMining and quarryingEnterprises - numberFrom 0 to 9 persons employedBelgium155248249227160175149167144173118140141
AnnualMining and quarryingEnterprises - numberFrom 0 to 9 persons employedBulgaria111133156199230241245252243228240224215211190199
AnnualMining and quarryingEnterprises - numberFrom 0 to 9 persons employedSwitzerland857975758986848581848285
AnnualMining and quarryingEnterprises - numberFrom 0 to 9 persons employedCyprus6969686868
AnnualMining and quarryingEnterprises - numberFrom 0 to 9 persons employedCzechia381386381432460203219233239263261281290311306331
AnnualMining and quarryingEnterprises - numberFrom 0 to 9 persons employedGermany1055954103110129141091941116394210299639668199909791142
AnnualMining and quarryingEnterprises - numberFrom 0 to 9 persons employedDenmark139137135181166166167166161157165176175192188188

CREATE TABLE raw (
  "freq" VARCHAR,
  "nace_r2" VARCHAR,
  "indic_sb" VARCHAR,
  "size_emp" VARCHAR,
  "geo" VARCHAR,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE
);

Share link

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