Annual Enterprise Statistics For Special Aggregates Of NACE Rev.2 Activities (2005-2020)

Eurostat code: sbs_na_sca_r2 · (2005 - 2020)

@eurostat.sbs_na_sca_r2

Table List

2 tables(8.48 MB)

Annual Enterprise Statistics For Special Aggregates Of NACE Rev.2 Activities (2005-2020) - Raw

Annual Enterprise Statistics For Special Aggregates Of NACE Rev.2 Activities (2005-2020) - Unpivoted

Annual Enterprise Statistics For Special Aggregates Of NACE Rev.2 Activities (2005-2020) - Raw

@eurostat.sbs_na_sca_r2.raw

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

4.31 MB
118597 rows
20 columns

freq Freq	nace_r2 Nace R2	indic_sb Indic Sb	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
Annual	Mining and quarrying	Enterprises - number	Albania															688	690
Annual	Mining and quarrying	Enterprises - number	Austria				349	357	358	355	355	353	349	348	348	341	304	298	307
Annual	Mining and quarrying	Enterprises - number	Bosnia and Herzegovina							223	194	191	188	196	199	197	182	178	177
Annual	Mining and quarrying	Enterprises - number	Belgium						293	274	203	214	192	213	192	218	147	174	179
Annual	Mining and quarrying	Enterprises - number	Bulgaria				353	373	378	379	382	386	359	374	357	342	326	304	310
Annual	Mining and quarrying	Enterprises - number	Switzerland					203	199	195	193	216	211	212	212	205	209	204	206
Annual	Mining and quarrying	Enterprises - number	Cyprus	90	90	90	90	90	90	91	80	70	68	58	52	47	44	45	42
Annual	Mining and quarrying	Enterprises - number	Czechia				567	592	333	348	359	363	380	376	399	403	421	417	440
Annual	Mining and quarrying	Enterprises - number	Germany				1720	1660	1836	1767	1902	1706	1916	1813	1753	1615	1540	1561	1663
Annual	Mining and quarrying	Enterprises - number	Denmark				222	206	203	214	218	210	207	213	214	220	231	229	229


CREATE TABLE raw (
  "freq" VARCHAR,
  "nace_r2" VARCHAR,
  "indic_sb" 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.